~openerp-community/openobject-addons/taktik

import time

from report import report_sxw

import pooler

 

class entry(report_sxw.rml_parse):

 

    def __init__(self, cr, uid, name, context):

        super(entry, self).__init__(cr, uid, name, context)

        user = pooler.get_pool(cr.dbname).get('res.users').browse(cr, uid, uid)

        self.sums = None;

        self.start_balance = None;

        self.localcontext.update({

            'time': time,

            'user': user,

            'get_start_balance' : self._get_start_balance,

            'get_sums' : self._get_sums,

        })

        

    def preprocess(self, objects, data, ids):

        super(entry, self).preprocess(objects, data, ids)

        self.cr.commit()

        self.localcontext['data'] = data

        #Add all entries between the 2 dates

        start = data['form']['date_start']

        stop = data['form']['date_stop']

        entry_obj = self.pool.get('pos.cash_entry')

        result = entry_obj.search(self.cr,self.uid,[('date','>=',start),('date','<=',stop)])

        entries = entry_obj.browse(self.cr,self.uid,result)

        self.localcontext['entries'] = entries

        

    def _get_start_balance(self):

        start = self.localcontext['data']['form']['date_start']

        entry_obj = self.pool.get('pos.cash_entry');

        result = entry_obj.search(self.cr,self.uid,[('date','<',start)])

        entries = entry_obj.browse(self.cr,self.uid,result)

        sum_debit=0

        sum_credit=0

        for e in entries:

            sum_debit = sum_debit + e['debit']

            sum_credit = sum_credit + e['credit']

        self.start_balance = sum_credit - sum_debit

        return sum_credit-sum_debit         

 

    def _get_sums(self):

        #returns [sum credit,sum debit,cumulative total,new balance]

        sum_debit=0

        sum_credit=0

        if not self.sums :  

            start = self.localcontext['data']['form']['date_start']

            stop = self.localcontext['data']['form']['date_stop']

            entry_obj = self.pool.get('pos.cash_entry');

            result = entry_obj.search(self.cr,self.uid,[('date','>=',start),('date','<=',stop)])

            entries = entry_obj.browse(self.cr,self.uid,result)

            for e in entries:

                sum_debit = sum_debit + e['debit']

                sum_credit = sum_credit + e['credit']

        else:

            sum_credit = self.sums[0];

            sum_debit = self.sums[1];

        return [sum_credit,sum_debit,self.start_balance+sum_credit,self.start_balance+sum_credit-sum_debit]         

 

 

report_sxw.report_sxw('report.pos.entry', 'pos.cash_entry', 'addons/point_of_sale/report/pos_entry.rml', parser=entry, header=False)