addons/sale/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         '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         return values
  35
  36 class stock_picking(osv.osv):
  37     _inherit = 'stock.picking'
  38     _columns = {
  39         'sale_id': fields.many2one('sale.order', 'Sales Order', ondelete='set null', select=True),
  40     }
  41     _defaults = {
  42         'sale_id': False
  43     }
  44
  45     def get_currency_id(self, cursor, user, picking):
  46         if picking.sale_id:
  47             return picking.sale_id.pricelist_id.currency_id.id
  48         else:
  49             return super(stock_picking, self).get_currency_id(cursor, user, picking)
  50
  51     def _get_partner_to_invoice(self, cr, uid, picking, context=None):
  52         """ Inherit the original function of the 'stock' module
  53             We select the partner of the sale order as the partner of the customer invoice
  54         """
  55         if picking.sale_id:
  56             return picking.sale_id.partner_id
  57         return super(stock_picking, self)._get_partner_to_invoice(cr, uid, picking, context=context)
  58
  59     def _get_comment_invoice(self, cursor, user, picking):
  60         if picking.note or (picking.sale_id and picking.sale_id.note):
  61             return picking.note or picking.sale_id.note
  62         return super(stock_picking, self)._get_comment_invoice(cursor, user, picking)
  63
  64     def _prepare_invoice(self, cr, uid, picking, partner, inv_type, journal_id, context=None):
  65         """ Inherit the original function of the 'stock' module in order to override some
  66             values if the picking has been generated by a sale order
  67         """
  68         invoice_vals = super(stock_picking, self)._prepare_invoice(cr, uid, picking, partner, inv_type, journal_id, context=context)
  69         if picking.sale_id:
  70             invoice_vals['fiscal_position'] = picking.sale_id.fiscal_position.id
  71             invoice_vals['payment_term'] = picking.sale_id.payment_term.id
  72             invoice_vals['user_id'] = picking.sale_id.user_id.id
  73         return invoice_vals
  74
  75     def _get_price_unit_invoice(self, cursor, user, move_line, type):
  76         if move_line.sale_line_id and move_line.sale_line_id.product_id.id == move_line.product_id.id:
  77             uom_id = move_line.product_id.uom_id.id
  78             uos_id = move_line.product_id.uos_id and move_line.product_id.uos_id.id or False
  79             price = move_line.sale_line_id.price_unit
  80             coeff = move_line.product_id.uos_coeff
  81             if uom_id != uos_id  and coeff != 0:
  82                 price_unit = price / coeff
  83                 return price_unit
  84             return move_line.sale_line_id.price_unit
  85         return super(stock_picking, self)._get_price_unit_invoice(cursor, user, move_line, type)
  86
  87     def _get_discount_invoice(self, cursor, user, move_line):
  88         if move_line.sale_line_id:
  89             return move_line.sale_line_id.discount
  90         return super(stock_picking, self)._get_discount_invoice(cursor, user, move_line)
  91
  92     def _get_taxes_invoice(self, cursor, user, move_line, type):
  93         if move_line.sale_line_id and move_line.sale_line_id.product_id.id == move_line.product_id.id:
  94             return [x.id for x in move_line.sale_line_id.tax_id]
  95         return super(stock_picking, self)._get_taxes_invoice(cursor, user, move_line, type)
  96
  97     def _get_account_analytic_invoice(self, cursor, user, picking, move_line):
  98         if picking.sale_id:
  99             return picking.sale_id.project_id.id
 100         return super(stock_picking, self)._get_account_analytic_invoice(cursor, user, picking, move_line)
 101
 102     def _invoice_line_hook(self, cursor, user, move_line, invoice_line_id):
 103         sale_line_obj = self.pool.get('sale.order.line')
 104         invoice_line_obj = self.pool.get('account.invoice.line')
 105         if move_line.sale_line_id:
 106             sale_line_obj.write(cursor, user, [move_line.sale_line_id.id],
 107                                     {
 108                                         'invoiced': True,
 109                                         'invoice_lines': [(4, invoice_line_id)],
 110                                     })
 111         return super(stock_picking, self)._invoice_line_hook(cursor, user, move_line, invoice_line_id)
 112
 113     def _invoice_hook(self, cursor, user, picking, invoice_id):
 114         sale_obj = self.pool.get('sale.order')
 115         if picking.sale_id:
 116             sale_obj.write(cursor, user, [picking.sale_id.id], {
 117                 'invoice_ids': [(4, invoice_id)],
 118                 })
 119         return super(stock_picking, self)._invoice_hook(cursor, user, picking, invoice_id)
 120
 121     def action_invoice_create(self, cursor, user, ids, journal_id=False,
 122             group=False, type='out_invoice', context=None):
 123         if context is None:
 124             context = {}
 125         invoice_obj = self.pool.get('account.invoice')
 126         picking_obj = self.pool.get('stock.picking')
 127         invoice_line_obj = self.pool.get('account.invoice.line')
 128         fiscal_position_obj = self.pool.get('account.fiscal.position')
 129         order_line_obj = self.pool.get('sale.order.line')
 130
 131         result = super(stock_picking, self).action_invoice_create(cursor, user,
 132                 ids, journal_id=journal_id, group=group, type=type,
 133                 context=context)
 134         picking_ids = result.keys()
 135         invoice_ids = result.values()
 136         invoices = {}
 137         for invoice in invoice_obj.browse(cursor, user, invoice_ids,
 138                 context=context):
 139             invoices[invoice.id] = invoice
 140
 141         for picking in picking_obj.browse(cursor, user, picking_ids,
 142                 context=context):
 143             if not picking.sale_id or picking.backorder_id:
 144                 continue
 145             sale_lines = picking.sale_id.order_line
 146             invoice_created = invoices[result[picking.id]]
 147             if picking.sale_id.user_id:
 148                 invoice_obj.write(cursor, user, [invoice_created.id], {'user_id': picking.sale_id.user_id.id}, context=context)
 149
 150             if picking.sale_id.fiscal_position:
 151                 invoice_obj.write(cursor, user, [invoice_created.id], {'fiscal_position': picking.sale_id.fiscal_position.id}, context=context)
 152             if picking.sale_id.client_order_ref:
 153                 inv_name = picking.sale_id.client_order_ref + " : " + invoice_created.name
 154                 invoice_obj.write(cursor, user, [invoice_created.id], {'name': inv_name}, context=context)
 155             for sale_line in sale_lines:
 156                 if sale_line.product_id.type == 'service' and sale_line.invoiced == False:
 157                     if not type:
 158                         type = context.get('inv_type', False)
 159                     if group:
 160                         name = picking.name + '-' + sale_line.name
 161                     else:
 162                         name = sale_line.name
 163                     if type in ('out_invoice', 'out_refund'):
 164                         account_id = sale_line.product_id.\
 165                                 property_account_income.id
 166                         if not account_id:
 167                             account_id = sale_line.product_id.categ_id.\
 168                                     property_account_income_categ.id
 169                     else:
 170                         account_id = sale_line.product_id.\
 171                                 property_account_expense.id
 172                         if not account_id:
 173                             account_id = sale_line.product_id.categ_id.\
 174                                     property_account_expense_categ.id
 175
 176                     vals = order_line_obj._prepare_order_line_invoice_line(cursor, user, sale_line, account_id, context)
 177                     if vals: #note: in some cases we may not want to include all service lines as invoice lines
 178                         vals['name'] = name
 179                         vals['account_analytic_id'] = self._get_account_analytic_invoice(cursor, user, picking, sale_line)
 180                         vals['invoice_id'] = invoices[result[picking.id]].id
 181                         invoice_line_id = invoice_line_obj.create(cursor, user, vals, context=context)
 182                         order_line_obj.write(cursor, user, [sale_line.id], {
 183                             'invoiced': True,
 184                             'invoice_lines': [(6, 0, [invoice_line_id])],
 185                         })
 186         return result
 187
 188 # Redefinition of the new field in order to update the model stock.picking.out in the orm
 189 # FIXME: this is a temporary workaround because of a framework bug (ref: lp996816). It should be removed as soon as
 190 #        the bug is fixed
 191 class stock_picking_out(osv.osv):
 192     _inherit = 'stock.picking.out'
 193     _columns = {
 194         'sale_id': fields.many2one('sale.order', 'Sale Order',
 195             ondelete='set null', select=True),
 196     }
 197 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: