def invoice(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") dbQuery().changeRefundPolicy() if request.method == "GET": allInv = dbQuery().getInvoices("all") return render_template("invoice.html", username=g.user, role=g.role, date=date, time=time, invoice=allInv) if request.method == "POST": parameter = request.form.get("search") allInv = dbQuery().getInvoices(parameter) return render_template("invoice.html", username=g.user, role=g.role, date=date, time=time, invoice=allInv) else: return redirect(url_for('unauthenticated'))
def inventory(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") dbQuery().checkQtStat() if request.method == "POST": specificProduct = dbQuery().getSpeProducts( request.form.get('search')) return render_template("inventory.html", username=g.user, role=g.role, date=date, time=time, products=specificProduct) allProduct = dbQuery().getProducts() return render_template("inventory.html", username=g.user, role=g.role, date=date, time=time, products=allProduct) else: return redirect(url_for('unauthenticated'))
def orderlist(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") if request.method == "GET": currentOrders = dbQuery().getCurrentOrders('all') return render_template("orderlist.html", username=g.user, role=g.role, date=date, time=time, orders=currentOrders) if request.method == "POST": param = request.form.get('sort') currentOrders = dbQuery().getCurrentOrders(param) return render_template("orderlist.html", username=g.user, role=g.role, date=date, time=time, orders=currentOrders) else: return redirect(url_for('unauthenticated'))
def recharge(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") carrier = dbQuery().getCarrier() if request.method == "GET": return render_template("recharge.html", username=g.user, role=g.role, date=date, time=time, carrier=carrier) if request.method == "POST": status = dbQuery().addRecharge(request.form) if status == "success": flash("New Reccord Added", "success") else: flash("Something Went Wrong", "error") return render_template("recharge.html", username=g.user, role=g.role, date=date, time=time, carrier=carrier) else: return redirect(url_for('unauthenticated'))
def alldues(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") if request.method == "GET": dues = dbQuery().getAllDues("all") return render_template("due.html", username=g.user, role=g.role, date=date, time=time, dues=dues) if request.method == "POST": values = request.form.get("search") dues = dbQuery().getAllDues(values) return render_template("due.html", username=g.user, role=g.role, date=date, time=time, dues=dues) else: return redirect(url_for('unauthenticated'))
def modify(product): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") product2modify = dbQuery().getThisproduct(product) types = dbQuery().getVarType() allCategory = dbQuery().getAllCatg() allSeller = dbQuery().getAllvendor() form = productImage() if request.method == "POST": if request.files['image'].filename != "": res = validateProduct(request.form, request.files).imageValidate() if res == "success": # upload image first extinsion = request.files['image'].filename.rsplit('.') originalFilename = extinsion[0] extinsion = extinsion[1].lower() rootPath = os.path.join(app.root_path, 'static', 'uploads') newname = str(uuid.uuid4().hex) + '.' + str(extinsion) destination = "/".join([rootPath, newname]) try: request.files['image'].save(destination) except Exception as e: flash("Unable To Upload Product Image. Contact Admin", "error") else: updateProduct = updateDb().updateProduct( request.form, product, newname) if updateProduct == "success": flash("Product Updated Successfully", "success") else: flash("Unable To Update Product. Contact Admin!", "error") elif res == "error1": flash("dowble ext", "error") elif res == "error2": flash("other file", "error") else: updateProduct = updateDb().updateProduct( request.form, product, product2modify[0]['image']) if updateProduct == "success": flash("Product Updated Successfully", "success") else: flash("Unable To Update Product. Contact Admin!", "error") return render_template("modify.html", form=form, username=g.user, role=g.role, date=date, time=time, pid=product, details=product2modify[0], vartype=types, catg=allCategory, seller=allSeller) else: return redirect(url_for('unauthenticated'))
def orders(cust): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") if request.method == "GET": orders = dbQuery().getSellOrder(cust) customer = dbQuery().getCustomerDetails(cust) customer = customer.split(":")[0] return render_template("custorder.html", username=g.user, role=g.role, date=date, time=time, orders=orders, cname=customer) elif request.method == "POST": param = request.form.get("search") orders = dbQuery().getCertOrder(param) customer = dbQuery().getCustomerDetails(cust) customer = customer.split(":")[0] return render_template("custorder.html", username=g.user, role=g.role, date=date, time=time, orders=orders, cname=customer) else: return redirect(url_for('unauthenticated'))
def addmasterdata(): if g.user: form = productImage() types = dbQuery().getVarType() allCategory = dbQuery().getAllCatg() allSeller = dbQuery().getAllvendor() if request.method == "POST": res = validateProduct(request.form, request.files) validate = res.startValidation() balance = dbQuery().checkBalance( int(request.form.get("cost")) * int(request.form.get("quantity"))) if validate == "error1": flash("Don't Do That", "error") elif validate == "error2": flash("You Can Not Upload This File", "error") elif validate == "error3": flash( "This Product Already In Inventory Place Order From Order Page", "error") elif balance != "available": flash("You Dont Have Sufficient Balance To Add This Product", "error") else: # upload image first extinsion = request.files['image'].filename.rsplit('.') extinsion = extinsion[1].lower() rootPath = os.path.join(app.root_path, 'static', 'productimage') newname = str(uuid.uuid4().hex) + '.' + str(extinsion) destination = "/".join([rootPath, newname]) try: request.files['image'].save(destination) except Exception as e: print(e) flash("Unable To Upload Product Image. Contact Admin", "error") else: # update database with new product res = updateDb().addProduct(request.form, newname) if res == "success": return redirect(url_for("inventory")) else: flash("Can Not Update Database. Contact Admin", "error") date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") return render_template("add.html", username=g.user, role=g.role, date=date, time=time, form=form, vartype=types, catg=allCategory, seller=allSeller) else: return redirect(url_for('unauthenticated'))
def custmanager(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") if request.method == "GET": allCust = dbQuery().getAllCust("all") return render_template("customermanager.html", username=g.user, role=g.role, date=date, time=time, cust=allCust) elif request.method == "POST": param = request.form.get("search") allCust = dbQuery().getAllCust(param) return render_template("customermanager.html", username=g.user, role=g.role, date=date, time=time, cust=allCust) else: return redirect(url_for('unauthenticated'))
def transactions(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") if request.method == "GET": trans = dbQuery().getTransaction("all") return render_template("transaction.html", username=g.user, role=g.role, date=date, time=time, trans=trans) if request.method == "POST": param = request.form.get('sort') trans = dbQuery().getTransaction(param) return render_template("transaction.html", username=g.user, role=g.role, date=date, time=time, trans=trans) else: return redirect(url_for('unauthenticated'))
def deleteCategory(): if g.user: if request.method == "POST": details = request.form.get("catid") return dbQuery().delCatg(details) else: return "Please Login"
def removeUser(): if g.user: if request.method == "POST": details = request.form.get("userid") return dbQuery().delUser(details) else: return "Please Login"
def removeVendor(): if g.user: if request.method == "POST": details = request.form.get("venid") return dbQuery().delVen(details) else: return "Please Login"
def removeVariation(): if g.user: if request.method == "POST": details = request.form.get("varid") return dbQuery().delVar(details) else: return "Please Login"
def addcustomer(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") if request.method == "GET": return render_template("addcustomer.html", username=g.user, role=g.role, date=date, time=time) elif request.method == "POST": data = request.form pstatus = dbQuery().addCustomer(data) if pstatus == "success": flash("Customer Added", "success") return render_template("addcustomer.html", username=g.user, role=g.role, date=date, time=time) else: flash("Something Went Wrong", "error") return render_template("addcustomer.html", username=g.user, role=g.role, date=date, time=time) else: return redirect(url_for('unauthenticated'))
def deleteService(): if g.user: if request.method == "POST": details = request.form.get("servid") return dbQuery().delServ(details) else: return "Please Login"
def getvars(): if g.user: if request.method == 'POST': data = request.form.get('data') allVars = dbQuery().getAllVars(data)[0]['variations'] return (allVars) else: return "PLease Login"
def makePurchaseOrder(): if g.user: if request.method == "POST": details = request.form makeOrder = dbQuery().makePurchaseOrder(details) return makeOrder else: return "Unauthenticated"
def getServ(): if g.user: if request.method == "POST": pid = request.form.get("data") status = dbQuery().getServ(pid) return status else: return "Please Login"
def cancelOrder(): if g.user: if request.method == "POST": details = request.form.get("data") status = dbQuery().cancelOrder(details) return status else: return "Please Login"
def checkBalance(): if g.user: if request.method == "POST": details = request.form makeOrder = dbQuery().checkBal(details) return makeOrder else: return "Unauthenticated"
def accounting(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") balance = dbQuery().getTransaction("bal") dues = dbQuery().getTotalDues() return render_template("account.html", username=g.user, role=g.role, date=date, time=time, bal=balance, due=dues) else: return redirect(url_for('unauthenticated'))
def serviceinvoice(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") allProd = dbQuery().getServices() invoice = dbQuery().generateInvoiceid() return render_template("servicecreate.html", username=g.user, role=g.role, date=date, time=time, prods=allProd, invid=invoice) else: return redirect(url_for('unauthenticated'))
def updateCustomer(): if g.user: if request.method == "POST": details = request.form status = dbQuery().custUpdate(details) return status else: return "Please Login"
def newServiceInvoice(): if g.user: if request.method == "POST": details = request.form status = dbQuery().makeInvoiceforService(details) return "success" else: return "Please Login"
def delPriv(): if g.user: if request.method == "POST": details = request.form.get("privid") return dbQuery().delPriv(details) else: return "Please Login"
def unfeaturethis(): if g.user: if request.method == "POST": details = request.form.get("id") status = dbQuery().unfeatureThis(details) return status else: return "Please Login"
def placeorder(): if g.user: date = datetime.today() date = date.strftime("%d/%m/%Y") time = datetime.now() time = time.strftime("%H:%M:%S") allProduct = dbQuery().getProducts() allVendor = dbQuery().getAllvendor() newOrderID = dbQuery().getNewOrderID() return render_template("placeorder.html", username=g.user, role=g.role, date=date, time=time, product=allProduct, vendor=allVendor, orderid=newOrderID) else: return redirect(url_for('unauthenticated'))
def statusToggle(): if g.user: if request.method == "POST": product = request.form.get("id") toggle = dbQuery().changeProduct(product) if toggle == "error": return "false" else: return toggle else: return "Please Login"
def removeProduct(): if g.user: if request.method == "POST": product = request.form.get("id") delPro = dbQuery().deleteProduct(product) if delPro == "success": return "True" else: return "False" else: return "Please Login"