Code Explanation

Here’s a breakdown of some of the important parts of the code:

1. create_db.py:
   This script sets up the database. It creates the tables where all the data, such as employee details, products, and suppliers, will be stored. The script uses SQLite3, a simple database system.

   Example code:

    

   import sqlite3
   
   def create_database():
       conn = sqlite3.connect('inventory.db')
       c = conn.cursor()
   
       # Create the tables
       c.execute('''CREATE TABLE IF NOT EXISTS employees
                    (id INTEGER PRIMARY KEY, name TEXT, email TEXT, contact TEXT)''')
       c.execute('''CREATE TABLE IF NOT EXISTS products
                    (id INTEGER PRIMARY KEY, name TEXT, category TEXT, supplier TEXT, price REAL)''')
       conn.commit()
       conn.close()
   

   This ensures that when you first start the system, the database is ready to store data.

2. dashboard.py:
   The dashboard.py file controls the main interface of the system. It shows buttons for managing employees, suppliers, products, and sales. When you click any button, the corresponding screen for managing that data opens.

   Example code:

    

   import tkinter as tk
   from tkinter import messagebox
   
   def open_employee_screen():
       # Open the employee management screen
       employee_screen = tk.Toplevel(window)
       employee_screen.title("Employee Management")
   
   window = tk.Tk()
   window.title("Inventory Management Dashboard")
   
   btn_employee = tk.Button(window, text="Employee", command=open_employee_screen)
   btn_employee.pack()
   
   window.mainloop()
   

   The code uses Tkinter to create buttons and windows, making the interface interactive and user-friendly.

3. employee.py:
   This script manages employee data. You can add new employees or search for existing ones by name, email, or contact details. It allows you to update or delete employee records.

   Example code:

    

   def add_employee(name, email, contact):
       conn = sqlite3.connect('inventory.db')
       c = conn.cursor()
       c.execute("INSERT INTO employees (name, email, contact) VALUES (?, ?, ?)", (name, email, contact))
       conn.commit()
       conn.close()
   

4. billing.py:
   The billing.py script handles everything related to billing. It calculates the total price of the products selected by the customer, including any discounts. It also generates invoices.

   Example code:

   def calculate_total(products, discounts):
       total = sum([product['price'] for product in products])
       discount_amount = total * (discounts / 100)
       return total - discount_amount
   

   This script is important because it helps the system calculate the total bill for each sale and generate invoices.

Provided Code

Here’s a list of the Python files used in this project:

1. create_db.py – Sets up the database and tables.

2. dashboard.py – Controls the main dashboard interface.

3. employee.py – Manages employee records.

4. supplier.py – Manages supplier data.

5. product.py – Manages product details.

6. category.py – Handles product categories.

7. sales.py – Tracks sales transactions.

8. billing.py – Handles billing and invoice generation.