def _responseData():
try:
vendor = find_by_id(vid=args['VENDOR_ID'])
if(not isNone(vendor)):
vendor.MENU = None if isNone(args['MENU']) else args['MENU']
session = pg_session()
try:
session.add(vendor)
except Exception as e:
session.rollback()
logger.error('_menu_update :' + str(e))
else:
session.commit()
response_data['data'] = models_to_list(vendor)
except Exception as e:
logger.error('_menu_update :' + str(e))
pass
return response_data
def job_to_name(code):
if (isNone(JOB_DICT)):
jobs = json.loads(JOB_JSON)
for job in jobs:
JOB_DICT[job['value']] = job['label']
if (not isNone(code) and not isNone(JOB_DICT) and (code in JOB_DICT)):
return JOB_DICT[code]
return ''
def get_outside_emp(apply_user_idno, field):
session = pg_session()
try:
res = session.query(OutsideEmpEntity).filter(
OutsideEmpEntity.ID_NO == apply_user_idno).first()
if (not isNone(res)):
temp = clzs_to_dicts(res)
return ('' if isNone(temp) else temp[field])
return ''
except Exception as e:
return None
finally:
session.close()
def country_to_name(code):
if (isNone(COUNTRYS)):
cts = json.loads(COUNTRY_JSON)
for city in cts:
COUNTRYS[city['countryCode']] = (city['countryName'],
city['phoneCode'],
city['countryCode'])
if (not isNone(code) and not isNone(COUNTRYS) and (code in COUNTRYS)):
return COUNTRYS[code][0]
return ''
def route_wrapper(*args, **kwargs):
try:
if (not isNone(params)):
kwargs['args'] = get_parameter(**params)
return func(*args, **kwargs)
except ValueError as e:
rs = {'success': False, 'message': str(e), 'data': []}
return api_response(**rs), 400
def _get_parameter(**_params):
_result = {}
if request.method in ['POST', 'DELETE']:
# if request.is_json == False:
# raise ValueError('JSON request required.')
#content = request.get_json()
content = request.get_json() if request.is_json else (
request.form if request.form else [])
for key, value in _params.items():
if (key in content):
_result[key] = content[key]
elif (key.lower() in content):
_result[key] = content[key.lower()]
else:
_result[key] = None
if ('required' in value):
if (key not in _result) or isNone(_result[key]):
raise ValueError('{0} is required.'.format(key))
if ('base64' in value):
if (not isNone(_result[key])):
_result[key] = str(base64.b64decode(_result[key]))
elif request.method == 'GET':
for key, value in _params.items():
if (request.args.get(key) is not None):
_result[key] = request.args.get(key)
elif (request.args.get(key.lower()) is not None):
_result[key] = request.args.get(key.lower())
else:
_result[key] = None
if ('required' in value):
if isNone(_result[key]):
raise ValueError('{0} is required.'.format(key))
if ('base64' in value):
if (not isNone(_result[key])):
_result[key] = str(base64.b64decode(_result[key]))
return _result
def getall(clz):
'''*** ***'''
try:
data = clz.ExeQueryByClz(
pg_session, """
SELECT "MASTER_ID", "REG_DATE", "APPLY_USER_IDNO", "APPLY_USER_NAME", "PAT_IDNO", "CHART_NO", "PAT_NAME", "FORM_ID", "CONTENT", "CRE_DATE", "CRE_TIME", "CRE_USER", "DEL_DATE", "DEL_TIME", "DEL_USER", "DEL_REASON", "REASON_DESC", "INP_NO"
FROM public.tocc_form_master
""")
return data if not isNone(data) else None
except:
raise
def to_excel(dataset, filepath, filename):
if (isNone(dataset)):
return False
writer = None
try:
# Note, Python 2 example. For Python 3 use: output = io.BytesIO().
output = io.BytesIO()
# Use the StringIO object as the filehandle.
writer = pd.ExcelWriter(output, engine='xlsxwriter')
#writer = pd.ExcelWriter(filepath, engine='xlsxwriter')
#title = DEFAULT_TOCC_TITLE.keys()
for k, v in TOCC_IN_REASON.items():
subset = filter(v['filter'], dataset)
xls_set = v['XLS_TITLE']
#title = xls_set.keys()
title = []
index = xls_set.keys()
datalist = []
for item in subset:
d = []
for key in index:
if (xls_set[key]['name'] not in title):
title.append(xls_set[key]['name'])
d.append(xls_set[key]['filter'](item))
datalist.append(d)
df = pd.DataFrame(columns=title, data=datalist)
df.to_excel(writer, sheet_name=k)
writer.save()
output.seek(0)
return output
#xlsx_data = output.getvalue()
except Exception as e:
logger.error('error travelhis to_excel :' + str(e))
return False
finally:
if (not isNone(writer)):
writer.close()
def _responseData():
try:
vendor = find_by_id(vid=args['VENDOR_ID'])
if (not isNone(vendor)):
pass
response_data['data'] = models_to_list(vendor)
except Exception as e:
logger.error('menu_release :' + str(e))
pass
return response_data
def GenSeqNO(seqNO):
'''*** ORACLE KFSYSCC.FN_GET_SEQ_NO 取號 ***'''
try:
sql = "select FN_GET_SEQ_NO(:P_SEQ_NO, '1') As SEQ_NO from DUAL"
params = {}
params['P_SEQ_NO'] = seqNO
data = QueryA(sql, **params)
if (not isNone(data)):
return data[0]['SEQ_NO']
else:
return ''
except sqlalchemy.exc.DatabaseError as e:
error, = e.args
utils.logger.error('oracle error:{0}'.format(error))
raise e
def o_to_d(obj, func=None):
'''object to dictionary'''
result = None
dict1 = {}
try:
method = func if not isNone(func) else 'to_dict'
if hasattr(obj, method):
dict1 = getattr(obj, method)()
else:
dict1 = dict((t, getattr(obj, t)) for t in obj.__dict__.keys()
if not t.startswith('_'))
#dict1 = getattr(obj, method)() if hasattr(obj, method) else obj.__dict__
except Exception as identifier:
logger.error(str(identifier))
else:
oths = {}
if isNone(func):
oths = {
p: getattr(obj, p)
for p in dir(obj.__class__)
if isinstance(getattr(obj.__class__, p), property)
}
result = dict(dict1, **oths)
return result
def get_emp_dept(empmo, field):
emp = get_emp(empmo)
return ('' if isNone(emp) else emp[field])
def TOOC_JSON2DICT(self):
try:
temp = {}
data = None
try:
data = json.loads(self.CONTENT)
except Exception as e:
data = self.CONTENT
#職業別
temp['occupation'] = data['occupation']['occupation']
temp['occupation_name'] = job_to_name(
data['occupation']['occupation'])
#同住家人是否居家隔離
temp['cluster_familyQuarantineIso'] = data['cluster'][
'familyQuarantineIso']
#周遭朋友最近是否有發燒或呼吸道不適症狀
temp['cluster_friendSymptom'] = data['cluster']['friendSymptom']
#同住家人最近是否有發燒或呼吸道不適症
temp['cluster_familySymptom'] = data['cluster']['familySymptom']
#同住家人是否居家檢疫
temp['cluster_familyQuarantineCheck'] = data['cluster'][
'familyQuarantineCheck']
#到期日
temp['cluster_dueDate'] = data['cluster']['dueDate']
#工作同事最近是否有發燒或呼吸道不適症狀
temp['cluster_colleagueSymptom'] = data['cluster'][
'colleagueSymptom']
#身邊親友最近是否有接二連三發燒或呼吸道不適症狀
temp['cluster_rfFrequentSymptom'] = data['cluster'][
'rfFrequentSymptom']
#同住家人是否自主健康管理
temp['cluster_familyHealthManage'] = data['cluster'][
'familyHealthManage']
#您近期是否與確診者接觸
temp['cluster_confirmCaseTouch'] = data['cluster'][
'confirmCaseTouch'] if ('confirmCaseTouch'
in data['cluster']) else ''
#接觸史
# 其他
temp['contactHistory_others'] = 'Y' if data['contactHistory'][
'others'] else 'N'
# 曾參與公眾集會
temp['contactHistory_PA'] = 'Y' if data['contactHistory'][
'PA'] else 'N'
# 無
temp['contactHistory_none'] = 'Y' if data['contactHistory'][
'none'] else 'N'
# 曾出入機場、觀光景點及其他頻繁接觸外國人場所
temp['contactHistory_ATF'] = 'Y' if data['contactHistory'][
'ATF'] else 'N'
# 曾參與開學/畢業典禮、婚喪喜慶、運動賽事等聚眾活動
temp['contactHistory_GMS'] = 'Y' if data['contactHistory'][
'GMS'] else 'N'
# 野生動物與禽鳥接觸
temp['contactHistory_WB'] = 'Y' if data['contactHistory'][
'WB'] else 'N'
# 曾至醫院、診所就醫
temp['contactHistory_HC'] = 'Y' if data['contactHistory'][
'HC'] else 'N'
# 曾參與宗教/政治/學術/藝文活動
temp['contactHistory_RPEC'] = 'Y' if data['contactHistory'][
'RPEC'] else 'N'
# 過去14日內是否出過國？
temp['travelHistory_isSelfGoAbroad'] = data['travelHistory'][
'isSelfGoAbroad']
# 過去14日內是否出過國？(國家)
temp['travelHistory_countrySelf_Code'] = data['travelHistory'][
'countrySelf']
temp['travelHistory_countrySelf_Name'] = country_to_name(
data['travelHistory']['countrySelf'])
# 同住家屬過去14天是否曾至國外旅遊？
temp['travelHistory_isFamilyGoAbroad'] = data['travelHistory'][
'isFamilyGoAbroad']
# 同住家屬過去14天是否曾至國外旅遊？(國家)
temp['travelHistory_countryFamily_Code'] = data['travelHistory'][
'countryFamily']
temp['travelHistory_countryFamily_Name'] = country_to_name(
data['travelHistory']['countryFamily'])
# 經常接觸之親友過去14天是否曾至國外旅遊？
temp['travelHistory_isFriendGoAbroad'] = data['travelHistory'][
'isFriendGoAbroad']
# 經常接觸之親友過去14天是否曾至國外旅遊？(國家)
temp['travelHistory_countryFriend_Code'] = data['travelHistory'][
'countryFriend']
temp['travelHistory_countryFriend_Name'] = country_to_name(
data['travelHistory']['countryFriend'])
# 健康史
#您自己是否有以下呼吸道不適或類流感症狀？例如：咳嗽、發燒、流鼻水、肌肉痠痛、頭痛
temp['healthHistory_selfSymptom'] = data['healthHistory'][
'selfSymptom']
#陪探病證申請結果
temp['passport'] = ('N' if (isNone(self.PRN_CNT)) else
('Y' if self.PRN_CNT > 0 else 'N'))
return temp
except Exception as e:
logger.error('_tocc_by_date :' + str(e))
return {}
def PASSPORT(self):
#陪探病證申請結果
return ('N' if (isNone(self.PRN_CNT)) else
('Y' if self.PRN_CNT > 0 else 'N'))
def get_tocc(self):
if (not isNone(self.TOCC_FROM_MASTER_ID)):
return pg_session.query(ToccFormMasterEntity).filter(
ToccFormMasterEntity.MASTER_ID ==
self.TOCC_FROM_MASTER_ID).first()
'name': '建檔日期',
'filter': lambda x: x['CRE_DATE']
},
9: {
'name': '建檔時間',
'filter': lambda x: x['CRE_TIME']
},
10: {
'name': '填表原因',
'filter': lambda x: x['REASON_DESC']
},
11: {
'name':
'病服協助登入',
'filter':
lambda x: ('N' if (isNone(x['IP_ADDRESS'])) else
('Y' if (x['IP_ADDRESS'][:3] == '172' and not (x[
'IN_REASON'] in ['EMP', 'EMP2'])) else 'N'))
},
12: {
'name': 'TOCC判定結果',
'filter': lambda x: ('Y' if x['TOOC_PASS'] else 'N')
},
13: {
'name': '職業別',
'filter': lambda x: x['TOOC_JSON2DICT']['occupation_name']
},
14: {
'name': '您自己是否有以下呼吸道不適或類流感症狀？例如：咳嗽、發燒、流鼻水、肌肉痠痛、頭痛',
'filter': lambda x: x['TOOC_JSON2DICT']['healthHistory_selfSymptom']
},
def get_deptbycode(deptcode, field):
dept = get_dept_by_code(deptcode)
return ('' if isNone(dept) else dept[field])
def reason_to_name(code):
if (not isNone(code) and not isNone(IN_REASON) and (code in IN_REASON)):
return IN_REASON[code]
return ''
