private static function newPriceNotification($stock, $purchaseDetail, $con)
{
// check price change
$priceDifference = $stock->getBuy() - $purchaseDetail->getTotalPrice() / $purchaseDetail->getAmount();
if ($priceDifference == 0) {
$priceStatus = 'stagnant';
} elseif ($priceDifference < 0) {
$priceStatus = 'up';
} elseif ($priceDifference > 0) {
$priceStatus = 'down';
}
// if price is not stagnant then make new notification
if ($priceStatus != 'stagnant') {
// build up notification data
$notificationData = new \stdClass();
$notificationData->stock_id = $stock->getId();
$notificationData->status = $priceStatus;
$notificationData->difference = abs($priceDifference);
$notificationData->to_price = $stock->getBuy() - $priceDifference;
// update stock buy price
$stock->setBuy($notificationData->to_price)->save($con);
// check whether price notification for this purchase detail is already there
$oldNotification = $purchaseDetail->getNotification();
if ($oldNotification) {
// if yes, assign the old one
$isNew = false;
$notification = $oldNotification;
} else {
// if not, create new notification
$isNew = true;
$notification = new Notification();
}
$notification->setTime(time())->setType('price')->setData(json_encode($notificationData))->save($con);
// if notification is new, then give notification to user
// if not, then update notification's status to unread
if ($isNew == true) {
// find which role to send notification
$roles = NotificationOptionQuery::create()->filterByType('price')->find($con);
// iterate through each role to find users assigned to it
foreach ($roles as $role) {
$users = UserQuery::create()->filterByStatus('Active')->filterByRoleId($role->getRoleId())->find($con);
// iterate through each user to give notification
foreach ($users as $user) {
$notifyUser = new NotificationOnUser();
$notifyUser->setUserId($user->getId())->setNotificationId($notification->getId())->save($con);
}
}
} else {
$notifyUsers = NotificationOnUserQuery::create()->filterByNotificationId($notification->getId())->find($con);
foreach ($notifyUsers as $notifyUser) {
$notifyUser->setStatus('Unread')->save($con);
}
}
$notificationId = $notification->getId();
} else {
$notificationId = 0;
}
return $notificationId;
}
/**
* Filter the query by a related \ORM\NotificationOnUser object
*
* @param \ORM\NotificationOnUser|ObjectCollection $notificationOnUser the related object to use as filter
* @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
*
* @return ChildUserQuery The current query, for fluid interface
*/
public function filterByNotification($notificationOnUser, $comparison = null)
{
if ($notificationOnUser instanceof \ORM\NotificationOnUser) {
return $this->addUsingAlias(UserTableMap::COL_ID, $notificationOnUser->getUserId(), $comparison);
} elseif ($notificationOnUser instanceof ObjectCollection) {
return $this->useNotificationQuery()->filterByPrimaryKeys($notificationOnUser->getPrimaryKeys())->endUse();
} else {
throw new PropelException('filterByNotification() only accepts arguments of type \\ORM\\NotificationOnUser or Collection');
}
}
/**
* @param ChildNotificationOnUser $onUser The ChildNotificationOnUser object to add.
*/
protected function doAddOnUser(ChildNotificationOnUser $onUser)
{
$this->collOnUsers[] = $onUser;
$onUser->setNotification($this);
}
/**
* @param ChildNotificationOnUser $notification The ChildNotificationOnUser object to add.
*/
protected function doAddNotification(ChildNotificationOnUser $notification)
{
$this->collNotifications[] = $notification;
$notification->setUser($this);
}