~serpentcs/openobject-addons/trunk-webkit-reports-addons

# -*- coding: utf-8 -*-

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

#

#    OpenERP, Open Source Management Solution

#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).

#

#    This program is free software: you can redistribute it and/or modify

#    it under the terms of the GNU Affero General Public License as

#    published by the Free Software Foundation, either version 3 of the

#    License, or (at your option) any later version.

#

#    This program is distributed in the hope that it will be useful,

#    but WITHOUT ANY WARRANTY; without even the implied warranty of

#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

#    GNU Affero General Public License for more details.

#

#    You should have received a copy of the GNU Affero General Public License

#    along with this program.  If not, see <http://www.gnu.org/licenses/>.

#

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

 

from openerp.report import report_sxw

from openerp.addons.report_webkit.webkit_report import WebKitParser

class account_analytic_profit(report_sxw.rml_parse):

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

        super(account_analytic_profit, self).__init__(cr, uid, name, context=context)

        self.localcontext.update({

            'lines': self._lines,

            'user_ids': self._user_ids,

            'journal_ids': self._journal_ids,

            'line': self._line,

            

        })

    def _user_ids(self, lines):

        user_obj = self.pool['res.users']

        ids=list(set([b.user_id.id for b in lines]))

        return user_obj.browse(self.cr, self.uid, ids)

 

    def _journal_ids(self, form, user_id):

        line_obj = self.pool['account.analytic.line']

        journal_obj = self.pool['account.analytic.journal']

        line_ids=line_obj.search(self.cr, self.uid, [

            ('date', '>=', form['date_from']),

            ('date', '<=', form['date_to']),

            ('journal_id', 'in', form['journal_ids'][0][2]),

            ('user_id', '=', user_id),

            ])

        ids=list(set([b.journal_id.id for b in line_obj.browse(self.cr, self.uid, line_ids)]))

        return journal_obj.browse(self.cr, self.uid, ids)

 

    def _line(self, form, journal_ids, user_ids):

        line_obj = self.pool['account.analytic.line']

        product_obj = self.pool['product.product']

        price_obj = self.pool['product.pricelist']

        ids=line_obj.search(self.cr, self.uid, [

                ('date', '>=', form['date_from']),

                ('date', '<=', form['date_to']),

                ('journal_id', 'in', journal_ids),

                ('user_id', 'in', user_ids),

                ])

        res={}

        for line in line_obj.browse(self.cr, self.uid, ids):

            if line.account_id.pricelist_id:

                if line.account_id.to_invoice:

                    if line.to_invoice:

                        id=line.to_invoice.id

                        name=line.to_invoice.name

                        discount=line.to_invoice.factor

                    else:

                        name="/"

                        discount=1.0

                        id = -1

                else:

                    name="Fixed"

                    discount=0.0

                    id=0

                pl=line.account_id.pricelist_id.id

                price=price_obj.price_get(self.cr, self.uid, [pl], line.product_id.id, line.unit_amount or 1.0, line.account_id.partner_id.id)[pl]

            else:

                name="/"

                discount=1.0

                id = -1

                price=0.0

            if id not in res:

                res[id]={'name': name, 'amount': 0, 'cost':0, 'unit_amount':0,'amount_th':0}

            xxx = round(price * line.unit_amount * (1-(discount or 0.0)), 2)

            res[id]['amount_th']+=xxx

            if line.invoice_id:

                self.cr.execute('select id from account_analytic_line where invoice_id=%s', (line.invoice_id.id,))

                tot = 0

                for lid in self.cr.fetchall():

                    lid2 = line_obj.browse(self.cr, self.uid, lid[0])

                    pl=lid2.account_id.pricelist_id.id

                    price=price_obj.price_get(self.cr, self.uid, [pl], lid2.product_id.id, lid2.unit_amount or 1.0, lid2.account_id.partner_id.id)[pl]

                    tot += price * lid2.unit_amount * (1-(discount or 0.0))

                if tot:

                    procent = line.invoice_id.amount_untaxed / tot

                    res[id]['amount'] +=  xxx * procent

                else:

                    res[id]['amount'] += xxx

            else:

                res[id]['amount'] += xxx

            res[id]['cost']+=line.amount

            res[id]['unit_amount']+=line.unit_amount

        for id in res:

            res[id]['profit']=res[id]['amount']+res[id]['cost']

            res[id]['eff']=res[id]['cost'] and '%d' % (-res[id]['amount'] / res[id]['cost'] * 100,) or 0.0

        return res.values()

 

    def _lines(self, form):

        line_obj = self.pool['account.analytic.line']

        ids=line_obj.search(self.cr, self.uid, [

            ('date', '>=', form['date_from']),

            ('date', '<=', form['date_to']),

            ('journal_id', 'in', form['journal_ids'][0][2]),

            ('user_id', 'in', form['employee_ids'][0][2]),

            ])

        return line_obj.browse(self.cr, self.uid, ids)

 

WebKitParser('report.account.analytic.profit', 'account.analytic.line', 'addons/hr_timesheet_invoice/report/account_analytic_profit.mako', parser=account_analytic_profit)

 

# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: