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; if(isset($_POST['done'])){ $searchText = mysql_escape_string($_POST['searchText']); $filterBuyerIDAss = mysql_escape_string($_POST['filterBuyerIDAss']); $searchTXT=trim(str_replace(' ', '', $searchText)); if($filterBuyerIDAss == 0){ if($searchTXT !=''){ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND`ahg_admin_date`!='' AND `header_ref_code`='$searchTXT' AND `item_status`=4 ORDER BY `ahg_admin_date` ASC"); }else{ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND`ahg_admin_date`!='' AND `canvass_by`!='0' AND `item_status`=4 ORDER BY `ahg_admin_date` ASC"); } } if($filterBuyerIDAss > 0){ if($searchTXT !=''){ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND`ahg_admin_date`!='' AND `canvass_by`='$filterBuyerIDAss' AND `header_ref_code`='$searchTXT' AND `item_status`=4 ORDER BY `ahg_admin_date` ASC"); } else{ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND`ahg_admin_date`!='' AND `canvass_by`='$filterBuyerIDAss' AND `item_status`=4 ORDER BY `ahg_admin_date` ASC"); } } if($filterBuyerIDAss ==''){ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND`ahg_admin_date`!='' AND `canvass_by`='$uniqueRefID' AND `header_ref_code`='$searchTXT' AND `item_status`=4 ORDER BY `ahg_admin_date` ASC"); } } ?>
REC. NO REF. CODE REQ. DATE COMPANY ITEM DESC QTY REQUEST BY CANVASS BY CATEGORY DOC
".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //} } ?>
".strtoupper($row['header_ref_code'])."".strtoupper($row['ahg_admin_date'])."".strtoupper($dealCode)."".strtoupper($row['item_description'])."".strtoupper($row['quantity'])."".strtoupper($reqByLName).", ".strtoupper($reqByFName)."".strtoupper($canByLName).", ".strtoupper($canByFName)."
".$picTS."		".strtoupper($CatName).""; $chkAttachment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $withMail ='📝'; $attFilename = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $noMail = '-'; if($chkAttachment > 0){ echo "📑"; }else{ echo $noMail; } echo"
Selected Record: