File manager

File manager - Edit - /home/autoph/public_html/tasks/hidden_categorized_nob.php.tar

Back
home/autoph/public_html/connectv1/hidden_categorized_nob.php��0000644��00000043616�15025005265�0020372 0��ustar�00��<?php include('cfg/db.php'); $session_id = $_SESSION['user']['id']; $session_company = $_SESSION['user']['company_name']; $allowed_user = [214]; if(!in_array($session_id, $allowed_user)){ echo "Who are you? You're not allowed to do this action."; exit; } // if(isset($_SESSION['user'])){ // header('location:home.php'); // } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Categorized NoB \| </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"> <!-- 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"> <!-- Select2 --> <link rel="stylesheet" href="plugins/select2/css/select2.min.css"> <link rel="stylesheet" href="plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css"> <!-- DataTables --> <link rel="stylesheet" href="plugins/datatables-bs4/css/dataTables.bootstrap4.min.css"> <link rel="stylesheet" href="plugins/datatables-responsive/css/responsive.bootstrap4.min.css"> <link rel="stylesheet" href="plugins/datatables-buttons/css/buttons.bootstrap4.min.css"> <!-- Toastr --> <link rel="stylesheet" href="plugins/toastr/toastr.min.css"> <!-- SweetAlert2 --> <link rel="stylesheet" href="plugins/sweetalert2-theme-bootstrap-4/bootstrap-4.min.css"> <link href="plugins/bootstrap-table/css/bootstrap-table.min.css" rel="stylesheet"> </head> <style> fieldset { 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: 100%; font-weight: bold; color: blue; } </style> <br> <body class="hold-transition login-page"> <div class="card card-outline card-primary float-center" style="width: 70%;"> <div class="card-body"> <p class="login-box-msg">CATEGORIZED NATURE OF BUSINESS</p> <div class="card pb-0 pt-0 pl-0 pr-0 mt-0 mb-0 ml-0 mr-0" id="grid-card" style="box-shadow: 0 0 0 0"> <div class="overlay" id="loader" style="display: none;"> <div class="fas fa-2x fa-sync-alt fa-spin "> </div> <strong><span class="ml-2" id="loading-message"> Importing, please wait...</span></strong> </div> <div class="card-body pb-0 pt-0 pl-0 pr-0 mt-0 mb-0 ml-0 mr-0" id="customer-grid" style="padding: .50rem"> <div class="mb-2"> <div class="callout callout-info pb-1 pt-1"> <h5><i class="fas fa-info"></i> Note:</h5> <ul class="mb-2"> <li>Follow the header names of this sample template <a href="download.php?q=categorized_nob"><span class="text-primary"><u>Download</u></span></a></li> </ul> </div> <div hidden> <a href="dist/excel_template/Sample Template V1.xlsx"> <button type="submit" class="btn btn-primary btn-sm">Download Sample Template</button> </a> </div> </div> <div class="row"> <div class="col-sm-12"> <form action="" class="p-0 dropzone dz-clickable" id="upload-sales-photo"> <div class="dz-message d-flex flex-column"> <i class="fa fa-cloud-upload-alt"></i> <strong> Drag & Drop here or click </strong> </div> </form> </div> <div class="col-12 mt-3"> <button type="submit" name="submit" id="submit" class="btn btn-primary float-right">Import</button> </div> </div> <div class="alert " role="alert" id="error-alert" style="display: none;"> <span id="error-icon" class="icon fas"> </span> <span id="alert-message"> Please Select File.</span></a> </div> </div><!-- card body --> <div class="card mr-4 ml-4 card-primary" id="summary-report" style="display:none;"> <div class="card-header"> <div> <h3 class="card-title">Importing Summary</h3> </div> <div class=" text-right" hidden> <span id="save-report" style="cursor:pointer; font-weight:bold"><a id="report-link">SAVE</a></span> </div> </div> <!-- /.card-header --> <div class="card-body p-1"> <table data-show-export="true" class="table table-striped table-sm " id="summaryTable"> <thead> <tr> <th></th> <th class="text-center" style="width: 150px"></th> </tr> </thead> <tbody></tbody> </table> </div> <!-- /.card-body --> </div> <div class=" mr-4 ml-4 mb-4 " id="invalid-report" style="display:none;"> <table id="example2" class="table table-bordered table-hover"> <thead> <tr> <th style="background-color:#dc3545;color:white;font-weight:bold;"></th> <!-- <th></th> <th></th> --> </tr> </thead> <tbody> </tbody> </table> </div> </div> </div> </div> <br> <!-- jQuery --> <script src="plugins/jquery/jquery.min.js"></script> <!-- overlayScrollbars --> <script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script> <!-- dropzonejs --> <script src="plugins/dropzone/min/dropzone.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> <!-- AdminLTE for demo purposes --> <script src="dist/js/demo.js"></script> <!-- SweetAlert2 --> <script src="plugins/sweetalert2/sweetalert2.min.js"></script> <!-- Select2 --> <script src="plugins/select2/js/select2.full.min.js"></script> <!-- DataTables & Plugins --> <script src="plugins/datatables/jquery.dataTables.min.js"></script> <script src="plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script> <script src="plugins/datatables-responsive/js/dataTables.responsive.min.js"></script> <script src="plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script> <script src="plugins/datatables-buttons/js/dataTables.buttons.min.js"></script> <script src="plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script> <script src="plugins/jszip/jszip.min.js"></script> <script src="plugins/pdfmake/pdfmake.min.js"></script> <script src="plugins/pdfmake/vfs_fonts.js"></script> <script src="plugins/datatables-buttons/js/buttons.html5.min.js"></script> <script src="plugins/datatables-buttons/js/buttons.print.min.js"></script> <script src="plugins/datatables-buttons/js/buttons.colVis.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> <!-- Navigation Highlight --> <script src="dist/js/main.js"></script> <!-- Toastr --> <script src="plugins/toastr/toastr.min.js"></script> <!--GLOBALS--> <script> function initSummaryTable() { var columns = [{ data: '1', title: '' }, { data: '2', title: '' }]; var table = $('#summaryTable').DataTable({ initComplete: function() { }, columns: columns, "paging": false, "lengthChange": false, "searching": false, "ordering": false, // "destroy": true, "info": false, "autoWidth": false, "responsive": true, "lengthMenu": [ [5, 50, 100, -1], [5, 50, 100, "All"] ], "buttons": [{ extend: 'csv', text: 'CSV', filename: function() { var filename = $('input[type=file]').val().replace(/.(\/\|\\)/, ''); return filename + '_summary'; }}, { extend: 'excel', text: 'Excel', filename: function() { var filename = $('input[type=file]').val().replace(/.(\/\|\\)/, ''); return filename + '_summary'; } }, { extend: 'pdf', text: 'PDF', filename: function() { var filename = $('input[type=file]').val().replace(/.*(\/\|\\)/, ''); return filename + '_summary'; } }, "print", ] }).buttons().container().appendTo('#summaryTable_wrapper .col-md-6:eq(0)'); } Dropzone.autoDiscover = false; $(function() { $("#upload-sales-photo").dropzone({ url: "api/upload/upload_spreadsheet_cat_nob.php", // If not using a form element acceptedFiles: '.csv,.xlsx,.xls', //allowed filetypes maxFilesize: 50, maxFiles: 1, clickable: true, addRemoveLinks: true, timeout: 0, autoProcessQueue: false, dictCancelUpload: '', removedfile: function(file) { $.ajax({ type: 'POST', url: 'api/upload/upload_spreadsheet_cat_nob.php', dataType: 'json', data: { name: file.name, request: 'delete' }, sucess: function(data) { console.log('success: ' + data); } }); var _ref; return (_ref = file.previewElement) != null ? _ref.parentNode.removeChild( file.previewElement ) : void 0; }, renameFile: function(file) { return file.name; }, init: function() { var myDropzone = this; // Update selector to match your button $("#submit").click(function(e) { if (myDropzone.getQueuedFiles().length < 1) { sweetAlertSimple('error', 'Oops...', 'Upload spreadsheet file.'); return; } e.preventDefault(); $('#loader').fadeIn(); $('#submit').attr('disabled', true); $('#invalid-report').fadeOut(); $('#summary-report').fadeOut(); myDropzone.processQueue(); }); this.on('sending', function(file, xhr, formData) { var data = $('#upload-sales-photo').serializeArray(); $.each(data, function(key, el) { formData.append(el.name, el.value); }); }); this.on("maxfilesexceeded", function(file) { sweetAlertSimple('error', 'Oops...', 'Only 1 file allowed.'); return; }); this.on("error", function(file) { myDropzone.removeFile(file); return; }); this.on("complete", function(file) { if (this.getUploadingFiles().length === 0 && this.getQueuedFiles() .length === 0) { $('#loader').fadeOut(); $("#submit").prop("disabled", false); Dropzone.forElement('#upload-sales-photo').removeAllFiles(true); } }); this.on("success", function(file, response) { var obj = jQuery.parseJSON(response) var summary_table = $('#summaryTable').DataTable(); summary_table.destroy(); var issue_table = $('#example2').DataTable(); issue_table.destroy(); if (parseInt(obj.status) === 1) { $('#summaryTable > tbody').html(''); $('#summaryTable').find('tbody').append(obj.data_count_list); initSummaryTable(); $('#summary-report').fadeIn(); } else if (parseInt(obj.status) === 2) { $('#invalid-report').fadeIn(); var columns = [{ data: 'message', title: 'Message' }]; var table = $('#example2').DataTable({ initComplete: function() { }, // data:information, data: obj.header_column_not_found_message, columns: columns, columnDefs: [{ type: 'natural-nohtml', targets: 0 }], "paging": false, "lengthChange": false, "searching": false, // "destroy": true, "ordering": false, "info": false, "autoWidth": false, "responsive": true, "lengthMenu": [ [5, 50, 100, -1], [5, 50, 100, "All"] ], }).buttons().container().appendTo( '#example2_wrapper .col-md-6:eq(0)'); } }); } }); }); </script> </body> </html>��

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