/**
* @service campaign read
*
* @param Gpf_Rpc_Params $params
*/
public function getPrivateAndManualCampaigns(Gpf_Rpc_Params $params) {
$selectBuilder = $this->getCampaignsSelect();
$selectBuilder->select->add(self::TYPE, 'type');
$selectBuilder->where->add(self::TYPE, 'IN', array(Pap_Db_Campaign::CAMPAIGN_TYPE_ON_INVITATION, Pap_Db_Campaign::CAMPAIGN_TYPE_PUBLIC_MANUAL));
$selectBuilder->orderBy->add(self::NAME);
$campaigns = $selectBuilder->getAllRows();
$cTable = Pap_Db_Table_Commissions::getInstance();
$rsCommissions = $cTable->getAllCommissionsInCampaign();
$campaigns->addColumn('commissions', '');
foreach ($campaigns as $campaign) {
$campaign->set('type', Pap_Common_Constants::getCampaignTypeAsText($campaign->get('type')));
if ($cTable->findCampaignInCommExistsRecords($campaign->get('id'), $rsCommissions)) {
$campaign->set('commissions', $cTable->getCommissionsDescription($campaign->get('id'), $rsCommissions));
}
}
return $campaigns;
}
