def export_xls(self):
from Common.exports_xlsx import export_dynamic_data
dict_data = {
'file_name':
"versements",
'headers':
self.table.hheaders[:-1],
'data':
self.table.data,
"extend_rows": [
(1, self.table.label_mov_tt),
(3, self.table.balance_tt),
],
# "footers": [],
'sheet':
self.title,
# 'title': self.title,
'widths':
self.table.stretch_columns,
'exclude_row':
len(self.table.data) - 1,
'format_money': [
"D:D",
],
'others': [
("A7", "B7", "Compte : {}".format(self.table.provider_clt)),
("A8", "B8", "Du {} au {} : {}".format(
date_to_datetime(self.on_date.text()).strftime(
Config.DATEFORMAT),
date_to_datetime(
self.end_date.text()).strftime(Config.DATEFORMAT),
device_amount(self.table.balance_tt))),
],
}
export_dynamic_data(dict_data)
def export_xls(self):
# TODO A
from Common.exports_xlsx import export_dynamic_data
from num2words import num2words
table = self.table_show
hheaders = table.hheaders[:-1]
data = table.data
endrowx = len(hheaders) - 1
dict_data = {
'file_name': "facture n {}".format(self.invoice.number),
'headers': hheaders,
'data': data,
"extend_rows": [(3, table.montant_ht), ],
'sheet': self.title,
# 'title': self.title,
'widths': table.stretch_columns,
"date": show_date(self.invoice.date),
"others": [
("A7", "B7", "FACTURE N° : {}".format(self.invoice.number)),
("A8", "B8", "Doit: {}".format(self.invoice.client.name)),
("A35", "D35", "Arrêté la présente facture à la somme de : {} FCFA".format(
num2words(table.montant_ht, lang="fr"))),
("A38", "B38", "Pour acquit"),
("C38", "D38", "Le fournisseur"),
],
# 'exclude_row': len(data) - 2,
}
export_dynamic_data(dict_data)
def export_xls(self):
from Common.exports_xlsx import export_dynamic_data
table = self.invent_table
hheaders = table.hheaders
dict_data = {
'file_name':
"Inventaire",
'headers':
hheaders,
'data':
table.data,
"extend_rows": [
(3, table.sum_totals),
],
'sheet':
self.title,
# 'title': self.title,
'format_money': [
"C:C",
"D:D",
],
'widths':
table.stretch_columns,
"date":
"Du {} au {}".format(
date_to_datetime(self.on_date.text()).strftime(u'%d/%m/%Y'),
date_to_datetime(self.end_date.text()).strftime(u'%d/%m/%Y'))
}
export_dynamic_data(dict_data)
def export_xls(self):
dict_data = {
'file_name': "produits.xls",
'headers': self.store_table.hheaders,
'data': self.store_table.data,
'sheet': self.title,
'widths': self.store_table.stretch_columns
}
export_dynamic_data(dict_data)
def export_xlsx(self):
from Common.exports_xlsx import export_dynamic_data
dict_data = {
'file_name': "produits.xlsx",
'headers': self.table_prod.hheaders,
'data': self.table_prod.data,
# 'data': self.table_prod.get_table_items(),
'sheet': self.title,
'title': self.title,
'widths': self.table_prod.stretch_columns
}
export_dynamic_data(dict_data)
def export_xls(self):
from Common.exports_xlsx import export_dynamic_data
table = self.table_show
hheaders = table.hheaders[:-1]
dict_data = {
'file_name': "arivage",
'headers': hheaders,
'data': table.data,
"extend_rows": [(4, table.v_amount_tt), (5, ""),
(6, table.b_f_tt)],
'sheet': self.title,
# 'title': self.title,
'format_money': ["C:C", "D:D", "E:E", "F:F", "G:G"],
'widths': table.stretch_columns,
"date": self.buy.date.strftime(u'%x'),
'exclude_row': len(table.data) - 2,
}
export_dynamic_data(dict_data)
def export_xls(self):
from Common.exports_xlsx import export_dynamic_data
dict_data = {
'file_name': "caise",
'headers': self.table_op.hheaders,
'data': self.table_op.get_table_items(),
"extend_rows": [
(3, self.table_op.amount_ht),
],
'sheet': self.title,
'title': self.title,
'format_money': [
"C:C",
"D:D",
],
'widths': self.table_op.stretch_columns,
"date": self.date_.text()
}
export_dynamic_data(dict_data)
def export_xls(self):
from Common.exports_xlsx import export_dynamic_data
dict_data = {
'file_name': "Semaine",
'headers': self.table_rpt.hheaders,
'data': self.table_rpt.data,
"extend_rows": [(0, "Totaux"),
(1, self.table_rpt.total_sum_d1),
(2, self.table_rpt.total_sum_d2),
(3, self.table_rpt.total_sum_d3),
(4, self.table_rpt.total_sum_d4),
(5, self.table_rpt.total_sum_d5),
(6, self.table_rpt.total_sum_d6),
(7, self.table_rpt.totals), ],
'sheet': self.title,
'title': self.title,
'widths': self.table_rpt.stretch_columns,
"date": self.table_rpt.date_on.strftime(
u"%x") + " au " + self.table_rpt.date_end.strftime(u"%x")
}
export_dynamic_data(dict_data)
def export_xls(self):
from Common.exports_xlsx import export_dynamic_data
dict_data = {
'file_name':
"versements.xlsx",
'headers':
self.table.hheaders[:-1],
'data':
self.table.data,
"extend_rows": [
(1, self.table.label_mov_tt),
(2, self.table.totals_debit),
(3, self.table.totals_credit),
],
"footers": [
("C", "E", "Solde au {} = {}".format(self.now,
self.table.balance_tt)),
],
'sheet':
self.title,
# 'title': self.title,
'format_money': [
'C:C',
'D:D',
'E:E',
],
'widths':
self.table.stretch_columns,
'exclude_row':
len(self.table.data) - 1,
"date":
"Du {} au {}".format(
date_to_datetime(self.on_date.text()).strftime(u'%d/%m/%Y'),
date_to_datetime(self.end_date.text()).strftime(u'%d/%m/%Y'))
}
export_dynamic_data(dict_data)
def export_xlsx(self):
from Common.exports_xlsx import export_dynamic_data
export_dynamic_data(self.table.dict_data())
