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());
}
}
