File manager

File manager - Edit - /home/autoph/public_html/pms_v1/dashboard/globalDashboard.php

Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['das'])){ $userID = $_POST['userID']; $dYear =date("Y"); $dMonth =date("m"); //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); $roleID = userProfileID($userID); $moduleID = 5; if(checkViewAccessM1024($roleID, $moduleID)[0] == 0){ echo " <center><img src='./images/locked_out_icon.png' width='100' style='margin-top:100px'><img></center> "; echo "<h4 class='text-center text-danger align-middle pt-5'> Access Denied </h4>"; echo "<p class='display-5 text-center text-danger'> Sorry, you are not authorized to access this page. <br>Please contact your system support for assistance. <br><br>Thank you! <br><br> </p>"; exit(); } //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== ?> <!DOCTYPE HTML> <html> <head> <script> CanvasJS.addColorSet("greenShades", [//colorSet Array "#FB7B58", // lightred "#52B1B9", "#13B903", //green family "#FD9FCA", // nice blue "#88B809", // light blur green "#F7053C", // bloody red "#AC87F7", // purple "#ef9c5b", // blue light "#17B2C8", // Elephant pink "#FA598F", // Orange light "#FB9CFF", //orange "#FCCF08", //green "#02B4A6", // red pink "#6168FF", // blue violet "#FB5E09", // yellow "#8F5AF8", // purple "#F78F58", //faded green "#29A154", // Orange mild "#FE671B" // ]); CanvasJS.addColorSet("greenShadesB", [//colorSet Array "#17B2C8", // nice blue "#FD9FCA", // Elephant pink "#FA598F", // red pink "#6168FF", // blue violet "#F3EF08", // yellow "#8F5AF8", // purple "#88B809", //faded green "#FB7B58", // lightred "#ef9c5b", //orange "#29A154", //green "#AC87F7", // purple "#0B91F4", // blue light "#13B903", //green family "#FB5E09", // Orange mild "#02B4A6", // light blur green "#F7053C", // bloody red "#F78F58", // Orange light "#FE671B" //sunset ]); //-=-====================================================================================================================== //-=-====================================================================================================================== var chart = new CanvasJS.Chart("chartAa", { theme: "light2", // "light1", "light2", "dark1", "dark2" exportEnabled: false, animationEnabled: true, colorSet: "greenShades", title:{ text: "Company PMS Compliance" }, subtitles: [{ text: "Based on PCP and MAR versus Total no. of Employees " }], axisX: { title: "Company" }, axisY: { title: "Compliance Rating", titleFontColor: "#4F81BC", lineColor: "#4F81BC", labelFontColor: "#4F81BC", tickColor: "#4F81BC", includeZero: true }, axisY2: { title: "MAR Submission", titleFontColor: "#C0504E", lineColor: "#C0504E", labelFontColor: "#C0504E", tickColor: "#C0504E", includeZero: true }, toolTip: { shared: true }, legend: { cursor: "pointer", itemclick: toggleDataSeries }, data: [{ type: "column", name: "PCP Submission", showInLegend: true, yValueFormatString: "#,##0.#00 \"%\"", indexLabel: "{y}", dataPoints: [ <?php $cpm = "SELECT * FROM `vts_company` WHERE `comp_status`='1'"; $qcmp = mysqli_query($conn,$cpm); while($row = mysqli_fetch_array($qcmp)){ $cCode =$row['comp_code']; $cName =$row['comp_name']; $cID =$row['comp_id']; $comEmpTotal = 0; $pcpCount = 0; $pcpCom = 0; $empID = 0; $cEmp = "SELECT COUNT(1) AS comEMP, emp_id FROM `pms_employee_data` WHERE deleted = 0 AND `comp_id` ='$cID'"; $qcEmp = mysqli_query($conn,$cEmp); while($com = mysqli_fetch_array($qcEmp)){ $comEmpTotal = $com['comEMP']; $empID = $com['emp_id']; } $cPCP = "SELECT COUNT(1) AS pcpCount, pcp_headers.id, pcp_headers.year, pcp_headers.employee_id, pcp_headers.deleted AS pcpDeleted, pcp_headers.year, vts_company.comp_id, vts_company.comp_status, pms_employee_data.id, pms_employee_data.comp_id, pms_employee_data.deleted AS empDeleted FROM pcp_headers JOIN pms_employee_data ON pms_employee_data.id = pcp_headers.employee_id JOIN vts_company ON vts_company.comp_id = pms_employee_data.comp_id WHERE pcp_headers.deleted=0 AND vts_company.comp_id=$cID AND pcp_headers.year=$dYear AND pcp_headers.employee_id = pms_employee_data.id"; $qPCP = mysqli_query($conn,$cPCP); while($pcp = mysqli_fetch_array($qPCP)){ $pcpCount = $pcp['pcpCount']; } if($pcpCount > 0){ $pcpCom = (($pcpCount / $comEmpTotal)* 100); }else{ $pcpCom = "0.00"; } $pcpComScore = number_format($pcpCom,3,'.',''); echo "{label: '$cCode', y: $pcpComScore },"; } ?> ] }, { type: "column", name: "MAR Submission", axisYType: "secondary", showInLegend: true, yValueFormatString: "#,##0.#00\"%\"", indexLabel: "{y}", dataPoints: [ <?php $cpm = "SELECT * FROM `vts_company` WHERE `comp_status`='1'"; $qcmp = mysqli_query($conn,$cpm); $marCount=0; $marAVG=0; $marCom=0; while($row = mysqli_fetch_array($qcmp)){ $mCode =$row['comp_code']; $mName =$row['comp_name']; $mID =$row['comp_id']; //================== $cEmp = "SELECT COUNT(1) AS marPMSEmpCount FROM `pms_employee_data` WHERE deleted = 0 AND `comp_id` ='$mID'"; $qcEmp = mysqli_query($conn,$cEmp); while($com = mysqli_fetch_array($qcEmp)){ $empCount = $com['marPMSEmpCount']; } //=================== $mar ="SELECT COUNT(1) AS marCount, vts_company.comp_id AS vtsCompID, vts_company.comp_status, mar_emp_data.comp_id AS marCompID, mar_emp_data.deleted, mar_emp_data.pcp_id FROM mar_emp_data JOIN vts_company ON vts_company.comp_id = mar_emp_data.comp_id WHERE vts_company.comp_status=1 AND mar_emp_data.deleted=0 AND mar_year_data = $dYear AND vts_company.comp_id=$mID"; $qmar = mysqli_query($conn,$mar); while($pcp = mysqli_fetch_array($qmar)){ $marCount = $pcp['marCount']; } if($marCount > 0 && $empCount > 0){ $marCom = (($marCount / $dMonth) / $empCount) * 100; }else{ $marCom = 0; } $marAVG = number_format($marCom ,3,'.',''); echo "{label: '$mCode', y: $marAVG },"; } ?> ] }] }); chart.render(); function toggleDataSeries(e) { if (typeof (e.dataSeries.visible) === "undefined" \|\| e.dataSeries.visible) { e.dataSeries.visible = false; } else { e.dataSeries.visible = true; } e.chart.render(); } //-=-====================================================================================================================== //-=-====================================================================================================================== var chart = new CanvasJS.Chart("chartCa", { animationEnabled: true, theme: "light2", // "light1", "light2", "dark1", "dark2" colorSet: "greenShades", subtitles: [{ text: "Behavioral Area", fontSize:35, fontColor:"black", verticalAlign: "bottom" }], title: { <?php $pFs = "SELECT AVG(`assigned_score`) AS pfcore FROM `pef_evaluation_behavioral` WHERE `time_stamp` LIKE '%$dYear%'"; $qpFs = mysqli_query($conn,$pFs); While($rowPF = mysqli_fetch_array($qpFs)){ $myAvgS = number_format($rowPF['pfcore'],2,'.',''); } if($myAvgS==''){ $myAvgS=0; } echo "text: $myAvgS,"; ?> //text: "90.0%", fontSize: 50, verticalAlign: "center" }, axisY: { fontSize:12, title: "Average Points", suffix: "Pt" }, axisX: { title: "Behavioral Areas" }, legend: { //indexLabel: "{y}%", horizontalAlign: "left", // "center" , "right" verticalAlign: "bottom", // "top" , "bottom" fontSize: 10 }, data: [{ type: "doughnut", TextInside:"00", yValueFormatString: "#,##0.0#\"", LabelFontSize: 10, indexLabel: "{label} {y}", legendMarkerType: "square", showInLegend: false, dataPoints: [ <?php $bpFactor=""; $gBH = "SELECT * FROM `performance_factors` WHERE `deleted` = 0 ORDER BY id DESC"; $qBH = mysqli_query($conn,$gBH); while($bp = mysqli_fetch_array($qBH)){ $myAvgScore = 0; $bpFactor = substr($bp['factors_name'],0,25); $pfID = $bp['id']; //getAveScroe $pF = "SELECT AVG(`assigned_score`) AS pfScore FROM `pef_evaluation_behavioral` WHERE `factor_id`='$pfID' AND `time_stamp` LIKE '%$dYear%'"; $qpF = mysqli_query($conn,$pF); While($rowPF = mysqli_fetch_array($qpF)){ $myAvgScore = $rowPF['pfScore']; } if($myAvgScore==''){ $myAvgScore=0; } echo "{label: '$bpFactor', y: $myAvgScore },"; } ?> ] }] }); chart.render(); //-=-====================================================================================================================== //-=-====================================================================================================================== var chart = new CanvasJS.Chart("chartCb", { animationEnabled: true, theme: "light2", // "light1", "light2", "dark1", "dark2" colorSet: "greenShades", subtitles: [{ text: "Employee Assessment based on PEF Data", fontSize:35, fontColor:"black", verticalAlign: "top" }], title: { <?php // $pFs = "SELECT AVG(`assigned_score`) AS pfcore FROM `pef_evaluation_behavioral` WHERE `time_stamp` LIKE '%$dYear%'"; // $qpFs = mysqli_query($conn,$pFs); // While($rowPF = mysqli_fetch_array($qpFs)){ // $myAvgS = number_format($rowPF['pfcore'],2,'.',''); // } // echo "text: $myAvgS,"; ?> //text: "90.0%", //fontSize: 70, //verticalAlign: "center" }, legend: { horizontalAlign: "left", // "center" , "right" verticalAlign: "bottom", // "top" , "bottom" fontSize: 12 }, axisY: { title: "Employee Count" //suffix: "" }, axisX: { labelMaxWidth: 100, labelTextAlign: "right",// Change it to "left, "center" title: "" }, data: [{ type: "column", yValueFormatString: "#,##0.0#", indexLabelFontSize: 14, indexLabel: "{y}", showInLegend:true, dataPoints: [ <?php $assFactor=""; $eBH = "SELECT * FROM `pms_employee_assessment` WHERE `deleted` = 0 ORDER BY id ASC"; $eqBH = mysqli_query($conn,$eBH); while($ass = mysqli_fetch_array($eqBH)){ $assFactor = substr($ass['pms_em_assessment'],0,25); $pfID = $ass['id']; switch($pfID){ case 1://very suitable $pF = "SELECT SUM(`part_three_suitability`) AS vSuitable FROM `pef_evaluation_data` WHERE `part_three_suitability`='1' AND deleted=0 AND `rated_date` LIKE '%$dYear%'"; $qpF = mysqli_query($conn,$pF); While($rowPF = mysqli_fetch_array($qpF)){ $vSuitable = $rowPF['vSuitable']; } break; case 2://suitable $pF = "SELECT SUM(`part_three_suitability`) AS vSuitable FROM `pef_evaluation_data` WHERE `part_three_suitability`='2' AND deleted=0 AND `rated_date` LIKE '%$dYear%'"; $qpF = mysqli_query($conn,$pF); While($rowPF = mysqli_fetch_array($qpF)){ $vSuitable = $rowPF['vSuitable']; } break; case 3://not suitable t $pF = "SELECT SUM(`part_three_suitability`) AS vSuitable FROM `pef_evaluation_data` WHERE `part_three_suitability`='3' AND deleted=0 AND `rated_date` LIKE '%$dYear%'"; $qpF = mysqli_query($conn,$pF); While($rowPF = mysqli_fetch_array($qpF)){ $vSuitable = $rowPF['vSuitable']; } break; case 4: // competency not utilize $pF = "SELECT SUM(`part_three_suitability`) AS vSuitable FROM `pef_evaluation_data` WHERE `part_three_competency`!='1' AND deleted=0 AND `rated_date` LIKE '%$dYear%'"; $qpF = mysqli_query($conn,$pF); While($rowPF = mysqli_fetch_array($qpF)){ $vSuitable = $rowPF['vSuitable']; } break; case 5: // just right to the position $pF = "SELECT SUM(`part_three_suitability`) AS vSuitable FROM `pef_evaluation_data` WHERE `part_three_potential`='1' AND deleted=0 AND `rated_date` LIKE '%$dYear%'"; $qpF = mysqli_query($conn,$pF); While($rowPF = mysqli_fetch_array($qpF)){ $vSuitable = $rowPF['vSuitable']; } break; case 6: // moderate potential $pF = "SELECT SUM(`part_three_suitability`) AS vSuitable FROM `pef_evaluation_data` WHERE `part_three_potential`='2' AND deleted=0 AND `rated_date` LIKE '%$dYear%'"; $qpF = mysqli_query($conn,$pF); While($rowPF = mysqli_fetch_array($qpF)){ $vSuitable = $rowPF['vSuitable']; } break; case 7: // promotable employee $pF = "SELECT SUM(`part_three_suitability`) AS vSuitable FROM `pef_evaluation_data` WHERE `part_three_potential`='3' AND deleted=0 AND `rated_date` LIKE '%$dYear%'"; $qpF = mysqli_query($conn,$pF); While($rowPF = mysqli_fetch_array($qpF)){ $vSuitable = $rowPF['vSuitable']; } break; } if($vSuitable == ''){ $vSuitable = 0; } echo "{label: '$assFactor', y: $vSuitable },"; } ?> ] }] }); chart.render(); //-=-====================================================================================================================== //-=-====================================================================================================================== var chart = new CanvasJS.Chart("chartBa", { exportEnabled: false, animationEnabled: true, theme: "light2", // "light1", "light2", "dark1", "dark2" colorSet: "greenShades", title: { //fontSize:24, text: "MAR Monthly Submission Rate - <?php echo $dYear;?>" }, axisY: { title: "Achievement Rate (%)", suffix: " %" }, axisX: { title: "Months" }, data: [{ type: "line", yValueFormatString: "#,##0.0#\" %\"", indexLabel: "{y}", dataPoints: [ <?php //================== $cEmp = "SELECT COUNT(1) AS marPMSEmpCount FROM `pms_employee_data` WHERE deleted = 0"; $qcEmp = mysqli_query($conn,$cEmp); while($com = mysqli_fetch_array($qcEmp)){ $empCount = $com['marPMSEmpCount']; } //=================== for ($x = 1; $x <=12; $x++){ $monthlyMARCount = 0; switch($x){ case '1': $months = "Jan"; break; case '2': $months = "Feb"; break; case '3': $months = "Mar"; break; case '4': $months = "Apr"; break; case '5': $months = "May"; break; case '6': $months = "Jun"; break; case '7': $months = "Jul"; break; case '8': $months = "Aug"; break; case '9': $months = "Sep"; break; case '10': $months = "Oct"; break; case '11': $months = "Nov"; break; case '12': $months = "Dec"; break; } $marSC = "SELECT COUNT(1) AS myMARCount FROM `mar_emp_data` WHERE`mar_month_data`='$x' AND deleted = 0 AND `mar_year_data`='$dYear'"; $qScores = mysqli_query($conn,$marSC); while($sc = mysqli_fetch_array($qScores)){ $monthlyMARCount = $sc['myMARCount']; } if($monthlyMARCount > 0){ $marSubRate =(($monthlyMARCount / $empCount) * 100); }else{ $marSubRate=0; } //$myMonthlySC = number_format($myMonthly,3,'.',''); echo "{ label: '".$months."', y: $marSubRate },"; } ?> ] }] }); chart.render(); //-=-====================================================================================================================== function loadDataDashbaord(){ var userID = $("#userID").val(); ShowUploadBar(); $.ajax({ url: "./dashboard/globalDashboard.php", type: "POST", async: true, data: { "userID":userID, "das": 1 }, success: function(d){ $("#content").html(d); //$("#sidebar").toggleClass("active"); //chart.render(); ShowUploadBar(); } }) } //-=-====================================================================================================================== </script> </head> <body> <h2>Dashboard - Autohub Wide</h2> </div> <h6 class="text-success bold text-right p-0" style='cursor:pointer;padding-right:20px;' onclick="javascript:loadDataDashbaord();"><i class="fa fa-refresh">   Reload</i></h6> <div class="wrapper mt-3 p-1 shadow-sm float:left bg-white h-auto"> <div class="row fluid m-0 w-100 bg-white"> <div id='chartAa' class='wrapper w-100' style='box-shadow:0px 0px 0px lightgray;height:400px;margin-bottom:50px;margin-top:50px'> </div> <div id='chartBa' class='wrapper w-100' style='box-shadow:0px 0px 0px lightgray;height:400px;margin-bottom:50px;margin-top:50px'> </div> <div id='chartCa' class='wrapper w-100' style='box-shadow:0px 0px 0px lightgray;height:400px;margin-bottom:50px;margin-top:50px'> </div> <div id='chartCb' class='wrapper w-100' style='box-shadow:0px 0px 0px lightgray;height:400px;margin-bottom:50px;margin-top:50px'> </div> </div> </div> </body> </html> <!-- style='box-shadow:8px 8px 8px lightgray;height:300px' --> <?php $conn->close(); } ?>

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