--- /dev/null
+<?xml version="1.0" encoding="ISO-8859-1"?>
+<!DOCTYPE xsl:stylesheet [
+<!ENTITY nbsp " ">
+<!ENTITY egrave "è">
+<!ENTITY euro "€">
+<!ENTITY agrave "à">
+<!ENTITY eacute "é">
+]>
+<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="http://www.xemelios.org/namespaces#cg-1.0" xmlns:n="http://www.xemelios.org/namespaces#cg-1.0" xmlns:added="http://projets.admisource.gouv.fr/xemelios/namespaces#added" version="2.0">
+ <!-- Paramètres de sortie -->
+ <xsl:character-map name="accents">
+ <xsl:output-character character="à" string="&#224;"/>
+ <xsl:output-character character="é" string="&#233;"/>
+ <xsl:output-character character="è" string="&#232;"/>
+ <xsl:output-character character="ê" string="&#234;"/>
+ <xsl:output-character character="ë" string="&#235;"/>
+ <xsl:output-character character="î" string="&#238;"/>
+ <xsl:output-character character="ï" string="&#239;"/>
+ <xsl:output-character character="ô" string="&#244;"/>
+ <xsl:output-character character="ù" string="&#249;"/>
+ <xsl:output-character character="°" string="&#176;"/>
+ </xsl:character-map>
+ <xsl:output method="xhtml" indent="yes" use-character-maps="accents" encoding="ISO-8859-1"/>
+ <xsl:decimal-format name="decformat" decimal-separator="," grouping-separator=" " digit="#" pattern-separator=";" NaN="NaN" minus-sign="-"/>
+
+ <!-- Inclusion des XSL externes -->
+ <xsl:include href="../../common-xsl/Title.xsl"/>
+ <xsl:include href="../../common-xsl/Style.xsl"/>
+ <xsl:include href="../../common-xsl/Error.xsl"/>
+ <xsl:include href="../../common-xsl/Navigate.xsl"/>
+ <xsl:include href="./common-xsl/Header.xsl"/>
+ <xsl:include href="../../common-xsl/Number.xsl"/><xsl:include href="../../common-xsl/Footer.xsl"/>
+
+ <!-- Paramètres Web -->
+ <xsl:param name="is.web">-1</xsl:param>
+ <xsl:param name="context.path"/>
+
+ <!-- Paramètres d'entrée -->
+ <xsl:param name="show.formulaire"/>
+ <xsl:param name="browser-destination"/>
+
+ <!-- Paramètres d'entrée de la liste de résultat -->
+ <xsl:param name="LibelleBC">0</xsl:param>
+
+ <!-- Paramètres d'erreur -->
+ <xsl:param name="error.message">nomessage</xsl:param>
+
+ <!-- Variables -->
+ <xsl:variable name="page-format" select="paysage"/>
+ <xsl:variable name="NumPage" select="/n:CompteGestion/n:TableauFondsRoulementTresorerie/n:PageTableauFondsRoulementTresorerie/n:Pied/@NumPage"/>
+ <xsl:variable name="isLastPage" select="/n:CompteGestion/n:TableauFondsRoulementTresorerie/n:PageTableauFondsRoulementTresorerie/@added:isLastPage"/>
+ <xsl:variable name="Entete">
+ <xsl:copy-of select="/n:CompteGestion/n:Entete"/>
+ </xsl:variable>
+
+ <!-- pour eviter les sorties parasites de tags non matches -->
+ <xsl:template match="*"/>
+
+ <xsl:template match="/n:CompteGestion">
+ <html>
+ <head>
+ <!--title>Tableau de suivi du fonds de roulement</title-->
+ <xsl:call-template name="title"><xsl:with-param name="Entete" select="//n:Entete"/><xsl:with-param name="etat">Tableau de suivi du fonds de roulement</xsl:with-param></xsl:call-template>
+ <xsl:call-template name="style"/>
+ </head>
+ <body width="100%">
+ <xsl:if test="$error.message!='nomessage'">
+ <xsl:attribute name="onload">javascript:showDialog('<xsl:value-of select="$error.message"/>');</xsl:attribute>
+ </xsl:if>
+ <xsl:call-template name="Error"><!--xsl:with-param name="error.message" select="$error.message"/--></xsl:call-template>
+ <xsl:call-template name="navigate">
+ <xsl:with-param name="docId">cg-colloc</xsl:with-param>
+ <xsl:with-param name="etatId">TableauFondsRoulementTresorerie</xsl:with-param>
+ <xsl:with-param name="elementId">PageTableauFondsRoulementTresorerie</xsl:with-param>
+ <xsl:with-param name="sous.elementId">LigneTableauFondsRoulementTresorerie</xsl:with-param>
+ <xsl:with-param name="NumPage" select="$NumPage"/>
+ <xsl:with-param name="isLastPage" select="$isLastPage"/>
+ <xsl:with-param name="Entete" select="$Entete"/>
+ <xsl:with-param name="show.formulaire" select="$show.formulaire"/>
+ <xsl:with-param name="show.formulaire.compte" select="0"/>
+ <xsl:with-param name="show.depense.recette" select="0"/>
+ <xsl:with-param name="is.web" select="$is.web"/>
+ <xsl:with-param name="context.path" select="$context.path"/>
+ </xsl:call-template>
+ <xsl:call-template name="header">
+ <xsl:with-param name="Entete" select="$Entete"/>
+ <xsl:with-param name="Titre.Plus"><h1>COMPTE FINANCIER <xsl:value-of select="n:TableauFondsRoulementTresorerie/n:PageTableauFondsRoulementTresorerie/n:EnteteTableauFondsRoulement/@Annee"/></h1><h2>RESULTATS</h2><h3>Tableau de variation du fonds de roulement et de la trésorerie</h3></xsl:with-param>
+ </xsl:call-template>
+ <xsl:call-template name="mainTable">
+ <xsl:with-param name="el" select="/n:CompteGestion/n:TableauFondsRoulementTresorerie/n:PageTableauFondsRoulementTresorerie"/>
+ </xsl:call-template>
+ <p>
+ <xsl:call-template name="footer"><xsl:with-param name="num.page" select="$NumPage"/><xsl:with-param name="tracabilite"><xsl:copy-of select="//n:Tracabilite"/></xsl:with-param></xsl:call-template>
+ </p>
+ <xsl:call-template name="navigate">
+ <xsl:with-param name="docId">cg-colloc</xsl:with-param>
+ <xsl:with-param name="etatId">TableauFondsRoulementTresorerie</xsl:with-param>
+ <xsl:with-param name="elementId">PageTableauFondsRoulementTresorerie</xsl:with-param>
+ <xsl:with-param name="sous.elementId">LigneTableauFondsRoulementTresorerie</xsl:with-param>
+ <xsl:with-param name="NumPage" select="$NumPage"/>
+ <xsl:with-param name="isLastPage" select="$isLastPage"/>
+ <xsl:with-param name="Entete" select="$Entete"/>
+ <xsl:with-param name="show.formulaire" select="$show.formulaire"/>
+ <xsl:with-param name="show.formulaire.compte" select="0"/>
+ <xsl:with-param name="show.depense.recette" select="0"/>
+ <xsl:with-param name="is.web" select="$is.web"/>
+ <xsl:with-param name="context.path" select="$context.path"/>
+ </xsl:call-template>
+ </body>
+ </html>
+ </xsl:template>
+
+ <xsl:template name="mainTable">
+ <xsl:param name="el"/>
+ <table width="100%" id="main" class="bordered">
+ <colgroup>
+ <col width="40%"/>
+ <col width="15%"/>
+ <col width="15%"/>
+ <col width="15%"/>
+ <col width="15%"/>
+ </colgroup>
+ <thead>
+ <tr class="titre">
+ <td class="bold center noborder" rowspan="2"/>
+ <td class="bold center borderedBold" colspan="2">Exercice <xsl:value-of select="$Entete//n:Exercice/@V"/></td>
+ <td class="bold center borderedBold" colspan="2">Exercice <xsl:value-of select="number($Entete//n:Exercice/@V) - 1"/></td>
+ </tr>
+ <tr>
+ <td class="bold center borderedBold">Emplois</td>
+ <td class="bold center borderedBold">Ressources</td>
+ <td class="bold center borderedBold">Solde</td>
+ <td class="bold center borderedBold">Solde</td>
+
+ </tr>
+ </thead>
+ <tbody>
+ <xsl:choose>
+ <xsl:when test="$el/@Modele='36'">
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered center">Variation du FRNG selon EPRD (1)</td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[1]/@VarMontN"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[1]/@VarMontN_1"/></xsl:call-template></td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered center">Variation de la créance dite de l'article 58 (2)</td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[2]/@VarMontN"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[2]/@VarMontN_1"/></xsl:call-template></td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered center">Variation de la créance de la sectorisation psychiatrique (3)</td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[3]/@VarMontN"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[3]/@VarMontN_1"/></xsl:call-template></td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered bold center">Variation totale du FRNG</td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[4]/@VarMontN"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[4]/@VarMontN_1"/></xsl:call-template></td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered montant"> </td>
+ <td class="bordered montant"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="borderedBold"><h2>BESOIN EN FONDS DE ROULEMENT</h2></td>
+ <td class="borderedBold" colspan="4"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="borderedBold"><h3>Variation de l'actif circulant</h3></td>
+ <td class="bordered center"><i>en hausse</i></td>
+ <td class="bordered center"><i>en baisse</i></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">stocks et en-cours</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[5]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[5]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">créances caisse pivot, sauf "part non exigiblede l'article 58"</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[6]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[6]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">créances sur hospitalisés & consultants</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[7]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[7]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">créances sur les caisses de sécurité sociale</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[8]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[8]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">créances sur les départements</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[9]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[9]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">créances sur les mutuelles et autres tiers payants (sauf créance de la sectorisationpsychiatrique)</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[10]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[10]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">créances irrécouvrables admises en non valeur</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[11]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[11]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">Autres débiteurs</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[12]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[12]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">Créances sur cessions d'immobilisations</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[13]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[13]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">Dépenses à classer</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[14]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[14]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered center"> </td>
+ <td class="bordered center"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered bold right">Sous total</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[15]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[15]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered center"> </td>
+ <td class="bordered center"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="borderedBold"><h3>Variation du passif circulant</h3></td>
+ <td class="bordered center"><i>en baisse</i></td>
+ <td class="bordered center"><i>en hausse</i></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">avances reçues</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[16]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[16]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">dettes fournisseurs et comptes rattachés</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[17]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[17]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">dettes fiscales et sociales</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[18]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[18]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">Autres créditeurs</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[19]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[19]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ </xsl:when>
+ <xsl:when test="$el/@Modele='37'">
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">dettes sur immobilisations</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[1]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[1]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">Recettes à classer ou à régulariser</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[2]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[2]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered center" colspan="2"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered bold right">Sous total</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[3]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[3]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered center" colspan="2"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered"><b>Variation du besoin en fonds deroulement</b> (total emplois du BFR - total ressources du BFR)</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[4]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[4]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[4]/@VarMontN"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[4]/@VarMontN_1"/></xsl:call-template></td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered center" colspan="2"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="borderedBold"><h2>TRESORERIE</h2></td>
+ <td class="borderedBold" colspan="4"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="borderedBold"><h3>Variation de la trésorerie d'actif</h3></td>
+ <td class="bordered center"><i>en hausse</i></td>
+ <td class="bordered center"><i>en baisse</i></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">liquidités</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[5]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[5]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">VMP et autres</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[6]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[6]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered center" colspan="2"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered bold right">Sous total</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[7]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[7]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered center" colspan="2"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="borderedBold"><h3>Variation de la trésorerie de passif</h3></td>
+ <td class="bordered center"><i>en hausse</i></td>
+ <td class="bordered center"><i>en baisse</i></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right">crédit de trésorerie</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[8]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[8]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">ICNE</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[9]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[9]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered right">fonds en dépôt</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[10]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[10]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered center" colspan="2"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered bold right">Sous total</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[11]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[11]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered right"> </td>
+ <td class="bordered center" colspan="2"> </td>
+ <td class="bordered grise"> </td>
+ <td class="bordered grise"> </td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered"><b>Variation de la trésorerie</b> total trésorerie d'actif - total trésorerie de passif</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[12]/@MtEmp"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[12]/@MtRess"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[12]/@VarMontN"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneTableauFondsRoulementTresorerie[12]/@VarMontN_1"/></xsl:call-template></td>
+ </tr>
+ </xsl:when>
+ </xsl:choose>
+ </tbody>
+ </table>
+ <xsl:if test="$el/@Modele='37'">
+ <br/>
+ <table width="55%" class="borderedInside">
+ <colgroup>
+ <col width="40%"/>
+ <col width="15%"/>
+ <col width="5%"/>
+ </colgroup>
+ <thead>
+ <tr class="titre">
+ <td class="borderedBold bold center" colspan="2"><h2>Vérification de la cohérence des états C5 etC6</h2></td>
+ <td class="noborder"/>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered">Variation du fonds de roulement</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneVariationTableauFondsRoulementTresorerie[1]/@VarMont"/></xsl:call-template></td>
+ <td class="noborder"/>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered">Variation du besoin en fonds de roulement</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneVariationTableauFondsRoulementTresorerie[2]/@VarMont"/></xsl:call-template></td>
+ <td class="noborder"/>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered">Variation de la trésorerie</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneVariationTableauFondsRoulementTresorerie[3]/@VarMont"/></xsl:call-template></td>
+ <td class="noborder right"><xsl:value-of select="$el/n:LigneVariationTableauFondsRoulementTresorerie[3]/@Libelano"/></td>
+ </tr>
+ </tbody>
+ </table>
+ <br/>
+ <table width="85%" class="borderedInside">
+ <colgroup>
+ <col width="40%"/>
+ <col width="15%"/>
+ <col width="15%"/>
+ <col width="15%"/>
+ </colgroup>
+ <thead>
+ <tr class="titre">
+ <td class="noborder">(1) source : état C5</td>
+ <td class="borderedBold bold center">Au 01/01/<xsl:value-of select="$Entete//n:Exercice/@V"/></td>
+ <td class="borderedBold bold center">Au 31/12/<xsl:value-of select="$Entete//n:Exercice/@V"/></td>
+ <td class="borderedBold bold center">Variation</td>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <xsl:attribute name="id">colorised1</xsl:attribute>
+ <td class="bordered">(2) créance dite de l'article 58</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneCreanceTableauFondsRoulementTresorerie[1]/@Crea01N"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneCreanceTableauFondsRoulementTresorerie[1]/@Crea12N"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneCreanceTableauFondsRoulementTresorerie[1]/@VarCreaN"/></xsl:call-template></td>
+ </tr>
+ <tr>
+ <xsl:attribute name="id">colorised2</xsl:attribute>
+ <td class="bordered">(3) créance de la sectorisation psychiatrique</td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneCreanceTableauFondsRoulementTresorerie[2]/@Crea01N"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneCreanceTableauFondsRoulementTresorerie[2]/@Crea12N"/></xsl:call-template></td>
+ <td class="bordered montant"><xsl:call-template name="number"><xsl:with-param name="num" select="$el/n:LigneCreanceTableauFondsRoulementTresorerie[2]/@VarCreaN"/></xsl:call-template></td>
+ </tr>
+ </tbody>
+ </table>
+ </xsl:if>
+ </xsl:template>
+</xsl:stylesheet>