{{ $title }}
@foreach($columns as $column)
{{ $column }}
@endforeach
@foreach($data as $row) @php if ($row['oleh_admin'] != '') { $userID = \App\User::where('id', $row['oleh_admin'])->first(); } else if ($row['oleh_admin'] === NULL) { $adminsade = 'Admin SADE'; } else { $userID = \App\User::where('username', $row['ic_pemohon'])->first(); } // status BSH if(!empty($row['status_bsh'])){ if($row['tahun_bsh'] == $year){ $status_bsh = 'Ya'; }else{ $status_bsh = 'Tidak'; } }else { $status_bsh = '-'; } // status EKASIH if(!empty($row['status_ekasih'])){ if($row['tahun_ekasih'] == $year){ $status_ekasih = 'Ya'; }else{ $status_ekasih = 'Tidak'; } }else { $status_ekasih = '-'; } $allColumns = [ 'User ID' => $userID['email'] ?? $row['email'] ?? $adminsade, 'Id Permohonan' => $row['id'] ?? '', 'Jenis Meter' => $row['jenis_meter_air'] ?? '', 'Tarikh Permohonan' => ' '.$row['tarikh_permohonan'] ?? '', 'No. Identiti' => ' '.$row['ic_pemohon'] ?? '', 'No. Akaun Air' => ' '.$row['no_akaun_air'] ?? '', 'Status Pemilikan' => $row['status_pemilikan']?? '', 'Nama Pemohon' => $row['nama'] ?? '', 'Alamat' => $row['alamat_1'] .''. $row['alamat_2'] .' '. $row['alamat_3'], 'Poskod' => $row['poskod'] ?? '', 'Negeri' => $row['negeri'] ?? '', 'Emel Pemohon' => $row['email'] ?? '', 'No. HP Pemohon' => ' '.$row['tel_bimbit'] ?? '', 'Status' => ($row['status']==-1?'Dibatalkan':($row['status']==2?'Lulus':($row['status']==3?'Gagal':($row['status']==4?'Pukal':'Diproses')))), 'Alasan' => $row['comments'] ?? '', 'Tarikh Pembatalan' => $row['tarikh_pembatalan'] ?? '', 'Tarikh Gagal/Lulus' => $row['tarikh_gagal_lulus'] ?? '', 'Pendapatan Pemohon' => $row['pendapatan_pemohon'] ?? '', 'Status BSH' => $status_bsh, 'Status EKASIH' => $status_ekasih, 'Status Rekod' => !empty($row['myid_status_rekod']) ? ($myid_status->where('code', $row['myid_status_rekod'])->pluck('name')->first() ?? 'Tiada Rekod') : 'Tiada Rekod', 'Tarikh Kematian' => !empty($row["myid_tarikh_mati"]) ? Carbon\Carbon::parse($row["myid_tarikh_mati"])->format('d/m/Y') : '', 'Tarikh Kemaskini Rekod'=> !empty($row["myid_updated_at"]) ? Carbon\Carbon::parse($row["myid_updated_at"])->format('d/m/Y') : '', 'IC Pasangan' => $row['ic_pasangan'] ?? '', 'Nama Pasangan' => $row['nama_pasangan'] ?? '', 'Pendapatan Pasangan' => $row['pendapatan_pasangan'] ?? '', ]; @endphp
@foreach($columns as $column)
{{ $allColumns[$column] }}
@endforeach
@endforeach