public function compose(View $view, Ticket $ticket) { $tickets_c = $ticket->latest()->completed()->get(); $tickets_p = $ticket->latest()->pending()->get(); $tickets_cmt = DB::table('tickets')->join('comments', 'tickets.id', '=', 'comments.post_id')->select('tickets.*')->distinct()->get(); // $view->with(['tickets_c', $tickets_c, 'tickets_p', $tickets_p, 'tickets_cmt', $tickets_cmt]); $view->with(['tickets_c' => $tickets_c, 'tickets_p' => $tickets_p, 'tickets_cmt' => $tickets_cmt]); }
public function ticketsWithComments(Ticket $ticket) { $page_flag = "with_comments"; $tickets_c = $ticket->latest()->completed()->get(); $tickets_p = $ticket->latest()->pending()->get(); //FIND TICKETS WITH SUBMITTED COMMENTS $tickets = Ticket::has('comments')->get(); return view('tickets.viewAll', compact('tickets', 'tickets_c', 'tickets_p', 'page_flag')); }
/** * Displays all Tickets * * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function all() { $tickets = Ticket::latest()->paginate(); $header = 'All Tickets'; return view('tickets.index', compact('tickets', 'header')); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $tickets = Ticket::latest()->get(); return view('cms.tickets.index', ['tickets' => $tickets]); }