<th> Priority </th> <th> Last Replier </th> <th> Last Activity </th> <th> Reply Due </th> </thead> <tbody id="hello"> <?php $tickets = App\Model\Ticket\Tickets::where('status', '=', 1)->orderBy('id', 'DESC')->paginate(20); ?> @foreach ($tickets as $ticket ) <tr <?php if ($ticket->seen_by == null) { ?> style="color:green;" <?php } ?> > <td><input type="checkbox" value="{{$ticket->id}}"/></td> <?php $title = App\Model\Ticket\Ticket_Thread::where('ticket_id', '=', $ticket->id)->first(); $string = strip_tags($title->title); if (strlen($string) > 40) {
// Inprogress Route::get('/{dept}/closed', ['as' => 'dept.closed.ticket', 'uses' => 'Agent\\helpdesk\\TicketController@deptclose']); // Closed }); /* |------------------------------------------------------------------ |Guest Routes |-------------------------------------------------------------------- | Here defining Guest User's routes | | */ // seasrch Route::POST('tickets/search/', function () { $keyword = Illuminate\Support\Str::lower(Input::get('auto')); $models = App\Model\Ticket\Tickets::where('ticket_number', '=', $keyword)->orderby('ticket_number')->take(10)->skip(0)->get(); $count = count($models); return Illuminate\Support\Facades\Redirect::back()->with("contents", $models)->with("counts", $count); }); Route::any('getdata', function () { $term = Illuminate\Support\Str::lower(Input::get('term')); $data = Illuminate\Support\Facades\DB::table("tickets")->distinct()->select('ticket_number')->where('ticket_number', 'LIKE', $term . '%')->groupBy('ticket_number')->take(10)->get(); foreach ($data as $v) { return ['value' => $v->ticket_number]; } }); Route::get('getform', ['as' => 'guest.getform', 'uses' => 'Client\\helpdesk\\FormController@getForm']); /* get the form for create a ticket by guest user */ Route::post('postform/{id}', 'Client\\helpdesk\\FormController@postForm'); /* post the AJAX form for create a ticket by guest user */ Route::post('postedform', 'Client\\helpdesk\\FormController@postedForm');