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