protected function getUserSelect($login_name, $organization)
    {
        /**
         * Read the needed parameters from the different tables, lots of renames
         * for compatibility accross implementations.
         */
        $select = new \Zend_Db_Select($this->db);
        $select->from('gems__user_logins', array(
                    'user_login_id'       => 'gul_id_user',
                    'user_two_factor_key' => 'gul_two_factor_key',
                    'user_enable_2factor' => 'gul_enable_2factor'
                    ))
                ->join('gems__staff', 'gul_login = gsf_login AND gul_id_organization = gsf_id_organization', array(
                    'user_id'             => 'gsf_id_user',
                    'user_login'          => 'gsf_login',
                    'user_email'          => 'gsf_email',
                    'user_first_name'     => 'gsf_first_name',
                    'user_surname_prefix' => 'gsf_surname_prefix',
                    'user_last_name'      => 'gsf_last_name',
                    'user_gender'         => 'gsf_gender',
                    'user_group'          => 'gsf_id_primary_group',
                    'user_locale'         => 'gsf_iso_lang',
                    'user_logout'         => 'gsf_logout_on_survey',
                    'user_base_org_id'    => 'gsf_id_organization',
                    ))
               ->join('gems__groups', 'gsf_id_primary_group = ggp_id_group', array(
                   'user_role'=>'ggp_role',
                   'user_allowed_ip_ranges' => 'ggp_allowed_ip_ranges',
                   ))
               //->joinLeft('gems__user_passwords', 'gul_id_user = gup_id_user', array(
               //    'user_password_reset' => 'gup_reset_required',
               //    ))
               ->where('ggp_group_active = 1')
               ->where('gsf_active = 1')
               ->where('gul_can_login = 1')
               ->where('gul_login = ?')
               ->where('gul_id_organization = ?')
               ->limit(1);

        return $select;
    }
protected function getUserSelect($login_name, $organization)
    {
        /**
         * Read the needed parameters from the different tables, lots of renames
         * for compatibility accross implementations.
         */
        $select = new \Zend_Db_Select($this->db);
        $select->from('gems__user_logins', array(
                    'user_login_id'       => 'gul_id_user',
                    'user_two_factor_key' => 'gul_two_factor_key',
                    'user_enable_2factor' => 'gul_enable_2factor'
                    ))
                ->join('gems__staff', 'gul_login = gsf_login AND gul_id_organization = gsf_id_organization', array(
                    'user_id'             => 'gsf_id_user',
                    'user_login'          => 'gsf_login',
                    'user_email'          => 'gsf_email',
                    'user_first_name'     => 'gsf_first_name',
                    'user_surname_prefix' => 'gsf_surname_prefix',
                    'user_last_name'      => 'gsf_last_name',
                    'user_gender'         => 'gsf_gender',
                    'user_group'          => 'gsf_id_primary_group',
                    'user_locale'         => 'gsf_iso_lang',
                    'user_logout'         => 'gsf_logout_on_survey',
                    'user_base_org_id'    => 'gsf_id_organization',
                    ))
               ->join('gems__groups', 'gsf_id_primary_group = ggp_id_group', array(
                   'user_role'=>'ggp_role',
                   'user_allowed_ip_ranges' => 'ggp_allowed_ip_ranges',
                   ))
               //->joinLeft('gems__user_passwords', 'gul_id_user = gup_id_user', array(
               //    'user_password_reset' => 'gup_reset_required',
               //    ))
               ->where('ggp_group_active = 1')
               ->where('gsf_active = 1')
               ->where('gul_can_login = 1')
               ->where('gul_login = ?')
               ->where('gul_id_organization = ?')
               ->limit(1);

        return $select;
    }
protected function getUserSelect ( $ login_name , $ organization ) { /**
         * Read the needed parameters from the different tables, lots of renames
         * for compatibility accross implementations.
         */ $ select = new \ Zend_Db_Select ( $ this -> db ) ; $ select -> from ( 'gems__user_logins' , array ( 'user_login_id' => 'gul_id_user' , 'user_two_factor_key' => 'gul_two_factor_key' , 'user_enable_2factor' => 'gul_enable_2factor' ) ) -> join ( 'gems__staff' , 'gul_login = gsf_login AND gul_id_organization = gsf_id_organization' , array ( 'user_id' => 'gsf_id_user' , 'user_login' => 'gsf_login' , 'user_email' => 'gsf_email' , 'user_first_name' => 'gsf_first_name' , 'user_surname_prefix' => 'gsf_surname_prefix' , 'user_last_name' => 'gsf_last_name' , 'user_gender' => 'gsf_gender' , 'user_group' => 'gsf_id_primary_group' , 'user_locale' => 'gsf_iso_lang' , 'user_logout' => 'gsf_logout_on_survey' , 'user_base_org_id' => 'gsf_id_organization' , ) ) -> join ( 'gems__groups' , 'gsf_id_primary_group = ggp_id_group' , array ( 'user_role' => 'ggp_role' , 'user_allowed_ip_ranges' => 'ggp_allowed_ip_ranges' , ) ) //->joinLeft('gems__user_passwords', 'gul_id_user = gup_id_user', array( //    'user_password_reset' => 'gup_reset_required', //    )) -> where ( 'ggp_group_active = 1' ) -> where ( 'gsf_active = 1' ) -> where ( 'gul_can_login = 1' ) -> where ( 'gul_login = ?' ) -> where ( 'gul_id_organization = ?' ) -> limit ( 1 ) ; return $ select ; }
Copied from \Gems_User_StaffUserDefinition but left out the password link

@param type $login_name
@param type $organization
@return \Zend_Db_Select
Copied from \ Gems_User_StaffUserDefinition but left out the password link