File manager

File manager - Edit - /home/autoph/public_html/portal/includes/chart/aurr_vs_dialyzer.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='aurrdu'> <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='aurrdu'> <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 //$fSixLess=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='68' AND `branch_id`='$compCode' AND `urr` < 65"),0); //$fSixHigh=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='68' AND `branch_id`='$compCode' AND `urr` > 64"),0); //$FEight=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='69' AND `branch_id`='$compCode' AND `creatinine` <10"),0); $FOneSixtyNRLESS=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='70' AND `branch_id`='$compCode' AND `urr` < 65"),0); $FOneSixtyNRHIGH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='70' AND `branch_id`='$compCode' AND `urr` > 65"),0); $FOneEightyNRLESS=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='71' AND `branch_id`='$compCode' AND `urr` < 65"),0); $FOneEightyNRHIGH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='71' AND `branch_id`='$compCode' AND `urr` > 64"),0); $FSIXTYALESS=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='72' AND `branch_id`='$compCode' AND `urr` <65"),0); $FSIXTYAHIGH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='72' AND `branch_id`='$compCode' AND `urr` > 64"),0); $FEightLESS=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='73' AND `branch_id`='$compCode' AND `urr` < 65"),0); $FEightHIGH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='73' AND `branch_id`='$compCode' AND `urr` > 64"),0); $FBothLESS = $FSIXTYALESS + $FEightLESS; $FBothHIGH = $FSIXTYAHIGH + $FEightHIGH; $HFEightALESS=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='74' AND `branch_id`='$compCode' AND `urr` < 65"),0); $HFEightAHIGH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='74' AND `branch_id`='$compCode' AND `urr` > 64"),0); $HFEightSLESS=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='75' AND `branch_id`='$compCode' AND urr` < 65"),0); $HFEightSHIGH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='75' AND `branch_id`='$compCode' AND urr` > 64"),0); $HFAllLESS = $HFEightALESS + $HFEightSLESS; $HFAllHIGH = $HFEightAHIGH + $HFEightSHIGH; //$myHF =$HFEightA + $HFEightS; // Merge HF60A and HF80S $TwoHundredNRLESS=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='283' AND `branch_id`='$compCode' AND `urr` < 65"),0); $TwoHundredNRHIGH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='283' AND `branch_id`='$compCode' AND `urr` > 64"),0); $ELisionHRL=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='293' AND `branch_id`='$compCode' AND `urr` < 65"),0); $ELisionHRH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='293' AND `branch_id`='$compCode' AND `urr` > 64"),0); $ELisionLRHL=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='296' AND `branch_id`='$compCode' AND `urr` < 65"),0); $ELisionLRHH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='296' AND `branch_id`='$compCode' AND `urr` > 64"),0); $ELisionFiftyHRLRL =$ELisionHRL + $ELisionHRH; $ELisionFiftyHRLRH =$ELisionLRHL + $ELisionLRHH; $ELisionFiftyHRL=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='294' AND `branch_id`='$compCode' AND `urr` < 54"),0); $ELisionFiftyHRH=mysql_result(mysql_query("SELECT COUNT('lab_id') FROM `laboratory_info` WHERE `lab_date` BETWEEN '$startDate' AND '$endDate' AND `issued_dialyzer`='294' AND `branch_id`='$compCode' AND `urr` > 64"),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', 'LESS 65%',{ role: 'annotation' },'ABOVE 65%',{ role: 'annotation' }], ['F160NR',<?php echo $FOneSixtyNRLESS;?>,<?php echo $FOneSixtyNRLESS;?>,<?php echo $FOneSixtyNRHIGH;?>,<?php echo $FOneSixtyNRHIGH;?>,], ['F180NR',<?php echo $FOneEightyNRLESS;?>,<?php echo $FOneEightyNRLESS;?>,<?php echo $FOneEightyNRHIGH;?>,<?php echo $FOneEightyNRHIGH;?>,], ['HF80\|60',<?php echo $HFAllLESS;?>,<?php echo $HFAllLESS;?>,<?php echo $HFAllHIGH;?>,<?php echo $HFAllHIGH;?>,], ['200FR',<?php echo $TwoHundredNRLESS;?>,<?php echo $TwoHundredNRLESS;?>,<?php echo $TwoHundredNRHIGH;?>,<?php echo $TwoHundredNRHIGH;?>,], ['190HR\|LR',<?php echo $ELisionFiftyHRLRL;?>,<?php echo $ELisionFiftyHRLRL;?>,<?php echo $ELisionFiftyHRLRH;?>,<?php echo $ELisionFiftyHRLRH;?>,], ['150HR',<?php echo $ELisionFiftyHRL;?>,<?php echo $ELisionFiftyHRL;?>,<?php echo $ELisionFiftyHRH;?>,<?php echo $ELisionFiftyHRH;?>,], ]); var options = { title : 'UREA REDUCTIONRATE VS DIALYZER USED <?php echo "(".$startDate." - ".$endDate.")";?>', vAxis: {title: ''}, hAxis: {title: ''}, seriesType: 'bars', series: {2: {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 | proxy | phpinfo | Settings