public function kreditPosition()
{
$menus = ref_coa::where('type_coa', 2)->orderby('seri', 'asc')->get();
$menu = [];
foreach ($menus as $row) {
$menu[$row->parent_id][] = $row;
}
return $this->formatKreditPosition($menu);
}
/**
* Execute the job.
*
* @return void
*/
public function handle()
{
$data = json_decode($this->req['update']);
//dd($data);
$seri = 1;
foreach ($data as $menus) {
$menu = ref_coa::find($menus->id);
$menu->parent_id = 0;
$menu->seri = $seri;
$menu->save();
$seri1 = 1;
if (!empty($menus->children)) {
foreach ($menus->children as $child) {
$menu = ref_coa::find($child->id);
$menu->parent_id = $menus->id;
$menu->seri = $seri1;
$menu->save();
$seri1++;
// Children 2
$seri2 = 1;
if (!empty($child->children)) {
foreach ($child->children as $child2) {
$menu = ref_coa::find($child2->id);
$menu->parent_id = $child->id;
$menu->seri = $seri2;
$menu->save();
$seri2++;
// Children 3
$seri3 = 1;
if (!empty($child2->children)) {
foreach ($child2->children as $child3) {
$menu = ref_coa::find($child3->id);
$menu->parent_id = $child2->id;
$menu->seri = $seri3;
$menu->save();
$seri3++;
// Children 4
$seri4 = 1;
if (!empty($child3->children)) {
foreach ($child3->children as $child4) {
$menu = ref_coa::find($child4->id);
$menu->parent_id = $child3->id;
$menu->seri = $seri4;
$menu->save();
$seri3++;
}
}
}
}
}
}
}
}
$seri++;
}
}
public function getAllitems(Request $req)
{
if ($req->ajax()) {
$res = [];
$items = ref_coa::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->no_coa . '</td>
<td>' . $item->nm_coa . '</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="4">Tidak ditemukan</td>
</tr>
';
}
$res['data'] = $out;
$res['pagin'] = $items->render();
return json_encode($res);
}
}
/**
* Execute the job.
*
* @return void
*/
public function handle()
{
ref_coa::find($this->req['id_coa'])->update(['parent_id' => $this->req['idparent'], 'type_coa' => $this->req['type_coa'], 'no_coa' => $this->req['no_coa'], 'nm_coa' => $this->req['nm_coa'], 'keterangan' => $this->req['keterangan']]);
return $this->req;
}
public function getView($id)
{
if (empty($id)) {
return redirect('/fakturpembelian');
}
$faktur = data_faktur::views($id)->first();
$items = data_faktur_item::byfaktur($id)->get();
if ($faktur->status == 3) {
return redirect('/fakturpembelian');
}
$status = [0 => ['label' => 'important', 'err' => 'Unpaid'], 1 => ['label' => 'warning', 'err' => 'Partially Paid'], 2 => ['label' => 'info', 'err' => 'Paid'], 3 => ['label' => 'important', 'err' => 'Batal']];
$methods = ref_payment_method::all();
$jurnals = data_jurnal::faktur($id)->get();
$coas = [];
foreach (ref_coa::orderby('no_coa', 'asc')->get() as $coa) {
$coas[$coa->parent_id][] = $coa;
}
$select_coa = \Format::select_coa($coas);
$total_bayar = 0;
foreach ($jurnals as $ju) {
$total_bayar += $ju->total;
}
return view('Akutansi.FakturPembelian.view', ['faktur' => $faktur, 'items' => $items, 'status' => $status, 'methods' => $methods, 'jurnals' => $jurnals, 'select_coa' => $select_coa, 'total_bayar' => $total_bayar]);
}
public function handle()
{
return ref_coa::create(['parent_id' => $this->req['idparent'], 'no_coa' => $this->req['no_coa'], 'nm_coa' => $this->req['nm_coa'], 'type_coa' => $this->req['type_coa'], 'keterangan' => $this->req['keterangan'], 'status' => 1]);
}
