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 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 General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with this program. If not, see <http://www.gnu.org/licenses/>.
21 ##############################################################################
26 from osv import fields,osv
27 from tools.translate import _
29 class purchase_requisition(osv.osv):
30 _name = "purchase.requisition"
31 _description="Purchase Requisition"
33 'name': fields.char('Requisition Reference', size=32,required=True),
34 'origin': fields.char('Origin', size=32),
35 'date_start': fields.datetime('Requisition Date'),
36 'date_end': fields.datetime('Requisition Deadline'),
37 'user_id': fields.many2one('res.users', 'Responsible'),
38 '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"""),
39 'description': fields.text('Description'),
40 'company_id': fields.many2one('res.company', 'Company', required=True),
41 'purchase_ids' : fields.one2many('purchase.order','requisition_id','Purchase Orders',states={'done': [('readonly', True)]}),
42 'line_ids' : fields.one2many('purchase.requisition.line','requisition_id','Products to Purchase',states={'done': [('readonly', True)]}),
43 'warehouse_id': fields.many2one('stock.warehouse', 'Warehouse'),
44 'state': fields.selection([('draft','Draft'),('in_progress','In Progress'),('cancel','Cancelled'),('done','Done')], 'State', required=True)
47 'date_start': time.strftime('%Y-%m-%d %H:%M:%S'),
49 'exclusive': 'multiple',
50 'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'purchase.requisition', context=c),
51 'user_id': lambda self, cr, uid, c: self.pool.get('res.users').browse(cr, uid, uid, c).id ,
52 'name': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'purchase.order.requisition'),
55 def copy(self, cr, uid, id, default=None,context={}):
61 'name': self.pool.get('ir.sequence').get(cr, uid, 'purchase.order.requisition'),
63 return super(purchase_requisition, self).copy(cr, uid, id, default, context)
64 def tender_cancel(self, cr, uid, ids, context=None):
65 purchase_order_obj = self.pool.get('purchase.order')
66 for purchase in self.browse(cr, uid, ids):
67 for purchase_id in purchase.purchase_ids:
68 if str(purchase_id.state) in('draft','wait'):
69 purchase_order_obj.action_cancel(cr,uid,[purchase_id.id])
70 self.write(cr, uid, ids, {'state': 'cancel'})
73 def tender_in_progress(self, cr, uid, ids, context=None):
74 self.write(cr, uid, ids, {'state':'in_progress'} ,context=context)
77 def tender_reset(self, cr, uid, ids, context=None):
78 self.write(cr, uid, ids, {'state': 'draft'})
81 def tender_done(self, cr, uid, ids, context=None):
82 self.write(cr, uid, ids, {'state':'done', 'date_end':time.strftime('%Y-%m-%d %H:%M:%S')}, context=context)
85 purchase_requisition()
87 class purchase_requisition_line(osv.osv):
89 _name = "purchase.requisition.line"
90 _description="Purchase Requisition Line"
91 _rec_name = 'product_id'
94 'product_id': fields.many2one('product.product', 'Product' ),
95 'product_uom_id': fields.many2one('product.uom', 'Product UoM'),
96 'product_qty': fields.float('Quantity', digits=(16,2)),
97 'requisition_id' : fields.many2one('purchase.requisition','Purchase Requisition', ondelete='cascade'),
98 'company_id': fields.many2one('res.company', 'Company', required=True),
99 'requisition_id' : fields.many2one('purchase.requisition','Purchase Requisition', ondelete='cascade')
102 def onchange_product_id(self, cr, uid, ids, product_id,product_uom_id, context=None):
103 """ Changes UoM and name if product_id changes.
104 @param name: Name of the field
105 @param product_id: Changed product_id
106 @return: Dictionary of changed values
108 value = {'product_uom_id': ''}
110 prod = self.pool.get('product.product').browse(cr, uid, [product_id])[0]
111 value = {'product_uom_id': prod.uom_id.id,'product_qty':1.0}
112 return {'value': value}
115 'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'purchase.requisition.line', context=c),
117 purchase_requisition_line()
119 class purchase_order(osv.osv):
120 _inherit = "purchase.order"
122 'requisition_id' : fields.many2one('purchase.requisition','Purchase Requisition')
124 def wkf_confirm_order(self, cr, uid, ids, context={}):
125 res = super(purchase_order, self).wkf_confirm_order(cr, uid, ids, context)
126 proc_obj=self.pool.get('procurement.order')
127 for po in self.browse(cr, uid, ids, context):
128 if po.requisition_id and (po.requisition_id.exclusive=='exclusive'):
129 for order in po.requisition_id.purchase_ids:
131 proc_ids = proc_obj.search(cr, uid, [('purchase_id', '=', order.id)])
132 if proc_ids and po.state=='confirmed':
133 proc_obj.wirte(cr,uid,proc_ids,{'purchase_id':po.id})
134 wf_service = netsvc.LocalService("workflow")
135 wf_service.trg_validate(uid, 'purchase.order', order.id, 'purchase_cancel', cr)
136 self.pool.get('purchase.requisition').write(cr, uid, [po.requisition_id.id], {'state':'done','date_end':time.strftime('%Y-%m-%d %H:%M:%S')})
141 class product_product(osv.osv):
142 _inherit = 'product.product'
145 'purchase_requisition': fields.boolean('Purchase Requisition', help="Check this box so that requisitions generates purchase requisitions instead of directly requests for quotations.")
148 'purchase_requisition': False
153 class procurement_order(osv.osv):
155 _inherit = 'procurement.order'
157 'requisition_id' : fields.many2one('purchase.requisition','Latest Requisition')
159 def make_po(self, cr, uid, ids, context=None):
160 sequence_obj = self.pool.get('ir.sequence')
161 res = super(procurement_order, self).make_po(cr, uid, ids, context=context)
162 for proc_id, po_id in res.items():
163 procurement = self.browse(cr, uid, proc_id)
165 if procurement.product_id.purchase_requisition:
166 requisition_id=self.pool.get('purchase.requisition').create(cr, uid, {
167 'name': sequence_obj.get(cr, uid, 'purchase.order.requisition'),
168 'origin': procurement.name,
169 'date_end': procurement.date_planned,
170 'warehouse_id':procurement.purchase_id and procurement.purchase_id.warehouse_id.id,
171 'company_id':procurement.company_id.id,
173 'product_id': procurement.product_id.id,
174 'product_uom_id': procurement.product_uom.id,
175 'product_qty': procurement.product_qty
178 'purchase_ids': [(6,0,[po_id])]
180 self.write(cr,uid,proc_id,{'requisition_id':requisition_id})
185 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: