addons/mrp/report/price.py

   1 # -*- coding: utf-8 -*-
   2 ##############################################################################
   3 #
   4 #    OpenERP, Open Source Management Solution
   5 #    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
   6 #
   7 #    This program is free software: you can redistribute it and/or modify
   8 #    it under the terms of the GNU Affero General Public License as
   9 #    published by the Free Software Foundation, either version 3 of the
  10 #    License, or (at your option) any later version.
  11 #
  12 #    This program is distributed in the hope that it will be useful,
  13 #    but WITHOUT ANY WARRANTY; without even the implied warranty of
  14 #    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15 #    GNU Affero General Public License for more details.
  16 #
  17 #    You should have received a copy of the GNU Affero General Public License
  18 #    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  19 #
  20 ##############################################################################
  21 import time
  22 import ir
  23 import pooler
  24 from report.interface import report_rml
  25 from report.interface import toxml
  26
  27 from tools.translate import _
  28
  29
  30 #FIXME: we should use toxml
  31 class report_custom(report_rml):
  32     def create_xml(self, cr, uid, ids, datas, context={}):
  33         number = (datas.get('form', False) and datas['form']['number']) or 1
  34         pool = pooler.get_pool(cr.dbname)
  35         product_pool = pool.get('product.product')
  36         product_uom_pool = pool.get('product.uom')
  37         supplier_info_pool = pool.get('product.supplierinfo')
  38         workcenter_pool = pool.get('mrp.workcenter')
  39         user_pool = pool.get('res.users')
  40         bom_pool = pool.get('mrp.bom')
  41         def process_bom(bom, currency_id, factor=1):
  42             xml = '<row>'
  43             sum = 0
  44             sum_strd = 0
  45             prod = product_pool.browse(cr, uid, bom['product_id'])
  46
  47             prod_name = bom['name']
  48             prod_qtty = factor * bom['product_qty']
  49             product_uom = product_uom_pool.browse(cr, uid, bom['product_uom'], context=context)
  50             level = 1
  51             main_sp_price, main_sp_name , main_strd_price = '','',''
  52             sellers, sellers_price = '',''
  53
  54             if prod.seller_id:
  55                 main_sp_name = "<b>%s</b>\r\n" %(prod.seller_id.name)
  56                 price = supplier_info_pool.price_get(cr, uid, prod.seller_id.id, prod.id, number*prod_qtty)[prod.seller_id.id]
  57                 price = product_uom_pool._compute_price(cr, uid, prod.uom_id.id, price, to_uom_id=product_uom.id)
  58                 main_sp_price = '<b>%.2f</b>\r\n' %(price)
  59                 sum += prod_qtty*price
  60             std_price = product_uom_pool._compute_price(cr, uid, prod.uom_id.id, prod.standard_price, to_uom_id=product_uom.id)
  61             main_strd_price = str(std_price) + '\r\n'
  62             sum_strd = prod_qtty*std_price
  63             for seller_id in prod.seller_ids:
  64                 sellers +=  '- <i>'+ seller_id.name.name +'</i>\r\n'
  65                 price = supplier_info_pool.price_get(cr, uid, seller_id.name.id, prod.id, number*prod_qtty)[seller_id.name.id]
  66                 price = product_uom_pool._compute_price(cr, uid, prod.uom_id.id, price, to_uom_id=product_uom.id)
  67                 sellers_price += """<i>%.2f</i>\r\n"""%(price)
  68             xml += """<col para='yes'> %s </col>
  69                     <col para='yes'> %s </col>
  70                     <col f='yes'>%.2f</col>
  71                     <col f='yes'>%s</col>
  72                     <col f='yes'>%.2f</col>
  73                     <col f='yes'>%s</col>'"""%(prod_name,main_sp_name +  sellers ,prod_qtty, product_uom.name,float(main_strd_price),main_sp_price + sellers_price)
  74
  75             xml += '</row>'
  76             return xml, sum, sum_strd
  77
  78         def process_workcenter(wrk):
  79             workcenter = workcenter_pool.browse(cr, uid, wrk['workcenter_id'])
  80             cost_cycle = wrk['cycle']*workcenter.costs_cycle
  81             cost_hour = wrk['hour']*workcenter.costs_hour
  82             total = cost_cycle + cost_hour
  83             xml = '<row>'
  84             xml += "<col para='yes'>" + workcenter.name + '</col>'
  85             xml += "<col/>"
  86             xml += "<col/>"
  87             xml += """<col f='yes'>%.2f</col>"""%(cost_cycle)
  88             xml += """<col f='yes'>%.2f</col>"""%(cost_hour)
  89             xml += """<col f='yes'>%.2f</col>"""%(cost_hour + cost_cycle)
  90             xml += '</row>'
  91
  92             return xml, total
  93
  94
  95         xml = ''
  96         config_start = """
  97         <config>
  98             <date>%s</date>
  99             <company>%s</company>
 100             <PageSize>210.00mm,297.00mm</PageSize>
 101             <PageWidth>595.27</PageWidth>
 102             <PageHeight>841.88</PageHeight>
 103             <tableSize>55.00mm,55.00mm, 20.00mm, 22.00mm, 22.00mm, 25.00mm</tableSize>
 104             """ % (time.strftime('%m/%d/%Y %H:%M'),user_pool.browse(cr, uid, uid).company_id.name)
 105         config_stop = """
 106             <report-footer>Generated by OpenERP</report-footer>
 107         </config>
 108         """
 109
 110         workcenter_header = """
 111             <lines style='header'>
 112                 <row>
 113                     <col>%s</col>
 114                     <col/>
 115                     <col t='yes'/>
 116                     <col t='yes'>%s</col>
 117                     <col t='yes'>%s</col>
 118                     <col t='yes'>%s</col>
 119                 </row>
 120             </lines>
 121         """ % (_('Work Center name'), _('Cycles Cost'), _('Hourly Cost'),_('Work Cost'))
 122         prod_header = """
 123                 <row>
 124                     <col>%s</col>
 125                     <col>%s</col>
 126                     <col t='yes'>%s</col>
 127                     <col t='yes'>%s</col>
 128                     <col t='yes'>%s</col>
 129                     <col t='yes'>%s</col>
 130                 </row>
 131         """ % (_('Component'), _('Component suppliers'), _('Quantity'), _('Uom'), _('Cost Price per Uom'), _('Supplier Price per Uom'))
 132
 133         company_currency = user_pool.browse(cr, uid, uid).company_id.currency_id.id
 134         for product in product_pool.browse(cr, uid, ids, context=context):
 135             bom_id = bom_pool._bom_find(cr, uid, product.id, product.uom_id.id)
 136             title = "<title>%s</title>" %(_("Cost Structure"))
 137             title += "<title>%s</title>" %product.name
 138             xml += "<lines style='header'>" + title + prod_header + "</lines>"
 139             if not bom_id:
 140                 total_strd = number * product.standard_price
 141                 total = number * product_pool.price_get(cr, uid, [product.id], 'standard_price')[product.id]
 142                 xml += """<lines style='lines'><row>
 143                     <col para='yes'>-</col>
 144                     <col para='yes'>-</col>
 145                     <col para='yes'>-</col>
 146                     <col para='yes'>-</col>
 147                     <col para='yes'>-</col>
 148                     <col para='yes'>-</col>
 149                     </row></lines>"""
 150                 xml += """<lines style='total'> <row>
 151                     <col>%s %s %s %s : </col>
 152                     <col/>
 153                     <col/>
 154                     <col f='yes'/>
 155                     <col f='yes'>%.2f</col>
 156                     <col f='yes'>%.2f</col>
 157                     </row></lines>'"""%(_('Total Cost'), _('of'), str(number), product.uom_id.name, total_strd, total)
 158             else:
 159                 bom = bom_pool.browse(cr, uid, bom_id, context=context)
 160                 factor = number * product.uom_id.factor / bom.product_uom.factor
 161                 sub_boms = bom_pool._bom_explode(cr, uid, bom, factor / bom.product_qty)
 162                 total = 0
 163                 total_strd = 0
 164                 parent_bom = {
 165                         'product_qty': bom.product_qty,
 166                         'name': bom.product_id.name,
 167                         'product_uom': bom.product_uom.id,
 168                         'product_id': bom.product_id.id
 169                 }
 170                 xml_tmp = ''
 171                 for sub_bom in (sub_boms and sub_boms[0]) or [parent_bom]:
 172                     txt, sum, sum_strd = process_bom(sub_bom, company_currency)
 173                     xml_tmp +=  txt
 174                     total += sum
 175                     total_strd += sum_strd
 176
 177                 xml += "<lines style='lines'>" + xml_tmp + '</lines>'
 178                 xml += """<lines style='sub_total'> <row>
 179                     <col>%s %s %s %s : </col>
 180                     <col/>
 181                     <col/>
 182                     <col t='yes'/>
 183                     <col t='yes'>%.2f</col>
 184                     <col t='yes'>%.2f</col>
 185                     </row></lines>'"""%(_('Cost'), _('of'), str(number), product.uom_id.name, total_strd, total)
 186
 187                 total2 = 0
 188                 xml_tmp = ''
 189                 for wrk in (sub_boms and sub_boms[1]):
 190                     txt, sum = process_workcenter(wrk)
 191                     xml_tmp += txt
 192                     total2 += sum
 193                 if xml_tmp:
 194                     xml += workcenter_header
 195                     xml += "<lines style='lines'>" + xml_tmp + '</lines>'
 196                     xml += """<lines style='sub_total'> <row>
 197                     <col>%s %s %s %s : </col>
 198                     <col/>
 199                     <col/>
 200                     <col/>
 201                     <col/>
 202                     <col t='yes'>%.2f</col>
 203                     </row></lines>'"""%(_('Work Cost'), _('of'), str(number), product.uom_id.name, total2)
 204                 xml += """<lines style='total'> <row>
 205                     <col>%s %s %s %s : </col>
 206                     <col/>
 207                     <col/>
 208                     <col t='yes'/>
 209                     <col t='yes'>%.2f</col>
 210                     <col t='yes'>%.2f</col>
 211                     </row></lines>'"""%(_('Total Cost'), _('of'), str(number), product.uom_id.name, total_strd+total2, total+total2)
 212
 213         xml = '<?xml version="1.0" ?><report>' + config_start + config_stop + xml + '</report>'
 214
 215         return xml
 216
 217 report_custom('report.product.price', 'product.product', '', 'addons/mrp/report/price.xsl')
 218
 219 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 220