1 # -*- coding: utf-8 -*-
2 ##############################################################################
4 # OpenERP, Open Source Management Solution
5 # Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
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.
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.
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/>.
20 ##############################################################################
22 from operator import attrgetter
25 from openerp.osv import fields, osv
26 from openerp.tools.translate import _
27 from openerp import netsvc
28 import openerp.addons.decimal_precision as dp
31 # ------------------------------------------------------------------
33 # Produce, Buy or Find products and place a move
34 # then wizard for picking lists & move
37 class mrp_property_group(osv.osv):
39 Group of mrp properties.
41 _name = 'mrp.property.group'
42 _description = 'Property Group'
44 'name': fields.char('Property Group', size=64, required=True),
45 'description': fields.text('Description'),
48 class mrp_property(osv.osv):
52 _name = 'mrp.property'
53 _description = 'Property'
55 'name': fields.char('Name', size=64, required=True),
56 'composition': fields.selection([('min','min'),('max','max'),('plus','plus')], 'Properties composition', required=True, help="Not used in computations, for information purpose only."),
57 'group_id': fields.many2one('mrp.property.group', 'Property Group', required=True),
58 'description': fields.text('Description'),
61 'composition': lambda *a: 'min',
64 class StockMove(osv.osv):
65 _inherit = 'stock.move'
67 'procurements': fields.one2many('procurement.order', 'move_id', 'Procurements'),
70 def copy_data(self, cr, uid, id, default=None, context=None):
73 default['procurements'] = []
74 return super(StockMove, self).copy_data(cr, uid, id, default, context=context)
77 class procurement_order(osv.osv):
81 _name = "procurement.order"
82 _description = "Procurement"
83 _order = 'priority desc,date_planned'
84 _inherit = ['mail.thread']
87 'name': fields.text('Description', required=True),
88 'origin': fields.char('Source Document', size=64,
89 help="Reference of the document that created this Procurement.\n"
90 "This is automatically completed by OpenERP."),
91 'priority': fields.selection([('0','Not urgent'),('1','Normal'),('2','Urgent'),('3','Very Urgent')], 'Priority', required=True, select=True),
92 'date_planned': fields.datetime('Scheduled date', required=True, select=True),
93 'date_close': fields.datetime('Date Closed'),
94 'product_id': fields.many2one('product.product', 'Product', required=True, states={'draft':[('readonly',False)]}, readonly=True),
95 'product_qty': fields.float('Quantity', digits_compute=dp.get_precision('Product Unit of Measure'), required=True, states={'draft':[('readonly',False)]}, readonly=True),
96 'product_uom': fields.many2one('product.uom', 'Product Unit of Measure', required=True, states={'draft':[('readonly',False)]}, readonly=True),
97 'product_uos_qty': fields.float('UoS Quantity', states={'draft':[('readonly',False)]}, readonly=True),
98 'product_uos': fields.many2one('product.uom', 'Product UoS', states={'draft':[('readonly',False)]}, readonly=True),
99 'move_id': fields.many2one('stock.move', 'Reservation', ondelete='set null'),
100 'close_move': fields.boolean('Close Move at end'),
101 'location_id': fields.many2one('stock.location', 'Location', required=True, states={'draft':[('readonly',False)]}, readonly=True),
102 'procure_method': fields.selection([('make_to_stock','Make to Stock'),('make_to_order','Make to Order')], 'Procurement Method', states={'draft':[('readonly',False)], 'confirmed':[('readonly',False)]},
103 readonly=True, required=True, help="If you encode manually a Procurement, you probably want to use" \
104 " a make to order method."),
105 'note': fields.text('Note'),
106 'message': fields.text('Latest error', help="Exception occurred while computing procurement orders."),
107 'state': fields.selection([
109 ('cancel','Cancelled'),
110 ('confirmed','Confirmed'),
111 ('exception','Exception'),
112 ('running','Running'),
115 ('waiting','Waiting')], 'Status', required=True, track_visibility='onchange',
116 help='When a procurement is created the status is set to \'Draft\'.\n If the procurement is confirmed, the status is set to \'Confirmed\'.\
117 \nAfter confirming the status is set to \'Running\'.\n If any exception arises in the order then the status is set to \'Exception\'.\n Once the exception is removed the status becomes \'Ready\'.\n It is in \'Waiting\'. status when the procurement is waiting for another one to finish.'),
118 'note': fields.text('Note'),
119 'company_id': fields.many2one('res.company','Company',required=True),
124 'date_planned': lambda *a: time.strftime('%Y-%m-%d %H:%M:%S'),
126 'procure_method': 'make_to_order',
127 'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'procurement.order', context=c)
130 def unlink(self, cr, uid, ids, context=None):
131 procurements = self.read(cr, uid, ids, ['state'], context=context)
133 for s in procurements:
134 if s['state'] in ['draft','cancel']:
135 unlink_ids.append(s['id'])
137 raise osv.except_osv(_('Invalid Action!'),
138 _('Cannot delete Procurement Order(s) which are in %s state.') % \
140 return osv.osv.unlink(self, cr, uid, unlink_ids, context=context)
142 def onchange_product_id(self, cr, uid, ids, product_id, context=None):
143 """ Finds UoM and UoS of changed product.
144 @param product_id: Changed id of product.
145 @return: Dictionary of values.
148 w = self.pool.get('product.product').browse(cr, uid, product_id, context=context)
150 'product_uom': w.uom_id.id,
151 'product_uos': w.uos_id and w.uos_id.id or w.uom_id.id
156 def is_product(self, cr, uid, ids, context=None):
157 """ Checks product type to decide which transition of the workflow to follow.
158 @return: True if all product ids received in argument are of type 'product' or 'consummable'. False if any is of type 'service'
160 return all(proc.product_id.type in ('product', 'consu') for proc in self.browse(cr, uid, ids, context=context))
162 def check_move_cancel(self, cr, uid, ids, context=None):
163 """ Checks if move is cancelled or not.
164 @return: True or False.
166 return all(procurement.move_id.state == 'cancel' for procurement in self.browse(cr, uid, ids, context=context))
168 #This Function is create to avoid a server side Error Like 'ERROR:tests.mrp:name 'check_move' is not defined'
169 def check_move(self, cr, uid, ids, context=None):
172 def check_move_done(self, cr, uid, ids, context=None):
173 """ Checks if move is done or not.
174 @return: True or False.
176 return all(proc.product_id.type == 'service' or (proc.move_id and proc.move_id.state == 'done') \
177 for proc in self.browse(cr, uid, ids, context=context))
180 # This method may be overrided by objects that override procurement.order
181 # for computing their own purpose
183 def _quantity_compute_get(self, cr, uid, proc, context=None):
184 """ Finds sold quantity of product.
185 @param proc: Current procurement.
186 @return: Quantity or False.
188 if proc.product_id.type == 'product' and proc.move_id:
189 if proc.move_id.product_uos:
190 return proc.move_id.product_uos_qty
193 def _uom_compute_get(self, cr, uid, proc, context=None):
194 """ Finds UoS if product is Stockable Product.
195 @param proc: Current procurement.
196 @return: UoS or False.
198 if proc.product_id.type == 'product' and proc.move_id:
199 if proc.move_id.product_uos:
200 return proc.move_id.product_uos.id
204 # Return the quantity of product shipped/produced/served, which may be
205 # different from the planned quantity
207 def quantity_get(self, cr, uid, id, context=None):
208 """ Finds quantity of product used in procurement.
209 @return: Quantity of product.
211 proc = self.browse(cr, uid, id, context=context)
212 result = self._quantity_compute_get(cr, uid, proc, context=context)
214 result = proc.product_qty
217 def uom_get(self, cr, uid, id, context=None):
218 """ Finds UoM of product used in procurement.
219 @return: UoM of product.
221 proc = self.browse(cr, uid, id, context=context)
222 result = self._uom_compute_get(cr, uid, proc, context=context)
224 result = proc.product_uom.id
227 def check_waiting(self, cr, uid, ids, context=None):
228 """ Checks state of move.
229 @return: True or False
231 for procurement in self.browse(cr, uid, ids, context=context):
232 if procurement.move_id and procurement.move_id.state == 'auto':
236 def check_produce_service(self, cr, uid, procurement, context=None):
237 """ Depicts the capacity of the procurement workflow to deal with production of services.
238 By default, it's False. Overwritten by project_mrp module.
242 def check_produce_product(self, cr, uid, procurement, context=None):
243 """ Depicts the capacity of the procurement workflow to deal with production of products.
244 By default, it's False. Overwritten by mrp module.
248 def check_make_to_stock(self, cr, uid, ids, context=None):
249 """ Checks product type.
250 @return: True or False
253 for procurement in self.browse(cr, uid, ids, context=context):
254 if procurement.product_id.type == 'service':
255 ok = ok and self._check_make_to_stock_service(cr, uid, procurement, context)
257 ok = ok and self._check_make_to_stock_product(cr, uid, procurement, context)
260 def check_produce(self, cr, uid, ids, context=None):
261 """ Checks product type.
262 @return: True or False
264 user = self.pool.get('res.users').browse(cr, uid, uid, context=context)
265 for procurement in self.browse(cr, uid, ids, context=context):
266 product = procurement.product_id
267 #TOFIX: if product type is 'service' but supply_method is 'buy'.
268 if product.supply_method <> 'produce':
270 if product.type=='service':
271 res = self.check_produce_service(cr, uid, procurement, context)
273 res = self.check_produce_product(cr, uid, procurement, context)
278 def check_buy(self, cr, uid, ids):
279 """ Depicts the capacity of the procurement workflow to manage the supply_method == 'buy'.
280 By default, it's False. Overwritten by purchase module.
284 def check_conditions_confirm2wait(self, cr, uid, ids):
285 """ condition on the transition to go from 'confirm' activity to 'confirm_wait' activity """
286 return not self.test_cancel(cr, uid, ids)
288 def test_cancel(self, cr, uid, ids):
289 """ Tests whether state of move is cancelled or not.
290 @return: True or False
292 for record in self.browse(cr, uid, ids):
293 if record.move_id and record.move_id.state == 'cancel':
297 #Initialize get_phantom_bom_id method as it is raising an error from yml of mrp_jit
298 #when one install first mrp and after that, mrp_jit. get_phantom_bom_id defined in mrp module
299 #which is not dependent for mrp_jit.
300 def get_phantom_bom_id(self, cr, uid, ids, context=None):
303 def action_confirm(self, cr, uid, ids, context=None):
304 """ Confirms procurement and writes exception message if any.
307 move_obj = self.pool.get('stock.move')
308 for procurement in self.browse(cr, uid, ids, context=context):
309 if procurement.product_qty <= 0.00:
310 raise osv.except_osv(_('Data Insufficient!'),
311 _('Please check the quantity in procurement order(s) for the product "%s", it should not be 0 or less!' % procurement.product_id.name))
312 if procurement.product_id.type in ('product', 'consu'):
313 if not procurement.move_id:
314 source = procurement.location_id.id
315 if procurement.procure_method == 'make_to_order':
316 source = procurement.product_id.property_stock_procurement.id
317 id = move_obj.create(cr, uid, {
318 'name': procurement.name,
319 'location_id': source,
320 'location_dest_id': procurement.location_id.id,
321 'product_id': procurement.product_id.id,
322 'product_qty': procurement.product_qty,
323 'product_uom': procurement.product_uom.id,
324 'date_expected': procurement.date_planned,
326 'company_id': procurement.company_id.id,
327 'auto_validate': True,
329 move_obj.action_confirm(cr, uid, [id], context=context)
330 self.write(cr, uid, [procurement.id], {'move_id': id, 'close_move': 1})
331 self.write(cr, uid, ids, {'state': 'confirmed', 'message': ''})
334 def action_move_assigned(self, cr, uid, ids, context=None):
335 """ Changes procurement state to Running and writes message.
338 message = _('Products reserved from stock.')
339 self.write(cr, uid, ids, {'state': 'running',
340 'message': message}, context=context)
341 self.message_post(cr, uid, ids, body=message, context=context)
344 def _check_make_to_stock_service(self, cr, uid, procurement, context=None):
346 This method may be overrided by objects that override procurement.order
347 for computing their own purpose
351 def _check_make_to_stock_product(self, cr, uid, procurement, context=None):
352 """ Checks procurement move state.
353 @param procurement: Current procurement.
354 @return: True or move id.
357 if procurement.move_id:
359 id = procurement.move_id.id
360 if not (procurement.move_id.state in ('done','assigned','cancel')):
361 ok = ok and self.pool.get('stock.move').action_assign(cr, uid, [id])
362 order_point_id = self.pool.get('stock.warehouse.orderpoint').search(cr, uid, [('product_id', '=', procurement.product_id.id)], context=context)
363 if not order_point_id and not ok:
364 message = _("Not enough stock and no minimum orderpoint rule defined.")
366 message = _("Not enough stock.")
369 message = _("Procurement '%s' is in exception: ") % (procurement.name) + message
370 #temporary context passed in write to prevent an infinite loop
371 ctx_wkf = dict(context or {})
372 ctx_wkf['workflow.trg_write.%s' % self._name] = False
373 self.write(cr, uid, [procurement.id], {'message': message},context=ctx_wkf)
374 self.message_post(cr, uid, [procurement.id], body=message, context=context)
377 def step_workflow(self, cr, uid, ids, context=None):
378 """ Don't trigger workflow for the element specified in trigger """
379 wkf_op_key = 'workflow.trg_write.%s' % self._name
380 if context and not context.get(wkf_op_key, True):
381 # make sure we don't have a trigger loop while processing triggers
383 return super(procurement_order, self).step_workflow(cr, uid, ids, context=context)
385 def action_produce_assign_service(self, cr, uid, ids, context=None):
386 """ Changes procurement state to Running.
389 for procurement in self.browse(cr, uid, ids, context=context):
390 self.write(cr, uid, [procurement.id], {'state': 'running'})
393 def action_produce_assign_product(self, cr, uid, ids, context=None):
394 """ This is action which call from workflow to assign production order to procurements
400 def action_po_assign(self, cr, uid, ids, context=None):
401 """ This is action which call from workflow to assign purchase order to procurements
406 # XXX action_cancel() should accept a context argument
407 def action_cancel(self, cr, uid, ids):
408 """Cancel Procurements and either cancel or assign the related Stock Moves, depending on the procurement configuration.
414 move_obj = self.pool.get('stock.move')
415 for proc in self.browse(cr, uid, ids):
416 if proc.close_move and proc.move_id:
417 if proc.move_id.state not in ('done', 'cancel'):
418 to_cancel.append(proc.move_id.id)
420 if proc.move_id and proc.move_id.state == 'waiting':
421 to_assign.append(proc.move_id.id)
423 move_obj.action_cancel(cr, uid, to_cancel)
425 move_obj.write(cr, uid, to_assign, {'state': 'assigned'})
426 self.write(cr, uid, ids, {'state': 'cancel'})
427 wf_service = netsvc.LocalService("workflow")
429 wf_service.trg_trigger(uid, 'procurement.order', id, cr)
432 def action_check_finished(self, cr, uid, ids):
433 return self.check_move_done(cr, uid, ids)
435 def action_check(self, cr, uid, ids):
436 """ Checks procurement move state whether assigned or done.
440 for procurement in self.browse(cr, uid, ids):
441 if procurement.move_id and procurement.move_id.state == 'assigned' or procurement.move_id.state == 'done':
442 self.action_done(cr, uid, [procurement.id])
446 def action_ready(self, cr, uid, ids):
447 """ Changes procurement state to Ready.
450 res = self.write(cr, uid, ids, {'state': 'ready'})
453 def action_done(self, cr, uid, ids):
454 """ Changes procurement state to Done and writes Closed date.
457 move_obj = self.pool.get('stock.move')
458 for procurement in self.browse(cr, uid, ids):
459 if procurement.move_id:
460 if procurement.close_move and (procurement.move_id.state <> 'done'):
461 move_obj.action_done(cr, uid, [procurement.move_id.id])
462 res = self.write(cr, uid, ids, {'state': 'done', 'date_close': time.strftime('%Y-%m-%d')})
463 wf_service = netsvc.LocalService("workflow")
465 wf_service.trg_trigger(uid, 'procurement.order', id, cr)
468 class StockPicking(osv.osv):
469 _inherit = 'stock.picking'
470 def test_finished(self, cr, uid, ids):
471 res = super(StockPicking, self).test_finished(cr, uid, ids)
472 for picking in self.browse(cr, uid, ids):
473 for move in picking.move_lines:
474 if move.state == 'done' and move.procurements:
475 self.pool.get('procurement.order').signal_button_check(cr, uid, map(attrgetter('id'), move.procurements))
478 class stock_warehouse_orderpoint(osv.osv):
480 Defines Minimum stock rules.
482 _name = "stock.warehouse.orderpoint"
483 _description = "Minimum Inventory Rule"
485 def _get_draft_procurements(self, cr, uid, ids, field_name, arg, context=None):
489 procurement_obj = self.pool.get('procurement.order')
490 for orderpoint in self.browse(cr, uid, ids, context=context):
491 procurement_ids = procurement_obj.search(cr, uid , [('state', '=', 'draft'), ('product_id', '=', orderpoint.product_id.id), ('location_id', '=', orderpoint.location_id.id)])
492 result[orderpoint.id] = procurement_ids
495 def _check_product_uom(self, cr, uid, ids, context=None):
497 Check if the UoM has the same category as the product standard UoM
502 for rule in self.browse(cr, uid, ids, context=context):
503 if rule.product_id.uom_id.category_id.id != rule.product_uom.category_id.id:
509 'name': fields.char('Name', size=32, required=True),
510 'active': fields.boolean('Active', help="If the active field is set to False, it will allow you to hide the orderpoint without removing it."),
511 'logic': fields.selection([('max','Order to Max'),('price','Best price (not yet active!)')], 'Reordering Mode', required=True),
512 'warehouse_id': fields.many2one('stock.warehouse', 'Warehouse', required=True, ondelete="cascade"),
513 'location_id': fields.many2one('stock.location', 'Location', required=True, ondelete="cascade"),
514 'product_id': fields.many2one('product.product', 'Product', required=True, ondelete='cascade', domain=[('type','!=','service')]),
515 'product_uom': fields.many2one('product.uom', 'Product Unit of Measure', required=True),
516 'product_min_qty': fields.float('Minimum Quantity', required=True,
517 help="When the virtual stock goes below the Min Quantity specified for this field, OpenERP generates "\
518 "a procurement to bring the forecasted quantity to the Max Quantity."),
519 'product_max_qty': fields.float('Maximum Quantity', required=True,
520 help="When the virtual stock goes below the Min Quantity, OpenERP generates "\
521 "a procurement to bring the forecasted quantity to the Quantity specified as Max Quantity."),
522 'qty_multiple': fields.integer('Qty Multiple', required=True,
523 help="The procurement quantity will be rounded up to this multiple."),
524 'procurement_id': fields.many2one('procurement.order', 'Latest procurement', ondelete="set null"),
525 'company_id': fields.many2one('res.company','Company',required=True),
526 'procurement_draft_ids': fields.function(_get_draft_procurements, type='many2many', relation="procurement.order", \
527 string="Related Procurement Orders",help="Draft procurement of the product and location of that orderpoint"),
530 'active': lambda *a: 1,
531 'logic': lambda *a: 'max',
532 'qty_multiple': lambda *a: 1,
533 'name': lambda x,y,z,c: x.pool.get('ir.sequence').get(y,z,'stock.orderpoint') or '',
534 'product_uom': lambda sel, cr, uid, context: context.get('product_uom', False),
535 'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'stock.warehouse.orderpoint', context=c)
538 ('qty_multiple_check', 'CHECK( qty_multiple > 0 )', 'Qty Multiple must be greater than zero.'),
541 (_check_product_uom, 'You have to select a product unit of measure in the same category than the default unit of measure of the product', ['product_id', 'product_uom']),
544 def default_get(self, cr, uid, fields, context=None):
545 res = super(stock_warehouse_orderpoint, self).default_get(cr, uid, fields, context)
546 # default 'warehouse_id' and 'location_id'
547 if 'warehouse_id' not in res:
548 warehouse = self.pool.get('ir.model.data').get_object(cr, uid, 'stock', 'warehouse0', context)
549 res['warehouse_id'] = warehouse.id
550 if 'location_id' not in res:
551 warehouse = self.pool.get('stock.warehouse').browse(cr, uid, res['warehouse_id'], context)
552 res['location_id'] = warehouse.lot_stock_id.id
555 def onchange_warehouse_id(self, cr, uid, ids, warehouse_id, context=None):
556 """ Finds location id for changed warehouse.
557 @param warehouse_id: Changed id of warehouse.
558 @return: Dictionary of values.
561 w = self.pool.get('stock.warehouse').browse(cr, uid, warehouse_id, context=context)
562 v = {'location_id': w.lot_stock_id.id}
566 def onchange_product_id(self, cr, uid, ids, product_id, context=None):
567 """ Finds UoM for changed product.
568 @param product_id: Changed id of product.
569 @return: Dictionary of values.
572 prod = self.pool.get('product.product').browse(cr, uid, product_id, context=context)
573 d = {'product_uom': [('category_id', '=', prod.uom_id.category_id.id)]}
574 v = {'product_uom': prod.uom_id.id}
575 return {'value': v, 'domain': d}
576 return {'domain': {'product_uom': []}}
578 def copy(self, cr, uid, id, default=None, context=None):
582 'name': self.pool.get('ir.sequence').get(cr, uid, 'stock.orderpoint') or '',
584 return super(stock_warehouse_orderpoint, self).copy(cr, uid, id, default, context=context)
586 class product_template(osv.osv):
587 _inherit="product.template"
590 'type': fields.selection([('product','Stockable Product'),('consu', 'Consumable'),('service','Service')], 'Product Type', required=True, help="Consumable: Will not imply stock management for this product. \nStockable product: Will imply stock management for this product."),
591 'procure_method': fields.selection([('make_to_stock','Make to Stock'),('make_to_order','Make to Order')], 'Procurement Method', required=True, help="Make to Stock: When needed, the product is taken from the stock or we wait for replenishment. \nMake to Order: When needed, the product is purchased or produced."),
592 'supply_method': fields.selection([('produce','Manufacture'),('buy','Buy')], 'Supply Method', required=True, help="Manufacture: When procuring the product, a manufacturing order or a task will be generated, depending on the product type. \nBuy: When procuring the product, a purchase order will be generated."),
595 'procure_method': 'make_to_stock',
596 'supply_method': 'buy',
599 class product_product(osv.osv):
600 _inherit="product.product"
602 'orderpoint_ids': fields.one2many('stock.warehouse.orderpoint', 'product_id', 'Minimum Stock Rules'),
607 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: