se/SE/se-lib/Api/WfsServer.php

<?php

Lib::loadClass('Api_WfsException');
Lib::loadClass('Api_WfsGeomTypeConverter');

class Api_WfsServer {

	private $_usrAcl;
	private $_typeConverter;

	public function __construct($usrAcl) {
		$this->_usrAcl = $usrAcl;
		$this->_typeConverter = new Api_WfsGeomTypeConverter();
	}

	public function parseXMLRequest() {
		$data = array();
		$reqContent = file_get_contents('php://input');
		if (empty($reqContent)) {
			throw new Exception("Empty request");
		}
		$parserXml = xml_parser_create();
		xml_parser_set_option($parserXml, XML_OPTION_CASE_FOLDING, 0);
		xml_parser_set_option($parserXml, XML_OPTION_SKIP_WHITE, 1);
		if (0 == xml_parse_into_struct($parserXml, $reqContent, $tags)) {
			throw new Exception("Error parsing xml");
		}
		xml_parser_free($parserXml);
		if (empty($tags)) {
			throw new Exception("Empty structure from request");
		}

		$rootTagName = V::get('tag', '', $tags[0]);
		if ('Transaction' == $rootTagName) {
			return $this->_parseTransactionXmlStruct($reqContent, $tags);
		}

		throw new Api_WfsException("TODO ... L." . __LINE__, 501);

		$xml = new SimpleXMLElement($reqContent);
		$namespaces = $xml->getNameSpaces(true);

		if ('Transaction' == $xml->getName()) {
			$this->_parseTransactionXml($xml);
		}
		else {
			throw new Api_WfsException("Not Implemented " . htmlspecialchars($xml->getName()), 501);
		}
	}

	private function _parseTransactionXmlStruct($requestXml, $requestXmlTags) {
		$DBG = (V::get('DBG_XML', '', $_GET) > 0);// TODO: Profiler
		$rootTagName = V::get('tag', '', $requestXmlTags[0]);
		if ('Transaction' != $rootTagName) {
			throw new Exception("Parse Request xml error #" . __LINE__);
		}

		// 1. convert request: wfs.transaction.convert-wfs-request.xsl
		// 2. validate converted request: wfs.transaction-converted-request.xsd
		// 3. execute request in data source
		// ? acl check?

		$usedSourceNsList = array();
		$sourceNsList = $this->_getSourceNsList();
		//$sourceNsList = array();
		//foreach ($requestXmlTags[0]['attributes'] as $attrName => $attrValue) {
		//	if ('xmlns:p5_' == substr($attrName, 0, 9)) {
		//		$sourceNsList[substr($attrName, 6)] = $attrValue;
		//	}
		//}
		{// get used typeNames
			$usedTypeNames = array();
			// <Update xmlns="http://www.opengis.net/wfs" typeName="p5_default_db:TEST_PERMS">
			foreach ($requestXmlTags as $tag) {
				if ('Update' == $tag['tag'] && 'open' == $tag['type']) {
					$typeName = $tag['attributes']['typeName'];
					foreach ($sourceNsList as $nsInd => $ns) {
						if ("p5_{$ns[0]}:{$ns[1]}" == $typeName) {
							$usedSourceNsList[$nsInd] = $ns;
						}
					}
				}
			}
			// TODO: check: <Transaction xmlns:p5_default_db="https://biuro.biall-net.pl/wfs/default_db/TEST_PERMS"
			// <Insert xmlns="http://www.opengis.net/wfs">
			//   <TEST_PERMS xmlns="https://biuro.biall-net.pl/wfs/default_db/TEST_PERMS">
			$lastTagName = '';
			foreach ($requestXmlTags as $tag) {
				if ('Insert' == $lastTagName) {
					$typeName = $tag['tag'];
					foreach ($sourceNsList as $nsInd => $ns) {
						if ("{$ns[1]}" == $typeName) {
							$usedSourceNsList[$nsInd] = $ns;
						}
					}
				}
				$lastTagName = $tag['tag'];
			}
		}
		if (empty($usedSourceNsList)) {
			throw new Exception("Parse Request xml error #" . __LINE__ . ": not implemented");
		}

		$convertedTransaction = $this->_convertTransactionXml($requestXml, $usedSourceNsList);
if($DBG){echo '$convertedTransaction:';print_r($convertedTransaction);echo "\n";}
		if (empty($convertedTransaction)) {
			throw new Exception("Parse Request xml error #" . __LINE__ . ": convert Transaction");
		}
//echo "\ntags[0]:\n" . json_encode($requestXmlTags[0]) . "\n";
//echo "\nconvertedTransaction:\n" . $convertedTransaction . "\n";
//echo "\nsourceNsList:\n" . json_encode($sourceNsList) . "\n";
		if (!$this->_validateConvertedTransactionXml($convertedTransaction, $usedSourceNsList)) {
			throw new Exception("Parse Request xml error #" . __LINE__ . ": schema validation failed");
		}

		$parserXml = xml_parser_create();
		xml_parser_set_option($parserXml, XML_OPTION_CASE_FOLDING, 0);
		xml_parser_set_option($parserXml, XML_OPTION_SKIP_WHITE, 1);
		if (0 == xml_parse_into_struct($parserXml, $convertedTransaction, $tags)) {
			throw new Exception("Parse Request xml error #" . __LINE__ . ": parse converted transaction failed");
		}
		xml_parser_free($parserXml);
		if (empty($tags)) {
			throw new Exception("Parse Request xml error #" . __LINE__ . ": parse converted transaction returns empty structure");
		}

		// [{"tag":"Transaction","type":"open","level":1,"attributes":{"version":"1.0.0","service":"WFS"}},
		//	{"tag":"Update","type":"open","level":2,"attributes":
		//		{"typeName":"p5_default_db_13051:TEST_PERMS","featureId":"TEST_PERMS.25"}},
		//			{"tag":"PARENT_ID","type":"complete","level":3,"value":"0"},
		//	{"tag":"Update","type":"close","level":2},
		//	{"tag":"Transaction","type":"close","level":1}]
		if($DBG){echo "\nTODO: tags L." . __LINE__ . ":\n"; print_r($tags);echo "\n";}
		$actionTag = null;
		$prevTagName = '';
		$theGeomField = 'the_geom';// TODO: get the geom field name from acl
		$itemPatchs = array();
		foreach ($tags as $tag) {
			switch (substr($tag['tag'], 0, 6)) {
				case 'Transa': continue; break;// Transaction
				case 'Update':
				case 'Insert':
				case 'Delete':
				case 'Native':
					if ('open' == $tag['type']) {
						$actionTag = array();
						$actionTag['tag'] = substr($tag['tag'], 0, 6);
						$actionTag['typeName'] = $tag['attributes']['typeName'];
						if ('Insert' == substr($tag['tag'], 0, 6)) {
							$actionTag['typeName'] = "p5_default_db:{$actionTag['typeName']}";
						}
						$featureEx = explode('.', $tag['attributes']['featureId'], 2);
						$actionTag['featureId'] = $featureEx[1];
						if ('Update' == substr($tag['tag'], 0, 6) && empty($actionTag['featureId'])) {
							throw new Api_WfsException("Syntax error - could not read feature id!");
						}
						$actionTag['itemPatch'] = array();
					} else {
						$itemPatchs[] = $actionTag;
						$actionTag = null;
					}
					break;
				default: {// fields
						if (3 != $tag['level'] && 'close' == $tag['type']) {
							$actionTag = null;
						}
						if (3 != $tag['level']) continue;
						if (empty($actionTag)) continue;
						if ('Update' == $actionTag['tag']) {
							if ($theGeomField == $tag['tag']) {
								$actionTag['itemPatch'][$tag['tag']] = $this->_typeConverter->convertGmlCoordinatesToWkt($tag['value']);
							} else {
								$actionTag['itemPatch'][$tag['tag']] = $tag['value'];
							}
						}
						else if ('Insert' == $actionTag['tag']) {
							if ($theGeomField == $tag['tag']) {
								$actionTag['itemPatch'][$tag['tag']] = $this->_typeConverter->convertGmlCoordinatesToWkt($tag['value']);
							} else {
								$actionTag['itemPatch'][$tag['tag']] = $tag['value'];
							}
						}
					}
			}

			if (empty($prevTagName)) $prevTagName = $tag['tag'];
		}

		if($DBG){echo "\nTODO: itemPatchs L." . __LINE__ . ":\n"; print_r($itemPatchs);echo "\n";}
		if($DBG){echo "\nTODO: _user_id L." . __LINE__ . ":\n"; print_r($this->_usrAcl->_user_id);echo "\n";}
		$changesList = array();
		if (!empty($itemPatchs)) {
			foreach ($itemPatchs as $itemPatchInfo) {
				if($DBG){echo "itemPatchInfo['itemPatch']:\n";print_r($itemPatchInfo['itemPatch']);}
				if (empty($itemPatchInfo['itemPatch'])) continue;

				$acl = $this->getAclFromTypeName($itemPatchInfo['typeName']);
				$itemPatch = $itemPatchInfo['itemPatch'];
				if ('Update' == $itemPatchInfo['tag']) {
					$itemPatch[$acl->getPrimaryKeyField()] = $itemPatchInfo['featureId'];
				}
				else if ('Insert' == $itemPatchInfo['tag']) {
					if (!empty($itemPatch[$acl->getPrimaryKeyField()])) {
						$itemPatchInfo['featureId'] = $itemPatch[$acl->getPrimaryKeyField()];
					}
					else {
						//throw new Exception("TODO: Insert #" . __LINE__ . ": Create new record");
					}
				}
				if($DBG){echo "TODO update itemPatch:\n";print_r($itemPatch);}
				if ('Insert' == $itemPatchInfo['tag'] && empty($itemPatch[$acl->getPrimaryKeyField()])) {
					$newId = $acl->addItem($itemPatch);
					$changesList[$newId] = array('Status'=>(($newId > 0)? 'SUCCESS' : 'FAILED'), 'Message'=>"created {$newId}.");
					if ($newId > 0) {
						$changesList[$newId]['fid'] = $acl->getName() . '.' . $newId;
					}
					if($DBG){echo "created {$newId}.\n";}
				} else {
					$affected = $acl->updateItem($itemPatch);
					$changesList[$itemPatchInfo['featureId']] = array('Status'=>(($affected >= 0)? 'SUCCESS' : 'FAILED'), 'Message'=>"affected {$affected}.");
					if($DBG){echo "affected {$affected}.\n";}
				}
			}
			//throw new Exception("TODO: run query #" . __LINE__ . " \nitemPatchs:\n" . json_encode($itemPatchs) . " \ntags:\n" . json_encode($tags) . "\n");
		}
		else {
			throw new Exception("Parse Request xml error #" . __LINE__ . ": Nothing to change");
		}

		return $this->_transactionResponse($changesList);
	}

	private function _transactionResponse($changesList) {
		//  <WFS_TransactionResponse>
		//    <TransactionResult>
		//      <Status> : SUCCESS / FAILED / PARTIAL
		//      [<Locator]
		//      [<Message]
		$messageTag = '';
		$statusTag = '';
		$statusIsFailed = false;
		$statusAll = null;
		$createdFetureId = '';
		foreach ($changesList as $featureId => $change) {
			if ('FAILED' == $change['Status']) {
				$statusIsFailed = true;
			}
			if ('SUCCESS' == $change['Status'] && !empty($change['fid'])) {
				$createdFetureId = $change['fid'];
			}
			if (!empty($change['Message'])) $messageTag .= "Feature '{$featureId}' {$change['Status']}: {$change['Message']}\n";
		}
		$statusTag = ($statusIsFailed)? 'FAILED' : 'SUCCESS';
		$statusTag = "<wfs:{$statusTag}/>";
		$messageTag = '';//"<wfs:Message>{$messageTag}</wfs:Message>";
		/* Example:
		<?xml version="1.0" encoding="UTF-8"?>
		<wfs:WFS_TransactionResponse version="1.0.0" xmlns:wfs="http://www.opengis.net/wfs"
			xmlns:ogc="http://www.opengis.net/ogc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
			xsi:schemaLocation="http://www.opengis.net/wfs http://localhost:8080/geoserver/schemas/wfs/1.0.0/WFS-transaction.xsd">
			<wfs:InsertResult>
				<ogc:FeatureId fid="archsites.26" />
			</wfs:InsertResult>
			<wfs:TransactionResult handle="Updating Signature rock label">
				<wfs:Status>
					<wfs:SUCCESS />
				</wfs:Status>
			</wfs:TransactionResult>
		</wfs:WFS_TransactionResponse>*/
		// TODO: build xml by DOMDocument
		// TODO: xsi:schemaLocation="http://www.opengis.net/wfs http://localhost:8080/geoserver/schemas/wfs/1.0.0/WFS-transaction.xsd"
		$wfsInsertResult = '';
		if (!empty($createdFetureId)) {
			$wfsInsertResult = <<<EOF
	<wfs:InsertResult>
		<ogc:FeatureId fid="{$createdFetureId}" xmlns:ogc="http://www.opengis.net/ogc"/>
	</wfs:InsertResult>
EOF;
		}
		$tranRes = <<<EOF
<wfs:WFS_TransactionResponse version="1.0.0"
		xmlns:wfs="http://www.opengis.net/wfs"
		xmlns:ogc="http://www.opengis.net/ogc"
		xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	{$wfsInsertResult}
	<wfs:TransactionResult>
		<wfs:Status>{$statusTag}</wfs:Status>
		{$messageTag}
	</wfs:TransactionResult>
</wfs:WFS_TransactionResponse>
EOF;
		return $tranRes;
	}

	private function _convertTransactionXml($requestXmlString, $sourceNsList) {
		$DBG = (V::get('DBG_XSL', '', $_GET) > 0);// TODO: Profiler
if($DBG){echo 'sourceNsList:';print_r($sourceNsList);echo "\n";}
		$updateActionsXsd = array();
		$insertActionsXsd = array();
		//<!-- TODO: create tag Update{X} where X is namespace index -->
		foreach ($sourceNsList as $nsInd => $sourceNs) {
			// <Update>
			$theGeomField = 'the_geom';// TODO: get from fields list
			$typeName = "p5_{$sourceNs[0]}:{$sourceNs[1]}";
			$updateElementName = "UpdateNs{$nsInd}";
			$geomCoordsUpdateXpath = "//wfs:Value/*/gml:outerBoundaryIs/gml:LinearRing/gml:coordinates";
			$geomCoordsInsertXpath = "//*/gml:outerBoundaryIs/gml:LinearRing/gml:coordinates";
			$acl = $this->getAclFromTypeName($typeName);
			$geomType = $acl->getGeomFieldType($theGeomField);
			if ('polygon' == $geomType) {
				$geomCoordsUpdateXpath = "//wfs:Value/*/gml:outerBoundaryIs/gml:LinearRing/gml:coordinates";
				$geomCoordsUpdateXpath = "((<xsl:value-of select=\"{$geomCoordsUpdateXpath}\"/>))";
				$geomCoordsInsertXpath = "//*/gml:outerBoundaryIs/gml:LinearRing/gml:coordinates";
				$geomCoordsInsertXpath = "((<xsl:value-of select=\"{$geomCoordsInsertXpath}\"/>))";
			} else if ('linestring' == $geomType) {
				$geomCoordsUpdateXpath = "//wfs:Value/*/gml:coordinates";
				$geomCoordsUpdateXpath = "(<xsl:value-of select=\"{$geomCoordsUpdateXpath}\"/>)";
				$geomCoordsInsertXpath = "//*/gml:coordinates";
				$geomCoordsInsertXpath = "(<xsl:value-of select=\"{$geomCoordsInsertXpath}\"/>)";
			} else if ('point' == $geomType) {
				$geomCoordsUpdateXpath = "//wfs:Value/*/gml:coordinates";
				$geomCoordsUpdateXpath = "(<xsl:value-of select=\"{$geomCoordsUpdateXpath}\"/>)";
				$geomCoordsInsertXpath = "//*/gml:coordinates";
				$geomCoordsInsertXpath = "(<xsl:value-of select=\"{$geomCoordsInsertXpath}\"/>)";
			}
			$actionXsd = <<<EOF
					<xsl:when test="@typeName = '{$typeName}'">
						<xsl:element name="{$updateElementName}">
							<xsl:attribute name="typeName"><xsl:value-of select="@typeName" /></xsl:attribute>
							<xsl:attribute name="featureId"><xsl:value-of select="ogc:Filter/ogc:FeatureId/@fid" /></xsl:attribute>
							<xsl:for-each select="wfs:Property">
								<xsl:element name="{wfs:Name}">
									<xsl:choose>
										<xsl:when test="wfs:Name = '{$theGeomField}'"><xsl:value-of select="local-name(//wfs:Value/*[1])"/>{$geomCoordsUpdateXpath}</xsl:when>
										<xsl:otherwise><xsl:value-of select="wfs:Value"/></xsl:otherwise>
									</xsl:choose>
								</xsl:element>
							</xsl:for-each>
						</xsl:element>
					</xsl:when>
EOF;
			$updateActionsXsd[] = $actionXsd;

			$typeName = "{$sourceNs[1]}";//"p5_{$sourceNs[0]}:{$sourceNs[1]}";
			$insertElementName = "InsertNs{$nsInd}";
			$actionXsd = <<<EOF
					<xsl:when test="local-name() = '{$typeName}'">
						<xsl:element name="{$insertElementName}">
							<xsl:attribute name="typeName"><xsl:value-of select="local-name()" /></xsl:attribute>
							<xsl:for-each select="*">
								<xsl:element name="{local-name()}">
									<xsl:choose>
										<xsl:when test="local-name() = '{$theGeomField}'"><xsl:value-of select="local-name(*[1])"/>{$geomCoordsInsertXpath}</xsl:when>
										<xsl:otherwise><xsl:value-of select="."/></xsl:otherwise>
									</xsl:choose>
								</xsl:element>
							</xsl:for-each>
						</xsl:element>
					</xsl:when>
EOF;
			$insertActionsXsd[] = $actionXsd;
		}
		if (!empty($updateActionsXsd)) {
			$updateActionsXsd = implode("\n", $updateActionsXsd);
			$updateActionsXsd = <<<EOF
				<xsl:choose>
					{$updateActionsXsd}
				</xsl:choose>
EOF;
		} else {
			$updateActionsXsd = '';
		}
		if (!empty($insertActionsXsd)) {
			$insertActionsXsd = implode("\n", $insertActionsXsd);
			$insertActionsXsd = <<<EOF
				<xsl:choose>
					{$insertActionsXsd}
				</xsl:choose>
EOF;
		} else {
			$insertActionsXsd = '';
		}

		$convertTransactionXslString = <<<EOF
<?xml version="1.0"?>
<xsl:transform version="1.0"
							 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
							 xmlns:wfs="http://www.opengis.net/wfs"
							 xmlns:ogc="http://www.opengis.net/ogc"
							 xmlns:gml="http://www.opengis.net/gml">

	<xsl:template match="/">
		<xsl:for-each select="wfs:Transaction">
			<Transaction>
				<xsl:attribute name="version"><xsl:value-of select="@version" /></xsl:attribute>
				<xsl:attribute name="service"><xsl:value-of select="@service" /></xsl:attribute>
				<xsl:for-each select="wfs:Update">
					{$updateActionsXsd}
				</xsl:for-each>
				<!-- TODO: Insert -->
				<xsl:for-each select="wfs:Insert/*">
					{$insertActionsXsd}
				</xsl:for-each>
				<!-- TODO: Delete -->
				<!-- TODO: Native -->
			</Transaction>
		</xsl:for-each>
	</xsl:template>

</xsl:transform>
EOF;
if($DBG){echo '$convertTransactionXslString:' . $convertTransactionXslString . "\n";}
		$requestXml = new DOMDocument();
		$requestXml->loadXml($requestXmlString);

		$convertTransactionXsl = new DOMDocument();
		$convertTransactionXsl->loadXml($convertTransactionXslString);
		$proc = new XSLTProcessor();
		$proc->importStylesheet($convertTransactionXsl);
		return $proc->transformToXML($requestXml);
	}

	private function _validateConvertedTransactionXml($convertedTransaction, $sourceNsList) {
		$DBG = (V::get('DBG_XSD', '', $_GET) > 0);// TODO: Profiler
if($DBG){echo 'sourceNsList:';print_r($sourceNsList);echo "\n";}

		$dom = new DOMDocument('1.0', 'utf-8');
		$dom->formatOutput = true;
		$dom->preserveWhiteSpace = false;
		$rootNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:schema');
		$dom->appendChild($rootNode);
		// $rootNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:gml', 'http://www.opengis.net/gml');
		// $rootNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:' . $wfsNs, $wfsNsUri);
		$rootNode->setAttribute('elementFormDefault', 'qualified');
		// $rootNode->setAttribute('targetNamespace', $wfsNsUri);
		$rootNode->setAttribute('version', '1.0');

		{// <xsd:element name="Transaction" type="TransactionType">
			$elNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:element');
			$rootNode->appendChild($elNode);
			$elNode->setAttribute('name', 'Transaction');
			$elNode->setAttribute('type', 'TransactionType');
			$cTypeNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:complexType');
			$rootNode->appendChild($cTypeNode);
			$cTypeNode->setAttribute('name', 'TransactionType');
				$seqNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:sequence');
				$cTypeNode->appendChild($seqNode);

					$choiceNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:choice');
					$seqNode->appendChild($choiceNode);
					$choiceNode->setAttribute('minOccurs', '0');
					$choiceNode->setAttribute('maxOccurs', 'unbounded');

					// <!-- <xsd:element ref="Update"/>	-->
					foreach ($sourceNsList as $nsInd => $sourceNs) {
						$typeName = "p5_{$sourceNs[0]}:{$sourceNs[1]}";
						$updateElementName = "UpdateNs{$nsInd}";
						$updateElementType = "UpdateNs{$nsInd}ElementType";
						$updateElemNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:element');
						$choiceNode->appendChild($updateElemNode);
						$updateElemNode->setAttribute('name', $updateElementName);
						$updateElemNode->setAttribute('type', $updateElementType);
					}
					// <!-- <xsd:element ref="Insert"/>	-->
					foreach ($sourceNsList as $nsInd => $sourceNs) {
						$typeName = "p5_{$sourceNs[0]}:{$sourceNs[1]}";
						$insertElementName = "InsertNs{$nsInd}";
						$insertElementType = "InsertNs{$nsInd}ElementType";
						$insertElemNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:element');
						$choiceNode->appendChild($insertElemNode);
						$insertElemNode->setAttribute('name', $insertElementName);
						$insertElemNode->setAttribute('type', $insertElementType);
					}
					// <!-- <xsd:element ref="Delete"/>	-->
					// <!-- <xsd:element ref="Native"/>	-->

				$attrNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:attribute');
				$cTypeNode->appendChild($attrNode);
				$attrNode->setAttribute('name', 'version');
				$attrNode->setAttribute('type', 'xsd:string');
				$attrNode->setAttribute('use', 'required');
				$attrNode->setAttribute('fixed', '1.0.0');

				$attrNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:attribute');
				$cTypeNode->appendChild($attrNode);
				$attrNode->setAttribute('name', 'service');
				$attrNode->setAttribute('type', 'xsd:string');
				$attrNode->setAttribute('use', 'required');
				$attrNode->setAttribute('fixed', 'WFS');
		}

		foreach ($sourceNsList as $nsInd => $sourceNs) {
			$transactionTypesList = array();
			$transactionTypesList[] = 'Update';
			$transactionTypesList[] = 'Insert';
			foreach ($transactionTypesList as $transactionType) {
				$typeName = "p5_{$sourceNs[0]}:{$sourceNs[1]}";
				$acl = $this->getAclFromTypeName($typeName);
				$updateElementName = "{$transactionType}Ns{$nsInd}";
				$updateElementType = "{$transactionType}Ns{$nsInd}ElementType";

	/*
	<xsd:complexType name="{$updateElementType}">
			<xsd:sequence>
				<xsd:element name="PARENT_ID" minOccurs="0" maxOccurs="1" type="xsd:integer" />
			</xsd:sequence>
	*/
				$updateTypeNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:complexType');
				$rootNode->appendChild($updateTypeNode);
				$updateTypeNode->setAttribute('name', $updateElementType);
					$seqNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:sequence');
					$updateTypeNode->appendChild($seqNode);

						$pKeyField = $acl->getPrimaryKeyField();
						$fldList = $acl->getRealFieldList();
						foreach ($fldList as $fldName) {
							if ($acl->isGeomField($fldName)) continue;

							$elNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:element');
							$seqNode->appendChild($elNode);
							$elNode->setAttribute('name', $fldName);
							$minOccurs = 0;
							if ($pKeyField == $fldName) {
								$minOccurs = '1';
							} else {
								$minOccurs = '0';
							}
							$elNode->setAttribute('minOccurs', $minOccurs);

							$fldType = null;
							if ($acl->isIntegerField($fldName)) {
								$fldType = 'xsd:integer';
							}
							else if ($acl->isDecimalField($fldName)) {
								$fldType = 'xsd:decimal';
							}
							else if ($acl->isDateField($fldName)) {
								$fldType = 'xsd:date';
							}
							else if ($acl->isDateTimeField($fldName)) {
								$fldType = 'xsd:dateTime';
							}
							else if ($acl->isGeomField($fldName)) {
								//$fldType = 'gml:GeometryPropertyType';
								// TODO: use geom types from gml to wkt
								// TODO: pattern wg atrybutów gml:coordinates decimal="." cs="," ts=" "
								$patternWkt = '';// TODO: error if empty - unsupported geom type
								$patternNum = '\-?\d+\.?\d*';
								$patternPoint = $patternNum . ',' . $patternNum;
								$patternPoints = '(' . $patternPoint . ')( ' . $patternPoint . ')+';

								$geomType = $acl->getGeomFieldType($fldName);
								if ('polygon' == $geomType) {
									// [a-zA-Z]+\(\((\-?\d+\.?\d*,\-?\d+\.?\d*)( (\-?\d+\.?\d*,\-?\d+\.?\d*))+\)\)
									$patternWkt = '[a-zA-Z]+\(\(' . $patternPoints . '\)\)';
								} else if ('linestring' == $geomType) {
									// [a-zA-Z]+\((\-?\d+\.?\d*,\-?\d+\.?\d*)( (\-?\d+\.?\d*,\-?\d+\.?\d*))+\)
									$patternWkt = '[a-zA-Z]+\(' . $patternPoints . '\)';
								} else if ('point' == $geomType) {
									// [a-zA-Z]+\(\-?\d\.?\d*,\-?\d\.?\d*\)
									$patternWkt = '[a-zA-Z]+\(' . $patternPoint . '\)';
								}

								$simpleTypeNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:simpleType');
								$restrictionNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:restriction');
								$patternNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:pattern');
								$restrictionNode->setAttribute('base', 'xsd:string');
								$patternNode->setAttribute('value', $patternWkt);
								$restrictionNode->appendChild($patternNode);
								$simpleTypeNode->appendChild($restrictionNode);
								$elNode->appendChild($simpleTypeNode);
							}
							else {
								$fldType = 'xsd:string';
							}
							if ($fldType) $elNode->setAttribute('type', $fldType);
							$elNode->setAttribute('nillable', 'true');
							$elNode->setAttribute('minOccurs', '0');
						}
						foreach ($fldList as $fldName) {
							if (!$acl->isGeomField($fldName)) continue;

							$elNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:element');
							$seqNode->appendChild($elNode);
							$elNode->setAttribute('name', $fldName);
							$minOccurs = 0;
							if ($pKeyField == $fldName) {
								$minOccurs = '1';
							} else {
								$minOccurs = '0';
							}
							$elNode->setAttribute('minOccurs', $minOccurs);
							if ($acl->isGeomField($fldName)) {
								//$fldType = 'gml:GeometryPropertyType';
								// TODO: use geom types from gml to wkt
								// TODO: pattern wg atrybutów gml:coordinates decimal="." cs="," ts=" "
								$patternWkt = '';// TODO: error if empty - unsupported geom type
								$patternNum = '\-?\d+\.?\d*';
								$patternPoint = $patternNum . ',' . $patternNum;
								$patternPoints = '(' . $patternPoint . ')( ' . $patternPoint . ')+';

								$geomType = $acl->getGeomFieldType($fldName);
								if ('polygon' == $geomType) {
									// [a-zA-Z]+\(\((\-?\d+\.?\d*,\-?\d+\.?\d*)( (\-?\d+\.?\d*,\-?\d+\.?\d*))+\)\)
									$patternWkt = '[a-zA-Z]+\(\(' . $patternPoints . '\)\)';
								} else if ('linestring' == $geomType) {
									// [a-zA-Z]+\((\-?\d+\.?\d*,\-?\d+\.?\d*)( (\-?\d+\.?\d*,\-?\d+\.?\d*))+\)
									$patternWkt = '[a-zA-Z]+\(' . $patternPoints . '\)';
								} else if ('point' == $geomType) {
									// [a-zA-Z]+\(\-?\d\.?\d*,\-?\d\.?\d*\)
									$patternWkt = '[a-zA-Z]+\(' . $patternPoint . '\)';
								}

								$simpleTypeNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:simpleType');
								$restrictionNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:restriction');
								$patternNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:pattern');
								$restrictionNode->setAttribute('base', 'xsd:string');
								$patternNode->setAttribute('value', $patternWkt);
								$restrictionNode->appendChild($patternNode);
								$simpleTypeNode->appendChild($restrictionNode);
								$elNode->appendChild($simpleTypeNode);
							}
							$elNode->setAttribute('nillable', 'true');
							$elNode->setAttribute('minOccurs', '0');
						}

				$attrNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:attribute');
				$updateTypeNode->appendChild($attrNode);
				$attrNode->setAttribute('name', 'typeName');
				$attrNode->setAttribute('type', 'xsd:token');
				$attrNode->setAttribute('use', 'required');

				if ($transactionType == 'Update') {
					$attrNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:attribute');
					$updateTypeNode->appendChild($attrNode);
					$attrNode->setAttribute('name', 'featureId');
					$attrNode->setAttribute('use', 'required');
						$sTypeNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:simpleType');
						$attrNode->appendChild($sTypeNode);
							$resNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:restriction');
							$sTypeNode->appendChild($resNode);
							$resNode->setAttribute('base', 'xsd:string');
								$patternNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:pattern');
								$resNode->appendChild($patternNode);
								$patternNode->setAttribute('value', '[a-zA-Z_]*\.[0-9]*');
				}
			}
		}

		$validateConvertedTransactionXsdString = $dom->saveXml();
if($DBG){echo '$validateConvertedTransactionXsdString:';print_r($validateConvertedTransactionXsdString);echo "\n";}
		$reqXml = new DOMDocument();
		$reqXml->loadXml($convertedTransaction);
		// TODO: fetch PHP Warning: DOMDocument::schemaValidateSource(): Element 'PARENT_ID': 'abc' is not a valid value of the atomic type 'xs:integer'.
		return $reqXml->schemaValidateSource($validateConvertedTransactionXsdString);
	}

	private function _generateXsdTypeNode($ns, $typeName, $dom, $parentNode) {
		//$fieldsXsd = '';
		//$fieldsXsd .= '<xsd:element name="PARENT_ID" minOccurs="0" maxOccurs="1" type="xsd:integer" />';
		$acl = $this->getAclFromTypeName($typeName);

		$cTypeNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:complexType');
		$rootNode = $cTypeNode;
		$cTypeNode->setAttribute('name', $typeName);

		$cConNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:complexContent');
		$cTypeNode->appendChild($cConNode);

		$extNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:extension');
		$cConNode->appendChild($extNode);
		$extNode->setAttribute('base', 'gml:AbstractFeatureType');

		$seqNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:sequence');// or xsd:all ?
		$extNode->appendChild($seqNode);

		// <xsd:element maxOccurs="1" minOccurs="0" name="{$fldName}" nillable="true" type="xsd:integer"/>
		$pKeyField = $acl->getPrimaryKeyField();
		$fldList = $acl->getRealFieldList();
		foreach ($fldList as $fldName) {
			$elNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:element');
			$seqNode->appendChild($elNode);
			$elNode->setAttribute('name', $fldName);
			$minOccurs = 0;
			if ($pKeyField == $fldName) {
				$minOccurs = '1';
			} else {
				$minOccurs = '0';
			}
			$elNode->setAttribute('minOccurs', $minOccurs);
			if ($acl->isIntegerField($fldName)) {
				$fldType = 'xsd:integer';
			}
			else if ($acl->isDecimalField($fldName)) {
				$fldType = 'xsd:decimal';
			}
			else if ($acl->isDateField($fldName)) {
				$fldType = 'xsd:date';
			}
			else if ($acl->isDateTimeField($fldName)) {
				$fldType = 'xsd:dateTime';
			}
			else if ($acl->isGeomField($fldName)) {
				$fldType = 'gml:GeometryPropertyType';
				//$fldType = 'gml:Polygon';// nie działa musi być gml:GeometryPropertyType
			}
			else {
				$fldType = 'xsd:string';
			}
			$elNode->setAttribute('type', $fldType);
			$elNode->setAttribute('nillable', 'true');
		}

/*
			<xsd:attribute name="typeName" type="xsd:token" use="required"/>
			<xsd:attribute name="featureId" use="required">
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:pattern value="[a-zA-Z_]*\.[0-9]*"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:attribute>
*/
		$cAttrNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:attribute');
		$rootNode->appendChild($cAttrNode);
		$cAttrNode->setAttribute('name', 'typeName');
		$cAttrNode->setAttribute('type', 'xsd:token');
		$cAttrNode->setAttribute('use', 'required');

		$cAttrNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:attribute');
		$rootNode->appendChild($cAttrNode);
		$cAttrNode->setAttribute('name', 'featureId');
		$cAttrNode->setAttribute('use', 'required');
			$sTypeNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:simpleType');
			$cAttrNode->appendChild($sTypeNode);
				$restrNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:restriction');
				$cAttrNode->appendChild($restrNode);
				$restrNode->setAttribute('base', 'xsd:string');
					$patternNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:pattern');
					$restrNode->appendChild($patternNode);
					$patternNode->setAttribute('value', '[a-zA-Z_]*\.[0-9]*');

		return $dom->saveXml($cTypeNode);

		$typeXsd = <<<EOF
		<xsd:complexType name="{$typeName}">
			<xsd:all>
				{$fieldsXsd}
			</xsd:all>
			<xsd:attribute name="typeName" type="xsd:token" use="required"/>
			<xsd:attribute name="featureId" use="required">
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:pattern value="[a-zA-Z_]*\.[0-9]*"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:attribute>
		</xsd:complexType>
EOF;
		return $typeXsd;
	}

	/**
	 * @param string $typeName - 'p5_default_db:TEST_PERMS'
	*/
	public function getAclFromTypeName($typeName) {
		$typeEx = explode(':', $typeName);
		if (2 != count($typeEx)) {
			throw new Api_WfsException("Could not get acl for '{$typeName}' - syntax error");
		}
		if ('p5_' != substr($typeEx[0], 0, 3)) {
			throw new Api_WfsException("Could not get acl for '{$typeName}' - prefix error");
		}
		$sourceName = substr($typeEx[0], 3);
		$objName = $typeEx[1];
		$acl = $this->_usrAcl->getObjectAcl($sourceName, $objName);
		if (!$acl) {
			throw new Api_WfsException("Could not get acl for '{$typeName}'");
		}
		$forceTblAclInit = 0;//('1' == V::get('_force', '', $_GET));
		$acl->init($forceTblAclInit);
		return $acl;
	}

	public function getFeatureAction() {
		$type = V::get('TYPENAME', '', $_REQUEST);
		$typeEx = explode(':', $type);
		$maxFeatures = V::get('MAXFEATURES', '10000', $_REQUEST, 'int');// TODO: Set Deafult Limit
		$srsname = V::get('SRSNAME', '', $_REQUEST);// eg. EPSG:4326
		if (count($typeEx) == 2) {
			return $this->getFeatures($typeEx[0], $typeEx[1], $maxFeatures, $srsname);
		} else {
			throw new HttpException("Wrong param TYPENAME", 400);
		}
	}

	public function getFeatures($nsPrefix, $type, $maxFeatures, $srsname) {
		$DBG = (V::get('DBG_GEO', '', $_GET) > 0);// TODO: Profiler
		$typeName = "{$nsPrefix}:{$type}";
		$acl = $this->getAclFromTypeName($typeName);
		$fldList = $acl->getRealFieldList();

		$wfsNs = 'p5_default_db_' . $type;//$nsPrefix;
		$wfsNsUri = 'https://biuro.biall-net.pl/wfs/' . substr($nsPrefix, 3) . '/' . $type;

		// get BBox from geom_field (only one geom fld is allowed)
		$geomFld = null;
		{
			foreach ($fldList as $fldName) {
				if ($acl->isGeomField($fldName)) {
					$geomFld = $fldName;
				}
			}
		}

		$dbGeomType = $acl->getGeomFieldType($geomFld);

		$searchParams = array();
		$searchParams['limit'] = $maxFeatures;
		$searchParams['order_by'] = $acl->getPrimaryKeyField();
		$searchParams['order_dir'] = 'DESC';
		if ($geomFld) $searchParams["f_{$geomFld}"] = 'IS NOT NULL';
		if ($geomFld) $searchParams["f_{$geomFld}"] = 'GeometryType=' . strtoupper($dbGeomType);
		//if ($geomFld) $searchParams["f_{$geomFld}"] = 'GeometryType=LINESTRING';
if($DBG){echo 'getItems:';print_r($searchParams);echo "\n";}
		$items = $acl->getItems($searchParams);

		$dom = new DOMDocument('1.0', 'utf-8');
		$dom->formatOutput = true;
		$dom->preserveWhiteSpace = false;
		$rootNode = $dom->createElementNS('http://www.opengis.net/wfs', 'wfs:FeatureCollection');
		$dom->appendChild($rootNode);
		$rootNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns', 'http://www.opengis.net/wfs');
		$rootNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:wfs', 'http://www.opengis.net/wfs');
		$rootNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:gml', 'http://www.opengis.net/gml');
		$rootNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');
		$rootNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:' . $wfsNs, $wfsNsUri);
		$rootNode->setAttribute('xsi:schemaLocation', 'http://www.opengis.net/wfs');// TODO: add DescribeFeatureType xsd uri

if(0){// TODO: get BBOX for add features
			$boundedByNode = $dom->createElementNS('http://www.opengis.net/gml', 'gml:boundedBy');
			$rootNode->appendChild($boundedByNode);
				$boxNode = $dom->createElementNS('http://www.opengis.net/gml', 'gml:Box');
				$boundedByNode->appendChild($boxNode);
				$boxNode->setAttribute('srsName', "http://www.opengis.net/gml/srs/epsg.xml#4326");// TODO: EPSG
					$coordinatesNode = $dom->createElementNS('http://www.opengis.net/gml', 'gml:coordinates');
					$boxNode->appendChild($coordinatesNode);
					$coordinatesNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:gml', 'http://www.opengis.net/gml');
					$coordinatesNode->setAttribute('decimal', '.');
					$coordinatesNode->setAttribute('cs', ',');
					$coordinatesNode->setAttribute('ts', ' ');
					$coordinatesNode->nodeValue = '1544947.6295,4322758.105 1548002.2259,4330464.1001';// TODO: coordinates for all items?
}

if($DBG){echo '(geomFld: '.$geomFld.'):';print_r($acl->getFieldType($geomFld));echo "\n";}
		if (empty($items)) {
			$pKeyField = $acl->getPrimaryKeyField();
			$fakeItem = new stdClass();
			$fakeItem->{$pKeyField} = 0;
			if ('polygon' == $dbGeomType) {
				$fakeItem->the_geom = "POLYGON(())";
			} else if ('linestring' == $dbGeomType) {
				$fakeItem->the_geom = "LINESTRING()";
			} else if ('point' == $dbGeomType) {
				$fakeItem->the_geom = "POINT(0,0)";
			}
			$items[0] = $fakeItem;
		}
		foreach ($items as $itemKey => $item) {
			//if($item->ID == 19)continue;

if($DBG){echo 'item['.$itemKey.'] ('.$geomFld.')isEmpty('.empty($item->{$geomFld}).'):';print_r($item->{$geomFld});echo "\n";}
			if ($geomFld) {
				if (empty($item->{$geomFld})) {
					continue;// QGIS crash when WFS contain features with empty geom field
				}
			}

			$featureMemberNode = $dom->createElementNS('http://www.opengis.net/gml', 'gml:featureMember');
			$rootNode->appendChild($featureMemberNode);
				$featureNode = $dom->createElementNS($wfsNsUri, "{$wfsNs}:{$type}");
				$featureMemberNode->appendChild($featureNode);
				$featureNode->setAttribute('fid', "{$type}.{$itemKey}");
if(0){// TODO: get BBOX
					$boundedByNode = $dom->createElementNS('http://www.opengis.net/gml', 'gml:boundedBy');
					$featureNode->appendChild($boundedByNode);
						$boxNode = $dom->createElementNS('http://www.opengis.net/gml', 'gml:Box');
						$boundedByNode->appendChild($boxNode);
						$boxNode->setAttribute('srsName', "http://www.opengis.net/gml/srs/epsg.xml#4326");// TODO: EPSG
							$coordinatesNode = $dom->createElementNS('http://www.opengis.net/gml', 'gml:coordinates');
							$boxNode->appendChild($coordinatesNode);
							$coordinatesNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:gml', 'http://www.opengis.net/gml');
							$coordinatesNode->setAttribute('decimal', '.');
							$coordinatesNode->setAttribute('cs', ',');
							$coordinatesNode->setAttribute('ts', ' ');
							$coordinatesNode->nodeValue = '1546472.2363,4328949.5775 1548002.2259,4330464.1001';// TODO: coordinates for item?
}
					foreach ($fldList as $fldName) {
						$featureFldNode = $dom->createElementNS($wfsNsUri, "{$wfsNs}:{$fldName}");
						if ($acl->isGeomField($fldName)) {
							$geomNode = $this->_typeConverter->createGmlFromWkt($item->{$fldName}, $dom);
							if (!$geomNode) continue;
							$featureFldNode->appendChild($geomNode);
						} else {
							$featureFldNode->nodeValue = str_replace('&', '&amp;', $item->{$fldName});
							if (empty($featureFldNode->nodeValue)) {
								continue;
							}
						}
						$featureNode->appendChild($featureFldNode);
					}
		}

		return $dom->saveXml();
	}

	public function describeFeatureTypeAction() {
		$type = V::get('TYPENAME', '', $_REQUEST);
		if (empty($type)) {
			throw new HttpException("Wrong param TYPENAME", 400);
		}
		$typeEx = explode(':', $type);
		if (count($typeEx) != 2) {
			throw new HttpException("Wrong param TYPENAME", 400);
		}
		return $this->getDescribeFeatureType($typeEx[0], $typeEx[1]);
	}

	private function getDescribeFeatureType($nsPrefix, $type) {
		$typeName = "{$nsPrefix}:{$type}";
		$acl = $this->getAclFromTypeName($typeName);

		$wfsNs = 'p5_default_db_' . $type;//$nsPrefix;
		$wfsNsUri = 'https://biuro.biall-net.pl/wfs/' . substr($nsPrefix, 3) . '/' . $type;

		if (empty($type)) {
			throw new HttpException("Feature Type Name not defined", 400);
		}
		if (!$this->isAllowedFeatureType($nsPrefix, $type)) {
			throw new Api_WfsException("Could not find type: " . htmlspecialchars($type));
		}

		$typeName = $type . 'Type';
		$fldList = $acl->getRealFieldList();
		header('Content-type: application/xml');
		// <xsd:import namespace="http://www.opengis.net/gml" schemaLocation="http://webgis.regione.sardegna.it:80/geoserver/schemas/gml/2.1.2/feature.xsd"/>
		//	<xsd:element name="{type}" substitutionGroup="gml:_Feature" type="dbu:{typeName}"/>

		$dom = new DOMDocument('1.0', 'utf-8');
		$dom->formatOutput = true;
		$dom->preserveWhiteSpace = false;
		$rootNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:schema');
		$dom->appendChild($rootNode);
		$rootNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:gml', 'http://www.opengis.net/gml');
		$rootNode->setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:' . $wfsNs, $wfsNsUri);
		$rootNode->setAttribute('elementFormDefault', 'qualified');
		$rootNode->setAttribute('targetNamespace', $wfsNsUri);

		$cTypeNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:complexType');
		$rootNode->appendChild($cTypeNode);
		$cTypeNode->setAttribute('name', $typeName);

		$cConNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:complexContent');
		$cTypeNode->appendChild($cConNode);

		$extNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:extension');
		$cConNode->appendChild($extNode);
		$extNode->setAttribute('base', 'gml:AbstractFeatureType');

		$seqNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:sequence');
		$extNode->appendChild($seqNode);

		// <xsd:element maxOccurs="1" minOccurs="0" name="{$fldName}" nillable="true" type="xsd:integer"/>
		$pKeyField = $acl->getPrimaryKeyField();
		foreach ($fldList as $fldName) {
			$elNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:element');
			$seqNode->appendChild($elNode);
			$elNode->setAttribute('name', $fldName);
			$minOccurs = 0;
			if ($pKeyField == $fldName) {
				$minOccurs = '1';
			} else {
				$minOccurs = '0';
			}
			$elNode->setAttribute('minOccurs', $minOccurs);
			if ($acl->isIntegerField($fldName)) {
				$fldType = 'xsd:integer';
			}
			else if ($acl->isDecimalField($fldName)) {
				$fldType = 'xsd:decimal';
			}
			else if ($acl->isDateField($fldName)) {
				$fldType = 'xsd:date';
			}
			else if ($acl->isDateTimeField($fldName)) {
				$fldType = 'xsd:dateTime';
			}
			else if ($acl->isGeomField($fldName)) {
				$fldType = 'gml:GeometryPropertyType';
				//$fldType = 'gml:Polygon';// nie działa musi być gml:GeometryPropertyType
			}
			else {
				$fldType = 'xsd:string';
			}
			$elNode->setAttribute('type', $fldType);
			$elNode->setAttribute('nillable', 'true');
		}

		$elNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xsd:element');
		$rootNode->appendChild($elNode);
		$elNode->setAttribute('name', $type);
		$elNode->setAttribute('type', $wfsNs . ':' . $typeName);

		echo $dom->saveXML();
		//print_r($acl);
	}

	public function isAllowedFeatureType($nsPrefix, $type) {
		if ('p5_' != substr($nsPrefix, 0, 3)) return false;
		if ('p5_default_db' == $nsPrefix) {
			$typeName = "p5_default_db:{$type}";
			try {
				$acl = $this->getAclFromTypeName($typeName);
			} catch (Exception $e) {
				return false;
			}
			if ($acl) {
				return true;
			}
		}
		return false;
	}

	public function getCapabilitiesAction() {
		$wfsServerUrl = 'https://biuro.biall-net.pl/dev-pl/se-feature-api/wfs.php/xml/wfs/default_db';
		$serviceTitle = "BIALL-NET Web Feature Service";
		$serviceDescription = "This is the reference implementation of WFS 1.0.0 and WFS 1.1.0, supports all WFS operations including Transaction.";

		//header('Content-type: application/xml; charset="utf-8"');
		header('Content-type: application/xml');
		echo '<?xml version="1.0" encoding="UTF-8"?>';
		?>
<WFS_Capabilities version="1.0.0"
				  xmlns="http://www.opengis.net/wfs"
				  xmlns:ogc="http://www.opengis.net/ogc"
				  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
				  <?php echo $this->_getXmlNamespaceList(); ?>
				  xsi:schemaLocation="http://www.opengis.net/wfs <?php echo $this->_getSchemaLocationString(); ?>">
  <Service>
    <Name>WFS</Name>
    <Title><?php echo $serviceTitle; ?></Title>
    <Abstract><?php echo $serviceDescription; ?></Abstract>
    <Keywords>WFS, WMS</Keywords>
    <OnlineResource><?php echo $wfsServerUrl; ?></OnlineResource>
    <Fees>NONE</Fees>
    <AccessConstraints>NONE</AccessConstraints>
  </Service>
  <Capability>
    <Request>
		<?php $this->_printGetCapabilitiesXml($wfsServerUrl); ?>
		<?php $this->_printDescribeFeatureTypeXml($wfsServerUrl); ?>
		<?php $this->_printGetFeatureXml($wfsServerUrl); ?>
		<?php $this->_printTransactionXml($wfsServerUrl); ?>
		<?php $this->_printLockFeatureXml($wfsServerUrl); ?>
		<?php $this->_printGetFeatureWithLockXml($wfsServerUrl); ?>
    </Request>
  </Capability>
  <FeatureTypeList>
    <Operations>
      <Query />
      <Insert />
      <Update />
      <Delete />
      <Lock />
    </Operations>
	<?php echo $this->_printFeatureTypeListXml(); ?>
  </FeatureTypeList>
  <ogc:Filter_Capabilities>
    <ogc:Spatial_Capabilities>
      <ogc:Spatial_Operators>
        <ogc:Disjoint />
        <ogc:Equals />
        <ogc:DWithin />
        <ogc:Beyond />
        <ogc:Intersect />
        <ogc:Touches />
        <ogc:Crosses />
        <ogc:Within />
        <ogc:Contains />
        <ogc:Overlaps />
        <ogc:BBOX />
      </ogc:Spatial_Operators>
    </ogc:Spatial_Capabilities>
    <ogc:Scalar_Capabilities>
      <ogc:Logical_Operators />
      <ogc:Comparison_Operators>
        <ogc:Simple_Comparisons />
        <ogc:Between />
        <ogc:Like />
        <ogc:NullCheck />
      </ogc:Comparison_Operators>
      <ogc:Arithmetic_Operators>
        <ogc:Simple_Arithmetic />
        <ogc:Functions>
          <ogc:Function_Names>
            <ogc:Function_Name nArgs="1">abs</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">abs_2</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">abs_3</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">abs_4</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">acos</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">AddCoverages</ogc:Function_Name>
            <ogc:Function_Name nArgs="4">Aggregate</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Area</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">area2</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">AreaGrid</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">asin</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">atan</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">atan2</ogc:Function_Name>
            <ogc:Function_Name nArgs="14">BarnesSurface</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">between</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">boundary</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">boundaryDimension</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Bounds</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">buffer</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">BufferFeatureCollection</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">bufferWithSegments</ogc:Function_Name>
            <ogc:Function_Name nArgs="7">Categorize</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">ceil</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Centroid</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">classify</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">Clip</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">CollectGeometries</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Collection_Average</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Collection_Bounds</ogc:Function_Name>
            <ogc:Function_Name nArgs="0">Collection_Count</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Collection_Max</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Collection_Median</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Collection_Min</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Collection_Sum</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Collection_Unique</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Concatenate</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">contains</ogc:Function_Name>
            <ogc:Function_Name nArgs="7">Contour</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">convert</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">convexHull</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">cos</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">Count</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">CropCoverage</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">crosses</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">dateFormat</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">dateParse</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">difference</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">dimension</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">disjoint</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">disjoint3D</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">distance</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">distance3D</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">double2bool</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">endAngle</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">endPoint</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">env</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">envelope</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">EqualInterval</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">equalsExact</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">equalsExactTolerance</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">equalTo</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">exp</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">exteriorRing</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">Feature</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">floor</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">geometryType</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">geomFromWKT</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">geomLength</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">getGeometryN</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">getX</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">getY</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">getz</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">greaterEqualThan</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">greaterThan</ogc:Function_Name>
            <ogc:Function_Name nArgs="5">Grid</ogc:Function_Name>
            <ogc:Function_Name nArgs="7">Heatmap</ogc:Function_Name>
            <ogc:Function_Name nArgs="0">id</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">IEEEremainder</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">if_then_else</ogc:Function_Name>
            <ogc:Function_Name nArgs="11">in10</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">in2</ogc:Function_Name>
            <ogc:Function_Name nArgs="4">in3</ogc:Function_Name>
            <ogc:Function_Name nArgs="5">in4</ogc:Function_Name>
            <ogc:Function_Name nArgs="6">in5</ogc:Function_Name>
            <ogc:Function_Name nArgs="7">in6</ogc:Function_Name>
            <ogc:Function_Name nArgs="8">in7</ogc:Function_Name>
            <ogc:Function_Name nArgs="9">in8</ogc:Function_Name>
            <ogc:Function_Name nArgs="10">in9</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">InclusionFeatureCollection</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">int2bbool</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">int2ddouble</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">interiorPoint</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">interiorRingN</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">Interpolate</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">intersection</ogc:Function_Name>
            <ogc:Function_Name nArgs="7">IntersectionFeatureCollection</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">intersects</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">intersects3D</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">isClosed</ogc:Function_Name>
            <ogc:Function_Name nArgs="0">isCoverage</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">isEmpty</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">isLike</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">isNull</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">isometric</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">isRing</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">isSimple</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">isValid</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">isWithinDistance</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">isWithinDistance3D</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">Jenks</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">length</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">lessEqualThan</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">lessThan</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">list</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">log</ogc:Function_Name>
            <ogc:Function_Name nArgs="4">LRSGeocode</ogc:Function_Name>
            <ogc:Function_Name nArgs="5">LRSMeasure</ogc:Function_Name>
            <ogc:Function_Name nArgs="5">LRSSegment</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">max</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">max_2</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">max_3</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">max_4</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">min</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">min_2</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">min_3</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">min_4</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">mincircle</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">minimumdiameter</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">minrectangle</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">modulo</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">MultiplyCoverages</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">Nearest</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">not</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">notEqualTo</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">numberFormat</ogc:Function_Name>
            <ogc:Function_Name nArgs="5">numberFormat2</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">numGeometries</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">numInteriorRing</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">numPoints</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">octagonalenvelope</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">offset</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">overlaps</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">parameter</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">parseBoolean</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">parseDouble</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">parseInt</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">parseLong</ogc:Function_Name>
            <ogc:Function_Name nArgs="0">pi</ogc:Function_Name>
            <ogc:Function_Name nArgs="4">PointBuffers</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">pointN</ogc:Function_Name>
            <ogc:Function_Name nArgs="7">PointStacker</ogc:Function_Name>
            <ogc:Function_Name nArgs="6">PolygonExtraction</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">pow</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">property</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">PropertyExists</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">Quantile</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">Query</ogc:Function_Name>
            <ogc:Function_Name nArgs="0">random</ogc:Function_Name>
            <ogc:Function_Name nArgs="5">RangeLookup</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">RasterAsPointCollection</ogc:Function_Name>
            <ogc:Function_Name nArgs="4">RasterZonalStatistics</ogc:Function_Name>
            <ogc:Function_Name nArgs="5">Recode</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">RectangularClip</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">relate</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">relatePattern</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">Reproject</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">rint</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">round</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">round_2</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">roundDouble</ogc:Function_Name>
            <ogc:Function_Name nArgs="6">ScaleCoverage</ogc:Function_Name>
            <ogc:Function_Name nArgs="4">sdo_nn</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">setCRS</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">Simplify</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">sin</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">Snap</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">sqrt</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">StandardDeviation</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">startAngle</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">startPoint</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">strCapitalize</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">strConcat</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">strEndsWith</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">strEqualsIgnoreCase</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">strIndexOf</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">strLastIndexOf</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">strLength</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">strMatches</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">strPosition</ogc:Function_Name>
            <ogc:Function_Name nArgs="4">strReplace</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">strStartsWith</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">strSubstring</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">strSubstringStart</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">strToLowerCase</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">strToUpperCase</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">strTrim</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">strTrim2</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">StyleCoverage</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">symDifference</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">tan</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">toDegrees</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">toRadians</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">touches</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">toWKT</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">Transform</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">union</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">UnionFeatureCollection</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">Unique</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">UniqueInterval</ogc:Function_Name>
            <ogc:Function_Name nArgs="6">VectorToRaster</ogc:Function_Name>
            <ogc:Function_Name nArgs="3">VectorZonalStatistics</ogc:Function_Name>
            <ogc:Function_Name nArgs="1">vertices</ogc:Function_Name>
            <ogc:Function_Name nArgs="2">within</ogc:Function_Name>
          </ogc:Function_Names>
        </ogc:Functions>
      </ogc:Arithmetic_Operators>
    </ogc:Scalar_Capabilities>
  </ogc:Filter_Capabilities>
</WFS_Capabilities>
		<?php
	}

	private function _getSchemaLocationString() {
		$schemaLocations = array();
		// $schemaLocations[] = 'http://webgis.regione.sardegna.it:80/geoserver/schemas/wfs/1.0.0/WFS-capabilities.xsd';// @from http://webgis.regione.sardegna.it/geoserver/ows?service=WFS&request=GetCapabilities
		return implode(' ', $schemaLocations);
	}
	private function _getXmlNamespaceList() {
		$namespaceList = $this->_getSourceNsList();
		$namespaceListOut = array();
		foreach ($namespaceList as $nsObj) {
			$ns = "p5_{$nsObj[0]}_{$nsObj[1]}";
			$uri = "https://biuro.biall-net.pl/wfs/{$nsObj[0]}/{$nsObj[1]}";
			$namespaceListOut[] = 'xmlns:' . $ns . '="' . $uri . '"';
		}
		return implode(' ', $namespaceListOut);
	}
	private function _getSourceNsList() {
		$usrObjList = array();
		$tblsAcl = $this->_usrAcl->getTablesAcl();
		foreach ($tblsAcl as $tblAcl) {
			$dataSourceName = 'default_db';// TODO: getSourceName
			$tblName = $tblAcl->getName();
			$usrObjList[] = array($dataSourceName, $tblName);
		}
		return $usrObjList;
	}
	private function _printGetCapabilitiesXml($wfsServerUrl) {
		?>
			<GetCapabilities>
				<DCPType>
					<HTTP>
						<Get onlineResource="<?php echo $wfsServerUrl; ?>?REQUEST=GetCapabilities" />
					</HTTP>
				</DCPType>
				<DCPType>
					<HTTP>
						<Post onlineResource="<?php echo $wfsServerUrl; ?>" />
					</HTTP>
				</DCPType>
			</GetCapabilities>
		<?php
	}
	private function _printDescribeFeatureTypeXml($wfsServerUrl) {
		?>
			<DescribeFeatureType>
				<SchemaDescriptionLanguage>
					<XMLSCHEMA />
				</SchemaDescriptionLanguage>
				<DCPType>
					<HTTP>
						<Get onlineResource="<?php echo $wfsServerUrl; ?>?REQUEST=DescribeFeatureType" />
					</HTTP>
				</DCPType>
				<DCPType>
					<HTTP>
						<Post onlineResource="<?php echo $wfsServerUrl; ?>" />
					</HTTP>
				</DCPType>
			</DescribeFeatureType>
		<?php
	}
	private function _printGetFeatureXml($wfsServerUrl) {
		?>
			<GetFeature>
				<ResultFormat>
					<WFSKMLOutputFormat />
					<GML2 />
					<GML3 />
					<SHAPE-ZIP />
					<CSV />
					<JSON />
				</ResultFormat>
				<DCPType>
					<HTTP>
						<Get onlineResource="<?php echo $wfsServerUrl; ?>?REQUEST=GetFeature" />
					</HTTP>
				</DCPType>
				<DCPType>
					<HTTP>
						<Post onlineResource="<?php echo $wfsServerUrl; ?>" />
					</HTTP>
				</DCPType>
			</GetFeature>
		<?php
	}
	private function _printTransactionXml($wfsServerUrl) {
		?>
			<Transaction>
				<DCPType>
					<HTTP>
						<Get onlineResource="<?php echo $wfsServerUrl; ?>?request=Transaction" />
					</HTTP>
				</DCPType>
				<DCPType>
					<HTTP>
						<Post onlineResource="<?php echo $wfsServerUrl; ?>" />
					</HTTP>
				</DCPType>
			</Transaction>
		<?php
	}
	private function _printLockFeatureXml($wfsServerUrl) {
		?>
			<LockFeature>
				<DCPType>
					<HTTP>
						<Get onlineResource="<?php echo $wfsServerUrl; ?>?REQUEST=LockFeature" />
					</HTTP>
				</DCPType>
				<DCPType>
					<HTTP>
						<Post onlineResource="<?php echo $wfsServerUrl; ?>" />
					</HTTP>
				</DCPType>
			</LockFeature>
		<?php
	}
	private function _printGetFeatureWithLockXml($wfsServerUrl) {
		?>
			<GetFeatureWithLock>
				<ResultFormat>
					<GML2 />
				</ResultFormat>
				<DCPType>
					<HTTP>
						<Get onlineResource="<?php echo $wfsServerUrl; ?>?REQUEST=GetFeatureWithLock" />
					</HTTP>
				</DCPType>
				<DCPType>
					<HTTP>
						<Post onlineResource="<?php echo $wfsServerUrl; ?>" />
					</HTTP>
				</DCPType>
			</GetFeatureWithLock>
		<?php
	}
	private function _printFeatureTypeListXml() {
		// TODO: get list from userAcl
		$featureTypes = array();
		$tblsAcl = $this->_usrAcl->getTablesAcl();
		foreach ($tblsAcl as $tblAcl) {
			$dataSourceName = 'default_db';// TODO: getSourceName
			$tblName = $tblAcl->getName();
			$usrObjList[] = array($dataSourceName, $tblName);
			$featureType = array();
			$featureType['ns'] = "p5_{$dataSourceName}";
			$featureType['Title'] = $tblAcl->getRawLabel();
			$featureType['Abstract'] = $tblAcl->getRawLabel();
			$featureType['Keywords'] = array();
			$featureType['Keywords'][] = $tblAcl->getID();
			$featureType['Keywords'][] = $tblName;
			$featureType['Keywords'][] = $tblAcl->getRawLabel();
			$featureType['Keywords'] = implode(", ", $featureType['Keywords']);
			$featureType['SRS'] = "EPSG:4326";
			$featureType['LatLongBoundingBox'] = array();// TODO: feature LatLongBoundingBox
			$featureType['LatLongBoundingBox']['minx'] = "8.12328509871721";
			$featureType['LatLongBoundingBox']['miny'] = "38.8575126897477";
			$featureType['LatLongBoundingBox']['maxx'] = "9.838674658246807";
			$featureType['LatLongBoundingBox']['maxy'] = "41.31378404137082";
			$featureTypes[$tblName] = $featureType;
		}
		/*
			<FeatureType>
				<Name>ppr06:AMBITIPAESAGGIO</Name>
				<Title>AMBITIPAESAGGIO</Title>
				<Abstract />
				<Keywords>features, AMBITIPAESAGGIO</Keywords>
				<SRS>EPSG:4326</SRS>
				<LatLongBoundingBox minx="8.12328509871721" miny="38.8575126897477" maxx="9.838674658246807" maxy="41.31378404137082" />
			</FeatureType>
		*/
		$featureTypesXml = '';
		foreach ($featureTypes as $tblName => $feature) {
			$featureTypesXml .= '<FeatureType>' . "\n";
				$featureTypesXml .= '<Name>' . "{$feature['ns']}:{$tblName}" . '</Name>' . "\n";
				$featureTypesXml .= '<Title>' . "{$feature['Title']}" . '</Title>' . "\n";
				if (!empty($feature['Abstract'])) {
					$featureTypesXml .= '<Abstract>' . "{$feature['Abstract']}" . '</Abstract>' . "\n";
				} else {
					$featureTypesXml .= '<Abstract/>' . "\n";
				}
				if (!empty($feature['Keywords'])) {
					$featureTypesXml .= '<Keywords>' . "{$feature['Keywords']}" . '</Keywords>' . "\n";
				} else {
					$featureTypesXml .= '<Keywords/>' . "\n";
				}
				$featureTypesXml .= '<SRS>' . "{$feature['SRS']}" . '</SRS>' . "\n";
				if (!empty($feature['LatLongBoundingBox'])) {
					$latLongBoundingBoxOut = array();
					$latLongBoundingBoxOut[] = 'minx="' . $feature['LatLongBoundingBox']['minx'] . '"';
					$latLongBoundingBoxOut[] = 'miny="' . $feature['LatLongBoundingBox']['miny'] . '"';
					$latLongBoundingBoxOut[] = 'maxx="' . $feature['LatLongBoundingBox']['maxx'] . '"';
					$latLongBoundingBoxOut[] = 'maxy="' . $feature['LatLongBoundingBox']['maxy'] . '"';
					$featureTypesXml .= '<LatLongBoundingBox ' . implode(' ', $latLongBoundingBoxOut) . ' />';
				}
			$featureTypesXml .= '</FeatureType>' . "\n";
		}
		return $featureTypesXml;
	}

}