def get_project_used_list(self, year, company):
query = build_query(self, year, company)
rows= []
c = connection.cursor()
try:
c.execute(query)
rows = dictfetchall(c)
finally:
c.close()
sum_line = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
index = 0
for line in rows:
index += 1
line['index'] = index
sum_line[0] += (line['online_before_amount'] or 0)
sum_line[1] += line['one_month'] or 0
sum_line[2] += line['two_month'] or 0
sum_line[3] += line['three_month']
sum_line[4] += line['four_month']
sum_line[5] += line['five_month']
sum_line[6] += line['six_month']
sum_line[7] += line['seven_month']
sum_line[8] += line['eight_month']
sum_line[9] += line['night_month']
sum_line[10] += line['ten_month']
sum_line[11] += line['eleven_month']
sum_line[12] += line['twelve_month']
line['total'] = (line['online_before_amount'] or 0) + (line['one_month'] or 0) + (line['two_month'] or 0)+ \
line['three_month'] + line['four_month'] + line['five_month'] + line['six_month'] + \
line['seven_month'] + line['eight_month'] + line['night_month'] + line['ten_month'] + \
line['eleven_month'] + line['twelve_month']
percent = line['total']/line['estimate_total'] * Decimal(100.0) if line['total'] != 0 and line['estimate_total'] != 0 and line['estimate_total'] is not None else 0.00
line['percent'] = ("%.2f" % percent)
sum_line[13] += (line['total'] or 0)
result = {}
result['lines'] = rows
if len(rows) > 0:
result['sum_line'] = sum_line
result['year'] = str(year)
result['company'] = company
return result
def get_project_apply_list(project, category, material_name):
query = build_query(project, category, material_name)
rows= []
c = connection.cursor()
try:
c.execute(query)
rows = dictfetchall(c)
finally:
c.close()
result = {}
result['lines'] = rows
result['project_name'] = project
result['category_name'] = category
result['material_name'] = material_name
return result
def get_project_apply_list(project, category, material_name):
query = build_query(project, category, material_name)
rows = []
c = connection.cursor()
try:
c.execute(query)
rows = dictfetchall(c)
finally:
c.close()
result = {}
result['lines'] = rows
result['project_name'] = project
result['category_name'] = category
result['material_name'] = material_name
return result