FoodMart/changeStatusProcess.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
<?php

include "connection.php";

$invoice_id = $_GET["id"];

    $invoice_rs = Database::search("SELECT * FROM `invoice` WHERE `invoice_id` = '".$invoice_id."' ");

    if($invoice_rs->num_rows == 1){
        $invoice_data = $invoice_rs->fetch_assoc();
        $status = $invoice_data["status"];

        if($status == 0){

            Database::iud("UPDATE `invoice` SET `status` = '1' WHERE `invoice_id` = '".$invoice_id."' ");
            echo("updated");


        }else if($status == 1){

            Database::iud("UPDATE `invoice` SET `status` = '2' WHERE `invoice_id` = '".$invoice_id."' ");
            echo("updated");

        }else if($status == 2){

            Database::iud("UPDATE `invoice` SET `status` = '3' WHERE `invoice_id` = '".$invoice_id."' ");
            echo("updated");

        }else if($status == 3){

            Database::iud("UPDATE `invoice` SET `status` = '4' WHERE `invoice_id` = '".$invoice_id."' ");
            echo("updated");

        }else if($status == 4){

            Database::iud("UPDATE `invoice` SET `status` = '4' WHERE `invoice_id` = '".$invoice_id."' ");
            echo("updated");

        }

    }else{
        echo("Something went wrong.. try again later");
    }

?>