本文整理匯總了PHP中PaginatedList::dataQuery方法的典型用法代碼示例。如果您正苦於以下問題：PHP PaginatedList::dataQuery方法的具體用法？PHP PaginatedList::dataQuery怎麽用？PHP PaginatedList::dataQuery使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類PaginatedList的用法示例。
在下文中一共展示了PaginatedList::dataQuery方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: buildAllAttributeFacets
/**
* Builds facets from all attributes present in the data set.
* @param DataList|PaginatedList $matches
* @return array
*/
protected function buildAllAttributeFacets($matches)
{
$q = $matches instanceof PaginatedList ? $matches->getList()->dataQuery()->query() : $matches->dataQuery()->query();
// this is the easiest way to get SiteTree vs SiteTree_Live
$baseTable = $q->getFrom();
if (is_array($baseTable)) {
$baseTable = reset($baseTable);
}
$q = $q->setSelect(array())->selectField('"ProductAttributeType"."ID"', 'TypeID')->selectField('"ProductAttributeType"."Label"', 'TypeLabel')->selectField('"ProductAttributeValue"."ID"', 'Value')->selectField('"ProductAttributeValue"."Value"', 'Label')->selectField('count(distinct ' . $baseTable . '."ID")', 'Count')->selectField('"ProductAttributeValue"."Sort"')->addInnerJoin('Product_StaticAttributeTypes', $baseTable . '."ID" = "Product_StaticAttributeTypes"."ProductID"')->addInnerJoin('ProductAttributeType', '"Product_StaticAttributeTypes"."ProductAttributeTypeID" = "ProductAttributeType"."ID"')->addInnerJoin('Product_StaticAttributeValues', $baseTable . '."ID" = "Product_StaticAttributeValues"."ProductID"')->addInnerJoin('ProductAttributeValue', '"Product_StaticAttributeValues"."ProductAttributeValueID" = "ProductAttributeValue"."ID"' . ' AND "ProductAttributeValue"."TypeID" = "ProductAttributeType"."ID"')->setOrderBy(array('"ProductAttributeType"."Label"' => 'ASC', '"ProductAttributeValue"."Sort"' => 'ASC'))->setGroupBy(array('"ProductAttributeValue"."ID"', '"ProductAttributeType"."ID"'))->execute();
$curType = 0;
$facets = array();
$curFacet = null;
foreach ($q as $row) {
if ($curType != $row['TypeID']) {
if ($curType > 0) {
$facets['ATT' . $curType] = $curFacet;
}
$curType = $row['TypeID'];
$curFacet = array('Label' => $row['TypeLabel'], 'Source' => 'ATT' . $curType, 'Type' => ShopSearch::FACET_TYPE_LINK, 'Values' => array());
}
unset($row['TypeID']);
unset($row['TypeLabel']);
$curFacet['Values'][$row['Value']] = new ArrayData($row);
}
if ($curType > 0) {
$facets['ATT' . $curType] = $curFacet;
}
return $facets;
}