public function getVendors(Request $req) { if ($req->ajax()) { $res = []; $out = '<option value="0">Pilih Penyedia</option>'; $vendors = data_vendor::whereStatus(1)->get(); foreach ($vendors as $ven) { $select = $req->idselect == $ven->id_vendor ? 'selected="selected"' : ''; $out .= '<option ' . $select . ' value="' . $ven->id_vendor . '">' . $ven->nm_vendor . '</option>'; } $res['content'] = $out; return json_encode($res); } }
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]); }