Java程序辅导

PROBLEM STATEMENT
Dajani Consulting does not presently have any system to monitor IT requests from their clients. They have requested the design and creation of a ticketing system to keep track of requests 
from clients who need assistance with their products. The ticketing system should allow for assignment of tickets to specific individual techs, classification of tickets, as well as a method of 
commenting on tickets to keep track of progress. It will need to be linked to their Dajani Microsoft-based accounts, and also allow for clients to submit requests directly.
Dajani I.T. Ticketing System
Russell Yee, Daniel Beauchamp, Jordan Llopis, Sai Suresh, Juan Landeros, Mohammed Msallam, Salar Abadi, Matt Luca, Swayam Pati(Advisor), Kenneth Elliott (Instructor) 
College: Department of Computer Science, California State University, Sacramento
Client: Dajani consulting Inc.
Dajani Consulting Inc. is a technology consultant 
company founded in 2011 that has produced 
government projects such as the Stop Data 
Collection System, Ammo 2016, California Sex and 
Arson Registry for the California Department of 
Justice. They have also done work for the 
California Department of General Services, 
Department of Technology, and Corrections 
Healthcare Services.
BACKGROUND
Figure 1:  (above) Visual mockup of front 
end with list of tickets and assignees, 
along with a toolbar for navigation
Figure 4:   (left) Organization of 
permissions for accessing the ticketing 
queue for users
Backend
• Relational database with tables identifying
users with various levels of permissions,
and individual tickets with various attributes
• Uses Spring Data JPA API for Java/MySQL
interaction
• “Tiered” AWS Cognito user pool with varying
levels of permissions to identify users
SUMMARY OF WORK Benefits to Dajani
Using a ticketing system, can help agents to keep 
track of  in-progress tickets and, have access to the 
records of past interactions with every customer.
Additionally, this helps the management to keep 
track of What tickets have been assigned to each 
consultant.