/**
* {@inheritdoc}
*/
public function getEntities($args = array())
{
$q = $this->_em->createQueryBuilder();
$q->select($this->getTableAlias())->from('MauticAddonBundle:Addon', $this->getTableAlias(), $this->getTableAlias() . '.id');
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* {@inheritdoc}
*/
public function getEntities($args = array())
{
$q = $this->_em->createQueryBuilder();
$q->select($this->getTableAlias())->from('MauticPluginBundle:Plugin', $this->getTableAlias(), !empty($args['index']) ? $this->getTableAlias() . '.' . $args['index'] : $this->getTableAlias() . '.id');
$args['qb'] = $q;
$args['ignore_paginator'] = true;
return parent::getEntities($args);
}
public function getPublishedEntitiesCount()
{
$q = $this->createQueryBuilder($this->getTableAlias());
$expr = $this->getPublishedByDateExpression($q);
$q->where($expr);
$args['qb'] = $q;
return parent::getEntities($args)->count();
}
/**
* Get a list of entities.
*
* @param array $args
*
* @return Paginator
*/
public function getEntities($args = [])
{
$q = $this->_em->createQueryBuilder()->select('e')->from('MauticDynamicContentBundle:DynamicContent', 'e', 'e.id');
if (empty($args['iterator_mode'])) {
$q->leftJoin('e.category', 'c');
}
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* {@inheritdoc}
*/
public function getEntities($args = array())
{
//use a subquery to get a count of submissions otherwise doctrine will not pull all of the results
$sq = $this->_em->createQueryBuilder()->select('count(fs.id)')->from('MauticFormBundle:Submission', 'fs')->where('fs.form = f');
$q = $this->createQueryBuilder('f');
$q->select('f, (' . $sq->getDql() . ') as submission_count');
$q->leftJoin('f.category', 'c');
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* Get a list of entities.
*
* @param array $args
*
* @return Paginator
*/
public function getEntities($args = [])
{
$alias = $this->getTableAlias();
$q = $this->_em->createQueryBuilder()->select($alias)->from('MauticFocusBundle:Focus', $alias, $alias . '.id');
if (empty($args['iterator_mode'])) {
$q->leftJoin($alias . '.category', 'c');
}
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* {@inheritdoc}
*/
public function getEntities($args = array())
{
$q = $this->getEntityManager()->createQueryBuilder()->select($this->getTableAlias() . ', cat')->from('MauticCampaignBundle:Campaign', $this->getTableAlias(), $this->getTableAlias() . '.id')->leftJoin($this->getTableAlias() . '.category', 'cat');
if (!empty($args['joinLists'])) {
$q->leftJoin($this->getTableAlias() . '.lists', 'l');
}
if (!empty($args['joinForms'])) {
$q->leftJoin($this->getTableAlias() . '.forms', 'f');
}
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* Get a list of entities
*
* @param array $args
*
* @return Paginator
*/
public function getEntities($args = array())
{
$q = $this->createQueryBuilder('e')->select('e, ec, ep')->join('e.campaign', 'c')->leftJoin('e.children', 'ec')->leftJoin('e.parent', 'ep');
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* {@inheritdoc}
*/
public function getEntities($args = [])
{
$q = $this->_em->createQueryBuilder()->select($this->getTableAlias() . ', cat')->from('MauticPointBundle:Point', $this->getTableAlias())->leftJoin($this->getTableAlias() . '.category', 'cat');
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* Get a list of entities
*
* @param array $args
* @return Paginator
*/
public function getEntities($args = array())
{
$q = $this->createQueryBuilder('c')->select('c');
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* Get a list of entities
*
* @param array $args
* @return Paginator
*/
public function getEntities($args = array())
{
return parent::getEntities($args);
}
/**
* Get a list of users
*
* @param array $args
*
* @return Paginator
*/
public function getEntities($args = array())
{
$q = $this->createQueryBuilder('u')->select('u, r')->leftJoin('u.role', 'r');
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* Get a list of roles.
*
* @param array $args
*
* @return Paginator
*/
public function getEntities($args = [])
{
$q = $this->createQueryBuilder('r');
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* Get a list of entities
*
* @param array $args
* @return Paginator
*/
public function getEntities($args = array())
{
$q = $this->_em->createQueryBuilder()->select('e')->from('MauticEmailBundle:Email', 'e', 'e.id');
if (empty($args['iterator_mode'])) {
$q->leftJoin('e.category', 'c');
if (!isset($args['email_type']) || $args['email_type'] == 'list') {
$q->leftJoin('e.lists', 'l');
}
}
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* Get a list of entities.
*
* @param array $args
*
* @return Paginator
*/
public function getEntities($args = [])
{
return parent::getEntities($args);
}
/**
* {@inheritdoc}
*/
public function getEntities($args = array())
{
$q = $this->createQueryBuilder($this->getTableAlias())->leftJoin($this->getTableAlias() . '.category', 'c');
$args['qb'] = $q;
return parent::getEntities($args);
}
/**
* {@inheritdoc}
*/
public function getEntities($args = [])
{
$q = $this->createQueryBuilder('p')->select('p')->leftJoin('p.category', 'c');
$args['qb'] = $q;
return parent::getEntities($args);
}
public function getEntities($args = array())
{
$q = $this->_em->createQueryBuilder()->select('e')->from('CustomCrmBundle:Opportunity', 'e', 'e.id')->leftJoin('e.ownerUser', 'o');
$args['qb'] = $q;
return parent::getEntities($args);
}