public static function getAssessment($year = null)
{
if ($year != null) {
$form = Form::where('nama', '=', 'ka4')->whereRaw('YEAR(`tanggal`) = ?', array($year))->get();
} else {
$form = Form::where('nama', '=', 'ka4')->get();
}
//only form that dont have form ka3 will be indexed
$outform = [];
$c = 0;
foreach ($form as $fm) {
$anak = $fm->anak->first();
$isFormKA4HasBeenCreated = FALSE;
foreach ($anak->form as $fa) {
if ($fa->nama == "ka5") {
//this form cannot be included...
$isFormKA4HasBeenCreated = TRUE;
}
}
if ($isFormKA4HasBeenCreated == FALSE) {
$outform[$c] = $fm;
$c++;
}
}
return $outform;
}
public static function synchronize($lka)
{
$form = Form::where('no_lka', '=', $lka);
$count = $form->count();
if ($count > 1) {
// looping pada tiap data..
$fm = $form->orderBy('tanggal', 'asc')->get();
$c = 1;
foreach ($fm as $ofm) {
// cek nilai multiple total dan ubah nilai multiple total
// sesuai dengan jumlah mutilple total
$upFm = Form::find($ofm->id);
if ($ofm->multiple_total != $count) {
$upFm->multiple_total = $count;
}
// ubah nilai multiple sequence
$upFm->multiple_sequence = $c;
$c++;
$upFm->mode = "multiple";
// ubah data
$upFm->save();
}
} else {
if ($count == 1) {
$fm = $form->first();
$fm->mode = "multiple";
$fm->multiple_total = 1;
$fm->multiple_sequence = 1;
$fm->update();
}
}
}
public function addView($anak_id)
{
$anak = Anak::find($anak_id);
$form = $anak->form->first();
$pendampingan = Pendampingan::where('anak_id', '=', $anak->id)->paginate(100);
$data = ['page_title' => 'Kasus Anak 6 (KA6) - Pendampingan', 'panel_title' => 'Pendampingan Add View', 'form_url' => '/dash/formka6/pendampingan/add', 'form_status' => 'add', 'form_id' => $form->id, 'location' => 'addView', 'table' => Form::where('nama', '=', 'ka6')->paginate(5), 'anak' => $anak];
return View::make('formka6.pendampingan.form', $data);
}
public static function isLKAExist($lka)
{
$form = Form::where('no_lka', '=', $lka)->count();
if ($form > 0) {
return true;
} else {
return false;
}
}
public function isLKAUnique()
{
$q = Input::get('query');
$form = Form::where('no_lka', '=', $q)->get();
if (count($form) > 0) {
return Response::json(['status' => false]);
} else {
return Response::json(['status' => true]);
}
}
public static function getLKAData($year = null)
{
$form = Form::where('nama', '=', 'ka1')->orWhere('nama', '=', 'ka2')->get();
//only form that dont have form ka3 will be indexed
$outform = [];
$c = 0;
foreach ($form as $fm) {
if ($year != null) {
$date = date_create($fm->tanggal);
$yearDB = date_format($date, 'Y');
if ($year == $yearDB) {
$anak = $fm->anak->first();
$isFormKA3HasBeenCreated = FALSE;
foreach ($anak->form as $fa) {
if ($fa->nama == "ka3") {
//this form cannot be included...
$isFormKA3HasBeenCreated = TRUE;
}
}
if ($isFormKA3HasBeenCreated == FALSE) {
$outform[$c] = $fm;
$c++;
}
}
} else {
$anak = $fm->anak->first();
$isFormKA3HasBeenCreated = FALSE;
foreach ($anak->form as $fa) {
if ($fa->nama == "ka3") {
//this form cannot be included...
$isFormKA3HasBeenCreated = TRUE;
}
}
if ($isFormKA3HasBeenCreated == FALSE) {
$outform[$c] = $fm;
$c++;
}
}
}
return $outform;
}
public static function getLKA()
{
$pad = 4;
$rand_max = 9999;
$yearDb = SettingDAO::getValue("LKA_YEAR");
$monthDb = SettingDAO::getValue("LKA_MONTH");
$yearNow = date('Y');
$part = SettingDAO::getValue('LKA_PART');
$num = rand(1, $rand_max);
//random number
$number = str_pad($num, $pad, "0", STR_PAD_LEFT);
$year = date('Y');
if ($yearDb != $yearNow) {
$num = rand(1, $rand_max);
//random number
$number = str_pad($num, $pad, "0", STR_PAD_LEFT);
$year = $yearNow;
}
$year = date('Y');
$month = RomanHelper::numberToRoman(date('m'));
$lka = $number . '/' . $part . '/' . $month . '/' . $year;
$unique = false;
while ($unique == false) {
$f = Form::where('no_lka', '=', $lka)->count();
if ($f == 0) {
$unique = true;
//or break looping
} else {
$num = rand(1, $rand_max);
//random number
$number = str_pad($num, $pad, "0", STR_PAD_LEFT);
$lka = $number . '/' . $part . '/' . $month . '/' . $year;
$f = Form::where('no_lka', '=', $lka)->count();
if ($f == 0) {
$unique == true;
}
}
}
return $lka;
}
public function search()
{
$keyword = Input::get('keyword');
$filter = Input::get('filter');
$result = Form::where('nama', '=', 'ka3')->orderBy('tanggal', 'desc');
if ($keyword != NULL) {
if ($filter == "kode" || $filter == NULL) {
$result = $result->where('id', '=', $keyword);
} else {
if ($filter == "lka") {
$result = $result->where('no_lka', 'LIKE', '%' . $keyword . '%');
} else {
if ($filter == "anak") {
$result = $result->whereHas('anak', function ($qa) use($keyword) {
$qa->where('anak.nama', 'LIKE', '%' . $keyword . '%');
});
} else {
if ($filter == "jenis") {
$result = $result->whereHas('anak', function ($qa) use($keyword) {
$qa->whereHas('jeniskasus', function ($qp) use($keyword) {
$qp->where('jenis_kasus.jenis', 'LIKE', '%' . $keyword . '%');
});
});
} else {
if ($filter == "tindak") {
$result = $result->whereHas('anak', function ($qa) use($keyword) {
$qa->whereHas('tindaklanjut', function ($qp) use($keyword) {
$qp->where('tindak_lanjut.aksi', 'LIKE', '%' . $keyword . '%');
});
});
}
}
}
}
}
}
$data = ['title' => '', 'page_title' => 'Kasus Anak 3 (KA3)', 'panel_title' => 'Search View', 'location' => 'search', 'table' => $result->orderBy('created_at', 'desc')->get()];
return View::make('formka3.view', $data);
}
public function search()
{
$keyword = Input::get('keyword');
$filter = Input::get('filter');
$result = Form::where('nama', '=', 'ka1')->orderBy('tanggal', 'asc');
if ($keyword != NULL) {
if ($filter == "anak") {
$result = $result->whereHas('anak', function ($qa) use($keyword) {
$qa->where('anak.nama', 'LIKE', '%' . $keyword . '%');
});
} else {
if ($filter == "pelapor") {
$result = $result->whereHas('anak', function ($qa) use($keyword) {
$qa->whereHas('pelapor', function ($qp) use($keyword) {
$qp->where('pelapor.nama', 'LIKE', '%' . $keyword . '%');
});
});
} else {
if ($filter == "lka") {
$result = $result->where('no_lka', 'LIKE', '%' . $keyword . '%');
} else {
if ($filter == "tanggal") {
$split = explode('-', $keyword);
$tanggal = date("Y-m-d", strtotime($keyword));
Session::flash('message', "{$split['0']},");
$result = $result->where('tanggal', 'LIKE', $tanggal);
} else {
if ($filter == "kode" || $filter == NULL) {
$result = $result->where('id', '=', $keyword);
}
}
}
}
}
}
$data = ['title' => '', 'page_title' => 'Kasus Anak 1 (KA1)', 'panel_title' => 'Search View', 'location' => 'search', 'filter' => $filter, 'table' => $result->orderBy('created_at', 'desc')->get()];
return View::make('formka1.view', $data);
}
public function detailView($id)
{
$data = ['page_title' => 'Kasus Anak 1 (KA1)', 'panel_title' => 'Detail View', 'location' => 'view', 'data' => Form::where('nama', '=', 'ka1')->where('id', '=', $id)->first()];
return View::make('formka1multi.detail', $data);
}
public function detailView($id, $enc_lka)
{
$data = ['page_title' => 'Kasus Anak 2 (KA2) Multi', 'panel_title' => 'Detail View', 'location' => 'view', 'lka' => $enc_lka, 'data' => Form::where('nama', '=', 'ka2')->where('id', '=', $id)->first()];
return View::make('formka2multi.detail', $data);
}
public function detailView($id)
{
$data = ['page_title' => 'Staff', 'panel_title' => 'Detail View', 'location' => 'view', 'data' => Form::where('nama', '=', 'ka1')->where('id', '=', $id)->first()];
return View::make('staff.detail', $data);
}
public function search()
{
$keyword = Input::get('keyword');
$filter = Input::get('filter');
$result = Form::where('nama', '=', 'ka2')->orderBy('tanggal', 'asc');
if ($keyword != NULL) {
if ($filter == "anak") {
$result = $result->whereHas('anak', function ($qa) use($keyword) {
$qa->where('anak.nama', 'LIKE', '%' . $keyword . '%');
});
} else {
if ($filter == "sumber") {
$result = $result->whereHas('anak', function ($qa) use($keyword) {
$qa->whereHas('sumberinformasi', function ($qp) use($keyword) {
$qp->where('sumber_informasi.sumber', 'LIKE', '%' . $keyword . '%');
});
});
} else {
if ($filter == "lka") {
$result = $result->where('no_lka', 'LIKE', '%' . $keyword . '%');
} else {
if ($filter == "kode" || $filter == NULL) {
$result = $result->where('id', '=', $keyword);
}
}
}
}
}
$data = ['title' => '', 'page_title' => 'Kasus Anak 2 (KA2)', 'panel_title' => 'Search View', 'location' => 'search', 'table' => $result->orderBy('created_at', 'desc')->get()];
return View::make('formka2.view', $data);
}
