perbaikan 93-a

<?php
class M_jp extends CI_model {
    private $dats=[];
    public function rw()
    {
        $query = $this->db->query('SELECT
            rw.id_rw AS id_rw
            , rw.nama_rw AS rw
            , SUM(rt.jumlah_kk)AS kk
            , SUM(rt.jumlah_l)AS L
            , SUM(rt.jumlah_p)AS P
            , SUM(rt.jumlah_l + rt.jumlah_p) AS jumlah_penduduk
            FROM
            penduduk.rw
            INNER JOIN penduduk.rt
            ON (rw.id_rw = rt.id_rw)
            GROUP BY rw.id_rw;');
        $result=array();
        foreach( $query->result as $row){
            $row->rt=$this->jumlah_rt($row->id_rw);
            $result[]=$row;

        }
    }

    public function jumlah_rt($id){
        $query = $this->db->query('SELECT
            rt.nama_rt
            , rt.jumlah_kk
            , (rt.jumlah_l + rt.jumlah_p) AS jumlah_penduduk
            , rt.jumlah_l
            , rt.jumlah_p
            FROM
            penduduk.rw
            INNER JOIN penduduk.rt
            ON (rw.id_rw = rt.id_rw)
            WHERE rw.id_rw="'.$id.'"');
        return $query;
    }

    public function jumlah()
    {
        $data[] = $this->M_jp->rw();

        $query = $this->db->query('SELECT
            rt.nama_rt
            , rt.jumlah_kk
            , (rt.jumlah_l + rt.jumlah_p) AS jumlah_penduduk
            , rt.jumlah_l
            , rt.jumlah_p
            FROM
            penduduk.rw
            INNER JOIN penduduk.rt
            ON (rw.id_rw = rt.id_rw)
            WHERE rw.id_rw="$data[]->id_rw";');

        return $query;
    }

}