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
