public function loadUserByUsername($username)
{
$Work = $this->getEntityManager()->getRepository('Eccube\\Entity\\Master\\Work')->find(\Eccube\Entity\Master\Work::WORK_ACTIVE_ID);
$query = $this->createQueryBuilder('m')->where('m.login_id = :login_id')->andWhere('m.Work = :Work')->setParameters(array('login_id' => $username, 'Work' => $Work))->setMaxResults(1)->getQuery();
$Member = $query->getOneOrNullResult();
if (!$Member) {
throw new UsernameNotFoundException(sprintf('Username "%s" does not exist.', $username));
}
return $Member;
}