include_once '../classes/Utilities.php';
$dbConnection = new PDOExt();
$utilities = new Utilities();
$response = array();
$basket_code = uniqid("BSKT_");
/*
* Json array with id, qunatity in this format.
* [
* {'item':1,'name': 'xyz','quantity':2,'price':200},
* {'item':2,'name': 'abc','quantity':1,'price':150},
* {'item':3,'name': 'qwert','quantity':1,'price':20},
* {'item':4,'name': 'poiuyt','quantity':1,'price':30}
* ]
*/
$item_quantity_price_json = $utilities->clean($_POST['item_quantity_price_json']);
$user_id = $utilities->replaceOne($_POST['user_id']);
$time_slot_id = $utilities->replaceOne($_POST['time_slot_id']);
$status = $utilities->replaceOne($_POST['status']);
$date = $utilities->replaceToday($_POST['date']);
$address_id = $utilities->replaceZero($_POST['address_id']);
$order_type_id = $utilities->replaceZero($_POST['order_type_id']);
$log_datetime = $utilities->replaceNow();
$order_id = -1;
try {
$insertQuery = "INSERT INTO " . " `order` (basket_code, user_id, item_quantity_price_json, time_slot_id, status, date, address_id, log_datetime) " . " VALUES ('{$basket_code}', '{$user_id}', '{$item_quantity_price_json}', '{$time_slot_id}', '{$status}', '{$date}', '{$address_id}', '{$log_datetime}')";
$statement = $dbConnection->prepare($insertQuery);
try {
$dbConnection->beginTransaction();
if ($statement->execute()) {
$order_id = $dbConnection->lastInsertId();
$dbConnection->commit();
$utilities = new Utilities();
$response = array();
$name = $utilities->clean($_POST['name']);
$description = $utilities->clean($_POST['description']);
$ingredients = $utilities->clean($_POST['ingredients']);
$preparation_method = $utilities->clean($_POST['preparation_method']);
$nutrition = $utilities->clean($_POST['nutrition']);
$food_image_1 = $utilities->clean($_POST['food_image_1']);
$food_image_2 = $utilities->clean($_POST['food_image_2']);
$food_image_3 = $utilities->clean($_POST['food_image_3']);
$food_image_4 = $utilities->clean($_POST['food_image_4']);
$food_image_5 = $utilities->clean($_POST['food_image_5']);
$food_image_6 = $utilities->clean($_POST['food_image_6']);
$rating = $utilities->replaceZero($_POST['rating']);
$price = $utilities->replaceZero($_POST['price']);
$currency_id = $utilities->replaceOne($_POST['currency_id']);
$chef_id = $utilities->replaceZero($_POST['chef_id']);
$category_id = $utilities->replaceOne($_POST['category_id']);
$log_datetime = $utilities->replaceNow();
$foodId = -1;
try {
$insertQuery = "INSERT INTO " . " `food_item` (name, description, ingredients, preparation_method, nutrition, food_image_1,food_image_2,food_image_3, food_image_4, food_image_5, food_image_6, rating, price, currency_id, chef_id, category_id, log_datetime) " . " VALUES ('{$name}', '{$description}', '{$ingredients}', '{$preparation_method}', '{$nutrition}', '{$food_image_1}', '{$food_image_2}','{$food_image_3}','{$food_image_4}','{$food_image_5}','{$food_image_6}', '{$rating}', '{$price}', '{$currency_id}', '{$chef_id}', '{$category_id}', '{$log_datetime}')";
$statement = $dbConnection->prepare($insertQuery);
try {
$dbConnection->beginTransaction();
if ($statement->execute()) {
$foodId = $dbConnection->lastInsertId();
$dbConnection->commit();
$response = array('status' => $foodId, 'desc' => 'Success');
} else {
$status = -99;
