class SigninWindow(BoxLayout):
def __init__(self, **kwargs):
super().__init__(**kwargs)
self.ids.username_field.focus = True
self.notify = Notify()
def cb(self, dt):
self.notify.dismiss()
self.notify.clear_widgets()
def validate_user(self):
client = MongoClient()
db = client.silverpos
users = db.users
user = self.ids.username_field
pwd = self.ids.pwd_field
#info = self.ids.info
uname = user.text
passw = pwd.text
#user.text = ''
#pwd.text = ''
if not uname and not passw:
self.notify.add_widget(
Label(text='[color=#FFFFFF][b]Username and Password are Required[/b][/color]', markup=True))
self.notify.open()
Clock.schedule_once(self.cb, 1.1)
elif not uname:
self.notify.add_widget(
Label(text='[color=#FFFFFF][b]Username is Required[/b][/color]', markup=True))
self.notify.open()
Clock.schedule_once(self.cb, 1.1)
# info.text = "[color=#FF0000]Username required ![/color]"
elif passw == '':
self.notify.add_widget(
Label(text='[color=#FFFFFF][b]Password is Required[/b][/color]', markup=True))
self.notify.open()
Clock.schedule_once(self.cb, 1.1)
# info.text = "[color=#FF0000]Password required ![/color]"
else:
user = users.find_one(({'user_name': uname}))
if user == None:
self.notify.add_widget(
Label(text='[color=#FF0000][b]Invalid Username[/b][/color]', markup=True))
self.notify.open()
Clock.schedule_once(self.cb, 1.1)
# info.text = "[color=#FF0000]Invalid Username ![/color]"
else:
passw = hashlib.sha256(passw.encode()).hexdigest()
if passw == user['password']:
des = user['designation']
self.notify.add_widget(
Label(text='[color=#00FF00][b]Success Login[/b][/color]', markup=True))
self.notify.open()
Clock.schedule_once(self.cb, 1.3)
self.parent.parent.parent.ids.scrn_op.children[0].ids.loggedin_user.text = uname
if des == 'Administrator':
self.parent.parent.current = 'scrn_admin'
else:
self.parent.parent.current = 'scrn_op'
else:
self.notify.add_widget(
Label(text='[color=#FF0000][b]Invalid Password[/b][/color]', markup=True))
self.notify.open()
Clock.schedule_once(self.cb, 1.1)
class AdminWindow(BoxLayout):
def __init__(self, **kwargs):
super().__init__(**kwargs)
client = MongoClient()
db = client.silverpos
self.users = db.users
self.products = db.stocks
self.notify = Notify()
product_code = []
product_name = []
spinvals = []
for product in self.products.find():
product_code.append(product["product_code"])
name = product["product_name"]
if len(name) > 30:
name = name[:30] + "..."
product_name.append(name)
for x in range(len(product_code)):
line = ' | '.join([product_code[x], product_name[x]])
spinvals.append(line)
self.ids.target_product.values = spinvals
content = self.ids.scrn_contents
users = self.get_users()
userstable = DataTable(table=users)
content.add_widget(userstable)
# Display Products
product_scrn = self.ids.scrn_product_contents
products = self.get_products()
prod_table = DataTable(table=products)
product_scrn.add_widget(prod_table)
def logout(self):
self.parent.parent.current = 'scrn_si'
def add_user_fields(self):
target = self.ids.ops_fields
target.clear_widgets()
crud_first = TextInput(hint_text="First Name", multiline=False)
crud_last = TextInput(hint_text="Last Name", multiline=False)
crud_user = TextInput(hint_text="User Name", multiline=False)
crud_pwd = TextInput(hint_text="Password", multiline=False)
crud_des = Spinner(text="Operator",
values=["Operator", "Administrator"])
crud_submit = Button(text="Add",
background_color=(87 / 255.0, 189 / 255.0,
24 / 255.0, .9),
size_hint_x=None,
width=100,
on_release=lambda x: self.add_user(
crud_first.text, crud_last.text, crud_user.
text, crud_pwd.text, crud_des.text))
target.add_widget(crud_first)
target.add_widget(crud_last)
target.add_widget(crud_user)
target.add_widget(crud_pwd)
target.add_widget(crud_des)
target.add_widget(crud_submit)
def add_product_fields(self):
target = self.ids.ops_fields_p
target.clear_widgets()
crud_code = TextInput(hint_text="Product Code", multiline=False)
crud_name = TextInput(hint_text="Product Name", multiline=False)
crud_weight = TextInput(hint_text="Product Weight", multiline=False)
crud_stock = TextInput(hint_text="Product Stock", multiline=False)
crud_sold = TextInput(hint_text="Product Sold", multiline=False)
crud_order = TextInput(hint_text="Product Order", multiline=False)
crud_purchase = TextInput(hint_text="Product Purchase",
multiline=False)
crud_submit = Button(
text="Add",
background_color=(87 / 255.0, 189 / 255.0, 24 / 255.0, .9),
size_hint_x=None,
width=100,
on_release=lambda x: self.add_product(
crud_code.text, crud_name.text, crud_weight.text, crud_stock.
text, crud_sold.text, crud_order.text, crud_purchase.text),
)
target.add_widget(crud_code)
target.add_widget(crud_name)
target.add_widget(crud_weight)
target.add_widget(crud_stock)
target.add_widget(crud_sold)
target.add_widget(crud_order)
target.add_widget(crud_purchase)
target.add_widget(crud_submit)
def add_product(self, code, name, weight, stock, sold, order, purchase):
if code == '' or name == '' or weight == '' or stock == '' or order == '':
self.notify.add_widget(
Label(text='[color=#FF0000][b]All Fields Required[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
self.products.insert_one({
"product_code": code,
"product_name": name,
"product_weight": weight,
"in_stock": stock,
"sold": sold,
"order": order,
"last_purchase": purchase
})
content = self.ids.scrn_product_contents
content.clear_widgets()
# sql = 'INSERT INTO users(first_name,last_name,user_name,password,designation,date) VALUES(%s,%s,%s,%s,%s,%s)'
# values = [first, last, user, pwd, des, datetime.now()]
# self.mycursor.execute(sql, values)
# self.mydb.commit()
prodz = self.get_products()
stocktable = DataTable(table=prodz)
content.add_widget(stocktable)
def add_user(self, first, last, user, pwd, des):
pwd = hashlib.sha256(pwd.encode()).hexdigest()
if first == '' or last == '' or user == '' or pwd == '':
self.notify.add_widget(
Label(text='[color=#FF0000][b]All Fields Required[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
self.users.insert_one({
"first_name": first,
"last_name": last,
"user_name": user,
"password": pwd,
"designation": des,
"date": datetime.now()
})
content = self.ids.scrn_contents
content.clear_widgets()
# sql = 'INSERT INTO users(first_name,last_name,user_name,password,designation,date) VALUES(%s,%s,%s,%s,%s,%s)'
# values = [first, last, user, pwd, des, datetime.now()]
# self.mycursor.execute(sql, values)
# self.mydb.commit()
users = self.get_users()
userstable = DataTable(table=users)
content.add_widget(userstable)
def killswitch(self, dtx):
self.notify.dismiss()
self.notify.clear_widgets()
def update_user(self, first, last, user, pwd, des):
pwd = hashlib.sha256(pwd.encode()).hexdigest()
if user == '':
self.notify.add_widget(
Label(text='[color=#FF0000][b]All Fields Required[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
user = self.users.find_one({'user_name': user})
if user == None:
self.notify.add_widget(
Label(
text='[color=#FF0000][b]Invalid Username[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
if first == "":
first = user['first_name']
if last == "":
last = user['last_name']
if pwd == "":
pwd = user['password']
if des == "":
des = user['designation']
content = self.ids.scrn_contents
content.clear_widgets()
self.users.update_one({"user_name": user}, {
"$set": {
"first_name": first,
"last_name": last,
"user_name": user,
"password": pwd,
"designation": des,
"date": datetime.now()
}
})
# sql = 'UPDATE users SET first_name=%s,last_name=%s,user_name=%s,password=%s,designation=%s WHERE user_name=%s'
# values = [first,last,user,pwd,des,user]
# self.mycursor.execute(sql,values)
# self.mydb.commit()
users = self.get_users()
userstable = DataTable(table=users)
content.add_widget(userstable)
def update_user_fields(self):
target = self.ids.ops_fields
target.clear_widgets()
crud_first = TextInput(hint_text="First Name", multiline=False)
crud_last = TextInput(hint_text="Last Name", multiline=False)
crud_user = TextInput(hint_text="User Name", multiline=False)
crud_pwd = TextInput(hint_text="Password", multiline=False)
crud_des = Spinner(text="Operator",
values=["Operator", "Administrator"])
crud_submit = Button(text="Update",
background_color=(189 / 255.0, 126 / 255.0,
24 / 255.0, 1),
size_hint_x=None,
width=100,
on_release=lambda x: self.update_user(
crud_first.text, crud_last.text, crud_user.
text, crud_pwd.text, crud_des.text))
target.add_widget(crud_first)
target.add_widget(crud_last)
target.add_widget(crud_user)
target.add_widget(crud_pwd)
target.add_widget(crud_des)
target.add_widget(crud_submit)
def update_product_fields(self):
target = self.ids.ops_fields_p
target.clear_widgets()
crud_code = TextInput(hint_text="Product Code", multiline=False)
crud_name = TextInput(hint_text="Product Name", multiline=False)
crud_weight = TextInput(hint_text="Product Weight", multiline=False)
crud_stock = TextInput(hint_text="Product Stock", multiline=False)
crud_sold = TextInput(hint_text="Product Sold", multiline=False)
crud_order = TextInput(hint_text="Product Order", multiline=False)
crud_purchase = TextInput(hint_text="Product Purchase",
multiline=False)
crud_submit = Button(
text="Update",
background_color=(189 / 255.0, 126 / 255.0, 24 / 255.0, 1),
size_hint_x=None,
width=100,
on_release=lambda x: self.update_product(
crud_code.text, crud_name.text, crud_weight.text, crud_stock.
text, crud_sold.text, crud_order.text, crud_purchase.text),
)
target.add_widget(crud_code)
target.add_widget(crud_name)
target.add_widget(crud_weight)
target.add_widget(crud_stock)
target.add_widget(crud_sold)
target.add_widget(crud_order)
target.add_widget(crud_purchase)
target.add_widget(crud_submit)
def update_product(self, code, name, weight, stock, sold, order, purchase):
if code == '':
self.notify.add_widget(
Label(text='[color=#FF0000][b]Code Required[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
target_code = self.products.find_one({'product_code': code})
if target_code == None:
self.notify.add_widget(
Label(text=
'[color=#FF0000][b]All Fields Required[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
if name == '':
name = target_code['product_name']
if weight == '':
weight = target_code['product_weight']
if stock == '':
stock = target_code['in_stock']
if sold == '':
sold = target_code['sold']
if order == '':
order = target_code['order']
if purchase == '':
purchase = target_code['last_purchase']
content = self.ids.scrn_product_contents
content.clear_widgets()
self.products.update_one(
{"product_code": code},
{
"$set": {
"product_code": code,
"product_name": name,
"product_weight": weight,
"in_stock": stock,
"sold": sold,
"order": order,
"last_purchase": purchase
}
},
)
prodz = self.get_products()
stocktable = DataTable(table=prodz)
content.add_widget(stocktable)
def remove_user_fields(self):
target = self.ids.ops_fields
target.clear_widgets()
crud_user = TextInput(hint_text="User Name")
crud_submit = Button(
text="Remove",
size_hint_x=None,
width=100,
background_color=(189 / 255.0, 43 / 255.0, 24 / 255.0, .9),
on_release=lambda x: self.remove_user(crud_user.text))
target.add_widget(crud_user)
target.add_widget(crud_submit)
def remove_product_fields(self):
target = self.ids.ops_fields_p
target.clear_widgets()
crud_code = TextInput(hint_text="Product Code")
crud_submit = Button(
text="Remove",
background_color=(189 / 255.0, 43 / 255.0, 24 / 255.0, .9),
size_hint_x=None,
width=100,
on_release=lambda x: self.remove_product(crud_code.text))
target.add_widget(crud_code)
target.add_widget(crud_submit)
def remove_user(self, user):
if user == '':
self.notify.add_widget(
Label(text='[color=#FF0000][b]UserName Required[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
target_user = self.users.find_one({'user_name': user})
if target_user == None:
self.notify.add_widget(
Label(
text='[color=#FF0000][b]Invalid User Name[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
content = self.ids.scrn_contents
content.clear_widgets()
self.users.delete_one({"user_name": user})
users = self.get_users()
userstable = DataTable(table=users)
content.add_widget(userstable)
def remove_product(self, code):
if code == '':
self.notify.add_widget(
Label(
text='[color=#FF0000][b]Product Code Required[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
target_code = self.products.find_one({'product_code': code})
if target_code == None:
self.notify.add_widget(
Label(text=
'[color=#FF0000][b]Invalid Product Code[/b][/color]',
markup=True))
self.notify.open()
Clock.schedule_once(self.killswitch, 1)
else:
content = self.ids.scrn_product_contents
content.clear_widgets()
self.products.delete_one({"product_code": code})
prodz = self.get_products()
stocktable = DataTable(table=prodz)
content.add_widget(stocktable)
def get_users(self):
client = MongoClient()
db = client.silverpos
users = db.users
_users = OrderedDict()
_users["first_names"] = {}
_users["last_names"] = {}
_users["user_names"] = {}
_users["passwords"] = {}
_users["designations"] = {}
first_names = []
last_names = []
user_names = []
passwords = []
designations = []
for user in users.find():
# first_names.append(user['first_name'])
# last_names.append(user['last_name'])
# user_names.append(user['user_name'])
# pwd = user['password']
# if len(pwd) > 10:
# pwd = pwd[:10] + '...'
# passwords.append(pwd)
# designations.append(user['designation'])
first_names.append(user.get("first_name"))
last_names.append(user.get("last_name"))
user_names.append(user.get("user_name"))
l = user.get("password")
if len(l) > 10:
l = l[:10] + "..."
passwords.append(l)
designations.append(user.get("designation"))
# print(designations)
users_length = len(first_names)
idx = 0
while idx < users_length:
_users["first_names"][idx] = first_names[idx]
_users["last_names"][idx] = last_names[idx]
_users["user_names"][idx] = user_names[idx]
_users["passwords"][idx] = passwords[idx]
_users["designations"][idx] = designations[idx]
idx += 1
return _users
def get_products(self):
client = MongoClient()
db = client.silverpos
products = db.stocks
_stocks = OrderedDict()
_stocks["product_code"] = {}
_stocks["product_name"] = {}
_stocks["product_weight"] = {}
_stocks["in_stock"] = {}
_stocks["sold"] = {}
_stocks["order"] = {}
_stocks["last_purchase"] = {}
product_code = []
product_name = []
product_weight = []
in_stock = []
sold = []
order = []
last_purchase = []
for product in products.find():
product_code.append(product["product_code"])
name = product["product_name"]
if len(name) > 10:
name = name[:10] + "..."
product_name.append(name)
product_weight.append(product["product_weight"])
in_stock.append(product["in_stock"])
try:
sold.append(product["sold"])
except KeyError:
sold.append("") # add nothing !
try:
order.append(product["order"])
except KeyError:
order.append("")
try:
last_purchase.append(product["last_purchase"])
except KeyError:
last_purchase.append("")
# print(designations)
products_length = len(product_code)
idx = 0
while idx < products_length:
_stocks["product_code"][idx] = product_code[idx]
_stocks["product_name"][idx] = product_name[idx]
_stocks["product_weight"][idx] = product_weight[idx]
_stocks["in_stock"][idx] = in_stock[idx]
_stocks["sold"][idx] = sold[idx]
_stocks["order"][idx] = order[idx]
_stocks["last_purchase"][idx] = last_purchase[idx]
idx += 1
return _stocks
'''
pip install pandas, matplotlib
garden install matplotlib
'''
def view_stats(self):
plt.cla()
self.ids.analysis_res.clear_widgets()
target_product = self.ids.target_product.text
target = target_product[:target_product.find(' | ')]
name = target_product[target_product.find(' | '):]
df = pd.read_csv('admin\products_purchase.csv')
purchases = []
dates = []
count = 0
for x in range(len(df)):
if str(df.Product_Code[x]) == target:
purchases.append(df.Purchased[x])
dates.append(count)
count += 1
plt.bar(dates, purchases, color='teal', label=name)
plt.ylabel('Total Purchases')
plt.xlabel('day')
self.ids.analysis_res.add_widget(FCK(plt.gcf()))
def change_screen(self, instance):
if instance.text == "Manage Products":
self.ids.scrn_mngr.current = "scrn_product_content"
elif instance.text == "Manage Users":
self.ids.scrn_mngr.current = "scrn_content"
else:
self.ids.scrn_mngr.current = "scrn_analysis"
