本文整理汇总了PHP中Gpf_SqlBuilder_SelectBuilder::getAllRowsIndexedBy方法的典型用法代码示例。如果您正苦于以下问题:PHP Gpf_SqlBuilder_SelectBuilder::getAllRowsIndexedBy方法的具体用法?PHP Gpf_SqlBuilder_SelectBuilder::getAllRowsIndexedBy怎么用?PHP Gpf_SqlBuilder_SelectBuilder::getAllRowsIndexedBy使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Gpf_SqlBuilder_SelectBuilder
的用法示例。
在下文中一共展示了Gpf_SqlBuilder_SelectBuilder::getAllRowsIndexedBy方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: loadFullStatistics
/**
*
* @service banner_stats read
* @param $data
*/
public function loadFullStatistics(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->from->add(Pap_Db_Table_Banners::getName());
$select->select->add("COUNT(".Pap_Db_Table_Banners::ID.")", "count");
$select->select->add(Pap_Db_Table_Banners::TYPE, 'type');
$select->groupBy->add(Pap_Db_Table_Banners::TYPE);
Gpf_Plugins_Engine::extensionPoint('AffiliateNetwork.modifyWhere',
new Gpf_Common_SelectBuilderCompoundRecord($select, new Gpf_Data_Record(array(), array())));
$result = $select->getAllRowsIndexedBy('type');
$bannerTypes = explode(',', $data->getParam('bannerTypes'));
$bannersCount = 0;
foreach ($bannerTypes as $bannerType) {
$bannerTypeCount = 0;
try {
$bannerTypeCount = $result->getRecord($bannerType)->get('count');
} catch (Gpf_Data_RecordSetNoRowException $e) {
}
$data->setValue($bannerType, "$bannerTypeCount");
$bannersCount += $bannerTypeCount;
}
$data->setValue("bannersCount", "$bannersCount");
return $data;
}
示例2: loadAttributes
public function loadAttributes($userId)
{
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add(self::NAME);
$select->select->add(self::VALUE);
$select->from->add(self::getName(), 'ua');
$select->where->add(self::ACCOUNT_USER_ID, '=', $userId);
$this->attributes = $select->getAllRowsIndexedBy('name');
}
示例3: getActiveLanguagesNoRpc
/**
* Get recordset of active languages in this account
*
* @return Gpf_Data_IndexedRecordSet
*/
public function getActiveLanguagesNoRpc()
{
$sql = new Gpf_SqlBuilder_SelectBuilder();
$sql->select->add(Gpf_Db_Table_Languages::CODE);
$sql->select->add(Gpf_Db_Table_Languages::ENGLISH_NAME);
$sql->select->add(Gpf_Db_Table_Languages::NAME);
$sql->select->add(Gpf_Db_Table_Languages::IS_DEFAULT);
$sql->from->add(Gpf_Db_Table_Languages::getName());
$sql->where->add(Gpf_Db_Table_Accounts::ID, '=', Gpf_Application::getInstance()->getAccountId());
$sql->where->add(Gpf_Db_Table_Languages::ACTIVE, '=', Gpf::YES);
$sql->orderBy->add(Gpf_Db_Table_Languages::NAME);
return $sql->getAllRowsIndexedBy(Gpf_Db_Table_Languages::CODE);
}