FoodMart/checkoutSaveInvoiceProcess.php at main · FHMNx/FoodMart · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<?php

session_start();
include "connection.php";

$mail = $_SESSION["u"]["email"];

$o_Id = $_POST["o"];
$price = $_POST["p"];

$cart_rs = Database::search("SELECT * FROM `cart` WHERE `cart_users_email` = '".$mail."' ");
$cart_num = $cart_rs->num_rows;

Database::iud("INSERT INTO `checkout_invoice` (`order_id` , `users_email` , `amount`) VALUES ('".$o_Id."' , '".$mail."' , '".$price."') ");

$invoice_id = Database::$connection->insert_id;  //lastly added record

$d = new DateTime();
$tz = new DateTimeZone("Asia/colombo");
$d->setTimezone($tz);
$sold_date = $d->format("Y-m-d H:i:s");

// echo("New invoice created");

for($x = 0; $x < $cart_num; $x++){

    $cart_data = $cart_rs->fetch_assoc();

    Database::iud("INSERT INTO `invoice_item` (`checkout_invoice_invoice_id`, `product_id`, `qty` , `sold_date`)
    VALUES ('".$invoice_id."' , '".$cart_data["cart_product_id"]."' , '".$cart_data["cart_qty"]."' , '".$sold_date."')");

    // echo("New Invoice item added");


    $product_rs = Database::search("SELECT * FROM `product` WHERE `id` = '".$cart_data["cart_product_id"]."' ");
    $product_data = $product_rs->fetch_assoc();

    $old_qty = $product_data["qty"];
    $sold_qty = $cart_data["cart_qty"];
    $new_qty = $old_qty - $sold_qty;

    Database::iud("UPDATE `product` SET `qty` = '".$new_qty."' WHERE `id`= '".$cart_data["cart_product_id"]."' ");
    // echo("quantity updated");

    Database::iud("DELETE FROM `cart` WHERE `cart_id` = '".$cart_data["cart_id"]."' ");
    // echo("cart cleared");

}


echo("success");


?>