File manager - Edit - /home/autoph/public_html/tasks/pdc_report.php.tar
Back
home/autoph/public_html/connectv1/pdc_report.php 0000644 00000053170 15025042325 0016054 0 ustar 00 <?php include('cfg/db.php'); // include('api/controllers/utility.php'); if(!isset($_SESSION['user']['id'])){ header('location:signin.php'); } // $utility_class = new Utility(); $granted_company_ids = $utility_class->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; if(!(isset($global_action_permissions['5']['38']['24']) && in_array("1", $global_action_permissions['5']['38']['24']))){ header('location:signin.php'); } $generate_ins_report = 0; if((isset($global_action_permissions['5']['38']['24']) && in_array("2", $global_action_permissions['5']['38']['24']))){ $generate_ins_report = 1; } $mobile_unmasking = 0; if((isset($global_action_permissions['5']['38']['24']) && in_array("3", $global_action_permissions['5']['38']['24']))){ $mobile_unmasking = 1; } $report_type = "0"; if(isset($_GET['q'])){ $json_params = $db -> base64_url_decode( $db -> escape(trim($_GET['q'])) ); $record_params = json_decode($json_params,true); $params_report_id = $record_params['record_id']; $params_employee_id = $record_params['employee_id']; $params_generate_by_employee_id = $record_params['generate_by_employee_id']; $current_user_employee_id = $_SESSION['user']['id']; // echo "SELECT count(id) FROM report_status WHERE `report_id` = '$report_id' AND `employee_id` = '$current_user_employee_id'"; $q_count = $db -> select("SELECT count(id) FROM report_status WHERE `report_id` = '$params_report_id' AND `employee_id` = '$params_generate_by_employee_id'"); // echo "<script>alert('$params_report_id')</script>"; // echo "SELECT count(id) FROM report_status WHERE `report_id` = '$params_report_id' AND `employee_id` = '$params_generate_by_employee_id'";exit; if($q_count == '0'){ // echo "<script>alert('sada')</script>"; header('location:requested_reports.php'); } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title><?php echo $variable['site_name']; ?> | PDC Report</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"> <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"> <!-- Theme style --> <link rel="stylesheet" href="dist/css/adminlte.min.css"> <!-- overlayScrollbars --> <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css"> <!-- Toastr --> <link rel="stylesheet" href="plugins/toastr/toastr.min.css"> <link href="dist/img/<?php echo $variable['logo']; ?>" rel="icon" /> <style> .color-palette { height: 35px; line-height: 35px; text-align: right; padding-right: .75rem; } .color-palette.disabled { text-align: center; padding-right: 0; display: block; } .color-palette-set { margin-bottom: 15px; } .color-palette span { display: none; font-size: 12px; } .color-palette:hover span { display: block; } .color-palette.disabled span { display: block; text-align: left; padding-left: .75rem; } .color-palette-box h4 { position: absolute; left: 1.25rem; margin-top: .75rem; color: rgba(255, 255, 255, 0.8); font-size: 12px; display: block; z-index: 7; } .form-div { margin-top: 100px; border: 1px solid #e0e0e0; } #profileDisplay { display: block; height: 160px; width: 160px; margin: 0px auto; border-radius: 50%; } .img-placeholder { width: 160px; color: white; height: 160px; background: black; 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; } table { cursor: pointer; } table th { cursor: default; } #customer-report select { -webkit-appearance: none; -moz-appearance: none; text-indent: 1px; text-overflow: ''; } #approver-list { pointer-events: none; } #report-date, #report-status, #control-number, #report-type { border-width: 0px; border: none; /* height:20px; */ } #report-status, #report-type { font-weight: bold; } .required-symbol { display: none; } fieldset { margin-left: 2px; margin-right: 2px; padding-top: 0.35em; padding-left: 0.75em; padding-right: 0.75em; border: 1px solid gray; border-radius: 3%; } legend { font-size: 120%; font-weight: bold; color: blue; } #toast-container > .toast-warning { background-image: url('dist/img/toast/warning.png')!important; background-color: #ffa500; color: black; } </style> </head> <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'); ?> <div class="content-wrapper"> <section id="customer-table" class="content"> <div class="container-fluid"> <div class="row"> <div class="col-md mt-3"> <div class="card card-primary" id="report-list-main"> <div class="card-header"> <h3 class="card-title">PDC SMS Report</h3> </div> <!-- INSERT TABLE HERE --> <div class="card"> <div class="card-body"> <div class="row "> <!-- <div class="col-12"> <canvas class="pb-5 px-2" id="bar-chart-company"></canvas> </div> --> <div class="col-sm-6"> <div class="row"> <div class="col-sm-12"> <div class="form-group my-0 mx-0 "> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Date Range<span class="required-symbol" style="color: red;" hidden>*</span></label> <div id="div-filter-date-from" class="input-group date" style="height: 28px;"> <div class="edit-customer input-group date" data-target-input="nearest"> <input name="filter-date-selected" id="filter-date-selected" placeholder="Specify dates" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="big-letter edit-customer lbl-forms-sm form-control form-control-sm datetimepicker-input" data-target="#filter-date-from" style="background-color: white;" disabled/> <div class="edit-customer input-group-append"> <div id="filter-date" class="input-group-text"><i class="fa fa-calendar"></i></div> </div> </div> </div> </div> </div> </div> </div> <div class="row mt-2"> <div class="col-sm-6"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Company</label> <select name="company" id="company" class="form-control form-control-sm requestt-field select4" style="width: 100%;"> <option value="" selected> ALL</option> <?php $company = $db -> return_result("SELECT `id`, `code`,`name` 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']}' >".strtoupper($data['code'].' - '.$data['name'])."</option>"; } ?> </select> </div> </div> </div> <div class="col-sm-6"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Dealer</label> <select name="dealer" id="dealer" class="form-control form-control-sm requestt-field select5" style="width: 100%;"> <option value="0" selected>ALL</option> </select> </div> </div> </div> </div> <div class="form-group row my-1 mt-3"> <label class="col-sm-2 col-form-label">Status</label> <div class="col-sm-10"> <select name="status" id="status" class="form-control form-control-sm requestt-field select4" style="width: 100%;"> <option value="-3">ALL</option> <!-- <option value="-1">PENDING</option> --> <option value="0">SENT</option> <option value="1">UNSENT</option> </select> </div> </div> <div class="icheck-primary d-inline"> <input type="checkbox" id="chkMasked" checked <?php if($mobile_unmasking == 0){ echo "disabled"; } else { echo ""; } ?> > <label for="chkMasked">Mask customer mobile</label> </div> <br> <button name="button-generate" id="button-generate" class="btn btn-success btn-sm mt-4 mb-2"> <i class="fab fa-deezer"></i> Generate </button> </div> <div id="details-div" class="col-sm-6" hidden> <fieldset class="card"> <legend>Details</legend> <div class="mr-1"> <h4><span class="align-middle col-form-label font-weight-bold">Total: <span id="span-total"></span></span></h4> </div> </fieldset> </div> </div> <div id="pdc-div" class="table-responsive" hidden> <table id="pdc-record-table" class="table table-sm" data-toggle="table" data-url="" data-pagination="true" data-search="true" data-show-refresh="false" data-show-toggle="false" data-show-columns="false" data-show-columns-toggle-all="false" data-show-export="false" data-buttons="buttonsFunction" data-side-pagination="server" data-page-list="[10, 25, all]" data-minimum-count-columns="2" data-show-pagination-switch="false" data-pagination="true" data-query-params="queryPDCRecord" data-click-to-select="false"> <thead> <tr> <th class="main-header-table" data-formatter="" data-field="client_name">Client Name</th> <th class="main-header-table" data-formatter="" data-field="number">Client Mobile</th> <th class="main-header-table" data-formatter="" data-field="company_dealer">Company / Dealer</th> <th class="main-header-table" data-formatter="" data-field="action_date">Action Date</th> <th class="main-header-table text-center" data-formatter="" data-field="status">Status</th> </tr> </thead> </table> </div> </div> </div> </div> </div> </div> </div> </section> </div> <!--/.content wrapper--> <?php include('include/footer.php'); ?> <aside class="control-sidebar control-sidebar-dark"> </aside> </div> <!-- jQuery --> <script src="plugins/jquery/jquery.min.js"></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> <!-- jQuery Cookie--> <script src="plugins/jquery-cookie/jquery.cookie.js"></script> <!-- Balloon --> <script src="dist/js/jquery.balloon.min.js"></script> <!-- Toastr --> <script src="plugins/toastr/toastr.min.js"></script> <!-- Page specific 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 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-file--> <script> var generate_ins_report = '<?php echo $generate_ins_report; ?>'; </script> <?php include('include/components/sms_service/script_pdc_report.php'); ?> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings