File manager - Edit - /home/u816558632/domains/postills.com/public_html/public/report.js.tar
Back
home/u816558632/domains/postills.com/public_html/public/js/report.js 0000644 00000230032 15000171413 0021011 0 ustar 00 $(document).ready(function() { //Purchase & Sell report //Date range as a button if ($('#purchase_sell_date_filter').length == 1) { $('#purchase_sell_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('#purchase_sell_date_filter span').html( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); updatePurchaseSell(); }); $('#purchase_sell_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#purchase_sell_date_filter').html( '<i class="fa fa-calendar"></i> ' + LANG.filter_by_date ); }); updatePurchaseSell(); } if ($('#scr_date_filter').length == 1) { $('#scr_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('#scr_date_filter').val( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); supplier_report_tbl.ajax.reload(); }); $('#scr_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#scr_date_filter').val(''); supplier_report_tbl.ajax.reload(); }); } //contact report supplier_report_tbl = $('#supplier_report_tbl').DataTable({ processing: true, serverSide: true, fixedHeader:false, ajax: { url: '/reports/customer-supplier', data: function(d) { d.customer_group_id = $('#cnt_customer_group_id').val(); d.contact_type = $('#contact_type').val(); d.location_id = $('#cs_report_location_id').val(); var start = $('input#scr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('input#scr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); d.start_date = start; d.end_date = end; d.contact_id = $('#scr_contact_id').val(); } }, columnDefs: [ { targets: [5], orderable: false, searchable: false }, { targets: [1, 2, 3, 4], searchable: false }, ], columns: [ { data: 'name', name: 'name' }, { data: 'total_purchase', name: 'total_purchase' }, { data: 'total_purchase_return', name: 'total_purchase_return' }, { data: 'total_invoice', name: 'total_invoice' }, { data: 'total_sell_return', name: 'total_sell_return' }, { data: 'opening_balance_due', name: 'opening_balance_due' }, { data: 'due', name: 'due' }, ], fnDrawCallback: function(oSettings) { var total_purchase = sum_table_col($('#supplier_report_tbl'), 'total_purchase'); $('#footer_total_purchase').text(total_purchase); var total_purchase_return = sum_table_col( $('#supplier_report_tbl'), 'total_purchase_return' ); $('#footer_total_purchase_return').text(total_purchase_return); var total_sell = sum_table_col($('#supplier_report_tbl'), 'total_invoice'); $('#footer_total_sell').text(total_sell); var total_sell_return = sum_table_col($('#supplier_report_tbl'), 'total_sell_return'); $('#footer_total_sell_return').text(total_sell_return); var total_opening_bal_due = sum_table_col( $('#supplier_report_tbl'), 'opening_balance_due' ); $('#footer_total_opening_bal_due').text(total_opening_bal_due); var total_due = sum_table_col($('#supplier_report_tbl'), 'total_due'); $('#footer_total_due').text(total_due); __currency_convert_recursively($('#supplier_report_tbl')); }, }); if($('#supplier_report_tbl').length != 0){ $('#cnt_customer_group_id, #contact_type, #cs_report_location_id, #scr_contact_id').change(function() { supplier_report_tbl.ajax.reload(); }); } var stock_report_cols = [ { data: 'action', name: 'action', searchable: false, orderable: false }, { data: 'sku', name: 'variations.sub_sku' }, { data: 'product', name: 'p.name' }, { data: 'variation', name: 'variation' }, { data: 'category_name', name: 'c.name' }, { data: 'location_name', name: 'l.name' }, { data: 'unit_price', name: 'variations.sell_price_inc_tax' }, { data: 'stock', name: 'stock', searchable: false }, ]; if ($('th.stock_price').length) { stock_report_cols.push({ data: 'stock_price', name: 'stock_price', searchable: false }); stock_report_cols.push({ data: 'stock_value_by_sale_price', name: 'stock_value_by_sale_price', searchable: false, orderable: false }); stock_report_cols.push({ data: 'potential_profit', name: 'potential_profit', searchable: false, orderable: false }); } stock_report_cols.push({ data: 'total_sold', name: 'total_sold', searchable: false }); stock_report_cols.push({ data: 'total_transfered', name: 'total_transfered', searchable: false }); stock_report_cols.push({ data: 'total_adjusted', name: 'total_adjusted', searchable: false }); stock_report_cols.push({ data: 'product_custom_field1', name: 'p.product_custom_field1'}); stock_report_cols.push({ data: 'product_custom_field2', name: 'p.product_custom_field2'}); stock_report_cols.push({ data: 'product_custom_field3', name: 'p.product_custom_field3'}); stock_report_cols.push({ data: 'product_custom_field4', name: 'p.product_custom_field4'}); if ($('th.current_stock_mfg').length) { stock_report_cols.push({ data: 'total_mfg_stock', name: 'total_mfg_stock', searchable: false }); } //Stock report table stock_report_table = $('#stock_report_table').DataTable({ processing: true, fixedHeader:false, order: [[1, 'asc']], serverSide: true, scrollY: "75vh", scrollX: true, scrollCollapse: true, ajax: { url: '/reports/stock-report', data: function(d) { d.location_id = $('#location_id').val(); d.category_id = $('#category_id').val(); d.sub_category_id = $('#sub_category_id').val(); d.brand_id = $('#brand').val(); d.unit_id = $('#unit').val(); d.only_mfg_products = $('#only_mfg_products').length && $('#only_mfg_products').is(':checked') ? 1 : 0; }, }, columns: stock_report_cols, fnDrawCallback: function(oSettings) { __currency_convert_recursively($('#stock_report_table')); }, "footerCallback": function ( row, data, start, end, display ) { var footer_total_stock = 0; var footer_total_sold = 0; var footer_total_transfered = 0; var total_adjusted = 0; var total_stock_price = 0; var footer_stock_value_by_sale_price = 0; var total_potential_profit = 0; var footer_total_mfg_stock = 0; for (var r in data){ footer_total_stock += $(data[r].stock).data('orig-value') ? parseFloat($(data[r].stock).data('orig-value')) : 0; footer_total_sold += $(data[r].total_sold).data('orig-value') ? parseFloat($(data[r].total_sold).data('orig-value')) : 0; footer_total_transfered += $(data[r].total_transfered).data('orig-value') ? parseFloat($(data[r].total_transfered).data('orig-value')) : 0; total_adjusted += $(data[r].total_adjusted).data('orig-value') ? parseFloat($(data[r].total_adjusted).data('orig-value')) : 0; total_stock_price += $(data[r].stock_price).data('orig-value') ? parseFloat($(data[r].stock_price).data('orig-value')) : 0; footer_stock_value_by_sale_price += $(data[r].stock_value_by_sale_price).data('orig-value') ? parseFloat($(data[r].stock_value_by_sale_price).data('orig-value')) : 0; total_potential_profit += $(data[r].potential_profit).data('orig-value') ? parseFloat($(data[r].potential_profit).data('orig-value')) : 0; footer_total_mfg_stock += $(data[r].total_mfg_stock).data('orig-value') ? parseFloat($(data[r].total_mfg_stock).data('orig-value')) : 0; } $('.footer_total_stock').html(__currency_trans_from_en(footer_total_stock, false)); $('.footer_total_stock_price').html(__currency_trans_from_en(total_stock_price)); $('.footer_total_sold').html(__currency_trans_from_en(footer_total_sold, false)); $('.footer_total_transfered').html(__currency_trans_from_en(footer_total_transfered, false)); $('.footer_total_adjusted').html(__currency_trans_from_en(total_adjusted, false)); $('.footer_stock_value_by_sale_price').html(__currency_trans_from_en(footer_stock_value_by_sale_price)); $('.footer_potential_profit').html(__currency_trans_from_en(total_potential_profit)); if ($('th.current_stock_mfg').length) { $('.footer_total_mfg_stock').html(__currency_trans_from_en(footer_total_mfg_stock, false)); } }, }); if ($('#trending_product_date_range').length == 1) { get_sub_categories(); $('#trending_product_date_range').daterangepicker({ ranges: ranges, autoUpdateInput: false, locale: { format: moment_date_format, cancelLabel: LANG.clear, applyLabel: LANG.apply, customRangeLabel: LANG.custom_range, }, }); $('#trending_product_date_range').on('apply.daterangepicker', function(ev, picker) { $(this).val( picker.startDate.format(moment_date_format) + ' ~ ' + picker.endDate.format(moment_date_format) ); }); $('#trending_product_date_range').on('cancel.daterangepicker', function(ev, picker) { $(this).val(''); }); } $('#stock_report_filter_form #location_id, #stock_report_filter_form #category_id, #stock_report_filter_form #sub_category_id, #stock_report_filter_form #brand, #stock_report_filter_form #unit,#stock_report_filter_form #view_stock_filter' ).change(function() { stock_report_table.ajax.reload(); stock_expiry_report_table.ajax.reload(); get_stock_value(); }); $('#only_mfg_products').on('ifChanged', function(event){ stock_report_table.ajax.reload(); lot_report.ajax.reload(); stock_expiry_report_table.ajax.reload(); items_report_table.ajax.reload(); }); $('#purchase_sell_location_filter').change(function() { updatePurchaseSell(); }); //Stock Adjustment Report if ($('#stock_adjustment_date_filter').length == 1) { $('#stock_adjustment_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('#stock_adjustment_date_filter span').html( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); updateStockAdjustmentReport(); }); $('#purchase_sell_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#purchase_sell_date_filter').html( '<i class="fa fa-calendar"></i> ' + LANG.filter_by_date ); }); updateStockAdjustmentReport(); } $('#stock_adjustment_location_filter').change(function() { updateStockAdjustmentReport(); }); if ($('#register_report_date_range').length == 1) { $('#register_report_date_range').daterangepicker({ ranges: ranges, autoUpdateInput: false, locale: { format: moment_date_format, cancelLabel: LANG.clear, applyLabel: LANG.apply, customRangeLabel: LANG.custom_range, }, }); $('#register_report_date_range').on('apply.daterangepicker', function(ev, picker) { $(this).val( picker.startDate.format(moment_date_format) + ' ~ ' + picker.endDate.format(moment_date_format) ); updateRegisterReport(); }); $('#register_report_date_range').on('cancel.daterangepicker', function(ev, picker) { $(this).val(''); updateRegisterReport(); }); } //Register report register_report_table = $('#register_report_table').DataTable({ processing: true, serverSide: true, scrollY: "75vh", scrollX: true, scrollCollapse: true, fixedHeader:false, ajax: '/reports/register-report', columns: [ { data: 'created_at', name: 'created_at' }, { data: 'closed_at', name: 'closed_at' }, { data: 'location_name', name: 'bl.name' }, { data: 'user_name', name: 'user_name' }, { data: 'total_card_payment', name: 'total_card_payment', searchable: false }, { data: 'total_cheque_payment', name: 'total_cheque_payment', searchable: false }, { data: 'total_cash_payment', name: 'total_cash_payment', searchable: false }, { data: 'total_bank_transfer_payment', name: 'total_bank_transfer_payment', searchable: false }, { data: 'total_advance_payment', name: 'total_advance_payment', searchable: false }, { data: 'total_custom_pay_1', name: 'total_custom_pay_1', searchable: false }, { data: 'total_custom_pay_2', name: 'total_custom_pay_2', searchable: false }, { data: 'total_custom_pay_3', name: 'total_custom_pay_3', searchable: false }, { data: 'total_custom_pay_4', name: 'total_custom_pay_4', searchable: false }, { data: 'total_custom_pay_5', name: 'total_custom_pay_5', searchable: false }, { data: 'total_custom_pay_6', name: 'total_custom_pay_6', searchable: false }, { data: 'total_custom_pay_7', name: 'total_custom_pay_7', searchable: false }, { data: 'total_other_payment', name: 'total_other_payment', searchable: false }, { data: 'total', name: 'total', orderable: false, searchable: false }, { data: 'action', name: 'action', orderable: false, searchable: false }, ], "footerCallback": function ( row, data, start, end, display ) { var total_card_payment = 0; var total_cheque_payment = 0; var total_cash_payment = 0; var total_bank_transfer_payment = 0; var total_other_payment = 0; var total_advance_payment = 0; var total_custom_pay_1 = 0; var total_custom_pay_2 = 0; var total_custom_pay_3 = 0; var total_custom_pay_4 = 0; var total_custom_pay_5 = 0; var total_custom_pay_6 = 0; var total_custom_pay_7 = 0; var total = 0; for (var r in data){ total_card_payment += $(data[r].total_card_payment).data('orig-value') ? parseFloat($(data[r].total_card_payment).data('orig-value')) : 0; total_cheque_payment += $(data[r].total_cheque_payment).data('orig-value') ? parseFloat($(data[r].total_cheque_payment).data('orig-value')) : 0; total_cash_payment += $(data[r].total_cash_payment).data('orig-value') ? parseFloat($(data[r].total_cash_payment).data('orig-value')) : 0; total_bank_transfer_payment += $(data[r].total_bank_transfer_payment).data('orig-value') ? parseFloat($(data[r].total_bank_transfer_payment).data('orig-value')) : 0; total_other_payment += $(data[r].total_other_payment).data('orig-value') ? parseFloat($(data[r].total_other_payment).data('orig-value')) : 0; total_advance_payment += $(data[r].total_advance_payment).data('orig-value') ? parseFloat($(data[r].total_advance_payment).data('orig-value')) : 0; total_custom_pay_1 += $(data[r].total_custom_pay_1).data('orig-value') ? parseFloat($(data[r].total_custom_pay_1).data('orig-value')) : 0; total_custom_pay_2 += $(data[r].total_custom_pay_2).data('orig-value') ? parseFloat($(data[r].total_custom_pay_2).data('orig-value')) : 0; total_custom_pay_3 += $(data[r].total_custom_pay_3).data('orig-value') ? parseFloat($(data[r].total_custom_pay_3).data('orig-value')) : 0; total_custom_pay_4 += $(data[r].total_custom_pay_4).data('orig-value') ? parseFloat($(data[r].total_custom_pay_4).data('orig-value')) : 0; total_custom_pay_5 += $(data[r].total_custom_pay_5).data('orig-value') ? parseFloat($(data[r].total_custom_pay_5).data('orig-value')) : 0; total_custom_pay_6 += $(data[r].total_custom_pay_6).data('orig-value') ? parseFloat($(data[r].total_custom_pay_6).data('orig-value')) : 0; total_custom_pay_7 += $(data[r].total_custom_pay_7).data('orig-value') ? parseFloat($(data[r].total_custom_pay_7).data('orig-value')) : 0; total += $(data[r].total).data('orig-value') ? parseFloat($(data[r].total).data('orig-value')) : 0; } $('.footer_total_card_payment').html(__currency_trans_from_en(total_card_payment)); $('.footer_total_cheque_payment').html(__currency_trans_from_en(total_cheque_payment)); $('.footer_total_cash_payment').html(__currency_trans_from_en(total_cash_payment)); $('.footer_total_bank_transfer_payment').html(__currency_trans_from_en(total_bank_transfer_payment)); $('.footer_total_other_payments').html(__currency_trans_from_en(total_other_payment)); $('.footer_total_advance_payment').html(__currency_trans_from_en(total_advance_payment)); $('.footer_total_custom_pay_1').html(__currency_trans_from_en(total_custom_pay_1)); $('.footer_total_custom_pay_2').html(__currency_trans_from_en(total_custom_pay_2)); $('.footer_total_custom_pay_3').html(__currency_trans_from_en(total_custom_pay_3)); $('.footer_total_custom_pay_4').html(__currency_trans_from_en(total_custom_pay_4)); $('.footer_total_custom_pay_5').html(__currency_trans_from_en(total_custom_pay_5)); $('.footer_total_custom_pay_6').html(__currency_trans_from_en(total_custom_pay_6)); $('.footer_total_custom_pay_7').html(__currency_trans_from_en(total_custom_pay_7)); $('.footer_total').html(__currency_trans_from_en(total)); }, }); $('.view_register').on('shown.bs.modal', function() { __currency_convert_recursively($(this)); }); $(document).on('submit', '#register_report_filter_form', function(e) { e.preventDefault(); updateRegisterReport(); }); $('#register_user_id, #register_status').change(function() { updateRegisterReport(); }); //Sales representative report if ($('#sr_date_filter').length == 1) { //date range setting $('input#sr_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('input#sr_date_filter').val( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); updateSalesRepresentativeReport(); }); $('input#sr_date_filter').on('apply.daterangepicker', function(ev, picker) { $(this).val( picker.startDate.format(moment_date_format) + ' ~ ' + picker.endDate.format(moment_date_format) ); }); $('input#sr_date_filter').on('cancel.daterangepicker', function(ev, picker) { $(this).val(''); }); //Sales representative report -> Total expense if ($('span#sr_total_expenses').length > 0) { salesRepresentativeTotalExpense(); } //Sales representative report -> Total sales if ($('span#sr_total_sales').length > 0) { salesRepresentativeTotalSales(); } if ($('#sr_payments_with_commission_table').length > 0) { sr_payments_with_commission_report = $('table#sr_payments_with_commission_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[1, 'desc']], ajax: { url: '/reports/sell-payment-report', data: function(d) { var start = $('input#sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('input#sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); var commission_agent = $('select#sr_id').val(); d.commission_agent = commission_agent != '' ? $('select#sr_id').val() : 0; d.location_id = $('select#sr_business_id').val(); d.start_date = start; d.end_date = end; }, }, columns: [ { data: 'payment_ref_no', name: 'payment_ref_no' }, { data: 'paid_on', name: 'paid_on' }, { data: 'amount', name: 'transaction_payments.amount' }, { data: 'customer', orderable: false, searchable: false }, { data: 'method', name: 'method' }, { data: 'invoice_no', name: 't.invoice_no' }, { data: 'action', orderable: false, searchable: false }, ], fnDrawCallback: function(oSettings) { var total_amount = sum_table_col($('#sr_payments_with_commission_table'), 'paid-amount'); $('#footer_total_amount').text(total_amount); __currency_convert_recursively($('#sr_payments_with_commission_table')); } }); } //Sales representative report -> Sales sr_sales_report = $('table#sr_sales_report').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[0, 'desc']], ajax: { url: '/sells', data: function(d) { var start = $('input#sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('input#sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); (d.created_by = $('select#sr_id').val()), (d.location_id = $('select#sr_business_id').val()), (d.start_date = start), (d.end_date = end); }, }, columns: [ { data: 'transaction_date', name: 'transaction_date' }, { data: 'invoice_no', name: 'invoice_no' }, { data: 'conatct_name', name: 'conatct_name' }, { data: 'business_location', name: 'bl.name' }, { data: 'payment_status', name: 'payment_status' }, { data: 'final_total', name: 'final_total' }, { data: 'total_paid', name: 'total_paid' }, { data: 'total_remaining', name: 'total_remaining' }, ], columnDefs: [ { searchable: false, targets: [6], }, ], fnDrawCallback: function(oSettings) { $('#sr_footer_sale_total').text( sum_table_col($('#sr_sales_report'), 'final-total') ); $('#sr_footer_total_paid').text(sum_table_col($('#sr_sales_report'), 'total-paid')); $('#sr_footer_total_remaining').text( sum_table_col($('#sr_sales_report'), 'payment_due') ); $('#sr_footer_total_sell_return_due').text( sum_table_col($('#sr_sales_report'), 'sell_return_due') ); $('#sr_footer_payment_status_count ').html( __sum_status_html($('#sr_sales_report'), 'payment-status-label') ); __currency_convert_recursively($('#sr_sales_report')); }, }); //Sales representative report -> Expenses sr_expenses_report = $('table#sr_expenses_report').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[0, 'desc']], ajax: { url: '/expenses', data: function(d) { var start = $('input#sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('input#sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); (d.expense_for = $('select#sr_id').val()), (d.location_id = $('select#sr_business_id').val()), (d.start_date = start), (d.end_date = end); }, }, columnDefs: [ { targets: 7, orderable: false, searchable: false, }, ], columns: [ { data: 'transaction_date', name: 'transaction_date' }, { data: 'ref_no', name: 'ref_no' }, { data: 'category', name: 'ec.name' }, { data: 'location_name', name: 'bl.name' }, { data: 'payment_status', name: 'payment_status' }, { data: 'final_total', name: 'final_total' }, { data: 'expense_for', name: 'expense_for' }, { data: 'additional_notes', name: 'additional_notes' }, ], fnDrawCallback: function(oSettings) { var expense_total = sum_table_col($('#sr_expenses_report'), 'final-total'); $('#footer_expense_total').text(expense_total); $('#er_footer_payment_status_count').html( __sum_status_html($('#sr_expenses_report'), 'payment-status') ); __currency_convert_recursively($('#sr_expenses_report')); }, }); //Sales representative report -> Sales with commission sr_sales_commission_report = $('table#sr_sales_with_commission_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[0, 'desc']], ajax: { url: '/sells', data: function(d) { var start = $('input#sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('input#sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); (d.commission_agent = $('select#sr_id').val()), (d.location_id = $('select#sr_business_id').val()), (d.start_date = start), (d.end_date = end); }, }, columns: [ { data: 'transaction_date', name: 'transaction_date' }, { data: 'invoice_no', name: 'invoice_no' }, { data: 'conatct_name', name: 'conatct_name' }, { data: 'business_location', name: 'bl.name' }, { data: 'payment_status', name: 'payment_status' }, { data: 'final_total', name: 'final_total' }, { data: 'total_paid', name: 'total_paid' }, { data: 'total_remaining', name: 'total_remaining' }, ], columnDefs: [ { searchable: false, targets: [6], }, ], fnDrawCallback: function(oSettings) { $('#footer_sale_total').text( sum_table_col($('#sr_sales_with_commission_table'), 'final-total') ); $('#footer_total_paid').text( sum_table_col($('#sr_sales_with_commission_table'), 'total-paid') ); $('#footer_total_remaining').text( sum_table_col($('#sr_sales_with_commission_table'), 'payment_due') ); $('#footer_total_sell_return_due').text( sum_table_col($('#sr_sales_with_commission_table'), 'sell_return_due') ); $('#footer_payment_status_count ').html( __sum_status_html($('#sr_sales_with_commission_table'), 'payment-status-label') ); __currency_convert_recursively($('#sr_sales_with_commission_table')); __currency_convert_recursively($('#sr_sales_with_commission')); }, }); //Sales representive filter $('select#sr_id, select#sr_business_id').change(function() { updateSalesRepresentativeReport(); }); } //Stock expiry report table stock_expiry_report_table = $('table#stock_expiry_report_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, ajax: { url: '/reports/stock-expiry', data: function(d) { d.location_id = $('#location_id').val(); d.category_id = $('#category_id').val(); d.sub_category_id = $('#sub_category_id').val(); d.brand_id = $('#brand').val(); d.unit_id = $('#unit').val(); d.exp_date_filter = $('#view_stock_filter').val(); d.only_mfg_products = $('#only_mfg_products').length && $('#only_mfg_products').is(':checked') ? 1 : 0; }, }, order: [[4, 'asc']], columns: [ { data: 'product', name: 'p.name' }, { data: 'sku', name: 'p.sku' }, // { data: 'ref_no', name: 't.ref_no' }, { data: 'location', name: 'l.name' }, { data: 'stock_left', name: 'stock_left', searchable: false }, { data: 'lot_number', name: 'lot_number' }, { data: 'exp_date', name: 'exp_date' }, { data: 'mfg_date', name: 'mfg_date' }, // { data: 'edit', name: 'edit' }, ], fnDrawCallback: function(oSettings) { __show_date_diff_for_human($('#stock_expiry_report_table')); $('button.stock_expiry_edit_btn').click(function() { var purchase_line_id = $(this).data('purchase_line_id'); $.ajax({ method: 'GET', url: '/reports/stock-expiry-edit-modal/' + purchase_line_id, dataType: 'html', success: function(data) { $('div.exp_update_modal') .html(data) .modal('show'); $('input#exp_date_expiry_modal').datepicker({ autoclose: true, format: datepicker_date_format, }); $('form#stock_exp_modal_form').submit(function(e) { e.preventDefault(); $.ajax({ method: 'POST', url: $('form#stock_exp_modal_form').attr('action'), dataType: 'json', data: $('form#stock_exp_modal_form').serialize(), success: function(data) { if (data.success == 1) { $('div.exp_update_modal').modal('hide'); toastr.success(data.msg); stock_expiry_report_table.ajax.reload(); } else { toastr.error(data.msg); } }, }); }); }, }); }); $('#footer_total_stock_left').html( __sum_stock($('#stock_expiry_report_table'), 'stock_left') ); __currency_convert_recursively($('#stock_expiry_report_table')); }, }); //Profit / Loss if ($('#profit_loss_date_filter').length == 1) { $('#profit_loss_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('#profit_loss_date_filter span').html( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); updateProfitLoss(); }); $('#profit_loss_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#profit_loss_date_filter').html( '<i class="fa fa-calendar"></i> ' + LANG.filter_by_date ); }); updateProfitLoss(); } $('#profit_loss_location_filter').change(function() { updateProfitLoss(); }); //Product Purchase Report if ($('#product_pr_date_filter').length == 1) { $('#product_pr_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('#product_pr_date_filter').val( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); product_purchase_report.ajax.reload(); }); $('#product_pr_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#product_pr_date_filter').val(''); product_purchase_report.ajax.reload(); }); } $( '#product_purchase_report_form #variation_id, \ #product_purchase_report_form #location_id, \ #product_purchase_report_form #supplier_id, \ #product_purchase_report_form \ #product_pr_date_filter, #ppr_brand_id' ).change(function() { product_purchase_report.ajax.reload(); }); product_purchase_report = $('table#product_purchase_report_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[3, 'desc']], ajax: { url: '/reports/product-purchase-report', data: function(d) { var start = ''; var end = ''; if ($('#product_pr_date_filter').val()) { start = $('input#product_pr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); end = $('input#product_pr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); } d.start_date = start; d.end_date = end; d.variation_id = $('#variation_id').val(); d.supplier_id = $('select#supplier_id').val(); d.location_id = $('select#location_id').val(); d.brand_id = $('select#ppr_brand_id').val(); }, }, columns: [ { data: 'product_name', name: 'p.name' }, { data: 'sub_sku', name: 'v.sub_sku' }, { data: 'supplier', name: 'c.name' }, { data: 'ref_no', name: 't.ref_no' }, { data: 'transaction_date', name: 't.transaction_date' }, { data: 'purchase_qty', name: 'purchase_lines.quantity' }, { data: 'quantity_adjusted', name: 'purchase_lines.quantity_adjusted' }, { data: 'unit_purchase_price', name: 'purchase_lines.purchase_price_inc_tax' }, { data: 'subtotal', name: 'subtotal', searchable: false }, ], fnDrawCallback: function(oSettings) { $('#footer_subtotal').text( sum_table_col($('#product_purchase_report_table'), 'row_subtotal') ); $('#footer_total_purchase').html( __sum_stock($('#product_purchase_report_table'), 'purchase_qty') ); $('#footer_total_adjusted').html( __sum_stock($('#product_purchase_report_table'), 'quantity_adjusted') ); __currency_convert_recursively($('#product_purchase_report_table')); }, }); if ($('#search_product').length > 0) { $('#search_product').autocomplete({ source: function(request, response) { $.ajax({ url: '/purchases/get_products?check_enable_stock=false', dataType: 'json', data: { term: request.term, }, success: function(data) { response( $.map(data, function(v, i) { if (v.variation_id) { return { label: v.text, value: v.variation_id }; } return false; }) ); }, }); }, minLength: 2, select: function(event, ui) { $('#variation_id') .val(ui.item.value) .change(); event.preventDefault(); $(this).val(ui.item.label); }, focus: function(event, ui) { event.preventDefault(); $(this).val(ui.item.label); }, }); } //Product Sell Report if ($('table#product_sell_report_table').length == 1) { $('#product_sr_date_filter').daterangepicker( dateRangeSettings, function(start, end) { $('#product_sr_date_filter').val( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); product_sell_report.ajax.reload(); product_sell_grouped_report.ajax.reload(); product_sell_report_with_purchase_table.ajax.reload(); $('.nav-tabs li.active').find('a[data-toggle="tab"]').trigger('shown.bs.tab'); } ); $('#product_sr_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#product_sr_date_filter').val(''); product_sell_report.ajax.reload(); product_sell_grouped_report.ajax.reload(); product_sell_report_with_purchase_table.ajax.reload(); $('.nav-tabs li.active').find('a[data-toggle="tab"]').trigger('shown.bs.tab'); }); $('#product_sr_start_time, #product_sr_end_time').datetimepicker({ format: moment_time_format, ignoreReadonly: true, }).on('dp.change', function(ev){ product_sell_report.ajax.reload(); product_sell_report_with_purchase_table.ajax.reload(); product_sell_grouped_report.ajax.reload(); $('.nav-tabs li.active').find('a[data-toggle="tab"]').trigger('shown.bs.tab'); }); product_sell_report = $('table#product_sell_report_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[6, 'desc']], ajax: { url: '/reports/product-sell-report', data: function(d) { var start = ''; var end = ''; var start_time = $('#product_sr_start_time').val(); var end_time = $('#product_sr_end_time').val(); if ($('#product_sr_date_filter').val()) { start = $('input#product_sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); start = moment(start + " " + start_time, "YYYY-MM-DD" + " " + moment_time_format).format('YYYY-MM-DD HH:mm'); end = $('input#product_sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); end = moment(end + " " + end_time, "YYYY-MM-DD" + " " + moment_time_format).format('YYYY-MM-DD HH:mm'); } d.start_date = start; d.end_date = end; d.variation_id = $('#variation_id').val(); d.customer_id = $('select#customer_id').val(); d.location_id = $('select#location_id').val(); d.category_id = $('select#psr_filter_category_id').val(); d.brand_id = $('select#psr_filter_brand_id').val(); d.customer_group_id = $('#psr_customer_group_id').val(); }, }, columns: [ { data: 'product_name', name: 'p.name'}, { data: 'sub_sku', name: 'v.sub_sku' }, { data: 'product_custom_field1', name: 'p.product_custom_field1', "visible": $('#psr_product_custom_field1').html().trim().length > 0}, { data: 'product_custom_field2', name: 'p.product_custom_field2', "visible": $('#psr_product_custom_field2').html().trim().length > 0}, { data: 'customer', name: 'c.name' }, { data: 'contact_id', name: 'c.contact_id' }, { data: 'invoice_no', name: 't.invoice_no' }, { data: 'transaction_date', name: 't.transaction_date' }, { data: 'sell_qty', name: 'transaction_sell_lines.quantity' }, { data: 'unit_price', name: 'transaction_sell_lines.unit_price_before_discount' }, { data: 'discount_amount', name: 'transaction_sell_lines.line_discount_amount' }, { data: 'tax', name: 'tax_rates.name' }, { data: 'unit_sale_price', name: 'transaction_sell_lines.unit_price_inc_tax' }, { data: 'subtotal', name: 'subtotal', searchable: false }, { data: 'payment_methods', name: 'payment_methods', searchable: false }, ], fnDrawCallback: function(oSettings) { $('#footer_subtotal').text( sum_table_col($('#product_sell_report_table'), 'row_subtotal') ); $('#footer_total_sold').html(__sum_stock($('#product_sell_report_table'), 'sell_qty')); $('#footer_tax').html(__sum_stock($('#product_sell_report_table'), 'tax', 'left')); __currency_convert_recursively($('#product_sell_report_table')); }, }); } var is_lot_enabled = $('#lot_enabled').length > 0 ? true : false; product_sell_report_with_purchase_table = $('table#product_sell_report_with_purchase_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[4, 'desc']], ajax: { url: '/reports/product-sell-report-with-purchase', data: function(d) { var start = ''; var end = ''; var start_time = $('#product_sr_start_time').val(); var end_time = $('#product_sr_end_time').val(); if ($('#product_sr_date_filter').val()) { start = $('input#product_sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); end = $('input#product_sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); start = moment(start + " " + start_time, "YYYY-MM-DD" + " " + moment_time_format).format('YYYY-MM-DD HH:mm'); end = moment(end + " " + end_time, "YYYY-MM-DD" + " " + moment_time_format).format('YYYY-MM-DD HH:mm'); } d.start_date = start; d.end_date = end; d.variation_id = $('#variation_id').val(); d.customer_id = $('select#customer_id').val(); d.location_id = $('select#location_id').val(); d.category_id = $('select#psr_filter_category_id').val(); d.brand_id = $('select#psr_filter_brand_id').val(); d.customer_group_id = $('#psr_customer_group_id').val(); }, }, columns: [ { data: 'product_name', name: 'p.name' }, { data: 'sub_sku', name: 'v.sub_sku' }, { data: 'customer', name: 'c.name' }, { data: 'invoice_no', name: 't.invoice_no' }, { data: 'transaction_date', name: 't.transaction_date' }, { data: 'ref_no', name: 'purchase.ref_no' }, { data: 'lot_number', name: 'pl.lot_number', visible: is_lot_enabled}, { data: 'supplier_name', name: 'supplier.name' }, { data: 'purchase_quantity', name: 'tspl.quantity' }, ], fnDrawCallback: function(oSettings) { __currency_convert_recursively($('#product_sell_report_with_purchase_table')); }, }); product_sell_grouped_report = $('table#product_sell_grouped_report_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[1, 'desc']], ajax: { url: '/reports/product-sell-grouped-report', data: function(d) { var start = ''; var end = ''; var start_time = $('#product_sr_start_time').val(); var end_time = $('#product_sr_end_time').val(); if ($('#product_sr_date_filter').val()) { start = $('input#product_sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); end = $('input#product_sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); start = moment(start + " " + start_time, "YYYY-MM-DD" + " " + moment_time_format).format('YYYY-MM-DD HH:mm'); end = moment(end + " " + end_time, "YYYY-MM-DD" + " " + moment_time_format).format('YYYY-MM-DD HH:mm'); } d.start_date = start; d.end_date = end; d.variation_id = $('#variation_id').val(); d.customer_id = $('select#customer_id').val(); d.location_id = $('select#location_id').val(); d.category_id = $('select#psr_filter_category_id').val(); d.brand_id = $('select#psr_filter_brand_id').val(); d.customer_group_id = $('#psr_customer_group_id').val(); }, }, columns: [ { data: 'product_name', name: 'p.name' }, { data: 'sub_sku', name: 'v.sub_sku' }, { data: 'transaction_date', name: 't.transaction_date' }, { data: 'current_stock', name: 'current_stock', searchable: false, orderable: false }, { data: 'total_qty_sold', name: 'total_qty_sold', searchable: false }, { data: 'subtotal', name: 'subtotal', searchable: false }, ], fnDrawCallback: function(oSettings) { $('#footer_grouped_subtotal').text( sum_table_col($('#product_sell_grouped_report_table'), 'row_subtotal') ); $('#footer_total_grouped_sold').html( __sum_stock($('#product_sell_grouped_report_table'), 'sell_qty') ); __currency_convert_recursively($('#product_sell_grouped_report_table')); }, }); $( '#psr_customer_group_id, #psr_filter_category_id, #psr_filter_brand_id, #product_sell_report_form #variation_id, #product_sell_report_form #location_id, #product_sell_report_form #customer_id' ).change(function() { product_sell_report.ajax.reload(); product_sell_grouped_report.ajax.reload(); product_sell_report_with_purchase_table.ajax.reload(); }); $('#product_sell_report_form #search_product').keyup(function() { if ( $(this) .val() .trim() == '' ) { $('#product_sell_report_form #variation_id') .val('') .change(); } }); $(document).on('click', '.remove_from_stock_btn', function() { swal({ title: LANG.sure, icon: 'warning', buttons: true, dangerMode: true, }).then(willDelete => { if (willDelete) { $.ajax({ method: 'GET', url: $(this).data('href'), dataType: 'json', success: function(result) { if (result.success == true) { toastr.success(result.msg); stock_expiry_report_table.ajax.reload(); } else { toastr.error(result.msg); } }, }); } }); }); //Product lot Report lot_report = $('table#lot_report').DataTable({ processing: true, serverSide: true, fixedHeader:false, // aaSorting: [[3, 'desc']], ajax: { url: '/reports/lot-report', data: function(d) { d.location_id = $('#location_id').val(); d.category_id = $('#category_id').val(); d.sub_category_id = $('#sub_category_id').val(); d.brand_id = $('#brand').val(); d.unit_id = $('#unit').val(); d.only_mfg_products = $('#only_mfg_products').length && $('#only_mfg_products').is(':checked') ? 1 : 0; }, }, columns: [ { data: 'sub_sku', name: 'v.sub_sku' }, { data: 'product', name: 'products.name' }, { data: 'lot_number', name: 'pl.lot_number' }, { data: 'exp_date', name: 'pl.exp_date' }, { data: 'stock', name: 'stock', searchable: false }, { data: 'total_sold', name: 'total_sold', searchable: false }, { data: 'total_adjusted', name: 'total_adjusted', searchable: false }, ], fnDrawCallback: function(oSettings) { $('#footer_total_stock').html(__sum_stock($('#lot_report'), 'total_stock')); $('#footer_total_sold').html(__sum_stock($('#lot_report'), 'total_sold')); $('#footer_total_adjusted').html(__sum_stock($('#lot_report'), 'total_adjusted')); __currency_convert_recursively($('#lot_report')); __show_date_diff_for_human($('#lot_report')); }, }); if ($('table#lot_report').length == 1) { $('#location_id, #category_id, #sub_category_id, #unit, #brand').change(function() { lot_report.ajax.reload(); }); } //Purchase Payment Report purchase_payment_report = $('table#purchase_payment_report_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[2, 'desc']], ajax: { url: '/reports/purchase-payment-report', data: function(d) { d.supplier_id = $('select#supplier_id').val(); d.location_id = $('select#location_id').val(); var start = ''; var end = ''; if ($('input#ppr_date_filter').val()) { start = $('input#ppr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); end = $('input#ppr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); } d.start_date = start; d.end_date = end; }, }, columns: [ { orderable: false, searchable: false, data: null, defaultContent: '', }, { data: 'payment_ref_no', name: 'payment_ref_no' }, { data: 'paid_on', name: 'paid_on' }, { data: 'amount', name: 'transaction_payments.amount' }, { data: 'supplier', orderable: false, searchable: false }, { data: 'method', name: 'method' }, { data: 'ref_no', name: 't.ref_no' }, { data: 'action', orderable: false, searchable: false }, ], fnDrawCallback: function(oSettings) { var total_amount = sum_table_col($('#purchase_payment_report_table'), 'paid-amount'); $('#footer_total_amount').text(total_amount); __currency_convert_recursively($('#purchase_payment_report_table')); }, createdRow: function(row, data, dataIndex) { if (!data.transaction_id) { $(row) .find('td:eq(0)') .addClass('details-control'); } }, }); // Array to track the ids of the details displayed rows var ppr_detail_rows = []; $('#purchase_payment_report_table tbody').on('click', 'tr td.details-control', function() { var tr = $(this).closest('tr'); var row = purchase_payment_report.row(tr); var idx = $.inArray(tr.attr('id'), ppr_detail_rows); if (row.child.isShown()) { tr.removeClass('details'); row.child.hide(); // Remove from the 'open' array ppr_detail_rows.splice(idx, 1); } else { tr.addClass('details'); row.child(show_child_payments(row.data())).show(); // Add to the 'open' array if (idx === -1) { ppr_detail_rows.push(tr.attr('id')); } } }); // On each draw, loop over the `detailRows` array and show any child rows purchase_payment_report.on('draw', function() { $.each(ppr_detail_rows, function(i, id) { $('#' + id + ' td.details-control').trigger('click'); }); }); if ($('#ppr_date_filter').length == 1) { $('#ppr_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('#ppr_date_filter span').val( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); purchase_payment_report.ajax.reload(); }); $('#ppr_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#ppr_date_filter').val(''); purchase_payment_report.ajax.reload(); }); } $( '#purchase_payment_report_form #location_id, #purchase_payment_report_form #supplier_id' ).change(function() { purchase_payment_report.ajax.reload(); }); //Sell Payment Report sell_payment_report = $('table#sell_payment_report_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, aaSorting: [[2, 'desc']], ajax: { url: '/reports/sell-payment-report', data: function(d) { d.supplier_id = $('select#customer_id').val(); d.location_id = $('select#location_id').val(); d.payment_types = $('select#payment_types').val(); d.customer_group_id = $('select#customer_group_filter').val(); var start = ''; var end = ''; if ($('input#spr_date_filter').val()) { start = $('input#spr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); end = $('input#spr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); } d.start_date = start; d.end_date = end; }, }, columns: [ { orderable: false, searchable: false, data: null, defaultContent: '', }, { data: 'payment_ref_no', name: 'payment_ref_no' }, { data: 'paid_on', name: 'paid_on' }, { data: 'amount', name: 'transaction_payments.amount' }, { data: 'customer', orderable: false, searchable: false }, { data: 'customer_group', name: 'customer_group', searchable: false}, { data: 'method', name: 'method' }, { data: 'invoice_no', name: 't.invoice_no' }, { data: 'action', orderable: false, searchable: false }, ], fnDrawCallback: function(oSettings) { var total_amount = sum_table_col($('#sell_payment_report_table'), 'paid-amount'); $('#footer_total_amount').text(total_amount); __currency_convert_recursively($('#sell_payment_report_table')); }, createdRow: function(row, data, dataIndex) { if (!data.transaction_id) { $(row) .find('td:eq(0)') .addClass('details-control'); } }, }); // Array to track the ids of the details displayed rows var spr_detail_rows = []; $('#sell_payment_report_table tbody').on('click', 'tr td.details-control', function() { var tr = $(this).closest('tr'); var row = sell_payment_report.row(tr); var idx = $.inArray(tr.attr('id'), spr_detail_rows); if (row.child.isShown()) { tr.removeClass('details'); row.child.hide(); // Remove from the 'open' array spr_detail_rows.splice(idx, 1); } else { tr.addClass('details'); row.child(show_child_payments(row.data())).show(); // Add to the 'open' array if (idx === -1) { spr_detail_rows.push(tr.attr('id')); } } }); // On each draw, loop over the `detailRows` array and show any child rows sell_payment_report.on('draw', function() { $.each(spr_detail_rows, function(i, id) { $('#' + id + ' td.details-control').trigger('click'); }); }); if ($('#spr_date_filter').length == 1) { $('#spr_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('#spr_date_filter span').val( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); sell_payment_report.ajax.reload(); }); $('#spr_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#spr_date_filter').val(''); sell_payment_report.ajax.reload(); }); } $('#sell_payment_report_form #location_id, #sell_payment_report_form #customer_id, #sell_payment_report_form #payment_types, #sell_payment_report_form #customer_group_filter').change( function() { sell_payment_report.ajax.reload(); } ); //Items report if ($('#ir_purchase_date_filter').length == 1) { $('#ir_purchase_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('#ir_purchase_date_filter').val( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); items_report_table.ajax.reload(); }); $('#ir_purchase_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#ir_purchase_date_filter').val(''); items_report_table.ajax.reload(); }); } if ($('#ir_sale_date_filter').length == 1) { $('#ir_sale_date_filter').daterangepicker(dateRangeSettings, function(start, end) { $('#ir_sale_date_filter').val( start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format) ); items_report_table.ajax.reload(); }); $('#ir_sale_date_filter').on('cancel.daterangepicker', function(ev, picker) { $('#ir_sale_date_filter').val(''); items_report_table.ajax.reload(); }); } items_report_table = $('#items_report_table').DataTable({ processing: true, serverSide: true, fixedHeader:false, ajax: { url: '/reports/items-report', data: function(d) { var purchase_start = ''; var purchase_end = ''; if ($('#ir_purchase_date_filter').val()) { purchase_start = $('input#ir_purchase_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); purchase_end = $('input#ir_purchase_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); } console.log(purchase_end); var sale_start = ''; var sale_end = ''; if ($('#ir_sale_date_filter').val()) { sale_start = $('input#ir_sale_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); sale_end = $('input#ir_sale_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); } d.purchase_start = purchase_start; d.purchase_end = purchase_end; d.sale_start = sale_start; d.sale_end = sale_end; d.supplier_id = $('select#ir_supplier_id').val(); d.customer_id = $('select#ir_customer_id').val(); d.location_id = $('select#ir_location_id').val(); d.only_mfg_products = $('#only_mfg_products').length && $('#only_mfg_products').is(':checked') ? 1 : 0; }, }, columns: [ { data: 'product_name', name: 'p.name' }, { data: 'sku', name: 'v.sub_sku' }, { data: 'sell_line_note', name: 'SL.sell_line_note' }, { data: 'purchase_date', name: 'purchase.transaction_date' }, { data: 'purchase_ref_no', name: 'purchase.ref_no' }, { data: 'lot_number', name: 'PL.lot_number' }, { data: 'supplier', name: 'suppliers.name' }, { data: 'purchase_price', name: 'PL.purchase_price_inc_tax' }, { data: 'sell_date', searchable: false }, { data: 'sale_invoice_no', name: 'sale_invoice_no' }, { data: 'customer', searchable: false }, { data: 'location', name: 'bl.name' }, { data: 'quantity', searchable: false }, { data: 'selling_price', searchable: false }, { data: 'subtotal', searchable: false } ], fnDrawCallback: function(oSettings) { $('#footer_total_pp').html(sum_table_col($('#items_report_table'), 'purchase_price')); $('#footer_total_sp').html(sum_table_col($('#items_report_table'), 'row_selling_price')); $('#footer_total_subtotal').html( sum_table_col($('#items_report_table'), 'row_subtotal') ); $('#footer_total_qty').html( __sum_stock($('#items_report_table'), 'quantity') ); __currency_convert_recursively($('#items_report_table')); }, }); $(document).on('change', '#ir_supplier_id, #ir_customer_id, #ir_location_id', function(){ items_report_table.ajax.reload(); }); expense_report_table = $('#expense_report_table').DataTable(); if ($('#closing_stock_by_pp').length == 1) { get_stock_value(); } if ($('#tax_report_date_range').length == 1) { updateTaxReport(); } $('#tax_report_location_id, #tax_report_date_range, #tax_report_contact_id').change(function() { updateTaxReport(); }); }); function updatePurchaseSell() { var start = $('#purchase_sell_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('#purchase_sell_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); var location_id = $('#purchase_sell_location_filter').val(); var data = { start_date: start, end_date: end, location_id: location_id }; var loader = __fa_awesome(); $('.total_purchase').html(loader); $('.purchase_due').html(loader); $('.total_sell').html(loader); $('.invoice_due').html(loader); $('.purchase_return_inc_tax').html(loader); $('.total_sell_return').html(loader); $.ajax({ method: 'GET', url: '/reports/purchase-sell', dataType: 'json', data: data, success: function(data) { $('.total_purchase').html( __currency_trans_from_en(data.purchase.total_purchase_exc_tax, true) ); $('.purchase_inc_tax').html( __currency_trans_from_en(data.purchase.total_purchase_inc_tax, true) ); $('.purchase_due').html(__currency_trans_from_en(data.purchase.purchase_due, true)); $('.total_sell').html(__currency_trans_from_en(data.sell.total_sell_exc_tax, true)); $('.sell_inc_tax').html(__currency_trans_from_en(data.sell.total_sell_inc_tax, true)); $('.sell_due').html(__currency_trans_from_en(data.sell.invoice_due, true)); $('.purchase_return_inc_tax').html( __currency_trans_from_en(data.total_purchase_return, true) ); $('.total_sell_return').html(__currency_trans_from_en(data.total_sell_return, true)); $('.sell_minus_purchase').html(__currency_trans_from_en(data.difference.total, true)); __highlight(data.difference.total, $('.sell_minus_purchase')); $('.difference_due').html(__currency_trans_from_en(data.difference.due, true)); __highlight(data.difference.due, $('.difference_due')); // $('.purchase_due').html( __currency_trans_from_en(data.purchase_due, true)); }, }); } function get_stock_details(rowData) { var div = $('<div/>') .addClass('loading') .text('Loading...'); var location_id = $('#location_id').val(); $.ajax({ url: '/reports/stock-details?location_id=' + location_id, data: { product_id: rowData.DT_RowId, }, dataType: 'html', success: function(data) { div.html(data).removeClass('loading'); __currency_convert_recursively(div); }, }); return div; } function updateStockAdjustmentReport() { var location_id = $('#stock_adjustment_location_filter').val(); var start = $('#stock_adjustment_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('#stock_adjustment_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); var data = { start_date: start, end_date: end, location_id: location_id }; var loader = __fa_awesome(); $('.total_amount').html(loader); $('.total_recovered').html(loader); $('.total_normal').html(loader); $('.total_abnormal').html(loader); $.ajax({ method: 'GET', url: '/reports/stock-adjustment-report', dataType: 'json', data: data, success: function(data) { $('.total_amount').html(__currency_trans_from_en(data.total_amount, true)); $('.total_recovered').html(__currency_trans_from_en(data.total_recovered, true)); $('.total_normal').html(__currency_trans_from_en(data.total_normal, true)); $('.total_abnormal').html(__currency_trans_from_en(data.total_abnormal, true)); }, }); stock_adjustment_table.ajax .url( '/stock-adjustments?location_id=' + location_id + '&start_date=' + start + '&end_date=' + end ) .load(); } function updateRegisterReport() { var start = $('#register_report_date_range') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('#register_report_date_range') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); var data = { user_id: $('#register_user_id').val(), status: $('#register_status').val(), start_date: start, end_date: end }; var out = []; for (var key in data) { out.push(key + '=' + encodeURIComponent(data[key])); } url_data = out.join('&'); register_report_table.ajax.url('/reports/register-report?' + url_data).load(); } function updateSalesRepresentativeReport() { //Update total expenses and total sales salesRepresentativeTotalExpense(); salesRepresentativeTotalSales(); salesRepresentativeTotalCommission(); //Expense and expense table refresh sr_expenses_report.ajax.reload(); sr_sales_report.ajax.reload(); sr_sales_commission_report.ajax.reload(); if ($('#sr_payments_with_commission_table').length > 0) { sr_payments_with_commission_report.ajax.reload(); } } function salesRepresentativeTotalExpense() { var start = $('input#sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('input#sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); var data_expense = { expense_for: $('select#sr_id').val(), location_id: $('select#sr_business_id').val(), start_date: start, end_date: end, }; $('span#sr_total_expenses').html(__fa_awesome()); $.ajax({ method: 'GET', url: '/reports/sales-representative-total-expense', dataType: 'json', data: data_expense, success: function(data) { $('span#sr_total_expenses').html(__currency_trans_from_en(data.total_expense, true)); }, }); } function salesRepresentativeTotalSales() { var start = $('input#sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('input#sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); var data_expense = { created_by: $('select#sr_id').val(), location_id: $('select#sr_business_id').val(), start_date: start, end_date: end, }; $('span#sr_total_sales').html(__fa_awesome()); $('span#sr_total_sales_return').html(__fa_awesome()); $('span#sr_total_sales_final').html(__fa_awesome()); $.ajax({ method: 'GET', url: '/reports/sales-representative-total-sell', dataType: 'json', data: data_expense, success: function(data) { $('span#sr_total_sales').html(__currency_trans_from_en(data.total_sell_exc_tax, true)); $('span#sr_total_sales_return').html( __currency_trans_from_en(data.total_sell_return_exc_tax, true) ); $('span#sr_total_sales_final').html(__currency_trans_from_en(data.total_sell, true)); }, }); } function salesRepresentativeTotalCommission() { var start = $('input#sr_date_filter') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('input#sr_date_filter') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); var data_sell = { commission_agent: $('select#sr_id').val(), location_id: $('select#sr_business_id').val(), start_date: start, end_date: end, }; $('div#total_payment_with_commsn_div').addClass('hide'); $('span#sr_total_commission').html(__fa_awesome()); $('span#total_payment_with_commsn').html(__fa_awesome()); if (data_sell.commission_agent) { $('div#total_commission_div').removeClass('hide'); $.ajax({ method: 'GET', url: '/reports/sales-representative-total-commission', dataType: 'json', data: data_sell, success: function(data) { var str = '<div style="padding-right:15px; display: inline-block">' + __currency_trans_from_en(data.total_commission, true) + '</div>'; if (data.commission_percentage != 0) { if (data.total_sales_with_commission) { str += ' <small>(' + data.commission_percentage + '% of ' + __currency_trans_from_en(data.total_sales_with_commission) + ')</small>'; } if (data.total_payment_with_commission) { $('div#total_payment_with_commsn_div').removeClass('hide'); $('span#total_payment_with_commsn').html(__currency_trans_from_en(data.total_payment_with_commission)); str += ' <small>(' + data.commission_percentage + '% of ' + __currency_trans_from_en(data.total_payment_with_commission) + ')</small>'; } } $('span#sr_total_commission').html(str); }, }); } else { $('div#total_commission_div').addClass('hide'); } } function show_child_payments(rowData) { var div = $('<div/>') .addClass('loading') .text('Loading...'); $.ajax({ url: '/payments/show-child-payments/' + rowData.DT_RowId, dataType: 'html', success: function(data) { div.html(data).removeClass('loading'); __currency_convert_recursively(div); }, }); return div; } function get_stock_value() { var loader = __fa_awesome(); $('#closing_stock_by_pp').html(loader); $('#closing_stock_by_sp').html(loader); $('#potential_profit').html(loader); $('#profit_margin').html(loader); var data = { location_id: $('#location_id').val(), category_id: $('#category_id').val(), sub_category_id: $('#sub_category_id').val(), brand_id: $('#brand').val(), unit_id: $('#unit').val(), } $.ajax({ url: '/reports/get-stock-value', data: data, success: function(data) { $('#closing_stock_by_pp').text(__currency_trans_from_en(data.closing_stock_by_pp)); $('#closing_stock_by_sp').text(__currency_trans_from_en(data.closing_stock_by_sp)); $('#potential_profit').text(__currency_trans_from_en(data.potential_profit)); $('#profit_margin').text(__currency_trans_from_en(data.profit_margin, false)); }, }); } function updateTaxReport() { var start = $('#tax_report_date_range') .data('daterangepicker') .startDate.format('YYYY-MM-DD'); var end = $('#tax_report_date_range') .data('daterangepicker') .endDate.format('YYYY-MM-DD'); var location_id = $('#tax_report_location_id').val(); var contact_id = $('#tax_report_contact_id').val(); var data = { start_date: start, end_date: end, location_id: location_id, contact_id: contact_id }; var loader = '<i class="fas fa-sync fa-spin fa-fw margin-bottom"></i>'; $('.tax_diff').html(loader); $.ajax({ method: 'GET', url: '/reports/tax-report', dataType: 'json', data: data, success: function(data) { $('.tax_diff').html(__currency_trans_from_en(data.tax_diff, true)); __highlight(data.tax_diff, $('.tax_diff')); }, }); }
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0 |
proxy
|
phpinfo
|
Settings