File manager

File manager - Edit - /home/autoph/public_html/ahglegal/includes/chart/ave_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='acVSbfr'> <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='acVSbfr'> <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 $LessTwoHundredA = mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `bfr` < 200 AND `branch_id`='$compCode' AND `lab_date` BETWEEN '$startDate' AND '$endDate'"),0); $LessTwoHundredB = mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `bfr` > 199.99 AND `bfr` < 251 AND `branch_id`='$compCode' AND `lab_date` BETWEEN '$startDate' AND '$endDate'"),0); $LessTwoHundredC = mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `bfr` > 250 AND `bfr` < 301 AND `branch_id`='$compCode' AND `lab_date` BETWEEN '$startDate' AND '$endDate'"),0); $LessTwoHundredD = mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `bfr` > 300 AND `branch_id`='$compCode' AND `lab_date` BETWEEN '$startDate' AND '$endDate'"),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(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['CREATINE', 'BFR'], ['Less 200', <?php echo $LessTwoHundredA;?>,], ['200-250',<?php echo $LessTwoHundredB;?>,], ['251-300', <?php echo $LessTwoHundredC;?>,], ['Above 300',<?php echo $LessTwoHundredD;?>,], ]); var options = { title: 'AVE. CREATININE LEVEL VS. BFR <?php echo "(".$startDate." - ".$endDate.")";?> ', is3D: false, }; var chart = new google.visualization.PieChart(document.getElementById('piechart_3d')); chart.draw(data, options);y } google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawChart1); </script> </head> <body> <div id="piechart_3d" style="width:98%; height: 98%;background:white;font-size:14px;color:black"></div> </body> </html> <?php }?>

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