def fetch_vendor_payment_info(vendor_id):
home_page_info = {}
records = conn.execute(vsq.vendor_query_1.format(vendor_id))
vendor_info = helpers.generate_json_results(records)[0]
vendor_name = vendor_info[constants.VENDOR_NAME]
home_page_info['vendor_name'] = str(vendor_name)
records = conn.execute(vsq.vendor_query_3.format(vendor_id))
payment_info = helpers.generate_json_results(records)[0]
type = payment_info['type']
home_page_info['type'] = str(type)
account_name = payment_info['account_name']
if account_name == "":
account_name = "NA"
home_page_info['account_name'] = str(account_name)
account_number = payment_info['account_number']
if account_number == "":
account_number = "NA"
home_page_info['account_number'] = str(account_number)
routing_number = payment_info['routing_number']
if routing_number == "":
routing_number = "NA"
home_page_info['routing_number'] = str(routing_number)
paypal_id = payment_info['paypal_id']
if paypal_id == "":
paypal_id = "NA"
home_page_info['paypal_id'] = str(paypal_id)
venmo_id = payment_info['venmo_id']
if venmo_id == "":
venmo_id = "NA"
home_page_info['venmo_id'] = str(venmo_id)
return home_page_info
def fetch_admin_home_info(admin_id):
records = conn.execute(sq.admin_query_1.format(admin_id))
home_page_info = {}
products = helpers.generate_json_results(records)
home_page_info['products'] = products
records = conn.execute(sq.admin_query_19.format(admin_id))
ordered_products = helpers.generate_json_results(records)
home_page_info['ordered_products'] = ordered_products
records = conn.execute(sq.admin_query_2.format(admin_id))
admin_info = helpers.generate_json_results(records)[0]
admin_name = admin_info[constants.ADMIN_NAME]
records = conn.execute(sq.admin_query_3.format(id=admin_id))
budget_info = helpers.generate_json_results(records)[0]
home_page_info['total_budget'] = float(budget_info[constants.BUDGET])
if budget_info['remaining_balance']:
home_page_info['remaining_budget'] = float(
budget_info['remaining_balance'])
else:
home_page_info['remaining_budget'] = float(
budget_info[constants.BUDGET])
home_page_info['admin_name'] = str(admin_name)
return home_page_info
def fetch_vendor_home_info(vendor_id):
home_page_info = {}
records = conn.execute(vsq.vendor_query_2.format(vendor_id))
products = helpers.generate_json_results(records)
home_page_info['products'] = products
records = conn.execute(vsq.vendor_query_1.format(vendor_id))
vendor_info = helpers.generate_json_results(records)[0]
vendor_name = vendor_info[constants.VENDOR_NAME]
home_page_info['vendor_name'] = str(vendor_name)
return home_page_info
def fetch_vendor_invoice_info(vendor_id, invoice_id):
records = conn.execute(vsq.vendor_query_8.format(vendor_id, invoice_id))
invoice = helpers.generate_json_results(records)[0]
invoice['date_placed'] = invoice['date_placed'].strftime("%m/%d/%Y %H:%M:%S")
records = conn.execute(vsq.vendor_query_9.format(invoice['admin_id']))
warehouse_info = helpers.generate_json_results(records)[0]
records = conn.execute(vsq.vendor_query_10.format(vendor_id))
vendor_info = helpers.generate_json_results(records)[0]
return {'order_info': invoice, 'warehouse_info': warehouse_info, 'vendor_info': vendor_info}
def fetch_admin_budget_info(admin_id):
info = {}
records = conn.execute(sq.admin_query_2.format(admin_id))
admin_info = helpers.generate_json_results(records)[0]
admin_name = admin_info[constants.ADMIN_NAME]
records = conn.execute(sq.admin_query_3.format(id=admin_id))
budget_info = helpers.generate_json_results(records)[0]
info['total_budget'] = float(budget_info[constants.BUDGET])
if budget_info['remaining_balance']:
info['remaining_budget'] = float(budget_info['remaining_balance'])
info['admin_name'] = str(admin_name)
else:
info['remaining_budget'] = float(budget_info[constants.BUDGET])
info['admin_name'] = str(admin_name)
return info
def fetch_brand_info(category):
records = conn.execute(sq.admin_query_11.format(category))
brands = helpers.generate_json_results(records)
brand_info = []
for brand in brands:
info = {"id": brand['brand'], "name": brand['brand']}
brand_info.append(info)
return brand_info
def fetch_product_drop_down_info(category, brand):
records = conn.execute(sq.admin_query_12.format(category, brand))
products = helpers.generate_json_results(records)
product_list = []
for product in products:
info = {"id": product['product_name'], "name": product['product_name']}
product_list.append(info)
return product_list
def fetch_category_drop_down_info():
records = conn.execute(sq.admin_query_17)
categories = helpers.generate_json_results(records)
category_list = []
for category in categories:
info = {"id": category['category'], "name": category['category']}
category_list.append(info)
return category_list
def fetch_vendor_drop_down_info(category, brand, product_name):
records = conn.execute(
sq.admin_query_13.format(category, brand, product_name))
vendors = helpers.generate_json_results(records)
vendor_list = []
for vendor in vendors:
val = vendor['vendor_name'] + " | Qt:" + str(
vendor['quantity']) + " | Price:" + str(vendor['price'])
info = {
"id":
val + "|" + vendor['product_id'] + "|" +
vendor['vendor_product_id'] + "|" + vendor['vendor_id'],
"name":
val
}
vendor_list.append(info)
return vendor_list
def fetch_vendor_info(vendor_id):
home_page_info = {}
records = conn.execute(vsq.vendor_query_1.format(vendor_id))
vendor_info = helpers.generate_json_results(records)[0]
vendor_name = vendor_info[constants.VENDOR_NAME]
home_page_info['vendor_name'] = str(vendor_name)
vendor_id = vendor_info[constants.VENDOR_ID]
home_page_info['vendor_id'] = str(vendor_id)
mobile = vendor_info[constants.MOBILE]
home_page_info['mobile'] = str(mobile)
email = vendor_info[constants.EMAIL]
home_page_info['email'] = str(email)
address_id = vendor_info[constants.ADDRESS_ID]
home_page_info['address_id'] = str(address_id)
street = vendor_info['vendor_street']
home_page_info['street'] = str(street)
city = vendor_info['vendor_city']
home_page_info['city'] = str(city)
state = vendor_info['vendor_state']
home_page_info['state'] = str(state)
zip = vendor_info['vendor_zipcode']
home_page_info['zip'] = str(zip)
return home_page_info
def generate_order(admin_id, product_id, vendor_product_id, vendor_id,
quantity, total_amount):
""" Update vendor product info(quantity) after order is placed.
:return:
"""
invoice_id = uuid.uuid4().hex
records = conn.execute(sq.admin_query_14.format(admin_id))
warehouse_id = helpers.generate_json_results(records)[0]['warehouse_id']
payment_status = "in progress"
current_time = datetime.datetime.now()
date_placed = current_time.strftime("%Y-%m-%d %H:%M:%S")
conn.execute(
sq.admin_query_15.format(invoice_id=invoice_id,
admin_id=admin_id,
vendor_id=vendor_id,
warehouse_id=warehouse_id,
product_id=product_id,
payment_status=payment_status,
price=total_amount,
quantity=quantity,
date_placed=date_placed))
conn.execute(sq.admin_query_16.format(quantity, vendor_product_id))
return invoice_id
def fetch_vendor_order_history(vendor_id):
records = conn.execute(vsq.vendor_query_6.format(vendor_id))
order_history = helpers.generate_json_results(records)
return order_history
def get_product_id(name, category, brand):
records =conn.execute(vsq.vendor_query_11.format(category=category, product_name=name, brand=brand))
product_info = helpers.generate_json_results(records)[0]
product_id = product_info['product_id']
return product_id
def fetch_order_history(admin_id):
records = conn.execute(sq.admin_query_6.format(admin_id))
order_history = helpers.generate_json_results(records)
return order_history
def fetch_admin_info(admin_id):
records = conn.execute(sq.admin_query_5.format(admin_id))
admin_info = helpers.generate_json_results(records)[0]
admin_info['dob'] = admin_info['dob'].strftime("%m/%d/%Y")
return admin_info
def fetch_product_info(product_id):
records = conn.execute(sq.admin_query_7.format(product_id))
product_info = helpers.generate_json_results(records)
return product_info[0]
def fetch_order_home_info():
records = conn.execute(sq.admin_query_4)
products = {'products': helpers.generate_json_results(records)}
return products
