File manager - Edit - /home/autoph/public_html/connectv1/resources/views/sc_compliance/compliance_clients.php
Back
<?php include('cfg/db.php'); // include('app/security/security.php'); if(!isset($_SESSION['user'])){ header('location:signin.php'); } // $check_page = new CheckPage(); // $check_page->start($db); if(!(isset($global_action_permissions['7']['33']) && in_array("1", $global_action_permissions['7']['33']))){ header('location:signin.php'); } if(!isset($_REQUEST['q'])){ header('location:sales_person.php'); } $sc_id = $db->escape($_REQUEST['q']); $customer_type = (!isset($_REQUEST['type'])) ? '' : $db->escape($_REQUEST['type']); $start_date = (!isset($_REQUEST['start'])) ? '' : $db->escape($_REQUEST['start']); $end_date = (!isset($_REQUEST['end'])) ? '' : $db->escape($_REQUEST['end']); $get_company = (!isset($_REQUEST['company'])) ? '' : $db->escape($_REQUEST['company']); $complete_type = (!isset($_REQUEST['status'])) ? '' : $db->escape($_REQUEST['status']); // echo $company;exit; ?> <!DOCTYPE html> <html lang="en"> <head> <!-- <script src="dist/js/filter.js"></script> --> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title> <?php echo $variable['site_name']; ?> | Client</title> <!-- Google Font: Source Sans Pro --> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback"> <!-- Font Awesome --> <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css"> <!-- Select2 --> <link rel="stylesheet" href="plugins/select2/css/select2.min.css"> <link rel="stylesheet" href="plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css"> <!-- Theme style --> <link rel="stylesheet" href="dist/css/adminlte.min.css"> <!-- overlayScrollbars --> <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css"> <!-- Default style --> <link rel="stylesheet" href="dist/css/default.css"> <!-- SweetAlert2 --> <link rel="stylesheet" href="plugins/sweetalert2-theme-bootstrap-4/bootstrap-4.min.css"> <!-- Toastr --> <link rel="stylesheet" href="plugins/toastr/toastr.min.css"> <link href="plugins/bootstrap-table/css/bootstrap-table.min.css" rel="stylesheet"> <!-- Tempusdominus Bootstrap 4 --> <link rel="stylesheet" href="plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css"> <link href="dist/img/<?php echo $variable['logo']; ?>" rel="icon" /> <!-- BS Stepper --> <link rel="stylesheet" href="plugins/bs-stepper/css/bs-stepper.min.css"> <!-- Ekko Lightbox --> <link rel="stylesheet" href="plugins/ekko-lightbox/ekko-lightbox.css"> <style> #customer-modal-tab .nav-link.active, .nav-item.active { color: rgb(0 123 255); border-bottom: 1px solid rgb(0 123 255) !important; } .custom-badge { padding: .30em .4em; position: absolute; top: 9px; font-weight: 500; line-height: 0.6; } #children-list-table .bootstrap-datetimepicker-widget { position: relative !important; /* height: 200px; */ top: 0px !important; } .fixed-table-width { table-layout: fixed; width: 100px; } .fixed-table-width td { /* border: 1px solid green; */ overflow: hidden; } /* Chrome, Safari, Edge, Opera */ input::-webkit-outer-spin-button, input::-webkit-inner-spin-button { -webkit-appearance: none; margin: 0; } /* Firefox */ input[type=number] { -moz-appearance: textfield; } .no-border-card { box-shadow: 0 0 1px rgba(0, 0, 0, .125), 0 1px 3px rgba(0, 0, 0, 0); } .big-letter { text-transform: uppercase; } /* .nav-link.active { font-weight: bold; } */ .badge { font-size: 85%; } </style> <!-- END MULTI --> <style> /* .div-blocks{ scroll-behavior: smooth; } */ /* .select2-selection__rendered li { margin: 6px 0px 4px; } */ table.fixed { table-layout: fixed; } table.fixed td { overflow: hidden; } .hidden { display: none; } .btnRemove { display: visible; } table { cursor: pointer; } table th { cursor: default; } .form-div { margin-top: 100px; border: 1px solid #e0e0e0; } #profileDisplay { display: block; height: 160px; width: 160px; margin: 0px auto; border-radius: 50%; } .blue-color { color: blue; } .tab1 { tab-size: 4; } .img-placeholder { width: 160px; color: white; height: 160px; background: none; opacity: .7; border-radius: 50%; z-index: 2; position: absolute; left: 50%; transform: translateX(-50%); display: none; } .img-placeholder h4 { margin-top: 40%; color: white; } .img-div:hover .img-placeholder { display: block; cursor: pointer; } fieldset { margin-left: 2px; margin-right: 2px; padding-top: 0.35em; padding-bottom: 0.625em; padding-left: 0.75em; padding-right: 0.75em; border: 1px solid gray; border-radius: 3%; } legend { font-size: 16px; font-weight: bold; color: blue; } .lbl { font-size: 90%; font-weight: normal !important; } .input { font-size: 90%; font-weight: normal !important; background-color: white !important; } .lbl-forms { font-size: 90%; font-weight: bold; } .lbl-forms-sm { font-size: 90%; height: 28px !important; } .input-forms { font-size: 95%; font-weight: normal !important; background-color: white !important; } .span-labels { font-size: 90%; font-style: italic; } .span-values { font-size: 90%; } table { font-size: 90%; } .list-group-item { padding: .25rem .50rem; } .edit-customer { height: 70%; } </style> </head> <!-- <body class="hold-transition sidebar-mini text-sm" oncopy='return false' oncut='return false' onselectstart='return false'> --> <body class="hold-transition sidebar-mini text-sm layout-fixed"> <div class="wrapper"> <!-- Preloader --> <div class="preloader flex-column justify-content-center align-items-center" hidden> <img class="animation__shake" src="dist/img/<?php echo $variable['logo']; ?>" alt="<?php echo $variable['logo']; ?>" height="60" width="60"> </div> <!-- INCLUDE HEADER --> <?php include('include/header.php'); ?> <?php include('include/sidebar.php'); ?> <!-- /.navbar --> <!-- Content Wrapper. Contains page content --> <div id="sales-wrapper" class="content-wrapper"> <!-- Content Header (Page header) --> <!-- Main content --> <section class="content"> <div class="container-fluid"> <div class="row"> <div class="col-md mt-3"> <div id="sales_table_list" class="card card-primary" style="display: ;"> <div class="card-header" id="profile-header" style="display:;"> <h3 class="card-title"><button class="btn btn-tool" title="Go back" type="button" onclick="back()"><i class="fas fa-arrow-alt-circle-left fa-2x"></i></button> Clients <span class="sales-person-names"></span></h3> </div> <!-- INSERT TABLE HERE --> <div class="card"> <div class="card-body"> <!-- <div class="col-6"> <input type="button" id="new-sales" class="btn btn-primary btn-sm mr-1" data-toggle="modal" data-target="#modal-sales" value="New Sales"></input> </div> --> <!-- <div class="table-responsive"> --> <div> <table id="sales-table" class="table table-sm" data-toggle="table" data-url="" data-pagination="true" data-search="true" data-show-refresh="true" data-show-toggle="false" data-show-columns="false" data-show-columns-toggle-all="false" data-side-pagination="server" data-page-size = "15" data-show-export="false" data-export-options='{"fileName": "Executive Report Client List"}' data-export-types= "['xlsx','excel','csv', 'doc', 'png']" data-buttons="buttonsFunction" data-page-list="[15, 30, 50, 100, all]" data-minimum-count-columns="2" data-show-pagination-switch="false" data-pagination="true" data-query-params="queryParams" data-click-to-select="true"> <thead> <tr> <th data-formatter="checkIfEmpty" data-field="release_date">Released Date</th> <th data-formatter="checkIfEmpty" data-field="customer_name"> Customer </th> <th data-formatter="checkIfEmpty" data-field="company"> Company </th> <th data-formatter="checkIfEmpty" data-field="dealer">Dealer </th> <!-- <th data-formatter="tableMobileFormatter" data-field="mobile_phone_1">Mobile </th> <th data-formatter="tableEmailFormatter" data-field="email_1"> Email </th> --> <!-- <th data-formatter="checkIfEmpty" data-field="po_number">PO Number</th> --> <th data-formatter="checkIfEmpty" data-field="conduction_sticker">CS Number </th> <th data-formatter="checkIfEmpty" data-field="brand_name">Brand </th> <th data-formatter="checkIfEmpty" data-field="model_name">Model </th> <th data-formatter="checkIfEmpty" data-field="status">Status </th> <!-- <th data-formatter="checkIfEmpty" data-field="sales_person"> Sales Person</th> --> <!-- <th data-formatter="checkIfEmpty" data-field="customer_name_id">Customer ID / Name</th> --> </tr> </thead> </table> </div> <!--table-responsive--> </div> <!--card-body--> </div> <!--card--> </div> <!--card card-primary--> </div> <!--col-md--> </div> <!--row--> </div><!-- /.container-fluid --> </section> <!-- /.content --> </div> <!-- /.content-wrapper --> <!--Modal here--> <?php include 'include/components/sales/modal/add_sales.php'; ?> <!-- INSERT FOOTER --> <?php include('include/footer.php'); ?> <!-- Control Sidebar --> <aside class="control-sidebar control-sidebar-dark"> <!-- Control sidebar content goes here --> </aside> <!-- /.control-sidebar --> </div> <!-- ./wrapper --> </div> <!-- jQuery --> <script src="plugins/jquery/jquery.min.js"></script> <!-- overlayScrollbars --> <script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script> <!-- Select2 --> <script src="plugins/select2/js/select2.full.min.js"></script> <!-- InputMask --> <script src="plugins/moment/moment.min.js"></script> <script src="plugins/inputmask/jquery.inputmask.min.js"></script> <!-- date-range-picker --> <script src="plugins/daterangepicker/daterangepicker.js"></script> <!-- jQuery Cookie--> <script src="plugins/jquery-cookie/jquery.cookie.js"></script> <!-- Bootstrap 4 --> <script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script> <!-- Tempusdominus Bootstrap 4 --> <script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script> <!-- SweetAlert2 --> <script src="plugins/sweetalert2/sweetalert2.min.js"></script> <!-- Toastr --> <script src="plugins/toastr/toastr.min.js"></script> <script src="dist/js/tableExport/tableExport.min.js"></script> <script src="dist/js/tableExport/libs/js-xlsx/xlsx.core.min.js"></script> <script src="dist/js/tableExport/libs/jsPDF/jspdf.umd.min.js"></script> <script src="dist/js/tableExport/libs/es6-promise/es6-promise.auto.min.js"></script> <script src="dist/js/tableExport/libs/html2canvas/html2canvas.min.js"></script> <script src="plugins/bootstrap-table/js/bootstrap-table.min.js"></script> <script src="plugins/bootstrap-table/js/bootstrap-table-en-US.js"></script> <script src="plugins/bootstrap-table/js/bootstrap-table-export.min.js"></script> <!-- BS-Stepper --> <script src="plugins/bs-stepper/js/bs-stepper.min.js"></script> <!-- AdminLTE App --> <script src="dist/js/adminlte.min.js"></script> <!-- Ekko Lightbox --> <script src="plugins/ekko-lightbox/ekko-lightbox.min.js"></script> <!-- Navigation Highlight --> <script src="dist/js/main.js"></script> <!-- Page specific script --> <script> var sc_id = '<?php echo $sc_id; ?>'; var customer_type = '<?php echo $customer_type; ?>'; var start_date = '<?php echo $start_date; ?>'; var end_date = '<?php echo $end_date; ?>'; var company = '<?php echo $get_company; ?>'; var complete_type = '<?php echo $complete_type; ?>'; function checkIfEmpty(value, row, index) { if (isEmpty(value)) { return "<span style='color:red;'> (Not Provided) </span>"; } return value; } function refreshTable() { var $sales_table = $('#sales-table') $(function() { $sales_table.bootstrapTable('refresh', { // url: 'https://www.autohub.ph/connect/LOAD_SALES_PERSON.php' url: "api/compliance/compliance.php", }); }) } function queryParams(params) { return { search: params.search, offset: params.offset, limit: params.limit, type: customer_type, company : company, start_date : start_date, end_date : end_date, sc_id: sc_id, status:complete_type, apiKey: '6037364564277021', secure : 1 //other filters hehe }; } function back() { window.history.back(); } function isEmpty(string) { var flag = false; try { string = string.trim(); if (string == '') { flag = true; } else if (string == null) { flag = true; } else if (string == '-') { flag = true; } else { return false; } } catch (err) { return true; } return flag; } function addCommas(numberString) { numberString += ''; var x = numberString.split('.'), x1 = x[0], x2 = x.length > 1 ? '.' + x[1] : '', rgxp = /(\d+)(\d{3})/; while (rgxp.test(x1)) { x1 = x1.replace(rgxp, '$1' + ',' + '$2'); } return x1 + x2; } function getASANameByASAID(objectId) { $.ajax({ url: 'https://www.autohub.ph/connect/LOAD_SALES_PERSON.php', type: "POST", dataType: 'json', data: { uid: sc_id, apiKey: '3892635489643867' }, beforeSend: function() {}, success: function(result) { // alert(result['rows'][0].u_lname) var name = result['rows'][0].u_fname + ' ' + result['rows'][0].u_lname; $("." + objectId).text(name); // alert(name) // var newOption = new Option(name, sc_id, true, true); // $("#" + objectId).append(newOption).trigger('change'); } }); } function tableMobileFormatter(value, row, index) { if (isEmpty(value)) { return "<span style='color:red;'> (Not Provided) </span>"; } if (value == '-1') { return ""; } return "<a href='tel:" + value + "'>" + value + "</a>"; } function tableEmailFormatter(value, row, index) { if (isEmpty(value)) { return "<span style='color:red;'> (Not Provided) </span>"; } if (value == '-1') { return ""; } return "<a href='mailto:" + value + "'>" + value + "</a>"; } function buttonsFunction() { return { grid_toggle_off: { 'icon': 'fa-file-pdf', 'event': 'exportPdf', 'attributes': { 'title': 'Download PDF', 'data-test': 'test123' } }, excel_export: { 'icon': 'fa-file-excel', 'event': 'exportXlsx', 'attributes': { 'title': 'Download XLSX', 'data-test': 'test123' } } } } function exportXlsx() { $('#sales-table').tableExport({ // onCellHtmlData: DoOnCellHtmlData, // ignoreColumn: [9,10], fileName: 'Executive Report Client List', type: 'xlsx' }); } function exportPdf() { $('#sales-table').tableExport({ fileName: 'Executive Report Client List', type: 'pdf', jspdf: { orientation: 'p', margins: { left: 20, right: 10, top: 20, bottom: 20 }, autotable: { styles: { overflow: 'linebreak' }, tableWidth: 'wrap', tableExport: { onBeforeAutotable: DoBeforeAutotable, onCellData: DoCellData } } } }); // $('#compliance-table').tableExport({type:'pdf', // pdfmake:{ // enabled:true, // docDefinition:{pageOrientation:'portrait'}} // }); } function DoCellData(cell, row, col, data) {} function DoBeforeAutotable(table, headers, rows, AutotableSettings) {} </script> <!-- CLARENCE ROCKS --> <script> $(document).ready(function() { refreshTable(); if (!isEmpty(sc_id)) { // getASANameByASAID('sales-person-name'); } $('#sales-table').on('click-cell.bs.table', function(field, value, row, $el) { if (value == 'email_1' || value == 'mobile_phone_1'){ return; } if( customer_type == 'customer_affiliation' || customer_type == 'nature_of_business' || customer_type == 'email_1' || customer_type == 'mobile_phone_1' || customer_type == 'address_1' || customer_type == 'profession' || customer_type == 'position' || customer_type == 'gender' || customer_type == 'date_of_birth' || customer_type == 'facebook' ){ $.cookie("customer_selected_tab", 'custom-tabs-three-home-tab'); window.location.href = "customer_view.php?q=" + $el.customer_id; }else{ $.cookie("vehicle_tab_open", 1); window.location.href = "vehicle_view.php?q=" + $el.vehicle_id; } }); }); </script> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings