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 osv import osv, fields
23 from tools.translate import _
26 import decimal_precision as dp
29 # ------------------------------------------------------------------
31 # Produce, Buy or Find products and place a move
32 # then wizard for picking lists & move
35 class mrp_property_group(osv.osv):
37 Group of mrp properties.
39 _name = 'mrp.property.group'
40 _description = 'Property Group'
42 'name': fields.char('Property Group', size=64, required=True),
43 'description': fields.text('Description'),
47 class mrp_property(osv.osv):
51 _name = 'mrp.property'
52 _description = 'Property'
54 'name': fields.char('Name', size=64, required=True),
55 'composition': fields.selection([('min','min'),('max','max'),('plus','plus')], 'Properties composition', required=True, help="Not used in computations, for information purpose only."),
56 'group_id': fields.many2one('mrp.property.group', 'Property Group', required=True),
57 'description': fields.text('Description'),
60 '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(self, cr, uid, id, default=None, context=None):
71 default = default or {}
72 default['procurements'] = []
73 return super(StockMove, self).copy(cr, uid, id, default, context=context)
77 class procurement_order(osv.osv):
81 _name = "procurement.order"
82 _description = "Procurement"
83 _order = 'priority,date_planned desc'
84 _inherit = ['mail.thread']
87 'name': fields.char('Reason', size=64, required=True, help='Procurement name.'),
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', required=True),
101 'location_id': fields.many2one('stock.location', 'Location', required=True, states={'draft':[('readonly',False)]}, readonly=True),
102 'procure_method': fields.selection([('make_to_stock','from stock'),('make_to_order','on 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."),
106 'note': fields.text('Note'),
107 'message': fields.char('Latest error', size=124, help="Exception occurred while computing procurement orders."),
108 'state': fields.selection([
110 ('cancel','Cancelled'),
111 ('confirmed','Confirmed'),
112 ('exception','Exception'),
113 ('running','Running'),
116 ('waiting','Waiting')], 'Status', required=True,
117 help='When a procurement is created the state is set to \'Draft\'.\n If the procurement is confirmed, the state is set to \'Confirmed\'.\
118 \nAfter confirming the state is set to \'Running\'.\n If any exception arises in the order then the state is set to \'Exception\'.\n Once the exception is removed the state becomes \'Ready\'.\n It is in \'Waiting\'. state when the procurement is waiting for another one to finish.'),
119 'note': fields.text('Note'),
120 'company_id': fields.many2one('res.company','Company',required=True),
125 'date_planned': lambda *a: time.strftime('%Y-%m-%d %H:%M:%S'),
127 'procure_method': 'make_to_order',
128 'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'procurement.order', context=c)
131 def unlink(self, cr, uid, ids, context=None):
132 procurements = self.read(cr, uid, ids, ['state'], context=context)
134 for s in procurements:
135 if s['state'] in ['draft','cancel']:
136 unlink_ids.append(s['id'])
138 raise osv.except_osv(_('Invalid Action!'),
139 _('Cannot delete Procurement Order(s) which are in %s state.') % \
141 return osv.osv.unlink(self, cr, uid, unlink_ids, context=context)
143 def onchange_product_id(self, cr, uid, ids, product_id, context=None):
144 """ Finds UoM and UoS of changed product.
145 @param product_id: Changed id of product.
146 @return: Dictionary of values.
149 w = self.pool.get('product.product').browse(cr, uid, product_id, context=context)
151 'product_uom': w.uom_id.id,
152 'product_uos': w.uos_id and w.uos_id.id or w.uom_id.id
157 def check_product(self, cr, uid, ids, context=None):
158 """ Checks product type.
159 @return: True or False
161 return all(proc.product_id.type in ('product', 'consu') for proc in self.browse(cr, uid, ids, context=context))
163 def check_move_cancel(self, cr, uid, ids, context=None):
164 """ Checks if move is cancelled or not.
165 @return: True or False.
167 return all(procurement.move_id.state == 'cancel' for procurement in self.browse(cr, uid, ids, context=context))
169 #This Function is create to avoid a server side Error Like 'ERROR:tests.mrp:name 'check_move' is not defined'
170 def check_move(self, cr, uid, ids, context=None):
173 def check_move_done(self, cr, uid, ids, context=None):
174 """ Checks if move is done or not.
175 @return: True or False.
177 return all(proc.product_id.type == 'service' or (proc.move_id and proc.move_id.state == 'done') \
178 for proc in self.browse(cr, uid, ids, context=context))
181 # This method may be overrided by objects that override procurement.order
182 # for computing their own purpose
184 def _quantity_compute_get(self, cr, uid, proc, context=None):
185 """ Finds sold quantity of product.
186 @param proc: Current procurement.
187 @return: Quantity or False.
189 if proc.product_id.type == 'product' and proc.move_id:
190 if proc.move_id.product_uos:
191 return proc.move_id.product_uos_qty
194 def _uom_compute_get(self, cr, uid, proc, context=None):
195 """ Finds UoS if product is Stockable Product.
196 @param proc: Current procurement.
197 @return: UoS or False.
199 if proc.product_id.type == 'product' and proc.move_id:
200 if proc.move_id.product_uos:
201 return proc.move_id.product_uos.id
205 # Return the quantity of product shipped/produced/served, which may be
206 # different from the planned quantity
208 def quantity_get(self, cr, uid, id, context=None):
209 """ Finds quantity of product used in procurement.
210 @return: Quantity of product.
212 proc = self.browse(cr, uid, id, context=context)
213 result = self._quantity_compute_get(cr, uid, proc, context=context)
215 result = proc.product_qty
218 def uom_get(self, cr, uid, id, context=None):
219 """ Finds UoM of product used in procurement.
220 @return: UoM of product.
222 proc = self.browse(cr, uid, id, context=context)
223 result = self._uom_compute_get(cr, uid, proc, context=context)
225 result = proc.product_uom.id
228 def check_waiting(self, cr, uid, ids, context=None):
229 """ Checks state of move.
230 @return: True or False
232 for procurement in self.browse(cr, uid, ids, context=context):
233 if procurement.move_id and procurement.move_id.state == 'auto':
237 def check_produce_service(self, cr, uid, procurement, context=None):
240 def check_produce_product(self, cr, uid, procurement, context=None):
241 """ Finds BoM of a product if not found writes exception message.
242 @param procurement: Current procurement.
243 @return: True or False.
247 def check_make_to_stock(self, cr, uid, ids, context=None):
248 """ Checks product type.
249 @return: True or False
252 for procurement in self.browse(cr, uid, ids, context=context):
253 if procurement.product_id.type == 'service':
254 ok = ok and self._check_make_to_stock_service(cr, uid, procurement, context)
256 ok = ok and self._check_make_to_stock_product(cr, uid, procurement, context)
259 def check_produce(self, cr, uid, ids, context=None):
260 """ Checks product type.
261 @return: True or False
263 user = self.pool.get('res.users').browse(cr, uid, uid, context=context)
264 for procurement in self.browse(cr, uid, ids, context=context):
265 product = procurement.product_id
266 #TOFIX: if product type is 'service' but supply_method is 'buy'.
267 if product.supply_method <> 'produce':
268 supplier = product.seller_id
269 if supplier and user.company_id and user.company_id.partner_id:
270 if supplier.id == user.company_id.partner_id.id:
273 if product.type=='service':
274 res = self.check_produce_service(cr, uid, procurement, context)
276 res = self.check_produce_product(cr, uid, procurement, context)
281 def check_buy(self, cr, uid, ids):
282 """ Checks product type.
283 @return: True or Product Id.
285 user = self.pool.get('res.users').browse(cr, uid, uid)
286 partner_obj = self.pool.get('res.partner')
287 for procurement in self.browse(cr, uid, ids):
288 if procurement.product_id.product_tmpl_id.supply_method <> 'buy':
290 if not procurement.product_id.seller_ids:
291 message = _('No supplier defined for this product !')
292 self.message_append_note(cr, uid, [procurement.id], body=message)
293 cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
295 partner = procurement.product_id.seller_id #Taken Main Supplier of Product of Procurement.
298 message = _('No default supplier defined for this product')
299 self.message_append_note(cr, uid, [procurement.id], body=message)
300 cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
302 if user.company_id and user.company_id.partner_id:
303 if partner.id == user.company_id.partner_id.id:
306 address_id = partner_obj.address_get(cr, uid, [partner.id], ['delivery'])['delivery']
308 message = _('No address defined for the supplier')
309 self.message_append_note(cr, uid, [procurement.id], body=message)
310 cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
314 def test_cancel(self, cr, uid, ids):
315 """ Tests whether state of move is cancelled or not.
316 @return: True or False
318 for record in self.browse(cr, uid, ids):
319 if record.move_id and record.move_id.state == 'cancel':
323 #Initialize get_phantom_bom_id method as it is raising an error from yml of mrp_jit
324 #when one install first mrp and after that, mrp_jit. get_phantom_bom_id defined in mrp module
325 #which is not dependent for mrp_jit.
326 def get_phantom_bom_id(self, cr, uid, ids, context=None):
329 def action_confirm(self, cr, uid, ids, context=None):
330 """ Confirms procurement and writes exception message if any.
333 move_obj = self.pool.get('stock.move')
334 for procurement in self.browse(cr, uid, ids, context=context):
335 if procurement.product_qty <= 0.00:
337 raise osv.except_osv(_('Data Insufficient !'),
338 _('Please check the quantity in procurement order(s) for the product "%s", it should not be 0 or less!' % procurement.product_id.name))
340 raise osv.except_osv(_('Insufficient Data!'),
341 _('Quantity in procurement order(s) must be greater than 0.'))
343 if procurement.product_id.type in ('product', 'consu'):
344 if not procurement.move_id:
345 source = procurement.location_id.id
346 if procurement.procure_method == 'make_to_order':
347 source = procurement.product_id.product_tmpl_id.property_stock_procurement.id
348 id = move_obj.create(cr, uid, {
349 'name': procurement.name,
350 'location_id': source,
351 'location_dest_id': procurement.location_id.id,
352 'product_id': procurement.product_id.id,
353 'product_qty': procurement.product_qty,
354 'product_uom': procurement.product_uom.id,
355 'date_expected': procurement.date_planned,
357 'company_id': procurement.company_id.id,
358 'auto_validate': True,
360 move_obj.action_confirm(cr, uid, [id], context=context)
361 self.write(cr, uid, [procurement.id], {'move_id': id, 'close_move': 1})
362 self.write(cr, uid, ids, {'state': 'confirmed', 'message': ''})
363 self.confirm_send_note(cr, uid, ids, context)
366 def action_move_assigned(self, cr, uid, ids, context=None):
367 """ Changes procurement state to Running and writes message.
370 message = _('From stock: products assigned.')
371 self.write(cr, uid, ids, {'state': 'running',
372 'message': message}, context=context)
373 self.message_append_note(cr, uid, ids, body=message, context=context)
374 self.running_send_note(cr, uid, ids, context=context)
377 def _check_make_to_stock_service(self, cr, uid, procurement, context=None):
379 This method may be overrided by objects that override procurement.order
380 for computing their own purpose
384 def _check_make_to_stock_product(self, cr, uid, procurement, context=None):
385 """ Checks procurement move state.
386 @param procurement: Current procurement.
387 @return: True or move id.
390 if procurement.move_id:
392 id = procurement.move_id.id
393 if not (procurement.move_id.state in ('done','assigned','cancel')):
394 ok = ok and self.pool.get('stock.move').action_assign(cr, uid, [id])
395 order_point_id = self.pool.get('stock.warehouse.orderpoint').search(cr, uid, [('product_id', '=', procurement.product_id.id)], context=context)
396 if not order_point_id and not ok:
397 message = _("Not enough stock and no minimum orderpoint rule defined.")
398 elif not order_point_id:
399 message = _("No minimum orderpoint rule defined.")
401 message = _("Not enough stock.")
404 message = _("Procurement '%s' is in exception: ") % (procurement.name) + message
405 cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
406 self.message_append_note(cr, uid, [procurement.id], body=message, context=context)
409 def action_produce_assign_service(self, cr, uid, ids, context=None):
410 """ Changes procurement state to Running.
413 for procurement in self.browse(cr, uid, ids, context=context):
414 self.write(cr, uid, [procurement.id], {'state': 'running'})
415 self.running_send_note(cr, uid, ids, context=None)
418 def action_produce_assign_product(self, cr, uid, ids, context=None):
419 """ This is action which call from workflow to assign production order to procurements
425 def action_po_assign(self, cr, uid, ids, context=None):
426 """ This is action which call from workflow to assign purchase order to procurements
431 def action_cancel(self, cr, uid, ids):
432 """ Cancels procurement and writes move state to Assigned.
437 move_obj = self.pool.get('stock.move')
438 for proc in self.browse(cr, uid, ids):
439 if proc.close_move and proc.move_id:
440 if proc.move_id.state not in ('done', 'cancel'):
441 todo2.append(proc.move_id.id)
443 if proc.move_id and proc.move_id.state == 'waiting':
444 todo.append(proc.move_id.id)
446 move_obj.action_cancel(cr, uid, todo2)
448 move_obj.write(cr, uid, todo, {'state': 'assigned'})
449 self.write(cr, uid, ids, {'state': 'cancel'})
450 self.cancel_send_note(cr, uid, ids, context=None)
451 wf_service = netsvc.LocalService("workflow")
453 wf_service.trg_trigger(uid, 'procurement.order', id, cr)
456 def action_check_finished(self, cr, uid, ids):
457 return self.check_move_done(cr, uid, ids)
459 def action_check(self, cr, uid, ids):
460 """ Checks procurement move state whether assigned or done.
464 for procurement in self.browse(cr, uid, ids):
465 if procurement.move_id and procurement.move_id.state == 'assigned' or procurement.move_id.state == 'done':
466 self.action_done(cr, uid, [procurement.id])
470 def action_ready(self, cr, uid, ids):
471 """ Changes procurement state to Ready.
474 res = self.write(cr, uid, ids, {'state': 'ready'})
475 self.ready_send_note(cr, uid, ids, context=None)
478 def action_done(self, cr, uid, ids):
479 """ Changes procurement state to Done and writes Closed date.
482 move_obj = self.pool.get('stock.move')
483 for procurement in self.browse(cr, uid, ids):
484 if procurement.move_id:
485 if procurement.close_move and (procurement.move_id.state <> 'done'):
486 move_obj.action_done(cr, uid, [procurement.move_id.id])
487 res = self.write(cr, uid, ids, {'state': 'done', 'date_close': time.strftime('%Y-%m-%d')})
488 self.done_send_note(cr, uid, ids, context=None)
489 wf_service = netsvc.LocalService("workflow")
491 wf_service.trg_trigger(uid, 'procurement.order', id, cr)
494 # ----------------------------------------
495 # OpenChatter methods and notifications
496 # ----------------------------------------
498 def create(self, cr, uid, vals, context=None):
499 obj_id = super(procurement_order, self).create(cr, uid, vals, context)
500 self.create_send_note(cr, uid, [obj_id], context=context)
503 def create_send_note(self, cr, uid, ids, context=None):
504 self.message_append_note(cr, uid, ids, body=_("Procurement has been <b>created</b>."), context=context)
506 def confirm_send_note(self, cr, uid, ids, context=None):
507 self.message_append_note(cr, uid, ids, body=_("Procurement has been <b>confirmed</b>."), context=context)
509 def running_send_note(self, cr, uid, ids, context=None):
510 self.message_append_note(cr, uid, ids, body=_("Procurement has been set to <b>running</b>."), context=context)
512 def ready_send_note(self, cr, uid, ids, context=None):
513 self.message_append_note(cr, uid, ids, body=_("Procurement has been set to <b>ready</b>."), context=context)
515 def cancel_send_note(self, cr, uid, ids, context=None):
516 self.message_append_note(cr, uid, ids, body=_("Procurement has been <b>cancelled</b>."), context=context)
518 def done_send_note(self, cr, uid, ids, context=None):
519 self.message_append_note(cr, uid, ids, body=_("Procurement has been <b>done</b>."), context=context)
523 class StockPicking(osv.osv):
524 _inherit = 'stock.picking'
526 def test_finished(self, cursor, user, ids):
527 wf_service = netsvc.LocalService("workflow")
528 res = super(StockPicking, self).test_finished(cursor, user, ids)
529 for picking in self.browse(cursor, user, ids):
530 for move in picking.move_lines:
531 if move.state == 'done' and move.procurements:
532 for procurement in move.procurements:
533 wf_service.trg_validate(user, 'procurement.order',
534 procurement.id, 'button_check', cursor)
539 class stock_warehouse_orderpoint(osv.osv):
541 Defines Minimum stock rules.
543 _name = "stock.warehouse.orderpoint"
544 _description = "Minimum Inventory Rule"
546 def _get_draft_procurements(self, cr, uid, ids, field_name, arg, context=None):
550 procurement_obj = self.pool.get('procurement.order')
551 for orderpoint in self.browse(cr, uid, ids, context=context):
552 procurement_ids = procurement_obj.search(cr, uid , [('state', '=', 'draft'), ('product_id', '=', orderpoint.product_id.id), ('location_id', '=', orderpoint.location_id.id)])
553 result[orderpoint.id] = procurement_ids
557 'name': fields.char('Name', size=32, required=True),
558 'active': fields.boolean('Active', help="If the active field is set to False, it will allow you to hide the orderpoint without removing it."),
559 'logic': fields.selection([('max','Order to Max'),('price','Best price (not yet active!)')], 'Reordering Mode', required=True),
560 'warehouse_id': fields.many2one('stock.warehouse', 'Warehouse', required=True, ondelete="cascade"),
561 'location_id': fields.many2one('stock.location', 'Location', required=True, ondelete="cascade"),
562 'product_id': fields.many2one('product.product', 'Product', required=True, ondelete='cascade', domain=[('type','=','product')]),
563 'product_uom': fields.many2one('product.uom', 'Product Unit of Measure', required=True),
564 'product_min_qty': fields.float('Minimum Quantity', required=True,
565 help="When the virtual stock goes below the Min Quantity specified for this field, OpenERP generates "\
566 "a procurement to bring the virtual stock to the Max Quantity."),
567 'product_max_qty': fields.float('Maximum Quantity', required=True,
568 help="When the virtual stock goes below the Min Quantity, OpenERP generates "\
569 "a procurement to bring the virtual stock to the Quantity specified as Max Quantity."),
570 'qty_multiple': fields.integer('Qty Multiple', required=True,
571 help="The procurement quantity will be rounded up to this multiple."),
572 'procurement_id': fields.many2one('procurement.order', 'Latest procurement', ondelete="set null"),
573 'company_id': fields.many2one('res.company','Company',required=True),
574 'procurement_draft_ids': fields.function(_get_draft_procurements, type='many2many', relation="procurement.order", \
575 string="Related Procurement Orders",help="Draft procurement of the product and location of that orderpoint"),
578 'active': lambda *a: 1,
579 'logic': lambda *a: 'max',
580 'qty_multiple': lambda *a: 1,
581 'name': lambda x,y,z,c: x.pool.get('ir.sequence').get(y,z,'stock.orderpoint') or '',
582 'product_uom': lambda sel, cr, uid, context: context.get('product_uom', False),
583 'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'stock.warehouse.orderpoint', context=c)
586 ('qty_multiple_check', 'CHECK( qty_multiple > 0 )', 'Qty Multiple must be greater than zero.'),
589 def default_get(self, cr, uid, fields, context=None):
590 res = super(stock_warehouse_orderpoint, self).default_get(cr, uid, fields, context)
591 # default 'warehouse_id' and 'location_id'
592 if 'warehouse_id' not in res:
593 warehouse = self.pool.get('ir.model.data').get_object(cr, uid, 'stock', 'warehouse0', context)
594 res['warehouse_id'] = warehouse.id
595 if 'location_id' not in res:
596 warehouse = self.pool.get('stock.warehouse').browse(cr, uid, res['warehouse_id'], context)
597 res['location_id'] = warehouse.lot_stock_id.id
600 def onchange_warehouse_id(self, cr, uid, ids, warehouse_id, context=None):
601 """ Finds location id for changed warehouse.
602 @param warehouse_id: Changed id of warehouse.
603 @return: Dictionary of values.
606 w = self.pool.get('stock.warehouse').browse(cr, uid, warehouse_id, context=context)
607 v = {'location_id': w.lot_stock_id.id}
611 def onchange_product_id(self, cr, uid, ids, product_id, context=None):
612 """ Finds UoM for changed product.
613 @param product_id: Changed id of product.
614 @return: Dictionary of values.
617 prod = self.pool.get('product.product').browse(cr, uid, product_id, context=context)
618 v = {'product_uom': prod.uom_id.id}
622 def copy(self, cr, uid, id, default=None, context=None):
626 'name': self.pool.get('ir.sequence').get(cr, uid, 'stock.orderpoint') or '',
628 return super(stock_warehouse_orderpoint, self).copy(cr, uid, id, default, context=context)
630 stock_warehouse_orderpoint()
632 class product_product(osv.osv):
633 _inherit="product.product"
635 'orderpoint_ids': fields.one2many('stock.warehouse.orderpoint', 'product_id', 'Minimum Stock Rules'),
640 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: