File manager

File manager - Edit - /home/autoph/public_html/ahglegal/includes/chart/creatinine_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='cdu'> <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='cdu'> <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 $FSIX=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 `creatinine` <10"),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); $FOneSixtyNR=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 `creatinine` <10"),0); $FOneEightyNR=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 `creatinine` <10"),0); $FSIXTYA=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 `creatinine` <10"),0); $FEightA=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 `creatinine` <10"),0); $HFEightA=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 `creatinine` <10"),0); $HFEightS=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 `creatinine` <10"),0); $myHF =$HFEightA + $HFEightS; // Merge HF60A and HF80S $TwoHundredNR=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 `creatinine` <10"),0); $ELisionHR=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'"),0); $ELisionLR=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 `creatinine` <10"),0); $ELisionFiftyHRLR =$ELisionHR + $ELisionLR; $ELisionFiftyHR=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 `creatinine` <10"),0); //10-20 creatinine count $FSIX_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); $FEight_B=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` > 9 AND `creatinine` < 20"),0); $FOneSixtyNR_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); $FOneEightyNR_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); $FSIXTYA_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); $FEightA_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); $HFEightA_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); $HFEightS=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 `creatinine` > 9 AND `creatinine` < 20"),0); $myHF_B =$HFEightA_B + $HFEightS_B; // Merge HF60A and HF80S $TwoHundredNR_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); $ELisionHR_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); $ELisionLR_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); $ELisionFiftyHRLR_B =$ELisionHR_B + $ELisionLR_B; $ELisionFiftyHR_B=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 `creatinine` > 9 AND `creatinine` < 20"),0); //20-30 creatinine count $FSIX_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $FEight_C=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` > 19 AND `creatinine` < 31"),0); $FOneSixtyNR_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $FOneEightyNR_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $FSIXTYA_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $FEightA_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $HFEightA_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $HFEightS_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $myHF_C =$HFEightA_C + $HFEightS_C; // Merge HF60A and HF80S $TwoHundredNR_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $ELisionHR_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $ELisionLR_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); $ELisionFiftyHRLR_C =$ELisionHR_C + $ELisionLR_C; $ELisionFiftyHR_C=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 `creatinine` > 19 AND `creatinine` < 31"),0); //ABOVE 30 CREATININE Count $FSIX_D=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 `creatinine` <10"),0); $FEight_D=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); $FOneSixtyNR_D=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 `creatinine` <10"),0); $FOneEightyNR_D=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 `creatinine` <10"),0); $FSIXTYA_D=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 `creatinine` <10"),0); $FEightA_D=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 `creatinine` <10"),0); $HFEightA_D=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 `creatinine` <10"),0); $HFEightS_D=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 `creatinine` <10"),0); $myHF_D =$HFEightA_D + $HFEightS_D; // Merge HF60A and HF80S $TwoHundredNR_D=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 `creatinine` <10"),0); $ELisionHR_D=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'"),0); $ELisionLR_D=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 `creatinine` <10"),0); $ELisionFiftyHRLR_D =$ELisionHR_D + $ELisionLR_D; $ELisionFiftyHR_D=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 `creatinine` <10"),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', 'F160NR',{ role: 'annotation' },'F180NR',{ role: 'annotation' },'HF80\|60',{ role: 'annotation' },'200NR',{ role: 'annotation' },'190HR\|LR',{ role: 'annotation' },'150LR',{ role: 'annotation' }], ['Less 10', <?php echo $FOneSixtyNR; ?>,<?php echo $FOneSixtyNR; ?>, <?php echo $FOneEightyNR; ?>,<?php echo $FOneEightyNR; ?>, <?php echo $myHF; ?>,<?php echo $myHF; ?>, <?php echo $TwoHundredNR; ?>,<?php echo $TwoHundredNR; ?>, <?php echo $ELisionFiftyHRLR; ?>, <?php echo $ELisionFiftyHRLR; ?>, <?php echo $ELisionHR; ?>, <?php echo $ELisionHR; ?>,],//Below 10 ['10-19.9', //<?php echo $FSIX; ?>,<?php echo $FSIX; ?>, // <?php echo $FEight; ?>,<?php echo $FEight; ?>, <?php echo $FOneSixtyNR_B; ?>,<?php echo $FOneSixtyNR_B; ?>, <?php echo $FOneEightyNR_B; ?>,<?php echo $FOneEightyNR_B; ?>, //<?php echo $FSIXTYA; ?>,<?php echo $FSIXTYA; ?>, //<?php echo $FEightA; ?>, <?php echo $FEightA; ?>, <?php echo $myHF_B; ?>,<?php echo $myHF_B; ?>, <?php echo $TwoHundredNR_B; ?>,<?php echo $TwoHundredNR_B; ?>, // <?php echo $ELisionLR; ?>, <?php echo $ELisionLR; ?>, <?php echo $ELisionFiftyHRLR_B; ?>, <?php echo $ELisionFiftyHRLR_B; ?>, <?php echo $ELisionHR_B; ?>, <?php echo $ELisionHR_B; ?>,],//Below 10 ['20-30', //<?php echo $FSIX; ?>,<?php echo $FSIX; ?>, //<?php echo $FEight; ?>,<?php echo $FEight; ?>, <?php echo $FOneSixtyNR_C; ?>,<?php echo $FOneSixtyNR_C; ?>, <?php echo $FOneEightyNR_C; ?>,<?php echo $FOneEightyNR_C; ?>, //<?php echo $FSIXTYA; ?>,<?php echo $FSIXTYA; ?>, //<?php echo $FEightA; ?>, <?php echo $FEightA; ?>, <?php echo $myHF_C; ?>,<?php echo $myHF_C; ?>, <?php echo $TwoHundredNR_C; ?>,<?php echo $TwoHundredNR_C; ?>, // <?php echo $ELisionLR; ?>, <?php echo $ELisionLR; ?>, <?php echo $ELisionFiftyHRLR_C; ?>, <?php echo $ELisionFiftyHRLR_C; ?>, <?php echo $ELisionHR_C; ?>, <?php echo $ELisionHR_C; ?>,],//Below 10 ['Above 30', //<?php echo $FSIX; ?>,<?php echo $FSIX; ?>, //<?php echo $FEight; ?>,<?php echo $FEight; ?>, <?php echo $FOneSixtyNR_D; ?>,<?php echo $FOneSixtyNR_D; ?>, <?php echo $FOneEightyNR_D; ?>,<?php echo $FOneEightyNR_D; ?>, //<?php echo $FSIXTYA; ?>,<?php echo $FSIXTYA; ?>, // <?php echo $FEightA; ?>, <?php echo $FEightA; ?>, <?php echo $myHF_D; ?>,<?php echo $myHF_D; ?>, <?php echo $TwoHundredNR_D; ?>,<?php echo $TwoHundredNR_D; ?>, //<?php echo $ELisionLR; ?>, <?php echo $ELisionLR; ?>, <?php echo $ELisionFiftyHRLR_D; ?>, <?php echo $ELisionFiftyHRLR_D; ?>, <?php echo $ELisionHR_D; ?>, <?php echo $ELisionHR_D; ?>,],//Below 10 ]); var options = { title : 'CREATININE VS DIALYZER USED <?php echo "(".$startDate." - ".$endDate.")";?>', vAxis: {title: ''}, hAxis: {title: ''}, 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: 850px; height: 500px;"></div> </body> </html> <?php } ?>

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