[MERGE] procuremnt msgs improved
[odoo/odoo.git] / addons / purchase / purchase.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 import time
23 from datetime import datetime
24 from dateutil.relativedelta import relativedelta
25
26 from osv import osv, fields
27 import netsvc
28 import pooler
29 from tools.translate import _
30 import decimal_precision as dp
31 from osv.orm import browse_record, browse_null
32 from tools import DEFAULT_SERVER_DATE_FORMAT, DEFAULT_SERVER_DATETIME_FORMAT, DATETIME_FORMATS_MAP
33
34 class purchase_order(osv.osv):
35
36     def _amount_all(self, cr, uid, ids, field_name, arg, context=None):
37         res = {}
38         cur_obj=self.pool.get('res.currency')
39         for order in self.browse(cr, uid, ids, context=context):
40             res[order.id] = {
41                 'amount_untaxed': 0.0,
42                 'amount_tax': 0.0,
43                 'amount_total': 0.0,
44             }
45             val = val1 = 0.0
46             cur = order.pricelist_id.currency_id
47             for line in order.order_line:
48                val1 += line.price_subtotal
49                for c in self.pool.get('account.tax').compute_all(cr, uid, line.taxes_id, line.price_unit, line.product_qty, line.product_id.id, order.partner_id)['taxes']:
50                     val += c.get('amount', 0.0)
51             res[order.id]['amount_tax']=cur_obj.round(cr, uid, cur, val)
52             res[order.id]['amount_untaxed']=cur_obj.round(cr, uid, cur, val1)
53             res[order.id]['amount_total']=res[order.id]['amount_untaxed'] + res[order.id]['amount_tax']
54         return res
55
56     def _set_minimum_planned_date(self, cr, uid, ids, name, value, arg, context=None):
57         if not value: return False
58         if type(ids)!=type([]):
59             ids=[ids]
60         for po in self.browse(cr, uid, ids, context=context):
61             if po.order_line:
62                 cr.execute("""update purchase_order_line set
63                         date_planned=%s
64                     where
65                         order_id=%s and
66                         (date_planned=%s or date_planned<%s)""", (value,po.id,po.minimum_planned_date,value))
67             cr.execute("""update purchase_order set
68                     minimum_planned_date=%s where id=%s""", (value, po.id))
69         return True
70
71     def _minimum_planned_date(self, cr, uid, ids, field_name, arg, context=None):
72         res={}
73         purchase_obj=self.browse(cr, uid, ids, context=context)
74         for purchase in purchase_obj:
75             res[purchase.id] = False
76             if purchase.order_line:
77                 min_date=purchase.order_line[0].date_planned
78                 for line in purchase.order_line:
79                     if line.date_planned < min_date:
80                         min_date=line.date_planned
81                 res[purchase.id]=min_date
82         return res
83
84
85     def _invoiced_rate(self, cursor, user, ids, name, arg, context=None):
86         res = {}
87         for purchase in self.browse(cursor, user, ids, context=context):
88             tot = 0.0
89             for invoice in purchase.invoice_ids:
90                 if invoice.state not in ('draft','cancel'):
91                     tot += invoice.amount_untaxed
92             if purchase.amount_untaxed:
93                 res[purchase.id] = tot * 100.0 / purchase.amount_untaxed
94             else:
95                 res[purchase.id] = 0.0
96         return res
97
98     def _shipped_rate(self, cr, uid, ids, name, arg, context=None):
99         if not ids: return {}
100         res = {}
101         for id in ids:
102             res[id] = [0.0,0.0]
103         cr.execute('''SELECT
104                 p.purchase_id,sum(m.product_qty), m.state
105             FROM
106                 stock_move m
107             LEFT JOIN
108                 stock_picking p on (p.id=m.picking_id)
109             WHERE
110                 p.purchase_id IN %s GROUP BY m.state, p.purchase_id''',(tuple(ids),))
111         for oid,nbr,state in cr.fetchall():
112             if state=='cancel':
113                 continue
114             if state=='done':
115                 res[oid][0] += nbr or 0.0
116                 res[oid][1] += nbr or 0.0
117             else:
118                 res[oid][1] += nbr or 0.0
119         for r in res:
120             if not res[r][1]:
121                 res[r] = 0.0
122             else:
123                 res[r] = 100.0 * res[r][0] / res[r][1]
124         return res
125
126     def _get_order(self, cr, uid, ids, context=None):
127         result = {}
128         for line in self.pool.get('purchase.order.line').browse(cr, uid, ids, context=context):
129             result[line.order_id.id] = True
130         return result.keys()
131
132     def _invoiced(self, cursor, user, ids, name, arg, context=None):
133         res = {}
134         for purchase in self.browse(cursor, user, ids, context=context):
135             invoiced = False
136             if purchase.invoiced_rate == 100.00:
137                 invoiced = True
138             res[purchase.id] = invoiced
139         return res
140
141     STATE_SELECTION = [
142         ('draft', 'Draft PO'),
143         ('sent', 'RFQ Sent'),
144         ('confirmed', 'Waiting Approval'),
145         ('approved', 'Purchase Order'),
146         ('except_picking', 'Shipping Exception'),
147         ('except_invoice', 'Invoice Exception'),
148         ('done', 'Done'),
149         ('cancel', 'Cancelled')
150     ]
151
152     _columns = {
153         'name': fields.char('Order Reference', size=64, required=True, select=True, help="Unique number of the purchase order, computed automatically when the purchase order is created."),
154         'origin': fields.char('Source Document', size=64,
155             help="Reference of the document that generated this purchase order request."
156         ),
157         'partner_ref': fields.char('Supplier Reference', states={'confirmed':[('readonly',True)], 'approved':[('readonly',True)],'done':[('readonly',True)]}, size=64),
158         'date_order':fields.date('Order Date', required=True, states={'confirmed':[('readonly',True)], 'approved':[('readonly',True)]}, select=True, help="Date on which this document has been created."),
159         'date_approve':fields.date('Date Approved', readonly=1, select=True, help="Date on which purchase order has been approved"),
160         'partner_id':fields.many2one('res.partner', 'Supplier', required=True, states={'confirmed':[('readonly',True)], 'approved':[('readonly',True)],'done':[('readonly',True)]}, change_default=True),
161         'dest_address_id':fields.many2one('res.partner', 'Customer Address (Direct Delivery)',
162             states={'confirmed':[('readonly',True)], 'approved':[('readonly',True)],'done':[('readonly',True)]},
163             help="Put an address if you want to deliver directly from the supplier to the customer. " \
164                 "Otherwise, keep empty to deliver to your own company."
165         ),
166         'warehouse_id': fields.many2one('stock.warehouse', 'Destination Warehouse', states={'confirmed':[('readonly',True)], 'approved':[('readonly',True)],'done':[('readonly',True)]}),
167         'location_id': fields.many2one('stock.location', 'Destination', required=True, domain=[('usage','<>','view')]),
168         'pricelist_id':fields.many2one('product.pricelist', 'Pricelist', required=True, states={'confirmed':[('readonly',True)], 'approved':[('readonly',True)],'done':[('readonly',True)]}, help="The pricelist sets the currency used for this purchase order. It also computes the supplier price for the selected products/quantities."),
169         'state': fields.selection(STATE_SELECTION, 'Status', readonly=True, help="The state of the purchase order or the quotation request. A quotation is a purchase order in a 'Draft' state. Then the order has to be confirmed by the user, the state switch to 'Confirmed'. Then the supplier must confirm the order to change the state to 'Approved'. When the purchase order is paid and received, the state becomes 'Done'. If a cancel action occurs in the invoice or in the reception of goods, the state becomes in exception.", select=True),
170         'order_line': fields.one2many('purchase.order.line', 'order_id', 'Order Lines', states={'approved':[('readonly',True)],'done':[('readonly',True)]}),
171         'validator' : fields.many2one('res.users', 'Validated by', readonly=True),
172         'notes': fields.text('Terms and Conditions'),
173         'invoice_ids': fields.many2many('account.invoice', 'purchase_invoice_rel', 'purchase_id', 'invoice_id', 'Invoices', help="Invoices generated for a purchase order"),
174         'picking_ids': fields.one2many('stock.picking.in', 'purchase_id', 'Picking List', readonly=True, help="This is the list of incoming shipments that have been generated for this purchase order."),
175         'shipped':fields.boolean('Received', readonly=True, select=True, help="It indicates that a picking has been done"),
176         'shipped_rate': fields.function(_shipped_rate, string='Received', type='float'),
177         'invoiced': fields.function(_invoiced, string='Invoice Received', type='boolean', help="It indicates that an invoice has been paid"),
178         'invoiced_rate': fields.function(_invoiced_rate, string='Invoiced', type='float'),
179         'invoice_method': fields.selection([('manual','Based on Purchase Order lines'),('order','Based on generated draft invoice'),('picking','Based on incoming shipments')], 'Invoicing Control', required=True,
180             help="Based on Purchase Order lines: place individual lines in 'Invoice Control > Based on P.O. lines' from where you can selectively create an invoice.\n" \
181                 "Based on generated invoice: create a draft invoice you can validate later.\n" \
182                 "Bases on incoming shipments: let you create an invoice when receptions are validated."
183         ),
184         'minimum_planned_date':fields.function(_minimum_planned_date, fnct_inv=_set_minimum_planned_date, string='Expected Date', type='date', select=True, help="This is computed as the minimum scheduled date of all purchase order lines' products.",
185             store = {
186                 'purchase.order.line': (_get_order, ['date_planned'], 10),
187             }
188         ),
189         'amount_untaxed': fields.function(_amount_all, digits_compute= dp.get_precision('Account'), string='Untaxed Amount',
190             store={
191                 'purchase.order.line': (_get_order, None, 10),
192             }, multi="sums", help="The amount without tax"),
193         'amount_tax': fields.function(_amount_all, digits_compute= dp.get_precision('Account'), string='Taxes',
194             store={
195                 'purchase.order.line': (_get_order, None, 10),
196             }, multi="sums", help="The tax amount"),
197         'amount_total': fields.function(_amount_all, digits_compute= dp.get_precision('Account'), string='Total',
198             store={
199                 'purchase.order.line': (_get_order, None, 10),
200             }, multi="sums",help="The total amount"),
201         'fiscal_position': fields.many2one('account.fiscal.position', 'Fiscal Position'),
202         'product_id': fields.related('order_line','product_id', type='many2one', relation='product.product', string='Product'),
203         'create_uid':  fields.many2one('res.users', 'Responsible'),
204         'company_id': fields.many2one('res.company','Company',required=True,select=1),
205     }
206     _defaults = {
207         'date_order': fields.date.context_today,
208         'state': 'draft',
209         'name': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'purchase.order'),
210         'shipped': 0,
211         'invoice_method': 'order',
212         'invoiced': 0,
213         'pricelist_id': lambda self, cr, uid, context: context.get('partner_id', False) and self.pool.get('res.partner').browse(cr, uid, context['partner_id']).property_product_pricelist_purchase.id,
214         'company_id': lambda self,cr,uid,c: self.pool.get('res.company')._company_default_get(cr, uid, 'purchase.order', context=c),
215     }
216     _sql_constraints = [
217         ('name_uniq', 'unique(name, company_id)', 'Order Reference must be unique per Company!'),
218     ]
219     _name = "purchase.order"
220     _inherit = ['mail.thread', 'ir.needaction_mixin']
221     _description = "Purchase Order"
222     _order = "name desc"
223
224     def create(self, cr, uid, vals, context=None):
225         order =  super(purchase_order, self).create(cr, uid, vals, context=context)
226         if order:
227             self.create_send_note(cr, uid, [order], context=context)
228         return order
229
230     def unlink(self, cr, uid, ids, context=None):
231         purchase_orders = self.read(cr, uid, ids, ['state'], context=context)
232         unlink_ids = []
233         for s in purchase_orders:
234             if s['state'] in ['draft','cancel']:
235                 unlink_ids.append(s['id'])
236             else:
237                 raise osv.except_osv(_('Invalid Action!'), _('In order to delete a purchase order, you must cancel it first.'))
238
239         # automatically sending subflow.delete upon deletion
240         wf_service = netsvc.LocalService("workflow")
241         for id in unlink_ids:
242             wf_service.trg_validate(uid, 'purchase.order', id, 'purchase_cancel', cr)
243
244         return super(purchase_order, self).unlink(cr, uid, unlink_ids, context=context)
245
246     def button_dummy(self, cr, uid, ids, context=None):
247         return True
248
249     def onchange_dest_address_id(self, cr, uid, ids, address_id):
250         if not address_id:
251             return {}
252         address = self.pool.get('res.partner')
253         values = {'warehouse_id': False}
254         supplier = address.browse(cr, uid, address_id)
255         if supplier:
256             location_id = supplier.property_stock_customer.id
257             values.update({'location_id': location_id})
258         return {'value':values}
259
260     def onchange_warehouse_id(self, cr, uid, ids, warehouse_id):
261         if not warehouse_id:
262             return {}
263         warehouse = self.pool.get('stock.warehouse').browse(cr, uid, warehouse_id)
264         return {'value':{'location_id': warehouse.lot_input_id.id, 'dest_address_id': False}}
265
266     def onchange_partner_id(self, cr, uid, ids, partner_id):
267         partner = self.pool.get('res.partner')
268         if not partner_id:
269             return {'value':{'fiscal_position': False}}
270         supplier_address = partner.address_get(cr, uid, [partner_id], ['default'])
271         supplier = partner.browse(cr, uid, partner_id)
272         pricelist = supplier.property_product_pricelist_purchase.id
273         fiscal_position = supplier.property_account_position and supplier.property_account_position.id or False
274         return {'value':{'pricelist_id': pricelist, 'fiscal_position': fiscal_position}}
275
276     def view_invoice(self, cr, uid, ids, context=None):
277         '''
278         This function returns an action that display existing invoices of given sale order ids. It can either be a in a list or in a form view, if there is only one invoice to show.
279         '''
280         mod_obj = self.pool.get('ir.model.data')
281         wizard_obj = self.pool.get('purchase.order.line_invoice')
282         #compute the number of invoices to display
283         inv_ids = []
284         for po in self.browse(cr, uid, ids, context=context):
285             if po.invoice_method == 'manual':
286                 if not po.invoice_ids:
287                     context.update({'active_ids' :  [line.id for line in po.order_line]})
288                     wizard_obj.makeInvoices(cr, uid, [], context=context)
289
290         for po in self.browse(cr, uid, ids, context=context):
291             inv_ids+= [invoice.id for invoice in po.invoice_ids]
292         res = mod_obj.get_object_reference(cr, uid, 'account', 'invoice_supplier_form')
293         res_id = res and res[1] or False
294
295         return {
296             'name': _('Supplier Invoices'),
297             'view_type': 'form',
298             'view_mode': 'form',
299             'view_id': [res_id],
300             'res_model': 'account.invoice',
301             'context': "{'type':'in_invoice', 'journal_type': 'purchase'}",
302             'type': 'ir.actions.act_window',
303             'nodestroy': True,
304             'target': 'current',
305             'res_id': inv_ids and inv_ids[0] or False,
306         }
307
308     def view_picking(self, cr, uid, ids, context=None):
309         '''
310         This function returns an action that display existing pîcking orders of given purchase order ids.
311         '''
312         mod_obj = self.pool.get('ir.model.data')
313         pick_ids = []
314         for po in self.browse(cr, uid, ids, context=context):
315             pick_ids += [picking.id for picking in po.picking_ids]
316
317         action_model, action_id = tuple(mod_obj.get_object_reference(cr, uid, 'stock', 'action_picking_tree4'))
318         action = self.pool.get(action_model).read(cr, uid, action_id, context=context)
319         ctx = eval(action['context'])
320         ctx.update({
321             'search_default_purchase_id': ids[0]
322         })
323         if pick_ids and len(pick_ids) == 1:
324             form_view_ids = [view_id for view_id, view in action['views'] if view == 'form']
325             view_id = form_view_ids and form_view_ids[0] or False
326             action.update({
327                 'views': [],
328                 'view_mode': 'form',
329                 'view_id': view_id,
330                 'res_id': pick_ids[0]
331             })
332
333         action.update({
334             'context': ctx,
335         })
336         return action
337
338     def wkf_approve_order(self, cr, uid, ids, context=None):
339         self.write(cr, uid, ids, {'state': 'approved', 'date_approve': fields.date.context_today(self,cr,uid,context=context)})
340         return True
341
342     def wkf_send_rfq(self, cr, uid, ids, context=None):
343         '''
344         This function opens a window to compose an email, with the edi purchase template message loaded by default
345         '''
346         mod_obj = self.pool.get('ir.model.data')
347         template = mod_obj.get_object_reference(cr, uid, 'purchase', 'email_template_edi_purchase')
348         template_id = template and template[1] or False
349         res = mod_obj.get_object_reference(cr, uid, 'mail', 'email_compose_message_wizard_form')
350         res_id = res and res[1] or False
351         ctx = dict(context)
352         ctx.update({
353             'default_model': 'purchase.order',
354             'default_res_id': ids[0],
355             'default_use_template': True,
356             'default_template_id': template_id,
357             })
358         return {
359             'view_type': 'form',
360             'view_mode': 'form',
361             'res_model': 'mail.compose.message',
362             'views': [(res_id, 'form')],
363             'view_id': res_id,
364             'type': 'ir.actions.act_window',
365             'target': 'new',
366             'context': ctx,
367             'nodestroy': True,
368         }
369
370     #TODO: implement messages system
371     def wkf_confirm_order(self, cr, uid, ids, context=None):
372         todo = []
373         for po in self.browse(cr, uid, ids, context=context):
374             if not po.order_line:
375                 raise osv.except_osv(_('Error!'),_('You cannot confirm a purchase order without any purchase order line.'))
376             for line in po.order_line:
377                 if line.state=='draft':
378                     todo.append(line.id)
379
380         self.pool.get('purchase.order.line').action_confirm(cr, uid, todo, context)
381         for id in ids:
382             self.write(cr, uid, [id], {'state' : 'confirmed', 'validator' : uid})
383         self.confirm_send_note(cr, uid, ids, context)
384         return True
385
386     def _prepare_inv_line(self, cr, uid, account_id, order_line, context=None):
387         """Collects require data from purchase order line that is used to create invoice line
388         for that purchase order line
389         :param account_id: Expense account of the product of PO line if any.
390         :param browse_record order_line: Purchase order line browse record
391         :return: Value for fields of invoice lines.
392         :rtype: dict
393         """
394         return {
395             'name': order_line.name,
396             'account_id': account_id,
397             'price_unit': order_line.price_unit or 0.0,
398             'quantity': order_line.product_qty,
399             'product_id': order_line.product_id.id or False,
400             'uos_id': order_line.product_uom.id or False,
401             'invoice_line_tax_id': [(6, 0, [x.id for x in order_line.taxes_id])],
402             'account_analytic_id': order_line.account_analytic_id.id or False,
403         }
404
405     def action_cancel_draft(self, cr, uid, ids, context=None):
406         if not len(ids):
407             return False
408         self.write(cr, uid, ids, {'state':'draft','shipped':0})
409         wf_service = netsvc.LocalService("workflow")
410         for p_id in ids:
411             # Deleting the existing instance of workflow for PO
412             wf_service.trg_delete(uid, 'purchase.order', p_id, cr)
413             wf_service.trg_create(uid, 'purchase.order', p_id, cr)
414         self.draft_send_note(cr, uid, ids, context=context)
415         return True
416
417     def action_invoice_create(self, cr, uid, ids, context=None):
418         """Generates invoice for given ids of purchase orders and links that invoice ID to purchase order.
419         :param ids: list of ids of purchase orders.
420         :return: ID of created invoice.
421         :rtype: int
422         """
423         res = False
424
425         journal_obj = self.pool.get('account.journal')
426         inv_obj = self.pool.get('account.invoice')
427         inv_line_obj = self.pool.get('account.invoice.line')
428         fiscal_obj = self.pool.get('account.fiscal.position')
429         property_obj = self.pool.get('ir.property')
430
431         for order in self.browse(cr, uid, ids, context=context):
432             pay_acc_id = order.partner_id.property_account_payable.id
433             journal_ids = journal_obj.search(cr, uid, [('type', '=','purchase'),('company_id', '=', order.company_id.id)], limit=1)
434             if not journal_ids:
435                 raise osv.except_osv(_('Error!'),
436                     _('Define purchase journal for this company: "%s" (id:%d).') % (order.company_id.name, order.company_id.id))
437
438             # generate invoice line correspond to PO line and link that to created invoice (inv_id) and PO line
439             inv_lines = []
440             for po_line in order.order_line:
441                 if po_line.product_id:
442                     acc_id = po_line.product_id.product_tmpl_id.property_account_expense.id
443                     if not acc_id:
444                         acc_id = po_line.product_id.categ_id.property_account_expense_categ.id
445                     if not acc_id:
446                         raise osv.except_osv(_('Error!'), _('Define expense account for this company: "%s" (id:%d).') % (po_line.product_id.name, po_line.product_id.id,))
447                 else:
448                     acc_id = property_obj.get(cr, uid, 'property_account_expense_categ', 'product.category').id
449                 fpos = order.fiscal_position or False
450                 acc_id = fiscal_obj.map_account(cr, uid, fpos, acc_id)
451
452                 inv_line_data = self._prepare_inv_line(cr, uid, acc_id, po_line, context=context)
453                 inv_line_id = inv_line_obj.create(cr, uid, inv_line_data, context=context)
454                 inv_lines.append(inv_line_id)
455
456                 po_line.write({'invoiced':True, 'invoice_lines': [(4, inv_line_id)]}, context=context)
457
458             # get invoice data and create invoice
459             inv_data = {
460                 'name': order.partner_ref or order.name,
461                 'reference': order.partner_ref or order.name,
462                 'account_id': pay_acc_id,
463                 'type': 'in_invoice',
464                 'partner_id': order.partner_id.id,
465                 'currency_id': order.pricelist_id.currency_id.id,
466                 'journal_id': len(journal_ids) and journal_ids[0] or False,
467                 'invoice_line': [(6, 0, inv_lines)],
468                 'origin': order.name,
469                 'fiscal_position': order.fiscal_position.id or order.partner_id.property_account_position.id,
470                 'payment_term': order.partner_id.property_payment_term and order.partner_id.property_payment_term.id or False,
471                 'company_id': order.company_id.id,
472             }
473             inv_id = inv_obj.create(cr, uid, inv_data, context=context)
474
475             # compute the invoice
476             inv_obj.button_compute(cr, uid, [inv_id], context=context, set_total=True)
477
478             # Link this new invoice to related purchase order
479             order.write({'invoice_ids': [(4, inv_id)]}, context=context)
480             res = inv_id
481         if res:
482             self.invoice_send_note(cr, uid, ids, res, context)
483         return res
484
485     def invoice_done(self, cr, uid, ids, context=None):
486         self.write(cr, uid, ids, {'state':'approved'}, context=context)
487         self.invoice_done_send_note(cr, uid, ids, context=context)
488         return True
489
490     def has_stockable_product(self, cr, uid, ids, *args):
491         for order in self.browse(cr, uid, ids):
492             for order_line in order.order_line:
493                 if order_line.product_id and order_line.product_id.product_tmpl_id.type in ('product', 'consu'):
494                     return True
495         return False
496
497     def action_cancel(self, cr, uid, ids, context=None):
498         wf_service = netsvc.LocalService("workflow")
499         for purchase in self.browse(cr, uid, ids, context=context):
500             for pick in purchase.picking_ids:
501                 if pick.state not in ('draft','cancel'):
502                     raise osv.except_osv(
503                         _('Unable to cancel this purchase order.'),
504                         _('First cancel all receptions related to this purchase order.'))
505             for pick in purchase.picking_ids:
506                 wf_service.trg_validate(uid, 'stock.picking', pick.id, 'button_cancel', cr)
507             for inv in purchase.invoice_ids:
508                 if inv and inv.state not in ('cancel','draft'):
509                     raise osv.except_osv(
510                         _('Unable to cancel this purchase order.'),
511                         _('You must first cancel all receptions related to this purchase order.'))
512                 if inv:
513                     wf_service.trg_validate(uid, 'account.invoice', inv.id, 'invoice_cancel', cr)
514         self.write(cr,uid,ids,{'state':'cancel'})
515
516         for (id, name) in self.name_get(cr, uid, ids):
517             wf_service.trg_validate(uid, 'purchase.order', id, 'purchase_cancel', cr)
518         self.cancel_send_note(cr, uid, ids, context)
519         return True
520
521     def _prepare_order_picking(self, cr, uid, order, context=None):
522         return {
523             'name': self.pool.get('ir.sequence').get(cr, uid, 'stock.picking.in'),
524             'origin': order.name + ((order.origin and (':' + order.origin)) or ''),
525             'date': order.date_order,
526             'partner_id': order.dest_address_id.id or order.partner_id.id,
527             'invoice_state': '2binvoiced' if order.invoice_method == 'picking' else 'none',
528             'type': 'in',
529             'partner_id': order.dest_address_id.id or order.partner_id.id,
530             'invoice_state': '2binvoiced' if order.invoice_method == 'picking' else 'none',
531             'purchase_id': order.id,
532             'company_id': order.company_id.id,
533             'move_lines' : [],
534         }
535
536     def _prepare_order_line_move(self, cr, uid, order, order_line, picking_id, context=None):
537         return {
538             'name': order.name + ': ' + (order_line.name or ''),
539             'product_id': order_line.product_id.id,
540             'product_qty': order_line.product_qty,
541             'product_uos_qty': order_line.product_qty,
542             'product_uom': order_line.product_uom.id,
543             'product_uos': order_line.product_uom.id,
544             'date': order_line.date_planned,
545             'date_expected': order_line.date_planned,
546             'location_id': order.partner_id.property_stock_supplier.id,
547             'location_dest_id': order.location_id.id,
548             'picking_id': picking_id,
549             'partner_id': order.dest_address_id.id or order.partner_id.id,
550             'move_dest_id': order_line.move_dest_id.id,
551             'state': 'draft',
552             'type':'in',
553             'purchase_line_id': order_line.id,
554             'company_id': order.company_id.id,
555             'price_unit': order_line.price_unit
556         }
557
558     def _create_pickings(self, cr, uid, order, order_lines, picking_id=False, context=None):
559         """Creates pickings and appropriate stock moves for given order lines, then
560         confirms the moves, makes them available, and confirms the picking.
561
562         If ``picking_id`` is provided, the stock moves will be added to it, otherwise
563         a standard outgoing picking will be created to wrap the stock moves, as returned
564         by :meth:`~._prepare_order_picking`.
565
566         Modules that wish to customize the procurements or partition the stock moves over
567         multiple stock pickings may override this method and call ``super()`` with
568         different subsets of ``order_lines`` and/or preset ``picking_id`` values.
569
570         :param browse_record order: purchase order to which the order lines belong
571         :param list(browse_record) order_lines: purchase order line records for which picking
572                                                 and moves should be created.
573         :param int picking_id: optional ID of a stock picking to which the created stock moves
574                                will be added. A new picking will be created if omitted.
575         :return: list of IDs of pickings used/created for the given order lines (usually just one)
576         """
577         if not picking_id:
578             picking_id = self.pool.get('stock.picking').create(cr, uid, self._prepare_order_picking(cr, uid, order, context=context))
579         todo_moves = []
580         stock_move = self.pool.get('stock.move')
581         wf_service = netsvc.LocalService("workflow")
582         for order_line in order_lines:
583             if not order_line.product_id:
584                 continue
585             if order_line.product_id.type in ('product', 'consu'):
586                 move = stock_move.create(cr, uid, self._prepare_order_line_move(cr, uid, order, order_line, picking_id, context=context))
587                 if order_line.move_dest_id:
588                     order_line.move_dest_id.write({'location_id': order.location_id.id})
589                 todo_moves.append(move)
590         stock_move.action_confirm(cr, uid, todo_moves)
591         stock_move.force_assign(cr, uid, todo_moves)
592         wf_service.trg_validate(uid, 'stock.picking', picking_id, 'button_confirm', cr)
593         return [picking_id]
594
595     def action_picking_create(self, cr, uid, ids, context=None):
596         picking_ids = []
597         for order in self.browse(cr, uid, ids):
598             picking_ids.extend(self._create_pickings(cr, uid, order, order.order_line, None, context=context))
599
600         # Must return one unique picking ID: the one to connect in the subflow of the purchase order.
601         # In case of multiple (split) pickings, we should return the ID of the critical one, i.e. the
602         # one that should trigger the advancement of the purchase workflow.
603         # By default we will consider the first one as most important, but this behavior can be overridden.
604         if picking_ids:
605             self.shipment_send_note(cr, uid, ids, picking_ids[0], context=context)
606         return picking_ids[0] if picking_ids else False
607
608     def picking_done(self, cr, uid, ids, context=None):
609         self.write(cr, uid, ids, {'shipped':1,'state':'approved'}, context=context)
610         self.shipment_done_send_note(cr, uid, ids, context=context)
611         return True
612
613     def copy(self, cr, uid, id, default=None, context=None):
614         if not default:
615             default = {}
616         default.update({
617             'state':'draft',
618             'shipped':False,
619             'invoiced':False,
620             'invoice_ids': [],
621             'picking_ids': [],
622             'name': self.pool.get('ir.sequence').get(cr, uid, 'purchase.order'),
623         })
624         return super(purchase_order, self).copy(cr, uid, id, default, context)
625
626     def do_merge(self, cr, uid, ids, context=None):
627         """
628         To merge similar type of purchase orders.
629         Orders will only be merged if:
630         * Purchase Orders are in draft
631         * Purchase Orders belong to the same partner
632         * Purchase Orders are have same stock location, same pricelist
633         Lines will only be merged if:
634         * Order lines are exactly the same except for the quantity and unit
635
636          @param self: The object pointer.
637          @param cr: A database cursor
638          @param uid: ID of the user currently logged in
639          @param ids: the ID or list of IDs
640          @param context: A standard dictionary
641
642          @return: new purchase order id
643
644         """
645         #TOFIX: merged order line should be unlink
646         wf_service = netsvc.LocalService("workflow")
647         def make_key(br, fields):
648             list_key = []
649             for field in fields:
650                 field_val = getattr(br, field)
651                 if field in ('product_id', 'move_dest_id', 'account_analytic_id'):
652                     if not field_val:
653                         field_val = False
654                 if isinstance(field_val, browse_record):
655                     field_val = field_val.id
656                 elif isinstance(field_val, browse_null):
657                     field_val = False
658                 elif isinstance(field_val, list):
659                     field_val = ((6, 0, tuple([v.id for v in field_val])),)
660                 list_key.append((field, field_val))
661             list_key.sort()
662             return tuple(list_key)
663
664         # Compute what the new orders should contain
665
666         new_orders = {}
667
668         for porder in [order for order in self.browse(cr, uid, ids, context=context) if order.state == 'draft']:
669             order_key = make_key(porder, ('partner_id', 'location_id', 'pricelist_id'))
670             new_order = new_orders.setdefault(order_key, ({}, []))
671             new_order[1].append(porder.id)
672             order_infos = new_order[0]
673             if not order_infos:
674                 order_infos.update({
675                     'origin': porder.origin,
676                     'date_order': porder.date_order,
677                     'partner_id': porder.partner_id.id,
678                     'dest_address_id': porder.dest_address_id.id,
679                     'warehouse_id': porder.warehouse_id.id,
680                     'location_id': porder.location_id.id,
681                     'pricelist_id': porder.pricelist_id.id,
682                     'state': 'draft',
683                     'order_line': {},
684                     'notes': '%s' % (porder.notes or '',),
685                     'fiscal_position': porder.fiscal_position and porder.fiscal_position.id or False,
686                 })
687             else:
688                 if porder.date_order < order_infos['date_order']:
689                     order_infos['date_order'] = porder.date_order
690                 if porder.notes:
691                     order_infos['notes'] = (order_infos['notes'] or '') + ('\n%s' % (porder.notes,))
692                 if porder.origin:
693                     order_infos['origin'] = (order_infos['origin'] or '') + ' ' + porder.origin
694
695             for order_line in porder.order_line:
696                 line_key = make_key(order_line, ('name', 'date_planned', 'taxes_id', 'price_unit', 'product_id', 'move_dest_id', 'account_analytic_id'))
697                 o_line = order_infos['order_line'].setdefault(line_key, {})
698                 if o_line:
699                     # merge the line with an existing line
700                     o_line['product_qty'] += order_line.product_qty * order_line.product_uom.factor / o_line['uom_factor']
701                 else:
702                     # append a new "standalone" line
703                     for field in ('product_qty', 'product_uom'):
704                         field_val = getattr(order_line, field)
705                         if isinstance(field_val, browse_record):
706                             field_val = field_val.id
707                         o_line[field] = field_val
708                     o_line['uom_factor'] = order_line.product_uom and order_line.product_uom.factor or 1.0
709
710
711
712         allorders = []
713         orders_info = {}
714         for order_key, (order_data, old_ids) in new_orders.iteritems():
715             # skip merges with only one order
716             if len(old_ids) < 2:
717                 allorders += (old_ids or [])
718                 continue
719
720             # cleanup order line data
721             for key, value in order_data['order_line'].iteritems():
722                 del value['uom_factor']
723                 value.update(dict(key))
724             order_data['order_line'] = [(0, 0, value) for value in order_data['order_line'].itervalues()]
725
726             # create the new order
727             neworder_id = self.create(cr, uid, order_data)
728             orders_info.update({neworder_id: old_ids})
729             allorders.append(neworder_id)
730
731             # make triggers pointing to the old orders point to the new order
732             for old_id in old_ids:
733                 wf_service.trg_redirect(uid, 'purchase.order', old_id, neworder_id, cr)
734                 wf_service.trg_validate(uid, 'purchase.order', old_id, 'purchase_cancel', cr)
735         return orders_info
736
737     # --------------------------------------
738     # OpenChatter methods and notifications
739     # --------------------------------------
740
741     def needaction_domain_get(self, cr, uid, ids, context=None):
742         return [('state', '=', 'draft')]
743
744     def create_send_note(self, cr, uid, ids, context=None):
745         return self.message_post(cr, uid, ids, body=_("Request for quotation <b>created</b>."), context=context)
746
747     def confirm_send_note(self, cr, uid, ids, context=None):
748         for obj in self.browse(cr, uid, ids, context=context):
749             self.message_post(cr, uid, [obj.id], body=_("Quotation for <em>%s</em> <b>converted</b> to a Purchase Order of %s %s.") % (obj.partner_id.name, obj.amount_total, obj.pricelist_id.currency_id.symbol), context=context)
750
751     def shipment_send_note(self, cr, uid, ids, picking_id, context=None):
752         for order in self.browse(cr, uid, ids, context=context):
753             for picking in (pck for pck in order.picking_ids if pck.id == picking_id):
754                 # convert datetime field to a datetime, using server format, then
755                 # convert it to the user TZ and re-render it with %Z to add the timezone
756                 picking_datetime = fields.DT.datetime.strptime(picking.min_date, DEFAULT_SERVER_DATETIME_FORMAT)
757                 picking_date_str = fields.datetime.context_timestamp(cr, uid, picking_datetime, context=context).strftime(DATETIME_FORMATS_MAP['%+'] + " (%Z)")
758                 self.message_post(cr, uid, [order.id], body=_("Shipment <em>%s</em> <b>scheduled</b> for %s.") % (picking.name, picking_date_str), context=context)
759
760     def invoice_send_note(self, cr, uid, ids, invoice_id, context=None):
761         for order in self.browse(cr, uid, ids, context=context):
762             for invoice in (inv for inv in order.invoice_ids if inv.id == invoice_id):
763                 self.message_post(cr, uid, [order.id], body=_("Draft Invoice of %s %s is <b>waiting for validation</b>.") % (invoice.amount_total, invoice.currency_id.symbol), context=context)
764
765     def shipment_done_send_note(self, cr, uid, ids, context=None):
766         self.message_post(cr, uid, ids, body=_("""Shipment <b>received</b>."""), context=context)
767
768     def invoice_done_send_note(self, cr, uid, ids, context=None):
769         self.message_post(cr, uid, ids, body=_("Invoice <b>paid</b>."), context=context)
770
771     def draft_send_note(self, cr, uid, ids, context=None):
772         return self.message_post(cr, uid, ids, body=_("Purchase Order has been set to <b>draft</b>."), context=context)
773
774     def cancel_send_note(self, cr, uid, ids, context=None):
775         for obj in self.browse(cr, uid, ids, context=context):
776             self.message_post(cr, uid, [obj.id], body=_("Purchase Order for <em>%s</em> <b>cancelled</b>.") % (obj.partner_id.name), context=context)
777
778 purchase_order()
779
780 class purchase_order_line(osv.osv):
781     def _amount_line(self, cr, uid, ids, prop, arg, context=None):
782         res = {}
783         cur_obj=self.pool.get('res.currency')
784         tax_obj = self.pool.get('account.tax')
785         for line in self.browse(cr, uid, ids, context=context):
786             taxes = tax_obj.compute_all(cr, uid, line.taxes_id, line.price_unit, line.product_qty)
787             cur = line.order_id.pricelist_id.currency_id
788             res[line.id] = cur_obj.round(cr, uid, cur, taxes['total'])
789         return res
790
791     _columns = {
792         'name': fields.text('Description', required=True),
793         'product_qty': fields.float('Quantity', digits_compute=dp.get_precision('Product Unit of Measure'), required=True),
794         'date_planned': fields.date('Scheduled Date', required=True, select=True),
795         'taxes_id': fields.many2many('account.tax', 'purchase_order_taxe', 'ord_id', 'tax_id', 'Taxes'),
796         'product_uom': fields.many2one('product.uom', 'Product Unit of Measure', required=True),
797         'product_id': fields.many2one('product.product', 'Product', domain=[('purchase_ok','=',True)], change_default=True),
798         'move_ids': fields.one2many('stock.move', 'purchase_line_id', 'Reservation', readonly=True, ondelete='set null'),
799         'move_dest_id': fields.many2one('stock.move', 'Reservation Destination', ondelete='set null'),
800         'price_unit': fields.float('Unit Price', required=True, digits_compute= dp.get_precision('Product Price')),
801         'price_subtotal': fields.function(_amount_line, string='Subtotal', digits_compute= dp.get_precision('Account')),
802         'order_id': fields.many2one('purchase.order', 'Order Reference', select=True, required=True, ondelete='cascade'),
803         'account_analytic_id':fields.many2one('account.analytic.account', 'Analytic Account',),
804         'company_id': fields.related('order_id','company_id',type='many2one',relation='res.company',string='Company', store=True, readonly=True),
805         'state': fields.selection([('draft', 'Draft'), ('confirmed', 'Confirmed'), ('done', 'Done'), ('cancel', 'Cancelled')], 'Status', required=True, readonly=True,
806                                   help=' * The \'Draft\' state is set automatically when purchase order in draft state. \
807                                        \n* The \'Confirmed\' state is set automatically as confirm when purchase order in confirm state. \
808                                        \n* The \'Done\' state is set automatically when purchase order is set as done. \
809                                        \n* The \'Cancelled\' state is set automatically when user cancel purchase order.'),
810         'invoice_lines': fields.many2many('account.invoice.line', 'purchase_order_line_invoice_rel', 'order_line_id', 'invoice_id', 'Invoice Lines', readonly=True),
811         'invoiced': fields.boolean('Invoiced', readonly=True),
812         'partner_id': fields.related('order_id','partner_id',string='Partner',readonly=True,type="many2one", relation="res.partner", store=True),
813         'date_order': fields.related('order_id','date_order',string='Order Date',readonly=True,type="date")
814
815     }
816     _defaults = {
817         'product_qty': lambda *a: 1.0,
818         'state': lambda *args: 'draft',
819         'invoiced': lambda *a: 0,
820     }
821     _table = 'purchase_order_line'
822     _name = 'purchase.order.line'
823     _description = 'Purchase Order Line'
824
825     def copy_data(self, cr, uid, id, default=None, context=None):
826         if not default:
827             default = {}
828         default.update({'state':'draft', 'move_ids':[],'invoiced':0,'invoice_lines':[]})
829         return super(purchase_order_line, self).copy_data(cr, uid, id, default, context)
830
831     def onchange_product_uom(self, cr, uid, ids, pricelist_id, product_id, qty, uom_id,
832             partner_id, date_order=False, fiscal_position_id=False, date_planned=False,
833             name=False, price_unit=False, context=None):
834         """
835         onchange handler of product_uom.
836         """
837         if not uom_id:
838             return {'value': {'price_unit': price_unit or 0.0, 'name': name or '', 'product_uom' : uom_id or False}}
839         return self.onchange_product_id(cr, uid, ids, pricelist_id, product_id, qty, uom_id,
840             partner_id, date_order=date_order, fiscal_position_id=fiscal_position_id, date_planned=date_planned,
841             name=name, price_unit=price_unit, context=context)
842
843     def _get_date_planned(self, cr, uid, supplier_info, date_order_str, context=None):
844         """Return the datetime value to use as Schedule Date (``date_planned``) for
845            PO Lines that correspond to the given product.supplierinfo,
846            when ordered at `date_order_str`.
847
848            :param browse_record | False supplier_info: product.supplierinfo, used to
849                determine delivery delay (if False, default delay = 0)
850            :param str date_order_str: date of order, as a string in
851                DEFAULT_SERVER_DATE_FORMAT
852            :rtype: datetime
853            :return: desired Schedule Date for the PO line
854         """
855         supplier_delay = int(supplier_info.delay) if supplier_info else 0
856         return datetime.strptime(date_order_str, DEFAULT_SERVER_DATE_FORMAT) + relativedelta(days=supplier_delay)
857
858     def _check_product_uom_group(self, cr, uid, context=None):
859         group_uom = self.pool.get('ir.model.data').get_object(cr, uid, 'product', 'group_uom')
860         res = [user for user in group_uom.users if user.id == uid]
861         return len(res) and True or False
862
863
864     def onchange_product_id(self, cr, uid, ids, pricelist_id, product_id, qty, uom_id,
865             partner_id, date_order=False, fiscal_position_id=False, date_planned=False,
866             name=False, price_unit=False, context=None):
867         """
868         onchange handler of product_id.
869         """
870         if context is None:
871             context = {}
872
873         res = {'value': {'price_unit': price_unit or 0.0, 'name': name or '', 'product_uom' : uom_id or False}}
874         if not product_id:
875             return res
876
877         product_product = self.pool.get('product.product')
878         product_uom = self.pool.get('product.uom')
879         res_partner = self.pool.get('res.partner')
880         product_supplierinfo = self.pool.get('product.supplierinfo')
881         product_pricelist = self.pool.get('product.pricelist')
882         account_fiscal_position = self.pool.get('account.fiscal.position')
883         account_tax = self.pool.get('account.tax')
884
885         # - check for the presence of partner_id and pricelist_id
886         if not pricelist_id:
887             raise osv.except_osv(_('No Pricelist !'), _('Select a price list for a supplier in the purchase form to choose a product.'))
888         if not partner_id:
889             raise osv.except_osv(_('No Partner!'), _('Select a partner in purchase order to choose a product.'))
890
891         # - determine name and notes based on product in partner lang.
892         lang = res_partner.browse(cr, uid, partner_id).lang
893         context_partner = {'lang': lang, 'partner_id': partner_id}
894         product = product_product.browse(cr, uid, product_id, context=context_partner)
895         name = product.name
896         if product.description_purchase:
897             name += '\n' + product.description_purchase
898         res['value'].update({'name': name})
899
900         # - set a domain on product_uom
901         res['domain'] = {'product_uom': [('category_id','=',product.uom_id.category_id.id)]}
902
903         # - check that uom and product uom belong to the same category
904         product_uom_po_id = product.uom_po_id.id
905         if not uom_id:
906             uom_id = product_uom_po_id
907
908         if product.uom_id.category_id.id != product_uom.browse(cr, uid, uom_id, context=context).category_id.id:
909             if self._check_product_uom_group(cr, uid, context=context):
910                 res['warning'] = {'title': _('Warning!'), 'message': _('Selected Unit of Measure does not belong to the same category as the product Unit of Measure.')}
911             uom_id = product_uom_po_id
912
913         res['value'].update({'product_uom': uom_id})
914
915         # - determine product_qty and date_planned based on seller info
916         if not date_order:
917             date_order = fields.date.context_today(self,cr,uid,context=context)
918
919         qty = qty or 1.0
920         supplierinfo = False
921         for supplier in product.seller_ids:
922             if supplier.name.id == partner_id:
923                 supplierinfo = supplier
924                 if supplierinfo.product_uom.id != uom_id:
925                     res['warning'] = {'title': _('Warning!'), 'message': _('The selected supplier only sells this product by %s') % supplierinfo.product_uom.name }
926                 min_qty = product_uom._compute_qty(cr, uid, supplierinfo.product_uom.id, supplierinfo.min_qty, to_uom_id=uom_id)
927                 if qty < min_qty: # If the supplier quantity is greater than entered from user, set minimal.
928                     res['warning'] = {'title': _('Warning!'), 'message': _('The selected supplier has a minimal quantity set to %s %s, you should not purchase less.') % (supplierinfo.min_qty, supplierinfo.product_uom.name)}
929                     qty = min_qty
930
931         dt = self._get_date_planned(cr, uid, supplierinfo, date_order, context=context).strftime(DEFAULT_SERVER_DATETIME_FORMAT)
932
933         res['value'].update({'date_planned': date_planned or dt, 'product_qty': qty})
934
935         # - determine price_unit and taxes_id
936         price = product_pricelist.price_get(cr, uid, [pricelist_id],
937                     product.id, qty or 1.0, partner_id, {'uom': uom_id, 'date': date_order})[pricelist_id]
938
939         taxes = account_tax.browse(cr, uid, map(lambda x: x.id, product.supplier_taxes_id))
940         fpos = fiscal_position_id and account_fiscal_position.browse(cr, uid, fiscal_position_id, context=context) or False
941         taxes_ids = account_fiscal_position.map_tax(cr, uid, fpos, taxes)
942         res['value'].update({'price_unit': price, 'taxes_id': taxes_ids})
943
944         return res
945
946     product_id_change = onchange_product_id
947     product_uom_change = onchange_product_uom
948
949     def action_confirm(self, cr, uid, ids, context=None):
950         self.write(cr, uid, ids, {'state': 'confirmed'}, context=context)
951         return True
952
953 purchase_order_line()
954
955 class procurement_order(osv.osv):
956     _inherit = 'procurement.order'
957     _columns = {
958         'purchase_id': fields.many2one('purchase.order', 'Purchase Order'),
959     }
960
961     def action_po_assign(self, cr, uid, ids, context=None):
962         """ This is action which call from workflow to assign purchase order to procurements
963         @return: True
964         """
965         res = self.make_po(cr, uid, ids, context=context)
966         res = res.values()
967         return len(res) and res[0] or 0 #TO CHECK: why workflow is generated error if return not integer value
968
969     def create_procurement_purchase_order(self, cr, uid, procurement, po_vals, line_vals, context=None):
970         """Create the purchase order from the procurement, using
971            the provided field values, after adding the given purchase
972            order line in the purchase order.
973
974            :params procurement: the procurement object generating the purchase order
975            :params dict po_vals: field values for the new purchase order (the
976                                  ``order_line`` field will be overwritten with one
977                                  single line, as passed in ``line_vals``).
978            :params dict line_vals: field values of the single purchase order line that
979                                    the purchase order will contain.
980            :return: id of the newly created purchase order
981            :rtype: int
982         """
983         po_vals.update({'order_line': [(0,0,line_vals)]})
984         return self.pool.get('purchase.order').create(cr, uid, po_vals, context=context)
985
986     def _get_purchase_schedule_date(self, cr, uid, procurement, company, context=None):
987         """Return the datetime value to use as Schedule Date (``date_planned``) for the
988            Purchase Order Lines created to satisfy the given procurement.
989
990            :param browse_record procurement: the procurement for which a PO will be created.
991            :param browse_report company: the company to which the new PO will belong to.
992            :rtype: datetime
993            :return: the desired Schedule Date for the PO lines
994         """
995         procurement_date_planned = datetime.strptime(procurement.date_planned, DEFAULT_SERVER_DATETIME_FORMAT)
996         schedule_date = (procurement_date_planned - relativedelta(days=company.po_lead))
997         return schedule_date
998
999     def _get_purchase_order_date(self, cr, uid, procurement, company, schedule_date, context=None):
1000         """Return the datetime value to use as Order Date (``date_order``) for the
1001            Purchase Order created to satisfy the given procurement.
1002
1003            :param browse_record procurement: the procurement for which a PO will be created.
1004            :param browse_report company: the company to which the new PO will belong to.
1005            :param datetime schedule_date: desired Scheduled Date for the Purchase Order lines.
1006            :rtype: datetime
1007            :return: the desired Order Date for the PO
1008         """
1009         seller_delay = int(procurement.product_id.seller_delay)
1010         return schedule_date - relativedelta(days=seller_delay)
1011
1012     def make_po(self, cr, uid, ids, context=None):
1013         """ Make purchase order from procurement
1014         @return: New created Purchase Orders procurement wise
1015         """
1016         res = {}
1017         if context is None:
1018             context = {}
1019         company = self.pool.get('res.users').browse(cr, uid, uid, context=context).company_id
1020         partner_obj = self.pool.get('res.partner')
1021         uom_obj = self.pool.get('product.uom')
1022         pricelist_obj = self.pool.get('product.pricelist')
1023         prod_obj = self.pool.get('product.product')
1024         acc_pos_obj = self.pool.get('account.fiscal.position')
1025         seq_obj = self.pool.get('ir.sequence')
1026         warehouse_obj = self.pool.get('stock.warehouse')
1027         for procurement in self.browse(cr, uid, ids, context=context):
1028             res_id = procurement.move_id.id
1029             partner = procurement.product_id.seller_id # Taken Main Supplier of Product of Procurement.
1030             seller_qty = procurement.product_id.seller_qty
1031             partner_id = partner.id
1032             address_id = partner_obj.address_get(cr, uid, [partner_id], ['delivery'])['delivery']
1033             pricelist_id = partner.property_product_pricelist_purchase.id
1034             warehouse_id = warehouse_obj.search(cr, uid, [('company_id', '=', procurement.company_id.id or company.id)], context=context)
1035             uom_id = procurement.product_id.uom_po_id.id
1036
1037             qty = uom_obj._compute_qty(cr, uid, procurement.product_uom.id, procurement.product_qty, uom_id)
1038             if seller_qty:
1039                 qty = max(qty,seller_qty)
1040
1041             price = pricelist_obj.price_get(cr, uid, [pricelist_id], procurement.product_id.id, qty, partner_id, {'uom': uom_id})[pricelist_id]
1042
1043             schedule_date = self._get_purchase_schedule_date(cr, uid, procurement, company, context=context)
1044             purchase_date = self._get_purchase_order_date(cr, uid, procurement, company, schedule_date, context=context)
1045
1046             #Passing partner_id to context for purchase order line integrity of Line name
1047             new_context = context.copy()
1048             new_context.update({'lang': partner.lang, 'partner_id': partner_id})
1049
1050             product = prod_obj.browse(cr, uid, procurement.product_id.id, context=new_context)
1051             taxes_ids = procurement.product_id.product_tmpl_id.supplier_taxes_id
1052             taxes = acc_pos_obj.map_tax(cr, uid, partner.property_account_position, taxes_ids)
1053
1054             name = product.partner_ref
1055             if product.description_purchase:
1056                 name += '\n'+ product.description_purchase
1057             line_vals = {
1058                 'name': name,
1059                 'product_qty': qty,
1060                 'product_id': procurement.product_id.id,
1061                 'product_uom': uom_id,
1062                 'price_unit': price or 0.0,
1063                 'date_planned': schedule_date.strftime(DEFAULT_SERVER_DATETIME_FORMAT),
1064                 'move_dest_id': res_id,
1065                 'taxes_id': [(6,0,taxes)],
1066             }
1067             name = seq_obj.get(cr, uid, 'purchase.order') or _('PO: %s') % procurement.name
1068             po_vals = {
1069                 'name': name,
1070                 'origin': procurement.origin,
1071                 'partner_id': partner_id,
1072                 'location_id': procurement.location_id.id,
1073                 'warehouse_id': warehouse_id and warehouse_id[0] or False,
1074                 'pricelist_id': pricelist_id,
1075                 'date_order': purchase_date.strftime(DEFAULT_SERVER_DATETIME_FORMAT),
1076                 'company_id': procurement.company_id.id,
1077                 'fiscal_position': partner.property_account_position and partner.property_account_position.id or False
1078             }
1079             res[procurement.id] = self.create_procurement_purchase_order(cr, uid, procurement, po_vals, line_vals, context=new_context)
1080             self.write(cr, uid, [procurement.id], {'state': 'running', 'purchase_id': res[procurement.id]})
1081         self.purchase_order_create_note(cr, uid, ids, context=context)
1082         return res
1083
1084     def purchase_order_create_note(self, cr, uid, ids, context=None):
1085         for procurement in self.browse(cr, uid, ids, context=context):
1086             body = "Draft Purchase Order <em>%s</em> created" % (procurement.purchase_id.name,)
1087             self.message_post(cr, uid, [procurement.id], body=body, context=context)
1088
1089 procurement_order()
1090
1091 class mail_mail(osv.osv):
1092     _name = 'mail.mail'
1093     _inherit = 'mail.mail'
1094
1095     def _postprocess_sent_message(self, cr, uid, mail, context=None):
1096         if mail.model == 'purchase.order':
1097             wf_service = netsvc.LocalService("workflow")
1098             wf_service.trg_validate(uid, 'purchase.order', mail.res_id, 'send_rfq', cr)
1099         return super(mail_mail, self)._postprocess_sent_message(cr, uid, mail=mail, context=context)
1100
1101 mail_mail()
1102
1103 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: