/** * Fetch user data from the database * possibility to mix search, filter and order * @param string $search_string * @param strong $order * @param string $order_type * @param int $limit_start * @param int $limit_end * @return array */ public function get_user($search_string = null, $order = null, $order_type = 'DESC', $limit_start = null, $limit_end = null, $wherestatus = null) { $get_parent_userids = model_load_model('user_role_extended_model')->get_user_role_extended_by_field_array(array("parent_user_id"), array(Access_level::session_user_id())); $this->db->select('*'); $this->db->from('user'); $this->db->where('user_type', 'operator'); $parent_ids[] = Access_level::session_user_id(); switch (Access_level::session_user_type()) { case 'super_admin': break; case 'admin': for ($i = 0; $i < count($get_parent_userids); $i++) { $parent_ids[] = $get_parent_userids[$i]['user_id']; } break; default: break; } $parent_string = implode(",", $parent_ids); if (Access_level::session_user_type() != 'super_admin') { $this->db->where("user_id IN ({$parent_string})"); } if ($wherestatus != null) { $this->db->where('status', $wherestatus); } //$this->db->order_by('status', 'Active'); if ($search_string) { if ($order == 'language_interface') { $this->load->model('site_language_model'); //$language_interface = $this->site_language_model->get_language_by_id(); //$lang = !empty($language_interface[0]['language_longform']) ? $language_interface[0]['language_longform'] : '--'; $this->db->join('site_language', 'user.language_interface = site_language.site_language_id'); $order = 'site_language.language_longform'; } $this->db->like($order, $search_string); } $this->db->group_by('user_id'); if ($order) { $this->db->order_by($order, $order_type); } else { $this->db->order_by('user_id', $order_type); } if ($limit_start && $limit_end) { $this->db->limit($limit_start, $limit_end); } if ($limit_start != null) { $this->db->limit($limit_start, $limit_end); } $query = $this->db->get(); return $query->result_array(); }
<div class="control-group"> <label for="inputError" class="control-label">Phone</label> <div class="controls"> <input type="text" id="" name="phone" value="<?php echo set_value('phone'); ?> " > <!--<span class="help-inline">Woohoo!</span>--> </div> </div> <?php //echo "<pre>"; print_r($this->session->all_userdata()); die; ?> <?php if (Access_level::session_user_type() == 'super_admin') { ?> <div class="control-group"> <label for="inputError" class="control-label">Company<span class="star">*</span></label> <div class="controls"> <select name="company_id"> <option value="">-select company-</option> <?php for ($i = 0; $i < count($company); $i++) { ?> <option <?php echo custom_set_value('company_id') == $company[$i]['company_id'] ? 'selected="selected"' : ''; ?> value="<?php echo $company[$i]['company_id']; ?>