File manager

File manager - Edit - /home/autoph/public_html/connectv1/resources/views/sc_compliance/compliance.php

Back
<?php include_once('cfg/db.php'); // include('app/security/security.php'); include_once("api/controllers/utility.php"); if (!isset($_SESSION['user']['id'])) { header('location:signin.php'); } if (!(isset($global_action_permissions['7']['33']) && in_array("1", $global_action_permissions['7']['33']))) { header('location:signin.php'); } // echo $_SERVER['HTTP_REFERER']; if (!isset($_REQUEST['q'])) { $sc_id = ""; $title = "Executive Report"; } else { $sc_id = $db->escape($_REQUEST['q']); $sc_name = $db->select("SELECT CONCAT(first_name, ' ' ,last_name) FROM sales_consultant WHERE id = $sc_id"); $sc_name = ucwords(strtolower($sc_name)); $title = $sc_name . " Compliance Report"; } $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1'; // $isRoNumberSet = 0; // $isPlateCsIsSet = 0; // $isOrderNumberSet = 0; // $plate_number = ""; // $cs_number = ""; // $vehicle_id = ""; // $vehicle_customer_id = ""; // if(isset($_GET['vehicle'])){ // $table = $_GET['vehicle']; // } else { // $table = "true"; // } // if($table == "true"){ // $isPlateCsIsSet = 0; // } else { // if((isset($_GET['plate_number']) && isNotEmpty($_GET['plate_number'])) \|\| (isset($_GET['cs_number']) && isNotEmpty($_GET['cs_number']))){ // $plate_number = $db->escape(trim($_GET['plate_number'])); // $cs_number = $db->escape(trim($_GET['cs_number'])); // $vehicle_id = $db->escape(trim($_GET['vehicle_id'])); // $vehicle_customer_id = $db->escape(trim($_GET['vehicle_customer_id'])); // $isPlateCsIsSet = 1; // } else if((isset($_GET['order_number'])) && (isNotEmpty($_GET['order_number']))){ // $isPlateCsIsSet = 1; // } // } // function isNotEmpty($data){ // return preg_match('/\S/', $data); // } ?> <!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']; ?> \| <?php echo $title; ?></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"> <!-- 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"> <link href="plugins/bootstrap-table/css/bootstrap-table.min.css" rel="stylesheet"> <!-- daterange picker --> <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css"> <!-- iCheck for checkboxes and radio inputs --> <link rel="stylesheet" href="plugins/icheck-bootstrap/icheck-bootstrap.min.css"> <!-- Bootstrap Color Picker --> <link rel="stylesheet" href="plugins/bootstrap-colorpicker/css/bootstrap-colorpicker.min.css"> <!-- Tempusdominus Bootstrap 4 --> <link rel="stylesheet" href="plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.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"> <!-- Bootstrap4 Duallistbox --> <link rel="stylesheet" href="plugins/bootstrap4-duallistbox/bootstrap-duallistbox.min.css"> <!-- BS Stepper --> <!-- <link rel="stylesheet" href="plugins/bs-stepper/css/bs-stepper.min.css"> --> <!-- dropzonejs --> <link rel="stylesheet" href="plugins/dropzone/min/dropzone.min.css"> <!-- <link rel="stylesheet" href="dist/css/dropzone.css"> --> <!-- Theme style --> <link rel="stylesheet" href="dist/css/adminlte.min.css"> <!-- SweetAlert2 --> <link rel="stylesheet" href="plugins/sweetalert2/sweetalert2.min.css"> <!-- Toastr --> <link rel="stylesheet" href="plugins/toastr/toastr.min.css"> <link href="dist/img/<?php echo $variable['logo']; ?>" rel="icon" /> <!-- Ekko Lightbox --> <link rel="stylesheet" href="plugins/ekko-lightbox/ekko-lightbox.css"> <!-- dropzonejs --> <!-- <link rel="stylesheet" href="plugins/dropzone/min/dropzone.min.css"> --> <style> /* Just add this CSS to your project / / 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; } table.fixed { table-layout: fixed; } table.fixed td { overflow: hidden; } table { cursor: pointer; } table th { cursor: default; } .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; } </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 id="wrapper" 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="6 0" width="60"> </div> <?php include('include/header.php'); ?> <?php include('include/sidebar.php'); ?> <!-- /.navbar --> <!-- Content Wrapper. Contains page content --> <div 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="vehicle_table_list" class="card card-primary" style="display: "> <div class="card-header"> <?php if ($utility->isNotEmpty($sc_id)) { ?> <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> <span class="sales-person-name"></span> <?php echo $title; ?></h3> <?php } else { ?> <h3 class="card-title"><?php echo $title; ?></h3> <?php } ?> </div> <div class="card"> <div class="card-body pt-3"> <!-- SHORT SUMMARY AND ACTION --> <div class="row"> <div class="col-6 text-left"> <div class="p-0 m-0"> <label class="p-0 m-0"> Date Range: </label>  <span id="date_cover"></span> </div> <div class="p-0 m-0"> <label class="p-0 m-0"> Company: </label>  <span id="company_cover"></span> </div> <!-- <input type="button" style="display:none;" id="customer-vehicle-button" class="btn btn-primary btn-sm mr-1" value="New Vehicle" title="New Vehicle"></input> --> </div> <div class="col-6 text-right"> <div class="btn-group mt-2"> <button type="button" class="tooltip-me btn btn-default dropdown-toggle btn-sm" data-toggle="dropdown" aria-haspopup="true" title="Filter" data-html="true" data-placement="left" aria-expanded="true"> <i class="fa fa-filter" aria-hidden="true"></i> </button> <div id="dropdown-filter" class="dropdown-menu dropdown-menu-right"> <div class="form-group mb-0"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <input type="button" class="btn btn-primary btn-sm form-control form-control-sm " name="btnCustomerListNoFilter" id="btnCustomerListNoFilter" value="Reset" style="width: 100%;"></input> </div> <!--form-group dropdown--> </div> <!--form-group--> <div class="form-group mb-0"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <div id="filter-date" class="p-1" name="filter-date" style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc; width: 100%"> <i class="fa fa-calendar"></i>  <span></span> <i class="fa fa-angle-down mt-1 float-right"></i> </div> </div> <!--form-group dropdown--> </div> <!--form-group--> <!-- text input --> <div class="form-group mb-0"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <select name="company-filter" id="company-filter" class="form-control form-control-sm select2" style="width: 100%;"> <option></option> <?php $company = $db->return_result("SELECT `id`, `code` FROM `source_company` WHERE status = 1 AND id IN (" . $granted_company_ids . ") ORDER BY code ASC"); foreach ($company as $data) { echo "<option value='{$data['id']}' >" . $data['code'] . "</option>"; } ?> </select> </div> <!--form-group dropdown--> </div> <!--form-group--> </div> </div> </div> </div> <hr class="mt-1"> <div class="row"> <!-- <div class="col-md-12"> <h4 class="no-margin">Compliance Summary</h4> </div> --> <div id="vehicle_action_all" class="col-md-3 col-sm-6 col-12" style="cursor: normal;"> <div class="info-box"> <span class="info-box-icon bg-primary"><i class="fa fa-car"></i></span> <div class="info-box-content"> <span class="info-box-text">Submitted</span> <span class="info-box-number" id="total_compliance">0</span> </div> <!-- /.info-box-content --> </div> <!-- /.info-box --> </div> <!-- /.col --> <div id="vehicle_action_new" class="col-md-3 col-sm-6 col-12" style="cursor: normal;"> <div class="info-box"> <span class="info-box-icon bg-info"><i class="fa fa-car"></i></span> <div class="info-box-content"> <div class="row"> <div class="col-10"> <span class="info-box-text">Complete </span> </div> <!-- <div class="col-2"> <i class="float-right tooltip-me mt-2 mr-2 mb-0 fas fa-question-circle" style="color:blue; cursor: help;" title="Record count from last 7 days"></i> </div> --> </div> <span class="info-box-number" id="complete_compliance">0</span> </div> <!-- /.info-box-content --> </div> <!-- /.info-box --> </div> <!-- /.col --> <div id="vehicle_action_updated" class="col-md-3 col-sm-6 col-12" style="cursor: normal;"> <div class="info-box"> <span class="info-box-icon bg-warning"><i class="fa fa fa-sync"></i></span> <div class="info-box-content"> <div class="row"> <div class="col-10"> <span class="info-box-text">Incomplete </span> </div> <!-- <div class="col-2"> <i class="float-right tooltip-me mt-2 mr-2 mb-0 fas fa-question-circle" style="color:blue; cursor: help;" title="Record count from last 7 days"></i> </div> --> </div> <span class="info-box-number" id="incomplete_compliance">0</span> </div> <!-- /.info-box-content --> </div> <!-- /.info-box --> </div> <!-- /.col --> <div id="vehicle_action_added" class="col-md-3 col-sm-6 col-12" style="cursor: normal;"> <div class="info-box"> <span class="info-box-icon bg-success"><i class="fa fa-plus"></i></span> <div class="info-box-content"> <span class="info-box-text">Rate</span> <span class="info-box-number" id="rate_compliance">0</span> </div> <!-- /.info-box-content --> </div> <!-- /.info-box --> </div> <!-- /.col --> </div> <!-- SHORT SUMMARY AND ACTION --> <div class="row"> <div class="col-sm-12"> <!-- <div class="card card-primary"> <div class="card-header"> <h3 class="card-title">Fields Percentage</h3> <div class="card-tools"> <button type="button" class="btn btn-tool" data-card-widget="collapse"> <i class="fas fa-minus"></i> </button> </div> </div> <div class="card-body p-0"> --> <table id="compliance-table" class="table table-sm" data-toggle="table" data-url="" data-pagination="false" data-search="false" data-show-refresh="true" data-show-toggle="false" data-show-columns="false" data-show-columns-toggle-all="false" data-show-export="false" data-export-options='{"fileName": "Executive Report"}' data-export-types="['xlsx','excel','csv', 'doc', 'png']" data-buttons="buttonsFunction" data-side-pagination="client" data-page-list="[10, All]" data-minimum-count-columns="2" data-show-pagination-switch="false" data-query-params="queryParams" data-click-to-select="true"> <thead> <tr> <th data-formatter="checkIfEmpty" data-sortable="true" data-field="information"> Information</th> <!-- <th data-formatter="checkIfEmpty" data-sortable="true" data-field="submitted">Submitted</th> --> <th data-formatter="formatCompleteIncomplete" data-sortable="true" data-field="complete"> Complete</th> <th data-formatter="formatCompleteIncomplete" data-sortable="true" data-field="incomplete"> Incomplete</th> <th data-formatter="checkIfEmpty" data-sortable="true" data-field="score">Score (%)</th> </tr> </thead> </table> <!-- </div> </div> --> </div> <div class="col-sm-6" hidden> <div class="card card-primary"> <div class="card-header"> <h3 class="card-title">YTD Percentage</h3> <div class="card-tools"> <button type="button" class="btn btn-tool" data-card-widget="collapse"> <i class="fas fa-minus"></i> </button> </div> <!-- /.card-tools --> </div> <!-- /.card-header --> <div class="card-body p-0"> adas </div> <!-- /.card-body --> </div> </div> </div> </div> <!--card-body--> </div> <!--card--> </div> </div> <!--col-md--> </div> <!--row--> </div> <!--container-fluid--> </section> <!-- /.content --> </div> <!-- /.content-wrapper --> <!--Modal here--> <!-- 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> <!-- jQuery UI 1.11.4 --> <script src="plugins/jquery-ui/jquery-ui.min.js"></script> <!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip --> <script> $.widget.bridge('uibutton', $.ui.button) </script> <!-- overlayScrollbars --> <script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script> <!-- Bootstrap 4 --> <script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script> <!-- Select2 --> <script src="plugins/select2/js/select2.full.min.js"></script> <!-- Bootstrap4 Duallistbox --> <!-- <script src="plugins/bootstrap4-duallistbox/jquery.bootstrap-duallistbox.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> <!-- bootstrap color picker --> <!-- <script src="plugins/bootstrap-colorpicker/js/bootstrap-colorpicker.min.js"></script> --> <!-- Tempusdominus Bootstrap 4 --> <script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script> <!-- Bootstrap Switch --> <!-- <script src="plugins/bootstrap-switch/js/bootstrap-switch.min.js"></script> --> <!-- BS-Stepper --> <!-- <script src="plugins/bs-stepper/js/bs-stepper.min.js"></script> --> <!-- dropzonejs --> <script src="plugins/dropzone/min/dropzone.min.js"></script> <!-- bs-custom-file-input --> <!-- <script src="plugins/bs-custom-file-input/bs-custom-file-input.min.js"></script> --> <!-- AdminLTE App --> <script src="dist/js/adminlte.min.js"></script> <!-- jquery-validation --> <!-- <script src="plugins/jquery-validation/jquery.validate.min.js"></script> <script src="plugins/jquery-validation/additional-methods.min.js"></script> --> <!-- Navigation Highlight --> <script src="dist/js/main.js"></script> <!-- Page specific script --> <!-- jQuery Cookie--> <script src="plugins/jquery-cookie/jquery.cookie.js"></script> <!-- Ekko Lightbox --> <script src="plugins/ekko-lightbox/ekko-lightbox.min.js"></script> <!-- Toastr --> <script src="plugins/toastr/toastr.min.js"></script> <!-- SweetAlert2 --> <script src="plugins/sweetalert2/sweetalert2.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> <script> var count_vehicle_summary = null; var sc_id = '<?php echo $sc_id; ?>'; function resetDateRangePicker(start, end) { // daterangepicker_filter = false; $("#filter-date").data('daterangepicker').setStartDate(start); $("#filter-date").data('daterangepicker').setEndDate(end); // $('#filter-date').data('daterangepicker').chosenLabel = 'Disable'; $('#filter-date').data('daterangepicker').hideCalendars(); $('.daterangepicker').css('width', 'auto'); var startDate = start.format('MMMM DD, YYYY'); var endDate = end.format('MMMM DD, YYYY'); $('#filter-date span').html(startDate + ' - ' + endDate); cb(start, end); } function addListenerCompanyFilter() { $('#company-filter').off('change.mychange').on('change.mychange', function() { var start = $('#filter-date').data('daterangepicker').startDate; var end = $('#filter-date').data('daterangepicker').endDate; cb(start, end); }); } function passDate(startDate, endDate) { var company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val(); filtered_company = (parseInt(company) === 0) ? '' : '&selected_company=' + company; filtered_date_start = (startDate === '') ? '' : '&start_date=' + startDate; filtered_date_end = (endDate === '') ? '' : '&end_date=' + endDate; refreshTable(); // getTotalCustomerCount(startDate, endDate, company); // getTotalVehicleCount(startDate, endDate, company); // getTotalServiceCount(startDate, endDate, company); // getTotalSalesCount(startDate, endDate, company); // showGraph(startDate, endDate, company); // showGraphCompany(startDate, endDate, company); // showDonut(startDate, endDate, company); // showPie(startDate, endDate, company); } 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() { $('#compliance-table').tableExport({ // onCellHtmlData: DoOnCellHtmlData, // ignoreColumn: [9,10], fileName: 'Executive Report', type: 'xlsx' }); } function exportPdf() { // $('#compliance-table').tableExport({ // fileName: export_filename, // type: 'pdf', // jspdf: { // orientation: 'p', // margins: { // left: 20, // top: 10 // }, // autotable: { // styles: { // overflow: 'linebreak' // }, // tableWidth: 'wrap' // }, // } // }); $('#compliance-table').tableExport({ // ignoreColumn: [9,10], fileName: 'Executive Report', 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) { // console.log(data) } function DoBeforeAutotable(table, headers, rows, AutotableSettings) {} function cb(start, end) { var startDate = start.format('YYYY-MM-DD'); passDate(start, end); //pass empty dates } function initList() { var $table = $('#compliance-table'); // $table.bootstrapTable('destroy') $('#compliance-table').bootstrapTable({ sidePagination: 'server', formatSearch: function() { return 'Search' }, }); } function initToolTip() { var bootstrapTooltip = $.fn.tooltip.noConflict(); $.fn.bstooltip = bootstrapTooltip; $('.tooltip-me').bstooltip(); } function refreshTable() { initList(); var $vehicle_table = $('#compliance-table') // $vehicle_table.bootstrapTable('destroy') $(function() { $vehicle_table.bootstrapTable('refresh', { url: 'api/compliance/compliance.php' }); }) complianceCountSummary(); } function complianceCountSummary() { var start = $('#filter-date').data('daterangepicker').startDate; var end = $('#filter-date').data('daterangepicker').endDate; var company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val(); var start_date = start.format('YYYY-MM-DD'); var end_date = end.format('YYYY-MM-DD'); $('#date_cover').text(start.format('MM/DD/YYYY') + ' - ' + end.format('MM/DD/YYYY')); $('#company_cover').text(company == '0' ? 'All' : $("#company-filter option:selected").text()); // alert('ds') if (count_vehicle_summary != null) { count_vehicle_summary.abort(); } count_vehicle_summary = $.ajax({ url: "api/compliance/compliance.php", type: "GET", dataType: 'json', data: { apiKey: '9917866898468776', sc_id: sc_id, company: company, start_date: start_date, end_date: end_date }, beforeSend: function() {}, success: function(result) { // result.total $('#total_compliance').text(result.total_compliance); $('#complete_compliance').text(result.complete_compliance); $('#incomplete_compliance').text(result.incomplete_compliance); $('#rate_compliance').text(result.rate_compliance); } }); } function checkIfEmpty(value, row, index) { if (isEmpty(value)) { return "<span style='color:red;'> (Not Provided) </span>"; } return value; } function formatCompleteIncomplete(value, row, index) { return "<span style='color:#007bff;'>" + value + "</span>"; } 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 queryParams(params) { var start = $('#filter-date').data('daterangepicker').startDate; var end = $('#filter-date').data('daterangepicker').endDate; var company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val(); var start_date = start.format('YYYY-MM-DD'); var end_date = end.format('YYYY-MM-DD'); $.cookie("compliance_start_date", start_date); $.cookie("compliance_end_date", end_date); return { // search: params.search, // offset: params.offset, // limit: params.limit, // dms: dms, company: company, start_date: start_date, end_date: end_date, sc_id: sc_id, apiKey: '2679462138438190' // vehicle_actions: vehicle_actions, // my_records : my_records //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 getCookie(name) { var match = document.cookie.match(RegExp('(?:^\|;\\s)' + name + '=([^;]*)')); return match ? match[1] : null; } function setDateRangePickerWidth(isMobile) { if ($(".daterangepicker").hasClass('show-calendar') && !isMobile) { $('.daterangepicker').css('width', '630px'); } else { $('.daterangepicker').css('width', 'auto'); } } </script> <script> $(function() { initToolTip(); var start = null; var end = null; if ( (getCookie("compliance_start_date") == null \|\| $.cookie("compliance_start_date") == '') \|\| (getCookie("compliance_end_date") == null \|\| $.cookie("compliance_end_date") == '') ) { // alert("no") start = moment().startOf('month'); end = moment().endOf('month'); } else { start = moment($.cookie("compliance_start_date")); end = moment($.cookie("compliance_end_date")); // alert(start) // alert(start) } // alert(start); // $('input[name="daterange"]').daterangepicker({ // opens: 'left' // }, function(start, end, label) { // console.log("A new date selection was made: " + start.format('YYYY-MM-DD') + ' to ' + end // .format('YYYY-MM-DD')); // }); $('#filter-date').daterangepicker({ autoUpdateInput: false, showDropdowns: true, parentEl: '#dropdown-filter', locale: { cancelLabel: 'Cancel' }, startDate: start, opens: "left", endDate: end, ranges: { 'Today': [moment(), moment()], 'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')], 'Last 7 Days': [moment().subtract(6, 'days'), moment()], 'Last 30 Days': [moment().subtract(29, 'days'), moment()], 'This Month': [moment().startOf('month'), moment().endOf('month')], 'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')], 'This Year': [moment().startOf('year'), moment().endOf('year')], 'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')] } }); // var start = $('#filter-date').data('daterangepicker').startDate; resetDateRangePicker(start, end); let isMobile = window.matchMedia("only screen and (max-width: 760px)").matches; $(".daterangepicker").click(function() { setDateRangePickerWidth(isMobile); }); $("#filter-date").click(function() { setDateRangePickerWidth(isMobile); }); $('#company-filter').select2({ placeholder: "Company", allowClear: true }) addListenerCompanyFilter(); $('#filter-date').on('apply.daterangepicker', function(ev, picker) { $('#filter-date span').html(picker.startDate.format('MMMM D, YYYY') + ' - ' + picker.endDate .format( 'MMMM D, YYYY')); cb(picker.startDate, picker.endDate); }); $('#filter-date').on('cancel.daterangepicker', function(ev, picker) { $('#filter-date').data('daterangepicker').hideCalendars(); }); $('#btnCustomerListNoFilter').click(function() { $('#company-filter').off('change.mychange'); //off the company filter built in change event $('#company-filter').val('').trigger('change') //triggr change addListenerCompanyFilter(); //enable afain the company filter even t var start = moment().startOf('month'); var end = moment().endOf('month'); resetDateRangePicker(start, end); }) // //for click bnalloon not hiding -> filter document.getElementById("dropdown-filter").addEventListener('click', function(event) { event.stopPropagation(); }); if (!isEmpty(sc_id)) { // getASANameByASAID('sales-person-name'); } }); // refreshTable(); $('#compliance-table').on('click-cell.bs.table', function(field, value, row, $el) { var status = ''; if (value == 'complete') { status = 1; } else if (value == 'incomplete') { status = 0; } // if(isEmpty(sc_id)){ var start = $('#filter-date').data('daterangepicker').startDate; var end = $('#filter-date').data('daterangepicker').endDate; var company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val(); var start_date = start.format('YYYY-MM-DD'); var end_date = end.format('YYYY-MM-DD'); var url = "<?php echo $variable['site_link'] ?>compliance_clients.php?q=" + sc_id + "&type=" + $el.information_code + "&start=" + start_date + "&end=" + end_date + "&company=" + company + "&status=" + status; window.location.href = url; // }else{ // var url = "<?php echo $variable['site_link'] ?>compliance_clients.php?q=" + sc_id + "&type=" + // $el.information_code + "&status=" + status; // window.location.href = url; // } // vehicleInfo($el.id,$el.c ustomer_record_id); // vehicle_id = $el.id; // customer_id = $el.customer_id; // customer_record_id = $el.customer_record_id; }); </script> </body> </html>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings