def sellerHome():
if 'email' in session:
user = session['email']
firstname = session['firstname']
db = Workbench('minProj', password=mysql_pwd)
uid = session['userID']
productdetails = db.select_from('supplierdet',
where_clause={'supplierID': uid})
productlist = [
db.select_from('products', where_clause={'prodID': x['prodID']})[0]
for x in productdetails
]
# print(productlist[0])
else:
return redirect(url_for('index'))
return render_template('sellerHome.html',
user=user,
firstname=firstname,
productdetails=productdetails,
productlist=productlist,
login_status=True)
def home(page=1):
if 'email' in session:
perPage = 20
startAt = perPage * page - perPage
user = session['email']
firstname = session['firstname']
db = Workbench('minProj', password=mysql_pwd)
if request.method == 'POST' and request.form:
payload = request.form
# print(payload)
query = 'SELECT * FROM products'
filters = []
if (len(payload) >= 1
and 'price' not in payload) or len(payload) > 1:
categoryIDs = []
for k, v in payload.items():
if k != 'price':
categoryIDs.append(v)
print(categoryIDs)
cat = ['categoryID = ' + x for x in categoryIDs]
cat = '(' + ' OR '.join(cat) + ')'
filters.append(cat)
if ('price' in payload):
priceconstraint = '(minPrice'
if payload['price'] == '1':
priceconstraint += '< 1000)'
elif payload['price'] == '2':
priceconstraint += '>= 1000 AND minPrice<= 5000)'
elif payload['price'] == '3':
priceconstraint += '>= 5000 AND minPrice<= 10000)'
elif payload['price'] == '4':
priceconstraint += '>= 10000 AND minPrice<= 20000)'
else:
priceconstraint += '> 20000)'
filters.append(priceconstraint)
filters = ' AND '.join(filters)
filters += ';'
query = ' WHERE '.join([query, filters])
print(query)
products = db.select_from_custom(query)
filter = True
return render_template('home.html',
user=user,
firstname=firstname,
products=products,
page=page,
filter=filter,
login_status=True)
else:
products = db.select_from('products')
global allproducts
allproducts = products
totalPages = len(products) // 20 + 1
# print(totalPages)
products = products[startAt:startAt + perPage]
filter = False
return render_template('home.html',
user=user,
firstname=firstname,
products=products,
page=page,
totalPages=totalPages,
filter=filter,
login_status=True)
else:
return redirect(url_for('index'))
def sellerProfile():
if 'email' in session:
login_status = True
db = Workbench(database='minProj', password=mysql_pwd)
print(session)
session['paymentdetailID'] = db.select_from(
"suppliers",
attributes=['paymentID'],
where_clause={'supplierID': session['userID']})[0]['paymentID']
if request.method == 'POST':
payload = request.form
card = ['cardName', 'bankName', 'cardNum', 'cvv', 'expDate']
payloads = dict([
x for x in payload.items()
if x[0] not in card and x[0] != 'upiID'
])
cardinfo = dict(
[x for x in payload.items() if x[0] in card and x[1] != ''])
upiinfo = dict(
[x for x in payload.items() if x[0] == 'upiID' and x[1] != ''])
def dataenter():
if session['paymentdetailID'] is None:
payinfo = dict()
payinfo['paymentdetailID'] = 'Pay-' + str(
randint(1, 9999999) + randint(1, 999999))
if bool(cardinfo) != False:
cardinfo['carddetailID'] = 'Ca-' + str(
randint(1, 9999999) + randint(1, 999999))
payinfo['carddetailID'] = cardinfo['carddetailID']
try:
db.insert_into("carddet", values=cardinfo)
except Error as e:
print(e)
return 'carddet.CardNum'
if bool(upiinfo) != False:
upiinfo['upidetailID'] = 'U-' + str(
randint(1, 9999999) + randint(1, 999999))
payinfo['upidetailID'] = upiinfo['upidetailID']
try:
db.insert_into("upidet", values=upiinfo)
except Error as e:
print(e)
return 'upidet.upiID'
if 'upidetailID' in payinfo or 'carddetailID' in payinfo:
session['paymentdetailID'] = payinfo['paymentdetailID']
payloads['paymentID'] = payinfo['paymentdetailID']
db.insert_into("paymentdet", values=payinfo)
else:
print(session)
payinfo = db.select_from("paymentdet",
where_clause={
'paymentdetailID':
session['paymentdetailID']
})
print(payinfo)
if payinfo[0]['carddetailID'] != None:
if bool(cardinfo) != False:
try:
db.update_table("carddet",
updates=cardinfo,
where_clause={
'carddetailID':
payinfo[0]['carddetailID']
})
except Error as e:
print(e)
return 'carddet.CardNum'
else:
db.delete_from("carddet",
where_clause={
'carddetailID':
payinfo[0]['carddetailID']
})
elif bool(cardinfo) != False:
cardinfo['carddetailID'] = 'Ca-' + str(
randint(1, 9999999) + randint(1, 999999))
payinfo[0]['carddetailID'] = cardinfo['carddetailID']
try:
db.insert_into("carddet", values=cardinfo)
except Error as e:
print(e)
return 'carddet.CardNum'
try:
db.update_table("paymentdet",
updates=payinfo[0],
where_clause={
'paymentdetailID':
session['paymentdetailID']
})
except Error as e:
print(e)
return
if payinfo[0]['upidetailID'] != None:
if bool(upiinfo) != False:
try:
db.update_table("upidet",
updates=upiinfo,
where_clause={
'upidetailID':
payinfo[0]['upidetailID']
})
except Error as e:
print(e)
return 'upidet.upiID'
else:
try:
db.delete_from("upidet",
where_clause={
'upidetailID':
payinfo[0]['upidetailID']
})
except Error as e:
print(e)
return
elif bool(upiinfo) != False:
upiinfo['upidetailID'] = 'U-' + str(
randint(1, 9999999) + randint(1, 999999))
payinfo[0]['upidetailID'] = upiinfo['upidetailID']
try:
db.insert_into("upidet", values=upiinfo)
except Error as e:
print(e)
return 'upidet.upiID'
try:
db.update_table("paymentdet",
updates=payinfo[0],
where_clause={
'paymentdetailID':
session['paymentdetailID']
})
except Error as e:
print(e)
return
login_status = dataenter()
try:
db.update_table("suppliers",
updates=payloads,
where_clause={'supplierID': session['userID']})
except Error as e:
if 'suppliers.pno_UNIQUE' in str(e):
print(e)
login_status = 'suppliers.pno_UNIQUE'
if 'suppliers.email_UNIQUE' in str(e):
print(e)
login_status = 'suppliers.email_UNIQUE'
else:
print(e)
userinfo = db.select_from(
"suppliers", where_clause={'supplierID': session['userID']})
result = None
print(session)
if session['paymentdetailID'] is not None:
paymentdet = db.select_from(
"paymentdet",
where_clause={'paymentdetailID':
session['paymentdetailID']})[0]
if paymentdet['carddetailID'] is not None:
result = db.select_from(
"carddet",
where_clause={'carddetailID':
paymentdet['carddetailID']})[0]
if paymentdet['upidetailID'] is not None:
if result is not None:
print(result)
print(paymentdet)
result.update(
db.select_from("upidet",
where_clause={
'upidetailID':
paymentdet['upidetailID']
})[0])
else:
result = db.select_from("upidet",
where_clause={
'upidetailID':
paymentdet['upidetailID']
})[0]
else:
return redirect(url_for('index'))
return render_template('sellerprofile.html',
user=userinfo,
firstname=userinfo[0]['firstname'],
payinfo=result,
login_status=login_status)
def index():
login_status = None
if request.method == 'POST':
payload = request.form
print(payload)
payload = payload.copy()
if payload['user'] == 'customer':
tableName = "customers"
idName = 'custID'
idPrefix = 'C-'
if 'orgname' in payload:
payload.pop('orgname')
else:
tableName = 'suppliers'
idName = 'supplierID'
idPrefix = 'S-'
payload.pop('user')
dB = Workbench(database='minProj', password=mysql_pwd)
if 'login' in payload:
whereClause = dict(
[x for x in payload.items() if 'login' not in x])
# print(userDat)
userData = dB.select_from(tableName, where_clause=whereClause)
# print(userData)
if userData:
login_status = True
if payload['email'] not in session:
session['email'] = payload['email']
session['firstname'] = userData[0]['firstname']
session['userID'] = userData[0][idName]
if idPrefix == 'C-':
return redirect(url_for('home'))
else:
return redirect(url_for('sellerHome'))
else:
login_status = False
return render_template("index.html", login_status=login_status)
else:
print(payload)
values = dict([x for x in payload.items() if 'signup' not in x])
# print(values)
values[idName] = idPrefix + str(
randint(1, 9999999) + randint(1, 999999))
values['joinDate'] = str(date.today())
try:
dB.insert_into(tableName, values)
if payload['email'] not in session:
session['email'] = payload['email']
session['firstname'] = payload['firstName']
session['userID'] = payload[idName]
if idPrefix == 'C-':
return redirect(url_for('home'))
else:
return redirect(url_for('sellerHome'))
else:
return redirect(url_for('home'))
except Error as e:
if 'Duplicate entry' in str(e):
print(e)
login_status = 'Already Exists'
return render_template('index.html',
login_status=login_status)
else:
return render_template("index.html")
