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