ChiamakaObitube/AutoMart

import orderQueries from '../../models/V2/order';
import carQueries from '../../models/V2/car';
import db from '../../database/index';


class orderController {
  static async postOrder(req, res) {
    try {
      const { token } = req;
      const status = 'pending';

      const getCar = [req.body.car_id];
      const { car_id, amount } = req.body;
      const car = await db.query(carQueries.specificCarQuery, getCar);
      const { price } = car.rows[0];

      const values = [
        car_id,
        req.user.id,
        new Date(),
        status,
        req.body.amount,
      ];

      const { rows } = await db.query(orderQueries.createOrderQuery, values);
      const {
        id,
        buyer,
      } = rows[0];

      const orderData = {
        token,
        id,
        car_id,
        buyer,
        price,
        amount,
      };

      return res.status(201).send({
        status: 201,
        message: 'Purchase Order created successfully',
        data: orderData,

      });
    } catch (error) {
      console.log(error);
      return res.status(500).send({
        status: 500,
        error,
      });
    }
  }

  static async updatePurchaseOrderPrice(req, res) {
    try {
      // const { amount } = req.body;
      // const { token } = req;

      // const values = [
      //   req.params.id,
      //   amount,
      // ];
      // // Purchase order price offered can only be updated if order status is pending
      // const { rows } = await db.query(orderQueries.updateOrderPriceQuery, values);

      // // const {
      // //   car_id,
      // //   new_price_offered,
      // // } = rows[0];

      // if (!rows[0]) {
      //   return res.status(400).send({
      //     status: 400,
      //     error: 'car does not exist',
      //   });
      // }

      // const updatedOrder = {
      //   token,
      //   car_id,
      //   price: new_price_offered,
      // };
      // console.log(new_price_offered);

      const { price } = req.body;
      const { token } = req;

      const values = [
        req.params.id,
        price,
      ];
      // Purchase order price offered can only be updated if order status is pending
      const { rows } = await db.query(orderQueries.updateOrderPriceQuery, values);

      // const {
      //   car_id,
      //   new_price_offered,
      // } = rows[0];

      if (!rows[0]) {
        return res.status(400).send({
          status: 400,
          error: 'car does not exist',
          error,
        });
      }

      // const updatedOrder = {
      //   token,
      //   car_id,
      //   price: new_price_offered,
      // };
      
      console.log(rows[0].new_price_offered);
      return res.status(200).send({
        status: 200,
        message: 'Order price updated successfully',
        data: rows[0],
      });
    } catch (error) {
      return res.status(500).send({
        status: 500,
        error,
      });
    }
  }

  static async getAllOrders(req, res) {
    try {
      const { token } = req;
      const { rows } = await db.query(orderQueries.allOrdersQuery);
      if (!rows) {
        return res.status(404).send({
          message: 'There are no orders in this database',
        });
      }
      if (!req.user.isAdmin) {
        return res.status(401).send({
          status: 401,
          error: 'You are not authorized to perform this action',
        });
      }
      return res.status(200).send({
        message: 'All orders retrieved successfully',
        data: { rows, token },
      });
    } catch (error) {
      return res.status(500).send({
        status: 500,
        error: 'Error fetching orders, try again',
      });
    }
  }

  static async getSpecificOrder(req, res) {
    try {
      const { token } = req;
      const { rows } = await db.query(orderQueries.specificOrderQuery, [req.params.id]);
      const specificOrder = rows[0];
      if (!rows[0]) {
        return res.status(404).send({
          status: 404,
          message: 'order does not exist',
        });
      }
      return res.status(200).send({
        status: 200,
        message: 'Order retrieved successfully',
        data: { token, specificOrder },
      });
    } catch (error) {
      return res.status(500).send({
        status: 500,
        error: 'Error fetching order, try again',
      });
    }
  }
}

export default orderController;