File manager

File manager - Edit - /home/autoph/public_html/connectv1/sales_consultant_compliance.bak.php

Back
<?php include_once('cfg/db.php'); include_once("api/controllers/utility.php"); if(!isset($_SESSION['user']['id'])){ header('location:signin.php'); } if(!isset($_REQUEST['q'])){ header('location:sales_person.php'); } $asa_id = $db->escape($_REQUEST['q']); $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']; ?> \| 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"> <!-- 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) --> <section class="content-header"> <div class="container-fluid"> <div class="row mb-0"> <div class="col-sm-6"> <!-- <h1>Compliance</h1> --> </div> <div class="col-sm-6"> <ol class="breadcrumb float-sm-right"> <li class="breadcrumb-item"><a href="home.php">Home</a></li> <!-- <li class="breadcrumb-item active"></li> --> <li class="breadcrumb-item active">Compliance <span class="sales-person-name" ></span></li> </ol> </div> </div> </div><!-- /.container-fluid --> </section> <!-- Main content --> <section class="content"> <div class="container-fluid"> <div class="row"> <div class="col-md"> <div id="vehicle_table_list" class="card card-primary" style="display: "> <div class="card-header"> <!-- <h3 class="card-title">Compliance</h3> --> <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> Compliance <span class="sales-person-name" ></span></h3> </div> <div class="card"> <div class="card-body"> <!-- SHORT SUMMARY AND ACTION --> <div class="row mb-2"> <div class="col-6"> <!-- <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"> <button type="button" class="btn btn-default dropdown-toggle btn-sm" data-toggle="dropdown" aria-haspopup="true" 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="No Filter" 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> <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: pointer;"> <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: pointer;"> <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: pointer;"> <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: pointer;"> <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="true" 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_code"> Information</th> --> <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="checkIfEmpty" data-sortable="true" data-field="complete"> Complete</th> <th data-formatter="checkIfEmpty" 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="plugins/bootstrap-table/js/tableExport.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 asa_id = '<?php echo $asa_id; ?>'; function resetDateRangePicker() { // daterangepicker_filter = false; var start = moment().startOf('month'); var end = moment().endOf('month'); $("#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 cb(start, end) { passDate(start, end); //pass empty dates } function initList() { var $table = $('#vehicle-table'); // $table.bootstrapTable('destroy') $('#vehicle-table').bootstrapTable({ sidePagination: 'server', formatSearch: function() { return 'Search Vehicle' }, }); } 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'); // 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', asa_id: asa_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) { // alert(value) //if((value != null && value.trim() == "") \|\| value == "-"){ if (value == null \|\| (value.trim() == "" \|\| value == "-")) { return "<span style='color:red;'> (Not Provided) </span>"; } return value; } function back() { window.history.back(); } function getASANameByASAID(objectId,asa_id) { $.ajax({ url: 'https://www.autohub.ph/connect/LOAD_SALES_PERSON.php', type: "POST", dataType: 'json', data: { uid: asa_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, asa_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'); return { // search: params.search, // offset: params.offset, // limit: params.limit, // dms: dms, company: company, start_date: start_date, end_date: end_date, asa_id: asa_id, apiKey: '2679462138438190' // vehicle_actions: vehicle_actions, // my_records : my_records //other filters hehe }; } </script> <script> $(function() { var start = moment().startOf('month'); var end = moment().endOf('month'); $('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: { // 'Disable': [moment().add(1, 'days'), moment().add(1, 'days')], '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')] } }); var start = $('#filter-date').data('daterangepicker').startDate; resetDateRangePicker(); let isMobile = window.matchMedia("only screen and (max-width: 760px)").matches; $(".daterangepicker").click(function() { if ($(".daterangepicker").hasClass('show-calendar') && !isMobile) { $('.daterangepicker').css('width', '630px'); } else { $('.daterangepicker').css('width', 'auto'); } }); $('#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 resetDateRangePicker(); }) // //for click bnalloon not hiding -> filter document.getElementById("dropdown-filter").addEventListener('click', function(event) { event.stopPropagation(); }); getASANameByASAID('sales-person-name','<?php echo $asa_id; ?>'); }); // refreshTable(); $('#compliance-table').on('click-cell.bs.table', function(field, value, row, $el) { var url = "<?php echo $variable['site_link']?>sales_consultant_clients.php?q="+asa_id+"&type="+$el.information_code; window.location.href = url; }); </script> </body> </html>

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