diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2022-05-10 17:14:58 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2022-05-10 17:14:58 +0700 |
| commit | 1ca3b3df3421961caec3b747a364071c80f5c7da (patch) | |
| tree | 6778a1f0f3f9b4c6e26d6d87ccde16e24da6c9d6 /base_accounting_kit/static/src/js/account_dashboard.js | |
| parent | b57188be371d36d96caac4b8d65a40745c0e972c (diff) | |
initial commit
Diffstat (limited to 'base_accounting_kit/static/src/js/account_dashboard.js')
| -rw-r--r-- | base_accounting_kit/static/src/js/account_dashboard.js | 1844 |
1 files changed, 1844 insertions, 0 deletions
diff --git a/base_accounting_kit/static/src/js/account_dashboard.js b/base_accounting_kit/static/src/js/account_dashboard.js new file mode 100644 index 0000000..79f7b1a --- /dev/null +++ b/base_accounting_kit/static/src/js/account_dashboard.js @@ -0,0 +1,1844 @@ +odoo.define('AccountingDashboard.AccountingDashboard', function(require) { + 'use strict'; + var AbstractAction = require('web.AbstractAction'); + var ajax = require('web.ajax'); + var core = require('web.core'); + var rpc = require('web.rpc'); + var web_client = require('web.web_client'); + var _t = core._t; + var QWeb = core.qweb; + var self = this; + var currency; + var ActionMenu = AbstractAction.extend({ + + contentTemplate: 'Invoicedashboard', + + events: { + 'click .invoice_dashboard': 'onclick_dashboard', + 'click #prog_bar': 'onclick_prog_bar', + 'click #invoice_this_month': 'onclick_invoice_this_month', + 'click #invoice_this_year': 'onclick_invoice_this_year', + 'click #invoice_last_month': 'onclick_invoice_last_month', + 'click #invoice_last_year': 'onclick_invoice_last_year', + 'click #onclick_banks_balance': 'onclick_bank_balance', + 'click #income_this_month': 'onclick_income_this_month', + 'click #income_this_year': 'onclick_income_this_year', + 'click #income_last_month': 'onclick_income_last_month', + 'click #income_last_year': 'onclick_income_last_year', + 'click #total_aged_payable': 'onclick_total_aged_payable', + 'click #in_ex_bar_chart': 'onclick_in_ex_bar_chart', + 'click #aged_recevable_pie_chart': 'onclick_aged_recevable_pie_chart', + 'click #invoice_bar_chart': 'onclick_invoice_bar_chart', + 'click .overdue_line_cust': 'onclick_overdue_line_cust', + 'click .top_customers': 'onclick_top_customers', + 'click .top_customers_amount': 'onclick_top_customers_amount', + 'click #bank_balance_hide': 'onclick_bank_balance_hide', + 'click #cash_balance_hide': 'onclick_cash_balance_hide', + 'click #in_ex_hide': 'onclick_in_ex_hide', + 'click #aged_payable_hide': 'onclick_aged_payable_hide', + 'change #aged_receivable_values': function(e) { + e.stopPropagation(); + var $target = $(e.target); + var value = $target.val(); + // this.$('.aged_receivable_this_month').empty(); + this.onclick_aged_payable(this.$('#aged_receivable_values').val()); + }, + 'change #aged_payable_value': function(e) { + e.stopPropagation(); + var $target = $(e.target); + var value = $target.val(); + this.$('.aged_receivable_this_month').empty(); + this.onclick_aged_receivable(this.$('#aged_payable_value').val()); + }, + 'change #top_10_customer_value': function(e) { + e.stopPropagation(); + var $target = $(e.target); + var value = $target.val(); + this.$('.top_10_customers_this_month').empty(); + this.onclick_top_10_month(this.$('#top_10_customer_value').val()); + }, + 'change #toggle-two': 'onclick_toggle_two', + 'click #unreconciled_counts_this_year': 'unreconciled_year', + 'click #unreconciled_items_': 'unreconciled_month', + 'click #total_customer_invoice_paid_current_month': 'invoice_month_paid', + 'click #total_customer_invoice_current_month': 'invoice_month', + 'click #total_supplier_invoice_paid_current_month': 'bill_month_paid', + 'click #total_supplier_invoice_current_month': 'bill_month', + 'click #total_customer_invoice_paid_current_year': 'invoice_year_paid', + 'click #total_customer_invoice_current_year': 'invoice_year', + 'click #total_supplier_invoice_paid_current_year': 'bill_year_paid', + 'click #total_supplier_invoice_current_year': 'bill_year', + 'click #net_profit_current_year': 'profit_income_year', + 'click #net_profit_current_months': 'profit_income_month', + 'click #total_incomes_this_year': 'total_income_year', + 'click #total_incomes_': 'total_income_month', + 'click #total_expense_this_year': 'expense_year', + 'click #total_expenses_': 'expense_month', + }, + profit_income_year: function(ev) { + var posted = false; + var self = this; + rpc.query({ + model: "account.move", + method: "click_profit_income_year", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move.line', + name: _t('Net Profit or Loss'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + profit_income_month: function(ev) { + var posted = false; + var self = this; + rpc.query({ + model: "account.move", + method: "click_profit_income_month", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move.line', + name: _t('Net Profit or Loss'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + total_income_year: function(ev) { + var posted = false; + var self = this; + rpc.query({ + model: "account.move", + method: "click_total_income_year", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move.line', + name: _t('Total Income'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + total_income_month: function(ev) { + var posted = false; + var self = this; + rpc.query({ + model: "account.move", + method: "click_total_income_month", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move.line', + name: _t('Total Income'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + expense_year: function(ev) { + var posted = false; + var self = this; + rpc.query({ + model: "account.move", + method: "click_expense_year", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move.line', + name: _t('Total Expenses'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + expense_month: function(ev) { + var posted = false; + var self = this; + rpc.query({ + model: "account.move", + method: "click_expense_month", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move.line', + name: _t('Total Expenses'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + unreconciled_year: function(ev) { + var posted = false; + var self = this; + rpc.query({ + model: "account.move", + method: "click_unreconcile_year", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move.line', + name: _t('Unreconciled'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + unreconciled_month: function(ev) { + var posted = false; + var self = this; + rpc.query({ + model: "account.move", + method: "click_unreconcile_month", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move.line', + name: _t('Unreconciled'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + invoice_month_paid: function(ev) { + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + var self = this; + rpc.query({ + model: "account.move", + method: "click_invoice_month_paid", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move', + name: _t('Paid'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + invoice_month: function(ev) { + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + var self = this; + rpc.query({ + model: "account.move", + method: "click_invoice_month", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move', + name: _t('Invoice'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + bill_month_paid: function(ev) { + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + var self = this; + rpc.query({ + model: "account.move", + method: "click_bill_month_paid", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move', + name: _t('Paid'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + bill_month: function(ev) { + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + var self = this; + rpc.query({ + model: "account.move", + method: "click_bill_month", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move', + name: _t('Invoice'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + bill_year: function(ev) { + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + var self = this; + rpc.query({ + model: "account.move", + method: "click_bill_year", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move', + name: _t('Invoice'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + bill_year_paid: function(ev) { + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + var self = this; + rpc.query({ + model: "account.move", + method: "click_bill_year_paid", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move', + name: _t('Paid'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + invoice_year: function(ev) { + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + var self = this; + rpc.query({ + model: "account.move", + method: "click_invoice_year", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move', + name: _t('Invoice'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + invoice_year_paid: function(ev) { + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + var self = this; + rpc.query({ + model: "account.move", + method: "click_invoice_year_paid", + args: [posted], + }).then(function(result) { + self.do_action({ + res_model: 'account.move', + name: _t('Paid'), + views: [ + [false, 'list'], + [false, 'form'] + ], + type: 'ir.actions.act_window', + domain: [ + ['id', 'in', result] + ], + }); + }) + }, + + onclick_toggle_two: function(ev) { + + this.onclick_aged_payable(this.$('#aged_receivable_values').val()); + + this.onclick_aged_receivable(this.$('#aged_payable_value').val()); + this.onclick_invoice_this_year(ev); + this.onclick_invoice_this_month(ev); + + this.onclick_income_this_month(ev); + this.onclick_income_last_month(ev); + this.onclick_income_last_year(ev); + this.onclick_income_this_year(ev); + }, + + onclick_top_10_month: function(f) { + var selected = $('.btn.btn-tool.income'); + var data = $(selected[0]).data(); + var posted = false; + var self = this; + var f = f; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + rpc.query({ + model: "account.move", + method: "get_currency", + }).then(function(result) { + currency = result; + }) + rpc.query({ + model: "account.move", + method: "get_top_10_customers_month", + args: [posted, f] + }) + .then(function(result) { + $('#top_10_customers').hide(); + $('#top_10_customers_last_month').hide(); + $('#top_10_customers_this_month').show(); + $('#top_10_customers_this_month').empty(); + + var due_count = 0; + _.forEach(result, function(x) { + due_count++; + var amount = self.format_currency(currency, x.amount); + $('#top_10_customers_this_month').append('<li><div id="line_' + x.parent + '" data-user-id="' + x.parent + '">' + x.customers + '</div>' + '<div id="line_' + x.parent + '" data-user-id="' + x.parent + '">' + amount + '</div>' + '</li>'); + $('#line_' + x.parent).on("click", function() { + self.do_action({ + res_model: 'res.partner', + name: _t('Partner'), + views: [ + [false, 'form'] + ], + type: 'ir.actions.act_window', + res_id: x.parent, + }); + }); + }); + + + }) + }, + + onclick_income_last_year: function(ev) { + ev.preventDefault(); + var selected = $('.btn.btn-tool.income'); + var data = $(selected[0]).data(); + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + rpc.query({ + model: 'account.move', + method: 'get_income_last_year', + args: [posted], + }) + .then(function(result) { + + $('#net_profit_current_months').hide(); + $('#net_profit_last_month').hide(); + $('#net_profit_last_year').show(); + $('#net_profit_this_year').hide(); + + var ctx = document.getElementById("canvas").getContext('2d'); + + // Define the data + var income = result.income; // Add data values to array + var expense = result.expense; + var profit = result.profit; + + var labels = result.month; // Add labels to array + // End Defining data + + // End Defining data + if (window.myCharts != undefined) + window.myCharts.destroy(); + window.myCharts = new Chart(ctx, { + //var myChart = new Chart(ctx, { + type: 'bar', + data: { + labels: labels, + datasets: [{ + label: 'Income', // Name the series + data: income, // Specify the data values array + backgroundColor: '#66aecf', + borderColor: '#66aecf', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Expense', // Name the series + data: expense, // Specify the data values array + backgroundColor: '#6993d6', + borderColor: '#6993d6', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Profit/Loss', // Name the series + data: profit, // Specify the data values array + backgroundColor: '#0bd465', + borderColor: '#0bd465', + + borderWidth: 1, // Specify bar border width + type: 'line', // Set this data to a line chart + fill: false + } + ] + }, + options: { + responsive: true, // Instruct chart js to respond nicely. + maintainAspectRatio: false, // Add to prevent default behaviour of full-width/height + } + }); + + }) + }, + + onclick_income_last_month: function(ev) { + ev.preventDefault(); + var selected = $('.btn.btn-tool.income'); + var data = $(selected[0]).data(); + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + rpc.query({ + model: 'account.move', + method: 'get_income_last_month', + args: [posted], + }) + .then(function(result) { + $('#net_profit_current_months').hide(); + $('#net_profit_last_month').show(); + $('#net_profit_this_year').hide(); + $('#net_profit_last_year').hide(); + + var ctx = document.getElementById("canvas").getContext('2d'); + + // Define the data + var income = result.income; // Add data values to array + var expense = result.expense; + var profit = result.profit; + + var labels = result.date; // Add labels to array + // End Defining data + + // End Defining data + if (window.myCharts != undefined) + window.myCharts.destroy(); + window.myCharts = new Chart(ctx, { + //var myChart = new Chart(ctx, { + type: 'bar', + data: { + labels: labels, + datasets: [{ + label: 'Income', // Name the series + data: income, // Specify the data values array + backgroundColor: '#66aecf', + borderColor: '#66aecf', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Expense', // Name the series + data: expense, // Specify the data values array + backgroundColor: '#6993d6', + borderColor: '#6993d6', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Profit/Loss', // Name the series + data: profit, // Specify the data values array + backgroundColor: '#0bd465', + borderColor: '#0bd465', + + borderWidth: 1, // Specify bar border width + type: 'line', // Set this data to a line chart + fill: false + } + ] + }, + options: { + responsive: true, // Instruct chart js to respond nicely. + maintainAspectRatio: false, // Add to prevent default behaviour of full-width/height + } + }); + + }) + }, + onclick_income_this_year: function(ev) { + ev.preventDefault(); + var selected = $('.btn.btn-tool.income'); + var data = $(selected[0]).data(); + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + + + rpc.query({ + model: 'account.move', + method: 'get_income_this_year', + args: [posted], + + }) + .then(function(result) { + + + $('#net_profit_current_months').hide(); + $('#net_profit_last_month').hide(); + $('#net_profit_last_year').hide(); + $('#net_profit_this_year').show(); + + var ctx = document.getElementById("canvas").getContext('2d'); + + // Define the data + var income = result.income; // Add data values to array + var expense = result.expense; + var profit = result.profit; + + var labels = result.month; // Add labels to array + + + if (window.myCharts != undefined) + window.myCharts.destroy(); + window.myCharts = new Chart(ctx, { + //var myChart = new Chart(ctx, { + type: 'bar', + data: { + labels: labels, + datasets: [{ + label: 'Income', // Name the series + data: income, // Specify the data values array + backgroundColor: '#66aecf', + borderColor: '#66aecf', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Expense', // Name the series + data: expense, // Specify the data values array + backgroundColor: '#6993d6', + borderColor: '#6993d6', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Profit/Loss', // Name the series + data: profit, // Specify the data values array + backgroundColor: '#0bd465', + borderColor: '#0bd465', + + borderWidth: 1, // Specify bar border width + type: 'line', // Set this data to a line chart + fill: false + } + ] + }, + options: { + responsive: true, // Instruct chart js to respond nicely. + maintainAspectRatio: false, // Add to prevent default behaviour of full-width/height + } + }); + + }) + }, + + + onclick_invoice_this_year: function(ev) { + ev.preventDefault(); + var selected = $('.btn.btn-tool.selected'); + var data = $(selected[0]).data(); + var posted = false; + var self = this; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + + rpc.query({ + model: "account.move", + method: "get_currency", + }).then(function(result) { + currency = result; + }) + + rpc.query({ + model: "account.move", + method: "get_total_invoice_current_year", + args: [posted], + }) + .then(function(result) { + + $('#total_supplier_invoice_paid').hide(); + $('#total_supplier_invoice').hide(); + $('#total_customer_invoice_paid').hide(); + $('#total_customer_invoice').hide(); + $('#tot_invoice').hide(); + $('#tot_supplier_inv').hide(); + + $('#total_supplier_invoice_paid_current_month').hide(); + $('#total_supplier_invoice_current_month').hide(); + $('#total_customer_invoice_paid_current_month').hide(); + $('#total_customer_invoice_current_month').hide(); + $('#tot_invoice_current_month').hide(); + $('#tot_supplier_inv_current_month').hide(); + + + $('#total_supplier_invoice_paid_current_year').empty(); + $('#total_supplier_invoice_current_year').empty(); + $('#total_customer_invoice_paid_current_year').empty(); + $('#total_customer_invoice_current_year').empty(); + $('#tot_invoice_current_year').empty(); + $('#tot_supplier_inv_current_year').empty(); + + $('#total_supplier_invoice_paid_current_year').show(); + $('#total_supplier_invoice_current_year').show(); + $('#total_customer_invoice_paid_current_year').show(); + $('#total_customer_invoice_current_year').show(); + $('#tot_invoice_current_year').show(); + $('#tot_supplier_inv_current_year').show(); + var tot_invoice_current_year = result[0][0] + var tot_credit_current_year = result[1][0] + var tot_supplier_inv_current_year = result[2][0] + var tot_supplier_refund_current_year = result[3][0] + var tot_customer_invoice_paid_current_year = result[4][0] + var tot_supplier_invoice_paid_current_year = result[5][0] + var tot_customer_credit_paid_current_year = result[6][0] + var tot_supplier_refund_paid_current_year = result[7][0] + var customer_invoice_total_current_year = (tot_invoice_current_year - tot_credit_current_year).toFixed(2) + var customer_invoice_paid_current_year = (tot_customer_invoice_paid_current_year - tot_customer_credit_paid_current_year).toFixed(2) + var invoice_percentage_current_year = ((customer_invoice_total_current_year / customer_invoice_paid_current_year) * 100).toFixed(2) + var supplier_invoice_total_current_year = (tot_supplier_inv_current_year - tot_supplier_refund_current_year).toFixed(2) + var supplier_invoice_paid_current_year = (tot_supplier_invoice_paid_current_year - tot_supplier_refund_paid_current_year).toFixed(2) + var supplier_percentage_current_year = ((supplier_invoice_total_current_year / supplier_invoice_paid_current_year) * 100).toFixed(2) + + $('#tot_supplier_inv_current_year').attr("value", supplier_invoice_paid_current_year); + $('#tot_supplier_inv_current_year').attr("max", supplier_invoice_total_current_year); + + $('#tot_invoice_current_year').attr("value", customer_invoice_paid_current_year); + $('#tot_invoice_current_year').attr("max", customer_invoice_total_current_year); + + customer_invoice_paid_current_year = self.format_currency(currency, customer_invoice_paid_current_year); + customer_invoice_total_current_year = self.format_currency(currency, customer_invoice_total_current_year); + supplier_invoice_paid_current_year = self.format_currency(currency, supplier_invoice_paid_current_year); + supplier_invoice_total_current_year = self.format_currency(currency, supplier_invoice_total_current_year); + + $('#total_customer_invoice_paid_current_year').append('<div class="logo">' + '<span>' + customer_invoice_paid_current_year + '</span><span>Total Paid<span></div>'); + $('#total_customer_invoice_current_year').append('<div" class="logo">' + '<span>' + customer_invoice_total_current_year + '</span><span>Total Invoice <span></div>'); + + $('#total_supplier_invoice_paid_current_year').append('<div" class="logo">' + '<span>' + supplier_invoice_paid_current_year + '</span><span>Total Paid<span></div>'); + $('#total_supplier_invoice_current_year').append('<div" class="logo">' + '<span>' + supplier_invoice_total_current_year + '</span><span>Total Invoice<span></div>'); + + }) + }, + onclick_invoice_this_month: function(ev) { + ev.preventDefault(); + var selected = $('.btn.btn-tool.selected'); + var data = $(selected[0]).data(); + var posted = false; + var self = this; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + rpc.query({ + model: "account.move", + method: "get_currency", + }).then(function(result) { + currency = result; + }) + rpc.query({ + model: "account.move", + method: "get_total_invoice_current_month", + args: [posted], + }) + .then(function(result) { + $('#total_supplier_invoice_paid').hide(); + $('#total_supplier_invoice').hide(); + $('#total_customer_invoice_paid').hide(); + $('#total_customer_invoice').hide(); + $('#tot_invoice').hide(); + $('#tot_supplier_inv').hide(); + $('#total_supplier_invoice_paid_current_month').empty(); + $('#total_supplier_invoice_current_month').empty(); + $('#total_customer_invoice_paid_current_month').empty(); + $('#total_customer_invoice_current_month').empty(); + $('#tot_invoice_current_month').empty(); + $('#tot_supplier_inv_current_month').empty(); + $('#total_supplier_invoice_paid_current_year').hide(); + $('#total_supplier_invoice_current_year').hide(); + $('#total_customer_invoice_paid_current_year').hide(); + $('#total_customer_invoice_current_year').hide(); + $('#tot_invoice_current_year').hide(); + $('#tot_supplier_inv_current_year').hide(); + $('#total_supplier_invoice_paid_current_month').show(); + $('#total_supplier_invoice_current_month').show(); + $('#total_customer_invoice_paid_current_month').show(); + $('#total_customer_invoice_current_month').show(); + $('#tot_invoice_current_month').show(); + $('#tot_supplier_inv_current_month').show(); + var tot_invoice_current_month = result[0][0] + var tot_credit_current_month = result[1][0] + var tot_supplier_inv_current_month = result[2][0] + var tot_supplier_refund_current_month = result[3][0] + var tot_customer_invoice_paid_current_month = result[4][0] + var tot_supplier_invoice_paid_current_month = result[5][0] + var tot_customer_credit_paid_current_month = result[6][0] + var tot_supplier_refund_paid_current_month = result[7][0] + var customer_invoice_total_current_month = (tot_invoice_current_month - tot_credit_current_month).toFixed(2) + var customer_invoice_paid_current_month = (tot_customer_invoice_paid_current_month - tot_customer_credit_paid_current_month).toFixed(2) + var invoice_percentage_current_month = ((customer_invoice_total_current_month / customer_invoice_paid_current_month) * 100).toFixed(2) + var supplier_invoice_total_current_month = (tot_supplier_inv_current_month - tot_supplier_refund_current_month).toFixed(2) + var supplier_invoice_paid_current_month = (tot_supplier_invoice_paid_current_month - tot_supplier_refund_paid_current_month).toFixed(2) + var supplier_percentage_current_month = ((supplier_invoice_total_current_month / supplier_invoice_paid_current_month) * 100).toFixed(2) + + $('#tot_supplier_inv_current_month').attr("value", supplier_invoice_paid_current_month); + $('#tot_supplier_inv_current_month').attr("max", supplier_invoice_total_current_month); + + $('#tot_invoice_current_month').attr("value", customer_invoice_paid_current_month); + $('#tot_invoice_current_month').attr("max", customer_invoice_total_current_month); + + customer_invoice_paid_current_month = self.format_currency(currency, customer_invoice_paid_current_month); + customer_invoice_total_current_month = self.format_currency(currency, customer_invoice_total_current_month); + supplier_invoice_paid_current_month = self.format_currency(currency, supplier_invoice_paid_current_month); + supplier_invoice_total_current_month = self.format_currency(currency, supplier_invoice_total_current_month); + + + $('#total_customer_invoice_paid_current_month').append('<div class="logo">' + '<span>' + customer_invoice_paid_current_month + '</span><span>Total Paid<span></div>'); + $('#total_customer_invoice_current_month').append('<div" class="logo">' + '<span>' + customer_invoice_total_current_month + '</span><span>Total Invoice<span></div>'); + + $('#total_supplier_invoice_paid_current_month').append('<div" class="logo">' + '<span>' + supplier_invoice_paid_current_month + '</span><span>Total Paid<span></div>'); + $('#total_supplier_invoice_current_month').append('<div" class="logo">' + '<span>' + supplier_invoice_total_current_month + '</span><span>Total Invoice<span></div>'); + + }) + }, + + onclick_income_this_month: function(ev) { + ev.preventDefault(); + var selected = $('.btn.btn-tool.income'); + var data = $(selected[0]).data(); + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + rpc.query({ + model: 'account.move', + method: 'get_income_this_month', + args: [posted], + + }) + .then(function(result) { + + + var ctx = document.getElementById("canvas").getContext('2d'); + + // Define the data + var income = result.income; // Add data values to array + var expense = result.expense; + var profit = result.profit; + + var labels = result.date; // Add labels to array + // End Defining data + + // End Defining data + if (window.myCharts != undefined) + window.myCharts.destroy(); + window.myCharts = new Chart(ctx, { + //var myChart = new Chart(ctx, { + type: 'bar', + data: { + labels: labels, + datasets: [{ + label: 'Income', // Name the series + data: income, // Specify the data values array + backgroundColor: '#66aecf', + borderColor: '#66aecf', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Expense', // Name the series + data: expense, // Specify the data values array + backgroundColor: '#6993d6', + borderColor: '#6993d6', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Profit/Loss', // Name the series + data: profit, // Specify the data values array + backgroundColor: '#0bd465', + borderColor: '#0bd465', + + borderWidth: 1, // Specify bar border width + type: 'line', // Set this data to a line chart + fill: false + } + ] + }, + options: { + responsive: true, // Instruct chart js to respond nicely. + maintainAspectRatio: false, // Add to prevent default behaviour of full-width/height + } + }); + + }) + }, + + onclick_aged_payable: function(f) { + + // ev.preventDefault(); + var arg = f; + var selected = $('.btn.btn-tool.expense'); + var data = $(selected[0]).data(); + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + rpc.query({ + model: 'account.move', + method: 'get_overdues_this_month_and_year', + args: [posted, f], + }) + .then(function(result) { + // Doughnut Chart + $(document).ready(function() { + var options = { + // legend: false, + responsive: false + }; + if (window.donut != undefined) + window.donut.destroy(); + + + window.donut = new Chart($("#canvas1"), { + type: 'doughnut', + tooltipFillColor: "rgba(51, 51, 51, 0.55)", + data: { + labels: result.due_partner, + datasets: [{ + data: result.due_amount, + backgroundColor: [ + '#66aecf ', '#6993d6 ', '#666fcf', '#7c66cf', '#9c66cf', + '#bc66cf ', '#b75fcc', ' #cb5fbf ', ' #cc5f7f ', ' #cc6260', + '#cc815f', '#cca15f ', '#ccc25f', '#b9cf66', '#99cf66', + ' #75cb5f ', '#60cc6c', '#804D8000', '#80B33300', '#80CC80CC', '#f2552c', '#00cccc', + '#1f2e2e', '#993333', '#00cca3', '#1a1a00', '#3399ff', + '#8066664D', '#80991AFF', '#808E666FF', '#804DB3FF', '#801AB399', + '#80E666B3', '#8033991A', '#80CC9999', '#80B3B31A', '#8000E680', + '#804D8066', '#80809980', '#80E6FF80', '#801AFF33', '#80999933', + '#80FF3380', '#80CCCC00', '#8066E64D', '#804D80CC', '#809900B3', + '#80E64D66', '#804DB380', '#80FF4D4D', '#8099E6E6', '#806666FF' + ], + hoverBackgroundColor: [ + '#66aecf ', '#6993d6 ', '#666fcf', '#7c66cf', '#9c66cf', + '#bc66cf ', '#b75fcc', ' #cb5fbf ', ' #cc5f7f ', ' #cc6260', + '#cc815f', '#cca15f ', '#ccc25f', '#b9cf66', '#99cf66', + ' #75cb5f ', '#60cc6c', '#804D8000', '#80B33300', '#80CC80CC', '#f2552c', '#00cccc', + '#1f2e2e', '#993333', '#00cca3', '#1a1a00', '#3399ff', + '#8066664D', '#80991AFF', '#808E666FF', '#804DB3FF', '#801AB399', + '#80E666B3', '#8033991A', '#80CC9999', '#80B3B31A', '#8000E680', + '#804D8066', '#80809980', '#80E6FF80', '#801AFF33', '#80999933', + '#80FF3380', '#80CCCC00', '#8066E64D', '#804D80CC', '#809900B3', + '#80E64D66', '#804DB380', '#80FF4D4D', '#8099E6E6', '#806666FF' + ] + }] + }, + options: { + responsive: false + } + }); + }); + // Doughnut Chart + + }) + }, + + + onclick_aged_receivable: function(f) { + var selected = $('.btn.btn-tool.expense'); + var data = $(selected[0]).data(); + var posted = false; + var f = f + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + rpc.query({ + model: 'account.move', + method: 'get_latebillss', + args: [posted, f], + + }) + .then(function(result) { + function myFunction() { + document.getElementByClass("btn btn-tool dropdown-toggle").text + document.getElementById("aged_receivable_this_month").text + } + + $(document).ready(function() { + var options = { + // legend: false, + responsive: true, + legend: { + position: 'bottom' + } + }; + + + if (window.donuts != undefined) + window.donuts.destroy(); + + + window.donuts = new Chart($("#horizontalbarChart"), { + type: 'doughnut', + tooltipFillColor: "rgba(51, 51, 51, 0.55)", + data: { + labels: result.bill_partner, + datasets: [{ + data: result.bill_amount, + backgroundColor: [ + '#66aecf ', '#6993d6 ', '#666fcf', '#7c66cf', '#9c66cf', + '#bc66cf ', '#b75fcc', ' #cb5fbf ', ' #cc5f7f ', ' #cc6260', + '#cc815f', '#cca15f ', '#ccc25f', '#b9cf66', '#99cf66', + ' #75cb5f ', '#60cc6c', '#804D8000', '#80B33300', '#80CC80CC', '#f2552c', '#00cccc', + '#1f2e2e', '#993333', '#00cca3', '#1a1a00', '#3399ff', + '#8066664D', '#80991AFF', '#808E666FF', '#804DB3FF', '#801AB399', + '#80E666B3', '#8033991A', '#80CC9999', '#80B3B31A', '#8000E680', + '#804D8066', '#80809980', '#80E6FF80', '#801AFF33', '#80999933', + '#80FF3380', '#80CCCC00', '#8066E64D', '#804D80CC', '#809900B3', + '#80E64D66', '#804DB380', '#80FF4D4D', '#8099E6E6', '#806666FF' + ], + hoverBackgroundColor: [ + '#66aecf ', '#6993d6 ', '#666fcf', '#7c66cf', '#9c66cf', + '#bc66cf ', '#b75fcc', ' #cb5fbf ', ' #cc5f7f ', ' #cc6260', + '#cc815f', '#cca15f ', '#ccc25f', '#b9cf66', '#99cf66', + ' #75cb5f ', '#60cc6c', '#804D8000', '#80B33300', '#80CC80CC', '#f2552c', '#00cccc', + '#1f2e2e', '#993333', '#00cca3', '#1a1a00', '#3399ff', + '#8066664D', '#80991AFF', '#808E666FF', '#804DB3FF', '#801AB399', + '#80E666B3', '#8033991A', '#80CC9999', '#80B3B31A', '#8000E680', + '#804D8066', '#80809980', '#80E6FF80', '#801AFF33', '#80999933', + '#80FF3380', '#80CCCC00', '#8066E64D', '#804D80CC', '#809900B3', + '#80E64D66', '#804DB380', '#80FF4D4D', '#8099E6E6', '#806666FF' + ] + }] + }, + options: { + responsive: false + } + }); + }); + + + }) + }, + + renderElement: function(ev) { + var self = this; + $.when(this._super()) + .then(function(ev) { + + + $('#toggle-two').bootstrapToggle({ + on: 'View All Entries', + off: 'View Posted Entries' + }); + + + var posted = false; + if ($('#toggle-two')[0].checked == true) { + posted = "posted" + } + + + rpc.query({ + model: "account.move", + method: "get_currency", + }) + .then(function(result) { + currency = result; + + }) + + + rpc.query({ + model: "account.move", + method: "get_income_this_month", + args: [posted], + }) + .then(function(result) { + + + var ctx = document.getElementById("canvas").getContext('2d'); + + // Define the data + var income = result.income; // Add data values to array + var expense = result.expense; + var profit = result.profit; + + var labels = result.date; // Add labels to array + // End Defining data + + // End Defining data + if (window.myCharts != undefined) + window.myCharts.destroy(); + window.myCharts = new Chart(ctx, { + //var myChart = new Chart(ctx, { + type: 'bar', + data: { + labels: labels, + datasets: [{ + label: 'Income', // Name the series + data: income, // Specify the data values array + backgroundColor: '#66aecf', + borderColor: '#66aecf', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Expense', // Name the series + data: expense, // Specify the data values array + backgroundColor: '#6993d6', + borderColor: '#6993d6', + + borderWidth: 1, // Specify bar border width + type: 'bar', // Set this data to a line chart + fill: false + }, + { + label: 'Profit/Loss', // Name the series + data: profit, // Specify the data values array + backgroundColor: '#0bd465', + borderColor: '#0bd465', + + borderWidth: 1, // Specify bar border width + type: 'line', // Set this data to a line chart + fill: false + } + ] + }, + options: { + responsive: true, // Instruct chart js to respond nicely. + maintainAspectRatio: false, // Add to prevent default behaviour of full-width/height + } + }); + + }) + var arg = 'this_month'; + rpc.query({ + model: 'account.move', + method: 'get_overdues_this_month_and_year', + args: [posted, arg], + }).then(function(result) { + + // + }) + var arg = 'this_month'; + rpc.query({ + model: 'account.move', + method: 'get_overdues_this_month_and_year', + args: [posted, arg], + }) + .then(function(result) { + // Doughnut Chart + $(document).ready(function() { + var options = { + // legend: false, + responsive: true, + legend: { + position: 'bottom' + } + }; + if (window.donut != undefined) + window.donut.destroy(); + window.donut = new Chart($("#canvas1"), { + type: 'doughnut', + tooltipFillColor: "rgba(51, 51, 51, 0.55)", + data: { + labels: result.due_partner, + datasets: [{ + data: result.due_amount, + backgroundColor: [ + '#66aecf ', '#6993d6 ', '#666fcf', '#7c66cf', '#9c66cf', + '#bc66cf ', '#b75fcc', ' #cb5fbf ', ' #cc5f7f ', ' #cc6260', + '#cc815f', '#cca15f ', '#ccc25f', '#b9cf66', '#99cf66', + ' #75cb5f ', '#60cc6c', '#804D8000', '#80B33300', '#80CC80CC', '#f2552c', '#00cccc', + '#1f2e2e', '#993333', '#00cca3', '#1a1a00', '#3399ff', + '#8066664D', '#80991AFF', '#808E666FF', '#804DB3FF', '#801AB399', + '#80E666B3', '#8033991A', '#80CC9999', '#80B3B31A', '#8000E680', + '#804D8066', '#80809980', '#80E6FF80', '#801AFF33', '#80999933', + '#80FF3380', '#80CCCC00', '#8066E64D', '#804D80CC', '#809900B3', + '#80E64D66', '#804DB380', '#80FF4D4D', '#8099E6E6', '#806666FF' + ], + hoverBackgroundColor: [ + '#66aecf ', '#6993d6 ', '#666fcf', '#7c66cf', '#9c66cf', + '#bc66cf ', '#b75fcc', ' #cb5fbf ', ' #cc5f7f ', ' #cc6260', + '#cc815f', '#cca15f ', '#ccc25f', '#b9cf66', '#99cf66', + ' #75cb5f ', '#60cc6c', '#804D8000', '#80B33300', '#80CC80CC', '#f2552c', '#00cccc', + '#1f2e2e', '#993333', '#00cca3', '#1a1a00', '#3399ff', + '#8066664D', '#80991AFF', '#808E666FF', '#804DB3FF', '#801AB399', + '#80E666B3', '#8033991A', '#80CC9999', '#80B3B31A', '#8000E680', + '#804D8066', '#80809980', '#80E6FF80', '#801AFF33', '#80999933', + '#80FF3380', '#80CCCC00', '#8066E64D', '#804D80CC', '#809900B3', + '#80E64D66', '#804DB380', '#80FF4D4D', '#8099E6E6', '#806666FF' + ] + }] + }, + options: { + responsive: false + } + }); + }); + }) + rpc.query({ + model: "account.move", + method: "get_total_invoice_current_month", + args: [posted], + }).then(function(result) { + + $('#total_supplier_invoice_paid').hide(); + $('#total_supplier_invoice').hide(); + $('#total_customer_invoice_paid').hide(); + $('#total_customer_invoice').hide(); + $('#tot_invoice').hide(); + $('#tot_supplier_inv').hide(); + + $('#total_supplier_invoice_paid_current_month').empty(); + $('#total_supplier_invoice_current_month').empty(); + $('#total_customer_invoice_paid_current_month').empty(); + $('#total_customer_invoice_current_month').empty(); + $('#tot_invoice_current_month').empty(); + $('#tot_supplier_inv_current_month').empty(); + + $('#total_supplier_invoice_paid_current_year').hide(); + $('#total_supplier_invoice_current_year').hide(); + $('#total_customer_invoice_paid_current_year').hide(); + $('#total_customer_invoice_current_year').hide(); + $('#tot_invoice_current_year').hide(); + $('#tot_supplier_inv_current_year').hide(); + + + $('#total_supplier_invoice_paid_current_month').show(); + $('#total_supplier_invoice_current_month').show(); + $('#total_customer_invoice_paid_current_month').show(); + $('#total_customer_invoice_current_month').show(); + $('#tot_invoice_current_month').show(); + $('#tot_supplier_inv_current_month').show(); + + + var tot_invoice_current_month = result[0][0] + var tot_credit_current_month = result[1][0] + var tot_supplier_inv_current_month = result[2][0] + var tot_supplier_refund_current_month = result[3][0] + var tot_customer_invoice_paid_current_month = result[4][0] + var tot_supplier_invoice_paid_current_month = result[5][0] + var tot_customer_credit_paid_current_month = result[6][0] + var tot_supplier_refund_paid_current_month = result[7][0] + var customer_invoice_total_current_month = (tot_invoice_current_month - tot_credit_current_month).toFixed(2) + var customer_invoice_paid_current_month = (tot_customer_invoice_paid_current_month - tot_customer_credit_paid_current_month).toFixed(2) + var invoice_percentage_current_month = ((customer_invoice_total_current_month / customer_invoice_paid_current_month) * 100).toFixed(2) + var supplier_invoice_total_current_month = (tot_supplier_inv_current_month - tot_supplier_refund_current_month).toFixed(2) + var supplier_invoice_paid_current_month = (tot_supplier_invoice_paid_current_month - tot_supplier_refund_paid_current_month).toFixed(2) + var supplier_percentage_current_month = ((supplier_invoice_total_current_month / supplier_invoice_paid_current_month) * 100).toFixed(2) + + $('#tot_supplier_inv_current_month').attr("value", supplier_invoice_paid_current_month); + $('#tot_supplier_inv_current_month').attr("max", supplier_invoice_total_current_month); + + $('#tot_invoice_current_month').attr("value", customer_invoice_paid_current_month); + $('#tot_invoice_current_month').attr("max", customer_invoice_total_current_month); + currency = result[8] + customer_invoice_paid_current_month = self.format_currency(currency, customer_invoice_paid_current_month); + customer_invoice_total_current_month = self.format_currency(currency, customer_invoice_total_current_month); + supplier_invoice_paid_current_month = self.format_currency(currency, supplier_invoice_paid_current_month); + supplier_invoice_total_current_month = self.format_currency(currency, supplier_invoice_total_current_month); + + $('#total_customer_invoice_paid_current_month').append('<div class="logo">' + '<span>' + customer_invoice_paid_current_month + '</span><span>Total Paid<span></div>'); + $('#total_customer_invoice_current_month').append('<div" class="logo">' + '<span>' + customer_invoice_total_current_month + '</span><span>Total Invoice<span></div>'); + + $('#total_supplier_invoice_paid_current_month').append('<div" class="logo">' + '<span>' + supplier_invoice_paid_current_month + '</span><span>Total Paid<span></div>'); + $('#total_supplier_invoice_current_month').append('<div" class="logo">' + '<span>' + supplier_invoice_total_current_month + '</span><span>Total Invoice<span></div>'); + + }) + var arg = 'last_month' + rpc.query({ + model: 'account.move', + method: 'get_latebillss', + args: [posted, arg], + }) + .then(function(result) { + + $(document).ready(function() { + var options = { + // legend: false, + responsive: true, + legend: { + position: 'bottom' + } + }; + if (window.donuts != undefined) + window.donuts.destroy(); + window.donuts = new Chart($("#horizontalbarChart"), { + type: 'doughnut', + tooltipFillColor: "rgba(51, 51, 51, 0.55)", + data: { + labels: result.bill_partner, + datasets: [{ + data: result.bill_amount, + backgroundColor: [ + '#66aecf ', '#6993d6 ', '#666fcf', '#7c66cf', '#9c66cf', + '#bc66cf ', '#b75fcc', ' #cb5fbf ', ' #cc5f7f ', ' #cc6260', + '#cc815f', '#cca15f ', '#ccc25f', '#b9cf66', '#99cf66', + ' #75cb5f ', '#60cc6c', '#804D8000', '#80B33300', '#80CC80CC', '#f2552c', '#00cccc', + '#1f2e2e', '#993333', '#00cca3', '#1a1a00', '#3399ff', + '#8066664D', '#80991AFF', '#808E666FF', '#804DB3FF', '#801AB399', + '#80E666B3', '#8033991A', '#80CC9999', '#80B3B31A', '#8000E680', + '#804D8066', '#80809980', '#80E6FF80', '#801AFF33', '#80999933', + '#80FF3380', '#80CCCC00', '#8066E64D', '#804D80CC', '#809900B3', + '#80E64D66', '#804DB380', '#80FF4D4D', '#8099E6E6', '#806666FF' + ], + hoverBackgroundColor: [ + '#66aecf ', '#6993d6 ', '#666fcf', '#7c66cf', '#9c66cf', + '#bc66cf ', '#b75fcc', ' #cb5fbf ', ' #cc5f7f ', ' #cc6260', + '#cc815f', '#cca15f ', '#ccc25f', '#b9cf66', '#99cf66', + ' #75cb5f ', '#60cc6c', '#804D8000', '#80B33300', '#80CC80CC', '#f2552c', '#00cccc', + '#1f2e2e', '#993333', '#00cca3', '#1a1a00', '#3399ff', + '#8066664D', '#80991AFF', '#808E666FF', '#804DB3FF', '#801AB399', + '#80E666B3', '#8033991A', '#80CC9999', '#80B3B31A', '#8000E680', + '#804D8066', '#80809980', '#80E6FF80', '#801AFF33', '#80999933', + '#80FF3380', '#80CCCC00', '#8066E64D', '#804D80CC', '#809900B3', + '#80E64D66', '#804DB380', '#80FF4D4D', '#8099E6E6', '#806666FF' + ] + }] + }, + options: { + responsive: false + } + }); + }); + }) + rpc.query({ + model: "account.move", + method: "get_overdues", + + }).then(function(result) { + var due_count = 0; + _.forEach(result, function(x) { + due_count++; + $('#overdues').append('<li><a class="overdue_line_cust" href="#" id="line_' + x.parent + '" data-user-id="' + x.parent + '">' + x.due_partner + '</a>' + ' ' + '<span>' + x.due_amount + ' ' + currency + '</span>' + '</li>'); + + // $('#overdues_amounts').append('<li><a class="overdue_line_cust" href="#" id="line_' + x.parent + '" data-user-id="' + x.parent + '">' + x.amount + '</a>' + '<span>'+' '+currency+ '</span>' + '</li>' ); + + }); + + $('#due_count').append('<span class="badge badge-danger">' + due_count + ' Due(s)</span>'); + }) + var f = 'this_month' + rpc.query({ + model: "account.move", + method: "get_top_10_customers_month", + args: [posted, f] + }).then(function(result) { + var due_count = 0; + var amount; + $('#top_10_customers_this_month').empty(); + + _.forEach(result, function(x) { + $('#top_10_customers_this_month').show(); + due_count++; + amount = self.format_currency(currency, x.amount); + $('#top_10_customers_this_month').append('<li><div id="line_' + x.parent + '" data-user-id="' + x.parent + '">' + x.customers + '</div>' + '<div id="line_' + x.parent + '" data-user-id="' + x.parent + '">' + amount + '</div>' + '</li>'); + $('#line_' + x.parent).on("click", function() { + self.do_action({ + res_model: 'res.partner', + name: _t('Partner'), + views: [ + [false, 'form'] + ], + type: 'ir.actions.act_window', + res_id: x.parent, + }); + }); + + }); + }) + rpc.query({ + model: "account.move", + method: "bank_balance", + args: [posted] + }) + .then(function(result) { + var banks = result['banks']; + var amount; + var balance = result['banking']; + var bnk_ids = result['bank_ids']; + for (var k = 0; k < banks.length; k++) { + amount = self.format_currency(currency, balance[k]); + // $('#charts').append('<li><a ' + banks[k] + '" data-user-id="' + banks[k] + '">' + banks[k] + '</a>'+ ' ' + '<span>'+ balance[k] +'</span>' + '</li>' ); + $('#current_bank_balance').empty() + + $('#current_bank_balance').append('<li><div val="' + bnk_ids[k] + '"id="b_' + bnk_ids[k] + '">' + banks[k] + '</div><div>' + amount + '</div></li>'); + // $('#current_bank_balance').append('<li>' + banks[k] +' '+ balance[k] + '</li>' ); + $('#drop_charts_balance').append('<li>' + balance[k].toFixed(2) + '</li>'); + $('#b_' + bnk_ids[k]).on("click", function(ev) { + self.do_action({ + res_model: 'account.account', + name: _t('Account'), + views: [ + [false, 'form'] + ], + type: 'ir.actions.act_window', + res_id: parseInt(this.id.replace('b_', '')), + }); + }); + } + }) + + rpc.query({ + model: "account.move", + method: "get_latebills", + + }).then(function(result) { + var late_count = 0; + + _.forEach(result, function(x) { + late_count++; + $('#latebills').append('<li><a class="overdue_line_cust" href="#" id="line_' + x.parent + '" data-user-id="' + x.parent + '">' + x.partner + '<span>' + x.amount + ' ' + currency + '</span>' + '</a>' + '</li>'); + }); + $('#late_count').append('<span class="badge badge-danger">' + late_count + ' Late(s)</span>'); + }) + rpc.query({ + model: "account.move", + method: "get_total_invoice", + }) + .then(function(result) { + var total_invoice = result[0].sum; + total_invoice = total_invoice + $('#total_invoice').append('<span>' + total_invoice + ' ' + currency + '</span> ') + }) + rpc.query({ + model: "account.move", + method: "get_total_invoice_this_month", + args: [posted], + }) + .then(function(result) { + var invoice_this_month = result[0].sum; + if (invoice_this_month) { + var total_invoices_this_month = invoice_this_month.toFixed(2) + $('#total_invoices_').append('<span>' + total_invoices_this_month + ' ' + currency + '</span> <div class="title">This month</div>') + } + }) + + rpc.query({ + model: "account.move", + method: "get_total_invoice_last_month", + }) + .then(function(result) { + var invoice_last_month = result[0].sum; + var total_invoices_last_month = invoice_last_month + $('#total_invoices_last').append('<span>' + total_invoices_last_month + ' ' + currency + '</span><div class="title">Last month</div>') + }) + + rpc.query({ + model: "account.move", + method: "unreconcile_items" + }) + .then(function(result) { + + var unreconciled_count = result[0].count; + $('#unreconciled_items').append('<span>' + unreconciled_count + ' Item(s)</a></span> ') + }) + rpc.query({ + model: "account.move", + method: "unreconcile_items_this_month", + args: [posted], + }) + .then(function(result) { + var unreconciled_counts_ = result[0].count; + $('#unreconciled_items_').empty() + + $('#unreconciled_items_').append('<span>' + unreconciled_counts_ + ' Item(s)</span><div class="title">This month</div>') + }) + rpc.query({ + model: "account.move", + method: "unreconcile_items_this_year", + args: [posted], + }) + .then(function(result) { + + var unreconciled_counts_this_year = result[0].count; + $('#unreconciled_counts_this_year').empty() + + $('#unreconciled_counts_this_year').append('<span>' + unreconciled_counts_this_year + ' Item(s)</span><div class="title">This Year</div>') + // $('#unreconciled_counts_this_year').append('<span style= "color:#455e7b;">' + unreconciled_counts_this_year + ' Item(s)</span><div class="title">This Year</div>') + }) + + rpc.query({ + model: "account.move", + method: "unreconcile_items_last_year" + }) + .then(function(result) { + var unreconciled_counts_last_year = result[0].count; + $('#unreconciled_counts_last_year').empty() + + $('#unreconciled_counts_last_year').append('<span>' + unreconciled_counts_last_year + ' Item(s)</span><div class="title">Last Year</div>') + + }) + rpc.query({ + model: "account.move", + method: "month_income" + }) + .then(function(result) { + var income = result[0].debit - result[0].credit; + income = -income; + income = self.format_currency(currency, income); + $('#total_income').append('<span>' + income + '</span>') + }) + rpc.query({ + model: "account.move", + method: "month_income_this_month", + args: [posted], + }) + .then(function(result) { + var incomes_ = result[0].debit - result[0].credit; + if (incomes_) { + incomes_ = -incomes_; + incomes_ = self.format_currency(currency, incomes_); + $('#total_incomes_').empty() + + $('#total_incomes_').append('<span>' + incomes_ + '</span><div class="title">This month</div>') + + } else { + incomes_ = -incomes_; + incomes_ = self.format_currency(currency, incomes_); + $('#total_incomes_').empty() + + $('#total_incomes_').append('<span>' + incomes_ + '</span><div class="title">This month</div>') + } + }) + + rpc.query({ + model: "account.move", + method: "month_income_last_month" + }) + .then(function(result) { + var incomes_last = result[0].debit - result[0].credit; + incomes_last = -incomes_last; + incomes_last = self.format_currency(currency, incomes_last); + $('#total_incomes_last').append('<span>' + incomes_last + '</span><div class="title">Last month</div>') + }) + + rpc.query({ + model: "account.move", + method: "month_expense" + }) + .then(function(result) { + var expense = result[0].debit - result[0].credit; + var expenses = expense; + expenses = self.format_currency(currency, expenses); + + $('#total_expense').append('<span>' + expenses + '</span>') + }) + rpc.query({ + model: "account.move", + method: "month_expense_this_month", + args: [posted], + }).then(function(result) { + var expense_this_month = result[0].debit - result[0].credit; + if (expense_this_month) { + + var expenses_this_month_ = expense_this_month; + expenses_this_month_ = self.format_currency(currency, expenses_this_month_); + $('#total_expenses_').empty() + + $('#total_expenses_').append('<span>' + expenses_this_month_ + '</span><div class="title">This month</div>') + } else { + var expenses_this_month_ = expense_this_month; + expenses_this_month_ = self.format_currency(currency, expenses_this_month_); + $('#total_expenses_').empty() + + $('#total_expenses_').append('<span>' + expenses_this_month_ + '</span><div class="title">This month</div>') + + } + }) + rpc.query({ + model: "account.move", + method: "month_expense_this_year", + args: [posted], + }).then(function(result) { + var expense_this_year = result[0].debit - result[0].credit; + if (expense_this_year) { + + var expenses_this_year_ = expense_this_year; + expenses_this_year_ = self.format_currency(currency, expenses_this_year_); + $('#total_expense_this_year').empty(); + + $('#total_expense_this_year').append('<span >' + expenses_this_year_ + '</span><div class="title">This Year</div>') + } else { + var expenses_this_year_ = expense_this_year; + expenses_this_year_ = self.format_currency(currency, expenses_this_year_); + $('#total_expense_this_year').empty(); + + $('#total_expense_this_year').append('<span >' + expenses_this_year_ + '</span><div class="title">This Year</div>') + } + }) + rpc.query({ + model: "account.move", + method: "month_income_last_year" + }) + .then(function(result) { + var incomes_last_year = result[0].debit - result[0].credit; + incomes_last_year = -incomes_last_year + incomes_last_year = self.format_currency(currency, incomes_last_year); + $('#total_incomes_last_year').empty(); + + $('#total_incomes_last_year').append('<span>' + incomes_last_year + '</span><div class="title">Last Year</div>') + }) + rpc.query({ + model: "account.move", + method: "month_income_this_year", + args: [posted], + }) + .then(function(result) { + var incomes_this_year = result[0].debit - result[0].credit; + if (incomes_this_year) { + incomes_this_year = -incomes_this_year; + incomes_this_year = self.format_currency(currency, incomes_this_year); + $('#total_incomes_this_year').empty(); + + $('#total_incomes_this_year').append('<span>' + incomes_this_year + '</span><div class="title">This Year</div>') + } else { + incomes_this_year = -incomes_this_year; + incomes_this_year = self.format_currency(currency, incomes_this_year); + $('#total_incomes_this_year').empty(); + + $('#total_incomes_this_year').append('<span>' + incomes_this_year + '</span><div class="title">This Year</div>') + } + + }) + + rpc.query({ + model: "account.move", + method: "profit_income_this_month", + args: [posted], + }).then(function(result) { + var net_profit = true + if (result[1] == undefined) { + result[1] = 0; + if ((result[0]) > (result[1])) { + net_profit = result[1] - result[0] + } + + } + + if (result[0] == undefined) { + + result[0] = 0; + } + + if ((-result[1]) > (result[0])) { + net_profit = -result[1] - result[0] + } else if ((result[1]) > (result[0])) { + net_profit = -result[1] - result[0] + } else { + net_profit = -result[1] - result[0] + } + var profit_this_months = net_profit; + if (profit_this_months) { + var net_profit_this_months = profit_this_months; + net_profit_this_months = self.format_currency(currency, net_profit_this_months); + $('#net_profit_current_months').empty(); + // $('#net_profit_current_months').append('<div class="title">Net Profit/Loss </div><span>' + net_profit_this_months + '</span>') + $('#net_profit_current_months').append('<span>' + net_profit_this_months + '</span> <div class="title">This Month</div>') + + } else { + var net_profit_this_months = profit_this_months; + net_profit_this_months = self.format_currency(currency, net_profit_this_months); + $('#net_profit_current_months').empty(); + // $('#net_profit_current_months').append('<div class="title">Net Profit/Loss </div><span>' + net_profit_this_months + '</span>') + $('#net_profit_current_months').append('<span>' + net_profit_this_months + '</span> <div class="title">This Month</div>') + } + }) + + rpc.query({ + model: "account.move", + method: "profit_income_this_year", + args: [posted], + }) + .then(function(result) { + var net_profit = true + + + if (result[1] == undefined) { + result[1] = 0; + if ((result[0]) > (result[1])) { + net_profit = result[1] - result[0] + } + + } + + if (result[0] == undefined) { + + result[0] = 0; + } + + if ((-result[1]) > (result[0])) { + net_profit = -result[1] - result[0] + } else if ((result[1]) > (result[0])) { + net_profit = -result[1] - result[0] + } else { + net_profit = -result[1] - result[0] + } + var profit_this_year = net_profit; + if (profit_this_year) { + var net_profit_this_year = profit_this_year; + net_profit_this_year = self.format_currency(currency, net_profit_this_year); + $('#net_profit_current_year').empty(); + // $('#net_profit_this_year').append('<div class="title">Net Profit/Loss </div><span>' + net_profit_this_year + '</span>') + $('#net_profit_current_year').append('<span>' + net_profit_this_year + '</span> <div class="title">This Year</div>') + } else { + var net_profit_this_year = profit_this_year; + net_profit_this_year = self.format_currency(currency, net_profit_this_year); + $('#net_profit_current_year').empty(); + // $('#net_profit_this_year').append('<div class="title">Net Profit/Loss </div><span>' + net_profit_this_year + '</span>') + $('#net_profit_current_year').append('<span>' + net_profit_this_year + '</span> <div class="title">This Year</div>') + + } + }) + }); + }, + + format_currency: function(currency, amount) { + if (typeof(amount) != 'number') { + amount = parseFloat(amount); + } + var formatted_value = (parseInt(amount)).toLocaleString(currency.language, { + minimumFractionDigits: 2 + }) + if (currency.position === "after") { + return formatted_value += ' ' + currency.symbol; + } else { + return currency.symbol + ' ' + formatted_value; + } + }, + + willStart: function() { + var self = this; + self.drpdn_show = false; + return Promise.all([ajax.loadLibs(this), this._super()]); + }, + }); + core.action_registry.add('invoice_dashboard', ActionMenu); + +});
\ No newline at end of file |