File manager

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

Back
<?php include('cfg/db.php'); include_once("api/controllers/utility.php"); if (!isset($_SESSION['user'])) { header('location:signin.php'); } if (!(isset($global_action_permissions['7']['34']) && in_array("1", $global_action_permissions['7']['34']))) { header('location:signin.php'); } $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1'; ?> <!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']; ?> \| Sales Consultant Compliance</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"> <!-- daterange picker --> <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.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%; } td.yes { background-color: #c3e6cb; } td.no { background-color: #f5c6cb; } </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: <?php if (isset($_GET['order_number'])) { echo 'none'; } else { echo 'block'; } ?> ;"> <div class="card-header"> <h3 class="card-title">Sales Consultant Compliance</h3> </div> <!-- INSERT TABLE HERE --> <div class="card"> <div class="card-body pt-3"> <!-- <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 class="row mb-2"> <div class="col-6"> <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> </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--> <!-- text input --> <div class="form-group mb-0" style="display:;"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <select name="commission-filter" id="commission-filter" class="form-control form-control-sm select2" style="width: 100%;"> <option></option> <?php $commission = $db->return_result("SELECT id,name FROM `source_commission_status` WHERE id <> 3 ORDER BY FIELD(id,0,1,2)"); foreach ($commission as $data) { echo "<option value='{$data['id']}' >" . "WITH " . $data['name'] . "</option>"; } ?> </select> </div> <!--form-group dropdown--> </div> <!--form-group--> </div> </div> </div> </div> <hr class="mt-1"> <div> <!-- NESTED TABLE START --> <!-- NESTED TABLE END --> <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-show-export="false" data-side-pagination="server" data-page-size="15" data-buttons="buttonsFunction" data-export-options='{"fileName": "SC Compliance Records"}' data-export-types="['xlsx','excel','csv', 'doc', 'png']" data-page-list="[15, 30, 50, 100, 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-field="employee_id"> Employee ID</th> --> <th data-formatter="checkIfEmpty" data-cell-style="cellStyle" data-sortable="true" data-field="name"> Name </th> <th data-formatter="completeFormat" data-cell-style="cellStyle" data-sortable="true" data-field="complete"> Complete </th> <th data-formatter="incompleteFormat" data-cell-style="cellStyle" data-sortable="true" data-field="incomplete"> Incomplete </th> <th data-formatter="checkIfEmpty" data-cell-style="cellStyle" data-sortable="true" data-field="total"> Total </th> <th data-formatter="checkIfEmpty" data-cell-style="cellStyle" data-sortable="true" data-field="rate"> Rate </th> <!-- <th data-formatter="checkIfEmpty" data-field="email">Email </th> <th data-formatter="checkIfEmpty" data-field="usr_mobile"> Mobile </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> <!-- html2canvas --> <!-- <script src="dist/js/html2canvas.js"></script> <script src="node_modules/html2canvas/dist/html2canvas.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> <!-- AdminLTE for demo purposes --> <script src="dist/js/demo.js"></script> <!-- Navigation Highlight --> <script src="dist/js/main.js"></script> <!-- Page specific script --> <script> 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: 'SC Compliance Records', 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' // }, // } // }); $('#sales-table').tableExport({ // ignoreColumn: [9,10], fileName: 'SC Compliance Records', type: 'pdf', jspdf: { orientation: 'p', margins: { left: 10, right: 10, top: 50, bottom: 20 }, autotable: { startY: false, startX: 10, showHeader: 'firstPage', margin: { top: 10 }, bodyStyles: { valign: "top" }, theme: "striped", beforePageContent: function(data) { //console.log(data.settings.tableExport.doc);return; var doc = data.settings.tableExport.doc; // Internal jspdf instance console.log(doc.getFontList()); doc.setFontSize(12); doc.text('SC Compliance Records', data.settings.margin.top - 40, 20); 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('MMMM DD, YYYY'); var end_date = end.format('MMMM DD, YYYY'); doc.setFont('helvetica', 'normal'); doc.setFontSize(10); doc.text('Date Range: ' + start_date + ' - ' + end_date, data.settings.margin.top - 40, 32); doc.text('Company: ' + (company == '0' ? 'All' : $("#company-filter option:selected").text()), data.settings.margin.top - 40, 43); // var str = "Page " + doc.internal.getNumberOfPages() +' - '+ export_filename; // doc.setFont('Times','normal'); // doc.setFontSize(10); // // jsPDF 1.4+ uses getWidth, <1.4 uses .width // var pageSize = doc.internal.pageSize; // var pageHeight = pageSize.height // ? pageSize.height // : pageSize.getHeight(); // doc.text(str, data.settings.margin.left, pageHeight - 10); }, styles: { overflow: 'linebreak', fontSize: 10, overflowColumns: 'linebreak' } } } }); // $('#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 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); }); $('#commission-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(); } function cb(start, end) { var startDate = start.format('YYYY-MM-DD'); passDate(start, end); //pass empty dates } function initList() { var $table = $('#sales-table'); // $table.bootstrapTable('destroy') $('#sales-table').bootstrapTable({ sidePagination: 'server', formatSearch: function() { return 'Search' }, }); } function refreshTable() { initList(); var $sales_table = $('#sales-table') $(function() { $sales_table.bootstrapTable('refresh', { url: 'api/compliance/compliance.php' }); }) } 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'); var commission = ($("#commission-filter").val() == '') ? '' : $("#commission-filter").val(); $('#date_cover').text(start.format('MM/DD/YYYY') + ' - ' + end.format('MM/DD/YYYY')); $('#company_cover').text(company == '0' ? 'All' : $("#company-filter option:selected").text()); $.cookie("sc_compliance_start_date", start_date); $.cookie("sc_compliance_end_date", end_date); return { company: company, start_date: start_date, end_date: end_date, commission_status: commission, search: params.search, offset: params.offset, limit: params.limit, order: params.order, sort: params.sort, apiKey: '4683843345322827' }; } 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'); } } function checkIfEmpty(value, row, index) { if (value == "" \|\| value == '-' \|\| value == null) { return "<span style='color:red;'> (Not Provided) </span>"; } return "<span class='tooltip-me' data-original-title='View all records' title='View all records'><strong>" + value + "</strong></span>"; } function completeFormat(value, row, index) { if (value == "" \|\| value == '-' \|\| value == null) { return "<span style='color:red;'> (Not Provided) </span>"; } return "<span style='color:#007bff;' class='tooltip-me' data-original-title='View complete records' title='View complete records'><strong>" + value + "</strong></span>"; } function incompleteFormat(value, row, index) { if (value == "" \|\| value == '-' \|\| value == null) { return "<span style='color:red;'> (Not Provided) </span>"; } return "<span style='color:#007bff;' class='tooltip-me' data-original-title='View incomplete records' title='View complete records'><strong>" + value + "</strong></span>"; } //////////////////////////////////////////////////////////////// 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 initToolTip() { var bootstrapTooltip = $.fn.tooltip.noConflict(); $.fn.bstooltip = bootstrapTooltip; $('.tooltip-me').bstooltip(); } 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 cellStyle(value, row, index, $el) { // console.log(row) return { classes: parseInt(row.hold_count) === 0 ? 'yes' : 'no' }; } </script> <!-- CLARENCE ROCKS --> <script> $(document).ready(function() { initToolTip(); var start = null; var end = null; if ( (getCookie("sc_compliance_start_date") == null \|\| $.cookie("sc_compliance_start_date") == '') \|\| (getCookie("sc_compliance_end_date") == null \|\| $.cookie("sc_compliance_end_date") == '') ) { // alert("no") start = moment().startOf('month'); end = moment().endOf('month'); } else { start = moment($.cookie("sc_compliance_start_date")); end = moment($.cookie("sc_compliance_end_date")); // alert(start) // alert(start) } $('#commission-filter').select2({ placeholder: "Commission Status", allowClear: true }) $('#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')] } }); 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 $('#commission-filter').off( 'change.mychange'); //off the company filter built in change event $('#commission-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(); }); $('#sales-table').on('click-cell.bs.table', function(field, value, row, $el) { if (value != "status") { // var url = "<?php echo $variable['site_link'] ?>sales_consultant_clients.php?q="+$el.u_id; // $.cookie("sc_compliance_start_date",''); // $.cookie("sc_compliance_end_date",''); var company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val(); var start = $('#filter-date').data('daterangepicker').startDate; var end = $('#filter-date').data('daterangepicker').endDate; var start_date = start.format('YYYY-MM-DD'); var end_date = end.format('YYYY-MM-DD'); if (value == 'complete') { status = 1; } else if (value == 'incomplete') { status = 0; } var url = "<?php echo $variable['site_link'] ?>sc_compliance_clients.php?q=" + $el.datacon_sc_id + "&start=" + start_date + "&end=" + end_date + "&company=" + company + "&status=" + status; window.location.href = url; } }); }); </script> </body> </html>

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