addons/purchase_requisition/purchase_requisition.py

   1 # -*- encoding: utf-8 -*-
   2 ##############################################################################
   3 #
   4 #    OpenERP, Open Source Management Solution
   5 #    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>). All Rights Reserved
   6 #    $Id$
   7 #
   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.
  12 #
  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.
  17 #
  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/>.
  20 #
  21 ##############################################################################
  22
  23 import time
  24 import netsvc
  25
  26 from osv import fields,osv
  27 from tools.translate import _
  28
  29 class purchase_requisition(osv.osv):
  30     _name = "purchase.requisition"
  31     _description="Purchase Requisition"
  32     _columns = {
  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)
  45     }
  46     _defaults = {
  47         'date_start': time.strftime('%Y-%m-%d %H:%M:%S'),
  48         'state': 'draft',
  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'),
  53     }
  54
  55     def copy(self, cr, uid, id, default=None, context=None):
  56         if not default:
  57             default = {}
  58         default.update({
  59             'state':'draft',
  60             'purchase_ids':[],
  61             'name': self.pool.get('ir.sequence').get(cr, uid, 'purchase.order.requisition'),
  62         })
  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, context=context):
  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'})
  71         return True
  72
  73     def tender_in_progress(self, cr, uid, ids, context=None):
  74         self.write(cr, uid, ids, {'state':'in_progress'} ,context=context)
  75         return True
  76
  77     def tender_reset(self, cr, uid, ids, context=None):
  78         self.write(cr, uid, ids, {'state': 'draft'})
  79         return True
  80
  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)
  83         return True
  84
  85 purchase_requisition()
  86
  87 class purchase_requisition_line(osv.osv):
  88
  89     _name = "purchase.requisition.line"
  90     _description="Purchase Requisition Line"
  91     _rec_name = 'product_id'
  92
  93     _columns = {
  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     }
 100
 101     def onchange_product_id(self, cr, uid, ids, product_id,product_uom_id, context=None):
 102         """ Changes UoM and name if product_id changes.
 103         @param name: Name of the field
 104         @param product_id: Changed product_id
 105         @return:  Dictionary of changed values
 106         """
 107         value = {'product_uom_id': ''}
 108         if product_id:
 109             prod = self.pool.get('product.product').browse(cr, uid, product_id, context=context)
 110             value = {'product_uom_id': prod.uom_id.id,'product_qty':1.0}
 111         return {'value': value}
 112
 113     _defaults = {
 114         'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'purchase.requisition.line', context=c),
 115     }
 116 purchase_requisition_line()
 117
 118 class purchase_order(osv.osv):
 119     _inherit = "purchase.order"
 120     _columns = {
 121         'requisition_id' : fields.many2one('purchase.requisition','Purchase Requisition')
 122     }
 123     def wkf_confirm_order(self, cr, uid, ids, context=None):
 124         res = super(purchase_order, self).wkf_confirm_order(cr, uid, ids, context=context)
 125         proc_obj = self.pool.get('procurement.order')
 126         for po in self.browse(cr, uid, ids, context=context):
 127             if po.requisition_id and (po.requisition_id.exclusive=='exclusive'):
 128                 for order in po.requisition_id.purchase_ids:
 129                     if order.id<>po.id:
 130                         proc_ids = proc_obj.search(cr, uid, [('purchase_id', '=', order.id)])
 131                         if proc_ids and po.state=='confirmed':
 132                             proc_obj.write(cr, uid, proc_ids, {'purchase_id': po.id})
 133                         wf_service = netsvc.LocalService("workflow")
 134                         wf_service.trg_validate(uid, 'purchase.order', order.id, 'purchase_cancel', cr)
 135                     self.pool.get('purchase.requisition').write(cr, uid, [po.requisition_id.id], {'state':'done','date_end':time.strftime('%Y-%m-%d %H:%M:%S')})
 136         return res
 137
 138 purchase_order()
 139
 140 class product_product(osv.osv):
 141     _inherit = 'product.product'
 142
 143     _columns = {
 144         'purchase_requisition': fields.boolean('Purchase Requisition', help="Check this box so that requisitions generates purchase requisitions instead of directly requests for quotations.")
 145     }
 146     _defaults = {
 147         'purchase_requisition': False
 148     }
 149
 150 product_product()
 151
 152 class procurement_order(osv.osv):
 153
 154     _inherit = 'procurement.order'
 155     _columns = {
 156         'requisition_id' : fields.many2one('purchase.requisition','Latest Requisition')
 157     }
 158     def make_po(self, cr, uid, ids, context=None):
 159         sequence_obj = self.pool.get('ir.sequence')
 160         res = super(procurement_order, self).make_po(cr, uid, ids, context=context)
 161         for proc_id, po_id in res.items():
 162             procurement = self.browse(cr, uid, proc_id, context=context)
 163             requisition_id=False
 164             if procurement.product_id.purchase_requisition:
 165                 requisition_id=self.pool.get('purchase.requisition').create(cr, uid, {
 166                     'name': sequence_obj.get(cr, uid, 'purchase.order.requisition'),
 167                     'origin': procurement.name,
 168                     'date_end': procurement.date_planned,
 169                     'warehouse_id':procurement.purchase_id and procurement.purchase_id.warehouse_id.id,
 170                     'company_id':procurement.company_id.id,
 171                     'line_ids': [(0,0,{
 172                         'product_id': procurement.product_id.id,
 173                         'product_uom_id': procurement.product_uom.id,
 174                         'product_qty': procurement.product_qty
 175
 176                     })],
 177                     'purchase_ids': [(6,0,[po_id])]
 178                 })
 179             self.write(cr,uid,proc_id,{'requisition_id':requisition_id})
 180         return res
 181
 182 procurement_order()
 183
 184 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: