def create(self, cr, uid, ids, datas, context={}): io = StringIO.StringIO() if 'date_start' not in datas: cr.execute('select min(date_start) from project_task where id in %s', (tuple(ids),)) dt = cr.fetchone()[0] if dt: datas['date_start'] = dt[:10] else: datas['date_start'] = time.strftime('%Y-%m-%d') if 'date_stop' not in datas: cr.execute('select max(date_start),max(date_close) from project_task where id in %s', (tuple(ids),)) res = cr.fetchone() datas['date_stop'] = (res[0] and res[0][:10]) or time.strftime('%Y-%m-%d') if res[1] and datas['date_stop']<res[1]: datas['date_stop'] = res[1][:10] date_to_int = lambda x: int(x.ticks()) int_to_date = lambda x: '/a60{}'+DateTime.localtime(x).strftime('%d/%m/%Y') datas = _burndown.compute_burndown(cr, uid, ids, datas['date_start'], datas['date_stop']) canv = canvas.init(fname=io, format='pdf') canv.set_author("Open ERP") max_hour = reduce(lambda x,y: max(y[1],x), datas, 0) date_to_int = lambda x: int(x.ticks()) int_to_date = lambda x: '/a60{}'+DateTime.localtime(x).strftime('%d %m %Y') def _interval_get(*args): result = set() for i in range(20): d = DateTime.localtime(datas[0][0] + (((datas[-1][0]-datas[0][0])/20)*(i+1))) res = DateTime.DateTime(d.year, d.month, d.day).ticks() result.add(res) return list(result) if datas[-1][0] == datas[0][0]: x_range = (datas[0][0],datas[-1][0]+1) else: x_range = (datas[0][0],datas[-1][0]) ar = area.T(x_grid_style=line_style.gray50_dash1, x_axis=axis.X(label="Date", format=int_to_date), y_axis=axis.Y(label="Burndown Chart - Planned Hours"), x_grid_interval=_interval_get, x_range = x_range, y_range = (0,max_hour), legend = None, size = (680,450)) ar.add_plot(line_plot.T(data=datas)) ar.draw(canv) canv.close() self.obj = external_pdf(io.getvalue()) self.obj.render() return (self.obj.pdf,'pdf')
def filedate(path, stat=os.stat): """ Return the modification date/time as DateTime instance. Needs mxDateTime to be installed. """ from mx import DateTime return DateTime.localtime(stat(path)[8])
def _interval_get(*args): result = [] for i in range(20): d = DateTime.localtime(datas[0][0] + (((datas[-1][0]-datas[0][0])/20)*(i+1))) res = DateTime.DateTime(d.year, d.month, d.day).ticks() if (not result) or result[-1]<>res: result.append(res) return result
def _interval_get(*args): result = set() for i in range(20): d = DateTime.localtime(datas[0][0] + (((datas[-1][0]-datas[0][0])/20)*(i+1))) res = DateTime.DateTime(d.year, d.month, d.day).ticks() result.add(res) return list(result)
def create(self, cr, uid, ids, datas, context={}): io = StringIO.StringIO() canv = canvas.init(fname=io, format='pdf') canv.set_author("Open ERP") cr.execute('select id,date_start,date_stop from scrum_sprint where id=%s', (datas['id'],)) for (id,date_start,date_stop) in cr.fetchall(): date_to_int = lambda x: int(x.ticks()) int_to_date = lambda x: '/a60{}'+DateTime.localtime(x).strftime('%d/%m/%Y') cr.execute('select id from project_task where product_backlog_id in(select id from scrum_product_backlog where sprint_id=%s)', (id,)) ids = map(lambda x: x[0], cr.fetchall()) datas = _burndown.compute_burndown(cr, uid, ids, date_start, date_stop) max_hour = reduce(lambda x,y: max(y[1],x), datas, 0) date_to_int = lambda x: int(x.ticks()) int_to_date = lambda x: '/a60{}'+DateTime.localtime(x).strftime('%d %m %Y') def _interval_get(*args): result = [] for i in range(20): d = DateTime.localtime(datas[0][0] + (((datas[-1][0]-datas[0][0])/20)*(i+1))) res = DateTime.DateTime(d.year, d.month, d.day).ticks() if (not result) or result[-1]<>res: result.append(res) return result ar = area.T(x_grid_style=line_style.gray50_dash1, x_axis=axis.X(label="Date", format=int_to_date), y_axis=axis.Y(label="Burndown Chart - Planned Hours"), x_grid_interval=_interval_get, x_range = (datas[0][0],datas[-1][0]), y_range = (0,max_hour), legend = None, size = (680,450)) ar.add_plot(line_plot.T(data=datas)) ar.draw(canv) canv.close() self.obj = external_pdf(io.getvalue()) self.obj.render() return (self.obj.pdf, 'pdf')
def now(): return DateTime.localtime()