def addProductBySaler(): name = request.form['name'] print(name) desc = request.form['description'] print(desc) price = request.form['price'] print(price) cate = request.form['cate'] print(cate) subcate = request.form['subcate'] print(subcate) stock = request.form["stock"] target = os.path.join(APP_ROOT, r'\Users\hp\PycharmProjects\shop\static\images') print(target) file = None for file in request.files.getlist("image"): filename = file.filename print("here21212") destination = "/".join([target, filename]) print("Accept incoming file:", filename) print(destination) file.save(destination) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) db.addproductBySaler(name, session["username"], session["email"], desc, price, cate, subcate, file.filename, stock) return render_template("SellerDashboard.html", status=True)
def addProductByAdmin(): print("ADMIN") name = request.form['name'] print(name) desc = request.form['description'] print(desc) price = request.form['price'] print(price) cate = request.form['cate'] print(cate) subcate = request.form['subcate'] print(subcate) stock = request.form["stock"] target = os.path.join(APP_ROOT, r'\Users\hp\PycharmProjects\shop\static\images') print(target) file = None for file in request.files.getlist("image"): filename = file.filename print("here21212") destination = "/".join([target, filename]) print("Accept incoming file:", filename) print(destination) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) obj = db.ShowProducts() print("AfterShow") if db.addproduct(name, desc, price, cate, subcate, file.filename, stock): print("innerIf") file.save(destination) return render_template("addProductByAdmin.html", status=True) else: return render_template("addProductByAdmin.html", status=False)
def productDetails(): db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.getproductbyid(session["pid"]) review = db.getreview(session["pid"]) print(dd) return render_template("product-detail.html", product=dd, review=review)
def review(): print("inside review") rev = request.form['message'] db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.setreview(session["pid"], session["email"], rev) if dd: db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.getproductbyid(session["pid"]) review = db.getreview(session["pid"]) print(dd) return render_template("product-detail.html", product=dd, review=review) else: return "garbar"
def checkout(): if session.get("email") != None: db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) cartlist = db.getCartforCheckout(session.get("email")) return render_template("checkout.html", summaryList=cartlist) else: return render_template("index.html")
def totalcart(): db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.totalFromCart(session["email"]) if dd is not None: return jsonify(dd) else: va = [{"check": "true"}] return jsonify(va)
def adminMain(): if session.get("admin-email") is not None: db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) obj = db.ShowProducts() return render_template("table.html", listOfProducts=obj, adminName=session.get("admin-username")) else: return render_template("adminLogin.html")
def wishlist(): if session.get("email") != None: obj = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) print(session["email"]) wishdic = obj.getWishlist(session["email"]) print(wishdic) return render_template("wishlist.html", wishList=wishdic) else: return render_template("index.html")
def sellerApproved(): if session.get("email") is not None: db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) obj = db.Approved3partyProducts(session["email"]) return render_template("SellerApproved.html", listOfProducts=obj, adminName=session.get("admin-username")) else: return render_template("adminLogin.html")
def cart(): if session.get("email") != None: obj = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) print(session["email"]) cartdic = obj.getCart(session["email"]) print(cartdic) return render_template("cart.html", cartList=cartdic) else: return render_template("index.html")
def orderdetail(): db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.orderitem(session["oid"]) adres = db.orderadress(session["oid"]) status = db.orderstatus(session["oid"]) print(dd) return render_template("orderdetail.html", orderitem=dd, orderadres=adres, oid=session["oid"], status=status)
def feedback(): name = request.form['name'] email = request.form['email'] subject = request.form['subject'] message = request.form['message'] db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.feedback(name, email, subject, message) if dd: return render_template("contact.html") else: return "Not added Feedback"
def reenterpass(): email = request.form['email'] passw = request.form['pass'] cpass = request.form['cpass'] if passw == cpass: obj = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) result = obj.changepass(email, passw) if result: return render_template("account.html", change=True) else: return render_template("reenterpass.html", change=False)
def deleteFromCart(): key1 = str(request.data) print(key1) key1 = key1.split("'") score = int(key1[1]) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.delproductbyIdFromCart(score) if dd: va = [{"check": "true"}] return jsonify(va) else: va = [{"check": "false"}] return jsonify(va)
def hello_world(): # session.clear() # session.pop("admin-email", None) # session.pop("admin-username", None) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) men = db.CATAGERY('Men') db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) women = db.CATAGERY('Women') db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) sports = db.CATAGERY('Sports') db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) kids = db.CATAGERY('Kids') cartlist = db.getCarthower(session.get("email")) return render_template("index.html", product=men, wproduct=women, kproduct=kids, sproduct=sports, cartList=cartlist)
def addToCart(): key1 = str(request.data) print(key1) key1 = key1.split("'") pid = int(key1[1]) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.addToCart(session["email"], pid) if dd: va = [{"check": "true"}] return jsonify(va) else: va = [{"check": "false"}] return jsonify(va)
def register(): email = request.form["email"] username = request.form["uname"] password = request.form["pass"] role = request.form["rad"] web_projectobj = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) if web_projectobj.register_user(username, email, password, role): return render_template("index.html", status=True) else: return render_template("account.html", status="This user email Already Exists")
def deliveered(): key1 = str(request.data) print(key1) key1 = key1.split("'") oid = int(key1[1]) print("In Place order before calling db handler") print(oid) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.updateStatus(oid) if dd: va = [{"check": "true"}] return jsonify(va) else: va = [{"check": "false"}] return None
def Oadress(): key1 = str(request.data) print(key1) key1 = key1.split("'") oid = int(key1[1]) print("In Place order before calling db handler") print(oid) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.getAddress(oid) if dd: return jsonify(dd) else: va = [{"check": "false"}] return jsonify(va)
def admin(): print("admin Portal") email = request.form["email"] password = request.form["pass"] db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dict = db.validateAdmin(email, password) if dict: obj = db.ShowProducts() session["admin-email"] = email session["admin-username"] = dict["username"] print() return render_template("table.html", listOfProducts=obj, adminName=dict["username"]) else: return render_template("adminLogin.html", error=True)
def pssrcvry(): email = request.form['email'] obj = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) isuser = obj.isexist(email) if isuser: email = str(email) print(email) msg = "This is 6 digit code:" + str(otp) message = Message("OTP", sender='*****@*****.**', recipients=[email]) message.body = msg mail.send(message) return render_template("pasrecvry.html", status=True) else: return render_template("pasrecvry.html", warning=True)
def upateStock(): key1 = str(request.data) key1 = key1.split("'") score = key1[1] score = score.split(",") name = int(score[0]) print(name) score = int(score[1]) print(score) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.updateInventory(name, score) if dd: va = [{"check": "true"}] return jsonify(va) else: va = [{"check": "false"}] return jsonify(va)
def anouncement(): subject = request.form['sub'] msg = request.form['message'] obj = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) email = obj.getusers() print(email) for i in email: message = Message(subject, sender='*****@*****.**', recipients=[i]) message.body = msg mail.send(message) return render_template("anounce.html", status=True)
def placeOrder(): key1 = str(request.data) key1 = key1.split("'") score = key1[1] score = score.split(",") total = int(score[0]) cell = int(score[1]) address = score[2] print("In Place order before calling db handler") print(total) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.placeOrder(session.get("email"), total, cell, address) if dd: id = db.getOID() dd = db.orderitem(id) item = "" j = 1 for i in dd: j = str(j) item = item + j + " Product Title: " + i[ "name"] + " Quantity: " + str( i["quantity"]) + " Product Price " + str( i["price"]) + "\n" j = int(j) j = j + 1 adress = "On Following Address\n" + " address " + address + " cell no. " + str( cell) detail = "Your order id " + str(id) + "\n" + item + adress message = Message("Order", sender='*****@*****.**', recipients=[session["email"]]) message.body = detail mail.send(message) va = [{"check": "true"}] return jsonify(va) else: va = [{"check": "false"}] return jsonify(va)
def upateCart(): key1 = str(request.data) key1 = key1.split("'") score = key1[1] score = score.split(",") id = int(score[0]) print(id) price = int(score[1]) print(price) quan = int(score[2]) print(quan) db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.updateCart(id, price, quan) if dd: va = [{"check": "true"}] return jsonify(va) else: va = [{"check": "false"}] return jsonify(va)
def login(): print("login") email = request.form["email"] passw = request.form["pass"] print("login1") obj = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) user_dic = obj.login(email, passw) print("login 2") print(user_dic) if user_dic: session["email"] = email session["username"] = user_dic["username"] if user_dic["role"] == "BuyerAccount": return redirect('/') else: return render_template("SellerDashboard.html", email=email, password=passw, role=user_dic["role"], username=user_dic["username"]) else: return render_template("account.html")
def showfeedback(): db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.getfeedback() return render_template("feedback.html", feedbackList=dd)
def showdigital(): db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.CATAGERY('Digital') return render_template("product.html", product=dd)
def sellerpendingRequest(): db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.sellershowpending(session["email"]) return render_template("SellerPending.html", listOfProducts=dd)
def showorder(): db = web_project(app.config["DATABASEIP"], app.config["DB_USER"], app.config["DB_PASSWORD"], app.config["DATABASE"]) dd = db.showOrder() df = db.detail return render_template("showOrder.html", listOfProducts=dd)