hola buenas quisiera saber si podrian ayudarme a resolver el siguiente problemma quiero hacer una grafica con la extension de yii
yii-highcharts y no logro convertir una arreglo de la base de datos y pasarlo a widget
$this->Widget(‘ext.highcharts.HighchartsWidget’, array(
‘scripts’ => array(
'highcharts-more', // enables supplementary chart types (gauge, arearange, columnrange, etc.)
'modules/exporting', // adds Exporting button/menu to chart
'themes/grid-light' // applies global 'grid' theme to all charts
),
'options' => array(
'title' => array('text' => 'Patient Visits By Day (Last Two Weeks)'),
'xAxis' => array(
'categories' => array('14th','15th','16th','17th','18th','19th','20th','21th','22th','23th','24th','25th','26th','27th','28th')
),
'yAxis' => array(
'title' => array('text' => 'Number of Visits')
),
'colors'=>array('#0563FE', '#6AC36A', '#FFD148', '#FF2F2F'),
'gradient' => array('enabled'=> true),
'credits' => array('enabled' => false),
/*'exporting' => array('enabled' => false),*/ //to turn off exporting uncomment
'chart' => array(
'plotBackgroundColor' => '#ffffff',
'plotBorderWidth' => null,
'plotShadow' => false,
'height' => 400,
),
'title' => false,
'series' => array(
array('type'=>'column','name' => 'Hampton Office', 'data' =>$esto),
array('type'=>'spline','name' => 'Hampton Office', [u]'data' => array(20, 25, 25,35, 30, 28,25, 27, 23, 24, 25, [/u]26,27,28,33) <img src='http://www.yiiframework.com/forum/public/style_emoticons/default/dry.gif' class='bbc_emoticon' alt='<_<' /> ),
array('type'=>'spline','name' => 'Richmond Office', 'data' => array(5, 7, 8,9, 7, 10,11, 12, 13,15, 17, 14,15,16,18)),
array(
'type'=>'pie',
'name' => 'Richmond Office',
'data' => array(5, 7, <img src='http://www.yiiframework.com/forum/public/style_emoticons/default/cool.gif' class='bbc_emoticon' alt='8)' />,
'dataLabels' => array(
'enabled' => false,
),
'showInLegend'=>false,
'size'=>'10',
),
),
)
));
es decir mi problema es que quiero pasar un arreglo de la base de datos, no el arreglo predeterminado que trae el widgets
array(5, 7, 8,9, 7, 10,11, 12, 13,15, 17, 14,15,16,18)