| public addTo ( Gpf_SqlBuilder_WhereClause $whereClause ) | ||
| $whereClause | Gpf_SqlBuilder_WhereClause | |
private function getSubaffiliatesCounts($ids) {
$results = array();
$condition = '';
$rs = new Gpf_Data_RecordSet();
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('count(u.'.Pap_Db_Table_Users::ID.')', 'count');
$selectBuilder->select->add('u.'.Pap_Db_Table_Users::PARENTUSERID, Pap_Db_Table_Users::PARENTUSERID);
$selectBuilder->from->add(Pap_Db_Table_Users::getName(), 'u');
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(), 'gu', 'u.'.Pap_Db_Table_Users::ACCOUNTUSERID.' = gu.'.Gpf_Db_Table_Users::ID);
$selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(), 'au', 'gu.'.Gpf_Db_Table_Users::AUTHID .' = au.'.Gpf_Db_Table_AuthUsers::ID);
$selectBuilder->where->add('u.'.Pap_Db_Table_Users::PARENTUSERID, 'in', $ids);
$selectBuilder->where->add('u.'.Pap_Db_Table_Users::DELETED, '=', Gpf::NO);
$selectBuilder->where->add('gu.'.Gpf_Db_Table_Users::STATUS, 'in', array(Gpf_Db_User::APPROVED, Gpf_Db_User::PENDING));
$this->filterCollection->addTo($selectBuilder->where);
$selectBuilder->groupBy->add('u.'.Pap_Db_Table_Users::PARENTUSERID);
$rs->load($selectBuilder);
foreach($rs as $record) {
$results[$record->get(Pap_Db_Table_Users::PARENTUSERID)] = $record->get('count');
}
return $results;
}
private function getPaidData(Gpf_Rpc_FilterCollection $filters) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->add("SUM(amount)", "paid");
$select->from->add(Pap_Db_Table_Payouts::getName(), "p");
$select->from->addInnerJoin(Pap_Db_Table_PayoutsHistory::getName(), "ph", "p.payouthistoryid = ph.payouthistoryid");
$filters->addTo($select->where);
Gpf_Plugins_Engine::extensionPoint('AffiliateNetwork.modifyWhere',
new Gpf_Common_SelectBuilderCompoundRecord($select, new Gpf_Data_Record(array('columnPrefix'), array('ph'))));
$row = $select->getOneRow();
return $this->checkNullValue($row->get("paid"));
}
