/** * function name : deleteAcc * view page deleteAcc * * delete data bank acc */ function deleteAcc_type5($id, $cid) { if (Session::get('level') != '') { $result = BankAcc::where('acc_id', $id)->delete(); if ($result) { $dataacc = DB::table('s_bank_acc')->join('s_bank', 's_bank.bank_id', '=', 's_bank_acc.bank_id')->where('s_bank_acc.cid', '=', $cid)->get(); $a = ''; if (count($dataacc) > 0) { $a = '<table class="responsive" >'; $a .= '<tbody>'; $ai = 0; $a .= '<tr> <th width="40" >ลำดับ</th> <th width="250" >ธนาคาร</th> <th width="250" >เลขที่บัญชี</th> <th width="40" >ลบ</th> </tr>'; foreach ($dataacc as $dacc) { $ai++; $a .= '<tr>'; $a .= '<td>' . $ai . '</td>'; $a .= '<td>' . $dacc->bank_name . '</td>'; $a .= '<td>' . $dacc->bank_acc . '</td>'; $a .= '<td><a title="ลบข้อมูล" onclick="delAcc(' . $dacc->cid . ',' . $dacc->acc_id . ');" href="#"><i class="fi-x small"></i></a></td>'; $a .= '</tr>'; } $a .= '</tbody>'; $a .= '</table>'; } return Response::json(array('success' => true, 'msg' => 'ลบข้อมูลเรียบร้อย', 'w' => $a)); } else { return Response::json(array('success' => false, 'msg' => 'ไม่สามารถลบข้อมูลได้ กรุณาติดต่อผู้ดูแลระบบ')); } } else { return View::make('login.index'); } }
private function get_bankid($cid) { $datas = BankAcc::where('cid', '=', $cid)->get(); foreach ($datas as $data) { return $data->bank_id; } }