def user():
if not session_check():
flash('재로그인 해주세요')
return redirect(url_for('login'))
user_list = user_list_select(session['level'])
return render_template('/user_list.html', result=user_list)
def list():
if not session_check():
flash('재로그인 해주세요')
return redirect(url_for('login'))
mylist = mylist_select('ADMIN')
return render_template('/my_list.html', result=mylist)
def listupload():
if not session_check():
flash('재로그인 해주세요')
return redirect(url_for('login'))
if request.method == 'POST':
f = request.files['file']
data_xls = pd.read_excel(f, sheet_name='Sheet1')
insert_qry = mylist_upload('ADMIN', data_xls)
return render_template('/my_list_upload.html', result=insert_qry)
def my_edit():
if not session_check():
flash('재로그인 해주세요')
return redirect(url_for('login'))
if request.method == 'POST':
result = request.form
rtn_message = my_update(result)
print(rtn_message)
e_idx = result["IDX"]
return redirect(url_for('my_view', idx=e_idx))
def user_edit():
if not session_check():
flash('재로그인 해주세요')
return redirect(url_for('login'))
if request.method == 'POST':
result = request.form
mode = result['mode']
edit_id = result['edit_id']
edit_name = result['edit_name']
edit_level = result['edit_level']
resp = chg_user_info(mode, edit_id, '1234', edit_name, edit_level)
return redirect(url_for('user'))
def result():
if not session_check():
flash('재로그인 해주세요')
return redirect(url_for('login'))
if request.method == 'POST':
result = request.form
search_product = result['search_product'].split('\r\n')
for idx, search_item in enumerate(search_product):
# 특수문자제거, 공백제거
search_product[idx] = re.sub(
'[-=+,#/\?:^$.@*\"※~&%ㆍ!』\\‘|\(\)\[\]\<\>`\'…》]', '',
search_item).replace(' ', '')
# 중복제거
search_product = OrderedSet(search_product)
s_data = []
for item in search_product:
# 글자수가 1글자 이상일때만 검색
if len(item) > 0:
korean_nm = ""
start = 0
# 없을시 다음페이지 3 페이지 까지만
while len(korean_nm) < 1 and start < 30:
gSearch_result = search_google(item, start, "druginfo")
korean_nm = gSearch_result['korean_nm']
start = start + 10
# 그래도 없을 시 kmle로 검색 (kmle 우리랑 성분명 표시하는방법이달라서 내 리스트 잘 못골라옴)
start = 0
while len(korean_nm) < 1 and start < 30:
gSearch_result = search_google(item, start, "kmle")
korean_nm = gSearch_result['korean_nm']
start = start + 10
print(start, gSearch_result)
s_data.append(gSearch_result)
return render_template("/result_main.html", result=s_data)
def search():
if not session_check():
flash('재로그인 해주세요')
return redirect(url_for('login'))
return render_template('/search_main.html')