/**
* {@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);
}
/**
* {@inheritdoc}
*
* @param object $entity
* @param bool $flush
*/
public function deleteEntity($entity, $flush = true)
{
// Null parents of associated events first
$q = $this->getEntityManager()->getConnection()->createQueryBuilder();
$q->update(MAUTIC_TABLE_PREFIX . 'campaign_events')->set('parent_id', ':null')->setParameter('null', null)->where('campaign_id = ' . $entity->getId())->execute();
// Delete events
$q = $this->getEntityManager()->getConnection()->createQueryBuilder();
$q->delete(MAUTIC_TABLE_PREFIX . 'campaign_events')->where('campaign_id = ' . $entity->getId())->execute();
parent::deleteEntity($entity, $flush);
}
/**
* 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);
}
/**
* 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 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 getFilterExpr(&$q, $filter, $parameterName = null)
{
if ($filter['column'] == 's.date_submitted') {
$date = $this->factory->getDate($filter['value'], 'Y-m-d')->toUtcString();
$date1 = $this->generateRandomParameterName();
$date2 = $this->generateRandomParameterName();
$parameters = array($date1 => $date . ' 00:00:00', $date2 => $date . ' 23:59:59');
$expr = $q->expr()->andX($q->expr()->gte('s.date_submitted', ":{$date1}"), $q->expr()->lte('s.date_submitted', ":{$date2}"));
return array($expr, $parameters);
} else {
return parent::getFilterExpr($q, $filter);
}
}
/**
* Get a list of entities
*
* @param array $args
* @return Paginator
*/
public function getEntities($args = array())
{
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);
}
