def table_loading(type='html'): # Load database df = Affaire.load_db() table_man = TableLoader(Affaire.l_index, Affaire.l_fields(), limit=10, type=type) df, kwargs = table_man.load_reduce_table(df) d_footer = None return df, d_footer, kwargs
def table_loading(reduced=True, type='html', full_path=None): # Load database df = Devis.load_db() table_man = TableLoader(Devis.l_index, Devis.l_fields(), limit=10, type=type) if type == 'excel': # Get processed table df = table_man.load_full_table(df) # Save excel file writer = pd.ExcelWriter(full_path, engine='xlsxwriter') df.to_excel(writer, sheet_name='Feuille1', index=False) writer.save() return if reduced: df, kwargs = table_man.load_reduce_table(df) d_footer = None else: table_man = TableLoader(Devis.l_index, Devis.l_fields()) df, d_footer, kwargs = table_man.load_full_table(df) return df, d_footer, kwargs
def table_loading(type='html', full_path=None): l_index = FeuilleTravaux.main_model.l_index l_fields = FeuilleTravaux.main_model.l_fields() # Load database df, l_model_cols = FeuilleTravaux.load_view(return_cols=True) table_man = TableLoader(l_index, l_fields, type=type) if type == 'excel': # Get processed table df = table_man.load_full_table(df, l_extra_cols=l_model_cols) # Save excel file writer = pd.ExcelWriter(full_path, engine='xlsxwriter') df.to_excel(writer, sheet_name='Feuille1', index=False) writer.save() return l_model_cols = [f.name for f in l_index + l_fields] l_extra_cols = [c for c in df.columns if c not in l_model_cols] table_man = TableLoader(l_index, l_fields) df, d_footer, kwargs = table_man.load_full_table( df, l_extra_cols=l_extra_cols) return df, d_footer, kwargs
def control_loading(rights): d_control_data = {} df = User.driver.read_table('users') if rights != 'SADMIN': df.loc[df.rights == 'SADMIN', 'password'] = '******' # App 1 Table of user table_man = TableLoader(User.d_fields['index'], User.d_fields['fields']) df_, d_footer, kwargs = table_man.load_full_table(df, sort=False) d_control_data['tableuser'] = { 'table': { 'df': df_.copy(), 'd_footer': d_footer, 'kwargs': kwargs, 'key': 'nothing' }, 'rows': [('title', [{ 'content': 'title', 'value': 'Utilisateur de la base', 'cls': 'text-center' }]), ('Table', [{ 'content': 'table' }])], 'rank': 0 } # App 2: form action on user action = StringFields(title="Action", name='action', l_choices=[('Ajouter', 'Ajouter'), ('Suprimer', 'Suprimer'), ('Modifier', 'modifier')]) l_nodes = [action.sn] + [f.sn for f in User.d_fields['index'] ] + [f.sn for f in User.d_fields['fields']] mapping = { 'action': None, 'username': None, 'password': None, 'rights': [] } d_control_data['setusers'] = { 'form': { 'nodes': l_nodes, 'mapping': mapping }, 'rows': [('title', [{ 'content': 'title', 'value': "Modification des utilisateurs", 'cls': 'text-center' }]), ('form', [{ 'content': 'form' }])], 'rank': 1 } return d_control_data
def control_loading(): d_control_data = {} df = Facture.load_db() # Load table manager table_man = TableLoader(Facture.l_index, Facture.l_fields()) # App 1 table of bill waiting for visa ref_date = pd.Timestamp('1970-01-01') df['date_visa'] = df.date_visa.apply(lambda x: pd.Timestamp(x)) df['date_payed'] = df.date_payed.apply(lambda x: pd.Timestamp(x)) df_, d_footer, kwargs = table_man.load_full_table( df.loc[df.date_visa.apply( lambda x: pd.isna(x) or x == '' or x == ref_date)]) d_control_data['tablenovisa'] = { 'table': { 'df': df_.copy(), 'd_footer': d_footer, 'kwargs': kwargs, 'key': 'nothing' }, 'rows': [('title', [{ 'content': 'title', 'value': u'Factures en attente de visa', 'cls': 'text-center' }]), ('Table', [{ 'content': 'table' }])], 'rank': 0 } # App 2 table of bill waiting for payment df_, d_footer, kwargs = table_man.load_full_table( df.loc[~df.date_visa.apply( lambda x: pd.isna(x) or x == '' or x == ref_date) & df.date_payed.apply( lambda x: pd.isna(x) or x == '' or x == ref_date)]) d_control_data['tablenopayement'] = { 'table': { 'df': df_.copy(), 'd_footer': d_footer, 'kwargs': kwargs, 'key': 'visa' }, 'rows': [('title', [{ 'content': 'title', 'value': u'Factures en attente de paiement', 'cls': 'text-center' }]), ('Table', [{ 'content': 'table' }])], 'rank': 1 } # App 3 table of bill payed df_, d_footer, kwargs = table_man.load_full_table( df.loc[df.date_payed > ref_date]) d_control_data['tablepayment'] = { 'table': { 'df': df_, 'd_footer': d_footer, 'kwargs': kwargs, 'key': 'payement' }, 'rows': [('title', [{ 'content': 'title', 'value': u'Factures encaissées', 'cls': 'text-center' }]), ('Table', [{ 'content': 'table' }])], 'rank': 2 } return d_control_data