public function ringkasan1_3() { $year = Carbon::now()->format('Y'); $data = []; for ($i = 1; $i <= 9; $i++) { for ($j = 1; $j <= 12; $j++) { $detail = Keluarmasuk::where('tarikh', 'like', $year . '-' . $j . '-%')->where('cawangan_id', 3)->where('kesalahan', $i)->sum('jumlah'); array_push($data, [$i . '_' . $j => $detail]); } } $jumlah = 1; // dd($data); return View('admin.ringkasan.ringkasan1_3', compact('data', 'jumlah')); }
public function sungaipetani() { $year = Carbon::now()->format('Y'); $data = []; $cawangan = 3; for ($i = 1; $i <= 9; $i++) { for ($j = 1; $j <= 12; $j++) { $month = $j; if ($month < 10) { $month = '0' . $j; } $detail = Keluarmasuk::where('tarikh', 'like', $year . '-' . $month . '-%')->where('cawangan_id', 3)->where('kesalahan', $i)->sum('jumlah'); array_push($data, [$i . '_' . $j => $detail]); } } $jumlah = 1; // dd($data); return View('members.laporan.sungaipetani', compact('data', 'jumlah', 'cawangan', 'year')); }
public function laporan($cawangan) { $year = Carbon::now()->format('Y'); $data = []; for ($i = 1; $i <= 9; $i++) { for ($j = 1; $j <= 12; $j++) { $detail = Keluarmasuk::where('tarikh', 'like', $year . '-' . $j . '-%')->where('cawangan_id', $cawangan)->where('kesalahan', $i)->sum('jumlah'); array_push($data, [$i . '_' . $j => $detail]); } } $cawangan = Cawangan::find($cawangan)->nama; $jumlah = 1; return View('members.laporan.cetak', compact('data', 'jumlah', 'cawangan', 'year')); }
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(); }