File manager

File manager - Edit - /home/autoph/public_html/portal/includes/chart/dialyzer_usage.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='duz'> <input type='hidden' name='subView' value='gdat'> <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;'> </form> <?php } if(isset($_GET['startDate'])){ $startDate = $_GET['startDate']; $endDate = $_GET['endDate']; $fSix = mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='68' AND `branch_code`='$compCode' AND `dialyzer_status`='0' AND `date_issue` BETWEEN '$startDate' AND '$endDate'"),0); $fEight = mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='69' AND `branch_code`='$compCode' AND `dialyzer_status`='0'"),0); $fOneSixtyNR =mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='70' AND `branch_code`='$compCode' AND `dialyzer_status`='0'"),0); $fOneEightNR =mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='71' AND `branch_code`='$compCode' AND `dialyzer_status` = '0'"),0); $fSixtyA =mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='72' AND `branch_code`='$compCode' AND `dialyzer_status`='0'"),0); $fEightA =mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='73' AND `branch_code`='$compCode' AND `dialyzer_status`='0'"),0); $hfEightA =mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='74' AND `branch_code`='$compCode' AND `dialyzer_status`='0'"),0); $hfSixtyS =mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='75' AND `branch_code`='$compCode' AND `dialyzer_status`='Expired'"),0); $fTwoHundredNR = mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='283' AND `branch_code`='$compCode' AND `dialyzer_status`='0'"),0); $fOneNinetyNR = mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='293' AND `branch_code`='$compCode' AND `dialyzer_status`='0'"),0); $fOneFiftyNR = mysql_result(mysql_query("SELECT COUNT('trans_id') FROM `patient_dialyzer_issuance` WHERE `dialyzer_id`='294' AND `branch_code`='$compCode' AND `dialyzer_status`='0'"),0); $intrajugular = mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `access`='INTRAJUGULAR' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $Femoral = mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `access`='FEMORAL' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $Subclavian =mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `access`='SUBCLAVIAN' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $AVG =mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `access`='AVG' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $AVF =mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `access`='AVF' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $total=$intrajugular + $Femoral + $Subclavian + $AVG + $AVF; ?> <html> <head> <script type="text/javascript" src="http://localhost/nephro/script/chartScript/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['bar']}); google.charts.setOnLoadCallback(drawStuff); function drawStuff() { var data = new google.visualization.arrayToDataTable([ ['DIALYZER UTILIZATION', 'UTILIZATION'], ["F6", <?php echo $fSix; ?>], ["F8", <?php echo $fEight; ?>], ["F160NR", <?php echo $fOneSixtyNR; ?>], ["F180NR", <?php echo $fOneEightNR; ?>], ['F60A', <?php echo $fSixtyA; ?>], ['F80A', <?php echo $fEightA; ?>], ['HF80A', <?php echo $hfEightA; ?>], ['HF60S', <?php echo $hfSixtyS; ?>], ['HF200', <?php echo $fTwoHundredNR; ?>], ['HF200', <?php echo $fOneNinetyNR; ?>], ['HF200', <?php echo $fOneFiftyNR; ?>], ]); var options = { title: 'DIALYZER USAGE SUMMARY', width: 600, legend: { position: 'none' }, chart: { title: 'DIALYZER UTILIZATION', subtitle: 'Based on Patient Records' }, bars: 'horizontal', // Required for Material Bar Charts. axes: { x: { 0: { side: 'top', label: 'ACTUAL COUNT'} // Top x-axis. } }, bar: { groupWidth: "90%" } }; var chart = new google.charts.Bar(document.getElementById('top_x_div')); chart.draw(data, options); }; </script> </head> <body> <div id="top_x_div" style="width: 600px; height:450px;"></div> </body> </html> <?php } ?>

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