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