本文整理汇总了PHP中ActiveRecordModel::createSelectQuery方法的典型用法代码示例。如果您正苦于以下问题:PHP ActiveRecordModel::createSelectQuery方法的具体用法?PHP ActiveRecordModel::createSelectQuery怎么用?PHP ActiveRecordModel::createSelectQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ActiveRecordModel
的用法示例。
在下文中一共展示了ActiveRecordModel::createSelectQuery方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getCountByFilterSubSet
private function getCountByFilterSubSet($filters, $includeAppliedFilters)
{
$selectFilter = $this->productFilter->getSelectFilter(!$includeAppliedFilters);
$selectFilter->removeFieldList();
$selectFilter->setLimit(0);
foreach ($filters as $filter) {
$filter->defineJoin($selectFilter);
$cond = $filter->getCondition();
if (!is_object($cond)) {
continue;
}
$expression = 'SUM(' . $cond->getExpressionHandle()->toString() . ')';
$selectFilter->addField($expression, null, 'cnt_' . $filter->getID());
}
$query = ActiveRecordModel::createSelectQuery('Product');
$query->joinTable('Category', 'Product', 'ID', 'categoryID');
$query->removeFieldList();
$query->getFilter()->merge($selectFilter);
$res = ActiveRecordModel::fetchDataFromDB($query);
$res = $res[0];
$ret = array();
foreach ($res as $key => $value) {
$ret[substr($key, 4)] = $value;
}
return $ret;
}