<?php

/*
 * Following code will list all the products
 */
// array for JSON response
$response = array();

// include db connect class
include("db_connect.php");

// connecting to db
$con = new DB_CONNECT();
$connection = $con->connect();

$connection->query("SET NAMES 'utf8'");

$connection->query("SET CHARACTER SET utf8");

$connection->query("SET SESSION collation_connection = 'utf8_unicode_ci'");

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET,POST,PUT,DELETE,OPTIONS');
header('Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With');

header('Content-Type: application/json');

// get all products from products table
// Start Functionality  
$postdata = file_get_contents("php://input");

if (isset($postdata) && !empty($postdata)) {
    $Req = json_decode($postdata, TRUE);
    $lang = $Req['lang'];
    $remove_id = $Req['remove_id'];

    $note = $Req['note'];
    $sub_category_id = $Req['sub_category_id'];
    $size_id = $Req['size_id'];
    $addition_id = $Req['addition_id'];
    $side_id= $Req['side_id'];

    $quantity = $Req['quantity'];
    $get_size_price = get_size_price_from_id($size_id);
    $addition_price = 0;


    if ($addition_id != '') {
        $addition_id_all = explode(',', $addition_id);
        foreach ($addition_id_all as $one) {
            $get_addition_price = get_addition_price_from_id($one);
            $addition_price += $get_addition_price;
        }
    }

    $total = $get_size_price + $addition_price ;

    $total_price = $quantity * $total;
    $price = $total_price;

    $client_id = $Req['client_id'];

    $result = $connection->query("INSERT INTO cart(sub_category_id,size_id,addition_id,quantity,price,client_id,remove_id,side_id,note,status,date) VALUES('$sub_category_id','$size_id','$addition_id','$quantity','$price','$client_id','$remove_id','$side_id',\"{$note}\" ,'0','" . date("Y-m-d") . "')");


    $response["product"] = array();

    // temp user array
    $product = array();
    $product["cart_id"] = mysqli_insert_id($connection);

    $product["total"] = $price;
    $product["client_id"] = $Req["client_id"];

    // push single product into final response array
    array_push($response["product"], $product);


    // check if row inserted or not
    if ($result) {
        // successfully inserted into database
        $response["success"] = 1;
        $response["message"] = "تم الإضافة بنجاح.";

        // echoing JSON response
        echo json_encode($response);
    } else {
        // failed to insert row
        if ($lang == "ar") {
            $response["message"] = "عفوا لقد حدث خطأ.";
        } else {
            $response["message"] = "Sorry, there was an error.";
        }
        // echoing JSON response
        echo json_encode($response);
    }
} else {
    // required field is missing
    $response["success"] = 0;
    $response["message"] = "هناك بيانات مفقوده برجاء مراجعة بياناتك";

    // echoing JSON response
    echo json_encode($response);
}
?>