@section('sub-title', $data->no_pengajuan_harian) @section('title', 'Pengajuan Harian')
No Pengajuan : {{$data->no_pengajuan_harian}} {{ __('Loading...') }}
No Polis : {{isset($data->polis->no_polis) ? $data->polis->no_polis .' / '.$data->polis->nama : '-'}}
Tanggal Pengajuan : {{date('d F Y',strtotime($data->created_at))}}
Status @if($data->status==0) Underwriting @endif @if($data->status==1) Head Teknik @endif @if($data->status==2) Head Syariah @endif @if($data->status==3) Selesai @endif
Perhitungan Usia : @if($data->perhitungan_usia==1) Nears Birthday @endif @if($data->perhitungan_usia==2) Actual Birthday @endif
Masa Asuransi : {{$data->masa_asuransi==1?'Day to Day':'Day to Day -1'}}
Tampilkan Peserta {{ __('Loading...') }}
UL/UW {{ __('Loading...') }}
 
@php($nilai_manfaat = $data->kepesertaan->where('status_akseptasi',0)->sum('basic')) @php($dana_tabbaru = $data->kepesertaan->where('status_akseptasi',0)->sum('dana_tabarru')) @php($dana_ujrah = $data->kepesertaan->where('status_akseptasi',0)->sum('dana_ujrah')) @php($kontribusi = $data->kepesertaan->where('status_akseptasi',0)->sum('kontribusi')) @php($extra_mortalita = $data->kepesertaan->where('status_akseptasi',0)->sum('extra_mortalita')) @php($extra_kontribusi = $data->kepesertaan->where('status_akseptasi',0)->sum('extra_kontribusi')) @php($index_proses = 0) @foreach($kepesertaan_proses as $k => $item) @php($index_proses++) @endforeach @if($data->kepesertaan->count()==0) @endif
No @if(count($check_id)>0) {{ __('Loading...') }} Diterima Semua @endif Nama Bank KC/KP No KTP No Telepon Gender Nama Peserta Tgl. Lahir Usia TB BB Mulai Asuransi Akhir Asuransi Masa Asuransi Rate Nilai Manfaat Asuransi
{{format_idr($nilai_manfaat)}}
Dana Tabarru
{{format_idr($dana_tabbaru)}}
Dana Ujrah
{{format_idr($dana_ujrah)}}
Kontribusi
{{format_idr($kontribusi)}}
Extra Mortality
{{format_idr($extra_mortalita)}}
Extra Kontribusi
{{format_idr($extra_kontribusi)}}
Total Kontribusi
{{format_idr($kontribusi+$extra_kontribusi+$extra_mortalita)}}
Tgl Stnc UL Ket
{{$index_proses}} @if($data->status==0 and (\Auth::user()->user_access_id==1 || \Auth::user()->user_access_id==2)) @endif @if($data->status==1 and \Auth::user()->user_access_id==3) @endif @if($data->status==2 and\Auth::user()->user_access_id==4) @endif {{ __('Loading...') }} {{-- Underwriting --}} @if($data->status==0 and (\Auth::user()->user_access_id==1 || \Auth::user()->user_access_id==2)) @endif {{-- Head Teknik --}} @if($data->status==1 and \Auth::user()->user_access_id==3) @endif {{-- Head Syariah --}} @if($data->status==2 and \Auth::user()->user_access_id==4) @endif {!!$item->bank?$item->bank:'.....'!!} {!!$item->cab?$item->cab:'.....'!!} {!!$item->no_ktp?$item->no_ktp:'.....'!!} {!!$item->no_telepon?$item->no_telepon:'.....'!!} {!!$item->jenis_kelamin?$item->jenis_kelamin:'.....'!!} {!!$item->nama?$item->nama:'.....'!!} {{$item->tanggal_lahir ? date('d-M-Y',strtotime($item->tanggal_lahir)) : '-'}} {{$item->usia}} {!!$item->tinggi_badan?$item->tinggi_badan:'.....'!!} {!!$item->berat_badan?$item->berat_badan:'.....'!!} {{$item->tanggal_mulai ? date('d-M-Y',strtotime($item->tanggal_mulai)) : '-'}} {{$item->tanggal_akhir ? date('d-M-Y',strtotime($item->tanggal_akhir)) : '-'}} {{$item->masa_bulan}} {{$item->rate}} @if($item->is_double==1 || $item->akumulasi_ganda) {{format_idr($item->basic)}} @else {{format_idr($item->basic)}} @endif {{format_idr($item->dana_tabarru)}} {{format_idr($item->dana_ujrah)}} {{format_idr($item->kontribusi)}} @if($item->use_em==0) @else {{format_idr($item->extra_mortalita)}} @endif @if($item->extra_kontribusi) {{format_idr($item->extra_kontribusi)}} @else @endif {{format_idr($item->extra_mortalita+$item->kontribusi+$item->extra_kontribusi)}} {{$item->tanggal_stnc ? date('d-M-Y',strtotime($item->tanggal_stnc)) : '-'}} {{$item->ul}} {{$item->keterangan}}
Empty
Total {{format_idr($nilai_manfaat)}} {{format_idr($dana_tabbaru)}} {{format_idr($dana_ujrah)}} {{format_idr($kontribusi)}} {{format_idr($extra_mortalita)}} {{format_idr($extra_kontribusi)}} {{format_idr($kontribusi+$extra_mortalita+$extra_kontribusi)}}
@php($nilai_manfaat_approve = $data->kepesertaan->where('status_akseptasi',1)->sum('basic')) @php($dana_tabbaru_approve = $data->kepesertaan->where('status_akseptasi',1)->sum('dana_tabarru')) @php($dana_ujrah_approve = $data->kepesertaan->where('status_akseptasi',1)->sum('dana_ujrah')) @php($kontribusi_approve = $data->kepesertaan->where('status_akseptasi',1)->sum('kontribusi')) @php($extra_mortalita_approve = $data->kepesertaan->where('status_akseptasi',1)->sum('extra_mortalita')) @php($extra_kontribusi_approve = $data->kepesertaan->where('status_akseptasi',1)->sum('extra_kontribusi')) @php($index_approve = 0) @foreach($kepesertaan_approve as $k => $item) @php($index_approve++) @endforeach @if($data->kepesertaan->count()==0) @endif
No Nama Bank KC/KP No KTP No Telepon Gender No Peserta Nama Peserta Tgl. Lahir Usia TB BB Mulai Asuransi Akhir Asuransi Masa Asuransi Rate Nilai Manfaat Asuransi
{{format_idr($nilai_manfaat_approve)}}
Dana Tabarru
{{format_idr($dana_tabbaru_approve)}}
Dana Ujrah
{{format_idr($dana_ujrah_approve)}}
Kontribusi
{{format_idr($kontribusi_approve)}}
Extra Mortality
{{format_idr($extra_mortalita_approve)}}
Extra Kontribusi
{{format_idr($extra_kontribusi_approve)}}
Total Kontribusi
{{format_idr($kontribusi_approve+$extra_kontribusi_approve+$extra_mortalita_approve)}}
Tgl Stnc UL Ket
{{$index_approve}} {{-- Underwriting --}} @if($data->status==0 and (\Auth::user()->user_access_id==1 || \Auth::user()->user_access_id==2)) @endif {{-- Head Teknik --}} @if($data->status==1 and \Auth::user()->user_access_id==3) @endif {{-- Head Syariah --}} @if($data->status==2 and \Auth::user()->user_access_id==4) @endif {!!$item->bank?$item->bank:'.....'!!} {!!$item->cab?$item->cab:'.....'!!} {!!$item->no_ktp?$item->no_ktp:'.....'!!} {!!$item->no_telepon?$item->no_telepon:'.....'!!} {!!$item->jenis_kelamin?$item->jenis_kelamin:'.....'!!} {{$item->no_peserta}} {!!$item->nama?$item->nama:'.....'!!} {{$item->tanggal_lahir ? date('d-M-Y',strtotime($item->tanggal_lahir)) : '-'}} {{$item->usia}} {!!$item->tinggi_badan?$item->tinggi_badan:'.....'!!} {!!$item->berat_badan?$item->berat_badan:'.....'!!} {{$item->tanggal_mulai ? date('d-M-Y',strtotime($item->tanggal_mulai)) : '-'}} {{$item->tanggal_akhir ? date('d-M-Y',strtotime($item->tanggal_akhir)) : '-'}} {{$item->masa_bulan}} {{$item->rate}} @if($item->is_double==1 || $item->akumulasi_ganda) {{format_idr($item->basic)}} @else {{format_idr($item->basic)}} @endif {{format_idr($item->dana_tabarru)}} {{format_idr($item->dana_ujrah)}} {{format_idr($item->kontribusi)}} @if($item->use_em==0) @else {{format_idr($item->extra_mortalita)}} @endif @if($item->extra_kontribusi) {{format_idr($item->extra_kontribusi)}} @else @endif {{format_idr($item->extra_mortalita+$item->kontribusi+$item->extra_kontribusi)}} {{$item->tanggal_stnc ? date('d-M-Y',strtotime($item->tanggal_stnc)) : '-'}} {{$item->ul}} {{$item->keterangan}}
Empty
Total {{format_idr($nilai_manfaat_approve)}} {{format_idr($dana_tabbaru_approve)}} {{format_idr($dana_ujrah_approve)}} {{format_idr($kontribusi_approve)}} {{format_idr($extra_mortalita_approve)}} {{format_idr($extra_kontribusi_approve)}} {{format_idr($kontribusi_approve+$extra_mortalita_approve+$extra_kontribusi_approve)}}
@php($nilai_manfaat_reject = $data->kepesertaan->where('status_akseptasi',2)->sum('basic')) @php($dana_tabbaru_reject = $data->kepesertaan->where('status_akseptasi',2)->sum('dana_tabarru')) @php($dana_ujrah_reject = $data->kepesertaan->where('status_akseptasi',2)->sum('dana_ujrah')) @php($kontribusi_reject = $data->kepesertaan->where('status_akseptasi',2)->sum('kontribusi')) @php($extra_mortalita_reject = $data->kepesertaan->where('status_akseptasi',2)->sum('extra_mortalita')) @php($extra_kontribusi_reject = $data->kepesertaan->where('status_akseptasi',2)->sum('extra_kontribusi')) @php($index_reject = 0) @foreach($kepesertaan_reject as $k => $item) @php($index_reject++) @endforeach @if($data->kepesertaan->count()==0) @endif
No @if(count($check_id)>0) {{ __('Loading...') }} Diterima Semua @endif Reason Nama Bank KC/KP No KTP No Telepon Gender Nama Peserta Tgl. Lahir Usia TB BB Mulai Asuransi Akhir Asuransi Masa Asuransi Rate Nilai Manfaat Asuransi
{{format_idr($nilai_manfaat_reject)}}
Dana Tabarru
{{format_idr($dana_tabbaru_reject)}}
Dana Ujrah
{{format_idr($dana_ujrah_reject)}}
Kontribusi
{{format_idr($kontribusi_reject)}}
Extra Mortality
{{format_idr($extra_mortalita_reject)}}
Extra Kontribusi
{{format_idr($extra_kontribusi_reject)}}
Total Kontribusi
{{format_idr($kontribusi_reject+$extra_kontribusi_reject+$extra_mortalita_reject)}}
Tgl Stnc UL Ket
{{$index_reject}} @if($data->status==0 and (\Auth::user()->user_access_id==1 || \Auth::user()->user_access_id==2)) @endif @if($data->status==1 and \Auth::user()->user_access_id==3) @endif @if($data->status==2 and \Auth::user()->user_access_id==4) @endif {{ __('Loading...') }} {{-- Underwriting --}} @if($data->status==0 and (\Auth::user()->user_access_id==1 || \Auth::user()->user_access_id==2)) @endif {{-- Head Teknik --}} @if($data->status==1 and \Auth::user()->user_access_id==3) @endif {{-- Head Syariah --}} @if($data->status==2 and \Auth::user()->user_access_id==4) @endif {{$item->reason_reject}} {!!$item->bank?$item->bank:'.....'!!} {!!$item->cab?$item->cab:'.....'!!} {!!$item->no_ktp?$item->no_ktp:'.....'!!} {!!$item->no_telepon?$item->no_telepon:'.....'!!} {!!$item->jenis_kelamin?$item->jenis_kelamin:'.....'!!} {!!$item->nama?$item->nama:'.....'!!} {{$item->tanggal_lahir ? date('d-M-Y',strtotime($item->tanggal_lahir)) : '-'}} {{$item->usia}} {!!$item->tinggi_badan?$item->tinggi_badan:'.....'!!} {!!$item->berat_badan?$item->berat_badan:'.....'!!} {{$item->tanggal_mulai ? date('d-M-Y',strtotime($item->tanggal_mulai)) : '-'}} {{$item->tanggal_akhir ? date('d-M-Y',strtotime($item->tanggal_akhir)) : '-'}} {{$item->masa_bulan}} {{$item->rate}} @if($item->is_double==1 || $item->akumulasi_ganda) {{format_idr($item->basic)}} @else {{format_idr($item->basic)}} @endif {{format_idr($item->dana_tabarru)}} {{format_idr($item->dana_ujrah)}} {{format_idr($item->kontribusi)}} @if($item->status !=3) @if($item->use_em==0) @else {{format_idr($item->extra_mortalita)}} @endif @else {{format_idr($item->extra_mortalita)}} @endif @if($item->status !=3) @if($item->extra_kontribusi) {{format_idr($item->extra_kontribusi)}} @else @endif @else {{format_idr($item->extra_kontribusi)}} @endif {{format_idr($item->extra_mortalita+$item->kontribusi+$item->extra_kontribusi)}} {{$item->tanggal_stnc ? date('d-M-Y',strtotime($item->tanggal_stnc)) : '-'}} {{$item->ul}} {{$item->keterangan}}
Empty
Total {{format_idr($nilai_manfaat_reject)}} {{format_idr($dana_tabbaru_reject)}} {{format_idr($dana_ujrah_reject)}} {{format_idr($kontribusi_reject)}} {{format_idr($extra_mortalita_reject)}} {{format_idr($extra_kontribusi_reject)}} {{format_idr($kontribusi_reject+$extra_mortalita_reject+$extra_kontribusi_reject)}}
@if($data->kepesertaan->where('status_akseptasi',0)->count() > 0) @endif
Kembali {{ __('Loading...') }} @if($data->kepesertaan->where('status_akseptasi',0)->count() == 0) @if($data->status==0 and (\Auth::user()->user_access_id==2 || \Auth::user()->user_access_id==1)) @endif @if($data->status==1 and \Auth::user()->user_access_id==3) @endif @if($data->status==2 and \Auth::user()->user_access_id==4) @endif @endif
@push('after-scripts') @endpush