/**
* Execute the job.
*
* @return void
*/
public function handle()
{
try {
\DB::begintransaction();
$id_karyawan = \Me::data()->id_karyawan;
$barang = data_barang::find($this->req['id']);
$barang->update(['nm_barang' => $this->req['nm_barang'], 'id_kategori' => $this->req['id_kategori'], 'id_satuan' => $this->req['id_satuan'], 'stok_minimal' => $this->req['stok_minimal'], 'keterangan' => $this->req['keterangan'], 'tipe' => $this->req['tipe'], 'ppn' => $this->req['ppn'], 'harga_beli' => $this->req['harga_beli'], 'harga_jual' => $this->req['harga_jual'], 'id_klasifikasi' => $this->req['id_klasifikasi']]);
data_barang_detail::where('id_barang', $this->req['id'])->delete();
if (isset($this->req['labels']) && count($this->req['labels']) > 0) {
foreach ($this->req['labels'] as $i => $val) {
if (strlen($val) > 0 && strlen($this->req['values'][$i]) > 0) {
data_barang_detail::create(['id_barang' => $this->req['id'], 'label' => ucwords($val), 'nm_detail' => $this->req['values'][$i]]);
}
}
}
ref_konversi_satuan::where('id_barang', $this->req['id'])->delete();
ref_konversi_satuan::create(['id_barang' => $barang->id_barang, 'id_satuan_max' => $this->req['id_satuan'], 'id_satuan_min' => $this->req['id_satuan'], 'qty' => 1]);
if (isset($this->req['koversi_satuan']) && count($this->req['koversi_satuan']) > 0) {
foreach ($this->req['koversi_satuan'] as $i => $id_satuan) {
if ($id_satuan > 0) {
ref_konversi_satuan::create(['id_barang' => $barang->id_barang, 'id_satuan_max' => $id_satuan, 'id_satuan_min' => $this->req['id_satuan'], 'qty' => $this->req['koversi_qty'][$i]]);
}
}
}
if ($this->req['harga_beli'] != $this->req['last_harga']) {
data_harga::create(['id_barang' => $barang->id_barang, 'harga' => $this->req['harga_beli'], 'keterangan' => 'Update harga dari ' . number_format($this->req['last_harga'], 0, ',', '.'), 'id_karyawan' => $id_karyawan, 'tipe' => 1]);
}
if ($this->req['harga_jual'] != $this->req['last_harga_jual']) {
data_harga::create(['id_barang' => $barang->id_barang, 'harga' => $this->req['harga_jual'], 'keterangan' => 'Update harga dari ' . number_format($this->req['last_harga_jual'], 0, ',', '.'), 'id_karyawan' => $id_karyawan, 'tipe' => 2]);
}
// Pengkodean
$tipe = $this->req['tipe'] == 1 ? 'O-' : 'B-';
$kat = ref_kategori::find($this->req['id_kategori']);
$kats = $kat->alias . '-';
$urut = \Format::code($barang->id_barang);
$jj = '';
if ($this->req['tipe'] == 1) {
$kls = ref_klasifikasi::find($this->req['id_klasifikasi']);
$jj = '-' . $kls->kode;
}
$kode = $tipe . $kats . $urut . $jj;
$barang->kode = $kode;
$barang->save();
\Loguser::create('Melakukan perubahan terhada data master gudang Kode. ' . $barang->kode);
\DB::commit();
return ['label' => 'success', 'err' => $this->req['nm_barang'] . ' Berhasil diperbaharui'];
} catch (\Exception $e) {
\DB::rollback();
return ['label' => 'danger', 'err' => $e->getMessage()];
}
}
public function getAllitems(Request $req)
{
if ($req->ajax()) {
$res = [];
$items = ref_konversi_satuan::join('ref_satuan AS a', 'a.id_satuan', '=', 'ref_konversi_satuan.id_satuan_max')->join('ref_satuan AS b', 'b.id_satuan', '=', 'ref_konversi_satuan.id_satuan_min')->join('data_barang', 'data_barang.id_barang', '=', 'ref_konversi_satuan.id_barang')->select('data_barang.nm_barang', 'a.nm_satuan as satuan_max', 'b.nm_satuan as satuan_min', 'ref_konversi_satuan.qty', 'ref_konversi_satuan.id', 'ref_konversi_satuan.created_at')->paginate(10);
$out = '';
if ($items->total() > 0) {
$no = $items->currentPage() == 1 ? 1 : $items->perPage() * $items->currentPage() - $items->perPage() + 1;
foreach ($items as $item) {
$out .= '
<tr class="item_' . $item->id . ' items">
<td>' . $no . '</td>
<td>' . $item->nm_barang . '</td>
<td>
<a href="javascript:;" title="' . $item->id_satuan_max . '" data-toggle="tooltip" data-placement="bottom">' . $item->satuan_max . '</a>
</td>
<td>' . $item->satuan_min . '</td>
<td>' . $item->qty . '</td>
<td>
<div>
' . \Format::indoDate($item->created_at) . '
</div>
<small class="text-muted">' . \Format::hari($item->created_at) . ', ' . \Format::jam($item->created_at) . '</small>
</td>
</tr>
';
$no++;
}
} else {
$out = '
<tr>
<td colspan="6">Tidak ditemukan</td>
</tr>
';
}
$res['data'] = $out;
$res['pagin'] = $items->render();
return json_encode($res);
}
}
/**
* Edit barang
* @access Admin Logistik
* @author @hexters
*/
public function getUpdate($id)
{
$item = data_barang::find($id);
if ($item == null) {
return redirect('/logistik')->withNotif(['label' => 'danger', 'err' => 'Maaf, Tidak ditemukan !']);
}
if (!in_array($item->tipe, \Me::accessGudang())) {
return redirect('/logistik')->withNotif(['label' => 'danger', 'err' => 'Maaf Bukan domain anda!']);
}
$user = data_karyawan::find($item->id_karyawan);
$details = data_barang_detail::where('id_barang', $item->id_barang)->get();
$konversi = ref_konversi_satuan::where('ref_konversi_satuan.id_barang', $id)->whereNotIn('ref_konversi_satuan.id_satuan_max', [$item->id_satuan])->get();
return view('Pengadaan.Update', ['kategoris' => ref_kategori::all(), 'satuan' => ref_satuan::all(), 'item' => $item, 'oleh' => $user->nm_depan . ' ' . $user->nm_belakang, 'details' => $details, 'klasifikasi' => ref_klasifikasi::all(), 'konversi' => $konversi]);
}
public function getSatuans(Request $req)
{
if ($req->ajax()) {
$res = [];
$res['ids'] = $req->ids;
$sels = $req->sels;
foreach ($req->ids as $id) {
$converts = ref_konversi_satuan::join('ref_satuan', 'ref_satuan.id_satuan', '=', 'ref_konversi_satuan.id_satuan_max')->where('ref_konversi_satuan.id_barang', $id)->select('ref_konversi_satuan.*', 'ref_satuan.nm_satuan');
if ($converts->count() > 0) {
$out = '<select name="satuan[]" class="form-control">';
foreach ($converts->get() as $kon) {
if (count($sels) > 0) {
$sel = $sels[$id] == $kon->id_satuan_max ? 'selected="selected"' : '';
$out .= '<option ' . $sel . ' value="' . $kon->id_satuan_max . '">' . $kon->nm_satuan . '</option>';
} else {
$out .= '<option value="' . $kon->id_satuan_max . '" >' . $kon->nm_satuan . '</option>';
}
}
$out .= '</select>';
$res['result'][$id] = true;
$res['content'][$id] = $out;
} else {
$res['result'][$id] = false;
}
}
return json_encode($res);
}
}
public function convertSatuan($id, $idmax, $idmin)
{
$convert = ref_konversi_satuan::where('id_barang', $id)->where('id_satuan_max', $idmax)->where('id_satuan_min', $idmin)->select('qty');
if ($convert->count() > 0) {
$c = $convert->first();
return $c->qty;
} else {
return 1;
}
}
