addons/sale_stock/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
  24 class stock_move(osv.osv):
  25     _inherit = 'stock.move'
  26     _columns = {
  27         'sale_line_id': fields.many2one('sale.order.line', 'Sales Order Line', ondelete='set null', select=True, readonly=True),
  28     }
  29
  30     def _prepare_chained_picking(self, cr, uid, picking_name, picking, picking_type, moves_todo, context=None):
  31         values = super(stock_move, self)._prepare_chained_picking(cr, uid, picking_name, picking, picking_type, moves_todo, context=context)
  32         if picking.sale_id:
  33             values['sale_id'] = picking.sale_id.id
  34             if values.get('type') == 'out' and picking.sale_id.order_policy == 'picking':
  35                 values['invoice_state'] = '2binvoiced'
  36         picking.write({'invoice_state': 'none'})
  37         return values
  38
  39 class stock_picking(osv.osv):
  40     _inherit = 'stock.picking'
  41     _columns = {
  42         'sale_id': fields.many2one('sale.order', 'Sales Order', ondelete='set null', select=True),
  43     }
  44     _defaults = {
  45         'sale_id': False
  46     }
  47
  48     def get_currency_id(self, cursor, user, picking):
  49         if picking.sale_id:
  50             return picking.sale_id.pricelist_id.currency_id.id
  51         else:
  52             return super(stock_picking, self).get_currency_id(cursor, user, picking)
  53
  54     def _get_partner_to_invoice(self, cr, uid, picking, context=None):
  55         """ Inherit the original function of the 'stock' module
  56             We select the partner of the sales order as the partner of the customer invoice
  57         """
  58         if picking.sale_id:
  59             return picking.sale_id.partner_invoice_id
  60         return super(stock_picking, self)._get_partner_to_invoice(cr, uid, picking, context=context)
  61
  62     def _get_comment_invoice(self, cursor, user, picking):
  63         if picking.note or (picking.sale_id and picking.sale_id.note):
  64             return picking.note or picking.sale_id.note
  65         return super(stock_picking, self)._get_comment_invoice(cursor, user, picking)
  66
  67     def _prepare_invoice_group(self, cr, uid, picking, partner, invoice, context=None):
  68         """ Inherit the original function of the 'stock' module in order to override name field
  69             to pass the customer reference form the sales order
  70         """
  71         invoice_vals = super(stock_picking, self)._prepare_invoice_group(cr, uid, picking, partner, invoice, context)
  72         if picking.sale_id:
  73             invoice_vals['name'] = (invoice.name or '') + ', ' + (picking.sale_id.client_order_ref or '')
  74         return invoice_vals
  75
  76     def _prepare_invoice(self, cr, uid, picking, partner, inv_type, journal_id, context=None):
  77         """ Inherit the original function of the 'stock' module in order to override some
  78             values if the picking has been generated by a sales order
  79         """
  80         invoice_vals = super(stock_picking, self)._prepare_invoice(cr, uid, picking, partner, inv_type, journal_id, context=context)
  81         if picking.sale_id:
  82             invoice_vals['fiscal_position'] = picking.sale_id.fiscal_position.id
  83             invoice_vals['payment_term'] = picking.sale_id.payment_term.id
  84             invoice_vals['user_id'] = picking.sale_id.user_id.id
  85             invoice_vals['name'] = picking.sale_id.client_order_ref or ''
  86         return invoice_vals
  87
  88     def _prepare_invoice_line(self, cr, uid, group, picking, move_line, invoice_id, invoice_vals, context=None):
  89         invoice_vals = super(stock_picking, self)._prepare_invoice_line(cr, uid, group, picking, move_line, invoice_id, invoice_vals, context=context)
  90         if picking.sale_id:
  91             if move_line.sale_line_id:
  92                 invoice_vals['account_analytic_id'] = self._get_account_analytic_invoice(cr, uid, picking, move_line)
  93         return invoice_vals
  94
  95     def _get_price_unit_invoice(self, cursor, user, move_line, type):
  96         if move_line.sale_line_id and move_line.sale_line_id.product_id.id == move_line.product_id.id:
  97             uom_id = move_line.product_id.uom_id.id
  98             uos_id = move_line.product_id.uos_id and move_line.product_id.uos_id.id or False
  99             price = move_line.sale_line_id.price_unit
 100             coeff = move_line.product_id.uos_coeff
 101             if uom_id != uos_id  and coeff != 0:
 102                 price_unit = price / coeff
 103                 return price_unit
 104             return move_line.sale_line_id.price_unit
 105         return super(stock_picking, self)._get_price_unit_invoice(cursor, user, move_line, type)
 106
 107     def _get_discount_invoice(self, cursor, user, move_line):
 108         if move_line.sale_line_id:
 109             return move_line.sale_line_id.discount
 110         return super(stock_picking, self)._get_discount_invoice(cursor, user, move_line)
 111
 112     def _get_taxes_invoice(self, cursor, user, move_line, type):
 113         if move_line.sale_line_id and move_line.sale_line_id.product_id.id == move_line.product_id.id:
 114             return [x.id for x in move_line.sale_line_id.tax_id]
 115         return super(stock_picking, self)._get_taxes_invoice(cursor, user, move_line, type)
 116
 117     def _get_account_analytic_invoice(self, cursor, user, picking, move_line):
 118         if picking.sale_id:
 119             return picking.sale_id.project_id.id
 120         return super(stock_picking, self)._get_account_analytic_invoice(cursor, user, picking, move_line)
 121
 122     def _invoice_line_hook(self, cursor, user, move_line, invoice_line_id):
 123         if move_line.sale_line_id:
 124             move_line.sale_line_id.write({'invoice_lines': [(4, invoice_line_id)]})
 125         return super(stock_picking, self)._invoice_line_hook(cursor, user, move_line, invoice_line_id)
 126
 127     def _invoice_hook(self, cursor, user, picking, invoice_id):
 128         sale_obj = self.pool.get('sale.order')
 129         order_line_obj = self.pool.get('sale.order.line')
 130         invoice_obj = self.pool.get('account.invoice')
 131         invoice_line_obj = self.pool.get('account.invoice.line')
 132         if picking.sale_id:
 133             sale_obj.write(cursor, user, [picking.sale_id.id], {
 134                 'invoice_ids': [(4, invoice_id)],
 135             })
 136             for sale_line in picking.sale_id.order_line:
 137                 if sale_line.product_id.type == 'service' and not sale_line.invoiced:
 138                     vals = order_line_obj._prepare_order_line_invoice_line(cursor, user, sale_line, False)
 139                     vals['invoice_id'] = invoice_id
 140                     invoice_line_id = invoice_line_obj.create(cursor, user, vals)
 141                     order_line_obj.write(cursor, user, [sale_line.id], {
 142                         'invoice_lines': [(6, 0, [invoice_line_id])],
 143                     })
 144                     invoice_obj.button_compute(cursor, user, [invoice_id])
 145         return super(stock_picking, self)._invoice_hook(cursor, user, picking, invoice_id)
 146
 147 # Redefinition of the new field in order to update the model stock.picking.out in the orm
 148 # FIXME: this is a temporary workaround because of a framework bug (ref: lp996816). It should be removed as soon as
 149 #        the bug is fixed
 150 class stock_picking_out(osv.osv):
 151     _inherit = 'stock.picking.out'
 152     _columns = {
 153         'sale_id': fields.many2one('sale.order', 'Sale Order',
 154             ondelete='set null', select=True),
 155     }
 156 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: