/**
* 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'];
?>
