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 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 General Public License for more details.
  17 #
  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/>.
  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 Tender (exclusive)'),('multiple','Multiple Requisitions')],'Requisition Type', required=True, help="Purchase Tender (exclusive):On the confirmation of a purchase order, it cancels the remaining purchase order.Multiple Requisitions: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={}):
  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):
  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         for (id,name) in self.name_get(cr, uid, ids):
  72                     message = _('Tender') + " '" + name + "' "+ _("is cancelled")
  73                     self.log(cr, uid, id, message)
  74         return True
  75
  76     def tender_in_progress(self, cr, uid, ids, context=None):
  77         self.write(cr, uid, ids, {'state':'in_progress'} ,context=context)
  78         for (id,name) in self.name_get(cr, uid, ids):
  79                     message = _('Tender') + " '" + name + "' "+ _(" is In Progress")
  80                     self.log(cr, uid, id, message)
  81         return True
  82
  83     def tender_reset(self, cr, uid, ids, context=None):
  84         self.write(cr, uid, ids, {'state': 'draft'})
  85         for (id,name) in self.name_get(cr, uid, ids):
  86                     message = _('Tender') + " '" + name + "' "+ _("is in draft state")
  87                     self.log(cr, uid, id, message)
  88         return True
  89
  90     def tender_done(self, cr, uid, ids, context=None):
  91         self.write(cr, uid, ids, {'state':'done', 'date_end':time.strftime('%Y-%m-%d %H:%M:%S')}, context=context)
  92         for (id,name) in self.name_get(cr, uid, ids):
  93                     message = _('Tender') + " '" + name + "' "+ _("is done")
  94                     self.log(cr, uid, id, message)
  95         return True
  96
  97 purchase_requisition()
  98
  99 class purchase_requisition_line(osv.osv):
 100
 101     _name = "purchase.requisition.line"
 102     _description="Purchase Requisition Line"
 103     _rec_name = 'product_id'
 104
 105     _columns = {
 106         'product_id': fields.many2one('product.product', 'Product' ),
 107         'product_uom_id': fields.many2one('product.uom', 'Product UoM'),
 108         'product_qty': fields.float('Quantity', digits=(16,2)),
 109         'requisition_id' : fields.many2one('purchase.requisition','Purchase Requisition', ondelete='cascade'),
 110         'company_id': fields.many2one('res.company', 'Company', required=True),
 111         'requisition_id' : fields.many2one('purchase.requisition','Purchase Requisition', ondelete='cascade')
 112     }
 113
 114     def onchange_product_id(self, cr, uid, ids, product_id,product_uom_id, context=None):
 115         """ Changes UoM and name if product_id changes.
 116         @param name: Name of the field
 117         @param product_id: Changed product_id
 118         @return:  Dictionary of changed values
 119         """
 120         value = {'product_uom_id': ''}
 121         if product_id:
 122             prod = self.pool.get('product.product').browse(cr, uid, [product_id])[0]
 123             value = {'product_uom_id': prod.uom_id.id,'product_qty':1.0}
 124         return {'value': value}
 125
 126     _defaults = {
 127         'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'purchase.requisition.line', context=c),
 128     }
 129 purchase_requisition_line()
 130
 131 class purchase_order(osv.osv):
 132     _inherit = "purchase.order"
 133     _columns = {
 134         'requisition_id' : fields.many2one('purchase.requisition','Purchase Requisition')
 135     }
 136     def wkf_confirm_order(self, cr, uid, ids, context={}):
 137         res = super(purchase_order, self).wkf_confirm_order(cr, uid, ids, context)
 138         proc_obj=self.pool.get('procurement.order')
 139         for po in self.browse(cr, uid, ids, context):
 140             if po.requisition_id and (po.requisition_id.exclusive=='exclusive'):
 141                 for order in po.requisition_id.purchase_ids:
 142                     if order.id<>po.id:
 143                         proc_ids = proc_obj.search(cr, uid, [('purchase_id', '=', order.id)])
 144                         if proc_ids and po.state=='confirmed':
 145                             proc_obj.wirte(cr,uid,proc_ids,{'purchase_id':po.id})
 146                         wf_service = netsvc.LocalService("workflow")
 147                         wf_service.trg_validate(uid, 'purchase.order', order.id, 'purchase_cancel', cr)
 148                     self.pool.get('purchase.requisition').write(cr, uid, [po.requisition_id.id], {'state':'done','date_end':time.strftime('%Y-%m-%d %H:%M:%S')})
 149         return res
 150
 151 purchase_order()
 152
 153 class product_product(osv.osv):
 154     _inherit = 'product.product'
 155
 156     _columns = {
 157         'purchase_requisition': fields.boolean('Purchase Requisition', help="Check this box so that requisitions generates purchase requisitions instead of directly requests for quotations.")
 158     }
 159     _defaults = {
 160         'purchase_requisition': False
 161     }
 162
 163 product_product()
 164
 165 class procurement_order(osv.osv):
 166
 167     _inherit = 'procurement.order'
 168     _columns = {
 169         'requisition_id' : fields.many2one('purchase.requisition','Latest Requisition')
 170     }
 171     def make_po(self, cr, uid, ids, context=None):
 172         sequence_obj = self.pool.get('ir.sequence')
 173         res = super(procurement_order, self).make_po(cr, uid, ids, context=context)
 174         for proc_id, po_id in res.items():
 175             procurement = self.browse(cr, uid, proc_id)
 176             requisition_id=False
 177             if procurement.product_id.purchase_requisition:
 178                 requisition_id=self.pool.get('purchase.requisition').create(cr, uid, {
 179                     'name': sequence_obj.get(cr, uid, 'purchase.order.requisition'),
 180                     'origin': procurement.name,
 181                     'date_end': procurement.date_planned,
 182                     'warehouse_id':procurement.purchase_id and procurement.purchase_id.warehouse_id.id,
 183                     'company_id':procurement.company_id.id,
 184                     'line_ids': [(0,0,{
 185                         'product_id': procurement.product_id.id,
 186                         'product_uom_id': procurement.product_uom.id,
 187                         'product_qty': procurement.product_qty
 188
 189                     })],
 190                     'purchase_ids': [(6,0,[po_id])]
 191                 })
 192             self.write(cr,uid,proc_id,{'requisition_id':requisition_id})
 193         return res
 194
 195 procurement_order()
 196
 197 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: