def __init__(self, account, period=current_period(), \
parent=0, *args, **kwargs):
super(OperationWidget, self).__init__(parent=parent, *args, **kwargs)
ANMPeriodHolder.__init__(self, period, *args, **kwargs)
# set global account
self.account = account
self.main_period = period
self.balance = account_balance(self.account, period)
self.table = OperationTableWidget(parent=self, period=self.main_period)
self.title = ANMPageTitle(_(u"Transactions List for Account " \
u"%(number)s: %(name)s.") \
% {'name': self.account.name, \
'number': self.account.number})
self.balance_title = ANMPageTitle(_(u"Balance: " u"%(balance)s FCFA") \
% {'balance': \
formatted_number(account_balance(self.account, period))})
hbox = QtGui.QHBoxLayout()
hbox.addWidget(self.table)
formbox = QtGui.QFormLayout()
self.order_number = QtGui.QLineEdit()
self.invoice_number = QtGui.QLineEdit()
self.invoice_date = QtGui.QDateTimeEdit(QtCore.QDate.currentDate())
self.invoice_date.setDisplayFormat("yyyy-MM-dd")
# change date if appropriate
self.adjust_date_field()
self.provider = QtGui.QLineEdit()
self.amount = QtGui.QLineEdit()
self.amount.setValidator(QtGui.QIntValidator())
butt = QtGui.QPushButton(_(u"Add"))
butt.clicked.connect(self.add_operation)
formbox1 = QtGui.QHBoxLayout()
formbox1.addWidget(QtGui.QLabel(_(u'Order number')))
formbox1.addWidget(QtGui.QLabel(_(u'Invoice number')))
formbox1.addWidget(QtGui.QLabel(_(u'Invoice date')))
formbox1.addWidget(QtGui.QLabel(_(u'Provider')))
formbox1.addWidget(QtGui.QLabel(_(u'Amount')))
formbox1.addSpacing(90)
formbox = QtGui.QHBoxLayout()
formbox.addWidget(self.order_number)
formbox.addWidget(self.invoice_number)
formbox.addWidget(self.invoice_date)
formbox.addWidget(self.provider)
formbox.addWidget(self.amount)
formbox.addWidget(butt)
vbox = QtGui.QVBoxLayout()
vbox.addWidget(self.title)
vbox.addWidget(self.balance_title)
vbox.addWidget(self.periods_bar)
vbox.addLayout(formbox1)
vbox.addLayout(formbox)
vbox.addLayout(hbox)
self.setLayout(vbox)
def write_xls(file_name):
""" Export data """
book = xlwt.Workbook(encoding="ascii")
sheet = book.add_sheet(_(u"Accounts"))
sheet.write_merge(0, 1, 1, 2, _(u"List of accounts per quarter"), style_title)
date_ = _(u"Bamako the %s") % date.today().strftime("%x")
sheet.write(2, 1, unicode(date_))
hdngs = [_(u"Account N°"), _(u"Account Name")]
rowx1 = 5
for colx, value in enumerate(hdngs):
sheet.write(rowx1, colx, value, style0)
periods = session.query(Period).order_by(Period.start_on).all()
accounts = session.query(Account).all()
for account in accounts:
rowx1 += 1
sheet.col(colx).width = 0x0D00 * 3
if int(rowx1) % 2 == 0:
style = style1
else:
style = style2
sheet.write(rowx1, colx - 1, account.number, style)
sheet.write(rowx1, colx, account.name, style)
col = 2
for period in periods:
try:
balance = account_balance(account, period)
Budget_amount = session.query(Budget.amount).filter_by(account=account, period=period).scalar()
if checking_existence_budget(period):
if int(rowx1) % 2 == 0:
style = style1
else:
style = style2
sheet.write(rowx1, col, Budget_amount, style)
sheet.write(rowx1, col + 1, balance, style)
col += 2
except AccountNotConfigured:
pass
col = 2
sheet.write(rowx1 + 1, col - 1, _(u"TOTALS"), style0)
for number_period in range(len(periods)):
# La somme de tout les operations
total_budget, total_balance = sum_budget_and_operation(periods[number_period])
sheet.col(col).width = 0x0D00 * 2
sheet.col(col + 1).width = 0x0D00 * 2
# We check if the total budget is not equal to zero and if so we write
if checking_existence_budget(periods[number_period]):
sheet.write(rowx1 + 1, col, total_budget, style0)
sheet.write(rowx1 + 1, col + 1, total_balance, style0)
col += 2
col = 2
for number_period in range(len(periods)):
if checking_existence_budget(periods[number_period]):
sheet.write_merge(4, 4, col, col + 1, periods[number_period].display_name(), style0)
sheet.write(5, col, _(u"Budget"), style0)
sheet.write(5, col + 1, _(u"Balance"), style0)
col += 2
# Pour les operations
for account in accounts:
sheet_name = account.number
sheet = book.add_sheet(sheet_name)
rowx = 1
sheet.write_merge(0, rowx, 1, 3, _(u"List operation per quarter"), style_title)
rowx += 2
account_name = _(u"Account: %s") % account.name
sheet.write_merge(rowx, rowx, 1, 3, account_name, style_title)
sheet.col(2).width = 0x0D00 * 2
sheet.col(3).width = 0x0D00 * 3
sheet.col(4).width = 0x0D00 * 2
for period in periods:
operations = [
(
operation.order_number,
operation.invoice_number,
operation.invoice_date.strftime("%x"),
operation.provider,
operation.amount,
)
for operation in session.query(Operation)
.filter_by(account=account, period=period)
.order_by(desc(Operation.invoice_date))
.all()
]
if operations:
sheet.write_merge(rowx + 2, rowx + 2, 2, 3, period.display_name(), style_title)
hdngs = [_(u"No mandate"), _(u"No invoice"), _(u"Invoice Date"), _(u"Provider"), _(u"Amount")]
rowx += 4
for colx, value in enumerate(hdngs):
sheet.write(rowx, colx, value, style0)
amount_opera = 0
for row in operations:
rowx += 1
if int(rowx) % 2 == 0:
style = style1
else:
style = style2
for colx, value in enumerate(row):
sheet.write(rowx, colx, value, style)
amount_opera += row[4]
# On fait le total du montant des operations par teimestre
sheet.write(rowx + 1, colx - 1, _(u"TOTAL"), style0)
sheet.write(rowx + 1, colx, amount_opera, style0)
rowx += 1
book.save(file_name)
return file_name
def adjust_balance(self, period):
''' adjusts the balance by period '''
self.balance = account_balance(self.account, period)
self.balance_title.setText(_(u"Balance: " u"%(balance)s FCFA") \
% {'balance': \
formatted_number(self.balance)})
