@extends('be.layout-index')
@section('content')
@php
$modul="Kajian Akhir";
$modula="m_kajianakhir";
$id='';
$no='';
$id_laporan='';
$trendpelanggarannm='';
$rekomendasi_no='';
$rekomendasi_file='';
$locus='';
$stsposisi='';
if(isset($data)){
    $id=$data->id;
    $no=$data->no;
    $id_laporan=$data->id_laporan;
    $trendpelanggarannm=$data->trendpelanggarannm;
    $rekomendasi_no=$data->rekomendasi_no;
    $rekomendasi_file=$data->rekomendasi_file;
    $locus=$data->locus;
    $stsposisi=$data->stsposisi;
}
$trendkajiannm="";
$n_trend=DB::select("
            select b.nama trend
            from t_kajianakhir_trend a
            left join m_trendpelanggaran b on b.id=a.id_trend
            where a.id_kajianakhir='".$id."' order by a.urut");
foreach($n_trend as $item_trend){
    $trendkajiannm.="<tr>
        <td valign=top></td>
        <td valign=top>-</td>
        <td>".$item_trend->trend."</td>
    </tr><tr><td height=10></td></tr>";
}
@endphp
<style>
.borderless tr td{
    padding:3px;
    border:0;
    text-align:left;
    background-color:transparent!important;
    font-size:10pt;
}
.borderless tr{
    background-color:transparent!important;
}
</style>
<div class="row">
   <div class="col-12">
       <div class="card">
               <div class="card-body">
            
<div class="panel-default">
    <div class="content-box-header  panel-heading">
        <div class="panel-title"></div>
    </div>
    <div class="content-box-large box-with-header">
            <div class="row">
                <div class="col-sm-12">
                    <div class="form-group row">
                        <label class="col-sm-2 control-label">Laporan</label>
                        <div class="input-group col-md-4">{!!$no;!!}</div>
                    </div>
                    <div class="form-group row">
                        <label class="col-sm-2 control-label">Kategori</label>
                        <div class="col-sm-5">
                            <table class="table borderless" width=100%>
                             <tbody id="tbody">
                             @php
                                $i=1;
                                if(count($m_kajiankategori)>0){
                                    foreach($m_kajiankategori as $item)
                                    {
                                          $trendnama = '';
										  if($item->id_trend!=''){
	                                          $n_trendpelanggaran=DB::select("select id,nama from m_trendpelanggaran where id=".$item->id_trend);
	                                          if (!empty($n_trendpelanggaran)) {
	                                                foreach ($n_trendpelanggaran as $row){
	                                                    $trendnama = $row->nama;
	                                                }
	                                          }
										  }
                                        echo '
                                        <tr>
                                            <td width=1% valign=top>'.$i.'. </td>
                                            <td width=99%>
                                                Kategori : '.$item->kat1nm.'<br>
                                                Trend : '.$trendnama.'<br>
                                                Rekomendasi No : '.$item->rekomendasi_no.'<br>';
                                                if($item->rekomendasi_file!=''){
                                                    echo 'File Rekomendasi : <a href="'.route("download.be_ka_dk")."/".rawurlencode($item->rekomendasi_file).'" class="btn btn-primary btn-xs"><i class=" ti-download"></i> Download</a>';
                                                }
                                                else{
                                                    echo 'File Rekomendasi : <br>';
                                                }
                                                echo '
                                            </td>
                                        </tr>';
                                        $i++;
                                    }
                                }
                                @endphp
                                </tbody>
                            </table>
                        </div>
                    </div>
                    <div class="form-group row">
                        <label class="col-sm-2 control-label">Trend Pelanggaran</label>
                        <div class="input-group col-md-4">
                            @if($trendkajiannm!='')
                                <tr>
                                   <td colspan=3><table>{!!$trendkajiannm!!}</table></td>
                                </tr>
                            @endif
                        </div>
                    </div>
                </div>
            </div>
            <br />
            <div class="row">
                <div class="col-sm-6">
                    <div class="form-group" style="margin-left:13px">
                        <div class="col-sm-offset-2 col-sm-10">
                            @if(session('be_urole')!=4)
                                @if($locus==session('be_uwilayah')||session('be_urole')==3)
                                	<a href="{!!route('m_kajianakhir.add').'/'.ec($id_jenislaporan).'/'.ec($id)!!}" class="btn btn-primary btn-sm"><i class='fa fa-repeat'></i> Ubah</a>
                                @endif
                            @endif
                            <a href="javascript:history.back()" class="btn btn-warning btn-sm"><i class='fa fa-repeat'></i> Batalkan</a>
                        </div>
                    </div>
                </div>
            </div>
    </div>
</div>

            </div>
        </div>
    </div>
</div>
@endsection