0){ echo " "; exit(); } if($getItemHdrCount == 0){ echo " "; }else{ while($row=mysql_fetch_array($getItemHdr)){ $myPRFNumber = $row['header_ref_code']; $itmID=$row['id']; $itemSpecs = mysql_result(mysql_query("SELECT `item_specs` FROM `prf_canvass_sheet` WHERE `item_id` = '$itmID' AND `item_specs`=''"),0); $dealID=$row['dealer_id']; $dealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); $companyID=$row['comp_id']; $companyName =mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $reqNameID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); echo ""; $purpose = mysql_result(mysql_query("SELECT `purpose_of_request` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $prfAttachment = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number`='".$row['header_ref_code']."'"),0); $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $catID = mysql_result(mysql_query("SELECT `category_id` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $SubcatID = mysql_result(mysql_query("SELECT `sub_category_id` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); $Category = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='".$catID."'"),0); $ProposalCount = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_canvass_sheet WHERE `item_id`='$itmID'"),0); $reqNameFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqNameID'"),0); $reqNameLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqNameID'"),0); ?>".$row['id'].""; echo ""; echo ""; // echo ""; } } ?>

"; echo " "; echo " "; echo " Record ID: "; echo " Requestor: "; echo " Date Needed: "; echo " Item Description: ".$row['item_description']." ".$itemSpecs." "; echo " Category: "; echo " Company: "; echo " Quantity: "; echo " Purpose of Request: ".$purpose." "; echo " "; //(".$ProposalCount.") echo " CLICK HERE TO VIEW PROPOSALS "; echo " "; echo " "; $checkComment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomnotes` WHERE `item_id`='$itmID'"),0); if($checkComment == 0){ echo "No comment found. "; }else{ if($checkComment > 1){ $isMany ='S'; }else{ $isMany=''; } echo " ACTIVE COMMENT".$isMany." "; } echo " "; echo " "; echo "APPROVED BY: "; $getExecomApproval = mysql_query("SELECT * FROM `prf_execomcanvassapproval` WHERE `item_code`='$itmID'"); while($row=mysql_fetch_array($getExecomApproval)){ $aprByExecomID = $row['approved_by_execom']; $ExVendorID = $row['vendor_id']; $exVenName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$ExVendorID'"),0); $xFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprByExecomID'"),0); $xLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprByExecomID'"),0); echo " ". strtoupper($xFName) ." " . strtoupper($xLName) ." ( AWARDED TO: ".$exVenName.") "; } echo " "; if($checkComment > 0){ echo " "; //echo 'myITEM'. $itmID; $getComments = mysql_query("SELECT * FROM `prf_execomnotes` WHERE `item_id`='$itmID' ORDER BY `id` DESC"); while($row=mysql_fetch_array($getComments)){ $getSender = $row['sender_id']; if($getSender == $myUID){ $color =' #047f22 '; }else{ $color ='#49584c '; } $serFName = mysql_result(mysql_query("SELECT u_fname FROM `vts_users` WHERE `u_id`='$getSender'"),0); $serLName = mysql_result(mysql_query("SELECT u_lname FROM `vts_users` WHERE `u_id`='$getSender'"),0); echo " "; echo " SENDER: ".$serFName. " ".$serLName." "; echo $row['my_notes']." "; echo "".$row['timestamp'].""; echo " "; } echo " "; } echo " "; echo "	."; echo "
".$row['item_description'].""; //echo "
// View Canvass