File manager - Edit - /home/autoph/public_html/connect/home/CL_REPORT_SearchEmployee.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"); $dataCount = 0; if(isset($_POST['done'])){ $SearchText = mysql_escape_string($_POST['SearchText']); $getActiveClearance = mysql_query("SELECT cl_clearance_header.h_id,cl_clearance_header.key_code,cl_clearance_header.cl_h_emp_id,cl_clearance_header.cl_h_date_created, cl_clearance_header.cl_h_reason,cl_clearance_header.cl_h_hr_approval, vts_users.u_fname, vts_users.u_lname, vts_users.u_position FROM cl_clearance_header left join vts_users ON cl_clearance_header.cl_h_emp_id = vts_users.u_id WHERE vts_users.u_lname LIKE '%$SearchText%'"); echo "<table style='width:130%'>"; echo "<thead>"; echo "<th style='width:50px;border:0px solid white'>REC.ID.</th>"; echo "<th style='width:120px;border:0px solid white'>TRANS CODE.</th>"; echo "<th style='width:140px;border:0px solid white'>DATE CREATED.</th>"; echo "<th style='width:300px;border:0px solid white'>EMPLOYEE NAME</th>"; echo "<th style='width:150px;border:0px solid white'>POSITION</th>"; echo "<th style='width:100px;border:0px solid white'>STATUS</th>"; echo "<th style='width:100px;border:0px solid white'>REASON</th>"; echo "</thead>"; //$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`!='CLOSED' AND `cl_h_comp_id` = '$comID' ORDER BY `cl_h_date_created` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $dataCount = $dataCount + 1; $hDI = $row['h_id']; $uID = $row['cl_h_emp_id']; ?><tr onclick="javascript:showAdminAccess(this);"><?php echo "<td style=';border:0px solid white;cursor:pointer;color:$color'>".$row['h_id']."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;color:$color'>".strtoupper($row['key_code'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;color:$color'>".strtoupper($row['cl_h_date_created'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;color:$color'>".strtoupper($row['u_fname'])." ".strtoupper($row['u_lname'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;color:$color'>".strtoupper($row['u_position'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;color:$color'>".strtoupper($row['cl_h_hr_approval'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;color:$color'>".strtoupper($row['cl_h_reason'])."</td>"; echo "</tr>"; } echo "</table>"; if($dataCount == 0){ echo "<p style='font-family:Yu Gothic Light;font-size:16px;font-weight:normal;color:black;padding:30px;margin-top:100px;text-align:center'>--No Record Found--</p>"; } //echo '<script>alert("Record '.$selectedApprovingID.' has been deleted...")</script>';s exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings