php - query - symfony2 Catchable Fatal Error: Objeto de clase no se puede convertir a cadena

symfony 3.4 doctrine query

Question

Tengo esta Entidad definida:

<?php

namespace Apw/BlackbullBundle/Entity;

use Doctrine/Common/Collections/ArrayCollection;
use Doctrine/ORM/Mapping as ORM;

/**
* Categories
*
* @ORM/Table()
*    @ORM/Entity(repositoryClass="Apw/BlackbullBundle/Entity/CategoriesRepository")
*/
class Categories
{
/**
 * @var integer
 *
 * @ORM/Column(name="id", type="integer")
 * @ORM/Id
 * @ORM/GeneratedValue(strategy="AUTO")
 */
private $id;

/**
 * @var string
 *
 * @ORM/Column(name="categories_image", type="string", length=64, nullable = true)
 */
private $categoriesImage;

/**
 * @var integer
 *
 * @ORM/Column(name="parent_id", type="integer", nullable = true, options={"default":0})
 */
private $parentId;

/**
 * @var integer
 *
 * @ORM/Column(name="sort_order", type="integer", nullable = true, options={"default":0})
 */
private $sortOrder;

/**
 * @var /DateTime
 *
 * @ORM/Column(name="date_added", type="datetime", nullable = true)
 */
private $dateAdded;

/**
 * @var /DateTime
 *
 * @ORM/Column(name="last_modified", type="datetime", nullable = true)
 */
private $lastModified;

/**
 * @var boolean
 *
 * @ORM/Column(name="categories_status", type="boolean", nullable = true, options={"default" = 1})
 */
private $categoriesStatus;

/**
 * @ORM/OneToMany(targetEntity="CategoriesDescription", mappedBy="category", cascade={"persist", "remove"})
 */
private $categoryDescription;

/**
 * @ORM/ManyToMany(targetEntity="Products", mappedBy="categories")
 **/
private $products;

/**
 * Get id
 *
 * @return integer
 */
public function getId()
{
    return $this->id;
}

/**
 * Set categoriesImage
 *
 * @param string $categoriesImage
 * @return Categories
 */
public function setCategoriesImage($categoriesImage)
{
    $this->categoriesImage = $categoriesImage;

    return $this;
}

/**
 * Get categoriesImage
 *
 * @return string
 */
public function getCategoriesImage()
{
    return $this->categoriesImage;
}

/**
 * Set parentId
 *
 * @param integer $parentId
 * @return Categories
 */
public function setParentId($parentId)
{
    $this->parentId = $parentId;

    return $this;
}

/**
 * Get parentId
 *
 * @return integer
 */
public function getParentId()
{
    return $this->parentId;
}

/**
 * Set sortOrder
 *
 * @param string $sortOrder
 * @return Categories
 */
public function setSortOrder($sortOrder)
{
    $this->sortOrder = $sortOrder;

    return $this;
}

/**
 * Get sortOrder
 *
 * @return string
 */
public function getSortOrder()
{
    return $this->sortOrder;
}

/**
 * Set dateAdded
 *
 * @param /DateTime $dateAdded
 * @return Categories
 */
public function setDateAdded($dateAdded)
{
    $this->dateAdded = $dateAdded;

    return $this;
}

/**
 * Get dateAdded
 *
 * @return /DateTime
 */
public function getDateAdded()
{
    return $this->dateAdded;
}

/**
 * Set lastModified
 *
 * @param /DateTime $lastModified
 * @return Categories
 */
public function setLastModified($lastModified)
{
    $this->lastModified = $lastModified;

    return $this;
}

/**
 * Get lastModified
 *
 * @return /DateTime
 */
public function getLastModified()
{
    return $this->lastModified;
}

/**
 * Constructor
 */
public function __construct()
{
    $this->categoryDescription = new ArrayCollection();
    $this->products = new ArrayCollection();
}

/**
 * Add categoryDescription
 *
 * @param /Apw/BlackbullBundle/Entity/CategoriesDescription $categoryDescription
 * @return Categories
 */
public function addCategoryDescription(/Apw/BlackbullBundle/Entity/CategoriesDescription $categoryDescription)
{
    $this->categoryDescription[] = $categoryDescription;

    return $this;
}

/**
 * Remove categoryDescription
 *
 * @param /Apw/BlackbullBundle/Entity/CategoriesDescription $categoryDescription
 */
public function removeCategoryDescription(/Apw/BlackbullBundle/Entity/CategoriesDescription $categoryDescription)
{
    $this->categoryDescription->removeElement($categoryDescription);
}

/**
 * Get categoryDescription
 *
 * @return /Doctrine/Common/Collections/Collection
 */
public function getCategoryDescription()
{
    return $this->categoryDescription;
}

/**
 * Add products
 *
 * @param /Apw/BlackbullBundle/Entity/Products $products
 * @return Categories
 */
public function addProduct(/Apw/BlackbullBundle/Entity/Products $products)
{
    $this->products[] = $products;

    return $this;
}

/**
 * Remove products
 *
 * @param /Apw/BlackbullBundle/Entity/Products $products
 */
public function removeProduct(/Apw/BlackbullBundle/Entity/Products $products)
{
    $this->products->removeElement($products);
}

/**
 * Get products
 *
 * @return /Doctrine/Common/Collections/Collection
 */
public function getProducts()
{
    return $this->products;
}

/**
 * Set categoriesStatus
 *
 * @param boolean $categoriesStatus
 * @return Categories
 */
public function setCategoriesStatus($categoriesStatus)
{
    $this->categoriesStatus = $categoriesStatus;

    return $this;
}

/**
 * Get categoriesStatus
 *
 * @return boolean
 */
public function getCategoriesStatus()
{
    return $this->categoriesStatus;
}
}

Luego tengo este método en mi controlador para manejar el envío del formulario:

<?php

namespace Apw/BlackbullBundle/Controller;


use Apw/BlackbullBundle/Entity/Categories;
use Apw/BlackbullBundle/Entity/CategoriesDescription;
use Apw/BlackbullBundle/Form/CategoriesType;
use Symfony/Bundle/FrameworkBundle/Controller/Controller;
use Sensio/Bundle/FrameworkExtraBundle/Configuration/Route;
use Sensio/Bundle/FrameworkExtraBundle/Configuration/Template;
use Symfony/Component/HttpFoundation/JsonResponse;
use Symfony/Component/HttpFoundation/Request;
use Symfony/Component/Form/Extension/Core/ChoiceList/ChoiceList;
use Sensio/Bundle/FrameworkExtraBundle/Configuration/Security;


class CategoriesController extends Controller
{
   /**
 * @Security("has_role(''ROLE_ADMIN'')")
 * @Route("/createCategory")
 * @Template()
 */

public function createCategoryAction(Request $request){

    $category = new Categories();
    $categoryDesc = new CategoriesDescription();
    $category->addCategoryDescription($categoryDesc);
    $categoryDesc->setCategory($category);

    $form = $this->createForm(new CategoriesType(), $category);
    $form->handleRequest($request);

    if($form->isValid()){
        //exit(/Doctrine/Common/Util/Debug::dump($category));
        $em = $this->getDoctrine()->getManager();

        $em->persist($category);
        $em->persist($categoryDesc);
        $em->flush();

        return $this->redirect($this->generateUrl(''apw_blackbull_categories_showcategories''));
    }

    return array(
        ''form'' => $form->createView()
    );
}

}

Y finalmente este es mi CategoryType.php:

<?php

namespace Apw/BlackbullBundle/Form;

use Doctrine/ORM/EntityRepository;
use Symfony/Component/Form/AbstractType;
use Symfony/Component/Form/FormBuilderInterface;
use Symfony/Component/OptionsResolver/OptionsResolverInterface;

class CategoriesType extends AbstractType
{
    /**
     * @param FormBuilderInterface $builder
     * @param array $options
     */
    public function buildForm(FormBuilderInterface $builder, array $options)
    {
        $builder
            ->add(''categoryDescription'', ''collection'',
                array(
                    ''type'' => new CategoriesDescriptionType(),
                    ''allow_add'' => true,
                    ''options'' => array(''data_class'' => ''Apw/BlackbullBundle/Entity/CategoriesDescription''),
                    ''by_reference'' => false,
                ))
            ->add(''categoriesImage'', null, array(''label''=>''Foto:''))
            ->add(''categoriesStatus'', null, array(''label''=>''Stato:''))
            ->add(''parentId'', ''entity'', array( //provare a mettere una querybuiler
                                            ''class''       => ''ApwBlackbullBundle:CategoriesDescription'',
                                            ''property''    => ''categoriesName'',
                                            ''empty_value'' => ''Scegliere una categoria'',
                                            ''required''    => false,
                                            ''label''       => ''Crea in:''))
            ->add(''salva'',''submit'')
            ->add(''azzera'',''reset'')
        ;
    }

    /**
     * @param OptionsResolverInterface $resolver
     */
    public function setDefaultOptions(OptionsResolverInterface $resolver)
    {
        $resolver->setDefaults(array(
            ''data_class'' => ''Apw/BlackbullBundle/Entity/Categories'',
        ));
    }

    /**
     * @return string
     */
    public function getName()
    {
        return ''categories'';
    }
}

Cuando intento guardar datos obtengo este error:

Se produjo una excepción al ejecutar ''INSERT INTO Categories (categories_image, parent_id, sort_order, date_added, last_modified, categories_status) VALUES (?,?,?,?,?,?)'' Con params ["as", {}, null, null , nulo, 1]:

Fatal Error acumulable: el objeto de la clase Apw / BlackbullBundle / Entity / CategoriesDescription no se pudo convertir a cadena

¿Qué estoy haciendo mal?

Answer 1

Necesita implementar el método __toString() en su Apw/BlackbullBundle/Entity/CategoriesDescription .

Podrías hacerlo:

public function __toString() {
    return $this->name;
}

Answer 2

Obtuve el mismo error pero lo modifiqué un poco al agregar:

    public function __toString() {
return (string) $this->name; }

Estoy seguro de que estaba obteniendo nulo en lugar de un valor de cadena. (Estaba trabajando con el proyecto sonata).

Answer 3

También puede usar el acceso a la propiedad en su formulario:

->add(''categoryDescription'', ''collection'',
            array(
                ''type''         => new CategoriesDescriptionType(),
                ''allow_add'' => true,
                ''options''      => array(''data_class'' => ''Apw/BlackbullBundle/Entity/CategoriesDescription''),
                ''by_reference'' => false,

            ))

Y agregue ''property'' => ''name'' en su CategoriesDescriptionType.

Por cierto, la respuesta @CoachNono también está bien.

Answer 4

así que resolví el problema obteniendo el valor de parent relativo en el método $form->isValid()

public function createCategoryAction(Request $request){

        $category = new Categories();
        $categoryDesc = new CategoriesDescription();
        $category->addCategoryDescription($categoryDesc);
        $categoryDesc->setCategory($category);

        $form = $this->createForm(new CategoriesType(), $category);
        $form->handleRequest($request);

        if($form->isValid()){
        //exit(/Doctrine/Common/Util/Debug::dump($parentCategory->getId()));
            $em = $this->getDoctrine()->getManager();
            if(!$category->getParentId()){
                $category->setParentId(0);
            }else{
            // get parent id value from input choice
            $parent = $category->getParentId();
            $parentCategory = $parent->getCategory();
            // end
                $category->setParentId($parentCategory->getId());
            }
            $em->persist($category);
            $em->persist($categoryDesc);
            $em->flush();

            return $this->redirect($this->generateUrl(''apw_blackbull_categories_showcategories''));
        }

        return array(
            ''form'' => $form->createView()
        );
    }

¡Gracias!

Answer 5

Para Symfony 3.x

De acuerdo con Symfony docs v3.x , debe usar la propiedad choice_label para especificar el nombre del campo de la entidad que se usará aquí.

->add(''categoryDescription'', ''collection'',
        array(
            ''type''         => new CategoriesDescriptionType(),
            ''allow_add'' => true,
            ''options''      => array(''data_class'' => ''Apw/BlackbullBundle/Entity/CategoriesDescription''),
            ''choice_label'' => ''name'',
            ''by_reference'' => false,

        ))