File manager

File manager - Edit - /home/autoph/public_html/pms_v1/dashboard/personalDashboard.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"); //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); $roleID = userProfileID($userID); $moduleID = 6; 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", { animationEnabled: true, theme: "light2", // "light1", "light2", "dark1", "dark2" colorSet: "greenShades", title: { text: "KRA Achievement Rate - <?php echo $dYear;?>" }, axisY: { title: "Achievement Rate (%)", suffix: "%" }, axisX: { title: "Assigned KRA's" }, data: [{ type: "column", yValueFormatString: "#0.0#", indexLabel: "{y} %", dataPoints: [ <?php $empKRA = "SELECT * FROM `kra_employee_tbl` WHERE `emp_id`='$userID'"; $qEmpKRA = mysqli_query($conn,$empKRA); $totalMyScore = 0; $kraCount=0; while($row=mysqli_fetch_array($qEmpKRA)){ $kraCode = $row['kra_code']; $kraID = $row['id']; $kAVG = "SELECT SUM(`my_score`) AS myScore FROM `mar_emp_data` WHERE deleted=0 AND mar_year_data ='$dYear' AND kra_id='$kraID'"; $qkAVG = mysqli_query($conn,$kAVG); while($mar = mysqli_fetch_array($qkAVG)){ $avgMyScore = $mar['myScore'] / 6; $kraCount = $kraCount +1; $totalMyScore = number_format(($totalMyScore + $avgMyScore),2,'.',''); echo "{label: '$kraCode', y: $avgMyScore},"; $avgMyScore = 0; } } ?> ] }] }); chart.render(); //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ var chart = new CanvasJS.Chart("chartBa", { animationEnabled: true, theme: "light2", // "light1", "light2", "dark1", "dark2" colorSet: "greenShades", title: { text: "Monthly Performance Rating - <?php echo $dYear;?>" }, axisY: { title: "Achievement Rate (%)", suffix: "%" }, axisX: { title: "Months" }, data: [{ type: "line", yValueFormatString: "#0.0#", indexLabel: "{y} %", 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`='$userID' AND `mar_month_data`='$x' AND deleted = 0 AND `mar_year_data`='$dYear' 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("chartCa", { animationEnabled: true, theme: "light2", // "light1", "light2", "dark1", "dark2" colorSet: "greenShades", subtitles: [{ text: "Behavioral Area", fontSize:35, fontColor:"black", verticalAlign: "bottom" }], title: { //text: "Behavioral Rating " <?php $pFs = "SELECT AVG(`assigned_score`) AS pfcore FROM `pef_evaluation_behavioral` WHERE `time_stamp` LIKE '%$dYear%' AND `emp_record_id`='$userID'"; $qpFs = mysqli_query($conn,$pFs); While($rowPF = mysqli_fetch_array($qpFs)){ $myAvgS = number_format($rowPF['pfcore'],2,'.',''); } echo "text: $myAvgS,"; ?> //text: "90.0%", fontSize: 50, verticalAlign: "center" }, axisY: { title: "Average Points", suffix: "Pt" }, axisX: { title: "Behavioral Areas" }, data: [{ type: "doughnut", yValueFormatString: "#,##0.0#", indexLabelFontSize: 14, indexLabel: "{label} \| {y}", 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%' AND `emp_record_id`='$userID'"; $qpF = mysqli_query($conn,$pF); While($rowPF = mysqli_fetch_array($qpF)){ $myAvgScore = $rowPF['pfScore']; } if($myAvgScore ==0 \|\| $myAvgScore ==''){ $myAvgScore=0; } echo "{label: '$bpFactor', y: $myAvgScore },"; } ?> ] }] }); chart.render(); //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ function loadDataDashbaord(){ var userID = $("#userID").val(); ShowUploadBar(); $.ajax({ url: "./dashboard/personalDashboard.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 - Personal</h2> <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='col-xl-9 col-lg-7 col-md-12 col-sm-12 col-xs-12 float-left bg-white' style='box-shadow:0px 0px 0px lightgray;height:360px;margin-bottom:50px;margin-top:50px'> </div> <div id="chartAb"class='col-xl-3 col-lg-5 col-md-12 col-sm-12 col-xs-12 float-left text-xl-center text-lg-center text-md-left text-sm-left p-3 ' style='box-shadow:0px 0px 0px lightgray;height:360px;margin-bottom:50px;margin-top:50px'> <div class='form-group bg-warning col-xl-12 col-lg-12 col-md-12 col-sm-12 border float-left m-xl-2 m-lg-2 m-md-2 m-sm-2 p-3' style="height:45%"> <h6 class=' text-dark text-left'>Average Score</h6> <p class='text-dark pt-3' style="font-family:Arial;font-size:250%;"> <?php if($kraCount == 0){ $tScore = 0; }else{ $tScore = $totalMyScore/$kraCount; } echo number_format($tScore,2,'.','')." %"; ?> </p><br> </div> <div class='form-group bg-info col-xl-12 col-lg-12 col-md-12 col-sm-12 border float-left m-xl-2 m-lg-2 m-md-2 m-sm-2 p-xl-3 p-lg-3 p-md-3 p-sm-0 p-xs-3 ' style="height:45%"> <h6 class=' text-dark text-left'>Adj. Equivalent </h6> <?php $Adj = "SELECT eq_adjectival FROM `gps_adjectival_eq` WHERE $tScore BETWEEN eq_percentage_from AND eq_percentage_to LIMIT 1"; $qAdj = mysqli_query($conn,$Adj); while($ad = mysqli_fetch_array($qAdj)){ echo "<p class='text-primary pt-3 text-light' style='font_family:Gothic Light;font-size:150%;'>".$ad['eq_adjectival']."</p>"; } ?> </div> </div> <div id="chartBa" class='col-xl-9 col-lg-6 col-md-12 col-sm-12 col-xs-12 float-left bg-white' style='box-shadow:0px 0px 0px lightgray;height:360px;margin-bottom:50px;margin-top:40px'></div> <div id="chartBb" class='col-xl-3 col-lg-6 col-md-12 col-sm-12 col-xs-12 float-left bg-white' style='box-shadow:0px 0px 0px lightgray;height:360px;margin-bottom:50px;margin-top:40px'> <div class='form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12 border float-left m-xl-2 m-lg-2 m-md-2 m-sm-2 p-3' style="height:45%;background:#FAC5B6"> <h6 class=' text-dark'>RATING - 1ST SEM</h6> <?php $avgstScore=0; $kST = "SELECT SUM(`my_score`) AS stScore FROM `mar_emp_data` WHERE deleted=0 AND mar_year_data ='$dYear' AND mar_semester_data='1' AND `emp_rec_id`='$userID'"; $qkST = mysqli_query($conn,$kST); while($mar = mysqli_fetch_array($qkST)){ $avgstScore = $mar['stScore']; } $avgstScoreX = $avgstScore / 6; echo "<p class='text-dark text-center pt-3 text-light' style='font_family:Gothic Light;font-size:250%;'>".number_format($avgstScoreX,2,'.','')." %</p>"; ?> </div> <div class='form-group col-xl-12 col-lg-12 col-md-12 col-sm-12 border float-left m-xl-2 m-lg-2 m-md-2 m-sm-2 p-3' style="height:45%;background:#38CA05"> <h6 class=' text-dark'>RATING - 2ND SEM</h6> <?php $avgsndScore=0; $kND = "SELECT SUM(`my_score`) AS ndScore FROM `mar_emp_data` WHERE deleted=0 AND mar_year_data ='$dYear' AND mar_semester_data='2' AND `emp_rec_id`='$userID'"; $qkND = mysqli_query($conn,$kND); while($mar = mysqli_fetch_array($qkND)){ $avgsndScore = $mar['ndScore']; } $avgstScoreXb = $avgsndScore / 6; echo "<p class='text-dark text-center pt-3 text-light' style='font_family:Gothic Light;font-size:250%;'>".number_format($avgstScoreXb,2,'.','')." %</p>"; ?> </div> </div> <div id="chartCa" class='col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12 float-left bg-white' style='box-shadow:0px 0px 0px lightgray;height:500px;margin-bottom:50px;margin-top:40px'></div> <div class='col-xl-12 col-lg-12 col-md-12 col-sm-12 col-xs-12 float-left bg-white border p-4' style='overflow:auto;box-shadow:0px 0px 0px lightgray;height:500px;margin-bottom:50px;margin-top:40px'> <div class="col-lg-12 p-0 mb-1 bg-light text-dark font-weight-bold">COMMENTS/NOTES FROM YOUR HEAD</div> <?php $gNote = "SELECT `part_three_strength`,`part_three_improvement`, `rated_date` FROM `pef_evaluation_data` WHERE `rated_date` LIKE '%$dYear%' AND `emp_record_id` = $userID AND `deleted`=0"; $qgNote = mysqli_query($conn,$gNote); $gRow = mysqli_num_rows($qgNote); if($gRow > 0){ echo "<h6 class='text-left text-primary '>Your Strenght and Contribution :</h6>"; while($msg = mysqli_fetch_array($qgNote)){ $tsDate = $msg['rated_date']; $ratedDate = explode(" ", $tsDate); $ratedDYear = $ratedDate[0]; echo "<p class='text-left text-dark'>".$msg['part_three_strength']." ( <i class='text-dark' style='font-size:12px'>".$ratedDYear."</i> )</p>"; } $gNotea = "SELECT `part_three_strength`,`part_three_improvement`, `rated_date` FROM `pef_evaluation_data` WHERE `rated_date` LIKE '%$dYear%' AND `emp_record_id` = $userID AND `deleted`=0"; $qgNotea = mysqli_query($conn,$gNotea); $gRowa = mysqli_num_rows($qgNotea); echo "<h6 class='text-left text-danger' style='margin-top:20px'>Areas for Improvement / Development needs</h6>"; while($msgA = mysqli_fetch_array($qgNotea)){ $rtDate = $msgA['rated_date']; $ratedDates = explode(" ", $rtDate); $ratedrtYear = $ratedDates[0]; echo "<p class='text-left text-dark'>".$msgA['part_three_improvement']." ( <i class='text-dark' style='font-size:12px'>".$ratedrtYear."</i> )</p>"; } }else{ echo "<h6 class='text-center p-5'> No message has found.</h6>"; } echo "<div class='p-0 mb-2 mt-5 bg-light text-dark font-weight-bold'>NEXT HIGHER HEAD NOTES</div>"; $gNxt = "SELECT `next_head_notes`, `rated_date` FROM `pef_evaluation_data` WHERE `rated_date` LIKE '%$dYear%' AND `emp_record_id` = $userID AND `deleted`=0"; $qNxt = mysqli_query($conn,$gNxt); $gRowa = mysqli_num_rows($qNxt); while($nxt = mysqli_fetch_array($qNxt)){ $rtDate = $nxt['rated_date']; $rNxtdDates = explode(" ", $rtDate); $nxtYear = $rNxtdDates[0]; echo "<p class='text-left text-dark'>".$nxt['next_head_notes']." ( <i class='text-dark' style='font-size:12px'>".$nxtYear."</i> )</p>"; } ?> </div> <!--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --> <!--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --> </div> </div> </body> </html> <!-- style='box-shadow:0px 0px 0px lightgray;height:300px' --> <?php $conn->close(); } ?>

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