def Store_Information():
columns = ['STORE_NAME', 'EMAIL', 'PHONE_NUMBER', 'CREDIT_CARD_NUMBER']
ID = request.json['ID']
connector = SQL(host=server_name, user=server_admin)
condition = " STORE_ID ='" + ID + "' and MANAGER_ID "
Count_Region = connector.select_query(table='store_branch ',
columns=['count(STORE_ID)'],
sql_condition=condition)
Region = connector.select_query(table='store_branch ',
columns=['REGION'],
sql_condition=condition)
condition = " STORE_ID ='" + ID + "' "
result = connector.select_query(table='STORE ',
columns=columns,
sql_condition=condition)
result = {
'STORE_NAME': result['STORE_NAME'],
'EMAIL': result['EMAIL'],
'PHONE_NUMBER': result['PHONE_NUMBER'],
'CREDIT_CARD_NUMBER': result['CREDIT_CARD_NUMBER'],
'Count_Branches': Count_Region['count(STORE_ID)'],
'BRANCHES': Region['REGION']
}
connector.close_connection()
return json.dumps(result)
def StoreStatus():
email = request.json['email']
condition = "email = '" + email + "'"
connector = SQL(host=server_name, user=server_admin)
Store_ID = connector.select_query(table='STORE',
columns=['STORE_ID'],
sql_condition=condition)
if Store_ID['STORE_ID'] == [None]:
return 'invalid email'
ID = Store_ID['STORE_ID'][0]
condition = "STORE_ID = '" + str(ID) + "'"
#if manager ID has value -> Delivery is accepted
IDS = connector.select_query(table='STORE_BRANCH',
columns=['MANAGER_ID', 'Store_branch_id'],
sql_condition=condition)
for item in IDS['MANAGER_ID']:
if item != None:
connector.close_connection()
return "Accepted"
#else there are 2 state waiting or rejected
else:
for item in IDS['Store_branch_id']:
condition = "Store_branch_id = '" + str(item) + "'"
#if delivery verification id has value(existed) means delivery in pending
verificationid = connector.select_query(table='store_verification',
columns=['Verifing_ID'],
sql_condition=condition)
if verificationid['Verifing_ID'] != []:
connector.close_connection()
return "Pending"
#else delivery is rejected
else:
connector.close_connection()
return "Rejected"
def ViewComments():
# Retrive Comments of a certian product
sql = SQL(server_name, server_admin)
product_id = request.json['product_id']
comment_result = sql.select_query('DENTIST_COMMENT', ['DENTIST_ID', 'COMMENT_ID', 'COMMENT_CONTEXT', 'COMMENT_TIME', 'LIKES'], f" PRODUCT_ID = {product_id}")
Output = {}
Output['comment_id'] = comment_result['COMMENT_ID']
Output['comment'] = comment_result['COMMENT_CONTEXT']
Output['likes'] = comment_result['LIKES']
Output['DentistID'] = comment_result['DENTIST_ID']
Dentist_Names = []
Dentist_Images = []
dentist_ids = comment_result['DENTIST_ID']
for dentist_id in dentist_ids:
dentist_query = sql.select_query('DENTIST', ['DENTIST_Fname', 'DENTIST_LNAME', 'DENTIST_IMAGE_URL'], f" DENTIST_ID = {dentist_id}")
name = dentist_query['DENTIST_Fname'][0] + " " + dentist_query["DENTIST_LNAME"][0]
Dentist_Names.append(name)
Dentist_Images.append(dentist_query['DENTIST_IMAGE_URL'][0])
Output['DentistName'] = Dentist_Names
Output['Dentist_Images'] = Dentist_Images
#Date
Dates = []
for date in comment_result['COMMENT_TIME']:
Dates.append(CheckDate(date))
Output['CommentDate'] = Dates
sql.close_connection()
return json.dumps(Output)
def AddtoCart():
sql = SQL(server_name, server_admin)
product_id = request.json['product_id']
dentist_email = request.json['dentist_email']
for_id = sql.select_query('DENTIST', ['DENTIST_ID'],
f"DENTIST_EMAIL = '{dentist_email}'")
dentist_id = for_id['DENTIST_ID'][0]
check_exsist = sql.select_query(
'DentistCart', ['DENTIST_ID', 'Number_Units'],
f"DENTIST_ID = {dentist_id} and PRODUCT_ID = {product_id}")
try:
if len(check_exsist['DENTIST_ID']) > 0:
units = check_exsist['Number_Units'][0] + 1
#sql.update_query('DentistCart', {'Number_Units' : units}, f" DENTIST_ID = {dentist_id} and PRODUCT_ID = {product_id}")
sql.exectute_query(
f"UPDATE DentistCart SET Number_Units = {units} WHERE DENTIST_ID = {dentist_id} and PRODUCT_ID = {product_id};"
)
else:
sql.insert_query('DentistCart',
['DENTIST_ID', 'PRODUCT_ID', 'Number_Units'],
[dentist_id, product_id, 1])
except:
sql.insert_query('DentistCart',
['DENTIST_ID', 'PRODUCT_ID', 'Number_Units'],
[dentist_id, product_id, 1])
sql.close_connection()
return '1'
def ProductsofOrder():
orderid = request.json['orderid']
connector = SQL(host=server_name, user=server_admin)
condition = " op.PRODUCT_ID = p.PRODUCT_ID and op.ORDER_ID = '" + orderid + "'"
columns = ['count(*)']
numberofproducts = connector.select_query(
table='order_product as op, product as p ',
columns=columns,
sql_condition=condition)
columns = [
'op.PRODUCT_ID', 'p.PRODUCT_NAME', 'p.SELLING_PRICE',
'op.NUMBER_OF_UNITS'
]
result = connector.select_query(table='order_product as op, product as p ',
columns=columns,
sql_condition=condition)
result = {
'productid': result['op.PRODUCT_ID'],
'productname': result['p.PRODUCT_NAME'],
'productprice': result['p.SELLING_PRICE'],
'no.units': result['op.NUMBER_OF_UNITS'],
'no.products': numberofproducts['count(*)']
}
connector.close_connection()
return json.dumps(result)
def OrdersToBeDelivered():
columns = [
'o.ORDER_ID', 'o.TOTAL_COST', 'd.DENTIST_Fname', 'd.DENTIST_LNAME',
'd.DENTIST_ADDRESS', 'd.DENTIST_PHONE_NUMBER', 'd.DENTIST_EMAIL',
'd.DENTIST_ID', 'O.SHIPMENT_STATUS'
]
area = request.json['area']
connector = SQL(host=server_name, user=server_admin)
condition = " (SHIPMENT_STATUS = 'Not Delivered' or SHIPMENT_STATUS = 'ASSIGNED')and d.DENTIST_ID=o.DENTIST_ID and d.DENTIST_CITY='" + area + "' order by O.SHIPMENT_STATUS"
availableordersnumber = connector.select_query(
table='orders as O, dentist as d ',
columns=['count(distinct O.ORDER_ID)'],
sql_condition=condition)
result = connector.select_query(table='orders as O, dentist as d ',
columns=columns,
sql_condition=condition,
DISTINCTdetector=True)
result = {
'status': result['O.SHIPMENT_STATUS'],
'orderid': result['o.ORDER_ID'],
'ordertotal': result['o.TOTAL_COST'],
'dentistfname': result['d.DENTIST_Fname'],
'dentistlname': result['d.DENTIST_LNAME'],
'no.orders': availableordersnumber['count(distinct O.ORDER_ID)'],
'address': result['d.DENTIST_ADDRESS'],
'phone': result['d.DENTIST_PHONE_NUMBER'],
'email': result['d.DENTIST_EMAIL'],
'DID': result['d.DENTIST_ID']
}
connector.close_connection()
return json.dumps(result)
def Store_ManagerChat():
ID = request.json['ID']
connector = SQL(host=server_name, user=server_admin)
condition = " STORE_ID ='" + ID + "'"
Count_Region = connector.select_query(
table='store_branch ',
columns=['count(DISTINCT (MANAGER_ID))'],
sql_condition=condition)
condition = "MANAGER_ID in (select MANAGER_ID from store_branch where STORE_ID ='" + ID + "' and MANAGER_ID )"
columns = ['MANAGER_Fname', 'MANAGER_Lname', 'MANAGER_ID']
result = connector.select_query(table='manager',
columns=columns,
sql_condition=condition)
result = {
'MANAGER_Fname':
result['MANAGER_Fname'],
'MANAGER_ID':
result['MANAGER_ID'],
'MANAGER_Lname':
result['MANAGER_Lname'],
'count(DISTINCT (MANAGER_ID))':
Count_Region['count(DISTINCT (MANAGER_ID))']
}
connector.close_connection()
return json.dumps(result)
def DeliveryStatus():
deliveryemail = request.json['email']
condition = "DELIVERY_EMAIL = '" + deliveryemail + "'"
connector = SQL(host=server_name,
user=server_admin,
password=server_password)
#if manager ID has value -> Delivery is accepted
IDS = connector.select_query(table='DELIVERY',
columns=['MANAGER_ID', 'DELIVERY_ID'],
sql_condition=condition)
if IDS['MANAGER_ID'] != [None]:
connector.close_connection()
return "Accepted"
#else there are 2 state waiting or rejected
else:
condition = "DELIVERY_ID = " + str(IDS['DELIVERY_ID'][0])
#if delivery verification id has value(existed) means delivery in pending
verificationid = connector.select_query(
table='delivery_verification',
columns=['DELIVERY_VERIFICATION_ID'],
sql_condition=condition)
if verificationid['DELIVERY_VERIFICATION_ID'] != []:
connector.close_connection()
return "Pending"
#else delivery is rejected
else:
connector.close_connection()
return "Rejected"
def Avaliable_total_Products():
columns = ['NUMBER_OF_UNITS','SELLING_PRICE','PRICE' ,'IMAGE_URL', 'PRODUCT_NAME','PRODUCT_ID']
connector = SQL(host=server_name, user=server_admin)
Count_Product = connector.select_query(table='product',columns= ['count(distinct PRODUCT_ID)'])
result = connector.select_query(table='product',columns=columns)
result = {'SELLING_PRICE': result['SELLING_PRICE'],'PRICE': result['PRICE'],'PRODUCT_ID': result['PRODUCT_ID'], 'NUMBER_OF_UNITS': result['NUMBER_OF_UNITS'], 'IMAGE_URL': result['IMAGE_URL'], 'PRODUCT_NAME': result['PRODUCT_NAME'], 'Count': Count_Product['count(distinct PRODUCT_ID)']}
connector.close_connection()
return json.dumps(result)
def Avaliable_Products():
columns = ['NUMBER_OF_UNITS','SELLING_PRICE','RATE','Brand','PRICE' ,'Category','DESCRIPTION','IMAGE_URL', 'PRODUCT_NAME','PRODUCT_ID']
ID = request.json['ID']
connector = SQL(host=server_name, user=server_admin)
condition = " STORE_ID ='" + ID+ "' "
Count_Product = connector.select_query(table='product ',columns= ['count(distinct PRODUCT_ID)'],sql_condition=condition)
result = connector.select_query(table='product ',columns=columns,sql_condition=condition)
result = {'SELLING_PRICE': result['SELLING_PRICE'],'PRICE': result['PRICE'],'Brand': result['Brand'],'RATE': result['RATE'],'PRODUCT_ID': result['PRODUCT_ID'], 'NUMBER_OF_UNITS': result['NUMBER_OF_UNITS'],'Category': result['Category'],'DESCRIPTION': result['DESCRIPTION'], 'IMAGE_URL': result['IMAGE_URL'], 'PRODUCT_NAME': result['PRODUCT_NAME'], 'Count': Count_Product['count(distinct PRODUCT_ID)']}
connector.close_connection()
return json.dumps(result)
def FetchProducts():
index = request.json['index']
sql = SQL(server_name, server_admin)
Prod_Query = sql.select_general('PRODUCT', ['PRODUCT_ID', 'PRODUCT_NAME', 'SELLING_PRICE', 'IMAGE_URL', 'RATE', 'DESCRIPTION', 'Brand', 'NO_OF_REVIEWERS', 'CATEGORY'], f" Limit {index}, 1")
Output = {}
Output['ProductID'] = Prod_Query['PRODUCT_ID'][0]
Output['ProductName'] = Prod_Query['PRODUCT_NAME'][0]
Output['Price'] = Prod_Query['SELLING_PRICE'][0]
Output['Category'] = Prod_Query['CATEGORY'][0]
Output['ImageURL'] = Prod_Query['IMAGE_URL'][0]
Output['Rate'] = Prod_Query['RATE'][0]
Output['Description'] = Prod_Query['DESCRIPTION'][0]
Output['Brand'] = Prod_Query['Brand'][0]
Output['NoOfReviews'] = Prod_Query['NO_OF_REVIEWERS'][0]
# Offer is remaining
offer_query = sql.select_query('OFFERS', ['DISCOUNT'], f"PRODUCT_ID = {Output['ProductID']}")
try:
Output["discount"] = offer_query['DISCOUNT'][0]
except:
Output["discount"] = 0
print(Output)
return json.dumps(Output)
def Delivery_insertion():
connector = SQL(host=server_name, user=server_admin)
columns = [
'DELIVERY_Fname', 'DELIVERY_Lname', 'DELIVERY_EMAIL',
'DELIVERY_PASSWORD', 'DELIVERY_CREDIT_CARD_NUMBER', 'AREA',
'VECHILE_LICENCE', 'VECHILE_MODEL', 'Delivery_PHONE_NUMBER'
]
values = []
for key in columns:
values.append(request.json[key])
columns.append('AVAILABLE')
values.append(1)
columns.append('RATE')
values.append(0)
columns.append('NUMBER_OF_DORDERS')
values.append(0)
connector.insert_query(table='DELIVERY', attributes=columns, values=values)
condition = "DELIVERY_EMAIL = '" + values[2] + "'"
DeliveryID = connector.select_query(table='DELIVERY',
columns=['delivery_ID'],
sql_condition=condition)
connector.insert_query(table='DELIVERY_VERIFICATION',
attributes=['DELIVERY_ID'],
values=DeliveryID['delivery_ID'])
connector.close_connection()
return "1"
def DeliveredOrders():
deliverid = request.json['DELIVERYID']
today = datetime.date.today().strftime("%Y-%m-%d")
columns = [
'O.ORDER_ID',
'D.DENTIST_FNAME',
'D.DENTIST_LNAME',
'O.SHIPMENT_STATUS',
'O.TOTAL_COST',
]
condition = "O.DELIVERY_ID = " + deliverid + " and O.ORDER_DATE= '" + today + "' and O.DENTIST_ID=D.DENTIST_ID and O.SHIPMENT_STATUS ='DELIVERED' order by O.SHIPMENT_STATUS"
connector = SQL(host=server_name, user=server_admin)
result = connector.select_query(table='ORDERS as O , DENTIST as D',
columns=columns,
sql_condition=condition,
DISTINCTdetector=True)
connector.close_connection()
result = {
'cost': result['O.TOTAL_COST'],
'orderids': result['O.ORDER_ID'],
'number': len(result['O.ORDER_ID']),
'dentistfname': result['D.DENTIST_FNAME'],
'dentistlname': result['D.DENTIST_LNAME'],
'status': result['O.SHIPMENT_STATUS']
}
return json.dumps(result)
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 TotalDeliveredOrders():
deliverid = request.json['DELIVERYID']
condition = "DELIVERY_ID = " + deliverid + " and SHIPMENT_STATUS = 'DELIVERED'"
connector = SQL(server_name, server_admin, server_password)
result = connector.select_query(table='ORDERS',
columns=['count(*)'],
sql_condition=condition)
connector.close_connection()
return json.dumps(result)
def ViewLikes():
comment_id = request.json['comment_id']
sql = SQL(server_name, server_admin)
dentist_result = sql.select_query('DENTIST_LIKES', ['DENTIST_ID'], f"COMMENT_ID = {comment_id}")
dentist_ids = dentist_result['DENTIST_ID']
Dentist_Names = []
Dentist_Images = []
for dentist_id in dentist_ids:
dentist_query = sql.select_query('DENTIST', ['DENTIST_Fname', 'DENTIST_LNAME', 'DENTIST_IMAGE_URL'], f" DENTIST_ID = {dentist_id}")
name = dentist_query['DENTIST_Fname'][0] + " " + dentist_query["DENTIST_LNAME"][0]
Dentist_Names.append(name)
Dentist_Images.append(dentist_query['DENTIST_IMAGE_URL'][0])
Outputs = {}
Outputs['Names'] = Dentist_Names
Outputs['Images'] = Dentist_Images
return json.dumps(Outputs)
def NoComments():
# Retrive number of comments
product_id = request.json['product_id']
sql = SQL(server_name, server_admin)
result = sql.select_query('DENTIST_COMMENT', ['PRODUCT_ID'], f"PRODUCT_ID = {product_id}")
sql.close_connection()
try:
return str(len(result['PRODUCT_ID']))
except:
return '0'
def Total_Delivered_orders():
Delivery_ID = request.json['DID']
Conditon = "DELIVERY_ID = '" + str(Delivery_ID) + "'"
connector = SQL(server_name, server_admin, server_password)
result = connector.select_query(table='Delivery',
columns=['NUMBER_OF_DORDERS'],
sql_condition=Conditon)
result = {"noofOrders": result['NUMBER_OF_DORDERS'][0]}
connector.close_connection()
return json.dumps(result)
def GetAreaofManager():
email = request.json['Email']
Condition = "MANAGER_EMAIL = '" + email + "'"
connector = SQL(server_name, server_admin, server_password)
result = connector.select_query(table="MANAGER",
columns=['AREA_OF_MANAGEMENT'],
sql_condition=Condition)
result = {'Area': result['AREA_OF_MANAGEMENT'][0]}
connector.close_connection()
return json.dumps(result)
def LikeComment():
# Add the like on a certian comment
sql = SQL(server_name, server_admin)
dentist_email = request.json['dentist_email']
for_id = sql.select_query('DENTIST', ['DENTIST_ID'], f"DENTIST_EMAIL = '{dentist_email}'")
dentist_id = for_id['DENTIST_ID'][0]
comment_id = request.json['comment_id']
# First increment likes of the comment by 1
comments_result = sql.select_query('DENTIST_COMMENT', ['LIKES'], f" COMMENT_ID = {comment_id}")
num_comments = comments_result['LIKES'][0] + 1
sql.exectute_query(f"UPDATE DENTIST_COMMENT SET LIKES = {num_comments};")
# Second add the like to the relationship
sql.exectute_query(f"INSERT INTO DENTIST_LIKES(DENTIST_ID, COMMENT_ID) VALUES ({dentist_id, comment_id});")
sql.close_connection()
return '1'
def Get_Store_branches():
Store_ID = request.json['SID']
Conditon = "S.STORE_ID = '" + str(Store_ID) + "'"
connector = SQL(server_name, server_admin, server_password)
result = connector.select_query(
table='(store_branch SB JOIN STORE S ON SB.STORE_ID = S.STORE_ID)',
columns=['REGION'],
sql_condition=Conditon)
result = {'branches': result['REGION']}
connector.close_connection()
return json.dumps(result)
def LogIn():
email = request.json['email']
password = request.json['password']
sql = SQL(host=server_name, user=server_admin, password=server_password)
condition = "email = '" + email + "' and Password = '******'"
result = sql.select_query(table='LOGIN_DATA',
columns=['AccountType'],
sql_condition=condition)
sql.close_connection()
if result['AccountType'] == {}:
return 'None'
return result['AccountType'][0]
def NoProducts():
prod = request.json['product']
sql = SQL(server_name, server_admin)
result = sql.select_query("PRODUCT", ['PRODUCT_ID'])
print(result)
try:
noprod = result['PRODUCT_ID']
print(noprod)
return str(len(noprod))
except:
return '0'
def Get_All_Stores():
ManagerArea = request.json['MArea']
ManagerId = request.json['MID']
Condition = "REGION = '" + ManagerArea + "'" + "AND MANAGER_ID = '" + str(
ManagerId) + "'"
connector = SQL(server_name, server_admin, server_password)
result = connector.select_query(
table='(STORE S JOIN store_branch SB ON SB.STORE_ID = S.STORE_ID)',
columns=['S.STORE_ID', 'STORE_NAME'],
sql_condition=Condition)
result = {'SID': result['S.STORE_ID'], 'SNAME': result['STORE_NAME']}
connector.close_connection()
return json.dumps(result)
def ViewCart():
sql = SQL(server_name, server_admin)
dentist_id = request.json['DentistID']
Query = f"SELECT COUNT(*) FROM DentistCart WHERE DENTIST_ID = {dentist_id};"
result = sql.exectute_query(Query)
total_cart = result[0][0]
result = sql.select_query('DentistCart', ['PRODUCT_ID', 'Number_Units'],
f"DENTIST_ID = {dentist_id}")
Output = {}
Output['Number_Units'] = result['Number_Units']
Output['ProductID'] = []
Output['ProductName'] = []
Output['Price'] = []
Output['Category'] = []
Output['ImageURL'] = []
Output['Rate'] = []
Output['Description'] = []
Output['Brand'] = []
Output['NoOfReviews'] = []
Output['total_cart'] = int(total_cart)
for prod_id in result['PRODUCT_ID']:
Prod_Query = sql.select_query('PRODUCT', [
'PRODUCT_ID', 'PRODUCT_NAME', 'SELLING_PRICE', 'IMAGE_URL', 'RATE',
'DESCRIPTION', 'Brand', 'NO_OF_REVIEWERS', 'CATEGORY'
], f" PRODUCT_ID = {prod_id}")
Output['ProductID'].append(Prod_Query['PRODUCT_ID'][0])
Output['ProductName'].append(Prod_Query['PRODUCT_NAME'][0])
Output['Price'].append(Prod_Query['SELLING_PRICE'][0])
Output['Category'].append(Prod_Query['CATEGORY'][0])
Output['ImageURL'].append(Prod_Query['IMAGE_URL'][0])
Output['Rate'].append(Prod_Query['RATE'][0])
Output['Description'].append(Prod_Query['DESCRIPTION'][0])
Output['Brand'].append(Prod_Query['Brand'][0])
Output['NoOfReviews'].append(Prod_Query['NO_OF_REVIEWERS'][0])
sql.close_connection()
return json.dumps(Output)
def Store_DeliveryChat():
ID = request.json['ID']
connector = SQL(host=server_name, user=server_admin)
condition = " Chat ='" + ID + "'"
condition = "AREA IN (select REGION from store_branch where STORE_ID = '" + ID + "' and MANAGER_ID );"
print(condition)
Count_Region = connector.select_query(table='delivery ',
columns=['count(DELIVERY_ID)'],
sql_condition=condition)
columns = ['DELIVERY_Fname', 'DELIVERY_Lname', 'DELIVERY_ID']
result = connector.select_query(table='delivery ',
columns=columns,
sql_condition=condition)
print(result)
result = {
'DELIVERY_Fname': result['DELIVERY_Fname'],
'DELIVERY_ID': result['DELIVERY_ID'],
'DELIVERY_Lname': result['DELIVERY_Lname'],
'count(DELIVERY_ID)': Count_Region['count(DELIVERY_ID)']
}
connector.close_connection()
return json.dumps(result)
def GetManager():
DeliveryArea = request.json['area']
Condition = "AREA_OF_MANAGEMENT = '" + DeliveryArea + "'"
connector = SQL(server_name, server_admin, server_password)
result = connector.select_query(
table='Manager',
columns=['Manager_ID', 'Manager_Fname', 'Manager_Lname'],
sql_condition=Condition)
result = {
'MID': result['Manager_ID'],
'MFname': result['Manager_Fname'],
'MLname': result['Manager_Lname']
}
connector.close_connection()
return json.dumps(result)
def Store2_insertion():
columns = ['STORE_ID', 'ADDRESS', 'REGION', 'CITY', 'ZIP_CODE']
values = []
for key in columns:
values.append(request.json[key])
connector = SQL(host=server_name, user=server_admin)
StoreIDColumn = ['STORE_ID']
condition = "STORE_NAME = '" + values[0] + "'"
StoreID = connector.select_query(table='STORE',
columns=StoreIDColumn,
sql_condition=condition)
values[0] = (",".join(repr(e) for e in StoreID['STORE_ID']))
condition = "STORE_ID = '" + values[0] + "' + REGION = '" + values[0] + "'"
connector.insert_query(table='STORE_BRANCH',
attributes=columns,
values=values)
store_bransh_id = connector.select_query(table='STORE_BRANCH',
columns=['Store_branch_id'],
sql_condition=condition)
connector.insert_query(table='store_verification',
attributes=['Store_branch_id'],
values=store_bransh_id)
connector.close_connection()
return "1"
def Get_Request_Info_Store():
Store_ID = request.json['SID']
Condition = "STORE_ID = '" + str(Store_ID) + "'"
connector = SQL(server_name, server_admin, server_password)
result = connector.select_query(
table='STORE',
columns=['STORE_NAME', 'EMAIL', 'PHONE_NUMBER', 'CREDIT_CARD_NUMBER'],
sql_condition=Condition)
result = {
'Sname': result['STORE_NAME'][0],
'Email': result['EMAIL'][0],
'CCN': result['CREDIT_CARD_NUMBER'][0],
'Phone': result['PHONE_NUMBER'][0]
}
connector.close_connection()
return json.dumps(result)
def Get_Products_Count():
Store_ID = request.json['SID']
Conditon = "S.STORE_ID = '" + str(Store_ID) + "'"
connector = SQL(server_name, server_admin, server_password)
result = connector.select_query(
table='(PRODUCT P JOIN STORE S ON S.STORE_ID= P.STORE_ID)',
columns=['PRODUCT_ID'],
sql_condition=Conditon)
total_products = 0
try:
total_products = len(result['PRODUCT_ID'])
except:
pass
result = {'Products_Count': total_products}
connector.close_connection()
return json.dumps(result)
