format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; if(isset($_POST['done'])){ //$canvassRecoValue = mysql_escape_string($_POST['canvassRecoValue']); $selectedRecordID = mysql_escape_string($_POST['selectedRecordID']); $proposalCount = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_canvass_sheet` WHERE `item_id`='$selectedRecordID'"),0); $userEndorsmentCount = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_canvass_sheet` WHERE `item_id`='$selectedRecordID' AND `user_feedback`!=0"),0); if($userEndorsmentCount != $proposalCount){ echo ""; exit; } if($userEndorsmentCount == 0){ echo ""; exit; } //$checkItemCount = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_canvass_sheet` WHERE `item_id`='$selectedRecordID'"),0); $checkIfAllRejected = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_canvass_sheet` WHERE `item_id`='$selectedRecordID' AND `user_feedback` > 3"),0); if($checkIfAllRejected == $proposalCount){ echo ""; mysql_query("UPDATE `prf_request_detl` SET `user_canvass_approval` = '0', `item_status`=4 WHERE `id` = '$selectedRecordID'"); exit; }else{ mysql_query("UPDATE `prf_request_detl` SET `create_canvass_sheet`='1',`user_approval_ts`='$prfDateTime', `item_status`=6 WHERE `id`='$selectedRecordID'"); $refCodeID = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id='$selectedRecordID'"),0); mysql_query("UPDATE `prf_request_hdr` SET `current_status`='6' WHERE `reference_code`='$refCodeID'"); echo ""; } } ?>

REC. NO	ITEM DESCRIPTION	QUANTITY	UOM	DATE NEEDED

".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

".strtoupper($row['item_description'])."

".$row['quantity']."

".strtoupper($row['uom'])."

".$row['date_needed']."

Selected Record: