<?php

namespace App\User;

use Qs_Auth_Adapter_DbTable as AdapterDbTable;

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

    protected function _authenticateCreateSelect()
    {
        $select = parent::_authenticateCreateSelect();
        $select->where('`bought` = "y"');
        $select->where('`membershipTypeId` IS NOT NULL');
        $select->columns([
            'membershipExpired'   => Model::getMembershipExpiredExpr(),
            'gracePeriodExpired'  => Model::getMembershipGracePeriodExpiredExpr(),
            'unreadMessagesCount' => Model::unreadMessagesCountExpr(),
        ]);
        return $select;
    }
}