本文整理匯總了PHP中Propel\Runtime\ActiveQuery\ModelCriteria::addJoinCondition方法的典型用法代碼示例。如果您正苦於以下問題：PHP ModelCriteria::addJoinCondition方法的具體用法？PHP ModelCriteria::addJoinCondition怎麽用？PHP ModelCriteria::addJoinCondition使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Propel\Runtime\ActiveQuery\ModelCriteria的用法示例。
在下文中一共展示了ModelCriteria::addJoinCondition方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: testAddJoinConditionOperator
public function testAddJoinConditionOperator()
{
$con = Propel::getServiceContainer()->getConnection(BookTableMap::DATABASE_NAME);
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c->join('Propel\\Tests\\Bookstore\\Book.Author', Criteria::INNER_JOIN);
$c->addJoinCondition('Author', 'Propel\\Tests\\Bookstore\\Book.Title IS NOT NULL', null, Criteria::LOGICAL_OR);
$books = BookQuery::create(null, $c)->find($con);
$expectedSQL = $this->getSql("SELECT book.id, book.title, book.isbn, book.price, book.publisher_id, book.author_id FROM book INNER JOIN author ON (book.author_id=author.id OR book.title IS NOT NULL)");
$this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'addJoinCondition() allows the use of custom conditions with a custom operator');
}示例2: joinRelatedCategoryQueryWithUrls
/**
* @api
*
* @param \Propel\Runtime\ActiveQuery\ModelCriteria $expandableQuery
* @param string $relationTableAlias
* @param string $fieldIdentifier
*
* @return \Propel\Runtime\ActiveQuery\ModelCriteria
*/
public function joinRelatedCategoryQueryWithUrls(ModelCriteria $expandableQuery, $relationTableAlias, $fieldIdentifier)
{
$expandableQuery->addJoinObject((new Join($relationTableAlias . '.id_category_node', SpyUrlTableMap::COL_FK_RESOURCE_CATEGORYNODE, Criteria::LEFT_JOIN))->setRightTableAlias($relationTableAlias . 'Urls'), $relationTableAlias . 'UrlJoin');
$expandableQuery->addJoinCondition($relationTableAlias . 'UrlJoin', $relationTableAlias . 'Urls.fk_locale = ' . SpyLocaleTableMap::COL_ID_LOCALE);
$expandableQuery->withColumn('GROUP_CONCAT(' . $relationTableAlias . 'Urls.url)', 'category_' . $fieldIdentifier . '_urls');
return $expandableQuery;
}示例3: joinProductQueryWithLocalizedAttributes
/**
* @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;
}