public function searchUser()
{
try {
#deklarasi data input
$id = Input::get('id');
$validator = Validator::make(array('id' => $id), array('id' => 'numeric'));
if ($validator->fails()) {
$response = new stdclass();
$response->code = '0';
$response->status = 'error';
$response->message = $validator->messages()->first();
$response->data = null;
return Response::json($response);
}
$user = User::whereNotNull('user_id');
if (!empty($id)) {
$user->where('user_id', $id);
}
$name = Input::get('name');
if (!empty($name)) {
$user->where('name', 'like', '%' . $name . '%');
}
$role_id = Input::get('role');
if (!empty($role_id)) {
$user->where('role_id', $name);
}
$_user = clone $user;
$sort_by = 'users.user_id';
$_sort_by = Input::get('sort_by');
if (!empty($_sort_by)) {
$sort_by = $_sort_by;
}
$sort_mode = 'asc';
$_sort_mode = Input::get('sort_mode');
if (!empty($_sort_mode)) {
$sort_mode = $_sort_mode;
}
$total_records = $_user->count();
$response = new stdclass();
$response->code = '1';
$response->status = 'success';
$response->message = 'Successful';
$response->total_records = $total_records;
$response->data = $user->orderBy($sort_by, $sort_mode)->get();
#jika ingin dapat last insert id
#$response->data = $user->user_id;
return Response::json($response);
} catch (Exception $e) {
$response = new stdclass();
$response->code = '0';
$response->status = 'error';
$response->message = 'Failed';
$response->data = null;
return Response::json($response);
}
}
public function testOrder()
{
$user = User::whereNotNull('age')->orderBy('age', 'asc')->first();
$this->assertEquals(13, $user->age);
$user = User::whereNotNull('age')->orderBy('age', 'ASC')->first();
$this->assertEquals(13, $user->age);
$user = User::whereNotNull('age')->orderBy('age', 'desc')->first();
$this->assertEquals(37, $user->age);
$user = User::whereNotNull('age')->orderBy('natural', 'asc')->first();
$this->assertEquals(35, $user->age);
$user = User::whereNotNull('age')->orderBy('natural', 'ASC')->first();
$this->assertEquals(35, $user->age);
$user = User::whereNotNull('age')->orderBy('natural', 'desc')->first();
$this->assertEquals(35, $user->age);
}
public function getIndex()
{
$users = User::whereNotNull('announcement_stream')->get();
return View::make('backend.admin.subscriptions.index', ['users' => $users, 'period' => Config::get('announcements.duration')]);
}