/**
* @param \Sudoux\Cms\UserBundle\Entity\User $user
* @return string
* @author Eric Haynes
*/
public function getLoanUserRoleType(User $user)
{
$roleType = 'Website Admin';
if ($this->isClientUser($user)) {
$roleType = 'Additional User';
} elseif (isset($this->user)) {
if ($user->getId() == $this->user->getId()) {
if ($user->hasRole('ROLE_LOAN_OFFICER')) {
$roleType = 'Loan Officer';
} else {
$roleType = 'Applicant';
}
}
}
return $roleType;
}
/**
* @param \Sudoux\Cms\UserBundle\Entity\User $user
* @return bool
* @author Eric Haynes
*/
public function isClientUser(User $user)
{
$isClientUser = false;
if (isset($this->client_user)) {
if ($this->client_user->count() > 0) {
foreach ($this->client_user as $clientUser) {
if ($clientUser->getId() == $user->getId()) {
$isClientUser = true;
break;
}
}
}
}
return $isClientUser;
}
/**
* @param Site $site
* @param User $user
* @return array
*/
public function findNewMessagesCountByUserQuery(Site $site, User $user)
{
$q = $this->createQueryBuilder('l')->select('count(t.id) as messages')->join('l.message_thread', 't')->join('t.message', 'm')->where('l.site = :site')->andWhere('m.user != :user_id')->andWhere('l.user = :user_id')->andWhere('l.deleted = 0')->andWhere('m.status = 0')->setParameter('user_id', $user->getId())->setParameter('site', $site->getId());
//echo $q->getDQL(); exit;
return $q->getQuery()->getScalarResult();
}
