@extends('layout/database') @section('title') Detail Produsen @endsection @section('meta') @endsection @section('content')
@foreach($targetnya as $target)
@php $jumlah1 = DB::table('target_benih') ->join('lap_benih_panen','lap_benih_panen.target_benih_id','target_benih.id') ->join('lap_benih_label','lap_benih_label.lap_benih_panen_id','lap_benih_panen.id') ->where('target_benih.id',$target->id) ->select(DB::raw( 'lap_benih_label.tanggal_lapor as tgllpr, lap_benih_label.jumlah_lanjut as jumlah_lanjut, lap_benih_label.jumlah_gagal as jumlah_gagal, lap_benih_label.jumlah_tunda as jumlah_tunda, lap_benih_label.keterangan as ket, lap_benih_label.upload as upload ' )) ->get(); @endphp @endforeach @foreach($produksinon as $pronon) @endforeach
Detail Produsen/Pengedar

{{$lembaga->nama_lembaga}}

Alamat : {{$lembaga->alamat}}, {{$lembaga->provinces->name}}, {{$lembaga->regencies->name}}, {{$lembaga->districts->name}}, {{$lembaga->villages->name}}

Kepala : {{$lembaga->nama_kepala}}

No. Telp : {{$lembaga->no_telp}}

Lihat Pada Googlemap

SERTIFIKAT KOMPETENSI PRODUSEN BENIH

@foreach($serkom as $ser) @if(isset($ser->produsenbenih)) @php $col = collect($ser->jenis_kompetensi); $array = $col->toArray(); $string = implode(', ', $array); @endphp @endif @endforeach
NOMOR SERTIFIKAT KOMPETENSI JENIS KOMPETENSI TANGGAL PENETAPAN SERTIFIKAT KOMPETENSI AWAL BERLAKU HINGGA PERPANJANGAN STATUS
{{$ser->no_serti}}{{$string ?? 'Kesalahan dalam Pengisian Data'}} {{$ser->tgl_awal}} @php $tgl_akhir = $ser->tgl_akhir; $panjang = $ser->perpanjangansmm->where('child_smm_id',$ser->id)->sortByDesc('tgl_perpanjangan')->first(); if($panjang){ $tglakhirp = $panjang->tgl_berlaku; echo $tglakhirp; }else{ echo $tgl_akhir; } @endphp {{$ser->perpanjangansmm->count() }} @php $now = date("Y-m-d"); $tgl_akhir = $ser->tgl_akhir; $panjang = $ser->perpanjangansmm->where('child_smm_id',$ser->id)->sortByDesc('tgl_perpanjangan')->first(); if($panjang){ $tglakhirp = $panjang->tgl_berlaku; if($now>$tglakhirp){ echo "Tidak Berlaku"; }else{ echo "Berlaku"; } }else{ if($now>$tgl_akhir){ echo "Tidak Berlaku" ; }else{ echo "Berlaku"; } } @endphp

Lokasi Produksi Benih

@foreach($lembaga->lokasiproduksidetail as $lok) @endforeach
Alamat Luas Lokasi Produksi
{{$lok->alamat}} {{$lok->luas}} ha

Lokasi Penyimpanan Benih

@foreach($lembaga->lokasigudangdetail as $gud) @endforeach
Alamat Kapasitas Penyimpanan
{{$gud->alamat}} {{$gud->kapasitas}}

Peta Penyaluran Benih

Produksi APBN

@foreach($targetnya as $target) @php $jumlah = DB::table('target_benih') ->join('lap_benih_panen','lap_benih_panen.target_benih_id','target_benih.id') ->join('lap_benih_label','lap_benih_label.lap_benih_panen_id','lap_benih_panen.id') ->where('target_benih.id',$target->id) ->sum('jumlah_lanjut'); @endphp @endforeach
TAHUN TARGET PRODUKSI LOKASI PRODUKSI TARGET PRODUKSI KOMODITAS (SATUAN) TARGET SALUR KOMODITAS (SATUAN) PROSES PERBANYAKAN MENCAPAI PTM SIAP SALUR TERSALUR KINERJA PENYALURAN SISA STOK STATUS
BERHASIL GAGAL BELUM DIPROSES KINERJA PERBANYAKAN BERHASIL GAGAL BELUM PTM KINERJA PTM BERLABEL PENGURANGAN BERLABEL BELUM BERLABEL KINERJA BERLABEL
{{$target->tahun}} {{$target->lokasiproduksidetail->alamat}} {{$target->komoditas->nama}} - {{$target->varietas->nama_varietas}}
{{number_format($target->jum_target,0,",",".")}} {{$target->satuan->nama_satuan}}
{{$target->komoditas->nama}} - {{$target->varietas->nama_varietas}}
{{number_format($target->targetsalur->sum('jumlah'),0,",",".")}} {{$target->satuan->nama_satuan}}
{{number_format(($target->produksi->sum('pengadaan_benih')-$target->produksimati->sum('produksi_mati')),0,",",".")}} {{$target->satuan->nama_satuan}} {{number_format($target->produksimati->sum('produksi_mati'),0,",",".")}} {{$target->satuan->nama_satuan}} {{number_format(($target->jum_target-$target->produksi->sum('pengadaan_benih')+$target->produksimati->sum('produksi_mati')),0,",",".")}} {{$target->satuan->nama_satuan}} {{number_format((($target->produksi->sum('pengadaan_benih')-$target->produksimati->sum('produksi_mati'))*100/$target->jum_target),0,",",".")."%"}} {{number_format(($target->ptm->sum('jum_panen')-$target->ptmmati->sum('label_mati')),0,",",".")}} {{$target->satuan->nama_satuan}} {{number_format($target->ptmmati->sum('label_mati'),0,",",".")}} {{$target->satuan->nama_satuan}} {{number_format(($target->produksi->sum('pengadaan_benih')-$target->produksimati->sum('produksi_mati')-$target->ptm->sum('jum_panen')+$target->ptmmati->sum('label_mati')))}} {{$target->satuan->nama_satuan}} {{number_format((($target->ptm->sum('jum_panen')-$target->ptmmati->sum('label_mati'))*100/$target->jum_target),0,",",".")."%"}} {{number_format(($jumlah-$target->penguranganstok->sum('jumlah')),0,",",".")}} {{$target->satuan->nama_satuan}} {{number_format($target->penguranganstok->sum('jumlah'),0,",",".")}} {{$target->satuan->nama_satuan}} {{number_format(($target->ptm->sum('jum_panen')-$target->ptmmati->sum('label_mati')-$jumlah),0,",",".")}} {{$target->satuan->nama_satuan}} {{number_format((($jumlah-$target->penguranganstok->sum('jumlah'))*100/$target->jum_target),0,",",".")."%"}} {{number_format($target->penyaluranstok->sum('jumlah'),0,",",".")}} {{$target->satuan->nama_satuan}} {{number_format((($target->penyaluranstok->sum('jumlah'))*100/$target->jum_target),0,",",".")."%"}} {{number_format(($jumlah-$target->penguranganstok->sum('jumlah')-$target->penyaluranstok->sum('jumlah')),0,",",".")}} {{$target->satuan->nama_satuan}} @if($target->status=="active") Terverifikasi @elseif($target->status=="pending") Diajukan Ulang @elseif($target->status=="tolak") Ditolak dengan keterangan {{$target->keterangan}} @elseif($target->status=="selesai") Target Selesai @else Diajukan @endif
{!! $targetnya->withQueryString()->links() !!}
@if($produksinon->count())

Produksi Non APBN

@foreach($produksinon as $pronon) @php $idToValue = [ "apbd" => "APBD", "mandiri" => "Mandiri" ]; $jsonArray1 = collect($pronon->sumber_dana); $jsonArray = json_decode($jsonArray1); if ($jsonArray !== null) { foreach ($jsonArray as &$id) { if (array_key_exists($id, $idToValue)) { $id = $idToValue[$id]; } } } $jsonResult = implode(", ", $jsonArray); @endphp @endforeach
KOMODITAS VARIETAS SATUAN SUMBER DANA JUMLAH PRODUKSI JUMLAH TERSALUR STOK
{{$pronon->komoditas->nama}} {{$pronon->varietas->nama_varietas}} {{$pronon->satuan->nama_satuan}} {{$jsonResult}} {{$pronon->childproduksiswadaya->sum('produksi_benih')}} {{$pronon->satuan->nama_satuan}} {{$pronon->childproduksiswadaya->sum('salur_benih')}} {{$pronon->satuan->nama_satuan}} {{($pronon->childproduksiswadaya->sum('produksi_benih')-$pronon->childproduksiswadaya->sum('salur_benih'))}} {{$pronon->satuan->nama_satuan}} Detail
{!! $produksinon->withQueryString()->links() !!}
@endif
@endsection