public function disposisiYear() { $year = Input::get('year'); $dis = KA3DisposisiHelper::getDisposisiForm($year); $data = ['panel_title' => 'Table View', 'location' => 'disposisi', 'table' => $dis, 'selectedYear' => $year, 'disposisiCount' => KA3DisposisiHelper::count($year)]; $data = array_merge($data, $this->basic); return View::make('formka4.view', $data); }
public static function getDisposisiForm($year) { $formDisArray = KA3DisposisiHelper::countMyDisposisi($year); // var_dump($formDisArray); if (is_array($formDisArray) && count($formDisArray) != 0) { $form = Form::wherein('id', $formDisArray)->whereRaw('YEAR(`tanggal`) = ?', array($year))->orderBy('no_lka', 'desc')->get(); // var_dump($form); return $form; } else { return null; } }