Zend FR

<?php

/**
 * Zend Framework
 *
 * LICENSE
 *
 * This source file is subject to the new BSD license that is bundled
 * with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://framework.zend.com/license/new-bsd
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@zend.com so we can send you a copy immediately.
 *
 * @package   Fast
 * @subpackage  Fast_Auth
 * @subpackage Fast_Auth_Adapter
 * @copyright  ftgroup
 * @author Jean-Yves Terrien
 * @version    $Id: DbTable.php,v 1.2 2008/08/25 07:57:27 sekaijin Exp $
 */


/**
 * @see Zend_Auth_Adapter_DbTable
 */
Zend_Loader::loadClass('Zend_Auth_Adapter_DbTable');

/**
 * @package   Fast
 * @subpackage  Fast_Auth
 * @subpackage Fast_Auth_Adapter
 * @copyright  ftgroup
 */
class Fast_Auth_Adapter_DbTable
extends Zend_Auth_Adapter_DbTable
{
    /**
     * __construct() - Sets configuration options
     *
     * @param  Zend_Db_Adapter_Abstract $zendDb
     * @param  string                   $tableName
     * @param  string                   $identityColumn
     * @param  string                   $credentialColumn
     * @param  string                   $credentialTreatment
     * @return void
     */
    public function __construct(Zend_Db_Adapter_Abstract $zendDb, $tableName = null, $identityColumn = null,
                                $credentialColumn = null, $credentialTreatment = null)
    {
        $parameters = Fast_Registry::getParameters();
        $parameters = $parameters->get('fast', (object)array('authTable' => 'user'));

        parent::__construct($zendDb, $parameters->authTable, 'usr_ident',
                                'usr_pwd', $credentialTreatment);
    }

    /**
     * Requete sur la base.
     *
     * @var Zend_Db_Adapter_Abstract
     */
    protected $_dbSelect = null;

    public function setQuery($query) {
        $this->_dbSelect = $query;
    }


    protected function _getQuery() {
        if (!isset($this->_dbSelect)) {
            //Récupérer le nom du driver;
            $driver = basename(preg_replace('/_/', '/',get_class($this->_zendDb)));

            //methode d'acces à la date du jour en fonction du driver
            $today = array(
                'Oci' => 'sysdate',
                'Mysql' => 'NOW()'
            );
            $exception = null;

            if ($this->_tableName == '') {
                $exception = 'A table must be supplied for the Zend_Auth_Adapter_DbTable authentication adapter.';
            } elseif ($this->_identityColumn == '') {
                $exception = 'An identity column must be supplied for the Zend_Auth_Adapter_DbTable authentication adapter.';
            } elseif ($this->_credentialColumn == '') {
                $exception = 'A credential column must be supplied for the Zend_Auth_Adapter_DbTable authentication adapter.';
            } elseif ($this->_identity == '') {
                $exception = 'A value for the identity was not provided prior to authentication with Zend_Auth_Adapter_DbTable.';
            } elseif ($this->_credential === null) {
                $exception = 'A credential value was not provided prior to authentication with Zend_Auth_Adapter_DbTable.';
            }

            if (null !== $exception) {
                /**
                 * @see Zend_Auth_Adapter_Exception
                 */
                require_once 'Zend/Auth/Adapter/Exception.php';
                throw new Zend_Auth_Adapter_Exception($exception);
            }
            $credentialExpression = new Zend_Db_Expr(
                $this->_zendDb->quoteInto(
                    '(CASE WHEN '.$this->_credentialColumn
                    . ' = '
                    . $this->_credentialTreatment, $this->_credential
                    )

                . ' THEN 1 ELSE 0 END) AS '
                . $this->_zendDb->quoteIdentifier('zend_auth_credential_match')
                );



            // get select
            $this->_dbSelect = $this->_zendDb->select();
            $this->_dbSelect->distinct()
                ->from($this->_tableName, array('*', $credentialExpression))
                ->join('PROFILE', $this->_zendDb->quoteIdentifier($this->_tableName).'.usr_id = '.$this->_zendDb->quoteIdentifier('PROFILE').'.usr_id', Array())
                ->where($this->_zendDb->quoteIdentifier($this->_tableName).'.'.$this->_identityColumn . ' = ?', $this->_identity)
                ->where($this->_zendDb->quoteIdentifier($this->_tableName).'.usr_begin_dt <= ' . $today[$driver])
                ->where($this->_zendDb->quoteIdentifier($this->_tableName).'.usr_end_dt >= ' . $today[$driver])
                ->where($this->_zendDb->quoteIdentifier('PROFILE').'.prf_begin_dt <= ' . $today[$driver])
                ->where($this->_zendDb->quoteIdentifier('PROFILE').'.prf_end_dt >= ' . $today[$driver])
            ;
        }
        return $this->_dbSelect;
    }

    /**
     * authenticate() - defined by Zend_Auth_Adapter_Interface.
     *
     * @throws Zend_Auth_Adapter_Exception if answering the authentication query is impossible
     * @return Zend_Auth_Result
     */
    public function authenticate()
    {
        $exception = null;
#Fast_Debug::show('$user', $this);
        if ($this->_identity == '') {
            $exception = 'A value for the identity was not provided prior to authentication with Zend_Auth_Adapter_DbTable.';
        }
        if (null !== $exception) {
            /**
             * @see Zend_Auth_Adapter_Exception
             */
            require_once 'Zend/Auth/Adapter/Exception.php';
            throw new Zend_Auth_Adapter_Exception($exception);
        }

        // create result array
        $authResult = array(
            'code'     => Zend_Auth_Result::FAILURE,
            'identity' => $this->_identity,
            'messages' => array()
            );


        // build credential expression
        if (empty($this->_credentialTreatment) || (strpos($this->_credentialTreatment, "?") === false)) {
            $this->_credentialTreatment = '?';
        }

        // query for the identity
        try {
            // get select
            $this->_getQuery();
            $resultIdentities = $this->_zendDb->fetchAll($this->_dbSelect->__toString());
         } catch (Zend_Db_Adapter_Exception $e) {
            $authResult['code'] = Zend_Auth_Result::FAILURE;
            $authResult['messages'][] = 'Conection fail.';
            return new Zend_Auth_Result($authResult['code'], $authResult['identity'], $authResult['messages']);
        } catch (Exception $e) {
            /**
             * @see Zend_Auth_Adapter_Exception
             */
            require_once 'Zend/Auth/Adapter/Exception.php';
            throw new Zend_Auth_Adapter_Exception('The supplied parameters to Zend_Auth_Adapter_DbTable failed to '
                                                . 'produce a valid sql statement, please check table and column names '
                                                . 'for validity.');
        }

        if (count($resultIdentities) < 1) {
            $authResult['code'] = Zend_Auth_Result::FAILURE_IDENTITY_NOT_FOUND;
            $authResult['messages'][] = 'A record with the supplied identity could not be found.';
            return new Zend_Auth_Result($authResult['code'], $authResult['identity'], $authResult['messages']);
        } elseif (count($resultIdentities) > 1) {
            $authResult['code'] = Zend_Auth_Result::FAILURE_IDENTITY_AMBIGUOUS;
            $authResult['messages'][] = 'More than one record matches the supplied identity.';
            return new Zend_Auth_Result($authResult['code'], $authResult['identity'], $authResult['messages']);
        }

        $resultIdentity = $resultIdentities[0];

        if ($resultIdentity['zend_auth_credential_match'] != '1') {
            $authResult['code'] = Zend_Auth_Result::FAILURE_CREDENTIAL_INVALID;
            $authResult['messages'][] = 'Supplied credential is invalid.';
            return new Zend_Auth_Result($authResult['code'], $authResult['identity'], $authResult['messages']);
        }

        unset($resultIdentity['zend_auth_credential_match']);
        $this->_resultRow = $resultIdentity;

        $authResult['code'] = Zend_Auth_Result::SUCCESS;
        $authResult['messages'][] = 'Authentication successful.';
        return new Zend_Auth_Result($authResult['code'], $authResult['identity'], $authResult['messages']);
    }

}