/**
* @param int $id
* @return array
*/
public static function getOrder($id)
{
$sql = "SELECT\n order_id,\n order_amount,\n order_date,\n order_user_id,\n user_name,\n op_quantity,\n product_id,\n product_name\n FROM\n orders\n LEFT JOIN\n users ON order_user_id = user_id\n LEFT JOIN\n ordered_products ON op_order_id = order_id\n LEFT JOIN\n products ON op_product_id = product_id\n WHERE order_id = " . $id;
return DbFunctions::sql($sql);
}
/**
* @return mixed
*/
public function save()
{
$productSQL = "'" . $this->name . "'";
DbFunctions::insert("INSERT INTO products (product_name) VALUES (" . $productSQL . ")");
$this->id = DbFunctions::sql("SELECT product_id FROM products\n WHERE product_name = '" . $this->name . "'\n ORDER BY product_id DESC", 1)['product_id'];
$descriptionSQL = $this->id . ", '" . $this->description . "', " . $this->price . ", " . $this->quantity . ", NULL";
DbFunctions::insert("INSERT INTO products_description VALUES (" . $descriptionSQL . ")");
}