1. class
  2. Alligator
  3. \
  4. Business
  5. \
  6. Database
  7. \
  8. Ticketing
  9. \
  10. TicketRepository

TicketRepository

class TicketRepository extends EntityRepository

Class TicketRepository is injected as alligator.ticket_repository service. TicketRepository is used for crud operation for entity.

Use this class to connect to database.

Traits

JQGridTrait
Trait JQGridTrait

Constants

ALIAS

Alias for ticket entity
COMMENT_ALIAS

Alias for comment entity
FILE_ALIAS

Alias for file entity
USER_ALIAS

Alias for user entity

Methods

jQGridJoinFields(QueryBuilder $qb, JQGridWrapper $jqGridWrapper)

All joins used in select.

from JQGridTrait
jQGridGroupByFields(QueryBuilder $qb, JQGridWrapper $jqGridWrapper)

Should contain group by which jqgrid uses.

from JQGridTrait
array
findAllForJQGRID(int $page, int $offset, array $sortParams, array $additionalParams, JQGridWrapper $jqGridWrapper)

JQGrid function

from JQGridTrait
array
searchForJQGRID(array $searchParams, array $sortParams, bool $isCountSearch = false, array $additionalParams = array(), JQGridWrapper $jqGridWrapper = null)

JQGrid function

from JQGridTrait
array
getDBTicket(Ticket|int $ticketId)

Find ticket by id

Ticket
getTicketObjectById(int $ticketId)

Find ticket by id

Ticket[]
getAllTickets()

Find all ticket objects

Ticket
saveTicketRepository(Ticket $entity)

Persist new Ticket

bool
deleteFromTicketRepository(array $array)

Delete tickets from array of ids

array
findAllCustomBy(User $user)

Find all tickets for specific user

array
getAllTicketsIds()

Find ids of all tickets

array
getTicketsForPagination(int $userId, int $page, int $offset)

JQGrid function - return rows based on page and offset

mixed
countTicketsForPagination(int $userId)

JQGrid function - counts rows

Details

in JQGridTrait at line 27
jQGridJoinFields(QueryBuilder $qb, JQGridWrapper $jqGridWrapper)

All joins used in select.

Override in the repository class if needed. Should do nothing otherwise

Parameters

QueryBuilder $qb
JQGridWrapper $jqGridWrapper

in JQGridTrait at line 42
jQGridGroupByFields(QueryBuilder $qb, JQGridWrapper $jqGridWrapper)

Should contain group by which jqgrid uses.

Override in the repository class if needed. Should do nothing otherwise

Parameters

QueryBuilder $qb
JQGridWrapper $jqGridWrapper

in JQGridTrait at line 61
array findAllForJQGRID(int $page, int $offset, array $sortParams, array $additionalParams, JQGridWrapper $jqGridWrapper)

JQGrid function

Parameters

int $page
int $offset
array $sortParams
array $additionalParams
JQGridWrapper $jqGridWrapper

Return Value

array

in JQGridTrait at line 94
array searchForJQGRID(array $searchParams, array $sortParams, bool $isCountSearch = false, array $additionalParams = array(), JQGridWrapper $jqGridWrapper = null)

JQGrid function

Parameters

array $searchParams
array $sortParams
bool $isCountSearch
array $additionalParams
JQGridWrapper $jqGridWrapper

Return Value

array

at line 63
array getDBTicket(Ticket|int $ticketId)

Find ticket by id

Parameters

Ticket|int $ticketId

Return Value

array

Exceptions

NoResultException
NonUniqueResultException

at line 92
Ticket getTicketObjectById(int $ticketId)

Find ticket by id

Parameters

int $ticketId

Return Value

Ticket

Exceptions

NoResultException
NonUniqueResultException

at line 109
Ticket[] getAllTickets()

Find all ticket objects

Return Value

Ticket[]

at line 124
Ticket saveTicketRepository(Ticket $entity)

Persist new Ticket

Parameters

Ticket $entity

Return Value

Ticket

Exceptions

ORMException
OptimisticLockException

at line 140
bool deleteFromTicketRepository(array $array)

Delete tickets from array of ids

Parameters

array $array Array of ticket ids for delete

Return Value

bool FALSE on error, TRUE otherwise

at line 164
array findAllCustomBy(User $user)

Find all tickets for specific user

Parameters

User $user

Return Value

array

at line 199
array getAllTicketsIds()

Find ids of all tickets

Return Value

array

at line 216
array getTicketsForPagination(int $userId, int $page, int $offset)

JQGrid function - return rows based on page and offset

Parameters

int $userId
int $page
int $offset

Return Value

array

at line 254
mixed countTicketsForPagination(int $userId)

JQGrid function - counts rows

Parameters

int $userId

Return Value

mixed

Exceptions

NonUniqueResultException