Código PHP:
Ver original<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Highcharts Example</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<style type="text/css">
${demo.css}
</style>
<script type="text/javascript">
$(function () {
$('#container').highcharts({
chart: {
type: 'column'
},
title: {
text: 'Monthly Average Rainfall'
},
subtitle: {
text: 'Source: '
},
xAxis: {
categories: [
<?php
SUM(IF(route='PO',count,NULL)) AS PO,
SUM(IF(route='IV',count,NULL)) AS IV,
(SUM(IF(route='PO',count,NULL)) + SUM(IF(route='IV',count,NULL))) AS Total
FROM core_reports_antiinfectives
GROUP BY drug_id");
{
?>
'<?php echo $drug_id = $row["drug_id"]; ?>',
<?php
}
?>
/************************** El Resultado es *************************************/
/** Esto Se Incrementa Al final trae una Coma, No deberia ir esa coma al final **/
/*
ASI ESTA AHORA
categories: [ '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', ],
DEBE QUEDAR ASI
categories: [ '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12' ],
*/
/*********************************************************************************/
],
crosshair: true
},
yAxis: {
min: 0,
title: {
text: 'Rain (mm)'
}
},
tooltip: {
headerFormat: '<span style="font-size:10px">{point.key}</span><table>',
pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +
'<td style="padding:0"><b>{point.y:.1f} mm</b></td></tr>',
footerFormat: '</table>',
shared: true,
useHTML: true
},
plotOptions: {
column: {
pointPadding: 0.2,
borderWidth: 0
}
},
series: [{
name: 'PO',
data: [
<?php
SUM(IF(route='PO',count,NULL)) AS PO,
SUM(IF(route='IV',count,NULL)) AS IV,
(SUM(IF(route='PO',count,NULL)) + SUM(IF(route='IV',count,NULL))) AS Total
FROM core_reports_antiinfectives
GROUP BY drug_id");
{
?>
<?php echo $PO = $row["PO"]; ?>,
<?php
}
?>
]
},
{
name: 'IV',
data: [
<?php
SUM(IF(route='PO',count,NULL)) AS PO,
SUM(IF(route='IV',count,NULL)) AS IV,
(SUM(IF(route='PO',count,NULL)) + SUM(IF(route='IV',count,NULL))) AS Total
FROM core_reports_antiinfectives
GROUP BY drug_id");
{
?>
<?php echo $IV = $row["IV"]; ?>,
<?php
}
?>
]
},
{
name: 'Total: ',
data: [
<?php
SUM(IF(route='PO',count,NULL)) AS PO,
SUM(IF(route='IV',count,NULL)) AS IV,
(SUM(IF(route='PO',count,NULL)) + SUM(IF(route='IV',count,NULL))) AS Total
FROM core_reports_antiinfectives
GROUP BY drug_id");
{
?>
<?php echo $Total = $row["Total"]; ?>,
<?php
}
?>
]
}]
/************************** El Resultado es *************************************/
/*
series: [{
name: 'PO',
ASI ESTA AHORA Y siempre la Coma al final
data: [ 13, 5, 5, , 1, ]
DEBE QUEDAR ASI
data: [49.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4]
}, {
name: 'IV',
ASI ESTA AHORA Y siempre la Coma al final
data: [ , , 1, 2, 8, ]
DEBE QUEDAR ASI
data: [83.6, 78.8, 98.5, 93.4, 106.0, 84.5, 105.0, 104.3, 91.2, 83.5, 106.6, 92.3]
}, {
name: 'Total: ',
ASI ESTA AHORA Y siempre la Coma al final
data: [ , , 6, , 9, ]
DEBE QUEDAR ASI
data: [48.9, 38.8, 39.3, 41.4, 47.0, 48.3, 59.0, 59.6, 52.4, 65.2, 59.3, 51.2]
}]
*/
/*********************************************************************************/
});
});
</script>
</head>
<body>
<script src="../../js/highcharts.js"></script>
<script src="../../js/modules/exporting.js"></script>
<div id="container" style="min-width: 310px; height: 400px; margin: 0 auto"></div>
</body>
</html>
