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 openerp.osv import fields, osv
  23 from openerp.tools.translate import _
  24
  25 class stock_move(osv.osv):
  26     _inherit = 'stock.move'
  27     _columns = {
  28         'purchase_line_id': fields.many2one('purchase.order.line',
  29             'Purchase Order Line', ondelete='set null', select=True,
  30             readonly=True),
  31     }
  32
  33
  34 #
  35 # Inherit of picking to add the link to the PO
  36 #
  37 class stock_picking(osv.osv):
  38     _inherit = 'stock.picking'
  39     _columns = {
  40         'purchase_id': fields.many2one('purchase.order', 'Purchase Order',
  41             ondelete='set null', select=True),
  42     }
  43
  44     _defaults = {
  45         'purchase_id': False,
  46     }
  47
  48     def _get_partner_to_invoice(self, cr, uid, picking, context=None):
  49         """ Inherit the original function of the 'stock' module
  50             We select the partner of the sale order as the partner of the customer invoice
  51         """
  52         if picking.purchase_id:
  53             return picking.purchase_id.partner_id
  54         return super(stock_picking, self)._get_partner_to_invoice(cr, uid, picking, context=context)
  55
  56     def _prepare_invoice(self, cr, uid, picking, partner, inv_type, journal_id, context=None):
  57         """ Inherit the original function of the 'stock' module in order to override some
  58             values if the picking has been generated by a purchase order
  59         """
  60         invoice_vals = super(stock_picking, self)._prepare_invoice(cr, uid, picking, partner, inv_type, journal_id, context=context)
  61         if picking.purchase_id:
  62             invoice_vals['fiscal_position'] = picking.purchase_id.fiscal_position.id
  63             invoice_vals['payment_term'] = picking.purchase_id.payment_term_id.id
  64             # Fill the date_due on the invoice, for usability purposes.
  65             # Note that when an invoice with a payment term is validated, the
  66             # date_due is always recomputed from the invoice date and the payment
  67             # term.
  68             if picking.purchase_id.payment_term_id and context.get('date_inv'):
  69                 invoice_vals['date_due'] = self.pool.get('account.invoice').onchange_payment_term_date_invoice(cr, uid, [], picking.purchase_id.payment_term_id.id, context.get('date_inv'))['value'].get('date_due')
  70         return invoice_vals
  71
  72     def get_currency_id(self, cursor, user, picking):
  73         if picking.purchase_id:
  74             return picking.purchase_id.currency_id.id
  75         else:
  76             return super(stock_picking, self).get_currency_id(cursor, user, picking)
  77
  78     def _get_comment_invoice(self, cursor, user, picking):
  79         if picking.purchase_id and picking.purchase_id.notes:
  80             if picking.note:
  81                 return picking.note + '\n' + picking.purchase_id.notes
  82             else:
  83                 return picking.purchase_id.notes
  84         return super(stock_picking, self)._get_comment_invoice(cursor, user, picking)
  85
  86     def _get_price_unit_invoice(self, cursor, user, move_line, type):
  87         if move_line.purchase_line_id:
  88             if move_line.purchase_line_id.order_id.invoice_method == 'picking':
  89                 return move_line.price_unit
  90             else:
  91                 return move_line.purchase_line_id.price_unit
  92         return super(stock_picking, self)._get_price_unit_invoice(cursor, user, move_line, type)
  93
  94     def _get_discount_invoice(self, cursor, user, move_line):
  95         if move_line.purchase_line_id:
  96             return 0.0
  97         return super(stock_picking, self)._get_discount_invoice(cursor, user, move_line)
  98
  99     def _get_taxes_invoice(self, cursor, user, move_line, type):
 100         if move_line.purchase_line_id:
 101             return [x.id for x in move_line.purchase_line_id.taxes_id]
 102         return super(stock_picking, self)._get_taxes_invoice(cursor, user, move_line, type)
 103
 104     def _get_account_analytic_invoice(self, cursor, user, picking, move_line):
 105         if picking.purchase_id and move_line.purchase_line_id:
 106             return move_line.purchase_line_id.account_analytic_id.id
 107         return super(stock_picking, self)._get_account_analytic_invoice(cursor, user, picking, move_line)
 108
 109     def _invoice_line_hook(self, cursor, user, move_line, invoice_line_id):
 110         if move_line.purchase_line_id:
 111             invoice_line_obj = self.pool.get('account.invoice.line')
 112             purchase_line_obj = self.pool.get('purchase.order.line')
 113             purchase_line_obj.write(cursor, user, [move_line.purchase_line_id.id], {
 114                 'invoice_lines': [(4, invoice_line_id)],
 115             })
 116         return super(stock_picking, self)._invoice_line_hook(cursor, user, move_line, invoice_line_id)
 117
 118     def _invoice_hook(self, cursor, user, picking, invoice_id):
 119         purchase_obj = self.pool.get('purchase.order')
 120         if picking.purchase_id:
 121             purchase_obj.write(cursor, user, [picking.purchase_id.id], {'invoice_ids': [(4, invoice_id)]})
 122         return super(stock_picking, self)._invoice_hook(cursor, user, picking, invoice_id)
 123
 124 class stock_partial_picking(osv.osv_memory):
 125     _inherit = 'stock.partial.picking'
 126
 127     # Overridden to inject the purchase price as true 'cost price' when processing
 128     # incoming pickings.
 129     def _product_cost_for_average_update(self, cr, uid, move):
 130         purchase_line = move.purchase_line_id
 131         if move.picking_id.purchase_id and purchase_line:
 132             if any([x.invoice_id.state not in ('draft', 'cancel') for x in purchase_line.invoice_lines]):
 133                 # use price set on validated invoices
 134                 cost = move.price_unit
 135                 for inv_line in purchase_line.invoice_lines:
 136                     if inv_line.invoice_id.state not in ('draft', 'cancel'):
 137                         inv_currency = inv_line.invoice_id.currency_id.id
 138                         company_currency = inv_line.invoice_id.company_id.currency_id.id
 139                         cost = self.pool.get('res.currency').compute(cr, uid, inv_currency, company_currency, inv_line.price_unit, round=False, context={'date': inv_line.invoice_id.date_invoice})
 140                         return {'cost': cost, 'currency': company_currency}
 141             else:
 142                 # use price set on the purchase order
 143                 pur_currency = purchase_line.order_id.currency_id.id
 144                 company_currency = purchase_line.company_id.currency_id.id
 145                 cost = self.pool.get('res.currency').compute(cr, uid, pur_currency, company_currency, purchase_line.price_unit, round=False, context={'date': purchase_line.date_order})
 146                 return {'cost': cost, 'currency': company_currency}
 147         return super(stock_partial_picking, self)._product_cost_for_average_update(cr, uid, move)
 148
 149     def __get_help_text(self, cursor, user, picking_id, context=None):
 150         picking = self.pool.get('stock.picking').browse(cursor, user, picking_id, context=context)
 151         if picking.purchase_id:
 152             text = _("The proposed cost is made based on %s")
 153             value = _("Purchase Order %s") % picking.purchase_id.name
 154             if picking.purchase_id.pricelist_id.currency_id != picking.purchase_id.company_id.currency_id:
 155                 value += _(" (currency rate of purchase order taken)")
 156             if any([x.state not in ('draft', 'cancel') for x in picking.purchase_id.invoice_ids]):
 157                 value = _("Invoices made on Purchase Order %s") % (picking.purchase_id.name)
 158                 if picking.purchase_id.pricelist_id.currency_id != picking.purchase_id.company_id.currency_id:
 159                     value += _(" (currency rate of invoices taken)")
 160             return text % value
 161         return super(stock_partial_picking, self).__get_help_text(cursor, user, picking_id, context=context)
 162
 163 # Redefinition of the new field in order to update the model stock.picking.in in the orm
 164 # FIXME: this is a temporary workaround because of a framework bug (ref: lp996816). It should be removed as soon as
 165 #        the bug is fixed
 166 class stock_picking_in(osv.osv):
 167     _inherit = 'stock.picking.in'
 168     _columns = {
 169         'purchase_id': fields.many2one('purchase.order', 'Purchase Order',
 170             ondelete='set null', select=True),
 171         'warehouse_id': fields.related('purchase_id', 'warehouse_id', type='many2one', relation='stock.warehouse', string='Destination Warehouse', readonly=True),
 172     }
 173 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: