File manager

File manager - Edit - /home/autoph/public_html/portal/includes/pms_AddEmployeeKPI.php

Back
<html> <head> <title>THE AUTOHUB GROUP</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="css/screen_white.css"> <link rel="stylesheet" href="ajs/vendors/jQueryUI/jquery-ui.css"> <script src="ajs/vendors/jQueryUI/jquery-1.12.4.js"></script> <script src="ajs/vendors/jQueryUI/jquery-ui.js"></script> </head> <?php $kraID =$_GET['id']; $getKRADesc= mysql_result(mysql_query("SELECT `kra` FROM `kras` WHERE `id`='$kraID'"),0); if(isset($_POST['SaveRecord'])){ $kraID =$_GET['id']; $empID = mysql_result(mysql_query("SELECT `emp_code` FROM `kras` WHERE `id`='$kraID'"),0); $compID = mysql_result(mysql_query("SELECT `comp_id` FROM `kras` WHERE `id`='$kraID'"),0); $dealID = mysql_result(mysql_query("SELECT `deal_id` FROM `kras` WHERE `id`='$kraID'"),0); $deptID = mysql_result(mysql_query("SELECT `dept_id` FROM `kras` WHERE `id`='$kraID'"),0); $newKPI=$_POST['newKPI']; $newTarget=$_POST['newTarget']; $newWeight=$_POST['newWeight']; $newTimeLine=$_POST['newTimeLine']; $sql="INSERT INTO `kpi_list` (`id`,`kra_id`,`comp_id`,`deal_id`,`dept_id`,`emp_id`,`kpi_desc`,`kpi_weight`,`kpi_target`,`kpi_timeline`,`status`,`created_by`,`date`,`time`) VALUES('','$kraID','$compID','$dealID','$deptID','$empID','$newKPI','$newWeight','$newTarget','$newTimeLine','1','$user','$toDate','$currentTime')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "<div class='ContinueMSG'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:18px;font-weight:bold;padding-left:5px;padding-top:2px;'>NEW RECORD SAVED...</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=107&sid=KEE&sview=100&tab=2#id-0' > <center>X</center> </a> </div>"; echo " <br><br><h2 style='margin-top:2px;text-align:center;width:100%;font-family:Calibri Light;font-size:16px;font-weight:normal'>NEW DEPARTMENT CREATED...</h2> <p style='font-family:Calibri Light;font-size:14px;color:#0B610B;font-weight:bold;padding-top:0px'> <br><br> <center> <a href='main_new.php?view=107&sid=KEE&sview=100&tab=2#id-0' > <input type='button' class='button' value='CLOSE' style='width:80px;'> </a> <a href='main_new.php?id=".$_GET['id']."&view=107&sview=100&sid=KEE&action=kpi&tab=2#id-0' > <input type='button' class='button' value='ADD NEW' style='width:80px;'> </a> </center> </a> </p>"; echo "</div>"; } } ?> <body> <center> <div style='width:98%;border:1px solid #E6E6E6;height:310px;padding:5px'> <table style='width:100%;border:1px solid white'> <tr style='background:white;border:1px solid white'> <td colspan='2' valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:100%'> <div align='left' class="form-group" style='margin-top:10px;padding:5px;font-size:12px;color:black;font-weight:normal;border:1px solid GRAY'> <?php echo "<div style='top:30px;left:3%;position:absolute;z-index:3;background:white;border:1px solid white;padding:5px;font-family:Calibri;color:red;font-size:16px;border-radius:5px;border-left:1px solid white;border-right:1px solid white'> <b style='font-family:Calibri;color:red;font-size:16px;'>KRA: </b>".$getKRADesc." </div>"; ?> <br><FORM ACTION='' METHOD='POST'> <table style='width:100%;border:1px solid white'> <tr style='background:white;border:1px solid white'> <td colspan='1' valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:39%'> <div align='left' class="form-group" style='margin-top:10px;padding:5px;font-size:14px;color:black;font-weight:normal;border:1px solid white'> ADD NEW KEY PERFORMANce INDICATOR:<BR> <textarea rows='2' name='newKPI' value='' REQUIRED style='width:100%;padding:5px;font-size:12px;color:blue;border:1px solid lightgray'></textarea> </div> </td> <td colspan='1' valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:39%'> <div align='left' style='margin-top:10px;padding:5px;font-size:14px;color:black;font-weight:normal;border:1px solid white'> PERFORMANCE TARGET:<BR> <textarea rows='2' name='newTarget' value='' REQUIRED style='width:100%;padding:5px;font-size:12px;color:blue;border:1px solid lightgray'></textarea> </div> </td> <td rowspan='2' valign='bottom' style='background:white;border:1px solid white;border-right:1px solid white;width:20%'> <div align='right' class="form-group" style='padding:5px'> <input type='submit' class='submit' name='SaveRecord' value='ADD RECORD' style='width:90%;height:120px'><br><br> </div> </td> </tr> <tr style='background:white;border:1px solid white'> <td colspan='1' valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:20%'> <div align='left' style='margin-top:10px;padding:5px;font-size:12px;color:black;font-weight:normal;border:1px solid white'> WEIGHT:<BR> <textarea rows='1' name='newWeight' value='' REQUIRED style='width:100%;padding:5px;font-size:12px;color:blue;border:1px solid lightgray'></textarea> </div> </td> <td colspan='1' valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:20%'> <div align='left' style='margin-top:10px;padding:5px;font-size:12px;color:black;font-weight:normal;border:1px solid white'> TIMELINE:<BR> <textarea rows='1' name='newTimeLine' value='' REQUIRED style='width:100%;padding:5px;font-size:12px;color:blue;border:1px solid lightgray'></textarea> </div> </td> <tr> </table> </FORM> </div> </td> </tr> <tr style='background:white;border:1px solid white'> <td valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:100%'> <br><div align='left' class="form-group" style='height:180px;padding:5px;font-size:12px;color:black;font-weight:normal;border:1px solid gray'> <?php echo "<div style='top:275px;left:3%;position:absolute;z-index:3;background:white;border:1px solid white;padding:5px;font-family:Calibri;color:red;font-size:12px;border-radius:5px;z-index:5'> KPI SUMMARY </div>"; ?> <?php $qq=mysql_query("SELECT * FROM `kpi_list` WHERE `status`='1' AND `kra_id`='$kraID' ORDER by `kpi_desc` ASC "); echo "<div STYLE='height: 155px; width: 100%;padding:1px; font-size: 12px; overflow: auto;z-index:10'> <table style='width:100%; height:100% border:1px solid gray; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' align='center' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:10px'></th> <th class='Gradient' align='left' style='padding-left:5px;width:10%;background:#f5f5f5;border:1px solid lightgray;font-size:10px'>WEIGHT</th> <th class='Gradient' align='left' style='padding-left:5px;width:35%;background:#f5f5f5;border:1px solid lightgray;font-size:10px'>KEY PERFORMANCE INDICATOR</th> <th class='Gradient' align='left' style='padding-left:5px;width:35%;background:#f5f5f5;border:1px solid lightgray;font-size:10px'>PERFORMANCE TARGET</th> <th class='Gradient' align='left' style='padding-left:5px;width:15%;background:#f5f5f5;border:1px solid lightgray;font-size:10px'>TIMELINE</th>"; echo "</tr>"; while($row = mysql_fetch_array($qq)){ echo "<tr>"; echo "<td class='tableList' align='center' style='font-family:Calibri Light;font-size:10px;color:black;padding:1px;'> <ABBR title='Delete Record'><a href='main_new.php?id=".$row['id']."&view=107&sview=100&sid=KEE&action=delete&tab=2#id-0'> <img src='images/rica/delete_b.png'></img></a></ABBR> </td>"; echo "<td class='tableList' style='font-family:Calibri Light;font-size:10px;color:black;padding:1px;' ><center>".$row['kpi_weight']."</center></td>"; echo "<td class='tableList' align='left' style='font-family:Calibri Light;font-size:10px;color:black;padding:1px;'>".$row['kpi_desc']."</td>"; echo "<td class='tableList' align='left' style='font-family:Calibri Light;font-size:10px;color:black;padding:1px;'>".$row['kpi_target']."</td>"; echo "<td class='tableList' align='left' style='font-family:Calibri Light;font-size:10px;color:black;padding:1px;'>".$row['kpi_timeline']."</td>"; echo "</tr>"; } echo "</table>"; ?> </div> </td> </tr> </table> </div> </center> </body> </html>

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