/**
* Loads access restrictions onto the account object
* @global moodle_database $DB Moodle database controller
* @param TxttoolsAccount $txttoolsAccount Account to fill
* @return TxttoolsAccount Modified account object
* @version 2012042301
* @since 2011061701
*/
private function getAllowedUsersForAccount(TxttoolsAccount $txttoolsAccount)
{
global $DB;
$sql = 'SELECT u.id, u.username, u.firstname, u.lastname FROM {user} u
INNER JOIN {block_moodletxt_restrict} l
ON u.id = l.moodleuser
INNER JOIN {block_moodletxt_accounts} a
ON l.txttoolsaccount = a.id
WHERE a.id = :accountid';
$allowedUsers = $DB->get_records_sql($sql, array('accountid' => $txttoolsAccount->getId()));
foreach ($allowedUsers as $allowedUser) {
$txttoolsAccount->addAllowedUser(new MoodletxtBiteSizedUser($allowedUser->id, $allowedUser->username, $allowedUser->firstname, $allowedUser->lastname));
}
return $txttoolsAccount;
}
