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]); }