File manager - Edit - /home/autoph/public_html/ahglegal/includes/chart/frequency_tx.php
Back
<?php $OnceX = mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `tx_frequency` ='1x' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $TwoX = mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `tx_frequency` ='2x' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $TwoThreeX =mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `tx_frequency` ='2x|3x' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $ThreeX = mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `tx_frequency` ='3x' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $totalCount = $OnceX + $TwoX + $TwoThreeX + $ThreeX; ?> <html> <head> <script type="text/javascript" src="http://localhost/nephro/script/chartScript/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawVisualization); function drawVisualization() { // Some raw data (not necessarily accurate) var data = google.visualization.arrayToDataTable([ ['SCHEDULE', 'FREQUENCY'], ['1X', <?php echo $OnceX; ?>], ['2X', <?php echo $TwoX; ?>], ['2X | 3X', <?php echo $TwoThreeX; ?>], ['3X', <?php echo $TwoThreeX; ?>], ]); var options = { title : 'FREQUENCY OF HD', vAxis: {title: 'Cencus'}, hAxis: {title: 'Age Range by Sex'}, seriesType: 'bars', series: {5: {type: 'line'}} }; var chart = new google.visualization.ComboChart(document.getElementById('chart_div')); chart.draw(data, options); } </script> </head> <body> <div id="chart_div" style="width: 700px; height: 430px;background:white"></div> <center><table style='width:700px;border-collapse:collapse'> <tr> <td align='right' style='width:110px;font-size:12px;padding:3px;background:#F6D8CE;border:none;font-weight:bold'>1x Week</td> <td style='padding-left:10px;font-size:12px;background:#CEF6EC'><?php echo number_format($rateOnce = (($OnceX / $totalCount)*100),1,'.','.')." %"; ?></td> <td align='right' style='width:110px;font-size:12px;padding:3px;background:#F6D8CE;border:none;font-weight:bold'>2x per Week</td> <td style='padding-left:10px;font-size:12px;background:#CEF6EC'><?php echo number_format($rateTwo = (($TwoX / $totalCount)*100),2,'.','.')." %"; ?></td> <td align='right' style='width:120px;font-size:12px;padding:3px;background:#F6D8CE;border:none;font-weight:bold'>2x | 3X per Week</td> <td style='padding-left:10px;font-size:12px;background:#CEF6EC'><?php echo number_format($rateTwoThree = (($TwoThreeX / $totalCount)*100),2,'.','.')." %"; ?></td> <td align='right' style='width:110px;font-size:12px;padding:3px;background:#F6D8CE;border:none;font-weight:bold'>3x per Week</td> <td style='padding-left:10px;font-size:12px;background:#CEF6EC'><?php echo number_format($rateThree = (($ThreeX / $totalCount)*100),2,'.','.')." %"; ?></td> </tr> </table> </center> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings