File manager

File manager - Edit - /home/autoph/public_html/connectv1/importv2.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'); } if(!(isset($global_action_permissions['2']['1']['2']) && in_array("1", $global_action_permissions['2']['1']['2']))){ header('location:signin.php'); } $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; ?> <!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']; ?> \| Import</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"> <link href="dist/img/<?php echo $variable['logo']; ?>" rel="icon" /> <style> /* Just add this CSS to your project / .dropzone { border: 2px dashed #3b9aff; border-radius: 5px; justify-content: center; background: #f5f5f5; } .dropzone i { font-size: 5rem; } .dropzone .dz-message { color: rgba(0, 0, 0, .54); font-weight: 500; font-size: initial; text-transform: uppercase; } .dropzone-image-preview { height: unset; width: 100%; } .form-group { margin-bottom: 0.5rem; } .swal-height { height: 7vh; } #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"> <!-- INCLUDE HEADER --> <?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"> <!-- left column --> <div class="col-md mt-3"> <!-- general form elements --> <div class="card card-primary" id="my-card"> <div class="card-header"> <h3 class="card-title">Import</h3> </div> <!-- /.card-header --> <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"> <div class="mb-2"> <div> <label class="m-0 text-danger">Notes:</label> <ul class="mb-2"> <li>Date format must be <strong>MM/DD/YYYY</strong></li> <li>Follow the header names of this sample template <a href="download.php?q=dms_fields"><span class="text-primary"><u>Download</u></span></a></li> <li>Dealer values must be equal to the name or code of this template <a href="download.php?q=dealer_fields"><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"> <!-- <input type="submit" name="submit" id="submit" value="Update" class="btn btn-success float-right"> --> <button type="submit" name="submit" id="submit" class="btn btn-primary float-right">Import</button> </div> <!-- <div class="col-sm-12 float-right"> <div id="submit-div text-right"> <button type="submit" name="submit" id="submit" class="btn btn-primary">Import</button> </div> </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> <!-- /.card --> </div><!-- /.col-md --> </div> <!-- row --> <!-- /.control-sidebar --> </div><!-- container fluid --> <!-- ./wrapper --> </section><!-- content --> </div><!-- content wrapper --> <!-- INSERT FOOTER --> <?php include('include/footer.php'); ?> <!-- Control Sidebar --> <aside class="control-sidebar control-sidebar-dark"> <!-- Control sidebar content goes here --> </aside> </div><!-- wrapper --> <!-- 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> <!-- html2canvas --> <!-- <script src="dist/js/html2canvas.js"></script> --> <!-- <script src="node_modules/html2canvas/dist/html2canvas.js"></script> --> <!-- <script src="node_modules/xlsx/dist/xlsx.core.min.js"></script> <script src="node_modules/file-saverjs/FileSaver.js"></script> <script src="node_modules/tableexport/dist/js/tableexport.js"></script> --> <!-- <script src="dist/js/jquery.table2excel.js"></script> --> <!-- <script src="https://cdn.jsdelivr.net/gh/linways/table-to-excel@v1.0.4/dist/tableToExcel.js"></script> --> <!-- <script src="https://cdnjs.cloudflare.com/ajax/libs/TableExport/5.2.0/js/tableexport.min.js" integrity="sha512-XmZS54be9JGMZjf+zk61JZaLZyjTRgs41JLSmx5QlIP5F+sSGIyzD2eJyxD4K6kGGr7AsVhaitzZ2WTfzpsQzg==" crossorigin="anonymous"></script> --> <!-- <script src="https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/2.0.0/FileSaver.min.js" integrity="sha512-csNcFYJniKjJxRWRV1R7fvnXrycHP6qDR21mgz1ZP55xY5d+aHLfo9/FcGDQLfn2IfngbAHd8LdfsagcCqgTcQ==" crossorigin="anonymous"></script> --> <!-- Navigation Highlight --> <script src="dist/js/main.js"></script> <!-- Toastr --> <script src="plugins/toastr/toastr.min.js"></script> <script> function sweetAlertSimple(icon, title, text) { // Swal.fire({ // icon: icon, // title: title, // text: text, // allowEnterKey: true // default value // }) toastr.remove(); switch (icon) { case 'success': toastr.success(text); break; case 'info': toastr.info(text); break; case 'warning': toastr.warning(text); break; case 'error': toastr.error(text); break; } } function initSummaryTable() { var columns = [{ data: '1', title: '' }, { data: '2', title: '' } ]; var table = $('#summaryTable').DataTable({ initComplete: function() { // $('#summaryTable_wrapper .buttons-csv').click() }, 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.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) { // alert(file.upload.filename) $.ajax({ type: 'POST', url: 'api/upload/upload_spreadsheet.php', dataType: 'json', data: { name: file.name, request: 'delete' }, sucess: function(data) { console.log('success: ' + data); } }); // var upload_name = file.upload.filename.substr((file.name.lastIndexOf('.') + 1)); //re.exec(file.name)[1]; // upload_image_name.splice($.inArray(file.upload.filename, // upload_image_name), // 1); //remove image var _ref; return (_ref = file.previewElement) != null ? _ref.parentNode .removeChild(file .previewElement) : void 0; }, renameFile: function(file) { return file.name; // var extension = file.name.substr((file.name.lastIndexOf('.') + // 1)); //re.exec(file.name)[1]; // extension = extension.toLowerCase(); // let newName = uniqImgId() + '.' + // extension; //;new Date().getTime() + '_' + file.name; // upload_image_name.push(newName) // return newName; }, 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) { // Append all form inputs to the formData Dropzone will POST var data = $('#upload-sales-photo').serializeArray(); $.each(data, function(key, el) { formData.append(el.name, el.value); }); }); this.on("maxfilesexceeded", function(file) { // this.removeAllFiles(); // this.addFile(file); sweetAlertSimple('error', 'Oops...', 'Only 1 file allowed.'); return; }); this.on("error", function(file) { // upload_image_name.splice($.inArray(file.upload.filename, // upload_image_name), 1); //remove image // alert("Nice"); 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) // sweetAlertSimple('success', 'Oops...', 'Upload done.'); } }); 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(); // console.log(obj); if (parseInt(obj.status) === 1) { $('#summaryTable > tbody').html(''); // $('#summaryTable').find('tbody').append( // " <tr> <td>Company</td> <td class='text-center'><h5><span class='badge bg-primary' id='summary-company'></span></h5></td> </tr> <tr> <td>Dealer</td> <td class='text-center'><h5><span class='badge bg-primary' id='summary-dealer'></span></h5></td> </tr> <tr> <td>Source DMS</td> <td class='text-center'><h5><span class='badge ' id='summary-dms'></span></h5></td> </tr> <tr> <td>Database Type</td> <td class='text-center'><h5><span class='badge ' id='summary-db'></span></h5></td> </tr>" // ); $('#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() { // $('#invalid-report .buttons-csv').click() }, // 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": [{ // extend: 'csv', // text: 'CSV', // filename: function() { // var filename = $('input[type=file]') // .val() // .replace(/.(\/\|\\)/, ''); // return filename + '_issues'; // } // }, // { // extend: 'excel', // text: 'Excel', // filename: function() { // var filename = $('input[type=file]') // .val() // .replace(/.(\/\|\\)/, ''); // return filename + '_issues'; // } // }, // { // extend: 'pdf', // text: 'PDF', // filename: function() { // var filename = $('input[type=file]') // .val() // .replace(/.*(\/\|\\)/, ''); // return filename + '_issues'; // } // }, // "print", // ] }).buttons().container().appendTo( '#example2_wrapper .col-md-6:eq(0)'); } }) } }); }); </script> <script> $(function() { toastr.options = { "closeButton": false, "debug": false, "newestOnTop": false, "progressBar": false, "positionClass": "toast-bottom-right", "preventDuplicates": false, "onclick": null, "showDuration": "300", "hideDuration": "5000", "timeOut": "5000", "extendedTimeOut": "1000", "showEasing": "swing", "hideEasing": "linear", "showMethod": "fadeIn", "hideMethod": "fadeOut" } notify(); $("#example1").DataTable({ "responsive": true, "lengthChange": false, "autoWidth": false, "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"] }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)'); }); function isEmpty(string) { var flag = false; if (string == '') { flag = true; } else if (string == null) { flag = true; } else { if (string.trim() == '') { flag = true; } } return flag; } function notify(){ var Toast = Swal.mixin({ toast: true, position: 'top-end', showConfirmButton: false, timer: 10000 }); $.ajax({ url: "app/nature_of_business/nob_notification.php", type: "POST", dataType: 'json', data: { }, beforeSend: function(){ }, success: function(result) { var message = "There are " + result + " uncategorized Nature of Business"; // Toast.fire({ // icon: 'info', // title: " " + message, // customClass: 'swal-height' // }); toastr.remove(); toastr.warning(message); }, }); } </script> </body> </html>

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