function login($user_id, $password)
{
$CI =& get_instance();
/*
$data = array(
"email" => $email,
"password" => sha1($password)
);
*/
//$row=$this->conn->GetRow("select * from t_user where user_id=? and password=?",array($user_id,$password));
//echo $user_id.b64encode($password);exit;
$row = $this->conn->GetRow("select * from " . $this->user_table . " where " . $this->user_id . "=? and " . $this->password . "=?", array($user_id, $password));
if (cek_array($row) != TRUE) {
return FALSE;
} else {
//update the last login time
$last_login = date("Y-m-d H-i-s");
$data = array("last_login" => $last_login);
$userID = $row["user_id"];
$this->conn->AutoExecute($this->user_table, $data, "UPDATE", "user_id='{$userID}'");
//store user id in the session
//$CI->session->set_userdata("user_id", $row["user_id"]);
//$CI->session->set_userdata("user", $row);
//$_SESSION["userdata"]["user_id"]=$row["user_id"];
//$_SESSION["userdata"]["user"]=$row;
$_SESSION[$this->appname]["userdata"] = $row;
$_SESSION[$this->appname]["userdata"]["user_id"] = $row[$this->user_id];
$_SESSION[$this->appname]["userdata"]["user"] = $row;
return true;
}
}
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 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 cmsConfiguration()
{
$cms_cfg = $this->cfg_model->SearchRecord();
if (cek_array($cms_cfg)) {
foreach ($cms_cfg as $k => $v) {
$this->cms_cfg[$v['id_key']] = nl2br($v['value']);
}
}
}
function init_layout($page_title = "", $page_title_small = "", $bread_crumb = array())
{
$this->main_layout = "admin_lte_layout/main_layout";
$this->bread_layout = "admin_lte_layout/bread_crumb_template";
$this->layout_data["page_title"] = $page_title != "" ? $page_title : $this->module_title;
$this->layout_data["page_title_small"] = $page_title_small != "" ? $page_title_small : $this->module_title_small;
$data["breadcrumb"] = cek_array($bread_crumb) ? $bread_crumb : array(array("title" => "Home", "url" => base_url() . "/admin/", "active" => "", "icon" => "<i class='icon-home blue'></i> "));
$str_bread = $this->parser->parse($this->bread_layout, $data, true);
$this->layout_data["breadcrumb"] = $str_bread;
}
function get_lookup_skpa()
{
$arrData = $this->model->skpa_search_record(false, " order by id");
if (cek_array($arrData)) {
foreach ($arrData as $x => $val) {
$arrCat[$val["id"]] = $val["name"];
}
}
return $arrCat;
}
function get_lookup_pekerjaan()
{
$arrData = $this->user_model->m_pekerjaan(false, " order by id");
if (cek_array($arrData)) {
foreach ($arrData as $x => $val) {
$arrCat[$val["name"]] = $val["name"];
}
}
return $arrCat;
}
function get_keberatan_detil2($where = false)
{
$arrDB = $this->adodbx->search_record_where($this->tbl_detil, $where, $sort, $dataColumn);
if (cek_array($arrDB)) {
foreach ($arrDB as $k => $v) {
$arr[$v['status']] = $v['created_date'];
}
}
return $arr;
}
function check()
{
$user = isset($_POST["username"]) ? $_POST["username"] : "";
$pass = isset($_POST["password"]) ? $_POST["password"] : "";
if ($user == "" || $pass == "") {
$this->index();
}
$arrDB = $this->conn->GetRow("select * from t_user where user_id=? and password=?", array($user, $pass));
$status = cek_array($arrDB);
if ($status == true) {
if ($user != $arrDB["user_id"] || $pass != $arrDB["password"]) {
$this->index();
break;
}
$arrDB[$this->appname]["islogin"] = true;
//set session
//$this->session->set_userdata($arrDB);
//$_SESSION["userdata"]=$arrDB;
//$_SESSION["org"]=array();
//$_SESSION["app"]["p2hp"]="1";
$_SESSION[$this->appname]["userdata"] = $arrDB;
/*$_SESSION[$this->appname]["org"]=array();*/
/*$arrLPP=$this->conn->GetRow("select * from m_lpp where kd_lpp='".$arrDB["org_id"]."'");
if(cek_array($arrLPP)):
$_SESSION[$this->appname]["org"]=$arrLPP;
endif;
*/
/*
if($arrDB["group_id"]):
$dataDJPB["id_perusahaan"]="DJPB";
$dataDJPB["nama_perusahaan"]="Direktorat Jenderal Perikanan Budidaya";
$_SESSION["perusahaan"]=$dataDJPB;
endif;
*/
//if user pengguna jasa
/*
if($arrDB["group_id"]==2):
$arrPerusahaan=$this->perusahaan_model->GetRecord("idx=".$arrDB["id_perusahaan"]);
$_SESSION["perusahaan"]=$arrPerusahaan;
endif;
*/
$data["status"] = "success";
$data["msg"] = "Login Succeed";
$data["data"] = $arrDB;
redirect("/");
} else {
$this->session->set_flashdata('message', '<div id="message">Oopsie, username dan password salah, silahkan mencoba kembali.</div>');
$data["status"] = "success";
$data["msg"] = "Login Succeed";
$data["data"] = $arrDB;
redirect('login', 'refresh');
}
print json_encode($data);
}
function get_lookup($tmp_arr, $tmp_lookup_map)
{
$data = array();
$arrData = $tmp_arr;
$key = $tmp_lookup_map["key"];
$value = $tmp_lookup_map["value"];
if (cek_array($arrData)) {
$data = array();
foreach ($arrData as $x => $val) {
$datatmp = array();
$data[$val[$key]] = $val[$value];
}
}
return $data;
}
function get_kab_kota($kd_bps_propinsi = "", $arr_id = "")
{
$sql = "select * from m_kabupaten_kota where kode_prop={$kd_bps_propinsi} and kode_kab!='00' order by kode_bps";
$arrKabKota = $this->conn->GetAll($sql);
$arrData = array();
$arrData[""] = "Pilih Kabupaten";
if (cek_array($arrKabKota)) {
foreach ($arrKabKota as $x => $val) {
$arrData[$val["kode_bps"]] = $val["nama"];
}
}
$data["dataKabupaten"] = $arrData;
$data["arr_id"] = $arr_id;
echo $this->load->view($this->module . "lookup_kabupaten", $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 get_indikator($structurize = true)
{
$sql = "kode_komponen='0003'";
$arr = $this->indikator_model->SearchRecordWhere($sql . $not_sql);
if (!$structurize) {
if (cek_array($arr)) {
foreach ($arr as $k => $v) {
$ind[$v['colom_nilai']] = $v;
}
return $ind;
}
} else {
if (cek_array($arr)) {
foreach ($arr as $k => $v) {
$ind[$v['kategori']][] = $v;
}
return $ind;
}
}
}
function group_list()
{
if (!$this->cms->has_view($this->module)) {
redirect($this->auth_error_page);
}
//debug();
$this->load->library('pagination');
$queryString = rebuild_query_string();
$field = "name,description";
$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 = $this->model->getTotalRecordWhere($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 . "group_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;
//$arrData=$this->model->group_search_record_where(false," order by id ");
//$data["arrData"]=$arrData;
$this->_render_page($this->module . "group_list", $data, true);
}
function brwa_stats2()
{
$sql = "select doc_proses,doc_status from v_wa_data order by doc_proses, doc_status";
$arrData = $this->conn->GetAll($sql);
if (cek_array($arrData)) {
foreach ($arrData as $k => $v) {
if ($v['doc_proses'] == 1) {
$status_badges = '<span class="label label-warning">Teregistrasi</span>';
if ($v['doc_status'] == 4) {
$arr['Teregistrasi'] += 1;
} else {
$arr['Registrasi'] += 1;
}
} else {
if ($v['doc_proses'] == 2) {
if ($v['doc_status'] == 4) {
$arr['Terverifikasi'] += 1;
} else {
$arr['Teregistrasi'] += 1;
}
} else {
if ($v['doc_proses'] == 3) {
if ($v['doc_status'] == 4) {
$arr['Tersertifikasi'] += 1;
} else {
$arr['Terverifikasi'] += 1;
}
}
}
}
//$arr[$m_jenis[$v['doc_proses']]]=$v['total'];
//$stats[]='["'.($m_jenis[$v['doc_proses']]).'",'.$v['total']."]";
}
//pre ($arr);
if (cek_array($arr)) {
foreach ($arr as $k => $v) {
$stats[] = '["' . $k . '",' . $v . "]";
}
}
}
if (cek_array($stats)) {
$data['wa_stats'] = implode(",", $stats);
}
$this->load->view("wg/web/brwa_stats", $data);
}
<?php
foreach ($header_col as $head) {
?>
<th><?php
echo $head;
?>
</th>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
if (cek_array($arrData)) {
?>
<?php
foreach ($arrData as $x => $val) {
?>
<?php
//$id=$this->encrypt_status==TRUE?encrypt($val["id"]):$val["id"];
/* explode data to tr */
$data_tmp = array();
foreach ($val as $xx => $valxx) {
$data_tmp[] = "data-" . $xx . "='" . $valxx . "'";
}
$data_str = join(" ", $data_tmp);
?>
<tr <?php
function get_lookup_kabupatenAjax($id)
{
$filter = " kode_prop='" . $id . "' AND level=1";
$arrData = $this->user_model->m_kabupaten($filter);
// pre($arrData);
if (cek_array($arrData)) {
foreach ($arrData as $x => $val) {
$arrCat[$x]['kode_kab'] = $val["kode_kab"];
$arrCat[$x]['nama'] = $val["nama"];
}
}
// pre($arrCat);
$data['data'] = $arrCat;
// pre($data);
$data_layout["content"] = $this->load->view("wilayah/wilayah/v_select", $data, true);
// pre($data_layout["content"]);
if ($arrCat) {
print json_encode(array('status' => true, 'data' => $data_layout["content"]));
} else {
print json_encode(array('status' => false));
}
exit;
// return $arrCat;
}
function dms_user_perms_update($fid, $rights = 0, $uid = false)
{
debug();
$uid = $this->get_user_id($uid);
$row = $this->conn->GetRow("select fid from " . $this->tbl_user_perms . " where fid=? and uid=?", array($fid, $uid));
$found = 0;
if (cek_array($row)) {
$found = 1;
}
$this->conn->StartTrans();
if ($found == 0) {
$dataInsert["fid"] = $fid;
$dataInsert["uid"] = $uid;
$dataInsert["rights"] = $rights;
$this->adodbx->Insert($this->tbl_user_perms, $dataInsert);
} else {
$dataUpdate["rights"] = $rights;
$this->adodbx->Insert($this->tbl_user_perms, $data, "UPDATE", "fid={$fid} and uid={$uid}");
}
$ok = $this->conn->CompleteTrans();
return $ok;
}
<div class="box-body">
<h5 class="heading">Upload File Pendukung</h5>
<div class="form-group">
<div class="col-md-12" >
<a id="browse2" class="btn btn-xs btn-primary" href="javascript:;">Pilih File</a>
<a id="start-upload2" class="btn btn-xs btn-primary" href="javascript:;">[Start Upload]</a>
<br>
<ul id="filelist2"></ul>
<div class="table-responsive" style="overflow-y:hidden;overflow-x:auto;">
<table id="table_file_upload" class="table table-condensed file_list table-bordered">
<thead>
<tr><th width="10px">#</th><th>File</th><th width="10px">#</th></tr>
</thead>
<tbody>
<?php
if (cek_array($data_file)) {
?>
<?php
foreach ($data_file as $xfile => $file) {
?>
<tr class='file_row' id="file_upload_<?php
echo $file["id_file"];
?>
" data-file_id="<?php
echo $file["id_file"];
?>
">
<td><input type="hidden" name="upload_file_id[]" value="<?php
echo $file["id_file"];
?>
"/><a href="./<?php
foreach ($data_uu_detail as $xx => $valx) {
?>
<li style="padding:0"><?php
echo $valx["no_peraturan"] . " Tentang " . $valx["tentang"];
?>
</li>
<?php
}
?>
</ol>
<?php
}
?>
</td>
<td><?php
echo cek_array($data_peta_detail) ? "Ada" : "Tidak Ada";
?>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
</div><!-- end:print-this-->
<script type="text/javascript" src="assets/js/lingkar/jquery.export2excel.js"></script>
<a data-id_doc="<?php
echo $id_doc;
?>
" class="btn browse_doc_upload btn-xs btn-primary hide" href="javascript:;">[Start Upload]</a>
<ul class="filelist"></ul>
<table id="table_file_<?php
echo $id_doc;
?>
" class="table table-condensed file_list table-bordered">
<thead>
<tr><th width="10px">#</th><th>File</th><th width="10px">#</th></tr>
</thead>
<tbody>
<?php
if (cek_array($data_file2[$id_doc])) {
?>
<?php
foreach ($data_file2[$id_doc] as $x => $file) {
?>
<tr class='file_row' id="file_upload_<?php
echo $file["id_file"];
?>
" data-file_id="<?php
echo $file["id_file"];
?>
">
<td><input type="hidden" name="upload_file_id[]" value="<?php
echo $file["id_file"];
?>
"/><input type="hidden" name="id_jenis_doc[]" value="<?php
<ul>
<?php
foreach ($arrCategory as $cat) {
?>
<li id="<?php
echo $cat["idx"];
?>
">
<h5><?php
echo $cat["category"];
?>
</h5>
<div class="child">
<?php
if (cek_array($arrLink[$cat["idx"]])) {
?>
<ul>
<?php
foreach ($arrLink[$cat["idx"]] as $x => $val) {
?>
<li><a href="<?php
echo $val["link_url"];
?>
"><?php
echo $val["name"];
?>
</a></li>
<?php
}
?>
<div class="clearfix"></div>
</div></div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<h3>Upload Picture</h3>
<a id="browse_pic" class="btn btn-xs btn-primary" href="javascript:;">[+] Image</a>
<ul id="imagelist"></ul>
<div class="gallery">
<ul id="ul_gallery" class="row">
<?php
if (cek_array($data_image)) {
?>
<?php
foreach ($data_image as $img) {
?>
<li data-file_id="<?php
echo $img["id_file"];
?>
" id="img_upload_<?php
echo $img["id_file"];
?>
" class="col-lg-2 col-md-2 col-sm-3 col-xs-4">
<input type="hidden" name="image_file_id[]" value="<?php
echo $img["id_file"];
?>
"/><img src="<?php
<div class="row-fluid">
<div class="span11">
<label>Email</label>
<input name="email_pemohon" type="text" class="span12 required" value="<?php
echo $user['email'];
?>
" >
</div>
</div>
<!-- -->
<div class="row-fluid">
<div class="span11">
<br />
<label>Alasan Pengajuan Keberatan:</label>
<?php
if (cek_array($m_alasan)) {
foreach ($m_alasan as $k => $v) {
?>
<label class="checkbox">
<input name="alasan[]" type="checkbox" value="<?php
echo $k;
?>
" />
<?php
echo $v;
?>
</label>
<?php
}
}
?>
if (cek_array($data_file)) {
foreach ($data_file as $x => $val) {
$tmp = array();
$tmp = array_map("trim", $val);
$tmp["relative_path"] = $tmp["file_path"];
$tmp["id"] = $tmp["id_file"];
$data_file_all[$val["tipe_doc"]][] = $tmp;
}
}
$arrDasar = array();
$arrDasarID = array();
$arrDasarTentang = array();
$dasarTxtStr = "";
$dasarIDStr = "";
$dasarTentangStr = "";
if (cek_array($data_detail_uu)) {
foreach ($data_detail_uu as $x => $val) {
$arrDasar[] = $val["no_peraturan"];
$arrDasarID[] = $val["id"];
$arrDasarTentang[] = $val["tentang"];
}
$dasarTxtStr = join("|", $arrDasar);
$dasarIDStr = join("|", $arrDasarID);
$dasarTentangStr = join("|", $arrDasarTentang);
}
?>
<div class="row">
<div class="col-sm-12 col-lg-12">
<!-- start: page header -->
<div class="page-header">
</strong></div>
</div>
<br>
</div>
<div class="span4">
<div style="padding-left:10px">
<table cellpadding="2" border="0" cellspacing="0" class="table">
<thead>
<tr>
<th>Tanggal</td>
<th>Status</td>
</tr>
</th>
<tbody
<?php
if (cek_array($status_list)) {
foreach ($status_list as $k => $v) {
switch ($v['status']) {
case -1:
$status = "New";
$label = "label-important";
break;
case 1:
$status = "Open";
$label = "label-success";
break;
case 2:
$status = "Diproses";
$label = "label-warning";
break;
case 3:
function get_lookup_propinsi()
{
$arrData = $this->user_model->m_propinsi(false, " order by ur_wilayah");
if (cek_array($arrData)) {
foreach ($arrData as $x => $val) {
$arrCat[$val["ur_wilayah"]] = $val["ur_wilayah"];
}
}
return $arrCat;
}
</td>
</tr>
<tr>
<td style="background-color:#F7F7F7">Email</td><td><?php
echo $data["email"];
?>
</td>
</tr>
<tr>
<td style="background-color:#F7F7F7">Group</td><td>
<?php
$group_arr = array();
foreach ($data["groups"] as $group) {
$group_arr[] = $group["name"];
}
echo cek_array($group_arr) ? join(",", $group_arr) : "";
?>
</td>
</tr>
</table>
</div></div><!-- /span /row-->
<div class="control-group">
<label for="tentang" class="control-label"> </label>
<div class="controls">
</div>
</div>
</fieldset>
</form>
</div>
function click_count($id_link)
{
$CI =& get_instance();
$row = $this->adodbx->GetRecord($this->tbl_link_count, "id_link={$id_link}");
$this->conn->StartTrans();
//update cms link count
if (cek_array($row)) {
$dataUpdate["click_count"] = $row["click_count"] + 1;
$this->adodbx->Update($this->tbl_link_count, $dataUpdate, "id_link={$id_link}");
$dataUpdateStats = $dataUpdate;
} else {
$dataInsert["click_count"] = 1;
$dataInsert["id_link"] = $id_link;
$this->adodbx->Insert($this->tbl_link_count, $dataInsert);
}
//udate cms link stat
$dataUpdateStats["id_link"] = $id_link;
$dataUpdateStats["click_count"] = 1;
$dataUpdateStats["ip_address"] = $CI->_prepare_ip($this->input->ip_address());
$this->adodbx->Insert($this->tbl_link_stats, $dataUpdateStats);
$ok = $this->conn->CompleteTrans();
if ($ok) {
return TRUE;
} else {
return FALSE;
}
}
function update_data_detail($id_parent)
{
$this->model_detail->DeleteData("id_parent={$id_parent}");
//$data=$this->input->post("daerah_penugasan");
$data = get_post();
$id_propinsi_1 = $data["id_propinsi_1"];
$id_propinsi_2 = $data["id_propinsi_2"];
$arrPropinsi1_kab = $this->get_kab_kota_arr($id_propinsi_1);
$arrPropinsi2_kab = $this->get_kab_kota_arr($id_propinsi_2);
$id_peraturan = $data["id_jenis_peraturan"] . "_" . $data["no_peraturan"] . "_" . $data["tahun_peraturan"];
$no_sk = ucwords($data["id_jenis_peraturan"]) . " No." . $data["no_peraturan"] . " Tahun " . $data["tahun_peraturan"];
if (cek_array($data["id_kabupaten_1"])) {
foreach ($data["id_kabupaten_1"] as $x => $val) {
$data_detail_tmp = array();
$data_detail_tmp["id_parent"] = $id_parent;
$data_detail_tmp["id_peraturan"] = $id_peraturan;
$data_detail_tmp["id_propinsi_1"] = $id_propinsi_1;
$data_detail_tmp["id_propinsi_2"] = $id_propinsi_2;
$data_detail_tmp["id_kabupaten_1"] = $val;
$data_detail_tmp["id_kabupaten_2"] = $data["id_kabupaten_2"][$x];
$data_detail_tmp["kabupaten_1"] = $arrPropinsi1_kab[$val];
$data_detail_tmp["kabupaten_2"] = $arrPropinsi2_kab[$data["id_kabupaten_2"][$x]];
//$data_detail[]=$data_detail_tmp;
$this->model_detail->InsertData($data_detail_tmp);
}
}
}
