I use SonataAdminBundle. My goal is to manage my articles and so allow administrators to create through the admin interface.
Here's how the relationship is defined in my User class.
So I have to use:
/**
* @var articles
*
* Here we will set the OneToMany relationship (Many: One - article : user)
* @ORM\OneToMany(targetEntity="Kark\RecetteBundle\Entity\Article", mappedBy="user", cascade={"persist", "remove"})
*/
protected $articles;
public function __construct()
{
//Une classe à pour instrctruction dans sont constructeur, le constructeur du parent
parent::__construct();
$this->articles = new \Doctrine\Common\Collections\ArrayCollection();
}
/**
* Get articles
*
* @return ArrayCollection
*/
public function getArticles()
{
return
$articles;
}
/**
*
* @param $unArticle
*/
public function addArticle(\Kark\RecetteBundle\Entity\Article $unArticle)
{
$this->articles[] = $unArticle;
$unArticle->setUser($this);
}
And here in my class Article:
/**
* @ORM\ManyToOne(targetEntity="Kark\UserBundle\Entity\User", inversedBy="articles")
*/
private $user;
/**
* Set user
*
* @param User
* @return article
*/
public function setUser(\Kark\UserBundle\Entity\User $unUser)
{
$this->user = $unUser;
return $this;
}
/**
* Get user
*
* @return User
*/
public function getUser()
{
return $this->user;
}
In my SonataAdminBundle I then defined the constroller CRUD two entities User and Article:
namespace Kark\AdminBundle\Controller;
use Sonata\AdminBundle\Controller\CRUDController as Controller;
class ArticleAdminController extends Controller
{
}
Here is the CRUD User:
<?php
namespace Kark\AdminBundle\Controller;
use Sonata\AdminBundle\Controller\CRUDController as Controller;
class UserAdminController extends Controller
{
}
and their configurations in admin.cfg:
# Kark/AdminBundle/Resources/config/admin.yml
services:
kark.admin.admin.article:
class: Kark\AdminBundle\Admin\ArticleAdmin
tags:
- { name: sonata.admin, manager_type: orm, group: Article, label: articles }
arguments:
- ~
- Kark\RecetteBundle\Entity\Article
- KarkAdminBundle:ArticleAdmin
Here's the part for the User entity:
kark.admin.admin.userarticle:
class: Kark\AdminBundle\Admin\UserAdmin
tags:
- { name: sonata.admin, manager_type: orm, group: user, label: users }
arguments:
- ~
- Kark\UserBundle\Entity\User
- KarkAdminBundle:UserAdmin
Everything is set up, and I have the following definition in my class Admin of my Article:
<?php
namespace Kark\AdminBundle\Admin;
use Sonata\AdminBundle\Admin\Admin;
use Sonata\AdminBundle\Form\FormMapper;
use Sonata\AdminBundle\Datagrid\DatagridMapper;
use Sonata\AdminBundle\Datagrid\ListMapper;
use Sonata\AdminBundle\Show\ShowMapper;
use Kark\RecetteBundle\Entity\Article;
use Kark\RecetteBundle\Entity\ImageArticle;
use Knp\Menu\ItemInterface as MenuItemInterface;
class ArticleAdmin extends Admin
{
// setup the default sort column and order
protected $datagridValues = array(
'_sort_order' => 'ASC',
'_sort_by' => 'name'
);
// L'ensemble des champs qui seront montrer lors de la création ou de la modification d'une entité
protected function configureFormFields(FormMapper $formMapper)
{
$formMapper
->with('General')
->add('titre', 'text')
->add('imageArticle', 'sonata_type_admin', array('delete' => false), array('required' => true, 'edit' => 'inline'))
->add('contenu','textarea');
}
/**
*
* Fonction qui va permettre d'afficher les différent filtres de recherche dans notre tableau
* de notre interface.
*
*/
protected function configureDatagridFilters(DatagridMapper $datagridMapper)
{
$datagridMapper
->add('titre')
->add('user.username')
;
}
/**
* Fonction qui redéfini celle de la classe mère Admin. Cette fonction va nous permettre de préciser les
* champs qui seront affiché dans notre tableau lorsque l'on listera nos entités
*/
protected function configureListFields(ListMapper $listMapper)
{
$listMapper
->addIdentifier('titre')
->add('date', null, array('route' => array('name' => 'show')))
->add('contenu')
->add('user.username')
->add('_action', 'actions', array(
'actions' => array(
'show' => array(),
'edit' => array(),
'delete' => array()
)
))
;
}
/**
* Fonction qui redéfinie la fonction de la classe mère qui permet d'indiquer les champs qui seront affiché
* lorsque l'on consultera un article
*/
protected function configureShowFields(ShowMapper $showMapper)
{
$showMapper
->add('date')
->add('titre')
->add('contenu')
->add('imageArticle.getWebPath()', 'string', array('template' => 'KarkAdminBundle:ArticleAdmin:list_image.html.twig'))
->add('user.username')
;
}
/**
* {@inheritdoc}
*/
public function prePersist($object)
{
$user = $this->getConfigurationPool()->getContainer()->get('security.context')->getToken()->getUser();
$user->addArticle($object);
}
/**
* {@inheritdoc}
*/
public function preUpdate($object)
{
$user = $this->getConfigurationPool()->getContainer()->get('security.context')->getToken()->getUser();
$user->addArticle($object);
}
}
However, the article does not insert because it performs INSERT and UPDATE, and in table 'article_audit it performs the same insert twice, and so there is a primary key dupliquata ...
[3/4] UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO article_audit (rev, revtype, imageArticle_id, user_id, id, date, titre, contenu, publication, dateEdition, slugTitre) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["545", "UPD", 43, 1, 43, "2014-06-16 23:28:40", "qsmodjqskdjqslkdqjsk", "<p>qsldkqsmldkqslmdkqsmdlqslk lmqskdmlqskdqsmld qskdjqslkdqjsldqksd<\/p>", 0, "2014-06-16 23:28:40", "qsmodjqskdjqslkdqjsk"]:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '43-545' for key 'PRIMARY'
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '43-545' for key 'PRIMARY'
Here is the log file:
DEBUG - INSERT INTO article (date, titre, contenu, publication, dateEdition, slugTitre, imageArticle_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - INSERT INTO article_audit (rev, revtype, imageArticle_id, user_id, id, date, titre, contenu, publication, dateEdition, slugTitre) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - UPDATE article SET date = ?, titre = ?, contenu = ?, publication = ?, dateEdition = ?, slugTitre = ?, imageArticle_id = ?, user_id = ? WHERE id = ?
DEBUG - INSERT INTO article_audit (rev, revtype, imageArticle_id, user_id, id, date, titre, contenu, publication, dateEdition, slugTitre) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
DEBUG - "ROLLBACK"
CRITICAL - Uncaught PHP Exception Sonata\AdminBundle\Exception\ModelManagerException: "Failed to create object: Kark\RecetteBundle\Entity\Article" at /var/www/recette-etudiant/vendor/sonata-project/doctrine-orm-admin-bundle/Model/ModelManager.php line 142
UPDATE -
I try to insert the traditional way, that is to say with an action in my ArticleController which reads:
public function ajouterNewsAction($_local) { // The whole creation will be through this form $monArticle = new Article();
// We create our form using an external class
$monFormulaire = $this->createForm(new ArticleType, $monArticle);
// Query is recovered
$request = $this->get('request');
// When sending a form, it is realized through transfer data from page to page via a method
//called POST. So we'll check when calling this function if this method is effective, if the case is
//data that have been transmitted via a data form.
if($this->get('request')->getMethod() == 'POST')
{
// Process the data here we will moisturize our form with what was before retrieving values
// my $ _POST superglobal via a rather fast function
$monFormulaire->bind($request);
// Check that the values entered are correct. Validation objects is via annotation
// Constraints our class Validator aliased via our @ Assert.
if($monFormulaire->isValid())
{
// If the item is actually add is that everything is good then created a Tag
$this->get('session')->getFlashBag()->add('AjoutRealise', 'L\'article a été rajouté avec succès');
// Get the current utilistaeur
$user = $this->getUser();
// We persist then our body hydrated by Form
$entity_manager = $this->getDoctrine()->getManager();
// Get the service management of user FOSUserBundle
$userManager = $this->get('fos_user.user_manager');
//We add a user to our article
$user->addArticle($monArticle);
$userManager->updateUser($user);
$entity_manager->flush();
//We redirect to the page display section
return $this->redirect($this->generateUrl('karkrecette_voir_article', array("id" => $monArticle->getId(), "slugTitre" => $monArticle->getSlugTitre() )));
}
}
// If we're not in the presence of a méthde get is that the form is not sent, then it is blank
//Otherwise it is possible that the form is not valid, it displays the form hydrating value previously entered
return $this->render('KarkRecetteBundle:Article:ajouter.html.twig', array("form" => $monFormulaire->createView(), "langue" => $_local));
}
If i delete in the admin.yml the service defined for my administration of my Article class, their is no problem because the SonataAdmin is not fired. But i really NEED to administrate my Article object.
Thanks.
