def workbook_add(self, activity_note: ActivityNote) -> bool:
logtest = f'workbook_add method with - :{activity_note.Activity_Type}'
print_begin(f'Enter {logtest}')
current_logger.info(f'Entered {logtest}')
if not path.exists(
f'inputs/{activity_note.Author}-Activity-Note.xlsx'):
df = pdb.read_excel(f'inputs/Authors-Activity-Note-Template.xlsx',
index_col=None,
names=excel_columns,
dtype=str,
keep_default_na=False)
df.to_excel(f'inputs/{activity_note.Author}-Activity-Note.xlsx')
df = pdb.read_excel(
f'inputs/{activity_note.Author}-Activity-Note.xlsx',
index_col=None,
names=excel_columns,
header=None,
dtype=str,
keep_default_na=False)
# print(activity_note.__dict__)
new_df = df.append(activity_note.__dict__, ignore_index=True)
# print(new_df)
new_df.to_excel(f'inputs/{activity_note.Author}-Activity-Note.xlsx')
return True
def dataframes_load(author: str) -> None:
global who_pd
logtest = 'dataframes_load method'
print_begin(f'Enter {logtest}')
current_logger.info(f'Entered {logtest}')
if path.exists(f'inputs/{author}-Activity-Note.xlsx'):
who_pd = pdb.read_excel(f'inputs/{author}-Activity-Note.xlsx',
index_col=None,
names=[
'Mbr_Id', 'Date_Time', 'Case_Id',
'Activity_Type', 'Note'
],
header=None,
dtype=str,
keep_default_na=False)
else:
who_pd = pdb.read_excel(
f'inputs/Authors-Activity-Note-Template.xlsx',
index_col=None,
names=[
'Mbr_Id', 'Date_Time', 'Case_Id', 'Activity_Type', 'Note'
],
header=None,
dtype=str,
keep_default_na=False)
if who_pd.empty:
current_logger.info(f'Failed to load Excel to PDF in {logtest}')
# return False
print_begin(f'Exiting {logtest}')
def post(self, sql_call):
print_begin(sql_call)
parser = reqparse.RequestParser(bundle_errors=True)
parser.add_argument(arg_handler.ARG_RECORDCOUNT,
type=str,
help='record count',
required=False)
print_end(sql_call)
def dataframes_search(self, speech_text: str) -> str:
logtest = f'dataframes_search method with - :{speech_text}'
print_begin(f'Enter {logtest}')
current_logger.info(f'Entered {logtest}')
result = speech_text.split(" ")
words = '|'.join(result)
# 'Mbr_Id', 'Date_Time', 'Case_Id', 'Activity_Type', 'Note'
s = who_pd['Mbr_Id'] + who_pd['Date_Time'] + who_pd[
'Case_Id'] + who_pd['Activity_Type'] + who_pd['Note']
who_results = who_pd[s.str.contains(words, case=False, regex=True)]
def main_page(display_name):
"""
:param display_name:hwo to get requirements.
:return:
---
tags:
- main page
"""
# config_rw = ConfigRW(Settings.PRIOR_AUTH_SETTINGS.value)
print_begin()
ip_address = definitions.get_ip_address()
# server_options = markup.server_options(ip_address)
return render_template(
'DashboardPriorAuth.html',
error=None,
def_server_option=ip_address,
display_name=display_name,
)
def login():
"""
Login
:return: redirects to the page
---
tag:
- login
"""
error = None
try:
user_name = request.form['userName']
except Exception:
user_name = ''
print_begin()
if request.method == 'POST' and user_name:
return redirect(url_for('main_page', display_name=user_name))
return render_template('login.html', error=error, user_name=user_name)
if who_pd.empty:
current_logger.info(f'Failed to load Excel to PDF in {logtest}')
# return False
print_begin(f'Exiting {logtest}')
def dataframes_search(self, speech_text: str) -> str:
logtest = f'dataframes_search method with - :{speech_text}'
print_begin(f'Enter {logtest}')
current_logger.info(f'Entered {logtest}')
result = speech_text.split(" ")
words = '|'.join(result)
# 'Mbr_Id', 'Date_Time', 'Case_Id', 'Activity_Type', 'Note'
s = who_pd['Mbr_Id'] + who_pd['Date_Time'] + who_pd[
'Case_Id'] + who_pd['Activity_Type'] + who_pd['Note']
who_results = who_pd[s.str.contains(words, case=False, regex=True)]
print_begin(f'Exiting {logtest}')
return who_results.to_json()
def workbook_add(self, activity_note: ActivityNote) -> bool:
logtest = f'workbook_add method with - :{activity_note.Activity_Type}'
print_begin(f'Enter {logtest}')
current_logger.info(f'Entered {logtest}')
if not path.exists(
f'inputs/{activity_note.Author}-Activity-Note.xlsx'):
df = pdb.read_excel(f'inputs/Authors-Activity-Note-Template.xlsx',
index_col=None,
names=excel_columns,
dtype=str,
keep_default_na=False)
df.to_excel(f'inputs/{activity_note.Author}-Activity-Note.xlsx')