File manager

File manager - Edit - /home/autoph/public_html/portal/includes/chart/creatinine_vs_bfr.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='cVSbfr'> <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='cVSbfr'> <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 //QUERY BFR WITH LESS 200 VALUE AND CREATININE LESS 10 $bfrLessTwoHundred=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` < 200 AND `branch_id`='$compCode' AND `creatinine` < 10 "),0); $bfrTwoHundredOneToThreeHundred=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 199 AND `bfr` < 251 AND `branch_id`='$compCode' AND `creatinine` < 10 "),0); $bfrTwoHundredFiftyToThreeHundred=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 250 AND `bfr` < 299 AND `branch_id`='$compCode' AND `creatinine` < 10 "),0); $bfrAboveThreeHundred=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 300 AND `branch_id`='$compCode' AND `creatinine` < 10 "),0); //QUERY BFR WITH LESS 200 VALUE AND CREATININE LESS 10-19.9 $bfrLessTwoHundredB=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` < 200 AND `branch_id`='$compCode' AND `creatinine` < 20 AND `creatinine` > 9 "),0); $bfrTwoHundredOneToThreeHundredB=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 199 AND `bfr` < 251 AND `branch_id`='$compCode' AND `creatinine` < 20 AND `creatinine` > 9 "),0); $bfrTwoHundredFiftyToThreeHundredB=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 250 AND `bfr` < 299 AND `branch_id`='$compCode' AND `creatinine` < 20 AND `creatinine` > 9 "),0); $bfrAboveThreeHundredB=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 300 AND `branch_id`='$compCode' AND `creatinine` < 20 AND `creatinine` > 9 "),0); //QUERY BFR WITH LESS 20 VALUE AND CREATININE LESS 30 $bfrLessTwoHundredC=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` < 200 AND `branch_id`='$compCode' AND `creatinine` > 19.99 AND `creatinine` < 31 "),0); $bfrTwoHundredOneToThreeHundredC=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 199 AND `bfr` < 251 AND `branch_id`='$compCode' AND `creatinine` > 19.99 AND `creatinine` < 31 "),0); $bfrTwoHundredFiftyToThreeHundreC=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 250 AND `bfr` < 299 AND `branch_id`='$compCode' AND `creatinine` > 19.99 AND `creatinine` < 31 "),0); $bfrAboveThreeHundreC=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 300 AND `branch_id`='$compCode' AND `creatinine` > 19.99 AND `creatinine` < 31 "),0); //QUERY BFR WITH ABOVE 30 $bfrLessTwoHundredD=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` < 200 AND `branch_id`='$compCode' AND `creatinine` > 30 "),0); $bfrTwoHundredOneToThreeHundredD=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 199 AND `bfr` < 251 AND `branch_id`='$compCode' AND `creatinine` > 30 "),0); $bfrTwoHundredFiftyToThreeHundredD=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 250 AND `bfr` < 299 AND `branch_id`='$compCode' AND `creatinine` > 30 "),0); $bfrAboveThreeHundredD=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `bfr` > 300 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([ ['BRF RANGE', 'Less 200',{ role: 'annotation' },'200 - 250 ',{ role: 'annotation' },'251 - 300 ',{ role: 'annotation' },'300 Above',{ role: 'annotation' },], ['Less 10', <?php echo $bfrLessTwoHundred; ?>,<?php echo $bfrLessTwoHundred; ?>, <?php echo $bfrTwoHundredOneToThreeHundred; ?>,<?php echo $bfrTwoHundredOneToThreeHundred; ?>, <?php echo $bfrTwoHundredFiftyToThreeHundred; ?>,<?php echo $bfrTwoHundredFiftyToThreeHundred; ?>, <?php echo $bfrAboveThreeHundred; ?>,<?php echo $bfrAboveThreeHundred; ?>,], ['10 - 19.9', <?php echo $bfrLessTwoHundredB; ?>,<?php echo $bfrLessTwoHundredB; ?>, <?php echo $bfrTwoHundredOneToThreeHundredB; ?>,<?php echo $bfrTwoHundredOneToThreeHundredB; ?>, <?php echo $bfrTwoHundredFiftyToThreeHundredB; ?>,<?php echo $bfrTwoHundredFiftyToThreeHundredB; ?>, <?php echo $bfrAboveThreeHundredB; ?>,<?php echo $bfrAboveThreeHundredB; ?>, ], ['20 - 30', <?php echo $bfrLessTwoHundredC; ?>,<?php echo $bfrLessTwoHundredC; ?>, <?php echo $bfrTwoHundredOneToThreeHundredC; ?>,<?php echo $bfrTwoHundredOneToThreeHundredC; ?>, <?php echo $bfrTwoHundredFiftyToThreeHundredC; ?>,<?php echo $bfrTwoHundredFiftyToThreeHundredC; ?>, <?php echo $bfrAboveThreeHundredC; ?>,<?php echo $bfrAboveThreeHundredC; ?>,], ['Above 30', <?php echo $bfrLessTwoHundredD; ?>,<?php echo $bfrLessTwoHundredD; ?>, <?php echo $bfrTwoHundredOneToThreeHundredD; ?>,<?php echo $bfrTwoHundredOneToThreeHundredD; ?>, <?php echo $bfrTwoHundredFiftyToThreeHundredD; ?>,<?php echo $bfrTwoHundredFiftyToThreeHundredD; ?>, <?php echo $bfrAboveThreeHundredD; ?>,<?php echo $bfrAboveThreeHundredD; ?>,], ]); var options = { title : 'CREATININE VS BLOOD FLOW RATE <?php echo "(".$startDate." - ".$endDate.")";?>', vAxis: {title: 'BRF'}, hAxis: {title: 'CREATININE'}, seriesType: 'bars', series: {6: {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: 810px; height: 500px;"></div> </body> </html> <?php } ?>

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