File manager

File manager - Edit - /home/autoph/public_html/portal/includes/pms_editemployeeKRA.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> <script type="text/javascript" charset="utf-8"> $( function() { var userName = <?php $d = mysql_query( "SELECT * FROM `kras` WHERE `tag`='DEAL' AND `deal_code`='$dealCode' ORDER BY `kra` ASC" ); $usernames = array(); while( $r = mysql_fetch_assoc($d) ) { $usernames[] = $r['kra'].'---'.$r['id']; } echo json_encode( $usernames ); ?>; $( "#dealKRAList" ).autocomplete({ source: userName }); } ); </script> <script type="text/javascript" charset="utf-8"> $( function() { var userName = <?php $d = mysql_query( "SELECT * FROM `kras` WHERE `tag`='DEPT' AND `deal_code`='$dealCode' ORDER BY `kra` ASC" ); $usernames = array(); while( $r = mysql_fetch_assoc($d) ) { $usernames[] = $r['kra'].'---'.$r['id']; } echo json_encode( $usernames ); ?>; $( "#deptKRAList" ).autocomplete({ source: userName }); } ); </script> <?php $kraID =$_GET['id']; $getDealerID = mysql_result(mysql_query("SELECT `deal_id` FROM `kras` WHERE `id`='$kraID'"),0); $getCompID = mysql_result(mysql_query("SELECT `comp_id` FROM `kras` WHERE `id`='$kraID'"),0); $getDeptID = mysql_result(mysql_query("SELECT `dept_id` FROM `kras` WHERE `id`='$kraID'"),0); $getCompCode = mysql_result(mysql_query("SELECT `comp_code` FROM `kras` WHERE `id`='$kraID'"),0); $getDeptCode = mysql_result(mysql_query("SELECT `dept_code` FROM `kras` WHERE `id`='$kraID'"),0); $getEmpCode = mysql_result(mysql_query("SELECT `emp_code` FROM `kras` WHERE `id`='$kraID'"),0); $getDealerCode = mysql_result(mysql_query("SELECT `deal_code` FROM `kras` WHERE `id`='$kraID'"),0); $dealName = mysql_result(mysql_query("SELECT `name` FROM `dealers` WHERE `dcode`='$getDealerCode'"),0); $deptName = mysql_result(mysql_query("SELECT `name` FROM `departments` WHERE `code`='$getDeptCode'"),0); $empFName = mysql_result(mysql_query("SELECT `first_name` FROM `employee_list` WHERE `employee_id`='$getEmpCode'"),0); $empLName = mysql_result(mysql_query("SELECT `last_name` FROM `employee_list` WHERE `employee_id`='$getEmpCode'"),0); $kraWeight = mysql_result(mysql_query("SELECT `kra_weight` FROM `kras` WHERE `id`='$kraID'"),0); $kraDesc = mysql_result(mysql_query("SELECT `kra` FROM `kras` WHERE `id`='$kraID'"),0); $deptKRAID = mysql_result(mysql_query("SELECT `kra_dept_id` FROM `kras` WHERE `id`='$kraID'"),0); $deptKRADesc = mysql_result(mysql_query("SELECT `kra` FROM `kras` WHERE `id`='$deptKRAID'"),0); $empKRADesc = mysql_result(mysql_query("SELECT `kra` FROM `kras` WHERE `id`='$kraID'"),0); $loadDept =$deptName."---".$getDeptCode; $loadDeal =$dealName."---".$getDealerCode; $loadEmp =$empLName.", ".$empFName."---".$getEmpCode; $loadDeptKRA =$deptKRADesc."---".$deptKRAID; $loadEmpKRA =$empKRADesc."---".$kraID; if(isset($_POST['SaveRecord'])){ $kraID =$_GET['id']; $deptName = $_POST['deptName']; $exDeptName = explode('---',$deptName); $deptCode = $exDeptName[1]; $myDeptID = mysql_result(mysql_query("SELECT `id` FROM `departments` WHERE `code`='$deptCode'"),0); $dealerName = $_POST['dealerName']; $exDealerName = explode('---',$dealerName); $dealerCode = $exDealerName[1]; $myDealID = mysql_result(mysql_query("SELECT `id` FROM `dealers` WHERE `dcode`='$dealerCode'"),0); $myCompCode = mysql_result(mysql_query("SELECT `ccode` FROM `dealers` WHERE `dcode`='$dealerCode'"),0); $myCompID = mysql_result(mysql_query("SELECT `id` FROM `company` WHERE `code`='$myCompCode'"),0); $kraDeptKRA = $_POST['kraDeptKRA']; $exDeptKRA = explode('---',$kraDeptKRA); $deptKRAID= $exDeptKRA[1]; $kraEmpName = $_POST['kraEmpName']; $exEmpKRA = explode('---',$kraEmpName); $empKRAID= $exEmpKRA[1]; $kraEmpKRA = $_POST['kraEmpKRA']; $kraWeight = $_POST['kraWeight']; $kraEmployeeKRA = mysql_real_escape_string($kraEmpKRA); mysql_query("UPDATE `kras` SET `comp_id`='$myCompID',`deal_id`='$myDealID',`dept_id`='$myDeptID',`deal_code`='$dealerCode',`comp_code`='$myCompCode',`dept_code`='$deptCode',`emp_code`='$empKRAID',`kra`='$kraEmployeeKRA',`kra_weight`='$kraWeight',`created_by`='$user',`date`='$toDate',`time`='$currentTime',`kra_dept_id`='$deptKRAID' WHERE `id`='$kraID'"); 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=KE1&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=KE1&sview=100&tab=2#id-0' ><input type='button' class='button' value='CLOSE' style='width:80px;'></a></center> </a> </p>"; echo "</div>"; } ?> <body> <center> <div style='width:98%;border:1px solid #E6E6E6;height:310px;padding:5px'> <form action='' method='POST'> <table style='width:100%;border:1px solid white'> <tr style='background:white;border:1px solid white'> <td valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:40%'> <div align='left' class="form-group" style='width:90%;padding:15px;font-size:12px;color:black;font-weight:normal'> SELECT DEPARTMENT:<BR> <ABBR title='SELECT DEPARTMENT'> <input REQUIRED id='deptList' class='textbox' type="text" value='<?php echo $loadDept;?>' placeholder="" name="deptName" style='background:white;width:100%;margin-top:5px;font-size:14px;font-weight:bold'> </ABBR> </div> </td> <td valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:40%'> <div align='left' class="form-group" style='width:90%;padding:15px;font-size:12px;color:black;font-weight:normal'> SELECT DEALERSHIP:<BR> <ABBR title='SELECT DEALERSHIP'> <input REQUIRED id='dealList' class='textbox' type="text" value='<?php echo $loadDeal;?>' placeholder="" name="dealerName" style='background:white;width:100%;margin-top:5px;font-size:14px;font-weight:bold'> </div> </td> <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='padding:15px;font-size:12px;color:black;font-weight:normal;border:1px solid white'> DEPARTMENT KRA:<BR> <ABBR title='SELECT/TYPE DEPARTMENT KRA'> <input REQUIRED id='deptKRAList' class='textbox' type="text" value='<?php echo $loadDeptKRA;?>' placeholder="" name="kraDeptKRA" style='background:white;width:100%;margin-top:5px;font-size:14px;font-weight:bold'> </ABBR> </div> </td> </tr> <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='padding:15px;font-size:12px;color:black;font-weight:normal;border:1px solid white'> EMPLOYEE'S KRA:<br> <ABBR title='DEALERS KRA should have a matching record or entry under the Company KRA'> <input REQUIRED class='textbox' type="text" value='<?php echo $loadEmpKRA;?>' placeholder="" name="kraEmpKRA" style='background:white;width:100%;margin-top:5px;font-size:14px;font-weight:bold'></ABBR> </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:40%'> <div align='left' class="form-group" style='padding:15px;font-size:12px;color:black;font-weight:normal;border:1px solid white'> WEIGHT ALLOCATION: <BR> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:12px;padding-left:0px;color:gray;font-weight:normal'> <ABBR title='KRA WEIGHT ALLOCATION'> <input REQUIRED class='textbox' type="text" value='<?php echo $kraWeight;?>' placeholder="" name="kraWeight" style='background:white;width:50%;margin-top:5px;font-size:14px;font-weight:bold'></ABBR> </p> </div> </td> <td valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:40%'> </td> </tr> </table> <div align='right' class="form-group" style='padding:10px'> <input type='submit' class='submit' name='SaveRecord' value='SAVE RECORD'> <a href='main_new.php?view=107&sid=KEE&sview=100&tab=2#id-0'><input type='button' class='submit' name='Exit' value='EXIT' style='width:100px;'></a> </div> </form> </div> </center> </body> </html>

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