public function carianPost() { $tarikh = Request::get('tarikh'); $bil = 1; $statuses = []; $data[1] = $data[2] = $data[3] = $data[4] = 0; $cawangans = Cawangan::all(); foreach ($cawangans as $cawangan) { $details = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan->id)->get(); // dd($details); if ($details->isEmpty()) { array_push($statuses, ['cawangan' => $cawangan->nama, 'status' => 'BELUM DIREKOD']); Session::flash('error', 'Tiada data.'); } else { array_push($statuses, ['cawangan' => $cawangan->nama, 'status' => 'TELAH DIREKOD']); $jumlah = 0; foreach ($details as $detail) { $jumlah += $detail->jumlah; } $data[$cawangan->id] = $jumlah; } } $yourFirstChart["chart"] = array("type" => "bar"); $yourFirstChart["title"] = array("text" => "Tarikh : " . Carbon::parse($tarikh)->format('d-m-Y')); $yourFirstChart["xAxis"] = array("categories" => ['Alor Setar', 'Pokok Sena', 'Sungai Petani', 'Parol']); $yourFirstChart["yAxis"] = array("title" => array("text" => "Bilangan Banduan / Tahanan")); $yourFirstChart["series"] = [array("name" => "JUMLAH KESELURUHAN", "data" => [$data[1], $data[2], $data[3], $data[4]])]; return View('members.carian.result', compact('bil', 'cawangans', 'statuses', 'yourFirstChart')); }
public function parol($cawangan, $tarikh) { $cawangan_id = Cawangan::where('nama', $cawangan)->first(); $cawangan_id = $cawangan_id->id; $flag = false; $details = Details::where('cawangan_id', $cawangan_id)->where('tarikh', 'like', $tarikh . '%')->get(); $datas = []; if (!$details->isEmpty()) { $flag = true; for ($kesalahan = 17; $kesalahan <= 23; $kesalahan++) { for ($bangsa = 1; $bangsa <= 3; $bangsa++) { for ($jantina = 1; $jantina <= 2; $jantina++) { $detail = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', 4)->where('warganegara_id', 1)->where('bangsa_id', $bangsa)->where('kesalahan_id', $kesalahan)->where('jantina_id', $jantina)->first(); array_push($datas, ['1_' . $bangsa . '_' . $kesalahan . '_' . $jantina => $detail->jumlah]); } } } } return View('members.rekod.cetak.details_parol_cetak', compact('tarikh', 'cawangan', 'flag', 'datas')); }
/** * Run the database seeds. * * @return void */ public function run() { $cawangans = Cawangan::all(); for ($day = 15; $day <= 20; $day++) { if ($day < 10) { $days = '0' . $day; } else { $days = $day; } $tarikh = '2015-10-' . $days; foreach ($cawangans as $cawangan) { if ($cawangan->id == 1) { $count = 16; } else { $count = 14; } for ($kesalahan = 1; $kesalahan <= $count; $kesalahan++) { // Warganegara for ($warga = 1; $warga <= 3; $warga++) { if ($warga == 1) { for ($jantina = 1; $jantina <= 2; $jantina++) { for ($bangsa = 1; $bangsa <= 3; $bangsa++) { Details::create(['tarikh' => $tarikh, 'cawangan_id' => $cawangan->id, 'warganegara_id' => $warga, 'bangsa_id' => $bangsa, 'kesalahan_id' => $kesalahan, 'jantina_id' => $jantina, 'jumlah' => rand(0, 30)]); } } } else { for ($bangsa = 4; $bangsa <= 4; $bangsa++) { for ($jantina = 1; $jantina <= 2; $jantina++) { Details::create(['tarikh' => $tarikh, 'cawangan_id' => $cawangan->id, 'warganegara_id' => $warga, 'bangsa_id' => $bangsa, 'kesalahan_id' => $kesalahan, 'jantina_id' => $jantina, 'jumlah' => rand(0, 123)]); } } } // end if else warga } // end warga } //end kesalahan } } }
protected function getRingkasan4($date, $cawangan) { $tarikh = $date; $data = []; // ALOR SETAR - Melayu Lelaki $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 1)->where('jantina_id', 1)->sum('jumlah'); array_push($data, ['jumlah' => $count]); // Melayu - Perempuan $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 1)->where('jantina_id', 2)->sum('jumlah'); array_push($data, ['jumlah' => $count]); // ALOR SETAR - Cina Lelaki $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 2)->where('jantina_id', 1)->sum('jumlah'); array_push($data, ['jumlah' => $count]); // Cina - Perempuan $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 2)->where('jantina_id', 2)->sum('jumlah'); array_push($data, ['jumlah' => $count]); // ALOR SETAR - India Lelaki $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 3)->where('jantina_id', 1)->sum('jumlah'); array_push($data, ['jumlah' => $count]); // India - Perempuan $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 3)->where('jantina_id', 2)->sum('jumlah'); array_push($data, ['jumlah' => $count]); // B. Warga Lelaki $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('warganegara_id', 2)->where('jantina_id', 1)->sum('jumlah'); array_push($data, ['jumlah' => $count]); // B. Warga Perempuan $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('warganegara_id', 2)->where('jantina_id', 2)->sum('jumlah'); array_push($data, ['jumlah' => $count]); // Lain-lain Lelaki $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('warganegara_id', 3)->where('jantina_id', 1)->sum('jumlah'); array_push($data, ['jumlah' => $count]); // Lain-lain Perempuan $count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('warganegara_id', 3)->where('jantina_id', 2)->sum('jumlah'); array_push($data, ['jumlah' => $count]); return $data; }
public function detailsUpdate() { $tarikh = Request::get('tarikh'); $cawangan = Request::get('cawangan'); $cawangan_id = Cawangan::where('nama', $cawangan)->first()->id; if ($cawangan_id == 1 || $cawangan_id == 2) { $count = 16; } else { $count = 14; } // Kesalahan for ($kesalahan = 1; $kesalahan <= $count; $kesalahan++) { // Warganegara for ($warga = 1; $warga <= 3; $warga++) { if ($warga == 1) { for ($jantina = 1; $jantina <= 2; $jantina++) { for ($bangsa = 1; $bangsa <= 3; $bangsa++) { $details = Details::where('tarikh', 'like', Request::get('tarikh') . '%')->where('cawangan_id', $cawangan_id)->where('warganegara_id', $warga)->where('bangsa_id', $bangsa)->where('kesalahan_id', $kesalahan)->where('jantina_id', $jantina)->update(['jumlah' => Request::get($warga . '_' . $bangsa . '_' . $kesalahan . '_' . $jantina)]); } } } else { for ($bangsa = 4; $bangsa <= 4; $bangsa++) { for ($jantina = 1; $jantina <= 2; $jantina++) { $details = Details::where('tarikh', 'like', Request::get('tarikh') . '%')->where('cawangan_id', $cawangan_id)->where('warganegara_id', $warga)->where('bangsa_id', $bangsa)->where('kesalahan_id', $kesalahan)->where('jantina_id', $jantina)->update(['jumlah' => Request::get($warga . '_' . $bangsa . '_' . $kesalahan . '_' . $jantina)]); } } } // end if else warga } // end warga } //end kesalahan // Update Keluarmasuk for ($i = 1; $i <= 9; $i++) { if (Request::get($i . '_melayu')) { $bangsa = 'melayu'; Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'melayu')->update(['jumlah' => Request::get($i . '_' . $bangsa)]); } if (Request::get($i . '_cina')) { $bangsa = 'cina'; Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'cina')->update(['jumlah' => Request::get($i . '_' . $bangsa)]); } if (Request::get($i . '_india')) { $bangsa = 'india'; Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'india')->update(['jumlah' => Request::get($i . '_' . $bangsa)]); } if (Request::get($i . '_singh')) { $bangsa = 'singh'; Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'singh')->update(['jumlah' => Request::get($i . '_' . $bangsa)]); } if (Request::get($i . '_pathan')) { $bangsa = 'pathan'; Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'pathan')->update(['jumlah' => Request::get($i . '_' . $bangsa)]); } if (Request::get($i . '_ptetap')) { $bangsa = 'ptetap'; Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'ptetap')->update(['jumlah' => Request::get($i . '_' . $bangsa)]); } if (Request::get($i . '_llb')) { $bangsa = 'llb'; Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'llb')->update(['jumlah' => Request::get($i . '_' . $bangsa)]); } if (Request::get($i . '_wanita')) { $bangsa = 'wanita'; Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'wanita')->update(['jumlah' => Request::get($i . '_' . $bangsa)]); } } return Redirect::back(); }