public function getAllitems(Request $req)
{
if ($req->ajax()) {
$res = [];
$tipes = [1 => 'Obat', 2 => 'Barang'];
$fileds = $req->sort;
switch ($fileds) {
case "barang":
$filed = 'data_barang.nm_barang';
break;
case "kode":
$filed = 'data_barang.kode';
break;
case "kategori":
$filed = 'ref_kategori.nm_kategori';
break;
case "waktu":
$filed = 'data_barang.created_at';
break;
default:
$filed = 'data_barang.nm_barang';
}
if ($req->stok === 'true') {
$items = data_barang::detailslimit($req->src, $req->kat, $filed, $req->orderby, $req->tipe, $req->kode)->paginate($req->limit);
} else {
$items = data_barang::details($req->src, $req->kat, $filed, $req->orderby, $req->tipe, $req->kode)->paginate($req->limit);
}
$out = '';
$total = $items->total();
if ($total > 0) {
$no = $items->currentPage() == 1 ? 1 : $items->perPage() * $items->currentPage() - $items->perPage() + 1;
foreach ($items as $item) {
$link = \Auth::user()->permission > 1 ? '| <a href="' . url('/logistik/update/' . $item->id_barang) . '">Edit</a> ' : '';
$info = $item->stok_minimal >= $item->in - $item->out ? '<small class="text-danger semi-bold">(Stok Limit)</small>' : '';
$btn = \Auth::user()->permission > 2 ? '<button type="button" class="close hapus" onclick="hapus(\'' . $item->nm_barang . '\', ' . $item->id_barang . ');"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>' : '';
$out .= '
<tr class="item_' . $item->id_barang . ' items">
<td>' . $no . '</td>
<td>
<a href="javascript:;" title="' . $item->nm_barang . '" data-toggle="tooltip" data-placement="bottom">' . \Format::substr($item->nm_barang, 15) . '</a>
<div style="display:none;" class="tbl-opsi">
<small>[
<a href="#" data-toggle="modal" data-target="#review" onclick="review(' . $item->id_barang . ')">Lihat</a>
| <a href="' . url('/logistik/detail/' . $item->id_barang) . '">Rinci</a>
' . $link . '
]</small>
</div>
</td>
<td>
' . $item->kode . '<br />
<small class="text-muted">' . \Format::hari($item->created_at) . ', ' . \Format::indoDate($item->created_at) . '</small>
</td>
<td title="' . $item->nm_kategori . '">' . \Format::substr($item->nm_kategori, 20) . '</td>
<td>' . $tipes[$item->tipe] . '</td>
<td class="text-right">
' . number_format($item->in - $item->out, 0, ',', '.') . ' ' . $item->nm_satuan . '
<div>' . $info . '</div>
</td>
<td class="text-right">
' . $btn . '
</td>
</tr>
';
$no++;
}
} else {
$out = '
<tr>
<td colspan="7">Tidak ditemukan</td>
</tr>
';
}
$res['data'] = $out;
$res['pagin'] = $items->render();
$res['total'] = number_format($total, 0, ',', '.');
return json_encode($res);
}
}
