public function getEdit($id)
{
$prq = data_prq::join('data_karyawan AS a', 'a.id_karyawan', '=', 'data_prq.id_pemohon')->leftJoin('data_karyawan AS b', 'b.id_karyawan', '=', 'data_prq.id_acc')->where('data_prq.id_prq', $id)->select('data_prq.*', 'a.nm_depan', 'a.nm_belakang', 'b.nm_depan AS acc_depan', 'b.nm_belakang AS acc_belakang')->first();
$items = data_prq_item::join('data_barang', 'data_barang.id_barang', '=', 'data_prq_item.id_barang')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_barang.id_satuan')->where('data_prq_item.id_prq', $id)->select('data_barang.kode', 'data_barang.nm_barang', 'data_barang.in', 'data_barang.out', 'data_prq_item.*', 'ref_satuan.nm_satuan')->get();
$ids = [];
$sels = [];
foreach ($items as $id) {
$ids[] = $id->id_barang;
$sels[$id->id_barang] = $id->id_satuan;
}
$param['ids'] = $ids;
$param['tipe'] = $prq->tipe;
$param['sels'] = $sels;
$param = json_encode($param);
return view('Pengadaan.PRQ.EditPRQ', ['prq' => $prq, 'items' => $items, 'param' => $param, 'tipe' => $prq->tipe]);
}
