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