public function searchSurat()
{
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);
}
$surat = Surat::whereNotNull('surat_id');
if (!empty($id)) {
$surat->where('surat_id', $id);
}
$kode_surat = Input::get('kode_surat');
if (!empty($kode_surat)) {
$surat->where('kode_surat', 'like', '%' . $kode_surat . '%');
}
$_surat = clone $surat;
$sort_by = 'surat.surat_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 = $_surat->count();
$surat = $surat->orderBy($sort_by, $sort_mode)->get();
$format = Format::all();
$active = 'surat';
$user = User::with('role')->where('user_id', Auth::user()->user_id)->first();
return View::make('formSurat', compact('user', 'active', 'surat', 'format'));
} catch (Exception $e) {
$response = new stdclass();
$response->code = '0';
$response->status = 'error';
$response->message = 'Failed';
$response->data = null;
return Response::json($response);
}
}
