function lookup_uu() { $this->load->library('pagination'); $queryString = rebuild_query_string(); $table = "tb_peraturan_pembentukan_daerah"; $data_type = $this->adodbx->GetDataType($table); foreach ($data_type as $x => $val) { if ($val == "C" || $val == "X") { $data["text"][] = $x; } } $col_text = cek_var($data["text"]) ? $data["text"] : ""; $field = join(",", $col_text); //$field="jenis_pelanggaran"; $whereSql = get_where_from_searchbox($field); if ($this->input->get_post("q")) { $where[] = "(" . $whereSql . ")"; } $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "25"; $data["perPage"] = $perPage; $uriSegment = 4; //$table=$this->model->tbl; $totalRows = count($this->adodbx->search_record_where($table, $whereSql)); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sort = $this->input->get_post("sort") ? $this->input->get_post("sort") : "idx"; if (!empty($sort)) { $sortBy = " order by {$sort}"; } $arrData = $this->adodbx->search_record_by_limit_where($table, $whereSql, $perPage, $offset, $sortBy); $config['base_url'] = $this->module . "lookup_uu"; $config['per_page'] = $perPage; $config['total_rows'] = $totalRows; $config['uri_segment'] = $uriSegment; $config["suffix"] = $queryString; $config["first_url"] = $config["base_url"] . $queryString; //$config['display_pages'] = FALSE; $this->pagination->initialize($config); $data["arrData"] = $arrData; $this->load->view($this->module . "v_lookup_uu", $data); }
function data_rkp_segmen() { $sql_rkp = "select 'propinsi' as batas_wilayah,1 as sort,\n\t\t\t\ta.tahun_peraturan as tahun,count(b.idx) as total \n\t\t\t\tfrom tb_batas_propinsi a,tb_batas_propinsi_detail b\n\t\t\t\twhere a.idx=b.id_parent and tahun_peraturan>=2004\n\t\t\t\tgroup by a.tahun_peraturan\n\t\t\t\t\n\t\t\t\tunion all\n\t\t\t\t\n\t\t\t\tselect 'propinsi_old' as batas_wilayah,2 as sort,\n\t\t\t\ta.tahun_peraturan as tahun,count(b.idx) as total \n\t\t\t\tfrom tb_batas_propinsi a,tb_batas_propinsi_detail b\n\t\t\t\twhere a.idx=b.id_parent and tahun_peraturan<2004\n\t\t\t\t\n\t\t\t\tunion all\n\t\t\t\t\n\t\t\t\tselect 'kab_kota' as batas_wilayah,3 as sort,\n\t\t\t\ta.tahun_peraturan as tahun,count(b.idx) as total \n\t\t\t\tfrom tb_batas_kabupaten a,tb_batas_kabupaten_detail b\n\t\t\t\twhere a.idx=b.id_parent and tahun_peraturan>=2004\n\t\t\t\tgroup by a.tahun_peraturan\n\t\t\t\t\n\t\t\t\tunion all \n\t\t\t\t\n\t\t\t\tselect 'kab_kota_old' as batas_wilayah,4 as sort,\n\t\t\t\ta.tahun_peraturan as tahun,count(b.idx) as total \n\t\t\t\tfrom tb_batas_kabupaten a,tb_batas_kabupaten_detail b\n\t\t\t\twhere a.idx=b.id_parent and tahun_peraturan<2004\n\t\t\t\t\n\t\t\t\t"; $sql_group = "select sort,batas_wilayah,group_concat(tahun,':',total order by tahun asc separator ',') as data from (" . $sql_rkp . ") a \n\t\t\t\t\tgroup by sort,batas_wilayah order by sort"; $arrData = $this->conn->GetAll($sql_group); if (cek_array($arrData)) { foreach ($arrData as $x => $val) { $data_tmp = array(); $data_tmp["batas_wilayah"] = strtoupper($val["batas_wilayah"]); $data_tmp_data = $this->parse_data($val["data"]); $data_all[$val["batas_wilayah"]] = $data_tmp_data; $arrData[$x]["data_per_tahun"] = $data_tmp_data; /* merge to $data_tmp */ $data_tmp += $data_tmp_data; $arrDataPivot[] = $data_tmp; } } //$data[]=array("Tahun","Batas Propinsi","Batas Kabupaten"); for ($i = date('Y'); $i >= 2004; $i--) { $prop = cek_var($data_all["propinsi"][$i]) ? (int) $data_all["propinsi"][$i] : 0; $kab = cek_var($data_all["kab_kota"][$i]) ? (int) $data_all["kab_kota"][$i] : 0; $data[] = array((string) $i, $prop, $kab); } $prop = cek_var($data_all["propinsi_old"][0]) ? (int) $data_all["propinsi_old"][0] : 0; $kab = cek_var($data_all["kab_kota_old"][0]) ? (int) $data_all["kab_kota_old"][0] : 0; $data[] = array("1945-2003", $prop, $kab); $this->jumlah_segmen_propinsi = array_sum($data_all["propinsi"]) + array_sum($data_all["propinsi_old"]); $this->jumlah_segmen_kabupaten = array_sum($data_all["kab_kota"]) + array_sum($data_all["kab_kota_old"]); return $data; }
function daftar_penetapan_prop() { $arrBread = array(array("title" => "Daftar Penetapan Batas Propinsi", "url" => "" . $this->module . "/daftar_penetapan_prop/", "active" => "", "icon" => " ")); $this->set_bread($arrBread); $sql = "select a.*,concat(propinsi_1,':',propinsi_2) as propinsi,\n\t\t\t\tconcat(id_propinsi_1,':',id_propinsi_2) as id_propinsi,\n\t\t\t\tb.kabupaten\n\t\t\t\t from tb_batas_propinsi a \n\t\t\t\tleft join\n\t\t\t\t(select id_parent,group_concat(concat(kabupaten_1,':',kabupaten_2) separator ','\n\t\t\t\t) as kabupaten from tb_batas_propinsi_detail group by id_parent\n\t\t\t\t) b on a.idx=b.id_parent"; $data_type = $this->adodbx->GetDataType("({$sql}) a"); foreach ($data_type as $x => $val) { if ($val == "C" || ($val = "X")) { $data["text"][] = $x; } } $col_text = $data["text"]; $field = join(",", $col_text); //$field="jenis_pelanggaran"; $whereSql = get_where_from_searchbox($field); if ($this->input->get_post("q")) { $where[] = "(" . $whereSql . ")"; } if (cek_var($this->input->get_post("id_propinsi"))) { $where[] = "id_propinsi like '%" . $this->input->get_post("id_propinsi") . "%'"; } if (cek_var($this->input->get_post("tahun_peraturan"))) { $where[] = "tahun_peraturan='" . $this->input->get_post("tahun_peraturan") . "'"; } if (cek_var($this->input->get_post("id_jenis_peraturan"))) { $where[] = "id_jenis_peraturan='" . $this->input->get_post("id_jenis_peraturan") . "'"; } $whereSql = ""; if (cek_array($where)) { $whereSql = " where "; $whereSql .= join(" and ", $where); } $arrDataTahun = $this->conn->GetAll("select tahun_peraturan from tb_batas_propinsi group by tahun_peraturan order by tahun_peraturan desc"); if (cek_array($arrDataTahun)) { foreach ($arrDataTahun as $x => $val) { $dataTahun["" . $val["tahun_peraturan"] . ""] = $val["tahun_peraturan"]; } } $arrData = $this->conn->GetAll("select * from ({$sql}) a " . $whereSql); $arrDataDetail = $this->conn->GetAll("select * from tb_batas_propinsi_detail"); foreach ($arrDataDetail as $x => $val) { $data_detail[$val["id_parent"]][] = $val; } foreach ($arrData as $x => $val) { $data_detail_parent = array(); $data_detail_parent = cek_var($data_detail[$val["idx"]]) ? $data_detail[$val["idx"]] : array(); $arrData[$x]["data_detail"] = $data_detail_parent; } $data["arrData"] = $arrData; $data["arrDataTahun"] = $dataTahun; $this->_render_page($this->module . "daftar_penetapan_propinsi", $data, true); }
</small> </h1> <!-- <ol class="breadcrumb"> <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li> <li class="active">Blank page</li> </ol>--> </section> <?php } ?> <!-- Main content --> <section class="content"> <?php if (cek_var($this->layout_data["breadcrumb"])) { ?> <?php echo $this->layout_data["breadcrumb"]; ?> <?php } ?> <?php echo $content; ?> </section><!-- /.content --> </aside><!-- /.right-side --> </div> <!-- end: Wrapper-->
function update_uu($id_parent) { $data = get_post(); if (cek_var($data["dasar_id"])) { $data_id_arr = preg_split("/\\||\\,/", $data["dasar_id"]); if (cek_array($data_id_arr)) { $this->model_uu->DeleteData("id_parent={$id_parent}"); foreach ($data_id_arr as $id_uu) { $data_update = array(); $data_update["id_parent"] = $id_parent; $data_update["id_peraturan"] = $id_uu; $this->model_uu->InsertData($data_update); } } } }
?> <tr> <td><?php echo strtoupper($val["batas_wilayah"]); ?> </td> <td class="tc"><?php echo cek_var($val["data_lt_2003"]) ? $val["data_lt_2003"] : '-'; ?> </td> <?php for ($i = 2004; $i <= max($tahun_max_arr); $i++) { ?> <td class="tc"><?php echo cek_var($val["data_per_tahun"][$i]) ? $val["data_per_tahun"][$i] : '-'; ?> </td> <?php } ?> </tr> <?php } ?> </tbody> </table> </div></div> <!-- end:row--> </div><!-- end: print_this --> <script type="text/javascript" src="assets/js/lingkar/jquery.export2excel.js"></script>
</li> <?php } ?> </ol> <?php } ?> <?php } ?> </td> <td> <?php if (cek_var($dataUU[$val["idx"]])) { ?> <?php $data_uu = $dataUU[$val["idx"]]["data_uu"]; $data_id = $dataUU[$val["idx"]]["id_uu"]; $data_uu_arr = preg_split("/\\;/", str_replace("|", " Tentang ", $data_uu)); ?> <?php if (cek_array($data_uu_arr)) { ?> <ol style="padding-left:1em"> <?php foreach ($data_uu_arr as $xx => $valx) { ?> <li><?php echo $valx;