se/SE/schema/default_db_xml_cache.public/ADMIN_USERS__wyposazenie.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"
    xmlns:system_cache__resources_tree_required_occurs_raport="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_required_occurs_raport"
    xmlns:default_db="http://biuro.biall-net.pl/xmlschema_procesy5/default_db"
    xmlns:default_db__ADMIN_USERS="default_db:ADMIN_USERS"
    xmlns:default_db__CRM_LISTA_ZASOBOW_OFFERS="default_db:CRM_LISTA_ZASOBOW_OFFERS"
    xmlns:default_db__CRM_LISTA_ZASOBOW="default_db:CRM_LISTA_ZASOBOW"
    xmlns:default_db__DEVICES="default_db:DEVICES"
    xmlns:default_db__TELBOXES="default_db:TELBOXES"
    exclude-result-prefixes="xs"
    version="2.0">
    
    <!--funkcje do generowania umow o prace 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:import href="resources_tree_required_occurs_raport.xsl"/>
    <xsl:import href="CRM_LISTA_ZASOBOW_OFFERS__options.xsl"/>
   
    
    <xsl:variable name="ADMIN_USERS">
        <xsl:call-template name="import_resource_table_xml_from_api">
            <xsl:with-param name="cache" select="'read'"/>
            <xsl:with-param name="resource" select="'ADMIN_USERS'"/>
        </xsl:call-template>
    </xsl:variable>
    
    <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="system_cache__appinfo:_build_resources_tree_with_instances_refs">
        <xsl:call-template name="system_cache__appinfo:_build_resources_tree_with_instances_refs"/>
    </xsl:variable>
    
    <xsl:variable name="CRM_LISTA_ZASOBOW">
        <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:template name="main">
        <!--<xsl:variable name="test">
            <ADMIN_USERS>
                <ID>9</ID>
                <ADM_ACCOUNT>a.binder</ADM_ACCOUNT>
                <ADM_NAME/>
                <ADM_PHONE/>
                <ADM_ADDRESS_CITY/>
                <ADM_ADDRESS_STREET/>
                <ADM_ADDRESS_HOUSE/>
            </ADMIN_USERS>
        </xsl:variable>-->
        
        <xsl:apply-templates mode="default_db:ADMIN_USERS" select="$ADMIN_USERS//item[ID='11' or ID='9' or ADM_ACCOUNT='remiszewskim' or ADM_ACCOUNT='crash' or ID='4889' or ID='5141' or ADM_ACCOUNT='mateusz.klimek' or ID='5318' or ADM_ACCOUNT='dojlidom' ]"/>
        <!--<xsl:result-document href="../default_db.instance.xml/transformed/ADMIN_USERS__wyposazenie_all.html"> 
            <xsl:call-template name="wyposazenie_all"/>
        </xsl:result-document>-->
        <xsl:result-document href="../default_db.instance.xml/transformed/ADMIN_USERS__wyposazenie__allowed_functions.xml">
            <default_db__ADMIN_USERS:allowed_functions>
                <xsl:apply-templates mode="default_db__ADMIN_USERS:allowed_functions" select="$ADMIN_USERS//item[ID='11' or ID='9' or ADM_ACCOUNT='remiszewskim' or ADM_ACCOUNT='crash' or ID='4889']"/>
            </default_db__ADMIN_USERS:allowed_functions>
        </xsl:result-document>
        
        
    </xsl:template>
    
    <!-- funkcja do wyzwolenia podczas chodzenia przez GUI po tabeli rekordow w ADMIN_USERS wykrywajaca dla ktorych rekordow mozna wyzwolic jakas funkcje -->
    <xsl:template match="node()" mode="default_db__ADMIN_USERS:allowed_functions">
        <xsl:choose>
            <xsl:when test="ID and A_STATUS!='DELETED'">
                <system_cache__appinfo:apply-templates>
                    <xsl:attribute name="mode" select="'default_db:ADMIN_USERS'"/>
                    <xsl:attribute name="output" select="'html'"/>
                    <xsl:attribute name="description" select="'wyposazenie pracownika widok html'"/>
                    <source_record>
                        <xsl:copy-of select="ID"/>
                    </source_record>
                </system_cache__appinfo:apply-templates>
            </xsl:when>
        </xsl:choose>
        <!-- TODO jakos by to ograniczyc/podlaczyc do widoku biezacej listy elementow - czyli musze wiedziec, ze mam wiecej elementow na ekranie -czyli jakis count(node())&gt;1 ? -->
        <system_cache__appinfo:call-template>
            <xsl:attribute name="name" select="'wyposazenie_all'"/>
            <xsl:attribute name="output" select="'html'"/>
            <xsl:attribute name="description" select="'wyposazenie wszystkich pracownikow widok html'"/>
            <source_record>
                <xsl:comment>TODO tutaj jakas lista rekordow lub filtr dla ktorego to jest dostepne jako caly ekran lub kawalek</xsl:comment>
            </source_record>
        </system_cache__appinfo:call-template>
    </xsl:template>
    
    
    <xsl:template match="node()" mode="default_db:ADMIN_USERS">
        <xsl:variable name="ADMIN_USERS_node" select="current()"/>
            <xsl:variable name="ADMIN_USERS__wyposazenie">
                <xsl:call-template name="wyposazenie_i_braki_for_user">
                    <xsl:with-param name="ADMIN_USERS_node" select="$ADMIN_USERS_node"/>
                </xsl:call-template>
            </xsl:variable>
        <xsl:result-document href="{concat('../default_db.instance.xml/transformed/ADMIN_USERS__wyposazenie_',$ADMIN_USERS_node/ID,'.xml')}">
            <xsl:copy-of select="$ADMIN_USERS__wyposazenie"></xsl:copy-of>
        </xsl:result-document>
        <xsl:apply-templates mode="wyposazenie_html" select="$ADMIN_USERS__wyposazenie">
            <xsl:with-param name="ADMIN_USERS_node" select="$ADMIN_USERS_node"/>
        </xsl:apply-templates>        
    </xsl:template>
    
    <xsl:template name="wyposazenie_i_braki_for_user">
        <xsl:param name="ADMIN_USERS_node" required="yes"/>
        <ADMIN_USERS__wyposazenie>
            <xsl:attribute name="ADMIN_USERS_ID" select="$ADMIN_USERS_node/ID"></xsl:attribute>
            <wyposazenie>
                <xsl:for-each select="$system_cache__appinfo:_build_resources_tree_with_instances_refs//node()[ name()!='ERROR_NOT_ENOUGH' and @RESOURCE  and @TREE_ADMIN_USERS_ID=$ADMIN_USERS_node/ID ]  ">
                    <xsl:copy-of select="."/>
                </xsl:for-each>
            </wyposazenie>
            <braki>
                <xsl:for-each-group select="$system_cache__appinfo:_build_resources_tree_with_instances_refs//node()[ name()='ERROR_NOT_ENOUGH' and @TREE_ADMIN_USERS_ID=$ADMIN_USERS_node/ID ]" group-by="@ID" >
                    <ERROR_NOT_ENOUGH>
                        <xsl:for-each select="@*">
                            <xsl:attribute name="{name()}" select="."/>
                        </xsl:for-each>
                        <xsl:copy-of select="DESC"/>
                             <xsl:call-template name="default_db__CRM_LISTA_ZASOBOW_OFFERS:show_offers_for_resource">
                                 <xsl:with-param name="default_db__CRM_LISTA_ZASOBOW:ID" select="@ID"/>
                             </xsl:call-template>
                    </ERROR_NOT_ENOUGH>
                </xsl:for-each-group>
            </braki>            
            <errors_all_structures>
                <!-- wykrycie bledow w postaci nie odnalezionych numerow INSTANCES[@ID], podczas gdy ich RESOURCE_ID bylo w drzewie-->
                <DEVICES>
                    <xsl:for-each select="$DEVICES//item">
                        <xsl:variable name="ID" select="ID"/>
                        <xsl:variable name="CRM_LISTA_ZASOBOW_ID" select="CRM_LISTA_ZASOBOW_ID"/>
                        <xsl:choose>
                            <xsl:when test="CRM_LISTA_ZASOBOW_ID=''">
                                <ERROR_NOT_SET_RESOURCE_ID>
                                    <xsl:attribute name="ID" select="$ID"/>                                
                                </ERROR_NOT_SET_RESOURCE_ID>
                            </xsl:when>
                            <xsl:when test="$system_cache__appinfo:_build_resources_tree_with_instances_refs//DEVICES[@RESOURCE=$CRM_LISTA_ZASOBOW_ID]">
                                <xsl:choose>
                                    <xsl:when test="$system_cache__appinfo:_build_resources_tree_with_instances_refs//DEVICES[@RESOURCE=$CRM_LISTA_ZASOBOW_ID and @ID=$ID]">
                                        <!--  <OK_INSTANCE_FOUND>
                                        <xsl:attribute name="ID" select="$ID"></xsl:attribute>
                                    </OK_INSTANCE_FOUND>-->
                                    </xsl:when>
                                    <xsl:otherwise>
                                        <ERROR_INSTANCE_NOT_FOUND_IN_TREE>
                                            <xsl:attribute name="ID" select="$ID"/> 
                                            <xsl:attribute name="CRM_LISTA_ZASOBOW_ID" select="$CRM_LISTA_ZASOBOW_ID"/>
                                            <xsl:attribute name="TYPE" select="$CRM_LISTA_ZASOBOW//item[ID=$CRM_LISTA_ZASOBOW_ID]/TYPE"/>
                                            <xsl:attribute name="A_STATUS" select="$CRM_LISTA_ZASOBOW//item[ID=$CRM_LISTA_ZASOBOW_ID]/A_STATUS"/>
                                            <xsl:choose>
                                                <xsl:when test="$system_cache__appinfo:_build_resources_tree_with_instances_refs//node()[@ID=$CRM_LISTA_ZASOBOW_ID and name()='ERROR_NOT_ENOUGH']/@TREE_ADMIN_USERS_ID">
                                                    <xsl:variable name="TREE_ADMIN_USERS_ID" select="string-join($system_cache__appinfo:_build_resources_tree_with_instances_refs//node()[@ID=$CRM_LISTA_ZASOBOW_ID and name()='ERROR_NOT_ENOUGH']/@TREE_ADMIN_USERS_ID,' ')"/>
                                                    <xsl:attribute name="TREE_ADMIN_USERS_ID" select="distinct-values(tokenize($TREE_ADMIN_USERS_ID,' '))"/>
                                                </xsl:when>
                                                <xsl:otherwise>
                                                    <xsl:variable name="TREE_ADMIN_USERS_ID" select="string-join($system_cache__appinfo:_build_resources_tree_with_instances_refs//node()[@RESOURCE=$CRM_LISTA_ZASOBOW_ID and name()='DEVICES']/@TREE_ADMIN_USERS_ID,' ')"/>
                                                    <xsl:attribute name="TREE_ADMIN_USERS_ID" select="distinct-values(tokenize($TREE_ADMIN_USERS_ID,' '))"/>
                                                </xsl:otherwise>
                                            </xsl:choose>
                                            <DESC><xsl:value-of select="$CRM_LISTA_ZASOBOW//item[ID=$CRM_LISTA_ZASOBOW_ID]/DESC"/></DESC> 
                                            <xsl:copy-of select="T_DEVICE_TYPE"/>
                                            <xsl:copy-of select="T_DEVICE_INFO"/>
                                            <xsl:copy-of select="T_DEVICE_SERIAL"/>
                                        </ERROR_INSTANCE_NOT_FOUND_IN_TREE>
                                    </xsl:otherwise>
                                </xsl:choose>
                            </xsl:when>
                        </xsl:choose>
                    </xsl:for-each>
                </DEVICES>
                <TELBOXES>
                    <xsl:for-each select="$TELBOXES//item">
                        <xsl:variable name="ID" select="ID"/>
                        <xsl:variable name="CRM_LISTA_ZASOBOW_ID" select="CRM_LISTA_ZASOBOW_ID"/>
                        <xsl:choose>
                            <xsl:when test="CRM_LISTA_ZASOBOW_ID=''">
                                <ERROR_NOT_SET_RESOURCE_ID>
                                    <xsl:attribute name="ID" select="$ID"/>                                
                                </ERROR_NOT_SET_RESOURCE_ID>
                            </xsl:when>
                            <xsl:when test="$system_cache__appinfo:_build_resources_tree_with_instances_refs//TELBOXES[@RESOURCE=$CRM_LISTA_ZASOBOW_ID]">
                                <xsl:choose>
                                    <xsl:when test="$system_cache__appinfo:_build_resources_tree_with_instances_refs//TELBOXES[@RESOURCE=$CRM_LISTA_ZASOBOW_ID and @ID=$ID]">
                                        <!--  <OK_INSTANCE_FOUND>
                                        <xsl:attribute name="ID" select="$ID"></xsl:attribute>
                                    </OK_INSTANCE_FOUND>-->
                                    </xsl:when>
                                    <xsl:otherwise>
                                        <ERROR_INSTANCE_NOT_FOUND_IN_TREE>
                                            <xsl:attribute name="ID" select="$ID"/> 
                                            <xsl:attribute name="CRM_LISTA_ZASOBOW_ID" select="$CRM_LISTA_ZASOBOW_ID"/>
                                            <xsl:attribute name="TYPE" select="$CRM_LISTA_ZASOBOW//item[ID=$CRM_LISTA_ZASOBOW_ID]/TYPE"/>
                                            <xsl:attribute name="A_STATUS" select="$CRM_LISTA_ZASOBOW//item[ID=$CRM_LISTA_ZASOBOW_ID]/A_STATUS"/>
                                            <xsl:choose>
                                                <xsl:when test="$system_cache__appinfo:_build_resources_tree_with_instances_refs//node()[@ID=$CRM_LISTA_ZASOBOW_ID and name()='ERROR_NOT_ENOUGH']/@TREE_ADMIN_USERS_ID">
                                                    <xsl:variable name="TREE_ADMIN_USERS_ID" select="string-join($system_cache__appinfo:_build_resources_tree_with_instances_refs//node()[@ID=$CRM_LISTA_ZASOBOW_ID and name()='ERROR_NOT_ENOUGH']/@TREE_ADMIN_USERS_ID,' ')"/>
                                                    <xsl:attribute name="TREE_ADMIN_USERS_ID" select="distinct-values(tokenize($TREE_ADMIN_USERS_ID,' '))"/>
                                                </xsl:when>
                                                <xsl:otherwise>
                                                    <xsl:variable name="TREE_ADMIN_USERS_ID" select="string-join($system_cache__appinfo:_build_resources_tree_with_instances_refs//node()[@RESOURCE=$CRM_LISTA_ZASOBOW_ID and name()='DEVICES']/@TREE_ADMIN_USERS_ID,' ')"/>
                                                    <xsl:attribute name="TREE_ADMIN_USERS_ID" select="distinct-values(tokenize($TREE_ADMIN_USERS_ID,' '))"/>
                                                </xsl:otherwise>
                                            </xsl:choose>
                                            <DESC><xsl:value-of select="$CRM_LISTA_ZASOBOW//item[ID=$CRM_LISTA_ZASOBOW_ID]/DESC"/></DESC> 
                                            <xsl:copy-of select="T_TELBOX_NAME"/>
                                        </ERROR_INSTANCE_NOT_FOUND_IN_TREE>
                                    </xsl:otherwise>
                                </xsl:choose>
                            </xsl:when>
                        </xsl:choose>
                    </xsl:for-each>
                </TELBOXES>
            </errors_all_structures>
            <braki_all_structures>
                <xsl:for-each-group select="$system_cache__appinfo:_build_resources_tree_with_instances_refs//node()[ name()='ERROR_NOT_ENOUGH']" group-by="@ID" >
                    <ERROR_NOT_ENOUGH>
                        <xsl:for-each select="@*">
                            <xsl:attribute name="{name()}" select="."/>
                        </xsl:for-each>
                        <xsl:copy-of select="DESC"/>
                        <xsl:call-template name="default_db__CRM_LISTA_ZASOBOW_OFFERS:show_offers_for_resource">
                             <xsl:with-param name="default_db__CRM_LISTA_ZASOBOW:ID" select="@ID"/>
                        </xsl:call-template>
                    </ERROR_NOT_ENOUGH>
                </xsl:for-each-group>
            </braki_all_structures>
        </ADMIN_USERS__wyposazenie>
    </xsl:template>
    
    
    
    <xsl:template name="wyposazenie_all">
        <html>
            <head>Wyposazenia</head>
            <body>
                <xsl:for-each select="$ADMIN_USERS//item[A_STATUS='NORMAL' and EMPLOYEE_TYPE='Pracownik']">
                    <xsl:variable name="ADMIN_USERS_node" select="current()"/>
                    <xsl:variable name="ADMIN_USERS__wyposazenie">
                        <xsl:call-template name="wyposazenie_i_braki_for_user">
                            <xsl:with-param name="ADMIN_USERS_node" select="$ADMIN_USERS_node"/>
                        </xsl:call-template>
                    </xsl:variable>
                   <!-- <xsl:result-document href="{concat('../default_db.instance.xml/transformed/ADMIN_USERS__wyposazenie_all_',$ADMIN_USERS_node/ID,'.xml')}">
                       <xsl:copy-of select="$ADMIN_USERS__wyposazenie"></xsl:copy-of>
                     </xsl:result-document>-->
                    <xsl:apply-templates mode="wyposazenie_inside" select="$ADMIN_USERS__wyposazenie">
                        <xsl:with-param name="ADMIN_USERS_node" select="$ADMIN_USERS_node"/>
                    </xsl:apply-templates>
                </xsl:for-each>
            </body>
        </html>
    </xsl:template>
    
    
    <xsl:template match="node()" mode="wyposazenie_inside">
        <xsl:param name="ADMIN_USERS_node"/>
        Wyposażenie aktualnie przydzielone: dla <xsl:value-of select="$ADMIN_USERS_node/ADM_NAME"/> (ID:<xsl:value-of select="$ADMIN_USERS_node/ID"/>/Login:<xsl:value-of select="$ADMIN_USERS_node/ADM_ACCOUNT"/>)
        <table border="1" cellpadding="2" cellspacing="2" width="100%">
            <tr>
                <th>Typ</th>
                <th>Nr zasobu</th>
                <th>Nazwa</th>
                <th>Opis</th>
                <th>Producent</th>
                <th>Wartość</th>
                <th>Właściciel</th>
                <th>Oznaczenie</th>
            </tr>
            <xsl:for-each-group select="/ADMIN_USERS__wyposazenie/wyposazenie//node()[@RESOURCE and @TREE_ADMIN_USERS_ID=$ADMIN_USERS_node/ID and (name()!='ADMIN_USERS' or @source!='ALIAS') ]" group-by="concat(@ID,'-',@RESOURCE)">
                <tr>
                    <td><xsl:value-of select="name()"/></td>
                    <td><xsl:value-of select="@RESOURCE"/></td>
                    <td><xsl:value-of select="@ID"/></td>
                    <td><xsl:value-of select="DESC"/></td>
                    <td>
                        <xsl:if test="T_DEVICE_TYPE">&#160;<xsl:value-of select="T_DEVICE_TYPE"/></xsl:if>
                        <xsl:if test="T_DEVICE_INFO">&#160;<xsl:value-of select="T_DEVICE_INFO"/></xsl:if>
                        &#160;<xsl:value-of select="@A_STATUS"/>
                        <xsl:if test="ADM_PHONE"><pre> tel: <xsl:value-of select="ADM_PHONE"/></pre></xsl:if>
                    </td>
                    <td><xsl:value-of select="T_PRODUCER"/></td>
                    <td><xsl:value-of select="F_BILL_COST"/></td>
                    <td><xsl:value-of select="T_OWNER"/></td>
                    <td><xsl:value-of select="T_DEVICE_SERIAL"/>
                        &#160;<xsl:value-of select="T_TELBOX_NAME"/>
                    </td>
                </tr>
            </xsl:for-each-group>
        </table>
        <br/>
        Wyposażenie aktualnie brakujące:
        <table border="1" cellpadding="2" cellspacing="2"  width="100%">
            <tr>
                <th>Typ</th>
                <th>Nr zasobu</th>
                <th>Ile brakuje</th>
                <th>Nazwa</th>                        
            </tr>
            <xsl:for-each select="/ADMIN_USERS__wyposazenie/braki//ERROR_NOT_ENOUGH[@TREE_ADMIN_USERS_ID=$ADMIN_USERS_node/ID]">
                <tr>
                    <td><xsl:value-of select="@TYPE"/></td>
                    <td><xsl:value-of select="@ID"/></td>
                    <td><xsl:value-of select="@minOccurs - @system_cache__resources_tree_required_occurs_raport:Occurs"/></td>
                    <td><xsl:value-of select="DESC"/></td>
                    <td></td>
                </tr>
            </xsl:for-each>
        </table>
        <hr>
        <br>
        </br>
        </hr>
    </xsl:template>
    
    
    <xsl:template match="node()" mode="wyposazenie_html">
        <xsl:param name="ADMIN_USERS_node"/>
        <xsl:result-document href="{concat('../default_db.instance.xml/transformed/ADMIN_USERS__wyposazenie_',$ADMIN_USERS_node/ID,'.html')}">
        <html>
            <head>Wykaz wyposazenie dla pracownika <xsl:value-of select="$ADMIN_USERS_node/ADM_NAME"/> (ID:<xsl:value-of select="$ADMIN_USERS_node/ID"/>/Login:<xsl:value-of select="$ADMIN_USERS_node/ADM_ACCOUNT"/>)</head>
            <body>
                Wyposażenie aktualnie przydzielone:
                <table border="1" cellpadding="2" cellspacing="2" width="100%">
                   <tr>
                       <th>Typ</th>
                       <th>Nr zasobu</th>
                       <th>ID</th>
                       <th>Nazwa</th>
                       <th>Opis</th>
                       <th>Producent</th>
                       <th>Wartość</th>
                       <th>Właściciel</th>
                       <th>Oznaczenie</th>
                   </tr>
                    <xsl:for-each-group select="/ADMIN_USERS__wyposazenie/wyposazenie//node()[@RESOURCE and @TREE_ADMIN_USERS_ID=$ADMIN_USERS_node/ID and (name()!='ADMIN_USERS') ]" group-by="concat(@ID,'-',@RESOURCE)">
                       <tr>
                           <td><xsl:value-of select="name()"/></td>
                           <td><xsl:value-of select="@RESOURCE"/></td>
                           <td><xsl:value-of select="@ID"/></td>
                           <td><xsl:value-of select="DESC"/></td>
                           <td>
                               <xsl:if test="T_DEVICE_TYPE">&#160;<xsl:value-of select="T_DEVICE_TYPE"/></xsl:if>
                               <xsl:if test="T_DEVICE_INFO">&#160;<xsl:value-of select="T_DEVICE_INFO"/></xsl:if>
                               &#160;<xsl:value-of select="@A_STATUS"/><pre> </pre>
                               <xsl:if test="ADM_PHONE"><pre> tel: <xsl:value-of select="ADM_PHONE"/></pre></xsl:if>
                           </td>
                           <td><xsl:value-of select="T_PRODUCER"/></td>
                           <td><xsl:value-of select="F_BILL_COST"/></td>
                           <td><xsl:value-of select="T_OWNER"/></td>
                           <td><xsl:value-of select="T_DEVICE_SERIAL"/>
                               &#160;<xsl:value-of select="T_TELBOX_NAME"/>
                           </td>
                       </tr>
                   </xsl:for-each-group>
                    
                        <tr>
                            <td/>
                            <td/>
                            <td/>
                            <td>Suma kosztów wyposazenia</td>
                            <td/>
                            <td/>
                            <td><!--<xsl:value-of select="sum(/ADMIN_USERS__wyposazenie/wyposazenie//node()[@RESOURCE and @TREE_ADMIN_USERS_ID=$ADMIN_USERS_node/ID and (name()!='ADMIN_USERS' or @source!='ALIAS') and F_BILL_COST&gt;0]/F_BILL_COST)"/>-->
                                <xsl:variable name="suma">
                                    <xsl:for-each-group select="/ADMIN_USERS__wyposazenie/wyposazenie//node()[@RESOURCE and @TREE_ADMIN_USERS_ID=$ADMIN_USERS_node/ID and (name()!='ADMIN_USERS' or @source!='ALIAS') and F_BILL_COST&gt;0]/F_BILL_COST" group-by="concat(../@ID,../@RESOURCE)">
                                        <xsl:copy-of select="."/>
                                    </xsl:for-each-group>
                                </xsl:variable>
                                <xsl:value-of select="sum($suma/F_BILL_COST)"/>
                            </td>
                            <td/>
                            <td/>
                        </tr>
                    
                </table>
                
                Podległy personel:
                <table border="1" cellpadding="2" cellspacing="2" width="100%">
                    <tr>
                        <th>Typ</th>
                        <th>Nr zasobu</th>
                        <th>ID</th>
                        <th>Nazwa</th>
                        <th>Opis</th>
                        <th>Producent</th>
                        <th>Wartość</th>
                        <th>Właściciel</th>
                        <th>Oznaczenie</th>
                    </tr>
                    <xsl:for-each-group select="/ADMIN_USERS__wyposazenie/wyposazenie//node()[@RESOURCE and @TREE_ADMIN_USERS_ID=$ADMIN_USERS_node/ID and (name()='ADMIN_USERS' and @source!='ALIAS') ]" group-by="concat(@ID,'-',@RESOURCE)">
                        <tr>
                            <td><xsl:value-of select="name()"/></td>
                            <td><xsl:value-of select="@RESOURCE"/></td>
                            <td><xsl:value-of select="@ID"/></td>
                            <td><xsl:value-of select="DESC"/></td>
                            <td>
                                <xsl:if test="T_DEVICE_TYPE">&#160;<xsl:value-of select="T_DEVICE_TYPE"/></xsl:if>
                                <xsl:if test="T_DEVICE_INFO">&#160;<xsl:value-of select="T_DEVICE_INFO"/></xsl:if>
                                &#160;<xsl:value-of select="@A_STATUS"/><pre> </pre>
                                <xsl:if test="ADM_PHONE"><pre> tel: <xsl:value-of select="ADM_PHONE"/></pre></xsl:if>
                            </td>
                            <td><xsl:value-of select="T_PRODUCER"/></td>
                            <td><xsl:value-of select="F_BILL_COST"/></td>
                            <td><xsl:value-of select="T_OWNER"/></td>
                            <td><xsl:value-of select="T_DEVICE_SERIAL"/>
                                &#160;<xsl:value-of select="T_TELBOX_NAME"/>
                            </td>
                        </tr>
                    </xsl:for-each-group>
                </table>
               
                
                
                <br/>
                Wyposażenie aktualnie brakujące:
                <table border="1" cellpadding="2" cellspacing="2"  width="100%">
                    <tr>
                        <th>Typ</th>
                        <th>Nr zasobu</th>
                        <th>Ile brakuje</th>
                        <th>Nazwa</th> 
                        <th>Możliwość pobrania z</th> 
                        <th>Możliwość zamówienia z</th>
                    </tr>
                    <xsl:for-each select="/ADMIN_USERS__wyposazenie/braki//ERROR_NOT_ENOUGH[@TREE_ADMIN_USERS_ID=$ADMIN_USERS_node/ID]">
                        <tr>
                            <td><xsl:value-of select="@TYPE"/></td>
                            <td><xsl:value-of select="@ID"/></td>
                            <td><xsl:value-of select="@minOccurs - @system_cache__resources_tree_required_occurs_raport:Occurs"/></td>
                            <td><xsl:value-of select="DESC"/></td>
                            <td>    
                               
                                <xsl:for-each select="default_db__CRM_LISTA_ZASOBOW_OFFERS:show_offers_for_resource/INSTANCES/PARENTS/RESOURCE/node()[@ID and @A_STATUS!='OFF_HARD' and @A_STATUS!='DELETED' and @A_STATUS!='WAITING']">
                                    Źródła nadrzędne<br/><font size="-3">
                                    typ:<xsl:value-of select="name()"/>;<br/>
                                    RESOURCE:<xsl:value-of select="@RESOURCE"/>;<br/>
                                    ID:<xsl:value-of select="@ID"/>;<br/>
                                    STATUS:<xsl:value-of select="@A_STATUS"/>;<br/>
                                        <xsl:for-each select="child::*">
                                            <xsl:value-of select="name()"/>:<xsl:value-of select="text()"/><br/>
                                        </xsl:for-each>
                                    </font>
                                    <hr/>
                                </xsl:for-each>
                               
                                <xsl:for-each select="default_db__CRM_LISTA_ZASOBOW_OFFERS:show_offers_for_resource/INSTANCES/SIBLING/RESOURCE/node()[@ID and @A_STATUS!='OFF_HARD' and @A_STATUS!='DELETED' and @A_STATUS!='WAITING']">
                                        Źródła równorzędne<br/><font size="-3">
                                        typ:<xsl:value-of select="name()"/>;<br/>
                                        RESOURCE:<xsl:value-of select="@RESOURCE"/>;<br/>
                                        ID:<xsl:value-of select="@ID"/>;<br/>
                                        STATUS:<xsl:value-of select="@A_STATUS"/>;<br/>
                                            <xsl:for-each select="child::*">
                                                <xsl:value-of select="name()"/>:<xsl:value-of select="text()"/><br/>
                                            </xsl:for-each>
                                    </font>
                                    <hr/>
                                </xsl:for-each>
                                
                                <xsl:for-each select="default_db__CRM_LISTA_ZASOBOW_OFFERS:show_offers_for_resource/INSTANCES/CHILDS/RESOURCE/node()[@ID and @A_STATUS!='OFF_HARD' and @A_STATUS!='DELETED' and @A_STATUS!='WAITING']">
                                        Źródła dziedziczące<br/><font size="-3">
                                        typ:<xsl:value-of select="name()"/>;<br/>
                                        RESOURCE:<xsl:value-of select="@RESOURCE"/>;<br/>
                                        ID:<xsl:value-of select="@ID"/>;<br/>
                                        STATUS:<xsl:value-of select="@A_STATUS"/>;<br/>
                                            <xsl:for-each select="child::*">
                                                <xsl:value-of select="name()"/>:<xsl:value-of select="text()"/><br/>
                                            </xsl:for-each>
                                    </font>
                                    <hr/>
                                </xsl:for-each>
                            </td>
                            <td>
                                <xsl:for-each select="default_db__CRM_LISTA_ZASOBOW_OFFERS:show_offers_for_resource/OFFERS/PARENTS/node()[@ID and @A_STATUS!='OFF_HARD' and @A_STATUS!='DELETED' and @A_STATUS!='WAITING']">
                                    <font size="-3">
                                        Oferta/ID:<xsl:value-of select="@ID"/>;<br/>
                                        Dostawca:<xsl:copy-of select="COMPANIES_ID"/>;<br/>
                                        STATUS:<xsl:value-of select="@A_STATUS"/>;<br/>
                                        Oferta/Przelicznik/min.il.:<xsl:copy-of select="OFFER_UNIT_TYPE"/>/<xsl:copy-of select="OFFER_UNIT_TO_RESOURCE_UNIT_RATIO"/>/<xsl:copy-of select="OFFER_MIN_QTY"/>;<br/>
                                        Cena[dost]/[zasob]:<xsl:copy-of select="OFFER_PRICE_PER_UNIT"/>/<xsl:copy-of select="OFFER_PRICE_PER_RESOURCE_UNIT"/>;<br/>
                                        jakość:<xsl:copy-of select="OFFERED_QUALITY"/>
                                    </font>
                                    <hr/>
                                </xsl:for-each>
                                
                            </td>
                        </tr>
                    </xsl:for-each>
                </table>
                <br>
                    Niewłaściwie przydzielone do struktury urządzenia podlegające strukturalnie pod pracownika:
                </br>
                <table border="1" cellpadding="2" cellspacing="2"  width="100%">
                    <tr>
                        <th>Typ</th>
                        <th>Nr zasobu</th>
                        <th>Nr rekordu w urządzeniach</th>
                        <th>Nazwa</th>                        
                    </tr>
                    <xsl:for-each select="/ADMIN_USERS__wyposazenie/errors_all_structures/DEVICES/ERROR_INSTANCE_NOT_FOUND_IN_TREE[contains(concat(' ',@TREE_ADMIN_USERS_ID,' ') , concat(' ',$ADMIN_USERS_node/ID,' '))]">
                        <xsl:variable name="CRM_LISTA_ZASOBOW_ID" select="@CRM_LISTA_ZASOBOW_ID"/>
                        <tr>
                            <td><xsl:value-of select="@TYPE"/></td>
                            <td><xsl:value-of select="@CRM_LISTA_ZASOBOW_ID"/></td>
                            <td><xsl:value-of select="@ID"/></td>
                            <td> <xsl:copy-of select="T_DEVICE_TYPE"/>
                                <xsl:copy-of select="T_DEVICE_INFO"/>
                                <xsl:copy-of select="T_DEVICE_SERIAL"/></td>
                            <td></td>
                        </tr>
                    </xsl:for-each>
                </table>
                <br>
                Brakujące elementy w całej strukturze firmy
                </br>
                <table border="1" cellpadding="2" cellspacing="2"  width="100%">
                    <tr>
                    <th>Typ</th>
                    <th>Nr zasobu</th>
                    <th>Ile jest</th>
                    <th>Ile ma byc</th>
                    <th>Ile brakuje</th>
                    <th>Nazwa</th> 
                    <th>Możliwość pobrania</th>
                    </tr>
                    <xsl:for-each-group select="/ADMIN_USERS__wyposazenie/braki_all_structures//ERROR_NOT_ENOUGH[@TYPE='URZADZENIE' or @TYPE='DOSTEP-ZAMEK-ELEKTRONICZNY' or @TYPE='OZNACZENIE_LOKALIZACJI' or @TYPE='APLIKACJA' or @TYPE='SOFTWARE' or @TYPE='ALARM-SATEL' or @TYPE='SZAFA' or @TYPE='SEJF' or @TYPE='SEGREGATOR' or @TYPE='KUWETA' or @TYPE='NARZEDZIE' or @TYPE='DOSTEP-KLUCZ'  or @TYPE='DOSTEP-KARTA' or @TYPE='DOSTEP-ZAMEK' or @TYPE='MATERIAL_REKLAMOWY' or @TYPE='SERWER' or @TYPE='MATERIAL_EKSPLOATACYJNY' or @TYPE='PIECZATKA'  or @TYPE='PLYTA_CD' or @TYPE='KOMPUTER' or @TYPE='URZADZENIA_I_OZNACZENIA_BHP']" group-by="@ID">
                        <tr>
                            <td><xsl:value-of select="@TYPE"/></td>
                            <td><xsl:value-of select="@ID"/></td>
                            <td><xsl:value-of select="@system_cache__resources_tree_required_occurs_raport:Occurs"/></td>
                            <td><xsl:value-of select="@minOccurs"/></td>
                            <td><xsl:value-of select="@minOccurs - @system_cache__resources_tree_required_occurs_raport:Occurs"/></td>
                            <td><xsl:value-of select="DESC"/></td>
                            <td>
                                
                                
                                <xsl:for-each select="default_db__CRM_LISTA_ZASOBOW_OFFERS:show_offers_for_resource/INSTANCES/PARENTS/RESOURCE/node()[@ID and @A_STATUS!='OFF_HARD' and @A_STATUS!='DELETED' and @A_STATUS!='WAITING']">
                                    Źródło: nadrzędne<br/>
                                    <font size="-3">
                                        typ:<xsl:value-of select="name()"/>;<br/>
                                        RESOURCE:<xsl:value-of select="@RESOURCE"/>;<br/>
                                        ID:<xsl:value-of select="@ID"/>;<br/>
                                        STATUS:<xsl:value-of select="@A_STATUS"/>;<br/>
                                        T_DEVICE_TYPE:<xsl:copy-of select="T_DEVICE_TYPE"/>;<br/>
                                        T_DEVICE_INFO:<xsl:copy-of select="T_DEVICE_INFO"/>;<br/>
                                        T_DEVICE_SERIAL:<xsl:copy-of select="T_DEVICE_SERIAL"/>
                                    </font>
                                    <hr/>
                                </xsl:for-each>
                               
                                <xsl:for-each select="default_db__CRM_LISTA_ZASOBOW_OFFERS:show_offers_for_resource/INSTANCES/SIBLING/RESOURCE/node()[@ID and @A_STATUS!='OFF_HARD' and @A_STATUS!='DELETED' and @A_STATUS!='WAITING']">
                                    Źródła równorzędne<br/>
                                    <font size="-3">
                                        typ:<xsl:value-of select="name()"/>;<br/>
                                        RESOURCE:<xsl:value-of select="@RESOURCE"/>;<br/>
                                        ID:<xsl:value-of select="@ID"/>;<br/>
                                        STATUS:<xsl:value-of select="@A_STATUS"/>;<br/>
                                        T_DEVICE_TYPE:<xsl:copy-of select="T_DEVICE_TYPE"/>;<br/>
                                        T_DEVICE_INFO:<xsl:copy-of select="T_DEVICE_INFO"/>;<br/>
                                        T_DEVICE_SERIAL:<xsl:copy-of select="T_DEVICE_SERIAL"/>
                                    </font>
                                    <hr/>
                                </xsl:for-each>
                                
                                <xsl:for-each select="default_db__CRM_LISTA_ZASOBOW_OFFERS:show_offers_for_resource/INSTANCES/CHILDS/RESOURCE/node()[@ID and @A_STATUS!='OFF_HARD' and @A_STATUS!='DELETED' and @A_STATUS!='WAITING']">
                                    Źródła dziedziczące<br/><font size="-3">
                                        typ:<xsl:value-of select="name()"/>;<br/>
                                        RESOURCE:<xsl:value-of select="@RESOURCE"/>;<br/>
                                        ID:<xsl:value-of select="@ID"/>;<br/>
                                        STATUS:<xsl:value-of select="@A_STATUS"/>;<br/>
                                        T_DEVICE_TYPE:<xsl:copy-of select="T_DEVICE_TYPE"/>;<br/>
                                        T_DEVICE_INFO:<xsl:copy-of select="T_DEVICE_INFO"/>;<br/>
                                        T_DEVICE_SERIAL:<xsl:copy-of select="T_DEVICE_SERIAL"/>
                                    </font>
                                    <hr/>
                                </xsl:for-each>
 
                            </td>
                        </tr>
                    </xsl:for-each-group>
                </table>
            </body>
        </html>
        </xsl:result-document>
        
    </xsl:template>
    
    
  
    
    
    
    
    
    
    
</xsl:stylesheet>