def login(self, sUserCode, sPassword):
'''查询数据'''
objUser = User().query.filter(User.UserCode == sUserCode).first()
# print User().Password.property.doc
if not objUser:
return FuncResult(msg='用户名错误！')
# dictUser = obj_to_dict(objUser)
# del dictUser['UserDataRoleList'], \
# dictUser['Password'], dictUser['CreateTime']
# dictUser['StateName'] = dict_to_name(dictUser['State'], 'user_state')
#
# # 保存用户信息到session
# web.ctx.session.user = dictUser
sUserPassword = objUser.Password
# sUserPassword = aes_decrypt(objUser.Password)
if sUserPassword == sPassword:
dictUser = obj_to_dict(objUser)
del dictUser['UserDataRoleList'], \
dictUser['Password'], dictUser['CreateTime']
dictUser['StateName'] = dict_to_name(dictUser['State'],
'user_state')
# 保存用户信息到session
web.ctx.session.user = dictUser
web.ctx.session.login = True
return FuncResult(success=True, msg='登录成功！', data=dictUser)
else:
return FuncResult(msg='密码错误！')
def get_foreigner_guest_detail(self, nCheckInID):
objForeigner = Foreigner().query.\
filter(Foreigner.GuestDocID == nCheckInID).\
first()
if not objForeigner:
return FuncResult(msg='无查询结果！')
dictData = obj_to_dict(objForeigner)
del dictData['GuestDocID']
del dictData['CreateTime']
# 签证类型
dictData['VisaTypeName'] = dict_to_name(dictData['VisaType'],
'visa_type')
# 国籍
dictData['NationalityName'] = dict_to_name(dictData['Nationality'],
'gres_country')
return FuncResult(success=True, msg='', data=dictData)
def search_foreign_checkin(self, objCondition, objPage):
lsParams = []
dictParamsValue = {}
if objCondition.has_key('nGuestState') and objCondition['nGuestState']:
nGuestState = objCondition['nGuestState']
lsParams.append('h_relation_checkin.GuestState = :nGuestState')
dictParamsValue['nGuestState'] = nGuestState
# 入住出示证件信息
if objCondition.has_key(
'sGuestDocNameLike') and objCondition['sGuestDocNameLike']:
sGuestDocName = '%' + objCondition['sGuestDocNameLike'] + '%'
lsParams.append('g_guest_checkin.HotelDocName Like :sGuestDocName')
dictParamsValue['sGuestDocName'] = sGuestDocName
if objCondition.has_key('sDocNoLikeL') and objCondition['sDocNoLikeL']:
sDocNo = objCondition['sDocNoLikeL'] + '%'
lsParams.append('g_guest_checkin.HotelDocNo Like :sDocNo ')
dictParamsValue['sDocNo'] = sDocNo
if objCondition.has_key('nDocType') and objCondition['nDocType']:
nDocType = objCondition['sDocNoLikeL'] + '%'
lsParams.append('g_guest_checkin.HotelDocType Like :nDocType ')
dictParamsValue['nDocType'] = nDocType
if objCondition.has_key('nSex') and objCondition['nSex']:
nSex = objCondition['nSex']
lsParams.append('g_guest_checkin.HotelSex = :nSex')
dictParamsValue['nSex'] = nSex
if objCondition.has_key(
'sBornDateStart') and objCondition['sBornDateStart']:
dtBornDateStart = to_datetime(objCondition['sBornDateStart'])
lsParams.append('g_guest_checkin.HotelBornDate >= :sBornDateStart')
dictParamsValue['sBornDateStart'] = dtBornDateStart
if objCondition.has_key(
'sBornDateEnd') and objCondition['sBornDateEnd']:
dtBornDateEnd = to_datetime(objCondition['sBornDateEnd'])
lsParams.append('g_guest_checkin.HotelBornDate <= :sBornDateEnd')
dictParamsValue['sBornDateEnd'] = dtBornDateEnd
if objCondition.has_key(
'nMatchResult') and objCondition['nMatchResult']:
nMatchResult = objCondition['nMatchResult']
lsParams.append('g_guest_checkin.MatchResult = :nMatchResult')
dictParamsValue['nMatchResult'] = nMatchResult
# 入住酒店信息
if objCondition.has_key(
'sHotelNameLike') and objCondition['sHotelNameLike']:
sHotelName = '%' + objCondition['sHotelNameLike'] + '%'
lsParams.append('h_hotel.HotelName Like :sHotelName')
dictParamsValue['sHotelName'] = sHotelName
if objCondition.has_key('nProvinceID') and objCondition['nProvinceID']:
nProvinceID = objCondition['nProvinceID']
lsParams.append('h_hotel.ProvinceID = :nProvinceID')
dictParamsValue['nProvinceID'] = nProvinceID
if objCondition.has_key('nCityID') and objCondition['nCityID']:
nCityID = objCondition['nCityID']
lsParams.append('h_hotel.CityID = :nCityID')
dictParamsValue['nCityID'] = nCityID
if objCondition.has_key('nDistrictID') and objCondition['nDistrictID']:
nDistrictID = objCondition['nDistrictID']
lsParams.append('h_hotel.DistrictID = :nDistrictID')
dictParamsValue['nDistrictID'] = nDistrictID
if objCondition.has_key('sRoomNo') and objCondition['sRoomNo']:
sRoomNo = objCondition['sRoomNo']
lsParams.append('h_hotel.RoomNo = :sRoomNo')
dictParamsValue['sRoomNo'] = sRoomNo
if objCondition.has_key('sCheckInDateTimeStart'
) and objCondition['sCheckInDateTimeStart']:
dtCheckInDateTimeStart = to_datetime(
objCondition['sCheckInDateTimeStart'])
lsParams.append('h_checkin.CheckInTime >= :dtCheckInDateTimeStart')
dictParamsValue['dtCheckInDateTimeStart'] = dtCheckInDateTimeStart
if objCondition.has_key(
'sCheckInDateTimeEnd') and objCondition['sCheckInDateTimeEnd']:
dtCheckInDateTimeEnd = to_datetime(
objCondition['sCheckInDateTimeEnd'])
lsParams.append('h_checkin.CheckInTime <= :dtCheckInDateTimeEnd')
dictParamsValue['dtCheckInDateTimeEnd'] = dtCheckInDateTimeEnd
# 外籍旅客信息
if objCondition.has_key(
'sNationality') and objCondition['sNationality']:
sNationality = objCondition['Nationality']
lsParams.append('g_foreigner.Nationality = :sNationality')
dictParamsValue['sNationality'] = sNationality
if objCondition.has_key(
'sDepartureTimeStart') and objCondition['sDepartureTimeStart']:
dtDepartureTimeStart = to_datetime(
objCondition['sDepartureTimeStart'])
lsParams.append(
'g_foreigner.DepartureTime > :dtDepartureTimeStart')
dictParamsValue['dtDepartureTimeStart'] = dtDepartureTimeStart
if objCondition.has_key(
'sDepartureTimeEnd') and objCondition['sDepartureTimeEnd']:
dtDepartureTimeEnd = to_datetime(objCondition['sDepartureTimeEnd'])
lsParams.append('g_foreigner.DepartureTime <= :dtDepartureTimeEnd')
dictParamsValue['dtDepartureTimeEnd'] = dtDepartureTimeEnd
if objCondition.has_key(
'sEntryTimeStart') and objCondition['sEntryTimeStart']:
dtEntryTimeStart = to_datetime(objCondition['sEntryTimeStart'])
lsParams.append('g_foreigner.EntryTime >= :dtEntryTimeStart')
dictParamsValue['dtEntryTimeStart'] = dtEntryTimeStart
if objCondition.has_key(
'sEntryTimeEnd') and objCondition['sEntryTimeEnd']:
dtEntryTimeEnd = to_datetime(objCondition['sDepartureTimeEnd'])
lsParams.append('g_foreigner.EntryTime <= :dtEntryTimeEnd')
dictParamsValue['dtEntryTimeEnd'] = dtEntryTimeEnd
if objCondition.has_key('sEntryPlace') and objCondition['sEntryPlace']:
sEntryPlace = objCondition['sEntryPlace']
lsParams.append('g_foreigner.EntryPlace = :sEntryPlace')
dictParamsValue['sEntryPlace'] = sEntryPlace
if objCondition.has_key(
'sDeparturePlace') and objCondition['sDeparturePlace']:
sDeparturePlace = objCondition['sDeparturePlace']
lsParams.append('g_foreigner.DeparturePlace = :sDeparturePlace')
dictParamsValue['sDeparturePlace'] = sDeparturePlace
if objCondition.has_key('sVisaType') and objCondition['sVisaType']:
sVisaType = objCondition['sVisaType']
lsParams.append('g_foreigner.VisaType = :sVisaType')
dictParamsValue['sVisaType'] = sVisaType
if objCondition.has_key(
'sVisaDeadline') and objCondition['sVisaDeadline']:
dtVisaDeadline = to_datetime(objCondition['sVisaDeadline'])
lsParams.append('g_foreigner.VisaDeadline = :dtVisaDeadline')
dictParamsValue['dtVisaDeadline'] = dtVisaDeadline
objSql = web.ctx.cur_dbsession.query(CheckIn, RelationCheckIn, GuestCheckIn, Foreigner, Hotel). \
filter(CheckIn.HotelID == Hotel.HotelID,
RelationCheckIn.CheckInID == CheckIn.CheckInID,
RelationCheckIn.HotelGuestID == GuestCheckIn.HotelGuestID,
RelationCheckIn.GuestDocID == Foreigner.GuestDocID)
objResult = get_data(objSql, lsParams, dictParamsValue, objPage)
nPageCount = 0
nRowCount = 0
if objResult:
if objResult.success:
lsQueryData = objResult.data['DataList']
nPageCount = objResult.data['PageCount']
nRowCount = objResult.data['RowCount']
lsData = []
for objData in lsQueryData:
dictCheckIn = obj_to_dict(objData[0])
dictRelationCheckIn = obj_to_dict(objData[1])
dictGuestCheckIn = obj_to_dict(objData[2])
dictForeigner = obj_to_dict(objData[3])
dictHotel = obj_to_dict(objData[4])
del dictCheckIn['IsNew'], dictCheckIn['TableID'], \
dictForeigner['GuestDocID'], dictForeigner['CreateTime'], \
dictForeigner['TableID'], dictGuestCheckIn['TableID']
dictGuestCheckIn['CheckInTime'] = dictRelationCheckIn[
'CheckInTime']
dictGuestCheckIn['CheckOutTime'] = dictRelationCheckIn[
'CheckOutTime']
dictGuestCheckIn['GuestState'] = dictRelationCheckIn[
'GuestState']
dictCheckIn['HotelName'] = dictHotel['HotelName']
dictCheckIn['HotelAddr'] = dictHotel['HotelAddr']
# 返回字典类型字段对应名称
# 客人状态名
dictGuestCheckIn['GuestStateName'] = dict_to_name(
dictRelationCheckIn['GuestState'], 'checkin_state')
# 性别
dictGuestCheckIn['HotelSexName'] = dict_to_name(
dictGuestCheckIn['HotelSex'], 'sex')
# 民族
dictGuestCheckIn['HotelNationName'] = dict_to_name(
dictGuestCheckIn['HotelNation'], 'gres_nation')
# 证件类型
dictGuestCheckIn['HotelDocTypeName'] = dict_to_name(
dictGuestCheckIn['HotelDocType'], 'doc_type')
# 签证类型
dictForeigner['VisaTypeName'] = dict_to_name(
dictForeigner['VisaType'], 'visa_type')
# 国籍
dictForeigner['NationalityName'] = dict_to_name(
dictForeigner['Nationality'], 'gres_country')
dictData = {
'GuestCheckIn': dictGuestCheckIn,
'Foreigner': dictForeigner,
'CheckinInfo': dictCheckIn
}
lsData.append(dictData)
return FuncResult(success=True,
data={
'PageNo': objPage['nPageNo'],
'PageSize': objPage['nPageSize'],
'PageCount': nPageCount,
'RowCount': nRowCount,
'DataSet': lsData
})
return FuncResult(data='', msg='无查询结果！')
def get_checkin_detail(self, nCheckInID):
objCheckIn = CheckIn().query.filter(
CheckIn.CheckInID == nCheckInID).first()
dictCheckIn = obj_to_dict(objCheckIn)
del dictCheckIn['TableID'], dictCheckIn['IsNew']
objHotel = Hotel().query.filter(
Hotel.HotelID == dictCheckIn['HotelID']).first()
# dictHotel = obj_to_dict(objHotel)
dictCheckIn['HotelName'] = objHotel.HotelName
lsGuestCheckIn = web.ctx.cur_dbsession.query(GuestCheckIn, RelationCheckIn, GuestDoc).\
filter(RelationCheckIn.CheckInID == nCheckInID,
RelationCheckIn.HotelGuestID == GuestCheckIn.HotelGuestID,
RelationCheckIn.GuestDocID == GuestDoc.GuestDocID).all()
if not objCheckIn and len(lsGuestCheckIn) <= 0:
return FuncResult(success=True, msg='')
lsData = []
for tupData in lsGuestCheckIn:
dictGuestCheckin = obj_to_dict(tupData[0])
dictRelationCheckIn = obj_to_dict(tupData[1])
dictGuestDoc = obj_to_dict(tupData[2])
del dictGuestCheckin['TableID'], dictGuestDoc['TableID']
dictGuestCheckin['CheckInTime'] = dictRelationCheckIn[
'CheckInTime']
dictGuestCheckin['CheckOutTime'] = dictRelationCheckIn[
'CheckOutTime']
dictGuestCheckin['GuestState'] = dictRelationCheckIn['GuestState']
# 返回字典类型字段对应名称
# 客人状态名
dictGuestCheckin['GuestStateName'] = dict_to_name(
dictRelationCheckIn['GuestState'], 'checkin_state')
# 性别
dictGuestCheckin['HotelSexName'] = dict_to_name(
dictGuestCheckin['HotelSex'], 'sex')
# 民族
dictGuestCheckin['HotelNationName'] = dict_to_name(
dictGuestCheckin['HotelNation'], 'gres_nation')
# 证件类型
dictGuestCheckin['HotelDocTypeName'] = dict_to_name(
dictGuestCheckin['HotelDocType'], 'doc_type')
# 证件类型
dictGuestDoc['DocTypeName'] = dict_to_name(dictGuestDoc['DocType'],
'doc_type')
# 性别
dictGuestDoc['SexName'] = dict_to_name(dictGuestDoc['Sex'], 'sex')
# 民族
dictGuestDoc['NationName'] = dict_to_name(dictGuestDoc['Nation'],
'gres_nation')
# 客人状态
dictGuestDoc['StateName'] = dict_to_name(dictGuestDoc['State'],
'checkin_state')
dictData = {
'GuestCheckIn': dictGuestCheckin,
'GuestDoc': dictGuestDoc
}
lsData.append(dictData)
return FuncResult(success=True,
msg='',
data={
'CheckinInfo': dictCheckIn,
'GuestInfo': lsData
})
preference_dictionaries = [None]
successes = []
for n, prefs_dict in enumerate(preference_dictionaries):
if prefs_dict is not None:
print(f"{n + 1}. RUN: running on {target} with prefs:")
# print preferences (setting happens in RunTestCase.runTest())
utils.print_single_prefs(prefs_dict, set_prefs=prefs)
else: # None
print(f"Running {target} with default preferences")
# RunTestCase.runTest() needs a dictionary
prefs_dict = {}
image_dir = os.path.join(target_image_dir,
utils.dict_to_name(prefs_dict))
success = nose.run(argv=argv,
plugins=[
SelectFilesPlugin(target_list, image_dir,
prefs_dict),
Capture(),
Xunit()
])
successes.append(success)
print(f"\nTARGET: {target.upper()}")
all_success = utils.check_success(successes, all_prefs_combinations)
all_successes.append(all_success)
def search_all_checkin(self, objCondition, objPage):
lsParams = []
dictParamsValue = {}
try:
if objCondition.has_key(
'sHotelNameLike') and objCondition['sHotelNameLike']:
sHotelName = '%' + objCondition['sHotelNameLike'] + '%'
lsParams.append('h_hotel.HotelName Like :sHotelName')
dictParamsValue['sHotelName'] = sHotelName
if objCondition.has_key(
'nProvinceID') and objCondition['nProvinceID']:
nProvinceID = objCondition['nProvinceID']
lsParams.append('h_hotel.ProvinceID = :nProvinceID')
dictParamsValue['nProvinceID'] = nProvinceID
if objCondition.has_key('nCityID') and objCondition['nCityID']:
nCityID = objCondition['nCityID']
lsParams.append('h_hotel.CityID = :nCityID')
dictParamsValue['nCityID'] = nCityID
if objCondition.has_key(
'nDistrictID') and objCondition['nDistrictID']:
nDistrictID = objCondition['nDistrictID']
lsParams.append('h_hotel.DistrictID = :nDistrictID')
dictParamsValue['nDistrictID'] = nDistrictID
if objCondition.has_key('sRoomNo') and objCondition['sRoomNo']:
sRoomNo = objCondition['sRoomNo']
lsParams.append('h_hotel.RoomNo = :sRoomNo')
dictParamsValue['sRoomNo'] = sRoomNo
dictCheckInParams = {}
if objCondition.has_key('sCheckInDateTimeStart') and objCondition[
'sCheckInDateTimeStart']:
dtCheckinDatetimeStart = to_datetime(
objCondition['sCheckInDateTimeStart'])
lsParams.append(
'h_checkin.CheckInTime >= :dtCheckinDatetimeStart')
dictParamsValue[
'dtCheckinDatetimeStart'] = dtCheckinDatetimeStart
dictCheckInParams['CheckInTime'] = dtCheckinDatetimeStart
if objCondition.has_key('sCheckInDateTimeEnd'
) and objCondition['sCheckInDateTimeEnd']:
dtCheckinDatetimeEnd = to_datetime(
objCondition['sCheckInDateTimeEnd'])
lsParams.append(
'h_checkin.CheckInTime <= :dtCheckinDatetimeEnd')
dictParamsValue['dtCheckinDatetimeEnd'] = dtCheckinDatetimeEnd
if objCondition.has_key(
'sNationality') and objCondition['sNationality']:
sNationality = objCondition['sNationality']
lsParams.append('g_foreigner.Nationality = :sNationality')
dictParamsValue['sNationality'] = sNationality
dictCheckInParams['Nationality'] = sNationality
if objCondition.has_key(
'nGuestState') and objCondition['nGuestState']:
nGuestState = objCondition['nGuestState']
lsParams.append('h_relation_checkin.GuestState = :nGuestState')
dictParamsValue['nGuestState'] = nGuestState
# 证件信息
# dictParams = {}
if objCondition.has_key('sHotelGuestNameLike'
) and objCondition['sHotelGuestNameLike']:
sHotelGuestName = '%' + objCondition[
'sHotelGuestNameLike'] + '%'
lsParams.append('g_guest_doc.GuestName Like :sHotelGuestName')
dictParamsValue['sHotelGuestName'] = sHotelGuestName
# dictParams['GuestName'] = sHotelGuestName
if objCondition.has_key(
'nHotelDocType') and objCondition['nHotelDocType']:
nHotelDocType = objCondition['nHotelDocType']
lsParams.append('g_guest_doc.DocType = :nHotelDocType')
dictParamsValue['nHotelDocType'] = nHotelDocType
if objCondition.has_key(
'sHotelDocNoLikeL') and objCondition['sHotelDocNoLikeL']:
sHotelDocNo = objCondition['sHotelDocNoLikeL'] + '%'
lsParams.append('g_guest_doc.DocNo Like :sHotelDocNo')
dictParamsValue['sHotelDocNo'] = sHotelDocNo
if objCondition.has_key('nHotelSex') and objCondition['nHotelSex']:
nHotelSex = objCondition['nHotelSex']
lsParams.append('g_guest_doc.Sex = :nHotelSex')
dictParamsValue['nHotelSex'] = nHotelSex
if objCondition.has_key(
'nHotelNation') and objCondition['nHotelNation']:
nHotelNation = objCondition['nHotelNation']
lsParams.append('g_guest_doc.Nation = :nHotelNation')
dictParamsValue['nHotelNation'] = nHotelNation
if objCondition.has_key(
'nHotelNationality') and objCondition['nHotelNationality']:
nHotelNationality = objCondition['nHotelNationality']
lsParams.append('g_guest_doc.Nationality = :nHotelNationality')
dictParamsValue['nHotelNationality'] = nHotelNationality
if objCondition.has_key('sHotelBornDateStart'
) and objCondition['sHotelBornDateStart']:
dtHotelBornDateStart = to_datetime(
objCondition['sHotelBornDateStart'])
lsParams.append(
'g_guest_doc.BornDate >= :dtHotelBornDateStart')
dictParamsValue['dtHotelBornDateStart'] = dtHotelBornDateStart
if objCondition.has_key(
'sHotelBornDateEnd') and objCondition['sHotelBornDateEnd']:
dtHotelBornDateEnd = to_datetime(
objCondition['sHotelBornDateEnd'])
lsParams.append('g_guest_doc.BornDate <= :dtHotelBornDateEnd')
dictParamsValue['dtHotelBornDateEnd'] = dtHotelBornDateEnd
# 入住出示证件信息
if objCondition.has_key(
'sGuestDocNameLike') and objCondition['sGuestDocNameLike']:
sGuestDocName = '%' + objCondition['sGuestDocNameLike'] + '%'
lsParams.append(
'g_guest_checkin.HotelGuestName Like :sGuestDocName')
dictParamsValue['sGuestDocName'] = sGuestDocName
if objCondition.has_key('nDocType') and objCondition['nDocType']:
nDocType = objCondition['nDocType']
lsParams.append('g_guest_checkin.HotelDocType = :nDocType')
dictParamsValue['nDocType'] = nDocType
if objCondition.has_key(
'sDocNoLikeL') and objCondition['sDocNoLikeL']:
sDocNo = objCondition['sDocNoLikeL'] + '%'
lsParams.append('g_guest_checkin.HotelDocNo Like :sDocNo')
dictParamsValue['sDocNo'] = sDocNo
if objCondition.has_key('nSex') and objCondition['nSex']:
nSex = objCondition['nSex']
lsParams.append('g_guest_checkin.HotelSex = :nSex')
dictParamsValue['nSex'] = nSex
if objCondition.has_key('nNation') and objCondition['nNation']:
nNation = objCondition['nNation']
lsParams.append('g_guest_checkin.HotelNation = :nNation')
dictParamsValue['nNation'] = nNation
if objCondition.has_key(
'nNationality') and objCondition['nNationality']:
nNationality = objCondition['nNationality']
lsParams.append(
'g_guest_checkin.HotelNationality = :nNationality')
dictParamsValue['nNationality'] = nNationality
if objCondition.has_key(
'nMatchResult') and objCondition['nMatchResult']:
nMatchResult = objCondition['nMatchResult']
lsParams.append('g_guest_checkin.MatchResult = :nMatchResult')
dictParamsValue['nMatchResult'] = nMatchResult
if objCondition.has_key(
'sBornDateStart') and objCondition['sBornDateStart']:
dtBornDateStart = to_datetime(objCondition['sBornDateStart'])
lsParams.append(
'g_guest_checkin.HotelBornDate >= :dtBornDateStart')
dictParamsValue['dtBornDateStart'] = dtBornDateStart
if objCondition.has_key(
'sBornDateEnd') and objCondition['sBornDateEnd']:
dtBornDateEnd = to_datetime(objCondition['sBornDateEnd'])
lsParams.append(
'g_guest_checkin.HotelBornDate <= :dtBornDateEnd')
dictParamsValue['dtBornDateEnd'] = dtBornDateEnd
objSql = web.ctx.cur_dbsession.query(CheckIn, RelationCheckIn, GuestCheckIn, GuestDoc, Foreigner, Hotel).\
filter(and_(CheckIn.HotelID == Hotel.HotelID,
RelationCheckIn.CheckInID == CheckIn.CheckInID,
RelationCheckIn.HotelGuestID == GuestCheckIn.HotelGuestID,
RelationCheckIn.GuestDocID == GuestDoc.GuestDocID,
RelationCheckIn.GuestDocID == Foreigner.GuestDocID))
lsQueryData = []
nPageCount = 0
nRowCount = 0
objResult = get_data(objSql, lsParams, dictParamsValue, objPage)
if objResult:
if objResult.success and objResult.data is not None:
lsQueryData = objResult.data['DataList']
nPageCount = objResult.data['PageCount']
nRowCount = objResult.data['RowCount']
lsData = []
if len(lsQueryData) > 0:
for objData in lsQueryData:
dictCheckIn = obj_to_dict(objData[0])
dictRelationCheckIn = obj_to_dict(objData[1])
dictGuestCheckIn = obj_to_dict(objData[2])
dictGuestDoc = obj_to_dict(objData[3])
dictForeigner = obj_to_dict(objData[4])
dictHotel = obj_to_dict(objData[5])
del dictCheckIn['IsNew'], dictCheckIn['TableID'],\
dictForeigner['GuestDocID'], dictForeigner['CreateTime'], \
dictForeigner['TableID'], dictGuestCheckIn['TableID'], \
dictGuestDoc['TableID']
dictGuestCheckIn['CheckInTime'] = dictRelationCheckIn[
'CheckInTime']
dictGuestCheckIn['CheckOutTime'] = dictRelationCheckIn[
'CheckOutTime']
dictGuestCheckIn['GuestState'] = dictRelationCheckIn[
'GuestState']
dictCheckIn['HotelName'] = dictHotel['HotelName']
dictCheckIn['HotelAddr'] = dictHotel['HotelAddr']
# 返回字典类型字段对应名称
# 客人状态名
dictGuestCheckIn['GuestStateName'] = dict_to_name(
dictRelationCheckIn['GuestState'], 'checkin_state')
# 性别
dictGuestCheckIn['HotelSexName'] = dict_to_name(
dictGuestCheckIn['HotelSex'], 'sex')
# 民族
dictGuestCheckIn['HotelNationName'] = dict_to_name(
dictGuestCheckIn['HotelNation'], 'gres_nation')
# 证件类型
dictGuestCheckIn['HotelDocTypeName'] = dict_to_name(
dictGuestCheckIn['HotelDocType'], 'doc_type')
# 国籍
dictGuestCheckIn[
'HotelNationalityName'] = dict_to_name(
dictGuestCheckIn['HotelNationality'],
'gres_country')
# 证件类型
dictGuestDoc['DocTypeName'] = dict_to_name(
dictGuestDoc['DocType'], 'doc_type')
# 性别
dictGuestDoc['SexName'] = dict_to_name(
dictGuestDoc['Sex'], 'sex')
# 民族
dictGuestDoc['NationName'] = dict_to_name(
dictGuestDoc['Nation'], 'gres_nation')
# 客人状态
dictGuestDoc['StateName'] = dict_to_name(
dictGuestDoc['State'], 'checkin_state')
# 签证类型
dictForeigner['VisaTypeName'] = dict_to_name(
dictForeigner['VisaType'], 'visa_type')
# 外国人国籍
dictForeigner['NationalityName'] = dict_to_name(
dictForeigner['Nationality'], 'gres_country')
dictData = {
'GuestCheckIn': dictGuestCheckIn,
'GuestDoc': dictGuestDoc,
'Foreigner': dictForeigner,
'CheckinInfo': dictCheckIn
}
lsData.append(dictData)
return FuncResult(success=True,
data={
'PageNo': objPage['nPageNo'],
'PageSize': objPage['nPageSize'],
'PageCount': nPageCount,
'RowCount': nRowCount,
'DataSet': lsData
})
except Exception, ce:
return FuncResult(fail=ce)