kohjhjhصثقصثقصثقgdfgdg
Ele57885fddfgdfgfghgقفغفغفقhfg555434536
/
home
/
u402332945
/
domains
/
simmar.co.in
/
public_html
/
Admin-Panel
/
Upload FileeE
HOME
<?php include 'db.php'; $name1 = $_POST['name1']; $name2 = $_POST['name2']; //$timestamp1 = strtotime($original_date1); // $name1 = date("d-m-Y", $timestamp1); //$timestamp2 = strtotime($original_date2); // $name2 = date("d-m-Y", $timestamp2); $orderItemSql = "SELECT cust.order_id, cust.daty,cust.qt, cust.cnt, cust.name, cust.email, cust.phonenumr, cust.address FROM cust WHERE cust.daty >= '$name1' AND cust.daty <= '$name2' and cust.status ='Credit'"; $sql = $db->query($orderItemSql); ?> <!DOCTYPE html> <html lang="en"> <!-- Mirrored from thememinister.com/crm/clist.html by HTTrack Website Copier/3.x [XR&CO'2014], Thu, 03 Oct 2019 15:43:24 GMT --> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Customer Management</title> <!-- Favicon and touch icons --> <link rel="shortcut icon" href="assets/dist/img/ico/favicon.png" type="image/x-icon"> <!-- Start Global Mandatory Style =====================================================================--> <!-- jquery-ui css --> <link href="assets/plugins/jquery-ui-1.12.1/jquery-ui.min.css" rel="stylesheet" type="text/css"/> <!-- Bootstrap --> <link href="assets/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css"/> <!-- Bootstrap rtl --> <!--<link href="assets/bootstrap-rtl/bootstrap-rtl.min.css" rel="stylesheet" type="text/css"/>--> <!-- Lobipanel css --> <link href="assets/plugins/lobipanel/lobipanel.min.css" rel="stylesheet" type="text/css"/> <!-- Pace css --> <link href="assets/plugins/pace/flash.css" rel="stylesheet" type="text/css"/> <!-- Font Awesome --> <link href="assets/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/> <!-- Pe-icon --> <link href="assets/pe-icon-7-stroke/css/pe-icon-7-stroke.css" rel="stylesheet" type="text/css"/> <!-- Themify icons --> <link href="assets/themify-icons/themify-icons.css" rel="stylesheet" type="text/css"/> <!-- dataTables css --> <link href="assets/plugins/datatables/dataTables.min.css" rel="stylesheet" type="text/css"/> <!-- End Global Mandatory Style =====================================================================--> <!-- Start Theme Layout Style =====================================================================--> <!-- Theme style --> <link href="assets/dist/css/stylecrm.css" rel="stylesheet" type="text/css"/> <link href="https://cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css"/> <script src="https://code.jquery.com/jquery-3.3.1.js"></script> <script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script> <!-- Theme style rtl --> <!--<link href="assets/dist/css/stylecrm-rtl.css" rel="stylesheet" type="text/css"/>--> <!-- End Theme Layout Style =====================================================================--> </head> <body class="hold-transition sidebar-mini"> <?php include('include/header.php'); ?> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <div class="header-icon"> <i class="fa fa-users"></i> </div> <div class="header-title"> <h1><?php echo $name1;?></h1> <small>Customer List</small> </div> </section> <!-- Main content --> <section class="content"> <div class="row"> <div class="col-sm-12"> <div class="panel panel-bd lobidrag"> <div class="panel-heading"> <div class="btn-group" id="buttonexport"> <a href="#"> <h4>Add customer</h4> </a> </div> </div> <div class="panel-body"> <!-- Plugin content:powerpoint,txt,pdf,png,word,xl --> <div class="btn-group"> <!--<div class="buttonexport" id="buttonlist"> <a class="btn btn-add" href="add-customer.php"> <i class="fa fa-plus"></i> Add Customer </a> </div>--> <button class="btn btn-exp btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> Export Table Data</button> <ul class="dropdown-menu exp-drop" role="menu"> <li> <a href="#" onclick="$('#example').tableExport({type:'json',escape:'false'});"> <img src="assets/dist/img/json.png" width="24" alt="logo"> JSON</a> </li> <li> <a href="#" onclick="$('#example').tableExport({type:'json',escape:'false',ignoreColumn:'[2,3]'});"> <img src="assets/dist/img/json.png" width="24" alt="logo"> JSON (ignoreColumn)</a> </li> <li><a href="#" onclick="$('#example').tableExport({type:'json',escape:'true'});"> <img src="assets/dist/img/json.png" width="24" alt="logo"> JSON (with Escape)</a> </li> <li class="divider"></li> <li><a href="#" onclick="$('#example').tableExport({type:'xml',escape:'false'});"> <img src="assets/dist/img/xml.png" width="24" alt="logo"> XML</a> </li> <li><a href="#" onclick="$('#example').tableExport({type:'sql'});"> <img src="assets/dist/img/sql.png" width="24" alt="logo"> SQL</a> </li> <li class="divider"></li> <li> <a href="#" onclick="$('#example').tableExport({type:'csv',escape:'false'});"> <img src="assets/dist/img/csv.png" width="24" alt="logo"> CSV</a> </li> <li> <a href="#" onclick="$('#example').tableExport({type:'txt',escape:'false'});"> <img src="assets/dist/img/txt.png" width="24" alt="logo"> TXT</a> </li> <li class="divider"></li> <li> <a href="#" onclick="$('#example').tableExport({type:'excel',escape:'false'});"> <img src="assets/dist/img/xls.png" width="24" alt="logo"> XLS</a> </li> <li> <a href="#" onclick="$('#example').tableExport({type:'doc',escape:'false'});"> <img src="assets/dist/img/word.png" width="24" alt="logo"> Word</a> </li> <li> <a href="#" onclick="$('#example').tableExport({type:'powerpoint',escape:'false'});"> <img src="assets/dist/img/ppt.png" width="24" alt="logo"> PowerPoint</a> </li> <li class="divider"></li> <li> <a href="#" onclick="$('#example').tableExport({type:'png',escape:'false'});"> <img src="assets/dist/img/png.png" width="24" alt="logo"> PNG</a> </li> <li> <a href="#" onclick="$('#example').tableExport({type:'pdf',pdfFontSize:'7',escape:'false'});"> <img src="assets/dist/img/pdf.png" width="24" alt="logo"> PDF</a> </li> </ul> </div> <!-- Plugin content:powerpoint,txt,pdf,png,word,xl --> <div class="table-responsive"> <table id="example" class="display" style="width:100%" border="1"> <thead > <tr class="info"> <th>S.No</th> <th>Date</th> <th>Name</th> <th>Email</th> <th>Phone Numbers</th> <th>Address</th> <th>Quantity</th> <th>Total</th> </tr> </thead> <tbody> <?php $subTotal1z = ""; $subTotal1z = 0; $subTotal2 = ""; $subTotal2 = 0; $i = 1; while($row = $sql->fetch_array()) { ?> <tr> <td><?php echo $i;?></td> <td><?php echo $row['1'];?></td> <td><?php echo $row['4'];?></td> <td><?php echo $row['5'];?></td> <td><?php echo $row['6'];?></td> <td><?php echo $row['7'];?></td> <td><?php echo $row['2'];?></td> <td><?php echo $row['3'];?></td> </tr> <?php $i++; $subTotal1z += $row[3]; $subTotal2 += $row[2]; } ?> <tr> <td colspan="7"><center>Total Amount</center></td> <td><center><?php echo $subTotal1z;?></center></td> </tr> <tr> <td colspan="6"><center>Quantity</center></td> <td><center><?php echo $subTotal2;?></center></td> </tr> </tbody> </table> </div> </div> </div> </div> </div> <!-- customer Modal1 --> <div class="modal fade" id="customer1" tabindex="-1" role="dialog" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header modal-header-primary"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3><i class="fa fa-user m-r-5"></i> Update Enquiry</h3> </div> <div class="modal-body"> <div class="row"> <div class="col-md-12"> <form class="form-horizontal"> <fieldset> <!-- Text input--> <div class="col-md-4 form-group"> <label class="control-label">Name of the Student:</label> <input type="text" placeholder="Name of the Student" class="form-control"> </div> <!-- Text input--> <div class="col-md-4 form-group"> <label class="control-label">Name of the Parent:</label> <input type="text" placeholder="Name of the Parent" class="form-control"> </div> <!-- Text input--> <div class="col-md-4 form-group"> <label class="control-label">Course/Class</label> <input type="text" placeholder="Course/Class" class="form-control"> </div> <div class="col-md-6 form-group"> <label class="control-label">Date of Enqiry</label><br> <input type="date" placeholder="Date of Enqiry" class="form-control"> </div> <div class="col-md-6 form-group"> <label class="control-label">Expected Date of Joining</label> <input type="text" placeholder="Expected Date of Joining" class="form-control"> </div> <div class="col-md-6 form-group"> <label class="control-label">How do you know about Our School</label> <input type="text" placeholder="How do you know about Our School" class="form-control"> </div> <div class="col-md-6 form-group"> <label class="control-label">Incharge Staff</label> <input type="text" placeholder="Incharge Staff" class="form-control"> </div> <div class="col-md-6 form-group"> <label class="control-label">Staff Code</label> <input type="text" placeholder="Staff Code" class="form-control"> </div> <div class="col-md-12 form-group user-form-group"> <div class="pull-right"> <button type="button" class="btn btn-danger btn-sm">Cancel</button> <button type="submit" class="btn btn-add btn-sm">Save</button> </div> </div> </fieldset> </form> </div> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-danger pull-left" data-dismiss="modal">Close</button> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> </div> <!-- /.modal --> <!-- Modal --> <!-- Customer Modal2 --> <div class="modal fade" id="customer2" tabindex="-1" role="dialog" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header modal-header-primary"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3><i class="fa fa-user m-r-5"></i> Delete Customer</h3> </div> <div class="modal-body"> <div class="row"> <div class="col-md-12"> <form class="form-horizontal"> <fieldset> <div class="col-md-12 form-group user-form-group"> <label class="control-label">Delete Customer</label> <div class="pull-right"> <button type="button" class="btn btn-danger btn-sm">NO</button> <button type="submit" class="btn btn-add btn-sm">YES</button> </div> </div> </fieldset> </form> </div> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-danger pull-left" data-dismiss="modal">Close</button> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> </div> <!-- /.modal --> </section> <!-- /.content --> </div> <!-- /.content-wrapper --> <?php include('include/footer.php'); ?> </div> <script type="text/javascript"> $(document).ready(function() { $('#example').DataTable( { "pagingType": "full_numbers" } ); } ); </script> <!-- ./wrapper --> <!-- Start Core Plugins =====================================================================--> <!-- jQuery --> <script data-cfasync="false" src="../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script><script src="assets/plugins/jQuery/jquery-1.12.4.min.js" type="text/javascript"></script> <!-- jquery-ui --> <script src="assets/plugins/jquery-ui-1.12.1/jquery-ui.min.js" type="text/javascript"></script> <!-- Bootstrap --> <script src="assets/bootstrap/js/bootstrap.min.js" type="text/javascript"></script> <!-- lobipanel --> <script src="assets/plugins/lobipanel/lobipanel.min.js" type="text/javascript"></script> <!-- Pace js --> <script src="assets/plugins/pace/pace.min.js" type="text/javascript"></script> <!-- table-export js --> <script src="assets/plugins/table-export/tableExport.js" type="text/javascript"></script> <script src="assets/plugins/table-export/jquery.base64.js" type="text/javascript"></script> <script src="assets/plugins/table-export/html2canvas.js" type="text/javascript"></script> <script src="assets/plugins/table-export/sprintf.js" type="text/javascript"></script> <script src="assets/plugins/table-export/jspdf.js" type="text/javascript"></script> <script src="assets/plugins/table-export/base64.js" type="text/javascript"></script> <!-- dataTables js --> <script src="assets/plugins/datatables/dataTables.min.js" type="text/javascript"></script> <!-- SlimScroll --> <script src="assets/plugins/slimScroll/jquery.slimscroll.min.js" type="text/javascript"></script> <!-- FastClick --> <script src="assets/plugins/fastclick/fastclick.min.js" type="text/javascript"></script> <!-- CRMadmin frame --> <script src="assets/dist/js/custom.js" type="text/javascript"></script> <!-- End Core Plugins =====================================================================--> <!-- Start Theme label Script =====================================================================--> <!-- Dashboard js --> <script src="assets/dist/js/dashboard.js" type="text/javascript"></script> <!-- End Theme label Script =====================================================================--> </body> <!-- Mirrored from thememinister.com/crm/clist.html by HTTrack Website Copier/3.x [XR&CO'2014], Thu, 03 Oct 2019 15:44:01 GMT --> </html>