Exemple #1
0
 /**
  * Get paginator
  *
  * @param   mixed|null  $where
  * @param   mixed|null  $order
  * @param   mixed|null  $columns
  * @param   mixed|null  $joins
  * @param   mixed|null  $quantifier
  * @return  \Zend\Paginator\Paginator
  */
 public function getPaginator($where = null, $order = null, $columns = null, $joins = null, $quantifier = null)
 {
     $joins = array_merge((array) $joins, array('rootParagraph' => array('table' => array('rootParagraph' => $this->getTableInSchema('paragraph')), 'where' => 'customize_rule.rootParagraphId = rootParagraph.id', 'type' => Sql\Select::JOIN_LEFT, 'columns' => array('rootType' => 'type', 'rootName' => 'name'))));
     return parent::getPaginator($where, $order, $columns, $joins, $quantifier);
 }
Exemple #2
0
 /**
  * Get paginator
  *
  * @param   mixed|null  $where
  * @param   mixed|null  $order
  * @param   mixed|null  $columns
  * @param   mixed|null  $joins
  * @param   mixed|null  $quantifier
  * @return  \Zend\Paginator\Paginator
  */
 public function getPaginator($where = null, $order = null, $columns = null, $joins = null, $quantifier = null)
 {
     $joins = array_merge((array) $joins, array('user_group' => array('table' => $this->getTableInSchema('user_group'), 'where' => 'user.groupId = user_group.id', 'columns' => array('groupName' => 'name'))));
     return parent::getPaginator($where, $order, $columns, $joins, $quantifier);
 }
Exemple #3
0
 /**
  * Get paginator
  *
  * @param   mixed|null  $where
  * @param   mixed|null  $order
  * @param   mixed|null  $columns
  * @param   mixed|null  $joins
  * @param   mixed|null  $quantifier
  * @return  \Zend\Paginator\Paginator
  */
 public function getPaginator($where = null, $order = null, $columns = null, $joins = null, $quantifier = null)
 {
     $joins = array_merge((array) $joins, array('subdomain' => array('where' => static::$tableName . '.subdomainId = subdomain.id', 'columns' => array('subdomain'), 'type' => Select::JOIN_LEFT), 'paragraph_content' => array('table' => array('paragraph_content' => 'paragraph'), 'where' => static::$tableName . '.contentId = paragraph_content.id', 'columns' => array('contentName' => 'name'), 'type' => Select::JOIN_LEFT)));
     return parent::getPaginator($where, $order, $columns, $joins, $quantifier);
 }
Exemple #4
0
 /**
  * Get paginator
  *
  * @param   mixed|null  $where
  * @param   mixed|null  $order
  * @param   mixed|null  $columns
  * @param   mixed|null  $joins
  * @param   mixed|null  $quantifier
  * @return  \Zend\Paginator\Paginator
  */
 public function getPaginator($where = null, $order = null, $columns = null, $joins = null, $quantifier = null)
 {
     $joins = array_merge((array) $joins, array('user' => array('table' => $this->getTableInSchema('user'), 'where' => static::$tableName . '.loggedUserId = user.id', 'columns' => array('loggedUserName' => 'displayName'), 'type' => Sql\Select::JOIN_LEFT)));
     return parent::getPaginator($where, $order, $columns, $joins, $quantifier);
 }