original_string: 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;
      }
code: 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;
      }
code_tokens: 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 ; }
docstring: Copied from \Gems_User_StaffUserDefinition but left out the password link
  
  @param type $login_name
  @param type $organization
  @return \Zend_Db_Select
docstring_tokens: Copied from \ Gems_User_StaffUserDefinition but left out the password link