xsi:noNamespaceSchemaLocation="../../defs/technical-component-definition.xsd">
<name>ref-collec-spl</name>
<description>Configuration Référentiel des collectivités SPL</description>
- <release>5.0.0.5</release>
+ <release>5.0.0.7</release>
<url>http://xemelios.org/updatesV5/ref-collec-spl</url>
<type>CONFIG</type>
<destination>
<component-ref url="http://xemelios.org/updatesV5/xemelios-core" release="5.0.0.0"/>
</requires>
<release-notes>
+ <release v="5.0.0.7">
+ <note visibility="public">Correction de la gestion de la nature du contrôle.</note>
+ </release>
+ <release v="5.0.0.6">
+ <note visibility="public">Ajout de la nature du contrôle aux critères et à la liste de résultat.</note>
+ </release>
<release v="5.0.0.5">
<note visibility="dev">Importeur avec applicationProperties. Compatibilité core-5.0.0.25</note>
</release>
<help>Nomenclature comptable du budget</help>
<valeur>@nomencl</valeur>
</champ>
+ <champ id="lr12" libelle="Nature Contrôle">
+ <valeur>@nature-controle</valeur>
+ </champ>
</liste-resultat>
<critere id="CRI_EXERCICE" libelle="Exercice">
<option value="Non">Absente</option>
</select>
</critere>
+ <critere id="natControl" libelle="Nature Contrôle">
+ <path>{@nature-controle='##VALEUR:natControl##'}</path>
+ <select id="natControl">
+ <option value="Inconnu">Inconnu</option>
+ <option value="Allégé">Allégé</option>
+ <option value="Approfondi">Approfondi</option>
+ </select>
+ </critere>
</element>
</etat>
</document>
<xsl:element name="CollectivitesSPL" namespace="dgfip:collectivite.spl">
<xsl:element name="Collectivite" namespace="dgfip:collectivite.spl">
<xsl:for-each select="n:CollectivitesSPL/n:Collectivite/@*">
- <xsl:if test="not(name(.) eq 'archive')">
- <xsl:copy-of select="."/>
- </xsl:if>
- </xsl:for-each>
- <xsl:attribute name="archive" select="xem:getPresenceArchive(n:Exercice/text(),n:CollectivitesSPL/n:Collectivite/@idColl)"/>
+ <xsl:choose>
+ <xsl:when test="name(.) eq 'archive'"><xsl:attribute name="archive"><xsl:value-of select="xem:getPresenceArchive(//n:Exercice/text(),//n:CollectivitesSPL/n:Collectivite/@idColl)"/></xsl:attribute></xsl:when>
+ <xsl:when test="name(.) eq 'nature-controle'"><xsl:attribute name="nature-controle"><xsl:value-of select="normalize-space(.)"/></xsl:attribute></xsl:when>
+ <xsl:otherwise><xsl:copy-of select="."/></xsl:otherwise>
+ </xsl:choose>
+ </xsl:for-each>
+ <xsl:if test="not(exists(//n:CollectivitesSPL/n:Collectivite/@nature-controle))"><xsl:attribute name="nature-controle">Inconnu</xsl:attribute></xsl:if>
</xsl:element>
</xsl:element>
</xsl:element>
INDEX ${base-name}_AN (ARCHIVE_NAME)
) ENGINE MYISAM
</table>
- <table type="index" id="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" base-name="REF_COLL_SPL_COLLECTIVITESSPL_COLL_IX" version="3" main="true">
+ <table type="index" id="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" base-name="REF_COLL_SPL_COLLECTIVITESSPL_COLL_IX" version="4" main="true">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
JURI_FINAN VARCHAR(150) ,
GROUPE VARCHAR(150) ,
NOMENCL VARCHAR(150) ,
+ NATURE_CONTROLE VARCHAR(20) ,
ARCHIVE CHAR(3) ,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID) ,
<patch from-version="2">
<sql failonerror="false">ALTER TABLE ${base-name} ADD ARCHIVE CHAR(3)</sql>
</patch>
-
+ <patch from-version="3">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NATURE_CONTROLE VARCHAR(20)</sql>
+ </patch>
</table>
<criteria id="archive" sql-index-id="SQI_ARCHIVE">
<where-clause>${table}.${column}='##VALEUR:archive##'</where-clause>
</criteria>
+ <criteria id="natControl" sql-index-id="SQI_NATURE_CONTROLE">
+ <where-clause>${table}.${column}='##VALEUR:natControl##'</where-clause>
+ </criteria>
<sql-index id="SQI_JURI_FI" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@juri-finan" datatype="string" column="JURI_FINAN" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
<sql-index id="SQI_GROUPE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@groupe" datatype="string" column="GROUPE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
<sql-index id="SQI_NOMENCL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@nomencl" datatype="string" column="NOMENCL" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
+ <sql-index id="SQI_NATURE_CONTROLE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@nature-controle" datatype="string" column="NATURE_CONTROLE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX"/>
<sql-index id="SQI_ARCHIVE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="ARCHIVE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@archive" datatype="string"/>
</etat>
</document>