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