/** * @return int */ public function delete(User $user, Post $post) { $conn = $this->_em->getConnection(); $statement = $conn->prepare('DELETE FROM post_vote WHERE user_id = :user_id AND post_id = :post_id'); $statement->bindValue('user_id', $user->getId()); $statement->bindValue('post_id', $post->getId()); return $statement->execute(); }
protected function upload(Post $entity) { if (null === $entity->getFile()) { return; } // check if we have an old image if (null !== $entity->getTemp()) { // delete the old image unlink($entity->getTemp()); // clear the temp image path $entity->setTemp(null); } $entity->getFile()->move($entity->getUploadRootDir() . '/' . $entity->getId(), $entity->getImageName() . '.' . $entity->getFile()->guessExtension()); $entity->setFile(null); }
/** * Creates a form to delete a Post entity by id. * * This is necessary because browsers don't support HTTP methods different * from GET and POST. Since the controller that removes the blog posts expects * a DELETE method, the trick is to create a simple form that *fakes* the * HTTP DELETE method. * See http://symfony.com/doc/current/cookbook/routing/method_parameters.html. * * @param Post $post The post object * * @return \Symfony\Component\Form\Form The form */ private function createDeleteForm(Post $post) { return $this->createFormBuilder()->setAction($this->generateUrl('super_admin_post_delete', array('id' => $post->getId())))->setMethod('DELETE')->getForm(); }
public function createPostDeleteForm(Post $post) { //$builder = $this->formFactory->createBuilder(); $form = $this->builder->setAction($this->router->generate('remove_post', array('id' => $post->getId())))->setMethod('DELETE')->add('submit', SubmitType::class, ['label' => ' ', 'attr' => ['class' => 'glyphicon glyphicon-trash btn-link']])->getForm(); return $form; }
public function updateTotalVotes(Post $post) { $conn = $this->getEntityManager()->getConnection(); $sql = ' UPDATE post LEFT JOIN ( SELECT post_id, COUNT(*) AS total FROM post_vote WHERE post_id = :post_id_1 ) AS upvote ON upvote.post_id = post.id SET upvote_total = upvote.total WHERE post.id = :post_id_2 '; $statement = $conn->prepare($sql); if ($post->getId()) { $statement->bindValue('post_id_1', $post->getId()); $statement->bindValue('post_id_2', $post->getId()); } return $statement->execute(); }
/** * Creates a form to delete a Post entity. * * @param Post $post The Post entity * * @return \Symfony\Component\Form\Form The form */ private function createDeleteForm(Post $post) { return $this->createFormBuilder()->setAction($this->generateUrl('admin_post_delete', array('id' => $post->getId())))->setMethod('DELETE')->add('submit', SubmitType::class, ['label' => ' ', 'attr' => ['class' => 'btn btn-xs btn-danger ace-icon fa fa-trash-o bigger-120']])->getForm(); }
/** * Creates a form to delete a Post entity. * * @param Post $post The Post entity * * @return \Symfony\Component\Form\Form The form */ private function createDeleteForm(Post $post) { return $this->createFormBuilder()->setAction($this->generateUrl('cabinet_post_delete', array('id' => $post->getId())))->setMethod('DELETE')->add('submit', SubmitType::class, ['label' => ' ', 'attr' => ['class' => 'glyphicon glyphicon-trash btn-link']])->getForm(); }
/** * @return int|null * * @Serializer\VirtualProperty() */ public function getPostId() { return null !== $this->post ? $this->post->getId() : null; }
/** * {@inheritDoc} */ public function getId() { if ($this->__isInitialized__ === false) { return (int) parent::getId(); } $this->__initializer__ && $this->__initializer__->__invoke($this, 'getId', array()); return parent::getId(); }
/** * Creates a form to delete a Post entity. * * @param Post $post The Post entity * * @return \Symfony\Component\Form\Form The form */ private function createDeleteForm(Post $post) { return $this->createFormBuilder()->setAction($this->generateUrl('_delete', array('id' => $post->getId())))->setMethod('DELETE')->getForm(); return json_encode($post->getId()); //for json }