❖   CLEARANCE INFORMATION:

$compID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); if(isset($_POST['done'])){ $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 "
"; $amountTotal = mysql_result(mysql_query("SELECT SUM(amount) FROM `cl_action_slip_data` WHERE `cl_key_code`='$keyCode' "),0); $ldActionSlip = mysql_query("SELECT * FROM `cl_action_slip_data` WHERE `cl_key_code`='$keyCode' ORDER BY `id` DESC"); //095209674-699 $bg='#dafee3'; while($sRow = mysql_fetch_array($ldActionSlip)){ echo "
"; $sender = $sRow['cl_request_by_id']; $senderFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$sender'"),0); $senderLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$sender'"),0); $senderName = $senderFName ." " .$senderLName; if($bg==='#dafee3'){ $bg='white'; }else{ $bg='#dafee3'; } if($sender == $addByUID){ echo "Sender; ".$senderName.""; echo "

".$sRow['cl_slip_info']." : (".$sRow['amount'].")

"; echo "".$sRow['cl_slip_date']." | ".$sRow['cl_slip_time'].""; }else{ echo "From: ".$senderName.""; echo "

".$sRow['cl_slip_info']." : (".$sRow['amount'].")

"; echo "".$sRow['cl_slip_date']." | ".$sRow['cl_slip_time'].""; } echo"
"; } echo "
"; echo "Total Amount: Php ".$amountTotal.""; } ?>