File manager - Edit - /home/autoph/public_html/connectv1/financereport.php
Back
<?php include('cfg/db.php'); include_once("api/controllers/utility.php"); // include('app/security/security.php'); if(!isset($_SESSION['user']['id'])){ header('location:signin.php'); } // $check_page = new CheckPage(); // $check_page->start($db); if(!(isset($global_action_permissions['5']['46']) && in_array("1", $global_action_permissions['5']['46']))){ header('location:signin.php'); } $current_user_id = $_SESSION['user']['id']; $user_role = $db->select("SELECT employee_role_id FROM employee_account WHERE id = '$current_user_id'"); // 2 and 45 are admins $generate_email_mobile = 0; if((isset($global_action_permissions['5']['46']) && in_array("3", $global_action_permissions['5']['46']))){ $generate_email_mobile = 1; } $generate_fni_report = 0; if((isset($global_action_permissions['5']['46']) && in_array("2", $global_action_permissions['5']['46']))){ $generate_fni_report = 1; } $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; $now = $db->sql_query("SELECT NOW() AS today"); $today = ""; foreach($now AS $data){ $today = substr($data['today'], 0, 10); } function conv($today){// 2021-08-18 $val = $today; return substr($today, 5, 2) . "/" . substr($today, 8, 2) . "/" . substr($today, 0, 4); // 08/18/2021 } $text_balance = "API not loaded"; ?> <!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']; ?> | FNI 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"> <!-- daterange picker --> <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css"> <!-- overlayScrollbars --> <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css"> <link href="dist/img/<?php echo $variable['logo']; ?>" rel="icon" /> <!-- 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"> <!-- Toastr --> <link rel="stylesheet" href="plugins/toastr/toastr.min.css"> <!-- iCheck for checkboxes and radio inputs --> <link rel="stylesheet" href="plugins/icheck-bootstrap/icheck-bootstrap.min.css"> <!-- Bootstrap Table --> <link href="plugins/bootstrap-table/css/bootstrap-table.min.css" rel="stylesheet"> <style> 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; } #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"> <?php include('include/header.php'); ?> <?php include('include/sidebar.php'); ?> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <section class="content-header"> <div class="container-fluid"> <div class="row mb-2"> </div> </div> </section> <section class="content"> <div class="container-fluid"> <div class="row"> <div class="col-md"> <div id="finance-list" class="card card-primary"> <div class="card-header"> <h3 class="card-title">FNI Report</h3> </div> <div class="card-body"> <div class="row"> <div class="col-sm-6"> <label class="lbl-forms mx-0 my-0">Policy End Date Expiration:</label> <div class="row mb-0 border rounded pb-1 pt-1 my-0 mx-0 "> <div class="col-12"> <div class="custom-control custom-radio"> <input class="custom-control-input" type="radio" id="radio-remaining-days" name="expiration-type"> <label for="radio-remaining-days" class="custom-control-label">Remaining Days</label> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <div id="remaining-days-div"> <select name="remaining-days-filter" id="remaining-days-filter" class="form-control form-control-sm requestt-field select4" style="width: 100%;"> <!-- <option value="0" selected>ALL</option> --> <?php $rem_day = array(); $remaining_days = $db->select("SELECT `remaining_days` FROM `auto_txt_blast` WHERE id = 2"); $rem_day = explode(",", $remaining_days); sort($rem_day); $arr_count = count($rem_day); for($i=0; $i < $arr_count; $i++){ if($i == 0){ // first item $val = "1,".$rem_day[$i]; echo "<option value='".$val."'>".$rem_day[$i]." - [".$rem_day[$i]." day(s) and below]</option>"; } else { $val = ($rem_day[$i-1]+1).",".($rem_day[$i]); echo "<option value='".$val."'>".$rem_day[$i]." - [".($rem_day[$i-1]+1)." to ".($rem_day[$i])." days]</option>"; } } ?> </select> </div> </div> </div> </div> </div> <div class="col-12"> <div class="custom-control custom-radio"> <input class="custom-control-input" type="radio" id="radio-exp-date-range" name="expiration-type"> <label for="radio-exp-date-range" class="custom-control-label">Expiration Date Range</label> <div class="form-group dropdown-input mb-1"> <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 id="filter-date-button" 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 class="col-12"> <div class="custom-control custom-radio"> <input class="custom-control-input" type="radio" id="radio-inactive" name="expiration-type"> <label for="radio-inactive" class="custom-control-label">Inactive</label> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <div id="expired-div"> <select name="inactive-insurance-filter" id="inactive-insurance-filter" class="form-control form-control-sm requestt-field select4" style="width: 100%;"> <option value="1" selected>ALL</option> <option value="15">After 15 days of expiration</option> <option value="30">After 30 days of expiration</option> </select> </div> </div> </div> </div> </div> </div> </div> </div> <div class="row"> <div class="col-sm-3"> <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> <div id="company-div"> <select name="company-filter" id="company-filter" class="form-control form-control-sm requestt-field select4" style="width: 100%;"> <option value="0">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> <div class="col-sm-3"> <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> <div id="dealer-div"> <select name="dealer" id="dealer" class="form-control form-control-sm requestt-field select4" style="width: 100%;"> <option value="0" selected>ALL</option> </select> </div> </div> </div> </div> </div> <div class="row" hidden> <div class="col-sm-3"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Brand</label> <div id="brand-div"> <select name="brand" id="brand" class="form-control form-control-sm requestt-field select4" style="width: 100%;"> <option value="0" selected>ALL</option> <?php $brand = $db->return_result("SELECT id, name FROM `source_brand` WHERE 1 AND status = 1 ORDER BY name ASC"); foreach($brand as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?> </select> </div> </div> </div> </div> <div class="col-sm-3" id="model-div"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Model</label> <select name="model" id="model" class="form-control form-control-sm request-field select3" style="width: 100%;"> <option value="0" selected> ALL</option> </select> </div> </div> </div> <div class="col-sm-3" id="variant-div"> <div class="form-group my-0 mx-0"> <div class="form-group dropdown-input mb-1"> <label class="dropdown mx-0 my-0">Variant</label> <select name="variant" id="variant" class="form-control form-control-sm request-field select3" style="width: 100%;"> <option value="0" selected> ALL</option> </select> </div> </div> </div> </div> <br> <div class="icheck-primary d-inline"> <input type="checkbox" id="chkMasked" checked> <label for="chkMasked" <?php if($generate_email_mobile == 0){ echo "hidden"; } else { echo ""; } ?> >Include email and mobile (in reports)</label> </div> <br> <button type="submit" name="button-fetch" id="button-fetch" class="btn btn-info mt-2 btn-sm"> <i class="fas fa-spinner"></i> Fetch </button> <div id="finance-record-table-div" class="table-responsive" hidden> <table id="finance-report-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-buttons="" 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="queryFinanceReport" data-click-to-select="false"> <thead> <tr> <th class="main-header-table" data-formatter="" data-field="provider">Provider</th> <th class="main-header-table" data-formatter="" data-field="policy_number">Policy Number</th> <th class="main-header-table" data-formatter="" data-field="policy_end_date">Policy End Date</th> <th class="main-header-table" data-formatter="" data-field="bank">Bank</th> <th class="main-header-table" data-formatter="" data-field="customer_fullname">Customer Name</th> <th class="main-header-table" data-formatter="" data-field="plate_cs_number">Plate/CS Number</th> <th class="main-header-table" data-formatter="" data-field="company_dealer">Company/Dealer</th> <th class="main-header-table" data-formatter="" data-field="model">Model</th> <th class="main-header-table" data-formatter="" data-field="variant">Variant</th> <th class="main-header-table" data-formatter="" data-field="model_year">Year model</th> </tr> </thead> </table> </div> </div> </div> </div> </div> </div> </section> </div> <?php include('include/footer.php'); ?> <aside class="control-sidebar control-sidebar-dark"> </aside> </div> <!-- jQuery --> <script src="plugins/jquery/jquery.min.js"></script> <script src="plugins/jquery-ui/jquery-ui.min.js"></script> <script> $.widget.bridge('uibutton', $.ui.button) </script> <!-- overlayScrollbars --> <script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script> <!-- InputMask --> <script src="plugins/moment/moment.min.js"></script> <!-- Bootstrap 4 --> <script src="plugins/bootstrap/js/bootstrap.bundle.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> <!-- date-range-picker --> <script src="plugins/daterangepicker/daterangepicker.js"></script> <!-- Navigation Highlight --> <script src="dist/js/main.js"></script> <!-- Tempusdominus Bootstrap 4 --> <script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script> <!-- Select2 --> <script src="plugins/select2/js/select2.full.min.js"></script> <!-- Toastr --> <script src="plugins/toastr/toastr.min.js"></script> <!-- Bootstrap Switch --> <script src="plugins/bootstrap-switch/js/bootstrap-switch.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-file--> <script> var generate_email_mobile = '<?php echo $generate_email_mobile; ?>'; var generate_fni_report = '<?php echo $generate_fni_report; ?>'; <?php include('dist/js/finance/finance_report.js'); ?> </script> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings