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 openerp.osv import fields
23 from openerp.osv import osv
25 from datetime import datetime
26 from openerp.tools.translate import _
28 #----------------------------------------------------------
30 #----------------------------------------------------------
31 # capacity_hour : capacity per hour. default: 1.0.
32 # Eg: If 5 concurrent operations at one time: capacity = 5 (because 5 employees)
33 # unit_per_cycle : how many units are produced for one cycle
35 class stock_move(osv.osv):
36 _inherit = 'stock.move'
38 'move_dest_id_lines': fields.one2many('stock.move','move_dest_id', 'Children Moves')
41 class mrp_production_workcenter_line(osv.osv):
43 def _get_date_end(self, cr, uid, ids, field_name, arg, context=None):
44 """ Finds ending date.
45 @return: Dictionary of values.
47 ops = self.browse(cr, uid, ids, context=context)
48 date_and_hours_by_cal = [(op.date_planned, op.hour, op.workcenter_id.calendar_id.id) for op in ops if op.date_planned]
50 intervals = self.pool.get('resource.calendar').interval_get_multi(cr, uid, date_and_hours_by_cal)
56 i = intervals.get((op.date_planned, op.hour, op.workcenter_id.calendar_id.id))
58 res[op.id] = i[-1][1].strftime('%Y-%m-%d %H:%M:%S')
60 res[op.id] = op.date_planned
63 def onchange_production_id(self, cr, uid, ids, production_id, context=None):
66 production = self.pool.get('mrp.production').browse(cr, uid, production_id, context=None)
68 'product': production.product_id.id,
69 'qty': production.product_qty,
70 'uom': production.product_uom.id,
72 return {'value': result}
74 _inherit = 'mrp.production.workcenter.line'
75 _order = "sequence, date_planned"
78 'state': fields.selection([('draft','Draft'),('cancel','Cancelled'),('pause','Pending'),('startworking', 'In Progress'),('done','Finished')],'Status', readonly=True, copy=False,
79 help="* When a work order is created it is set in 'Draft' status.\n" \
80 "* When user sets work order in start mode that time it will be set in 'In Progress' status.\n" \
81 "* When work order is in running mode, during that time if user wants to stop or to make changes in order then can set in 'Pending' status.\n" \
82 "* When the user cancels the work order it will be set in 'Canceled' status.\n" \
83 "* When order is completely processed that time it is set in 'Finished' status."),
84 'date_planned': fields.datetime('Scheduled Date', select=True),
85 'date_planned_end': fields.function(_get_date_end, string='End Date', type='datetime'),
86 'date_start': fields.datetime('Start Date'),
87 'date_finished': fields.datetime('End Date'),
88 'delay': fields.float('Working Hours',help="The elapsed time between operation start and stop in this Work Center",readonly=True),
89 'production_state':fields.related('production_id','state',
91 selection=[('draft','Draft'),('confirmed','Waiting Goods'),('ready','Ready to Produce'),('in_production','In Production'),('cancel','Canceled'),('done','Done')],
92 string='Production Status', readonly=True),
93 'product':fields.related('production_id','product_id',type='many2one',relation='product.product',string='Product',
95 'qty':fields.related('production_id','product_qty',type='float',string='Qty',readonly=True, store=True),
96 'uom':fields.related('production_id','product_uom',type='many2one',relation='product.uom',string='Unit of Measure',readonly=True),
102 'production_state': 'draft'
105 def modify_production_order_state(self, cr, uid, ids, action):
106 """ Modifies production order state if work order state is changed.
107 @param action: Action to perform.
110 prod_obj_pool = self.pool.get('mrp.production')
111 oper_obj = self.browse(cr, uid, ids)[0]
112 prod_obj = oper_obj.production_id
113 if action == 'start':
114 if prod_obj.state =='confirmed':
115 prod_obj_pool.force_production(cr, uid, [prod_obj.id])
116 prod_obj_pool.signal_workflow(cr, uid, [prod_obj.id], 'button_produce')
117 elif prod_obj.state =='ready':
118 prod_obj_pool.signal_workflow(cr, uid, [prod_obj.id], 'button_produce')
119 elif prod_obj.state =='in_production':
122 raise osv.except_osv(_('Error!'),_('Manufacturing order cannot be started in state "%s"!') % (prod_obj.state,))
124 open_count = self.search_count(cr,uid,[('production_id','=',prod_obj.id), ('state', '!=', 'done')])
125 flag = not bool(open_count)
127 for production in prod_obj_pool.browse(cr, uid, [prod_obj.id], context= None):
128 if production.move_lines or production.move_created_ids:
129 prod_obj_pool.action_produce(cr,uid, production.id, production.product_qty, 'consume_produce', context = None)
130 prod_obj_pool.signal_workflow(cr, uid, [oper_obj.production_id.id], 'button_produce_done')
133 def write(self, cr, uid, ids, vals, context=None, update=True):
134 result = super(mrp_production_workcenter_line, self).write(cr, uid, ids, vals, context=context)
135 prod_obj = self.pool.get('mrp.production')
136 if vals.get('date_planned', False) and update:
137 for prod in self.browse(cr, uid, ids, context=context):
138 if prod.production_id.workcenter_lines:
139 dstart = min(vals['date_planned'], prod.production_id.workcenter_lines[0]['date_planned'])
140 prod_obj.write(cr, uid, [prod.production_id.id], {'date_start':dstart}, context=context, mini=False)
143 def action_draft(self, cr, uid, ids, context=None):
144 """ Sets state to draft.
147 return self.write(cr, uid, ids, {'state': 'draft'}, context=context)
149 def action_start_working(self, cr, uid, ids, context=None):
150 """ Sets state to start working and writes starting date.
153 self.modify_production_order_state(cr, uid, ids, 'start')
154 self.write(cr, uid, ids, {'state':'startworking', 'date_start': time.strftime('%Y-%m-%d %H:%M:%S')}, context=context)
157 def action_done(self, cr, uid, ids, context=None):
158 """ Sets state to done, writes finish date and calculates delay.
162 date_now = time.strftime('%Y-%m-%d %H:%M:%S')
163 obj_line = self.browse(cr, uid, ids[0])
165 date_start = datetime.strptime(obj_line.date_start,'%Y-%m-%d %H:%M:%S')
166 date_finished = datetime.strptime(date_now,'%Y-%m-%d %H:%M:%S')
167 delay += (date_finished-date_start).days * 24
168 delay += (date_finished-date_start).seconds / float(60*60)
170 self.write(cr, uid, ids, {'state':'done', 'date_finished': date_now,'delay':delay}, context=context)
171 self.modify_production_order_state(cr,uid,ids,'done')
174 def action_cancel(self, cr, uid, ids, context=None):
175 """ Sets state to cancel.
178 return self.write(cr, uid, ids, {'state':'cancel'}, context=context)
180 def action_pause(self, cr, uid, ids, context=None):
181 """ Sets state to pause.
184 return self.write(cr, uid, ids, {'state':'pause'}, context=context)
186 def action_resume(self, cr, uid, ids, context=None):
187 """ Sets state to startworking.
190 return self.write(cr, uid, ids, {'state':'startworking'}, context=context)
193 class mrp_production(osv.osv):
194 _inherit = 'mrp.production'
196 'allow_reorder': fields.boolean('Free Serialisation', help="Check this to be able to move independently all production orders, without moving dependent ones."),
199 def _production_date_end(self, cr, uid, ids, prop, unknow_none, context=None):
200 """ Calculates planned end date of production order.
201 @return: Dictionary of values
204 for prod in self.browse(cr, uid, ids, context=context):
205 result[prod.id] = prod.date_planned
206 for line in prod.workcenter_lines:
207 result[prod.id] = max(line.date_planned_end, result[prod.id])
210 def action_production_end(self, cr, uid, ids):
211 """ Finishes work order if production order is done.
212 @return: Super method
214 obj = self.browse(cr, uid, ids)[0]
215 workcenter_pool = self.pool.get('mrp.production.workcenter.line')
216 for workcenter_line in obj.workcenter_lines:
217 if workcenter_line.state == 'draft':
218 workcenter_line.signal_workflow('button_start_working')
219 workcenter_line.signal_workflow('button_done')
220 return super(mrp_production,self).action_production_end(cr, uid, ids)
222 def action_in_production(self, cr, uid, ids):
223 """ Changes state to In Production and writes starting date.
226 workcenter_pool = self.pool.get('mrp.production.workcenter.line')
227 for prod in self.browse(cr, uid, ids):
228 if prod.workcenter_lines:
229 workcenter_pool.signal_workflow(cr, uid, [prod.workcenter_lines[0].id], 'button_start_working')
230 return super(mrp_production,self).action_in_production(cr, uid, ids)
232 def action_cancel(self, cr, uid, ids, context=None):
233 """ Cancels work order if production order is canceled.
234 @return: Super method
236 workcenter_pool = self.pool.get('mrp.production.workcenter.line')
237 obj = self.browse(cr, uid, ids,context=context)[0]
238 workcenter_pool.signal_workflow(cr, uid, [record.id for record in obj.workcenter_lines], 'button_cancel')
239 return super(mrp_production,self).action_cancel(cr,uid,ids,context=context)
241 def _compute_planned_workcenter(self, cr, uid, ids, context=None, mini=False):
242 """ Computes planned and finished dates for work order.
243 @return: Calculated date
245 dt_end = datetime.now()
248 for po in self.browse(cr, uid, ids, context=context):
249 dt_end = datetime.strptime(po.date_planned, '%Y-%m-%d %H:%M:%S')
250 if not po.date_start:
251 self.write(cr, uid, [po.id], {
252 'date_start': po.date_planned
253 }, context=context, update=False)
255 for wci in range(len(po.workcenter_lines)):
256 wc = po.workcenter_lines[wci]
257 if (old is None) or (wc.sequence>old):
259 if context.get('__last_update'):
260 del context['__last_update']
261 if (wc.date_planned < dt.strftime('%Y-%m-%d %H:%M:%S')) or mini:
262 self.pool.get('mrp.production.workcenter.line').write(cr, uid, [wc.id], {
263 'date_planned': dt.strftime('%Y-%m-%d %H:%M:%S')
264 }, context=context, update=False)
265 i = self.pool.get('resource.calendar').interval_get(
268 #passing False makes resource_resource._schedule_hours run 1000 iterations doing nothing
269 wc.workcenter_id.calendar_id and wc.workcenter_id.calendar_id.id or None,
274 dt_end = max(dt_end, i[-1][1])
276 dt_end = datetime.strptime(wc.date_planned_end, '%Y-%m-%d %H:%M:%S')
278 old = wc.sequence or 0
279 super(mrp_production, self).write(cr, uid, [po.id], {
280 'date_finished': dt_end
284 def _move_pass(self, cr, uid, ids, context=None):
285 """ Calculates start date for stock moves finding interval from resource calendar.
288 for po in self.browse(cr, uid, ids, context=context):
291 todo = list(po.move_lines)
292 dt = datetime.strptime(po.date_start,'%Y-%m-%d %H:%M:%S')
295 if l.state in ('done','cancel','draft'):
297 todo += l.move_dest_id_lines
298 if l.production_id and (l.production_id.date_finished > dt):
299 if l.production_id.state not in ('done','cancel'):
300 for wc in l.production_id.workcenter_lines:
301 i = self.pool.get('resource.calendar').interval_min_get(
304 wc.workcenter_id.calendar_id.id or False,
308 if l.production_id.date_start > dt.strftime('%Y-%m-%d %H:%M:%S'):
309 self.write(cr, uid, [l.production_id.id], {'date_start':dt.strftime('%Y-%m-%d %H:%M:%S')}, mini=True)
312 def _move_futur(self, cr, uid, ids, context=None):
313 """ Calculates start date for stock moves.
316 for po in self.browse(cr, uid, ids, context=context):
319 for line in po.move_created_ids:
321 while l.move_dest_id:
323 if l.state in ('done','cancel','draft'):
325 if l.production_id.state in ('done','cancel'):
327 if l.production_id and (l.production_id.date_start < po.date_finished):
328 self.write(cr, uid, [l.production_id.id], {'date_start': po.date_finished})
333 def write(self, cr, uid, ids, vals, context=None, update=True, mini=True):
335 if vals.get('date_start', False):
336 for po in self.browse(cr, uid, ids, context=context):
337 direction[po.id] = cmp(po.date_start, vals.get('date_start', False))
338 result = super(mrp_production, self).write(cr, uid, ids, vals, context=context)
339 if (vals.get('workcenter_lines', False) or vals.get('date_start', False)) and update:
340 self._compute_planned_workcenter(cr, uid, ids, context=context, mini=mini)
342 if direction[d] == 1:
343 # the production order has been moved to the passed
344 self._move_pass(cr, uid, [d], context=context)
346 elif direction[d] == -1:
347 self._move_futur(cr, uid, [d], context=context)
348 # the production order has been moved to the future
352 def action_compute(self, cr, uid, ids, properties=None, context=None):
353 """ Computes bills of material of a product and planned date of work order.
354 @param properties: List containing dictionaries of properties.
355 @return: No. of products.
357 result = super(mrp_production, self).action_compute(cr, uid, ids, properties=properties, context=context)
358 self._compute_planned_workcenter(cr, uid, ids, context=context)
362 class mrp_operations_operation_code(osv.osv):
363 _name="mrp_operations.operation.code"
365 'name': fields.char('Operation Name', required=True),
366 'code': fields.char('Code', size=16, required=True),
367 'start_stop': fields.selection([('start','Start'),('pause','Pause'),('resume','Resume'),('cancel','Cancelled'),('done','Done')], 'Status', required=True),
370 class mrp_operations_operation(osv.osv):
371 _name="mrp_operations.operation"
373 def _order_date_search_production(self, cr, uid, ids, context=None):
374 """ Finds operations for a production order.
377 operation_ids = self.pool.get('mrp_operations.operation').search(cr, uid, [('production_id','=',ids[0])], context=context)
380 def _get_order_date(self, cr, uid, ids, field_name, arg, context=None):
381 """ Calculates planned date for an operation.
382 @return: Dictionary of values
385 operation_obj = self.browse(cr, uid, ids, context=context)
386 for operation in operation_obj:
387 res[operation.id] = operation.production_id.date_planned
390 def calc_delay(self, cr, uid, vals):
391 """ Calculates delay of work order.
397 code_ids = self.pool.get('mrp_operations.operation.code').search(cr, uid, [('id','=',vals['code_id'])])
398 code = self.pool.get('mrp_operations.operation.code').browse(cr, uid, code_ids)[0]
400 oper_ids = self.search(cr,uid,[('production_id','=',vals['production_id']),('workcenter_id','=',vals['workcenter_id'])])
401 oper_objs = self.browse(cr,uid,oper_ids)
403 for oper in oper_objs:
404 code_lst.append(oper.code_id.start_stop)
405 time_lst.append(oper.date_start)
407 code_lst.append(code.start_stop)
408 time_lst.append(vals['date_start'])
410 for i in range(0,len(code_lst)):
411 if code_lst[i] == 'pause' or code_lst[i] == 'done' or code_lst[i] == 'cancel':
413 if code_lst[i-1] not in ('resume','start'):
415 a = datetime.strptime(time_lst[i-1],'%Y-%m-%d %H:%M:%S')
416 b = datetime.strptime(time_lst[i],'%Y-%m-%d %H:%M:%S')
417 diff += (b-a).days * 24
418 diff += (b-a).seconds / float(60*60)
421 def check_operation(self, cr, uid, vals):
422 """ Finds which operation is called ie. start, pause, done, cancel.
423 @param vals: Dictionary of values.
424 @return: True or False
426 code_ids=self.pool.get('mrp_operations.operation.code').search(cr,uid,[('id','=',vals['code_id'])])
427 code=self.pool.get('mrp_operations.operation.code').browse(cr,uid,code_ids)[0]
429 oper_ids=self.search(cr,uid,[('production_id','=',vals['production_id']),('workcenter_id','=',vals['workcenter_id'])])
430 oper_objs=self.browse(cr,uid,oper_ids)
433 if code.start_stop!='start':
434 raise osv.except_osv(_('Sorry!'),_('Operation is not started yet!'))
437 for oper in oper_objs:
438 code_lst.append(oper.code_id.start_stop)
439 if code.start_stop=='start':
440 if 'start' in code_lst:
441 raise osv.except_osv(_('Sorry!'),_('Operation has already started! You can either Pause/Finish/Cancel the operation.'))
443 if code.start_stop=='pause':
444 if code_lst[len(code_lst)-1]!='resume' and code_lst[len(code_lst)-1]!='start':
445 raise osv.except_osv(_('Error!'),_('In order to Pause the operation, it must be in the Start or Resume state!'))
447 if code.start_stop=='resume':
448 if code_lst[len(code_lst)-1]!='pause':
449 raise osv.except_osv(_('Error!'),_('In order to Resume the operation, it must be in the Pause state!'))
452 if code.start_stop=='done':
453 if code_lst[len(code_lst)-1]!='start' and code_lst[len(code_lst)-1]!='resume':
454 raise osv.except_osv(_('Sorry!'),_('In order to Finish the operation, it must be in the Start or Resume state!'))
456 if 'cancel' in code_lst:
457 raise osv.except_osv(_('Sorry!'),_('Operation is Already Cancelled!'))
459 if code.start_stop=='cancel':
460 if not 'start' in code_lst :
461 raise osv.except_osv(_('Error!'),_('No operation to cancel.'))
463 if 'done' in code_lst:
464 raise osv.except_osv(_('Error!'),_('Operation is already finished!'))
468 def write(self, cr, uid, ids, vals, context=None):
469 oper_objs = self.browse(cr, uid, ids, context=context)[0]
470 vals['production_id']=oper_objs.production_id.id
471 vals['workcenter_id']=oper_objs.workcenter_id.id
473 if 'code_id' in vals:
474 self.check_operation(cr, uid, vals)
476 if 'date_start' in vals:
477 vals['date_start']=vals['date_start']
478 vals['code_id']=oper_objs.code_id.id
479 delay=self.calc_delay(cr, uid, vals)
480 wc_op_id=self.pool.get('mrp.production.workcenter.line').search(cr,uid,[('workcenter_id','=',vals['workcenter_id']),('production_id','=',vals['production_id'])])
481 self.pool.get('mrp.production.workcenter.line').write(cr,uid,wc_op_id,{'delay':delay})
483 return super(mrp_operations_operation, self).write(cr, uid, ids, vals, context=context)
485 def create(self, cr, uid, vals, context=None):
486 workcenter_pool = self.pool.get('mrp.production.workcenter.line')
487 code_ids=self.pool.get('mrp_operations.operation.code').search(cr,uid,[('id','=',vals['code_id'])])
488 code=self.pool.get('mrp_operations.operation.code').browse(cr, uid, code_ids, context=context)[0]
489 wc_op_id=workcenter_pool.search(cr,uid,[('workcenter_id','=',vals['workcenter_id']),('production_id','=',vals['production_id'])])
490 if code.start_stop in ('start','done','pause','cancel','resume'):
492 production_obj=self.pool.get('mrp.production').browse(cr, uid, vals['production_id'], context=context)
493 wc_op_id.append(workcenter_pool.create(cr,uid,{'production_id':vals['production_id'],'name':production_obj.product_id.name,'workcenter_id':vals['workcenter_id']}))
494 if code.start_stop=='start':
495 workcenter_pool.action_start_working(cr,uid,wc_op_id)
496 workcenter_pool.signal_workflow(cr, uid, [wc_op_id[0]], 'button_start_working')
498 if code.start_stop=='done':
499 workcenter_pool.action_done(cr,uid,wc_op_id)
500 workcenter_pool.signal_workflow(cr, uid, [wc_op_id[0]], 'button_done')
501 self.pool.get('mrp.production').write(cr,uid,vals['production_id'],{'date_finished':datetime.now().strftime('%Y-%m-%d %H:%M:%S')})
503 if code.start_stop=='pause':
504 workcenter_pool.action_pause(cr,uid,wc_op_id)
505 workcenter_pool.signal_workflow(cr, uid, [wc_op_id[0]], 'button_pause')
507 if code.start_stop=='resume':
508 workcenter_pool.action_resume(cr,uid,wc_op_id)
509 workcenter_pool.signal_workflow(cr, uid, [wc_op_id[0]], 'button_resume')
511 if code.start_stop=='cancel':
512 workcenter_pool.action_cancel(cr,uid,wc_op_id)
513 workcenter_pool.signal_workflow(cr, uid, [wc_op_id[0]], 'button_cancel')
515 if not self.check_operation(cr, uid, vals):
517 delay=self.calc_delay(cr, uid, vals)
519 line_vals['delay'] = delay
520 if vals.get('date_start',False):
521 if code.start_stop == 'done':
522 line_vals['date_finished'] = vals['date_start']
523 elif code.start_stop == 'start':
524 line_vals['date_start'] = vals['date_start']
526 self.pool.get('mrp.production.workcenter.line').write(cr, uid, wc_op_id, line_vals, context=context)
528 return super(mrp_operations_operation, self).create(cr, uid, vals, context=context)
530 def initialize_workflow_instance(self, cr, uid, context=None):
531 mrp_production_workcenter_line = self.pool.get('mrp.production.workcenter.line')
532 line_ids = mrp_production_workcenter_line.search(cr, uid, [], context=context)
533 mrp_production_workcenter_line.create_workflow(cr, uid, line_ids)
537 'production_id':fields.many2one('mrp.production','Production',required=True),
538 'workcenter_id':fields.many2one('mrp.workcenter','Work Center',required=True),
539 'code_id':fields.many2one('mrp_operations.operation.code','Code',required=True),
540 'date_start': fields.datetime('Start Date'),
541 'date_finished': fields.datetime('End Date'),
542 'order_date': fields.function(_get_order_date,string='Order Date',type='date',store={'mrp.production':(_order_date_search_production,['date_planned'], 10)}),
545 'date_start': lambda *a:datetime.now().strftime('%Y-%m-%d %H:%M:%S')
548 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: