1 # -*- coding: utf-8 -*-
2 ##############################################################################
4 # OpenERP, Open Source Management Solution
5 # Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
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.
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.
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/>.
20 ##############################################################################
22 from osv import osv, fields
24 class stock_move(osv.osv):
25 _inherit = 'stock.move'
27 'sale_line_id': fields.many2one('sale.order.line', 'Sales Order Line', ondelete='set null', select=True, readonly=True),
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)
33 values['sale_id'] = picking.sale_id.id
36 class stock_picking(osv.osv):
37 _inherit = 'stock.picking'
39 'sale_id': fields.many2one('sale.order', 'Sales Order', ondelete='set null', select=True),
45 def get_currency_id(self, cursor, user, picking):
47 return picking.sale_id.pricelist_id.currency_id.id
49 return super(stock_picking, self).get_currency_id(cursor, user, picking)
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
56 return picking.sale_id.partner_id
57 return super(stock_picking, self)._get_partner_to_invoice(cr, uid, picking, context=context)
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)
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
68 invoice_vals = super(stock_picking, self)._prepare_invoice(cr, uid, picking, partner, inv_type, journal_id, context=context)
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
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
84 return move_line.sale_line_id.price_unit
85 return super(stock_picking, self)._get_price_unit_invoice(cursor, user, move_line, type)
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)
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)
97 def _get_account_analytic_invoice(self, cursor, user, picking, move_line):
99 return picking.sale_id.project_id.id
100 return super(stock_picking, self)._get_account_analytic_invoice(cursor, user, picking, move_line)
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],
109 'invoice_lines': [(4, invoice_line_id)],
111 return super(stock_picking, self)._invoice_line_hook(cursor, user, move_line, invoice_line_id)
113 def _invoice_hook(self, cursor, user, picking, invoice_id):
114 sale_obj = self.pool.get('sale.order')
116 sale_obj.write(cursor, user, [picking.sale_id.id], {
117 'invoice_ids': [(4, invoice_id)],
119 return super(stock_picking, self)._invoice_hook(cursor, user, picking, invoice_id)
121 def action_invoice_create(self, cursor, user, ids, journal_id=False,
122 group=False, type='out_invoice', context=None):
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')
131 result = super(stock_picking, self).action_invoice_create(cursor, user,
132 ids, journal_id=journal_id, group=group, type=type,
134 picking_ids = result.keys()
135 invoice_ids = result.values()
137 for invoice in invoice_obj.browse(cursor, user, invoice_ids,
139 invoices[invoice.id] = invoice
141 for picking in picking_obj.browse(cursor, user, picking_ids,
143 if not picking.sale_id or picking.backorder_id:
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)
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:
158 type = context.get('inv_type', False)
160 name = picking.name + '-' + sale_line.name
162 name = sale_line.name
163 if type in ('out_invoice', 'out_refund'):
164 account_id = sale_line.product_id.product_tmpl_id.\
165 property_account_income.id
167 account_id = sale_line.product_id.categ_id.\
168 property_account_income_categ.id
170 account_id = sale_line.product_id.product_tmpl_id.\
171 property_account_expense.id
173 account_id = sale_line.product_id.categ_id.\
174 property_account_expense_categ.id
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
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], {
184 'invoice_lines': [(6, 0, [invoice_line_id])],
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
191 class stock_picking_out(osv.osv):
192 _inherit = 'stock.picking.out'
194 'sale_id': fields.many2one('sale.order', 'Sale Order',
195 ondelete='set null', select=True),
197 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: