/**
* @param ilTermsOfServiceAcceptanceEntity $entity
* @return ilTermsOfServiceAcceptanceEntity
*/
public function loadCurrentAcceptanceOfUser(ilTermsOfServiceAcceptanceEntity $entity)
{
$this->db->setLimit(1, 0);
$res = $this->db->queryF('
SELECT tos_versions.*, tos_acceptance_track.ts accepted_ts
FROM tos_acceptance_track
INNER JOIN tos_versions ON id = tosv_id
WHERE usr_id = %s
ORDER BY tos_acceptance_track.ts DESC
', array('integer'), array($entity->getUserId()));
$row = $this->db->fetchAssoc($res);
$entity->setId($row['id']);
$entity->setUserId($row['usr_id']);
$entity->setIso2LanguageCode($row['lng']);
$entity->setSource($row['src']);
$entity->setSourceType($row['src_type']);
$entity->setText($row['text']);
$entity->setTimestamp($row['accepted_ts']);
$entity->setHash($row['hash']);
return $entity;
}
/**
*
*/
public function testAcceptanceHistoryOfAUserIsDeleted()
{
$entity = new ilTermsOfServiceAcceptanceEntity();
$entity->setUserId(4711);
$database = $this->getMockBuilder('ilDB')->disableOriginalConstructor()->getMock();
$database->expects($this->once())->method('quote')->with($entity->getUserId(), 'integer')->will($this->returnValue($entity->getUserId()));
$database->expects($this->once())->method('manipulate')->with('DELETE FROM tos_acceptance_track WHERE usr_id = ' . $entity->getUserId());
$gateway = new ilTermsOfServiceAcceptanceDatabaseGateway($database);
$gateway->deleteAcceptanceHistoryByUser($entity);
}
/**
*
*/
public function testEntityShouldReturnUserIdWhenUserIdIsSet()
{
$expected = 1337;
$entity = new ilTermsOfServiceAcceptanceEntity();
$entity->setUserId($expected);
$this->assertEquals($expected, $entity->getUserId());
}
