se/SE/schema/default_db_xml_cache/fix_acl_functions_test.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:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
    exclude-result-prefixes="xs"
    version="2.0">
    
    <!-- @2015-07-28 testowe funkcje do sprzatania problemow z uprawnieniami i brakujacymi ACL -->
    <!-- @2017-02 bindera: wyglada na przydatne do wstawienia jako funkcja do WPS itp -->
   
    <xsl:import href="import_resource_table_xml_from_api.xsl"/>
    <xsl:import href="form_occurs_max_sequence.xsl"/>
    <xsl:import href="get_all_xsd.xsl"/>
    <xsl:import href="CRM_LISTA_ZASOBOW_tree.xsl"/>
    <xsl:import href="IN7_MK_BAZA_DYSTRYBUCJI_tree.xsl"/>
    
    <xsl:param name="resource_id" select="''"/> <!-- numer zasobu do odbudowy drzewa -->
    
   
    <xsl:variable name="DEVICES">
        <xsl:call-template name="import_resource_table_xml_from_api">
            <xsl:with-param name="cache" select="'read'"/>
            <xsl:with-param name="resource" select="'DEVICES'"/>
        </xsl:call-template>
    </xsl:variable>
    <xsl:variable name="LDAP_GROUPS">
        <!-- ID , NAME -->
        <xsl:call-template name="import_resource_table_xml_from_api">
            <xsl:with-param name="cache" select="'read'"/>
            <xsl:with-param name="resource" select="'LDAP_GROUPS'"/>
        </xsl:call-template>
    </xsl:variable>
    <xsl:variable name="CRM_LISTA_ZASOBOW">
        <!-- ID , A_LDAP_GID(LDAP_GROUPS)-->
        <xsl:call-template name="import_resource_table_xml_from_api">
            <xsl:with-param name="cache" select="'read'"/>
            <xsl:with-param name="resource" select="'CRM_LISTA_ZASOBOW'"/>
        </xsl:call-template>
    </xsl:variable>
    <xsl:variable name="IN7_DZIENNIK_KORESP">
        <xsl:call-template name="import_resource_table_xml_from_api">
            <xsl:with-param name="cache" select="'read'"/>
            <xsl:with-param name="resource" select="'IN7_DZIENNIK_KORESP'"/>
        </xsl:call-template>
    </xsl:variable>
    <xsl:variable name="IN7_MK_BAZA_DYSTRYBUCJI">
        <xsl:call-template name="import_resource_table_xml_from_api">
            <xsl:with-param name="cache" select="'read'"/>
            <xsl:with-param name="resource" select="'IN7_MK_BAZA_DYSTRYBUCJI'"/>
        </xsl:call-template>
    </xsl:variable>
    <xsl:variable name="TELBOXES">
        <xsl:call-template name="import_resource_table_xml_from_api">
            <xsl:with-param name="cache" select="'read'"/>
            <xsl:with-param name="resource" select="'TELBOXES'"/>
        </xsl:call-template>
    </xsl:variable>
    <xsl:variable name="PROBLEMS">
        <xsl:call-template name="import_resource_table_xml_from_api">
            <xsl:with-param name="cache" select="'read'"/>
            <xsl:with-param name="resource" select="'PROBLEMS'"/>
        </xsl:call-template>
    </xsl:variable>
    <xsl:variable name="system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree">
        <xsl:call-template name="system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree"/>
    </xsl:variable>
    <xsl:variable name="system_cache__appinfo:transform_cache__IN7_MK_BAZA_DYSTRYBUCJI_tree">
        <xsl:call-template name="system_cache__appinfo:transform_cache__IN7_MK_BAZA_DYSTRYBUCJI_tree"/>
    </xsl:variable>
  
    <xsl:template name="main">
        <system_cache__appinfo:fix_acl_functions_confirm_form>
        <xsl:call-template name="IN7_MK_BAZA_DYSTRYBUCJI"/>
        <xsl:call-template name="IN7_DZIENNIK_KORESP"/>
        <xsl:call-template name="PROBLEMS"/>   
        <xsl:call-template name="DEVICES">
        </xsl:call-template>
        <xsl:call-template name="TELBOXES"/>
        <xsl:call-template name="CRM_LISTA_ZASOBOW"/>
        </system_cache__appinfo:fix_acl_functions_confirm_form>
    </xsl:template>

    <!-- szukamy spraw z pustymi uprawnieniami i sugerujemy ustawienie z parenta (PROJEKTY)-->
    <xsl:template name="IN7_MK_BAZA_DYSTRYBUCJI">
        <xsl:for-each select="$IN7_MK_BAZA_DYSTRYBUCJI//item[A_CLASSIFIED='']">
            <xsl:variable name="ID" select="ID"/>
            <item>
                <xsl:attribute name="resource" select="'IN7_MK_BAZA_DYSTRYBUCJI'"/>
                <xsl:attribute name="ID" select="$ID"/>
                <old>
                    <xsl:attribute name="A_CLASSIFIED" select="A_CLASSIFIED"/>
                    <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                </old>
                <set>
                    <xsl:attribute name="A_CLASSIFIED" select="$system_cache__appinfo:transform_cache__IN7_MK_BAZA_DYSTRYBUCJI_tree//tree_item/@A_CLASSIFIED[parent::node()/@ID=//tree_item[descendant::node()[@ID=$ID]]/@ID  and parent::node()/@A_CLASSIFIED!='']"/>
                    <!--<xsl:attribute name="A_CLASSIFIED" select="$system_cache__appinfo:transform_cache__IN7_MK_BAZA_DYSTRYBUCJI_tree//tree_item[descendant::node()[@ID=$ID] and @A_CLASSIFIED!='' ]/@A_CLASSIFIED"/>-->
                </set>
            </item>
        </xsl:for-each>
        <xsl:for-each select="$IN7_MK_BAZA_DYSTRYBUCJI//item[A_ADM_COMPANY='']">
            <xsl:variable name="ID" select="ID"/>
            <item>
                <xsl:attribute name="resource" select="'IN7_MK_BAZA_DYSTRYBUCJI'"/>
                <xsl:attribute name="ID" select="$ID"/>
                <old>
                    <xsl:attribute name="A_ADM_COMPANY" select="A_ADM_COMPANY"/>
                    <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                </old>
                <set>
                    <xsl:attribute name="A_ADM_COMPANY" select="$system_cache__appinfo:transform_cache__IN7_MK_BAZA_DYSTRYBUCJI_tree//tree_item/@A_ADM_COMPANY[parent::node()/@ID=//tree_item[descendant::node()[@ID=$ID]]/@ID  and parent::node()/@A_ADM_COMPANY!='']"/>
                    <!--<xsl:attribute name="A_ADM_COMPANY" select="$system_cache__appinfo:transform_cache__IN7_MK_BAZA_DYSTRYBUCJI_tree//tree_item[descendant::node()[@ID=$ID] and @A_ADM_COMPANY!='' ]/@A_ADM_COMPANY"/>-->
                </set>
            </item>
        </xsl:for-each>
    </xsl:template>
                
    <!-- szukamy korespondencji z niewlasciwymi numerami ACL wzgledem spraw -->
    <xsl:template name="IN7_DZIENNIK_KORESP">
        <xsl:for-each select="$IN7_MK_BAZA_DYSTRYBUCJI//item">
            <xsl:variable name="A_ADM_COMPANY" select="A_ADM_COMPANY"/>
            <xsl:variable name="A_CLASSIFIED"  select="A_CLASSIFIED" />
            <xsl:variable name="ID"  select="ID" />
            <xsl:for-each select="$IN7_DZIENNIK_KORESP//item[ID_PROJECT=$ID and A_ADM_COMPANY!=$A_ADM_COMPANY]">
                <item>
                    <xsl:attribute name="resource" select="'IN7_DZIENNIK_KORESP'"/>
                    <xsl:attribute name="ID" select="ID"/>
                    <old>
                        <xsl:attribute name="A_ADM_COMPANY" select="A_ADM_COMPANY"/>
                        <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                    </old>
                    <set>
                        <xsl:attribute name="A_ADM_COMPANY" select="$A_ADM_COMPANY"/>
                    </set>
                </item>
            </xsl:for-each>
            <xsl:for-each select="$IN7_DZIENNIK_KORESP//item[ID_PROJECT=$ID and A_CLASSIFIED!=$A_CLASSIFIED]">
                <item>
                    <xsl:attribute name="resource" select="'IN7_DZIENNIK_KORESP'"/>
                    <xsl:attribute name="ID" select="ID"/>
                    <old>
                        <xsl:attribute name="A_CLASSIFIED" select="A_CLASSIFIED"/>
                        <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                    </old>
                    <set>
                        <xsl:attribute name="A_CLASSIFIED" select="$A_CLASSIFIED"/>
                    </set>
                </item>
            </xsl:for-each>
            
        </xsl:for-each>
    </xsl:template>

    <!-- szukamy problemow bez ACL i powiazanych ze sprawami -->
    <xsl:template name="PROBLEMS">
        <xsl:for-each select="$IN7_MK_BAZA_DYSTRYBUCJI//item">
            <xsl:variable name="A_ADM_COMPANY" select="A_ADM_COMPANY"/>
            <xsl:variable name="A_CLASSIFIED"  select="A_CLASSIFIED" />
            <xsl:variable name="ID"  select="ID" />
            <xsl:for-each select="$PROBLEMS//item[ID_PROJECT=$ID and A_ADM_COMPANY!=$A_ADM_COMPANY]">
                <item>
                    <xsl:attribute name="resource" select="'PROBLEMS'"/>
                    <xsl:attribute name="ID" select="ID"/>
                    <old>
                        <xsl:attribute name="A_ADM_COMPANY" select="A_ADM_COMPANY"/>
                        <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                    </old>
                    <set>
                        <xsl:attribute name="A_ADM_COMPANY" select="$A_ADM_COMPANY"/>
                    </set>
                </item>
            </xsl:for-each>
            <xsl:for-each select="$PROBLEMS//item[ID_PROJECT=$ID and A_CLASSIFIED!=$A_CLASSIFIED]">
                <item>
                    <xsl:attribute name="resource" select="'PROBLEMS'"/>
                    <xsl:attribute name="ID" select="ID"/>
                    <old>
                        <xsl:attribute name="A_CLASSIFIED" select="A_CLASSIFIED"/>
                        <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                    </old>
                    <set>
                        <xsl:attribute name="A_CLASSIFIED" select="$A_CLASSIFIED"/>
                    </set>
                </item>
            </xsl:for-each>            
        </xsl:for-each>
    </xsl:template>
    
    <!-- szukam urzadzen bez grupy uprawnien i sugeruje ustawienie na podstawie grupy zasobow TODO inaczej niz po nr zasobu -->
    <xsl:template name="DEVICES">
        <xsl:for-each select="$DEVICES//item[A_CLASSIFIED='' and CRM_LISTA_ZASOBOW_ID!='']">
            
            <xsl:variable name="CRM_LISTA_ZASOBOW_ID" select="CRM_LISTA_ZASOBOW_ID"/>
            <item>
                <xsl:attribute name="resource" select="'DEVICES'"/>
                <xsl:attribute name="ID" select="ID"/>
                <old>
                    <xsl:attribute name="A_CLASSIFIED" select="A_CLASSIFIED"/>
                    <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                </old>
                <set>
                    <!--<xsl:attribute name="A_CLASSIFIED" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item[descendant::node()[@ID=$CRM_LISTA_ZASOBOW_ID] and @A_CLASSIFIED!='' ]/@A_CLASSIFIED"/>-->
                    <xsl:attribute name="A_CLASSIFIED" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item/@A_CLASSIFIED[parent::node()/@ID=//tree_item[descendant::node()[@ID=$CRM_LISTA_ZASOBOW_ID]]/@ID  and parent::node()/@A_CLASSIFIED!='']"/>
                </set>
            </item>
        </xsl:for-each>
        <xsl:for-each select="$DEVICES//item[A_ADM_COMPANY='' and CRM_LISTA_ZASOBOW_ID!='']">
            <xsl:variable name="CRM_LISTA_ZASOBOW_ID" select="CRM_LISTA_ZASOBOW_ID"/>
            <item>
                <xsl:attribute name="resource" select="'DEVICES'"/>
                <xsl:attribute name="ID" select="ID"/>
                <old>
                    <xsl:attribute name="A_ADM_COMPANY" select="A_ADM_COMPANY"/>
                    <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                </old>
                <set>
                    <!--<xsl:attribute name="A_ADM_COMPANY" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item[descendant::node()[@ID=$CRM_LISTA_ZASOBOW_ID] and @A_ADM_COMPANY!='' ]/@A_ADM_COMPANY"/>-->
                    <xsl:attribute name="A_ADM_COMPANY" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item/@A_ADM_COMPANY[parent::node()/@ID=//tree_item[descendant::node()[@ID=$CRM_LISTA_ZASOBOW_ID]]/@ID  and parent::node()/@A_ADM_COMPANY!='']"/>
                </set>
            </item>
        </xsl:for-each>
    </xsl:template>

    <!-- szukam lokalizacji bez grupy uprawnien i sugeruje ustawienie na podstawie grupy zasobow -->
    <xsl:template name="TELBOXES">
        <xsl:for-each select="$TELBOXES//item[A_CLASSIFIED='']">
            
            <xsl:variable name="CRM_LISTA_ZASOBOW_ID" select="CRM_LISTA_ZASOBOW_ID"/>
            <item>
                <xsl:attribute name="resource" select="'TELBOXES'"/>
                <xsl:attribute name="ID" select="ID"/>
                <old>
                    <xsl:attribute name="A_CLASSIFIED" select="A_CLASSIFIED"/>
                    <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                </old>
                <set>
                    <xsl:attribute name="A_CLASSIFIED" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item[descendant::node()[@ID=$CRM_LISTA_ZASOBOW_ID] and @A_CLASSIFIED!='' ]/@A_CLASSIFIED"/>
                </set>
            </item>
        </xsl:for-each>
        <xsl:for-each select="$TELBOXES//item[A_ADM_COMPANY='']">
            <xsl:variable name="CRM_LISTA_ZASOBOW_ID" select="CRM_LISTA_ZASOBOW_ID"/>
            <item>
                <xsl:attribute name="resource" select="'TELBOXES'"/>
                <xsl:attribute name="ID" select="ID"/>
                <old>
                    <xsl:attribute name="A_ADM_COMPANY" select="A_ADM_COMPANY"/>
                    <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                </old>
                <set>
                    <xsl:attribute name="A_ADM_COMPANY" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item[descendant::node()[@ID=$CRM_LISTA_ZASOBOW_ID] and @A_ADM_COMPANY!='' ]/@A_ADM_COMPANY"/>
                </set>
            </item>
        </xsl:for-each>
    </xsl:template>

    <!-- szukamy zasobow bez grup uprawnien i sugerujemy na podstawie parenta -->
    <xsl:template name="CRM_LISTA_ZASOBOW">
        <xsl:for-each select="$CRM_LISTA_ZASOBOW//item[A_CLASSIFIED='']">
            <xsl:variable name="ID" select="ID"/>
            <item>
                <xsl:attribute name="resource" select="'CRM_LISTA_ZASOBOW'"/>
                <xsl:attribute name="ID" select="ID"/>
                <old>
                    <xsl:attribute name="A_CLASSIFIED" select="A_CLASSIFIED"/>
                    <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                </old>
                <set>
                    <xsl:attribute name="A_CLASSIFIED" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item/@A_CLASSIFIED[parent::node()/@ID=//tree_item[descendant::node()[@ID=$ID]]/@ID  and parent::node()/@A_CLASSIFIED!='']"/>
                    <!--<xsl:attribute name="A_CLASSIFIED" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item[descendant::node()[@ID=$ID] and @A_CLASSIFIED!='' ]/@A_CLASSIFIED"/>-->
                </set>
            </item>
        </xsl:for-each>
        <xsl:for-each select="$CRM_LISTA_ZASOBOW//item[A_ADM_COMPANY='']">
            <xsl:variable name="ID" select="ID"/>
            <item>
                <xsl:attribute name="resource" select="'CRM_LISTA_ZASOBOW'"/>
                <xsl:attribute name="ID" select="ID"/>
                <old>
                    <xsl:attribute name="A_ADM_COMPANY" select="A_ADM_COMPANY"/>
                    <xsl:attribute name="A_RECORD_UPDATE_DATE" select="A_RECORD_UPDATE_DATE"/>
                </old>
                <set>]
                    <!--<xsl:attribute name="A_ADM_COMPANY" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item[descendant::node()[@ID=$ID] and @A_ADM_COMPANY!='' ]/@A_ADM_COMPANY"/>-->
                    <xsl:attribute name="A_ADM_COMPANY" select="$system_cache__appinfo:transform_cache__CRM_LISTA_ZASOBOW_tree//tree_item/@A_ADM_COMPANY[parent::node()/@ID=//tree_item[descendant::node()[@ID=$ID]]/@ID  and parent::node()/@A_ADM_COMPANY!='']"/>
                </set>
            </item>
        </xsl:for-each>
    </xsl:template>

    

    



   
</xsl:stylesheet>