File manager - Edit - /home/autoph/public_html/portal/portal/pod_employee_dashboard.php
Back
<?php $trCountOpen = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pod_training_list` WHERE `status` ='1' AND `grouping`='OPEN' "),0); $trCountInvites = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pod_training_invites` WHERE `status` ='1' AND `employee_id`='$empID' AND `grouping`='INVITATIONAL ' "),0); $totalTrainingCount = $trCountOpen + $trCountInvites; $totalEnrolledTraining = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pod_training_enrollees` WHERE `status` ='1' AND `employee_id`='$empID' "),0); $Comply = ($totalEnrolledTraining / $totalTrainingCount) * 100; $notCOmply = 100 - $Comply; ?> <html> <head> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['TRAINING', 'ATTENDED'], ['COMPLIANCE RATE', <?php echo $Comply; ?>], ['NON-COMPLIANCE', <?php echo $notCOmply; ?>], ]); var options = { title: ' ' }; var chart = new google.visualization.PieChart(document.getElementById('piechart')); chart.draw(data, options); } google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawChart1); function drawChart1() { var data = google.visualization.arrayToDataTable([ ['Task', 'Hours per Day'], ['COMPLETE', <?php echo $complete; ?>], ['INCOMPLETE', <?php echo $incomplete; ?>], ]); var options = { title: 'DATA COMPLETENESS SUMMARY' }; var chart1 = new google.visualization.PieChart(document.getElementById('piechart1')); chart1.draw(data, options); } </script> </head> <body> <div id="piechart" style="width: 800px; height: 320px;border:0px solid red;border-right:0px solid red;padding:0px"> </div> <?php include 'pod_progress_bar_chart.php';?> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings