def update_stock():
if not request.cookies.get('authToken'):
return redirect("/admin/login")
elif (lib.decodeToken(request.cookies.get('authToken')) == 0
or lib.decodeToken(request.cookies.get('authToken')) == 1):
return render_template("admin/login")
return render_template("admin/update-stock.html")
def stock_categories():
if not request.cookies.get('authToken'):
return redirect("/admin/login")
elif (lib.decodeToken(request.cookies.get('authToken')) == 0
or lib.decodeToken(request.cookies.get('authToken')) == 1):
return render_template("admin/login")
return render_template("admin/stock-categories.html")
def adminDashboard():
if not request.cookies.get('authToken'):
return redirect("/admin/login")
elif (lib.decodeToken(request.cookies.get('authToken')) == 0
or lib.decodeToken(request.cookies.get('authToken')) == 1):
return render_template("admin/login")
return render_template("admin/dashboard.html")
def user_management():
if not request.cookies.get('authToken'):
return redirect("/admin/login")
elif (lib.decodeToken(request.cookies.get('authToken')) == 0
or lib.decodeToken(request.cookies.get('authToken')) == 1):
return render_template("admin/login")
return render_template("admin/user-management.html")
def vouchers():
if not request.cookies.get('authToken'):
return redirect("/admin/login")
elif (lib.decodeToken(request.cookies.get('authToken')) == 0
or lib.decodeToken(request.cookies.get('authToken')) == 1):
return render_template("admin/login")
return render_template("admin/vouchers.html")
def getBalanceSheet(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
result = mongo.db.stock_categories.find({}, {"_id": 1, "name": 1})
o = []
n = {}
if (result.count() == 0):
return dumps(result)
j = -1
for x in result:
r2 = mongo.db.stock_details.find({"productName": str(x['_id'])},
{"qty": 1})
c = 0
for i in r2:
c = c + int(i['qty'])
j = j + 1
o.append(c)
#n.append("a"+str(j))
#f=dict(zip(n, o))
#return dumps(f)
n['val'] = o
return dumps(n)
def newAcheivements(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
d2 = []
for i in range(0, int(request.form['no'])):
t = "nm" + str(i + 1)
d2.append(request.form[t])
data = {
"_id": int(time.time() * 1000),
"pname": request.form['pname'],
"ename": request.form['ename'],
"etype": request.form['etype'],
"ecat": request.form['ecat'],
"eprize": request.form['eprize'],
"evenue": request.form['evenue'],
"edate": request.form['edate'],
"eremarks": request.form['eremarks'],
"winners": d2
}
result = mongo.db.achievements.insert(data)
return l.response(True, 200, "Success.")
def newEvent(mongo, request, app):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
d3 = []
d2 = []
for i in range(0, int(request.form['pNo'])):
t = "p" + str(i + 1)
d3.append(request.files[t])
timeSave = str(int(time.time() * 1000))
d2.append(timeSave + "-" + d3[i].filename)
f = os.path.join(app.config['UPLOAD_FOLDER'], d2[i])
d3[i].save(f)
data = {
"_id": int(time.time() * 1000),
"name": request.form['title'],
"description": request.form['desc'],
"date": request.form['date'],
"photos": d2
}
result = mongo.db.events.insert(data)
return l.response(True, 200, "Success.")
def getCat(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
result = mongo.db.stock_categories.find({}, {"_id": 1, "name": 1})
return dumps(result)
def viewVouchers(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
result = mongo.db.vouchers.find({})
return dumps(result)
def deleteStockCategory(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
no = mongo.db.stock_categories.delete_one({"_id": int(request.form['id'])})
if no:
return l.response(True, 200, "Success.")
else:
return l.response(False, 0, "Fail.")
def getStockDetail(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
result = mongo.db.stock_categories.find({"_id": int(request.form['id'])})
if (result.count() == 1):
return dumps(result)
else:
return "dfdsf"
def deleteVouchers(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
no = mongo.db.vouchers.delete_one({"_id": int(request.form['id'])})
if no:
return l.response(True, 200, "Success.")
else:
return "dfd"
def getStockList(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
result = mongo.db.stock_details.find()
if (result.count() > 0):
return dumps(result)
else:
return "dfdsf"
def getStockCategoryNames(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
result = mongo.db.stock_categories.find({"status": {
"$ne": "0"
}}, {
"status": 0,
"statusComment": 0,
"description": 0
})
return dumps(result)
def stockEditSave(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
d1 = {"_id": int(request.form['id'])}
d2 = {
"$set": {
"name": request.form['name'],
"description": request.form['desc'],
"status": request.form['status']
}
}
result = mongo.db.stock_categories.update(d1, d2)
return l.response(True, 200, "Success.")
def addReceipts(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
data = {
"_id": int(time.time() * 1000),
"item": request.form['item'],
"rno": request.form['rno'],
"date": request.form['date'],
"amount": request.form['amount'],
"remarks": request.form['remarks']
}
result = mongo.db.receipts.insert(data)
return l.response(True, 200, "Success.")
def updateStockEditSave(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
d1 = {"_id": int(request.form['id'])}
d2 = {
"$set": {
"receivedFrom": request.form['receivedFrom'],
"invoiceNo": request.form['invoiceNo'],
"rate": request.form['rate'],
"qty": request.form['qty'],
"remarks": request.form['remarks'],
"time": int(time.time() * 1000)
}
}
result = mongo.db.stock_details.update(d1, d2)
return l.response(True, 200, "Success.")
def updateStock(mongo, request):
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
data = {
"_id": int(time.time() * 1000),
"productName": request.form['productName'],
"productId": request.form['productId'],
"receivedFrom": request.form['receivedFrom'],
"invoiceNo": request.form['invoiceNo'],
"rate": request.form['rate'],
"qty": request.form['qty'],
"remarks": request.form['remarks'],
"time": int(time.time() * 1000)
}
result = mongo.db.stock_details.insert(data)
return l.response(True, 200, "Success.")
def addStockCategory(mongo, request):
#auth = request.cookies.get('authToken')
auth = l.decodeToken(request.form['authToken'])
if (auth == 1):
return l.response(False, 2, "Authentication token invalid.")
elif (auth == 0):
return l.response(False, 3, "Authentication token expired.")
query = mongo.db.stock_categories.find({
"name":
re.compile(request.form['name'], re.IGNORECASE)
}).count()
if (query == 0):
data = {
"_id": int(time.time() * 1000),
"name": request.form['name'],
"status": 1,
"statusComment": "",
"description": request.form['desc']
}
mongo.db.stock_categories.insert(data)
return l.response(True, 200, "Success.")
else:
return l.response(False, 10, "Already Exits.")
