Data Access Requirements
function.LoginFunction
- get user by username
function.RetrieveData
- get ticket by id
- get all tickets
- get tickets by unit
- get tickets by user
- search all tickets (for later)
- search tickets by unit (for later)
- search tickets by user (for later)
- get user by id
- get unit by id
- get all users
- get ticket updates (ticket.getUpdates())
- get technician assigned to a ticket (ticket.getTechnicians())
- check if a technician is assigned to a ticket (ticket.getTechnicians().contains(technician))
- get technician by unit (unit.getTechnicians())
- get all units
- get supervisors of a unit (unit.getSupervisors())
- get requestor's email (ticket.getUser().getEmail())
controller.AcctManagement, controller.FirstLoginUpdate, controller.Settings
- save user
controller.AssignTechnicians, controller.Cancel, controller.CreateTicket, controller.EditTicket, controller.Priority, controller.Update
- save ticket
controller.CreateUnit
- save unit
controller.Details, controller.EditTicket, controller.Priority
- get ticket by id
DAO Methods
UserDao
- User getUser( String username )
- User getUser (Long id )
- List<User> getUsers()
- List<User> getTechnicians( Ticket ticket ) // not necessary if Ticket has List<User> technicians
- List<User> getTechnicians( Unit ) // not necessary if Unit has List<User> technicians
- List<User> getSupervisors( Unit ) // not necessary if Unit has List<User> supervisors
- User saveUser()
TicketDao
- Ticket getTicket( Long id )
- List<Ticket> getTickets()
- List<Ticket> getTickets( Unit unit ) // not necessary if Unit has List<Ticket> submitted to the unit.
- List<Ticket> getTickets( User requestor ) // not necessary if User has List<Ticket> created by the user.
- Ticket saveTicket( Ticket ticket )
UnitDao
- Unit getUnit( Long id )
- Unit getUnits()
- Unit saveUnit( Unit unit )