File manager

File manager - Edit - /home/autoph/public_html/connectv1/futurevehicle.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['5']['41']) && in_array("1", $global_action_permissions['5']['41']))){ header('location:signin.php'); } if(!(isset($global_action_permissions['5']['41']) && in_array("2", $global_action_permissions['5']['41']))){ $generate_report = 0; }else{ $generate_report = 1; } if(!(isset($global_action_permissions['5']['41']) && in_array("3", $global_action_permissions['5']['41']))){ $show_hide_contact = 0; }else{ $show_hide_contact = 1; } if(!(isset($global_action_permissions['5']['41']) && in_array("4", $global_action_permissions['5']['41']))){ $all_group_access = 0; }else{ $all_group_access = 1; } if(!(isset($global_action_permissions['5']['41']) && in_array("5", $global_action_permissions['5']['41']))){ $all_tag_access = 0; }else{ $all_tag_access = 1; } $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; // print_r($_SESSION['user']);exit; $my_company_id = $utility->isNotEmpty($_SESSION['user']['company']) ? $_SESSION['user']['company'] : '-1' ; $my_company_group_id = $db->select("SELECT scg.id FROM source_company_group scg INNER JOIN source_company_group_list scgl ON scg.id = scgl.company_group_id WHERE scgl.company_id = $my_company_id AND scgl.status = 1 AND scg.status = 1"); $my_company_group_id = $utility->isNotEmpty($my_company_group_id) ? $my_company_group_id : '-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>Future Vehicle</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"> <!-- Bootstrrap Toggle --> <link rel="stylesheet" href="node_modules/bootstrap4-toggle/css/bootstrap4-toggle.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; } / .select2-selection--single { height: 100% !important; padding-bottom: 0.2em !important; } .accounting-select .select2-selection__rendered { word-wrap: break-word !important; text-overflow: inherit !important; white-space: normal !important; line-height: 1.2em !important; padding-right: 0.1em !important; text-align: center; } .accounting-select-dd .select2-results__option { padding: 0.3em !important; user-select: none !important; overflow: hidden !important; -webkit-user-select: none !important; margin: 0px !important; } / / .accounting-select .select2-selection__arrow b { / / display: none !important; / / margin: -3px !important; / / } / </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"> <h3 class="card-title">Future Vehicle Report</h3> </div> <div class="card"> <div class="card-body"> <!-- SHORT SUMMARY AND ACTION --> <div class="row mb-2"> <div class="col-6"> <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> <div class="p-0 m-0"> <label class="p-0 m-0"> Brand: </label>  <span id="brand_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> <div class="col-6 text-right"> <div class="btn-group"> <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="No Filter" style="width: 100%;"></input> </div> <!--form-group dropdown--> </div> <!--form-group--> <div class="form-group mb-0" style="display:;"> <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" style="display:;"> <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 class="form-group mb-0 group-filter" style="display:none;"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <select name="group-filter" id="group-filter" class="form-control form-control-sm select2" style="width: 100%;"> <option></option> <?php $groups = $db -> return_result("SELECT FROM `source_company_group` WHERE 1 AND status = 1 ORDER BY id ASC"); foreach($groups as $data){ if($data['id'] == $my_company_group_id){ echo "<option value='{$data['id']}' selected>".$data['name']."</option>"; }else{ echo "<option value='{$data['id']}' >".$data['name']."</option>"; } } ?> </select> </div> <!--form-group dropdown--> </div> <div class="form-group mb-0" style="display:;"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <select name="brand-filter" id="brand-filter" class="form-control form-control-sm select2" style="width: 100%;"> <option></option> <?php $company = $db -> return_result("SELECT id,name FROM `source_brand` WHERE 1 AND status = 1 ORDER BY name ASC"); foreach($company as $data){ echo "<option value='{$data['id']}' >".$data['name']."</option>"; } ?> </select> </div> <!--form-group dropdown--> </div> <!--form-group--> <div class="form-group mb-0" style="display:;"> <div class="form-group dropdown-input mr-2 ml-2 mb-1"> <select name="status-filter" id="status-filter" class="form-control form-control-sm select2" style="width: 100%;"> <option></option> <option value="1">Attended</option> <option value="2">Unattended</option> </select> </div> <!--form-group dropdown--> </div> <!--form-group--> </div> </div> </div> </div> <hr> <!-- SHORT SUMMARY AND ACTION --> <div class="row"> <div class="table-responsive col-sm-12"> <table id="compliance-table" data-search="true" data-show-refresh="true" data-custom-search="customSearch" data-buttons="buttonsFunction" data-page-size="20" data-page-list="[20, 35, 50, 100, all]" data-url="" class="table table-bordered table-hover table-sm" data-export-types="['xlsx','excel','csv', 'doc', 'png']" data-show-export="false" data-query-params="queryParams" data-pagination="true"> <thead> <tr> <th data-formatter="checkIfEmpty" data-field="future_vehicle_no"> No.</th> <th data-formatter="checkIfEmpty" data-field="release_date"> Released &<br>Date</th> <th data-formatter="checkIfEmpty" data-field="company_dealer"> Company &<br>Dealer </th> <!-- <th data-formatter="checkIfEmpty" data-field="company"> Company </th> <th data-formatter="checkIfEmpty" data-field="dealer">Dealer </th> --> <th data-formatter="checkIfEmpty" data-field="customer_name"> Customer </th> <th data-formatter="customerMobileFormatter" data-field="mobile_phone_1"> Customer<br>Mobile </th> <th data-formatter="customerEmailFormatter" data-field="email_1"> Customer<br>Email </th> <th data-formatter="checkIfEmpty" data-field="brand_model"> Released<br>Vehicle </th> <th data-formatter="checkIfEmpty" data-field="brand_offered_brand">Future<br>Vehicle </th> <th data-formatter="SCFormat" class="" data-field="sc_info">Sales<br>Consultant </th> <th class="text-center" data-formatter="assignedSCFormat" data-events="" data-field="assigned_sc"> Assigned SC </th> </tr> </thead> </table> </div> </div> </div> <!--card-body--> </div> <!--card--> </div> </div> <!--col-md--> </div> <!--row--> </div> <!--container-fluid--> </section> <!-- /.content --> </div> <!-- /.content-wrapper --> <!--Modal here--> <div class="modal fade" id="modal-overlay"> <div class="modal-dialog"> <div class="modal-content"> <!-- <div class="overlay"> <i class="fas fa-2x fa-sync fa-spin"></i> </div> --> <div class="modal-header py-1"> <h5 class="modal-title">SC Information</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <div class="pl-3"> <div class="form-group row mb-0 "> <label for="" style="width: 50px;" class="pb-0 pt-1 col-form-label font-weight-bold">Name:</label> <div class="col"> <label class=" pb-0 pt-1 col-form-label font-weight-normal" ticket-info-data="" placeholder="" id="lbl_sc_name"></label> </div> </div> <div class="form-group row mb-0 person-field"> <label for="" style="width: 50px;" class="pb-0 pt-1 col-form-label font-weight-bold">Email:</label> <div class="col"> <label class=" pb-0 pt-1 col-form-label font-weight-normal" ticket-info-data="" placeholder="" id="lbl_sc_email"></label> </div> </div> <div class="form-group row mb-0 type_vehicle_reply_modal" style=""> <label for="" style="width: 50px;" class="pb-0 pt-1 col-form-label font-weight-bold">Mobile:</label> <div class="col"> <label class=" pb-0 pt-1 col-form-label font-weight-normal" ticket-info-data="" placeholder="" id="lbl_sc_mobile"></label> </div> </div> </div> </div> <div class="modal-footer p-1"> <button type="button" class="btn btn-sm btn-secondary" data-dismiss="modal">Close</button> <!-- <button type="button" class="btn btn-sm btn-primary" id="btn_ticket_info_save">Save</button> --> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> </div> <!-- /.modal --> <!-- 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 --> <!-- 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 --> <!-- html2canvas --> <!-- <script src="dist/js/html2canvas.js"></script> <script src="node_modules/html2canvas/dist/html2canvas.js"></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> <!-- Bootstrap Toggle --> <script src="node_modules/bootstrap4-toggle/js/bootstrap4-toggle.min.js"></script> <!-- SweetAlert2 --> <script src="plugins/sweetalert2/sweetalert2.min.js"></script> <!-- <script src="dist/js/jspdf.min.js"></script> --> <!-- <script src="plugins/bootstrap-table/js/tableExport.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/pdfmake/pdfmake.min.js"></script> <script src="dist/js/tableExport/libs/pdfmake/vfs_fonts.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 src="dist/js/jquery.balloon.min.js"></script> <!-- <script src="dist/js/bootstrap-table.min.js"></script> --> <script> var export_filename = 'Future Vehicle'; var selected_sc_asa_id = 0; var generate_report = <?php echo $generate_report; ?>; var show_hide_contact = <?php echo $show_hide_contact; ?>; var all_group_access = <?php echo $all_group_access; ?>; var all_tag_access = <?php echo $all_tag_access; ?>; var my_company_id = <?php echo $my_company_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() { $('#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); }); $('#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); }); $('#brand-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); }); $('#status-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); }); $('#group-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) { refreshTable(); } function cb(start, end) { var startDate = start.format('YYYY-MM-DD'); passDate(start, end); //pass empty dates } function buttonsFunction() { if(!generate_report){ return false; } 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 initList() { var $table = $('#compliance-table'); // $table.bootstrapTable('destroy') $('#compliance-table').bootstrapTable('destroy').bootstrapTable({ sidePagination: 'server', formatSearch: function() { return 'Search...' }, onLoadSuccess: function() { $("select[data-bootstrap-select]").each(function() { var $select2 = $(this).select2({ minimumResultsForSearch: -1, // containerCssClass: "accounting-select", // dropdownCssClass: "accounting-select-dd" }) }) $("select[data-assigned-sc]").each(function() { $(this).select2({ // tags: true, placeholder: "Unattended", allowClear: true, escapeMarkup: function(markup) { return markup; }, ajax: { url: 'https://www.autohub.ph/connect/LOAD_SALES_PERSON.php', dataType: 'json', delay: 250, data: function(data) { return { apiKey: '7594712920757225', search: data.term // search term }; }, processResults: function(response) { return { results: response }; }, cache: true } }); }) if(show_hide_contact){ $("[customer-mobile]").each(function(){ var status = false; var sales_id = $(this).attr("customer-mobile"); var from_db = $(this).attr("from-db"); var future_action_status = isEmpty(from_db) ? 'Show' : 'Hide' ; var assigned_sc = $(this).attr("assigned-sc"); $(this).on("click", function() { status ? $(this).hideBalloon() : $(this).showBalloon(); }).showBalloon({ position: 'right', html: true, css: { color: 'black', opacity: '100' }, contents: ` <div class="row"> <div class="col-sm-6 p-1"> <input type="button" onclick = "toggleContact('`+sales_id+`','`+assigned_sc+`')" class="btn btn-primary btn-sm" value="`+future_action_status+` Mobile & Email"></input> </div> </div> ` }); $(this).hideBalloon(); var $elBtn = $(this); $(document).mouseup(function(e) { var container = $elBtn; // if the target of the click isn't the container nor a descendant of the container if (!container.is(e.target) && container.has(e.target).length === 0) { container.hideBalloon(); status = false; } }); }) $("[customer-email]").each(function(){ var status = false; var sales_id = $(this).attr("customer-email"); var from_db = $(this).attr("from-db"); var future_action_status = isEmpty(from_db) ? 'Show' : 'Hide' ; var assigned_sc = $(this).attr("assigned-sc"); $(this).on("click", function() { status ? $(this).hideBalloon() : $(this).showBalloon(); }).showBalloon({ position: 'right', html: true, css: { color: 'black', opacity: '100' }, contents: ` <div class="row"> <div class="col-sm-6 p-1"> <input type="button" onclick = "toggleContact('`+sales_id+`','`+assigned_sc+`')" class="btn btn-primary btn-sm" value="`+future_action_status+` Mobile & Email"></input> </div> </div> ` }); $(this).hideBalloon(); var $elBtn = $(this); $(document).mouseup(function(e) { var container = $elBtn; // if the target of the click isn't the container nor a descendant of the container if (!container.is(e.target) && container.has(e.target).length === 0) { container.hideBalloon(); status = false; } }); }) } selectListener(); selectAssignedSCListener(); }, exportOptions: { fileName: function() { return export_filename } } }); } function toggleContact(sales_id,assigned_sc){ if(isEmpty(assigned_sc)){ toastr.remove(); toastr.error('No sales consultant assigned.' ); return false; } $.ajax({ url: "api/compliance/compliance.php", method: "POST", data: { apiKey: '3625999203434336', sales_id: sales_id, asa_id: assigned_sc }, beforeSend: function() { toastr.remove(); toastr.info('Updating status...'); }, success: function(data) { toastr.remove(); refreshTableSilent(); //tobe change not resetting table } }); } function selectAssignedSCListener() { $("select[data-assigned-sc]").each(function() { clickedId = this.id; var sales_id = clickedId.replace('assigned_sc_', ''); $('#' + clickedId).on('select2:select', function(e) { var data = e.params.data; $.ajax({ url: "api/compliance/compliance.php", method: "POST", data: { apiKey: '3625999201207034', sales_id: sales_id, assigned_sc_id: data.id, assigned_sc_name: data.text }, beforeSend: function() { toastr.remove(); toastr.info('Updating status...'); }, success: function(data) { refreshTableSilent(); //tobe change not resetting table toastr.remove(); toastr.success('Status updated...'); } }); }); $('#' + clickedId).on('select2:unselecting ', function(e) { $.ajax({ url: "api/compliance/compliance.php", method: "POST", data: { apiKey: '3625999201207786', sales_id: sales_id }, beforeSend: function() { toastr.remove(); toastr.info('Updating status...'); }, success: function(data) { refreshTableSilent(); //tobe change not resetting table toastr.remove(); toastr.success('Status updated...'); } }); }); }); } function selectListener() { $("select[data-bootstrap-select]").each(function() { clickedId = this.id; var accounting_status = $('#' + clickedId).attr('data-accounting-status'); var sales_id = clickedId.replace('accounting_', ''); $('#' + clickedId).val(accounting_status).trigger('change'); $('#' + clickedId).on('select2:select', function(e) { var data = e.params.data; // console.log(data); return false; $.ajax({ url: "api/compliance/compliance.php", method: "POST", data: { apiKey: '3625900201207034', sales_id: sales_id, status: data.id }, beforeSend: function() { toastr.remove(); toastr.info('Updating status...'); }, success: function(data) { refreshTableSilent(); //tobe change not resetting table toastr.remove(); toastr.success('Status updated...'); } }); }); }); } function commissionStatusChange(status, sales_id) { Swal.fire({ title: 'Enter your reason', input: 'textarea', confirmButtonText: `Confirm`, showCancelButton: true, }).then(function(result) { if (result.isConfirmed) { if (result.value) { $.ajax({ url: "api/compliance/compliance.php", method: "POST", data: { apiKey: '2357447068264980', sales_id: sales_id, status: status, description: result.value }, beforeSend: function() { toastr.remove(); toastr.info('Updating status...') }, success: function(data) { refreshTableSilent(); //tobe change not resetting table toastr.remove(); toastr.success('Status updated...') } }); } else { Swal.fire({ icon: 'warning', text: 'Enter your reason to change this record status.', showDenyButton: false, showCancelButton: false, confirmButtonText: `OK`, }).then((result) => { if (result.isConfirmed) { commissionStatusChange(); } else if (result.isDenied) {} else {} }) } } }) } function initToolTip() { var bootstrapTooltip = $.fn.tooltip.noConflict(); $.fn.bstooltip = bootstrapTooltip; $('.tooltip-me').bstooltip(); } function statusFormatterAccounting(value, row, index) { return `<select id="accounting_` + row.sales_id + `" class="form-control form-control-sm select2" data-accounting-status="` + row.future_vehicle_status_id + `" data-bootstrap-select style="width: 100%;"> <option value="1">UNATTENDED</option> <option value="2">ATTENDED</option> </select>`; } function assignedSCFormat(value, row, index) { return `<select id="assigned_sc_` + row.sales_id + `" class="form-control form-control-sm select2" data-assigned-sc style="width: 100%;"> <option></option> <option value="` + row.assigned_sc + `" selected>` + row.assigned_sc_name + `</option> </select>`; } function customerMobileFormatter(value,row,index){ if (isEmpty(value)) { return "<span style='color:red;'> (Not Provided) </span>"; } html = "<span class='text-primary font-weight-bold' customer-mobile = '"+row.sales_id+"' from-db= '"+row.future_from_db+"' assigned-sc= '"+row.assigned_sc +"'>"+value+"</span>"; return html; } function customerEmailFormatter(value,row,index){ if (isEmpty(value)) { return "<span style='color:red;'> (Not Provided) </span>"; } html = "<span class='text-primary font-weight-bold' customer-email = '"+row.sales_id+"' from-db= '"+row.future_from_db+"' assigned-sc= '"+row.assigned_sc +"'>"+value+"</span>"; return html; } function refreshTable() { initList(); var $vehicle_table = $('#compliance-table') // $vehicle_table.bootstrapTable('destroy') $(function() { $vehicle_table.bootstrapTable('refresh', { url: 'api/compliance/compliance.php' }); }) } function refreshTableSilent() { var $vehicle_table = $('#compliance-table') $(function() { $vehicle_table.bootstrapTable('refresh', { url: 'api/compliance/compliance.php' }); }) } function checkIfEmpty(value, row, index) { if (isEmpty(value)) { return "<span style='color:red;'> (Not Provided) </span>"; } return value; } function SCFormat(value, row, index) { if (isEmpty(value)) { return "<span style='color:red;'> (Not Provided) </span>"; } // var html = "<span class='text-primary text-sm border-bottom font-weight-bold'>"+value+"</span>"; // return html; // alert(row.asa_sc_id); // var asa_mobile = ''; // $.when(getASANameByASAID(row.asa_sc_id)).done(function(result){ // data = (result['rows'][0]); // // $('#lbl_sc_name').text(data.u_fname+' '+data.u_lname); // // $('#lbl_sc_email').text(data.email); // // $('#lbl_sc_mobile').text(data.usr_mobile); // asa_mobile = data.usr_mobile; // console.log(asa_mobile); // }); // return value;// + ' ('+ asa_mobile + ')'; return "<span class='text-primary font-weight-bold'>"+value+"</span>" } function formatCompleteIncomplete(value, row, index) { return "<span style='color:#007bff;'>" + value + "</span>"; } 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 brand = ($("#brand-filter").val() == '') ? '0' : $("#brand-filter").val(); var attended_filter = ($("#status-filter").val() == '') ? '0' : $("#status-filter").val(); var group = ($("#group-filter").val() == '') ? '0' : $("#group-filter").val(); var commission = ($("#commission-filter").val() == '') ? '' : $("#commission-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()); $('#brand_cover').text(brand == '0' ? 'All' :$("#brand-filter option:selected").text()); return { search: params.search, offset: params.offset, limit: params.limit, company: company, start_date: start_date, end_date: end_date, brand:brand, group:group, all_group_access:all_group_access, all_tag_access:all_tag_access, attended_filter:attended_filter, apiKey: '6137464565377022', secure: 1 }; } 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'); } } 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 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 exportPdf() { $('#compliance-table').tableExport({ onCellHtmlData: DoOnCellHtmlData, // ignoreColumn: [9,10], fileName: export_filename, type: 'pdf', jspdf: { orientation: 'l', margins: { left: 10, right: 10, top: 60, bottom: 20 }, autotable: { startY: false, startX: 10, showHeader: 'firstPage', margin: { top: 10 }, bodyStyles: { valign: "top" }, columnStyles: { 0: {columnWidth: 25}, 2: {columnWidth: 40}, 3: {columnWidth: 35} }, 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.text('Future Vehicle', data.settings.margin.top-50, 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 brand = ($("#brand-filter").val() == '') ? '0' : $("#brand-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-50, 32); doc.text('Company: '+ (company == '0' ? 'All' :$("#company-filter option:selected").text()), data.settings.margin.top-50, 43); doc.text('Brand: '+ (brand == '0' ? 'All' :$("#brand-filter option:selected").text()), data.settings.margin.top-50, 54); 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: 8, overflowColumns: 'linebreak' } } } }); } function exportXlsx() { $('#compliance-table').tableExport({ onCellHtmlData: DoOnCellHtmlData, // ignoreColumn: [9,10], fileName: export_filename, type: 'xlsx' }); } //Processing export content, this method can customize the content of a row, column, or even cell, that is, set its value to what you want. function DoOnCellHtmlData(cell, row, col, data) { // console.log(row) // if ((col == '9' \|\| col == '11') && parseInt(row) > 0) { // var spanObj = $(data); //Convert a string labeled <span title="val"> </span> to a jQuery object // var spanObj2 = $(spanObj[0].innerHTML); // var title = spanObj2.attr( // "title"); //Read the value of title attribute in <span title="val"</span>. // if (typeof(title) != 'undefined') { // return title; // } // } else if ((col == '9') && parseInt(row) > 0) { var obj = $(data); //Convert a string labeled <span title="val"> </span> to a jQuery object var id = obj[0].id; // var title = spanObj2.attr( // "selected"); //Read the value of title attribute in <span title="val"</span>. // return $('#'+spanObj[0].id+ ' option:selected').text(); // return spanObj[1].innerText; // var data = $('#'+id).select2('data'); return $('#'+id+' option:selected').text(); // return data; } else { return data; } } function DoCellData(cell, row, col, data) { // console.log(data) } function getASANameByASAID(asa_id) { return $.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) { } }); } function DoBeforeAutotable(table, headers, rows, AutotableSettings) {} </script> <script> $(function() { if(my_company_id == '-1'){ toastr.remove(); toastr.error('Set your company in profile page...') } if(all_group_access){ $('.group-filter').show(); }else{ $('.group-filter').hide(); } $('#modal-overlay').on('shown.bs.modal', function (e) { $.when(getASANameByASAID(selected_sc_asa_id)).done(function(result){ // console.log(result); var data = (result['rows'][0]); $('#lbl_sc_name').text(data.u_fname+' '+data.u_lname); $('#lbl_sc_email').text(data.email); $('#lbl_sc_mobile').text(data.usr_mobile); }); }) var start = moment().startOf('month'); var end = moment().endOf('month'); $('#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 }) $('#brand-filter').select2({ placeholder: "Future Brand", allowClear: true }) $('#status-filter').select2({ placeholder: "Status", allowClear: true, minimumResultsForSearch: -1 }) $('#group-filter').select2({ placeholder: "Group", allowClear: true, minimumResultsForSearch: -1 }) $('#commission-filter').select2({ placeholder: "Commission Status", 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 $('#brand-filter').off('change.mychange'); //off the company filter built in change event $('#status-filter').off('change.mychange'); //off the company filter built in change event $('#group-filter').off('change.mychange'); //off the company filter built in change event $('#commission-filter').off( 'change.mychange'); //off the company filter built in change event $('#company-filter').val('').trigger('change'); $('#brand-filter').val('').trigger('change'); $('#status-filter').val('').trigger('change'); // $('#group-filter').val('').trigger('change'); $('#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(); }); $('#compliance-table').on('click-cell.bs.table', function(field, value, row, $el) { if(value == 'sc_info'){ selected_sc_asa_id = $el.asa_sc_id; $("[ticket-info-data]").each(function() { $(this).html("<span class='text-sm text-muted font-italic'>Loading...</span>") }); $('#modal-overlay').modal('show'); } }); setTimeout(function() {}, 3000); }); window.statusEvents = { 'click .bootstrap-switch': function(e, value, row, index) { var status = parseInt(value) === 0 ? 1 : 3; var sales_id = row.sales_id; $.ajax({ url: "api/compliance/compliance.php", method: "POST", data: { apiKey: '2357447068264980', sales_id: sales_id, status: status }, success: function(data) { refreshTable(); } }); } }; window.statusEventsReleased = { 'click :checkbox': function(e, value, row, index) { var status = 2; var sales_id = row.sales_id; $.ajax({ url: "api/compliance/compliance.php", method: "POST", data: { apiKey: '2357447068264980', sales_id: sales_id, status: status }, success: function(data) { refreshTable(); } }); } }; </script> </body> </html>

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