D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
kk.encodersunlimited.com
/
Filename :
order_details.php
back
Copy
<?php include('config.php'); ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8" /> <title>kk-admin</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta content="Premium Multipurpose Admin & Dashboard Template" name="description" /> <meta content="Themesbrand" name="author" /> <!-- App favicon --> <link rel="shortcut icon" href="assets/images/favicon.ico"> <!-- plugin css --> <link href="assets/libs/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.css" rel="stylesheet" type="text/css" /> <!-- preloader css --> <link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" /> <!-- Bootstrap Css --> <link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" /> <!-- Icons Css --> <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" /> <!-- App Css--> <link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" /> </head> <body> <!-- <body data-layout="horizontal"> --> <!-- Begin page --> <div id="layout-wrapper"> <?php include('header.php') ?> <!-- ========== Left Sidebar Start ========== --> <?php include('sidebar.php') ?> <!-- Left Sidebar End --> <!-- ============================================================== --> <!-- Start right Content here --> <!-- ============================================================== --> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <!-- start page title --> <div class="row"> <div class="col-12"> <div class="page-title-box d-sm-flex align-items-center justify-content-between"> <h4 class="mb-sm-0 font-size-18">Product List</h4> <div class="page-title-right"> <ol class="breadcrumb m-0"> <li class="breadcrumb-item"><a href="javascript: void(0);">Products</a></li> <li class="breadcrumb-item active">Product List</li> </ol> </div> </div> </div> </div> <!-- end page title --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body"> <!-- Date filter section --> <form method="GET" action="export_pdf.php" target="_blank"> <input type="hidden" name="startDate" value="<?php echo isset($_GET['startDate']) ? $_GET['startDate'] : ''; ?>"> <input type="hidden" name="endDate" value="<?php echo isset($_GET['endDate']) ? $_GET['endDate'] : ''; ?>"> <button type="submit" class="btn btn-success mb-4">Export to PDF</button> </form> <form method="GET" action=""> <div class="row"> <div class="col-md-4"> <label for="startDate">Start Date:</label> <input type="date" id="startDate" name="startDate" class="form-control" value="<?php echo isset($_GET['startDate']) ? $_GET['startDate'] : ''; ?>"> </div> <div class="col-md-4"> <label for="endDate">End Date:</label> <input type="date" id="endDate" name="endDate" class="form-control" value="<?php echo isset($_GET['endDate']) ? $_GET['endDate'] : ''; ?>"> </div> <div class="col-md-4"> <label> </label> <button type="submit" class="btn btn-primary form-control">Filter</button> </div> </div> </form> <div class="table-responsive"> <table class="table" id="project-status"> <thead> <tr> <th> <span class="f-dark f-w-600">ID</span></th> <th> <span class="f-dark f-w-600">Product Name</span></th> <th> <span class="f-dark f-w-600">Customer</span></th> <th> <span class="f-dark f-w-600">Phone</span></th> <th> <span class="f-dark f-w-600">Gold Weight</span></th> <th> <span class="f-dark f-w-600">Diamond Weight</span></th> <th> <span class="f-dark f-w-600">Making Charge</span></th> <th> <span class="f-dark f-w-600">Profit %</span></th> <th> <span class="f-dark f-w-600">Total Cost</span></th> <th> <span class="f-dark f-w-600">Date</span></th> </tr> </thead> <tbody class="text-dark"> <?php // Get filter values $startDate = isset($_GET['startDate']) ? $_GET['startDate'] : ''; $endDate = isset($_GET['endDate']) ? $_GET['endDate'] : ''; // Build query based on filter $query = "SELECT od.id, p.name, c.category_name, od.gold_weight, od.diamond_weight, od.making_charge, od.profit_percentage, od.total_cost, od.created_at, od.customer_name, od.customer_number FROM order_details od JOIN products p ON od.product_id = p.id JOIN category c ON od.category_id = c.id"; if ($startDate && $endDate) { $query .= " WHERE od.created_at BETWEEN '$startDate' AND '$endDate'"; } $result = mysqli_query($conn, $query); $i = 1; while ($item = mysqli_fetch_assoc($result)) { ?> <tr> <th scope="row"><?php echo $i; ?></th> <td><?php echo $item['name']; ?></td> <td><?php echo $item['customer_name']; ?></td> <td><?php echo $item['customer_number']; ?></td> <td><?php echo $item['gold_weight']; ?></td> <td><?php echo $item['diamond_weight']; ?></td> <td><?php echo $item['making_charge']; ?></td> <td><?php echo $item['profit_percentage']; ?></td> <td><?php echo $item['total_cost']; ?></td> <td><?php echo date('Y-m-d', strtotime($item['created_at'])); ?></td> </tr> <?php $i++; } ?> </tbody> </table> </div> </div> </div> </div> <!-- end col --> </div> <!-- end row --> </div> <!-- container-fluid --> </div> <!-- End Page-content --> <footer class="footer"> <div class="container-fluid"> <div class="row"> <div class="col-sm-6"> <script> document.write(new Date().getFullYear()) </script> © KK Jewellers. </div> <div class="col-sm-6"> <div class="text-sm-end d-none d-sm-block"> Design & Develop by <a href="#!" class="text-decoration-underline">Encoders Unlimited</a> </div> </div> </div> </div> </footer> </div> <!-- Export to PDF and Filter functions --> <script> function filterByDate() { const startDate = document.getElementById('start-date-filter').value; const endDate = document.getElementById('end-date-filter').value; // Logic to filter the table based on the selected dates // You might need to fetch filtered data from the server or filter the data in the frontend alert(`Filtering from ${startDate} to ${endDate}`); } function exportToPDF() { // Logic for exporting the table data to PDF alert('Exporting to PDF...'); } </script> <!-- end main content--> </div> <!-- END layout-wrapper --> <!-- Right Sidebar --> <div class="right-bar"> <div data-simplebar class="h-100"> <div class="rightbar-title d-flex align-items-center bg-dark p-3"> <h5 class="m-0 me-2 text-white">Theme Customizer</h5> <a href="javascript:void(0);" class="right-bar-toggle ms-auto"> <i class="mdi mdi-close noti-icon"></i> </a> </div> <!-- Settings --> <hr class="m-0" /> <div class="p-4"> <h6 class="mb-3">Layout</h6> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout" id="layout-vertical" value="vertical"> <label class="form-check-label" for="layout-vertical">Vertical</label> </div> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout" id="layout-horizontal" value="horizontal"> <label class="form-check-label" for="layout-horizontal">Horizontal</label> </div> <h6 class="mt-4 mb-3 pt-2">Layout Mode</h6> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout-mode" id="layout-mode-light" value="light"> <label class="form-check-label" for="layout-mode-light">Light</label> </div> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout-mode" id="layout-mode-dark" value="dark"> <label class="form-check-label" for="layout-mode-dark">Dark</label> </div> <h6 class="mt-4 mb-3 pt-2">Layout Width</h6> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout-width" id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')"> <label class="form-check-label" for="layout-width-fuild">Fluid</label> </div> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout-width" id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')"> <label class="form-check-label" for="layout-width-boxed">Boxed</label> </div> <h6 class="mt-4 mb-3 pt-2">Layout Position</h6> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout-position" id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')"> <label class="form-check-label" for="layout-position-fixed">Fixed</label> </div> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout-position" id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')"> <label class="form-check-label" for="layout-position-scrollable">Scrollable</label> </div> <h6 class="mt-4 mb-3 pt-2">Topbar Color</h6> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="topbar-color" id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')"> <label class="form-check-label" for="topbar-color-light">Light</label> </div> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="topbar-color" id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')"> <label class="form-check-label" for="topbar-color-dark">Dark</label> </div> <h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6> <div class="form-check sidebar-setting"> <input class="form-check-input" type="radio" name="sidebar-size" id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')"> <label class="form-check-label" for="sidebar-size-default">Default</label> </div> <div class="form-check sidebar-setting"> <input class="form-check-input" type="radio" name="sidebar-size" id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')"> <label class="form-check-label" for="sidebar-size-compact">Compact</label> </div> <div class="form-check sidebar-setting"> <input class="form-check-input" type="radio" name="sidebar-size" id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')"> <label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label> </div> <h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6> <div class="form-check sidebar-setting"> <input class="form-check-input" type="radio" name="sidebar-color" id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')"> <label class="form-check-label" for="sidebar-color-light">Light</label> </div> <div class="form-check sidebar-setting"> <input class="form-check-input" type="radio" name="sidebar-color" id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')"> <label class="form-check-label" for="sidebar-color-dark">Dark</label> </div> <div class="form-check sidebar-setting"> <input class="form-check-input" type="radio" name="sidebar-color" id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')"> <label class="form-check-label" for="sidebar-color-brand">Brand</label> </div> <h6 class="mt-4 mb-3 pt-2">Direction</h6> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout-direction" id="layout-direction-ltr" value="ltr"> <label class="form-check-label" for="layout-direction-ltr">LTR</label> </div> <div class="form-check form-check-inline"> <input class="form-check-input" type="radio" name="layout-direction" id="layout-direction-rtl" value="rtl"> <label class="form-check-label" for="layout-direction-rtl">RTL</label> </div> </div> </div> <!-- end slimscroll-menu--> </div> <!-- /Right-bar --> <!-- Right bar overlay--> <div class="rightbar-overlay"></div> <!-- JAVASCRIPT --> <script src="assets/libs/jquery/jquery.min.js"></script> <script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script> <script src="assets/libs/metismenu/metisMenu.min.js"></script> <script src="assets/libs/simplebar/simplebar.min.js"></script> <script src="assets/libs/node-waves/waves.min.js"></script> <script src="assets/libs/feather-icons/feather.min.js"></script> <!-- pace js --> <script src="assets/libs/pace-js/pace.min.js"></script> <!-- apexcharts --> <script src="assets/libs/apexcharts/apexcharts.min.js"></script> <!-- Plugins js--> <script src="assets/libs/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.min.js"></script> <script src="assets/libs/admin-resources/jquery.vectormap/maps/jquery-jvectormap-world-mill-en.js"></script> <!-- dashboard init --> <script src="assets/js/pages/dashboard.init.js"></script> <script src="assets/js/app.js"></script> </body> </html>