File manager

File manager - Edit - /home/autoph/public_html/connectv1/report_list.php

Back
<?php include('cfg/db.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']; ?> \| Requested Reports</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"> <link href="dist/img/<?php echo $variable['logo']; ?>" rel="icon" /> <style> .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; } .input-group-append{ display: none; } select { -webkit-appearance: none; -moz-appearance: none; text-indent: 1px; text-overflow: ''; } #approver-list { pointer-events: none; } </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 class="content-header"> <div class="container-fluid"> <div class="row mb-2"> <div class="col-sm-6"> <h1>Requested Reports</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">Requested Reports</li> </ol> </div> </div> </div> </section> <section id="customer-table" class="content"> <div class="container-fluid"> <div class="card card-primary" id="report-list-main"> <div class="card-header"> <h3 class="card-title">List</h3> </div> <!-- INSERT TABLE HERE --> <div class="card"> <div class="card-body"> <div id="report-list" class="table-responsive"> <table id="report-table" data-toggle="table" data-url="" data-pagination="true" data-search="false" data-show-refresh="false" data-show-toggle="false" data-show-columns="false" data-show-columns-toggle-all="false" data-show-export="false" data-side-pagination="server" data-page-list="[10, 25, 50, 100, all]" data-minimum-count-columns="2" data-show-pagination-switch="false" data-pagination="true" data-query-params="queryParams" data-click-to-select="true"> <thead> <tr> <th data-field="date">Request Date</th> <th data-field="type">Type</th> <th data-field="expire_date">Expire Date</th> <th data-field="description">Description</th> <th data-field="status">Status</th> </tr> </thead> </table> </div><!--report-list--> </div><!--card-body--> </div><!--card--> </div><!--card card-primary--> <!-- Start Customer Report Information --> <div class="card card-primary" id="customer-report" style="display:none;"> <div class="card-header"> <h3 class="card-title">Report Information</h3> </div><!-- /.card-header --> <div class="overlay" name="loader" style="display:;"> <div class="fas fa-2x fa-sync-alt fa-spin "> </div> <strong><span class="ml-2" id="loading-message"> Fetching data, please wait...</span></strong> </div> <div class="card-body"> <div class="form-group mb-0"> <strong><span style="color:blue;">Number: </span></strong><span id="control-number"></span> </div> <div class="form-group mb-3"> <strong><span style="color:blue;">Report Date & Time: </span></strong><span id="report-date"></span> </div> <?php include('include/components/reports/generate_report.php'); ?> <div class="mt-3"> <div class="card"> <div class="card-header"> <h3 class="card-title">Approver</h3> </div> <!-- /.card-header --> <div class="card-body p-0"> <table class="table table-bordered table-hover table-sm" id="approver-list"> <thead> <tr> <th style="width: 20%">Name</th> <th style="width: 10%">Status</th> <th style="width: 70%">Notes</th> </tr> </thead> <tbody> </tbody> </table> </div> </div> <!-- /.card-body --> </div> <div class="row mt-3"> <div class="col-12"> <div class="alert alert-info float-right" role="alert" id="error-alert" style="display:none;"> <span id="error-icon" class="icon fas fa-info"> </span> <span id="alert-message"> Please Select File.</span></a> </div> </div> <div class="col-12"> <span onclick="reportList()" href="#" class="btn btn-secondary">Back</span> <input type="submit" name="submit" id="submit" value="Print Report" class="btn float-right"> </div> </div> </div> <!-- ./card-body --> </div> <!-- ./card-primary --> <!-- End Customer Report Information --> </div><!-- /.container-fluid --> </section> </div> <!--/.content wrapper--> <?php include('include/footer.php'); ?> <aside class="control-sidebar control-sidebar-dark"> </aside> </div> <!-- ./wrapper --> </div> <!-- jQuery --> <script src="plugins/jquery/jquery.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 --> <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> function reportList(){ $('#report-list-main').fadeIn(); $('#customer-report').fadeOut(); } </script> <script> $(document).ready(function() { // report-field $(".report-field").prop("disabled", true); $(".report-field").css("background-color", "white"); refreshTableCustomer() function refreshTableCustomer(){ var $table = $('#report-table') $(function() { $table.bootstrapTable('refresh', { url: 'app/table/reports.php' }); }) } function statusFormatter(value, row, index) { if(row.status == 1){ return '<input id="'+row.employee_id+'" class="status" name="status" type="checkbox" checked>'; }else{ return '<input id="'+row.employee_id+'" class="status" name="status" type="checkbox">'; } } function imageFormatter(value, row, index) { return '<a class="pic" href="#"><img width="50px" height="50px" class="user-image img-circle elevation-2" src="dist/img/'+value+'" /></a>'; } window.statusEvents = { 'click :checkbox': function (e, value, row, index) { var employee_id = row.employee_id; $.ajax({ url:"app/employee/status.php", method:"POST", data: {employee_id:employee_id}, success:function(data) { //alert(data); //window.location.reload(); } }); } }; }); </script> <script> function queryParams(params) { return { search: params.search, offset: params.offset, limit: params.limit }; } </script> <script> $('#report-table').on('click-cell.bs.table', function (field, value, row, $el) { var report_id = $el.id; $.ajax({ url:"app/report/report_information.php", method:"POST", dataType: 'json', data: {record_id:report_id}, beforeSend:function(){ $('#state').val('0').trigger('change'); $('#city').val('0').trigger('change'); $('#company').val('0').trigger('change'); $('#dealer').val('0').trigger('change'); $('#dms').val('0').trigger('change'); $('#type').val('0').trigger('change'); $('#filter-data').val('0').trigger('change'); $('#gender').val('0').trigger('change'); $("#reg-from").val(''); $("#reg-to").val(''); $("#age-from").val(''); $("#age-to").val(''); $("#upload-from").val(''); $("#upload-to").val(''); $("#upload-by").val(''); $("#report-description").val(''); $("#report-date").val(''); $("#control-number").val(''); // $('#error-alert').fadeOut(); $('#report-list-main').fadeOut(); $('#customer-report').fadeIn(); }, success:function(result) { $("#control-number").text(result.control_number); $("#report-date").text(result.report_date); $('#type').val(result.customer_type).trigger('change'); $('#filter-data').val(result.customer_data_type).trigger('change'); $('#gender').val(result.gender_id).trigger('change'); $("#reg-from").val(result.activity_date_from); $("#reg-to").val(result.activity_date_to); $("#age-from").val(result.age_from); $("#age-to").val(result.age_to); $("#upload-from").val(result.uploaded_date_from); $("#upload-to").val(result.uploaded_date_to); // alert(result.upload_by_employee_id); // $("#upload-by").val(result.upload_by_employee_id); $("#upload-by").html('<option selected>'+result.upload_by_employee_id+'</option>'); $("#report-description").val(result.description); // $('#city').val(result.city_id).trigger('change'); $('#company').val(result.company_id).trigger('change'); $('#dealer').val(result.dealer_id).trigger('change'); $('#dms').val(result.dms_id).trigger('change'); $('#state').val(result.state_id).trigger('change'); setTimeout(function () { $('#city').val(result.city_id).trigger('change'); }, 1000); $('#approver-list > tbody').html(''); $('#approver-list').find('tbody').append(result.approver_list); if(result.report_status == 2){ $("#submit").val('Print Report'); removeBtnClass() ; $('#submit').css("cursor","no-drop"); $(":submit").attr("disabled", true); $('#submit').addClass("btn-danger"); }else if(result.report_status == 1){ $("#submit").val('Print Report'); removeBtnClass(); $('#submit').css("cursor","pointer"); $('#submit').addClass("btn-success"); $(":submit").removeAttr("disabled"); }else{ $("#submit").val('Print Report'); removeBtnClass(); $('#submit').css("cursor","no-drop"); $('#submit').addClass("btn-warning"); $(":submit").attr("disabled", true); } $('.overlay').fadeOut(); } }); }); function removeBtnClass(){ $('#submit').removeClass("btn-warning"); $('#submit').removeClass("btn-danger"); $('#submit').removeClass("btn-success"); } </script> </script> <script> $(document).ready(function(){ $('#state').on('change', function(event){ event.preventDefault(); var state_id = this.value; $.ajax({ url:"app/misc/get_city.php", method:"POST", data: { state_id: state_id }, cache:false, beforeSend:function(){ $('#city').attr('disabled', true); }, success:function(data) { $("#city").html('<option value="0" selected>All</option>'+data); // $('#city').attr('disabled', false); } }) }); }); </script> </body> </html>

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