Exemplos de ticket::selectRaw em PHP

Exemplo n.º 1

Arquivo: TicketRepository.php Projeto: safcrace/tutosystem

 protected function selectTikectsList()
 {
     return ticket::selectRaw('tickets.*, ' . '(SELECT COUNT(*) FROM ticket_comments WHERE ticket_comments.ticket_id = tickets.id) as num_comments,' . '(SELECT COUNT(*) FROM ticket_votes WHERE ticket_votes.ticket_id = tickets.id) as num_votes')->with('author');
 }