public static function addToHotList($params = array())
{
$posting_id = $params[0];
$member_id = $params[1];
$q = HotListTable::getInstance()->createQuery('h');
$q->where('posting_id = ?', $posting_id);
$q->andWhere('member_id = ?', $member_id);
if ($q->execute()->count() > 0) {
return array('Already added in your Hot list.', false);
} else {
$hotlist = new HotList();
$hotlist->setMemberId($member_id);
$hotlist->setPostingId($posting_id);
try {
$hotlist->save();
return array('This posting has been added to your HOT List', true);
} catch (Exception $e) {
return array('Unable to process request. Please try again later!', false);
}
}
}
public function executeSaveChanges(sfWebRequest $request)
{
try {
$q = Postings::getPostingInfo($_REQUEST['posting_id']);
$q->gender_type = $_REQUEST['gender_type'];
$q->date_to_hangout = date("Y-m-d", strtotime($_REQUEST['startdt_hangout']));
$q->num_ppl = $_REQUEST['num_ppl'];
$q->posting_enddt = $this->calculatePostingEndDate($_REQUEST['posting_enddt'], $_REQUEST['starttime'], $_REQUEST['startdt_hangout']);
$q->age_range_1 = $_REQUEST['age_range_1'];
$q->age_range_2 = $_REQUEST['age_range_2'];
$q->starttime = $_REQUEST['starttime'];
$q->endtime = $_REQUEST['endtime'];
$q->posting_title = $_REQUEST['posting_title'];
$q->posting_desc = $_REQUEST['posting_desc'];
$q->enddate_hangout = date("Y-m-d", strtotime($_REQUEST['enddt_hangout']));
$q->save();
$hotlistMembers = HotList::getHotListMembers($_REQUEST['posting_id'], $_SESSION['userId']);
$Member = new Member();
$Member->setId($_SESSION['userId']);
$nick_name = $Member->getMemberInfo('nick_name');
foreach ($hotlistMembers as $v) {
$body = '
<div style="font-family:tahoma;font-size:12px;">
Hi <b>' . $v->getMember()->getNickName() . '</b>,
<br/><br/>
<p>
<b> ' . $nick_name . ' </b> has made some changes on a post with title "<b>' . $v->getPostings()->getPostingTitle() . '</b>".
</p>
<br/>
Thank you
<br/>
</div>';
CustomHangout::email($v->getMember()->getEmail(), $body, 'HangOutToday', 'HangOutToday Notification');
}
die(true);
} catch (Exception $e) {
die(false);
}
}
public function executeDeleteHotList(sfWebRequest $request)
{
$hotlist_id = $request->getParameter('id');
die(HotList::deleteHotList($hotlist_id));
}
