Notes

$filskpd = "a.kd_skpd='$skpd'";
$thi=$this->session->userdata('pcThang');
$thz=$thi-1;
$blndcetak = date("m", strtotime($dcetak));
$sql_setor="SELECT a.tgl_terima,a.no_terima,a.kd_rek5 as kd_rek6,b.nm_rek6,ISNULL(a.nilai,0) as nilai,c.tgl_sts,c.no_sts,ISNULL(c.rupiah,0) as total, a.keterangan,a.bank FROM tr_terima a INNER JOIN ms_rek6 b
ON a.kd_rek5=b.kd_rek6
LEFT JOIN (SELECT x.tgl_sts,x.no_sts,x.kd_skpd,y.no_terima,SUM(y.rupiah) as rupiah, x.bank FROM trhkasin_pkd x INNER JOIN trdkasin_pkd y ON x.no_sts=y.no_sts AND x.kd_skpd=y.kd_skpd
where x.tgl_sts >= '$dcetak' and x.tgl_sts <= '$dcetak2'
GROUP BY x.tgl_sts,x.no_sts,x.kd_skpd,y.no_terima,x.bank) c
ON a.no_terima=c.no_terima AND a.kd_skpd=c.kd_skpd
where a.tgl_terima >= '$dcetak' and a.tgl_terima <= '$dcetak2' and $filskpd
union ALL
SELECT null as tgl_terima,'' as no_terima,'' as kd_rek6,'' as nm_rek6,0 as nilai,c.tgl_sts,c.no_sts,ISNULL(c.rupiah,0) as total, a.keterangan,a.bank FROM tr_terima a INNER JOIN ms_rek6 b
ON a.kd_rek5=b.kd_rek6
LEFT JOIN (SELECT x.tgl_sts,x.no_sts,x.kd_skpd,y.no_terima,SUM(y.rupiah) as rupiah, x.bank FROM trhkasin_pkd x INNER JOIN trdkasin_pkd y ON x.no_sts=y.no_sts AND x.kd_skpd=y.kd_skpd
where x.tgl_sts >= '$dcetak' and x.tgl_sts <= '$dcetak2'
GROUP BY x.tgl_sts,x.no_sts,x.kd_skpd,y.no_terima,x.bank) c
ON a.no_terima=c.no_terima AND a.kd_skpd=c.kd_skpd
where $filskpd and month(a.tgl_terima) < $blndcetak and no_sts is not null
union ALL
select
'$thz-12-31' tgl_terima,
'' no_terima,
'' kd_rek6,
'' nm_rek6,
0 nilai,
a.tgl_sts,
a.no_sts,
b.rupiah AS total,
a.keterangan,
a.bank
from trhkasin_pkd a left join trdkasin_pkd b
on a.kd_skpd=b.kd_skpd and a.no_sts=b.no_sts
where a.jns_trans in ('2') and a.tgl_sts >= '$dcetak' and a.tgl_sts <= '$dcetak2' and $filskpd
group by a.tgl_sts,
a.no_sts,
b.rupiah,
a.keterangan,
a.bank
order by a.tgl_terima, a.no_terima";

$query_str = $this->db->query($sql_setor);
$jumlahsetor=0;
foreach($query_str->result() as $row){
$jumlahsetor = $jumlahsetor+$row->total;
}