Ali's Photography Space…

Introduction:
A Ticket System serves is a tool for managing and tracking customer support interactions or internal task requests efficiently. It offers a centralized platform where users can submit their issues, questions, or requests, known as Tickets, and designated personnel can address them promptly. This article outlines the structure and functionality of a Ticket System, emphasizing the importance of organization, efficiency, and accountability in handling various requests.
In coming weeks I will work to create Python “Simple Ticket System”, using DataBase to store the data,I will try to publish the code and documentation about this project. In this post I will draft-down a brain-storming session with myself of what may we need in this system, tables and functions. So points may not be consistent and organized and ordered in the right way.

Notes:

• Anything in this articale concidered as draft and may changed later.
• Functions and Tables in coming lines are not in order
• creation of the database will not be in one time, so we will use ALTER many times to add or change the tables.
• All the data will be as test and not real.

Functions:
Main Functions in the system to add and manage the data and interact with the Database and records.

• 1. Tickets:

Add, Edit, Delete and Show Tickets in the system.

• 2. Priority.

Add, Edit, Delete and Show Priorety in the system.

• 3. Department.

Add, Edit, Delete and Show Department in the system.

• 4. Status.

Add, Edit, Delete and Show Status in the system.

• 5. Category.

Add, Edit, Delete and Show Category in the system.

Helping Functions:
Functions that will help to perform some action within the system or other main function.

• 1. Show List:

To list/show the data we have in a lookup table.

• 2. Export to Excle:

Exporting the data to an excel file.[Backup]

• 3. Check Availability:

To check if the user input is exist in the lookup table or not.

Tables:
All the Tables Names and fields are subject of change during the implementation.

1. Staff Table (staff):

• s_id (Staff ID)
• name
• mobile
• email
• position (manager, technical, etc.)

2. Ticket Table (ticket):

• t_id (Ticket ID)
• dep_id (Department ID)
• date (Creation Date)
• asignto (Assigned To: s_id)
• description
• priority_id (High, Medium, Low)
• status_id (Open, In Progress, Resolved, Closed)
• updated_date
• category

3. Category Table:

• c_id (Category ID)
• cat_name (Category Name)

4. Ticket Notes Table (t_notes):

5.Priority Table (priority):

• pr_id (Priority ID)
• pri_level (Priority Level: High, Medium, Low)

6.Status Table (status):

• stat_id (Status ID)
• stat (Status: Open, In Progress, Resolved, Closed)

7.Staff Job Table (staff_job):

• sj_id (Job ID)
• job_id
• received_date
• finished_date
• status_id
• note_id

8.Departments Table (departments):

Versions Policy:
In this system i will create version 1 and will be released with all esintial functions to perform and work, however there will be some ideas to enhance the data entry and reporting also some validations that will be done later in version 2.

Part 1:
in Part1 we will do the folloeing:

• Define the Tables and their fields initially.
• Write the code to create the database and selected tables.
• Writing the code to insert initial data in selected tables .
• Initial naming of functions.
• Create the Main Menu
• Create the Menu for the Lookups Table

:: Ticket System ::

..:: Have Fun with Coding ::.. 🙂

To Download my Python code (.py) files Click-Here

Follow me on Twitter..

By: Ali Radwani