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; ?>

📝  SETUP P.O APPROVING OFFICERS

REC. ID NAME AUTHORITY ACTION
"; $getExecomList = mysql_query("SELECT vts_users.u_id,vts_users.u_fname,vts_users.u_lname,prf_poapprover.id,prf_poapprover.po_officer_id,prf_poapprover.authority,prf_poapprover.comp_id FROM `vts_users` JOIN `prf_poapprover` ON `prf_poapprover`.po_officer_id = vts_users.u_id WHERE `vts_users`.u_id=`prf_poapprover`.po_officer_id AND `prf_poapprover`.deleted=0"); while($row=mysql_fetch_array($getExecomList)){ ?> ".$row['id']." ".$row['u_lname'].", ".$row['u_fname']." ".$row['authority']." ❌"; echo ""; } echo ""; ?>

SELECT EMPLOYEE:

Employee Name:
Level of Authority:

LEVEL OF AUTHORITY:

1 = Can approve PO without the need of other approving officers

2 = Two (2) Offices are required to approved PO

3 = Three (3) Officers are required to approved PO