1. Main Script: Complaint-System-Main.py

   This is the primary script responsible for launching the graphical user interface (GUI) and handling the core functionality of the Complaint Management System.

   Key Components:

   • Tkinter Initialization:

      

     from tkinter import *
     import tkinter.messagebox as MessageBox
     from complaintListing import ComplaintListing
     

     Here, Tkinter is imported to create the graphical interface. The MessageBox module is used to display alert boxes (e.g., for error handling). The ComplaintListing is imported from the complaintListing.py file to handle displaying and managing complaints in the system.

   • Complaint Submission Form: The form used for complaint submission is built using Tkinter’s widgets such as Labels, Entries, and Buttons. For example:

      

     root = Tk()
     root.title("Complaint Management System")
     
     Label(root, text='Complaint Description').grid(row=0, column=0)
     desc_entry = Entry(root)
     desc_entry.grid(row=0, column=1)
     
     submit_btn = Button(root, text='Submit', command=submit_complaint)
     submit_btn.grid(row=2, column=1)
     

     • The root window (root) is created using Tk(), and the title of the window is set to “Complaint Management System”.
     • A label widget is created to prompt the user to enter the complaint description, and an entry widget is used to collect the complaint from the user.
     • The submit_complaint function is triggered when the “Submit” button is clicked.

   • Submit Complaint Functionality:

      

     def submit_complaint():
         description = desc_entry.get()
         if description == "":
             MessageBox.showinfo("Insert Status", "All fields are required")
         else:
             insert_complaint(description)
     

     • The submit_complaint() function is responsible for handling the submission of a complaint. It checks if the description is empty. If the field is empty, a message box alerts the user that all fields are required.
     • If the description is valid, the insert_complaint() function is called to store the data into the database.

   • Database Insertion:

      

     def insert_complaint(description):
         conn = sqlite3.connect('complaintDB.db')
         cursor = conn.cursor()
         cursor.execute("INSERT INTO complaints(description, status) VALUES(?, ?)", (description, "Pending"))
         conn.commit()
         conn.close()
         MessageBox.showinfo("Insert Status", "Complaint Submitted Successfully")
         desc_entry.delete(0, END)
     

     • A connection to the SQLite database (complaintDB.db) is established using sqlite3.connect().
     • The INSERT INTO SQL command is executed to add a new complaint with the description provided by the user. The status of the complaint is set to “Pending” by default.
     • After executing the command, the database is committed and the connection is closed. A success message is displayed to the user, and the input field is cleared.

   • Complaint Management Buttons: In addition to the submission button, buttons for viewing, updating, and deleting complaints are provided:

      

     view_btn = Button(root, text='View Complaints', command=view_complaints)
     view_btn.grid(row=3, column=1)
     
     delete_btn = Button(root, text='Delete Complaint', command=delete_complaint)
     delete_btn.grid(row=4, column=1)
     

     • The view_complaints() function opens a new window to display all complaints.
     • The delete_complaint() function allows the user to delete a specific complaint based on its ID.

2. Complaint Listing Script: complaintListing.py

   This script handles the display and management of the complaints that are stored in the database.

   • Complaint Listing GUI:

      

     def ComplaintListing():
         listing_window = Tk()
         listing_window.title("Complaint Listing")
         
         # Create Treeview to display complaints
         tree = ttk.Treeview(listing_window, columns=('ID', 'Description', 'Status'), show='headings')
         tree.heading('ID', text='ID')
         tree.heading('Description', text='Description')
         tree.heading('Status', text='Status')
         tree.pack(fill=BOTH, expand=1)
     

     • A new window (listing_window) is created to display the complaints.
     • A Treeview widget is used to display the complaints in a table-like format with columns for the ID, description, and status. The data is fetched from the database and inserted into the treeview.

   • Fetching and Displaying Complaints:

      

     conn = sqlite3.connect('complaintDB.db')
     cursor = conn.cursor()
     cursor.execute("SELECT * FROM complaints")
     rows = cursor.fetchall()
     
     for row in rows:
         tree.insert("", END, values=row)
     conn.close()
     

     • The SQLite database is queried to fetch all the complaints stored in the complaints table.
     • Each row from the result is inserted into the Treeview widget for display.

   • Updating and Deleting Complaints: Buttons are provided for users to update or delete complaints directly from the listing window:

      

     update_btn = Button(listing_window, text='Mark as Resolved', command=mark_as_resolved)
     update_btn.pack()
     

     • The mark_as_resolved() function updates the status of the selected complaint to “Resolved” in the database.

3. Database Configuration: configdb.py

   This script is responsible for setting up and configuring the SQLite database.

   • Database Initialization:
      

     conn = sqlite3.connect('complaintDB.db')
     cursor = conn.cursor()
     cursor.execute("CREATE TABLE IF NOT EXISTS complaints (id INTEGER PRIMARY KEY AUTOINCREMENT, description TEXT, status TEXT)")
     conn.commit()
     conn.close()
     

     • The SQLite database connection is established, and a table named complaints is created if it doesn’t already exist. The table contains three columns: id, description, and status.

4. Database File: complaintDB.db

   This file is the actual SQLite database where all complaint records are stored. The database is lightweight and does not require a separate server, making it ideal for small-scale applications like this one.

Code Flow:

1. Initialization: The database is initialized using configdb.py, creating the necessary table if it doesn’t exist.
2. Complaint Submission: The user submits a complaint through the main GUI, which is inserted into the SQLite database via Complaint-System-Main.py.
3. View Complaints: The user can view all the complaints in a separate window using the ComplaintListing function from complaintListing.py.
4. Manage Complaints: The user can update or delete complaints directly from the listing window, and these actions are reflected in the database.

This modular design allows for easy extension of the project, and additional features such as user authentication or enhanced reporting can be implemented with minimal changes to the core structure.