/** * Execute the job. * * @return void */ public function handle() { try { //dd($this->req); \DB::begintransaction(); $me = \Me::data()->id_karyawan; // Create PO $po = data_po::create(['id_sph' => $this->req['id'], 'id_vendor' => $this->req['vendor'], 'deadline' => $this->req['deadline'], 'id_pembuat' => $me, 'id_acc' => 0, 'adjustment' => $this->req['adjustment'], 'diskon' => $this->req['gdiskon'], 'ppn' => $this->req['gppn'], 'keterangan' => $this->req['ket'], 'titipan' => $this->req['titipan']]); foreach ($this->req['id_barang'] as $i => $id_barang) { data_po_item::create(['id_po' => $po->id_po, 'id_item' => $id_barang, 'req_qty' => $this->req['qty'][$i], 'qty' => $this->req['qty'][$i], 'harga' => $this->req['harga'][$i], 'diskon' => $this->req['diskon'][$i], 'keterangan' => $this->req['kets'][$i], 'id_satuan' => $this->req['satuan'][$i], 'id_prq' => $this->req['id_prq'][$i]]); data_prq::find($this->req['id_prq'][$i])->update(['status' => 2]); // update Harga data_barang::find($id_barang)->update(['harga_beli' => $this->req['harga'][$i]]); // Update Log harga data_harga::create(['id_barang' => $id_barang, 'harga' => $this->req['harga'][$i], 'keterangan' => 'Update berdasarkan PO', 'id_po' => $po->id_po, 'id_karyawan' => $me, 'tipe' => 1]); data_prq_item::find($this->req['id_prq_item'][$i])->update(['status' => 2]); } $format = 'PO-'; $po->no_po = $format . \Format::code($po->id_po); $po->save(); \Loguser::create('Membuat PO dengan No. PO ' . $po->no_po); \DB::commit(); return ['result' => true, 'err' => 'PO berhasil dibuat dengan No. ' . $po->no_po]; } catch (\Exception $e) { \DB::rollback(); return ['result' => false, 'err' => $e->getMessage()]; } }
/** * Execute the job. * * @return void */ public function handle() { try { \DB::begintransaction(); $me = \Me::data()->id_karyawan; $retur = data_retur::create(['tipe' => 2, 'id_po' => $this->req['id_po'], 'id_vendor' => $this->req['id_vendor'], 'id_karyawan' => $me]); data_po::find($this->req['id_po'])->update(['status' => 2]); foreach ($this->req['id_barang'] as $i => $id_barang) { if (!empty($this->req['qty'][$i])) { data_retur_item::create(['id_retur' => $retur->id_retur, 'id_barang' => $id_barang, 'id_satuan' => $this->req['id_satuan'][$i], 'qty' => $this->req['qty'][$i], 'qty_lg' => $this->req['qty'][$i]]); // Log Stok data_log_barang::create(['id_barang' => $id_barang, 'qty' => $this->req['qty'][$i], 'id_gudang' => 0, 'kondisi' => 2, 'tipe' => 5, 'id_parent' => $retur->id_retur, 'id_karyawan' => $me]); // Update stok $barang = data_barang::find($id_barang); $barang->out = $barang->out + $this->req['qty'][$i]; $barang->save(); // Update data PO items $itm = data_po_item::where('id_po', $this->req['id_po'])->where('id_item', $id_barang)->first(); $qpo = $itm->qty + $this->req['qty'][$i]; data_po_item::where('id_po', $this->req['id_po'])->where('id_item', $id_barang)->update(['qty' => $qpo, 'status' => 1]); } } $format = 'EX-RTN-'; $kode = $format . \Format::code($retur->id_retur); $retur->no_retur = $kode; $retur->save(); \Loguser::create('Membuat Retur Pembelian dengan No. ' . $kode); \DB::commit(); return ['result' => true, 'label' => 'success', 'err' => 'Return Pembelian berhasil dibuat dengan No. ' . $kode]; } catch (\Exception $e) { \DB::rollback(); return ['result' => false, 'label' => 'danger', 'err' => $e->getMessage()]; } }
/** * Execute the job. * * @return void */ public function handle() { try { //dd($this->req); \DB::begintransaction(); $me = \Me::data()->id_karyawan; // Create PO $po = data_po::find($this->req['id']); $po->update(['id_vendor' => $this->req['vendor'], 'deadline' => $this->req['deadline'], 'adjustment' => $this->req['adjustment'], 'diskon' => $this->req['gdiskon'], 'ppn' => $this->req['gppn'], 'keterangan' => $this->req['ket']]); data_po_item::whereId_po($this->req['id'])->delete(); foreach ($this->req['id_barang'] as $i => $id_barang) { data_po_item::create(['id_po' => $po->id_po, 'id_item' => $id_barang, 'req_qty' => $this->req['qty'][$i], 'qty' => $this->req['qty'][$i], 'harga' => $this->req['harga'][$i], 'diskon' => $this->req['diskon'][$i], 'keterangan' => $this->req['kets'][$i], 'id_satuan' => $this->req['satuan'][$i]]); // update Harga data_barang::find($id_barang)->update(['harga_beli' => $this->req['harga'][$i]]); // Update Log harga data_harga::create(['id_barang' => $id_barang, 'harga_beli' => $this->req['harga'][$i], 'keterangan' => 'Update berdasarkan pembaharuan PO', 'id_po' => $po->id_po, 'id_karyawan' => $me]); } \Loguser::create('Melakukan perubahan data PO No. ' . $po->no_po); \DB::commit(); return ['result' => true, 'err' => 'PO berhasil diperbaharui']; } catch (\Exception $e) { \DB::rollback(); return ['result' => false, 'err' => $e->getMessage()]; } }
public function getDatapembelian(Request $req) { if ($req->ajax()) { $res = []; $out = ''; $kat = []; $seri = []; $items = data_po::grafikpembelian($req->tahun)->get(); foreach ($items as $item) { $kat[] = \Format::indoDate2($item->tanggal); $seri[] = (int) $item->total; } $res['po'] = ['kategori' => $kat, 'data' => $seri]; $kato = []; $serio = []; $obats = data_po_item::grafikpembelian(1, $req->tahun)->get(); foreach ($obats as $o) { $kato[] = \Format::indoDate2($o->tanggal); $serio[] = (int) $o->total; } $res['obat'] = ['kategori' => $kato, 'data' => $serio]; $katb = []; $serib = []; $barangs = data_po_item::grafikpembelian(2, $req->tahun)->get(); foreach ($barangs as $b) { $katb[] = \Format::indoDate2($b->tanggal); $serib[] = (int) $b->total; } $res['barang'] = ['kategori' => $katb, 'data' => $serib]; return json_encode($res); } }
/** * Execute the job. * * @return void */ public function handle() { //dd($this->req); try { \DB::begintransaction(); $gr = data_spbm::create(['no_surat_jalan' => $this->req['sj'], 'tgl_terima_barang' => $this->req['tgl_terima'], 'tgl_periksa_barang' => $this->req['tgl_periksa'], 'id_kirim' => $this->req['pengiriman'], 'keterangan' => $this->req['keterangan'], 'id_po' => $this->req['id_po'], 'pemeriksa1' => $this->req['pemeriksa1'], 'pemeriksa2' => $this->req['pemeriksa2'], 'nm_pengirim' => $this->req['nm_pengirim'], 'titipan' => $this->req['titipan'], 'id_karyawan' => \Me::data()->id_karyawan]); $statuspo = []; foreach ($this->req['id_po_item'] as $i => $id_po_item) { if (!empty($this->req['qty_lg'])) { $qty = \Format::convertSatuan($this->req['id_barang'][$i], $this->req['id_satuan'][$i], $this->req['id_satuan_default'][$i]) * $this->req['qty_lg'][$i]; data_spbm_item::create(['id_spbm' => $gr->id_spbm, 'id_barang' => $this->req['id_barang'][$i], 'bonus' => $this->req['bonus'][$i], 'id_satuan' => $this->req['id_satuan'][$i], 'qty_lg' => $this->req['qty_lg'][$i], 'qty' => $qty, 'merek' => $this->req['merek'][$i], 'barang_sesuai' => $this->req['barang_sesuai'][$i], 'keterangan' => $this->req['kets'][$i], 'tgl_exp' => $this->req['tgl_exp'][$i], 'sisa' => $qty]); // Perubahan Status Item PO if ($this->req['bonus'][$i] == 0) { $itempo = data_po_item::find($this->req['id_po_item'][$i]); if ($this->req['qty_lg'][$i] >= $this->req['req_qty'][$i]) { $itempo->status = 3; $itempo->qty = $itempo->qty - $this->req['qty_lg'][$i]; $itempo->save(); // Perubahan status PRQ $count = data_prq_item::where('id_prq', $itempo->id_prq)->where('status', 1)->count(); if ($count == 0) { data_prq::find($itempo->id_prq)->update(['status' => 3]); } } else { $statuspo[] = 1; $itempo->status = 2; $itempo->qty = $itempo->qty - $this->req['qty_lg'][$i]; $itempo->save(); } } // Log Stok data_log_barang::create(['id_barang' => $this->req['id_barang'][$i], 'qty' => $qty, 'keterangan' => 'Good Receive', 'id_gudang' => 0, 'kondisi' => 1, 'tipe' => 2, 'id_parent' => $gr->id_spbm, 'id_karyawan' => \Me::data()->id_karyawan]); // Udate Stok ke data barang $b = data_barang::find($this->req['id_barang'][$i]); $b->in = $b->in + $qty; $b->save(); } } // Merubah Status PO $po = data_po::find($this->req['id_po']); if (count($statuspo) > 0) { $po->update(['status' => 2]); } else { $po->update(['status' => 3]); } $format = 'GR-'; $gr->no_spbm = $format . \Format::code($gr->id_spbm); $gr->save(); \Loguser::create('Membuat Permohonan Barang Masuk dengan No. ' . $gr->no_spbm); \DB::commit(); return ['label' => 'seccess', 'err' => 'PO berhasil diproses! dengan No. ' . $gr->no_spbm]; } catch (\Exception $e) { \DB::rollback(); return ['label' => 'danger', 'err' => $e->getMessage()]; } }
/** * Execute the job. * * @return void */ public function handle() { try { \DB::begintransaction(); $me = \Me::data()->id_karyawan; $sph = data_sph::find($this->req['id_sph']); $grup = data_sph_grup::whereId_sph_grup($sph->id_sph_grup)->select('status')->first(); if ($grup->status == 2) { throw new \Exception("Maaf SPH No. " . $sph->no_sph_item . " sudah kadaluarsa!", 1); } // Create PO $po = data_po::create(['id_sph' => $this->req['id_sph'], 'id_vendor' => $sph->id_vendor, 'deadline' => $sph->deadline, 'id_pembuat' => $me, 'id_acc' => 0, 'adjustment' => $sph->adjustment, 'diskon' => $sph->diskon, 'ppn' => $sph->ppn, 'keterangan' => $sph->keterangan]); $items = data_sph_item::whereId_sph($this->req['id_sph'])->get(); foreach ($items as $item) { data_po_item::create(['id_po' => $po->id_po, 'id_item' => $item->id_item, 'req_qty' => $item->qty, 'qty' => $item->qty, 'harga' => $item->harga, 'diskon' => $item->diskon, 'ppn' => $item->ppn, 'pph' => $item->pph, 'keterangan' => $item->keterangan, 'id_satuan' => $item->id_satuan, 'id_prq' => $item->id_prq]); // update Harga data_barang::find($item->id_item)->update(['harga_beli' => $item->harga]); // Update Log harga data_harga::create(['id_barang' => $item->id_item, 'harga' => $item->harga, 'keterangan' => 'Update berdasarkan PO', 'id_po' => $po->id_po, 'id_karyawan' => $me, 'tipe' => 1]); data_prq_item::whereId_prq($item->id_prq)->whereId_barang($item->id_item)->update(['status' => 2]); } $format = 'PO-'; $po->no_po = $format . \Format::code($po->id_po); $po->save(); // Update data SPH Grup data_sph_grup::find($this->req['id_sph_grup'])->update(['status' => 2]); // Update data sph $sph->status = 2; $sph->save(); \Loguser::create('Menjadikan SPH denga No. ' . $sph->no_sph . ' menjadi PO dengan No. ' . $po->no_po); \DB::commit(); return ['err' => 'Po Berhail di buat dengan No. ' . $po->no_po]; } catch (\Exception $e) { \DB::rollback(); return ['err' => $e->getMessage()]; } }
public function postAddbonus(Request $req) { if ($req->ajax()) { $res = []; $out = ''; $item = data_po_item::bypo($req->id); $res['content'] = ' <tr class="bonus-' . $req->id . ' item-bonus"> <td title="' . $item->nm_barang . '"> ' . $item->nm_barang . ' <div class="text-muted"><small>' . $item->kode . '</small></div> <input type="hidden" name="bonus[]" value="1"> <input type="hidden" name="id_po_item[]" value="' . $req->id . '"> <input type="hidden" name="id_barang[]" value="' . $item->id_item . '"> <input type="hidden" name="barang_sesuai[]" value="1"> <input type="hidden" name="req_qty[]" value="0"> <input type="hidden" name="id_satuan[]" value="' . $item->id_satuan . '"> <input type="hidden" name="id_satuan_default[]" value="' . $item->id_satuan_default . '"> </td> <td> <input type="text" data-exp="bonus" name="tgl_exp[]" class="form-control" value="' . date('Y-m-d', strtotime('+1 year')) . '" required="required" readonly="readonly" /> </td> <td> <div class="input-group transparent"> <span class="input-group-addon"></span> <input type="number" name="qty_lg[]" class="text-right form-control" required /> <span class="input-group-addon"> <small>' . $item->nm_satuan . '</small> </span> </div> </td> <td> <button class="btn btn-white" type="button" data-toggle="tooltip" onclick="rmbonus(' . $req->id . ');" data-placement="bottom" title="Hapus Bonus"><i class="fa fa-times"></i></button> <input type="hidden" name="merek[]" value="" class="form-control"> <input type="hidden" name="kets[]" value="Bonus" class="form-control"> </td> </tr> '; return json_encode($res); } }
public function getPrint(Request $req) { $items = data_po_item::laporan($req->all())->get(); return view('Laporan.Pembelian.PO.Print', ['items' => $items, 'req' => $req]); }
public function getAdditempo(Request $req) { if ($req->ajax()) { $res = []; $out = []; $po = data_po::find($req->id); $items = data_po_item::allpo($req->id)->get(); foreach ($items as $item) { /* MATEMATIKA */ $diskon = $item->harga * $item->diskon / 100; $aftdiskon = $item->harga - $diskon; $ppn = $aftdiskon + $item->ppn; $pph = $aftdiskon + $item->pph; $harga = $aftdiskon + $ppn + $pph; $out[] = ['id_barang' => $item->id_item, 'kode' => $item->kode, 'nm_barang' => $item->nm_barang, 'id_satuan' => $item->id_satuan, 'nm_satuan' => $item->nm_satuan, 'qty' => $item->req_qty, 'diskon' => $item->diskon, 'ppn' => $item->ppn, 'pph' => $item->pph, 'harga' => $item->harga, 'total' => $harga * $item->req_qty]; } $res['po'] = $po; $res['items'] = $out; return json_encode($res); } }
public function getPrintprodusen(Request $req) { $items = $items = data_po_item::rekapprodusesn($req->all())->get(); return view('Print.Laporan.BelanjaProdusen', ['items' => $items]); }
public function getLogharga(Request $req) { if ($req->ajax()) { $res = []; $items = data_po_item::join('data_po', 'data_po.id_po', '=', 'data_po_item.id_po')->where('data_po.id_vendor', $req->vendor)->whereIn('data_po.status', [1, 2, 3])->where('data_po_item.id_item', $req->id_barang)->orderby('data_po_item.id_po_item', 'desc')->select('data_po.no_po', 'data_po.id_po', 'data_po.created_at', 'data_po.status', 'data_po_item.harga')->paginate(10); $status = [1 => 'Baru', 2 => 'Proses', 3 => 'Selesai']; $out = '<table class="table table-striped" > <thead> <tr> <th>PO</th> <th>Tanggal</th> <th>Status</th> <th class="text-right">Harga</th> </tr> </thead> <tbody> '; if ($items->total() > 0) { foreach ($items as $item) { $out .= '<tr> <td> <a href="' . url('/po/print/' . $item->id_po) . '" target="_blank">' . $item->no_po . '</a> </td> <td> ' . \Format::indoDate($item->created_at) . '<br /> <div><small class="text-muted">' . \Format::hari($item->created_at) . ', ' . \Format::jam($item->created_at) . '</small></div> </td> <td>' . $status[$item->status] . '</td> <td class="text-right">' . number_format($item->harga, 0, ',', '.') . '</td> </tr>'; } } else { $out .= '<tr> <td colspan="4">Tidak ditemukan</td> <tr>'; } $out .= '</tbody></table>'; $vendor = data_vendor::find($req->vendor); $barang = data_barang::find($req->id_barang); $res['vendor'] = $vendor->nm_vendor; $res['kode'] = $barang->kode; $res['content'] = $out; $res['pagin'] = $items->render(); return json_encode($res); } }
public function getEdit($id) { $p = data_po::whereId_po($id); if ($p->count() < 1) { return redirect('/po')->withNotif(['label' => 'warning', 'err' => 'PO tidak tersedia!']); } $po = $p->first(); if ($po->status > 1) { return redirect('/po')->withNotif(['label' => 'warning', 'err' => 'PO tidak tersedia!']); } // Filter if ($po->id_sph > 0) { $sph = data_sph::find($po->id_sph); return redirect('/po')->withNotif(['label' => 'warning', 'err' => 'PO No. ' . $po->no_po . ' tidak dapat di perbaharui karena pembuatannya melalui proses Pengajuan Harga. Dengan No. ' . $sph->no_sph_item]); } $items = data_po_item::join('data_barang', 'data_barang.id_barang', '=', 'data_po_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_barang.id_satuan')->where('data_po_item.id_po', $id)->select('data_barang.nm_barang', 'data_barang.id_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'data_po_item.*', 'ref_satuan.nm_satuan')->get(); $ids = []; foreach ($items as $i) { $ids[] = $i->id_barang; } $ids = json_encode($ids); return view('Pembelian.PO.EditPO', ['po' => $po, 'items' => $items, 'id' => $id, 'no_sph' => 0, 'ids' => $ids]); }