public function getCreate($id = 0)
{
$items = data_prq_item::join('data_prq', 'data_prq.id_prq', '=', 'data_prq_item.id_prq')->join('data_barang', 'data_barang.id_barang', '=', 'data_prq_item.id_barang')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_prq_item.id_satuan')->join('ref_satuan AS b', 'b.id_satuan', '=', 'data_barang.id_satuan')->whereIn('data_prq_item.id_prq_item', $this->ids)->select('data_prq.no_prq', 'data_prq.id_prq', 'data_barang.nm_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'data_prq_item.*', 'ref_satuan.nm_satuan', 'b.nm_satuan AS default_satuan', 'b.id_satuan AS default_id_satuan')->get();
if (count($items) < 1) {
return redirect('/sph/select')->withNotif(['label' => 'danger', 'err' => 'Anda belum memilih item barang untuk dijadikan SPH']);
}
//$vendors = data_vendor::whereStatus(1)->get();
if ($id > 0) {
$sph = data_sph_grup::whereId_sph_grup($id);
if ($sph->count() < 1) {
return redirect('/sph')->withNotif(['label' => 'danger', 'err' => 'SPH tidak ditemukan!']);
}
$sp = $sph->first();
$no_sph = $sp->no_sph;
} else {
$no_sph = 0;
}
$ids = [];
foreach ($items as $i) {
$ids[] = $i->id_barang;
}
$ids = json_encode($ids);
return view('Pembelian.SPH.CreateSPH', ['items' => $items, 'id' => $id, 'no_sph' => $no_sph, 'ids' => $ids]);
}
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]);
}
public function getCreate()
{
$items = data_prq_item::join('data_prq', 'data_prq.id_prq', '=', 'data_prq_item.id_prq')->join('data_barang', 'data_barang.id_barang', '=', 'data_prq_item.id_barang')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_prq_item.id_satuan')->join('ref_satuan AS b', 'b.id_satuan', '=', 'data_barang.id_satuan')->whereIn('data_prq_item.id_prq_item', $this->ids)->select('data_prq.no_prq', 'data_prq.id_prq', 'data_barang.nm_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'data_prq_item.*', 'ref_satuan.nm_satuan', 'b.nm_satuan AS default_satuan', 'b.id_satuan AS default_id_satuan')->get();
if (count($items) < 1) {
return redirect('/po/select')->withNotif(['label' => 'danger', 'err' => 'Anda belum memilih item barang untuk dijadikan SPH']);
}
$vendors = data_vendor::whereStatus(1)->get();
$ids = [];
foreach ($items as $i) {
$ids[] = $i->id_barang;
}
$ids = json_encode($ids);
return view('Pembelian.PO.Create', ['items' => $items, 'vendors' => $vendors, 'id' => 0, 'no_sph' => 0, 'ids' => $ids]);
}
