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')); }
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(); }
public function tahunanXPpk() { $bil = 1; $counts = []; $wilayahs = Bahagian::where('nama', 'not like', 'wilayah%')->get(); foreach ($wilayahs as $wilayah) { $cawangans = Cawangan::where('bahagian_id', $wilayah->id)->where('nama', '!=', 'Wilayah')->get(); foreach ($cawangans as $cawangan) { $bilangan = 0; if (Auth::user()->level->id == 1) { $laporans = Laporan::where('cawangan_id', $cawangan->id)->where('tarikh', 'like', Request::get('year') . '%')->count(); $bilangan = $laporans; } else { $laporans = Laporan::where('cawangan_id', $cawangan->id)->where('tarikh', 'like', Request::get('year') . '%')->get(); foreach ($laporans as $laporan) { if ($laporan->peralatan->kategori->units->id == Auth::user()->units->id) { $bilangan++; } } } $data = ['ppk' => $cawangan->nama, 'bilangan' => $bilangan]; array_push($counts, $data); } } $jumlah = 0; foreach ($counts as $count) { $jumlah += $count['bilangan']; } return View('members.supervisor.laporan.tahunanXPpk', compact('bil', 'counts', 'jumlah')); }