public function anyData(Request $req)
{
// $data = Libur::all();
// $count = App\Flight::where('active', 1)->count();
// $data = \DB::table('unit_kerja');
$data = Libur::with('tahun');
// dd($data->get());
if ($req->get('filter_tahun_id')) {
$result = $data->where('tahun_id', $req->get('filter_tahun_id'))->get();
// $['rows']=$result;
// return $result;
$datax['rows'] = $this->show_relasi_kolom($result);
// return $this->show_relasi_kolom($result);
return $datax + ['token' => csrf_token()];
}
if ($req->get('page')) {
// dd($req->get('page')-1);
if ($req->get('page') == 1) {
$offset = $req->get('page') - 1;
} else {
$offset = ($req->get('page') - 1) * $req->get('rows');
}
$data->skip($offset);
}
if ($req->get('rows')) {
$data->take($req->get('rows'));
}
// $datax['rows']=$data->get();
// $datax['rows']=$this->show_relasi_kolom($data->get(),'skpd','nama_skpd','skpd');
$datax['rows'] = $this->show_relasi_kolom($data->orderBy('tahun_id', 'ASC')->orderBy('tanggal_libur_nasional', 'ASC')->get());
$total['total'] = \DB::table('libur_nasional')->count();
// dd($data->get());
return $total + $datax + ['token' => csrf_token()];
//
}
