File manager

File manager - Edit - /home/autoph/public_html/portal/includes/pms_addemployeeKRA.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 $accessType = $user_data['account_type']; if($accessType != 'ADMIN' && $accessType!='USER'){ secalert_new(); break; } if(isset($_POST['SaveRecord'])){ $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= ''; $kraEmpKRA = $_POST['kraEmpKRA']; $kraWeight = $_POST['kraWeight']; $kraEmployeeKRA = mysql_real_escape_string($kraEmpKRA); $sql="INSERT INTO `kras` (`id`,`comp_id`,`deal_id`,`dept_id`,`deal_code`,`comp_code`,`dept_code`,`emp_code`,`kra`,`kra_weight`,`status`,`created_by`,`date`,`time`,`tag`,`kra_comp_id`,`kra_deal_id`,`kra_dept_id`) VALUES('','$myCompID','$myDealID','$myDeptID','$dealerCode','$myCompCode','$deptCode','$empKRAID','$kraEmployeeKRA','$kraWeight','1','$user','$toDate','$currentTime','EMPL','','','$deptKRAID')"; 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=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:50%'> <div align='left' class="form-group" style='width:100%;padding:10px;font-size:12px;color:black;font-weight:normal'> SELECT DEPARTMENT:<BR> <ABBR title='SELECT DEPARTMENT'> <input REQUIRED id='deptList' class='textbox' type="text" value='' 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:50%'> <div align='left' class="form-group" style='width:100%;padding:10px;font-size:12px;color:black;font-weight:normal'> SELECT DEALERSHIP:<BR> <ABBR title='SELECT DEALERSHIP'> <input REQUIRED id='dealList' class='textbox' type="text" value='' 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:20px;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='' 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:20px;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='' 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:20px;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='' placeholder="" name="kraWeight" style='background:white;width:50%;margin-top:5px'></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=KE1&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