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