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