/**
* @param Gpf_Auth_Info $authInfo
* @return Gpf_SqlBuilder_SelectBuilder
*/
protected function createAuthSelect(Gpf_Auth_Info $authInfo)
{
$select = parent::createAuthSelect($authInfo);
$select->select->add('pu.' . Pap_Db_Table_Users::REFID, 'refid');
$select->select->add('pu.' . Pap_Db_Table_Users::NUMBERUSERID, 'numberuserid');
$select->select->add('pu.' . Pap_Db_Table_Users::PHOTO, 'photo');
for ($i = 1; $i <= 25; $i++) {
$select->select->add('pu.' . Pap_Db_Table_Users::getDataColumnName($i), 'data' . $i);
}
$select->select->add('pu.' . Pap_Db_Table_Users::PARENTUSERID, Pap_Db_Table_Users::PARENTUSERID);
$select->select->add('pu.' . Pap_Db_Table_Users::ID, 'userid');
$select->select->add('pu.' . Pap_Db_Table_Users::TYPE, 'rtype');
$select->select->add('pu.' . Pap_Db_Table_Users::DATEINSERTED, 'dateinserted');
$select->select->add('pu.' . Pap_Db_Table_Users::DATEAPPROVED, 'dateapproved');
$select->from->addInnerJoin(Pap_Db_Table_Users::getName(), 'pu', 'pu.accountuserid=u.accountuserid');
$select->where->add('pu.' . Pap_Db_Table_Users::TYPE, '=', $authInfo->getRoleType());
return $select;
}
/**
* @service pay_affiliate read
* @param $fields
* @throws Gpf_Exception
*/
public function payeesDetails(Gpf_Rpc_Params $params) {
$data = new Gpf_Rpc_Data($params);
$idFilter = $data->getFilters()->getFilter('id');
if (sizeof($data) != 1) {
throw new Gpf_Exception('No id specified');
}
$id = $idFilter[0]->getValue();
$payeeData = $this->getPayeeData(array($id));
$i = 0;
foreach($payeeData as $id => $payee) {
foreach($payee['users'] as $user) {
$payeeDataObject = new Gpf_Rpc_Data();
$payeeDataObject->setValue(Gpf_Db_Table_AuthUsers::USERNAME, $user[Gpf_Db_Table_AuthUsers::USERNAME]);
$payeeDataObject->setValue(Gpf_Db_Table_AuthUsers::FIRSTNAME, $user[Gpf_Db_Table_AuthUsers::FIRSTNAME]);
$payeeDataObject->setValue(Gpf_Db_Table_AuthUsers::LASTNAME, $user[Gpf_Db_Table_AuthUsers::LASTNAME]);
$payeeDataObject->setValue(Pap_Db_Table_Payouts::AMOUNT, $user[Pap_Db_Table_Payouts::AMOUNT]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(3), $user[Pap_Db_Table_Users::getDataColumnName(3)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(4), $user[Pap_Db_Table_Users::getDataColumnName(4)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(5), $user[Pap_Db_Table_Users::getDataColumnName(5)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(6), $user[Pap_Db_Table_Users::getDataColumnName(6)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(7), $user[Pap_Db_Table_Users::getDataColumnName(7)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(8), $user[Pap_Db_Table_Users::getDataColumnName(8)]);
$payeeDataObject->setValue(Pap_Db_Table_Users::getDataColumnName(9), $user[Pap_Db_Table_Users::getDataColumnName(9)]);
$data->setValue("user$i", $payeeDataObject->toObject());
$i++;
}
}
return $data;
}
