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