Home / Questions

Questions[symfony2]

Martin Hope
Cristian Budzicz
Asked: 2020-08-21 12:20:35 +0800 CST
  • 2

I am working on a symfony 2.8 project, I had the project versioned with svn but now we are starting to work with git

When synchronizing my local repository with the cloud, and trying to run it, I get the following error

An exception has been thrown during the rendering of a template ("Unable to generate a URL for the named route "_assetic_c49beaa_0" as such route does not exist.").

Could it be that I need to install some vendor? Or am I missing some configuration?

Any guidance is welcome!

symfony2
Martin Hope
Cristian Budzicz
Asked: 2020-03-29 07:50:23 +0800 CST
  • 2

I have defined a function in which I use the pager, used in my controllers it works correctly. However, when I define a service to not copy and paste the code, I have the following:

 app.paginacion:
    class: Caja\SiafcaInternetBundle\Services\Paginacion
    public: true
    arguments: ["@knp_paginator"]

In my config.yml

knp_paginator:
page_range: "%knp_paginator_page_range%"
default_options:
    page_name: "%knp_paginator_page_name%"
    sort_field_name: "%knp_paginator_sort_field_name%"
    sort_direction_name: "%knp_paginator_sort_direction_name%"
    distinct: "%knp_paginator_distinct%"
template:
    pagination: "%knp_paginator_pagination%"
    sortable: "%knp_paginator_sortable%"

And in my controller I define the following class

class Paginacion{

private $paginator;

public function __contruct($paginator){
   $this->$paginator = $paginator;
} 

public function obtenerPaginacion($request,$aportantesWS,$totalAportantes)
{
    if (!$aportantesWS) 
    {
        $pagination = null;
    } 
    else 
    {
        // $paginator = $this->get('app.knp_paginator');
        $pagination = 
                $this->paginator->paginate(
                                        $aportantesWS,
                                        $request->query->getInt('page', 1),
                                        20
                                    );
        $pagination->setTotalItemCount($totalAportantes);
    }
    return $pagination;
}}

For example calling it:

$this->get('app.paginacion')->obtenerPaginacion($request,$aportantesWS,$totalAportantes)

When I try to use it, it generates the following error Error: Call to a member function paginate() on null Checking with dump() the request data , contributorsWS and totalcontributors come back non-null, that is, with data.

symfony2
Martin Hope
warner
Asked: 2020-05-29 06:10:50 +0800 CST
  • 1

I'm doing a small project in Symfony 2.8, and what I'm trying to do is perform a query doctrinethat adds the values ​​of a column of a table and sends the total to my página.html.twig.

Here is the code I have written in the controller class where I want to perform this operation: 

class DefaultController extends Controller
{
    public function indexAction()
    {
        $em = $this->getDoctrine()->getManager();
        $query_ganancia = $em->createQuery('
            SELECT SUM(v.ingresos)
            FROM CarroBundle:Viaje v
        ');

        $var_ganancia = $query_ganancia->getResult();


        return $this->render('CarroBundle:Default:index.html.twig', array('ganancia'=> $var_ganancia));
    }
}

And in the page I get the value as follows: 

<h1>{{ ganancia }}</h1>

But for some reason that I still don't see, it keeps returning this exception : 

An exception has been thrown during the rendering of a template ("Notice: Array to string conversion") in CarroBundle:Default:index.html.twig at line 39.

I have searched the Symfony 2.8 guide regarding Doctrineand tried to perform the operation in this other way without result: 

$var_ganancia = $query_ganancia->setMaxResults(1)->getOneOrNullResult();

I would like someone to guide me on this error. Thanks.

symfony2
Martin Hope
Merche
Asked: 2020-03-13 11:03:05 +0800 CST
  • 4

I am trying to make a registration form where apart from the usual fields name, alias, password ( nombre, nickand password)... I also add two dependent fields, Municipioand Provincia.

The problem is that it only shows multiple messages of undefined in the municipality field.

enter image description here

The entity ( Entity) that creates the form is DbUsuario, which has the field idMunicipio.

/** @var \BackendBundle\Entity\DbMunicipios */
private $idMunicipio;

/**
 * Set idMunicipio
 * @param \BackendBundle\Entity\DbMunicipio $idMunicipio
 * @return DbUsuario
 */
public function setIdMunicipio(\BackendBundle\Entity\DbMunicipio $idMunicipio = null) {
    $this->idMunicipio = $idMunicipio;
    return $this;
}
/**
 * Get idMunicipio
 * @return \BackendBundle\Entity\DbMunicipio
 */
public function getIdMunicipio() {
    return $this->idMunicipio;
}

Then the entity DbMunicipiothat connects with the province:

/** @var \BackendBundle\Entity\DbProvincia */
private $provincia;

/**@param \BackendBundle\Entity\DbProvincia $provincia
 * @return DbMunicipio
 */
public function setProvincia(\BackendBundle\Entity\DbProvincia $provincia = null){
    $this->provincia = $provincia;
    return $this;
}
/**@return \BackendBundle\Entity\DbProvincia */
public function getProvincia(){
    return $this->provincia;
}

And the Entity DbProvinciathat only has the fields id( integer), slug( String) and provincia( String).

I define the form as follows:

namespace AppBundle\Form;

use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\FormBuilderInterface;
use Symfony\Component\OptionsResolver\OptionsResolver;
use Symfony\Component\Form\Extension\Core\Type\TextType;
use Symfony\Component\Form\Extension\Core\Type\EmailType;
use Symfony\Component\Form\Extension\Core\Type\PasswordType;
use Symfony\Component\Form\Extension\Core\Type\SubmitType;
use Symfony\Bridge\Doctrine\Form\Type\EntityType;
use Doctrine\ORM\EntityRepository;
use AppBundle\Form\EventListener\AddProvinciaField;
use AppBundle\Form\EventListener\AddMunicipioField;

class RegistreUserType extends AbstractType {

    public function buildForm(FormBuilderInterface $builder, array $options) {
         $factory = $builder->getFormFactory(); 

        $builder->add('nombre', TextType::class, array('label' => 'Nombre',
            'required' => 'required',
            'attr' => array('class' => 'form-nombre form-control')
        ));
        $builder->add('apellido', TextType::class, array('label' => 'Apellido',
            'required' => 'required',
            'attr' => array('class' => 'form-apellido form-control')
        ));
        $builder->add('nick', TextType::class, array('label' => 'Nick',
            'required' => 'required',
            'attr' => array('class' => 'form-nick form-control nick-input')
        ));
        $provinSubscriber = new AddProvinciaField($factory);
        $builder->addEventSubscriber($provinSubscriber);

        $muniSubscriber = new AddMunicipioField($factory);
        $builder->addEventSubscriber($muniSubscriber);

        $builder->add('email', EmailType::class, array('label' => 'Correo electrónico',
            'required' => 'required',
            'attr' => array('class' => 'form-email form-control')
        ));
        $builder->add('password', PasswordType::class, array('label' => 'Password',
            'required' => 'required',
            'attr' => array('class' => 'form-password form-control')
        ));
        $builder->add('Registrarse', SubmitType::class, array("attr" => array("class" => "form-submit btn btn-success")));
    }
    public function configureOptions(OptionsResolver $resolver) {
        $resolver->setDefaults(array(
            'data_class' => 'BackendBundle\Entity\DbUsuario'
        ));
    }
    public function getBlockPrefix() { return 'backendbundle_dbusuario'; }
}

I define inside AppBundle\Form\eventListener the classes, called in the form:

AddProvinciaField
namespace AppBundle\Form\EventListener;

use Symfony\Component\Form\Form;
use Symfony\Component\Form\FormEvent;
use Symfony\Component\Form\FormEvents;
use Symfony\Component\EventDispatcher\EventSubscriberInterface;
use Symfony\Component\Form\FormFactoryInterface;
use Doctrine\ORM\EntityRepository;
use Symfony\Bridge\Doctrine\Form\Type\EntityType;
use BackendBundle\Entity\DbProvincia;

class AddProvinciaField implements EventSubscriberInterface
{
     private $factory;

    public function __construct(FormFactoryInterface $factory) {
        $this->factory = $factory;
    }
    public static function getSubscribedEvents() {
        return array(
            FormEvents::PRE_SET_DATA => 'preSetData',
            FormEvents::PRE_SUBMIT     => 'preSubmit'
        );
    }
    private function addProvinciaForm($form, $provincia) {

       $form -> add('provincia', EntityType::class, array(
            'class'         => 'BackendBundle:DbProvincia',
            'label'         => 'Provincia',
            'placeholder'   => '_ Elegir _',
            'auto_initialize' => false,
            'mapped'        => false,
            'attr'=> array('class' => 'form-provincia form-control provincia-input'),
            'query_builder' => function (EntityRepository $repository) {
                $qb = $repository->createQueryBuilder('provincia');
                return $qb;
            }
        ));
    }
    public function preSetData(FormEvent $event){
        $data = $event->getData();
        $form = $event->getForm();

        if (null === $data) {return;}

        $provincia = ($data->getIdMunicipio()) ? $data->getIdMunicipio()->getProvincia() : null ;
        $this->addProvinciaForm($form, $provincia);
    }
    public function preSubmit(FormEvent $event) {
        $data = $event->getData();
        $form = $event->getForm();

        if (null === $data) { return;}

        $provincia = array_key_exists('provincia-input', $data) ? $data['provincia-input'] : null;
        $this->addProvinciaForm($form, $provincia);
    }
}

And later I define AddMunicipioField.php :

 namespace AppBundle\Form\EventListener;

 use Symfony\Component\Form\FormEvent;
 use Symfony\Component\Form\FormEvents;
 use Symfony\Component\Form\FormFactoryInterface;
 use Symfony\Component\EventDispatcher\EventSubscriberInterface;
 use Doctrine\ORM\EntityRepository;
 use Symfony\Bridge\Doctrine\Form\Type\EntityType;
 use BackendBundle\Entity\DbProvincia;


class AddMunicipioField implements EventSubscriberInterface {
    private $factory;

    public function _construct(FormFactoryInterface $factory) {
        $this->factory = $factory;
    }

    public static function getSubscribedEvents() {
        return array(
            FormEvents::PRE_SET_DATA => 'preSetData',
            FormEvents::PRE_SUBMIT     => 'preSubmit'
        );
    }
    private function addMunicipioForm($form, $provincia) {
        $form->add('idMunicipio', EntityType::class, array(
            'class'         => 'BackendBundle:DbMunicipio',
            'label'         => 'Municipio',
            'placeholder'   => '_ Elegir _',
            'auto_initialize' => false,
            'attr'=> array('class' => 'form-municipio form-control municipio-input'),
            'query_builder' => function (EntityRepository $repository) use ($provincia) {
                $qb = $repository->createQueryBuilder('idMunicipio')
                    ->innerJoin('idMunicipio.provincia', 'provincia');
                if ($provincia instanceof DbProvincia) {
                    $qb->where('idMunicipio.provincia = :provincia')
                    ->setParameter('provincia', $provincia);
                    var_dump($provincia);
                } elseif (is_numeric($provincia)) {
                    $qb->where('provincia.id = :provincia')
                    ->setParameter('provincia', $provincia);
                    var_dump($provincia);
                } else {
                    $qb->where('provincia.provincia = :provincia')
                    ->setParameter('provincia', null);
                    var_dump($provincia);
                }
                return $qb;
            }
        ));
    }
    public function preSetData(FormEvent $event){
        $data = $event->getData();
        $form = $event->getForm();

        if (null === $data) { return; }

        $provincia = ($data->getIdMunicipio()) ? $data->getIdMunicipio()->getProvincia() : null ;
        $this->addMunicipioForm($form, $provincia);
    }
    public function preSubmit(FormEvent $event){
        $data = $event->getData();
        $form = $event->getForm();

        if (null === $data) { return; }

        $provincia = array_key_exists('select_provincia', $data) ? $data['select_provincia'] : null;
        $this->addMunicipioForm($form, $provincia);
    }
}

And finally the AJAX request :

$(document).ready(function () {
    $('.provincia-input').change(function () {
        var $form = $(this).closest('form');
        var data = $('.provincia-input').serialize();

        $.ajax({
            url: $form.attr('action'),
            type: 'POST',
            data: data,
            success: function (html) {
                $('.municipio-input').replaceWith($(html).find('.municipio-input'));
            }
        });
    });
});
symfony2