From 7300add4a7d90f8d4fae3a897dd8add4902f6751 Mon Sep 17 00:00:00 2001 From: "Rvo (Open ERP)" Date: Thu, 18 Feb 2010 18:43:18 +0530 Subject: [ADD]:added constraints on parent_ids and child_ids of tasks when date_start and date_end fields modified,improved on_change method on tasks bzr revid: rvo@tinyerp.co.in-20100218131318-mu80ki61iuazu06c --- addons/project/project.py | 65 +++++++++++++++++++++++++++-- addons/project/wizard/compute_tasks_date.py | 2 +- 2 files changed, 62 insertions(+), 5 deletions(-) (limited to 'addons/project') diff --git a/addons/project/project.py b/addons/project/project.py index a57f782ef10..b2490a4eab7 100644 --- a/addons/project/project.py +++ b/addons/project/project.py @@ -259,13 +259,16 @@ class task(osv.osv): result = {} for res in self.browse(cr, uid, ids): if date_start and planned: + dt_start = mx.DateTime.strptime(date_start,'%Y-%m-%d %H:%M:%S') resource_id = self.pool.get('resource.resource').search(cr,uid,[('user_id','=',res.user_id.id)]) if resource_id: resource_obj = self.pool.get('resource.resource').browse(cr,uid,resource_id)[0] - d = mx.DateTime.strptime(date_start,'%Y-%m-%d %H:%M:%S') - hrs = (planned)/(occupation_rate) - work_times = self.pool.get('resource.calendar').interval_get(cr, uid, resource_obj.calendar_id.id or False, d, hrs or 0.0, resource_obj.id) - result['date_end'] = work_times[-1][1].strftime('%Y-%m-%d %H:%M:%S') + hrs = planned/(occupation_rate * resource_obj.time_efficiency) + work_times = self.pool.get('resource.calendar').interval_get(cr, uid, resource_obj.calendar_id.id or False, dt_start, hrs or 0.0, resource_obj.id) + else: + hrs = planned / occupation_rate + work_times = self.pool.get('resource.calendar').interval_get(cr, uid, res.project_id.resource_calendar_id .id or False, dt_start, hrs or 0.0) + result['date_end'] = work_times[-1][1].strftime('%Y-%m-%d %H:%M:%S') result['remaining_hours'] = planned-effective return {'value':result} @@ -472,6 +475,60 @@ class task(osv.osv): self.write(cr, uid, typ.id, {'type': index and types[index-1] or False}) return True + def constraint_date_start(self,cr,uid,task,date_end,context=None): + # Recursive call for all previous tasks if change in date_start < older time + + resource_cal_pool = self.pool.get('resource.calendar') + calendar_id = task.project_id.resource_calendar_id.id + hours = task.remaining_hours / task.occupation_rate + work_time = resource_cal_pool.interval_min_get(cr, uid, calendar_id or False, date_end, hours or 0.0) + dt_start = work_time[0][0].strftime('%Y-%m-%d %H:%M:%S') + self.write(cr,uid,[task.id],{'date_start':dt_start,'date_end':date_end.strftime('%Y-%m-%d %H:%M:%S')}) + + def constraint_date_end(self,cr,uid,task,date_start,context=None): + # Recursive call for all next tasks if change in date_end > older time + + resource_cal_pool = self.pool.get('resource.calendar') + calendar_id = task.project_id.resource_calendar_id.id + hours = task.remaining_hours / task.occupation_rate + work_time = resource_cal_pool.interval_get(cr, uid, calendar_id or False, date_start, hours or 0.0) + dt_end = work_time[-1][1].strftime('%Y-%m-%d %H:%M:%S') + self.write(cr,uid,[task.id],{'date_start':date_start.strftime('%Y-%m-%d %H:%M:%S'),'date_end':dt_end}) + + def write(self, cr, uid, ids, vals,context=None): + tasks = self.browse(cr,uid,ids[0]) + resource_cal_pool = self.pool.get('resource.calendar') + calendar_id = tasks.project_id.resource_calendar_id.id + + if not context: + context = {} +# write method changes the date_start and date_end +#for previous and next tasks respectively based on valid condition + + if vals.get('date_start'): + if vals['date_start'] < tasks.date_start: + dt_start = mx.DateTime.strptime(vals['date_start'],'%Y-%m-%d %H:%M:%S') + hrs = tasks.remaining_hours / tasks.occupation_rate + work_times = resource_cal_pool.interval_get(cr, uid, calendar_id or False, dt_start, hrs or 0.0) + vals['date_end'] = work_times[-1][1].strftime('%Y-%m-%d %H:%M:%S') + super(task, self).write(cr, uid, ids, vals, context=context) + + for prv_task in tasks.parent_ids: + self.constraint_date_start(cr,uid,prv_task,dt_start) + + if vals.get('date_end'): + if vals['date_end'] > tasks.date_end: + dt_end = mx.DateTime.strptime(vals['date_end'],'%Y-%m-%d %H:%M:%S') + hrs = tasks.remaining_hours / tasks.occupation_rate + work_times = resource_cal_pool.interval_min_get(cr, uid, calendar_id or False, dt_end, hrs or 0.0) + vals['date_start'] = work_times[0][0].strftime('%Y-%m-%d %H:%M:%S') + super(task, self).write(cr, uid, ids, vals, context=context) + + for next_task in tasks.child_ids: + self.constraint_date_end(cr,uid,next_task,dt_end) + return super(task, self).write(cr, uid, ids, vals, context=context) + + task() class project_work(osv.osv): diff --git a/addons/project/wizard/compute_tasks_date.py b/addons/project/wizard/compute_tasks_date.py index 5dc7c9ae007..c44fb902e87 100644 --- a/addons/project/wizard/compute_tasks_date.py +++ b/addons/project/wizard/compute_tasks_date.py @@ -216,7 +216,7 @@ class wizard_compute_tasks(wizard.interface): project_pool.write(cr,uid,[project_id],{'date':e_date}) else: user_id = user_pool.search(cr,uid,[('name','=',t.booked_resource[0].__name__)]) - task_pool.write(cr,uid,[task_obj[loop_no-1].id],{'date_start':s_date,'date_deadline':e_date,'user_id':user_id[0]}) + task_pool.write(cr,uid,[task_obj[loop_no-1].id],{'date_start':s_date.strftime('%Y-%m-%d %H:%M:%S'),'date_deadline':e_date.strftime('%Y-%m-%d %H:%M:%S'),'user_id':user_id[0]}) loop_no +=1 return {} -- cgit v1.2.3 From eabe16de50d796e35a8c6cfe9b17cfba163cc6b6 Mon Sep 17 00:00:00 2001 From: "Rvo (Open ERP)" Date: Fri, 19 Feb 2010 15:58:28 +0530 Subject: minor changes bzr revid: rvo@tinyerp.co.in-20100219102828-hrehhv0aacv8conw --- addons/project/project.py | 2 +- addons/project/wizard/compute_tasks_date.py | 21 +++++++++------------ 2 files changed, 10 insertions(+), 13 deletions(-) (limited to 'addons/project') diff --git a/addons/project/project.py b/addons/project/project.py index 841a688272c..85af339160a 100644 --- a/addons/project/project.py +++ b/addons/project/project.py @@ -265,7 +265,7 @@ class task(osv.osv): if resource_id: resource_obj = self.pool.get('resource.resource').browse(cr,uid,resource_id)[0] hrs = planned/(occupation_rate * resource_obj.time_efficiency) - work_times = self.pool.get('resource.calendar').interval_get(cr, uid, resource_obj.calendar_id.id or False, dt_start, hrs or 0.0, resource_obj.id) + work_times = self.pool.get('resource.calendar').interval_get(cr, uid, resource_obj.calendar_id.id or False, dt_start, hrs or 0.0, resource_obj) else: hrs = planned / occupation_rate work_times = self.pool.get('resource.calendar').interval_get(cr, uid, res.project_id.resource_calendar_id .id or False, dt_start, hrs or 0.0) diff --git a/addons/project/wizard/compute_tasks_date.py b/addons/project/wizard/compute_tasks_date.py index c44fb902e87..c52f0b5f079 100644 --- a/addons/project/wizard/compute_tasks_date.py +++ b/addons/project/wizard/compute_tasks_date.py @@ -61,15 +61,13 @@ def leaves_resource(cr,uid,id): resource_leaves_pool = pool.get('resource.calendar.leaves') resource_leave_ids = resource_leaves_pool.search(cr,uid,[('resource_id','=',id)]) leaves = [] - if resource_leave_ids: - res_leaves = resource_leaves_pool.read(cr,uid,resource_leave_ids,['date_from','date_to']) - for leave in range(len(res_leaves)): - dt_start = datetime.datetime.strptime(res_leaves[leave]['date_from'],'%Y-%m-%d %H:%M:%S') - dt_end = datetime.datetime.strptime(res_leaves[leave]['date_to'],'%Y-%m-%d %H:%M:%S') - no = dt_end - dt_start - leave_days = no.days + 1 - [leaves.append((dt_start + datetime.timedelta(days=x)).strftime('%Y-%m-%d')) for x in range(int(leave_days))] - leaves.sort() + res_leaves = resource_leaves_pool.read(cr,uid,resource_leave_ids,['date_from','date_to']) + for leave in range(len(res_leaves)): + dt_start = datetime.datetime.strptime(res_leaves[leave]['date_from'],'%Y-%m-%d %H:%M:%S') + dt_end = datetime.datetime.strptime(res_leaves[leave]['date_to'],'%Y-%m-%d %H:%M:%S') + no = dt_end - dt_start + [leaves.append((dt_start + datetime.timedelta(days=x)).strftime('%Y-%m-%d')) for x in range(int(no.days + 1))] + leaves.sort() return leaves class wizard_compute_tasks(wizard.interface): @@ -148,9 +146,8 @@ class wizard_compute_tasks(wizard.interface): dt_start = datetime.datetime.strptime(res_leaves[leave]['date_from'],'%Y-%m-%d %H:%M:%S') dt_end = datetime.datetime.strptime(res_leaves[leave]['date_to'],'%Y-%m-%d %H:%M:%S') no = dt_end - dt_start - leave_days = no.days + 1 - [leaves.append((dt_start + datetime.timedelta(days=x)).strftime('%Y-%m-%d')) for x in range(int(leave_days))] - leaves.sort() + [leaves.append((dt_start + datetime.timedelta(days=x)).strftime('%Y-%m-%d')) for x in range(int(no.days + 1))] + leaves.sort() # To create resources which are the Project Members resource = project.members -- cgit v1.2.3 From 512fce7d0729fd45ba000f918a6409ed49153a11 Mon Sep 17 00:00:00 2001 From: "Rvo (Open ERP)" Date: Fri, 26 Feb 2010 16:45:19 +0530 Subject: [IMP]:changes in project module,improved scheduling wizard bzr revid: rvo@tinyerp.co.in-20100226111519-38fiawt3qnz71tvs --- addons/project/project.py | 72 ++++++++++----- addons/project/project_view.xml | 2 +- addons/project/wizard/compute_tasks_date.py | 130 ++++------------------------ 3 files changed, 69 insertions(+), 135 deletions(-) (limited to 'addons/project') diff --git a/addons/project/project.py b/addons/project/project.py index 85af339160a..d130c48a6bb 100644 --- a/addons/project/project.py +++ b/addons/project/project.py @@ -256,20 +256,23 @@ class task(osv.osv): res[task.id]['delay_hours'] = res[task.id]['total_hours'] - task.planned_hours return res - def onchange_planned(self, cr, uid, ids, planned=0.0, effective=0.0, date_start=None,occupation_rate=0.0): + def onchange_planned(self, cr, uid, ids, project, user_id = False,planned=0.0, effective=0.0,date_start=None,occupation_rate=0.0): result = {} - for res in self.browse(cr, uid, ids): - if date_start and planned: - dt_start = mx.DateTime.strptime(date_start,'%Y-%m-%d %H:%M:%S') - resource_id = self.pool.get('resource.resource').search(cr,uid,[('user_id','=',res.user_id.id)]) - if resource_id: - resource_obj = self.pool.get('resource.resource').browse(cr,uid,resource_id)[0] - hrs = planned/(occupation_rate * resource_obj.time_efficiency) - work_times = self.pool.get('resource.calendar').interval_get(cr, uid, resource_obj.calendar_id.id or False, dt_start, hrs or 0.0, resource_obj) - else: - hrs = planned / occupation_rate - work_times = self.pool.get('resource.calendar').interval_get(cr, uid, res.project_id.resource_calendar_id .id or False, dt_start, hrs or 0.0) - result['date_end'] = work_times[-1][1].strftime('%Y-%m-%d %H:%M:%S') + if date_start: + resource_pool = self.pool.get('resource.resource') + project_pool = self.pool.get('project.project') + resource_calendar = self.pool.get('resource.calendar') + dt_start = mx.DateTime.strptime(date_start,'%Y-%m-%d %H:%M:%S') + resource_id = resource_pool.search(cr,uid,[('user_id','=',user_id)]) + if resource_id: + resource_obj = resource_pool.browse(cr,uid,resource_id)[0] + hrs = planned/(float(occupation_rate) * resource_obj.time_efficiency) + calendar_id = resource_obj.calendar_id.id + else: + hrs = float(planned / occupation_rate) + calendar_id = project_pool.browse(cr,uid,project).resource_calendar_id .id + work_times = resource_calendar.interval_get(cr, uid, calendar_id or False, dt_start, hrs or 0.0,resource_id or False) + result['date_end'] = work_times[-1][1].strftime('%Y-%m-%d %H:%M:%S') result['remaining_hours'] = planned-effective return {'value':result} @@ -480,9 +483,15 @@ class task(osv.osv): # Recursive call for all previous tasks if change in date_start < older time resource_cal_pool = self.pool.get('resource.calendar') + resource_pool = self.pool.get('resource.resource') calendar_id = task.project_id.resource_calendar_id.id hours = task.remaining_hours / task.occupation_rate - work_time = resource_cal_pool.interval_min_get(cr, uid, calendar_id or False, date_end, hours or 0.0) + resource_id = resource_pool.search(cr,uid,[('user_id','=',task.user_id.id)]) + if resource_id: + resource_obj = resource_pool.browse(cr,uid,resource_id[0]) + calendar_id = resource_obj.calendar_id.id + hours = task.planned_hours/(float(task.occupation_rate) * resource_obj.time_efficiency) + work_time = resource_cal_pool.interval_min_get(cr, uid, calendar_id or False, date_end, hours or 0.0,resource_id or False) dt_start = work_time[0][0].strftime('%Y-%m-%d %H:%M:%S') self.write(cr,uid,[task.id],{'date_start':dt_start,'date_end':date_end.strftime('%Y-%m-%d %H:%M:%S')}) @@ -490,27 +499,45 @@ class task(osv.osv): # Recursive call for all next tasks if change in date_end > older time resource_cal_pool = self.pool.get('resource.calendar') + resource_pool = self.pool.get('resource.resource') calendar_id = task.project_id.resource_calendar_id.id hours = task.remaining_hours / task.occupation_rate - work_time = resource_cal_pool.interval_get(cr, uid, calendar_id or False, date_start, hours or 0.0) + resource_id = resource_pool.search(cr,uid,[('user_id','=',task.user_id.id)]) + if resource_id: + resource_obj = resource_pool.browse(cr,uid,resource_id[0]) + calendar_id = resource_obj.calendar_id.id + hours = task.planned_hours/(float(task.occupation_rate) * resource_obj.time_efficiency) + work_time = resource_cal_pool.interval_get(cr, uid, calendar_id or False, date_start, hours or 0.0,resource_id or False) dt_end = work_time[-1][1].strftime('%Y-%m-%d %H:%M:%S') self.write(cr,uid,[task.id],{'date_start':date_start.strftime('%Y-%m-%d %H:%M:%S'),'date_end':dt_end}) def write(self, cr, uid, ids, vals,context=None): + + if not context: + context = {} + + if context.get('scheduler',False): + return super(task, self).write(cr, uid, ids, vals, context=context) + +# if the task is performed by a resource then its calendar and efficiency also taken +# otherwise the project's working calendar considered tasks = self.browse(cr,uid,ids[0]) resource_cal_pool = self.pool.get('resource.calendar') + resource_pool = self.pool.get('resource.resource') calendar_id = tasks.project_id.resource_calendar_id.id + hrs = tasks.remaining_hours / tasks.occupation_rate + resource_id = resource_pool.search(cr,uid,[('user_id','=',tasks.user_id.id)]) + if resource_id: + resource_obj = resource_pool.browse(cr,uid,resource_id[0]) + calendar_id = resource_obj.calendar_id.id + hrs = tasks.planned_hours/(float(tasks.occupation_rate) * resource_obj.time_efficiency) - if not context: - context = {} # write method changes the date_start and date_end -#for previous and next tasks respectively based on valid condition - +# for previous and next tasks respectively based on valid condition if vals.get('date_start'): if vals['date_start'] < tasks.date_start: dt_start = mx.DateTime.strptime(vals['date_start'],'%Y-%m-%d %H:%M:%S') - hrs = tasks.remaining_hours / tasks.occupation_rate - work_times = resource_cal_pool.interval_get(cr, uid, calendar_id or False, dt_start, hrs or 0.0) + work_times = resource_cal_pool.interval_get(cr, uid, calendar_id or False, dt_start, hrs or 0.0,resource_id or False) vals['date_end'] = work_times[-1][1].strftime('%Y-%m-%d %H:%M:%S') super(task, self).write(cr, uid, ids, vals, context=context) @@ -521,7 +548,7 @@ class task(osv.osv): if vals['date_end'] > tasks.date_end: dt_end = mx.DateTime.strptime(vals['date_end'],'%Y-%m-%d %H:%M:%S') hrs = tasks.remaining_hours / tasks.occupation_rate - work_times = resource_cal_pool.interval_min_get(cr, uid, calendar_id or False, dt_end, hrs or 0.0) + work_times = resource_cal_pool.interval_min_get(cr, uid, calendar_id or False, dt_end, hrs or 0.0,resource_id or False) vals['date_start'] = work_times[0][0].strftime('%Y-%m-%d %H:%M:%S') super(task, self).write(cr, uid, ids, vals, context=context) @@ -529,7 +556,6 @@ class task(osv.osv): self.constraint_date_end(cr,uid,next_task,dt_end) return super(task, self).write(cr, uid, ids, vals, context=context) - task() class project_work(osv.osv): diff --git a/addons/project/project_view.xml b/addons/project/project_view.xml index 945eec1f46c..875b2611afd 100644 --- a/addons/project/project_view.xml +++ b/addons/project/project_view.xml @@ -239,7 +239,7 @@ name="planned_hours" widget="float_time" attrs="{'readonly':[('state','!=','draft')]}" - on_change="onchange_planned(planned_hours,effective_hours,date_start,occupation_rate)"/> + on_change="onchange_planned(project_id,user_id,planned_hours,effective_hours,date_start,occupation_rate)"/>