def test_report(self):
f = FinancialIntervalReport(self.store, 2012)
f.run()
data = f.get_data()
# ===> Check banks transactions per month <===
banks = data.get(u'Banks')
# January
self.assertEqual(banks[0],
[(u'Banks', 0),
(u'Banco do Brasil', currency("33013.67"))])
# February
self.assertEqual(banks[1],
[(u'Banks', 0),
(u'Banco do Brasil', currency("-8325.35"))])
# Other months (March - December)
for n in range(2, 12):
self.assertEqual(banks[n], [(u'Banks', 0),
(u'Banco do Brasil', 0)])
# ===> Check Expenses transactions <===
expenses = data.get(u'Expenses')
# January
self.assertEqual(expenses[0], [(u'Expenses', 0),
(u'Aluguel', currency("850")),
(u'Luz', currency("120.18")),
(u'Sal\xe1rios', currency("4692.76")),
(u'Telefonia', currency("232.30")),
(u'Impostos', currency("6843.91"))])
# February
self.assertEqual(expenses[1], [(u'Expenses', 0),
(u'Aluguel', currency("850")),
(u'Luz', currency("138.48")),
(u'Sal\xe1rios', currency("4502.48")),
(u'Telefonia', 0),
(u'Impostos', currency("2834.39"))])
# Other months (March - December)
for n in range(2, 12):
self.assertEqual(expenses[n], [(u'Expenses', 0), (u'Aluguel', 0),
(u'Luz', 0), (u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)])
# ===> Check Income transactions <===
income = data.get(u'Income')
# January
self.assertEqual(income[0], [(u'Income', currency("-45752.82"))])
# Other months (February - December)
for n in range(1, 12):
self.assertEqual(income[n], [(u'Income', 0)])
def test_report(self):
f = FinancialIntervalReport(self.store, 2012)
f.run()
data = f.get_data()
# ===> Check banks transactions per month <===
banks = data.get(u'Banks')
# January
self.assertEquals(banks[0], [(u'Banks', 0), (u'Banco do Brasil', currency("33013.67"))])
# February
self.assertEquals(banks[1], [(u'Banks', 0), (u'Banco do Brasil', currency("-8325.35"))])
# Other months (March - December)
for n in range(2, 12):
self.assertEquals(banks[n], [(u'Banks', 0), (u'Banco do Brasil', 0)])
# ===> Check Expenses transactions <===
expenses = data.get(u'Expenses')
# January
self.assertEquals(expenses[0],
[(u'Expenses', 0),
(u'Aluguel', currency("850")),
(u'Luz', currency("120.18")),
(u'Sal\xe1rios', currency("4692.76")),
(u'Telefonia', currency("232.30")),
(u'Impostos', currency("6843.91"))])
# February
self.assertEquals(expenses[1],
[(u'Expenses', 0),
(u'Aluguel', currency("850")),
(u'Luz', currency("138.48")),
(u'Sal\xe1rios', currency("4502.48")),
(u'Telefonia', 0),
(u'Impostos', currency("2834.39"))])
# Other months (March - December)
for n in range(2, 12):
self.assertEquals(expenses[n],
[(u'Expenses', 0), (u'Aluguel', 0), (u'Luz', 0),
(u'Sal\xe1rios', 0), (u'Telefonia', 0), (u'Impostos', 0)])
# ===> Check Income transactions <===
income = data.get(u'Income')
# January
self.assertEquals(income[0],
[(u'Income', currency("-45752.82"))])
# Other months (February - December)
for n in range(1, 12):
self.assertEquals(income[n],
[(u'Income', 0)])
def confirm(self):
start = self.date_filter.get_start_date()
if start is None:
warning(_("There are no transactions yet"))
return
f = FinancialIntervalReport(self.store, start.year)
if not f.run():
return
temporary = tempfile.NamedTemporaryFile(
# Translators: This will be part of a filename
prefix=_('stoq-yearly-report'),
suffix='.xls', delete=False)
f.write(temporary)
sse = SpreadSheetExporter()
sse.export_temporary(temporary)
self.close()
def confirm(self):
start = self.date_filter.get_start_date()
if start is None:
warning(_("There are no transactions yet"))
return
f = FinancialIntervalReport(self.store, start.year)
if not f.run():
return
temporary = tempfile.NamedTemporaryFile(
# Translators: This will be part of a filename
prefix=_('stoq-yearly-report'),
suffix='.xls',
delete=False)
f.write(temporary)
sse = SpreadSheetExporter()
sse.export_temporary(temporary)
self.close()
def test_report(self):
f = FinancialIntervalReport(self.store, 2012)
f.run()
data = f.get_data()
self.assertEquals(
data,
{u'Banks': [[(u'Banks', 0), (u'Banco do Brasil', currency("58491.97"))],
[(u'Banks', 0), (u'Banco do Brasil', currency("8325.35"))],
[(u'Banks', 0), (u'Banco do Brasil', 0)],
[(u'Banks', 0), (u'Banco do Brasil', 0)],
[(u'Banks', 0), (u'Banco do Brasil', 0)],
[(u'Banks', 0), (u'Banco do Brasil', 0)],
[(u'Banks', 0), (u'Banco do Brasil', 0)],
[(u'Banks', 0), (u'Banco do Brasil', 0)],
[(u'Banks', 0), (u'Banco do Brasil', 0)],
[(u'Banks', 0), (u'Banco do Brasil', 0)],
[(u'Banks', 0), (u'Banco do Brasil', 0)],
[(u'Banks', 0), (u'Banco do Brasil', 0)]],
u'Expenses': [[(u'Expenses', 0),
(u'Aluguel', currency("850")),
(u'Luz', currency("120.18")),
(u'Sal\xe1rios', currency("4692.76")),
(u'Telefonia', currency("232.30")),
(u'Impostos', currency("6843.91"))],
[(u'Expenses', 0),
(u'Aluguel', currency("850")),
(u'Luz', currency("138.48")),
(u'Sal\xe1rios', currency("4502.48")),
(u'Telefonia', 0),
(u'Impostos', currency("2834.39"))],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)],
[(u'Expenses', 0),
(u'Aluguel', 0),
(u'Luz', 0),
(u'Sal\xe1rios', 0),
(u'Telefonia', 0),
(u'Impostos', 0)]],
u'Income': [[(u'Income', currency("45752.82"))],
[(u'Income', 0)],
[(u'Income', 0)],
[(u'Income', 0)],
[(u'Income', 0)],
[(u'Income', 0)],
[(u'Income', 0)],
[(u'Income', 0)],
[(u'Income', 0)],
[(u'Income', 0)],
[(u'Income', 0)],
[(u'Income', 0)]],
}
)
