File indexing completed on 2024-05-12 06:02:11

 <?php
 
 /**
  *  ocs-webserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-webserver.
  *
  *    This program is free software: you can redistribute it and/or modify
  *    it under the terms of the GNU Affero General Public License as
  *    published by the Free Software Foundation, either version 3 of the
  *    License, or (at your option) any later version.
  *
  *    This program is distributed in the hope that it will be useful,
  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  *    GNU Affero General Public License for more details.
  *
  *    You should have received a copy of the GNU Affero General Public License
  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  **/
 class Local_Validate_UsernameUnique extends Zend_Validate_Abstract
 {
     const EXISTS = 'already_exists';
 
     protected $_messageTemplates = array(
         self::EXISTS => 'An activated username already exists.'
     );
 
     /**
      * @param mixed $value
      * @param null  $context
      *
      * @return bool
      * @throws Zend_Exception
      */
     public function isValid($value, $context = null)
     {
         $value = (string)$value;
         $this->_setValue($value);
 
         return $this->isUsernameUnique($value, $context);
     }
 
     /**
      * @param $username
      * @param $context
      *
      * @return bool
      * @throws Zend_Db_Statement_Exception
      */
     private function isUsernameUnique($username, $context)
     {
         $sql = "
         SELECT `username`, `mail`, COUNT(*) AS `amount`
         FROM `member` AS `m`
         WHERE `m`.`is_active` = 1 AND `m`.`is_deleted` = 0 AND lower(`username`) = lower(:username)
         GROUP BY lower(`username`) -- , mail
         HAVING COUNT(*) > 1
         ";
 
         $result = Zend_Db_Table::getDefaultAdapter()->query($sql, array('username' => $username))->fetch();
 
         if (is_array($result) AND count($result) > 0) {
             $this->_error(self::EXISTS, $username);
 
             return false;
         }
 
         return true;
     }
 
 }