❖   CLEARANCE INFORMATION:

$compID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); if(isset($_POST['done'])){ $addCompID = mysql_escape_string($_POST['addCompID']); $addByUID = mysql_escape_string($_POST['addByUID']); $ActiveApproverID = mysql_escape_string($_POST['ActiveApproverID']); $recordID = mysql_escape_string($_POST['recordID']); $uID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $keyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$recordID'"),0); //echo $keyCode ."-"; //echo $uID ."-"; //echo $ClearanceDataID ."-"; //echo $addByUID ."-"; echo "
"; $ldActionSlip = mysql_query("SELECT * FROM `cl_action_slip_data` WHERE `cl_key_code`='$keyCode' ORDER BY `id` DESC"); $bg='#dafee3'; while($sRow = mysql_fetch_array($ldActionSlip)){ echo "
"; $sender = $sRow['cl_request_by_id']; $senderName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$sender'"),0); if($bg==='#dafee3'){ $bg='white'; }else{ $bg='#dafee3'; } if($sender == $addByUID){ echo "

☻ ".$senderName."

"; echo "

".$sRow['cl_slip_info']."
".$sRow['cl_slip_date']." | ".$sRow['cl_slip_time']."

"; }else{ echo "

☺".$senderName."

"; echo "

".$sRow['cl_slip_info']."

☀ ".$sRow['cl_slip_date']." | ".$sRow['cl_slip_time']."

"; } echo"
"; } echo "
"; } ?>