public function preAddResult()
{
$keyword = Input::get('keyword');
$based = Input::get('based');
$year = Input::get('year');
$result = null;
$form = null;
if ($based == "anak") {
$result = Anak::where('nama', 'LIKE', '%' . $keyword . '%');
$result = $result->whereHas('form', function ($qa) use($year) {
$qa->whereRaw('YEAR(`tanggal`) = ?', array($year));
});
} else {
if ($based == "lka") {
$result = Form::where('no_lka', 'LIKE', '%' . $keyword . '%')->whereRaw('YEAR(`tanggal`) = ?', array($year))->whereRaw('nama IN (?,?)', ['ka1', 'ka2']);
$form = Form::where('no_lka', '=', '%' . $keyword . '%');
}
}
$status = 'multiple';
if ($result->count() == 0) {
$status = null;
} else {
if ($result->count() == 1) {
$status == "single";
}
}
$data = ['page_title' => 'Kasus Anak 3 (KA3)', 'panel_title' => 'Form Pre Add Result', 'form_url' => '/dash/formka3/preaddresult', 'form_status' => 'add', 'keyword' => $keyword, 'based' => $based, 'selectedYear' => $year, 'result_status' => $status, 'result_data' => $result->get(), 'form' => $form];
return View::make('formka3.preadd', $data);
}
public function detailView($id)
{
$data = ['page_title' => 'Anak', 'panel_title' => 'Detail View', 'location' => 'view', 'data' => Anak::where('id', '=', $id)->first()];
return View::make('anak.detail', $data);
}
public function anakQueryNama($q)
{
$anak = Anak::where('nama', 'LIKE', '%' . $q . '%')->get();
$anak[0]->form->first();
return $anak->toJSON();
}
/**
*
* @param string $start example 1998-12-25
* @param string $end example 1999-12-25
* @return boolean | Anak
*/
public static function getAnakBetween($start = null, $end = null)
{
if (!is_null($start)) {
if (!is_null($end)) {
$start = date("Y-m-d", strtotime($start));
$end = date("Y-m-d", strtotime($end));
return Anak::where('created_at', '>=', $start)->where('created_at', '<=', $end)->get();
} else {
return false;
}
} else {
return Anak::all();
}
}
