<?php

namespace App\User;

use Qs_Auth_Adapter_DbTable as AdapterDbTable;
use Zend_Db_Expr;

class AuthAdapter extends AdapterDbTable
{
    protected $_tableAlias = 'User';
    protected $_identityColumn = 'login';
    protected $_credentialColumn = 'password';
    protected $_credentialTreatment = 'MD5(CONCAT(`salt`, ?))';


    protected function _authenticateCreateSelect()
    {
        $dbSelect = parent::_authenticateCreateSelect();
        $dbSelect->where('`bought` = "y"');
        $dbSelect->columns(['membershipExpired' => new Zend_Db_Expr('`membershipExpiresOn` < CURDATE()')]);
        return $dbSelect;
    }
}