Symfony2:Highchartsbundle数据问题

Symfony2: Highchartsbundle data problems

本文关键字:问题 数据 Highchartsbundle Symfony2      更新时间:2023-09-26

我在此函数上插入数据系列时遇到问题

public function chartAction()
{
    $em = $this->getDoctrine()->getManager();
    $entities = $em->getRepository('FarmacoBundle:Farmaco')->findCantfar();
    foreach($entities as $datos)
    {
        $datos['nombreComercial'];
        $datos['existencia'];
    }
    $series = array(
    array("name" => "Serie Name",  "data" => $datos['nombreComercial'], $datos['existencia'], "type" => "pie")
    );
    $ob = new Highchart();
    $ob->chart->renderTo('piechart');  
    $ob->title->text('Chart Title');
    $ob->series($series);
    return $this->render('FarmacoBundle:Default:chart.html.twig', array(
    'chart' => $ob
    ));
}

存储 库:

 public function findCantfar()
{
    $em = $this->getEntityManager();
    $query = $em->createQuery('
    SELECT f.nombreComercial, f.existencia
        FROM FarmacoBundle:Farmaco f 
    ');
    $query->setMaxResults(4);
    return $query->getResult();
}

因此,这就是结果

$(函数 () { var 饼图 = new Highcharts.Chart({ chart: {"renderTo":"piechart"}, series: [{"名称":"意甲名称","数据":"Atamel","0":"115","type":"pie"}], 标题: {"文本":"图表标题"} });});

显然,数据值不正确

如何正确传递此数据?

问候

foreach 循环的工作方式,$datos 将只保存上次迭代的值,并且原始值不会更改。

在循环之前初始化$series数组,并在每次迭代时向其添加另一个条目。