";
$prfStatus = mysql_result(mysql_query("SELECT `current_status` FROM `prf_request_hdr` WHERE `reference_code`='$searchString'"),0);
switch($prfStatus){ //
// case '0':
// $status ='Unposted';
// break;
// case '1':
// $status ='Head Approval';
// break;
// case '2':
// $status ='GM Approval';
// break;
// case '3':
// $status ='Checking Available Assets';
// break;
// case '4':
// $status ='For Canvass';
// break;
// case '5':
// $status ='User Approval';
// break;
// case '6':
// $status ='CANVASS Approval';
// break;
// case '7':
// $status ='PO Creation';
// break;
// case '8':
// $status ='For PO Approval';
// break;
// case '9':
// $status ='Waiting for Delivery';
// break;
// case '10':
// $status ='Delivered';
// break;
// case '11':
// $status ='Ready for Pickup';
// break;
// case '12':
// $status ='Received by User';
// break;
case '91':
$status ='Disapprove by Head';
break;
case '92':
$status ='Disapprove by GM';
break;
case '93':
$status ='Cancelled PRF';
break;
case '94':
$status ='No Supplier Available';
break;
case '95':
$status ='Disapproved by EXECOM';
break;
case '100':
$status ='Returned with Revision';
break;
}
echo "
".$status."
";
echo "
";
break;
case 'PONumber':
echo "
";
echo "
";
echo "";
echo "
Rec. No
";
echo "
P.O Date
";
echo "
PO Number
";
echo "
Company
";
echo "
Dealer
";
echo "
Vendory
";
echo "
Amount
";
echo "";
if($poNumberChecker == 0){
echo "
-- NO RECORD FOUND --
";
}else{
$srecNo=mysql_result(mysql_query("SELECT `id` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$poID = mysql_result(mysql_query("SELECT `id` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$spoDate = mysql_result(mysql_query("SELECT `date_posted` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$spoDateCreated = mysql_result(mysql_query("SELECT `date_created` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$spoDateChecked = mysql_result(mysql_query("SELECT `date_checked` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$spoDateApproved = mysql_result(mysql_query("SELECT `date_approved` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$spoVendorForwarded = mysql_result(mysql_query("SELECT `date_forwarded_to_vendor` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$spoVendorReceived = mysql_result(mysql_query("SELECT `date_forwarded_to_vendor` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$spoNumber = mysql_result(mysql_query("SELECT `po_number` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$recsCompID = mysql_result(mysql_query("SELECT `comp_id` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$recsCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$recsCompID'"),0);
$recsDealID = mysql_result(mysql_query("SELECT `dealer_id` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$recsDealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$recsDealID'"),0);
$sVendorID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_purchase_order` WHERE `po_number`='$searchString'"),0);
$sVendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$sVendorID'"),0);
$sumPoAmount = mysql_result(mysql_query("SELECT SUM(approved_amount) FROM `prf_request_detl` WHERE `po_code`='$searchString'"),0);
echo "
";
echo "
".$srecNo."
";
echo "
".$spoDate."
";
echo "
".$spoNumber."
";
echo "
".strtoupper($recsCompName)."
";
echo "
".strtoupper($recsDealName)."
";
echo "
".strtoupper($sVendorName)."
";
echo "
".strtoupper($sumPoAmount)."
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
PO DATE: ".$spoDate."
";
echo "
DATE CREATED: ".$spoDateCreated."
";
echo "
DATE CHECKED: ".$spoDateChecked."
";
echo "
DATE APPROVED: ".$spoDateApproved."
";
echo "
SENT TO VENDOR: ".$spoVendorForwarded."
";
echo "
DATE RECEIVED: ".$spoVendorReceived;
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "PRF NUMBER: ";
$getAllPRFInPO = mysql_query("SELECT * FROM `prf_request_detl` WHERE `po_code`='$spoNumber' GROUP BY `header_ref_code`");
while($row = mysql_fetch_array($getAllPRFInPO)){
echo $row['header_ref_code']. " ";
}
echo "
";
echo "
";
echo "
";
$poStatus = mysql_result(mysql_query("SELECT `po_status` FROM `prf_purchase_order` WHERE `po_number`='$spoNumber'"),0);
if($poStatus == 9){
$status ='CANCELLED PO';
//echo "
//
Cancelled P.O
//
";
echo "";
}else{
$status ='ACTIVE PO';
}
echo "
".$status."
";
}
echo "
";
echo "
";
if($PONumber != ""){
$getItemDetl = mysql_query("SELECT * FROM `prf_request_detl` WHERE `po_code` ='$spoNumber'");
echo "