def Accept_Request():
reqType = request.json['type']
ManagerID = request.json['MID']
connector = SQL(server_name, server_admin, server_password)
if reqType == 'Delivery':
Deliver_id = request.json['DID']
Condition = "DELIVERY_ID = '" + str(Deliver_id) + "'"
connector.delete_query(table='delivery_verification',
sql_condition=Condition)
connector.update_query(
table='DELIVERY',
columns_values_dict={'MANAGER_ID': str(ManagerID)},
sql_condition=Condition)
elif reqType == 'Store':
Store_id = request.json['SID']
store_branch_id = request.json['BID']
Condition = "STORE_branch_ID = '" + str(store_branch_id) + "'"
connector.delete_query(table='store_verification',
sql_condition=Condition)
connector.update_query(
table='Store_branch',
columns_values_dict={'MANAGER_ID': str(ManagerID)},
sql_condition=Condition)
connector.close_connection()
return "1"
def DeliverOrder():
deliveryid = request.json['DELIVERYID']
orderid = request.json['ORDERID']
numberofDorders = request.json['no.Dorders']
connector = SQL(host=server_name, user=server_admin)
result = connector.select_query(table='ORDERS',
columns=['SHIPMENT_STATUS'],
sql_condition="ORDER_ID= " + orderid)
today = datetime.date.today().strftime("%Y-%m-%d")
if result['SHIPMENT_STATUS'][0] == 'ASSIGNED':
return "0"
else:
Query = {
'O.DELIVERY_ID': deliveryid,
'O.SHIPMENT_STATUS': 'ASSIGNED',
'D.AVAILABLE': "0",
'D.NUMBER_OF_DORDERS': numberofDorders,
'O.ORDER_DATE': today
}
condition = "O.ORDER_ID = " + orderid + " and D.delivery_id = " + deliveryid
connector.update_query(table='ORDERS as O, DELIVERY as D',
columns_values_dict=Query,
sql_condition=condition)
connector.close_connection()
return "1"
def Update_Item_table():
columns_dic = request.json['dic']
ID = request.json["ID"]
PRODUCT_NAME =request.json["PRODUCT_NAME"]
condition = "STORE_ID = '" +str(ID) + "' and PRODUCT_NAME = '" +PRODUCT_NAME+"'"
connector = SQL(host=server_name, user=server_admin)
connector.update_query(table='product' ,columns_values_dict= columns_dic,sql_condition=condition)
connector.close_connection()
return "1"
def UpdateDentistTable():
columns_dic = request.json['dic']
DentistID = request.json["DID"]
condition = "DENTIST_ID = " +str(DentistID)
connector = SQL(server_name,server_admin)
connector.update_query(table='Dentist' ,columns_values_dict= columns_dic,sql_condition=condition)
connector.close_connection()
return "1"
def UpdateData():
columns_dic = request.json['dic']
DeliveryID = request.json["MID"]
condition = "DELIVERY_ID = '" + str(DeliveryID) + "'"
connector = SQL(server_name, server_admin, server_password)
connector.update_query(table='DELIVERY',
columns_values_dict=columns_dic,
sql_condition=condition)
connector.close_connection()
return "1"
def Update_Store_table():
columns_dic = request.json['dic']
ID = request.json["ID"]
condition = "STORE_ID = '" + str(ID) + "'"
connector = SQL(host=server_name, user=server_admin)
connector.update_query(table='STORE',
columns_values_dict=columns_dic,
sql_condition=condition)
connector.close_connection()
return "1"
def Update_Manager_table():
columns_dic = request.json['dic']
ManagerID = request.json["MID"]
condition = "MANAGER_ID = '" + str(ManagerID) + "'"
connector = SQL(server_name, server_admin, server_password)
connector.update_query(table='Manager',
columns_values_dict=columns_dic,
sql_condition=condition)
connector.close_connection()
return "1"
def UpdatePassword():
newpassword = request.json["newpassword"]
oldpassword = request.json['oldpassword']
DeliveryID = request.json["DELIVERYID"]
condition = "DELIVERY_ID = '" + str(DeliveryID) + "'"
Query = {'DELIVERY_PASSWORD': newpassword}
connector = SQL(server_name, server_admin, server_password)
result = connector.select_query(table='DELIVERY',
columns=['DELIVERY_PASSWORD'],
sql_condition=condition)
if result['DELIVERY_PASSWORD'][0] == oldpassword:
connector.update_query(table='DELIVERY',
columns_values_dict=Query,
sql_condition=condition)
connector.close_connection()
return "1"
else:
return "0"
