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