def Employee_Login(request):
d = request.json
pw = d['emp_password']
emp_code = {k: v for k, v in d.items() if k in ('employee_email')}
emp_status = {'emp_status_id': d['login_status_id']}
if pw == json.loads(gensql('select', 'employee', 'emp_password',
emp_code))[0]['emp_password']:
d = {k: v for k, v in d.items() if k not in ('emp_password')}
d['log_time'] = application_datetime()
gensql('insert', 'employee_log', d)
gensql('update', 'employee', emp_status, emp_code)
return (json.dumps(
{
"Return": "Record Inserted Successfully",
"ReturnCode": "RIS",
"Status": "Success",
"StatusCode": "200"
},
indent=2))
else:
return (json.dumps(
{
"Return": "Record Not Inserted Successfully",
"ReturnCode": "RNIS",
"Status": "Success",
"StatusCode": "200"
},
indent=2))
def Insertappointmentreason(request):
try:
d=request.json
gensql('insert','new.appointment_reason',d)
return(json.dumps({"Message":"Record Inserted Successfully","Message_Code":"RIS","Service_Status":"Success"},indent=4))
except:
return(json.dumps({"Message":"Record Inserted UnSuccessful","Message_Code":"RIUS","Service_Status":"Failure"},indent=4))
def HOTEL_AR_POST_INSERT_AccountInvoice(request):
app_datetime = application_date()
d = request.json
Posting_date = app_datetime[1]
select = json.loads(dbget("select * from account_receivable.invoice_no"))
print(select, type(select), len(select))
invoice_id = (select[0]['invoice_num'] + 1)
print(invoice_id)
update = dbput("update account_receivable.invoice_no set invoice_num = '" +
str(select[0]['invoice_num'] + 1) + "'")
d['invoice_no'] = invoice_id
d['invoice_date'] = Posting_date
d['invoice_amount'] = '0'
d['open_amount'] = '0'
d['acc_invoice_satus'] = 'UnCompress'
gensql('insert', 'account_receivable.accout_inivoice', d)
return (json.dumps(
{
"Return": "Record Inserted Successfully",
"ReturnCode": "RIS",
"Status": "Success",
"StatusCode": "200",
"invoice_num": invoice_id
},
indent=4))
def queryani(request):
try:
ani = request.args["ani"]
d, e = {}, {}
d['customer_ani'] = ani
e['customer_mobile'] = ani
tab1 = (gensql('select', 'ivr_customer_profile',
'customer_language_pref', d))
print(tab1)
tab2 = (gensql('select', ' ivr_room_customer_booked', '*', e))
print(tab2, type(tab2))
res = json.loads(tab1)
res = res[0]
lang = res["customer_language_pref"]
res1 = json.loads(tab2)
res1 = res1[0]
res1['customer_language_pref'] = lang
print(res1, type(res1))
dict1 = {
"Return": "Record Retrieved Successfully",
"Return_Code": "RRS",
"Status": "Success",
"Status_Code": "200"
}
print(dict1, type(dict1))
dict1.update(res1)
print(dict1)
return (json.dumps(dict1))
except:
return (json.dumps(
{
"ServiceStatus": "Success",
"ServiceMessage": "Failure"
},
indent=2))
def HOTEL_RES_POST_INSERT_UpdateDeposit(request):
s,a = {},{}
d = request.json
status = json.loads(dbget("SELECT res_guest_status FROM reservation.res_reservation \
where res_unique_id='"+d['Res_unique_id']+"' and res_id='"+d['res_id']+"'"))
if status[0]['res_guest_status'] in ('checkin','checkout','due out'):
return(json.dumps({'Status': 'Success', 'StatusCode': '200','Return': 'Can not Deposit. Reservation checked-in','ReturnCode':'CND'}, sort_keys=True, indent=4))
a = {k : v for k,v in d.items() if v != '' }
print(d['res_id'],type(d['res_id']))
sql_value = gensql('insert','reservation.res_deposit',a)
#RES_Log_Date = datetime.datetime.utcnow().date()
if d['RES_Deposit_Amount'] == '':
pass
else:
s = {}
s['Emp_Id'] = "121"
s['Emp_Firstname'] = "Admin"
app_datetime = application_date()
s['RES_Log_Date'] = app_datetime[1]
s['RES_Log_Time'] = app_datetime[2]
s['RES_Action_Type'] = "Deposit amount is"+" "+d['RES_Deposit_Amount']
s['RES_Description'] = 'deposit amount is paid'
s['Res_id'] = d['res_id']
s['Res_unique_id'] = d['Res_unique_id']
sql_value = gensql('insert','reservation.res_activity_log',s)
return(json.dumps({'Status': 'Success', 'StatusCode': '200','Return': 'Record Inserted Successfully','ReturnCode':'RIS'}, sort_keys=True, indent=4))
def update_Businessprofile(request):
try:
d = request.json
businessid = json.loads(
dbget(
"select count(*) as business_id from new.business_profile where business_id ='"
+ str(d['business_id']) + "'"))
if businessid[0]['business_id'] == 1:
b = {k: v for k, v in d.items() if k in ('business_id')}
c = {k: v for k, v in d.items() if k not in ('business_id')}
gensql('Update', 'new.business_profile', b, c)
return (json.dumps(
{
"Message": "Recored Updated Successfully",
"Message_Code": "RUS",
"Service_Status": "Success"
},
indent=4))
else:
return (json.dumps(
{
'Message': 'Invalid Data',
'Message_Code': 'ID',
'Status': 'Failure'
},
indent=4))
except:
return (json.dumps(
{
"Message": "Record Updated Unsuccessful",
"Message_Code": "RUUS",
"Service_Status": "Success"
},
indent=4))
def hotel_rm_post_update_updateroomdiscrepancies(request):
i = {}
if request.json.get('RM_Room') and request.json.get('RM_HK_Status'):
RM_Room = request.json['RM_Room']
RM_HK_Status = request.json['RM_HK_Status']
res = dbfetch("select rm_fo_status from room_management.RM_Room_List where RM_Room = "+RM_Room+"")
res = res[0]
d,e = {},{}
e['RM_Room'] = RM_Room
d['RM_HK_Status'] = RM_HK_Status
print(gensql('update','room_management.RM_Room_List',d,e))
#print(gensql('update','room_management.RM_Room_List',d,e))
elif request.json.get('RM_Room') and request.json.get('RM_HK_Person'):
RM_Room = request.json['RM_Room']
RM_HK_Person = request.json['RM_HK_Person']
res = dbfetch("select rm_fo_person from room_management.RM_Room_List where RM_Room = "+RM_Room+"")
res = res[0]
print(type(res))
d,e = {},{}
e['RM_Room'] = RM_Room
d['RM_HK_Person'] = RM_HK_Person
print(gensql('update','room_management.RM_Room_List',d,e))
return(json.dumps({'Status': 'Success', 'StatusCode': '200','Return': 'Record Updated Successfully','ReturnCode':'RUS'}, sort_keys=True, indent=4))
def update_businessanddoctors(request):
try:
d = request.json
docinbusid = json.loads(
dbget(
"select count(*) as docbus_id from new.doctorinbusiness where docinbus_id ='"
+ d['docinbus_id'] + "'"))
if docinbusid[0]['docbus_id'] == 1:
b = {k: v for k, v in d.items() if k in ('docinbus_id')}
c = {k: v for k, v in d.items() if k not in ('docinbus_id')}
gensql('Update', 'new.doctorinbusiness', b, c)
return (json.dumps(
{
"Message": "Recored Updated Successfully",
"Message_Code": "RUS",
"Service": "Success"
},
indent=4))
else:
return (json.dumps(
{
'Message': 'Invalid Data',
'Message_Code': 'ID',
'Status': 'Failure'
},
indent=4))
except:
return (json.dumps(
{
"Message": "Record Updated Unsuccessful",
"Message_Code": "RUUS",
"Service_Status": "Success"
},
indent=4))
def room_to_sell_update(request):
d = request.json['records']
print(d, type(d))
for i in d:
j = {k: v for k, v in i.items() if k not in ('sell_id')}
ids = {
k: v
for k, v in j.items()
if k in ('room_id', 'business_id', 'room_date')
}
values = {
k: v
for k, v in j.items() if v != None
if k not in ('room_id', 'business_id', 'room_date', 'booked_count',
'con_room_name')
}
gensql('update', 'room_to_sell', values, ids)
return (json.dumps([{
'Status': 'Success',
'StatusCode': '200',
'Return': 'Record Updated Successfully',
'ReturnCode': 'RUS'
}],
sort_keys=True,
indent=4))
def room_open_update(request):
d = request.json['records']
print(d, type(d))
for i in d:
j = {k: v for k, v in i.items() if k not in ('s_no')}
ids = {
k: v
for k, v in j.items()
if k in ('rate_plan_id', 'room_id', 'business_id', 'room_date')
}
values = {
k: v
for k, v in j.items() if v != None
if k not in ('rate_plan_id', 'room_id', 'business_id', 'rate_plan',
'room_name', 'room_date')
}
gensql('update', 'extranet_availableroom', values, ids)
return (json.dumps([{
'Status': 'Success',
'StatusCode': '200',
'Return': 'Record Updated Successfully',
'ReturnCode': 'RUS'
}],
sort_keys=True,
indent=4))
def Update_Country(request):
try:
d = request.json
e = {k: v for k, v in d.items() if k in ('country_id')}
a = {k: v for k, v in d.items() if k not in ('country_id')}
country = json.loads(
dbget(
"select count(*) as country_id from new.country where country_id ='"
+ str(d['country_id']) + "'"))
if country[0]['country_id'] == 1:
gensql('update', 'new.country', a, e)
return (json.dumps(
{
"Message": "Record Updated Successfully",
"Message_Code": "RUS",
"Service_Status": "Success"
},
indent=4))
else:
return (json.dumps(
{
"Message": "Invalid Country_Id ",
"Message_Code": "ICI",
"Service_Status": "Failure"
},
indent=4))
except:
return (json.dumps(
{
"Message": "Recored Updated UnSuccessfully",
"Message_Code": "RUUS",
"Service": "Failure"
},
indent=4))
def UpdateCompanyProfile(request):
d = request.json
select = json.loads(dbget("select * from profile.profile_id"))
print(select,type(select),len(select))
print(select[0]['profile_id'])
id1 = "cpy"+str(select[0]['profile_id']+1)
print(id1)
update = dbput("update profile.profile_id set profile_id = '"+str(select[0]['profile_id']+1)+"'")
d['pf_id'] = id1
sql_value = gensql('insert','profile.pf_company_profile',d)
data1 = d.get("PF_Firstname")
pf_type = d['PF_Type']
#PF_Log_Time = datetime.datetime.utcnow()+datetime.timedelta(hours=5, minutes=30)
#PF_Log_Time = PF_Log_Time.time().strftime("%H:%M:%S")
#print(PF_Log_Time)
#PF_Log_Date = datetime.datetime.utcnow().date()
#print(PF_Log_Date)
PF_Log_Description = "Create "+str(pf_type)+" Profile" + " "+str(data1)
s = {}
s['Emp_Id'] = '121'
s['Emp_Firstname'] = "Admin"
s['Emp_Lastname'] = "User"
app_datetime = application_date()
s['PF_Log_Date'] = app_datetime[1]
s['PF_Log_Time'] = app_datetime[2]
s['PF_Action_Type'] = "New Profile"
s['PF_Log_Description'] = PF_Log_Description
s['pf_id'] = id1
sql_value = gensql('insert','profile.pf_profile_activitylog',s)
# finally return the value from DB_Wrapper
return(json.dumps({'Status': 'Success', 'StatusCode': '200','Return': 'Record Inserted Successfully','profileid':id1,'profiletype':pf_type,'ReturnCode':'RIS'}, sort_keys=True, indent=4))
def updatecustomerlangselected(request):
ani = request.args["ani"]
lang = request.args["lang"]
d = {}
d['customer_ani'] = ani
tab1 = (gensql('select', 'ivr_customer_profile', 'customer_language_pref',
d))
if len(tab1) > 2:
print(tab1)
return (json.dumps(
{
"Return": "Language Already Selected",
"Return Code": "LAS",
"Status": "Success",
"Status Code": "200"
},
indent=2))
d['customer_language_pref'] = lang
result = gensql('insert', 'ivr_customer_profile', d)
return (json.dumps(
{
"Return": "Record Inserted Successfully",
"Return Code": "RIS",
"Status": "Success",
"Status Code": "200"
},
indent=2))
def queryani(request):
ani = request.args["ani"]
d, e = {}, {}
d['customer_ani'] = ani
e['customer_mobile'] = ani
tab1 = (gensql('select', 'ivr_customer_profile', 'customer_language_pref',
d))
print(tab1)
tab2 = (gensql('select', ' ivr_room_customer_booked', '*', e))
print(tab2)
res = json.loads(tab1)
res = res[0]
lang = res["customer_language_pref"]
res1 = json.loads(tab2)
res1 = res1[0]
res1['customer_language_pref'] = lang
return (json.dumps(
{
"Return": "Record Retrieved Successfully",
"Return Code": "RRS",
"Status": "Success",
"Status Code": "200",
"Return Value": res1
},
indent=2))
def updatespecialization(request):
try:
d = request.json
e = {k: v for k, v in d.items() if k in ('specialization_id')}
a = {k: v for k, v in d.items() if k not in ('specialization_id')}
specialization = json.loads(
dbget(
"select count(*) as specialization_id from new.specialization where specialization_id ='"
+ str(d['specialization_id']) + "'"))
if specialization[0]['specialization_id'] == 1:
gensql('update', 'new.specialization', a, e)
return (json.dumps(
{
"Message": "Record Updated Successfully",
"Message_Code": "RUS",
"Service_Status": "Success"
},
indent=4))
else:
return (json.dumps(
{
"Message": "Invalid specialization_id ",
"Message_Code": "ICI",
"Service_Status": "Failure"
},
indent=4))
except:
return (json.dumps(
{
"Message": "Recored Updated UnSuccessfully",
"Message_Code": "RUUS",
"Service": "Failure"
},
indent=4))
def config(request):
res = request.json
roomtype = request.json['room_name']
res['room_name'] = roomtype.title()
rooms = json.loads(
dbget("select count(*) from configration where room_name='" +
res['room_name'] + "'"))
if rooms[0]['count'] == 0:
print(res)
gensql('insert', 'configration', res)
return (json.dumps(
{
"Return": "Record Inserted Successfully",
"ReturnCode": "RIS",
"ReturnMessage": "Success"
},
indent=2))
else:
return (json.dumps(
{
"Return": "Room Name Already Exist",
"ReturnCode": "RNAE",
"ReturnMessage": "Success"
},
indent=2))
def HOTEL_CAH_POST_UPDATE_TransfertoAnotherRoom(request):
d = request.json
a = {
k: v
for k, v in d.items() if v != '' if k not in ('Res_id', 'Res_room')
}
print("a", a)
e = {k: v for k, v in d.items() if k != '' if k in ('Res_id', 'Res_room')}
print("e", e)
#option = a['transfer_option']
#print(option)
if a['transfer_option'] == "GP":
pass
elif a['transfer_option'] == "EF":
print(
dbput("update cashiering.billing_post set res_room=" +
a['to_room'] + " \
where Res_id=" + e['Res_id'] + " and Res_room=" +
e['Res_room'] + " "))
#return(json.dumps({'Status': 'Success', 'StatusCode': '200', \
# 'Return': 'Record Updated Successfully','ReturnCode':'RUS'}, sort_keys=True, indent=4))
else:
print(
dbput("update cashiering.billing_post set res_room=" +
a['to_room'] + " \
where Res_id=" + e['Res_id'] + " and Res_room=" +
e['Res_room'] + " and checkno='" + str(a['checkno']) + "' "))
#return(json.dumps({'Status': 'Success', 'StatusCode': '200', \
# 'Return': 'Record Updated Successfully','ReturnCode':'RUS'}, sort_keys=True, indent=4))
#sql_value = gensql('update','cashiering.billing_post',a,e)
#print(sql_value)
app_datetime = application_date()
res_id = e.get("Res_id")
window = str(a.get("res_room"))
Posting_date = app_datetime[1]
Revenue_date = app_datetime[1]
s = {}
s['Posting_date'] = Posting_date
s['Revenue_date'] = Revenue_date
s['User_role'] = "Admin"
s['User_name'] = "Admin"
s['Res_id'] = res_id
s['Posting_action'] = "Window Transfer to Window " + "" + window
s['Posting_reason'] = "window Transfer to window " + " " + window + " reservation id " + res_id
s['Posting_description'] = "Transfer charges from one window to another window successfully"
gensql('insert', 'cashiering.posting_history_log', s)
gensql('insert', 'cashiering.posting_changes_history_log', s)
return (json.dumps(
{
'Status': 'Success',
'StatusCode': '200',
'Return': 'Record Updated Successfully',
'ReturnCode': 'RUS'
},
sort_keys=True,
indent=4))
def UpdateProfilePreferencenew(request):
#PF_Log_Time = datetime.datetime.utcnow()+datetime.timedelta(hours=5, minutes=30)
#PF_Log_Time = PF_Log_Time.time().strftime("%H:%M:%S")
#print(PF_Log_Time)
#PF_Log_Date = datetime.datetime.utcnow().date()
d = request.json
sql_value = gensql('insert', 'profile.pf_preference', d)
s = {}
s['Emp_Id'] = '121'
s['Emp_Firstname'] = "Admin"
s['Emp_Lastname'] = "User"
app_datetime = application_date()
s['PF_Log_Date'] = app_datetime[1]
s['PF_Log_Time'] = app_datetime[2]
s['PF_Action_Type'] = "Profile Preference"
s['PF_Log_Description'] = d['PF_Preference_Group']
s['pf_id'] = d['pf_id']
sql_value = gensql('insert', 'profile.pf_profile_activitylog', s)
return (json.dumps(
{
'Status': 'Success',
'StatusCode': '200',
'Return': 'Record Inserted Successfully',
'ReturnCode': 'RIS'
},
sort_keys=True,
indent=4))
def HOTEL_CAH_POST_INSERT_UPDATEPOSTINGPAYMENT(request):
d = request.json
print(d)
e = { k : v for k,v in d.items() if v != "" }
print(e)
sql = gensql('insert','cashiering.posting_payment',e)
print(sql)
#d['Posting_date'] = Posting_date
res_id = d.get("res_id")
print(res_id)
app_datetime = application_date()
Posting_date = app_datetime[1]
Revenue_date = app_datetime[1]
s = {}
s['Posting_date'] = Posting_date
s['Revenue_date'] = Revenue_date
s['User_role'] = "Admin"
s['User_name'] = "Admin"
s['Res_id'] = res_id
s['Posting_action'] = "Night Audit posting"
s['Posting_reason'] = "Payment posted for"+" "+res_id+ "and"+d.get("res_room")
s['Posting_description'] = "Payment posted successfully"
gensql('insert','cashiering.posting_history_log',s)
gensql('insert','cashiering.posting_original_history_log',s)
#dbput("update reservation.guest_deposit set total_amount = total_amount+'"+str(d['Postig_amount'])+"'\
# where res_id = '"+d['res_id']+"'")
return(json.dumps({"Return": "Record Inserted Successfully","ReturnCode": "RIS","Status": "Success","StatusCode": "200"},indent=4))
def Insert_Timing(request):
# try:
timing = request.json
doc_timing = {
k: v
for k, v in timing.items() if k in ('doctor_id', 'business_id')
}
if doc_timing['doctor_id'] != 0:
doctor = json.loads(
dbget(
"select count(*) as doc_id from new.doctor_profile where doctor_profile_id ='"
+ doc_timing['doctor_id'] + "'"))
business = json.loads(
dbget(
"select count(*) as bus_id from new.business_profile where business_id ='"
+ str(doc_timing['business_id']) + "'"))
if doctor[0]['doc_id'] == 1 and business[0]['bus_id'] == 1:
days = timing['days']
for day in days:
i = {}
i['doctor_id'] = doc_timing['doctor_id']
i['business_id'] = doc_timing['business_id']
i['day'] = day['day']
i['start_timing'] = day['start_timing']
i['end_timing'] = day['end_timing']
i['session'] = day['session']
gensql('insert', 'new.timing', i)
return (json.dumps(
{
"Message": "Record Inserted Successfully",
"Message_Code": "RIS",
"Service_Status": "Success"
},
indent=4))
else:
return (json.dumps(
{
'Message': 'Invalid Data',
'Message_Code': 'ID',
'Status': 'Failure'
},
indent=4))
else:
days = timing['days']
for day in days:
i = {}
i['doctor_id'] = doc_timing['doctor_id']
i['business_id'] = doc_timing['business_id']
i['day'] = day['day']
i['start_timing'] = day['start_timing']
i['end_timing'] = day['end_timing']
i['session'] = day['session']
gensql('insert', 'new.timing', i)
return (json.dumps(
{
"Message": "Record Inserted Successfully",
"Message_Code": "RIS",
"Service_Status": "Success"
},
indent=4))
def HOTEL_AR_POST_INSERT_CompressInvoice(request):
d = request.json
s ,z,f= {},[],{}
print("hello world")
select = json.loads(dbget("select * from account_receivable.invoice_no"))
print(select,type(select),len(select))
invoice_id = (select[0]['invoice_num']+1)
print(invoice_id)
update = dbput("update account_receivable.invoice_no set invoice_num = '"+str(select[0]['invoice_num']+1)+"'")
s['invoice_no'] = invoice_id
s['account_name'] = d['account_name']
s['account_number'] = d['account_number']
s['invoice_supplement'] = d['invoice_supplement']
s['reference'] = d['reference']
s['market_id'] = d['market_id']
s['source_id'] = d['source_id']
s['room_class_id'] = d['room_class_id']
s['invoice_amount'] = d['invoice_amount']
s['open_amount'] = d['open_amount']
s['acc_invoice_satus'] = "New Compress"
gensql('insert','account_receivable.accout_inivoice',s)
z= d['invoice_no']
for i in z:
print(invoice_id,i)
f['new_invoice_id'] = invoice_id
f['compress_invoice'] = i
gensql('insert','account_receivable.account_compress',f)
sql = dbput("update account_receivable.accout_inivoice set acc_invoice_satus = 'Compress'\
where account_number = '"+d['account_number']+"' and invoice_no = '"+str(i)+"'")
return(json.dumps({"Return": "Record Inserted Successfully","ReturnCode": "RIS",
"Status": "Success","StatusCode": "200","invoice_num":invoice_id},indent=4))
def Insert_Doctor_Login(request):
try:
d=request.json
print(d)
datetime1=datetime.datetime.now()
print(datetime1)
d['date_time'] = datetime1
doctorid = json.loads(dbget("select count(*) as doctor_id from new.doctorinbusiness where doctor_id ='"+d['doctor_id']+"'"))
print( doctorid)
businessid = json.loads(dbget("select count(*) as business_id from new.doctorinbusiness where business_id ='"+str(d['business_id'])+"'"))
print(businessid)
if doctorid[0]['doctor_id']==1 and businessid[0]['business_id']!=1:
print("hai")
dbput("update new.doctorinbusiness set login_status='" + str(d['login_status']) + "' \
where doctor_id='" +d['doctor_id']+"' and business_id='"+str(d['business_id'])+"'")
gensql('insert','new.doctor_login',d)
return(json.dumps({"Message":"Record Updated Successfully","Message_Code":"RUS","Service_Status":"Success"},indent=4))
else:
return(json.dumps({"Message":"Invalid_Data","Message_Code":"ID","Service_Status":"UnSuccess"},indent=4))
#gensql('insert','new.doctor_login',d)
except:
return(json.dumps({"Message":"Record Inserted UnSuccessfull","Message_Code":"RIUS","Service_Status":"Failure"},indent=4))
def updatedcustomerprofile(request):
customer_name = request.json['customer_name']
customer_mobile = request.json['customer_mobile']
customer_email = request.json['customer_email']
customer_cc = request.json['customer_cc']
customer_expirydate = request.json['customer_expirydate']
customer_room_type = request.json['customer_room_type']
customer_pickup_drop = request.json['customer_pickup_drop']
customer_menu_navigation = request.json['customer_menu_navigation']
d1,d2,d3 = {},{},{}
d1['customer_name'] = customer_name
d1['customer_mobile'] = customer_mobile
d2['customer_email'] = customer_email
d2['customer_cc'] = customer_cc
d2['customer_expirydate'] = customer_expirydate
d3['customer_room_type'] = customer_room_type
d3['customer_pickup_drop'] = customer_pickup_drop
d3['customer_menu_navigation'] = customer_menu_navigation
print(gensql('update','ivr_customer_profile',d2,d1))
print(gensql('update','ivr_room_customer_booked',d3,d1))
return(json.dumps({"Return":"Record Updated Successfully","Return Code":"RUS","Status": "Success",
"Status Code": "200"},indent=2))
def UpdateProfileRecord(request):
res = request.json
print(res)
e = { k : v for k,v in res.items() if k in ('pf_id')}
print(e['pf_id'])
d = { k : v for k,v in res.items() if k not in ('pf_id')}
if e['pf_id'][0:3] == 'cpy':
sql_value = gensql('update','profile.pf_company_profile',d,e)
else:
sql_value = gensql('update','profile.pf_individual_profile',d,e)
values = d.values()
print(values)
PF_Log_Description = ''
for i in values:
PF_Log_Description += i +" | "
print(PF_Log_Description)
s = {}
s['Emp_Id'] = '121'
s['Emp_Firstname'] = "Admin"
s['Emp_Lastname'] = "User"
app_datetime = application_date()
s['PF_Log_Date'] = app_datetime[1]
s['PF_Log_Time'] = app_datetime[2]
s['PF_Action_Type'] = "Update Profile"
s['PF_Log_Description'] = PF_Log_Description
s['pf_id'] = e['pf_id']
sql_value = gensql('insert','profile.pf_profile_activitylog',s)
return(json.dumps({'Status': 'Success', 'StatusCode': '200','Return': 'Record Updated Successfully',
'ReturnCode':'RUS'}, sort_keys=True, indent=4))
def updateuser_profile(request):
try:
a = request.json
mob = json.loads(
dbget(
"select count(*) as mobile from new.user_profile where mobile ='"
+ a['mobile'] + "'"))
print(mob[0]['mobile'])
if mob[0]['mobile'] == 0:
return (json.dumps(
{
'Message': 'Invalid Data',
'MessageCode': 'ID',
'Status': 'Failure',
},
indent=4))
else:
b = {k: v for k, v in a.items() if k in ('mobile')}
c = {k: v for k, v in a.items() if k not in ('mobile')}
gensql('update', 'new.user_profile', c, b)
return (json.dumps(
{
"Message": "Recored Updated Successfully",
"Message_Code": "RUS",
"Service": "Success"
},
indent=4))
except:
return (json.dumps(
{
"Message": "Recored Updated UnSuccessfully",
"Message_Code": "RUUS",
"Service": "UnSuccess"
},
indent=4))
def adddiscount(request):
res = request.json
print(res)
e = {k: v for k, v in res.items() if k in ('business_id', 'room_type')}
d = {
k: v
for k, v in res.items() if k not in ('business_id', 'room_type',
'room_date_st', 'room_date_ed')
}
st_d = res['room_date_st']
ed_d = res['room_date_ed']
st_d = datetime.datetime.strptime(st_d, '%Y-%m-%d').date()
ed_d = datetime.datetime.strptime(ed_d, '%Y-%m-%d').date()
#print(e)
#print(d)
f = {k: v for k, v in res.items() if k in ('room_date')}
#print("f",f)
id_data = json.loads(gensql('select', 'extranet_room_list', 'id', e))
print("id_data", id_data, type(id_data))
str_id = ''
for i in id_data:
while st_d <= ed_d:
sql = json.loads(
dbget("select count(*) from extranet_discount where id in (" +
str(i['id']) + ") and room_date='" + str(st_d) + "' "))
print(sql[0]['count'])
if sql[0]['count'] == 0:
try:
d['id'] = i['id']
d['room_date'] = st_d
print(gensql('insert', 'extranet_discount', d))
print("inserted")
except:
return (json.dumps(
{
"ServiceStatus": "Failure",
"ServiceMessage": "Failure"
},
indent=2))
else:
try:
f['id'] = i['id']
print(gensql('update', 'extranet_discount', d, f))
print("updated")
except:
return (json.dumps(
{
"ServiceStatus": "Failure",
"ServiceMessage": "Failure"
},
indent=2))
print("record already inserted")
st_d += datetime.timedelta(days=1)
return (json.dumps(
{
"ServiceStatus": "Success",
"ServiceMessage": "Record Inserted"
},
indent=2))
def HOTEL_RES_POST_INSERT_CancelReservation(request):
d = request.json
z = {
k: v
for k, v in d.items()
if k not in ('Res_Arrival', 'Res_Depature', 'Res_Room_Type')
}
sql_value = gensql('insert', 'reservation.cancel_reservation', z)
Res_id = d.get("Res_id")
Res_unique_id = d.get("Res_unique_id")
e, a = {}, {}
e['Res_id'] = Res_id
e['Res_unique_id'] = Res_unique_id
a['Res_guest_status'] = "cancel"
sql_value = gensql('update', 'reservation.res_reservation', a, e)
print(sql_value)
initial = datetime.datetime.strptime(d['Res_Depature'], '%Y-%m-%d').date()
depature_minus = initial - datetime.timedelta(days=1)
bookedcount = dbput(
"update room_management.room_available set available_count=available_count + '1',\
booked_count = booked_count - '1' where rm_room = \
'" + str(d['Res_Room_Type']) + "' and \
rm_date between '" + str(d['Res_Arrival']) +
"' and '" + str(depature_minus) + "' ")
res_id = e.get("Res_id")
Emp_Id = '121'
Emp_Firstname = "Admin"
select = json.loads(dbget("select * from reservation.cancel_id"))
print(select, type(select), len(select))
print(select[0]['id'])
cancel_id = str(select[0]['id'] + 1)
print(cancel_id)
update = dbput("update reservation.cancel_id set id = '" +
str(select[0]['id'] + 1) + "'")
s = {}
s['Emp_Id'] = Emp_Id
s['Emp_Firstname'] = Emp_Firstname
app_datetime = application_date()
s['RES_Log_Date'] = app_datetime[1]
s['RES_Log_Time'] = app_datetime[2]
s['RES_Action_Type'] = "Cancel Reservation"
s['RES_Description'] = "cancellation Number is" + " " + cancel_id
s['Res_id'] = res_id
sql_value = gensql('insert', 'reservation.res_activity_log', s)
return (json.dumps(
{
'Status': 'Success',
'StatusCode': '200',
'Return': 'Record Inserted Successfully',
'cancellationNumber': cancel_id,
'ReturnCode': 'RIS'
},
sort_keys=True,
indent=4))
def HOTEL_BBL_POST_INSERT_BusinessBlock(request):
sql_value = json.loads(dbget("select count_id from business_block.count"))
print(sql_value,type(sql_value))
sql_value1 = sql_value[0]['count_id']
#sql = int(sql_value1)
print(sql_value1,type(sql_value1))
count = sql_value1 + 1
print(count)
psql = dbput("update business_block.count set count_id = '"+str(sql_value[0]['count_id']+1)+"'")
print(psql)
d = request.json
E = d['Inquiry']
E = { k : v for k,v in E.items() if v != ''}
print(E)
E['block_id'] = count
random_no = (random.randint(1000000000,9999999999))
random_no = str(random_no)
random_no = random_no[0:4]
print(random_no)
pf_id = E.get("pf_id")
PF_ACCOUNT = json.loads(dbget("select pf_account from profile.pf_company_profile where pf_id = '"+pf_id+"'"))
PF_ACCOUNT = PF_ACCOUNT[0]['pf_account']
pf_account = PF_ACCOUNT[0:5]
E['block_status'] = "Inquiry"
E['block_code'] = random_no + pf_account
E['block_name'] = PF_ACCOUNT
sql = gensql('insert','business_block.business_block',E)
print(sql)
#inquiry grid
id11 = E.get("block_id")
g = d['Inquiry_grid']
print(g,type(g))
for i in g:
j = { k : v for k,v in i.items() if v != ''}
j['block_id'] = id11
psql = gensql('insert','business_block.inquiry_grid',j)
s = {}
s['user_role'] = "Supervisor"
blockname = E.get("block_name")
app_datetime = application_date()
#RES_Log_Time = datetime.datetime.utcnow()+datetime.timedelta(hours=5, minutes=30)
RES_Log_Time = app_datetime[0]
RES_Log_Date = app_datetime[1]
print(RES_Log_Date)
s['date'] = RES_Log_Date
s['time'] = RES_Log_Time
s['block_id'] = count
s['action_type_id'] = "Business Block in inquiry status"
s['description'] = "Business Block in inquiry status for"+" "+str(blockname)
gensql('insert','business_block.business_block_activity_log',s)
return(json.dumps({"Return": "Record Inserted Successfully","ReturnCode": "RIS","Status": "Success","StatusCode": "200"},indent=4))
def Insert_Packages(request):
d = request.json
gensql('insert', 'public.packages', d)
return (json.dumps(
{
"ServiceStatus": "Success",
"ServiceMessage": "Success"
}, indent=2))
def updatedocservices(request):
try:
d=request.json
a= { k : v for k,v in d.items() if k not in ('service_id')}
e={ k : v for k,v in d.items() if k in ('service_id')}
gensql('update','new.doctor_services',a,e)
return(json.dumps({"Message":"Record Updated Successfully","Message_Code":"RUS","Service_Status":"Success"},indent=4))
except:
return(json.dumps({"Message":"Record Updated Unsuccessful","Message_Code":"RUUS","Service_Status":"Success"},indent=4))
