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"