/**
* @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;
}
