public function get_pb_jadup() { $sql = "SELECT \r\n a.KD_PB AS KD_PB,\r\n a.NM_PB AS NM_PB,\r\n a.KD_GOL AS KD_GOL,\r\n b.NM_STS_TB AS NM_STS_TB,\r\n c.NM_BANK AS NM_BANK,\r\n a.NO_REKENING_PB AS NO_REKENING_PB\r\n FROM d_pb a\r\n LEFT JOIN \r\n r_stb b ON a.KD_STS_TB = b.KD_STS_TB\r\n LEFT JOIN\r\n r_bank c ON a.KD_BANK = c.KD_BANK\r\n "; $result = $this->db->select($sql); $data = array(); foreach ($result as $value) { $pb = new Penerima($this->registry); $pb->set_kd_pb($value['KD_PB']); $pb->set_nama($value['NM_PB']); $pb->set_status($value['NM_STS_TB']); $pb->set_bank($value['NM_BANK']); $pb->set_no_rek($value['NO_REKENING_PB']); $data[] = $pb; } return $data; }
public function cari() { $name = $_POST['name']; $pb = new Penerima($this->registry); $pb->set_nama($name); if (Session::get('role') == 2) { $this->view->d_pb = $pb->get_penerima_by_name($pb, $this->kd_user); } else { $this->view->d_pb = $pb->get_penerima_by_name($pb, 0); } $this->view->nilai = new Nilai($this->registry); $this->view->load('riwayat_tb/tabel_d_pb'); }