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 | } |