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