se/SE/schema/default_db_xml_cache/struktura_silnika_obiektow_procesy5.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
    xmlns:sso_procesy5="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/struktura_silnika_obiektow_procesy5.xsd"
    xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
    xmlns:system_cache__resources_tree_generate_xsl_required_occurs_raport="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"
    xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
    xmlns:p5_obj_vars="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars.xsd"
    xmlns:p5_obj_vars_triggers="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars_triggers.xsd"
    xmlns:p5_obj_vars_php="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars_php.xsd"
    exclude-result-prefixes="xs"
    version="2.0">

    <xsl:import href="crm_lista_zasobow_to_xml_tree_instances.xsl"/>
    <xsl:import href="resources_tree_generate_xsl_require_occurs_raport.xsl"/>
    <xsl:import href="p5_obj_vars.xsl"/>
    <xsl:import href="p5_obj_vars_triggers.xsl"/>
    <xsl:param name="procesy5_SE_dir_loc" select="'/Library/Server/Web/Data/Sites/Default/SE'"/>
    <xsl:param name="public_html_xmslchema_procesy5_url" select="'https://127.0.0.1/SE/se-lib/src-xmlschema/public_html'"/>
    
    
    <xsl:variable name="p5_obj_vars_php:recurseArrayToXmlChildrens">
        
        
    
    
    
function save_array_to_xml($rootname,$array,$file) {			
    
        $namespaceMap = array();
        $namespaceMap['sso_procesy5'] = 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/struktura_silnika_obiektow_procesy5.xsd';
        //$namespaceMap['p5_obj_vars_php'] = 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars_php.xsd';
        $namespaceMap['p5_obj_vars'] = 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars_php.xsd';
        $namespaceMap['system_cache__appinfo'] = 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/system_cache__appinfo.TODO.xsd';
        $namespaceMap['p5_tr_map'] = 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_tr_map.TODO.xsd';
        
        $dom = new DOMDocument('1.0', 'utf-8');
        $dom-&gt;formatOutput = true;
        $dom-&gt;preserveWhiteSpace = false;
        $rootNode = $dom-&gt;createElementNS('http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/struktura_silnika_obiektow_procesy5.xsd', $rootname);
        $dom-&gt;appendChild($rootNode);
        $rootNode-&gt;setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');
        //$rootNode-&gt;setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:sso_procesy5', 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/struktura_silnika_obiektow_procesy5.xsd');
        ////$rootNode-&gt;setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:p5_obj_vars_php', 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars_php.xsd');
        //$rootNode-&gt;setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:p5_obj_vars', 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars_php.xsd');
        foreach ($namespaceMap as $nsKey =&gt; $nsLink) {
           $rootNode-&gt;setAttributeNS('http://www.w3.org/2000/xmlns/', "xmlns:{$nsKey}", $nsLink);
        }
        
        
        
    try {
    recurseArrayToXmlChildrens($dom, $rootNode, replaceKeys($array), $namespaceMap);
            $dom->save($file);
        }
        catch( Exception $ex )  {
            DEBUG_S(-3,'#838 Error with savexml exception ',$ex,__FILE__,__FUNCTION__,__LINE__);
        }
 }
        
        
function recurseArrayToXmlChildrens($dom, $parent, $a, $namespaceMap) {
            $DBG = 1;
            if (is_object($a)) $a = (array)$a;
            if (is_array($a)) {
            foreach ($a as $k =&gt; $v) {
            if($DBG&gt;1)echo "LOOP:{$k}...\n";
            // check if is attribute
             if ('@' === substr($k, 0, 1)) {// is attribute @
                 $k = substr($k, 1);
                 if (false !== strpos($k, ':')) {
                 if($DBG&gt;1)echo "LOOP:{$k} attr with namespace L. " . __LINE__ . "\n";
                 list($namespaceKey, $tagName) = explode(':', $k, 2);
                 $attrNode = $dom-&gt;createAttributeNS($namespaceMap[$namespaceKey], $tagName);
                 $attrNode-&gt;value = $v;
                 $parent-&gt;appendChild($attrNode);
             } else {
                 if($DBG&gt;1)echo "LOOP:{$k} attr without namespace L. " . __LINE__ . "\n";
                 $attrNode = $dom-&gt;createAttribute($k);
                 $attrNode-&gt;value = $v;
                 $parent-&gt;appendChild($attrNode);
                 }
                     } else if (false !== strpos($k, ':')) {// key has namespace ":"
                if($DBG&gt;1)echo "LOOP:{$k} with namespace L. " . __LINE__ . "\n";
                list($namespaceKey, $tagName) = explode(':', $k, 2);
                $elNode = $dom-&gt;createElementNS($namespaceMap[$namespaceKey], $tagName);
                $parent-&gt;appendChild($elNode);
                recurseArrayToXmlChildrens($dom, $elNode, $v, $namespaceMap);
            } else if (is_numeric($k)) {
                if($DBG&gt;1)echo "LOOP:{$k} is_numeric L. " . __LINE__ . "\n";
                //recurseArrayToXmlChildrens($dom, $parent, $v, $namespaceMap);
                $elNode = $dom-&gt;createElement("key".$k);
                $parent-&gt;appendChild($elNode);
                recurseArrayToXmlChildrens($dom, $elNode, $v, $namespaceMap);
            } else if (false !== strpos($k, '#')) {
                if($DBG)echo "LOOP:{$k} TODO: Invalid name with # L. " . __LINE__ . "\n";
            } else {
                $elNode = $dom-&gt;createElement($k);
                $parent-&gt;appendChild($elNode);
                recurseArrayToXmlChildrens($dom, $elNode, $v, $namespaceMap);
            }
            }
        } else {
            if($DBG&gt;1)echo "LOOP:TODO: a is not array '{$a}' L. " . __LINE__ . "\n";
            $txtNode = $dom-&gt;createTextNode($a);
            $parent-&gt;appendChild($txtNode);
        }
}
    </xsl:variable>
    <!--<xsl:variable name="p5_obj_vars_php:php-domdocument-convert-array-to-xml">
        
/**
 * Extends the DOMDocument to implement personal (utility) methods.
 *
 * @author Toni Van de Voorde
 */
class XmlDomConstruct extends DOMDocument {

	/**
	 * Constructs elements and texts from an array or string.
	 * The array can contain an element's name in the index part
	 * and an element's text in the value part.
	 * 
	 * It can also creates an xml with the same element tagName on the same 
	 * level.
	 * 
	 * ex:
	 * &lt;nodes&gt;
	 *   &lt;node&gt;text&lt;/node&gt;
	 *   &lt;node&gt;
	 *     &lt;field&gt;hello&lt;/field&gt;
	 *     &lt;field&gt;world&lt;/field&gt;
	 *   &lt;/node&gt;
	 * &lt;/nodes&gt;
	 * 
	 * Array should then look like:
	 * 
	 * Array (
	 *   "nodes" =&gt; Array (
	 *     "node" =&gt; Array (
	 *       0 =&gt; "text"
	 *       1 =&gt; Array (
	 *         "field" =&gt; Array (
	 *           0 =&gt; "hello"
	 *           1 =&gt; "world"
	 *         )
	 *       )
	 *     )
	 *   )
	 * )
	 *
	 * @param mixed $mixed An array or string.
	 * 
	 * @param DOMElement[optional] $domElement Then element
	 * from where the array will be construct to.
	 * 
	 */
	 public function fromMixed($mixed, DOMElement $domElement = null,$namespace,$namespace_key) {
	 
	 $domElement = is_null($domElement) ? $this : $domElement;
	 
   	 if (is_array($mixed)) {
          	   foreach( $mixed as $index =&gt; $mixedElement ) {
          	 
           	 if ( is_int($index) ) {
            	 /*if ( $index == 0 ) {
            	 $node = $domElement;
            	 } else {
            	 $node = $this-&gt;createElement($domElement-&gt;tagName);
            	 $domElement-&gt;parentNode-&gt;appendChild($node);
            	 }*/
            	 $node = $this-&gt;createElement("p5_obj_vars_php:key_".$index);
            	 $domElement-&gt;appendChild($node);
           	/* } else if( $index[0]='@' ) { //poczatek @ oznacza atrybut
           	     $node = $domElement->setAttributeNS($namespace, substr($index, -1), $mixedElement);
           	 
           	    // $node = $this->createElement("p5_obj_vars_php:key_".$index);
           	    $domElement->appendChild($node); 
           	*/ } else {
          	     $node = $this-&gt;createElementNS($namespace,$index);
          	     $domElement-&gt;appendChild($node);
          	 }
          	 
          	 $this-&gt;fromMixed($mixedElement, $node,$namespace,$namespace_key);
          	 
          	 }
   	 } else {
   	 if(strlen($mixed)&gt;0)
	 $domElement-&gt;appendChild($this-&gt;createTextNode($mixed));
	 }
	 
	 }
	
}




function save_array_to_xml($rootname,$array,$file) {			
$array2XmlConverter  = new XmlDomConstruct('1.0', 'utf-8');
$array2XmlConverter-&gt;xmlStandalone   = TRUE;
$array2XmlConverter-&gt;formatOutput    = TRUE;
$node=$array2XmlConverter-&gt;createElementNS('http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars_php_xml.xsd', 'sso_procesy5:'.$rootname);
$node-&gt;setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');
$array2XmlConverter-&gt;appendChild($node);  
$node-&gt;setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:sso_procesy5', 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/struktura_silnika_obiektow_procesy5.xsd');
$node-&gt;setAttributeNS('http://www.w3.org/2000/xmlns/', 'xmlns:p5_obj_vars_php', 'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars_php.xsd');
$array2XmlConverter-&gt;appendChild($node);  
try {
$array2XmlConverter-&gt;fromMixed( replaceKeys($array),$node,'http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/struktura_silnika_obiektow_procesy5.xsd','http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_obj_vars_php_xml.xsd' );
$array2XmlConverter-&gt;normalizeDocument ();
//        $xml    = $array2XmlConverter-&gt;saveXML();
$array2XmlConverter-&gt;save($file);
}
catch( Exception $ex )  {
DEBUG_S(-3,'#838 Error with savexml exception ',$ex,__FILE__,__FUNCTION__,__LINE__);
}
}




    </xsl:variable>-->
    <xsl:variable name="p5_obj_vars_php:functions_to_view_obj_form">
        
        <!--<xsl:value-of select="$p5_obj_vars_php:php-domdocument-convert-array-to-xml"/>-->
        <xsl:value-of select="$p5_obj_vars_php:recurseArrayToXmlChildrens"/>
        
        function replaceKeys(array $input) {
            $return = array();
             foreach ($input as $key =&gt; $value) {
             $key=str_replace(array('-',':','#','*','(',')'),array('__x2D__','__x3A__','__x23__','__x2A__','__x28__','__x29__'), $key);		
                    if (is_array($value))
                    $value = replaceKeys($value); 
                $return[$key] = $value;
             }
            return $return;
        }        
        function array_to_xml($array, &amp;$xml_user_info,$namespace) {
         foreach($array as $key =&gt; $value) {
            if(is_array($value)) {
            // if(!is_numeric($key)){
            $subnode = $xml_user_info-&gt;addChild($key);
            array_to_xml($value, $subnode,$namespace);
                //}else{
                //   $subnode = $xml_user_info->addChild("item$key");
                //   array_to_xml($value, $subnode);
                // }
            }else {
            $xml_user_info-&gt;addChild($key,htmlspecialchars("$value"));
            }
         }
        }
        
       
        
        function tag_to_drop_instance_by_missed_search(&amp;$key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance,$evaluate_key_value_root_instance_id_1472,$path) {
        //$path.="/".$evaluate_key_value_root_instance."[".$evaluate_key_value_root_instance_id_1472."]";
        $key3_values_search_RID_ID_to_REMOTE_ID[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance][$evaluate_key_value_root_instance_id_1472]['to_drop'][]='#1477'.$path;
        //chcemy zdropowac rodzicow poprzez wykorzystanie klucza  [back-referenced] =&gt; Array
        //@2015-12-24 todo jezeli nie mozna w kolejnej instancji dropowac klucza parenta jezeli jest tam inna instancja odnoszaca sie do tego samego parenta?
        //tag_to_drop_backreferenced_instance($key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance,$evaluate_key_value_root_instance_id_1472,$path);
        
        }
        
        
        
        function tag_to_drop_backreferenced_instance(&amp;$key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema_par,$evaluate_key_value_root_instance_par,$evaluate_key_value_root_instance_id_1472_par,$path) {
        $path.="/".$evaluate_key_value_root_instance_par."[".$evaluate_key_value_root_instance_id_1472_par."]";
        DEBUG_S(-3,'dropuje keye  ',array($evaluate_key_value_root_instance_schema_par,$evaluate_key_value_root_instance_par,$evaluate_key_value_root_instance_id_1472_par,$path),__FILE__,__FUNCTION__,__LINE__);
        //chcemy zdropowac rodzicow poprzez wykorzystanie klucza  [back-referenced] =&gt; Array
        
        
        foreach($key3_values_search_RID_ID_to_REMOTE_ID[$evaluate_key_value_root_instance_schema_par][$evaluate_key_value_root_instance_par][$evaluate_key_value_root_instance_id_1472_par]['back-referenced'] as  $evaluate_key_value_root_instance_schema=&gt;$evaluate_key_value_root_instance_schema_arr) {
        foreach($evaluate_key_value_root_instance_schema_arr as $evaluate_key_value_root_instance=&gt;$evaluate_key_value_root_instance_arr) {
        foreach($evaluate_key_value_root_instance_arr as $root_instance_id=&gt;$evaluate_key_value_schema_arr) {
        DEBUG_S(-3,'#1488 probuje zdropowac back-referenced $evaluate_key_value_root_instance_schema_arr: ',array($evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance,$root_instance_id,$path),__FILE__,__FUNCTION__,__LINE__);
        //$key3_values_search_RID_ID_to_REMOTE_ID[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance][$root_instance_id]['to_drop'][]='#1494'.$path;
        $list_not_dropped_parent_bindings=list_not_dropped_parent_bindings($key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance,$root_instance_id);
        DEBUG_S(-3,'#1507 upewniam sie czy moge rekursywnie dropowac dalej klucz: ',array($list_not_dropped_parent_bindings,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance),__FILE__,__FUNCTION__,__LINE__);
        if(empty($list_not_dropped_parent_bindings)) tag_to_drop_backreferenced_instance($key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance,$root_instance_id,$path) ;
        tag_to_drop_instance_by_missed_search($key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance,$root_instance_id,$path) ;
        }
        }
        }
        
        //szukamy czy inne instancje maja back-reference do tego samego ID i nie sa dropped
        
        
        }
        //funkcja do upewniania sie czy mozemy na podstawie dropowania z dziecka instancji, usuwac wyzsze instancje - a nie mozemy, jezeli do takiej samego klucza intsancji odwoluje sie inna instancja ktora aktualnie nie jest przeznaczona do drop
        function list_not_dropped_parent_bindings(&amp;$key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema_par,$evaluate_key_value_root_instance_par,$root_instance_id_par) {       
        foreach($key3_values_search_RID_ID_to_REMOTE_ID[$evaluate_key_value_root_instance_schema_par][$evaluate_key_value_root_instance_par] as $root_instance_id=&gt;$evaluate_key_value_schema_arr) {
        if($root_instance_id=='searched') continue;
        foreach($evaluate_key_value_schema_arr as  $evaluate_key_value_schema=&gt;$evaluate_key_value_arr) {
        // DEBUG_S(-3,'1514 szukam w instancji '.$root_instance_id.' / back-referenced oraz upewniam sie czy nie jest to_drop ',array($evaluate_key_value,$evaluate_key_value_id_arr),__FILE__,__FUNCTION__,__LINE__);
        if($evaluate_key_value_schema=='back-referenced') { //tutaj jest referencja do parent - odczytujemy do jakiego klucza
        foreach($evaluate_key_value_arr as $evaluate_key_value=&gt;$evaluate_key_value_id_arr) {
        foreach($evaluate_key_value_id_arr as $evaluate_key_value_id=&gt;$evaluate_key_value_remote_schema_arr) {
        foreach($evaluate_key_value_remote_schema_arr as $evaluate_key_value_remote_schema=&gt;$evaluate_key_value_remote_arr) {
        DEBUG_S(-3,'1514b zewnetrzny klucz instancji ('.$evaluate_key_value_remote_schema.') ',array($evaluate_key_value_remote_schema,$evaluate_key_value_remote_arr),__FILE__,__FUNCTION__,__LINE__);
        $refered_parent[$root_instance_id]=$evaluate_key_value_remote_schema;
        if($root_instance_id_par==$root_instance_id) $requested_instance_refers_to=$evaluate_key_value_remote_schema;
        }
        }
        }
        } else if($evaluate_key_value_schema=='to_drop') { //sprawdzam, czy nie jest juz to_drop
        $refered_parent_to_drop[$root_instance_id]=$refered_parent[$root_instance_id];
        DEBUG_S(-3,'1514c to_drop ('.$evaluate_key_value_remote_schema.') ',array($evaluate_key_value_remote_schema,$evaluate_key_value_remote_arr,$refered_parent_to_drop),__FILE__,__FUNCTION__,__LINE__);
        }
        }
        }
        //wszystkie ktore sa $refered_parent_to_drop kasuja aktywne  $refered_parent aby pokazac prawdiwa ilosc refow z pozostalych instancji
        DEBUG_S(-3,'raport do ewentualnego dropowania aktywnych refow do tego, do czego odwoluje sie ('.$root_instance_id_par.')',array($evaluate_key_value_root_instance_schema_par,$evaluate_key_value_root_instance_par,'nr instancji id ktora wyzwolila zapytanie i szukamy do jakiego parent_intance i badam czy jakas inna instancja nie ma takiego samego parent_id, jak nie ma, to moge rekursywnie dropnac parent_instance tego elementu:'.$root_instance_id_par,$refered_parent,$refered_parent_to_drop,$requested_instance_refers_to),__FILE__,__FUNCTION__,__LINE__);
        foreach($refered_parent as $rid=&gt;$parent_inst_id) { //wszystkie relacje do innych parent_id powinny byc skasowane z raportu 
        if(in_array($parent_inst_id, $refered_parent_to_drop))  unset($refered_parent[$rid]);
        }
        DEBUG_S(-3,'... po usunieciu kluczy dotyczacych instancji z flaga to_drop -refered_parent_to_drop ('.$root_instance_id_par.')',array($evaluate_key_value_root_instance_schema_par,$evaluate_key_value_root_instance_par,'nr instancji id ktora wyzwolila zapytanie i szukamy do jakiego parent_intance i badam czy jakas inna instancja nie ma takiego samego parent_id, jak nie ma, to moge rekursywnie dropnac parent_instance tego elementu:'.$root_instance_id_par,$refered_parent,$refered_parent_to_drop,$requested_instance_refers_to),__FILE__,__FUNCTION__,__LINE__);
        
        foreach($refered_parent as $rid=&gt;$parent_inst_id) {
        if($parent_inst_id!=$requested_instance_refers_to) unset($refered_parent[$rid]); //jezeli inna instancja odwoluje sie do innego parenta to nie interesuje nas ona
        }
        DEBUG_S(-3,'raport po wyfiltrowaniu i usunieciu kluczy z innych nieoczekiwanych realcji ',$refered_parent,__FILE__,__FUNCTION__,__LINE__);
        return($refered_parent);
        }
        
        //plan1 : dropujemy instancje ktore byly poszukiwane, lecz nie znaleziono kompletu elementow w schemacie $evaluate_key_value_root_instance_schema/$evaluate_key_value_root_instance  w oparciu o $evaluate_key_value_root_instance/['searched'] - jak czego nie ma, to dropujemy do $evaluate_key_value_root_instance['to_drop']
        foreach($key3_values_search_RID_ID_to_REMOTE_ID as $evaluate_key_value_root_instance_schema=&gt;$evaluate_key_value_root_instance_schema_arr) {
        foreach($evaluate_key_value_root_instance_schema_arr as $evaluate_key_value_root_instance=&gt;$evaluate_key_value_root_instance_arr) {
        foreach($evaluate_key_value_root_instance_arr['searched'] as $evaluate_key_value_schema_searched=&gt;$evaluate_key_value_schema_searched_arr) {
        //szukamy dla kazdego wyszukiwanego elementu, czy w kazdej z instancji zostal znaleziony TODO czy nie potrzebne sa tam oczekiwania co do minimalnych occurs ? na ten moment ignorujemy  
        // echo "&lt;br&gt;#1470 bede przeszukiwac dla evaluate_key_value_schema_searched: ".$evaluate_key_value_schema_searched." w instance ".$evaluate_key_value_root_instance;
        foreach($key3_values_search_RID_ID_to_REMOTE_ID[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance] as $evaluate_key_value_root_instance_id_1472=&gt;$evaluate_key_value_root_instance_id_1472_arr) {
        if($evaluate_key_value_root_instance_id_1472=='searched') continue;
        $path="/".$evaluate_key_value_root_instance."[".$evaluate_key_value_root_instance_id_1472."]";
        //	echo "&lt;br&gt;#1472: szukam evaluate_key_value_root_instance_id_1472:".$evaluate_key_value_root_instance_id_1472;
        if(!isset($evaluate_key_value_root_instance_id_1472_arr[$evaluate_key_value_schema_searched]))  { 
        $list_not_dropped_parent_bindings=list_not_dropped_parent_bindings($key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance,$evaluate_key_value_root_instance_id_1472);
        DEBUG_S(-3,'1475 ZABRAKLO w - sprawdzam list_not_dropped_parent_bindings',array($list_not_dropped_parent_bindings,$evaluate_key_value_schema_searched,$evaluate_key_value_root_instance_id_1472_arr),__FILE__,__FUNCTION__,__LINE__);
        //$key3_values_search_RID_ID_to_REMOTE_ID[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance][$evaluate_key_value_root_instance_id_1472]['to_drop']='#1477';
        
        tag_to_drop_backreferenced_instance($key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance,$evaluate_key_value_root_instance_id_1472);
        tag_to_drop_instance_by_missed_search($key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance,$evaluate_key_value_root_instance_id_1472,$path);
        }
        }
        }
        } //eof foreach($evaluate_key_value_root_instance_schema_arr as $evaluate_key_value_root_instance=&gt;$evaluate_key_value_root_instance_arr) {
        }
        
        
        
        
        DEBUG_S(-3,'evaluate_key3_value_root_instance_searched_merged  (z nich ida zapytania find_in[\$evaluate_key_value_root_instance_searched_merged] )',$evaluate_key3_value_root_instance_searched_merged,__FILE__,__FUNCTION__,__LINE__);
        
        //plan2 @2015-12-26 - zunifikowanie searcha ktory zwrocil dla przeciwsk.(1)=% oraz przeciwsk.(2)=% - z zabiegow (1)[1,2,3,4]+(2)[1,2,3,4] 
        // trzeba to przetworzyc chyba w miejscu rozdwojenia szukania wynik.ze.schem. do (1)[1,3]+(2)[2,4] - TODO czy jest zalezne to od @parent_choice_name ? - na razie tak to robimy
        //@2015-12-25 $queue itp - nie dzialaja - trzeba zupelnie inaczej dropowac keye - jest to do przemyslenia w zaleznosci od refow  - lub je po prostu zmergowac wszystkie i nie przetwarzac w ten sposob?
        function unique_searched_on_schema_split_queue(&amp;$key3_values_search_RID_ID_to_REMOTE_ID) {
        $last_evaluate_key_value_root_instance_count=1;
        foreach($key3_values_search_RID_ID_to_REMOTE_ID as $evaluate_key_value_root_instance_schema=&gt;$evaluate_key_value_root_instance_schema_arr) {
        $unique_searched_on_schema_split_queue=array();
        if(count($evaluate_key_value_root_instance_schema_arr)&gt;$last_evaluate_key_value_root_instance_count) { 
        DEBUG_S(-3,'#678 $last_evaluate_key_value_root_instance_count: for '.$evaluate_key_value_root_instance_schema.' = '.count($evaluate_key_value_root_instance_schema_arr).'&gt;'.$last_evaluate_key_value_root_instance_count.' ',$evaluate_key_value_root_instance_schema_arr,__FILE__,__FUNCTION__,__LINE__);
        foreach($evaluate_key_value_root_instance_schema_arr as $evaluate_key_value_root_instance=&gt;$evaluate_key_value_root_instance_arr) {
        foreach($evaluate_key_value_root_instance_arr as $root_instance_id=&gt;$evaluate_key_value_schema_arr) {
        if($root_instance_id=='searched') continue;
        
        if($evaluate_key_value_schema_arr['to_drop']) echo " to_drop RID:(".$root_instance_id.") ";
        if(!$evaluate_key_value_schema_arr['to_drop']) { echo " not_to_drop RID:(".$root_instance_id.") "; 
        
        foreach($evaluate_key_value_schema_arr as $evaluate_key_value_schema=&gt;$evaluate_key_value_arr) { //
        if($evaluate_key_value_schema=='back-referenced') continue;
        $unique_searched_on_schema_split_queue[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance][$root_instance_id]=array();
        
        foreach($evaluate_key_value_arr as $evaluate_key_value=&gt;$evaluate_key_value_id_arr) {
        foreach($evaluate_key_value_id_arr as $evaluate_key_value_id=&gt;$evaluate_key_value_remote_schema_arr ) { 
        foreach($evaluate_key_value_remote_schema_arr as $evaluate_key_value_remote_schema=&gt;$evaluate_key_value_remote_arr) {
        foreach($evaluate_key_value_remote_arr as $evaluate_key_value_remote=&gt;$evaluate_key_value_remote_id) {
        DEBUG_S(-3,'#695 doszedlem do Key Remote parametry',array($evaluate_key_value_root_instance_schema, $evaluate_key_value_root_instance, $root_instance_id, $evaluate_key_value_schema, $evaluate_key_value, $evaluate_key_value_id, $evaluate_key_value_remote_schema, $evaluate_key_value_remote, $evaluate_key_value_remote_id),__FILE__,__FUNCTION__,__LINE__);
        $unique_searched_on_schema_split_queue[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance][$root_instance_id][$evaluate_key_value_remote_schema][$evaluate_key_value_remote][]=$evaluate_key_value_remote_id;
        }
        }
        }
        }
        }
        } //eof if(not_to_drop)
        }
        } //eof foreach($evaluate_key_value_root_instance_schema_arr
        //zabijamy klucze naprzemian jadac od pierwszego
        foreach($unique_searched_on_schema_split_queue[$evaluate_key_value_root_instance_schema] as $evaluate_key_value_root_instance=&gt;$root_instance_id_arr) {
        $instances[]=$evaluate_key_value_root_instance; //mamy znane klucze instancji do przetwarzania
        }
        rsort($instances);
        DEBUG_S(-3,'#700 after all evaluate_key_value_root_instance $unique_searched_on_schema_split_queue - TODO dropowanie jest nieprawidlowe - musi sie odbywac z uwagi na klucze back-refferenced, aby rekord byl w odpowiedniej oczekiwanej sekwencji? jaka logika? ',array($instances,$flipped,$unique_searched_on_schema_split_queue),__FILE__,__FUNCTION__,__LINE__);
        
        $dropped_key=array(); $passed_to_next_drop=array(); $preserve=array(); $queue_cur=0; $queue_not_drop=count($unique_searched_on_schema_split_queue[$evaluate_key_value_root_instance_schema]);
        foreach($instances as $key_instance=&gt;$evaluate_key_value_root_instance1624) { //lecimy po kluczach z instancji
        foreach($unique_searched_on_schema_split_queue[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance1624] as $root_instance_id=&gt;$evaluate_key_value_schema_arr) { //jade po kluczach z danego typu search
        $drop_debug[]="&lt;br&gt;#1625 dOs ".$evaluate_key_value_root_instance1624."[".$key_instance."] *** RI: ".$root_instance_id."*** " ;
        foreach($instances as $ki714=&gt;$ekvri714) {
        if($ekvri714==$evaluate_key_value_root_instance1624) continue;
        $drop_debug[]="&lt;br&gt; ki714::".$ki714." ////  "." :::";
        if(isset($unique_searched_on_schema_split_queue[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance1624][$root_instance_id])) { //znalazlem, ze taki klucz wystepuje dalej - to go dropujemy
        if(isset($preserve[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance1624][$root_instance_id])) {
        $drop_debug[]=" #2171 preserve ";
        } else if(!isset($dropped_key[$root_instance_id]) and !isset($passed_to_next_drop[$root_instance_id]) and !isset($preserve[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance1624][$root_instance_id])) {      
        $dropped_key[$root_instance_id]=true;
        $drop_debug[]="#2173 passed and tell to be next dropped qc(".$queue_cur.") ".$queue_not_drop;
        $preserve[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance1624][$root_instance_id]=true;
        $queue_cur++;
        } else if(!isset($dropped_key[$root_instance_id]) and !isset($passed_to_next_drop[$root_instance_id])   and !isset($preserve[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance1624][$root_instance_id])) {      
        $queue_cur++;
        $dropped_key[$root_instance_id]=true;
        $passed_to_next_drop[$root_instance_id]=true;
        tag_to_drop_instance_by_missed_search($key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance1624,$root_instance_id,'#720 by unique_searched_on_schema_split_queue');
        $drop_debug[]="#2179 dropped and tell to next pass qc(".$queue_cur.") ".$queue_not_drop;
        }  else  if(isset($dropped_key[$root_instance_id]) and !isset($passed_to_next_drop[$root_instance_id]) and !isset($preserve[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance1624][$root_instance_id])) {      
        tag_to_drop_instance_by_missed_search($key3_values_search_RID_ID_to_REMOTE_ID,$evaluate_key_value_root_instance_schema,$evaluate_key_value_root_instance1624,$root_instance_id,'#720 by unique_searched_on_schema_split_queue');
        $drop_debug[]="#2176 dropped again dropped and tell to next drop qc(".$queue_cur.") ".$queue_not_drop;
        } else if(isset($dropped_key[$root_instance_id]) and isset($passed_to_next_drop[$root_instance_id])) {
        $drop_debug[]="#2178 unpassed passed  . qc(".$queue_cur.")";
        //$dropped_key[$root_instance_id]=true;
        $preserve[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance1624][$root_instance_id]=true;
        unset($passed_to_next_drop[$root_instance_id]);
        }	
        } else echo " ERROR?- not drop. ".$ki714."==".$key_instance;
        if($queue_cur&gt;=$queue_not_drop) $queue_cur=0;
        }
        }
        }
        } //eof  if(count($evaluate_key_value_root
        $last_evaluate_key_value_root_instance_count=count($evaluate_key_value_root_instance_schema_arr);   
        } //eof foreach $key3_values_search_RID_ID_to_REMOTE_ID
        DEBUG_S(-3,' drop debug - ',$drop_debug,__FILE__,__FUNCTION__,__LINE__);
        } //eof func
        
        
        
        unique_searched_on_schema_split_queue($key3_values_search_RID_ID_to_REMOTE_ID);
        
        DEBUG_S(-3,'key3_values_search_RID_ID_to_REMOTE_ID  (TODO testowe dodanie kluczy do dropowania dla instancji )',$key3_values_search_RID_ID_to_REMOTE_ID,__FILE__,__FUNCTION__,__LINE__);
        foreach($key3_values_search_RID_ID_to_REMOTE_ID as $evaluate_key_value_root_instance_schema=>$evaluate_key_value_root_instance_schema_arr) {
        foreach($evaluate_key_value_root_instance_schema_arr as $evaluate_key_value_root_instance=>$evaluate_key_value_root_instance_arr) {
        DEBUG_S(-3,'key3_values_search_RID_ID_to_REMOTE_ID '.$evaluate_key_value_root_instance,$evaluate_key_value_root_instance_arr,__FILE__,__FUNCTION__,__LINE__);
        }
        }
        
        
        function evaluate_key2_value_root_instance_searched_merged_cleaned($key3_values_search_RID_ID_to_REMOTE_ID) {
        foreach($key3_values_search_RID_ID_to_REMOTE_ID as $evaluate_key_value_root_instance_schema=&gt;$evaluate_key_value_root_instance_schema_arr) {
        foreach($evaluate_key_value_root_instance_schema_arr as $evaluate_key_value_root_instance=&gt;$evaluate_key_value_root_instance_arr) {
        foreach($evaluate_key_value_root_instance_arr as $root_instance_id=&gt;$evaluate_key_value_schema_arr) {
        //   DEBUG_S(-3,'jade ',$evaluate_key_value_schema_arr,__FILE__,__FUNCTION__,__LINE__);
        foreach($evaluate_key_value_schema_arr as $evaluate_key_value_schema=&gt;$evaluate_key_value_arr) 
        if($root_instance_id!='searched' and $root_instance_id!='back-referenced' and !isset( $evaluate_key_value_schema_arr['to_drop']))
        $evaluate_key2_value_root_instance_searched_merged_cleaned[$evaluate_key_value_root_instance_schema][]=$root_instance_id;
        //if(isset( $evaluate_key_value_schema_arr['to_drop'])) DEBUG_S(-3,'it is found to be dropped',$evaluate_key_value_schema_arr,__FILE__,__FUNCTION__,__LINE__);
        }
        } //eof foreach($evaluate_key_value_root_instance_schema_arr as $evaluate_key_value_root_instance=&gt;$evaluate_key_value_root_instance_arr) {
        }
        return $evaluate_key2_value_root_instance_searched_merged_cleaned;
        }
        
        $evaluate_key2_value_root_instance_searched_merged_cleaned=evaluate_key2_value_root_instance_searched_merged_cleaned($key3_values_search_RID_ID_to_REMOTE_ID);
        
        
        //@2015-12-26 klucze beda teraz zachowywac schemat (1)/(*) 
        function evaluate_key3_value_root_instance_searched_merged_cleaned($key3_values_search_RID_ID_to_REMOTE_ID) {
        foreach($key3_values_search_RID_ID_to_REMOTE_ID as $evaluate_key_value_root_instance_schema=&gt;$evaluate_key_value_root_instance_schema_arr) {
        foreach($evaluate_key_value_root_instance_schema_arr as $evaluate_key_value_root_instance=&gt;$evaluate_key_value_root_instance_arr) {
        foreach($evaluate_key_value_root_instance_arr as $root_instance_id=&gt;$evaluate_key_value_schema_arr) {
        //   DEBUG_S(-3,'jade ',$evaluate_key_value_schema_arr,__FILE__,__FUNCTION__,__LINE__);
        foreach($evaluate_key_value_schema_arr as $evaluate_key_value_schema=&gt;$evaluate_key_value_arr) 
        if($root_instance_id!='searched' and $root_instance_id!='back-referenced' and !isset( $evaluate_key_value_schema_arr['to_drop']))
        $evaluate_key3_value_root_instance_searched_merged_cleaned[$evaluate_key_value_root_instance_schema][$evaluate_key_value_root_instance][]=$root_instance_id;
        //if(isset( $evaluate_key_value_schema_arr['to_drop'])) DEBUG_S(-3,'it is found to be dropped',$evaluate_key_value_schema_arr,__FILE__,__FUNCTION__,__LINE__);
        }
        } //eof foreach($evaluate_key_value_root_instance_schema_arr as $evaluate_key_value_root_instance=&gt;$evaluate_key_value_root_instance_arr) {
        }
        return $evaluate_key3_value_root_instance_searched_merged_cleaned;
        }
        
        $evaluate_key3_value_root_instance_searched_merged_cleaned=evaluate_key3_value_root_instance_searched_merged_cleaned($key3_values_search_RID_ID_to_REMOTE_ID);
        
    </xsl:variable>
    
    <xsl:template name="sso_procesy5:main">
        <xsl:call-template name="main"/>
    </xsl:template>
    
    <xsl:template name="main">
        <xsl:message> 24 : testowe TODO do testowania template sso_procesy5:INSTANCES - @2015-12-13 nie wiem jeszcze po co to jest</xsl:message>
        <xsl:variable name="parent_type" select="'default_default_objects_types:MAGAZYN'"/>
        <!--<xsl:variable name="go_recurse_from_root_by_build_element_16">
            <xsl:call-template name="p5_tr_map:go_recurse_from_root_by_build_element_cache">
                <xsl:with-param name="parent_type" select="$parent_type"/> <!-\-test_objects:A_OBSZAR default_accounting:supplier_client_account_balance default_corespondence:document_position_offer default_default_objects_types:PUNKT_MAGISTRALNY default_default_objects_types:PUNKT_DYSTRYBUCYJNY default_default_objects_types:default_default_objects_types___d20e497 default_default_objects_types:MAGAZYN  default_companies:Company -\->
                <xsl:with-param name="cache" select="'read'"/>
            </xsl:call-template>
        </xsl:variable>-->
        <!--<xsl:result-document href="../default_db.instance.xml/sso_procesy5/INSTANCES.xml">
        <xsl:apply-templates mode="sso_procesy5:INSTANCES" select="$go_recurse_from_root_by_build_element_16"/>
        </xsl:result-document>-->

        <xsl:message>412 tworze zapytanie sql do stworzenia tabel dla oczekiwanego obiektu</xsl:message>
        <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type">
            <xsl:call-template name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations__complete">
                <!--<xsl:with-param name="name" select="$parent_type"/>-->
            </xsl:call-template>
        </xsl:variable>
        <xsl:variable name="sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache">
            <xsl:call-template name="sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache">
                <!--<xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>-->
           </xsl:call-template>
        </xsl:variable>
        <xsl:result-document href="../default_db.instance.xml/sso_procesy5/sso_procesy5_create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache.xml">
            <root>
                <sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache>
                    <xsl:copy-of select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache"/>
                </sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache>
            </root>
        </xsl:result-document>
        <!--@2015-12-14 rem for single file for single object instead--> 
        <!--<xsl:variable name="create_sql_tables_final">
            <xsl:apply-templates mode="sso_procesy5:create_sql_tables_final" select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache"/>
        </xsl:variable>
        <xsl:result-document href="../default_db.instance.xml/sso_procesy5/sso_procesy5_create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache.xml">
            <root>
                <sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache>
                    <xsl:copy-of select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache"/>
                </sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache>
                <!-\-<system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
            </system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>-\->
                <sso_procesy5:create_sql_tables_final>
                    <xsl:copy-of select="$create_sql_tables_final"/>
                </sso_procesy5:create_sql_tables_final>
            </root>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/create_sql_tables_final.php" omit-xml-declaration="yes">
           <xsl:processing-instruction name="php">
             <xsl:copy-of select="$create_sql_tables_final"/>
           </xsl:processing-instruction>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/create_obj_form_html.php" omit-xml-declaration="yes">
            <xsl:processing-instruction name="php">
            require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';            
            $db = DB::getDB();
            </xsl:processing-instruction>
                <html>
                    <body>                        
                        <hr/>create_obj_array_php_code:
                        <form action="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/create_obj_array_php_code.php" method="post">
                            <xsl:copy-of select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache//sso_procesy5:methods/p5_obj_vars:create_obj_form_html"/>
                        <input type="submit"  value="submit"/>    
                        </form>
                        
                        <form action="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/create_obj_array_php_code.php" method="post">
                            <input type="hidden" name="drop_tables" value="drop_tables"/>
                            <input type="submit"  value="drop_tables"/>    
                        </form>
                        <hr/>list_obj_form_php_code:
                        <form action="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/list_obj_form_php_code.php" method="post">
                            <input type="hidden" name="drop_tables" value="drop_tables"/>
                            <input type="submit"  value="drop_tables"/>    
                            <xsl:copy-of select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache//sso_procesy5:methods/p5_obj_vars:list_obj_form_html"/>
                            <input type="submit"  value="submit"/>
                        </form>

                        <hr/>view_obj_form_php_code:
                        <form action="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/view_obj_form_php_code.php" method="post">
                            <input type="hidden" name="drop_tables" value="drop_tables"/>
                            <xsl:copy-of select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache//sso_procesy5:methods/p5_obj_vars:view_obj_form_html"/>
                            <input type="submit"  value="submit"/>
                        </form>
                        
                        
                        <pre>
                            <xsl:copy-of select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache//sso_procesy5:methods/p5_obj_vars:create_obj_array_php"/>
                        </pre>
                </body>
                </html>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/create_obj_array_php_code.php" omit-xml-declaration="yes">
            <xsl:processing-instruction name="php">
            require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';            
    	    $db = DB::getDB();


                if($_POST['drop_tables']) {
                    foreach($sql_struct_drop as $sql) {
                    echo "i run drop sql:".$sql;
                    $db-&gt;query($sql);
                }
                die();
                }
                
                echo "&lt;pre&gt;";
                print_r($sql_struct);
                print_r($_POST);
                echo "&lt;/pre&gt;";
                foreach($sql_struct as $sql) {
                    echo "i run sql:".$sql;
                    $db-&gt;query($sql);
                }

            <xsl:copy-of select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache//p5_obj_vars:create_obj_array_php_code"/>
                echo "OK EXECUTED EOF";
            </xsl:processing-instruction>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/list_obj_form_php_code.php" omit-xml-declaration="yes">
            <xsl:processing-instruction name="php">
            //require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';            
    	    $db = DB::getDB();
                
                echo "&lt;pre&gt;";
                //print_r($sql_struct);
                print_r($_POST);
                echo "&lt;/pre&gt;";
                //foreach($sql_struct as $sql) {
                //    echo "i run sql:".$sql;
                //    $db-&gt;query($sql);
                //}

            <xsl:copy-of select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache//p5_obj_vars:list_obj_form_php_code"/>
                echo "OK EXECUTED EOF";
            </xsl:processing-instruction>
        </xsl:result-document>-->
        <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings">
            <!--<xsl:call-template name="system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings">
             <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
         </xsl:call-template>-->
            <!--<xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type//system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list"/>-->
            <xsl:for-each-group select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type//system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list[child::node()/child::node()/child::node()/@local-name='complexType']" group-by="child::node()/child::node()/@p5_tr_map:name_with_pref">
                <xsl:copy-of select="."></xsl:copy-of>
            </xsl:for-each-group>
        </xsl:variable>
        
        <xsl:result-document href="../default_db.instance.xml/sso_procesy5/create_object_navgation_menu.xml">
            <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings"/>
        </xsl:result-document>
        
        <xsl:result-document href="../default_db.instance.xml/sso_procesy5/create_object_navgation_menu.html" omit-xml-declaration="yes">
            <xsl:apply-templates mode="sso_procesy5:create_object_navgation_menu" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings"/>
        </xsl:result-document>
        
        
        <xsl:apply-templates mode="sso_procesy5:function_for_manage_object_files" select="$sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache"/>
        
    </xsl:template>

    <xsl:template match="*" mode="sso_procesy5:INSTANCES" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:choose>
            <xsl:when test="@event_type='494' and not(child::node()/attribute::node()[local-name()='event_type']='494') and ( child::node()[@event_type='473'] )">
                <xsl:element name="system_cache__appinfo:detect_root_sequence_id">
                    <xsl:attribute name="id" select="node()[@event_type='473']/@system_cache__appinfo:id" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"/>
                </xsl:element>
            </xsl:when>
            <xsl:when test="@event_type='434'">
                <xsl:apply-templates mode="#current"/>
            </xsl:when>
            <xsl:when test="@event_type='494'">
                <xsl:apply-templates mode="#current"/>
            </xsl:when>
            <xsl:when test="@event_type='710'">
                <xsl:apply-templates mode="#current"/>
            </xsl:when>
        </xsl:choose>
    </xsl:template>
    
    <!-- @2015-11-27 bindera: prawdopodobnie nalezy generowac struktury w bazie i triggerry dla wszystkich obiektow idac kolejno od obiektow z najmniejsza iloscia dziedziczen-->
    <xsl:template name="sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache">
        <!--<xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>-->
        <xsl:param name="transaction_id"/>
        <sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache>
            <xsl:attribute name="test" select="'TODO_73'"/>
            
            
            <!--<xsl:variable name="path2collection" select="'../default_db.instance.xml/detect_resource_type'"/>
            <xsl:variable name="path">
                <xsl:value-of select="concat($path2collection,'?select=*.(xml);recurse=no;on-error=warning')"/> 
            </xsl:variable>
            <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="collection($path)"/>-->
            
            
            <xsl:for-each select="$procesy5_system_schema/get_all_xsd_list/get_all_xsd[ substring-before(@system_cache__appinfo:document-uri,'/')!='default_db_xml_cache']" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd">
                <xsl:variable name="get_all_xsd_236" select="."/>
                        <xsl:for-each select="schema" xpath-default-namespace="http://www.w3.org/2001/XMLSchema"><!--[ @targetNamespace != $targetNamespace ] namespace::node() = $targetNamespace   and @targetNamespace='moj_ogrodek' -->
                            <xsl:variable name="targetNamespace_134" select="@targetNamespace"/>
                            <xsl:variable name="prefix_134" select="namespace::node()[. = $targetNamespace_134][1]/name()"/>
                            <xsl:choose>
                                <xsl:when test="count(.//node()[(local-name()='element' or local-name()='complexType' or local-name()='sequence' or local-name()='choice' or local-name()='complexContent' or local-name()='extension' ) and not(@id)])=0">
                                    <xsl:for-each select="(element)[ ( $prefix_134='test_objects' and ( @name='pacjent-el' or @name='zabieg-el' or @name='przeciwskazania-el' or @name='klasyfikacja_zgonu-el' ) ) ]"  xpath-default-namespace="http://www.w3.org/2001/XMLSchema"><!--   or ( and @name='URZADZENIA_I_OZNACZENIA_BHP' $prefix_134='prove_portal' or $prefix_134='moj_ogrodek' or $prefix_134='test_objects' ) and @name!='klient' and @name!='A_OBSZAR' and @name!='SEQUENCES_TEST' and @name!='t459b-el' and @name!='t459b-type-el' and @name!='t459b-type-derev-el'    dla ograniczenia mozna [$prefix_134='test_objects']-->
                                        <xsl:message>#690 sso: przetwarzam dla @name=<xsl:value-of select="@name"/>; $prefix_134=<xsl:value-of select="$prefix_134"/>;</xsl:message>
                                        <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type">
                                            <xsl:choose>
                                                <xsl:when test="local-name()='element'">
                                                    <xsl:call-template name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml">
                                                        <xsl:with-param name="name_with_prefix" select="concat($prefix_134,':',@name)"></xsl:with-param>
                                                        <xsl:with-param name="local-name" select="'element'"/>
                                                    </xsl:call-template>        
                                                </xsl:when>
                                                <xsl:when test="local-name()='complexType'">
                                                    <xsl:call-template name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml">
                                                        <xsl:with-param name="name_with_prefix" select="concat($prefix_134,':',@name)"></xsl:with-param>
                                                        <xsl:with-param name="local-name" select="'complexType'"/>
                                                    </xsl:call-template>
                                                </xsl:when>
                                                <xsl:otherwise><xsl:message terminate="yes">#706 element should be or ComplexType or element only!</xsl:message></xsl:otherwise>
                                            </xsl:choose>
                                        </xsl:variable>
                                        <xsl:variable name="go_recurse_from_root_by_build_element_85">
                                            <xsl:choose>
                                                <xsl:when test="local-name()='element'">
                                                    <xsl:call-template name="p5_tr_map:go_recurse_from_root_by_build_element_cache">
                                                        <xsl:with-param name="parent_type" select="concat($prefix_134,':',@name)"/> <!--test_objects:A_OBSZAR default_accounting:supplier_client_account_balance default_corespondence:document_position_offer default_default_objects_types:PUNKT_MAGISTRALNY default_default_objects_types:PUNKT_DYSTRYBUCYJNY default_default_objects_types:default_default_objects_types___d20e497 default_default_objects_types:MAGAZYN  default_companies:Company -->
                                                        <xsl:with-param name="cache" select="'read'"/>
                                                    </xsl:call-template>        
                                                </xsl:when>
                                                <xsl:when test="local-name()='complexType'">
                                                    <xsl:call-template name="p5_tr_map:go_recurse_from_root_by_build_complexType_cache">
                                                        <xsl:with-param name="parent_type" select="concat($prefix_134,':',@name)"/> <!--test_objects:A_OBSZAR default_accounting:supplier_client_account_balance default_corespondence:document_position_offer default_default_objects_types:PUNKT_MAGISTRALNY default_default_objects_types:PUNKT_DYSTRYBUCYJNY default_default_objects_types:default_default_objects_types___d20e497 default_default_objects_types:MAGAZYN  default_companies:Company -->
                                                        <xsl:with-param name="cache" select="'read'"/>
                                                    </xsl:call-template>
                                                </xsl:when>
                                                <xsl:otherwise><xsl:message terminate="yes">#706 element should be or ComplexType or element only!</xsl:message></xsl:otherwise>
                                            </xsl:choose>
                                        </xsl:variable>
                                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/detect_resource_type" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"> <!--   [ ( @parent_complexType='default_default_objects_types:URZADZENIE' or 1=2)  and ( @local-name='element')  ]     ( substring-before(@name,':')='prove_portal' or substring-before(@name,':')='moj_ogrodek' or substring-before(@parent_complexType,':')='test_objects'  and substring-before(@name,':')!='default_default_objects_types'  or -->
                                            <xsl:sort select="p5_tr_map:objects_derivations_list/@dereviation_count"/>
                                            <xsl:sort select="@p5_tr_map:parent_name_with_pref"></xsl:sort>
                                            <!--<xsl:copy-of select="objects_derivations_list" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"/>-->
                                            <xsl:message>#672 sso: przetwarzam dla elementu:<xsl:value-of select="@name"/>;</xsl:message>
                                            <!--<xsl:variable name="go_recurse_from_root_by_build_element_85">
                                                <xsl:call-template name="p5_tr_map:go_recurse_from_root_by_build_element_cache">
                                                    <xsl:with-param name="parent_type" select="@name"/> <!-\-test_objects:A_OBSZAR default_accounting:supplier_client_account_balance default_corespondence:document_position_offer default_default_objects_types:PUNKT_MAGISTRALNY default_default_objects_types:PUNKT_DYSTRYBUCYJNY default_default_objects_types:default_default_objects_types___d20e497 default_default_objects_types:MAGAZYN  default_companies:Company -\->
                                                    <xsl:with-param name="cache" select="'read'"/>
                                                </xsl:call-template>
                                            </xsl:variable>-->
                                            <xsl:variable name="sso_procesy5:instance_cache_informations">
                                                <xsl:element name="sso_procesy5:instance_cache_informations">
                                                    <xsl:apply-templates mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" select="$go_recurse_from_root_by_build_element_85">
                                                        <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="."/>
                                                        <xsl:with-param name="objects_derivations_list_same_id" select="p5_tr_map:objects_derivations_list"/>
                                                        <xsl:with-param name="transaction_id" select="$transaction_id"/>
                                                        <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="@name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                                                        <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="@local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                                                    </xsl:apply-templates>
                                                </xsl:element>
                                            </xsl:variable>
                                            <xsl:element name="sso_procesy5:function_for_manage_object">
                                                <xsl:attribute name="object_name" select="@name"/>
                                                <xsl:element name="sso_procesy5:methods">
                                                    <xsl:variable name="transaction_id" select="''"/>
                                                    <xsl:variable name="p5_obj_vars:create_obj_array">
                                                    <xsl:element name="p5_obj_vars:create_obj_array">
                                                        <xsl:apply-templates mode="p5_obj_vars:create_obj_array" select="$go_recurse_from_root_by_build_element_85">
                                                            <xsl:with-param name="sso_procesy5:instance_cache_informations" select="$sso_procesy5:instance_cache_informations"/>
                                                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                                                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="@name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                                                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="@local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                                                        </xsl:apply-templates>
                                                    </xsl:element>
                                                    </xsl:variable>
                                                    <xsl:comment>polaczony xml z funkcjami do przetwarzania do zapisu(formularz+php zapisujacy) a teraz takze i do odczytu(lista UI+php czytajacy)</xsl:comment>
                                                    <xsl:copy-of select="$p5_obj_vars:create_obj_array"/>
                                                    <!-- DODANIE OBIEKTU -->
                                                    <xsl:if test="1=1"><!-- DEBUG#700 - jak sie cos psuje - to zrobic 1=2 i sprawdzac co -->
                                                    <xsl:comment>przetworzony p5_obj_vars:create_obj_form_html z kodem w html do stworzenia formularza do zapisu obiektu i przeslania go do funkcji wytworzonej w p5_obj_vars:create_obj_array_php</xsl:comment>
                                                    <xsl:element name="p5_obj_vars:create_obj_form_html">
                                                        <xsl:apply-templates mode="p5_obj_vars:create_obj_html_form" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    <xsl:comment>przetworzony p5_obj_vars:create_obj_array dla generowania funkcji zapisujacej w php, do dalszego przetworzenia do p5_obj_vars:create_obj_array_php_code</xsl:comment>
                                                    <xsl:element name="p5_obj_vars:create_obj_array_php">
                                                        <xsl:apply-templates mode="p5_obj_vars:create_obj_array_php" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    <xsl:comment>przetworzony p5_obj_vars:create_obj_array_php z kodem w php do zapisu obiektu przeslanego z p5_obj_vars:list_obj_form_html</xsl:comment> 
                                                     <xsl:element name="p5_obj_vars:create_obj_array_php_code">
                                                        <xsl:apply-templates mode="p5_obj_vars:create_obj_array_php_code" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    <xsl:element name="p5_obj_vars:get_encapsulated_to_array_form"> <!-- schemat obiektu przeniesiony do arraya.php -->
                                                        <xsl:apply-templates mode="p5_obj_vars:get_encapsulated_to_array_form" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    <!-- LISTA/WYSWIETLENIE OBIEKTOW-->                        
                                                    <xsl:comment>przetworzony p5_obj_vars:create_obj_array dla wyswietlenia listy obiektow</xsl:comment>
                                                    <xsl:element name="p5_obj_vars:view_obj_form_html">
                                                        <xsl:apply-templates mode="p5_obj_vars:view_obj_form_html" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>                        
                                                    <xsl:comment>przetworzony p5_obj_vars:create_obj_array dla celu przetworzenia do funkcji pokazujacych obiekty - WIDOK/VIEW </xsl:comment>
                                                    <xsl:element name="p5_obj_vars:list_obj_form_html">
                                                        <xsl:apply-templates mode="p5_obj_vars:list_obj_form_html" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    <xsl:comment>przetworzony p5_obj_vars:create_obj_array dla zapewnienia dzialania p5_obj_vars:list_obj_form_html - przekazujacy dane  </xsl:comment>
                                                    <xsl:element name="p5_obj_vars:list_obj_form_php">
                                                        <xsl:apply-templates mode="p5_obj_vars:list_obj_form_php" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    <xsl:comment>przetworzony php obslugujacy pierwsze zapytanie do wyszukiwanych kluczy, ktore jest potem drugi raz przejezdzane - p5_obj_vars:list_obj_form_php dla zapewnienia dzialania p5_obj_vars:list_obj_form_html - przekazujacy dane - kod php </xsl:comment>
                                                    <xsl:element name="p5_obj_vars:list_obj_form_php_code">
                                                        <xsl:apply-templates mode="p5_obj_vars:list_obj_form_php_code" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    <xsl:comment>kod php po przetworzeniu z szukania - sciaga keys/values, ktore sa potem skladane </xsl:comment>
                                                    <xsl:element name="p5_obj_vars:merge_keys_list_obj_form_php_code">
                                                        <xsl:apply-templates mode="p5_obj_vars:merge_keys_list_obj_form_php_code" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    <xsl:comment>kod php parsujacy p5_obj_vars:merge_keys_list_obj_form_php_code i pokazujacy obiekt dla uzytkownika</xsl:comment>
                                                    <xsl:element name="p5_obj_vars:merge_keys_list_obj_form_html">
                                                        <xsl:apply-templates mode="p5_obj_vars:merge_keys_list_obj_form_html" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    <xsl:comment>kod php parsujacy p5_obj_vars:merge_keys_list_obj_form_php_code i pokazujacy obiekt w json - do obslugi syzbkiego podlaczania refow </xsl:comment>
                                                    <xsl:element name="p5_obj_vars:merge_keys_list_obj_form_json">
                                                        <xsl:apply-templates mode="p5_obj_vars:merge_keys_list_obj_form_json" select="$p5_obj_vars:create_obj_array"/>
                                                    </xsl:element>
                                                    </xsl:if>
                                                    <!-- EOF LISTA/WYSWIETLENIE OBIEKTOW-->
                                                    <!-- dane do menu wzajemnego -->
                                                    <xsl:element name="sso_procesy5:create_object_navgation_menu">
                                                        <xsl:apply-templates mode="sso_procesy5:create_object_navgation_menu" />
                                                    </xsl:element>
                                                    
                                                    <!--<xsl:element name="new_object">
                                                        <xsl:comment>@2015-12-13 TODO tu ma byc info o dostepnych funkcjach i metodach na danym obiekcie - co z nim robic - na razie robimy funkcje elementarne i testujemy</xsl:comment>
                                                        <xsl:element name="INSERT_TO_ROOT_TABLE_INSTANCE">
                                                            <xsl:attribute name="sso_procesy5:root_table_instance_name" select="@p5_tr_map:parent_id"/>
                                                            <xsl:element name="sso_procesy5:make_cache_action">
                                                                <xsl:element name="sso_procesy5:checkout_intance_tables">
                                                                    <xsl:comment>106: wszystkie structure_table_instance z polami nalezy stworzyc lub zalterowac</xsl:comment>
                                                                </xsl:element>
                                                                <xsl:element name="sso_procesy5:evaluate_map_variables">
                                                                    <xsl:comment>109: wszystkie zmienne nalezy evaluowac z id </xsl:comment>
                                                                </xsl:element>
                                                                <xsl:element name="sso_procesy5:insert_all_instances">
                                                                    <xsl:attribute name="sso_procesy5:root_table_instance_id"  select="@p5_tr_map:parent_id"/>
                                                                    <xsl:comment>112: wstawiamy obiekt do wszystkich tabel instancyjncyh zgodnie z mapa, bez tabeli root</xsl:comment>
                                                                    <xsl:element name="sso_procesy5:get_action_response">
                                                                        <xsl:element name="sso_procesy5:new_inserted_id">
                                                                            <xsl:element name="sso_procesy5:assign_to_evaluate_variable">
                                                                                <xsl:attribute name="sso_procesy5:evaluate_variable_name" select="'#NEW_ROOT_INSTANCE_ID_KEY'"/>
                                                                            </xsl:element>
                                                                        </xsl:element>
                                                                    </xsl:element>
                                                                </xsl:element>
                                                            </xsl:element>
                                                        </xsl:element>
                                                    </xsl:element>-->
                                                    
                                                    <xsl:comment>2016-01-15 triggery do synchronizacji struktur plaskich z obiektami zaglebionymi</xsl:comment>
                                                    <!--<xsl:element name="p5_obj_vars_triggers:create_db_sync_triggers">
                                                        <xsl:apply-templates mode="p5_obj_vars_triggers:create_db_sync_triggers" />
                                                    </xsl:element>-->
                                                </xsl:element>
                                                <xsl:copy-of select="$sso_procesy5:instance_cache_informations"/>
                                                <xsl:variable name="unique_tables_510">
                                                    <xsl:apply-templates mode="sso_procesy5:unique_structure_table" select="$sso_procesy5:instance_cache_informations"/>
                                                </xsl:variable>
                                                <xsl:copy-of select="$unique_tables_510"/>                    
                                                <xsl:element name="sso_procesy5:create_sql_tables_final_just_object">
                                                    <xsl:processing-instruction name="php">
                                                    <xsl:apply-templates mode="sso_procesy5:create_sql_tables_final" select="$unique_tables_510">
                                                        <xsl:with-param name="create_db_functions_from_go_recurse_from_root_by_build_element_with_cache" select="$sso_procesy5:instance_cache_informations"/>
                                                    </xsl:apply-templates>
                                                    </xsl:processing-instruction>
                                                </xsl:element>
                                            </xsl:element>
                                    </xsl:for-each>
                            </xsl:for-each>
                        </xsl:when>
                    </xsl:choose>
                </xsl:for-each>
            </xsl:for-each>
        </sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache>
    </xsl:template>
    
    <xsl:template match="sso_procesy5:function_for_manage_object" mode="sso_procesy5:function_for_manage_object_files">
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/create_sql_tables_final.php" omit-xml-declaration="yes">
            <xsl:processing-instruction name="php">
                require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';    
                <xsl:apply-templates mode="sso_procesy5:create_sql_table" select="." /> <!-- select="../../sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache"-->
        	    $db = DB::getDB();
                if($_POST['create_tables']) {
                  foreach($sql_struct as $sql) {
                    echo "i run sql:".$sql;
                    $db-&gt;query($sql);
                    echo " - CREATE FINISHED OK";
                }
                die();
                }
           </xsl:processing-instruction>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/create_obj_form_html.php" omit-xml-declaration="yes">
            <xsl:processing-instruction name="php">
            <!--require_once 'create_sql_tables_final.php';-->
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';   
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/superedit-DEBUG_S.php';            
            $db = DB::getDB();
            </xsl:processing-instruction>
            <html>
                <body>
                    <a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/create_object_navgation_menu.html">menu-glowne</a>
                    <xsl:copy-of select="sso_procesy5:methods/sso_procesy5:create_object_navgation_menu"/>
                    <hr/>create_obj_array_php_code:
                    <form action="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/create_obj_array_php_code.php" method="post">
                        <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:create_obj_form_html"/>
                        <input type="submit"  value="submit"/>    
                    </form>
                    <form action="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/create_obj_array_php_code.php" method="post">
                        <input type="hidden" name="drop_tables" value="drop_tables"/>
                        <input type="submit"  value="drop_tables"/>    
                    </form>
                    <form action="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/create_sql_tables_final.php" method="post">
                        <input type="hidden" name="create_tables" value="create_tables"/>
                        <input type="submit"  value="create_tables"/>    
                    </form>
                    <a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/list_obj_form_html.php">wyszukiwanie</a>
                </body>
            </html>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/create_obj_array_php_code.php" omit-xml-declaration="yes">
            <xsl:processing-instruction name="php">
            require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';    
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/superedit-DEBUG_S.php';            
    	    $db = DB::getDB();
                if($_POST['drop_tables']) {
                    foreach($sql_struct_drop as $sql) {
                    echo "i run drop sql:".$sql;
                    $db-&gt;query($sql);
                }
                die();
                }
              
                DEBUG_S(-3,'_POST',$_POST,__FILE__,__FUNCTION__,__LINE__);          
            <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:create_obj_array_php_code"/>
                echo "OK EXECUTED EOF";
            </xsl:processing-instruction>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/list_obj_form_html.php" omit-xml-declaration="yes">
            <xsl:processing-instruction name="php">
            require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';   
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/superedit-DEBUG_S.php';            
         
            $db = DB::getDB();
            </xsl:processing-instruction>
            <html>
                <body>
                    <a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/create_object_navgation_menu.html">menu-glowne</a>
                    <xsl:copy-of select="sso_procesy5:methods/sso_procesy5:create_object_navgation_menu"/>
                    <hr/>list_obj_form_php_code:
                    <form action="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/view_obj_form_html.php" method="post">
                        <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:list_obj_form_html"/>
                        <input type="submit"  value="submit"/>
                    </form>
                    <form action="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/view_obj_form_json.php" method="post">
                        <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:list_obj_form_html"/>
                        <input type="submit"  value="submit-json"/>
                    </form>
                </body>
            </html>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/list_obj_form_php_code.php" omit-xml-declaration="yes">
            <xsl:processing-instruction name="php">
            //require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';     
                $db = DB::getDB();
                
                echo "&lt;pre&gt;";
                DEBUG_S(-3,'_POST',$_POST,__FILE__,__FUNCTION__,__LINE__);          
                echo "&lt;/pre&gt;";
                //foreach($sql_struct as $sql) {
                //    echo "i run sql:".$sql;
                //    $db-&gt;query($sql);
                //}

            <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:list_obj_form_php_code"/>
                echo "OK EXECUTED EOF";
            </xsl:processing-instruction>

        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/view_obj_form_html.php" omit-xml-declaration="yes">
            <html>
                <head></head>
                <body>
            <a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/create_object_navgation_menu.html">menu-glowne</a>
            <xsl:copy-of select="sso_procesy5:methods/sso_procesy5:create_object_navgation_menu"/>
            <xsl:processing-instruction name="php">
            //require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';            
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/superedit-DEBUG_S.php';            
                 //includujemy schemat obiektu do php
                require_once 'get_encapsulated_to_array_form.php';            
            $db = DB::getDB();
            
            
                require_once 'list_obj_form_php_code.php'; <!-- zamiast: <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:list_obj_form_php_code"/>-->
                echo "OK EXECUTED 1/3 EOF";
           <!-- require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';            
    	    $db = DB::getDB();-->
              
                DEBUG_S(-3,'sql_debug - zapytania do bazy z p5_obj_vars:list_obj_form_php_code ',$sql_debug,__FILE__,__FUNCTION__,__LINE__);          
                
               

                DEBUG_S(-3,'key4_arr_values_search - macierz danych zlozonych ze sciezki xpath',$key4_arr_values_search,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'values znalezione wartosci po pierwszym formularzu list - TODO raczej niepotrzebne  [@sso_procesy5:read_key_value][p5_obj_vars:get_encapsulated_last_key_form()][] ',$values,__FILE__,__FUNCTION__,__LINE__);          
                DEBUG_S(-3,'key_values znalezione wartosci po pierwszym formularzu list - TODO raczej niepotrzebne  [@sso_procesy5:read_key_value][p5_obj_vars:get_encapsulated_last_key_form()][] ',$key_values,__FILE__,__FUNCTION__,__LINE__);          
                DEBUG_S(-3,'key_values_search_instance_ID[@sso_procesy5:read_key_value][p5_obj_vars:get_encapsulated_last_key_form()][] ',$key_values_search_instance_ID,__FILE__,__FUNCTION__,__LINE__);          
                DEBUG_S(-3,'key2_values_search_instance_ID ',$key2_values_search_instance_ID,__FILE__,__FUNCTION__,__LINE__);          
                DEBUG_S(-3,'key_values_search_CACHE_INSTANCE_ID[@sso_procesy5:read_key_value] ',$key_values_search_CACHE_INSTANCE_ID,__FILE__,__FUNCTION__,__LINE__);          
                DEBUG_S(-3,'key2_values_search_CACHE_INSTANCE_ID[@sso_procesy5:read_key_value] ',$key2_values_search_CACHE_INSTANCE_ID,__FILE__,__FUNCTION__,__LINE__);            
                DEBUG_S(-3,'key_values_search_REMOTE_ID[@p5_obj_vars:evaluate_key_value_root_instance][@p5_obj_vars:http_form_get_variable][p5_obj_vars:get_encapsulated_last_key_form()][]  ',$key_values_search_REMOTE_ID,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'key2_values_search_REMOTE_ID ( [p5_obj_vars:get_encapsulated_without_last_key_form(@p5_obj_vars:evaluate_key_value_remote)][p5_obj_vars:get_encapsulated_last_key_form(@p5_obj_vars:evaluate_key_value_remote][]) ',$key2_values_search_REMOTE_ID,__FILE__,__FUNCTION__,__LINE__);                            
                DEBUG_S(-3,'key_values_search_ID[@p5_obj_vars:evaluate_key_value_root_instance][@p5_obj_vars:http_form_get_variable][p5_obj_vars:get_encapsulated_last_key_form(http_form_get_variable)][]  ',$key_values_search_ID,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'key2_values_search_ID (wartosci instancji dla elementow tworozne w stylu #KEY[#seq] zamiast #KEY(x)[#seq] do analizy) ',$key2_values_search_ID,__FILE__,__FUNCTION__,__LINE__);

                DEBUG_S(-3,'key2_values_search_OBJ (znalezione wartosci elementow z bazy) ',$key2_values_search_OBJ,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'key3_values_search_ID_to_REMOTE_ID (klucze do zmniejszenia ilosci instancji na podstawie brakujacych referencji z wezlow nizszych - powinny zarazac wyzsze) ',$key3_values_search_ID_to_REMOTE_ID,__FILE__,__FUNCTION__,__LINE__);

                DEBUG_S(-3,'key3_values_search_RID_ID_to_REMOTE_ID ([ROOT_INSTANCE*][ROOT_INSTANCE][ROOT_INSTANCE_ID][ELEMENT_NAME*][ELEMENT_NAME][ID][@evaluate_key_value_remote][ID]) ',$key3_values_search_RID_ID_to_REMOTE_ID,__FILE__,__FUNCTION__,__LINE__);
    
                <xsl:copy-of select="$p5_obj_vars_php:functions_to_view_obj_form"/>

               
          		$file = '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/src-xmlschema/public_html/default_db.instance.xml/sso_procesy5/<xsl:value-of select="system_cache__appinfo:escape_object_prefix_to_string(@object_name)"/>/key3_values_search_RID_ID_to_REMOTE_ID.xml';
		        save_array_to_xml('key3_values_search_RID_ID_to_REMOTE_ID',$key3_values_search_RID_ID_to_REMOTE_ID,$file);
                echo '&lt;a href="<xsl:value-of select="$public_html_xmslchema_procesy5_url"/>/default_db.instance.xml/sso_procesy5/<xsl:value-of select="system_cache__appinfo:escape_object_prefix_to_string(@object_name)"/>/key3_values_search_RID_ID_to_REMOTE_ID.xml"&gt; xml z array do yed do analizy&lt;a&gt;';

                 DEBUG_S(-3,'replaceKeys(key4_arr_values_search)',replaceKeys($key4_arr_values_search),__FILE__,__FUNCTION__,__LINE__);

                $file = '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/src-xmlschema/public_html/default_db.instance.xml/sso_procesy5/<xsl:value-of select="system_cache__appinfo:escape_object_prefix_to_string(@object_name)"/>/key4_arr_values_search.xml';
		        save_array_to_xml('key4_arr_values_search',$key4_arr_values_search,$file);
                echo '&lt;a href="<xsl:value-of select="$public_html_xmslchema_procesy5_url"/>/default_db.instance.xml/sso_procesy5/<xsl:value-of select="system_cache__appinfo:escape_object_prefix_to_string(@object_name)"/>/key4_arr_values_search.xml"&gt; xml z array do yed do analizy&lt;a&gt;';

                
                
                <!-- function drop_key_by_missed_child($root_instance_name,$root_intance_id,$child_instance_name,$child_instance_expected_id) {
                    global $evaluate_key2_value_root_instance_searched_merged_cleaned;
                    unset($evaluate_key2_value_root_instance_searched_merged_cleaned[$root_instance_name][$root_intance_id]);
                    if(isset($key3_values_search_ID_to_REMOTE_ID
                }-->
                
              
                DEBUG_S(-3,'key3_values_search_ID_to_REMOTE_ID_merged (brakujace klucze na podstawie dzieci - TODO) ',$key3_values_search_ID_to_REMOTE_ID_merged,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'evaluate_key2_value_root_instance_searched_merged_cleaned (przetworzony evaluate_key2_value_root_instance_searched_merged wyczyszczony z intancji brakujacych refernecji rekursywnie- TODO) ',$evaluate_key2_value_root_instance_searched_merged_cleaned,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'evaluate_key3_value_root_instance_searched_merged_cleaned (przetworzony evaluate_key2_value_root_instance_searched_merged wyczyszczony z intancji brakujacych refernecji rekursywnie- TODO) ',$evaluate_key3_value_root_instance_searched_merged_cleaned,__FILE__,__FUNCTION__,__LINE__);

                 
               
            </xsl:processing-instruction>
            <h2>sso_procesy5:methods/p5_obj_vars:view_obj_form_html - tymczasowe przetworzenie do wyswietlenia 1 obiektu</h2>
            <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:view_obj_form_html"/>
            <xsl:processing-instruction name="php">
                <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:merge_keys_list_obj_form_php_code"/>
                 
                  
                DEBUG_S(-3,'sql_debug_merge - zapytania do bazy z p5_obj_vars:merge_keys_list_obj_form_php_code ',$sql_debug_merge,__FILE__,__FUNCTION__,__LINE__);          

                DEBUG_S(-3,'key_values_merged (odczytane klucze na podstawie find_in[$evaluate_key_value_root_instance_searched_merged[@p5_obj_vars:http_form_get_variable]] TODO do pozbycia sie na rzecz key3',$key_values_merged,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'values_merged (odczytane klucze na podstawie find_in[\$evaluate_key_value_root_instance_searched_merged[@@p5_obj_vars:http_form_get_variable]] TODO do pozbycia sie na rzecz key3 ',$values_merged,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'key3_values_merged (odczytane klucze na podstawie find_in[$evaluate_key_value_root_instance_searched_merged[@p5_obj_vars:http_form_get_variable]] - w stylu (*)/(1)',$key3_values_merged,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'values3_merged (odczytane klucze na podstawie find_in[\$evaluate_key_value_root_instance_searched_merged[@@p5_obj_vars:http_form_get_variable]] - w stylu (*)/(1)',$values3_merged,__FILE__,__FUNCTION__,__LINE__);

                echo "OK EXECUTED 2/3 EOF";
            </xsl:processing-instruction>
            <h2> sso_procesy5:methods/p5_obj_vars:merge_keys_list_obj_form_html wyswietlenie listy obiektow do przejscia do ich edycji</h2>
            <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:merge_keys_list_obj_form_html"/>
                OK EXECUTED 3/3
                <xsl:processing-instruction name="php">
                      echo "&lt;pre&gt;";
                DEBUG_S(-3,'form (odczytane wartosci przez formularz mode p5_obj_vars:merge_keys_list_obj_form_html)',$form,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'evaluate_from_ref_key_value (odczytane wartosci przez formularz mode p5_obj_vars:merge_keys_list_obj_form_html dla wyzwalania event 477 instancji na refie)',$evaluate_from_ref_key_value,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'debug_passed_else',$debug_passed_else,__FILE__,__FUNCTION__,__LINE__);
                 echo "&lt;/pre&gt;";
                </xsl:processing-instruction>
                </body>
            </html>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/view_obj_form_json.php" omit-xml-declaration="yes">
            <xsl:processing-instruction name="php">
            //require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';            
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/superedit-DEBUG_S.php';            
                 //includujemy schemat obiektu do php
             require_once 'get_encapsulated_to_array_form.php';            
            $db = DB::getDB();
            
              require_once 'list_obj_form_php_code.php'; <!--<xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:list_obj_form_php_code"/>-->
                echo "OK EXECUTED 1/3 EOF";

                <xsl:copy-of select="$p5_obj_vars_php:functions_to_view_obj_form"/>
        
                <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:merge_keys_list_obj_form_php_code"/>
                 
                DEBUG_S(-3,'sql_debug_merge - zapytania do bazy z p5_obj_vars:merge_keys_list_obj_form_php_code ',$sql_debug_merge,__FILE__,__FUNCTION__,__LINE__);          

                DEBUG_S(-3,'key_values_merged (odczytane klucze na podstawie find_in[$evaluate_key_value_root_instance_searched_merged[@p5_obj_vars:http_form_get_variable]] TODO do pozbycia sie na rzecz key3',$key_values_merged,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'values_merged (odczytane klucze na podstawie find_in[\$evaluate_key_value_root_instance_searched_merged[@@p5_obj_vars:http_form_get_variable]] TODO do pozbycia sie na rzecz key3 ',$values_merged,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'key3_values_merged (odczytane klucze na podstawie find_in[$evaluate_key_value_root_instance_searched_merged[@p5_obj_vars:http_form_get_variable]] - w stylu (*)/(1)',$key3_values_merged,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'values3_merged (odczytane klucze na podstawie find_in[\$evaluate_key_value_root_instance_searched_merged[@@p5_obj_vars:http_form_get_variable]] - w stylu (*)/(1)',$values3_merged,__FILE__,__FUNCTION__,__LINE__);
                echo "OK EXECUTED 2/3 EOF";
            </xsl:processing-instruction>
            <h2> sso_procesy5:methods/p5_obj_vars:merge_keys_list_obj_form_html wyswietlenie listy obiektow do przejscia do ich edycji</h2>
                <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:merge_keys_list_obj_form_json"/>
                OK EXECUTED 3/3
                <xsl:processing-instruction name="php">
                DEBUG_S(-3,'form (odczytane wartosci przez formularz mode p5_obj_vars:merge_keys_list_obj_form_html)',$form,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'evaluate_from_ref_key_value (odczytane wartosci przez formularz mode p5_obj_vars:merge_keys_list_obj_form_html dla wyzwalania event 477 instancji na refie)',$evaluate_from_ref_key_value,__FILE__,__FUNCTION__,__LINE__);
                DEBUG_S(-3,'debug_passed_else',$debug_passed_else,__FILE__,__FUNCTION__,__LINE__);
                </xsl:processing-instruction>
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/merge_keys_list_obj_form_php_code.php" omit-xml-declaration="yes">
            <h3> sso_procesy5:methods/p5_obj_vars:merge_keys_list_obj_form_php_code funkcje do znalezienia czesci wspolnej z kluczy key*searched* oraz opracowanych key2*searched*</h3>
            <xsl:processing-instruction name="php">
            //require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';            
            $db = DB::getDB();
            <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:merge_keys_list_obj_form_php_code"/><!-- tez to powinno byc prawidlowe dla jsona-->
                echo "OK EXECUTED EOF";
            </xsl:processing-instruction>
            <!--<xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:view_obj_form_html"/>-->
            echo "OK EXECUTED EOF";
        </xsl:result-document>
        <xsl:result-document  href="../default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@object_name)}/get_encapsulated_to_array_form.php" omit-xml-declaration="yes">
            <h3> sso_procesy5:methods/p5_obj_vars:merge_keys_list_obj_form_php_code funkcje do znalezienia czesci wspolnej z kluczy key*searched* oraz opracowanych key2*searched*</h3>
            <xsl:processing-instruction name="php">
            //require_once 'create_sql_tables_final.php';
            require_once '<xsl:value-of select="$procesy5_SE_dir_loc"/>/se-lib/bootstrap.php';            
            $db = DB::getDB();
            <xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:get_encapsulated_to_array_form"/>
                echo "OK EXECUTED  mode p5_obj_vars:get_encapsulated_to_array_form EOF";
            </xsl:processing-instruction>
            <!--<xsl:copy-of select="sso_procesy5:methods/p5_obj_vars:view_obj_form_html"/>-->   
        </xsl:result-document>
    </xsl:template>
    <xsl:template match="sso_procesy5:instance_cache_informations" mode="sso_procesy5:unique_structure_table">
        <xsl:for-each-group select="//(sso_procesy5:structure_table_child_instance|sso_procesy5:structure_table_root_instance|sso_procesy5:structure_table_sequence|sso_procesy5:structure_table_reference|sso_procesy5:structure_table_value)" group-by="@table_name" >
            <sso_procesy5:unique_structure_table>
                <xsl:attribute name="table_name" select="@table_name"/>
                <xsl:attribute name="table_type" select="local-name()"/>
                <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="@p5_tr_map:parent_name_with_pref"/>
                <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="@p5_tr_map:object_type_name_with_pref"/>
            </sso_procesy5:unique_structure_table>
        </xsl:for-each-group>
    </xsl:template>
    
    
    <xsl:template match="schema" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"/>
    
    <xsl:template match="go_recurse_from_root_by_build_element_loop" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <!--<xsl:variable name="detect_resource_type_102" select="current()"/>-->
        <xsl:element name="sso_procesy5:structure_loop_info">
            <xsl:copy-of select="@*"/>
        </xsl:element>
    </xsl:template>
    
    <xsl:template match="go_recurse_from_root_by_build_element_494|go_recurse_from_root_by_build_element_4940" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id" required="no"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>
            <!--<xsl:comment>92: tworzymy tabele instancyjna z cachem wszystkich mozliwch dziedziczen w dol dla analizowanego obiektu</xsl:comment>-->
            <xsl:choose>
                <xsl:when test="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_id=@system_cache__appinfo:id">
                    <xsl:element name="sso_procesy5:structure_table_root_instance">
                        <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                        <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                        <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                        <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                        <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                        <xsl:element name="column_ELEMENT_ID">
                            <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                        </xsl:element>
                        <xsl:element name="column_ELEMENT_NAME">
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                            </xsl:element>
                        </xsl:element>
                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']" ><!--  objects_derivations_list/p5_tr_map:derivations-->
                            <xsl:sort select="position()" data-type="number" order="descending"/> 
                            <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                            <xsl:element name="columns_CACHE_INSTANCE">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                    <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                                    <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:choose>
                                        <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                            <xsl:value-of select="true()"/>
                                        </xsl:when>
                                        <xsl:when test="@system_cache__resources_tree_generate_xsl_required_occurs_raport:derived_appropriate='true'"><xsl:value-of select="'derived'"/></xsl:when>
                                        <xsl:when test="@system_cache__resources_tree_generate_xsl_required_occurs_raport:derived_appropriate='false'"><xsl:value-of select="false()"/></xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="'derived'"/>
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:element>
                            </xsl:element>
                        </xsl:for-each>
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                        </xsl:apply-templates>
                    </xsl:element>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:message terminate="yes">not expected scenario - if no error further - delete section for system_cache__appinfo:id=<xsl:value-of select="@system_cache__appinfo:id"/>; p5_tr_map:uuid=<xsl:value-of select="@p5_tr_map:uuid"/>; </xsl:message>
                    <xsl:element name="sso_procesy5:structure_table_child_instance">
                        <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                        <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                        <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                        <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                        <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                        <xsl:element name="column_ELEMENT_ID">
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                            </xsl:element>
                        </xsl:element>
                        <xsl:element name="column_ELEMENT_NAME">
                            <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                        </xsl:element>
                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                            <xsl:sort select="position()" data-type="number" order="descending"/> 
                            <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                            <xsl:element name="columns_CACHE_INSTANCE">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                    <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                                    <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:choose>
                                        <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                            <xsl:value-of select="true()"/>
                                        </xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="'derived'"/>
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:element>
                            </xsl:element>
                        </xsl:for-each>
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                        </xsl:apply-templates>
                    </xsl:element>
                </xsl:otherwise>
            </xsl:choose>
    </xsl:template>
    <!-- @2015-12-10 funkcja do tworzenia koncowej mapy z uwzglednieniem cache instancji zintegrowanej z dziecziczeniami - jeszcze jest pozniej przetwarzana przez funkcje generujaca formularze i zapis do bazy -->
    <xsl:template match="go_recurse_from_root_by_build_element_494d" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>
        <!--<xsl:comment>92: tworzymy tabele instancyjna z cachem wszystkich mozliwch dziedziczen w dol dla analizowanego obiektu</xsl:comment>-->                        
            <!-- przyklad : when_type="after_main"
                                name="TERYT_terc_xml_import_after_main:after_main"
                                name_id="TERYT_terc_xml_import_after_main___d44e9"
                                prefix="TERYT_terc_xml_import_after_main"
                                local-name="element"
                                apply_template=""
                                p5_tr_map:parent_name_with_pref=""
                                p5_tr_map:parent_id=""
                                p5_tr_map:object_type_name_with_pref=""
                                p5_tr_map:object_type_id="" -->
            <xsl:element name="sso_procesy5:structure_table_root_instance">
                <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                <!-- -->
                <xsl:element name="column_ELEMENT_ID">
                    <xsl:element name="COLUMN_VALUE">
                        <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                    </xsl:element>
                </xsl:element>
                <xsl:element name="column_ELEMENT_NAME">
                    <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                </xsl:element>
                <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                    <xsl:sort select="position()" data-type="number" order="descending"/> 
                    <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                    <xsl:element name="columns_CACHE_INSTANCE">
                        <xsl:element name="COLUMN_NAME">
                            <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                            <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                        </xsl:element>
                        <xsl:element name="COLUMN_VALUE">
                            <xsl:choose>
                                <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                    <xsl:value-of select="true()"/>
                                </xsl:when>
                                <xsl:otherwise>
                                    <xsl:value-of select="'derived'"/>
                                </xsl:otherwise>
                            </xsl:choose>
                        </xsl:element>
                    </xsl:element>
                </xsl:for-each>
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                </xsl:apply-templates>
            </xsl:element>
    </xsl:template>
    
    <xsl:template match="go_recurse_from_root_by_build_element_4941|go_recurse_from_root_by_build_element_4942" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>                
            <!--<xsl:comment>92: tworzymy tabele instancyjna z cachem wszystkich mozliwch dziedziczen w dol dla analizowanego obiektu</xsl:comment>-->
            <xsl:choose>
                <xsl:when test="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_id=@system_cache__appinfo:id">
                    <xsl:message terminate="yes">not applicable event - to remove section if error will not occurs</xsl:message>
                    <xsl:element name="sso_procesy5:structure_table_root_instance">
                        <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                        <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                        <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                        <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                        <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                        <xsl:element name="column_ELEMENT_ID">
                            <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                        </xsl:element>
                        <xsl:element name="column_ELEMENT_NAME">
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                            </xsl:element>
                        </xsl:element>
                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                            <xsl:sort select="position()" data-type="number" order="descending"/> 
                            <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                            <xsl:element name="columns_CACHE_INSTANCE">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                    <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                                    <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:choose>
                                        <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                            <xsl:value-of select="true()"/>
                                        </xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="'derived'"/>
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:element>
                            </xsl:element>
                        </xsl:for-each>
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                        </xsl:apply-templates>
                    </xsl:element>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:element name="sso_procesy5:structure_table_child_instance">
                        <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                        <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                        <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                        <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                        <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                        <xsl:element name="column_ELEMENT_ID">
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                            </xsl:element>
                        </xsl:element>
                        <xsl:element name="column_ELEMENT_NAME">
                            <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                        </xsl:element>
                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                            <xsl:sort select="position()" data-type="number" order="descending"/> 
                            <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                            <xsl:element name="columns_CACHE_INSTANCE">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                    <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                                    <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:choose>
                                        <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                            <xsl:value-of select="true()"/>
                                        </xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="'derived'"/>
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:element>
                            </xsl:element>
                        </xsl:for-each>
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                        </xsl:apply-templates>
                    </xsl:element>
                </xsl:otherwise>
            </xsl:choose>
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_473|go_recurse_from_root_by_build_element_473b" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>
        <!-- sekwencje oraz elementy lokalne complexType-->
            <xsl:element name="sso_procesy5:structure_table_sequence">
                <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                <xsl:if test="@system_cache__appinfo:maxOccurs"><xsl:attribute name="system_cache__appinfo:maxOccurs" select="@system_cache__appinfo:maxOccurs"/></xsl:if>
                <xsl:if test="@system_cache__appinfo:minOccurs"><xsl:attribute name="system_cache__appinfo:minOccurs" select="@system_cache__appinfo:minOccurs"/></xsl:if>
                <xsl:element name="column_ELEMENT_ID">
                    <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_SEQ_KEY'"/>
                </xsl:element>
                <xsl:element name="column_PARENT_ID">
                    <xsl:attribute name="sso_procesy5:evaluate_key_value" select="@retrieve_PARENT_ID"/>
                </xsl:element>
                <xsl:element name="column_CACHE_INSTANCE_ID">
                    <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                </xsl:element>
                <!--<xsl:element name="column_ELEMENT_NAME">
                        <xsl:element name="COLUMN_VALUE">
                            <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                        </xsl:element>
                    </xsl:element>-->
                <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                    <xsl:sort select="position()" data-type="number" order="descending"/> 
                    <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                    <xsl:element name="columns_CACHE_INSTANCE">
                        <xsl:element name="COLUMN_NAME">
                            <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                            <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                        </xsl:element>
                        <xsl:element name="COLUMN_VALUE">
                            <xsl:choose>
                                <xsl:when test="@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                    <xsl:value-of select="true()"/>
                                </xsl:when>
                                <xsl:when test="@system_cache__resources_tree_generate_xsl_required_occurs_raport:derived_appropriate='true'"><xsl:value-of select="'derived'"/></xsl:when>
                                <xsl:when test="@system_cache__resources_tree_generate_xsl_required_occurs_raport:derived_appropriate='false'"><xsl:value-of select="false()"/></xsl:when>
                                <xsl:otherwise>
                                    <xsl:value-of select="'derived'"/>
                                </xsl:otherwise>
                            </xsl:choose>
                        </xsl:element>
                    </xsl:element>
                </xsl:for-each>    
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                </xsl:apply-templates>
            </xsl:element>
        
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_720|go_recurse_from_root_by_build_element_428a|go_recurse_from_root_by_build_element_428" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:variable name="detect_resource_type_102" select="current()"/>
         <!-- attrybuty i wartosci? -->
            <xsl:element name="sso_procesy5:structure_table_value">
                <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                <xsl:if test="@system_cache__appinfo:maxOccurs"><xsl:attribute name="system_cache__appinfo:maxOccurs" select="@system_cache__appinfo:maxOccurs"/></xsl:if>
                <xsl:if test="@system_cache__appinfo:minOccurs"><xsl:attribute name="system_cache__appinfo:minOccurs" select="@system_cache__appinfo:minOccurs"/></xsl:if>
                <xsl:element name="column_ELEMENT_ID">
                    <xsl:attribute name="sso_procesy5:read_key_value" select="'#new_local_key(TODO_RECURSE_NEXT_OBJ)'"/>
                </xsl:element>
                <xsl:element name="column_PARENT_ID">
                    <xsl:attribute name="sso_procesy5:evaluate_key_value" select="@retrieve_ID"/>
                </xsl:element>
                <xsl:element name="column_CACHE_INSTANCE_ID">
                    <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                </xsl:element>
                <xsl:element name="column_VALUE"/>
                <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                    <xsl:sort select="position()" data-type="number" order="descending"/> 
                    <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                    <xsl:element name="columns_CACHE_INSTANCE">
                        <xsl:element name="COLUMN_NAME">
                            <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                            <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                        </xsl:element>
                        <xsl:element name="COLUMN_VALUE">
                            <xsl:choose>
                                <xsl:when test="@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                    <xsl:value-of select="true()"/>
                                </xsl:when>
                                <xsl:otherwise>
                                    <xsl:value-of select="'derived'"/>
                                </xsl:otherwise>
                            </xsl:choose>
                        </xsl:element>
                    </xsl:element>
                </xsl:for-each>
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                </xsl:apply-templates>
            </xsl:element>
        
    </xsl:template>
    <xsl:template match="p5_tr_map:go_recurse_from_root_by_build_element_4777" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>
        <!-- 734: ref do czegos z tabeli plaskiej  ; 477 to samo - raczej nie - @2016-01-20 tutaj musimy opisac metode synchronizacji i dostepu do danych plaskich dalej - bo to jest sztuczny @ref i go nie ma - tylko jest spiecie po instancjach!  -->
            <xsl:element name="sso_procesy5:structure_sync_table_default_db">
                <xsl:attribute name="table_name" select="@local-name-name"/>
                <!--<xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>-->
                <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                <!--<xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>-->
                <!--jedziemy ze schematu i tworzymy tabele plaska-->
                <!--<test><xsl:copy-of select="system_cache__appinfo:schema"/></test>-->
                <!--<xsl:variable name="go_recurse_from_root_by_build_element">
                    <xsl:choose>
                        <xsl:when test="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name='element'" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport">
                            <xsl:call-template name="p5_tr_map:go_recurse_from_root_by_build_element_cache">
                                <xsl:with-param name="parent_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"/> <!-\-test_objects:A_OBSZAR default_accounting:supplier_client_account_balance default_corespondence:document_position_offer default_default_objects_types:PUNKT_MAGISTRALNY default_default_objects_types:PUNKT_DYSTRYBUCYJNY default_default_objects_types:default_default_objects_types___d20e497 default_default_objects_types:MAGAZYN  default_companies:Company -\->
                                <xsl:with-param name="cache" select="'read'"/>
                            </xsl:call-template>        
                        </xsl:when>
                        <xsl:when test="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name='complexType'" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport">
                            <xsl:call-template name="p5_tr_map:go_recurse_from_root_by_build_complexType_cache">
                                <xsl:with-param name="parent_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"/> <!-\-test_objects:A_OBSZAR default_accounting:supplier_client_account_balance default_corespondence:document_position_offer default_default_objects_types:PUNKT_MAGISTRALNY default_default_objects_types:PUNKT_DYSTRYBUCYJNY default_default_objects_types:default_default_objects_types___d20e497 default_default_objects_types:MAGAZYN  default_companies:Company -\->
                                <xsl:with-param name="cache" select="'read'"/>
                            </xsl:call-template>
                        </xsl:when>
                        <xsl:otherwise><xsl:message terminate="yes">#1570 element should be or ComplexType or element only! at p5_tr_map:uuid=<xsl:value-of select="@p5_tr_map:uuid"/>; @name=<xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>; $system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name=<xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/>;</xsl:message></xsl:otherwise>
                    </xsl:choose>
                </xsl:variable>-->
                <!--<xsl:variable name="form_element_name_4777">
                    <!-\-<xsl:call-template name="p5_obj_vars:create_key_value_path">
                        <xsl:with-param name="transaction_id" select="$transaction_id"/>
                        <xsl:with-param name="go_recurse_from_root_by_build_element" select="$go_recurse_from_root_by_build_element"/>
                        <xsl:with-param name="p5_obj_vars:key_value" select="system_cache__appinfo:create_form_element_id($transaction_id,concat(system_cache__appinfo:translate_object_escaped_prefix_from_string(@system_cache__appinfo:id),'-',$go_recurse_from_root_by_build_element/p5_tr_map:go_recurse_from_root_by_build_element/@p5_tr_map:uuid),1)"/>
                    </xsl:call-template>-\->
                    <xsl:apply-templates mode="sso_procesy5:create_key_value_path" select="$go_recurse_from_root_by_build_element">
                        <xsl:with-param name="transaction_id" select="$transaction_id"/>
                        <xsl:with-param name="p5_tr_map:uuid" select="'d15864e386'"/>
                        <xsl:with-param name="p5_obj_vars:key_value" select="system_cache__appinfo:create_form_element_id($transaction_id,concat(system_cache__appinfo:translate_object_escaped_prefix_from_string(@system_cache__appinfo:id),'-',$go_recurse_from_root_by_build_element/p5_tr_map:go_recurse_from_root_by_build_element/@p5_tr_map:uuid),1)"/>
                    </xsl:apply-templates>
                </xsl:variable>-->
                <!--<form_element_name_4777>
                    <xsl:copy-of select="$form_element_name_4777"/>
                </form_element_name_4777>-->
                <!--<go_recurse_from_root_by_build_element><xsl:copy-of select="$go_recurse_from_root_by_build_element"></xsl:copy-of></go_recurse_from_root_by_build_element>-->
                <!--<test_detect><xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/name()" /></test_detect>-->
                <xsl:for-each select="system_cache__appinfo:schema/element/element/complexType/sequence/element" xpath-default-namespace="http://www.w3.org/2001/XMLSchema">
                    <xsl:variable name="flat_el_1543" select="current()"/>
                    <xsl:choose>
                        <xsl:when test="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__appinfo:detect_local-elements_relations_references_with_flat_procesy5_table_list/system_cache__appinfo:detect_local-elements_relations_references_with_flat_procesy5_table/system_cache__appinfo:flat_element-to-object_element[@system_cache__appinfo:flat_element=$flat_el_1543/@name]">
                            <xsl:element name="columns_FLAT_ELEMENT_4777">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:choose>
                                        <xsl:when test="@name='ID'">
                                            <!--<xsl:variable name="p5_obj_vars:create_key_value_root_instance_by_4777_path">
                                                <xsl:apply-templates mode="sso_procesy5:create_key_value_root_instance_by_4777_path" select="$go_recurse_from_root_by_build_element">
                                                        <xsl:with-param name="transaction_id" select="$transaction_id"/>
                                                        <xsl:with-param name="p5_tr_map:uuid" select="$detect_resource_type_102/@p5_tr_map:uuid"/>
                                                    </xsl:apply-templates>
                                            </xsl:variable>-->
                                            <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#no need because it is just sync method'"/>
                                            <!--<xsl:attribute name="sso_procesy5:detect_evaluate_key_value_root_instance" select="$p5_obj_vars:evaluate_key_value_root_instance//"/>-->
                                            <!--<p5_obj_vars:create_key_value_root_instance_by_4777_path>
                                                <xsl:attribute name="p5_tr_map:uuid" select="$detect_resource_type_102/@p5_tr_map:uuid"></xsl:attribute>
                                                <xsl:copy-of select="$p5_obj_vars:create_key_value_root_instance_by_4777_path"/></p5_obj_vars:create_key_value_root_instance_by_4777_path>-->
                                        </xsl:when>
                                    </xsl:choose>
                                    <xsl:value-of select="@name"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:attribute name="p5_tr_map:uuid" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__appinfo:detect_local-elements_relations_references_with_flat_procesy5_table_list/system_cache__appinfo:detect_local-elements_relations_references_with_flat_procesy5_table/system_cache__appinfo:flat_element-to-object_element[@system_cache__appinfo:flat_element=$flat_el_1543/@name][1]/@p5_tr_map:uuid"/>
                                    <!--<xsl:apply-templates mode="sso_procesy5:create_key_value_path" select="$go_recurse_from_root_by_build_element">
                                        <xsl:with-param name="transaction_id" select="$transaction_id"/>
                                        <xsl:with-param name="p5_tr_map:uuid" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__appinfo:detect_local-elements_relations_references_with_flat_procesy5_table_list/system_cache__appinfo:detect_local-elements_relations_references_with_flat_procesy5_table/system_cache__appinfo:flat_element-to-object_element[@system_cache__appinfo:flat_element=$flat_el_1543/@name][1]/@p5_tr_map:uuid"/>
                                    </xsl:apply-templates>-->
                                </xsl:element>
                            </xsl:element>
                        </xsl:when>
                    </xsl:choose>
                </xsl:for-each>
                <!--<xsl:element name="column_ELEMENT_ID">
                    <xsl:attribute name="sso_procesy5:read_key_value" select="'#new_local_key(TODO_RECURSE_NEXT_OBJ)'"/>
                </xsl:element>
                <xsl:element name="column_PARENT_ID">
                    <xsl:attribute name="sso_procesy5:evaluate_key_value" select="@retrieve_ID"/>
                </xsl:element>
                <xsl:element name="column_REMOTE_ID">
                    <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#SOME_INSTANCE_ID_OF_REFERED_OBJET(TODO_EXACT_ONE_IN_CONTEXT)'"/>
                </xsl:element>
                <xsl:element name="column_CACHE_INSTANCE_ID">
                    <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                </xsl:element>
                <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                    <xsl:sort select="position()" data-type="number" order="descending"/> 
                    <!-\-<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-\->
                    <xsl:element name="columns_CACHE_INSTANCE">
                        <xsl:element name="COLUMN_NAME">
                            <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                            <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                        </xsl:element>
                        <xsl:element name="COLUMN_VALUE">
                            <xsl:choose>
                                <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                    <xsl:value-of select="true()"/>
                                </xsl:when>
                                <xsl:otherwise>
                                    <xsl:value-of select="'derived'"/>
                                </xsl:otherwise>
                            </xsl:choose>
                        </xsl:element>
                    </xsl:element>
                </xsl:for-each>-->
            </xsl:element>    
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_477|go_recurse_from_root_by_build_element_477b|go_recurse_from_root_by_build_element_4771" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>
        <!-- 734: ref do czegos z tabeli plaskiej  ; 477 to samo  -->
            <xsl:element name="sso_procesy5:structure_477_info">
                <xsl:attribute name="comment" select="concat('wezel przetwarzany po przetworzeniu pierwszej instancji 481. p5_tr_map:uuid=',@p5_tr_map:uuid,'; system_cache__appinfo:id=',@system_cache__appinfo:id,';')"/>
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="moved_after_node_to_apply" select="$detect_resource_type_102"/>
                    <xsl:with-param name="moved_after_node_to_apply_detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                </xsl:apply-templates>
            </xsl:element>
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_434|go_recurse_from_root_by_build_element_434c|go_recurse_from_root_by_build_element_434b|go_recurse_from_root_by_build_element_434d|go_recurse_from_root_by_build_element_434r|go_recurse_from_root_by_build_element_434n" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>
            <xsl:element name="sso_procesy5:structure_434_info">
                <xsl:for-each select="@*"><xsl:attribute name="{name()}" select="."/></xsl:for-each>
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="moved_after_node_to_apply" select="$moved_after_node_to_apply"/>
                    <xsl:with-param name="moved_after_node_to_apply_detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                </xsl:apply-templates>
            </xsl:element>
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_394|go_recurse_from_root_by_build_element_3940" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>                
            <!--<xsl:comment>1572: tworzymy tabele instancyjna + wartosc dla simpleContent z cachem wszystkich mozliwch dziedziczen w dol dla analizowanego obiektu</xsl:comment>-->
            <xsl:element name="sso_procesy5:structure_table_root_instance_with_value">
                <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                <xsl:element name="column_ELEMENT_ID">
                    <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                </xsl:element>
                <xsl:element name="column_ELEMENT_NAME">
                    <xsl:element name="COLUMN_VALUE">
                        <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                    </xsl:element>
                </xsl:element>
                <xsl:element name="column_VALUE"/>
                <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']" ><!--  objects_derivations_list/p5_tr_map:derivations-->
                    <xsl:sort select="position()" data-type="number" order="descending"/> 
                    <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                    <xsl:element name="columns_CACHE_INSTANCE">
                        <xsl:element name="COLUMN_NAME">
                            <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                            <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                        </xsl:element>
                        <xsl:element name="COLUMN_VALUE">
                            <xsl:choose>
                                <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                    <xsl:value-of select="true()"/>
                                </xsl:when>
                                <xsl:when test="@system_cache__resources_tree_generate_xsl_required_occurs_raport:derived_appropriate='true'"><xsl:value-of select="'derived'"/></xsl:when>
                                <xsl:when test="@system_cache__resources_tree_generate_xsl_required_occurs_raport:derived_appropriate='false'"><xsl:value-of select="false()"/></xsl:when>
                                <xsl:otherwise>
                                    <xsl:value-of select="'derived'"/>
                                </xsl:otherwise>
                            </xsl:choose>
                        </xsl:element>
                    </xsl:element>
                </xsl:for-each>
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                </xsl:apply-templates>
            </xsl:element>
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_3941|go_recurse_from_root_by_build_element_3942" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>                
            <!--<xsl:comment>1620: tworzymy tabele instancyjna dziecka gdize root ma value dla simpleContent z cachem wszystkich mozliwch dziedziczen w dol dla analizowanego obiektu</xsl:comment>-->
            <xsl:element name="sso_procesy5:structure_table_child_instance_with_value">
                <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                <xsl:element name="column_ELEMENT_ID">
                    <xsl:element name="COLUMN_VALUE">
                        <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                    </xsl:element>
                </xsl:element>
                <xsl:element name="column_ELEMENT_NAME">
                    <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                </xsl:element>
                <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                    <xsl:sort select="position()" data-type="number" order="descending"/> 
                    <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                    <xsl:element name="columns_CACHE_INSTANCE">
                        <xsl:element name="COLUMN_NAME">
                            <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                            <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                        </xsl:element>
                        <xsl:element name="COLUMN_VALUE">
                            <xsl:choose>
                                <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                    <xsl:value-of select="true()"/>
                                </xsl:when>
                                <xsl:otherwise>
                                    <xsl:value-of select="'derived'"/>
                                </xsl:otherwise>
                            </xsl:choose>
                        </xsl:element>
                    </xsl:element>
                </xsl:for-each>
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                </xsl:apply-templates>
            </xsl:element>
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_459" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>                
            <!--<xsl:comment>92: tworzymy tabele instancyjna z wartoscia, bez mozliwosci dziedziczen dla simpleContent - moze tu dojsc tylko atrybut</xsl:comment>-->
            <xsl:element name="sso_procesy5:structure_table_root_instance_with_value">
                <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                <!--<xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>-->
                <!--<xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>-->
                <!--<xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>-->
                <!--<xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>-->
                <xsl:element name="column_ELEMENT_ID">
                    <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                </xsl:element>
                <xsl:element name="column_VALUE"/>
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                </xsl:apply-templates>
            </xsl:element>
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_459b" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:variable name="detect_resource_type_102" select="current()"/>                
            <!-- typ kolejnej instancji simpleContent (instancja+wartosc) wywolanej z @refa, wymagajacej ponownej analizy dziedziczen oraz wpisania rekordu @ref  -->
            <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type">
                <xsl:message>#1577: sso will call system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml name_with_prefix: name_with_prefix:<xsl:value-of select="concat(@system_cache__appinfo:prefix,':',@local-name-name)"/></xsl:message>
                <xsl:call-template name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml">
                    <xsl:with-param name="name_with_prefix" select="concat(@system_cache__appinfo:prefix,':',@local-name-name)"></xsl:with-param>
                    <xsl:with-param name="local-name" select="'element'"/>
                    <xsl:with-param name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                </xsl:call-template>
            </xsl:variable>
            <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
            <xsl:element name="sso_procesy5:structure_table_root_instance_with_value">
                <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                <!--<xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>-->
                <!--<xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>-->
                <!--<xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                            <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>-->
                <xsl:element name="column_ELEMENT_ID">
                    <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                </xsl:element>
                <xsl:element name="column_VALUE"/>
                <xsl:if test="$moved_after_node_to_apply">
                    <xsl:apply-templates mode="sso_procesy5:moved_after_node_to_apply" select="$moved_after_node_to_apply">
                        <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$moved_after_node_to_apply_detect_resource_type"/>
                        <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    </xsl:apply-templates>
                </xsl:if>
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                </xsl:apply-templates>
            </xsl:element>
        
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_481" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>                
            <!-- typ kolejnej instancji wywolanej z @refa, wymagajacej ponownej analizy dziedziczen oraz wpisania rekordu @ref  -->
            <!--<xsl:comment>92: tworzymy tabele instancyjna z cachem wszystkich mozliwch dziedziczen w dol dla analizowanego obiektu</xsl:comment>-->
            <!--<xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type2">
                    <xsl:copy-of select="document(concat('../default_db.instance.xml/detect_resource_type/',system_cache__appinfo:escape_object_prefix_to_string(concat(@system_cache__appinfo:prefix,':',@parent_name)),'.xml'))/system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations"/>
                </xsl:variable>-->
            <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type">
                <xsl:choose>
                    <xsl:when test="@p5_tr_map:parent_type">
                        <xsl:message>#1499: sso will call system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml name_with_prefix: name_with_prefix:<xsl:value-of select="@p5_tr_map:parent_type"/></xsl:message>
                        <xsl:call-template name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml">
                            <xsl:with-param name="name_with_prefix" select="@p5_tr_map:parent_type"></xsl:with-param>
                            <xsl:with-param name="local-name" select="'complexType'"/>
                            <xsl:with-param name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        </xsl:call-template>
                    </xsl:when>
                    <xsl:when test="@parent_name">
                        <xsl:message>#1512: sso will call system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml name_with_prefix: name_with_prefix:<xsl:value-of select="concat(@system_cache__appinfo:prefix,':',@parent_name)"/></xsl:message>
                        <xsl:call-template name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml">
                            <xsl:with-param name="name_with_prefix" select="concat(@system_cache__appinfo:prefix,':',@parent_name)"></xsl:with-param>
                            <xsl:with-param name="local-name" select="'element'"/>
                            <xsl:with-param name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        </xsl:call-template>
                    </xsl:when>
                    <xsl:otherwise><xsl:message terminate="yes">#1621 error - sould be or parent_name after 477 or @p5_tr_map:parent_type after 477b !</xsl:message></xsl:otherwise>
                </xsl:choose>
            </xsl:variable>
            <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
            <xsl:choose>
                <xsl:when test="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_id=@system_cache__appinfo:id">
                    <xsl:element name="sso_procesy5:structure_table_root_instance">
                        <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                        <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                        <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                        <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                        <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                        <xsl:element name="column_ELEMENT_ID">
                            <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                        </xsl:element>
                        <xsl:element name="column_ELEMENT_NAME">
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                            </xsl:element>
                        </xsl:element>
                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                            <xsl:sort select="position()" data-type="number" order="descending"/> 
                            <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                            <xsl:element name="columns_CACHE_INSTANCE">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                    <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                                    <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <!--<test_TODO626>
                                            <xsl:attribute name="dolar_det_res_type__na_appinfo_id" select="$detect_resource_type_102/@system_cache__appinfo:id"/>
                                            <xsl:attribute name="appinfo_id" select="@system_cache__appinfo:id"/>
                                            <xsl:attribute name="p5_tr_map:object_type_id__from_detect" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/node()/@p5_tr_map:object_type_id"/>
                                            <system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                                <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"></xsl:copy-of>
                                            </system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                        </test_TODO626>-->
                                    <xsl:choose>
                                        <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                            <xsl:value-of select="true()"/>
                                        </xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="'derived'"/>
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:element>
                            </xsl:element>
                        </xsl:for-each>
                        <xsl:if test="$moved_after_node_to_apply">
                            <xsl:apply-templates mode="sso_procesy5:moved_after_node_to_apply" select="$moved_after_node_to_apply">
                                <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$moved_after_node_to_apply_detect_resource_type"/>
                                <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            </xsl:apply-templates>
                        </xsl:if>
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                        </xsl:apply-templates>
                    </xsl:element>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:element name="sso_procesy5:structure_table_child_instance">
                        <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                        <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                        <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                        <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                        <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                        <xsl:element name="column_ELEMENT_ID">
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                                <!--<test_TODO659>
                                        <xsl:attribute name="dolar_det_res_type__na_appinfo_id" select="$detect_resource_type_102/@system_cache__appinfo:id"/>
                                        <xsl:attribute name="appinfo_id" select="@system_cache__appinfo:id"/>
                                        <xsl:attribute name="sys_cach_res_tree__na__obj_type_id" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id"/>
                                        <system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                            <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"></xsl:copy-of>
                                        </system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                    </test_TODO659>-->
                            </xsl:element>
                        </xsl:element>
                        <xsl:element name="column_ELEMENT_NAME">
                            <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                        </xsl:element>
                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                            <xsl:sort select="position()" data-type="number" order="descending"/> 
                            <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                            <xsl:element name="columns_CACHE_INSTANCE">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                    <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                                    <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:choose>
                                        <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                            <xsl:value-of select="true()"/>
                                        </xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="'derived'"/>
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:element>
                            </xsl:element>
                        </xsl:for-each>
                        <xsl:if test="$moved_after_node_to_apply">
                            <xsl:apply-templates mode="sso_procesy5:moved_after_node_to_apply" select="$moved_after_node_to_apply">
                                <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                                <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            </xsl:apply-templates>
                        </xsl:if>
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                        </xsl:apply-templates>
                    </xsl:element>
                </xsl:otherwise>
            </xsl:choose>
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_4812" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>  
            <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type">
                <xsl:choose>
                    <xsl:when test="@p5_tr_map:parent_type">
                        <xsl:message>#1617a: sso will call system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml name_with_prefix: name_with_prefix:<xsl:value-of select="@p5_tr_map:parent_type"/></xsl:message>
                        <xsl:call-template name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml">
                            <xsl:with-param name="name_with_prefix" select="@p5_tr_map:parent_type"></xsl:with-param>
                            <xsl:with-param name="local-name" select="'complexType'"/>
                            <xsl:with-param name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        </xsl:call-template>
                    </xsl:when>
                    <xsl:when test="@parent_name">
                        <xsl:message>#1617b: sso will call system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml name_with_prefix: name_with_prefix:<xsl:value-of select="concat(@system_cache__appinfo:prefix,':',@parent_name)"/></xsl:message>
                        <xsl:call-template name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_objects_parent_relations_single_element_from_xml">
                            <xsl:with-param name="name_with_prefix" select="concat(@system_cache__appinfo:prefix,':',@parent_name)"></xsl:with-param>
                            <xsl:with-param name="local-name" select="'element'"/>
                            <xsl:with-param name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        </xsl:call-template>
                    </xsl:when>
                    <xsl:otherwise><xsl:message terminate="yes">#1621 error - sould be or parent_name after 477 or @p5_tr_map:parent_type after 477b !</xsl:message></xsl:otherwise>
                </xsl:choose>
            </xsl:variable>
            <xsl:variable name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
            <xsl:choose>
                <!--<xsl:when test="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_id=@system_cache__appinfo:id">
                        <xsl:element name="sso_procesy5:structure_table_root_instance">
                            <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                            <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                            <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                            <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                            <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                            <xsl:element name="column_ELEMENT_ID">
                                <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                            </xsl:element>
                            <xsl:element name="column_ELEMENT_NAME">
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                                </xsl:element>
                            </xsl:element>
                            <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/objects_derivations_list/p5_tr_map:derivations" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
                                <xsl:sort select="position()" data-type="number" order="descending"/> 
                                <!-\-<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-\->
                                <xsl:element name="columns_CACHE_INSTANCE">
                                    <xsl:element name="COLUMN_NAME">
                                        <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                        <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                    </xsl:element>
                                    <xsl:element name="COLUMN_VALUE">
                                        <!-\-<test_TODO626>
                                            <xsl:attribute name="dolar_det_res_type__na_appinfo_id" select="$detect_resource_type_102/@system_cache__appinfo:id"/>
                                            <xsl:attribute name="appinfo_id" select="@system_cache__appinfo:id"/>
                                            <xsl:attribute name="p5_tr_map:object_type_id__from_detect" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/node()/@p5_tr_map:object_type_id"/>
                                            <system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                                <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"></xsl:copy-of>
                                            </system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                        </test_TODO626>-\->
                                        <xsl:choose>
                                            <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                                <xsl:value-of select="true()"/>
                                            </xsl:when>
                                            <xsl:otherwise>
                                                <xsl:value-of select="'derived'"/>
                                            </xsl:otherwise>
                                        </xsl:choose>
                                    </xsl:element>
                                </xsl:element>
                            </xsl:for-each>
                            <!-\-<xsl:if test="$moved_after_node_to_apply">
                                <xsl:apply-templates mode="sso_procesy5:moved_after_node_to_apply" select="$moved_after_node_to_apply">
                                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$moved_after_node_to_apply_detect_resource_type"/>
                                </xsl:apply-templates>
                            </xsl:if>-\->
                            <xsl:apply-templates mode="#current">
                                <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                                <xsl:with-param name="moved_after_node_to_apply" select="$moved_after_node_to_apply"/>
                            </xsl:apply-templates>
                        </xsl:element>
                    </xsl:when>-->
                <xsl:when test="1=2"/>
                <xsl:otherwise>
                    <xsl:element name="sso_procesy5:structure_table_child_instance">
                        <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                        <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                        <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                        <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                        <xsl:element name="column_ELEMENT_ID">
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                                <!--<test_TODO659>
                                        <xsl:attribute name="dolar_det_res_type__na_appinfo_id" select="$detect_resource_type_102/@system_cache__appinfo:id"/>
                                        <xsl:attribute name="appinfo_id" select="@system_cache__appinfo:id"/>
                                        <xsl:attribute name="sys_cach_res_tree__na__obj_type_id" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id"/>
                                        <system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                            <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"></xsl:copy-of>
                                        </system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                    </test_TODO659>-->
                            </xsl:element>
                        </xsl:element>
                        <xsl:element name="column_ELEMENT_NAME">
                            <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                        </xsl:element>
                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                            <xsl:sort select="position()" data-type="number" order="descending"/> 
                            <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                            <xsl:element name="columns_CACHE_INSTANCE">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                    <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                                    <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:choose>
                                        <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                            <xsl:value-of select="true()"/>
                                        </xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="'derived'"/>
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:element>
                            </xsl:element>
                        </xsl:for-each>
                        <!--<xsl:if test="$moved_after_node_to_apply">
                                <xsl:apply-templates mode="sso_procesy5:moved_after_node_to_apply" select="$moved_after_node_to_apply">
                                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                                </xsl:apply-templates>
                            </xsl:if>-->
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                            <xsl:with-param name="moved_after_node_to_apply_detect_resource_type" select="$moved_after_node_to_apply_detect_resource_type"/>
                            <xsl:with-param name="moved_after_node_to_apply" select="$moved_after_node_to_apply"/>
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                        </xsl:apply-templates>
                    </xsl:element>
                </xsl:otherwise>
            </xsl:choose>
        
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_4811" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>                
            <xsl:choose>
                <!--<xsl:when test="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_id=@system_cache__appinfo:id">
                        <xsl:element name="sso_procesy5:structure_table_root_instance">
                            <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                            <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                            <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                            <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                            <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                            <xsl:element name="column_ELEMENT_ID">
                                <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                            </xsl:element>
                            <xsl:element name="column_ELEMENT_NAME">
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                                </xsl:element>
                            </xsl:element>
                            <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/objects_derivations_list/p5_tr_map:derivations" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
                                <xsl:sort select="position()" data-type="number" order="descending"/> 
                                <!-\-<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-\->
                                <xsl:element name="columns_CACHE_INSTANCE">
                                    <xsl:element name="COLUMN_NAME">
                                        <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                        <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                    </xsl:element>
                                    <xsl:element name="COLUMN_VALUE">
                                        <!-\-<test_TODO626>
                                            <xsl:attribute name="dolar_det_res_type__na_appinfo_id" select="$detect_resource_type_102/@system_cache__appinfo:id"/>
                                            <xsl:attribute name="appinfo_id" select="@system_cache__appinfo:id"/>
                                            <xsl:attribute name="p5_tr_map:object_type_id__from_detect" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/node()/@p5_tr_map:object_type_id"/>
                                            <system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                                <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"></xsl:copy-of>
                                            </system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                        </test_TODO626>-\->
                                        <xsl:choose>
                                            <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                                <xsl:value-of select="true()"/>
                                            </xsl:when>
                                            <xsl:otherwise>
                                                <xsl:value-of select="'derived'"/>
                                            </xsl:otherwise>
                                        </xsl:choose>
                                    </xsl:element>
                                </xsl:element>
                            </xsl:for-each>
                            <!-\-<xsl:if test="$moved_after_node_to_apply">
                                <xsl:apply-templates mode="sso_procesy5:moved_after_node_to_apply" select="$moved_after_node_to_apply">
                                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$moved_after_node_to_apply_detect_resource_type"/>
                                </xsl:apply-templates>
                            </xsl:if>-\->
                            <xsl:apply-templates mode="#current">
                                <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                                <xsl:with-param name="moved_after_node_to_apply" select="$moved_after_node_to_apply"/>
                            </xsl:apply-templates>
                        </xsl:element>
                    </xsl:when>-->
                <xsl:when test="1=2"/>
                <xsl:otherwise>
                    <xsl:element name="sso_procesy5:structure_table_child_instance">
                        <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                        <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                        <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                        <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                        <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                        <xsl:element name="column_ELEMENT_ID">
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                                <!--<test_TODO659>
                                        <xsl:attribute name="dolar_det_res_type__na_appinfo_id" select="$detect_resource_type_102/@system_cache__appinfo:id"/>
                                        <xsl:attribute name="appinfo_id" select="@system_cache__appinfo:id"/>
                                        <xsl:attribute name="sys_cach_res_tree__na__obj_type_id" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id"/>
                                        <system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                            <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"></xsl:copy-of>
                                        </system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                    </test_TODO659>-->
                            </xsl:element>
                        </xsl:element>
                        <xsl:element name="column_ELEMENT_NAME">
                            <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                        </xsl:element>
                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                            <xsl:sort select="position()" data-type="number" order="descending"/> 
                            <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                            <xsl:element name="columns_CACHE_INSTANCE">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                    <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                                    <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:choose>
                                        <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                            <xsl:value-of select="true()"/>
                                        </xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="'derived'"/>
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:element>
                            </xsl:element>
                        </xsl:for-each>
                        <!--<xsl:if test="$moved_after_node_to_apply">
                                <xsl:apply-templates mode="sso_procesy5:moved_after_node_to_apply" select="$moved_after_node_to_apply">
                                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                                </xsl:apply-templates>
                            </xsl:if>-->
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                            <xsl:with-param name="moved_after_node_to_apply_detect_resource_type" select="$moved_after_node_to_apply_detect_resource_type"/>
                            <xsl:with-param name="moved_after_node_to_apply" select="$moved_after_node_to_apply"/>
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                        </xsl:apply-templates>
                    </xsl:element>
                </xsl:otherwise>
            </xsl:choose>
        
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_4810" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>
            <xsl:choose>
                <xsl:when test="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_id=@system_cache__appinfo:id">
                    <xsl:element name="sso_procesy5:structure_table_root_instance">
                        <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                        <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                        <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                        <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                        <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                        <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                        <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                        <xsl:element name="column_ELEMENT_ID">
                            <xsl:attribute name="sso_procesy5:read_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                        </xsl:element>
                        <xsl:element name="column_ELEMENT_NAME">
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                            </xsl:element>
                        </xsl:element>
                        <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list/system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings/system_cache__appinfo:parent_complexType/system_cache__appinfo:parent_complexType_child[@local-name='complexType']">
                            <xsl:sort select="position()" data-type="number" order="descending"/> 
                            <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                            <xsl:element name="columns_CACHE_INSTANCE">
                                <xsl:element name="COLUMN_NAME">
                                    <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                    <xsl:attribute name="p5_tr_map:name_with_pref" select="@p5_tr_map:name_with_pref"/>
                                    <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                </xsl:element>
                                <xsl:element name="COLUMN_VALUE">
                                    <!--<test_TODO626>
                                            <xsl:attribute name="dolar_det_res_type__na_appinfo_id" select="$detect_resource_type_102/@system_cache__appinfo:id"/>
                                            <xsl:attribute name="appinfo_id" select="@system_cache__appinfo:id"/>
                                            <xsl:attribute name="p5_tr_map:object_type_id__from_detect" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/node()/@p5_tr_map:object_type_id"/>
                                            <system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                                <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"></xsl:copy-of>
                                            </system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                        </test_TODO626>-->
                                    <xsl:choose>
                                        <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                            <xsl:value-of select="true()"/>
                                        </xsl:when>
                                        <xsl:otherwise>
                                            <xsl:value-of select="'derived'"/>
                                        </xsl:otherwise>
                                    </xsl:choose>
                                </xsl:element>
                            </xsl:element>
                        </xsl:for-each>
                        <xsl:if test="$moved_after_node_to_apply">
                            <xsl:apply-templates mode="sso_procesy5:moved_after_node_to_apply" select="$moved_after_node_to_apply">
                                <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$moved_after_node_to_apply_detect_resource_type"/>
                                <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            </xsl:apply-templates>
                        </xsl:if>
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                            <!--<xsl:with-param name="moved_after_node_to_apply" select="$moved_after_node_to_apply"/>-->
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
                        </xsl:apply-templates>
                    </xsl:element>
                </xsl:when>
                <xsl:when test="1=2"/>
                <xsl:otherwise><xsl:message terminate="yes">1615 ERROR it should be parent type. Tested: $system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_id:<xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_id"/>!=<xsl:value-of select="@system_cache__appinfo:id"/>;</xsl:message></xsl:otherwise>
                <!--<xsl:otherwise>
                        <xsl:element name="sso_procesy5:structure_table_child_instance">
                            <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                            <xsl:attribute name="retrieve_ID" select="@retrieve_ID"/>
                            <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                            <xsl:attribute name="retrieve_TYPE" select="@retrieve_TYPE"/>
                            <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                            <xsl:attribute name="p5_tr_map:parent_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:parent_name_with_pref"/>
                            <xsl:element name="column_ELEMENT_ID">
                                <xsl:element name="COLUMN_VALUE">
                                    <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                                    <!-\-<test_TODO659>
                                        <xsl:attribute name="dolar_det_res_type__na_appinfo_id" select="$detect_resource_type_102/@system_cache__appinfo:id"/>
                                        <xsl:attribute name="appinfo_id" select="@system_cache__appinfo:id"/>
                                        <xsl:attribute name="sys_cach_res_tree__na__obj_type_id" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id"/>
                                        <system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                            <xsl:copy-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"></xsl:copy-of>
                                        </system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type>
                                    </test_TODO659>-\->
                                </xsl:element>
                            </xsl:element>
                            <xsl:element name="column_ELEMENT_NAME">
                                <xsl:value-of select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@name"/>
                            </xsl:element>
                            <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/objects_derivations_list/p5_tr_map:derivations" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
                                <xsl:sort select="position()" data-type="number" order="descending"/> 
                                <!-\-<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-\->
                                <xsl:element name="columns_CACHE_INSTANCE">
                                    <xsl:element name="COLUMN_NAME">
                                        <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                        <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                                    </xsl:element>
                                    <xsl:element name="COLUMN_VALUE">
                                        <xsl:choose>
                                            <xsl:when test="$detect_resource_type_102/@system_cache__appinfo:id=@system_cache__appinfo:id and $detect_resource_type_102/@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                                <xsl:value-of select="true()"/>
                                            </xsl:when>
                                            <xsl:otherwise>
                                                <xsl:value-of select="'derived'"/>
                                            </xsl:otherwise>
                                        </xsl:choose>
                                    </xsl:element>
                                </xsl:element>
                            </xsl:for-each>
                            <!-\-<xsl:if test="$moved_after_node_to_apply">
                                <xsl:apply-templates mode="sso_procesy5:moved_after_node_to_apply" select="$moved_after_node_to_apply">
                                    <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                                </xsl:apply-templates>
                            </xsl:if>-\->
                            <xsl:apply-templates mode="#current">
                                <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
                                <xsl:with-param name="moved_after_node_to_apply" select="$moved_after_node_to_apply"/>
                            </xsl:apply-templates>
                        </xsl:element>
                    </xsl:otherwise>-->
            </xsl:choose>
    </xsl:template>
    
    
    <xsl:template match="go_recurse_from_root_by_build_element" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" required="yes"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>
        <xsl:apply-templates mode="#current">
            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type"/>
            <xsl:with-param name="transaction_id" select="$transaction_id"/>
            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
            <xsl:with-param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:local-name"/><!-- do przekazywania dalej - jaki byl obiekt poczatkowy wyzwalany root -->
        </xsl:apply-templates>
    </xsl:template>
    
    <xsl:template match="*" mode="sso_procesy5:create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="objects_derivations_list_same_id"/> <!-- wraz z kazdym uzyciem instancji element wypada - aby uzyc tego samego ID w instancjach tego obiektu  -->
        <xsl:param name="moved_after_node_to_apply"/> <!-- w przypadku @event_type=477 tu jest zapisany detect_resource_type_102 -->
        <xsl:param name="moved_after_node_to_apply_detect_resource_type"/>  <!-- w przypadku @event_type=477 tu jest zapisany system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type aby wlasciwe instance_cache odtworzyc -->
        <xsl:variable name="detect_resource_type_102" select="current()"/>
                <xsl:element name="ERROR_ELSE">
                    <xsl:for-each select="@*">
                        <xsl:attribute name="{name()}" select="."/>
                    </xsl:for-each>
                    <xsl:message terminate="yes">#1987 unknown @event_type:<xsl:value-of select="@event_type"/>; for @system_cache__appinfo:id:<xsl:value-of select="@system_cache__appinfo:id"/>; </xsl:message>
                    <!--<xsl:copy-of select="."/>-->
                </xsl:element>
    </xsl:template>
    
    
    <!-- w przypadku @event_type=477 apply template jest uruchamiany z tym parametrem aby przetworzyc wstawienie refa bez daleszego przetwarzania -->
    
    <xsl:template match="go_recurse_from_root_by_build_element_477|go_recurse_from_root_by_build_element_477b" mode="sso_procesy5:moved_after_node_to_apply" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:param name="transaction_id"/>
        <xsl:variable name="detect_resource_type_102" select="current()"/>
                <xsl:element name="sso_procesy5:structure_table_reference">
                    <xsl:attribute name="table_name" select="@system_cache__appinfo:id"/>
                    <xsl:attribute name="table_cache_type_name" select="@system_cache__appinfo:id"/>
                    <xsl:attribute name="p5_tr_map:uuid" select="@p5_tr_map:uuid"/>
                    <xsl:attribute name="retrieve_PARENT_ID" select="@retrieve_PARENT_ID"/>
                    <xsl:attribute name="retrieve_REMOTE_ID" select="@retrieve_REMOTE_ID"/>
                    <xsl:attribute name="p5_tr_map:object_type_name_with_pref" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_name_with_pref"/>
                    <xsl:attribute name="p5_tr_map:object_type_id" select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id"/>
                    <xsl:element name="column_ELEMENT_ID">
                        <xsl:attribute name="sso_procesy5:read_key_value" select="'#new_local_key(TODO_RECURSE_NEXT_OBJ)'"/>
                    </xsl:element>
                    <xsl:element name="column_PARENT_ID">
                        <xsl:attribute name="sso_procesy5:evaluate_key_value" select="@retrieve_PARENT_ID"/>
                    </xsl:element>
                    <xsl:element name="column_REMOTE_ID">
                        <xsl:attribute name="sso_procesy5:evaluate_key_value_remote" select="'#SOME_INSTANCE_ID_OF_REFERED_OBJET(TODO_EXACT_ONE_IN_CONTEXT)'"/>
                    </xsl:element>
                    <xsl:element name="column_CACHE_INSTANCE_ID">
                        <xsl:attribute name="sso_procesy5:evaluate_key_value" select="'#NEW_ROOT_INSTANCE_ID_KEY(TODO_RECURSE_NEXT_OBJ)'"/>
                    </xsl:element>
                    <xsl:for-each select="$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/objects_derivations_list/p5_tr_map:derivations" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
                        <xsl:sort select="position()" data-type="number" order="descending"/> 
                        <!--<xsl:comment>100: tworzymy elementy wskazujace na instnienie tabeli instancyjnej glownej do ktorych dodajemy wszelkie mozliwe dziedziczone z niej struktury dotyczace kontekstowego obiektu, biorac pod uwage, ze w przypadku innych obiektow dziedziczacych w innych kierunkach, tamte obiekty beda dodawac dla siebie cacheujace wartosci, komplet wszystkich danych umozliwi znalezienie unikalnosci oraz powtorzen w tym zakresie dla zastosowania albo funkcji cacheujacych, albo triggerow albo innych metod </xsl:comment>-->
                        <xsl:element name="columns_CACHE_INSTANCE">
                            <xsl:element name="COLUMN_NAME">
                                <xsl:attribute name="system_cache__appinfo:id" select="@system_cache__appinfo:id"/>
                                <xsl:attribute name="system_cache__appinfo:xpath_full" select="@system_cache__appinfo:xpath_full"/>
                            </xsl:element>
                            <xsl:element name="COLUMN_VALUE">
                                <xsl:choose>
                                    <xsl:when test="@system_cache__appinfo:id=$system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type/@p5_tr_map:object_type_id">
                                        <xsl:value-of select="true()"/>
                                    </xsl:when>
                                    <xsl:otherwise>
                                        <xsl:value-of select="'derived'"/>
                                    </xsl:otherwise>
                                </xsl:choose>
                            </xsl:element>
                        </xsl:element>
                    </xsl:for-each>
                </xsl:element>
    </xsl:template>
    
    <xsl:template match="*" mode="sso_procesy5:moved_after_node_to_apply" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="system_cache__resources_tree_generate_xsl_required_occurs_raport:detect_resource_type" required="yes"/>
        <xsl:variable name="detect_resource_type_102" select="current()"/>
       <xsl:message terminate="yes">#2069 error Unknown @event_type:<xsl:value-of select="@event_type"/>;</xsl:message>
    </xsl:template>
    
    
    
    
    <!-- @2016-01-31 - do wykrycia key dla wszystkich typow EOF -->
    <!-- @2016-01-20 template do zbudowania zwlaszcza w 4812 $read_key_value , ze sciezkami - podany poczatek oraz koniec analizy sciezki po :uuid -->
    <xsl:template match="go_recurse_from_root_by_build_element_473|go_recurse_from_root_by_build_element_428|go_recurse_from_root_by_build_element_428a|go_recurse_from_root_by_build_element_720" mode="sso_procesy5:create_key_value_path" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <!-- usage example:
            <xsl:variable name="form_element_name_4810">
                <xsl:call-template name="p5_obj_vars:create_key_value_path">
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="go_recurse_from_root_by_build_element" select="$go_recurse_from_root_by_build_element"/>
                    <xsl:with-param name="p5_obj_vars:key_value" select="$form_element_name"/>
                </xsl:call-template>
            </xsl:variable>
            <xsl:variable name="form_element_name_4810_keys_to_share"> <!-/- Keys to share are used in db operations to initiate key_values to be known -/->
                <xsl:apply-templates mode="p5_obj_vars:create_key_value_path" select="$go_recurse_from_root_by_build_element/child::node()">
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="p5_obj_vars:key_value" select="$form_element_name"/>
                </xsl:apply-templates>
                <p5_obj_vars:create_key_value_path>
                    <xsl:value-of select="$form_element_name"/>
                </p5_obj_vars:create_key_value_path>
            </xsl:variable>
        -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="p5_tr_map:uuid"/><!-- koncowy wezel do ktorego ma byc przeliczony klucz-->
        <xsl:param name="p5_obj_vars:key_value" required="yes"/><!-- przy pierwszym wyzwoleniu nalezy podac aktualna sciezke, do ktorej beda doklejane wartosci-->
            <xsl:variable name="current" select="current()"/>
            <xsl:for-each select="1 to system_cache__appinfo:form_occurs_max_sequence(@system_cache__appinfo:maxOccurs)">
                <xsl:variable name="form_element_name" select="system_cache__appinfo:create_form_element_id($transaction_id,concat($p5_obj_vars:key_value,'#',$current/@event_type,'#',system_cache__appinfo:translate_object_escaped_prefix_from_string($current/@system_cache__appinfo:id),'-',$current/@p5_tr_map:uuid),position())"/>
                    <xsl:choose>
                        <xsl:when test="$current/@p5_tr_map:uuid=$p5_tr_map:uuid">
                            <!--<p5_tr_map:uuid>matched</p5_tr_map:uuid>-->
                            <sso_procesy5:create_key_value_path>
                            <xsl:value-of select="$form_element_name"/>
                            </sso_procesy5:create_key_value_path>
                        </xsl:when>
                        <xsl:otherwise>
                            <xsl:apply-templates mode="#current" select="$current/*">
                                <xsl:with-param name="transaction_id" select="$transaction_id"/>
                                <xsl:with-param name="p5_obj_vars:key_value" select="$form_element_name"/>
                                <xsl:with-param name="p5_tr_map:uuid" select="$p5_tr_map:uuid"/>
                            </xsl:apply-templates>
                        </xsl:otherwise>
                    </xsl:choose>
            </xsl:for-each>
    </xsl:template>
    
    
    <xsl:template match="go_recurse_from_root_by_build_element_494|go_recurse_from_root_by_build_element_494d|go_recurse_from_root_by_build_element_4940|go_recurse_from_root_by_build_element_4941|go_recurse_from_root_by_build_element_4942" mode="sso_procesy5:create_key_value_path" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="transaction_id"/>
        <xsl:param name="p5_tr_map:uuid"/><!-- koncowy wezel do ktorego ma byc przeliczony klucz--><!-- przy pierwszym wyzwoleniu nalezy podac aktualna sciezke, do ktorej beda doklejane wartosci-->
        <xsl:param name="p5_obj_vars:key_value" required="no"/><!-- po kolejnym wyzwoleniu dziedziczenia przechodzi parametr -->
        <xsl:variable name="current" select="current()"/>
        <xsl:variable name="form_element_name">
            <xsl:choose>
                <xsl:when test="$p5_obj_vars:key_value"><xsl:value-of select="system_cache__appinfo:create_form_element_id($transaction_id,concat($p5_obj_vars:key_value,'#',@event_type,'#',system_cache__appinfo:translate_object_escaped_prefix_from_string(@system_cache__appinfo:id),'-',@p5_tr_map:uuid),1)"/></xsl:when>
                <xsl:otherwise><xsl:value-of select="system_cache__appinfo:create_form_element_id($transaction_id,concat(system_cache__appinfo:translate_object_escaped_prefix_from_string(@system_cache__appinfo:id),'-',@p5_tr_map:uuid),1)"/></xsl:otherwise>
            </xsl:choose>
        </xsl:variable>
       <!--<xsl:variable name="form_element_name" select="system_cache__appinfo:create_form_element_id($transaction_id,concat($p5_obj_vars:key_value,'#',@event_type,'#',system_cache__appinfo:translate_object_escaped_prefix_from_string(@system_cache__appinfo:id),'-',@p5_tr_map:uuid),1)"/>-->
            <xsl:choose>
                <xsl:when test="$current/@p5_tr_map:uuid=$p5_tr_map:uuid"><!--<p5_tr_map:uuid>matched</p5_tr_map:uuid>-->
                    <sso_procesy5:create_key_value_path>
                        <xsl:value-of select="$form_element_name"/>
                    </sso_procesy5:create_key_value_path>
                </xsl:when>
                <xsl:otherwise>
                        <xsl:apply-templates mode="#current">
                            <xsl:with-param name="transaction_id" select="$transaction_id"/>
                            <xsl:with-param name="p5_obj_vars:key_value" select="$form_element_name"/>
                            <xsl:with-param name="p5_tr_map:uuid" select="$p5_tr_map:uuid"/>
                        </xsl:apply-templates>
                </xsl:otherwise>
            </xsl:choose>
    </xsl:template>
    
    
    <xsl:template match="go_recurse_from_root_by_build_element|go_recurse_from_root_by_build_element_434" mode="sso_procesy5:create_key_value_path" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="transaction_id"/>
        <xsl:param name="p5_tr_map:uuid"/><!-- koncowy wezel do ktorego ma byc przeliczony klucz-->
        <xsl:param name="p5_obj_vars:key_value" required="no"/>
            <xsl:apply-templates mode="#current">
                <xsl:with-param name="transaction_id" select="$transaction_id"/><!--<xsl:with-param name="p5_obj_vars:key_value" select="$p5_obj_vars:key_value"/>-->
                <xsl:with-param name="p5_tr_map:uuid" select="$p5_tr_map:uuid"/>
            </xsl:apply-templates>
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_4777|go_recurse_from_root_by_build_element_477|go_recurse_from_root_by_build_element_477b|go_recurse_from_root_by_build_element_481" mode="sso_procesy5:create_key_value_path" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"/>
    <xsl:template match="comment()|text()" mode="sso_procesy5:create_key_value_path" />    
    <xsl:template match="*" mode="sso_procesy5:create_key_value_path">
        <xsl:message terminate="yes">#2573 - unexpected element to parse - upgrade conditions for element=<xsl:value-of select="name()"/>;</xsl:message>
    </xsl:template>
    <!-- @2016-01-10 bierze ostatnia wartosc z przetwarzania -->
    <xsl:template name="sso_procesy5:create_key_value_path">
        <xsl:param name="transaction_id"/>
        <xsl:param name="p5_obj_vars:key_value" required="yes"/><!-- tutaj nalezy wstawic $form_element_name - juz przetworzony klucz dla danego wezla. -->
        <xsl:param name="go_recurse_from_root_by_build_element" required="yes"/><!-- system przetworzy dla kolejnych wezlow dzieci typu 481* -->
        <xsl:variable name="p5_obj_vars:create_key_value_path">
            <xsl:apply-templates mode="p5_obj_vars:create_key_value_path" select="$go_recurse_from_root_by_build_element/child::node()">
                <xsl:with-param name="transaction_id" select="$transaction_id"/>
                <xsl:with-param name="p5_obj_vars:key_value" select="$p5_obj_vars:key_value"/>
            </xsl:apply-templates>
        </xsl:variable>
        <xsl:value-of select="$p5_obj_vars:create_key_value_path/p5_obj_vars:create_key_value_path[position()=last()]"/>
        <!--<xsl:value-of select="count($p5_obj_vars:create_key_value_path/p5_obj_vars:create_key_value_path)"/>-->
    </xsl:template>
    <!-- EOF @2016-01-31 - do wykrycia key dla wszystkich typow  -->
    
    
    
    
    <!-- @2016-01-31 - do wykrycia p5_obj_vars:evaluate_key_value_root_instance  dla  4777 EOF -->
    
    <xsl:template match="go_recurse_from_root_by_build_element_473|go_recurse_from_root_by_build_element_4777|go_recurse_from_root_by_build_element_477|go_recurse_from_root_by_build_element_477b" mode="sso_procesy5:create_key_value_root_instance_by_4777_path" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <!-- usage example:
            <xsl:variable name="form_element_name_4810">
                <xsl:call-template name="p5_obj_vars:create_key_value_path">
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="go_recurse_from_root_by_build_element" select="$go_recurse_from_root_by_build_element"/>
                    <xsl:with-param name="p5_obj_vars:key_value" select="$form_element_name"/>
                </xsl:call-template>
            </xsl:variable>
            <xsl:variable name="form_element_name_4810_keys_to_share"> <!-/- Keys to share are used in db operations to initiate key_values to be known -/->
                <xsl:apply-templates mode="p5_obj_vars:create_key_value_path" select="$go_recurse_from_root_by_build_element/child::node()">
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="p5_obj_vars:key_value" select="$form_element_name"/>
                </xsl:apply-templates>
                <p5_obj_vars:create_key_value_path>
                    <xsl:value-of select="$form_element_name"/>
                </p5_obj_vars:create_key_value_path>
            </xsl:variable>
        -->
        <xsl:param name="transaction_id"/>
        <xsl:param name="p5_tr_map:uuid"/><!-- koncowy wezel do ktorego ma byc przeliczony klucz-->
        <xsl:param name="p5_obj_vars:key_value" required="yes"/><!-- przy pierwszym wyzwoleniu nalezy podac aktualna sciezke, do ktorej beda doklejane wartosci-->
        <xsl:param name="p5_obj_vars:last_instance_key_value" required="yes"/><!-- ostatni 494* nadpisuje ta wartosc swoim key - przy zgodzie , nalezy jego wyswietlic-->
        <xsl:variable name="current" select="current()"/>
        <!--<xsl:comment>#2659:<xsl:value-of select="$current/name()"/> uuid:<xsl:value-of select="$current/@p5_tr_map:uuid"/>;</xsl:comment>-->
        <xsl:for-each select="1 to system_cache__appinfo:form_occurs_max_sequence(@system_cache__appinfo:maxOccurs)">
            <xsl:variable name="form_element_name" select="system_cache__appinfo:create_form_element_id($transaction_id,concat($p5_obj_vars:key_value,'#',$current/@event_type,'#',system_cache__appinfo:translate_object_escaped_prefix_from_string($current/@system_cache__appinfo:id),'-',$current/@p5_tr_map:uuid),position())"/>
            <xsl:choose>
                <xsl:when test="$current/@p5_tr_map:uuid=$p5_tr_map:uuid">
                    <!--<p5_tr_map:uuid>matched</p5_tr_map:uuid>-->
                    <sso_procesy5:create_key_value_path>
                        <xsl:value-of select="$p5_obj_vars:last_instance_key_value"/>
                    </sso_procesy5:create_key_value_path>
                </xsl:when>
                <xsl:otherwise>
                    <!--<xsl:comment>#2671:<xsl:value-of select="$current/name()"/> uuid:<xsl:value-of select="$current/@p5_tr_map:uuid"/>;</xsl:comment>-->
                    <xsl:apply-templates mode="#current" select="$current/*">
                        <xsl:with-param name="transaction_id" select="$transaction_id"/>
                        <xsl:with-param name="p5_obj_vars:key_value" select="$form_element_name"/>
                        <xsl:with-param name="p5_tr_map:uuid" select="$p5_tr_map:uuid"/>
                        <xsl:with-param name="p5_obj_vars:last_instance_key_value" select="$p5_obj_vars:last_instance_key_value"/>
                    </xsl:apply-templates>
                </xsl:otherwise>
            </xsl:choose>
        </xsl:for-each>
    </xsl:template>
    
    
    <xsl:template match="go_recurse_from_root_by_build_element_494|go_recurse_from_root_by_build_element_494d|go_recurse_from_root_by_build_element_4940|go_recurse_from_root_by_build_element_4941|go_recurse_from_root_by_build_element_4942|go_recurse_from_root_by_build_element_481|go_recurse_from_root_by_build_element_4812|go_recurse_from_root_by_build_element_4811|go_recurse_from_root_by_build_element_4810" mode="sso_procesy5:create_key_value_root_instance_by_4777_path" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="transaction_id"/>
        <xsl:param name="p5_tr_map:uuid"/><!-- koncowy wezel do ktorego ma byc przeliczony klucz--><!-- przy pierwszym wyzwoleniu nalezy podac aktualna sciezke, do ktorej beda doklejane wartosci-->
        <xsl:param name="p5_obj_vars:key_value" required="no"/><!-- po kolejnym wyzwoleniu dziedziczenia przechodzi parametr -->
        <xsl:variable name="current" select="current()"/>
        <xsl:variable name="form_element_name">
            <xsl:choose>
                <xsl:when test="$p5_obj_vars:key_value"><xsl:value-of select="system_cache__appinfo:create_form_element_id($transaction_id,concat($p5_obj_vars:key_value,'#',@event_type,'#',system_cache__appinfo:translate_object_escaped_prefix_from_string(@system_cache__appinfo:id),'-',@p5_tr_map:uuid),1)"/></xsl:when>
                <xsl:otherwise><xsl:value-of select="system_cache__appinfo:create_form_element_id($transaction_id,concat(system_cache__appinfo:translate_object_escaped_prefix_from_string(@system_cache__appinfo:id),'-',@p5_tr_map:uuid),1)"/></xsl:otherwise>
            </xsl:choose>
        </xsl:variable>
        <!--<xsl:variable name="form_element_name" select="system_cache__appinfo:create_form_element_id($transaction_id,concat($p5_obj_vars:key_value,'#',@event_type,'#',system_cache__appinfo:translate_object_escaped_prefix_from_string(@system_cache__appinfo:id),'-',@p5_tr_map:uuid),1)"/>-->
        <xsl:choose>
            <xsl:when test="$current/@p5_tr_map:uuid=$p5_tr_map:uuid"><!--<p5_tr_map:uuid>matched</p5_tr_map:uuid>-->
                <sso_procesy5:create_key_value_path>
                    <xsl:value-of select="$form_element_name"/>
                </sso_procesy5:create_key_value_path>
            </xsl:when>
            <xsl:otherwise>
                <!--<xsl:comment>#2701:<xsl:value-of select="$current/name()"/> uuid:<xsl:value-of select="$current/@p5_tr_map:uuid"/>;</xsl:comment>-->
                <xsl:apply-templates mode="#current">
                    <xsl:with-param name="transaction_id" select="$transaction_id"/>
                    <xsl:with-param name="p5_obj_vars:key_value" select="$form_element_name"/>
                    <xsl:with-param name="p5_tr_map:uuid" select="$p5_tr_map:uuid"/>
                    <xsl:with-param name="p5_obj_vars:last_instance_key_value" select="$form_element_name"/>
                </xsl:apply-templates>
            </xsl:otherwise>
        </xsl:choose>
    </xsl:template>
    
    
    
    <xsl:template match="go_recurse_from_root_by_build_element|go_recurse_from_root_by_build_element_434|go_recurse_from_root_by_build_element_434c" mode="sso_procesy5:create_key_value_root_instance_by_4777_path" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd">
        <xsl:param name="transaction_id"/>
        <xsl:param name="p5_tr_map:uuid"/><!-- koncowy wezel do ktorego ma byc przeliczony klucz - dla 4777 - w przypadku odnalezienia zostana wyswietlone wczesniejsze -->
        <xsl:param name="p5_obj_vars:key_value" required="no"/>
        <xsl:param name="p5_obj_vars:last_instance_key_value" required="no"/><!-- przy pierwszym wezle moze nie byc w schemacie -->
        <xsl:apply-templates mode="#current">
            <xsl:with-param name="transaction_id" select="$transaction_id"/><!--<xsl:with-param name="p5_obj_vars:key_value" select="$p5_obj_vars:key_value"/>-->
            <xsl:with-param name="p5_tr_map:uuid" select="$p5_tr_map:uuid"/>
            <xsl:with-param name="p5_obj_vars:key_value" select="$p5_obj_vars:key_value"/>
            <xsl:with-param name="p5_obj_vars:last_instance_key_value" select="$p5_obj_vars:last_instance_key_value"/>
        </xsl:apply-templates>
    </xsl:template>
    <xsl:template match="go_recurse_from_root_by_build_element_428|go_recurse_from_root_by_build_element_428a|go_recurse_from_root_by_build_element_720|go_recurse_from_root_by_build_element_loop|system_cache__appinfo:schema|go_recurse_from_root_by_build_element_434r" mode="sso_procesy5:create_key_value_root_instance_by_4777_path" xpath-default-namespace="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"/>
    <xsl:template match="text()" mode="sso_procesy5:create_key_value_root_instance_by_4777_path" />
    <xsl:template match="comment()" mode="sso_procesy5:create_key_value_root_instance_by_4777_path" />    
    <xsl:template match="*" mode="sso_procesy5:create_key_value_root_instance_by_4777_path">
        <xsl:message terminate="yes">#2573 - unexpected element to parse - upgrade conditions for element=<xsl:value-of select="name()"/>;</xsl:message>
    </xsl:template>
    <!-- @2016-01-10 bierze ostatnia wartosc z przetwarzania -->
    <xsl:template name="sso_procesy5:create_key_value_root_instance_by_4777_path">
        <xsl:param name="transaction_id"/>
        <xsl:param name="p5_obj_vars:key_value" required="yes"/><!-- tutaj nalezy wstawic $form_element_name - juz przetworzony klucz dla danego wezla. -->
        <xsl:param name="go_recurse_from_root_by_build_element" required="yes"/><!-- system przetworzy dla kolejnych wezlow dzieci typu 481* -->
        <xsl:variable name="p5_obj_vars:create_key_value_path">
            <xsl:apply-templates mode="p5_obj_vars:create_key_value_path" select="$go_recurse_from_root_by_build_element/child::node()">
                <xsl:with-param name="transaction_id" select="$transaction_id"/>
                <xsl:with-param name="p5_obj_vars:key_value" select="$p5_obj_vars:key_value"/>
            </xsl:apply-templates>
        </xsl:variable>
        <xsl:value-of select="$p5_obj_vars:create_key_value_path/p5_obj_vars:create_key_value_path[position()=last()]"/>
        <!--<xsl:value-of select="count($p5_obj_vars:create_key_value_path/p5_obj_vars:create_key_value_path)"/>-->
    </xsl:template>
    <!-- EOF  @2016-01-31 - do wykrycia p5_obj_vars:evaluate_key_value_root_instance  dla  4777  -->
    
    
    
    
    
    
    
    
    <xsl:template match="sso_procesy5:create_db_functions_from_go_recurse_from_root_by_build_element_with_cache" mode="sso_procesy5:create_sql_tables_final" >
        <xsl:variable name="create_db_functions_from_go_recurse_from_root_by_build_element_with_cache_507" select="."/>
        <create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache>
            <xsl:variable name="unique_tables_510">
                <xsl:apply-templates mode="sso_procesy5:unique_structure_table" select="//sso_procesy5:instance_cache_informations"/>
            </xsl:variable>
            <xsl:for-each select="$unique_tables_510">
                <xsl:apply-templates mode="sso_procesy5:create_sql_tables_final">
                    <xsl:with-param name="create_db_functions_from_go_recurse_from_root_by_build_element_with_cache" select="$create_db_functions_from_go_recurse_from_root_by_build_element_with_cache_507"/>
                </xsl:apply-templates>
            </xsl:for-each>
        </create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache>
    </xsl:template>
    <xsl:template match="sso_procesy5:function_for_manage_object" mode="sso_procesy5:create_sql_table" >
        <xsl:variable name="sso_procesy5:instance_cache_informations" select="sso_procesy5:instance_cache_informations"/>
        <create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache>
            <xsl:variable name="unique_tables_510">
                <xsl:apply-templates mode="sso_procesy5:unique_structure_table" select="//sso_procesy5:instance_cache_informations"/>
            </xsl:variable>
            <xsl:for-each select="$unique_tables_510">
                <xsl:apply-templates mode="sso_procesy5:create_sql_table">
                    <xsl:with-param name="sso_procesy5:instance_cache_informations" select="$sso_procesy5:instance_cache_informations"/>
                </xsl:apply-templates>
            </xsl:for-each>
        </create_sql_tables_from_go_recurse_from_root_by_build_element_with_cache>
    </xsl:template>
    <!-- @2015-12-02 template do wykonania analizy albo wszystkich tabel albo wyzwolony dla jednej funkcji - @2015-12-14 WARNING czy tabele dla calosci oraz tabele dla pojedynczego obiektu moga byc transformowane tak samo TODO - ten sam styl w sso_procesy5:create_sql_table ? -->
    
    <xsl:template match="sso_procesy5:unique_structure_table" mode="sso_procesy5:create_sql_tables_final">
        <xsl:param name="create_db_functions_from_go_recurse_from_root_by_build_element_with_cache" required="yes"/><!-- biezacy element zawierajacy instance_cache_informations -->
        <xsl:variable name="current_table_517" select="@table_name"/> <!-- todo czy escapowac? system_cache__appinfo:translate_object_escaped_prefix_from_string -->
        <sql_create><xsl:attribute name="table_name" select="$current_table_517"/><xsl:attribute name="table_type" select="@table_type"/>
            $sql_struct[]="CREATE TABLE IF NOT EXISTS `<xsl:value-of select="$current_table_517"/>` ( `ID` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin2 COMMENT='<xsl:value-of select="concat(@p5_tr_map:parent_name_with_pref,'/',@p5_tr_map:object_type_name_with_pref)"/>'"; 
            $sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD PRIMARY KEY (`ID`)";
            $sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT";
            <xsl:choose>
                <xsl:when test="@table_type='structure_table_child_instance' or @table_type='structure_table_root_instance'">
                    <sql_ELEMENT_NAME> $sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD NAME varchar(255)" ; </sql_ELEMENT_NAME>
                </xsl:when>
                <xsl:when test="@table_type='structure_table_reference'">
                    <sql_CACHE_INSTANCE_ID> $sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD CACHE_INSTANCE_ID int(11)" ; </sql_CACHE_INSTANCE_ID>
                    <sql_PARENT_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD PARENT_ID int(11)" ; </sql_PARENT_ID>
                    <sql_REMOTE_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD REMOTE_ID int(11) "; </sql_REMOTE_ID>
                </xsl:when>
                <xsl:when test="@table_type='structure_table_value'">
                    <sql_VALUE>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD VALUE varchar(255)" ; </sql_VALUE>
                    <sql_PARENT_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD PARENT_ID int(11)" ; </sql_PARENT_ID>
                    <sql_CACHE_INSTANCE_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD CACHE_INSTANCE_ID int(11)" ; </sql_CACHE_INSTANCE_ID>
                </xsl:when>
                <xsl:when test="@table_type='structure_table_sequence'">
                    <sql_PARENT_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD PARENT_ID int(11)" ; </sql_PARENT_ID>
                    <sql_CACHE_INSTANCE_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD CACHE_INSTANCE_ID int(11)" ; </sql_CACHE_INSTANCE_ID>
                </xsl:when>
            </xsl:choose>
            <xsl:for-each select="$create_db_functions_from_go_recurse_from_root_by_build_element_with_cache//(sso_procesy5:structure_table_child_instance|sso_procesy5:structure_table_root_instance|sso_procesy5:structure_table_sequence|sso_procesy5:structure_table_reference|sso_procesy5:structure_table_value)[@table_name=$current_table_517]" >
                <xsl:for-each-group select="columns_CACHE_INSTANCE/COLUMN_NAME" group-by="@system_cache__appinfo:id">
                    <sql_CACHE_INSTANCE><xsl:attribute name="COLUMN_NAME" select="@system_cache__appinfo:id"/>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD `<xsl:value-of select="@system_cache__appinfo:id"/>` enum('true','derived','false','','N/S;') default 'N/S;'";</sql_CACHE_INSTANCE>
                </xsl:for-each-group>
            </xsl:for-each>
        </sql_create>
        <sql_drop>
            <xsl:attribute name="table_name" select="$current_table_517"/><xsl:attribute name="table_type" select="@table_type"/>
            $sql_struct_drop[]="DROP TABLE  `<xsl:value-of select="$current_table_517"/>`"; 
        </sql_drop>
    </xsl:template>
    <xsl:template match="sso_procesy5:unique_structure_table" mode="sso_procesy5:create_sql_table">
        <xsl:param name="sso_procesy5:instance_cache_informations" required="yes"/><!-- biezacy element zawierajacy instance_cache_informations -->
        <xsl:variable name="current_table_517" select="@table_name"/> <!-- todo czy escapowac? system_cache__appinfo:translate_object_escaped_prefix_from_string -->
            <sql_create><xsl:attribute name="table_name" select="$current_table_517"/><xsl:attribute name="table_type" select="@table_type"/>
            $sql_struct[]="CREATE TABLE IF NOT EXISTS `<xsl:value-of select="$current_table_517"/>` ( `ID` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin2 COMMENT='<xsl:value-of select="concat(@p5_tr_map:parent_name_with_pref,'/',@p5_tr_map:object_type_name_with_pref)"/>'"; 
            $sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD PRIMARY KEY (`ID`)";
            $sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT";
                <xsl:choose>
                    <xsl:when test="@table_type='structure_table_child_instance' or @table_type='structure_table_root_instance'">
                        <sql_ELEMENT_NAME> $sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD NAME varchar(255)" ; </sql_ELEMENT_NAME>
                    </xsl:when>
                    <xsl:when test="@table_type='structure_table_reference'">
                        <sql_CACHE_INSTANCE_ID> $sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD CACHE_INSTANCE_ID int(11)" ; </sql_CACHE_INSTANCE_ID>
                        <sql_PARENT_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD PARENT_ID int(11)" ; </sql_PARENT_ID>
                        <sql_REMOTE_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD REMOTE_ID int(11) "; </sql_REMOTE_ID>
                    </xsl:when>
                    <xsl:when test="@table_type='structure_table_value'">
                        <sql_VALUE>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD VALUE varchar(255)" ; </sql_VALUE>
                        <sql_PARENT_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD PARENT_ID int(11)" ; </sql_PARENT_ID>
                        <sql_CACHE_INSTANCE_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD CACHE_INSTANCE_ID int(11)" ; </sql_CACHE_INSTANCE_ID>
                    </xsl:when>
                    <xsl:when test="@table_type='structure_table_sequence'">
                        <sql_PARENT_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD PARENT_ID int(11)" ; </sql_PARENT_ID>
                        <sql_CACHE_INSTANCE_ID>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD CACHE_INSTANCE_ID int(11)" ; </sql_CACHE_INSTANCE_ID>
                    </xsl:when>
                </xsl:choose>
                <xsl:for-each select="$sso_procesy5:instance_cache_informations//(sso_procesy5:structure_table_child_instance|sso_procesy5:structure_table_root_instance|sso_procesy5:structure_table_sequence|sso_procesy5:structure_table_reference|sso_procesy5:structure_table_value)[@table_name=$current_table_517]" >
                    <xsl:for-each-group select="columns_CACHE_INSTANCE/COLUMN_NAME" group-by="@system_cache__appinfo:id">
                        <sql_CACHE_INSTANCE><xsl:attribute name="COLUMN_NAME" select="@system_cache__appinfo:id"/>$sql_struct[]="ALTER IGNORE TABLE `<xsl:value-of select="$current_table_517"/>` ADD `<xsl:value-of select="@system_cache__appinfo:id"/>` enum('true','derived','false','','N/S;') default 'N/S;'";</sql_CACHE_INSTANCE>
                    </xsl:for-each-group>
                </xsl:for-each>
            </sql_create>
            <sql_drop>
                <xsl:attribute name="table_name" select="$current_table_517"/><xsl:attribute name="table_type" select="@table_type"/>
                $sql_struct_drop[]="DROP TABLE  `<xsl:value-of select="$current_table_517"/>`"; 
            </sql_drop>
    </xsl:template>
    
    <!-- @2015-12-26 budujemy menu do nawigacji otwierania obiektow parent oraz ich dzieci-->
    
    <xsl:template match="system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings_list|system_cache__resources_tree_generate_xsl_required_occurs_raport:from_parent_relations_list" mode="sso_procesy5:create_object_navgation_menu">
        <xsl:apply-templates mode="#current"/>
    </xsl:template>
    <xsl:template match="system_cache__appinfo:detect_element_relations_to_objects_list" mode="sso_procesy5:create_object_navgation_menu">
        <table border="1" bgcolor="yellow">
            <tr>
                <td>
                    <font size="-2">Typy powiazane</font>
                </td>
                <xsl:apply-templates mode="#current"/>
            </tr>
        </table>
    </xsl:template>
    <xsl:template match="system_cache__appinfo:detect_element_relations_to_objects" mode="sso_procesy5:create_object_navgation_menu">
                    <td><font size="-3"><xsl:value-of select="@system_cache__appinfo:ref"/><a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@system_cache__appinfo:ref)}/create_obj_form_html.php">(add)</a><a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@system_cache__appinfo:ref)}/list_obj_form_html.php">(lista)</a></font></td>
    </xsl:template>
    <xsl:template match="system_cache__resources_tree_generate_xsl_required_occurs_raport:from_parent_relations" mode="sso_procesy5:create_object_navgation_menu">
        <xsl:choose>
            <xsl:when test="@local-name='element'">
                <table border="2" bgcolor="green"><tr><td>
                    <font size="-3">Obiekty dowiazujace niniejszy obiekt</font>
                </td>
                    <td><font size="-3"><xsl:value-of select="@parent_object"/><a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@parent_object)}/create_obj_form_html.php">(add)</a><a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@parent_object)}/list_obj_form_html.php">(lista)</a></font></td>
                </tr>
                </table>
            </xsl:when>
            <xsl:otherwise>
                <table border="2" bgcolor="green"><tr><td>
                    <font size="-3">Obiekty dowiazujace niniejszy obiekt - bez mozliwej instanacji w schemacie</font>
                </td>
                    <td><font size="-3"><xsl:value-of select="@parent_object"/></font></td>
                </tr>
                </table>
            </xsl:otherwise>
        </xsl:choose>
        
    </xsl:template>
    <xsl:template match="system_cache__resources_tree_generate_xsl_required_occurs_raport:parent_complexType_siblings" mode="sso_procesy5:create_object_navgation_menu">
        <!--<table border="2" bgcolor="green"><tr><td>-->
        <xsl:apply-templates mode="#current"/>
        <!--</td>
        </tr>
        </table>-->
    </xsl:template>
    <xsl:template match="system_cache__appinfo:parent_complexType" mode="sso_procesy5:create_object_navgation_menu">
        <xsl:if test="substring-before(@p5_tr_map:name_with_pref,':')='prove_portal' or substring-before(@p5_tr_map:name_with_pref,':')='test_objects' or substring-before(@p5_tr_map:name_with_pref,':')='moj_ogrodek' or 1=1"> <!-- TOTO DEBUG OGRANICZENIE-->
        <table border="1" bgcolor="yellow">
            <tr>
                <td>
                    <font size="-2">Typy blizniacze <xsl:value-of select="@parent_complexType"/></font>
                </td>
            <xsl:apply-templates mode="#current"/>
            </tr>
        </table>
        </xsl:if>
    </xsl:template>
    <xsl:template match="system_cache__appinfo:parent_complexType_child" mode="sso_procesy5:create_object_navgation_menu">
        <td><font size="-3"><xsl:value-of select="@p5_tr_map:name_with_pref"/><a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@p5_tr_map:name_with_pref)}/create_obj_form_html.php">(add)</a><a href="{$public_html_xmslchema_procesy5_url}/default_db.instance.xml/sso_procesy5/{system_cache__appinfo:escape_object_prefix_to_string(@p5_tr_map:name_with_pref)}/list_obj_form_html.php">(lista)</a></font></td>
    </xsl:template>
    <xsl:template match="*|comment()" mode="sso_procesy5:create_object_navgation_menu"/>
    
</xsl:stylesheet>