korsygdsfftyhgfdddszangaiide
Elepffwfggsfggjewesxsfrghf
/
var
/
www
/
html
/
site_shopudiet
/
admin
/
Upload FileeE
HOME
<?php include 'dbconnect.php'; session_start(); if(!isset($_SESSION["sess_user"])){ header("Location: shop.php"); } else { ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <link rel="apple-touch-icon" sizes="76x76" href="../assets/img/apple-icon.png"> <link rel="icon" type="image/png" href="../assets/img/favicon.png"> <title>shopUdiet | Confirm Order </title> <!-- Fonts and icons --> <link href="https://fonts.googleapis.com/css?family=Poppins:200,300,400,600,700,800" rel="stylesheet" /> <link href="https://use.fontawesome.com/releases/v5.0.6/css/all.css" rel="stylesheet"> <!-- Nucleo Icons --> <link href="./css/nucleo-icons.css" rel="stylesheet" /> <!-- CSS Files --> <link href="./css/black-dashboard.css?v=1.0.0" rel="stylesheet" /> <!-- CSS Just for demo purpose, don't include it in your project --> <link href="./demo/demo.css" rel="stylesheet" /> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script> </head> <body class=""> <div class="wrapper"> <?php include('sidebar.php');?> <div class="main-panel"> <!-- Navbar --> <nav class="navbar navbar-expand-lg navbar-absolute navbar-transparent"> <div class="container-fluid"> <div class="navbar-wrapper"> <div class="navbar-toggle d-inline"> <button type="button" class="navbar-toggler"> <span class="navbar-toggler-bar bar1"></span> <span class="navbar-toggler-bar bar2"></span> <span class="navbar-toggler-bar bar3"></span> </button> </div> <a class="navbar-brand" href="javascript:void(0)">shopUdiet</a> </div> <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navigation" aria-expanded="false" aria-label="Toggle navigation"> <span class="navbar-toggler-bar navbar-kebab"></span> <span class="navbar-toggler-bar navbar-kebab"></span> <span class="navbar-toggler-bar navbar-kebab"></span> </button> <div class="collapse navbar-collapse" id="navigation"> <ul class="navbar-nav ml-auto"> <li class="dropdown nav-item"> <a href="#" class="dropdown-toggle nav-link" data-toggle="dropdown"> <div class="photo"> <img src="./img/anime3.png" alt="Profile Photo"> </div> <b class="caret d-none d-lg-block d-xl-block"></b> <p class="d-lg-none"> Log out </p> </a> <ul class="dropdown-menu dropdown-navbar"> <li class="nav-link"><a href="change_pwd" class="nav-item dropdown-item">Change Password</a></li> <li class="nav-link"> <?php echo $_SESSION['id']; ?><a href="logout.php" class="nav-item dropdown-item">Log out</a></li> </ul> </li> <li class="separator d-lg-none"></li> </ul> </div> </div> </nav> <div class="modal modal-search fade" id="searchModal" tabindex="-1" role="dialog" aria-labelledby="searchModal" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <input type="text" class="form-control" id="inlineFormInputGroup" placeholder="SEARCH"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <i class="tim-icons icon-simple-remove"></i> </button> </div> </div> </div> </div> <!-- End Navbar --> <div class="content"> <div class="row"> <div class="col-md-12"> <div class="card "> <div class="card-header"> <h4 class="card-title"> Orders List</h4> </div> <div class="card-body"> <div class="tb_search col-sm-3 col-sm-offset-2"> <input type="text" id="search_input_all" onkeyup="FilterkeyWord_all_table()" placeholder="Search.." class="form-control"> </div> <!--<form action = "confirm_product.php" method="POST">--> <div class=" col-sm-2 col-sm-offset-2" style = "float:right;"> <input type="button" onclick = "date_filter()" value = "GO"class="btn btn-success"> </div> <div class=" col-sm-2 col-sm-offset-2" style = "float:right;"> <input type="date" name="to" id = "to" class="form-control"> </div> <div class=" col-sm-2 col-sm-offset-2" style = "float:right;"> <input type="date" class="form-control" id = "from" name = "from"> </div> <!-- </form> --> <div class="table-responsive" style="overflow: hidden; width:99%;"> <table class="table table-bordered " id="table-id"> <thead class=" text-primary"> <tr> <th> Order Id </th> <th>Date</th> <th>Time</th> <th> Name </th> <th>Products</th> <!-- <th>No of Items</th> <th>Total Price</th> --> <th>status</th> <th>Coupon discount amt</th> <th></th> <th style="width: 20%;" class="text-center">Action</th> </tr> </thead> <?php include 'dbconnect.php'; // $squery = "SELECT * FROM confirm_order WHERE status='confirm' or status='cancel'"; // $result = mysqli_query($conn,$squery); // while( $row = mysqli_fetch_array($result)) // { include('connect.php'); $limit = 15; if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; }; $start_from = ($page-1) * $limit; $result = mysqli_query($conn, "SELECT * FROM confirm_order WHERE status='confirm' OR status='enquiry' ORDER BY id DESC LIMIT $start_from, $limit"); ?> <tbody id = "table"> <?php while($row = mysqli_fetch_array($result)) { ?> <tr id="<?php echo $row['id'] ?>"> <td>FC00<?php echo $row['id'];?></td> <td> <?php echo $row['date'];?> </td> <td> <?php echo $row['time'];?> </td> <td> <?php echo $row['username'];?> </td> <td><?php $data = $row['product']; $id = $row['id']; $prd_id = $row['product_id']; $arr = explode(",",$data); $pid = explode(",",$prd_id); for($i = 0; $i <count($arr); $i++){ echo $arr[$i]; $data = mysqli_query($conn,"SELECT * FROM product INNER JOIN purchased_products ON product.id=purchased_products.product_id WHERE product.id='$pid[$i]' AND purchased_products.confirm_id='$id' AND purchased_products.gst_price=''"); while($prd = mysqli_fetch_array($data)) { ?><span style="color:gray;"><?php echo ' ('.$prd['weight'].') ';?></span><span style="font-size:12px;"><?php $bid = $prd['brand_id']; $s = mysqli_query($conn,"SELECT * FROM brand WHERE id='$bid'"); while($r = mysqli_fetch_array($s)) { echo '['.$r['brand_name'].'].'; } ?></span><?php } ?><br><?php } ?></td> <!-- <td> <?php echo $row['item_no'];?> </td> <td><?php echo $row['total'];?></td --> <td><?php echo $row['status'];?><br><?php if(isset($row['pay_status'])) echo '['.$row['pay_status'];?></td> <td><?php echo $row['coupon_discount_amount'];?></td> <td><form action="update_confirm.php?id=<?php echo $row['id']; ?>" method="post"> <select name="order" class="order"> <option value="cancel"> cancel </option> <option value="delivered"> delivered </option> </select> <button class="changebutton"><i class="fa fa-check changebuttoni" aria-hidden="true" ></i> </button> </form></td> <td class="text-center icons"> <a class="remove" title="Delete"><i class="fa fa-trash" aria-hidden="true" ></i></a> <a href="view_confirm_order.php?id=<?php echo $row['id']; ?>" title="View"><i class="fa fa-eye" aria-hidden="true"></i></a> <a href="edit_confirm_order.php?id=<?php echo $row['id']; ?>" title="View"><i class="tim-icons icon-pencil" aria-hidden="true"></i></a> <a href="invoice_order.php?id=<?php echo base64_encode($row['id']); ?>" title="invoice" target="_blank"><i class="fa fa-download" aria-hidden="true"></i></a> </td> </tr> <?php } ?> </tbody> </table> <?php $sql = "SELECT COUNT(id) FROM confirm_order WHERE status='confirm' or status='cancel' or status='enquiry'"; /*echo "$sql"; */ $rs_result = mysqli_query($conn, $sql); $row = mysqli_fetch_row($rs_result); $total_records = $row[0]; $total_pages = ceil($total_records / $limit); $pagLink = "<div class='pagination pull-right'>"; for ($i=1; $i<=$total_pages; $i++) { $pagLink .= "<a href='conform_product.php?page=".$i."'>".$i."</a>"; }; echo $pagLink . "</div>"; ?> <!-- <script> // Get the modal var modal = document.getElementById("myModal"); // Get the button that opens the modal var btn = document.getElementById("myBtn"); // Get the <span> element that closes the modal var span = document.getElementsByClassName("close")[0]; // When the user clicks the button, open the modal btn.onclick = function() { modal.style.display = "block"; } // When the user clicks on <span> (x), close the modal span.onclick = function() { modal.style.display = "none"; } // When the user clicks anywhere outside of the modal, close it window.onclick = function(event) { if (event.target == modal) { modal.style.display = "none"; } } </script> --> </div> </div> </div> </div> </div> </div> <footer class="footer"> <div class="container-fluid"> <div class="copyright"> © <script> document.write(new Date().getFullYear()) </script> Developped with <i class="tim-icons icon-heart-2"></i> by <a href="javascript:void(0)" target="_blank">Ephphatha Softech</a> </div> </div> </footer> </div> </div> <!-- Core JS Files --> <script src="./js/core/jquery.min.js"></script> <script src="./js/core/popper.min.js"></script> <script src="./js/core/bootstrap.min.js"></script> <script src="./js/plugins/perfect-scrollbar.jquery.min.js"></script> <!-- Google Maps Plugin --> <!-- Place this tag in your head or just before your close body tag. --> <script src="https://maps.googleapis.com/maps/api/js?key=YOUR_KEY_HERE"></script> <!-- Chart JS --> <script src=".js/plugins/chartjs.min.js"></script> <!-- Notifications Plugin --> <script src=".js/plugins/bootstrap-notify.js"></script> <!-- Control Center for Black Dashboard: parallax effects, scripts for the example pages etc --> <script src=".js/black-dashboard.min.js?v=1.0.0"></script><!-- Black Dashboard DEMO methods, don't include it in your project! --> <script src="./demo/demo.js"></script> <script src="https://cdn.trackjs.com/agent/v3/latest/t.js"></script> <script> window.TrackJS && TrackJS.install({ token: "ee6fab19c5a04ac1a32a645abde4613a", application: "black-dashboard-free" }); /*menu*/ var dropdown = document.getElementsByClassName("dropdown-btn"); var i; for (i = 0; i < dropdown.length; i++) { dropdown[i].addEventListener("click", function() { this.classList.toggle("active"); var dropdownContent = this.nextElementSibling; if (dropdownContent.style.display === "block") { dropdownContent.style.display = "none"; } else { dropdownContent.style.display = "block"; } }); } </script> </body> <style type="text/css"> .icons a{ padding:10px; } .add{ float: right; } .sidenav a, .dropdown-btn { padding: 6px 8px 6px 16px; text-decoration: none; display: block; border: none; background: none; width: 100%; text-align: left; cursor: pointer; outline: none; color: #fff; } /* Main content */ .main { margin-left: 200px; /* Same as the width of the sidenav */ padding: 0px 10px; } /* Add an active class to the active dropdown button */ /* Dropdown container (hidden by default). Optional: add a lighter background color and some left padding to change the design of the dropdown content */ .dropdown-container { display: none; padding-left: 8px; } .dropdown-container a{ text-align: right; padding-right: 70px; line-height: 30px;} .sidenav a:hover { color: #32325d; } a:focus { /* outline: 1px dotted; */ outline: none; background-color: #0000001c; } .sidenav li{ padding: 10px; outline: 1px solid #0000001c; /* background-color: #0000001c; */ } .table tbody+tbody { border-top: 0.125rem solid #3d3f51; } </style> <style> .pagination { display: inline-block; } .pagination a { color: #fff; float: left; padding: 8px 16px; text-decoration: none; transition: background-color .3s; border: 1px solid #ba54f5; } .pagination a:hover:not(.active) {background-color: #ba54f5;} </style> <script type="text/javascript"> function FilterkeyWord_all_table() { var count = $('.table').children('tbody').children('tr:first-child').children('td').length; var input, filter, table, tr, td, i; input = document.getElementById("search_input_all"); var input_value = document.getElementById("search_input_all").value; filter = input.value.toLowerCase(); if(input_value !=''){ table = document.getElementById("table-id"); tr = table.getElementsByTagName("tr"); for (i = 1; i < tr.length; i++) { var flag = 0; for(j = 0; j < count; j++){ td = tr[i].getElementsByTagName("td")[j]; if (td) { var td_text = td.innerHTML; if (td.innerHTML.toLowerCase().indexOf(filter) > -1) { flag = 1; } else { } } } if(flag==1){ tr[i].style.display = ""; }else { tr[i].style.display = "none"; } } }else { $('#maxRows').trigger('change'); } } </script> </html> <script type="text/javascript"> $(".remove").click(function(){ var id = $(this).parents("tr").attr("id"); if(confirm('Are you sure to remove this record ?')) { $.ajax({ url: 'delete_shipping.php', type: 'GET', data: {id: id}, error: function() { alert('Something is wrong'); }, success: function(data) { $("#"+id).remove(); alert("Record removed successfully"); } }); } }); function date_filter() { var from = $("#from").val(); var to = $("#to").val(); $("#table").empty(''); $.ajax({ type:'POST', dataType:'json', url:"get_filter_data.php", data:{from:from,to:to}, success: function(data) { $("#table").append(data.tableData); } }); } </script> <?php } ?>