<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class OrderModel extends BaseModel
{

	/**
	 * [insertOrder description]
	 * @param  array $data
	 * @return int id_order
	 */
	public function insertOrder($data)
	{
		$query = $this->connect()->query("
			INSERT INTO orders SET
			id_user 		= " . $data['id_user'] . ",
			order_token		= '" . $data['order_token'] . "',
			subtotal 		= " . $data['subtotal'] . ",
			discount 		= " . $data['discount'] . ",
			shipping 		= " . $data['shipping'] . ",
			total 			= " . $data['total'] . "
			");
	}

	public function insertOrderItems($data)
	{
		$query = $this->connect()->query("
			INSERT INTO order_items SET
			id_order 	= " . $data['id_order'] . ",
			sku			= '" . $data['sku'] . "',
			qty			= " . $data['qty'] . ",
			price 		= " . $data['price'] . " 
			");
	}

	public function insertOrderPayment($data)
	{
		$query = $this->connect()->query("
			INSERT INTO order_payments SET
			id_order 		= " . $data['id_order'] . ",
			transaction_id	= '" . $data['transaction_id'] . "',
			amount 			= " . $data['total'] . " 
			");
	}

	public function getLastOrderId()
	{
		$query = $this->connect()->query("
			SELECT max(id_order) as id_order FROM orders;
			");
		return $query->row['id_order'];
	}

	public function getOrder($token)
	{
		$query = $this->connect()->query("
			SELECT 
			id_order,
			subtotal,
			discount,
			shipping,
			total
			FROM orders
			WHERE order_token = '" . $token . "'
			");

		return $query;
	}

	public function getOrderItems($id_order)
	{
		$query = $this->connect()->query("
			SELECT 
			A.sku,
			A.qty,
			A.price,
			B.name,
			B.image
			FROM order_items A
			LEFT JOIN products B
			ON A.sku = B.sku
			WHERE id_order = " . $id_order . "
			");

		return $query;
	}
}