Beispiel #1
0
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)
Beispiel #2
0
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"