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