public function getLogharga(Request $req)
{
if ($req->ajax()) {
$res = [];
$items = data_po_item::join('data_po', 'data_po.id_po', '=', 'data_po_item.id_po')->where('data_po.id_vendor', $req->vendor)->whereIn('data_po.status', [1, 2, 3])->where('data_po_item.id_item', $req->id_barang)->orderby('data_po_item.id_po_item', 'desc')->select('data_po.no_po', 'data_po.id_po', 'data_po.created_at', 'data_po.status', 'data_po_item.harga')->paginate(10);
$status = [1 => 'Baru', 2 => 'Proses', 3 => 'Selesai'];
$out = '<table class="table table-striped" >
<thead>
<tr>
<th>PO</th>
<th>Tanggal</th>
<th>Status</th>
<th class="text-right">Harga</th>
</tr>
</thead>
<tbody>
';
if ($items->total() > 0) {
foreach ($items as $item) {
$out .= '<tr>
<td>
<a href="' . url('/po/print/' . $item->id_po) . '" target="_blank">' . $item->no_po . '</a>
</td>
<td>
' . \Format::indoDate($item->created_at) . '<br />
<div><small class="text-muted">' . \Format::hari($item->created_at) . ', ' . \Format::jam($item->created_at) . '</small></div>
</td>
<td>' . $status[$item->status] . '</td>
<td class="text-right">' . number_format($item->harga, 0, ',', '.') . '</td>
</tr>';
}
} else {
$out .= '<tr>
<td colspan="4">Tidak ditemukan</td>
<tr>';
}
$out .= '</tbody></table>';
$vendor = data_vendor::find($req->vendor);
$barang = data_barang::find($req->id_barang);
$res['vendor'] = $vendor->nm_vendor;
$res['kode'] = $barang->kode;
$res['content'] = $out;
$res['pagin'] = $items->render();
return json_encode($res);
}
}
public function getEdit($id)
{
$p = data_po::whereId_po($id);
if ($p->count() < 1) {
return redirect('/po')->withNotif(['label' => 'warning', 'err' => 'PO tidak tersedia!']);
}
$po = $p->first();
if ($po->status > 1) {
return redirect('/po')->withNotif(['label' => 'warning', 'err' => 'PO tidak tersedia!']);
}
// Filter
if ($po->id_sph > 0) {
$sph = data_sph::find($po->id_sph);
return redirect('/po')->withNotif(['label' => 'warning', 'err' => 'PO No. ' . $po->no_po . ' tidak dapat di perbaharui karena pembuatannya melalui proses Pengajuan Harga. Dengan No. ' . $sph->no_sph_item]);
}
$items = data_po_item::join('data_barang', 'data_barang.id_barang', '=', 'data_po_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_barang.id_satuan')->where('data_po_item.id_po', $id)->select('data_barang.nm_barang', 'data_barang.id_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'data_po_item.*', 'ref_satuan.nm_satuan')->get();
$ids = [];
foreach ($items as $i) {
$ids[] = $i->id_barang;
}
$ids = json_encode($ids);
return view('Pembelian.PO.EditPO', ['po' => $po, 'items' => $items, 'id' => $id, 'no_sph' => 0, 'ids' => $ids]);
}
