File manager

File manager - Edit - /home/autoph/public_html/connectv1/include/components/sms_service/script_tb_report.php

Back
<!-- GLOBAL VARIABLES --> <script> var company = ""; var dealer = ""; var status = ""; var status_sms = ""; var mask = 1; </script> <!-- READY FUNCTION --> <script> $(function() { refreshTextBlastRequestTable(); countRequestTotal(); }); </script> <!-- INITIALIZATIONS --> <script> $('#company').select2(); $('#dealer').select2(); </script> <!-- FUNCTIONS --> <script> function refreshTextBlastRequestTable() { // 13 var $table = $('#request-status-table') $(function() { $table.bootstrapTable('refresh', { url: 'app/table/reload_table.php' }); }) } function refreshTextBlastSmsTable(){ // 14 $(function() { var $table = $('#sms-status-table') $table.bootstrapTable('refresh', { url: 'app/table/reload_table.php' }); }) } function queryParamsTextBlastRequests(params) { return { search: params.search, offset: params.offset, limit: params.limit, company: company, dealer: dealer, status: status, type: 13 // text blast request report table }; } function queryParamsTextBlastSms(params) { return { search: params.search, offset: params.offset, limit: params.limit, request_id: request_id, status: status_sms, mask: mask, type: 14 // text blast sms report table }; } function countRequestTotal(){ $.ajax({ url: "app/table/count_table.php", method: "GET", dataType: 'json', data: { company: company, dealer: dealer, status: status, type: 2 // text blast request report }, beforeSend: function() { }, success: function(result) { $('#span-request-total').text(result.count_total); if(result.count_total == 0){ $('#download-pdf-request').attr('disabled', true); $('#download-excel-request').attr('disabled', true); } else { $('#download-pdf-request').attr('disabled', false); $('#download-excel-request').attr('disabled', false); } } }) } function countSmsTotal(){ $.ajax({ url: "app/table/count_table.php", method: "GET", dataType: 'json', data: { request_id: request_id, company: company, dealer: dealer, status: status_sms, type: 3 // text blast sms report }, beforeSend: function() { }, success: function(result) { $('#span-sms-total').text(result.count_total); } }) } function goBack(){ $('#sending-status-section').fadeOut(); $('#on-going-section').fadeIn(); // window.history.back(); } function fetchDealer(){ $('#dealer').select2({ "language": { "noResults": function() { return 'Enter dealer name or code'; } }, escapeMarkup: function(markup) { return markup; }, placeholder: 'Search dealer name or code', ajax: { url: 'app/misc/get_dealer_customer.php', dataType: 'json', delay: 250, data: function(data) { return { searchTerm: data.term, // search term type: 1, company_id: $("#company").val() }; }, processResults: function(response) { response.unshift({ // id: "0" }); return { results: response }; }, cache: true } }); } function buttonsFunctionRequest() { return { grid_toggle_off: { 'icon': 'far fa-file-pdf', 'event': 'exportPdfRequest', 'attributes': { 'id': 'download-pdf-request', 'title': 'Download PDF', 'text': 'PDF' } } // , // excel_export: { // 'icon': 'fa-file-excel', // 'event': 'exportXlsxRequest', // 'attributes': { // 'id': 'download-excel-request', // 'title': 'Download XLSX (Excel)', // 'data-test': 'test123' // } // } } } function buttonsFunctionSms() { return { grid_toggle_off: { 'icon': 'far fa-file-pdf', 'event': 'exportPdfSms', 'attributes': { 'title': 'Download PDF', 'id': 'download-pdf-sms', 'data-test': 'test123' } } // , // excel_export: { // 'icon': 'fa-file-excel', // 'event': 'exportXlsxSms', // 'attributes': { // 'title': 'Download XLSX (Excel)', // 'id': 'download-excel-sms', // 'data-test': 'test123' // } // } } } function exportPdfRequest(){ var count = $('#span-request-total').text(); window.open('print_tb_request_record.php?company=' + company + '&dealer=' + dealer + '&status='+ status + '&count='+ count); } function exportXlsxRequest() { $('#request-status-table').tableExport({ fileName: 'Text Blast Request Report', type: 'xlsx' }); } function exportPdfSms(){ var count = $('#span-sms-total').text(); window.open('print_tb_sms_record.php?status_sms=' + status_sms + '&count='+ count + '&company='+ company + '&dealer='+ dealer + '&mask='+ mask + '&request_id='+ request_id); } function exportXlsxSms() { $('#sms-status-table').tableExport({ fileName: 'Text Blast Report', type: 'xlsx' }); } </script> <script> window.addEventListener("hashchange", function(e) { var type = window.location.hash.substr(1); // alert(type) switch (type) { case "request_data": break; default: // refreshTextBlastRequestTable(); $('#sending-status-section').fadeOut(); $('#on-going-section').fadeIn(); } }); </script> <script> $('#company').on('change', function(event) { company = $('#company').val(); fetchDealer(); refreshTextBlastRequestTable(); countRequestTotal(); }); </script> <script> $('#dealer').on('change', function(event) { dealer = $('#dealer').val(); refreshTextBlastRequestTable(); countRequestTotal(); }); </script> <script> $('#status').on('change', function(event) { status = $('#status').val(); refreshTextBlastRequestTable(); countRequestTotal(); }); </script> <script> $('#status-sms').on('change', function(event) { status_sms = $('#status-sms').val(); refreshTextBlastSmsTable(); countSmsTotal(); }); </script> <script> $('#chkMasked').click(function(){ if (mask == 0){mask = 1;} else {mask = 0;} refreshTextBlastSmsTable(); }); </script> <script> $('#request-status-table').on('click-cell.bs.table', function(field, value, row, $el) { var $table = $('#request-sending-table') request_id = $el.id; clicked_status = $el.status_id; window.location.hash = 'request_data'; refreshTextBlastSmsTable(); $.ajax({ url: "app/table/count_table.php", method: "GET", dataType: 'json', data: { request_id: request_id, type: 1 // text blast sms report }, beforeSend: function() { }, success: function(result) { $('#span-sms-total').text(result.count_total); result.company == "-" ? $('#span-company-value').text("ALL COMPANIES") : $('#span-company-value').text(result.company + " (" + result.company_code + ")"); result.dealer == "-" ? $('#span-dealer-value').text("ALL DEALERS") : $('#span-dealer-value').text(result.dealer + " (" + result.dealer_code + ")"); company = result.company; dealer = result.dealer; if(result.count_total == 0){ $('#download-pdf-sms').attr('disabled', true); // $('#download-excel-sms').attr('disabled', true); } else { $('#download-pdf-sms').attr('disabled', false); // $('#download-excel-sms').attr('disabled', false); } $('#span-request-value').html(''); $('#span-request-value').append(result.status); } }); $('#sending-status-section').fadeIn(); $('#sending-status-section').attr('hidden', false); $('#on-going-section').fadeOut(); }); </script>

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