format("Y-m-d");
$prfTime = date('H:i:s');
$myDate = date_create() ->format("Y-m-d");
$activeID=$user_data['u_id'];
if(isset($_POST['done'])){
$poNumber = mysql_escape_string($_POST['poNumber']);
?>
".$row['id']."";
echo "| ".$row['header_ref_code']." | ";
echo "".$row['po_code']." | ";
echo "".$row['item_description']." | ";
echo "".$row['approved_qty']." | ";
echo "".$row['approved_amount']." | ";
echo "
";
}
?>
4 ){
echo '';
echo "
ERROR:
This PO has already been processed. Changing the price is not permitted. Please contact your system administrator for assistance. Thank you!
";
}else{
$selCanvassID = mysql_result(mysql_query("SELECT `approved_proposal_code` FROM `prf_request_detl` WHERE `id`='$selItemPOID'"),0);
mysql_query("UPDATE `prf_request_detl` SET `approved_amount` = '$newAmount',`approved_qty` = '$selNewPOQty' WHERE `id`='$selItemPOID'");
mysql_query("UPDATE `prf_canvass_sheet` SET `amount` = '$newAmount' WHERE `item_id`='$selItemPOID' AND `canvass_id`='$selCanvassID'");
mysql_query("INSERT INTO prf_changes_logs(id,action_taken,user_id,old_info,new_info, ref_number,item_id)
VALUES('','Change P.O Price','{$activeID}','{$selOldPOAmount}','{$selPOAmount}','{$selPONumber}','{$selItemPOID}')");
?>
".$row['id']."";
echo "| ".$row['header_ref_code']." | ";
echo "".$row['po_code']." | ";
echo "".$row['item_description']." | ";
echo "".$row['approved_qty']." | ";
echo "".$row['approved_amount']." | ";
echo "
";
}
?>
Alert("Price has been changed.")';
}
}
?>