tampil

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

}