Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $anggota_id = $r->anggota_id;
- $listPinjaman = $this->db->get_where('v_bulk', array('MONTH(angsur_tmp)' => $bulan, 'YEAR(angsur_tmp)' => $tahun, 'anggota_id' => $anggota_id, 'angsur_status' => 1))->result();
- if (count($listPinjaman) == 0) {
- $arr_pinjaman = array(
- 'no' => '',
- 'namapinjaman' => '',
- 'kedr' => '',
- 'pokok' => '',
- 'bunga' => '',
- 'total' => '',
- 'sisa' => '',
- );
- } else {
- $arr_pinjaman = array();
- $no = 1;
- foreach ($listPinjaman as $p) {
- $arr_pinjaman[] = array(
- 'no' => $no,
- 'namapinjaman' => $p->jenis_name,
- 'kedr' => $p->angsur_ke . '/' . $p->pinjaman_jk,
- 'pokok' => number_format($p->angsur_pokok, 0, '', ','),
- 'bunga' => number_format($p->angsur_bunga, 0, '', ','),
- 'total' => number_format($p->angsur_total, 0, '', ','),
- 'sisa' => number_format($p->angsur_sisa, 0, '', ','),
- );
- $no++;
- }
- }
- $listSimpanan = $this->db->get_where('v_transaksi', array('MONTH(trtab_date)' => $bulan, 'YEAR(trtab_date)' => $tahun, 'anggota_id' => $anggota_id))->result();
- if (count($listSimpanan) == 0) {
- $arr_simpanan = array(
- 'nox' => '',
- 'namasimpanan' => '',
- 'jumlah' => '',
- 'saldo' => '',
- );
- } else {
- $arr_simpanan = array();
- $nox = 1;
- foreach ($listSimpanan as $s) {
- $arr_simpanan[] = array(
- 'nox' => $nox,
- 'namasimpanan' => $s->jenis_name,
- 'jumlah' => number_format($s->trtab_value, 0, '', ','),
- 'saldo' => number_format($s->tab_total, 0, '', ','),
- );
- $nox++;
- }
- }
- $res = array_merge($arr_pinjaman, $arr_simpanan);
- print_r($res);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement