SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | class M_jp extends CI_model {
| |
| 3 | private $dats=[]; | |
| 4 | public function rw() | |
| 5 | {
| |
| 6 | $query = $this->db->query('SELECT
| |
| 7 | rw.id_rw AS id_rw | |
| 8 | , rw.nama_rw AS rw | |
| 9 | , SUM(rt.jumlah_kk)AS kk | |
| 10 | , SUM(rt.jumlah_l)AS L | |
| 11 | , SUM(rt.jumlah_p)AS P | |
| 12 | , SUM(rt.jumlah_l + rt.jumlah_p) AS jumlah_penduduk | |
| 13 | FROM | |
| 14 | penduduk.rw | |
| 15 | INNER JOIN penduduk.rt | |
| 16 | ON (rw.id_rw = rt.id_rw) | |
| 17 | GROUP BY rw.id_rw;'); | |
| 18 | $result=array(); | |
| 19 | foreach( $query->result as $row){
| |
| 20 | $row->rt=$this->jumlah_rt($row->id_rw); | |
| 21 | $result[]=$row; | |
| 22 | ||
| 23 | } | |
| 24 | } | |
| 25 | ||
| 26 | public function jumlah_rt($id){
| |
| 27 | $query = $this->db->query('SELECT
| |
| 28 | rt.nama_rt | |
| 29 | , rt.jumlah_kk | |
| 30 | , (rt.jumlah_l + rt.jumlah_p) AS jumlah_penduduk | |
| 31 | , rt.jumlah_l | |
| 32 | , rt.jumlah_p | |
| 33 | FROM | |
| 34 | penduduk.rw | |
| 35 | INNER JOIN penduduk.rt | |
| 36 | ON (rw.id_rw = rt.id_rw) | |
| 37 | WHERE rw.id_rw="'.$id.'"'); | |
| 38 | return $query; | |
| 39 | } | |
| 40 | ||
| 41 | public function jumlah() | |
| 42 | {
| |
| 43 | $data[] = $this->M_jp->rw(); | |
| 44 | ||
| 45 | $query = $this->db->query('SELECT
| |
| 46 | rt.nama_rt | |
| 47 | , rt.jumlah_kk | |
| 48 | , (rt.jumlah_l + rt.jumlah_p) AS jumlah_penduduk | |
| 49 | , rt.jumlah_l | |
| 50 | , rt.jumlah_p | |
| 51 | FROM | |
| 52 | penduduk.rw | |
| 53 | INNER JOIN penduduk.rt | |
| 54 | ON (rw.id_rw = rt.id_rw) | |
| 55 | WHERE rw.id_rw="$data[]->id_rw";'); | |
| 56 | ||
| 57 | return $query; | |
| 58 | } | |
| 59 | ||
| 60 | } |
