format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; $NewRefCode = $refMonth.''.$refMinute.''.$refSecond; ?>

📝  APPROVAL MATRIX

LEVEL DESCRIPTION MIN. AMOUNT MAX. AMOUNT REQUIRED EXECOM REQUIRED APPROVER
"; while($row=mysql_fetch_array($getMatrixData)){ $fixApprover = $row['requiredApproverID']; $fixAPproverFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$fixApprover'"),0); $fixAPproverLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$fixApprover'"),0); ?>".$row['level'].""; echo "".$row['description'].""; echo "".$row['min_amount'].""; echo "".$row['max_amount'].""; echo "".$row['requiredExecom'].""; echo "".strtoupper($fixAPproverLName).", ".strtoupper($fixAPproverFName).""; echo ""; } echo ""; ?>

Matrix Data:

Level:
Description:
Min. Amount:
Max. Amount:
Req. EXECOM:
Fixed Approver: