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; }