supplychain/get_select_order.php at master · Ajmain-Inqiad/supplychain · 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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
<?php
require_once 'dbconnect.php';
if(isset($_POST["type"])){
    $type = $_POST["type"];
    if($type=="neworder"){
      $sql = "SELECT * FROM orders WHERE approved='no' AND completed='no' ORDER BY priority ASC, ordering_date ASC";
      $result = $connect->query($sql);
      if($result->num_rows > 0){
        $output = "<table class='table table-hover' style='width:100%;'>
          <thead>
              <tr>
                <th>Order ID</th>
                <th>Client</th>
                <th>Details</th>
                <th>Ordered date</th>
                <th>Delivery date</th>
                <th>Client Address</th>
                <th>Action</th>
              </tr>
          </thead>

          <tbody>";
        while($order = $result->fetch_assoc()){
          $client_id=$order['client_id'];
          $query = $connect->query("SELECT fullname, address,email FROM client WHERE id='$client_id'");
          $client = $query->fetch_assoc();
          $client_name = $client['fullname'];
          $client_add = $client['address'];
          $client_email = $client['email'];
          $order_id = $order['id'];
          $ordered_date = $order['ordering_date'];
          $delivery_date = $order['delivery_date'];
          $details = $order['details'];
          $output .= "
          <tr>
            <td>$order_id</td>
            <td>$client_name</td>
            <td>$details</td>
            <td>$ordered_date</td>
            <td>$delivery_date</td>
            <td>$client_add</td>
            <td><button type='button' class='btn btn-danger' id='delete' data-toggle='modal' data-target='#exampleModal' data-whatever='$client_email delete $order_id'> Delete</button>
            &nbsp;<button type='button' class='btn btn-success' id='approve' data-toggle='modal' data-target='#exampleModal2' data-whatever='$client_email approve $order_id'> Approve</button>
            &nbsp;<button type='button' class='btn btn-default' id='contact' data-toggle='modal' data-target='#exampleModal' data-whatever='$client_email contact $order_id'> Contact </button>

            </td>
          </tr>
          ";
        }
        $output .="</tbody></table>";
      }else{
        $output="<br><p style='text-align:center; color:red'><i>No new order</i></p>";
      }
      echo $output;
    }else if($type=="approved"){
      $sql = "SELECT * FROM orders WHERE approved='yes' ORDER BY completed ASC, priority ASC";
      $result = $connect->query($sql);
      if($result->num_rows > 0){
        $output = "<table class='table table-hover' style='width:100%;'>
          <thead>
              <tr>
                <th>Order ID</th>
                <th>Client</th>
                <th>Details</th>
                <th>Manager</th>
                <th>Ordered date</th>
                <th>Delivery date</th>
                <th>Client Address</th>
                <th>Completed</th>
              </tr>
          </thead>

          <tbody>";
        while($order = $result->fetch_assoc()){
          $client_id=$order['client_id'];
          $query = $connect->query("SELECT fullname, address FROM client WHERE id='$client_id'");
          $client = $query->fetch_assoc();
          $client_name = $client['fullname'];
          $client_add = $client['address'];
          $order_id = $order['id'];
          $ordered_date = $order['ordering_date'];
          $delivery_date = $order['delivery_date'];
          $details = $order['details'];
          $completed = $order['completed'];
          $manager = $order['manager'];
          $managersql = $connect->query("SELECT fullname FROM employee WHERE username='$manager'");
          $managerrow = $managersql->fetch_assoc();
          $managername = $managerrow['fullname'];
          $output .= "
          <tr>
            <td>$order_id</td>
            <td>$client_name</td>
            <td>$details</td>
            <td>$managername</td>
            <td>$ordered_date</td>
            <td>$delivery_date</td>
            <td>$client_add</td>
            <td>$completed</td>
          </tr>
          ";
        }
        $output .="</tbody></table>";
      }else{
        $output="<br><p style='text-align:center; color:red'><i>No old order to show</i></p>";
      }
      echo $output;
    }
}

?>