~camptocamp/account-financial-report/7.0-fix-1253659

import pdb

from openerp.tools.safe_eval import safe_eval as eval

        all_account_ids = _get_children_and_consol(

            self.cr, self.uid, account_ids, 100, self.context)

            tot_bal1 = 0.0

            tot_bal2 = 0.0

            tot_bal3 = 0.0

            tot_bal4 = 0.0

            tot_bal5 = 0.0

        ###############################################################

        # Calculations of credit, debit and balance, 

        # without repeating operations.

        ###############################################################

 

        account_black_ids = account_obj.search(self.cr, self.uid, (

                                               [('id', 'in', [i[0] for i in all_account_ids]),

                                                ('type', 'not in',

                                                ('view', 'consolidation'))]))

 

        account_not_black_ids = account_obj.search(self.cr, self.uid, ([('id', 'in', [

                                                   i[0] for i in all_account_ids]), ('type', 'in', ('view', 'consolidation'))]))

 

        # This could be done quickly with a sql sentence

        account_not_black = account_obj.browse(

            self.cr, self.uid, account_not_black_ids)

        account_not_black.sort(key=lambda x: x.level)

        account_not_black.reverse()

        account_not_black_ids = [i.id for i in account_not_black]

 

        all_account_period = {}  # All accounts per period 

        

        # Iteration limit depending on the number of columns

        if form['columns'] == 'thirteen':

            limit = 13

        elif form['columns'] == 'qtr':

            limit = 5

        else:

            limit = 1

 

        for p_act in range(limit):

            if limit != 1:

                if p_act == limit-1:

                    form['periods'] = period_ids

                else:

                    if form['columns'] == 'thirteen':

                        form['periods'] = [period_ids[p_act]]

                    elif form['columns'] == 'qtr':

                        form['periods'] = p[p_act]

 

            if form['inf_type'] == 'IS':

                ctx_to_use = _ctx_end(self.context.copy())

            else:

                ctx_i = _ctx_init(self.context.copy())

                ctx_to_use = _ctx_end(self.context.copy())

 

            account_black = account_obj.browse(

                self.cr, self.uid, account_black_ids, ctx_to_use)

 

            if form['inf_type'] == 'BS':

                account_black_init = account_obj.browse(

                    self.cr, self.uid, account_black_ids, ctx_i)

 

            #~ Black

            dict_black = {}

            for i in account_black:

                d = i.debit

                c = i.credit

                dict_black[i.id] = {

                    'obj': i,

                    'debit': d,

                    'credit': c,

                    'balance': d-c

                }

                if form['inf_type'] == 'BS':

                    dict_black.get(i.id)['balanceinit'] = 0.0

 

            # If the report is a balance sheet

            # Balanceinit values are added to the dictionary

            if form['inf_type'] == 'BS':

                for i in account_black_init:

                    dict_black.get(i.id)['balanceinit'] = i.balance

 

            #~ Not black

            dict_not_black = {}

            for i in account_not_black:

                dict_not_black[i.id] = {

                    'obj': i, 'debit': 0.0, 'credit': 0.0, 'balance': 0.0}

                if form['inf_type'] == 'BS':

                    dict_not_black.get(i.id)['balanceinit'] = 0.0

 

            all_account = dict_black.copy(

            )  #It makes a copy because they modify 

 

            for acc_id in account_not_black_ids:

                acc_childs = dict_not_black.get(acc_id).get('obj').child_id

                for child_id in acc_childs:

                    dict_not_black.get(acc_id)['debit'] += all_account.get(

                        child_id.id).get('debit')

                    dict_not_black.get(acc_id)['credit'] += all_account.get(

                        child_id.id).get('credit')

                    dict_not_black.get(acc_id)['balance'] += all_account.get(

                        child_id.id).get('balance')

                    if form['inf_type'] == 'BS':

                        dict_not_black.get(acc_id)['balanceinit'] += all_account.get(

                            child_id.id).get('balanceinit')

                all_account[acc_id] = dict_not_black[acc_id]

 

            if p_act == limit-1:

                all_account_period['all'] = all_account

            else:

                if form['columns'] == 'thirteen':

                    all_account_period[p_act] = all_account

                elif form['columns'] == 'qtr':

                    all_account_period[p_act] = all_account

 

        ###############################################################

        # End of the calculations of credit, debit and balance

        #

        ###############################################################

 

                    for pn in range(1, 5):

                                          all_account_period.get(pn-1).get(id).get('debit', 0.0), all_account_period.get(pn-1).get(id).get('credit', 0.0), all_account_period.get(pn-1).get(id).get('balance', 0.0)])

                                          all_account_period.get(pn-1).get(id).get('balanceinit', 0.0), all_account_period.get(pn-1).get(id).get('debit', 0.0), all_account_period.get(pn-1).get(id).get('credit', 0.0)])

                                      all_account_period.get('all').get(id).get('debit', 0.0), all_account_period.get('all').get(id).get('credit',0.0), all_account_period.get('all').get(id).get('balance')])

                                      all_account_period.get('all').get(id).get('balanceinit', 0.0), all_account_period.get('all').get(id).get('debit', 0.0), all_account_period.get('all').get(id).get('credit',0.0)])

                    for p_num in range(12):

                                          all_account_period.get(p_num).get(id).get('debit', 0.0), all_account_period.get(p_num).get(id).get('credit', 0.0), all_account_period.get(p_num).get(id).get('balance', 0.0)])

                                          all_account_period.get(p_num).get(id).get('balanceinit', 0.0), all_account_period.get(p_num).get(id).get('debit', 0.0), all_account_period.get(p_num).get(id).get('credit', 0.0)])

                                      all_account_period.get('all').get(id).get('debit', 0.0), all_account_period.get('all').get(id).get('credit', 0.0), all_account_period.get('all').get(id).get('balance', 0.0)])

                                      all_account_period.get('all').get(id).get('balanceinit', 0.0), all_account_period.get('all').get(id).get('debit', 0.0), all_account_period.get('all').get(id).get('credit', 0.0)])

                                  all_account_period.get('all').get(id).get('balanceinit', 0.0), all_account_period.get('all').get(id).get('debit', 0.0), all_account_period.get('all').get(id).get('credit', 0.0)])

                            bal1=z(tot_bal1),

                            bal2=z(tot_bal2),

                            bal3=z(tot_bal3),

                            bal4=z(tot_bal4),

                            bal5=z(tot_bal5),))

                            bal1=z(tot_bal1),

                            bal2=z(tot_bal2),

                            bal3=z(tot_bal3),

                            bal4=z(tot_bal4),

                            bal5=z(tot_bal5),

                            bal6=z(tot_bal6),

                            bal7=z(tot_bal7),

                            bal8=z(tot_bal8),

                            bal9=z(tot_bal9),

                            bal10=z(tot_bal10),

                            bal11=z(tot_bal11),

                            bal12=z(tot_bal12),

                            bal13=z(tot_bal13),))