/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
if (Request::wantsJson()) {
$query = User::join('user_roles', 'users.role_id', '=', 'user_roles.id');
//->where('county_id', config('app.county'));
$input = Input::only('draw', 'columns', 'search', 'order', 'start', 'length');
$dt = new DataTables($query, $input);
$dt->column('users.id', 'id')->column('full_name')->column('email')->column('users.created_at', 'created_at')->column('user_roles.name', 'role');
$data = $dt->get(function ($user) {
return [$user->id, $user->full_name, $user->email, $user->created_at->format('d-m-Y H:i'), $user->role];
});
return json($data);
}
return view('admin.users.index')->with('roles', Role::all());
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
if (Request::wantsJson()) {
$input = Input::only('draw', 'columns', 'search', 'order', 'start', 'length');
$input['columns'][4] = ['data' => 4, 'searchable' => 'true'];
$query = ContactMessage::where('county_id', config('app.county'));
$dt = new DataTables($query, $input);
$dt->column('id')->column('name')->column('subject')->column('created_at', function ($date) {
return $date->format('d-m-Y H:i');
})->column('email')->column('message')->column('replied', function ($data) {
return (bool) $data;
})->column('user_id');
return json($dt->get());
}
return view('admin.contact.index');
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
if (Request::wantsJson()) {
$query = Response::join('quiz', 'response.quiz_id', '=', 'quiz.id')->join('areas', function ($join) {
$join->on('quiz.area_id', '=', 'areas.id')->where('areas.county_id', '=', config('app.county'));
})->leftJoin('area_categories', 'quiz.category_id', '=', 'area_categories.id')->join('users', 'users.id', '=', 'user_id');
$input = Input::only('draw', 'columns', 'search', 'order', 'start', 'length');
$input['columns'][4] = ['data' => 4, 'searchable' => 'true'];
$dt = new DataTables($query, $input);
$dt->column('full_name')->column('areas.name', 'area_name')->column('response.created_at', 'created_at')->column('user_id')->column('area_categories.name', 'category_name')->column('response.id', 'id');
$data = $dt->get(function ($result) {
return [['id' => $result->user_id, 'name' => $result->full_name], ['area' => $result->area_name, 'category' => $result->category_name], $result->created_at->format('d-m-Y H:i'), $result->id];
});
return json($data);
}
return view('admin.responses.index');
}