def incEmpLogin():
if request.method == "POST":
loginInfo = request.get_json(silent=True)
response = False
try:
obj = DBFns(app.config['DATABASE_HOST'],
app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'],
app.config['DATABASE_DB'])
empID = obj.getEmpId(loginInfo['username'])
if empID:
if obj.emploginVerify(loginInfo['username'],
loginInfo['password']):
session["loggedInEmpId"] = empID
print('logged in id: ', empID)
print('logged in Session id: ', empID)
response = True
except Exception as e:
print(str(e))
response = False
finally:
if response:
return jsonify(empID)
else:
return 'INVALID'
else:
return redirect(url_for("sellLoginSignup"))
def incEmpSignup():
if request.method == "POST":
signupInfo = request.get_json(silent=True)
response = False
try:
obj = DBFns(app.config['DATABASE_HOST'],
app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'],
app.config['DATABASE_DB'])
if obj.isUnameRegistered(signupInfo['username']):
empId = obj.getEmpId(signupInfo['username'])
print(empId)
print(type(empId))
if empId:
if obj.signupEmployee(empId, signupInfo['username'],
signupInfo['password']):
response = True
except Exception as e:
print(str(e))
response = False
if response:
return jsonify(empId)
else:
return 'INVALID'
else:
return redirect(url_for("sellLoginSignup"))
def incAvailableCustomer():
if "loggedInEmpId" in session:
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
myavailableCustomers = obj.getAllCustomers()
# print(myavailableInventory)
return jsonify(myavailableCustomers)
else:
return redirect(url_for("sellLoginSignup"))
def viewReceipt(ordid):
if "adminLoggedIn" not in session:
return redirect(url_for('adminlogin'))
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
data = obj.getTheReceipt(ordid)
if data:
return render_template('finalReceipt.html', data=data)
return render_template('finalReceipt.html', message='NO Order Exists')
def incGetproduct():
if request.method != "POST":
return redirect(url_for("adminlogin"))
data = request.get_json(silent=True)
print((data['prod_id'])[5:])
data['prod_id'] = (data['prod_id'])[5:]
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
reqProd = obj.getProduct(data['prod_id'])
return jsonify(reqProd)
def incRecentReceipts():
empid = session["loggedInEmpId"]
response = 'ERROR'
try:
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
response = obj.getLastReceiptsEmp(empid)
response = jsonify(response)
except Exception as e:
print(str(e))
return response
def adminloginverify():
if request.method == "POST":
data = request.get_json(silent=True)
# obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'], app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
if obj.adminLogin(data['username'], data['password']):
session['adminLoggedIn'] = True
return 'VALID'
else:
return 'INVALID'
else:
return redirect(url_for("adminlogin"))
def printReceipt(ordid):
if "loggedInEmpId" in session:
empid = session["loggedInEmpId"] # from session of employee
print(empid)
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
if obj.isReceiptallowedEmp(ordid, empid):
data = obj.getTheReceipt(ordid)
if data:
return render_template('finalReceipt.html', data=data)
return render_template('finalReceipt.html',
message='Only Admin can View that Receipt')
else:
return redirect(url_for("sellLoginSignup"))
def incGetDelproduct():
if request.method != "POST":
return redirect(url_for("adminlogin"))
data = request.get_json(silent=True)
print((data['prod_id'])[5:])
data['prod_id'] = (data['prod_id'])[5:]
reqProd = []
try:
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
reqProd = obj.getProduct(data['prod_id'])
except Exception as e:
print(str(e))
return 'Database Error!'
finally:
return jsonify(reqProd)
def incDeleteproduct():
if request.method != "POST":
return redirect(url_for("adminlogin"))
response = request.get_json(silent=True)
message = 'Database/Server Error!'
try:
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
# response['id'] = (response['id'])[5:]
print('incDeleteproduct', response)
if obj.deleteProduct(response['id']):
message = 'true'
except Exception as e:
print(str(e))
message = 'Database Error!'
finally:
return message
def incUpdateproduct():
if request.method != "POST":
return redirect(url_for("adminlogin"))
response = request.get_json(silent=True)
message = 'Database/Server Error!'
try:
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
if obj.updateProduct(response['title'], response['sku'],
response['cost'], response['price'],
response['stock'], response['low'],
response['id']):
message = 'true'
except Exception as e:
print(str(e))
message = 'Database Error!'
finally:
return message
def incAddproduct():
if request.method != "POST":
return redirect(url_for("adminlogin"))
response = request.get_json(silent=True)
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
message = 'Database/Server Error!'
try:
if obj.isSkuExists(response['sku']) != True:
if obj.addProduct(response['title'], response['sku'],
response['cost'], response['price'],
response['stock'], response['low']):
message = 'true'
elif obj.isSkuExists(response['sku']) == True:
message = 'SKU Already Exist!'
except Exception as e:
print(str(e))
message = 'Database/Server Error!'
finally:
return message
def incSavereceiptdata():
if request.method == "POST":
data = request.get_json(silent=True)
cust_id = data['cust_id']
emp_id = session["loggedInEmpId"] # From session Session
total_prod = len(data['orderProducts'])
discount = data['discount']
total_rcpt_price = data['total']
pay_status = data['status']
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
print(cust_id)
if obj.saveReceipt(cust_id, emp_id, total_prod, discount,
total_rcpt_price, pay_status):
rcpId = obj.getlastReceiptIdEmp(emp_id)
for prod in data['orderProducts']:
obj.addProdToReceipt(rcpId, prod['current_prod_id'],
prod['prod_title'], prod['prod_price'],
prod['prod_qty'], prod['prod_priceXqty'])
return jsonify(rcpId)
return 'INVALID'
else:
return redirect(url_for("sellLoginSignup"))
def productsSold():
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
productsSold = obj.getProductsSold()
print('type of : ', type(productsSold))
return jsonify(productsSold)
def ProductsSoldYest():
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
yestProductsSold = obj.getYestProductsSold()
return jsonify(yestProductsSold)
def ProductsSoldToday():
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
todayProductsSold = obj.getTodayProductsSold()
return jsonify(todayProductsSold)
def ProductsSoldMonth():
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
monthProductsSold = obj.getMonthProductsSold()
return jsonify(monthProductsSold)
def incInventory():
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
myinventory = obj.getAllProducts()
return jsonify(myinventory)
def incEmployees():
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
allEmployees = obj.getAllEmployees()
return jsonify(allEmployees)
def incCustomers():
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
allCustomers = obj.getAllCustomers()
return jsonify(allCustomers)
def incReceipts():
obj = DBFns(app.config['DATABASE_HOST'], app.config['DATABASE_USER'],
app.config['DATABASE_PASSWORD'], app.config['DATABASE_DB'])
allReceipts = obj.getAllReceipts()
return jsonify(allReceipts)