File manager

File manager - Edit - /home/autoph/public_html/portal/includes/pms_editnewemployee.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> <script type="text/javascript" charset="utf-8"> $( function() { var userName = <?php $d = mysql_query( "SELECT * FROM `employee_list` WHERE `level`!='SUPERVISOR' AND `level`!='RANK AND FILE' ORDER BY `last_name` ASC" ); $usernames = array(); while( $r = mysql_fetch_assoc($d) ) { $usernames[] = $r['last_name']." ".$r['first_name'].'---'.$r['employee_id']; } echo json_encode( $usernames ); ?>; $( "#empListManager" ).autocomplete({ source: userName }); } ); </script> <script type="text/javascript" charset="utf-8"> $( function() { var userName = <?php $d = mysql_query( "SELECT * FROM `employee_list` WHERE `level`='SUPERVISOR' ORDER BY `last_name` ASC" ); $usernames = array(); while( $r = mysql_fetch_assoc($d) ) { $usernames[] = $r['last_name']." ".$r['first_name'].'---'.$r['employee_id']; } echo json_encode( $usernames ); ?>; $( "#empListSupervisor" ).autocomplete({ source: userName }); } ); </script> </head> <?php $emplID=$_GET['id']; $accessType = $user_data['account_type']; if($accessType != 'ADMIN' && $accessType!='USER'){ secalert_new(); break; } $emID = mysql_result(mysql_query("SELECT `employee_id` FROM `employee_list` WHERE `id`='$emplID'"),0); $emLName = mysql_result(mysql_query("SELECT `last_name` FROM `employee_list` WHERE `id`='$emplID'"),0); $emFName = mysql_result(mysql_query("SELECT `first_name` FROM `employee_list` WHERE `id`='$emplID'"),0); $emMI = mysql_result(mysql_query("SELECT `middle_name` FROM `employee_list` WHERE `id`='$emplID'"),0); $emGender = mysql_result(mysql_query("SELECT `gender` FROM `employee_list` WHERE `id`='$emplID'"),0); $emPosition = mysql_result(mysql_query("SELECT `position` FROM `employee_list` WHERE `id`='$emplID'"),0); $emLevel = mysql_result(mysql_query("SELECT `level` FROM `employee_list` WHERE `id`='$emplID'"),0); $emMobile = mysql_result(mysql_query("SELECT `mobile_number` FROM `employee_list` WHERE `id`='$emplID'"),0); $emEmail = mysql_result(mysql_query("SELECT `e_mail` FROM `employee_list` WHERE `id`='$emplID'"),0); $emComp = mysql_result(mysql_query("SELECT `ccom_code` FROM `employee_list` WHERE `id`='$emplID'"),0); $emCompName = mysql_result(mysql_query("SELECT `name` FROM `company` WHERE `code`='$emComp'"),0).'---'.$emComp; $emDeal = mysql_result(mysql_query("SELECT `deal_code` FROM `employee_list` WHERE `id`='$emplID'"),0); $emDealName = mysql_result(mysql_query("SELECT `name` FROM `dealers` WHERE `dcode`='$emDeal'"),0).'---'.$emDeal; $emDept = mysql_result(mysql_query("SELECT `dept_code` FROM `employee_list` WHERE `id`='$emplID'"),0); $emDeptName = mysql_result(mysql_query("SELECT `name` FROM `departments` WHERE `code`='$emDept'"),0).'---'.$emDept; $emDeptHead = mysql_result(mysql_query("SELECT `head_id` FROM `employee_list` WHERE `id`='$emplID'"),0); $emDeptHeadFName = mysql_result(mysql_query("SELECT `first_name` FROM `employee_list` WHERE `id`='$emDeptHead'"),0); $emDeptHeadLName = mysql_result(mysql_query("SELECT `last_name` FROM `employee_list` WHERE `id`='$emDeptHead'"),0); $emHeadName = $emDeptHeadLName.', '.$emDeptHeadFName.'---'.$emDeptHead; $emDeptSup = mysql_result(mysql_query("SELECT `head_id` FROM `employee_list` WHERE `id`='$emplID'"),0); $emDeptSupFName = mysql_result(mysql_query("SELECT `first_name` FROM `employee_list` WHERE `id`='$emDeptSup'"),0); $emDeptSupLName = mysql_result(mysql_query("SELECT `last_name` FROM `employee_list` WHERE `id`='$emDeptSup'"),0); $emSupName = $emDeptSupLName.', '.$emDeptSupFName.'---'.$emDeptSup; if(isset($_POST['SaveRecord'])){ $emplID=$_GET['id']; $empID =$_POST['empID']; $compName =$_POST['compName']; $comN = explode('---',$compName); $companyID = $comN[1]; $dealName =$_POST['dealName']; $delN = explode('---',$dealName); $dealerID = $delN[1]; $deptName =$_POST['deptName']; $deptN = explode('---',$deptName); $deptN = $deptN[1]; $deptHead =$_POST['deptHead']; $depEmp = explode('---',$deptHead); $deptHeadID = $depEmp[1]; $deptSupervisor =$_POST['deptSupervisor']; $depSupEmp = explode('---',$deptSupervisor); $deptSupID = $depSupEmp[1]; $empEmail =$_POST['empEmail']; $lName=$_POST['lName']; $fName=$_POST['fName']; $mName =$_POST['mName']; $empPosition =$_POST['empPosition']; $empGender =$_POST['empGender']; $empClass =$_POST['empClass']; $empMobile =$_POST['empMobile']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); mysql_query("UPDATE `employee_list` SET `ccom_code`='$companyID',`deal_code`='$dealerID',`dept_code`='$deptN',`head_id`='$deptHeadID',`supervisor_id`='$deptSupID',`last_name`='$lName',`first_name`='$fName',`middle_name`='$mName',`position`='$empPosition',`gender`='$empGender',`level`='$empClass',`mobile_number`='$empMobile',`e_mail`='$empEmail' WHERE `id`='$emplID'"); 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=102&sid=P1&sview=100&tab=0#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'>RECORDS HAS BEEN MODIFIED...</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=103&sid=E1&sview=100&tab=1#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 white;height:25px;text-align:left;padding-left:10px;padding-top:5px;font-family:Calibri;font-size:14px;color:#000;text-shadow:1px 1px 5px #fff' class='lightGradient'>EMPLOYEE'S INFORMATION <div style='position:relative;float:right;font-family:Calibri;font-size:12px;margin-right:10px'> </div> </div> <div style='width:98%;border:1px solid #E6E6E6;height:302px;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:70%'> <div align='left' class="form-group" style='padding:10px'> <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='COMPANY ASSIGNMENT'> <input REQUIRED id='complist' class='textbox' type="text" value='<?php echo $emCompName;?>' placeholder="COMPANY ASSIGNMENT" name="compName" style='background:white;width:33%;margin-top:5px'></ABBR> <ABBR title='DEALER ASSIGNMENT'> <input REQUIRED id='dealList' class='textbox' type="text" value='<?php echo $emDealName;?>' placeholder="DEALER ASSIGNMENT" name="dealName" style='background:white;width:33%; margin-top:5px'></ABBR> <ABBR title='DEPARTMENT ASSIGNMENT'> <input REQUIRED id='deptList' class='textbox' type="text" value='<?php echo $emDeptName;?>' placeholder="DEPARTMENT ASSIGNMENT" name="deptName" style='background:white;width:30%; margin-top:5px'></ABBR> </p> </div> <div align='left' class="form-group" style='padding:10px'> <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='LAST NAME'> <input REQUIRED class='textbox' type="text" value='<?php echo $emLName;?>' placeholder="LAST NAME" name="lName" style='background:white;width:32%;min-width:220px;margin-top:5px'></ABBR> <ABBR title='FIRST NAME'> <input REQUIRED class='textbox' type="text" value='<?php echo $emFName;?>' placeholder="FIRST NAME" name="fName" style='background:white;width:35%;min-width:220px;margin-top:5px'></ABBR> <ABBR title='MIDDLE NAME'> <input REQUIRED class='textbox' type="text" value='<?php echo $emMI;?>' placeholder="M.I" name="mName" style='background:white;width:10%;min-width:100px;margin-top:5px'></ABBR> <ABBR title='GENDER'> <select class='textbox' name="empGender" style='background:white;width:15%;margin-top:5px'> <option><?php echo $emGender;?></option> <option>MALE</option> <option>FEMALE</option> </select></ABBR> </p> <div align='left' class="form-group" style='padding:10px'> <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='REPORT TO:'> <input REQUIRED class='textbox' id='empListManager' type="text" value='<?php echo $emHeadName;?>' placeholder="DEPARTMENT HEAD" name="deptHead" style='background:white;width:40%;min-width:220px;margin-top:5px'></ABBR> <ABBR title='SUPERVISOR'> <input REQUIRED class='textbox' id='empListSupervisor' type="text" value='<?php echo $emSupName;?>' placeholder="SUPERVISOR" name="deptSupervisor" style='background:white;width:40%;min-width:220px;margin-top:5px'></ABBR> </p> </div> <div align='left' class="form-group" style='padding:10px'> <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='POSITION'> <input REQUIRED class='textbox' type="text" value='<?php echo $emPosition;?>'placeholder="POSITION" name="empPosition" style='background:white;width:40%;min-width:220px;margin-top:5px'></ABBR> <ABBR title='POSITION CLASSIFICATION'> <select class='textbox' name="empClass" style='background:white;width:40%;min-width:220px;margin-top:5px'> <option> <?php echo $emLevel;?></option> <option>RANK & FILE</option> <option>SUPERVISOR</option> <option>MANAGER</option> <option>EXECUTIVE</option> </select> </ABBR> <ABBR title='EMPLOYEE ID'> <input REQUIRED class='textbox' type="text" placeholder="EMPLOYEE ID" value='<?php echo $emID;?>' disabled name="empID" style='background:white;width:10%;min-width:100px;margin-top:5px'></ABBR> </p> </div> <div align='left' class="form-group" style='padding:10px'> <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='MOBILE NUMBER'> <input REQUIRED class='textbox' type="text" value='<?php echo $emMobile;?>'placeholder="MOBILE NUMBER" name="empMobile" style='background:white;width:20%;min-width:220px;margin-top:5px'></ABBR> <ABBR title='E-MAIL ADDRESS'> <input REQUIRED class='textbox' type="text" value='<?php echo $emEmail;?>'placeholder="E-MAIL ADDRESS" name="empEmail" style='background:white;width:65%;min-width:220px;margin-top:5px'> </ABBR> </p> </div> </td> </tr> </table> <div align='right' class="form-group" style='padding:10px'> <input type='submit' class='submit' name='SaveRecord' value='UPDATE RECORD'> <a href='main_new.php?view=103&sid=E1&sview=100&tab=1#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