public function getLastGroupPromptEmailSent(UserWatchesSiteModel $userWatchesSite, GroupModel $group)
{
global $DB;
$stat = $DB->prepare("SELECT MAX(sent_at) AS c FROM user_watches_site_group_prompt_email WHERE user_account_id=:user_account_id AND group_id=:group_id");
$stat->execute(array('user_account_id' => $userWatchesSite->getUserAccountId(), 'group_id' => $group->getId()));
$data = $stat->fetch();
return $data['c'] ? new \DateTime($data['c'], new \DateTimeZone("UTC")) : null;
}
public function fetchAll()
{
$this->buildStart();
$this->build();
$this->buildStat();
$results = array();
while ($data = $this->stat->fetch()) {
$uwsm = new UserWatchesSiteModel();
$uwsm->setFromDataBaseRow($data);
$results[] = $uwsm;
}
return $results;
}
