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"
