public function getDatapembelian(Request $req) { if ($req->ajax()) { $res = []; $out = ''; $kat = []; $seri = []; $items = data_po::grafikpembelian($req->tahun)->get(); foreach ($items as $item) { $kat[] = \Format::indoDate2($item->tanggal); $seri[] = (int) $item->total; } $res['po'] = ['kategori' => $kat, 'data' => $seri]; $kato = []; $serio = []; $obats = data_po_item::grafikpembelian(1, $req->tahun)->get(); foreach ($obats as $o) { $kato[] = \Format::indoDate2($o->tanggal); $serio[] = (int) $o->total; } $res['obat'] = ['kategori' => $kato, 'data' => $serio]; $katb = []; $serib = []; $barangs = data_po_item::grafikpembelian(2, $req->tahun)->get(); foreach ($barangs as $b) { $katb[] = \Format::indoDate2($b->tanggal); $serib[] = (int) $b->total; } $res['barang'] = ['kategori' => $katb, 'data' => $serib]; return json_encode($res); } }
public function getAllretur(Request $req) { if ($req->ajax()) { $res = []; $out = ''; $items = data_retur::gudang($req->all())->paginate($req->limit); if ($items->total() > 0) { $no = $items->currentPage() == 1 ? 1 : $items->perPage() * $items->currentPage() - $items->perPage() + 1; foreach ($items as $item) { $out .= ' <tr> <td>' . $no . '</td> <td>' . $item->no_retur . '</td> <td> ' . \Format::indoDate2($item->created_at) . '<br /> <small class="text-muted">' . \Format::hari($item->created_at) . ', ' . \Format::jam($item->created_at) . '</small> </td> <td class="text-right"> <a class="btn btn-white" href="' . url('/returgudang/print/' . $item->id_retur) . '" target="_blank"><i class="fa fa-print"></i></a> </td> </tr> '; $no++; } } else { $out = ' <tr> <td colspan="4">Tidak ditemukan!</td> </tr> '; } $res['content'] = $out; $res['pagin'] = $items->render(); return json_encode($res); } }
public function getGetallprq(Request $req) { if ($req->ajax()) { $res = []; $out = ''; $items = data_prq::listprq($req->all(), $req->status)->paginate($req->limit); $no = $items->currentPage() == 1 ? 1 : $items->perPage() * $items->currentPage() - $items->perPage() + 1; $status = [1 => 'Baru', 2 => 'Proses', 3 => 'Selesai', 4 => 'Hapus']; if ($items->total() > 0) { foreach ($items as $item) { $class = strtotime($item->target) > strtotime(date('Y-m-d')) ? '' : 'class=text-danger'; $selisih = strtotime($item->target) > strtotime(date('Y-m-d')) ? '<small class="text-muted">' . \Format::selisih_hari($item->target, date('Y-m-d')) . 'hari dari sekarang</small>' : ''; $tipe = $item->tipe == 1 ? 'Obat' : 'Barang'; $tanda = empty($item->id_acc) ? '<i class="fa fa-times text-muted pull-right" title="Belum terverifikasi"></i>' : '<i title="Terverifikasi" class="fa fa-check-circle text-success pull-right"></i>'; $edit = $item->status < 2 ? '| <a href="' . url('/prq/edit/' . $item->id_prq) . '">Edit</a>' : ''; $del = \Auth::user()->permission > 1 && $item->status < 2 ? '| <a href="javascript:;" onclick="hapusprq(' . $item->id_prq . ');" class="text-danger">Hapus</a>' : ''; if (!empty($item->tgl_approval) || $item->tgl_approval != '0000-00-00 00:00:00') { $tgl_approval = ' <div>' . \Format::indoDate2($item->tgl_approval) . '</div> <div class="text-muted"><small>' . \Format::hari($item->tgl_approval) . ', ' . \Format::jam($item->tgl_approval) . '</small></div> '; } else { $tgl_approval = '<center>-</center>'; } $out .= ' <tr class="item-prq-' . $item->id_prq . '"> <td>' . $no . '</td> <td> <div> ' . $item->no_prq . ' ' . $tanda . ' </div> <div class="links"> <small> [ <a href="#" data-toggle="modal" data-target="#detailprq" onclick="detailprq(' . $item->id_prq . ')">Lihat</a> ' . $edit . ' ' . $del . ' ] </small> </div> </td> <td> <div ' . $class . '> ' . \Format::indoDate2($item->target) . '</div> ' . $selisih . ' </td> <td title="' . $item->nm_depan . ' ' . $item->nm_belakang . '"> ' . \Format::substr($item->nm_depan . ' ' . $item->nm_belakang, 10) . ' <div><small class="text-muted">' . \Format::indoDate($item->created_at) . '</small></div> </td> <td>' . $tipe . '</td> <td>' . $tgl_approval . '</td> <td>' . $status[$item->status] . '</td> </tr> '; $no++; } } else { $out = ' <tr> <td colspan="7">Tidak ditemukan</td> </tr> '; } $res['pagin'] = $items->render(); $res['content'] = $out; return json_encode($res); } }
public function getLoadpo(Request $req) { if ($req->ajax()) { $res = []; $out = ''; $items = data_po::active($req->all())->paginate(5); $total = $items->total(); $status = [1 => 'Baru', 2 => 'Proses', 3 => 'Selesai']; if ($total > 0) { foreach ($items as $item) { $out .= ' <tr class="po-' . $item->id_po . '"> <td>' . $item->no_po . '</td> <td>' . \Format::hari($item->created_at) . ', ' . \Format::indoDate2($item->created_at) . '</td> <td>' . $status[$item->status] . '</td> <td class="text-right"><button onclick="add_itempo(' . $item->id_po . ');" class="btn btn-po-' . $item->id_po . ' btn-white btn-small"><i class="fa fa-plus"></i></button></td> </tr> '; } } else { $out = ' <tr> <td colspan="4">Tidak ditemukan</td> </tr> '; } $res['total'] = $total; $res['content'] = $out; $res['pagin'] = $items->render(); return json_encode($res); } }
public function postDetailspb(Request $req) { if ($req->ajax()) { $result = []; $out = ''; $spb = data_spb::find($req->id); if ($spb->status > 2) { $items = data_spb_item::join('data_barang', 'data_barang.id_barang', '=', 'data_spb_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_barang.id_satuan')->where('data_spb_item.id_spb', $req->id)->whereIn('data_spb_item.status', [1, 2])->select('data_spb_item.*', 'data_barang.nm_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'ref_satuan.nm_satuan')->get(); } else { $items = data_spb_item::join('data_barang', 'data_barang.id_barang', '=', 'data_spb_item.id_item')->join('ref_satuan', 'ref_satuan.id_satuan', '=', 'data_spb_item.id_satuan')->where('data_spb_item.id_spb', $req->id)->where('data_spb_item.status', 1)->select('data_spb_item.*', 'data_barang.nm_barang', 'data_barang.kode', 'data_barang.in', 'data_barang.out', 'ref_satuan.nm_satuan')->get(); } if ($spb->id_acc > 0) { $me = data_karyawan::find($spb->id_acc); $out .= '<div class="grid simple"> <div class="grid-title no-border"></div> <div class="grid-body no-border"> <b>Disetujui Oleh : </b> ' . $me->nm_depan . ' ' . $me->nm_belakang . '<br /> <small class="text-muted">' . \Format::hari($spb->tgl_approval) . ', ' . \Format::indoDate2($spb->tgl_approval) . ' ' . \Format::jam($spb->tgl_approval) . '</small> </div> </div> '; } $out .= '<div class="grid simple"> <div class="grid-title no-border"> <h4>' . count($items) . ' barang <strong>ditemukan</strong></4><br /> <small>Deadline : ' . \Format::indoDate($spb->deadline) . '</small> </div> <div class="grid-body no-border"> <table class="table table-striped"> <thead> <tr> <th>Kode</th> <th>Barang</th> <th>Sisa</th> <th class="text-right">Qty</th> </tr> </thead> <tbody> '; foreach ($items as $item) { $out .= ' <tr> <td>' . $item->kode . '</td> <td>' . \Format::substr($item->nm_barang, 20) . '</td> <td>' . number_format($item->in - $item->out, 0, ',', '.') . ' ' . $item->nm_satuan . '</td> <td class="text-right">' . number_format($item->qty_lg, 0, ',', '.') . ' ' . $item->nm_satuan . '</td> </tr> '; } $out .= ' </tbody> </table> </div> </div>'; $btn = \Auth::user()->permission > 2 && $spb->status < 2 && empty($spb->id_acc) ? '<button data-loading-text="<i class=\'fa fa-circle-o-notch fa-spin\'></i> Proses..." class="btn btn-primary btn-accspb" onclick="acc(' . $req->id . ');"><i class="fa fa-check"></i> Setujui</button>' : ''; $result['kode'] = $spb->no_spb; $result['content'] = $out; $result['button'] = $btn; return json_encode($result); } }
public function getSkbajax(Request $req) { if ($req->ajax()) { $res = []; $out = ''; //$items = data_po_item::lpbdo($req->all())->paginate($req->limit); $items = data_skb::with(['rekap' => function ($query) { $query->join('data_barang', 'data_barang.id_barang', '=', 'data_skb_item.id_item')->join('ref_satuan', 'data_barang.id_satuan', '=', 'ref_satuan.id_satuan'); }])->rekapskb($req->all())->get(); $total = count($items); if ($total > 0) { $no = 1; $id_skb = ''; foreach ($items as $item) { if ($id_skb != $item->id_spb) { $out .= '<tr style="background-color: #d3d3d3"> <td class="text-left">' . $item->no_skb . '</td> <td class="text-left">' . $item->nm_depan . ' ' . $item->nm_belakang . '</td> <td class="text-left">' . $item->nm_departemen . '</td> <td class="text-left">' . \Format::indoDate2($item->created_at) . '</td> <td colspan="6"></td> </tr>'; } foreach ($item->rekap as $data) { $out .= ' <tr> <td colspan="4"></td> <td class="text-left">' . $data->nm_barang . '</td> <td class="text-right">' . $data->qty . '</td> <td class="text-right">' . $data->qty_lg . '</td> <td class="text-right">' . $data->sisa . '</td> <td class="text-left">' . $data->nm_satuan . '</td> </tr> '; $no++; } } } else { $out = ' <tr> <td colspan="8">Tidak ditemukan</td> </tr> '; } $res['content'] = $out; // $res['pagin'] = $items->render(); // $res['total'] = $total; return json_encode($res); } }