initial commit

1 files changed, 387 insertions, 0 deletions

diff --git a/dynamic_accounts_report/static/src/js/daybook.js b/dynamic_accounts_report/static/src/js/daybook.js
new file mode 100644
index 0000000..47d98c1
--- /dev/null
+++ b/dynamic_accounts_report/static/src/js/daybook.js
@@ -0,0 +1,387 @@
+odoo.define('dynamic_partner_daybook.daybook', function (require) {
+    'use strict';
+    var AbstractAction = require('web.AbstractAction');
+    var core = require('web.core');
+    var field_utils = require('web.field_utils');
+    var rpc = require('web.rpc');
+    var session = require('web.session');
+    var utils = require('web.utils');
+    var QWeb = core.qweb;
+    var _t = core._t;
+
+    window.click_num = 0;
+    var DayBook = AbstractAction.extend({
+    template: 'DaybookTemp',
+        events: {
+            'click .parent-line': 'journal_line_click',
+            'click .child_col1': 'journal_line_click',
+            'click #apply_filter': 'apply_filter',
+            'click #pdf': 'print_pdf',
+            'click #xlsx': 'print_xlsx',
+            'click .db-line': 'show_drop_down',
+            'click .view-account-move': 'view_acc_move',
+        },
+
+        init: function(parent, action) {
+        this._super(parent, action);
+                this.currency=action.currency;
+                this.report_lines = action.report_lines;
+                this.wizard_id = action.context.wizard | null;
+            },
+
+
+          start: function() {
+            var self = this;
+            self.initial_render = true;
+            rpc.query({
+                model: 'account.day.book',
+                method: 'create',
+                args: [{
+
+                }]
+            }).then(function(t_res) {
+                self.wizard_id = t_res;
+                self.load_data(self.initial_render);
+            })
+        },
+
+
+        load_data: function (initial_render = true) {
+            var self = this;
+                self.$(".categ").empty();
+                try{
+                    var self = this;
+                    self._rpc({
+                        model: 'account.day.book',
+                        method: 'view_report',
+                        args: [[this.wizard_id]],
+                    }).then(function(datas) {
+                     _.each(datas['report_lines'], function(rep_lines) {
+                            rep_lines.debit = self.format_currency(datas['currency'],rep_lines.debit);
+                            rep_lines.credit = self.format_currency(datas['currency'],rep_lines.credit);
+                            rep_lines.balance = self.format_currency(datas['currency'],rep_lines.balance);
+
+                            });
+
+                            if (initial_render) {
+
+                                    self.$('.filter_view_db').html(QWeb.render('DayFilterView', {
+                                        filter_data: datas['filters'],
+                                    }));
+                                    self.$el.find('.journals').select2({
+                                        placeholder: ' Journals...',
+                                    });
+                                    self.$el.find('.account').select2({
+                                        placeholder: ' Accounts...',
+                                    });
+                                    self.$el.find('.target_move').select2({
+                                        placeholder: 'Target Move...',
+                                    });
+
+
+                            }
+                            var child=[];
+
+                        self.$('.table_view_db').html(QWeb.render('Daytable', {
+
+                                            report_lines : datas['report_lines'],
+                                            filter : datas['filters'],
+                                            currency : datas['currency'],
+                                        }));
+
+                });
+
+                    }
+                catch (el) {
+                    window.location.href
+                    }
+            },
+
+
+            format_currency: function(currency, amount) {
+                if (typeof(amount) != 'number') {
+                    amount = parseFloat(amount);
+                }
+                var formatted_value = (parseInt(amount)).toLocaleString(currency[2],{
+                    minimumFractionDigits: 2
+                })
+                return formatted_value
+            },
+
+            print_pdf: function(e) {
+            e.preventDefault();
+
+            var self = this;
+            self._rpc({
+                model: 'account.day.book',
+                method: 'view_report',
+                args: [
+                    [self.wizard_id]
+                ],
+            }).then(function(data) {
+
+                var action = {
+                    'type': 'ir.actions.report',
+                    'report_type': 'qweb-pdf',
+                    'report_name': 'dynamic_accounts_report.day_book',
+                    'report_file': 'dynamic_accounts_report.day_book',
+                    'data': {
+                        'report_data': data
+                    },
+                    'context': {
+                        'active_model': 'account.day.book',
+                        'landscape': 1,
+                        'daybook_pdf_report': true
+                    },
+                    'display_name': 'Day Book',
+                };
+
+                return self.do_action(action);
+            });
+        },
+
+        print_xlsx: function() {
+            var self = this;
+            self._rpc({
+                model: 'account.day.book',
+                method: 'view_report',
+                args: [
+                    [self.wizard_id]
+                ],
+            }).then(function(data) {
+
+                var action = {
+                    'type': 'ir_actions_dynamic_xlsx_download',
+                    'data': {
+                         'model': 'account.day.book',
+                         'options': JSON.stringify(data['filters']),
+                         'output_format': 'xlsx',
+                         'report_data': JSON.stringify(data['report_lines']),
+                         'report_name': 'Day Book',
+                         'dfr_data': JSON.stringify(data),
+                    },
+                };
+                return self.do_action(action);
+            });
+        },
+
+        create_lines_with_style: function(rec, attr, datas) {
+
+            var temp_str = "";
+            var style_name = "border-bottom: 1px solid #e6e6e6;";
+            var attr_name = attr + " style="+style_name;
+            temp_str += "<td  class='child_col1' "+attr_name+" >"+rec['code'] +rec['name'] +"</td>";
+            if(datas.currency[1]=='after'){
+            temp_str += "<td  class='child_col2' "+attr_name+" >"+rec['debit'].toFixed(2)+datas.currency[0]+"</td>";
+            temp_str += "<td  class='child_col3' "+attr_name+" >"+rec['credit'].toFixed(2) +datas.currency[0]+ "</td>";
+            }
+            else{
+            temp_str += "<td  class='child_col2' "+attr_name+" >"+datas.currency[0]+rec['debit'].toFixed(2) + "</td>";
+            temp_str += "<td  class='child_col3' "+attr_name+">"+datas.currency[0]+rec['credit'].toFixed(2) + "</td>";
+            }
+            return temp_str;
+        },
+
+
+        journal_line_click: function (el){
+            click_num++;
+            var self = this;
+            var line = $(el.target).parent().data('id');
+            return self.do_action({
+                type: 'ir.actions.act_window',
+                    view_type: 'form',
+                    view_mode: 'form',
+                    res_model: 'account.move',
+                    views: [
+                        [false, 'form']
+                    ],
+                    res_id: line,
+                    target: 'current',
+            });
+
+        },
+
+        show_drop_down: function(event) {
+            event.preventDefault();
+            var self = this;
+            var account_id = $(event.currentTarget).data('account-id');
+            var offset = 0;
+            var td = $(event.currentTarget).next('tr').find('td');
+            if (td.length == 1) {
+
+                    self._rpc({
+                        model: 'account.day.book',
+                        method: 'view_report',
+                        args: [
+                            [self.wizard_id]
+                        ],
+                    }).then(function(data) {
+                    _.each(data['report_lines'], function(rep_lines) {
+                            _.each(rep_lines['child_lines'], function(move_line) {
+
+                             move_line.debit = self.format_currency(data['currency'],move_line.debit);
+                            move_line.credit = self.format_currency(data['currency'],move_line.credit);
+                            move_line.balance = self.format_currency(data['currency'],move_line.balance);
+
+
+                             });
+                             });
+                    for (var i = 0; i < data['report_lines'].length; i++) {
+
+                    if (account_id == data['report_lines'][i]['id'] ){
+                    $(event.currentTarget).next('tr').find('td .db-table-div').remove();
+                    $(event.currentTarget).next('tr').find('td ul').after(
+                        QWeb.render('SubSectiondb', {
+
+                            account_data: data['report_lines'][i]['child_lines'],
+                            currency_symbol : data.currency[0],
+                            currency_position : data.currency[1],
+                        }))
+
+                    $(event.currentTarget).next('tr').find('td ul li:first a').css({
+                        'background-color': '#00ede8',
+                        'font-weight': 'bold',
+                    });
+                     }
+                    }
+
+                    });
+            }
+        },
+
+       view_acc_move: function(event) {
+
+            event.preventDefault();
+            var self = this;
+            var context = {};
+            var show_acc_move = function(res_model, res_id, view_id) {
+                var action = {
+                    type: 'ir.actions.act_window',
+                    view_type: 'form',
+                    view_mode: 'form',
+                    res_model: res_model,
+                    views: [
+                        [view_id || false, 'form']
+                    ],
+                    res_id: res_id,
+                    target: 'current',
+                    context: context,
+                };
+                return self.do_action(action);
+            };
+            rpc.query({
+                    model: 'account.move',
+                    method: 'search_read',
+                    domain: [
+                        ['id', '=', $(event.currentTarget).data('move-id')]
+                    ],
+                    fields: ['id'],
+                    limit: 1,
+                })
+                .then(function(record) {
+
+                    if (record.length > 0) {
+                        show_acc_move('account.move', record[0].id);
+                    } else {
+                        show_acc_move('account.move', $(event.currentTarget).data('move-id'));
+                    }
+                });
+        },
+
+
+        apply_filter: function(event) {
+
+            event.preventDefault();
+            var self = this;
+            self.initial_render = false;
+
+            var filter_data_selected = {};
+
+
+            var account_ids = [];
+            var account_text = [];
+
+            var account_res = document.getElementById("acc_res")
+
+            var account_list = $(".account").select2('data')
+            for (var i = 0; i < account_list.length; i++) {
+                if(account_list[i].element[0].selected === true){
+
+                    account_ids.push(parseInt(account_list[i].id))
+                    if(account_text.includes(account_list[i].text) === false){
+                        account_text.push(account_list[i].text)
+                    }
+                    account_res.value = account_text
+                    account_res.innerHTML=account_res.value;
+                }
+            }
+            if (account_list.length == 0){
+               account_res.value = ""
+                    account_res.innerHTML="";
+
+            }
+
+            filter_data_selected.account_ids = account_ids
+
+
+
+             var journal_ids = [];
+            var journal_text = [];
+            var journal_res = document.getElementById("journal_res")
+            var journal_list = $(".journals").select2('data')
+            for (var i = 0; i < journal_list.length; i++) {
+                if(journal_list[i].element[0].selected === true){
+
+                    journal_ids.push(parseInt(journal_list[i].id))
+                    if(journal_text.includes(journal_list[i].text) === false){
+                        journal_text.push(journal_list[i].text)
+                    }
+                    journal_res.value = journal_text
+                    journal_res.innerHTML=journal_res.value;
+                }
+            }
+            if (journal_list.length == 0){
+               journal_res.value = ""
+                    journal_res.innerHTML="";
+
+            }
+            filter_data_selected.journal_ids = journal_ids
+
+            if ($("#date_from").val()) {
+                var dateString = $("#date_from").val();
+
+                filter_data_selected.date_from = dateString;
+            }
+            if ($("#date_to").val()) {
+                var dateString = $("#date_to").val();
+                filter_data_selected.date_to = dateString;
+            }
+
+            if ($(".target_move").length) {
+
+            var post_res = document.getElementById("post_res")
+            filter_data_selected.target_move = $(".target_move")[1].value
+            post_res.value = $(".target_move")[1].value
+                    post_res.innerHTML=post_res.value;
+              if ($(".target_move")[1].value == "") {
+              post_res.innerHTML="posted";
+
+              }
+            }
+
+            rpc.query({
+                model: 'account.day.book',
+                method: 'write',
+                args: [
+                    self.wizard_id, filter_data_selected
+                ],
+            }).then(function(res) {
+            self.initial_render = false;
+                self.load_data(self.initial_render);
+            });
+        },
+
+    });
+    core.action_registry.add("d_b", DayBook);
+    return DayBook;
+});