se/SE/se-lib/Route/Storage.php

<?php
// @requires $_SERVER['SERVER_NAME']

Lib::loadClass('RouteBase');
Lib::loadClass('Schema_TableFactory');
Lib::loadClass('Response');
Lib::loadClass('UI');

/*
# Storage:
- [ ] view available storage (from Zasoby - type 'BAZA_DANYCH', 'DATABASE_MYSQL', ...)
- [ ] check config for connection
- [ ] add cells to Zasoby
- [ ] create cells in Storage
- [x] use PDO

*/
class Route_Storage extends RouteBase {

	public function handleAuth() {
		if (!User::logged()) {
			User::authByRequest();
		}
	}

	public function defaultAction() {
		UI::gora();
		UI::menu();
		$this->navView();
		try {
			$storageList = $this->getStorageList();
			if (empty($storageList)) throw new Exception("No storage defined");
			$storageMenu = array();
			foreach ($storageList as $storage) {
				$menuItem = array();
				$menuItem['id'] = $id = $storage['ID'];
				$menuItem['nazwa'] = $storage['DESC'];
				$menuItem['typ'] = $storage['TYPE'];
				$menuItem['tabele i widoki'] = '<a href="index.php?_route=Storage&_task=tableList&idStorage=' . $id . '">' . "tabele" . '</a>';
				//$menuItem['views'] = '<a href="index.php?_route=Storage&_task=viewList&idStorage=' . $id . '">' . "views" . '</a>';
				$menuItem['raw info'] = '<a href="index.php?_route=Storage&_task=rawInfo&idStorage=' . $id . '">' . "raw info" . '</a>';
				$menuItem['xsd'] = '<a href="index.php?_route=Storage&_task=xsd&idStorage=' . $id . '" target="_blank">' . "xsd" . '</a>';
				$storageMenu[] = $menuItem;
			}
			{// core object list
				$menuItem = array();
				//$menuItem['id'] = 'Obiekty';
				$menuItem['nazwa'] = 'Obiekty podstawowe';
				$menuItem['typ'] = 'OBJECTS';
				$menuItem['tabele i widoki'] = '<a href="index.php?_route=Storage&_task=coreObjectList">' . "obiekty" . '</a>';
				//$menuItem['views'] = '<a href="index.php?_route=Storage&_task=viewList&idStorage=' . $id . '">' . "views" . '</a>';
				//$menuItem['raw info'] = '<a href="index.php?_route=Storage&_task=objectRawInfo">' . "raw info" . '</a>';
				// TODO: $menuItem['xsd'] = '<a href="index.php?_route=Storage&_task=xsd&idStorage=' . $id . '" target="_blank">' . "xsd" . '</a>';
				$storageMenu[] = $menuItem;
			}
			{// object list - for current company
				$hostName = $_SERVER['SERVER_NAME'];
				$cleanHostName = str_replace(array(".", "-"), '_', $hostName);
				$menuItem = array();
				//$menuItem['id'] = 'Obiekty';
				$menuItem['nazwa'] = "Obiekty dla domeny '{$cleanHostName}'";
				$menuItem['typ'] = 'OBJECTS';
				$menuItem['tabele i widoki'] = '<a href="index.php?_route=Storage&_task=objectList">' . "obiekty" . '</a>';
				//$menuItem['views'] = '<a href="index.php?_route=Storage&_task=viewList&idStorage=' . $id . '">' . "views" . '</a>';
				//$menuItem['raw info'] = '<a href="index.php?_route=Storage&_task=objectRawInfo">' . "raw info" . '</a>';
				// TODO: $menuItem['xsd'] = '<a href="index.php?_route=Storage&_task=xsd&idStorage=' . $id . '" target="_blank">' . "xsd" . '</a>';
				$storageMenu[] = $menuItem;
			}
			DBG::table("storageMenu", $storageMenu, __CLASS__, __FUNCTION__, __LINE__);
		} catch (Exception $e) {
			UI::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		UI::dol();
	}

	public function getCoreObjectFromFile($objectName) {
		if ('default_db/' === substr($objectName, 0, 11)) {
			return array('name' => substr($objectName, 11));
		}

		$filePath = APP_PATH_SCHEMA . "/gui/core/{$objectName}.json";
		if (!file_exists($filePath)) throw new Exception("File not exists", 404);

		$json = file_get_contents($filePath);
		DBG::_('DBG', '>1', "{$objectName} filePath", $filePath, __CLASS__, __FUNCTION__, __LINE__);
		DBG::_('DBG', '>1', "{$objectName} file content", $json, __CLASS__, __FUNCTION__, __LINE__);
		$json = @json_decode($json, $assoc = true);
		DBG::_('DBG', '>1', "{$objectName} json_last_error()", json_last_error(), __CLASS__, __FUNCTION__, __LINE__);
		if (null == $json && 0 !== json_last_error()) throw new Exception("Parse json error for object '{$objectName}': " . json_last_error());
		$jsonParent = array();
		$parent = (is_array($json['parent_object']))? end($json['parent_object']) : $json['parent_object'];
		$jsonParent = $this->getCoreObjectFromFile($parent);
		return array_merge_recursive($jsonParent, $json);
	}

	public function coreObjectStructAction() {
		UI::gora();
		UI::menu();
		$this->navView();
		try {

			$object = V::get('object', '', $_REQUEST, 'word');
			if (empty($object)) throw new Exception("Missing Object name");
			$json = $this->getCoreObjectFromFile($object);
			DBG::_(true, true, "json", $json, __CLASS__, __FUNCTION__, __LINE__);


		} catch (Exception $e) {
			UI::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		UI::dol();
	}

	public function coreObjectListAction() {
		UI::gora();
		UI::menu();
		$this->navView();
		try {
			$files = glob(APP_PATH_SCHEMA . "/gui/core/*.json", GLOB_NOSORT);
			//DBG::_(true, true, "files", $files);
			$objectList = array();
			foreach ($files as $filePath) {
				$objItem = array();
				$fileName = basename($filePath);
				$objName = substr($fileName, 0, -5);// remove ext '.json'
				$objItem['name'] = $objName;
				$objItem['file_name'] = $fileName;
				$objItem['label'] = "";// TODO: read from json
				$objItem['struktura'] = '<a href="index.php?_route=Storage&_task=coreObjectStruct&object=' . $objName . '">' . "struct" . '</a>';
				$objectList[] = $objItem;
			}
			usort($objectList, function($rowA, $rowB) {
				$a = $rowA['nazwa']; $b = $rowB['nazwa'];
				if ($a == $b) return 0;
				return ($a < $b) ? -1 : 1;
			});

			DBG::table("objectList", $objectList, __CLASS__, __FUNCTION__, __LINE__);
		} catch (Exception $e) {
			UI::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		UI::dol();
	}

	public function objectListAction() {
		UI::gora();
		UI::menu();
		try {

		} catch (Exception $e) {
			UI::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		UI::dol();
	}

	public function tableListAction() {
		UI::gora();
		UI::menu();
		$this->navView();
		try {
			$idStorage = V::get('idStorage', 0, $_REQUEST, 'int');
			if (empty($idStorage)) throw new Exception("No id storage");
			$storageList = $this->getStorageList();
			if (empty($storageList)) throw new Exception("No storage defined");
			if (!array_key_exists($idStorage, $storageList)) throw new Exception("Storage id='{$idStorage}' not exists");

			$storagePdo = DB::getStorage($idStorage);
			$viewRealList = $storagePdo->getViewList();
			$tableRealList = $storagePdo->getTableList();
			$tableZasobList = array();
			foreach (DB::getPDO()->fetchAllByKey("
					select z.ID, z.`DESC`, z.A_STATUS
					from CRM_LISTA_ZASOBOW z
					where z.PARENT_ID = '{$idStorage}'
				", $key = 'DESC') as $ind => $row) {
				$tableZasobList[strtolower($ind)] = $row;
			}

			$emptyItem = array();
			$emptyItem['nazwa'] = '';
			$emptyItem['type'] = '';
			$emptyItem['id_zasob'] = '';
			$emptyItem['struktura'] = '';
			$emptyItem['objectTest'] = '';
			$emptyItem['xsd'] = '';
			$emptyItem['isHist'] = '';
			$emptyItem['uwagi'] = '';

			$tableList = array();
			foreach ($tableRealList as $row) {
				$tblName = $row['table_name'];
				$tblItem = V::cloneArray($emptyItem);
				$tblItem['nazwa'] = $tblName;
				$tblItem['type'] = $row['table_type'];
				$tblItem['struktura'] = '<a href="index.php?_route=Storage&_task=tableStruct&idStorage=' . $idStorage . '&table=' . $tblName . '">' . "struct" . '</a>';
				$tblItem['xsd'] = '<a href="index.php?_route=Storage&_task=tableXsd&idStorage=' . $idStorage . '&table=' . $tblName . '" target="_blank">' . "xsd" . '</a>';
				$tblItem['objectTest'] = '<a href="index.php?_route=Storage&_task=objectTest&idStorage=' . $idStorage . '&table=' . $tblName . '">' . "objectTest" . '</a>';
				$tblItem['isHist'] = ('_hist' == substr($tblName, -5));
				$tblItem['uwagi'] = '';
				$tblZasob = V::get($tblName, '', $tableZasobList);
				if ($tblZasob) {
					$tableZasobList[$tblName]['_checked'] = true;
					$tblItem['id_zasob'] = $tblZasob['ID'];
				} else {
					$tblItem['uwagi'] .= 'TODO: ADD ZASOB';
					$ajaxAddZasobLink = Request::getUriDirName() . "/index.php?_route=Storage&_task=addTableToZasoby&idStorage={$idStorage}&tblName={$tblName}";
					$onClick = "return p5UI__ButtonAjax(this, 'p5UIBtnAjax:Storage:addToZasoby', { href: '{$ajaxAddZasobLink}' })";
					$tblItem['id_zasob'] = '<a onclick="'.$onClick.'" class="btn btn-xs btn-primary" href="#">TODO: ADD ZASOB</a>';
				}
				$tableList[] = $tblItem;
			}
			foreach ($viewRealList as $row) {
				$tblName = $row['table_name'];
				$tblItem = V::cloneArray($emptyItem);
				$tblItem['nazwa'] = $tblName;
				$tblItem['type'] = $row['table_type'];
				$tblItem['struktura'] = '<a href="index.php?_route=Storage&_task=viewStruct&idStorage=' . $idStorage . '&table=' . $tblName . '">' . "struct" . '</a>';
				$tblItem['uwagi'] = '';
				$tblZasob = V::get($tblName, '', $tableZasobList);
				if ($tblZasob) {
					$tableZasobList[$tblName]['_checked'] = true;
					$tblItem['id_zasob'] = $tblZasob['ID'];
				} else {
					$tblItem['uwagi'] .= 'TODO: ADD ZASOB';
					$tblItem['id_zasob'] = 'TODO: ADD ZASOB';
				}
				$tableList[] = $tblItem;
			}
			foreach ($tableZasobList as $tblName => $row) {
				if (!$row['_checked']) {
					$tblItem = V::cloneArray($emptyItem);
					$tblItem['nazwa'] = $tblName;
					$tblItem['id_zasob'] = $row['ID'];
					$tblItem['type'] = 'unknown';
					$tblItem['uwagi'] = 'TODO: nie istnieje w bazie danych';
					$tableList[] = $tblItem;
				}
			}
			usort($tableList, function($rowA, $rowB) {
				$a = $rowA['nazwa']; $b = $rowB['nazwa'];
				if ($a == $b) return 0;
				$a1 = substr($a, 0, 1); $b1 = substr($b, 0, 1);
				if (('_' == $a1 || '_' == $b1) && $a1 != $b1) {
					return ($a1 < $b1) ? 1 : -1;
				}
				return ($a < $b) ? -1 : 1;
			});
			DBG::table("tableList", $tableList, __CLASS__, __FUNCTION__, __LINE__);
			?>
<script>
jQuery(document).on('p5UIBtnAjax:Storage:addToZasoby:click', function(e, n, payload) {
	console.log('event p5UIBtnAjax:Storage:addToZasoby:click', n, payload);
});
jQuery(document).on('p5UIBtnAjax:Storage:addToZasoby:ajaxLoaded', function(e, n, payload) {
	console.log('event p5UIBtnAjax:Storage:addToZasoby:ajaxLoaded', n, payload);
	if ('success' == payload.type && payload.body && payload.body.id > 0) {
		jQuery(n).parents('td').text(payload.body.id);
	}
	jQuery.notify(payload.msg, payload.type);
});
</script>
			<?php
		} catch (Exception $e) {
			UI::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		UI::dol();
	}

	public function rawInfoAction() {
		UI::gora();
		UI::menu();
		$this->navView();
		try {
			$idStorage = V::get('idStorage', 0, $_REQUEST, 'int');
			if (empty($idStorage)) throw new Exception("No id storage");
			$storageList = $this->getStorageList();
			if (empty($storageList)) throw new Exception("No storage defined");
			if (!array_key_exists($idStorage, $storageList)) throw new Exception("No id storage not exists");

			$storagePdo = DB::getStorage($idStorage);
			$rawInfo = $storagePdo->getTableListWithInfo();
			DBG::table("rawInfo", $rawInfo, __CLASS__, __FUNCTION__, __LINE__);
		} catch (Exception $e) {
			UI::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		UI::dol();
	}

	public function tableStructAction() {
		UI::gora();
		UI::menu();
		$this->navView();
		try {
			$idStorage = V::get('idStorage', 0, $_REQUEST, 'int');
			if (empty($idStorage)) throw new Exception("No id storage");
			$storageList = $this->getStorageList();
			if (empty($storageList)) throw new Exception("No storage defined");
			if (!array_key_exists($idStorage, $storageList)) throw new Exception("No id storage not exists");
			$tblName = V::get('table', '', $_REQUEST, 'word');
			if (empty($tblName)) throw new Exception("No table name");

			$storagePdo = DB::getStorage($idStorage);
			$tblStruct = $storagePdo->getTableStruct($tblName);

			$idTable = $this->fetchTableId($idStorage, $tblName);
			if ($idTable <= 0) {
				UI::alert('warning', "Zasob tabela '{$tblName}' nie istnieje");// TODO: add p5UI btn
				DBG::table("tblStruct", $tblStruct, __CLASS__, __FUNCTION__, __LINE__);
				throw new Exception("Zasob tabela '{$tblName}' nie istnieje");
			}

			$cellZasobList = array();
			foreach (DB::getPDO()->fetchAllByKey("
					select z.ID, z.`DESC`, z.A_STATUS
					from CRM_LISTA_ZASOBOW z
					where z.PARENT_ID = '{$idTable}'
				", $key = 'DESC') as $ind => $row) {
				$cellZasobList[strtolower($ind)] = $row;
			}

			$emptyItem = array();
			$emptyItem['name'] = '';
			$emptyItem['id_zasob'] = '';
			$emptyItem['uwagi'] = '';

			$emptyItem['type'] = '';
			$emptyItem['is_nullable'] = '';
			$emptyItem['default_value'] = '';
			$emptyItem['default_is_null'] = '';
			$emptyItem['max_length'] = '';
			$emptyItem['num_precision'] = '';
			$emptyItem['num_scale'] = '';
			$emptyItem['char_encoding'] = '';
			$emptyItem['char_collation'] = '';
			$emptyItem['extra'] = '';
			$emptyItem['raw_storage_type'] = '';

			$tableList = array();
			foreach ($tblStruct as $row) {
				$cellName = $row['name'];
				$tblItem = V::cloneArray($emptyItem);
				$tblItem['name'] = $cellName;
				foreach ($row as $fldName => $fldVal) {
					if (array_key_exists($fldName, $tblItem)) $tblItem[$fldName] = $fldVal;
				}
				$tblItem['uwagi'] = '';
				$lowerCellName = strtolower($cellName);
				$tblZasob = V::get($lowerCellName, '', $cellZasobList);
				if ($tblZasob) {
					$cellZasobList[$lowerCellName]['_checked'] = true;
					$tblItem['id_zasob'] = $tblZasob['ID'];
				} else {
					$tblItem['uwagi'] .= '!Zasob';//'TODO: ADD ZASOB';
					$ajaxAddZasobLink = Request::getUriDirName() . "/index.php?_route=Storage&_task=addCellToZasoby&idStorage={$idStorage}&tblName={$tblName}&cellName={$cellName}";
					$onClick = "return p5UI__ButtonAjax(this, 'p5UIBtnAjax:Storage:addToZasoby', { href: '{$ajaxAddZasobLink}' })";
					$tblItem['id_zasob'] = '<a onclick="'.$onClick.'" class="btn btn-xs btn-primary" href="#">TODO: ADD ZASOB</a>';
				}
				$tableList[] = $tblItem;
			}
			foreach ($cellZasobList as $cellName => $row) {
				if (!$row['_checked']) {
					$tblItem = V::cloneArray($emptyItem);
					$tblItem['name'] = $cellName;
					$tblItem['id_zasob'] = $row['ID'];
					$tblItem['uwagi'] = '!DB';//'TODO: nie istnieje w bazie danych';
					$tableList[] = $tblItem;
				}
			}
			usort($tableList, function($rowA, $rowB) {
				$a = $rowA['name']; $b = $rowB['name'];
				if ('ID' == $a) return -1;
				if ('ID' == $b) return 1;
				if ($a == $b) return 0;
				$a1 = substr($a, 0, 1); $b1 = substr($b, 0, 1);
				if (('_' == $a1 || '_' == $b1) && $a1 != $b1) {
					return ($a1 < $b1) ? 1 : -1;
				}
				return ($a < $b) ? -1 : 1;
			});
			DBG::table("tableList", $tableList, __CLASS__, __FUNCTION__, __LINE__);
			?>
<script>
jQuery(document).on('p5UIBtnAjax:Storage:addToZasoby:click', function(e, n, payload) {
	console.log('event p5UIBtnAjax:Storage:addToZasoby:click', n, payload);
});
jQuery(document).on('p5UIBtnAjax:Storage:addToZasoby:ajaxLoaded', function(e, n, payload) {
	console.log('event p5UIBtnAjax:Storage:addToZasoby:ajaxLoaded', n, payload);
	if ('success' == payload.type && payload.body && payload.body.id > 0) {
		jQuery(n).parents('td').next('td').text(payload.body.id);
		jQuery(n).remove();
	}
	jQuery.notify(payload.msg, payload.type);
});

</script>
<?php

		} catch (Exception $e) {
			UI::alert('danger', "Error #" . $e->getCode() .  "|" . $e->getLine() .  ": " . $e->getMessage());
		}
		UI::dol();
	}

	public function xsdAction() {
		$idStorage = V::get('idStorage', 0, $_REQUEST, 'int');
		$storage = DB::getStorage($idStorage);
		$tableRealList = $storage->getTableList();
		$srvName = $_SERVER['SERVER_NAME'];
		$storageZasobId = $storage->getZasobId();
		$objNs = "p5_{$storageZasobId}_{$tblName}";
		$objNsUri = "https://biuro.biall-net.pl/api/{$storageZasobId}/{$tblName}";
		$p5TypePrefix = "p5Type";
		$p5TypeNsUri = "http://biuro.biall-net.pl/p5/schema/types";
		$p5TypeNsLocation = "http://biuro.biall-net.pl/p5/schema/types.xsd";
		header('Content-type: text/plain; charset=utf-8');// TODO: test

		//header('Content-type: application/xml; charset=utf-8');
		$xmlWriter = new XMLWriter();
		$xmlWriter->openUri('php://output');
		$xmlWriter->setIndent(true);
		if (!$xmlWriter) throw new HttpException("Error no XMLWriter", 404);
		$xmlWriter->startDocument('1.0', 'UTF-8');
		$xmlWriter->startElement('xs:schema');
		$xmlWriter->writeAttribute('xmlns:xs', 'http://www.w3.org/2001/XMLSchema');
		$xmlWriter->writeAttribute('xmlns:vc', 'http://www.w3.org/2007/XMLSchema-versioning');
		$xmlWriter->writeAttribute("xmlns:{$p5TypePrefix}", $p5TypeNsUri);
		$xmlWriter->writeAttribute('elementFormDefault', 'qualified');
		$xmlWriter->writeAttribute('targetNamespace', $objNsUri);
		$xmlWriter->writeAttribute('vc:minVersion', '1.1');

		$xmlWriter->startElement('xs:import');
		$xmlWriter->writeAttribute('namespace', $p5TypeNsUri);
		$xmlWriter->writeAttribute('schemaLocation', $p5TypeNsLocation);
		$xmlWriter->endElement();// xs:import

		foreach ($tableRealList as $tbl) {
			$tblName = $tbl['table_name'];
			$this->tableXsdViewXmlWriter($xmlWriter, $idStorage, $tblName);
		}

		$xmlWriter->endElement();// xs:schema
		$xmlWriter->endDocument();
	}

	public function tableXsdAction() {
		$idStorage = V::get('idStorage', '', $_GET);
		$tblName = V::get('table', '', $_GET, 'word');
		if (empty($tblName)) die("Wrong table name");
		header('Content-type: text/plain; charset=utf-8');// TODO: test

		$storage = DB::getStorage($idStorage);
		$storageZasobId = $storage->getZasobId();
		$objNs = "p5_{$storageZasobId}_{$tblName}";
		$objNsUri = "https://biuro.biall-net.pl/api/{$storageZasobId}/{$tblName}";
		$p5TypePrefix = "p5Type";
		$p5TypeNsUri = "http://biuro.biall-net.pl/p5/schema/types";
		$p5TypeNsLocation = "http://biuro.biall-net.pl/p5/schema/types.xsd";

		//header('Content-type: application/xml; charset=utf-8');
		$xmlWriter = new XMLWriter();
		$xmlWriter->openUri('php://output');
		$xmlWriter->setIndent(true);
		if (!$xmlWriter) throw new HttpException("Error no XMLWriter", 404);
		$xmlWriter->startDocument('1.0', 'UTF-8');
		$xmlWriter->startElement('xs:schema');
		$xmlWriter->writeAttribute('xmlns:xs', 'http://www.w3.org/2001/XMLSchema');
		$xmlWriter->writeAttribute('xmlns:vc', 'http://www.w3.org/2007/XMLSchema-versioning');
		$xmlWriter->writeAttribute("xmlns:{$p5TypePrefix}", $p5TypeNsUri);
		$xmlWriter->writeAttribute('elementFormDefault', 'qualified');
		$xmlWriter->writeAttribute('targetNamespace', $objNsUri);
		$xmlWriter->writeAttribute('vc:minVersion', '1.1');

		$xmlWriter->startElement('xs:import');
		$xmlWriter->writeAttribute('namespace', $p5TypeNsUri);
		$xmlWriter->writeAttribute('schemaLocation', $p5TypeNsLocation);
		$xmlWriter->endElement();// xs:import
		$this->tableXsdViewXmlWriter($xmlWriter, $idStorage, $tblName);
		$xmlWriter->endElement();// xs:schema
		$xmlWriter->endDocument();
	}

	public function tableXsdViewXmlWriter(&$xmlWriter, $idStorage, $tblName) {
		$storage = DB::getStorage($idStorage);
		$schema = Schema_TableFactory::build($tblName, $idStorage, $_SERVER['SERVER_NAME']);
		$struct = $schema->getStruct();
		DBG::_('DBG', '>1', "struct", $struct, __CLASS__, __FUNCTION__, __LINE__);

		$typeName = "{$tblName}Type";

		$xmlWriter->startElement('xs:complexType');
		$xmlWriter->writeAttribute('name', $typeName);
		$xmlWriter->startElement('xs:sequence');
		foreach ($struct as $field) {
			$xmlWriter->startElement('xs:element');
			$xmlWriter->writeAttribute('name', $field['name']);
			$xmlWriter->writeAttribute('minOccurs', 0);// TODO: set minOccurs by default, etc.
			if ($field['is_nullable']) $xmlWriter->writeAttribute('nillable', 'true');
			if (null !== $field['default_value']) {
				$xmlWriter->writeAttribute('default', $field['default_value']);
			} else if (null === $field['default_value'] && $field['is_nullable']) {
				$xmlWriter->writeAttribute('default', $field['default_value']);
			} else {
				// TODO: Schema BUG?
			}

			if (empty($field['p5_restrictions'])) {
				$xmlWriter->writeAttribute('type', "p5Type:{$field['p5_type']}");
			} else {
				$xmlWriter->startElement('xs:simpleType');
				$xmlWriter->writeAttribute('base', "p5Type:{$field['p5_type']}");
				$xmlWriter->startElement('xs:restriction');
				if (!empty($field['p5_restrictions']['enumeration'])) {
					foreach ($field['p5_restrictions']['enumeration'] as $enumValue) {
						$xmlWriter->startElement('xs:enumeration');
						$xmlWriter->writeAttribute('value', $enumValue);
						$xmlWriter->endElement();// xs:enumeration
					}
				} else {
					// TODO: another restrictions...
				}
				$xmlWriter->endElement();// xs:restriction
				$xmlWriter->endElement();// xs:simpleType
			}
			$xmlWriter->endElement();// xs:element
		}
		$xmlWriter->endElement();// xs:sequence
		$xmlWriter->endElement();// xs:complexType
		return;

		// <xs:element maxOccurs="1" minOccurs="0" name="{$fldName}" nillable="true" type="xs:integer"/>
		$pKeyField = 'ID';//$storageObject->getPrimaryKeyFieldName();
		//DBG::_(true, true, "struct", $struct, __CLASS__, __FUNCTION__, __LINE__);
		foreach ($struct as $field) {
			$fldName = $vField->getName();
			$fldType = $vField->getType();
			$xsdType = $fldType->getTypeForXsd();

			if ($fldType->hasDefault()) {
				$fldDefault = $fldType->getDefault();
				if (!empty($fldDefault) || '0' === $fldDefault) {
					$elNode->setAttribute('default', $fldDefault);
				}
			}

			$fldRestrictions = $fldType->getRestrictions();
			if (empty($fldRestrictions)) {
				$elNode->setAttribute('type', "{$p5TypePrefix}:{$xsdType}");
			} else {
				$sType = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:simpleType');
				$elNode->appendChild($sType);
				$sTypeRes = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:restriction');
				$sType->appendChild($sTypeRes);
				$sTypeRes->setAttribute('base', "{$p5TypePrefix}:{$xsdType}");

				$enumList = $fldType->getEnumeration();
				if (empty($enumList)) {
					foreach ($fldRestrictions as $restricionName => $restrictionValue) {
						if ('maxLength' == $restricionName) {
							$sTypeResMaxLength = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:maxLength');
							$sTypeRes->appendChild($sTypeResMaxLength);
							$sTypeResMaxLength->setAttribute('value', $restrictionValue);
						} else if ('minLength' == $restricionName) {
							$sTypeResMinLength = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:minLength');
							$sTypeRes->appendChild($sTypeResMinLength);
							$sTypeResMinLength->setAttribute('value', $restrictionValue);
						} else if ('pattern' == $restricionName) {
							$sTypeResPattern = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:pattern');
							$sTypeRes->appendChild($sTypeResPattern);
							$sTypeResPattern->setAttribute('value', $restrictionValue);
						} else if ('fractionDigits' == $restricionName) {
							$sTypeResFractionDigits = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:fractionDigits');
							$sTypeRes->appendChild($sTypeResFractionDigits);
							$sTypeResFractionDigits->setAttribute('value', $restrictionValue);
						} else if ('totalDigits' == $restricionName) {
							$sTypeResTotalDigits = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:totalDigits');
							$sTypeRes->appendChild($sTypeResTotalDigits);
							$sTypeResTotalDigits->setAttribute('value', $restrictionValue);
						} else if ('maxExclusive' == $restricionName) {
							$sTypeResMaxExclusive = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:maxExclusive');
							$sTypeRes->appendChild($sTypeResMaxExclusive);
							$sTypeResMaxExclusive->setAttribute('value', $restrictionValue);
						} else if ('minExclusive' == $restricionName) {
							$sTypeResMinExclusive = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:minExclusive');
							$sTypeRes->appendChild($sTypeResMinExclusive);
							$sTypeResMinExclusive->setAttribute('value', $restrictionValue);
						} else if ('maxInclusive' == $restricionName) {
							$sTypeResMaxInclusive = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:maxInclusive');
							$sTypeRes->appendChild($sTypeResMaxInclusive);
							$sTypeResMaxInclusive->setAttribute('value', $restrictionValue);
						} else if ('minInclusive' == $restricionName) {
							$sTypeResMinInclusive = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:minInclusive');
							$sTypeRes->appendChild($sTypeResMinInclusive);
							$sTypeResMinInclusive->setAttribute('value', $restrictionValue);
						}
						/* TODO: xsd restrictions:
	enumeration	Defines a list of acceptable values
	fractionDigits	Specifies the maximum number of decimal places allowed. Must be equal to or greater than zero
	length	Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero
	maxExclusive	Specifies the upper bounds for numeric values (the value must be less than this value)
	maxInclusive	Specifies the upper bounds for numeric values (the value must be less than or equal to this value)
	maxLength	Specifies the maximum number of characters or list items allowed. Must be equal to or greater than zero
	minExclusive	Specifies the lower bounds for numeric values (the value must be greater than this value)
	minInclusive	Specifies the lower bounds for numeric values (the value must be greater than or equal to this value)
	minLength	Specifies the minimum number of characters or list items allowed. Must be equal to or greater than zero
	pattern	Defines the exact sequence of characters that are acceptable
	totalDigits	Specifies the exact number of digits allowed. Must be greater than zero
	whiteSpace	Specifies how white space (line feeds, tabs, spaces, and carriage returns) is handled
						*/
					}
				} else {
					foreach ($enumList as $enumValue) {
						$sTypeResEnum = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:enumeration');
						$sTypeRes->appendChild($sTypeResEnum);
						$sTypeResEnum->setAttribute('value', $enumValue);
					}
				}
			}
		}

		$elNode = $dom->createElementNS('http://www.w3.org/2001/XMLSchema', 'xs:element');
		$rootNode->appendChild($elNode);
		$elNode->setAttribute('name', $tblName);
		$elNode->setAttribute('type', "{$objNs}:{$typeName}");

		header('Content-type: application/xml');
		echo $dom->saveXML();
		exit;
	}

	public function navView() {
		$backLabel = 'back';
		$backLink = 'index.php?_route=Storage';
		$backDisabled = true;
		$currentLabel = 'Storage';
		$currentLink = 'index.php?_route=Storage';
		if ($task = V::get('_task', '', $_REQUEST)) {
			$currentLink = "index.php?_route=Storage&_task={$task}";
			$backDisabled = false;
			$idStorage = V::get('idStorage', 0, $_REQUEST, 'int');
			$tblName = V::get('table', '', $_REQUEST, 'word');
			$objName = V::get('object', '', $_REQUEST, 'word');
			switch ($task) {
				case 'tableList':
				case 'viewList':
				case 'rawInfo':
					$backLabel = 'Storage';
					$backLink = 'index.php?_route=Storage';
					$currentLink = "index.php?_route=Storage&_task={$task}&idStorage={$idStorage}";
					break;
				case 'tableStruct':
					$backLabel = "Tabele [{$idStorage}]";
					$backLink = "index.php?_route=Storage&_task=tableList&idStorage={$idStorage}";
					$currentLink = "index.php?_route=Storage&_task={$task}&idStorage={$idStorage}&table={$tblName}";
					break;
				case 'objectStruct': break;
				case 'coreObjectStruct':
					$backLabel = "Obiekty podstawowe";
					$backLink = "index.php?_route=Storage&_task=coreObjectList";
					$currentLink = "index.php?_route=Storage&_task={$task}&object={$objName}";
					break;
			}
			switch ($task) {
				case 'tableList': $currentLabel = "Tabele [{$idStorage}]"; break;
				case 'viewList':  $currentLabel = "Widoki [{$idStorage}]"; break;
				case 'rawInfo':   $currentLabel = "Raw info [{$idStorage}]"; break;
				case 'tableStruct': $currentLabel = "Struktura tabeli '{$tblName}'"; break;
				case 'coreObjectList': $currentLabel = "Obiekty podstawowe"; break;
				case 'coreObjectStruct': $currentLabel = "Obiekt '{$objName}'"; break;
				case 'objectList': $currentLabel = "Obiekty z aktualnej domeny"; break;// TODO: domain from $_GET
			}
		}
		?>
<nav class="navbar navbar-default navbar-static-top">
  <div class="container-fluid">
    <div class="navbar-left">
			<ul class="nav navbar-nav navbar-center">
				<li><a href="<?php echo $backLink; ?>" class="btn <?php echo ($backDisabled)? 'disabled' : ''; ?>"><i class="glyphicon glyphicon-chevron-left"></i> <?php echo $backLabel; ?></a></li>
			</ul>
		</div>
    <div class="navbar-left">
			<ul class="nav navbar-nav navbar-center">
				<li><a class="btn" href="<?php echo $currentLink; ?>"><?php echo $currentLabel; ?></a></li>
			</ul>
		</div>
    <div class="navbar-right">
<!--
			<ul class="nav navbar-nav navbar-right">
				<li><a href="#">Link</a></li>
				<li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Dropdown <span class="caret"></span></a>
					<ul class="dropdown-menu">
						<li><a href="#">Action</a></li>
						<li><a href="#">Another action</a></li>
						<li><a href="#">Something else here</a></li>
						<li role="separator" class="divider"></li>
						<li><a href="#">Separated link</a></li>
					</ul>
				</li>
			</ul>
-->
		</div>
  </div>
</nav>
		<?php
	}

	public function getStorageList() {
		$storageList = array();
		$sth = DB::getPDO()->prepare("
			select z.ID, z.`DESC`, z.`TYPE`
			from CRM_LISTA_ZASOBOW z
			where z.TYPE in('BAZA_DANYCH','DATABASE_MYSQL','DATABASE_POSTGRESQL')
		");
		$sth->execute();
		$rows = $sth->fetchAll();
		foreach ($rows as $row) {
			$storageList[$row['ID']] = $row;
		}
		return $storageList;
	}

	public function addTableToZasobyAction() {// sends JSON
		$response = new stdClass();
		try {
			$response->id = 123; throw new AlertSuccessException("TEST: Utworzono pomyślnie rekord nr 123");
			$idStorage = V::get('storageId', '', $_GET);
			$tblName = V::get('tblName', '', $_GET, 'word');
			if (empty($tblName)) throw new HttpException("Wrong table name");
			// $response->zasobTblId = $zasobItemFound->TABLE_ID;
			// $response->zasobId = $zasobItemFound->ID;

			$storage = DB::getStorage($idStorage);

			$tableStruct = $storage->getTableStruct($tblName);

			$zasobStorageId = $storage->getZasobId();
			if (!is_numeric($zasobStorageId)) throw new HttpException("Storage id is not set in config file");

			$zasobItem = array();
			$zasobItem['PARENT_ID'] = $zasobStorageId;
			$zasobItem['TYPE'] = 'TABELA';
			$zasobItem['DESC'] = $tblName;
			$zasobItem['DESC_PL'] = $tblName;

			$zasobItemFound = null;
			{
				$rows = DB::getPDO()->fetchAll("
					select z.`ID`, z.`DESC`
					from `CRM_LISTA_ZASOBOW` z
					where z.`PARENT_ID`='{$zasobStorageId}'
						and z.`DESC`='{$tblName}'
						and z.`A_STATUS` in('NORMAL','WAITING')
				");
				if (!empty($rows)) {
					$zasobItemFound = $rows[0]['ID'];
				}
			}

			if ($zasobItemFound > 0) {
				$response->_replaceButtonNode = "[{$zasobItemFound}]";
				throw new AlertInfoException("Zasob tabela '{$tblName}' już istnieje - nr '{$zasobItemFound}'");
			}

			$acl = User::getAcl()->getObjectAcl('default_db', 'crm_lista_zasobow');
			if (!$acl) throw new Exception("Brak dostępu do tabeli Zasoby");

			$item = array();
			$item['PARENT_ID'] = $zasobStorageId;
			$item['TYPE'] = 'TABELA';
			$item['DESC'] = $tblName;
			$item['DESC_PL'] = $tblName;
			if (DBG::isActive()) $response->_itemToCreate = $item;

			$createdId = $acl->addItem($item);
			if (!$createdId) throw new Exception("Nie udało się utworzyć nowego rekordu!");

			$response->id = $createdId;
			$response->record = $acl->getItem($createdId);
			$response->_replaceButtonNode = "[{$createdId}]";
			throw new AlertSuccessException("Utworzono pomyślnie rekord nr {$createdId}");
		} catch (AlertSuccessException $e) {
			$response->type = 'success';
			$response->msg = $e->getMessage();
		} catch (AlertInfoException $e) {
			$response->type = 'info';
			$response->msg = $e->getMessage();
		} catch (Exception $e) {
			$response->type = 'error';
			$response->msg = $e->getMessage();
		}

		Response::sendJsonExit($response);
	}

	public function addCellToZasobyAction() {// sends JSON
		$response = new stdClass();
		try {
			$response->id = 123; throw new AlertSuccessException("TEST: Utworzono pomyślnie rekord nr 123");
			$idStorage = V::get('storageId', '', $_GET);
			$tblName = V::get('tblName', '', $_GET, 'word');
			$cellName = V::get('cellName', '', $_GET, 'word');
			if (empty($tblName)) throw new HttpException("Wrong table name");
			if (empty($tblName)) throw new HttpException("Wrong cell name");

			$storage = DB::getStorage($idStorage);
			$tableStruct = $storage->getTableStruct($tblName);
			$zasobStorageId = $storage->getZasobId();
			if (!is_numeric($zasobStorageId)) throw new HttpException("Storage id is not set in config file");
			$idTable = $this->fetchTableId($zasobStorageId, $tblName);
			if ($idTable <= 0) throw new Exception("Zasob tabela '{$tblName}' nie istnieje");

			$acl = User::getAcl()->getObjectAcl('default_db', 'crm_lista_zasobow');
			if (!$acl) throw new Exception("Brak dostępu do tabeli Zasoby");

			$item = array();
			$item['PARENT_ID'] = $idTable;
			$item['TYPE'] = 'KOMORKA';
			$item['DESC'] = $cellName;
			$item['DESC_PL'] = $cellName;
			if (DBG::isActive()) $response->_itemToCreate = $item;

			$createdId = $acl->addItem($item);
			if (!$createdId) throw new Exception("Nie udało się utworzyć nowego rekordu!");

			$response->id = $createdId;
			$response->record = $acl->getItem($createdId);
			$response->_replaceButtonNode = "[{$createdId}]";
			throw new AlertSuccessException("Utworzono pomyślnie rekord nr {$createdId}");
		} catch (AlertSuccessException $e) {
			$response->type = 'success';
			$response->msg = $e->getMessage();
		} catch (AlertInfoException $e) {
			$response->type = 'info';
			$response->msg = $e->getMessage();
		} catch (Exception $e) {
			$response->type = 'error';
			$response->msg = $e->getMessage();
		}

		Response::sendJsonExit($response);
	}

	public function fetchTableId($idZasobStorage, $tblName) {
		$rows = DB::getPDO()->fetchAll("
			select z.`ID`, z.`DESC`
			from `CRM_LISTA_ZASOBOW` z
			where z.`PARENT_ID`='{$idZasobStorage}'
				and z.`DESC`='{$tblName}'
				and z.`A_STATUS` in('NORMAL','WAITING')
		");
		if (!empty($rows)) return $rows[0]['ID'];
		return null;
	}

}