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