def output_maker(projects):
dictionary = {}
for row in projects:
if row.company_name not in dictionary and row.maintenance_requested != "true":
dictionary.setdefault(row.company_name, [])
if row.maintenance_requested != "true":
dictionary[row.company_name].append(row.maintenance_requested)
dictionary[row.company_name].append(row.main_color)
else:
if row.maintenance_requested != "true":
dictionary.setdefault(row.company_name, []).append(row.maintenance_requested)
dictionary.setdefault([row.company_name].append(row.main_color))
list = []
for k, v in dictionary.items():
if v != None:
sublist = []
dictionary[k] = v[0], TextBox.hex_to_rgb(v[1]), v[2:]
sublist.append(k)
sublist.append(TextBox.hex_to_rgb(v[1]))
a = 0
for i in v:
if "false" == i:
a += 1
sublist.append(a*30)
list.append(sublist)
return list
def projects_by_currency():
try:
cursor.execute(sql_3)
# Fetch all the rows in a list of lists.
results_1 = cursor.fetchall()
all_companies = []
for row in results_1:
if row[0] not in all_companies:
company = []
company.append(row[0])
company.append(float(row[1]))
company.append(row[2])
company.append(row[3])
all_companies.append(company)
else:
pass
result = ProjectByCurrency.make_reverse_order(all_companies)
for i in result:
i[2] = TextBox.hex_to_rgb(i[2])
for i in result:
Picture.add_to_textboxes(i[2], i[1], i[0])
# print(i)
Picture.drawer('projects_by_currency.png')
except Exception as e:
print(e)
