/**
* @return QueryBuilder
*/
public function getCharacterQueryBuilder()
{
/** @var \GameBackend\Entity\SRO\Shard\Repository\Character $repository */
$repository = $this->shardEntityManager->getRepository($this->gameOptions->getEntityShardCharacter());
$queryBuilder = $repository->createQueryBuilder('p')->select('p', 'user', 'job', 'guild')->join('p.user', 'user')->leftJoin('p.job', 'job')->leftJoin('p.guild', 'guild', Join::WITH, 'guild.id > 0')->orderBy('p.id', 'desc')->where('p.id > 0');
return $queryBuilder;
}
/**
* @return QueryBuilder
*/
public function getCharacterQueryBuilder()
{
$repository = $this->accountEntityManager->getRepository($this->gameOptions->getEntityAccountSmcLog());
$queryBuilder = $repository->createQueryBuilder('p')->select('p')->orderBy('p.dlogdate', 'desc');
return $queryBuilder;
}
/**
* @return QueryBuilder
*/
public function getNickNameQueryBuilder()
{
$repository = $this->shardEntityManager->getRepository($this->gameOptions->getEntityShardCharNickNameList());
$queryBuilder = $repository->createQueryBuilder('p')->select('p', 'user', 'job', 'char')->join('p.char', 'char')->join('char.job', 'job')->join('char.user', 'user')->orderBy('char.id', 'desc');
return $queryBuilder;
}
