public function bank() { $banks = \App\Bank::with('tax')->where('active', 1)->get(); $data = []; foreach ($banks as $bank) { $row = ['bank_id' => $bank->id, 'nama_bank' => $bank->nama_bank]; foreach ($bank->tax as $bt) { $type = 'tax_' . $bt->type; $row[$type] = $bt->tax; } array_push($data, $row); } $display['bank'] = $data; return $display; }
public function ajaxLoad(Request $request) { if ($request->get('id')) { return \App\BankTax::join('banks', 'bank_taxes.bank_id', '=', 'banks.id')->where('banks.active', 1)->where('bank_id', $request->get('id'))->where('type', $request->get('type'))->first(); } return Bank::with('tax')->where('active', 1)->get(); }