def create_wip_report(data, output_text=True):
output = create_wip_lines(data)
if output_text:
period.create_text_report("wip.txt", output)
else:
# TODO Consider zapping Excel output option if considered unecessary
excel.create_report("Wip", output, [2, 3, 4, 5, 6, 7])
def create_expense_report(data, output_text = True):
the_expenses = data['Expenses']
sorted_expenses= sorted(the_expenses, key= lambda x: x['JobCode'])
output = [['Job', 'Amount', 'Period', '', 'Name', '', 'Desc']]
xs = filter(lambda x: x['Amount'] != 0, sorted_expenses)
for x in xs:
desc = x['Desc']
desc_upper = desc.upper()
if 'ACCOM' in desc_upper: desc += ' - Munros'
if 'FLIGHT' in desc_upper: desc += ' - Munros'
if 'TAXI' in desc_upper: desc += ' - Rainbow'
output.append([ x['JobCode'], x['Amount'], x['Period'], '', x['Name'], '', desc])
output.append([])
total = common.summate_lod(sorted_expenses, 'Amount')
output.append(['TOTAL', total])
if output_text:
period.create_text_report("expenses.txt", output)
else:
# TODO Consider zapping Excel output option if considered unecessary
excel.create_report("expenses", output, [2, 3 ,4, 5, 6, 7])
