twig - Change the google graph value using AJAX

Question

My controller :

$pieDemandeStatut = new PieChart();
    $pieDemandeStatut->getData()->setArrayToDataTable(            
        [[]]       
    );

    if(isset($_GET['value_equipe'])) {
        $value = $_GET['value_equipe'];
        
        $pieDemandeStatut = new PieChart();
        $pieDemandeStatut->getOptions()->setTitle('Demandes par Statut');

        $em = $this->getDoctrine()->getManager();
        $statuts = $em->getRepository('AppBundle:Statut')->findAll();
        $query = $em->createQuery('
            SELECT e.nom as equipe, count(a) as total from AppBundle:Affectation a
            JOIN AppBundle:Equipe e
            WHERE e.id = '.$value.'
            
            GROUP By equipe
            
        ');
        $demandes_equipe = $query->getResult();
        
        //$statut_data = array(array());
        $equipe_data = [['hamid',2]];
        //array_push($stack, "apple", "raspberry");
        foreach ($demandes_equipe as $demande){
            array_push($equipe_data, [$demande['equipe'],(int)$demande['total']]);
        }   
        $pieDemandeStatut->getData()->setArrayToDataTable(
                
            $equipe_data
                
        );
        return $this->render('default/index.html.twig',array('demandes' => $demandes,
        'users' => $users,
        'equipes' => $equipes,
        'injections' => $injections,
        'piechart' => $pieChart,
        'pieDemandeStatut' => $pieDemandeStatut));
    
    }
    
    return $this->render('default/index.html.twig', [
        'demandes' => $demandes,
        'users' => $users,
        'equipes' => $equipes,
        'injections' => $injections,
        'piechart' => $pieChart,
        'pieDemandeStatut' => $pieDemandeStatut

    ]);

My view:

<script>
    
    $('#equipe').on('change', function() {
        var value_equipe = this.value;
        var url = window.location.href;  
       $.ajax({
            url: "{{ path('homepage') }}",  
            type: 'GET',
            data: {value_equipe: value_equipe},
            

                success : function(response_data) {  
                    alert(response_data)
                    {{ gc_draw([pieDemandeStatut], ['div_pieDemandeStatutchart']) }}
                } 
        }); 
    });

I want to change the google graph view on every select change. But it sticks to the first value of my "PieDemandeStatut".

The idea is to get the status for every team. The user select the team and it gives him the chart of the status

I searched in other members problem that look similar to this and I found out that twig doesn't get changed on AJAX success.

question from:https://stackoverflow.com/questions/65888618/change-the-google-graph-value-using-ajax

Answer 1

Waitting for answers