addons/purchase/stock.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
  22 from osv import osv, fields
  23
  24 class stock_move(osv.osv):
  25     _inherit = 'stock.move'
  26     _columns = {
  27         'purchase_line_id': fields.many2one('purchase.order.line',
  28             'Purchase Order Line', ondelete='set null', select=True,
  29             readonly=True),
  30     }
  31
  32     def _get_reference_accounting_values_for_valuation(self, cr, uid, move, context=None):
  33         """
  34         Overrides the default stock valuation to take into account the currency that was specified
  35         on the purchase order in case the valuation data was not directly specified during picking
  36         confirmation.
  37         """
  38         reference_amount, reference_currency_id = super(stock_move, self)._get_reference_accounting_values_for_valuation(cr, uid, move, context=context)
  39         if move.product_id.cost_method != 'average' or not move.price_unit:
  40             # no average price costing or cost not specified during picking validation, we will
  41             # plug the purchase line values if they are found.
  42             if move.purchase_line_id and move.picking_id.purchase_id.pricelist_id:
  43                 reference_amount, reference_currency_id = move.purchase_line_id.price_unit, move.picking_id.purchase_id.pricelist_id.currency_id.id
  44         return reference_amount, reference_currency_id
  45
  46 stock_move()
  47
  48 #
  49 # Inherit of picking to add the link to the PO
  50 #
  51 class stock_picking(osv.osv):
  52     _inherit = 'stock.picking'
  53     _columns = {
  54         'purchase_id': fields.many2one('purchase.order', 'Purchase Order',
  55             ondelete='set null', select=True),
  56     }
  57     _defaults = {
  58         'purchase_id': False,
  59     }
  60
  61     def get_currency_id(self, cursor, user, picking):
  62         if picking.purchase_id:
  63             return picking.purchase_id.pricelist_id.currency_id.id
  64         else:
  65             return super(stock_picking, self).get_currency_id(cursor, user, picking)
  66
  67     def _get_comment_invoice(self, cursor, user, picking):
  68         if picking.purchase_id and picking.purchase_id.notes:
  69             if picking.note:
  70                 return picking.note + '\n' + picking.purchase_id.notes
  71             else:
  72                 return picking.purchase_id.notes
  73         return super(stock_picking, self)._get_comment_invoice(cursor, user, picking)
  74
  75     def _get_price_unit_invoice(self, cursor, user, move_line, type):
  76         if move_line.purchase_line_id:
  77             return move_line.purchase_line_id.price_unit
  78         return super(stock_picking, self)._get_price_unit_invoice(cursor, user, move_line, type)
  79
  80     def _get_discount_invoice(self, cursor, user, move_line):
  81         if move_line.purchase_line_id:
  82             return 0.0
  83         return super(stock_picking, self)._get_discount_invoice(cursor, user, move_line)
  84
  85     def _get_taxes_invoice(self, cursor, user, move_line, type):
  86         if move_line.purchase_line_id:
  87             return [x.id for x in move_line.purchase_line_id.taxes_id]
  88         return super(stock_picking, self)._get_taxes_invoice(cursor, user, move_line, type)
  89
  90     def _get_account_analytic_invoice(self, cursor, user, picking, move_line):
  91         if move_line.purchase_line_id:
  92             return move_line.purchase_line_id.account_analytic_id.id
  93         return super(stock_picking, self)._get_account_analytic_invoice(cursor, user, picking, move_line)
  94
  95     def _invoice_line_hook(self, cursor, user, move_line, invoice_line_id):
  96         if move_line.purchase_line_id:
  97             invoice_line_obj = self.pool.get('account.invoice.line')
  98             invoice_line_obj.write(cursor, user, [invoice_line_id], {'note':  move_line.purchase_line_id.notes,})
  99         return super(stock_picking, self)._invoice_line_hook(cursor, user, move_line, invoice_line_id)
 100
 101     def _invoice_hook(self, cursor, user, picking, invoice_id):
 102         purchase_obj = self.pool.get('purchase.order')
 103         if picking.purchase_id:
 104             purchase_obj.write(cursor, user, [picking.purchase_id.id], {'invoice_id': invoice_id,})
 105         return super(stock_picking, self)._invoice_hook(cursor, user, picking, invoice_id)
 106
 107 stock_picking()
 108
 109 class stock_partial_picking(osv.osv_memory):
 110     _inherit = 'stock.partial.picking'
 111
 112     def default_get(self, cr, uid, fields, context=None):
 113         """ To get default values for the object.
 114         @param self: The object pointer.
 115         @param cr: A database cursor
 116         @param uid: ID of the user currently logged in
 117         @param fields: List of fields for which we want default values
 118         @param context: A standard dictionary
 119         @return: A dictionary which of fields with values.
 120         """
 121         pick_obj = self.pool.get('stock.picking')
 122         res = super(stock_partial_picking, self).default_get(cr, uid, fields, context=context)
 123         for pick in pick_obj.browse(cr, uid, context.get('active_ids', [])):
 124             has_product_cost = (pick.type == 'in' and pick.purchase_id)
 125             for m in pick.move_lines:
 126                 if m.state in ('done','cancel') :
 127                     continue
 128                 if has_product_cost and m.product_id.cost_method == 'average' and m.purchase_line_id:
 129                     # We use the original PO unit purchase price as the basis for the cost, expressed
 130                     # in the currency of the PO (i.e the PO's pricelist currency)
 131                     res['move%s_product_price'%(m.id)] =  m.purchase_line_id.price_unit
 132                     res['move%s_product_currency'%(m.id)] = pick.purchase_id.pricelist_id.currency_id.id
 133         return res
 134 stock_partial_picking()
 135
 136 class stock_partial_move(osv.osv_memory):
 137     _inherit = "stock.partial.move"
 138     def default_get(self, cr, uid, fields, context=None):
 139         """ To get default values for the object.
 140         @param self: The object pointer.
 141         @param cr: A database cursor
 142         @param uid: ID of the user currently logged in
 143         @param fields: List of fields for which we want default values
 144         @param context: A standard dictionary
 145         @return: A dictionary which of fields with values.
 146         """
 147         res = super(stock_partial_move, self).default_get(cr, uid, fields, context=context)
 148         move_obj = self.pool.get('stock.move')
 149         for m in move_obj.browse(cr, uid, context.get('active_ids', [])):
 150             if m.picking_id.type == 'in' and m.product_id.cost_method == 'average' \
 151                 and m.purchase_line_id and m.picking_id.purchase_id:
 152                     # We use the original PO unit purchase price as the basis for the cost, expressed
 153                     # in the currency of the PO (i.e the PO's pricelist currency)
 154                     res['move%s_product_price'%(m.id)] = m.purchase_line_id.price_unit
 155                     res['move%s_product_currency'%(m.id)] = m.picking_id.purchase_id.pricelist_id.currency_id.id
 156         return res
 157 stock_partial_move()
 158 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 159