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);
}
}
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);
}
}
