Eccube\Repository\CustomerRepository::getNonActiveCustomerBySecretKey PHP Метод

    public function getNonActiveCustomerBySecretKey($secret_key)
    {
        $qb = $this->createQueryBuilder('c')->where('c.del_flg = 0 AND c.secret_key = :secret_key')->leftJoin('c.Status', 's')->andWhere('s.id = :status')->setParameter('secret_key', $secret_key)->setParameter('status', CustomerStatus::NONACTIVE);
        $query = $qb->getQuery();
        return $query->getSingleResult();
    }