File manager

File manager - Edit - /home/autoph/public_html/pms_v1/reports/chartB.php

Back
<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['lDat'])){ $searchID = $_POST['searchID']; $unitID = $_POST['unitID']; $rptYear = $_POST['rptYear']; $rptSemester = $_POST['rptSemester']; $empName = $_POST['empName']; $empPosition = $_POST['empPosition']; //INITIALIZE USED VARIABLES $marchCount = 0; $myScore =0; $kraCode =0; $fMyScore =0; $janCount = 0; $jan = 0; $janTotal=0; $febTotal=0; $feb =0; $febCount =0; $marTotal=0; $mar =0; $marCount =0; $aprTotal=0; $apr =0; $aprCount =0; $mayTotal=0; $may =0; $mayCount =0; $junTotal=0; $jun =0; $junCount =0; $julTotal=0; $jul =0; $julCount =0; $augTotal=0; $aug =0; $augCount =0; $sepTotal=0; $sep =0; $sepCount =0; $octTotal=0; $oct =0; $octCount =0; $novTotal=0; $nov =0; $novCount =0; $decTotal=0; $dec =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(); } } // echo "<br>". $searchID; // echo "<br>". $unitID; // echo "<br>". $rptYear; // echo "<br>". $rptSemester; // echo "<br>". $empName; // echo "<br>". $empPosition; ?> <!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: { //fontSize: 22, text: "Unit Performance by KRA - <?php echo $rptYear;?> " }, axisY: { title: "Average KRA Scores", suffix: "%" }, data: [ { // Change type to "doughnut", "line", "splineArea", etc. type: "column", dataPoints: [ <?php //QUERY EMPLOYEE KRA TO BE LOADED IN CHART A $chartKRA = "SELECT mar_emp_data.id, mar_emp_data.emp_rec_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_variance_no, mar_emp_data.mar_numerical_rating, mar_emp_data.deleted, 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 GROUP BY kra_unit_tbl.id"; $cKRA = mysqli_query($conn,$chartKRA); while($row = mysqli_fetch_array($cKRA)){ $empID = $row['emp_rec_id']; $ckhUID = "SELECT `unit_id` FROM `pms_employee_data` WHERE `id`='$empID'"; $qUID = mysqli_query($conn,$ckhUID); while($ud=mysqli_fetch_array($qUID)){ $empUnitID = $ud['unit_id']; } if($searchID == $empUnitID){ $marchCount = $marchCount + 1; $kraCode =$row['kra_code']; // UNIT KRA ID $myScore = $myScore + $row['my_score']; $fMyScore = number_format($myScore,3,'.',''); } echo "{ label: '".$kraCode."', y: ".$fMyScore." },"; $myScore = 0; } ?> ] } ] }; $("#MyChartA").CanvasJSChart(options); //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ var chart = new CanvasJS.Chart("MyChartB", { animationEnabled: true, theme: "greenShadesB", // "light1", "light2", "dark1", "dark2" colorSet: "greenShadesB", title: { //fontSize:22, text: "Unit 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: "area", //yValueFormatString: "#,##0.0#\"%\"", yValueFormatString: "", labelWrap: true, //labelMaxWidth: 70, interval: 1, 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_variance_no, mar_emp_data.mar_numerical_rating, mar_emp_data.deleted, mar_emp_data.emp_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"; $cKRA = mysqli_query($conn,$chartKRA); while($row = mysqli_fetch_array($cKRA)){ $empID = $row['emp_id']; $ckhUID = "SELECT `unit_id` FROM `pms_employee_data` WHERE `id`='$empID'"; $qUID = mysqli_query($conn,$ckhUID); while($ud=mysqli_fetch_array($qUID)){ $empUnitID = $ud['unit_id']; } if($searchID == $empUnitID){ $x = $row['mar_month_data']; switch($x){ case '1': $janCount = $janCount + 1; $jan = ($jan + $row['my_score']) / $janCount; $janTotal = number_format($jan,3,'.',''); break; case '2': $febCount = $febCount + 1; $feb = ($feb + $row['my_score']) / $febCount; $febTotal = number_format($feb,3,'.',''); break; case '3': $marCount = $marCount + 1; $mar = ($mar + $row['my_score']) / $marCount; $marTotal = number_format($mar,3,'.',''); break; case '4': $aprCount = $aprCount + 1; $apr = ($apr + $row['my_score']) / $aprCount; $aprTotal = number_format($apr,3,'.',''); break; case '5': $mayCount = $mayCount + 1; $may = ($may + $row['my_score']) / $mayCount; $mayTotal = number_format($may,3,'.',''); break; case '6': $junCount = $junCount + 1; $jun = ($jun + $row['my_score']) / $junCount; $junTotal = number_format($jun,3,'.',''); break; case '7': $julCount = $julCount + 1; $jul = ($jul + $row['my_score']) / $julCount; $julTotal = number_format($jul,3,'.',''); break; case '8': $augCount = $augCount + 1; $aug = ($aug + $row['my_score']) / $augCount; $augTotal = number_format($aug,3,'.',''); break; case '9': $sepCount = $sepCount + 1; $sep = ($sep + $row['my_score']) / $sepCount; $sepTotal = number_format($sep,3,'.',''); break; case '10': $octCount = $octCount + 1; $oct = ($oct + $row['my_score']) / $octCount; $octTotal = number_format($oct,3,'.',''); break; case '11': $novCount = $novCount + 1; $nov = ($nov + $row['my_score']) / $novCount; $novTotal = number_format($nov,3,'.',''); break; case '12': $decCount = $decCount + 1; $dec = ($dec + $row['my_score']) / $decCount; $decTotal = number_format($dec,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." },"; ?> ] }] }); chart.render(); } //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ </script> </head> <body> <center> <div id="MyChartA" class="col-lg-6 col-md-6 col-sm-12 p-2 mt-5" style="float:left;height: 360px"></div> <div id="MyChartB" class="col-lg-6 col-md-6 col-sm-12 p-2 mt-5" style="float:left;height: 360px; "></div> <div id="MyChartC" class="col-lg-12 col-md-6 col-sm-12 p-2 mt-5" style="float:left;height: 360px"> <?php //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ echo "<div class='col-lg-12 col-md-12 col-sm-12 float-left h-auto w-100' style='overflow:auto;width:100%;'> <h5 class='content text-left color-blue' style='margin-top:100px;padding:0px;background:#FDEFD2'>Employee Performance Summary</h5> <table class='col-lg-12 col-md-12 w-100' style='width:100%'>"; echo "<thead>"; echo "<th class='col-lg-4 col-md-5 col-sm-12'>EMPLOYEE NAME</th>"; echo "<th class='col-lg-3 col-md-1 col-sm-12'>POSITION</th>"; echo "<th class='col-lg-1 col-md-1 col-sm-12'>TARGET</th>"; echo "<th class='col-lg-1 col-md-1 col-sm-12'>AVG. ACTUAL</th>"; echo "<th class='col-lg-1 col-md-1 col-sm-12'>AVG. SCORE</th>"; echo "<th class='col-lg-1 col-md-1 col-sm-12'>VARIANCE</th>"; echo "<th class='col-lg-1 col-md-1 col-sm-12'>AVE. NR</th>"; echo "</thead>"; $empData = "SELECT * FROM `pms_employee_data` WHERE `unit_id` = $searchID AND deleted = 0 ORDER BY last_name ASC"; $qEmpData = mysqli_query($conn,$empData); while($erow = mysqli_fetch_array($qEmpData)){ $activeempID = $erow['id']; $activeempUnit = $erow['unit_id']; $position = $erow['position']; echo "<tr>"; echo "<td class='col-lg-4 text-left'>".$erow['last_name'].", ".$erow['first_name']."</td>"; $qEmp ="SELECT AVG(mar_emp_data.my_score) AS myKPIScore, AVG(mar_emp_data.mar_actual) AS myKPImarActual, AVG(mar_emp_data.mar_numerical_rating) AS myKPINumerical, AVG(mar_emp_data.mar_variance_no) AS myKPIVarianceNO, AVG(REPLACE(mar_emp_data.mar_target, '%', '')) AS marTarget, pms_employee_data.id AS employeeID, pms_employee_data.unit_id AS empUnitID, pms_employee_data.first_name, pms_employee_data.last_name, pms_employee_data.position, pms_positions_tbl.position_name, pms_positions_tbl.id as posID, mar_emp_data.emp_rec_id, mar_emp_data.unit_id AS marUnitID, mar_emp_data.kra_id, mar_emp_data.kpi_id, mar_emp_data.mar_weight AS markpiWeight, mar_emp_data.mar_actual, mar_emp_data.my_score, mar_emp_data.mar_variance_no, mar_emp_data.mar_numerical_rating, mar_emp_data.mar_year_data, mar_emp_data.mar_semester_data, mar_emp_data.deleted, kra_employee_tbl.emp_id, kra_employee_tbl.weight AS kraWeight, kra_employee_tbl.kra_name, kra_employee_tbl.id, kpi_employee.emp_id, kpi_employee.kpi_name, kpi_employee.kra_id, kpi_employee.kpi_weight AS kpiWeight, kpi_employee.kpi_target AS kpiTarget, kpi_employee.id AS empKPID FROM pms_employee_data JOIN mar_emp_data ON mar_emp_data.unit_id = pms_employee_data.unit_id JOIN kra_employee_tbl ON kra_employee_tbl.id = mar_emp_data.kra_id JOIN kpi_employee ON kpi_employee.id = mar_emp_data.kpi_id JOIN pms_positions_tbl ON pms_positions_tbl.id = $position WHERE mar_emp_data.mar_year_data = $rptYear AND mar_emp_data.deleted = 0 AND mar_emp_data.unit_id = $searchID AND mar_emp_data.emp_rec_id=$activeempID AND mar_emp_data.unit_id = $activeempUnit"; $uOut = mysqli_query($conn,$qEmp); $rChk = mysqli_num_rows($uOut); if($rChk > 0){ while($qRow = mysqli_fetch_array($uOut)){ if($qRow['myKPIVarianceNO'] <= 0){ $txtColor = 'text-danger'; }else{ $txtColor = 'text-primary'; } if($qRow['myKPImarActual'] < $qRow['marTarget'] \|\| $qRow['myKPImarActual'] <=0){ $txtColorT = 'text-danger'; }else{ $txtColorT = 'text-primary'; } echo "<td class='col-lg-3 text-left '>".$qRow['position_name']."</td>"; echo "<td class='col-lg-1 text-center '>".number_format($qRow['marTarget'],3,'.','')."</td>"; echo "<td class='col-lg-1 text-center $txtColorT'>".number_format($qRow['myKPImarActual'],3,'.','')."</td>"; echo "<td class='col-lg-1 text-center $txtColor'>".number_format($qRow['myKPIScore'],3,'.','')."</td>"; echo "<td class='col-lg-1 text-center $txtColor'>".number_format($qRow['myKPIVarianceNO'],3,'.','')."</td>"; echo "<td class='col-lg-1 text-center $txtColorT'>".number_format($qRow['myKPINumerical'],3,'.','')."</td>"; } } echo "</tr>"; } echo "</table></div>"; //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ?> </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>

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