DATE ADDED	CANVASS CODE	VENDOR CODE	VENDOR NAME	VALIDITY	UPLOADED BY

'$prfDate' AND `notes` LIKE '%$UpdatePRFReferenceNumber%'"); while($cRow = mysql_fetch_array($getActiveProposals)){ $cvID = $cRow['id']; $checkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_canvass_sheet WHERE `canvass_id`='$cvID' AND `item_id`='$ItemRecordID'"),0); if($checkIfExist==0){ $cvFileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); ?>".$cRow['date_added'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } ?>

".$cRow['ref_code']."

".$cRow['vendor_code']."

"; $uploadVCode = $cRow['vendor_code']; $supName = mysql_result(mysql_query("SELECT sup_name FROM prf_suppliers WHERE sup_code='$uploadVCode'"),0); echo strtoupper($supName); echo "

".$cRow['validity_date']."

"; $uploadID = $cRow['uploaded_by']; $upFname = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$uploadID'"),0); $upLname = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$uploadID'"),0); echo strtoupper($upLname). ", ".strtoupper($upFname); echo "

📑

CANVASS CODE	VENDOR CODE	VENDOR NAME	QTY	AMOUNT

".$cvCode.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

"; echo $venCode; echo "

"; echo strtoupper($venName); echo "

".$csRow['quantity']."

".$csRow['amount']."

📑