playtechsolutions/changeInvoiceStatusProcess.php at main · PasanSWijekoon/playtechsolutions · 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
<?php

require "includes/connection.php";

if(isset($_GET["id"])){
    $invoice_id = $_GET["id"];

    $invoice_rs = Database::search("SELECT * FROM `invoice` WHERE `id`='".$invoice_id."'");
    $invoice_data = $invoice_rs->fetch_assoc();

    $status_id = $invoice_data["status"];
    $new_status = 0;

    if($status_id == 0){
        Database::iud("UPDATE `invoice` SET `status`='1' WHERE `id`='".$invoice_id."'");
        $new_status = 1;
    }else if($status_id == 1){
        Database::iud("UPDATE `invoice` SET `status`='2' WHERE `id`='".$invoice_id."'");
        $new_status = 2;
    }else if($status_id == 2){
        Database::iud("UPDATE `invoice` SET `status`='3' WHERE `id`='".$invoice_id."'");
        $new_status = 3;
    }else if($status_id == 3){
        Database::iud("UPDATE `invoice` SET `status`='4' WHERE `id`='".$invoice_id."'");
        $new_status = 4;
    }
    echo($new_status);

}


?>