1 # -*- encoding: utf-8 -*-
2 ##############################################################################
4 # OpenERP, Open Source Management Solution
5 # Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>). All Rights Reserved
8 # This program is free software: you can redistribute it and/or modify
9 # it under the terms of the GNU Affero General Public License as published by
10 # the Free Software Foundation, either version 3 of the License, or
11 # (at your option) any later version.
13 # This program is distributed in the hope that it will be useful,
14 # but WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU Affero General Public License for more details.
18 # You should have received a copy of the GNU Affero General Public License
19 # along with this program. If not, see <http://www.gnu.org/licenses/>.
21 ##############################################################################
22 from datetime import datetime
23 from dateutil.relativedelta import relativedelta
27 from osv import fields,osv
28 from tools.translate import _
29 import decimal_precision as dp
31 class purchase_requisition(osv.osv):
32 _name = "purchase.requisition"
33 _description="Purchase Requisition"
34 _inherit = ['ir.needaction_mixin', 'mail.thread']
36 'name': fields.char('Requisition Reference', size=32,required=True),
37 'origin': fields.char('Source', size=32),
38 'date_start': fields.datetime('Requisition Date'),
39 'date_end': fields.datetime('Requisition Deadline'),
40 'user_id': fields.many2one('res.users', 'Responsible'),
41 'exclusive': fields.selection([('exclusive','Purchase Requisition (exclusive)'),('multiple','Multiple Requisitions')],'Requisition Type', required=True, help="Purchase Requisition (exclusive): On the confirmation of a purchase order, it cancels the remaining purchase order.\nPurchase Requisition(Multiple): It allows to have multiple purchase orders.On confirmation of a purchase order it does not cancel the remaining orders"""),
42 'description': fields.text('Description'),
43 'company_id': fields.many2one('res.company', 'Company', required=True),
44 'purchase_ids' : fields.one2many('purchase.order','requisition_id','Purchase Orders',states={'done': [('readonly', True)]}),
45 'line_ids' : fields.one2many('purchase.requisition.line','requisition_id','Products to Purchase',states={'done': [('readonly', True)]}),
46 'warehouse_id': fields.many2one('stock.warehouse', 'Warehouse'),
47 'state': fields.selection([('draft','New'),('in_progress','Sent to Suppliers'),('cancel','Cancelled'),('done','Purchase Done')], 'Status', required=True)
50 'date_start': time.strftime('%Y-%m-%d %H:%M:%S'),
52 'exclusive': 'multiple',
53 'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'purchase.requisition', context=c),
54 'user_id': lambda self, cr, uid, c: self.pool.get('res.users').browse(cr, uid, uid, c).id ,
55 'name': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'purchase.order.requisition'),
58 def copy(self, cr, uid, id, default=None, context=None):
64 'name': self.pool.get('ir.sequence').get(cr, uid, 'purchase.order.requisition'),
66 return super(purchase_requisition, self).copy(cr, uid, id, default, context)
68 def tender_cancel(self, cr, uid, ids, context=None):
69 purchase_order_obj = self.pool.get('purchase.order')
70 for purchase in self.browse(cr, uid, ids, context=context):
71 for purchase_id in purchase.purchase_ids:
72 if str(purchase_id.state) in('draft','wait'):
73 purchase_order_obj.action_cancel(cr,uid,[purchase_id.id])
74 self.write(cr, uid, ids, {'state': 'cancel'})
75 self.cancel_send_note(cr, uid, ids, context=context)
78 def tender_in_progress(self, cr, uid, ids, context=None):
79 self.write(cr, uid, ids, {'state':'in_progress'} ,context=context)
80 self.in_progress_send_note(cr, uid, ids, context=context)
83 def tender_reset(self, cr, uid, ids, context=None):
84 self.write(cr, uid, ids, {'state': 'draft'})
85 self.reset_send_note(cr, uid, ids, context=context)
88 def tender_done(self, cr, uid, ids, context=None):
89 self.write(cr, uid, ids, {'state':'done', 'date_end':time.strftime('%Y-%m-%d %H:%M:%S')}, context=context)
90 self.done_to_send_note(cr, uid, ids, context=context)
93 def in_progress_send_note(self, cr, uid, ids, context=None):
94 for requisition in self.browse(cr, uid, ids, context=context):
95 self.message_append_note(cr, uid, [requisition.id], body=_("Draft Requistion is <b>Sent to Suppliers</b>."), context=context)
97 def reset_send_note(self, cr, uid, ids, context=None):
98 self.message_append_note(cr, uid, ids, body=_("""Purchase Requisition <b>set to Draft</b>."""), context=context)
100 def done_to_send_note(self, cr, uid, ids, context=None):
101 self.message_append_note(cr, uid, ids, body=_("Purchase Requisition has been <b>Done</b>."), context=context)
103 def draft_send_note(self, cr, uid, ids, context=None):
104 return self.message_append_note(cr, uid, ids, body=_("Purchase Requisition has been set to <b>draft</b>."), context=context)
106 def cancel_send_note(self, cr, uid, ids, context=None):
107 for obj in self.browse(cr, uid, ids, context=context):
108 self.message_append_note(cr, uid, [obj.id], body=_("Purchase Requisition has been <b>cancelled</b>."), context=context)
110 def _planned_date(self, requisition, delay=0.0):
111 company = requisition.company_id
113 if requisition.date_start:
114 date_planned = datetime.strptime(requisition.date_start, '%Y-%m-%d %H:%M:%S') - relativedelta(days=company.po_lead)
116 date_planned = datetime.today() - relativedelta(days=company.po_lead)
118 date_planned -= relativedelta(days=delay)
119 return date_planned and date_planned.strftime('%Y-%m-%d %H:%M:%S') or False
121 def _seller_details(self, cr, uid, requisition_line, supplier, context=None):
122 product_uom = self.pool.get('product.uom')
123 pricelist = self.pool.get('product.pricelist')
124 supplier_info = self.pool.get("product.supplierinfo")
125 product = requisition_line.product_id
126 default_uom_po_id = product.uom_po_id.id
127 qty = product_uom._compute_qty(cr, uid, requisition_line.product_uom_id.id, requisition_line.product_qty, default_uom_po_id)
131 for product_supplier in product.seller_ids:
132 if supplier.id == product_supplier.name and qty >= product_supplier.qty:
133 seller_delay = product_supplier.delay
134 seller_qty = product_supplier.qty
135 supplier_pricelist = supplier.property_product_pricelist_purchase or False
136 seller_price = pricelist.price_get(cr, uid, [supplier_pricelist.id], product.id, qty, False, {'uom': default_uom_po_id})[supplier_pricelist.id]
138 qty = max(qty,seller_qty)
139 date_planned = self._planned_date(requisition_line.requisition_id, seller_delay)
140 return seller_price, qty, default_uom_po_id, date_planned
142 def make_purchase_order(self, cr, uid, ids, partner_id, context=None):
144 Create New RFQ for Supplier
148 assert partner_id, 'Supplier should be specified'
149 purchase_order = self.pool.get('purchase.order')
150 purchase_order_line = self.pool.get('purchase.order.line')
151 res_partner = self.pool.get('res.partner')
152 fiscal_position = self.pool.get('account.fiscal.position')
153 supplier = res_partner.browse(cr, uid, partner_id, context=context)
154 supplier_pricelist = supplier.property_product_pricelist_purchase or False
156 for requisition in self.browse(cr, uid, ids, context=context):
157 if supplier.id in filter(lambda x: x, [rfq.state <> 'cancel' and rfq.partner_id.id or None for rfq in requisition.purchase_ids]):
158 raise osv.except_osv(_('Warning'), _('You have already one %s purchase order for this partner, you must cancel this purchase order to create a new quotation.') % rfq.state)
159 location_id = requisition.warehouse_id.lot_input_id.id
160 purchase_id = purchase_order.create(cr, uid, {
161 'origin': requisition.name,
162 'partner_id': supplier.id,
163 'pricelist_id': supplier_pricelist.id,
164 'location_id': location_id,
165 'company_id': requisition.company_id.id,
166 'fiscal_position': supplier.property_account_position and supplier.property_account_position.id or False,
167 'requisition_id':requisition.id,
168 'notes':requisition.description,
169 'warehouse_id':requisition.warehouse_id.id ,
171 res[requisition.id] = purchase_id
172 for line in requisition.line_ids:
173 product = line.product_id
174 seller_price, qty, default_uom_po_id, date_planned = self._seller_details(cr, uid, line, supplier, context=context)
175 taxes_ids = product.supplier_taxes_id
176 taxes = fiscal_position.map_tax(cr, uid, supplier.property_account_position, taxes_ids)
177 purchase_order_line.create(cr, uid, {
178 'order_id': purchase_id,
179 'name': product.partner_ref,
181 'product_id': product.id,
182 'product_uom': default_uom_po_id,
183 'price_unit': seller_price,
184 'date_planned': date_planned,
185 'notes': product.description_purchase,
186 'taxes_id': [(6, 0, taxes)],
191 def get_needaction_user_ids(self, cr, uid, ids, context=None):
192 result = dict.fromkeys(ids, [])
193 for obj in self.browse(cr, uid, ids, context=context):
194 if (obj.state == 'draft') and obj.user_id:
195 result[obj.id] = [obj.user_id.id]
198 def create_send_note(self, cr, uid, ids, context=None):
199 return self.message_append_note(cr, uid, ids, body=_("Purchase Requisition has been <b>created</b>."), context=context)
201 def create(self, cr, uid, vals, context=None):
202 requisition = super(purchase_requisition, self).create(cr, uid, vals, context=context)
204 self.create_send_note(cr, uid, [requisition], context=context)
207 purchase_requisition()
209 class purchase_requisition_line(osv.osv):
211 _name = "purchase.requisition.line"
212 _description="Purchase Requisition Line"
213 _rec_name = 'product_id'
215 'product_id': fields.many2one('product.product', 'Product' ),
216 'product_uom_id': fields.many2one('product.uom', 'Product Unit of Measure'),
217 'product_qty': fields.float('Quantity', digits_compute=dp.get_precision('Product Unit of Measure')),
218 'requisition_id' : fields.many2one('purchase.requisition','Purchase Requisition', ondelete='cascade'),
219 'company_id': fields.related('requisition_id','company_id',type='many2one',relation='res.company',string='Company', store=True, readonly=True),
222 def onchange_product_id(self, cr, uid, ids, product_id,product_uom_id, context=None):
223 """ Changes UoM and name if product_id changes.
224 @param name: Name of the field
225 @param product_id: Changed product_id
226 @return: Dictionary of changed values
228 value = {'product_uom_id': ''}
230 prod = self.pool.get('product.product').browse(cr, uid, product_id, context=context)
231 value = {'product_uom_id': prod.uom_id.id,'product_qty':1.0}
232 return {'value': value}
235 'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'purchase.requisition.line', context=c),
237 purchase_requisition_line()
239 class purchase_order(osv.osv):
240 _inherit = "purchase.order"
242 'requisition_id' : fields.many2one('purchase.requisition','Purchase Requisition')
245 def wkf_confirm_order(self, cr, uid, ids, context=None):
246 res = super(purchase_order, self).wkf_confirm_order(cr, uid, ids, context=context)
247 proc_obj = self.pool.get('procurement.order')
248 for po in self.browse(cr, uid, ids, context=context):
249 if po.requisition_id and (po.requisition_id.exclusive=='exclusive'):
250 for order in po.requisition_id.purchase_ids:
252 proc_ids = proc_obj.search(cr, uid, [('purchase_id', '=', order.id)])
253 if proc_ids and po.state=='confirmed':
254 proc_obj.write(cr, uid, proc_ids, {'purchase_id': po.id})
255 wf_service = netsvc.LocalService("workflow")
256 wf_service.trg_validate(uid, 'purchase.order', order.id, 'purchase_cancel', cr)
257 po.requisition_id.tender_done(context=context)
262 class product_product(osv.osv):
263 _inherit = 'product.product'
266 'purchase_requisition': fields.boolean('Purchase Requisition', help="Check this box so that procurement generates purchase requisition instead of only generating requests for quotation.")
269 'purchase_requisition': False
274 class procurement_order(osv.osv):
276 _inherit = 'procurement.order'
278 'requisition_id' : fields.many2one('purchase.requisition','Latest Requisition')
280 def make_po(self, cr, uid, ids, context=None):
281 sequence_obj = self.pool.get('ir.sequence')
282 res = super(procurement_order, self).make_po(cr, uid, ids, context=context)
283 for proc_id, po_id in res.items():
284 procurement = self.browse(cr, uid, proc_id, context=context)
286 if procurement.product_id.purchase_requisition:
287 requisition_id=self.pool.get('purchase.requisition').create(cr, uid, {
288 'name': sequence_obj.get(cr, uid, 'purchase.order.requisition'),
289 'origin': procurement.origin,
290 'date_end': procurement.date_planned,
291 'warehouse_id':procurement.purchase_id and procurement.purchase_id.warehouse_id.id,
292 'company_id':procurement.company_id.id,
294 'product_id': procurement.product_id.id,
295 'product_uom_id': procurement.product_uom.id,
296 'product_qty': procurement.product_qty
299 'purchase_ids': [(6,0,[po_id])]
301 self.write(cr,uid,[proc_id],{'requisition_id':requisition_id},context=context)
306 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: