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)