function module_list() { //if (!$this->cms->has_view($this->module)) redirect ($this->auth_error_page); //debug(); $this->load->library('pagination'); $queryString = rebuild_query_string(); $field = "module_name,module_path,module_url"; $whereSql = get_where_from_searchbox($field); if ($this->input->get_post("q")) { $where[] = "(" . $whereSql . ")"; } $whereSql = ""; if (cek_array($where)) { $whereSql .= join(" and ", $where); } $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "25"; $data["perPage"] = $perPage; //$this->model= new account_manager_model(); $uriSegment = 4; $totalRows = count($this->model->SearchRecordWhere($whereSql)); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by order_num,idx"; $arrData = $this->model->SearchRecordLimitWhere($whereSql, $perPage, $offset, $sortBy); $config['base_url'] = $this->module . "module_list"; $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->_render_page($this->module . "module_list", $data, true); }
function user_list() { $queryString = rebuild_query_string(); //debug(); $q = $this->input->get_post("q"); $field = "username,first_name,last_name,email"; $whereSql = get_where_from_searchbox($field); $arrBread[] = array("text" => "" . $this->listText . "", "url" => ""); $this->load->library('pagination'); $perPage = 20; $uriSegment = 4; $totalRows = count($this->ammmodel->SearchRecordWhere($whereSql)); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by username"; $arrData = $this->ammmodel->SearchRecordLimitWhere($whereSql, $perPage, $offset, $sortBy); if (cek_array($arrData)) { foreach ($arrData as $x => $val) { $arrData[$x]["groups"] = (array) $this->ion_auth->get_users_groups($val["id"])->result_array(); } } $config['base_url'] = $this->http_ref . "/index/"; $config['per_page'] = $perPage; $config['total_rows'] = $totalRows; $config['uri_segment'] = $uriSegment; $config["suffix"] = $queryString; //$config['display_pages'] = FALSE; $this->pagination->initialize($config); $data["arrData"] = $arrData; $datam["arrBread"] = $arrBread; $datam["acc_active"] = $this->acc_active; $datam["content"] = $this->load->view("news/user_list", $data, true); $this->load->view($this->admin_layout, $datam); }
function listview() { //if (!$this->cms->has_view($this->module)) redirect ("admin/error"); $this->load->library('pagination'); $queryString = rebuild_query_string(); $data_type = $this->adodbx->GetDataType($this->model->tbl); 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 . ")"; } $whereSql = ""; if (cek_array($where)) { $whereSql .= join(" and ", $where); } $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "25"; $data["perPage"] = $perPage; $uriSegment = 4; $table = $this->model->tbl; $totalRows = count($this->model->SearchRecordWhere($whereSql)); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by {$this->tbl_sort}"; $arrData = $this->model->SearchRecordLimitWhere($whereSql, $perPage, $offset, $sortBy); $arrUU = $this->conn->GetAll("select id_parent,group_concat(b.idx) as id_uu,group_concat(b.no_peraturan,'|',b.tentang order by b.idx separator ';') as data_uu from " . $this->model_uu->tbl . " a left join tb_peraturan_pembentukan_daerah b on a.id_peraturan=b.idx group by a.id_parent"); $dataUU = array(); if (cek_array($arrUU)) { foreach ($arrUU as $x => $val) { $dataUU[$val["id_parent"]] = $val; } } $data["dataUU"] = $dataUU; $config['base_url'] = $this->module . "listview"; $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["acc_active"] = "guestbook"; $data["arrData"] = $arrData; $this->_render_page($this->module . "v_list", $data, true); }
function link_list() { $cat_idx = $this->input->get_post("cat_id"); $arrLinkIndex[] = "Category"; $where[] = " publish=1 "; if ($cat_idx) { $where[] = "category={$cat_idx}"; $arrLinkIndex[] = $this->conn->GetOne("select category from " . $this->model->tbl_link_category . " where idx={$cat_idx}"); } else { $arrLinkIndex[] = "All"; } $this->load->library('pagination'); $queryString = rebuild_query_string(); $field = "category_name,name,link_url,description"; if ($this->input->get_post("q")) { $whereSqlx = get_where_from_searchbox($field); $where[] = "({$whereSqlx})"; } $whereSql = ""; if (cek_array($where)) { $whereSql .= join(" and ", $where); } $sql = " select a.*,b.category as category_name,coalesce(c.click_count,0) as click_count from " . $this->model->tbl . " a \n left join " . $this->model->tbl_link_category . " b on a.category=b.idx\n left join " . $this->model->tbl_link_count . " c on a.idx=c.id_link\n where b.publish=1 and a.publish=1\n "; //$arrData=$this->model->SearchRecordWhere(false," order by category,name"); $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "10"; $data["perPage"] = $perPage; $uriSegment = 3; $table = "({$sql}) a"; $totalRows = count($this->adodbx->search_record_where($table, $whereSql)); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by idx"; $arrData = $this->adodbx->search_record_by_limit_where($table, $whereSql, $perPage, $offset, $sortBy); $config['base_url'] = $this->module . "link_list/"; $config['per_page'] = $perPage; $config['total_rows'] = $totalRows; $config['uri_segment'] = $uriSegment; $config["suffix"] = $queryString; $config["first_url"] = $config["base_url"] . $queryString; $config['num_links'] = 2; $this->pagination->initialize($config); $data["arrData"] = $arrData; $data["arrLinkIndex"] = $arrLinkIndex; $data["category_list"] = $this->category_list(false); $this->_render_page("content_list", $data, true); }
function listview() { //if (!$this->cms->has_view($this->module)) redirect ("admin/error"); $this->load->library('pagination'); $table = $this->model->tbl; $queryString = rebuild_query_string(); $data_type = $this->adodbx->GetDataType($table); 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 . ")"; } $whereSql = ""; if (cek_array($where)) { $whereSql .= join(" and ", $where); } $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "25"; $data["perPage"] = $perPage; $uriSegment = 4; $totalRows = $this->model->getTotalRecordWhere($whereSql); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by {$this->tbl_sort}"; //$arrData=$this->model->SearchRecordLimitWhere($whereSql,$perPage,$offset,$sortBy); $arrData = $this->model->search_record_by_limit_where($table, $whereSql, $perPage, $offset, $sortBy); $config['base_url'] = $this->module . "listview"; $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; //pre($data["arrData"]);exit; $this->_render_page($this->module . "v_list", $data, true); }
function user_list() { if (!$this->cms->has_view($this->module)) { redirect($this->auth_error_page); } $this->load->library('pagination'); $queryString = rebuild_query_string(); $field = "first_name,last_name,username"; $whereSql = get_where_from_searchbox($field); if ($this->input->get_post("q")) { $where[] = "(" . $whereSql . ")"; } $whereSql = ""; if (cek_array($where)) { $whereSql .= join(" and ", $where); } $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "25"; $data["perPage"] = $perPage; //$this->model= new account_manager_model(); $uriSegment = 4; $totalRows = count($this->model->SearchRecordWhere($whereSql)); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by id"; $arrData = $this->model->SearchRecordLimitWhere($whereSql, $perPage, $offset, $sortBy); $config['base_url'] = $this->module . "user_list"; $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); if (cek_array($arrData)) { foreach ($arrData as $x => $val) { $arrData[$x]["groups"] = $this->conn->GetAll("select a.*,b.name from users_groups a left join groups b on a.group_id=b.id where user_id=" . $val["id"]); } } $data["arrData"] = $arrData; //$arrData=$this->model->group_search_record_where(false," order by id "); //$data["arrData"]=$arrData; $this->_render_page($this->module . "user_list2", $data, true); }
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 listview() { //if (!$this->cms->has_view($this->module)) redirect ("admin/error"); $this->load->library('pagination'); $queryString = rebuild_query_string(); $field = "name"; $whereSql = get_where_from_searchbox($field); if ($this->input->get_post("q")) { $where[] = "(" . $whereSql . ")"; } $whereSql = ""; if (cek_array($where)) { $whereSql .= join(" and ", $where); } $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "25"; $data["perPage"] = $perPage; $uriSegment = 4; $table = $this->model->tbl; $totalRows = count($this->model->SearchRecordWhere($whereSql)); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by id_penghargaan"; $arrData = $this->model->SearchRecordLimitWhere($whereSql, $perPage, $offset, $sortBy); $config['base_url'] = $this->module . "listview"; $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["acc_active"] = "guestbook"; $data["arrData"] = $arrData; $this->_render_page($this->module . "v_list", $data, true); }
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); }
function user_list() { $queryString = rebuild_query_string(); $q = $this->input->get_post("q"); $field = "ip_address,password,salt,activation_code,forgotten_password_code,forgotten_password_time,remember_code,created_on,last_login,active,username,first_name,last_name,email,company,phone,handphone,nama,tanda_pengenal,nomor_pengenal,jenis_kelamin,tempat_lahir,tanggal_lahir,pekerjaan,golongan_darah,alamat,kode_pos,kabupaten_kota,propinsi,image"; $whereSql = get_where_from_searchbox($field); $arrBread[] = array("text" => "" . $this->listText . "", "url" => ""); $this->load->library('pagination'); $perPage = 20; $uriSegment = 4; $totalRows = count($this->ammmodel->SearchRecordWhere($whereSql)); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by username"; $arrData = $this->ammmodel->SearchRecordLimitWhere($whereSql, $perPage, $offset, $sortBy); if (cek_array($arrData)) { foreach ($arrData as $x => $val) { $arrData[$x]["groups"] = (array) $this->ion_auth->get_users_groups($val["id"])->result_array(); } } $config['base_url'] = $this->http_ref . "/index/"; $config['per_page'] = $perPage; $config['total_rows'] = $totalRows; $config['uri_segment'] = $uriSegment; $config["suffix"] = $queryString; //$config['display_pages'] = FALSE; $this->pagination->initialize($config); $data["arrData"] = $arrData; $datam["arrBread"] = $arrBread; $datam["acc_active"] = $this->acc_active; $datam["content"] = $this->load->view("register/user_list", $data, true); $this->load->view($this->admin_layout, $datam); }
function link_list() { //if (!$this->cms->has_view($this->module)) redirect ("admin/error"); $this->load->library('pagination'); $queryString = rebuild_query_string(); $field = "category_name,name,link_url,description"; $whereSql = get_where_from_searchbox($field); if ($this->input->get_post("q")) { $where[] = "(" . $whereSql . ")"; } if ($this->input->get_post("cat_id")) { $where[] = " category=" . $this->input->get_post("cat_id"); } $whereSql = ""; if (cek_array($where)) { $whereSql .= join(" and ", $where); } $sql = " select a.*,b.category as category_name from " . $this->model->tbl . " a \r\n left join " . $this->model->tbl_link_category . " b on a.category=b.idx\r\n "; //$arrData=$this->model->SearchRecordWhere(false," order by category,name"); $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "25"; $data["perPage"] = $perPage; $uriSegment = 4; $table = "({$sql}) a"; $totalRows = count($this->adodbx->search_record_where($table, $whereSql)); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by idx desc"; $arrData = $this->adodbx->search_record_by_limit_where($table, $whereSql, $perPage, $offset, $sortBy); $config['base_url'] = $this->module . "link_list"; $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->_render_page($this->module . "link_list", $data, true); }
function listview() { //if (!$this->cms->has_view($this->module)) redirect ("admin/error"); $this->load->library('pagination'); $queryString = rebuild_query_string(); $sql = "select a.*,b.kabupaten_2,c.detail_uu,d.detail_file,e.detail_file_peta from tb_batas_kabupaten a \n\t\t\tleft join \n\t\t\t(select id_parent,group_concat(id_kabupaten_2,':',kabupaten_2 separator ',') as kabupaten_2 from tb_batas_kabupaten_detail group by id_parent) b\n\t\t\t on a.idx=b.id_parent \n\t\t\t left join \n\t\t\t (select id_parent,group_concat(idx,'|',no_peraturan,'|',tentang separator ';') as detail_uu from \n\t\t\t (select a.id_parent,b.* from tb_batas_kabupaten_uu a left join tb_peraturan_pembentukan_daerah b on a.id_peraturan=b.idx) uu \n\t\t\t group by id_parent) c on a.idx=c.id_parent\n\t\t\t \n\t\t\t left join (select id_parent,group_concat(id,'|',file_name,'|',file_path separator ';') as detail_file from tb_batas_kabupaten_file group by id_parent) d\n\t\t\t on a.idx=d.id_parent \n\t\t\t \n\t\t\t left join (select id_parent,group_concat(id,'|',file_name,'|',file_path separator ';') as detail_file_peta from tb_batas_kabupaten_file_peta group by id_parent) e\n\t\t\t on a.idx=e.id_parent \n\t\t\t "; $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 . ")"; } $whereSql = ""; if (cek_array($where)) { $whereSql .= join(" and ", $where); } $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "25"; $data["perPage"] = $perPage; $uriSegment = 4; $table = $this->model->tbl; $totalRows = $this->model->total_rows_where("({$sql}) a", $whereSql); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by {$this->tbl_sort}"; $arrData = $this->adodbx->search_record_by_limit_where("({$sql}) a", $whereSql, $perPage, $offset, $sortBy); /* $arrUU=$this->conn->GetAll("select id_parent,group_concat(b.idx) as id_uu,group_concat(b.no_peraturan,'|',b.tentang order by b.idx separator ';') as data_uu from ".$this->model_uu->tbl." a left join tb_peraturan_pembentukan_daerah b on a.id_peraturan=b.idx group by a.id_parent"); $dataUU=array(); if(cek_array($arrUU)): foreach($arrUU as $x=>$val): $dataUU[$val["id_parent"]]=$val; endforeach; endif; $data["dataUU"]=$dataUU; */ $config['base_url'] = $this->module . "listview"; $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["acc_active"] = "guestbook"; $data["arrData"] = $arrData; $this->_render_page($this->module . "v_list", $data, true); }
function view($id) { if ($this->encrypt_status == TRUE) { $id_enc = $id; $id = decrypt($id); } $this->msg_ok = "Link updated successfully"; $this->msg_fail = "Unable to update link"; $act = $this->input->post("act") ? $this->input->post("act") : ""; $arrData = $this->model->GetRecordData("idx={$id}"); $arrData += $this->model_contact->GetRecordData("id_wa={$id}"); $arrData += $this->model_sejarah->GetRecordData("id_wa={$id}"); $arrData += $this->model_hak_atas_tanah->GetRecordData("id_wa={$id}"); $arrData += $this->model_hayati->GetRecordData("id_wa={$id}"); $arrData += $this->model_lembaga_adat->GetRecordData("id_wa={$id}"); $arrData += $this->model_hukum_adat->GetRecordData("id_wa={$id}"); $arrKab = $this->get_kab_kota_arr($arrData["id_propinsi"]); $arrPropinsi = m_lookup("propinsi2", "kode_bps", "nama"); $arrWaKondisiFisik = m_lookup("wa_kondisi_fisik", "idx", "kondisi_fisik"); $arrEkosistem = m_lookup("wa_jenis_ekosistem", "id_jenis_ekosistem", "jenis_ekosistem", "", " order by order_num asc "); $arrPotensiHayati = m_lookup("wa_potensi_hayati", "id_potensi_hayati", "nama_potensi_hayati", "", " order by idx asc "); $data["arr_propinsi"] = $arrPropinsi; $data["arr_kabupaten"] = $arrKab; $data["arr_wa_kondisi_fisik"] = $arrWaKondisiFisik; $data["arr_wa_ekosistem"] = $arrEkosistem; $data["arr_wa_potensihayati"] = $arrPotensiHayati; //nambahin $arrDataPotensiMap = array(); $arrDataPotensi = $this->model_potensi_hayati->SearchRecordWhere("id_wa={$id}"); if (cek_array($arrDataPotensi)) { foreach ($arrDataPotensi as $x => $val) { $arrDataPotensiMap[$val["id_potensi_hayati"]] = $val; } } $data["potensi"] = $arrDataPotensiMap; $data['arrAlamat'] = $this->model_cms_configuration->GetRecordData("id_key='alamat_laporan'"); $data['arrEmail'] = $this->model_cms_configuration->GetRecordData("id_key='email'"); $data['arrKontak'] = $this->model_cms_configuration->GetRecordData("id_key='kontak_laporan'"); if ($act == "update") { // debug(); $this->conn->StartTrans(); $data = get_post(); $data = $this->_add_editor($data); unset($data[$this->tbl_idx]); //pre($data);exit; $this->model->UpdateData($data, "{$this->tbl_idx}={$id}"); $ok = $this->conn->CompleteTrans(); $this->_proses_message($ok, $this->module . "view/{$id_enc}", $this->module . "view/{$id_enc}"); } // debug(); //----------- $this->load->library('pagination'); $table_dok = 'wa_pengajuan_keberatan'; $queryString = rebuild_query_string(); $data_type = $this->adodbx->GetDataType($table_dok); foreach ($data_type as $x => $val) { if ($val == "C" || $val == "X") { $data["text"][] = $x; } } $col_text = $data["text"]; $field = join(",", $col_text); $whereSql = get_where_from_searchbox($field); if ($this->input->get_post("q")) { $where[] = "(" . $whereSql . ")"; } $whereSql = "id_wa = {$id}"; if (cek_array($where)) { $whereSql .= join(" and ", $where); } $perPage = $this->input->get_post("pp") ? $this->input->get_post("pp") : "25"; $data["perPage"] = $perPage; $uriSegment = 4; $totalRows = $this->model_wa_keberatan->getTotalRecordWhere($whereSql); $offset = $totalRows > $perPage ? (int) $this->uri->segment($uriSegment) : 0; $sortBy = " order by {$this->tbl_sort}"; //$arrData=$this->model->SearchRecordLimitWhere($whereSql,$perPage,$offset,$sortBy); $arrDataDok = $this->model_wa_keberatan->search_record_by_limit_where($table_dok, $whereSql, $perPage, $offset, $sortBy); $config['base_url'] = $this->module . "view"; $config['per_page'] = $perPage; $config['total_rows'] = $totalRows; $config['uri_segment'] = $uriSegment; $config["suffix"] = $queryString; $config["first_url"] = $config["base_url"] . $queryString; $this->pagination->initialize($config); $data["arrDataDok"] = $arrDataDok; //-------- $data["data"] = $arrData; $data["pembagian_ruang"] = $this->model_pembagian_ruang->SearchRecordWhere("id_wa={$id}"); $data["data_view2"] = $this->load->view($this->module . "v_view2", $data, true); $this->_render_page($this->module . "v_view", $data, true); }