File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_EDIT_LOAD_DATA.php

Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); $compID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); if(isset($_POST['done'])){ $recordID = mysql_escape_string($_POST['recordID']); $addCompID = mysql_escape_string($_POST['addCompID']); $empID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $tempateID = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clCompID = mysql_result(mysql_query("SELECT `cl_h_comp_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clReason = mysql_result(mysql_query("SELECT `cl_h_reason` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clReasonFrom = mysql_result(mysql_query("SELECT `cl_h_reason_from` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clReasonTo = mysql_result(mysql_query("SELECT `cl_h_reason_to` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clReasonNotes = mysql_result(mysql_query("SELECT `cl_h_reason_notes` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clDateHired = mysql_result(mysql_query("SELECT `cl_date_hired` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clEmpPosition = mysql_result(mysql_query("SELECT `cl_emp_position` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clEmpDesignation = mysql_result(mysql_query("SELECT `cl_emp_designated` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clUnitAssignment = mysql_result(mysql_query("SELECT `cl_unit_assignment` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clSharedServices = mysql_result(mysql_query("SELECT `cl_shared_services` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $clEmpStat = mysql_result(mysql_query("SELECT `cl_h_employment_status` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); if($clEmpStat === "REG"){ $clEmpStatName = "REGULAR"; } if($clEmpStat === "CON"){ $clEmpStatName = "CONTRACTUAL"; } if($clEmpStat === "PRJ"){ $clEmpStatName = "PROJECT BASED"; } if($clEmpStat === "PRO"){ $clEmpStatName = "PROBATIONARY"; } switch($clReason){ case 'LOAB': $clReasonName = "Leave of Absense"; break; case 'RASS': $clReasonName = "ReAssignment"; break; case 'TRAN': $clReasonName = "Transfer"; break; case 'DETL': $clReasonName = "Detail"; break; case 'SUS': $clReasonName = "Suspension"; break; case 'REMP': $clReasonName = "Leave of Absense"; break; case 'RESA': $clReasonName = "Resignation"; break; case 'IRES': $clReasonName = "Involuntary Resignation"; break; case 'RETR': $clReasonName = "Retirement"; break; } $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$clEmpPosition'"),0); $clCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$clCompID'"),0); } ?> <div style="float:left;width:50%;height:100%;padding:10px;"> <!-------------------- --> <div style="width:100%;position:relative;border:0px solid red;height:70px"> <div style="float:left;width:70%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>SELECT EMPLOYEE:</p> <select id="SelEmpIDe" style="width:100%;"> <?php $getAdminList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `deleted`=0 ORDER BY `u_lname` ASC"); echo "<option value='".$empID."'>".$uLName.", ".$uFName."</option>"; while($row=mysql_fetch_array($getAdminList)){ echo "<option value='".$row['u_id']."'>".$row['u_lname'].", ".$row['u_fname']." - ".$row['u_position']."</option>"; } ?> </select> </div> <div style="float:left;width:30%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>EMPLOYEE ID:</p> <input type="text" id="empIDe" value="<?php echo $uEMPID;?>" style='margin:0px'> </div> </div> <!-------------------- --> <div style="width:100%;position:relative;border:0px solid red;height:70px"> <div style="float:left;width:50%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>EMPLOYMENT STATUS:</p> <select id='employmentStatuse'> <?php echo "<option value='".$clEmpStat."'>".$clEmpStatName."</option>";?> <option value='REG'>Regular</option> <option value='PRO'>Probationary</option> <option value='CON'>Contractual</option> <option value='PRJ'>Project Based</option> </select> </div> <div style="float:left;width:50%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>DATE HIRED:</p> <input type="date" id="empDateHirede" value="<?php echo $clDateHired;?>" style='width:100%;margin:0px'> </div> </div> <!-------------------- --> <div style="width:100%;position:relative;border:0px solid red;height:70px"> <div style="float:left;width:50%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>POSITION TITLE:</p> <select id='employeePositione'> <?php echo "<option value='".$clEmpPosition."'>".$uPosition."</option>"; $gePosition = mysql_query("SELECT * FROM `db_positions` WHERE `status` = 1 ORDER BY `position_title` ASC"); while($row=mysql_fetch_array($gePosition)){ echo "<option value='".$row['pid']."'>".$row['position_title']."</option>"; } ?> </select> </div> <div style="float:left;width:50%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>WORKING TITLE:</p> <input type="text" id="empDesignatede" value="<?php echo $clEmpDesignation;?>" style='margin:0px'> </div> </div> <!-------------------- --> <div style="width:100%;position:relative;border:0px solid red;height:70px"> <div style="float:left;width:50%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>CURRENT UNIT ASSIGNMENT:</p> <input type="text" id="empUnitAssignmente" value="<?php echo $clUnitAssignment;?>" style='margin:0px'> </div> <div style="float:left;width:50%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>COMPANY:</p> <select id='empCompanye'> <?php echo "<option value='".$clCompID."'>".$clCompName."</option>"; $gePosition = mysql_query("SELECT * FROM `vts_company` WHERE `comp_status` = 1 ORDER BY `comp_code` ASC"); while($row=mysql_fetch_array($gePosition)){ echo "<option value='".$row['comp_id']."'>".$row['comp_code']."</option>"; } ?> </select> </div> </div> <!-------------------- --> </div> <div style="float:left;width:50%;height:100%;padding:10px;"> <div style="width:100%;position:relative;border:0px solid red;height:70px"> <div style="float:left;width:100%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>SHARED SERVICES:</p> <input type="text" id="empSharedServicese" value="<?php echo $clSharedServices;?>" style='margin:0px'> </div> </div> <!-------------------- --> <div style="width:100%;position:relative;border:0px solid red;height:70px"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>REASON FOR SECURING CLEARANCE:</p> <select id='clearanceReasone'> <?php echo "<option value='".$clReason."'>".$clReasonName."</option>";?> <option value='LOAB'>Leave Of Absence</option> <option value='RASS'>ReAssignment</option> <option value='TRAN'>Transfer</option> <option value='DETL'>Detail</option> <option value='SUS'>Suspension</option> <option value='REMP'>ReEmployment</option> <option value='RESA'>Resignation</option> <option value='IRES'>Involuntary Resignation</option> <option value='RETR'>Retirement</option> </select> </div> <!-------------------- --> <div style="width:100%;position:relative;border:0px solid red;height:70px"> <div style="float:left;width:50%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>FROM:</p> <input type="text" id="reasonFrome" value="<?php echo $clReasonFrom;?>" style='margin:0px'> </div> <div style="float:left;width:50%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>TO:</p> <input type="text" id="reasonToe" value="<?php echo $clReasonTo;?>" style='margin:0px'> </div> </div> <!-------------------- --> <div style="float:left;width:100%;height:auto;padding:1px;"> <p style='width:100%;padding:1px;margin:1px;font-size:16px;padding-top:10px;font-weight:normal'>CLEARANCE NOTE:</p> <textarea id="empClearanceNotee" style='margin:0px;width:100%;height:40px'rows="3"><?php echo $clReasonNotes;?></textarea> </div> <!-------------------- --> </div>

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