{{ $clusters->display_name }}
Sila klik pada IPR yang anda ingin memohon dan untuk keterangan lanjut
@php
$model_skw = [];
$model_smue = [];
$model_tawas = [];
$model_sbap = [];
$pemohon = [];
$tunas = [];
@endphp
@foreach ($iprs as $ipr)
 }}{{ $ipr->name == 'kiss' || $ipr->name == 'sps' ? '?ver=3.0' : '' }})
@if ($ipr->status == 'Active')
@if ($ipr->name == 'sade')
@elseif ($ipr->name == 'bss' && count($model_bss) > 0)
@elseif ($ipr->name == 'skw' && count($model_skw) > 0)
@elseif ($ipr->name == 'smue' && count($model_smue) > 0)
@elseif ($ipr->name == 'iktisas')
@elseif ($ipr->name == 'sml')
@elseif ($ipr->name == 'danasel')
@elseif ($ipr->name == 'pto')
@elseif ($ipr->name == 'hpipt' && $wujud == true)
@elseif ($ipr->name == 'tawas' && count($model_tawas) > 0)
@elseif ($ipr->name =='sbap' && count($model_sbap) > 0)
@elseif ($ipr->name == 'ipb' && count($pemohon) > 0)
@elseif ($ipr->name == 'igems' && count($pemohon) > 0)
@elseif ($ipr->name == 'baucer' && count($pemohon) > 0)
@elseif ($ipr->name == 'ladang' && count($pemohon) > 0)
@elseif ($ipr->name == 'fi')
@elseif ($ipr->name == 'cukai')
@elseif ($ipr->name == 'tunas' && count($tunas) > 0)
@elseif ($ipr->name == 'rsku' && count($rsku_response) > 0)
@endif
@endif
@endforeach
{{ strtoupper($ipr->display_name) }}
{!! $ipr->description !!}
@if ($ipr->status == 'Active')
@if ($ipr->name == 'sade')
@php
$permohonan_sade = App\PermohonanSade::where('ic_pemohon', Auth::user()->username)->where('ipr_id', $ipr->id)->get();
@endphp
@if(count($permohonan_sade) > 0)
@foreach ($permohonan_sade as $permohonan)
@if($permohonan->status == -1)
DIBATALKAN
@elseif($permohonan->status == 0 || $permohonan->status == -1)
PERMOHONAN {{ ($permohonan->status==-1?'DIBATALKAN':($permohonan->status<=1?'DIPROSES':'')) }}
{{ ($permohonan->status==-1 || $permohonan->status==3)?'('.($permohonan->comments!=''?$permohonan->comments:'Tiada Sebab').')':'' }}
{{ ($permohonan->status==0 && $permohonan->comments!='')?'('.$permohonan->comments.')':'' }}
@elseif($permohonan->status == 2)
LULUS
@elseif(Auth::user()->profile->pendapatan > 5000)
@elseif($permohonan->status == 4)
@else
GAGAL
@endif
@if($permohonan->status == -1 || $permohonan->status == 3)
{{ $permohonan->comments }}
@if(Auth::user()->profile->pendapatan <= 6000)
@else
@endif
@endif
@endforeach
@elseif(Auth::user()->profile->pendapatan <= 6000)
DAFTAR
@else
@endif
@elseif ($ipr->name == 'kiss')
@php
$kiss = App\PermohonanKiss::where('id', '=', Auth::user()->id)->whereYear('created_at', date('Y'))->get();
$isOpen = "DAFTAR";
$timenow = Carbon\Carbon::now()->startOfDay();
// if ($ipr->tarikh_mula != null && $ipr->tarikh_akhir != null) {
// $tarikh_mula = Carbon\Carbon::parse($ipr->tarikh_mula)->startOfDay();
// $tarikh_akhir = Carbon\Carbon::parse($ipr->tarikh_akhir)->startOfDay();
// if ($tarikh_mula > $timenow) {
// $isOpen = "AKAN DATANG (" . \Carbon\Carbon::parse($ipr->tarikh_mula)->format('d/m/Y') . ")";
// } elseif ($timenow > $tarikh_akhir) {
// $isOpen = "PERMOHONAN DITUTUP (" . \Carbon\Carbon::parse($ipr->tarikh_akhir)->format('d/m/Y') . ")";
// }
// }
// elseif($ipr->tarikh_mula == null && $ipr->tarikh_akhir == null){
// $isOpen = "Akan Datang";
// }
@endphp
@php
$pasangan = App\Pasangan::where('ic_pemohon', Auth::user()->username)->first();
$anak = App\Anak::where('ic_pemohon', Auth::user()->username)->get();
$totalincome = (float)Auth::user()->profile->pendapatan;
$isEligible = true;
$isKidExits18 = false;
if ($pasangan) {
$totalincome = (float)$totalincome + (float)$pasangan->pendapatan;
}
if ($anak->count() > 0) {
foreach ($anak as $a) {
$totalincome = (float)$totalincome + (float)$a->pendapatan;
if($isKidExits18 == false) {
$from = new DateTime($a->tarikh_lahir);
$to = new DateTime('today');
$age = $from->diff($to)->y;
if($age < 18) {
$isKidExits18 = true;
}
}
}
}
if ($totalincome > 3000 || !$isKidExits18 || Auth::user()->profile->status_perkahwinan == 'Bujang') {
$isEligible = false;
}
$permohonan_kiss = App\PermohonanKiss::where('ic_pemohon', Auth::user()->username)->where('ipr_id', $ipr->id)->get();
@endphp
@if(count($permohonan_kiss) > 0)
@foreach ($permohonan_kiss as $permohonan)
@if($permohonan->status == 0)
PERMOHONAN DIPROSES
@elseif($permohonan->status == 1)
PERMOHONAN DIPROSES
@elseif($permohonan->status == 2)
LULUS
@elseif($permohonan->status == 5)
KAD SEDIA UNTUK DIAMBIL
@elseif($permohonan->status == 6)
KAD SUDAH DIAMBIL
@elseif(!$isEligible)
@else
TIDAK DILULUSKAN
@endif
@endforeach
@elseif(count($permohonan_kiss) == 0)
@if($isOpen != "DAFTAR")
MOHON
@else
{{-- DAFTAR ({{\Carbon\Carbon::parse($ipr->tarikh_mula)->format('d/m/Y')}} - {{\Carbon\Carbon::parse($ipr->tarikh_akhir)->format('d/m/Y')}}) --}}
MOHON
@endif
@endif
@elseif ($ipr->name == 'bbbr')
@php
$permohonan_bbbr = App\PermohonanBbbr::where('ic_pemohon', Auth::user()->username)->get();
@endphp
@if (count($permohonan_bbbr) > 0)
@foreach ($permohonan_bbbr as $permohonan)
@if($permohonan->status == 0)
PERMOHONAN DIPROSES
@elseif($permohonan->status == 1)
PERMOHONAN DIPROSES
@elseif($permohonan->status == 2)
LULUS
@else
GAGAL
@endif
@endforeach
@else
@php
$user = Auth::user()->profile->tarikh_lahir;
$years = Carbon\Carbon::parse($user)->age;
$profile_count = App\Profile::where('ic', Auth::user()->username)->count();
$totalincome_bbbr = (float)Auth::user()->profile->pendapatan;
$pasangan = App\Pasangan::where('ic_pemohon', Auth::user()->username)->first();
$anak = App\Anak::where('ic_pemohon', Auth::user()->username)->get();
if($pasangan) {
$totalincome_bbbr = (float)$totalincome_bbbr + (float)$pasangan->pendapatan;
}
if($anak->count() > 0) {
foreach ($anak as $a) {
$totalincome_bbbr = (float)$totalincome_bbbr + (float)$a->pendapatan;
}
}
@endphp
{{-- @if ($profile_count > 0 && $totalincome_bbbr <= 1500 &&
(Auth::user()->profile->status_perkahwinan == 'Berkahwin' || Auth::user()->profile->status_perkahwinan == 'Duda/Janda') &&
( ( Auth::user()->profile->jantina == 'lelaki' && Auth::user()->profile->pair() ) || (Auth::user()->profile->jantina == 'lelaki' && Auth::user()->profile->children() ) ) &&
Auth::user()->profile->tempoh_mastautin >= 15 &&
($years >= 45 && $years <= 75) )
DAFTAR
@else
@endif --}}
@endif
@elseif ($ipr->name == 'blueprint')
@if (count(App\PermohonanBlueprint::where('ic_pemohon', Auth::user()->username)->get()) > 0)
@foreach (App\PermohonanBlueprint::where('ic_pemohon', Auth::user()->username)->get() as $permohonan)
@if($permohonan->status_mohon == 0 || $permohonan->status_mohon == 1)
PERMOHONAN DIPROSES
@elseif($permohonan->status_mohon == 2)
LULUS
@else
GAGAL
@endif
@endforeach
@else
@php
$profile_count = App\Profile::where('ic', Auth::user()->username)->count();
$pasangan = App\Pasangan::where('ic_pemohon', Auth::user()->username)->first();
$totalincome_blueprint = (float)Auth::user()->profile->pendapatan;
if ($pasangan) {
$totalincome_blueprint = (float)$totalincome_blueprint + (float)$pasangan->pendapatan;
}
@endphp
{{-- @if ($profile_count > 0 && Auth::user()->profile->status_perkahwinan == 'Bujang' && Auth::user()->profile->pendapatan <= 2000 && Auth::user()->profile->tempoh_mastautin >= 10 )
DAFTAR
@elseif ($profile_count > 0 && Auth::user()->profile->status_perkahwinan == 'Berkahwin' && $totalincome_blueprint <= 3000 )
DAFTAR
@else
@endif --}}
@endif
@elseif ($ipr->name == 'ladang')
@php
$ic = Auth::user()->username;
//condition layak daftar baucar
$bangsa = Auth::user()->profile->bangsa;
$pendapatan = Auth::user()->profile->pendapatan;
$totalpendapatanpasangan = 0;
$pasangan = App\Pasangan::where('pasangan.ic_pemohon', '=', $ic)->get();
foreach ($pasangan as $data) {
$totalpendapatanpasangan = $totalpendapatanpasangan + $data->pendapatan;
}
if ($pasangan != null) {
$pendapatanpasangan = $totalpendapatanpasangan;
} else {
$pendapatanpasangan = 0;
}
$pendapatanisirumah = $pendapatanpasangan + $pendapatan;
$layak = false;
if ( ($bangsa == 'India') && ($pendapatanisirumah <= 2000))
{
$layak = true;
}
else
{
$layak = false;
}
@endphp
@if(count(App\PermohonanLadang::where('ic_pemohon', Auth::user()->username)->get()) > 0)
@foreach (App\PermohonanLadang::where('ic_pemohon', Auth::user()->username)->get() as $permohonan)
@if($permohonan->ipr_id == $ipr->id && $ipr->name == 'ladang')
@if($permohonan->status == 1)
PERMOHONAN DIPROSES
@elseif($permohonan->status == 2)
LULUS
@elseif($permohonan->status == 3)
GAGAL
@endif
@endif
@endforeach
@else
@if ($layak == true)
DAFTAR
@elseif ($layak == false)
@endif
@endif
@elseif ($ipr->name == 'tawas')
@php
$model_tawas = DB::connection('tawas')
->table('data_ssipr')
->leftJoin('dun', 'data_ssipr.dun_daftar', '=', 'dun.KOD_DUN')
->where('data_ssipr.b_kpBaru', Auth::user()->username)
->orWhere('data_ssipr.i_kpBaru', Auth::user()->username)
->get();
DB::disconnect('tawas');
@endphp
@if(count($model_tawas) > 0)
LIHAT PERMOHONAN
@else
@endif
@elseif ($ipr->name == 'ipb')
@php
$pemohon = DB::connection('ipb')
->select(
"SELECT
nama_pasangan,
nokp_pasangan,
nama_pemohon,
a.nomykad nokp_pemohon,
pejabat_dun,
tarikh_bac,
tkh_serahbank,
simpanan_serahan,
simpanan_SSP,
status_permohonan,
CASE WHEN status_permohonan = 'Baru' AND dokumen_xlengkap != '' THEN 'Dokumen Tidak Lengkap' ELSE
CASE WHEN status_permohonan = 'Baru' THEN 'Belum Disemak' ELSE
CASE WHEN status_permohonan = 'Ditolak' THEN 'Ditolak' ELSE
CASE WHEN status_permohonan = 'Diluluskan' THEN 'Diluluskan' ELSE
CASE WHEN status_permohonan = 'Disahkan' THEN 'Dalam Proses' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND simpanan_serahan != '0000-00-00' AND simpanan_SSP = 'BANK' THEN 'Sijil Simpanan Premium (SSP) BSN Boleh Dituntut Di Cawangan BSN berhampiran' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND simpanan_serahan != '0000-00-00' AND simpanan_SSP = 'YAWAS' THEN 'Sijil Simpanan Premium (SSP) BSN Boleh Dituntut Di Pejabat YAWAS' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND simpanan_serahan != '0000-00-00' AND simpanan_SSP IS NOT NULL THEN CONCAT('Sijil Simpanan Premium (SSP) BSN Boleh Dituntut Di Pejabat DUN ', simpanan_SSP) ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND DATE(tarikh_bac) != '0000-00-00' THEN 'Dalam Proses Penyediaan Sijil Simpanan Premium (SSP) BSN Kepada DUN' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND tkh_serahbank != '0000-00-00' THEN 'Dalam Proses Penyediaan Sijil Simpanan Premium (SSP) BSN Kepada Pihak Bank' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND DATE(tarikh_bac) = '0000-00-00' THEN 'Diluluskan' ELSE
CASE WHEN status_permohonan = 'Telah Dibayar' THEN 'Telah Dibayar'
END END END END END END END END END END END END `status`,
ulasan_status_permohonan,
dokumen_xlengkap,
lookup_tidak_lulus.id,
lookup_tidak_lulus.keterangan,
lookup_dokumen.id_dokumen,
lookup_dokumen.nama_dokumen
FROM permohonan a
LEFT JOIN kelulusan b ON b.nomykad=a.nomykad
LEFT JOIN lookup_tidak_lulus ON lookup_tidak_lulus.id=a.ulasan_status_permohonan
LEFT JOIN lookup_dokumen ON lookup_dokumen.id_dokumen=a.dokumen_xlengkap
WHERE a.nomykad = '".Auth::user()->username."' AND sumber_update!='N' ");
DB::disconnect('ipb');
if(count($pemohon)>0) {
$pasangan = DB::connection('ipb')
->select(
"SELECT
nama_pemohon,
a.nomykad nokp_pemohon,
pejabat_dun,
tarikh_bac,
tkh_serahbank,
simpanan_serahan,
simpanan_SSP,
status_permohonan,
CASE WHEN status_permohonan = 'Baru' AND dokumen_xlengkap != '' THEN 'Dokumen Tidak Lengkap' ELSE
CASE WHEN status_permohonan = 'Baru' THEN 'Belum Disemak' ELSE
CASE WHEN status_permohonan = 'Ditolak' THEN 'Ditolak' ELSE
CASE WHEN status_permohonan = 'Diluluskan' THEN 'Diluluskan' ELSE
CASE WHEN status_permohonan = 'Disahkan' THEN 'Dalam Proses' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND simpanan_serahan != '0000-00-00' AND simpanan_SSP = 'BANK' THEN 'Sijil Simpanan Premium (SSP) BSN Boleh Dituntut Di Cawangan BSN berhampiran' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND simpanan_serahan != '0000-00-00' AND simpanan_SSP = 'YAWAS' THEN 'Sijil Simpanan Premium (SSP) BSN Boleh Dituntut Di Pejabat YAWAS' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND simpanan_serahan != '0000-00-00' AND simpanan_SSP IS NOT NULL THEN CONCAT('Sijil Simpanan Premium (SSP) BSN Boleh Dituntut Di Pejabat DUN ', simpanan_SSP) ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND DATE(tarikh_bac) != '0000-00-00' THEN 'Dalam Proses Penyediaan Sijil Simpanan Premium (SSP) BSN Kepada DUN' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND tkh_serahbank != '0000-00-00' THEN 'Dalam Proses Penyediaan Sijil Simpanan Premium (SSP) BSN Kepada Pihak Bank' ELSE
CASE WHEN status_permohonan = 'Belum Dibayar' AND DATE(tarikh_bac) = '0000-00-00' THEN 'Diluluskan' ELSE
CASE WHEN status_permohonan = 'Telah Dibayar' THEN 'Telah Dibayar'
END END END END END END END END END END END END `status`,
ulasan_status_permohonan,
dokumen_xlengkap,
lookup_tidak_lulus.id,
lookup_tidak_lulus.keterangan,
lookup_dokumen.id_dokumen,
lookup_dokumen.nama_dokumen
FROM permohonan a
LEFT JOIN kelulusan b ON b.nomykad=a.nomykad
LEFT JOIN lookup_tidak_lulus ON lookup_tidak_lulus.id=a.ulasan_status_permohonan
LEFT JOIN lookup_dokumen ON lookup_dokumen.id_dokumen=a.dokumen_xlengkap
WHERE a.nomykad = '".$pemohon[0]->nokp_pasangan."' AND sumber_update!='N'"
);
DB::disconnect('ipb');
}
@endphp
@if(count($pemohon) <= 0)
@else
@endif
@elseif ($ipr->name == 'smue')
@php
$model_smue = DB::connection('smue')->table('maklumat_ahli')
->where('maklumat_ahli.no_kp', Auth::user()->username)
->leftJoin('shopping_peserta', function($join) {
$join->on('shopping_peserta.id_ahli', '=', 'maklumat_ahli.id_ahli');
})
->leftJoin('shopping_program', function($join) {
$join->on('shopping_program.id_program', '=', 'shopping_peserta.id_program');
})
->leftJoin('penerima_jasamu', function($join) {
$join->on('penerima_jasamu.no_kp_baru', '=', 'maklumat_ahli.no_kp');
})
->get();
DB::disconnect('smue');
$jomshopping_manfaat = null;
if (count($model_smue) > 0) {
$base_url = 'http://e-manfaat.yawas.my/api';
$api_key = md5(base64_encode('secure'));
$call = $base_url."?action=get_maklumat_ahli&id_ahli=".$model_smue[0]->id_ahli."&api_key={$api_key}";
$response = file_get_contents($call);
$response = json_decode($response, true);
if($response['status'] == 'ok') {
$jomshopping_manfaat = $response;
}
}
$jangka_hadir = isset($jomshopping_manfaat) ? $jomshopping_manfaat : '';
$tempohmastautin = Auth::user()->profile->tempoh_mastautin;
$user = Auth::user()->profile->tarikh_lahir;
$years = Carbon\Carbon::parse($user)->age;
@endphp
@if(count($model_smue) > 0)
LIHAT PERMOHONAN
@elseif(count($model_smue) <= 0 && $years >= 60 && $tempohmastautin >= 15)
@else
@endif
@elseif ($ipr->name == 'hpipt')
@php
$id = Auth::user()->username;
$client = new GuzzleHttp\Client(['http_errors' => false]);
$wujud = false;
try {
$get_token = $client->request('GET', 'http://58.27.97.33/api/jwt', ['connect_timeout' => 15]);
$authApiResponse = $get_token->getBody()->getContents();
$access_token = $authApiResponse;
$headers = ['Authorization' => 'Bearer ' . $access_token, 'Accept' => 'application/json',];
$response = $client->request('GET', 'http://58.27.97.33/api/permohonan', ['headers' => $headers, ['connect_timeout' => 15]]);
$model = json_decode($response->getBody()->getContents(), true);
if ($model) {
foreach($model as $item) {
if($item["pt2_no_kp_pemohon"] == $id) {
if($item["pelulus_stat"] == '4001') {
$wujud = true;
$dataget = $item;
}else{
$wujud = true;
$dataget = $item;
}
}
}
}
} catch (Exception $e) {}
$income = Auth::user()->profile->pendapatan;
$mastautin = Auth::user()->profile->tempoh_mastautin;
$negeri = Auth::user()->profile->negeri;
@endphp
@if($wujud != true && $income <= 5000 && $mastautin >= 11 && $negeri == 'Selangor')
DAFTAR
@elseif($wujud == true)
@else
Tidak Layak
@endif
@elseif ($ipr->name == 'iktisas')
@elseif ($ipr->name == 'fi')
@php
$tahun = date("Y");
$data = App\Taksiran::where('taksiran.tahun', '=', $tahun)
->where('taksiran.status_audit', '=', 1)
->where('taksiran.ipr_id', '=', 20)
->select(
'taksiran.tahun',
'taksiran.kkr_pegangan',
'taksiran.kkr_taksiran',
'taksiran.status_audit',
'taksiran.pbt_id',
'm.kod as pbt_kod',
'm.nama as pbt_nama',
'm.status_audit as pbt_audit',
)
->leftJoin('pbt as m', 'm.id', '=', 'taksiran.pbt_id')
->orderBy('m.id')
->get();
@endphp
@elseif ($ipr->name == 'cukai')
@php
$tahun = date("Y");
$data = DB::connection()
->table('taksiran')
->where('taksiran.tahun', '=', $tahun)
->where('taksiran.status_audit', '=', 1)
->where('taksiran.ipr_id', '=', 21)
->select(
'taksiran.tahun',
'taksiran.kkr_pegangan',
'taksiran.kkr_taksiran',
'taksiran.kk_pegangan',
'taksiran.kk_taksiran',
'taksiran.status_audit',
'taksiran.pbt_id',
'm.kod as pbt_kod',
'm.nama as pbt_nama',
'm.status_audit as pbt_audit',
)
->leftJoin('pbt as m', 'm.id', '=', 'taksiran.pbt_id')
->orderBy('m.id')
->get();
@endphp
@elseif ($ipr->name == 'mikro')
@php
$layak = false;
$permohonan = App\PermohonanMikro::where('ic_pemohon', '=', Auth::user()->username)->get();
if(count($permohonan) == 0) {
$mastautin = Auth::user()->profile->tempoh_mastautin;
$borndate = Auth::user()->profile->tarikh_lahir;
$umur = Carbon\Carbon::parse($borndate)->age;
}
if (count($permohonan) <= 0 && $mastautin >= 10 && $umur <= 55 && $umur >= 18){
$layak = true;
}
@endphp
@if(count($permohonan) != 0)
@if($permohonan[0]->status == 0 || $permohonan[0]->status == 1)
PERMOHONAN DIPROSES
@elseif($permohonan[0]->status == 2)
LULUS
@elseif($permohonan[0]->status == 3)
Gagal
@endif
{{-- @elseif($layak == true)
DAFTAR
@elseif($layak == false)
Tidak Layak
--}}
@else
Mohon di Pejabat Daerah Terdekat
@endif
@if(count($permohonan) != 0)
@endif
@elseif ($ipr->name == 'sitec')
@php
$layak = false;
$permohonan = App\PermohonanSitec::where('ic_pemohon', '=', Auth::user()->username)->get();
if(count($permohonan) == 0) {
$layak = true;
}
@endphp
@if (count($permohonan) != 0)
@if($permohonan[0]->status == 0 || $permohonan[0]->status == 1)
PERMOHONAN DIPROSES
@elseif($permohonan[0]->status == 2)
LULUS
@elseif($permohonan[0]->status == 3)
Gagal
@endif
@elseif ($layak == true)
DAFTAR
@elseif ($layak == false)
Tidak Layak
@endif
@if (count ($permohonan) != 0)
@endif
@elseif ($ipr->name == 'sewa')
@php
$layak = false;
$permohonan = App\PermohonanSewa::where('ic_pemohon', '=', Auth::user()->username)->get();
$totalpendapatanpasangan = 0;
$ic = Auth::user()->username;
$pasangan = App\Pasangan::where('pasangan.ic_pemohon', '=', $ic)->get();
foreach ($pasangan as $data) {
$totalpendapatanpasangan = $totalpendapatanpasangan + $data->pendapatan;
}
if (count($permohonan) == 0) {
$pendapatan = Auth::user()->profile->pendapatan;
$borndate = Auth::user()->profile->tarikh_lahir;
$umur = Carbon\Carbon::parse($borndate)->age;
if ($pasangan != null) {
$pendapatanpasangan = $totalpendapatanpasangan;
} else {
$pendapatanpasangan = 0;
}
$pendapatanisirumah = $pendapatanpasangan + $pendapatan;
if (count($permohonan) <= 0 && $pendapatanisirumah <= 15000 && count($pasangan) >= 0 && $umur >= 18) {
$layak = true;
}
}
@endphp
@if (count($permohonan) != 0)
@if($permohonan[0]->status == 0)
PERMOHONAN DIPROSES
@elseif($permohonan[0]->status == 1)
PERMOHONAN DIPROSES
@elseif($permohonan[0]->status == 2)
PERMOHONAN LULUS
@elseif($permohonan[0]->status == 3)
PERMOHONAN GAGAL
@endif
@elseif ($layak)
DAFTAR
@else
Tidak Layak
@endif
@elseif ($ipr->name == 'ceria')
@php
$layak = false;
$permohonan = App\PermohonanCeria::where('nama_pengurusan', '=', Auth::user()->name)->get();
if (count($permohonan) <= 0){
$layak = true;
}
@endphp
@if(count($permohonan) != 0)
@if($permohonan[0]->status == 0)
DALAM PROSES
@elseif($permohonan[0]->status == 1)
PERMOHONAN LULUS
@elseif($permohonan[0]->status == 2)
PERMOHONAN GAGAL
@elseif($permohonan[0]->status == 3)
PERMOHONAN TIDAK LENGKAP
@endif
@elseif ($layak)
{{--
DAFTAR
--}}
DAFTAR
@else
Tidak Layak
@endif
@elseif ($ipr->name == 'hijrah')
@php
if (App::environment('local')) {
$hijrah = DB::connection('hijrah')->table('I_Peserta')
->leftJoin('I_Peserta_Daftar_Pinjaman', 'I_Peserta_Daftar_Pinjaman.NoKP_Peserta', '=', 'I_Peserta.NoKP_Peserta')
->where('I_Peserta_Daftar_Pinjaman.NoKP_Peserta', Auth::user()->username)
->first();
}
if (App::environment('PRODUCTION')) {
$hijrah = DB::connection('hijrah')->table('I_Peserta')
->leftJoin('I_Peserta_Daftar_Pembiayaan', 'I_Peserta_Daftar_Pembiayaan.NoKP_Peserta', '=', 'I_Peserta.NoKP_Peserta')
->where('I_Peserta_Daftar_Pembiayaan.NoKP_Peserta', Auth::user()->username)
->first();
}
@endphp
@if($hijrah == null)
@if (Carbon\Carbon::parse(Auth::user()->profile->tarikh_lahir)->age >= 18 && Carbon\Carbon::parse(Auth::user()->profile->tarikh_lahir)->age <= 60 )
DAFTAR
@else
@endif
@else
@if( $hijrah->Status_Pinjaman == 1)
PERMOHONAN DIPROSES
@elseif( $hijrah->Status_Pinjaman == 2)
@elseif( $hijrah->Status_Pinjaman == 3)
@elseif( $hijrah->Status_Pinjaman == 4)
@elseif( $hijrah->Status_Pinjaman == 5)
@elseif( $hijrah->Status_Pinjaman == 6)
@elseif( $hijrah->Status_Pinjaman == 7)
@elseif( $hijrah->Status_Pinjaman == 8)
@elseif( $hijrah->Status_Pinjaman == 9)
@elseif( $hijrah->Status_Pinjaman == 10)
BATAL (MAKLUMAT SALAH)
@if($hijrah->Status_Pinjaman == 10)
{{ $hijrah->Ulasan_Pegawai }}
@if (Carbon\Carbon::parse(Auth::user()->profile->tarikh_lahir)->age >= 18 && Carbon\Carbon::parse(Auth::user()->profile->tarikh_lahir)->age <= 60 )
DAFTAR SEMULA
@else
@endif
@endif
@endif
@endif
@elseif ($ipr->name == 'bkm')
@php
// TODO tukar table kepada bkm
$layak = false;
$permohonan = App\PermohonanBkm::where('no_kp', '=', Auth::user()->username)->where('ipr_id', '=', $ipr->id)->get();
if (count($permohonan) <= 0){
$layak = true;
}
@endphp
@if(count($permohonan) != 0)
@if($permohonan[0]->status == 0)
DALAM PROSES
@elseif($permohonan[0]->status == 2)
PERMOHONAN LULUS
@elseif($permohonan[0]->status == 3)
PERMOHONAN GAGAL
@endif
@elseif ($layak)
DAFTAR
@else
Tidak Layak
@endif
@if(count($permohonan) != 0)
@endif
@elseif ($ipr->name == 'siswa')
@php
$layak = false;
$permohonan = App\PermohonanSiswa::where('ic_pemohon', '=', Auth::user()->username)->where('ipr_id', '=', $ipr->id)->get();
if (count($permohonan) <= 0){
$layak = true;
}
@endphp
@if(count($permohonan) != 0)
@if($permohonan[0]->status == 0)
DALAM PROSES
@elseif($permohonan[0]->status == 2)
PERMOHONAN LULUS
@elseif($permohonan[0]->status == 3)
PERMOHONAN GAGAL
@endif
@elseif ($layak)
DAFTAR
@else
Tidak Layak
@endif
@if(count($permohonan) != 0)
@endif
@elseif ($ipr->name == 'sml')
@php
$layak = false;
$permohonan = DB::connection('sml')->table('PATRON')->where('DRIVERS_LICENSE_NUMBER', '=', Auth::user()->username)->get();
if (count($permohonan) <= 0){
$layak = true;
}
@endphp
@if(count($permohonan) != 0)
{{-- @if($permohonan[0]->status == 0 || $permohonan[0]->status == 1 || $permohonan[0]->status == 2 || $permohonan[0]->status == 3) --}}
{{-- --}}
{{-- @endif --}}
@elseif ($layak)
PERMINTAAN PROGRAM
@else
Tidak Layak
@endif
@if (count ($permohonan) != 0 || ($layak))
DAFTAR
@endif
@if (count ($permohonan) != 0 || ($layak))
JADUAL
@endif
@elseif ($ipr->name == 'bas' || $ipr->name == 'wifi')
PAPARAN PETA
@elseif ($ipr->name == 'ptrs')
PAPARAN LOKASI SEKOLAH
@elseif ($ipr->name == 'igems')
@php
$id = Auth::user()->username;
$pemohon = DB::connection('ipb')
->table('gems_ahli')
->where(function ($query) use ($id) {
$query->orWhere ( 'gems_ahli.kp_pm', 'LIKE', '%' . $id . '%' );
})
->orWhere ( 'gems_ahli.kp_ps', 'LIKE', '%' . $id . '%' )
->select(
'gems_ahli.nama_pm',
'gems_ahli.id_ahli',
'gems_ahli.kp_pm',
'gems_ahli.dun',
'gems_ahli.status_pm',
'gems_ahli.status_ps',
'gems_ahli.nama_ps',
'gems_ahli.kp_ps',
'gems_ahli.dun',
'gems_ahli.emel',
'gagal_pm', // multiple reason
'gagal_ps', // multiple reason
'gems_kursus.tarikh as tarikh_kursus',
'gems_kursus.tempat as tempat_kursus',
'gems_kursus.daerah as daerah_kursus',
'gems_kursus.time_start as start_kursus',
'gems_kursus.time_end as end_kursus',
'gp.pengesahan'
)
->leftJoin('gems_kursus', 'gems_kursus.id', '=', 'gems_ahli.id_kursus')
->leftJoin('gems_peserta as gp', 'gp.id_ahli', '=', 'gems_ahli.id_ahli')
->get();
DB::disconnect('ipb');
if (count($pemohon) > 0){
$id_pemohon = $pemohon[0]->id_ahli;
$kursus = DB::connection('ipb')
->table('gems_peserta')
->where('gems_peserta.id_ahli', '=', $id_pemohon)
->select(
'm.daerah',
'm.tarikh',
'm.time_start',
'm.time_end',
'm.tempat'
)
->leftJoin('gems_kursus as m', 'm.id', '=', 'gems_peserta.id_kursus')
->first();
DB::disconnect('ipb');
}
$makluman = DB::connection('ipb')->table('gems_l_semakan')->get();
DB::disconnect('ipb');
$id = DB::connection('ipb')->table('gems_l_semakan')->get();
DB::disconnect('ipb');
$mastautin = Auth::user()->profile->tempoh_mastautin;
$borndate = Auth::user()->profile->tarikh_lahir;
$umur = Carbon\Carbon::parse($borndate)->age;
$status = Auth::user()->profile->status_perkahwinan;
$layak = false;
if ($mastautin >= 10 && $umur <= 40 && $status == 'Berkahwin') {
$layak = true;
}
@endphp
@if (count($pemohon) <= 0 && $layak == true)
DAFTAR
@elseif(count($pemohon) <= 0 && $layak == false)
@endif
@if(count($pemohon) > 0)
LIHAT PERMOHONAN
@endif
@elseif ($ipr->name == 'baucer')
@php
$ic = Auth::user()->username;
$pemohon = App\PermohonanBaucer::where('permohonan_baucer.ic_pemohon', '=', $ic)
->select(
'permohonan_baucer.ic_pemohon',
'permohonan_baucer.status',
'permohonan_baucer.dun',
'permohonan_baucer.alasan',
'permohonan_baucer.tahun_permohonan',
'm.nama as dun_nama',
'p.nama as nama',
'p.email as email',
'p.tel_bimbit as tel_bimbit',
'p.status_perkahwinan as status_perkahwinan',
'p.pendapatan as pendapatan',
'p.negerikelahiran as negerikelahiran',
'p.bangsa as bangsa',
'p.jantina as jantina',
'p.tarikh_lahir as tarikh_lahir',
'ps.pendapatan as pendapatan_pasangan'
)
->leftJoin('pasangan as ps', 'ps.ic_pemohon', '=', 'permohonan_baucer.ic_pemohon')
->leftJoin('s_adun as m', 'm.id', '=', 'permohonan_baucer.dun')
->leftJoin('profile as p', 'p.ic', '=', 'permohonan_baucer.ic_pemohon')
->get();
$totalpendapatanpasangan = 0;
$pasangan = App\Pasangan::where('pasangan.ic_pemohon', '=', $ic)->get();
foreach ($pasangan as $data) {
$totalpendapatanpasangan = $totalpendapatanpasangan + $data->pendapatan;
}
// cross check with SMUE
$model_smue = DB::connection('smue')->table('maklumat_ahli')
->where('maklumat_ahli.no_kp', Auth::user()->username)
->leftJoin('shopping_peserta', function($join) {
$join->on('shopping_peserta.id_ahli', '=', 'maklumat_ahli.id_ahli');
})
->leftJoin('shopping_program', function($join) {
$join->on('shopping_program.id_program', '=', 'shopping_peserta.id_program');
})
->leftJoin('penerima_jasamu', function($join) {
$join->on('penerima_jasamu.no_kp_baru', '=', 'maklumat_ahli.no_kp');
})
->get()->toArray();
DB::disconnect('smue');
foreach ($model_smue as $pemohon_smue) {
$model_smue[] = $pemohon_smue->no_kp;
}
if (in_array(Auth::user()->username, $model_smue)) {
$model_smue = true;
} else {
$model_smue = false;
}
// cross check with kiss
$model_kiss = false;
if (App\PermohonanKiss::where('permohonan_kiss.ic_pemohon', Auth::user()->username)->whereIn('status', [0, 1, 2])->exists()) {
$model_kiss = true;
}
//condition layak daftar baucar
$bangsa = Auth::user()->profile->bangsa;
$pendapatan = Auth::user()->profile->pendapatan;
// cross check with family
$get_pasangan = App\Pasangan::where('ic_pasangan', Auth::user()->username)->get();
$get_anak = App\Anak::where('ic_anak', Auth::user()->username)->get();
if (!empty($get_pasangan)) {
$get_pasangan = false;
} else {
$get_pasangan = true;
}
if (!empty($get_anak)) {
$get_anak = false;
} else {
$get_anak = true;
}
if ($pasangan != null) {
$pendapatanpasangan = $totalpendapatanpasangan;
} else {
$pendapatanpasangan = 0;
}
$pendapatanisirumah = $pendapatanpasangan + $pendapatan;
$layak = false;
if (($bangsa == 'Melayu' || $bangsa == 'Cina' || $bangsa == 'India') && $pendapatanisirumah <= 2000 && !$get_pasangan && !$get_anak && !$model_smue && !$model_kiss) {
$layak = true;
}
// reset permohonan if year !=
// check rakyat profile with whether have permohonan
$profile = App\Profile::leftJoin('permohonan_baucer', 'profile.ic', '=', 'permohonan_baucer.ic_pemohon')
->where('ic', '=', Auth::user()->username)
->first();
if ($profile->exists()) {
// get kuota
$kuota = App\Kuota::where('kuota_ipr_id', $ipr->id)
->where('kuota_dun_id', $profile->dun)
->where('status_kuota', 1)
->first(['id', 'tahun', 'kuota']);
// get tahun permohonan
$tahun_mohon = App\PermohonanBaucer::where('dun', $profile->dun)
->where('ic_pemohon', $profile->ic_pemohon)
->where('status', $profile->status)
->where('status_audit', 1)
->first();
}
@endphp
@if ($tahun_mohon != null)
@if(count($pemohon) > 0 && $kuota && $tahun_mohon->tahun_permohonan == $kuota->tahun)
@if($pemohon[0]->status == 0 || $pemohon[0]->status == 1)
PERMOHONAN DIPROSES
@elseif($pemohon[0]->status == 2)
LULUS
@elseif($pemohon[0]->status == -1)
DIBATALKAN
@elseif($pemohon[0]->status == 3)
GAGAL
@else
DAFTAR
@endif
@if ($layak == true && $kuota->tahun == Carbon\Carbon::now()->format('Y'))
DAFTAR
@elseif ($layak == true && $tahun_mohon->tahun_permohonan != $kuota->tahun)
@endif
@elseif(count($pemohon) > 0)
@if($pemohon[0]->status == 0 || $pemohon[0]->status == 1)
PERMOHONAN DIPROSES
@elseif($pemohon[0]->status == 2)
LULUS
@elseif($pemohon[0]->status == 3)
GAGAL
@else
DAFTAR
@endif
@elseif ($layak == true && $kuota->tahun == Carbon\Carbon::now()->format('Y'))
DAFTAR
@elseif ($layak == false)
@elseif ($layak == true && $tahun_mohon->tahun_permohonan != $kuota->tahun)
@endif
@else
@if ($layak == true)
DAFTAR
@elseif ($layak == false)
@endif
@endif
@elseif ($ipr->name == 'pto' || $ipr->name == 'danasel')
@elseif ($ipr->name == 'rsku')
@php
try{
$ic = substr_replace(substr_replace(Auth::user()->username, '-', 6, 0), '-', 9, 0);
$client = new GuzzleHttp\Client(['http_errors' => false]);
$url = $ipr->api.$ic;
$result = $client->request('GET', $url, ['timeout' => 10]);
$rsku_response = json_decode($result->getBody()->getContents());
}catch(\Exception $e){
$rsku_response = json_decode('[]');
}
@endphp
@if($rsku_response)
@if($rsku_response[0]->permohonan_status == 'Tidak Layak')
@elseif($rsku_response[0]->permohonan_status == 'Layak')
@else
@endif
@else
DAFTAR
@endif
@elseif ($ipr->name == 'skw')
@php
$ic = Auth::user()->username;
$model_skw = DB::connection('skw')
->select("SELECT maklumat_pemohon.PemohonID, maklumat_pemohon.Nama, maklumat_pemohon.NoKPBaru,
maklumat_pemohon.NoKPLama, maklumat_pemohon.NoTel no_tel_pemohon,
maklumat_pemohon.NamaWaris, maklumat_pemohon.NoTelWaris,
maklumat_pemohon.Pekerjaan, maklumat_pemohon.Alamat1, maklumat_pemohon.Alamat2,
maklumat_pemohon.Poskod, maklumat_pemohon.Bandar, maklumat_pemohon.Daerah, maklumat_pemohon.StatusPermohonan, maklumat_pemohon.CreatedDate,
maklumat_pemeriksaan.TarikhPemeriksaan, maklumat_pemeriksaan.JenisPemeriksaan, maklumat_pemeriksaan.Kehadiran hadir,
lookup_operator.NamaOperator,
dun.KOD_DUN, dun.NAMA_DUN, pemohon.NoReg,
pemohon.Operator operator_name, pemohon.TarikhPemeriksaan checkup_date, pemohon.JenisPemeriksaan checkup_type
FROM yawasadmin_skw.maklumat_pemohon
LEFT JOIN yawasadmin_skw.maklumat_pemeriksaan
ON maklumat_pemohon.PemohonID = maklumat_pemeriksaan.PemohonID
LEFT JOIN yawasadmin_skw.lookup_operator
ON maklumat_pemeriksaan.OperatorID = lookup_operator.OperatorID
LEFT JOIN yawasadmin_skw.dun
ON maklumat_pemohon.Dun = dun.KOD_DUN
LEFT JOIN yawasadmin_skw.pemohon
ON maklumat_pemohon.NoKPBaru = pemohon.NoKP
WHERE maklumat_pemohon.NoKPBaru = $ic;");
DB::disconnect('skw');
$user = Auth::user()->profile->tarikh_lahir;
$years = Carbon\Carbon::parse($user)->age;
@endphp
@if (count($model_skw) > 0)
@elseif ($years >= 50 && Auth::user()->profile->jantina == 'perempuan' && Auth::user()->profile->tempoh_mastautin >= 10)
DAFTAR
@else
@endif
@elseif ($ipr->name == 'sps')
@php
$status = false;
$client = new GuzzleHttp\Client(['http_errors' => false]);
$domain = Config::get('iprapi.sps.domain');
$authapi = Config::get('iprapi.sps.auth_api');
$params = [
'form_params' => [
'username' => Config::get('iprapi.sps.username'),
'password' => Config::get('iprapi.sps.password')
]
];
try {
$authApiResponse = $client->post($domain.$authapi, $params);
$authApiResponse = json_decode($authApiResponse->getBody()->getContents(), true);
$access_token = $authApiResponse['access_token'];
$headers = [
'Authorization' => 'Bearer ' . $access_token,
'Accept' => 'application/json',
];
$checkStatusApi = Config::get('iprapi.sps.check-status').'?id_no='.Auth::user()->username;
$checkStatusApiResponse = $client->get($domain.$checkStatusApi,[
'headers' => $headers
]);
$status = json_decode($checkStatusApiResponse->getBody()->getContents());
} catch (Exception $e) {}
$pasangan = App\Pasangan::where('ic_pemohon', Auth::user()->username)->first();
$anak = App\Anak::where('ic_pemohon', Auth::user()->username)->get();
$totalincome = (float)Auth::user()->profile->pendapatan;
$isEligible = true;
$isKidExits21 = false;
if ($pasangan) {
$totalincome = (float)$totalincome + (float)$pasangan->pendapatan;
}
if ($anak->count() > 0) {
foreach ($anak as $a) {
$totalincome = (float)$totalincome + (float)$a->pendapatan;
if($isKidExits21 == false) {
$from = new DateTime($a->tarikh_lahir);
$to = new DateTime('today');
$age = $from->diff($to)->y;
if($age < 21) {
$isKidExits21 = true;
}
}
}
}
@endphp
@if ($status)
@if($status->code == 404)
@if(((Auth::user()->profile->status_perkahwinan) == 'Bujang'))
@if((($totalincome) <= 1500) && (\Carbon\Carbon::parse(Auth::user()->profile->tarikh_lahir)->age) >= 21 && Auth::user()->profile->tempoh_mastautin >= 10 && Auth::user()->profile->negeri == 'Selangor')
DAFTAR
@else
@endif
@elseif(((Auth::user()->profile->status_perkahwinan) == 'Duda/Janda'))
@if($totalincome <= 2000 && Auth::user()->profile->tempoh_mastautin >= 10 && Auth::user()->profile->negeri == 'Selangor')
DAFTAR
@else
@endif
@else
@if($totalincome <= 2000 && Auth::user()->profile->tempoh_mastautin >= 10 && Auth::user()->profile->negeri == 'Selangor')
DAFTAR
@else
@endif
@endif
@else
@if($status->status == 'Beneficiary exists - Active')
Permohonan anda telah diluluskan. Sila hubungi pusat panggilan kami di talian +603 5525 6600
@elseif($status->status == 'Beneficiary is found - INACTIVE ')
Dukacita permohonan anda tidak berjaya. Harap maaf. Untuk maklumat lanjut, Sila hubungi pusat panggilan kami di talian 1800226600.
@elseif($status->status == 'Beneficiary is found - DELETED ')
Dukacita permohonan anda dihapuskan. Harap maaf. Untuk maklumat lanjut, Sila hubungi pusat panggilan kami di talian 1800226600.
@elseif($status->status == 'Beneficiary is found - PENDING ')
Permohonan anda sedang diproses. Status akan dimaklumkan kelak.
@elseif($status->status == 'Beneficiary is found - VERIFIED ')
Permohonan anda telah disahkan. Status akan dimaklumkan kelak.
@elseif($status->status == 'Beneficiary is found - REJECTED ')
Dukacita permohonan anda tidak berjaya. Harap maaf. Untuk maklumat lanjut, Sila hubungi pusat panggilan kami di talian 1800226600.
@elseif($status->status == 'Beneficiary is found - SUSPENDED ')
Dukacita permohonan anda digantung. Harap maaf. Untuk maklumat lanjut, Sila hubungi pusat panggilan kami di talian 1800226600.
@else
None
@endif
@endif
@else
@if(((Auth::user()->profile->status_perkahwinan) == 'Bujang'))
@if((($totalincome) <= 1500) && (\Carbon\Carbon::parse(Auth::user()->profile->tarikh_lahir)->age) >= 21 && Auth::user()->profile->tempoh_mastautin >= 10)
DAFTAR
@else
@endif
@elseif(((Auth::user()->profile->status_perkahwinan) == 'Duda/Janda'))
@if($totalincome <= 2000 && Auth::user()->profile->tempoh_mastautin >= 10)
DAFTAR
@else
@endif
@else
@if($totalincome <= 2000 && Auth::user()->profile->tempoh_mastautin >= 10)
DAFTAR
@else
@endif
@endif
@endif
@elseif ($ipr->name == 'bss')
@php
$ic = Auth::user()->username;
$pasangan = App\Pasangan::where('ic_pemohon', Auth::user()->username)->first();
$anak = App\Anak::where('ic_pemohon', Auth::user()->username)->get();
$totalincome = (float)Auth::user()->profile->pendapatan;
if($pasangan) {
$totalincome = (float)$totalincome + (float)$pasangan->pendapatan;
}
if($anak->count() > 0) {
foreach ($anak as $a) {
$totalincome = (float)$totalincome + (float)$a->pendapatan;
}
}
try {
$model_bss = DB::connection('bss')->table('smart_sihat.person_profile')
->whereIn('person_profile.PERS_ROLES', ['APPLICANT', 'KIN'])
->where('person_profile.PERS_IC', Auth::user()->username)
->leftJoin('person_application', 'person_profile.PERS_ID', '=', 'person_application.APPL_PERS_ID')
->get();
$profile_bss = DB::connection('bss')->table('smart_sihat.person_profile')
->leftJoin('lkp_daerah_dun', function($join)
{
$join->on('person_profile.PERS_DUN_ID', '=', 'lkp_daerah_dun.DUN_ID');
})
->leftJoin('lkp_daerah', function($join)
{
$join->on('person_profile.PERS_DAERAH_ID', '=', 'lkp_daerah.DAERAH_ID');
})
->leftJoin('lkp_marriage', function($join)
{
$join->on('person_profile.PERS_MARRIAGE_STATUS', '=', 'lkp_marriage.MARRIAGE_ID');
})
->leftJoin('lkp_race', function($join)
{
$join->on('person_profile.PERS_RACE', '=', 'lkp_race.RACE_ID');
})
->leftJoin('person_address', function($join)
{
$join->on('person_profile.PERS_ID', '=', 'person_address.ADDR_PERS_ID');
})
->leftJoin('lkp_poscode', function($join)
{
$join->on('person_address.ADDR_POSCODE', '=', 'lkp_poscode.POSCODE_ID');
})
->leftJoin('person_job', function($join)
{
$join->on('person_profile.PERS_ID', '=', 'person_job.JOB_PERS_ID');
})
->leftJoin('lkp_job_type', function($join)
{
$join->on('person_job.JOB_TYPE', '=', 'lkp_job_type.JOB_TYPE_ID');
})
->leftJoin('person_income', function($join)
{
$join->on('person_profile.PERS_ID', '=', 'person_income.INCOME_PERS_ID');
})
->select('*')
->where('person_profile.PERS_ROLES', '=', 'APPLICANT')
->where('person_profile.PERS_IC', '=', $ic)
->get();
$tanggungan = DB::connection('bss')->table('smart_sihat.person_profile')
->leftJoin('person_tanggungan', function($join)
{
$join->on('person_profile.PERS_ID', '=', 'person_tanggungan.TANGGUNG_PERS_ID');
})
->where('person_profile.PERS_IC', '=', $ic)
->selectRaw('TANGGUNG_ID, TANGGUNG_PERS_ID, TANGGUNG_NAME, TANGGUNG_IC, TANGGUNG_GENDER, TANGGUNG_RELATION, TANGGUNG_IS_OKU')
->get();
$bantuan = DB::connection('bss')->table('smart_sihat.person_bantuan')
->leftJoin('person_bantuan_details', function($join)
{
$join->on('person_bantuan.APPL_BANTUAN_ID', '=', 'person_bantuan_details.BANTUAN_DETAILS_APPL_BANTUAN_ID');
})
->leftJoin('lkp_bantuan', function($join)
{
$join->on('person_bantuan_details.BANTUAN_DETAILS_BANTUAN_ID', '=', 'lkp_bantuan.BANTUAN_ID');
})
->where('person_bantuan.APPL_BANTUAN_PERS_ID', '=', $profile_bss[0]->PERS_ID)
->get();
$permohonan_bss = DB::connection('bss')->table('smart_sihat.person_application')
->leftJoin('lkp_help', function($join)
{
$join->on('person_application.APPL_HELP_ID', '=', 'lkp_help.HELP_ID');
})
->leftJoin('payment', function($join)
{
$join->on('person_application.APPL_ID', '=', 'payment.PAYMENT_APPL_ID');
})
->leftJoin('medical_center', function($join)
{
$join->on('person_application.APPL_MC_ID', '=', 'medical_center.MC_ID');
})
->leftJoin('person_application_progress', function($join)
{
$join->on('person_application.APPL_ID', '=', 'person_application_progress.APPL_PRO_APPL_ID');
})
->leftJoin('person_application_rejected', function($join)
{
$join->on('person_application_progress.APPL_PRO_ID', '=', 'person_application_rejected.PAR_APPL_PRO_ID');
})
->leftJoin('lkp_rejected', function($join)
{
$join->on('person_application_rejected.PAR_REJECTED_ID', '=', 'lkp_rejected.LKP_REJECTED_ID');
})
->leftJoin('person_application_ncomplete', function($join)
{
$join->on('person_application_progress.APPL_PRO_ID', '=', 'person_application_ncomplete.PAN_APPL_PRO_ID');
})
->leftJoin('lkp_notcomplete', function($join)
{
$join->on('person_application_ncomplete.PAN_NCOMPLETE_ID', '=', 'lkp_notcomplete.LKP_NCOMPLETE_ID');
})
->leftJoin('person_application_progress_update', function($join)
{
$join->on('person_application_progress.APPL_PRO_ID', '=', 'person_application_progress_update.PAPU_APPL_PRO_ID');
})
->where('person_application.APPL_PERS_ID', '=', $profile_bss[0]->PERS_ID)
->get();
} catch (Exception $e) {
$model_bss = [];
}
@endphp
@if(count($model_bss) > 0)
@elseif(count($model_bss) == 0 && $totalincome <= 3000 && Auth::user()->profile->tempoh_mastautin >= 10)
DAFTAR
@else
@endif
@elseif ($ipr->name == 'sbap')
@php
$get_ic = Auth::user()->username;
$model_sbap = DB::connection('sbap')
->select("SELECT maklumat_pembayaran_taska.StatusBayaran,
maklumat_pembayaran_taska.TarikhBayaran, maklumat_pembayaran_anak.YuranDibayar,
maklumat_pembayaran_anak.BulanBayaran, maklumat_taska_anak.StatusPermohonan,
maklumat_taska_anak.TahunSesi, maklumat_taska_anak.BulanMula,
maklumat_taska_anak.BulanTamat, maklumat_anak.Nama, maklumat_anak.NoMyKid,
maklumat_pemohon.Nama as nama_pemohon, maklumat_pemohon.NoKP as nokp_pemohon,
maklumat_pemohon.Alamat as alamat_pemohon, maklumat_pemohon.Bandar,
maklumat_pemohon.Poskod, maklumat_pemohon.Daerah, maklumat_pemohon.NoTel as no_tel_pemohon,
maklumat_pemohon.Dun, maklumat_pemohon.NamaPsgn, maklumat_pemohon.NoKpPsgn,
maklumat_pemohon.NoTelPsgn, maklumat_pemohon.EmailPsgn as email_pasangan,
taska.kodtaska, taska.nama
FROM maklumat_pembayaran_anak
left join maklumat_pembayaran_taska
on maklumat_pembayaran_anak.BayaranID = maklumat_pembayaran_taska.BayaranID
left join maklumat_anak
on maklumat_pembayaran_anak.AnakID = maklumat_anak.AnakID
left join maklumat_taska_anak
on maklumat_anak.AnakID = maklumat_taska_anak.AnakID
left join maklumat_pemohon
on maklumat_anak.PemohonID = maklumat_pemohon.PemohonID
left join taska
on taska.taskano = maklumat_taska_anak.TaskaNo
WHERE maklumat_pemohon.NoKP = '$get_ic'
ORDER BY NoMyKid, BayaranAnakID");
DB::disconnect('sbap');
$model_1 = DB::connection('sbap')->table('maklumat_pemohon')
->where('maklumat_pemohon.NoKP', Auth::user()->username)
->select('maklumat_pemohon.Nama as nama_pemohon',
'maklumat_pemohon.AppNo',
'applicant.AppStatus',
'maklumat_pemohon.NoKP as NRIC',
'maklumat_pemohon.NoTel as TelNo',
'maklumat_pemohon.DUN',
'maklumat_pemohon.Email',
'maklumat_pemohon.StatusPerkahwinan',
DB::raw('CONCAT(maklumat_pemohon.Alamat, ", ", maklumat_pemohon.Bandar, ", ", maklumat_pemohon.Poskod, ", ", maklumat_pemohon.Daerah) AS FullAddress'),
'maklumat_pemohon.TarikhTerimaBorang as DateRMSB',
'maklumat_pemohon.NamaPsgn as SpouseName',
'maklumat_pemohon.NoKpPsgn as SpouseNRIC',
'maklumat_pemohon.NoTelPsgn as SpouseTel',
'maklumat_pemohon.EmailPsgn as SpouseEmail',
'maklumat_anak.Nama as nama_anak', 'maklumat_anak.NoMyKid as mykid_anak',
'maklumat_taska_anak.TaskaNo as id_taska', 'maklumat_taska_anak.TahunSesi', 'maklumat_taska_anak.BulanMula', 'maklumat_taska_anak.BulanTamat',
'maklumat_taska_anak.StatusPermohonan as status_permohonan_taska_anak',
'taska.kodtaska as kod_taska', 'taska.nama as nama_taska',
'maklumat_pembayaran_taska.StatusBayaran')
->leftJoin('maklumat_anak', function($join)
{
$join->on('maklumat_pemohon.PemohonID', '=', 'maklumat_anak.PemohonID');
})
->leftJoin('applicant', function($join)
{
$join->on('maklumat_pemohon.AppNo', '=', 'applicant.AppNo');
})
->leftJoin('maklumat_taska_anak', function($join)
{
$join->on('maklumat_anak.AnakID', '=', 'maklumat_taska_anak.AnakID');
})
->leftJoin('taska', function($join)
{
$join->on('maklumat_taska_anak.TaskaNo', '=', 'taska.taskano');
})
->leftJoin('maklumat_pembayaran_anak', function($join)
{
$join->on('maklumat_taska_anak.AnakID', '=', 'maklumat_pembayaran_anak.AnakID');
})
->leftJoin('maklumat_pembayaran_taska', function($join)
{
$join->on('maklumat_taska_anak.TaskaNo', '=', 'maklumat_pembayaran_taska.TaskaNo')->where('maklumat_pembayaran_anak.AnakID', '=', );
})
->groupBy('mykid_anak')
->get();
DB::disconnect('sbap');
$model_2 = DB::connection('sbap')->table('maklumat_pemohon')
->where('maklumat_pemohon.NoKP', Auth::user()->username)
->select('maklumat_pemohon.Nama as nama_pemohon',
'maklumat_pemohon.AppNo',
'applicant.AppStatus',
'maklumat_pemohon.NoKP as NRIC',
'maklumat_pemohon.NoTel as TelNo',
'maklumat_pemohon.DUN',
'maklumat_pemohon.Email',
'maklumat_pemohon.StatusPerkahwinan',
DB::raw('CONCAT(maklumat_pemohon.Alamat, ", ", maklumat_pemohon.Bandar, ", ", maklumat_pemohon.Poskod, ", ", maklumat_pemohon.Daerah) AS FullAddress'),
'maklumat_pemohon.TarikhTerimaBorang as DateRMSB',
'maklumat_pemohon.NamaPsgn as SpouseName',
'maklumat_pemohon.NoKpPsgn as SpouseNRIC',
'maklumat_pemohon.NoTelPsgn as SpouseTel',
'maklumat_pemohon.EmailPsgn as SpouseEmail',
'applicant_child.FullName as anak_pemohon', 'applicant_child.MykidNo as mykid_anak_pemohon',
'applicant_child.AppStatus as status_anak')
->leftJoin('applicant', function($join)
{
$join->on('maklumat_pemohon.AppNo', '=', 'applicant.AppNo');
})
->join('applicant_child', function($join)
{
$join->on('maklumat_pemohon.AppNo', '=', 'applicant_child.AppNo');
})
->groupBy('mykid_anak_pemohon')
->get();
DB::disconnect('sbap');
$result = App\Anak::where('ic_pemohon', Auth::user()->username)->select('tarikh_lahir')->pluck('tarikh_lahir');
if(App\Profile::where('ic', Auth::user()->username)->count() > 0) {
if(Auth::user()->profile->status_perkahwinan == 'Berkahwin') {
if(Auth::user()->profile->pendapatan <= 5000 && count($result) > 0) {
foreach($result as $umur_anak) {
$umur_anak = Carbon\Carbon::parse($umur_anak)->age;
if($umur_anak <= 4 && Auth::user()->profile->tempoh_mastautin >= 5) {
$sbap = 'ya';
} elseif($umur_anak > 4 && Auth::user()->profile->tempoh_mastautin < 5) {
$sbap = 'tidak';
}
}
} else {
$sbap = 'tidak';
}
} elseif(Auth::user()->profile->status_perkahwinan == 'Duda/Janda') {
if(Auth::user()->profile->pendapatan <= 5000 && count($result) > 0) {
foreach($result as $umur_anak) {
$umur_anak = Carbon\Carbon::parse($umur_anak)->age;
if($umur_anak <= 4 && Auth::user()->profile->tempoh_mastautin >= 5) {
$sbap = 'ya';
} elseif($umur_anak > 4 && Auth::user()->profile->tempoh_mastautin < 5) {
$sbap = 'tidak';
}
}
}
} else {
$sbap = 'tidak';
}
} else {
$sbap = 'tidak';
}
@endphp
@if(count($model_sbap) > 0 )
LIHAT PERMOHONAN
DAFTAR
@elseif(count($model_sbap) <= 0 )
@if(Auth::user()->profile->status_perkahwinan == 'Bujang' && App\Anak::where('ic_pemohon', Auth::user()->username)->count() <= 0)
@elseif(Auth::user()->profile->status_perkahwinan == 'Berkahwin' || Auth::user()->profile->status_perkahwinan == 'Duda/Janda' || Auth::user()->profile->status_perkahwinan == 'Bujang' && App\Anak::where('ic_pemohon', Auth::user()->username)->count() > 0)
@if(Auth::user()->profile->pendapatan <= 5000)
@if(count($result) > 0)
@php
foreach($result as $umur_anak) {
$umur_anak = Carbon\Carbon::parse($umur_anak)->age;
}
@endphp
@if($umur_anak <= 4 && Auth::user()->profile->tempoh_mastautin >= 5)
DAFTAR
@else
@endif
@else
DAFTAR
@endif
@elseif(Auth::user()->profile->pendapatan > 5000)
@else
DAFTAR
@endif
@else
DAFTAR
@endif
@else
DAFTAR
@endif
@elseif ($ipr->name == 'tunas')
@php
$status_tunas = Auth::user()->username;
$ic=$status_tunas;
$tunas = DB::connection('tunas')
->table('tunas_pemohon')
->where('tunas_pemohon.nokp', '=', $ic)
->get();
DB::disconnect('tunas');
if($tunas->count()) {
$anak = DB::connection('tunas')
->table('applicant_child')
->leftJoin('tunas_pemohon', 'tunas_pemohon.kodlama', '=', 'applicant_child.AppNo')
->leftJoin('taska', 'taska.taskano', '=', 'applicant_child.TaskaNo')
->leftJoin('payment_details', 'payment_details.RecNo', '=', 'applicant_child.RecNo')
->leftJoin('payment', 'payment.PaymentNo', '=', 'payment_details.PaymentNo')
->leftJoin('year_session', 'year_session.YearSession', '=', 'applicant_child.AppNo')
->select('applicant_child.*', 'taska.nama as namatadika','status_baru', 'payment_details.*')
->where('applicant_child.AppNo', '=', $tunas[0]->kodlama)
->get()
->toArray();
DB::disconnect('tunas');
}
$bayar = DB::connection('tunas')
->table('tunas_anak')
->leftJoin('tunas_pemohon', 'tunas_pemohon.id_pemohon', '=', 'tunas_anak.id_pemohon')
->leftJoin('tunas_anak_tadika', 'tunas_anak_tadika.id_anak', '=', 'tunas_anak.id_anak')
->leftJoin('taska', 'taska.taskano', '=', 'tunas_anak_tadika.taskano')
->leftJoin('tunas_bayar_murid', 'tunas_bayar_murid.id_school', '=', 'tunas_anak_tadika.id_school')
->select('tunas_anak.*',
'tunas_pemohon.nama as nama_pemohon',
'taska.nama as namatadika',
'status_baru',
'status_anak',
'catatan_anak',
'tunas_anak_tadika.id_school',
'tunas_bayar_murid.*',
'tunas_bayar_murid.*')
->where('tunas_pemohon.nokp', '=', $ic)
->get()
->toArray();
DB::disconnect('tunas');
$result = App\Anak::where('ic_pemohon', Auth::user()->username)->select('tarikh_lahir')->pluck('tarikh_lahir');
@endphp
@if($tunas->count() > 0)
LIHAT PERMOHONAN
DAFTAR
@elseif($tunas->count() <= 0)
@if(Auth::user()->profile->status_perkahwinan == 'Bujang' && App\Anak::where('ic_pemohon', Auth::user()->username)->count() <= 0)
@elseif(Auth::user()->profile->status_perkahwinan == 'Berkahwin' || Auth::user()->profile->status_perkahwinan == 'Duda/Janda' || Auth::user()->profile->status_perkahwinan == 'Bujang' && App\Anak::where('ic_pemohon', Auth::user()->username)->count() > 0)
@if(Auth::user()->profile->pendapatan <= 3000)
@if(count($result) > 0)
@php
$kelayakan_anak = false;
foreach($result as $umur_anak) {
$umur_anak = Carbon\Carbon::parse($umur_anak)->age;
if ($umur_anak >=5 && $umur_anak <=6) {
$kelayakan_anak = true;
}
}
@endphp
@if($kelayakan_anak && Auth::user()->profile->tempoh_mastautin >= 5)
DAFTAR
@else
@endif
@else
DAFTAR
@endif
@elseif(Auth::user()->profile->pendapatan > 3000)
@else
DAFTAR
@endif
@endif
@else
DAFTAR
@endif
@elseif ($ipr->name == 'pbss')
@php
$pbss = App\PermohonanPbss::where('user_id', '=', Auth::user()->id)->whereYear('created_at', date('Y'))->get();
$isOpen = "DAFTAR";
$timenow = Carbon\Carbon::now()->startOfDay();
if ($ipr->tarikh_mula != null && $ipr->tarikh_akhir != null) {
$tarikh_mula = Carbon\Carbon::parse($ipr->tarikh_mula)->startOfDay();
$tarikh_akhir = Carbon\Carbon::parse($ipr->tarikh_akhir)->startOfDay();
if ($tarikh_mula > $timenow) {
$isOpen = "AKAN DATANG (" . \Carbon\Carbon::parse($ipr->tarikh_mula)->format('d/m/Y') . ")";
} elseif ($timenow > $tarikh_akhir) {
$isOpen = "PERMOHONAN DITUTUP (" . \Carbon\Carbon::parse($ipr->tarikh_akhir)->format('d/m/Y') . ")";
}
}
@endphp
@if(count($pbss) < 2)
@if($isOpen != "DAFTAR")
{{$isOpen}}
@else
DAFTAR ({{\Carbon\Carbon::parse($ipr->tarikh_mula)->format('d/m/Y')}} - {{\Carbon\Carbon::parse($ipr->tarikh_akhir)->format('d/m/Y')}})
@endif
LIHAT STATUS
@else
LIHAT STATUS
@endif
@endif
@else
MOHON
@endif
 }})
 }})
 }})
 }})
 }})
 }}/logo_{{ $maklumat->pbt_kod }}.png){kind=logo}