PHP_TicketSystem

Information

This system is made as an assessment for DigiFactory.

Installation

Info about project

This project is made using Visual Studio and Wamp.

Step 1 - Setup of database

• Open phpMyAdmin.
• Create a new database named "php_ticketsystem".
• Go to the import tab.
• Choose the "php_ticketsystem.sql" and choose Import.

Step 2 - Changing sql user account

• in the "PHP_TicketSystem" folder go to "Assets/Functions/Functions.php".
• Change the "$DatabaseUsername" and the "$DatabasePassword" to the correct username and password.

Time indication

12/12/2023 - 10:30 till 15:15

• 10:30 - Github created
• 10:41 - Created Index
• 12:00 - Finished front-end style (bootstrap 5)
• 13:50 - Added table with datatables, and prepared database
• 15:10 - Finished Index.php (table / SQL query)

13/12/2023 - 11:40 till 14:20

• 11:40 - start working on 'ticket_create.php'
• 12:45 - Finished styling 'ticket_create.php'
• 13:00 - Start create command
• 13:30 - Debug "index" overview table

14/12/2023 - 12:35 till 14:30

• 12:35 - Started Working on Create Ticket (value validations)
• 12:50 - Finished value validation
• 13:30 - Finished Insert query's
• 13:50 - Debug some code
• 14:00 - Start working on upload files script
• 14:30 - finished create ticket script.

15/12/2023 - 11:30 till 12:30

• 11:30 - Start working on ticket View
• 12:30 - Finished Styling ticket page

18/12/2023 - 11:15 till 15:10

• 11:15 - Ticket view data view
• 12:00 - Start Reaction system
• 13:00 - Start Reaction Attachments upload system
• 13:40 - Start Reaction Display system
• 14:40 - Finished Code, start Debug and Temp data Generation
• 15:00 - Finished generating temp data, Creating Installation guide
• 15:10 - Finished guides