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())