Interface TicketDao

All Known Implementing Classes:
DefaultTicketDao

public interface TicketDao
The Interface TicketDao responsible for searching CsTicketModel objects.
Spring Bean ID:
ticketDao
  • Method Details

    • findTicketsByAgentGroupState

      List<CsTicketModel> findTicketsByAgentGroupState(EmployeeModel agent, CsAgentGroupModel group, CsTicketState state)
      Find tickets by the specified agent, group and state. If any of these parameters are null, they should be considered "don't care" - i.e. don't include in the query
      Parameters:
      agent - The agent to search for or null if none
      group - The group to search for or null if none
      state - The state to search for or null if any
      Returns:
      The list of tickets matching the specified critera
    • findTicketsByStringInTicketOrEvent

      List<CsTicketModel> findTicketsByStringInTicketOrEvent(String searchString)
      Find tickets which contain the specified search string in the headline or any of the events
      Parameters:
      searchString - The string to find in the ticket
      Returns:
      The list of tickets matching the criteria
    • findTicketsByStringInTicketOrEventAndStates

      List<CsTicketModel> findTicketsByStringInTicketOrEventAndStates(String searchString, Set<CsTicketState> states)
      Find tickets which contain the specified search string in the headline or any of the events and that are also in the given list of states. If the list of states is empty or null then the state should not be considered in the query.
      Parameters:
      searchString - The string to find in the ticket
      states - The states that any returned tickets should be in
      Returns:
      The list of tickets matching the criteria
    • findTicketEventsByTicket

      List<CsTicketEventModel> findTicketEventsByTicket(CsTicketModel ticket)
      Find all ticket events for CsTicketModel object.
      Parameters:
      ticket - the CsTicketModel for which to return ticket events.
      Returns:
      A list of ticket events matching search criteria.
    • findTicketEventsForCustomerByTicket

      List<CsTicketEventModel> findTicketEventsForCustomerByTicket(CsTicketModel ticket)
      Find all ticket events for CsTicketModel object excluding private messages.
      Parameters:
      ticket - the CsTicketModel for which to return ticket events.
      Returns:
      A list of ticket events matching search criteria.
    • findTicketEventsByEventCode

      List<CsTicketEventModel> findTicketEventsByEventCode(CsTicketModel ticket, String eventCode)
      Lookup events of the specified CsTicketModel object with the specified event code
      Parameters:
      ticket - the CsTicketModel for which to return ticket events.
      eventCode - The code of the ticket event to lookup
      Returns:
      The ticket events with that event code
    • findTicketEventsForCustomerByEventCode

      List<CsTicketEventModel> findTicketEventsForCustomerByEventCode(CsTicketModel ticket, String eventCode)
      Lookup events of the specified CsTicketModel object with the specified event code, excluding private messages
      Parameters:
      ticket - the CsTicketModel for which to return ticket events.
      eventCode - The code of the ticket event to lookup
      Returns:
      The ticket events with that event code
    • findTicketsByAgent

      List<CsTicketModel> findTicketsByAgent(EmployeeModel agent)
      Find all the tickets that are assigned to the Agent.
      Parameters:
      agent - The agent to find assigned tickets for
      Returns:
      A list of tickets matching search criteria
    • findTicketsByAgentGroup

      List<CsTicketModel> findTicketsByAgentGroup(CsAgentGroupModel agentGroup)
      Find all the tickets assigned to the AgentGroup.
      Parameters:
      agentGroup - The AgentGroup to find assigned tickets for
      Returns:
      A list of tickets matching search criteria
    • findTicketsByCategory

      List<CsTicketModel> findTicketsByCategory(CsTicketCategory... category)
      Find all the tickets that have the provided categories.
      Parameters:
      category - The category/categories for which to return tickets. The number of arguments is variable and may be zero, although zero arguments will return an empty list.
      Returns:
      A list of tickets matching search criteria
    • findTicketsByCustomer

      List<CsTicketModel> findTicketsByCustomer(UserModel customer)
      Find all tickets that are associated with the customer.
      Parameters:
      customer - The customer to find tickets for
      Returns:
      A list of tickets matching search criteria
    • findTicketsById

      List<CsTicketModel> findTicketsById(String ticketId)
      Lookup tickets with the specified ticket id
      Parameters:
      ticketId - The id of the ticket to lookup
      Returns:
      The tickets with that Id
    • findTicketsByOrder

      List<CsTicketModel> findTicketsByOrder(OrderModel order)
      Find all the tickets that are associated with the order.
      Parameters:
      order - The order to find tickets for
      Returns:
      A list of tickets matching search criteria
    • findTicketsByPriority

      List<CsTicketModel> findTicketsByPriority(CsTicketPriority... priority)
      Find all the tickets that have the provided priorities.
      Parameters:
      priority - The priority/priorities for which to return tickets. The number of arguments is variable and may be zero, although zero arguments will return an empty list.
      Returns:
      A list of tickets matching search criteria
    • findTicketsByResolutionType

      List<CsTicketModel> findTicketsByResolutionType(CsResolutionType... resolutionType)
      Find all the tickets that have the provided Resolution Type(s).
      Parameters:
      resolutionType - The Resolution Type(s) for which to return tickets. The number of arguments is variable and may be zero, although zero arguments will return an empty list.
      Returns:
      A list of tickets matching search criteria
    • findTicketsByState

      List<CsTicketModel> findTicketsByState(CsTicketState... state)
      Find all the tickets that are in the provided states.
      Parameters:
      state - The state(s) for which to return tickets. The number of arguments is variable and may be zero, although zero arguments will return an empty list.
      Returns:
      A list of tickets matching search criteria
    • findTicketsWithNullAgent

      List<CsTicketModel> findTicketsWithNullAgent()
      Find all the tickets that are not assigned to an agent.
      Returns:
      A list of tickets not assigned to an agent
    • findTicketsWithNullAgentGroup

      List<CsTicketModel> findTicketsWithNullAgentGroup()
      Find all the tickets that are not assigne to an agent group.
      Returns:
      A list of tickets not assigned to an agent group
    • findTicketsByCustomerOrderByModifiedTime

      List<CsTicketModel> findTicketsByCustomerOrderByModifiedTime(UserModel user)
      Find all tickets that are associated with the customer in descending and order by Modified date time.
      Parameters:
      user -
      Returns:
      List
    • findTicketsByCustomerOrderByModifiedTime

      SearchPageData<CsTicketModel> findTicketsByCustomerOrderByModifiedTime(UserModel user, BaseSiteModel baseSite, PageableData pageableData)
      Find all tickets that are associated with the customer and current site, in descending and order by Modified date time.
      Parameters:
      user -
      baseSite -
      pageableData -
      Returns:
      List
    • findTicketsBySiteAndCustomer

      List<CsTicketModel> findTicketsBySiteAndCustomer(BaseSiteModel baseSite, UserModel customer)
      Find all tickets that are associated with the customer in descending and order by Modified date time.
      Parameters:
      baseSite - The base site
      customer - The customer to find tickets for
      Returns:
      A list of tickets matching search criteria