/** * Execute the job. * * @return void */ public function handle() { try { \DB::begintransaction(); $spb = data_spb::find($this->req['id_spb']); $item = data_spb_item::whereId_spb($this->req['id_spb'])->select('id_gudang')->first(); $gudang = $item->id_gudang; foreach ($this->req['id_barang'] as $i => $id) { if (!empty($this->req['qty'][$i])) { $items = data_spb_item::firstOrCreate(['id_spb' => $this->req['id_spb'], 'id_item' => $id, 'status' => 1]); $qty = \Format::convertSatuan($id, $this->req['satuan'][$i], $this->req['id_satuan'][$i]) * $this->req['qty'][$i]; $items->update(['id_gudang' => $gudang, 'qty_awal' => $qty, 'qty' => $qty, 'qty_lg' => $this->req['qty'][$i], 'keterangan' => $this->req['kets'][$i], 'id_satuan' => $this->req['satuan'][$i]]); } } \Loguser::create('Menambahkan item tambahan terhadap PMB/PMO No. ' . $spb->no_spb); \DB::commit(); return ['res' => true, 'label' => 'success', 'err' => $spb->no_spb . ' berhasil ditambahkan!']; } catch (\Exception $e) { \DB::rollback(); return ['res' => false, 'label' => 'danger', 'err' => $e->getMessage()]; } }
/** * Execute the job. * * @return void */ public function handle() { try { \DB::begintransaction(); $spb = data_spb::create(['id_departemen' => \Me::data()->id_departemen, 'id_pemohon' => \Me::data()->id_karyawan, 'keterangan' => $this->req['ket'], 'id_acc' => 0, 'deadline' => date('Y-m-d', strtotime($this->req['deadline'])), 'tipe' => $this->req['tipe']]); $gudang = empty($this->req['id_gudang']) ? 0 : $this->req['id_gudang']; foreach ($this->req['id_barang'] as $i => $id) { if (!empty($this->req['qty'][$i])) { $qty = \Format::convertSatuan($id, $this->req['satuan'][$i], $this->req['id_satuan'][$i]) * $this->req['qty'][$i]; data_spb_item::create(['id_spb' => $spb->id_spb, 'id_item' => $id, 'qty_awal' => $qty, 'qty' => $qty, 'qty_lg' => $this->req['qty'][$i], 'keterangan' => $this->req['kets'][$i], 'status' => 1, 'id_gudang' => $gudang, 'id_satuan' => $this->req['satuan'][$i]]); } } $kode = $this->req['tipe'] == 1 ? 'PMO-' : 'PMB-'; $spb->no_spb = $kode . \Format::code($spb->id_spb); $spb->save(); \Loguser::create('Membuat Pengajuan barang No. ' . $spb->no_spb); \DB::commit(); return ['res' => true, 'label' => 'success', 'err' => 'Permohonan Barang berhasil terkirim dengan Nomor ' . $spb->no_spb]; } catch (\Exception $e) { \DB::rollback(); return ['res' => false, 'label' => 'danger', 'err' => $e->getMessage()]; } }
/** * Execute the job. * * @return void */ public function handle() { try { \DB::begintransaction(); $spb = data_spb::find($this->req['id_spb']); $spb->keterangan = $this->req['ket']; $spb->deadline = date('Y-m-d', strtotime($this->req['deadline'])); $spb->save(); data_spb_item::where('id_spb', $this->req['id_spb'])->delete(); $gudang = empty($this->req['id_gudang']) ? 0 : $this->req['id_gudang']; foreach ($this->req['id_barang'] as $i => $id) { if (!empty($this->req['qty'][$i])) { $qty = \Format::convertSatuan($id, $this->req['satuan'][$i], $this->req['id_satuan'][$i]) * $this->req['qty'][$i]; data_spb_item::create(['id_spb' => $spb->id_spb, 'id_item' => $id, 'qty_awal' => $qty, 'qty' => $qty, 'qty_lg' => $this->req['qty'][$i], 'keterangan' => $this->req['kets'][$i], 'status' => 1, 'id_gudang' => $gudang, 'id_satuan' => $this->req['satuan'][$i]]); } } \Loguser::create('Melakukan perubahan terhadap data PMB/PMO No. ' . $spb->no_spb); \DB::commit(); return ['label' => 'success', 'err' => 'Sukses, No ' . $spb->no_spb . ' berhasil diperbaharui.']; } catch (\Exception $e) { \DB::rollback(); return ['label' => 'danger', 'err' => $e->getMessage()]; } }
public function getPrint($id) { $find = data_spb::join('data_karyawan AS a', 'a.id_karyawan', '=', 'data_spb.id_pemohon')->join('data_departemen', 'data_departemen.id_departemen', '=', 'data_spb.id_departemen')->join('data_skb', 'data_skb.id_spb', '=', 'data_spb.id_spb')->join('data_karyawan AS b', 'b.id_karyawan', '=', 'data_skb.id_petugas')->where('data_skb.id_skb', $id)->select('data_spb.*', 'a.nm_depan', 'a.nm_belakang', 'data_departemen.nm_departemen', 'b.nm_depan As petugas_depan', 'b.nm_belakang AS petugas_belakang', 'data_skb.no_skb'); $spb = $find->first(); $items = data_skb_item::byskb($id)->get(); //dd($items); return view('Print.Pengadaan.SKB', ['spb' => $spb, 'items' => $items]); }
public function postAdditemspb(Request $req) { $find = data_spb::where('id_spb', $req->id_spb)->where('status', 1)->count(); if ($find == 0) { return redirect()->back()->withNotif(['label' => 'warning', 'err' => 'Maaf, Nomor permintaan tersebut sudah diperoses beberapa saat lalu!']); } $spb = $this->dispatch(new AdditemSPBJob($req->all())); if ($spb['res']) { $req->session()->forget($this->MySession); return redirect('/pmbumum/editspb/' . $req->id_spb)->withNotif(['label' => $spb['label'], 'err' => $spb['err']]); } else { return redirect()->back()->withNotif(['label' => $spb['label'], 'err' => $spb['err']]); } }
public function getPrintspb(Request $req) { $items = data_spb::with(['rekap' => function ($query) { $query->join('data_barang', 'data_barang.id_barang', '=', 'data_spb_item.id_item')->join('ref_satuan', 'data_barang.id_satuan', '=', 'ref_satuan.id_satuan'); }])->rekapspb($req->all())->get(); return view('Print.Transaksi.SPB', ['items' => $items, 'req' => $req]); }