/**
* 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()];
}
}
public function getPrint($id = 0)
{
if (empty($id) || !is_numeric($id)) {
return redirect('/gr')->withNotif(['label' => 'danger', 'err' => 'Maaf, tidak ditemukan !']);
}
$gr = data_spbm::byid($id)->first();
if ($gr == null) {
return redirect('/gr')->withNotif(['label' => 'danger', 'err' => 'Maaf, tidak ditemukan !']);
}
$items = data_spbm_item::bygr($id)->get();
$kirim = [1 => 'Dikirim oleh Supplier', 2 => 'Dikirim Oleh Ekspedisi', 3 => 'Diambil Oleh Onkologi'];
return view("Print.Pembelian.GR.printGR", ['items' => $items, 'gr' => $gr, 'kirim' => $kirim]);
}
public function getListexpired(Request $req)
{
if ($req->ajax()) {
$items = data_spbm_item::join('data_spbm', 'data_spbm.id_spbm', '=', 'data_spbm_item.id_spbm')->where('data_spbm_item.id_barang', $req->id_barang)->select('data_spbm_item.tgl_exp', 'data_spbm.no_spbm', 'data_spbm.id_spbm')->paginate(5);
$res = [];
$out = '';
if ($items->total() > 0) {
foreach ($items as $item) {
$out .= '
<tr>
<td>
<a href="' . url('/gr/print/' . $item->id_spbm) . '" target="_blank">' . $item->no_spbm . '</a>
</td>
<td class="text-right">' . \Format::indoDate($item->tgl_exp) . '</td>
</tr>
';
}
} else {
$out = '
<tr>
<td colspan="2">Tidak ditemukan</td>
</tr>
';
}
$res['content'] = $out;
$res['pagin'] = $items->render();
$res['id_barang'] = $req->id_barang;
return json_encode($res);
}
}