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); }