File manager

File manager - Edit - /home/autoph/public_html/connectv1/resources/views/common/scripts/finance/financedashboard.js

Back
// GLOBALS var graph_companies = null; var lineChart = null; var box = 0; var granted = granted_company_ids; var start_date = ""; var end_date = ""; var start = null; var end = null; var company = 0; var dealer = 0; var reset = 1; var filter_date = 0; var filter_box = 0; $(function(){ initToolTip(); detailsCount(); showGraphCompany(); showLineGraph(); initTableFinanceDashboard(); start = moment().startOf('month'); end = moment().endOf('month'); $('#tip-new').attr('data-original-title', "<div id='tool-newly-added' class=''>Newly added this year, first time</div>"); $('#tip-company-count').attr('data-original-title', "<div id='tool-comp-count' class=''>Overall count</div>"); $('#tip-versus-years').attr('data-original-title', "<div id='tool-versus-years' class=''>Individual insurance count</div>"); $('#tip-with-vehicle').attr('data-original-title', "<div id='tool-with-vehicle' class=''>Insurance that have vehicle record</div>"); $('#filter-date').daterangepicker({ autoUpdateInput: false, showDropdowns: true, parentEl: '#dropdown-filter', locale: { cancelLabel: 'Cancel' }, startDate: start, opens: "left", endDate: end, ranges: { 'Today': [moment(), moment()], 'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')], 'Last 7 Days': [moment().subtract(6, 'days'), moment()], 'Last 30 Days': [moment().subtract(29, 'days'), moment()], 'This Month': [moment().startOf('month'), moment().endOf('month')], 'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')], 'This Year': [moment().startOf('year'), moment().endOf('year')], 'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')] } }); // resetDateRangePicker(start, end); let isMobile = window.matchMedia("only screen and (max-width: 760px)").matches; $(".daterangepicker").on('click', function() { setDateRangePickerWidth(isMobile); }); $("#filter-date").on('click', function() { setDateRangePickerWidth(isMobile); }); $('#company-filter').select2({ placeholder: "Company", allowClear: true }) $('#dealer').select2({ placeholder: "Dealer", allowClear: false }) $('[data-mask]').inputmask(); addListenerCompanyFilter(); $('#filter-date').on('apply.daterangepicker', function(ev, picker) { $('#filter-date span').html(picker.startDate.format('MMMM D, YYYY') + ' - ' + picker.endDate .format( 'MMMM D, YYYY')); filter_date = 1; cb(picker.startDate, picker.endDate); }); $('#filter-date').on('cancel.daterangepicker', function(ev, picker) { $('#filter-date').data('daterangepicker').hideCalendars(); filter_date = 0; }); $('#btn-no-filter').on('click', function() { $('#company-filter').off('change.mychange'); //off the company filter built in change event $('#company-filter').val('').trigger('change'); $('#dealer').off('change.mychange'); //off the company filter built in change event $('#dealer').val(0).trigger('change'); $('#dealer').html(''); company = 0; dealer = 0; addListenerCompanyFilter(); //enable again the company filter event start = moment().startOf('month'); end = moment().endOf('month'); reset = 1; filter_date = 0; resetDateRangePicker(start, end); }); document.getElementById("dropdown-filter").addEventListener('click', function(event) { event.stopPropagation(); }); $('#date-range').text("No Filter"); }) function initToolTip(){ var bootstrapTooltip = $.fn.tooltip.noConflict(); $.fn.bstooltip = bootstrapTooltip; $('#tip-new').bstooltip(); $('#tip-company-count').bstooltip(); $('#tip-versus-years').bstooltip(); $('#tip-with-vehicle').bstooltip(); } function initTableFinanceDashboard() { var $table = $('#finance-table-dashboard') $table.bootstrapTable('destroy').bootstrapTable({ }) } function refreshFinanceDashboardTable() { // 5 var $table = $('#finance-dashboard-table') $(function() { $table.bootstrapTable('refresh', { url: '/app/table/finance_table.php' }); }) } function queryParamsFinanceDashboardTable(params) { // $('#company-filter').text(company == '0' ? 'All' : $("#company-filter option:selected").text()); return { search: params.search, offset: params.offset, limit: params.limit, company: company, dealer: dealer, type: 5, box: box }; } function addCommas(nStr) { nStr += ''; x = nStr.split('.'); x1 = x[0]; x2 = x.length > 1 ? '.' + x[1] : ''; var rgx = /(\d+)(\d{3})/; while (rgx.test(x1)) { x1 = x1.replace(rgx, '$1' + ',' + '$2'); } return x1 + x2; } function fillDealer(){ var comp = $('#company-filter').val(); dealer = 0; hideTable(); $.ajax({ url:"app/misc/get_dealer3.php", type:"POST", data: { company: comp, type: 1 }, beforeSend: function(){ }, success: function(result){ $('#dealer').html(''); // $('#dealer').append("\"<option value=''>ALL</option>\""); $('#dealer').append("\"" + result + "\""); } }); } function resetDateRangePicker(start, end) { $("#filter-date").data('daterangepicker').setStartDate(start); $("#filter-date").data('daterangepicker').setEndDate(end); $('#filter-date').data('daterangepicker').hideCalendars(); $('.daterangepicker').css('width', 'auto'); var startDate = start.format('MMMM DD, YYYY'); var endDate = end.format('MMMM DD, YYYY'); if(reset == 0) {$('#date-range').text(startDate + ' - ' + endDate);} else if(reset == 1) {$('#date-range').text("No Filter");} cb(start, end); } function addListenerCompanyFilter() { $('#company-filter').off('change.mychange').on('change.mychange', function() { var start = $('#filter-date').data('daterangepicker').startDate; var end = $('#filter-date').data('daterangepicker').endDate; company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val(); if(company === null \|\| company == "" \|\| typeof company === "undefined"){ company = 0; } fillDealer(); hideTable(); reset = 0; $('#span-company').text($('#company-filter').select2('data')[0].text); $('#span-dealer').text(""); cb(start, end); }); } function setDateRangePickerWidth(isMobile) { if ($(".daterangepicker").hasClass('show-calendar') && !isMobile) { $('.daterangepicker').css('width', '630px'); } else { $('.daterangepicker').css('width', 'auto'); } reset = 0; } function passDate(startDate, endDate) { detailsCount(); showGraphCompany(); showLineGraph(); } function cb(start, end) { var startDate = start.format('YYYY-MM-DD'); passDate(start, end); //pass empty dates } function buttonsFunction() { return { grid_toggle_off: { 'icon': 'far fa-times', 'event': 'hideTable', 'attributes': { 'id': 'hide-table', 'title': 'Close / Hide table', 'class': 'error' } } // , // excel_export: { // 'icon': 'fa-file-excel', // 'event': 'exportXlsx', // 'attributes': { // 'id': 'download-excel-bg', // 'title': 'Download XLSX (Excel)', // 'data-test': 'test123' // } // } } } function hideTable(){ $('#fni-dashboard-div').fadeOut(); } function showGraphCompany(){ $.ajax({ url: "/app/finance/dashboard/company_count.php", method: "POST", dataType: 'json', data: { // startDate: startDate, // endDate: endDate, company: company, dealer: dealer }, beforeSend: function() { $('#loading_company_count').show(); }, success: function(data) { var tooltip = ""; var id = []; var name = []; var marks = []; var total = 0; for(var i in data) { name.push(data[i].code); marks.push(data[i].total); id.push(data[i].id); total = total + parseInt(data[i].total); tooltip = tooltip + data[i].code + ' - ' +addCommas(data[i].total) + ' <br>'; } $('#bar-chart-company-title').attr('data-original-title', tooltip); var chartdata = { labels: name, ids: id, datasets: [{ label: 'Total: ' + addCommas(total), backgroundColor: '#17a2b8', borderColor: '#46d5f1', hoverBackgroundColor: '#00c0ef', hoverBorderColor: '#666666', data: marks }] }; var barOptions = { responsive: true, maintainAspectRatio: false, // onClick: graphClickEventCompany, tooltips: { callbacks: { label: function(tooltipItem, data) { var value = data.datasets[0].data[tooltipItem.index]; return addCommas(value) } } // end callbacks: }, //end tooltips scales: { yAxes: [{ ticks: { precision: 0, beginAtZero: true, callback: function(label, index, labels) { if (parseInt(label) >= 1000000) { return label / 1000000 + 'M'; } else if (parseInt(label) >= 1000) { return label / 1000 + 'K'; } else { return label; } } }, }], xAxes: [{ ticks: { autoSkip: false, maxRotation: 90, minRotation: 90 } }] } } var graphTarget = $("#bar-chart-company"); if(graph_companies != null) { graph_companies.destroy(); } graph_companies = new Chart(graphTarget, { type: 'bar', data: chartdata, options: barOptions }); $('.company_countings_loading').hide(); } }) } function showLineGraph(){ $.ajax({ url: "/app/finance/dashboard/versus_years.php", method: "POST", dataType: 'json', data: { // startDate: startDate, // endDate: endDate, company: company, dealer: dealer }, beforeSend: function() { $('#loading_versus_years').show(); }, success: function(data) { var current_year = data.current_year; var current = data.current; var previous = data.previous; var previous_2 = data.previous_2; var lineChartData = { labels : ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'], datasets: [ { label : current_year, backgroundColor : 'rgba(45,85,255,1)', borderColor : 'rgba(45,85,255,1)', pointRadius : true, pointColor : '#3b8bba', pointStrokeColor : 'rgba(60,141,188,1)', pointHighlightFill : '#fff', pointHighlightStroke: 'rgba(60,141,188,1)', data : current }, { label : current_year-1, backgroundColor : 'rgba(0, 181, 204, 1)', borderColor : 'rgba(0, 181, 204, 1)', pointRadius : true, pointColor : 'rgba(210, 214, 222, 1)', pointStrokeColor : '#c1c7d1', pointHighlightFill : '#fff', pointHighlightStroke: 'rgba(220,220,220,1)', data : previous }, { label : current_year-2, backgroundColor : 'rgba(210, 214, 222, 1)', borderColor : 'rgba(210, 214, 222, 1)', pointRadius : true, pointColor : '', pointStrokeColor : 'rgba(60,141,188,1)', pointHighlightFill : '#fff', pointHighlightStroke: 'rgba(60,141,188,1)', data : previous_2 }, ] } var lineChartCanvas = $('#line-chart').get(0).getContext('2d'); lineChartData.datasets[0].fill = false; lineChartData.datasets[1].fill = false; lineChartData.datasets[2].fill = false; var lineChartOptions = { responsive: true, maintainAspectRatio: false, scales: { yAxes: [{ ticks: { precision: 0, beginAtZero: true, callback: function(label, index, labels) { if (parseInt(label) >= 1000000) { return label / 1000000 + 'M'; } else if (parseInt(label) >= 1000) { return label / 1000 + 'K'; } else { return label; } } }, }], xAxes: [{ ticks: { autoSkip: false, maxRotation: 90, minRotation: 90 } }] }, title: { fontSize: 15, display: true, text: 'Versus previous years', padding: 3 }, } lineChart = new Chart(lineChartCanvas, { type: 'line', data: lineChartData, options: lineChartOptions }) $('#loading_versus_years').hide(); } }) } function detailsCount(){ $.ajax({ url:"/app/finance/dashboard/details_count.php", type:"POST", dataType:"json", data: { company: company, dealer: dealer, type: 1 // details box count }, beforeSend: function(){ }, success: function(result){ $('#span-categorized-vehicle').text(result.categorized); // $('#span-individual-insurance').text(result.individual_insurance); $('#span-inactive').text(result.inactive); $('#span-newly-added').text(result.newly_added); $('#span-vehicle-record').text(result.vehicle_record); } }); } $('#dealer').on('change', function(){ dealer = $('#dealer').val(); var start = $('#filter-date').data('daterangepicker').startDate; var end = $('#filter-date').data('daterangepicker').endDate; reset = 0; $('#span-dealer').text($('#dealer').find(':selected').text()); cb(start, end); }) // COUNT BOXES $('#box-categorized-by-vehicle').on('click', function() { box = 1; // categorized by vehicle $('#fni-dashboard-div').attr('hidden', false); $('#fni-dashboard-div').fadeIn(); refreshFinanceDashboardTable(); }) $('#box-inactive').on('click', function() { // alert("On going"); return; box = 2; // inactive $('#fni-dashboard-div').attr('hidden', false); $('#fni-dashboard-div').fadeIn(); refreshFinanceDashboardTable(); }) $('#box-new').on('click', function() { // alert("Maintenance"); return; box = 3; // new $('#fni-dashboard-div').attr('hidden', false); $('#fni-dashboard-div').fadeIn(); refreshFinanceDashboardTable(); }) $('#box-with-vehicle').on('click', function() { // alert("On going"); return; box = 4; // with vehicle $('#fni-dashboard-div').attr('hidden', false); $('#fni-dashboard-div').fadeIn(); refreshFinanceDashboardTable(); }) $('#finance-dashboard-table').on('click-cell.bs.table', function(field, value, row, $el) { var finance_id = $el.id; var plate_cs_number = $el.plate_cs_number; window.location.href = "/financelist/" + plate_cs_number; }); $('#btn-no-filter').on('click', function() { $('#company-filter').off('change.mychange'); //off the company filter built in change event $('#company-filter').val('').trigger('change'); $('#dealer').off('change.mychange'); //off the company filter built in change event $('#dealer').val(0).trigger('change'); $('#dealer').html(''); hideTable(); company = 0; dealer = 0; $('#span-company').text(""); $('#span-dealer').text(""); addListenerCompanyFilter(); //enable again the company filter event start = moment().startOf('month'); end = moment().endOf('month'); reset = 1; filter_date = 0; resetDateRangePicker(start, end); });

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