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 parol()
{
$tarikh = Request::get('tarikh');
$cawangan = Cawangan::find(4)->nama;
$flag = false;
$details = Details::where('cawangan_id', 4)->where('tarikh', 'like', Request::get('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', Request::get('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.display.details_parol', compact('tarikh', 'cawangan', 'flag', 'datas'));
}
