/**
* get admins email
*
* @return array
*
* @author Dimitri Lameri <*****@*****.**>
*/
private function _getAdminsMail()
{
$ArAdmins = array();
$DB = new DBHandler();
$StSQL = '
SELECT
US.StEmail AS StEmail
FROM
' . DBPREFIX . 'User US
LEFT JOIN ' . DBPREFIX . 'Supporter S ON (US.IDUser = S.IDUser)
LEFT JOIN ' . DBPREFIX . 'Unit UN ON (UN.IDUnit = S.IDUnit)
WHERE
UN.BoMailError = true';
$DB->execSQL($StSQL);
$Admins = $DB->getResult('string');
foreach ((array) $Admins as $Admin) {
$ArAdmins[] = $Admin['StEmail'];
}
return $ArAdmins;
}
/**
* get user data, handling importation, after being included
*
* @param int $IDUser
*/
public function getUserData($IDUser)
{
global $UserFields;
$UserDB = new DBHandler(true);
$StFields = implode(', ', $UserFields);
if (ISEXTERNAL == 0) {
$StSQL = "\nSELECT\n {$StFields}\nFROM\n " . DBPREFIX . "User\nWHERE\n IDUser = '******'";
$UserDB->execSQL($StSQL);
$ArUser = $UserDB->getResult("string");
} else {
$StSQL = "\nSELECT\n IDExternalUser\nFROM\n " . DBPREFIX . "User\nWHERE\n IDUser = '******'";
$UserDB->execSQL($StSQL);
$ArExternalUser = $UserDB->getResult("string");
$IDExternalUser = $ArExternalUser[0]['IDExternalUser'];
$StSQL = "\nSELECT\n {$StFields}\nFROM\n " . USERDBTABLE . "\nWHERE\n {$UserFields['IDExternalUser']} = '{$IDExternalUser}'";
$UserDB->execSQL($StSQL);
$ArUser = $UserDB->getResult("string");
}
if (count($ArUser) <= 0) {
throw new ErrorHandler(EXC_USER_WRONGUSER);
}
return $ArUser[0];
}
