@extends('be.layout-index') @section('content') @php $modul="Pelaporan"; $modula="laporan"; $id = ''; $no = ''; $no_offline = ''; $tgl_offline=''; $no_registrasi = ''; $pelapornm = ''; $id_tahapan = ''; $tahapannm = ''; $jeniswilpemilihan = ''; $waktukejadian = ''; $waktudiketahui = ''; $ringkasan = ''; $tempatkejadian = ''; $uraian = ''; $stsvalidnm=""; $stsvalid_date=null; $ststsmnm=''; $stsvalidnama=''; $stslap=''; $stslap_bynm=''; $stslap_date=''; $keterangan=''; $id_jenislaporan=''; $id_jenislaporaninit=''; if(isset($data)){ $id = $data->id; $no = $data->no; $no_offline = $data->no_offline; $tgl_offline=$data->tgl_offline; $no_registrasi = $data->no_registrasi; $pelapornm = $data->pelapornm; $id_tahapan = $data->id_tahapan; $tahapannm = $data->tahapannm; $jeniswilpemilihan = $data->jeniswilpemilihan; $waktukejadian = $data->waktukejadian; $waktudiketahui = $data->waktudiketahui; $ringkasan = $data->ringkasan; $tempatkejadian = $data->tempatkejadian; $uraian = html_entity_decode($data->uraian); $stsvalidnm = $data->stsvalidnm; $stsvalid_date = $data->stsvalid_date; $ststsmnm = $data->ststsmnm; $stsvalidnama = $data->stsvalidnama; $stslap = $data->stslap; $stslap_bynm = $data->stslap_bynm; $stslap_date = $data->stslap_date; $keterangan = $data->keterangan; $id_jenislaporan = $data->id_jenislaporan; } $filepath[]=''; $adazip=0; if($id_jenislaporan==1){ $id_jenislaporaninit='A'; } elseif($id_jenislaporan==2){ $id_jenislaporaninit='B'; } @endphp
{!!$no!!}
{!!$no_registrasi!!}
{!!$no_offline!!}
{!!konversi_tanggal('j M Y H:i:s',$tgl_offline)!!}
{!!$pelapornm!!}
{!!$jeniswilpemilihan!!}
{!!konversi_tanggal('j M Y H:i:s',$waktukejadian)!!}
{!!konversi_tanggal('j M Y H:i:s',$waktudiketahui)!!}
{!!$ringkasan!!}
{!!$tempatkejadian!!}
@if($keterangan!='')
{!!$keterangan!!}
@endif
Laporan
{!!$id_jenislaporaninit!!}.3
{!!$id_jenislaporaninit!!}.3.1
@php $configfoot="$('#table_kajianawal').DataTable();"; $id_ka=''; $data_ka=DB::table('t_kajianawal')->where("id_laporan",$id)->first(); if(!$data_ka){ echo ''; } else{ $id_ka=$data_ka->id; $idx=1; if($data_ka->dok_reg!=""){ echo ' '; $idx++; } if($data_ka->dok_unreg!=""){ echo ' '; $idx++; } if($data_ka->dok_lengkapidokumen!=""){ echo ' '; $idx++; } if($data_ka->dok_dicabut!=""){ echo ' '; $idx++; } if($data_ka->dok_unreg_sdh_ditangani!=""){ echo ' '; $idx++; } if($data_ka->admbafile!=""){ echo ' '; $idx++; } $ka_dok=DB::table("t_kajianawal_dokumen")->where('id_kajianawal',$id_ka)->get(); foreach($ka_dok as $item){ echo ' '; $idx++; } } @endphp
No Keterangan Download
Data tidak ada
'.$idx.' Dokumen BA Registrasi'; echo 'dok_reg).'" class="btn btn-'.(is_file(public_path().'/media/uploads/kajianawal/'.$data_ka->dok_reg)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/kajianawal/'.$data_ka->dok_reg; echo '
'.$idx.' Dokumen BA tidak diregistrasi'; echo 'dok_unreg).'" class="btn btn-'.(is_file(public_path().'/media/uploads/kajianawal/'.$data_ka->dok_unreg)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/kajianawal/'.$data_ka->dok_unreg; echo '
'.$idx.' Kelengkapan dokumen'; echo 'dok_lengkapidokumen).'" class="btn btn-'.(is_file(public_path().'/media/uploads/kajianawal/'.$data_ka->dok_lengkapidokumen)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/kajianawal/'.$data_ka->dok_lengkapidokumen; echo '
'.$idx.' Dokumen BA laporan tidak diregistrasi karena laporan dicabut'; echo 'dok_dicabut).'" class="btn btn-'.(is_file(public_path().'/media/uploads/kajianawal/'.$data_ka->dok_dicabut)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/kajianawal/'.$data_ka->dok_dicabut; echo '
'.$idx.' Dokumen BA laporan tidak diregistrasi karena sudah ditangani sebelumnya'; echo 'dok_unreg_sdh_ditangani).'" class="btn btn-'.(is_file(public_path().'/media/uploads/kajianawal/'.$data_ka->dok_unreg_sdh_ditangani)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/kajianawal/'.$data_ka->dok_unreg_sdh_ditangani; echo '
'.$idx.' Dokumen BA pelanggaran administrasi'; echo 'admbafile).'" class="btn btn-'.(is_file(public_path().'/media/uploads/kajianawal/'.$data_ka->admbafile)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/kajianawal/'.$data_ka->admbafile; echo '
'.$idx.' '.$item->note.''; if($item->dokumen!=""){ echo 'dokumen).'" class="btn btn-'.(is_file(public_path().'/media/uploads/kajianawal/'.$item->dokumen)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/kajianawal/'.$item->dokumen; } else{ echo "-"; } echo '
@php $configfoot="$('#table_undangan').DataTable();"; $idx=1; $data_undangan=DB::table("t_undangan")->where("id_laporan",$id)->get(); if(!$data_undangan){ echo ''; } else{ foreach($data_undangan as $item){ echo ' '; $idx++; } } @endphp
No Keterangan Download
Data tidak ada
'.$idx.' '.$item->note.''; if($item->dokumen!=""){ echo 'dokumen).'" class="btn btn-'.(is_file(public_path().'/media/uploads/undangan/'.$item->dokumen)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/undangan/'.$item->dokumen; } else{ echo "-"; } echo '
@php $configfoot="$('#table_klarifikasi').DataTable();"; $idx=1; $str=" select b.proses, c.deskripsi, c.dokumen from t_klarifikasi_proses b inner join t_klarifikasi a on a.id=b.id_klarifikasi left join t_klarifikasi_prosesfile c on c.id_klarifikasiproses=b.id where a.id_laporan=".$id." and c.deskripsi is not null"; $data_klarifikasi_proses=DB::select($str); if(!$data_klarifikasi_proses){ echo ''; } else{ foreach($data_klarifikasi_proses as $item){ echo ' '; $idx++; } } @endphp
No Keterangan Download
Data tidak ada
'.$idx.' '.$item->deskripsi.' (Tahap '.$item->proses.')'; if($item->dokumen!=""){ echo 'dokumen).'" class="btn btn-'.(is_file(public_path().'/media/uploads/klarifikasi/'.$item->dokumen)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/klarifikasi/'.$item->dokumen; } else{ echo "-"; } echo '
@php $configfoot="$('#table_sidang').DataTable();"; $idx=1; $str=" select b.proses, c.deskripsi, c.dokumen from t_sidang_proses b inner join t_sidang a on a.id=b.id_sidang left join t_sidang_prosesfile c on c.id_sidangproses=b.id where a.id_laporan=".$id." and c.deskripsi is not null"; $data_sidang_proses=DB::select($str); $data_sidang_risalah=DB::table("t_sidang_risalah as a") ->join("t_sidang as b","a.id_sidang","=","b.id") ->where("b.id_laporan",$id) ->selectRaw('a.proses,a.file_pdf,a.file_audio') ->get(); if(!$data_sidang_proses&&!$data_sidang_risalah){ echo ''; } else{ if($data_sidang_proses){ foreach($data_sidang_proses as $item){ echo ' '; $idx++; } } if($data_sidang_risalah){ foreach($data_sidang_risalah as $item){ echo ' '; $idx++; } } } @endphp
No Keterangan Download
Data tidak ada
'.$idx.' '.$item->deskripsi.' (Tahap '.$item->proses.')'; if($item->dokumen!=""){ echo 'dokumen).'" class="btn btn-'.(is_file(public_path().'/media/uploads/sidang/'.$item->dokumen)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/sidang/'.$item->dokumen; } else{ echo "-"; } echo '
'.$idx.' '.$item->proses.' (Risalah)'; if($item->file_pdf!=""){ echo 'file_pdf).'" class="btn btn-'.(is_file(public_path().'/media/uploads/sidang/'.$item->file_pdf)?"info":"danger").' btn-sm"> Pdf     
'; $filepath[]=public_path().'/media/uploads/sidang/'.$item->file_pdf; } if($item->file_audio!=""){ echo 'file_audio).'" class="btn btn-'.(is_file(public_path().'/media/uploads/sidang/'.$item->file_audio)?"info":"danger").' btn-sm"> Audio'; $filepath[]=public_path().'/media/uploads/sidang/'.$item->file_audio; } echo '
@php $configfoot="$('#table_kajianakhir').DataTable();"; $idx=1; $rekomendasi_file=''; $data_kajianakhir=DB::table("t_kajianakhir")->where("id_laporan",$id)->get(); $data_kajianakhir_kat=DB::table("t_kajianakhir_kategori as a") ->join("t_kajianakhir as c","c.id","=","a.id_kajianakhir") ->join("m_kajianakhir_kategori as b","b.id","=","a.id_kat1") ->where("c.id_laporan",$id) ->selectRaw('a.*,b.nama katnm') ->get(); $data_kajianakhir_dok=DB::table("t_kajianakhir_dokumen as a") ->join("t_kajianakhir as b","a.id_kajianakhir","=","b.id") ->where("b.id_laporan",$id) ->selectRaw('a.note,a.dokumen') ->get(); if(!$data_kajianakhir&&!$data_kajianakhir_dok){ echo ''; } else{ foreach($data_kajianakhir_kat as $item){ if($item->rekomendasi_file!=""){ echo ' '; $idx++; } } foreach($data_kajianakhir_dok as $item){ if($item->dokumen!=""){ echo ' '; $idx++; } } } @endphp
No Keterangan Download
Data tidak ada
'.$idx.' '.$item->katnm.'
'.$item->rekomendasi_no.'		'; if($item->rekomendasi_file!=""){ echo 'rekomendasi_file).'" class="btn btn-'.(is_file(public_path().'/media/uploads/kajianakhir/'.$item->rekomendasi_file)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/kajianakhir/'.$item->rekomendasi_file; } else{ echo "-"; } echo '
'.$idx.' '.$item->note.''; if($item->dokumen!=""){ echo 'dokumen).'" class="btn btn-'.(is_file(public_path().'/media/uploads/kajianakhir/'.$item->dokumen)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/kajianakhir/'.$item->dokumen; } else{ echo "-"; } echo '
@php $configfoot="$('#table_status').DataTable();"; $idx=1; $data_status=DB::table("t_status")->where("id_laporan",$id)->get(); if(!$data_status){ echo ''; } else{ foreach($data_status as $item){ echo ' '; $idx++; } } @endphp
No Keterangan Download
Data tidak ada
'.$idx.' '.$item->note.''; if($item->dokumen!=""){ echo 'dokumen).'" class="btn btn-'.(is_file(public_path().'/media/uploads/status/'.$item->dokumen)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/status/'.$item->dokumen; } else{ echo "-"; } echo '
@php $configfoot="$('#table_putusan').DataTable();"; $idx=1; $data_putusan=DB::table("t_putusan_dokumen as a") ->join("t_putusan as b","a.id_putusan","=","b.id") ->where("b.id_laporan",$id) ->selectRaw('a.note,a.dokumen') ->get(); if(!$data_putusan){ echo ''; } else{ foreach($data_putusan as $item){ echo ' '; $idx++; } } @endphp
No Keterangan Download
Data tidak ada
'.$idx.' '.$item->note.''; if($item->dokumen!=""){ echo 'dokumen).'" class="btn btn-'.(is_file(public_path().'/media/uploads/putusan/'.$item->dokumen)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/putusan/'.$item->dokumen; } else{ echo "-"; } echo '
@php $configfoot="$('#table_tindaklanjut').DataTable();"; $idx=1; $str=" select a.note,a.dokumen,e.nama kategori,c.nama status from t_tindaklanjut_kategori_tahapan a inner join t_tindaklanjut b on a.id_tindaklanjut=b.id left join m_tindaklanjut_status c on c.id=a.id_status left join t_tindaklanjut_kategori d on d.id_tindaklanjut=a.id_tindaklanjut and d.id=a.id_tindaklanjut_kategori left join m_kajianakhir_kategori e on e.id=d.id_kategori where b.id_laporan='".$id."'"; $data_tl=DB::select($str); if(!$data_tl){ echo ''; } else{ foreach($data_tl as $item){ echo ' '; $idx++; } } $adazip=0; if(count($filepath)>0){ $zip = new ZipArchive; $fileName = public_path().'/media/uploads/tmp/arsip_laporan_'.$id.'.zip'; if ($zip->open(($fileName), ZipArchive::CREATE)== TRUE){ foreach ($filepath as $relativName) { if(file_exists($relativName)){ $zip->addFile($relativName,basename($relativName)); $adazip=1; } } if ($zip->open(public_path($fileName)) === true) { $zip->close(); } } } @endphp
No Keterangan Download
Data tidak ada
'.$idx.' '.$item->note.' ('.$item->kategori.' - '.$item->status.')'; if($item->dokumen!=""){ echo 'dokumen).'" class="btn btn-'.(is_file(public_path().'/media/uploads/tindaklanjut/'.$item->dokumen)?"info":"danger").' btn-sm">'; $filepath[]=public_path().'/media/uploads/tindaklanjut/'.$item->dokumen; } else{ echo "-"; } echo '
@if($adazip==1) Download all as zip file @endif Show All Back
@endsection