File manager

File manager - Edit - /home/autoph/public_html/tasks/scorecard.tar

Back
scoreCardUnit_print.php��0000644��00000044574�15025026344�0011255 0��ustar�00��<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_GET['searchID'])){ $searchID = $_POST['searchID']; $empID = $_POST['empID']; //employee number not record ID $rptYear = $_POST['rptYear']; $rptSemester = $_POST['rptSemester']; $empName = $_POST['empName']; $empPosition = $_POST['empPosition']; //INITIALIZING VARIABLES $janCount = 0; $jan = 0; $janT = 0; $janTotal=0; $janTotal=0; $febTotalT =0; $febTotal=0; $feb =0; $febT =0; $febCount =0; $marTotalT=0; $marTotal=0; $mar =0; $marT =0; $marCount =0; $aprTotalT=0; $aprTotal=0; $apr =0; $aprT =0; $aprCount =0; $mayTotalT=0; $mayTotal=0; $may =0; $mayT =0; $mayCount =0; $junTotalT=0; $junTotal=0; $jun =0; $junT =0; $junCount =0; $julTotalT=0; $julTotal=0; $jul =0; $julT =0; $julCount =0; $augTotalT=0; $augTotal=0; $aug =0; $augT =0; $augCount =0; $sepTotalT=0; $sepTotal=0; $sep =0; $sepT =0; $sepCount =0; $octTotalT=0; $octTotal=0; $oct =0; $octT =0; $octCount =0; $novTotalT=0; $novTotal=0; $nov =0; $novT =0; $novCount =0; $decTotalT=0; $decTotal=0; $dec =0; $decT =0; $decCount =0; //QUERY PCP HEADER BASED ON SEARCH DATA $getPCPHeaderID = "SELECT * FROM `pcp_headers` WHERE `employee_id`='$searchID' AND `year`='$rptYear' AND `deleted`=0 LIMIT 1"; $qPCP = mysqli_query($conn,$getPCPHeaderID); $ckhResult = mysqli_num_rows($qPCP); if($ckhResult > 0){ while($prow = mysqli_fetch_array($qPCP)){ $pcpID = $prow['id']; } //get Formula for later use $pi = "SELECT * FROM `pms_formula` WHERE deleted = 0 LIMIT 1"; $qPi = mysqli_query($conn,$pi); while($row = mysqli_fetch_array($qPi)){ $multiplierPTS = $row['multiplier_pts']; $plusFactorPTS = $row['plus_factor_pts']; } }else{ exit(); } } ?> <!DOCTYPE HTML> <html> <head> <script> var idVarA = setInterval(() => { loadChartA(); }, 800); function StopLoadGraph() { clearInterval(idVarA); } function loadChartA(){ StopLoadGraph(); clearInterval(idVarA); CanvasJS.addColorSet("greenShades", [//colorSet Array "#FB7B58", // lightred "#13B903", //green family "#FB5E09", // Orange mild "#17B2C8", // nice blue "#02B4A6", // light blur green "#F7053C", // bloody red "#AC87F7", // purple "#0B91F4", // blue light "#FD9FCA", // Elephant pink "#F78F58", // Orange light "#ef9c5b", //orange "#29A154", //green "#FA598F", // red pink "#6168FF", // blue violet "#F3EF08", // yellow "#8F5AF8", // purple "#88B809", //faded green "#FE671B" //sunset ]); 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 options = { animationEnabled: true, theme: "light1", colorSet: "greenShades", title: { text: "Performance Rating by KRA - <?php echo $rptYear;?> " }, axisY: { title: "Average KRA Scores", suffix: "%" }, axisX: { title: "Employee's KRA" }, data: [ { // Change type to "doughnut", "line", "splineArea", etc. type: "column", indexLabel: "{y}", //showInLegend: true, dataPoints: [ <?php //QUERY EMPLOYEE KRA TO BE LOADED IN CHART A $chartKRA = "SELECT * FROM `pcp_employee_data` WHERE `pcp_header_id`='$pcpID' AND `deleted`=0 GROUP BY `pcp_kra_id` ORDER BY `id` ASC"; $cKRA = mysqli_query($conn,$chartKRA); while($row = mysqli_fetch_array($cKRA)){ $kraID =$row['pcp_kra_id']; $actKRA = "SELECT * FROM `kra_employee_tbl` WHERE `id`='$kraID'"; $qAct = mysqli_query($conn,$actKRA); while($krow = mysqli_fetch_array($qAct)){ $kCode = $krow['kra_code']; } $kScores = "SELECT AVG(`my_score`) AS myScore FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `pcp_id`='$pcpID' AND `mar_year_data`='$rptYear' AND `deleted`=0 AND `emp_rec_id`='$searchID' GROUP BY `kra_id`"; $qScores = mysqli_query($conn,$kScores); while($sRow = mysqli_fetch_array($qScores)){ $score = $sRow['myScore']; } $scores = number_format($score,3,'.',''); echo "{ label: '".$kCode."', y: ".$scores." },"; } ?> ] } ] }; $("#MyChartA").CanvasJSChart(options); //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ var chart = new CanvasJS.Chart("MyChartB", { animationEnabled: true, theme: "greenShadesB", // "light1", "light2", "dark1", "dark2" colorSet: "greenShades", title: { //fontSize:22, text: "Monthly Performance - <?php echo $rptYear;?>" }, axisY: { title: "Average Monthly Scores", labelAutoFit: true, //true by default. //fontSize: 14, suffix: "%" }, axisX: { //fontSize: 18, //labelAngle: 90, title: "Months" }, data: [{ type: "line", indexLabel: "{y}", //showInLegend: true, //yValueFormatString: "#,##0.0#\"%\"", markerType: "circle", yValueFormatString: "", labelWrap: true, //labelMaxWidth: 70, interval: 1, dataPoints: [ <?php for ($x = 1; $x <=12; $x++){ $myMonthly = 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 AVG(`my_score`) AS myMScore FROM `mar_emp_data` WHERE `emp_rec_id`='$searchID' AND `mar_month_data`='$x' AND `mar_year_data`='$rptYear' AND deleted = 0 GROUP BY `mar_month_data`"; $qScores = mysqli_query($conn,$marSC); while($sc = mysqli_fetch_array($qScores)){ $myMonthly = number_format($sc['myMScore'],3,'.',''); } //$myMonthlySC = number_format($myMonthly,3,'.',''); echo "{ label: '".$months."', y: $myMonthly },"; } ?> ] }] }); chart.render(); //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ var chart = new CanvasJS.Chart("MyChartC", { animationEnabled: true, theme: "greenShadesB", // "light1", "light2", "dark1", "dark2" colorSet: "greenShades", title:{ text: "Target vs Actual" }, axisX:{ valueFormatString: "DD MMM", crosshair: { enabled: true, snapToDataPoint: true } }, axisY: { title: "Unit KRA Target vs Actual", includeZero: true, crosshair: { enabled: true } }, toolTip:{ shared:true }, legend:{ cursor:"pointer", verticalAlign: "bottom", horizontalAlign: "left", dockInsidePlotArea: true, itemclick: toogleDataSeries }, data: [{ type: "line", showInLegend: true, name: "Actual", indexLabel: "{y}", markerType: "square", xValueFormatString: "DD MMM, YYYY", color: "#F08080", showInLegend: true, dataPoints: [ <?php //QUERY EMPLOYEE KRA TO BE LOADED IN CHART A $chartKRA = "SELECT mar_emp_data.id, kra_unit_tbl.id AS unitKRAID, kra_unit_tbl.kra_code, kra_unit_tbl.unit_id AS unitKRAID, kra_unit_tbl.deleted AS UnitDeleted, kra_employee_tbl.id AS empKRAID, kra_employee_tbl.weight AS empKRAWeight, kra_employee_tbl.unit_kra_id AS kraUnitID, mar_emp_data.kra_id, mar_emp_data.mar_actual, mar_emp_data.my_score, mar_emp_data.mar_target, mar_emp_data.mar_variance_no, mar_emp_data.mar_numerical_rating, mar_emp_data.deleted, mar_emp_data.emp_rec_id, mar_emp_data.mar_year_data, mar_emp_data.mar_month_data, mar_emp_data.mar_semester_data, mar_emp_data.unit_id, mar_emp_data.id AS marID FROM kra_unit_tbl JOIN kra_employee_tbl ON kra_employee_tbl.unit_kra_id = kra_unit_tbl.id JOIN mar_emp_data ON mar_emp_data.kra_id = kra_employee_tbl.id WHERE kra_unit_tbl.unit_id = mar_emp_data.unit_id AND kra_employee_tbl.unit_kra_id =kra_unit_tbl.id AND kra_unit_tbl.deleted=0 AND mar_emp_data.mar_year_data=$rptYear AND mar_emp_data.emp_rec_id='$searchID'"; $cKRA = mysqli_query($conn,$chartKRA); while($row = mysqli_fetch_array($cKRA)){ $target = 0; $x = $row['mar_month_data']; $target = str_replace("%","",$row['mar_target']); switch($x){ case '1': $janCount = $janCount + 1; $jan = ($jan + $row['my_score']) / $janCount; $janT = ($janT + $target) / $janCount; $janTotalT = number_format($janT,3,'.',''); $janTotal = number_format($jan,3,'.',''); break; case '2': $febCount = $febCount + 1; $feb = ($feb + $row['my_score']) / $febCount; $febTotal = number_format($feb,3,'.',''); $febT = ($febT + $target) / $febCount; $febTotalT = number_format($febT,3,'.',''); break; case '3': $marCount = $marCount + 1; $mar = ($mar + $row['my_score']) / $marCount; $marTotal = number_format($mar,3,'.',''); $marT = ($marT + $target) / $marCount; $marTotalT = number_format($marT,3,'.',''); break; case '4': $aprCount = $aprCount + 1; $apr = ($apr + $row['my_score']) / $aprCount; $aprTotal = number_format($apr,3,'.',''); $aprT = ($aprT + $target) / $aprCount; $aprTotalT = number_format($aprT,3,'.',''); break; case '5': $mayCount = $mayCount + 1; $may = ($may + $row['my_score']) / $mayCount; $mayTotal = number_format($may,3,'.',''); $mayT = ($mayT + $target) / $mayCount; $mayTotalT = number_format($mayT,3,'.',''); break; case '6': $junCount = $junCount + 1; $jun = ($jun + $row['my_score']) / $junCount; $junTotal = number_format($jun,3,'.',''); $junT = ($junT + $target) / $junCount; $junTotalT = number_format($junT,3,'.',''); break; case '7': $julCount = $julCount + 1; $jul = ($jul + $row['my_score']) / $julCount; $julTotal = number_format($jul,3,'.',''); $julT = ($julT + $target) / $julCount; $julTotalT = number_format($julT,3,'.',''); break; case '8': $augCount = $augCount + 1; $aug = ($aug + $row['my_score']) / $augCount; $augTotal = number_format($aug,3,'.',''); $augT = ($augT + $target) / $augCount; $augTotalT = number_format($augT,3,'.',''); break; case '9': $sepCount = $sepCount + 1; $sep = ($sep + $row['my_score']) / $sepCount; $sepTotal = number_format($sep,3,'.',''); $sepT = ($sepT + $target) / $sepCount; $sepTotalT = number_format($sepT,3,'.',''); break; case '10': $octCount = $octCount + 1; $oct = ($oct + $row['my_score']) / $octCount; $octTotal = number_format($oct,3,'.',''); $octT = ($octT + $target) / $octCount; $octTotalT = number_format($octT,3,'.',''); break; case '11': $novCount = $novCount + 1; $nov = ($nov + $row['my_score']) / $novCount; $novTotal = number_format($nov,3,'.',''); $novT = ($novT + $target) / $novCount; $novTotalT = number_format($novT,3,'.',''); break; case '12': $decCount = $decCount + 1; $dec = ($dec + $row['my_score']) / $decCount; $decTotal = number_format($dec,3,'.',''); $decT = ($decT + $target) / $decCount; $decTotalT = number_format($decT,3,'.',''); break; } } echo "{ label: 'Jan', y: ".$janTotal." },"; echo "{ label: 'Feb', y: ".$febTotal." },"; echo "{ label: 'Mar', y: ".$marTotal." },"; echo "{ label: 'Apr', y: ".$aprTotal." },"; echo "{ label: 'May', y: ".$mayTotal." },"; echo "{ label: 'Jun', y: ".$junTotal." },"; echo "{ label: 'Jul', y: ".$julTotal." },"; echo "{ label: 'Aug', y: ".$augTotal." },"; echo "{ label: 'Sep', y: ".$sepTotal." },"; echo "{ label: 'Oct', y: ".$octTotal." },"; echo "{ label: 'Nov', y: ".$novTotal." },"; echo "{ label: 'Dec', y: ".$decTotal." },"; ?> ] }, { type: "line", showInLegend: true, name: "Target", lineDashType: "dash", indexLabel: "{y}", dataPoints: [ <?php echo "{ label: 'Jan', y: ".$janTotalT." },"; echo "{ label: 'Feb', y: ".$febTotalT." },"; echo "{ label: 'Mar', y: ".$marTotalT." },"; echo "{ label: 'Apr', y: ".$aprTotalT." },"; echo "{ label: 'May', y: ".$mayTotalT." },"; echo "{ label: 'Jun', y: ".$junTotalT." },"; echo "{ label: 'Jul', y: ".$julTotalT." },"; echo "{ label: 'Aug', y: ".$augTotalT." },"; echo "{ label: 'Sep', y: ".$sepTotalT." },"; echo "{ label: 'Oct', y: ".$octTotalT." },"; echo "{ label: 'Nov', y: ".$novTotalT." },"; echo "{ label: 'Dec', y: ".$decTotalT." },"; ?> ] }] }); chart.render(); function toogleDataSeries(e){ if (typeof(e.dataSeries.visible) === "undefined" \|\| e.dataSeries.visible) { e.dataSeries.visible = false; } else{ e.dataSeries.visible = true; } chart.render(); } } //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ </script> </head> <body> <center> <div id="MyChartA" class="col-xl-6 col-lg-12 col-md-6 col-sm-12 p-2 mt-5" style="float:left;height: 360px;margin-bottom:50px"></div> <div id="MyChartB" class="col-xl-6 col-lg-12 col-md-6 col-sm-12 p-2 mt-5" style="float:left;height: 360px;margin-bottom:50px"></div> <div id="MyChartC" class="col-xl-12 col-lg-12 col-md-12 col-sm-12 p-2 mt-5" style="float:left;height: 360px;margin-bottom:50px"></div> </center><!-- <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script type="text/javascript" src="https://cdn.canvasjs.com/jquery.canvasjs.min.js"></script> --> </body> </html> ��scoreCardEmp.php��0000644��00000030437�15025026344�0007634 0��ustar�00��<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['scr'])){ $titol = $_POST['titol']; $userID = $_POST['userID']; //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($userID); $moduleID = 44; $add =checkViewAccessM1024($roleID, $moduleID)[1]; $edit =checkViewAccessM1024($roleID, $moduleID)[2]; $delete =checkViewAccessM1024($roleID, $moduleID)[3]; $print =checkViewAccessM1024($roleID, $moduleID)[4]; $download =checkViewAccessM1024($roleID, $moduleID)[5]; echo "<input type='hidden' id='addAccess' value='$add'>"; echo "<input type='hidden' id='editAccess' value='$edit'>"; echo "<input type='hidden' id='deleteAccess' value='$delete'>"; echo "<input type='hidden' id='printAccess' value='$print'>"; echo "<input type='hidden' id='downloadAccess' value='$download'>"; if($add == 1){$addButton = '';}else{$addButton='Disabled';} if($edit == 1){$editButton = '';}else{$editButton='Disabled';} if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';} if($print == 1){$printButton = '';}else{$printButton='Disabled';} if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';} 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 ============================================================================================== //============================================================================================================== ?> <input type='hidden' id='searchID' placeholder='searchID'> <div class="pageSearchHeader bg-white p-1 pt-1 w-100"> <h5 class='p-1 text-left'>Search Employees:</h5> <input class="form-control p-3 border-info" type="search" placeholder="Search Employees..." id="searchText" onKeyUp="searchEmp()" style="border-radius:3px 0px 0px 3px;margin:0px;min-width:250px;width:75%;float:left"> <button type="button" class="btn btn-info text-light" onclick="searchEmp()" style="float:rigth;width:20%;margin-left:0px;border-radius:0px 3px 3px 0px;height:40px">Search</button> </div> <div id='selectedRecord' class='content w-100' style='height:220px;overflow:auto;border:1px solid lightgray'> </div> <!--MODAL FORM VIEWING OF PCP--> <!-- The Modal --> <div class="content" id="kraModal"> <div class="modal-dialog modal-xl"> <!-- Modal Header --><h5 style='text-align:left;color:#535356;padding:3px'><?php echo $titol;?> </h5> <div class="modal-content"> <div class="modal-header"> <h5 id='rptTitle' class="modal-title">Filter Report</h5> </div> <!-- Modal body --> <form action='pdfViewer/score_cardEmployeeLevel.php' method='GET' target='_Blank'> <input type='hidden' id='s' name='s' value='<?php echo $userID;?>'> <div class="modal-body p-1" style="border:0px solid blue;overflow:auto"> <div class="form-group col-lg-2 col-md-12 float-left"> <label for="compName">Emp.ID:</label> <input type="text" class="form-control radius-sm" id="e" name="e"> </div> <div class="form-group col-lg-4 col-md-12 float-left"> <label for="compName">Employee Name:</label> <input type="text" class="form-control radius-sm" id="n" name="n"> </div> <div class="form-group col-lg-6 col-md-12 float-left"> <label for="compName">Position:</label> <input type="text" class="form-control radius-sm" id="t" name="t"> </div> <div class="form-group col-lg-2 col-md-12 float-left"> <label for="compName">Year:</label> <input type="number" max=9999 min=2020 value='<?php echo date('Y');;?>' class="form-control radius-sm" id="ys" name="ye"> </div> <div class="form-group col-lg-4 col-md-12 float-left"> <label for="compName">Period</label> <select name='sm' id='sm' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option value='1'>1st Semester</option> <option value='2'>2nd Semester</option> <option value='0' selected>Yearly</option> </select> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <input type='submit' id='loadReport' class="btn btn-danger pl-4 pr-4 m-0 fa fa-plus" style="display:none;height:40px"> <!-- <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> --> </div> </form> </div> </div> </div> <!-- The Modal PEF FORM--> <!-- The Modal --> <div class="modal" data-bs-toggle="modal" data-bs-target="#staticBackdrop" id="vewRPTPage" style='height:100%;width:100%;'> <div class="modal-fullscreen m-md-0 m-lg-0 h-100"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 id='rptViewTitle' class="modal-title">Employee Performance Report</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <h6 class="text-success bold border text-right p-3" style='cursor:pointer;padding-right:20px;' onclick="javascript:loadData();"><i class="fa fa-refresh">   Refresh</i></h6> <!-- Modal body --> <div class="modal-body-scrollable w-100 h-auto"> <div id='chartA' class="form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 float-left h-50 p-3" style='background:white'> </div> <div id='empKRAList' class="form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 float-left h-100 p-10 text-center" style='overflow:auto'> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button type="button" class="btn btn-success m-0" onclick="javascript:loadData();" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-refresh">   Refresh</i></button> <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!-- <div class="d-flex justify-content-center"> <div class="spinner-border" role="status"> <span class="visually-hidden"></span> </div> </div> --> <?php } $conn->close(); ?> <script> $(document).ready(function() { //alert('arnel'); searchEmp(); }); function cloadChartA(){ var searchID = $("#searchID").val(); var empID = $("#empID").val(); var rptYear = $("#rptYear").val(); var rptSemester = $("#rptSemester").val(); var empName = $("#empName").val(); var empPosition = $("#empPosition").val(); ShowUploadBar(); $.ajax({ url: "./reports/chartA.php", type: "POST", async: true, data: { "searchID":searchID, "empID":empID, "rptYear":rptYear, "rptSemester":rptSemester, "empName":empName, "empPosition":empPosition, "lDat": 1 }, success: function(d){ $("#chartA").html(d); ShowUploadBar(); cloadChartB(); } }) } function getInfo(row) { var x=row.cells; var myX = x[0].innerHTML; if(myX > 0){ document.getElementById("loadReport").style.display = "block"; }else{ document.getElementById("loadReport").style.display = "none"; } document.getElementById("searchID").value = x[0].innerHTML; document.getElementById("e").value = x[0].innerHTML; document.getElementById("n").value = x[3].innerHTML; document.getElementById("t").value = x[4].innerHTML; document.getElementById("rptViewTitle").innerHTML = "Performance Review Report: [" + x[2].innerHTML + "]"; } function loadData(){ var searchID = $("#searchID").val(); var empID = $("#empID").val(); var rptYear = $("#rptYear").val(); var rptSemester = $("#rptSemester").val(); var empName = $("#empName").val(); var empPosition = $("#empPosition").val(); if(searchID==''){ Swal.fire({ icon: 'error', title: 'Invalid', text: 'No employee name has been selected.' }) return false; } //alert(searchID); ShowUploadBar(); $.ajax({ url: "./reports/loadDataReportA.php", type: "POST", async:true, data:{ "rptYear":rptYear, "rptSemester":rptSemester, "empName":empName, "empPosition":empPosition, "empID":empID, "searchID":searchID, "lDat":1 }, success: function(x){ $("#empKRAList").html(x); ShowUploadBar(); cloadChartA(); } }) } function searchEmp(){ var searchText = $("#searchText").val(); var userID = $("#userID").val(); //alert(searchText); //return false; ShowUploadBar(); $.ajax({ url: "./reports/Score_searchEmployee.php", type: "POST", async: true, data: { "searchText":searchText, "userID":userID, "searchSec": 1 }, success: function(d){ $("#selectedRecord").html(d); ShowUploadBar(); } }) } </script> <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script type="text/javascript" src="https://cdn.canvasjs.com/jquery.canvasjs.min.js"></script>��employeeScoreCard.php��0000644��00000031330�15025026344�0010663 0��ustar�00��<link rel="stylesheet" type="text/css" href="./css/sidebarmain.css?v=<?php echo time(); ?>"/> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700,800,900"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"> <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); include_once("../functions/menuScript.php"); include ("../pages/loadergif.php"); //error_reporting(0); $roleID=0; if(isset($_GET['s'])){ $empID = $_GET['e']; $sourceID = $_GET['s']; $sem = $_GET['sm']; $nme = $_GET['n']; $rptYear = $_GET['ye']; $fN = explode(" ", $nme); $fName = $fN[0]; $lName = $fN[1]; //START OF CHECKPOINT=============================================================================== //START OF CHECKPOINT=============================================================================== //==========CHECK IF USER EXIST IN THE RECORD AND MATCH ALL INFORMATION IN THE LICNK ========= $chkUser = "SELECT * FROM `pms_employee_data` WHERE `id`='$sourceID' AND `deleted` = 0"; $qCU=mysqli_query($conn,$chkUser); $countUser = mysqli_num_rows($qCU); if($countUser == 0){ echo " <center><img src='../images/locked_out_icon.png' width='100' style='margin-top:100px'><img>"; 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></center> "; exit(); }else{ while($uow=mysqli_fetch_array($qCU)){ $uowaccStat = $uow['account_status']; $uowdeleted = $uow['deleted']; } } if($uowaccStat == 0){ echo " <center><img src='../images/locked_out_icon.png' width='100' style='margin-top:100px'><img>"; 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></center> "; exit(); } if($uowdeleted == 1){ echo " <center><img src='../images/locked_out_icon.png' width='100' style='margin-top:100px'><img>"; 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></center> "; exit(); } //==========CHECK IF EMPLOYEE EXIST IN RECORD AND MATCH ALL INFORMATION IN THE LICNK ========= $chkPoint = "SELECT `last_name`, `first_name`,`account_status`,`deleted` FROM `pms_employee_data` WHERE `id`='$empID'"; $qChk=mysqli_query($conn,$chkPoint); $ckhRow = mysqli_num_rows($qChk); If($ckhRow > 0){ while($row=mysqli_fetch_array($qChk)){ $lastName = $row['last_name']; $firstName = $row['first_name']; $accStat = $row['account_status']; $deleted = $row['deleted']; } }else{ echo " <center><img src='../images/locked_out_icon.png' width='100' style='margin-top:100px'><img>"; 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></center> "; exit(); } if($lName != $lastName){ echo " <center><img src='../images/locked_out_icon.png' width='100' style='margin-top:100px'><img>"; 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></center> "; exit(); } if($fName != $firstName){ echo " <center><img src='../images/locked_out_icon.png' width='100' style='margin-top:100px'><img>"; 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></center> "; exit(); } //END OF CHECKPOINT=============================================================================== //END OF CHECKPOINT=============================================================================== ?> <center> <div class='col text-left' style='margin-top:80px;width:80%'> <img src='../images/ahg_logo.png',10,5, 25,10></img> <h5 class='text-dark pb-4 mt-3'>SCORECARD - <?php echo getEmployeeEmpInformationB($empID)[3]. " " .getEmployeeEmpInformationB($empID)[2];?></h5> </div> <table style="width:80%;border-collapse:collapse"> <tbody> <thead> <th class="border p-2 bg-dark text-light">KRA DESCIPRTION</th> <th class="border p-2 bg-dark text-light text-center">WEIGHT</th> <th class="border p-2 bg-dark text-light">KPI DESCRIPTION</th> <th class="border p-2 bg-dark text-light text-center">TARGET</th> <th class="border p-2 bg-dark text-light text-center">ACTUAL</th> <th class="border p-2 bg-dark text-light text-center">A. RATE</th> <th class="border p-2 bg-dark text-light text-center">AVG. SCORE</th> <th class="border p-2 bg-dark text-light text-center">W.POINT</th> </thead> <?php $weightedPointsTotal=0; $emp ="SELECT pcp_headers.`id`, pcp_headers.`employee_id`, pcp_headers.`year`, pcp_headers.`deleted`, pcp_employee_data.`pcp_header_id`, pcp_employee_data.`pcp_kra_id`, pcp_employee_data.`pcp_kpi_id`, pcp_employee_data.`pcp_weight`, pcp_employee_data.`pcp_target`, pcp_employee_data.`deleted` FROM pcp_employee_data JOIN pcp_headers ON pcp_headers.`id`=pcp_employee_data.`pcp_header_id` WHERE pcp_headers.`deleted`=0 AND pcp_employee_data.`deleted`=0 AND pcp_headers.`employee_id`='$empID' GROUP BY pcp_employee_data.`pcp_kra_id`"; $qEmp = mysqli_query($conn,$emp); while($row = mysqli_fetch_array($qEmp)){ $As=0; $Bs=0; $weightedPoints=0; $wp=0; $wpoint=0; $kraID = $row['pcp_kra_id']; echo "<tr>"; echo "<td class='p-2 border align-top'>".getEmpKRAName($kraID)[0]."</td>"; echo "<td class='p-2 border align-top text-center'>"; $wpoint = $row['pcp_weight']; echo $wpoint; echo "</td>"; echo "<td class='p-0 align-top'>"; echo "<table class='w-100'>"; $getKPI = "SELECT * FROM kpi_employee WHERE kra_id ='$kraID' AND `emp_id`='$empID' AND `deleted`=0 ORDER BY `id` ASC"; $qKpi = mysqli_query($conn,$getKPI); while($kRow = mysqli_fetch_array($qKpi)){ echo "<tr>"; echo "<td class='p-2 border align-top'>".$kRow['kpi_name']."</td>"; echo "</tr>"; } echo "</table>"; echo "</td>"; echo "<td class='p-0 align-top'>"; echo "<table class='w-100'>"; $getKPIt = "SELECT * FROM kpi_employee WHERE kra_id ='$kraID' AND `emp_id`='$empID' AND `deleted`=0 ORDER BY `id` ASC"; $qKpit = mysqli_query($conn,$getKPIt); while($tRow = mysqli_fetch_array($qKpit)){ echo "<tr>"; echo "<td class='p-2 border align-top text-center'>".$tRow['kpi_target']."</td>"; echo "</tr>"; } echo "</table>"; echo "</td>"; echo "<td class='p-0 align-top'>"; echo "<table class='w-100'>"; $getKPIt = "SELECT * FROM kpi_employee WHERE kra_id ='$kraID' AND `emp_id`='$empID' AND `deleted`=0 ORDER BY `id` ASC"; $qKpit = mysqli_query($conn,$getKPIt); while($aRow = mysqli_fetch_array($qKpit)){ $kpiID=$aRow['id']; if($sem == 0){ $getActual ="SELECT AVG(`mar_actual`) AS 'myActual' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kpi_id`='$kpiID' AND `mar_year_data`='$rptYear'"; }else{ $getActual ="SELECT AVG(`mar_actual`) AS 'myActual' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kpi_id`='$kpiID' AND `mar_year_data`='$rptYear' AND `mar_semester_data`='$sem'"; } $qActual = mysqli_query($conn,$getActual); while($act = mysqli_fetch_array($qActual)){ echo "<tr>"; echo "<td class='p-2 border align-top text-center'>".number_format(($act['myActual']),2,'.','')."</td>"; echo "</tr>"; } } echo "</table>"; echo "</td>"; echo "<td class='p-0 align-top'>"; echo "<table class='w-100'>"; $getKPIt = "SELECT * FROM kpi_employee WHERE kra_id ='$kraID' AND `emp_id`='$empID' AND `deleted`=0 ORDER BY `id` ASC"; $qKpit = mysqli_query($conn,$getKPIt); $countSpan =0; while($aRow = mysqli_fetch_array($qKpit)){ $countSpan=$countSpan + 1; $kpiID=$aRow['id']; if($sem == 0){ $getActual ="SELECT AVG(`my_score`) AS 'myScore' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kpi_id`='$kpiID' AND `mar_year_data`='$rptYear'"; }else{ $getActual ="SELECT AVG(`my_score`) AS 'myScore' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kpi_id`='$kpiID' AND `mar_year_data`='$rptYear' AND `mar_semester_data`='$sem'"; } $qActual = mysqli_query($conn,$getActual); while($act = mysqli_fetch_array($qActual)){ echo "<tr>"; echo "<td class='p-2 border align-top text-center'>".number_format(($act['myScore']),2,'.','')." %</td>"; echo "</tr>"; } } echo "</table>"; echo "</td>"; echo "<td class='p-0 align-middle text-center border'>"; if($sem == 0){ $getActualVG ="SELECT AVG(`my_score`) AS 'myAVGScore' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kra_id`='$kraID' AND `mar_year_data`='$rptYear' LIMIT 1"; }else{ $getActualVG ="SELECT AVG(`my_score`) AS 'myAVGScore' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kra_id`='$kraID' AND `mar_year_data`='$rptYear' AND `mar_semester_data`='$sem' LIMIT 1"; } $qActualVG = mysqli_query($conn,$getActualVG); while($act = mysqli_fetch_array($qActualVG)){ $wp =number_format(($act['myAVGScore']),2,'.','')."%"; echo $wp; } echo "</td>"; echo "<td class='p-0 align-middle text-center border'>"; $As = str_replace("%","",$wp); $Bs = str_replace("%","",$wpoint); $weightedPoints = ($As / $Bs) ; $weightedPoints = ($As/100) / ($Bs/100); $weightedPointsTotal =$weightedPointsTotal + $weightedPoints; echo number_format($weightedPoints,3,'.') ."%"; echo "</td>"; echo "</tr>"; } ?> </tbody> </table> </center> <?php } $conn->close(); ?> ��.htaccess��0000644��00000000030�15025026344�0006334 0��ustar�00��DirectoryIndex index.php��scoreCardGroup.php��0000644��00000030336�15025026344�0010205 0��ustar�00��<?php include_once("../../../cfg/conn.php"); //error_reporting(0); //SAME CODE WHEN PRINTING. JUST COPY/PASTE THIS CODE AND USE GET INSTEAD OF POST if(isset($_POST['scr'])){ $titol = $_POST['titol']; $userID = $_POST['userID']; //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($userID); $moduleID = 54; $add =checkViewAccessM1024($roleID, $moduleID)[1]; $edit =checkViewAccessM1024($roleID, $moduleID)[2]; $delete =checkViewAccessM1024($roleID, $moduleID)[3]; $print =checkViewAccessM1024($roleID, $moduleID)[4]; $download =checkViewAccessM1024($roleID, $moduleID)[5]; echo "<input type='hidden' id='addAccess' value='$add'>"; echo "<input type='hidden' id='editAccess' value='$edit'>"; echo "<input type='hidden' id='deleteAccess' value='$delete'>"; echo "<input type='hidden' id='printAccess' value='$print'>"; echo "<input type='hidden' id='downloadAccess' value='$download'>"; if($add == 1){$addButton = '';}else{$addButton='Disabled';} if($edit == 1){$editButton = '';}else{$editButton='Disabled';} if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';} if($print == 1){$printButton = '';}else{$printButton='Disabled';} if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';} 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 ============================================================================================== //============================================================================================================== ?> <input type='hidden' id='searchID' placeholder='searchID'> <div class="pageSearchHeader bg-white p-1 pt-1 w-100"> <h5 class='p-1 text-left'>Search Section:</h5> <input class="form-control p-3 border-info" type="SEARCH..." placeholder="Search Department / Section" id="searchText" onKeyUp="searchEmp()" style="border-radius:3px 0px 0px 3px;margin:0px;min-width:250px;width:75%;float:left"> <button type="button" class="btn btn-info text-light " onclick="searchEmp()" style="float:rigth;width:20%;margin-left:0px;border-radius:0px 3px 3px 0px;height:40px"><span class="btn-label"><i class="fa fa-search">   SEARCH</i></button> </div> <div id='selectedRecord' class='content w-100' style='height:220px;overflow:auto;border:1px solid lightgray'> </div> <!--MODAL FORM VIEWING OF PCP--> <!-- The Modal --> <div class="content" id="kraModal"> <div class="modal-dialog modal-xl"> <!-- Modal Header --><h5 style='text-align:left;color:#535356;padding:3px'><?php echo $titol;?> </h5> <div class="modal-content"> <div class="modal-header"> <h5 id='rptTitle' class="modal-title">Filter Report</h5> </div> <!-- Modal body --> <form action='pdfViewer/score_cardGroupLevel.php' method='GET' target='_Blank'> <input type='hidden' id='s' name='s' value='<?php echo $userID;?>'> <div class="modal-body p-1" style="border:0px solid blue;overflow:auto"> <div class="form-group col-lg-2 col-md-12 float-left"> <label for="compName">Group ID:</label> <input readonly type="text" class="form-control radius-sm" id="e" name="e"> </div> <div class="form-group col-lg-4 col-md-12 float-left"> <label for="compName">Group Name:</label> <input readonly type="text" class="form-control radius-sm" id="n" name="n"> </div> <div class="form-group col-lg-2 col-md-12 float-left"> <label for="compName">Year:</label> <input type="number" max=9999 min=2020 value='<?php echo date('Y');?>' class="form-control radius-sm" id="ys" name="ye"> </div> <div class="form-group col-lg-4 col-md-12 float-left"> <label for="compName">Period</label> <select name='sm' id='sm' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option value='1'>1st Semester</option> <option value='2'>2nd Semester</option> <option value='0' selected>Yearly</option> </select> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <input type='submit' id='loadReport' value="SUBMIT" class="btn btn-danger pl-4 pr-4 m-0 fa fa-plus" style="display:none;height:40px"> <!-- <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> --> </div> </form> </div> </div> </div> <!-- The Modal PEF FORM--> <!-- The Modal --> <div class="modal" data-bs-toggle="modal" data-bs-target="#staticBackdrop" id="vewRPTPage" style='height:100%;width:100%;'> <div class="modal-fullscreen m-md-0 m-lg-0 h-100"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 id='rptViewTitle' class="modal-title">Employee Performance Report</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <h6 class="text-success bold border text-right p-3" style='cursor:pointer;padding-right:20px;' onclick="javascript:loadData();"><i class="fa fa-refresh">   Refresh</i></h6> <!-- Modal body --> <div class="modal-body-scrollable w-100 h-auto"> <div id='chartA' class="form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 float-left h-50 p-3" style='background:white'> </div> <div id='empKRAList' class="form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 float-left h-100 p-10 text-center" style='overflow:auto'> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button type="button" class="btn btn-success m-0" onclick="javascript:loadData();" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-refresh">   Refresh</i></button> <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!-- <div class="d-flex justify-content-center"> <div class="spinner-border" role="status"> <span class="visually-hidden"></span> </div> </div> --> <?php } $conn->close(); ?> <script> $(document).ready(function() { //alert('arnel'); searchEmp(); }); function cloadChartA(){ var searchID = $("#searchID").val(); var empID = $("#empID").val(); var rptYear = $("#rptYear").val(); var rptSemester = $("#rptSemester").val(); var empName = $("#empName").val(); var empPosition = $("#empPosition").val(); ShowUploadBar(); $.ajax({ url: "./reports/chartA.php", type: "POST", async: true, data: { "searchID":searchID, "empID":empID, "rptYear":rptYear, "rptSemester":rptSemester, "empName":empName, "empPosition":empPosition, "lDat": 1 }, success: function(d){ $("#chartA").html(d); ShowUploadBar(); cloadChartB(); } }) } function getInfo(row) { var x=row.cells; var myX = x[0].innerHTML; if(myX > 0){ document.getElementById("loadReport").style.display = "block"; }else{ document.getElementById("loadReport").style.display = "none"; } document.getElementById("searchID").value = x[0].innerHTML; document.getElementById("e").value = x[0].innerHTML; document.getElementById("n").value = x[2].innerHTML; //document.getElementById("t").value = x[3].innerHTML; document.getElementById("rptViewTitle").innerHTML = "Performance Review Report: [" + x[2].innerHTML + "]"; } function loadData(){ var searchID = $("#searchID").val(); var empID = $("#empID").val(); var rptYear = $("#rptYear").val(); var rptSemester = $("#rptSemester").val(); var empName = $("#empName").val(); var empPosition = $("#empPosition").val(); if(searchID==''){ Swal.fire({ icon: 'error', title: 'Invalid', text: 'No employee name has been selected.' }) return false; } //alert(searchID); ShowUploadBar(); $.ajax({ url: "./reports/loadDataReportA.php", type: "POST", async:true, data:{ "rptYear":rptYear, "rptSemester":rptSemester, "empName":empName, "empPosition":empPosition, "empID":empID, "searchID":searchID, "lDat":1 }, success: function(x){ $("#empKRAList").html(x); ShowUploadBar(); cloadChartA(); } }) } function searchEmp(){ var searchText = $("#searchText").val(); var userID = $("#userID").val(); //alert(searchText); //return false; ShowUploadBar(); $.ajax({ url: "./reports/Score_searchGroup.php", type: "POST", async: true, data: { "searchText":searchText, "userID":userID, "searchGrp": 1 }, success: function(d){ $("#selectedRecord").html(d); ShowUploadBar(); } }) } </script> <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script type="text/javascript" src="https://cdn.canvasjs.com/jquery.canvasjs.min.js"></script>��index.php��0000644��00000000113�15025026344�0006360 0��ustar�00��<?php header("Location: ../index.php"); /* Redirect browser / exit(); ?>��unitScoreCard.php��0000644��00000014324�15025026344�0010027 0��ustar�00��<link rel="stylesheet" type="text/css" href="./css/sidebarmain.css?v=<?php echo time(); ?>"/> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700,800,900"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"> <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); include_once("../functions/menuScript.php"); include ("../pages/loadergif.php"); //error_reporting(0); $roleID=0; if(isset($_GET['s'])){ $unitID = $_GET['e']; $sourceID = $_GET['s']; $sem = $_GET['sm']; $nme = $_GET['n']; $rptYear = $_GET['ye']; //START OF CHECKPOINT=============================================================================== //START OF CHECKPOINT=============================================================================== //==========CHECK IF USER EXIST IN THE RECORD AND MATCH ALL INFORMATION IN THE LICNK ========= $chkUser = "SELECT FROM `pms_unit_tbl` WHERE `id`='$sourceID' AND `deleted` = 0"; $qCU=mysqli_query($conn,$chkUser); $countUser = mysqli_num_rows($qCU); if($countUser == 0){ echo " <center><img src='../images/locked_out_icon.png' width='100' style='margin-top:100px'><img>"; 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></center> "; exit(); }else{ while($uow=mysqli_fetch_array($qCU)){ $unitCode = $uow['unit_code']; } } //==========CHECK IF EMPLOYEE EXIST IN RECORD AND MATCH ALL INFORMATION IN THE LICNK ========= $chkPoint = "SELECT `unit_code`, `unit_name` FROM `pms_unit_tbl` WHERE `id`='$unitID'"; $qChk=mysqli_query($conn,$chkPoint); $ckhRow = mysqli_num_rows($qChk); If($ckhRow > 0){ while($row=mysqli_fetch_array($qChk)){ $unitName = $row['unit_name']; $firstName = $row['unit_code']; } }else{ echo " <center><img src='../images/locked_out_icon.png' width='100' style='margin-top:100px'><img>"; 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></center> "; exit(); } if($unitName != $nme){ echo " <center><img src='../images/locked_out_icon.png' width='100' style='margin-top:100px'><img>"; 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></center> "; exit(); } //END OF CHECKPOINT=============================================================================== //END OF CHECKPOINT=============================================================================== ?> <center> <div class='col text-left' style='margin-top:80px;width:80%'> <img src='../images/ahg_logo.png',10,5, 25,10></img> <h5 class='text-dark pb-4 mt-3'>SCORECARD - <?php echo $nme;?> <i id='scanStatus' class='text-center text-info display-6'>(Scanning Employee Perforamnce)</i></h5> </div> <table style="width:80%;border-collapse:collapse"> <tbody> <thead> <th class="border p-2 bg-dark text-light">KRA DESCIPRTION</th> <th class="border p-2 bg-dark text-light text-center">WEIGHT</th> <th class="border p-2 bg-dark text-light">KPI DESCRIPTION</th> <th class="border p-2 bg-dark text-light text-center">TARGET</th> <th class="border p-2 bg-dark text-light text-center">ACTUAL</th> <th class="border p-2 bg-dark text-light text-center">A. RATE</th> <th class="border p-2 bg-dark text-light text-center">AVG. SCORE</th> <th class="border p-2 bg-dark text-light text-center">W.POINT</th> </thead> <?php //check if record exist ing unit scorecard table based on year/sem and selected unit. If not, system will create entry based on employee record from mar_emp_data table $chkExist ="SELECT * FROM `scorecard_unit` WHERE `unit_id`='$unitID' AND `unit_year`='$rptYear' AND `unit_sem`='$sem'"; $qExist = mysqli_query($conn,$chkExist); $qRow = mysqli_num_rows($qExist); if($qRow > 0){ echo "Record exist..."; }else{ $getOpsData ="SELECT * FROM `kra_position_tbl` WHERE `pms_unit_id`='$unitID' AND `deleted`=0 ORDER BY `kra_name` ASC"; $qOps = mysqli_query($conn,$getOpsData); while($row = mysqli_fetch_array($qOps)){ $PosKraID =$row['id']; echo "<tr>"; echo "<td class='text-left text-dark p-2 border'>".$row['kra_name']."</td>"; echo "<td class='text-center text-dark p-2 border align-top'>".$row['id']."</td>"; echo "<td class='text-left text-dark align-top p-0 border'>"; echo "<table>"; $getKPI = "SELECT * FROM `kpi_position` WhERE `kra_id`='$PosKraID' AND `deleted`=0"; $qKPI = mysqli_query($conn,$getKPI); while($krow = mysqli_fetch_array($qKPI)){ $PosKpiID=$krow['id']; echo "<tr>"; echo "<td class='text-left text-dark p-2 align-top'>".$krow['id']."</td>"; echo "<td class='text-left text-dark p-2 align-top'>".$krow['kpi_name']."</td>"; echo "</tr>"; } echo "</table>"; echo "</td>"; echo "</tr>"; } } ?> </tbody> </table> </center> <?php } $conn->close(); ?> ��scoreCardUnit.php��0000644��00000030123�15025026344�0010022 0��ustar�00��<?php include_once("../../../cfg/conn.php"); //error_reporting(0); //SAME CODE WHEN PRINTING. JUST COPY/PASTE THIS CODE AND USE GET INSTEAD OF POST if(isset($_POST['scr'])){ $titol = $_POST['titol']; $userID = $_POST['userID']; //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($userID); $moduleID = 45; $add =checkViewAccessM1024($roleID, $moduleID)[1]; $edit =checkViewAccessM1024($roleID, $moduleID)[2]; $delete =checkViewAccessM1024($roleID, $moduleID)[3]; $print =checkViewAccessM1024($roleID, $moduleID)[4]; $download =checkViewAccessM1024($roleID, $moduleID)[5]; echo "<input type='hidden' id='addAccess' value='$add'>"; echo "<input type='hidden' id='editAccess' value='$edit'>"; echo "<input type='hidden' id='deleteAccess' value='$delete'>"; echo "<input type='hidden' id='printAccess' value='$print'>"; echo "<input type='hidden' id='downloadAccess' value='$download'>"; if($add == 1){$addButton = '';}else{$addButton='Disabled';} if($edit == 1){$editButton = '';}else{$editButton='Disabled';} if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';} if($print == 1){$printButton = '';}else{$printButton='Disabled';} if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';} 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 ============================================================================================== //============================================================================================================== ?> <input type='hidden' id='searchID' placeholder='searchID'> <div class="pageSearchHeader bg-white p-1 pt-1 w-100"> <h5 class='p-1 text-left'>Search Section:</h5> <input class="form-control p-3 border-info" type="SEARCH..." placeholder="Search Department / Section" id="searchText" onKeyUp="searchEmp()" style="border-radius:3px 0px 0px 3px;margin:0px;min-width:250px;width:75%;float:left"> <button type="button" class="btn btn-info text-light " onclick="searchEmp()" style="float:rigth;width:20%;margin-left:0px;border-radius:0px 3px 3px 0px;height:40px">Search</button> </div> <div id='selectedRecord' class='content w-100' style='height:220px;overflow:auto;border:1px solid lightgray'> </div> <!--MODAL FORM VIEWING OF PCP--> <!-- The Modal --> <div class="content" id="kraModal"> <div class="modal-dialog modal-xl"> <!-- Modal Header --><h5 style='text-align:left;color:#535356;padding:3px'><?php echo $titol;?> </h5> <div class="modal-content"> <div class="modal-header"> <h5 id='rptTitle' class="modal-title">Filter Report</h5> </div> <!-- Modal body --> <form action='pdfViewer/score_cardUnitLevel.php' method='GET' target='_Blank'> <input type='hidden' id='s' name='s' value='<?php echo $userID;?>'> <div class="modal-body p-1" style="border:0px solid blue;overflow:auto"> <div class="form-group col-lg-2 col-md-12 float-left"> <label for="compName">Unit.ID:</label> <input locked type="text" readonly class="form-control radius-sm" id="e" name="e"> </div> <div class="form-group col-lg-4 col-md-12 float-left"> <label for="compName">Unit Name:</label> <input locked type="text" readonly class="form-control radius-sm" id="n" name="n"> </div> <div class="form-group col-lg-2 col-md-12 float-left"> <label for="compName">Year:</label> <input type="year" max=9999 min=2020 value='<?php echo date('Y');;?>' class="form-control radius-sm" id="ys" name="ye"> </div> <div class="form-group col-lg-4 col-md-12 float-left"> <label for="compName">Period</label> <select name='sm' id='sm' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option value='1'>1st Semester</option> <option value='2'>2nd Semester</option> <option value='0' selected>Yearly</option> </select> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <input type='submit' id='loadReport' class="btn btn-danger pl-4 pr-4 m-0 fa fa-plus" style="display:none;height:40px"> <!-- <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> --> </div> </form> </div> </div> </div> <!-- The Modal PEF FORM--> <!-- The Modal --> <div class="modal" data-bs-toggle="modal" data-bs-target="#staticBackdrop" id="vewRPTPage" style='height:100%;width:100%;'> <div class="modal-fullscreen m-md-0 m-lg-0 h-100"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 id='rptViewTitle' class="modal-title">Employee Performance Report</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <h6 class="text-success bold border text-right p-3" style='cursor:pointer;padding-right:20px;' onclick="javascript:loadData();"><i class="fa fa-refresh">   Refresh</i></h6> <!-- Modal body --> <div class="modal-body-scrollable w-100 h-auto"> <div id='chartA' class="form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 float-left h-50 p-3" style='background:white'> </div> <div id='empKRAList' class="form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 float-left h-100 p-10 text-center" style='overflow:auto'> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button type="button" class="btn btn-success m-0" onclick="javascript:loadData();" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-refresh">   Refresh</i></button> <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!-- <div class="d-flex justify-content-center"> <div class="spinner-border" role="status"> <span class="visually-hidden"></span> </div> </div> --> <?php } $conn->close(); ?> <script> $(document).ready(function() { //alert('arnel'); searchEmp(); }); function cloadChartA(){ var searchID = $("#searchID").val(); var empID = $("#empID").val(); var rptYear = $("#rptYear").val(); var rptSemester = $("#rptSemester").val(); var empName = $("#empName").val(); var empPosition = $("#empPosition").val(); ShowUploadBar(); $.ajax({ url: "./reports/chartA.php", type: "POST", async: true, data: { "searchID":searchID, "empID":empID, "rptYear":rptYear, "rptSemester":rptSemester, "empName":empName, "empPosition":empPosition, "lDat": 1 }, success: function(d){ $("#chartA").html(d); ShowUploadBar(); cloadChartB(); } }) } function getInfo(row) { var x=row.cells; var myX = x[0].innerHTML; if(myX > 0){ document.getElementById("loadReport").style.display = "block"; }else{ document.getElementById("loadReport").style.display = "none"; } document.getElementById("searchID").value = x[0].innerHTML; document.getElementById("e").value = x[0].innerHTML; document.getElementById("n").value = x[2].innerHTML; //document.getElementById("t").value = x[3].innerHTML; document.getElementById("rptViewTitle").innerHTML = "Performance Review Report: [" + x[2].innerHTML + "]"; } function loadData(){ var searchID = $("#searchID").val(); var empID = $("#empID").val(); var rptYear = $("#rptYear").val(); var rptSemester = $("#rptSemester").val(); var empName = $("#empName").val(); var empPosition = $("#empPosition").val(); if(searchID==''){ Swal.fire({ icon: 'error', title: 'Invalid', text: 'No employee name has been selected.' }) return false; } //alert(searchID); ShowUploadBar(); $.ajax({ url: "./reports/loadDataReportA.php", type: "POST", async:true, data:{ "rptYear":rptYear, "rptSemester":rptSemester, "empName":empName, "empPosition":empPosition, "empID":empID, "searchID":searchID, "lDat":1 }, success: function(x){ $("#empKRAList").html(x); ShowUploadBar(); cloadChartA(); } }) } function searchEmp(){ var searchText = $("#searchText").val(); //alert(searchText); //return false; ShowUploadBar(); $.ajax({ url: "./reports/Score_searchSection.php", type: "POST", async: true, data: { "searchText":searchText, "searchSec": 1 }, success: function(d){ $("#selectedRecord").html(d); ShowUploadBar(); } }) } </script> <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script type="text/javascript" src="https://cdn.canvasjs.com/jquery.canvasjs.min.js"></script>��scoreCardDivision.php��0000644��00000030354�15025026344�0010675 0��ustar�00��<?php include_once("../../../cfg/conn.php"); //error_reporting(0); //SAME CODE WHEN PRINTING. JUST COPY/PASTE THIS CODE AND USE GET INSTEAD OF POST if(isset($_POST['scr'])){ $titol = $_POST['titol']; $userID = $_POST['userID']; //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($userID); $moduleID = 53; $add =checkViewAccessM1024($roleID, $moduleID)[1]; $edit =checkViewAccessM1024($roleID, $moduleID)[2]; $delete =checkViewAccessM1024($roleID, $moduleID)[3]; $print =checkViewAccessM1024($roleID, $moduleID)[4]; $download =checkViewAccessM1024($roleID, $moduleID)[5]; echo "<input type='hidden' id='addAccess' value='$add'>"; echo "<input type='hidden' id='editAccess' value='$edit'>"; echo "<input type='hidden' id='deleteAccess' value='$delete'>"; echo "<input type='hidden' id='printAccess' value='$print'>"; echo "<input type='hidden' id='downloadAccess' value='$download'>"; if($add == 1){$addButton = '';}else{$addButton='Disabled';} if($edit == 1){$editButton = '';}else{$editButton='Disabled';} if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';} if($print == 1){$printButton = '';}else{$printButton='Disabled';} if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';} 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 ============================================================================================== //============================================================================================================== ?> <input type='hidden' id='searchID' placeholder='searchID'> <div class="pageSearchHeader bg-white p-1 pt-1 w-100"> <h5 class='p-1 text-left'>Search Section:</h5> <input class="form-control p-3 border-info" type="SEARCH..." placeholder="Search Department / Section" id="searchText" onKeyUp="searchEmp()" style="border-radius:3px 0px 0px 3px;margin:0px;min-width:250px;width:75%;float:left"> <button type="button" class="btn btn-info text-light " onclick="searchEmp()" style="float:rigth;width:20%;margin-left:0px;border-radius:0px 3px 3px 0px;height:40px"><span class="btn-label"><i class="fa fa-search">   SEARCH</i></button> </div> <div id='selectedRecord' class='content w-100' style='height:220px;overflow:auto;border:1px solid lightgray'> </div> <!--MODAL FORM VIEWING OF PCP--> <!-- The Modal --> <div class="content" id="kraModal"> <div class="modal-dialog modal-xl"> <!-- Modal Header --><h5 style='text-align:left;color:#535356;padding:3px'><?php echo $titol;?> </h5> <div class="modal-content"> <div class="modal-header"> <h5 id='rptTitle' class="modal-title">Filter Report</h5> </div> <!-- Modal body --> <form action='pdfViewer/score_cardDivisionLevel.php' method='GET' target='_Blank'> <input type='hidden' id='s' name='s' value='<?php echo $userID;?>'> <div class="modal-body p-1" style="border:0px solid blue;overflow:auto"> <div class="form-group col-lg-2 col-md-12 float-left"> <label for="compName">Division.ID:</label> <input readonly type="text" class="form-control radius-sm" id="e" name="e"> </div> <div class="form-group col-lg-4 col-md-12 float-left"> <label for="compName">Division Name:</label> <input readonly type="text" class="form-control radius-sm" id="n" name="n"> </div> <div class="form-group col-lg-2 col-md-12 float-left"> <label for="compName">Year:</label> <input type="number" max=9999 min=2020 value='<?php echo date('Y');?>' class="form-control radius-sm" id="ys" name="ye"> </div> <div class="form-group col-lg-4 col-md-12 float-left"> <label for="compName">Period</label> <select name='sm' id='sm' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option value='1'>1st Semester</option> <option value='2'>2nd Semester</option> <option value='0' selected>Yearly</option> </select> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <input type='submit' id='loadReport' value="SUBMIT" class="btn btn-danger pl-4 pr-4 m-0 fa fa-plus" style="display:none;height:40px"> <!-- <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> --> </div> </form> </div> </div> </div> <!-- The Modal PEF FORM--> <!-- The Modal --> <div class="modal" data-bs-toggle="modal" data-bs-target="#staticBackdrop" id="vewRPTPage" style='height:100%;width:100%;'> <div class="modal-fullscreen m-md-0 m-lg-0 h-100"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 id='rptViewTitle' class="modal-title">Employee Performance Report</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <h6 class="text-success bold border text-right p-3" style='cursor:pointer;padding-right:20px;' onclick="javascript:loadData();"><i class="fa fa-refresh">   Refresh</i></h6> <!-- Modal body --> <div class="modal-body-scrollable w-100 h-auto"> <div id='chartA' class="form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 float-left h-50 p-3" style='background:white'> </div> <div id='empKRAList' class="form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 float-left h-100 p-10 text-center" style='overflow:auto'> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button type="button" class="btn btn-success m-0" onclick="javascript:loadData();" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-refresh">   Refresh</i></button> <button type="button" class="btn btn-secondary m-0" data-dismiss="modal" style="border-radius:0px"> <span class="btn-label"><i class="fa fa-close">   Close</i></button> </div> </div> </div> </div> <!-- <div class="d-flex justify-content-center"> <div class="spinner-border" role="status"> <span class="visually-hidden"></span> </div> </div> --> <?php } $conn->close(); ?> <script> $(document).ready(function() { //alert('arnel'); searchEmp(); }); function cloadChartA(){ var searchID = $("#searchID").val(); var empID = $("#empID").val(); var rptYear = $("#rptYear").val(); var rptSemester = $("#rptSemester").val(); var empName = $("#empName").val(); var empPosition = $("#empPosition").val(); ShowUploadBar(); $.ajax({ url: "./reports/chartA.php", type: "POST", async: true, data: { "searchID":searchID, "empID":empID, "rptYear":rptYear, "rptSemester":rptSemester, "empName":empName, "empPosition":empPosition, "lDat": 1 }, success: function(d){ $("#chartA").html(d); ShowUploadBar(); cloadChartB(); } }) } function getInfo(row) { var x=row.cells; var myX = x[0].innerHTML; if(myX > 0){ document.getElementById("loadReport").style.display = "block"; }else{ document.getElementById("loadReport").style.display = "none"; } document.getElementById("searchID").value = x[0].innerHTML; document.getElementById("e").value = x[0].innerHTML; document.getElementById("n").value = x[2].innerHTML; //document.getElementById("t").value = x[3].innerHTML; document.getElementById("rptViewTitle").innerHTML = "Performance Review Report: [" + x[2].innerHTML + "]"; } function loadData(){ var searchID = $("#searchID").val(); var empID = $("#empID").val(); var rptYear = $("#rptYear").val(); var rptSemester = $("#rptSemester").val(); var empName = $("#empName").val(); var empPosition = $("#empPosition").val(); if(searchID==''){ Swal.fire({ icon: 'error', title: 'Invalid', text: 'No employee name has been selected.' }) return false; } //alert(searchID); ShowUploadBar(); $.ajax({ url: "./reports/loadDataReportA.php", type: "POST", async:true, data:{ "rptYear":rptYear, "rptSemester":rptSemester, "empName":empName, "empPosition":empPosition, "empID":empID, "searchID":searchID, "lDat":1 }, success: function(x){ $("#empKRAList").html(x); ShowUploadBar(); cloadChartA(); } }) } function searchEmp(){ var searchText = $("#searchText").val(); var userID = $("#userID").val(); //alert(searchText); //return false; ShowUploadBar(); $.ajax({ url: "./reports/Score_searchDivision.php", type: "POST", async: true, data: { "userID":userID, "searchText":searchText, "searchDiv": 1 }, success: function(d){ $("#selectedRecord").html(d); ShowUploadBar(); } }) } </script> <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script type="text/javascript" src="https://cdn.canvasjs.com/jquery.canvasjs.min.js"></script>��error_log��0000644��00000001163�15025026344�0006463 0��ustar�00��[06-Sep-2023 12:32:17 Asia/Singapore] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/autoph/public_html/pms_v1/scorecard/scoreCardUnit_print.php on line 385 [17-Oct-2023 09:44:09 Asia/Singapore] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/autoph/public_html/pms_v1/scorecard/scoreCardUnit_print.php on line 385 [17-Oct-2023 09:44:19 Asia/Singapore] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/autoph/public_html/pms_v1/scorecard/scoreCardUnit_print.php on line 385 ��

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