File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_SEARCH_CL_HISTORY.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'])){ $SearchText = mysql_escape_string($_POST['SearchText']); $NewCLRecordEmpID = mysql_escape_string($_POST['NewCLRecordEmpID']); $addByUID = mysql_escape_string($_POST['addByUID']); $NewCLRecordID = mysql_escape_string($_POST['NewCLRecordID']); echo "<table>"; echo "<thead>"; echo "<th style='width:50px;border:0px solid white;font-weight:normal'>NO.</th>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal'>DATE</th>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal'>EMP. ID.</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>EMPLOYEE NAME</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>CREATED BY</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>AUTHORIZED BY</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>ENDORSED BY #1</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>ENDORSED BY #2</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>APPROVED BY</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>STATUS</th>"; //echo "<th style='width:220px;border:0px solid white;font-weight:normal'>Action</th>"; echo "</thead>"; //$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_hr_approval_id` = '$addByUID' AND `search_ref_fname` LIKE '%SearchText%' \|\| `cl_recommender_a_id` ='$addByUID' AND `search_ref_lname` LIKE '%SearchText%' \|\| `cl_approver_id` ='$addByUID' AND `search_ref_emp_id` LIKE '%SearchText%' \|\| `cl_recommender_b_id` ='$addByUID' ORDER BY `h_id` DESC"); $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `search_ref_fname` LIKE '%$SearchText%' \|\| `search_ref_lname` LIKE '%$SearchText%' \|\| `search_ref_emp_id` LIKE '%$SearchText%' ORDER BY `h_id` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $uID = $row['cl_h_emp_id']; $pID = $row['cl_emp_position']; $createdBy = $row['cl_created_by']; $AuthorizedBy = $row['cl_hr_approval_id']; $AuthorizedTS = $row['cl_hr_approval_timestamp']; $EndorsedByA = $row['cl_recommender_a_id']; $EndorsedByATS = $row['cl_recommender_a_timestamp']; $EndorsedByB = $row['cl_recommender_b_id']; $EndorsedByBTS = $row['cl_recommender_b_timestamp']; $ApprovedB = $row['cl_approver_id']; $ApprovedBTS = $row['cl_approver_id_timestamp']; $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0); $createdBy=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$createdBy'"),0); $authFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $authLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $endaFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $endaLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $endbFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $endbLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $apprFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $apprLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $count = $count + 1; ?><tr onclick="javascript:showAdminAccess(this);"><?php echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".$row['h_id']."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($row['cl_h_date_created'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($uEMPID)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($uLName).", ".strtoupper($uFName)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($createdBy)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($authLName).", ".strtoupper($authFName); echo "<br><i style='font-family:Calibri;font-size:10px;font-color:gray;;vertical-align:top'>".$AuthorizedTS."<i>"; echo"</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($endaLName).", ".strtoupper($endaFName); echo "<br><i style='font-family:Calibri;font-size:10px;font-color:gray;'>".$EndorsedByATS."<i>"; echo"</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($endbLName).", ".strtoupper($endbFName); echo "<br><i style='font-family:Calibri;font-size:10px;font-color:gray;'>".$EndorsedByBTS."<i>"; echo"</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($apprLName).", ".strtoupper($apprFName); echo "<br><i style='font-family:Calibri;font-size:10px;font-color:gray;'>".$ApprovedBTS."<i>"; echo"</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($row['cl_h_hr_approval'])."</td>"; echo "</tr>"; } echo "</table>"; //echo '<script>alert("Record '.$selectedApprovingID.' has been deleted...")</script>'; exit(); } ?>

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