KUUUEEEH/orders.php at master · tananntze/KUUUEEEH · 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
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->

<?php
session_start();
if (!isset($_SESSION['userId'])) {
    header("Location: login.php");
    exit();
}
?>

<html lang="en" class="header">

<head>
    <title>Orders and Deliveries</title>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
    <link rel="stylesheet" href="css/main.css">
    <link rel="stylesheet" href="css/editadmin.css">
    <!--<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"> -->
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
    <!--<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script> -->
    <script src='https://kit.fontawesome.com/a076d05399.js'></script>
</head>

<body class="overlay">
    <?php
    include "adminheader.php";

    ?>

    <header class="container">
        <!--The animated kueh images for the banner are taken and credited by ladyironchef: Beginner’s Guide to Kuehs – 9 Traditional Kuehs You Must Try https://www.ladyironchef.com/2015/08/guide-traditional-kueh/-->
        <img src="img/BannerWhite.png" alt="Kueh Banner" class="responsive" id="bannerresize">
    </header>

    <section class="container standardfont card card-body">
        <h1 class="fontheader" id="order_header">Orders & Deliveries</h1>
        <form>
            <div class="row">
                <div class="col-4">
                    <div class="form-group">
                        <!--<label for="orderId">Order Id</label> -->
                        <input type="text" name="orderId" id="orderId" class="form-control" aria-label="search" placeholder="Enter Order Id">
                    </div>
                </div>

                <div class="col-4">
                    <button type="submit" name="submit" id="submit" class="btn btn-primary" aria-label="Submit Search"><span class="fas fa-search"></span> Search</button>
                    <button type="submit" name="clear" id="clear" class="btn btn-danger"><span class="fas fa-sync-alt"></span> Clear</button>
                </div>
            </div>
        </form>

        <table class="table table-hover table-responsive">
            <thead>
                <tr class="d-flex">
                    <th class="col-2">OrderId</th>
                    <th class="col-6">Customer Email</th>
                    <th class="col-3">Delivery Mode</th>
                    <th class="col-4">Status</th>
                    <th class="col-4">Total</th>
                    <th class="col-3">Action</th>
                </tr>
            </thead>
            <tbody>
                <?php
                include "dbConfig.php";
                $conn = connectToDB();
                $sql = "SELECT * FROM checkout_details";
                $result = $conn->query($sql);
                while ($row = $result->fetch_assoc()) {
                    $orderId = $row['orderId'];
                    ?>
                    <tr class="table-light d-flex">
                        <td class="col-2 data"><?php echo $orderId ?></td>
                        <td class="col-6 data"><?php echo $row['customer_email']; ?></td>
                        <td class="col-3 data"><?php echo $row['deliveryType']; ?></td>
                        <td class="col-4 data"><?php echo $row['status']; ?></td>
                        <td class="col-4 data"><?php echo $row['totalPrice']; ?></td>
                        <td class="col-3">
                            <a href="edit_order.php?orderId=<?php echo $orderId ?>" class="edit" aria-label="Edit Order"><span class="fa fa-edit">Edit</span></a> <br>
                            <a href="delete_order.php?orderId=<?php echo $orderId ?>" class="delete" aria-label="Delete Order"><span class="fas fa-trash-alt"> Delete</span></a></td>

                    </tr>
                <?php
                }
                $result->free_result();
                $conn->close();
                ?>
            </tbody>
        </table>
    </section>

</body>

</html>