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_text_invoice_summary(the_invoices):
output = [['Ref', 'Client', 'Job', 'Net', 'VAT', 'Gross', 'Desc']]
net_total = 0.0
vat_total = 0.0
for inv in the_invoices:
irn = inv['irn']
client = inv['client']
job = inv['JobCode']
net = inv['net']
net_total += net
vat = inv['vat_rate']* net
vat_total += vat
gross = net + vat
desc = inv['desc']
desc.strip()
if len(desc) > 12: desc = desc[0:12]
line = [irn, client, job, number(net), number(vat), number(gross), desc]
output.append(line)
output.append(['total', '', '', number(net_total), number(vat_total), number(net_total + vat_total)])
output.append([])
period.create_text_report("invoices.txt", output)
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])
