public function removeNotifications($user, $notificationType, $notificationDetails)
{
if ($notificationType === Notification::CONVERSATION_NOTIFICATION) {
$conversationId = $notificationDetails['conversation_id'];
$query = $this->qb->delete('NaidusvoeBundle:Notification', 'n')->where('n.userId=:uid')->setParameter('uid', $user->getId())->andWhere('n.conversationId=:convid')->setParameter('convid', $conversationId)->getQuery();
$query->execute();
}
}
/**
* {@inheritdoc}
*/
protected function configureQueryBuilder(QueryBuilder $queryBuilder)
{
$queryBuilder->delete();
}
/**
* Delete a record from a table
*
*
* Ex: array('user_id'=>'1','id_site'=>'12');
* Raw SQL: * WHERE user_id='1' AND id_site='12'
*
* @param string $table
* @param array $condition
* @return integer Of Affected rows
*/
public function delete($table, array $condition)
{
$qbDelete = new QueryBuilder($this->getEntityManager());
$alias = $this->_getNewAlias();
//create a delete query for the given entity
$qbDelete->delete($table, $alias);
$first = true;
foreach ($condition as $column => $value) {
//remove alias and prepend own one
$column = $this->_removeAlias($column);
$column = $alias . '.' . $column;
$this->_addCondition($qbDelete, $column, '=', $value);
}
$return = $qbDelete->getQuery()->execute();
return $return;
}
