def update_graphic(self, _num_week=None): """ :param num_week: :return: """ if _num_week is None: _num_week = this_week() _act = Activity() _wn = WeekNumber() _week = _wn.get_or_create(_num_week, True) _plan = Planned().get_tasks_week(_week) gap_week = _wn.get_gap_week(_week.date_init) for day in gap_week: activ_week = _act.sync_activity(day)
def report_month(self, num_week): """ :param num_week: :return: """ month = month.get([datetime.today().month]) type_launch = TypeLaunch.objects.filter().order_by('-cost_fixo') _line = type_launch.count() matrix = [['' for coll in range(0)] for row in range(_line + 1)] line = 0 matrix[line].append('cost month %s' %month) line += 1 for tl in type_launch: matrix[line].append(tl.type_name) line += 1 line = 0 matrix[line].append('prevision') line += 1 for tl in type_launch: matrix[line].append(tl.value_fixed) line += 1 line = 0 matrix[line].append('fixo prevision') line += 1 for tl in type_launch: if tl.cost_fixo: matrix[line].append(tl.value_fixed) else: matrix[line].append('') line += 1 dif_week = 3 #4 week report_month wn = WeekNumber() ext = Extract() while dif_week >= 0: _num_week = (num_week - dif_week) _week = wn.get_or_create(_num_week) matrix = ext.get_cost_month(matrix, _week, type_launch) dif_week -= 1 worksheet = get_worksheet(num_week, month) _range = get_range(matrix) send_week(worksheet, _range, matrix)
def report_week(self, _num_week=None): """ :param num_week: :return: """ if _num_week is None: _num_week = this_week() wn = WeekNumber() ext = Extract() act = Activity() _pla = Planned() _week = wn.get_or_create(_num_week, True) gap_week = wn.get_gap_week(_week.date_init) import ipdb; ipdb.set_trace() if _num_week == this_week(): _pla.get_tasks_week() wn.import_extract_itau() wn.import_extract_mycap() m_summary_ext = self.get_matrix(gap_week, _week, Extract.__name__, None) m_summary_activ = self.get_matrix(gap_week, _week, Activity.__name__, None) m_details_ext = self.get_matrix(gap_week, _week, None, Extract.__name__) m_details_activ = self.get_matrix(gap_week, _week, None, Activity.__name__) for day in gap_week: cost_week = ext.get_cost_week(m_details_ext, day) try: activ_week = act.report_activity(m_details_activ, day) except Exception: print("trello unauthorized permission requested.") pass