I am new in CI hmvc and i am using CI generate_crud() method like below :
public function index()
{
$crud = $this->generate_crud('users');
$crud->columns('groups', 'username', 'email', 'first_name', 'last_name', 'company', 'no_employee', 'active');
$this->unset_crud_fields('ip_address', 'last_login');
// only webmaster and admin can change member groups
if ($crud->getState()=='list' || $this->ion_auth->in_group(array('webmaster', 'admin')))
{
$crud->set_relation_n_n('groups', 'users_groups', 'groups', 'user_id', 'group_id', 'name');
}
// only webmaster and admin can reset user password
if ($this->ion_auth->in_group(array('webmaster', 'admin')))
{
$crud->add_action('Reset Password', '', 'admin/user/reset_password', 'fa fa-repeat');
$crud->add_action('Edit', '', 'admin/user/edit_user', 'edit-icon');
}
// disable direct create / delete Frontend User
$crud->unset_add();
$this->mPageTitle = 'Users';
$this->render_crud();
}
This returns me the list of all active and inactive users but i want only active users in list. How can i modify my code with so that i can get list of only active users.
You need to set the condition for the active = true
$crud->where('active',true);
This will only return the active columns.