data.xsl

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

    <!-- **********************************************************************
         Vulnerability Data - CSV Import Stylesheet

         Column headers defined in this stylesheet:

         Indicator......................required.....vulnerability_indicator.name
         Description....................optional.....vulnerability_indicator.description
         Value..........................required.....vulnerability_data.value
         Country........................optional.....gis_location.L0
         Date...........................required.....vulnerability_data.date
         L1.............................optional.....gis_location.L1
         L2.............................optional.....gis_location.L2
         L3.............................optional.....gis_location.L3
         L4.............................optional.....gis_location.L4
         Name...........................optional.....gis_location.name
         Approved.......................optional.....vulnerability_data.approved_by
                                                     Set to 'false' to not approve records.
                                                     Note this only works for prepop or users with acl.APPROVE rights

         A location of some kind is required, although the level can vary by source

         This will first get the location based on the standard Ln data
         It will then create a stats_source record for each location and date,
         with a doc_source_entity, the source_id and data_id should go into a 
         stats_data record.
         Then each vulnerability indicator will be created
         For each location and vulnerability indicator the vulnerability_data
         record will be created.

    *********************************************************************** -->
    <xsl:output method="xml"/>
    <xsl:include href="../commons.xsl"/>
    <xsl:include href="../../xml/countries.xsl"/>

    <!-- ****************************************************************** -->
    <xsl:key name="location"
             match="row"
             use="concat(col[@field='Country'],
                         col[@field='L1'],
                         col[@field='L2'],
                         col[@field='L3'],
                         col[@field='L4'],
                         col[@field='Name'])"/>

    <xsl:key name="timeplace"
             match="row"
             use="concat(col[@field='Date'],
                         col[@field='Country'],
                         col[@field='L1'],
                         col[@field='L2'],
                         col[@field='L3'],
                         col[@field='L4'],
                         col[@field='Name'])"/>

    <xsl:key name="indicator"
             match="row"
             use="col[@field='Indicator']"/>

    <!-- ****************************************************************** -->
    <xsl:template match="/">

        <s3xml>
            <!-- Create the Doc Source Type -->
            <resource name="stats_group_type">
                <xsl:attribute name="tuid">stats_group_type/vulnerability_indicator</xsl:attribute>
                <data field="name">vulnerability_indicator</data>
            </resource>

            <!-- Create the Indicators -->
            <xsl:for-each select="//row[generate-id(.)=
                                        generate-id(key('indicator',
                                                        col[@field='Indicator'])[1])]">
                <xsl:call-template name="Indicator" />
            </xsl:for-each>

            <!-- Create the Vulnerability Data records -->
            <xsl:apply-templates select="table/row"/>

            <!-- Search for each location -->
            <xsl:for-each select="//row[generate-id(.)=
                                        generate-id(key('location',
                                                        concat(col[@field='Country'],
                                                               col[@field='L1'],
                                                               col[@field='L2'],
                                                               col[@field='L3'],
                                                               col[@field='L4'],
                                                               col[@field='Name']
                                                              ))[1])]">
                <xsl:call-template name="Locations"/>
            </xsl:for-each>

            <!-- Search for each time and place -->
            <xsl:for-each select="//row[generate-id(.)=
                                        generate-id(key('timeplace',
                                                        concat(col[@field='Date'],
                                                               col[@field='Country'],
                                                               col[@field='L1'],
                                                               col[@field='L2'],
                                                               col[@field='L3'],
                                                               col[@field='L4'],
                                                               col[@field='Name']
                                                              ))[1])]">
                <xsl:call-template name="Group"/>
            </xsl:for-each>
        </s3xml>

    </xsl:template>

    <!-- ****************************************************************** -->
    <!-- Vulnerability Data Record -->
    <xsl:template match="row">
        <xsl:variable name="locationPath"><xsl:call-template name="LocationPath"/></xsl:variable>
        <xsl:variable name="location"><xsl:call-template name="LocationReference"/></xsl:variable>
        <xsl:variable name="date" select="col[@field='Date']"/>
        
        <xsl:variable name="approved">
            <xsl:choose>
                <xsl:when test="col[@field='Approved']='false'">
                    <xsl:text>false</xsl:text>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:text>true</xsl:text>
                </xsl:otherwise>
            </xsl:choose>
        </xsl:variable>

        <resource name="vulnerability_data" approved="$approved">

            <data field="value"><xsl:value-of select="col[@field='Value']"/></data>
            <data field="date"><xsl:value-of select="$date"/></data>

            <!-- Link to Indicator -->
            <reference field="parameter_id" resource="vulnerability_indicator">
                <xsl:attribute name="tuid">
                    <xsl:value-of select="concat('vulnerability_indicator/',col[@field='Indicator'])"/>
                </xsl:attribute>
            </reference>

            <!-- Link to Stats Group -->
            <reference field="group_id" resource="stats_group">
                <xsl:attribute name="tuid">
                    <xsl:value-of select="concat('stats_group/',$locationPath,'/',$date)"/>
                </xsl:attribute>
            </reference>

            <!-- Link to Location -->
            <reference field="location_id" resource="gis_location">
                <xsl:attribute name="tuid">
                    <xsl:value-of select="$location"/>
                </xsl:attribute>
            </reference>
        </resource>
    </xsl:template>

    <!-- ****************************************************************** -->
    <xsl:template name="Indicator">
        <xsl:variable name="name" select="col[@field='Indicator']"/>
        <xsl:variable name="desc" select="col[@field='Description']"/>

        <resource name="vulnerability_indicator">
            <xsl:attribute name="tuid">
                <xsl:value-of select="concat('vulnerability_indicator/',$name)"/>
            </xsl:attribute>
            <data field="name"><xsl:value-of select="$name"/></data>
            <xsl:if test="$desc!=''">
                <data field="description"><xsl:value-of select="$desc"/></data>
            </xsl:if>
        </resource>

    </xsl:template>

    <!-- ****************************************************************** -->
    <xsl:template name="Group">
        <xsl:variable name="locationPath"><xsl:call-template name="LocationPath"/></xsl:variable>
        <xsl:variable name="location"><xsl:call-template name="LocationReference"/></xsl:variable>
        <xsl:variable name="date" select="col[@field='Date']"/>
        <xsl:variable name="status" select="col[@field='Status']"/>

        <xsl:variable name="approved">
            <xsl:choose>
                <xsl:when test="col[@field='Approved']='false'">
                    <xsl:text>false</xsl:text>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:text>true</xsl:text>
                </xsl:otherwise>
            </xsl:choose>
        </xsl:variable>

        <resource name="stats_group" approved="$approved">
            <xsl:attribute name="tuid">
                <xsl:value-of select="concat('stats_group/',$locationPath,'/',$date)"/>
            </xsl:attribute>
            <data field="date"><xsl:value-of select="$date"/></data>

            <!-- Link to Location -->
            <reference field="location_id" resource="gis_location">
                <xsl:attribute name="tuid">
                    <xsl:value-of select="$location"/>
                </xsl:attribute>
            </reference>

            <!-- Link to Group Type -->
            <reference field="group_type_id" resource="stats_group_type">
                <xsl:attribute name="tuid">stats_group_type/vulnerability_indicator</xsl:attribute>
            </reference>
        </resource>

    </xsl:template>

    <!-- ****************************************************************** -->
    <xsl:template name="LocationReference">

        <xsl:variable name="l0" select="col[@field='Country']/text()"/>
        <xsl:variable name="l1" select="col[@field='L1']/text()"/>
        <xsl:variable name="l2" select="col[@field='L2']/text()"/>
        <xsl:variable name="l3" select="col[@field='L3']/text()"/>
        <xsl:variable name="l4" select="col[@field='L4']/text()"/>
        <xsl:variable name="Name" select="col[@field='Name']/text()"/>

        <xsl:variable name="l1id" select="concat('Location L1: ', $l1)"/>
        <xsl:variable name="l2id" select="concat('Location L2: ', $l2)"/>
        <xsl:variable name="l3id" select="concat('Location L3: ', $l3)"/>
        <xsl:variable name="l4id" select="concat('Location L4: ', $l4)"/>
        <xsl:variable name="l5id" select="concat('Location: ', $Name)"/>

        <xsl:choose>
            <xsl:when test="$Name!=''">
                <xsl:value-of select="concat('Location: ', $Name)"/>
            </xsl:when>
            <xsl:when test="$l4!=''">
                <xsl:value-of select="concat('Location L4: ', $l4)"/>
            </xsl:when>
            <xsl:when test="$l3!=''">
                <xsl:value-of select="concat('Location L3: ', $l3)"/>
            </xsl:when>
            <xsl:when test="$l2!=''">
                <xsl:value-of select="concat('Location L2: ', $l2)"/>
            </xsl:when>
            <xsl:when test="$l1!=''">
                <xsl:value-of select="concat('Location L1: ', $l1)"/>
            </xsl:when>
            <xsl:when test="$l0!=''">
                <!-- Country Code = UUID of the L0 Location -->
                <xsl:variable name="countrycode">
                    <xsl:choose>
                        <xsl:when test="string-length($l0)!=2">
                            <xsl:call-template name="countryname2iso">
                                <xsl:with-param name="country">
                                    <xsl:value-of select="$l0"/>
                                </xsl:with-param>
                            </xsl:call-template>
                        </xsl:when>
                        <xsl:otherwise>
                            <xsl:value-of select="$l0"/>
                        </xsl:otherwise>
                    </xsl:choose>
                </xsl:variable>
                <xsl:variable name="country" select="concat('urn:iso:std:iso:3166:-1:code:', $countrycode)"/>
                <xsl:value-of select="$country"/>
            </xsl:when>
        </xsl:choose>

    </xsl:template>

    <!-- ****************************************************************** -->
    <xsl:template name="LocationPath">

        <xsl:variable name="l0" select="col[@field='Country']/text()"/>
        <xsl:variable name="l1" select="col[@field='L1']/text()"/>
        <xsl:variable name="l2" select="col[@field='L2']/text()"/>
        <xsl:variable name="l3" select="col[@field='L3']/text()"/>
        <xsl:variable name="l4" select="col[@field='L4']/text()"/>
        <xsl:variable name="Name" select="col[@field='Name']/text()"/>

        <xsl:if test="$Name!=''">
            <xsl:value-of select="$Name "/>
        </xsl:if>
        <xsl:if test="$l4!=''">
            <xsl:value-of select="$l4 "/>
        </xsl:if>
        <xsl:if test="$l3!=''">
            <xsl:value-of select="$l3 "/>
        </xsl:if>
        <xsl:if test="$l2!=''">
            <xsl:value-of select="$l2 "/>
        </xsl:if>
        <xsl:if test="$l1!=''">
            <xsl:value-of select="$l1 "/>
        </xsl:if>
        <xsl:if test="$l0!=''">
            <!-- Country Code = UUID of the L0 Location -->
            <xsl:variable name="countrycode">
                <xsl:choose>
                    <xsl:when test="string-length($l0)!=2">
                        <xsl:call-template name="countryname2iso">
                            <xsl:with-param name="country">
                                <xsl:value-of select="$l0"/>
                            </xsl:with-param>
                        </xsl:call-template>
                    </xsl:when>
                    <xsl:otherwise>
                        <xsl:value-of select="$l0"/>
                    </xsl:otherwise>
                </xsl:choose>
            </xsl:variable>
            <xsl:variable name="country" select="concat('urn:iso:std:iso:3166:-1:code:', $countrycode)"/>
            <xsl:value-of select="$country"/>
        </xsl:if>

    </xsl:template>

    <!-- ****************************************************************** -->
    <xsl:template name="Locations">

        <xsl:variable name="Name" select="col[@field='Name']/text()"/>

        <xsl:variable name="l0" select="col[@field='Country']/text()"/>
        <xsl:variable name="l1" select="col[@field='L1']/text()"/>
        <xsl:variable name="l2" select="col[@field='L2']/text()"/>
        <xsl:variable name="l3" select="col[@field='L3']/text()"/>
        <xsl:variable name="l4" select="col[@field='L4']/text()"/>

        <xsl:variable name="l1id" select="concat('Location L1: ', $l1)"/>
        <xsl:variable name="l2id" select="concat('Location L2: ', $l2)"/>
        <xsl:variable name="l3id" select="concat('Location L3: ', $l3)"/>
        <xsl:variable name="l4id" select="concat('Location L4: ', $l4)"/>
        <xsl:variable name="l5id" select="concat('Location: ', $Name)"/>

        <!-- Country Code = UUID of the L0 Location -->
        <xsl:variable name="countrycode">
            <xsl:choose>
                <xsl:when test="string-length($l0)!=2">
                    <xsl:call-template name="countryname2iso">
                        <xsl:with-param name="country">
                            <xsl:value-of select="$l0"/>
                        </xsl:with-param>
                    </xsl:call-template>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:value-of select="$l0"/>
                </xsl:otherwise>
            </xsl:choose>
        </xsl:variable>

        <xsl:variable name="country" select="concat('urn:iso:std:iso:3166:-1:code:', $countrycode)"/>

        <!-- L1 Location -->
        <xsl:if test="$l1!=''">
            <resource name="gis_location">
                <xsl:attribute name="tuid">
                    <xsl:value-of select="$l1id"/>
                </xsl:attribute>
                <reference field="parent" resource="gis_location">
                    <xsl:attribute name="uuid">
                        <xsl:value-of select="$country"/>
                    </xsl:attribute>
                </reference>
                <data field="name"><xsl:value-of select="$l1"/></data>
                <data field="level"><xsl:text>L1</xsl:text></data>
            </resource>
        </xsl:if>

        <!-- L2 Location -->
        <xsl:if test="$l2!=''">
            <resource name="gis_location">
                <xsl:attribute name="tuid">
                    <xsl:value-of select="$l2id"/>
                </xsl:attribute>
                <xsl:choose>
                    <xsl:when test="$l1!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l1id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:otherwise>
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="uuid">
                                <xsl:value-of select="$country"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:otherwise>
                </xsl:choose>
                <data field="name"><xsl:value-of select="$l2"/></data>
                <data field="level"><xsl:text>L2</xsl:text></data>
            </resource>
        </xsl:if>

        <!-- L3 Location -->
        <xsl:if test="$l3!=''">
            <resource name="gis_location">
                <xsl:attribute name="tuid">
                    <xsl:value-of select="$l3id"/>
                </xsl:attribute>
                <xsl:choose>
                    <xsl:when test="$l2!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l2id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:when test="$l1!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l1id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:otherwise>
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="uuid">
                                <xsl:value-of select="$country"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:otherwise>
                </xsl:choose>
                <data field="name"><xsl:value-of select="$l3"/></data>
                <data field="level"><xsl:text>L3</xsl:text></data>
            </resource>
        </xsl:if>

        <!-- L4 Location -->
        <xsl:if test="$l4!=''">
            <resource name="gis_location">
                <xsl:attribute name="tuid">
                    <xsl:value-of select="$l4id"/>
                </xsl:attribute>
                <xsl:choose>
                    <xsl:when test="$l3!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l3id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:when test="$l2!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l2id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:when test="$l1!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l1id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:otherwise>
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="uuid">
                                <xsl:value-of select="$country"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:otherwise>
                </xsl:choose>
                <data field="name"><xsl:value-of select="$l4"/></data>
                <data field="level"><xsl:text>L4</xsl:text></data>
            </resource>
        </xsl:if>

        <!-- Specific Location -->
        <xsl:if test="$Name!=''">
            <resource name="gis_location">
                <xsl:attribute name="tuid">
                    <xsl:value-of select="$l5id"/>
                </xsl:attribute>
                <xsl:choose>
                    <xsl:when test="$l4!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l4id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:when test="$l3!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l3id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:when test="$l2!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l2id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:when test="$l1!=''">
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="tuid">
                                <xsl:value-of select="$l1id"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:when>
                    <xsl:otherwise>
                        <reference field="parent" resource="gis_location">
                            <xsl:attribute name="uuid">
                                <xsl:value-of select="$country"/>
                            </xsl:attribute>
                        </reference>
                    </xsl:otherwise>
                </xsl:choose>
                <data field="name"><xsl:value-of select="$Name"/></data>
                <data field="lat"><xsl:value-of select="col[@field='Lat']"/></data>
                <data field="lon"><xsl:value-of select="col[@field='Lon']"/></data>
            </resource>
        </xsl:if>

    </xsl:template>

</xsl:stylesheet>