function makeOptionCategory($s_id = '') { try { $CI =& get_instance(); $CI->load->model('task_model'); $info = $CI->task_model->fetch_category(); $s_option = ''; if ($info) { foreach ($info as $res) { $s_select = ''; if ($res["i_id"] == $s_id) { $s_select = " selected "; } $s_option .= "<option {$s_select} value='" . $res["i_id"] . "'>" . ($res[db_field_wrtcl("s_category_name")] == "" ? $res[db_field_wrtol("s_category_name")] : $res[db_field_wrtcl("s_category_name")]) . "</option>"; } } unset($info, $s_select); return $s_option; } catch (Exception $err_obj) { show_error($err_obj->getMessage()); } }
public function fetch_menus_navigation($s_where = null, $i_user_type_id, $or = ' ORDER BY i_id ASC ') { try { $ret_ = array(); $s_qry = "SELECT n.*, \n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\t\tSELECT count(i_id) \n\t\t\t\t\t\t\t\t\tFROM {$this->tbl_permit} \n\t\t\t\t\t\t\t\t\tWHERE i_menu_id = n.i_id AND (i_user_type = '{$i_user_type_id}' OR s_action = 'Default') \n\t\t\t\t\t\t\t) AS i_total_controls\n\t\t\t \tFROM " . $this->tbl . " n " . ($s_where != "" ? $s_where : "") . $or . (is_numeric($i_start) && is_numeric($i_limit) ? " Limit " . intval($i_start) . "," . intval($i_limit) : ""); $rs = $this->db->query($s_qry); $i_cnt = 0; if ($rs->num_rows() > 0) { foreach ($rs->result() as $row) { $ret_[$i_cnt]["id"] = $row->i_id; ////always integer $ret_[$i_cnt]["s_name"] = stripslashes(htmlspecialchars_decode($row->s_name)); $ret_[$i_cnt]["s_link"] = stripslashes(htmlspecialchars_decode($row->s_link)); $ret_[$i_cnt]["i_total_controls"] = $row->i_total_controls; $ret_[$i_cnt]["s_icon_class"] = $row->s_icon_class; $ret_[$i_cnt]["t_name"] = $row->{db_field_wrtcl('s_name')}; $i_cnt++; } $rs->free_result(); } unset($s_qry, $rs, $row, $i_cnt, $s_where, $i_start, $i_limit, $s_desc); return $ret_; } catch (Exception $err_obj) { show_error($err_obj->getMessage()); } }