/**
* @api
*
* @param \Propel\Runtime\ActiveQuery\ModelCriteria $expandableQuery
* @param bool $excludeDirectParent
* @param bool $excludeRoot
* @param string $leftTableAlias
* @param string $relationTableAlias
* @param string $fieldIdentifier
*
* @return \Propel\Runtime\ActiveQuery\ModelCriteria
*/
public function joinCategoryQueryWithParentCategories(ModelCriteria $expandableQuery, $excludeDirectParent = true, $excludeRoot = true, $leftTableAlias = SpyCategoryNodeTableMap::TABLE_NAME, $relationTableAlias = 'categoryParents', $fieldIdentifier = 'parent')
{
$expandableQuery->addJoinObject(new Join($leftTableAlias . '.id_category_node', SpyCategoryClosureTableTableMap::COL_FK_CATEGORY_NODE_DESCENDANT, Criteria::LEFT_JOIN));
$expandableQuery->addJoinObject((new Join(SpyCategoryClosureTableTableMap::COL_FK_CATEGORY_NODE, SpyCategoryNodeTableMap::COL_ID_CATEGORY_NODE, Criteria::INNER_JOIN))->setRightTableAlias($relationTableAlias), $relationTableAlias . 'Join');
if ($excludeDirectParent) {
$expandableQuery->addAnd(SpyCategoryClosureTableTableMap::COL_DEPTH, 0, Criteria::GREATER_THAN);
}
if ($excludeRoot) {
$expandableQuery->addJoinCondition($relationTableAlias . 'Join', $relationTableAlias . '.is_root = false');
}
$expandableQuery->withColumn('GROUP_CONCAT(' . $relationTableAlias . '.id_category_node)', 'category_' . $fieldIdentifier . '_ids');
$expandableQuery->withColumn(SpyCategoryClosureTableTableMap::COL_FK_CATEGORY_NODE_DESCENDANT, 'descendant_id');
$expandableQuery->withColumn(SpyCategoryClosureTableTableMap::COL_DEPTH, 'depth');
return $expandableQuery;
}
public function testAddUsingAliasTrueAliasTwice()
{
$c1 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c1->setModelAlias('b', true);
$c1->addUsingAlias(BookTableMap::COL_TITLE, 'foo');
$c1->addUsingAlias(BookTableMap::COL_TITLE, 'bar');
$c2 = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c2->setModelAlias('b', true);
$c2->add('b.title', 'foo');
$c2->addAnd('b.title', 'bar');
$this->assertEquals($c2, $c1, 'addUsingalias() translates to addAnd() when the table already has a condition on the column');
}
/**
* @api
*
* @param \Propel\Runtime\ActiveQuery\ModelCriteria $expandableQuery
* @param \Generated\Shared\Transfer\LocaleTransfer $locale
*
* @return $this
*/
public function joinProductQueryWithLocalizedAttributes(ModelCriteria $expandableQuery, LocaleTransfer $locale)
{
$expandableQuery->addJoin(SpyProductAbstractTableMap::COL_ID_PRODUCT_ABSTRACT, SpyProductAbstractLocalizedAttributesTableMap::COL_FK_PRODUCT_ABSTRACT, Criteria::INNER_JOIN);
$expandableQuery->addJoin(SpyProductAbstractLocalizedAttributesTableMap::COL_FK_LOCALE, SpyLocaleTableMap::COL_ID_LOCALE, Criteria::INNER_JOIN);
$expandableQuery->addAnd(SpyLocaleTableMap::COL_ID_LOCALE, $locale->getIdLocale(), Criteria::EQUAL);
$expandableQuery->addAnd(SpyLocaleTableMap::COL_IS_ACTIVE, true, Criteria::EQUAL);
$expandableQuery->addJoinObject((new Join(SpyProductAbstractTableMap::COL_ID_PRODUCT_ABSTRACT, SpyUrlTableMap::COL_FK_RESOURCE_PRODUCT_ABSTRACT, Criteria::LEFT_JOIN))->setRightTableAlias('product_urls'), 'productUrlsJoin');
$expandableQuery->addJoinCondition('productUrlsJoin', 'product_urls.fk_locale = ' . SpyLocaleTableMap::COL_ID_LOCALE);
$expandableQuery->addJoinObject(new Join(SpyProductTableMap::COL_ID_PRODUCT, SpyProductLocalizedAttributesTableMap::COL_FK_PRODUCT, Criteria::INNER_JOIN), 'productAttributesJoin');
$expandableQuery->addJoinCondition('productAttributesJoin', SpyProductLocalizedAttributesTableMap::COL_FK_LOCALE . ' = ' . SpyLocaleTableMap::COL_ID_LOCALE);
$expandableQuery->withColumn(SpyProductAbstractTableMap::COL_ID_PRODUCT_ABSTRACT, 'id_product_abstract');
$expandableQuery->withColumn(SpyProductAbstractTableMap::COL_ATTRIBUTES, 'abstract_attributes');
$expandableQuery->withColumn(SpyProductAbstractLocalizedAttributesTableMap::COL_ATTRIBUTES, 'abstract_localized_attributes');
$expandableQuery->withColumn("GROUP_CONCAT(spy_product.attributes SEPARATOR '\$%')", 'concrete_attributes');
$expandableQuery->withColumn("GROUP_CONCAT(spy_product_localized_attributes.attributes SEPARATOR '\$%')", 'concrete_localized_attributes');
$expandableQuery->withColumn('GROUP_CONCAT(product_urls.url)', 'product_urls');
$expandableQuery->withColumn(SpyProductAbstractLocalizedAttributesTableMap::COL_NAME, 'abstract_name');
$expandableQuery->withColumn('GROUP_CONCAT(spy_product_localized_attributes.name)', 'concrete_names');
return $this;
}
