public function getOfficeOrRegion(Request $request)
{
if ($request->input('id') == 'reg') {
$office_region = Region::select(\DB::raw("CONCAT(code,'-',name) AS full_name, id"))->lists('full_name', 'id');
} else {
$office_region = Office::select(\DB::raw("CONCAT(code,'-',name) AS full_name, id"))->lists('full_name', 'id');
}
return Response::json($office_region);
}
public function region_data()
{
\DB::statement(\DB::raw('set @rownum=0'));
$regions = Region::select([\DB::raw('@rownum := @rownum + 1 AS rownum'), 'id', 'code', 'name', 'abbreviation', 'date_open']);
return Datatables::of($regions)->addColumn('action', function ($region) {
return '
<a href="./region/detail_kprk/' . $region->id . '" class="btn btn-xs btn-info"><i class="glyphicon glyphicon-plus"></i> KPRK</a>
<a href="./region/edit/' . $region->id . '" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-edit"></i> Edit</a>
';
})->editColumn('date_open', function ($region) {
return $region->date_open ? with(new Carbon($region->date_open))->format('d/m/Y') : '';
})->make(true);
}
