File manager

File manager - Edit - /home/autoph/public_html/ahglegal/includes/chart/creatinine_vs_frequencyhd.php

Back
<?php if(!isset($_GET['startDate'])){ ?> <form action='' method='GET'> <input type='hidden' name='view' value='plist'> <input type='hidden' name='search' value=''> <input type='hidden' name='sum' value='true'> <input type='hidden' name='go' value='cvsfhd'> <input type='hidden' name='subView' value='hemo'> <br>   <input id='datepicker' type="text" name="startDate" value ="<?php echo $toDate;?>" style="font-size:14px;font-weight:normal;color:blue;width:100px;height:28px;border:1px solid lightgray;text-align:left;background:white" onkeyup="addDateSeparator(event,this,'dd/mm/yyyy')" placeholder="mm/dd/yyyy" required> -<input id='datepickerA' type="text" name="endDate" value ="<?php echo $toDate;?>" style="font-size:14px;font-weight:normal;color:blue;width:100px;height:28px;border:1px solid lightgray;text-align:left;background:white" onkeyup="addDateSeparator(event,this,'dd/mm/yyyy')" placeholder="mm/dd/yyyy" required> <input type='submit' name='getDate' value='Search' style='width:80px;height:28px;'> <br>    Date Range (Start Date - End Date) </form> <?php }else { $startDate = $_GET['startDate']; $endDate = $_GET['endDate']; ?> <form action='' method='GET'> <input type='hidden' name='view' value='plist'> <input type='hidden' name='search' value=''> <input type='hidden' name='sum' value='true'> <input type='hidden' name='go' value='cvsfhd'> <input type='hidden' name='subView' value='hemo'> <br>   <input id='datepicker' type="text" name="startDate" value ="<?php echo $startDate;?>" style="font-size:14px;font-weight:normal;color:blue;width:100px;height:28px;border:1px solid lightgray;text-align:left;background:white" onkeyup="addDateSeparator(event,this,'dd/mm/yyyy')" placeholder="mm/dd/yyyy" required> -<input id='datepickerA' type="text" name="endDate" value ="<?php echo $endDate;?>" style="font-size:14px;font-weight:normal;color:blue;width:100px;height:28px;border:1px solid lightgray;text-align:left;background:white" onkeyup="addDateSeparator(event,this,'dd/mm/yyyy')" placeholder="mm/dd/yyyy" required> <input type='submit' name='getDate' value='Search' style='width:80px;height:28px;'> <br>    Date Range (Start Date - End Date) </form> <?php $oneXLessTen=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='1x' AND `branch_id`='$compCode' AND `creatinine` < 10"),0); $twoXLessTen=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='2x' AND `branch_id`='$compCode' AND `creatinine` < 10"),0); $twotreXLessTen=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='2x\|3x' AND `branch_id`='$compCode' AND `creatinine` < 10"),0); $threeXLessTen=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='2x\|3x' AND `branch_id`='$compCode' AND `creatinine` < 10"),0); //echo "Less: ".$oneXLessTen."<br>"; //echo "Less: ".$twoXLessTen."<br>"; //echo "Less: ".$twotreXLessTen."<br>"; //echo "Less: ".$threeXLessTen."<br>"; $oneXtwnty=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='1x' AND `branch_id`='$compCode' AND `creatinine` > 10 AND `creatinine` < 20"),0); $twoXtwnty=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='2x' AND `branch_id`='$compCode' AND `creatinine` > 10 AND `creatinine` < 20"),0); $twotreXtwnty=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='2x\|3xx' AND `branch_id`='$compCode' AND `creatinine` > 10 AND `creatinine` < 20"),0); $threeXtwnty=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='3x' AND `branch_id`='$compCode' AND `creatinine` > 10 AND `creatinine` < 20"),0); $oneXtwntyT=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='1x' AND `branch_id`='$compCode' AND `creatinine` > 20 AND `creatinine` < 31"),0); $twoXtwntyT=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='2x' AND `branch_id`='$compCode' AND `creatinine` > 20 AND `creatinine` < 31"),0); $twotreXtwntyT=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='2x\|3x' AND `branch_id`='$compCode' AND `creatinine` > 20 AND `creatinine` < 31"),0); $threeXtwntyT=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='3x' AND `branch_id`='$compCode' AND `creatinine` > 20 AND `creatinine` < 31"),0); $oneXthirtyUp=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='1x' AND `branch_id`='$compCode' AND `creatinine` > 30"),0); $twoXthirtyUp=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='2x' AND `branch_id`='$compCode' AND `creatinine` > 30"),0); $twotreXthirtyUp=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='2x\|3x' AND `branch_id`='$compCode' AND `creatinine` > 30"),0); $threeXthirtyUp=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `tx_count`='3x' AND `branch_id`='$compCode' AND `creatinine` > 30"),0); ?> <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/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) Creatinine level of each 1x below 10, 10-19.0, 20-30, 30 above var data = google.visualization.arrayToDataTable([ ['FREQUENCY', '1X', { role: 'annotation' }, '2X', { role: 'annotation' }, '2X \| 3X', { role: 'annotation' }, '3X', { role: 'annotation' }], ['Less 10', <?php echo $oneXLessTen;?>,<?php echo $oneXLessTen;?>,<?php echo $twoXLessTen;?>,<?php echo $twoXLessTen;?>,<?php echo $twotreXLessTen;?>,<?php echo $twotreXLessTen;?>,<?php echo $threeXLessTen;?>,<?php echo $threeXLessTen;?>, ],//Below 10 ['10 - 19.9', <?php echo $oneXtwnty;?>,<?php echo $oneXtwnty;?>,<?php echo $twoXtwnty;?>,<?php echo $twoXtwnty;?>,<?php echo $twotreXtwnty;?>,<?php echo $twotreXtwnty;?>,<?php echo $threeXtwnty;?>,<?php echo $threeXtwnty;?>, ], // 11-19.9 ['20-30', <?php echo $oneXtwntyT;?>,<?php echo $oneXtwntyT;?>,<?php echo $twoXtwntyT;?>,<?php echo $twoXtwntyT;?>,<?php echo $twotreXtwntyT;?>,<?php echo $twotreXtwntyT;?>,<?php echo $threeXtwntyT;?>,<?php echo $threeXtwntyT;?>, ], // 20-30 ['30 Up', <?php echo $oneXthirtyUp;?>,<?php echo $oneXthirtyUp;?>,<?php echo $twoXthirtyUp;?>,<?php echo $twoXthirtyUp;?>,<?php echo $twotreXthirtyUp;?>,<?php echo $twotreXthirtyUp;?>,<?php echo $threeXthirtyUp;?>,<?php echo $threeXthirtyUp;?>, ] ]); var options = { title : 'Creatinine vs. Frequency of HD', vAxis: {title: ''}, hAxis: {title: ''}, 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: 800px; height: 500px;"></div> </body> </html> <?php } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0.01 | proxy | phpinfo | Settings