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