Meeskond Tudengikalender

Meeskond "Tudengikalender"

Meeskonna liikmed:

• Taavi Sildeberg
• Kunnar Kukk

Kodutöö XML (11. märts)

XML-fail hoiab andmeid ainete, tudengite ning tudengiga seotud kodutööde kohta.

Database.xml

<?xml version="1.0" encoding="utf-8" ?>

<database>
  <users>
    <user id="1908934" username="taavis">
      <fullname>Taavi Sildeberg</fullname>
      <email>taavi@sildeberg.eu</email>
      <mobile>+3725058624</mobile>
    </user>
    <user id="43" username="kunnark">
      <fullname>Kunnar Kukk</fullname>
      <email>kunnar.kukk@gmail.com</email>
      <mobile>+37256299030</mobile>
    </user>
    <user id="433" username="johnd">
      <fullname>Jhon Doe</fullname>
      <email></email>
      <mobile>57260989</mobile>
    </user>
  </users>
  <subjects>
    <subject id="1" userId="433">
      <name><![CDATA[Võrgurakendused II]]></name>
      <schedule from="2014-02-01" to="2014-05-01"></schedule>
      <homeworks>
        <homework id="1" deadline="2014-03-03T20:00:00Z">
          <name><![CDATA[XML osa]]></name>
          <description><![CDATA[Korralik xml fail ja lisaks on vaja ka kaks transformatsiooni]]></description>
          <comment><![CDATA[Oh krt, ei ole üldse veel sellega alusatnud. Ja kas mitte keegi tiimist ei pidanud seda juba tegema]]></comment>
          <status>open</status>
        </homework>
        <homework id="2" deadline="2014-05-03T20:00:00Z">
          <name><![CDATA[Retsensioonid]]></name>
          <description><![CDATA[Retsensioon ja veel üks retsensioon]]></description>
          <comment><![CDATA[Oh krt, ei ole üldse veel sellega alusatnud. Ja kas mitte keegi tiimist ei pidanud seda juba tegema]]></comment>
          <status>open</status>
        </homework>
        <homework id="3" deadline="2014-04-05T20:00:00Z">
          <name><![CDATA[Web service for .NET]]></name>
          <description><![CDATA[Veebiteenus ASP.dot neti jaoks, kena UI ja midagi veel]]></description>
          <comment><![CDATA[Esialgne plaan olemas, vaja veel data kihi jaoks asjad kokku leppida]]></comment>
          <status>in-progress</status>
        </homework>
        <homework id="4" deadline="2014-02-04T20:00:00Z">
          <name><![CDATA[Web asjake]]></name>
          <description><![CDATA[Praktikumi näite käimaajamine]]></description>
          <comment><![CDATA[]]></comment>
          <status>done</status>
        </homework>
      </homeworks>
    </subject>
    <subject id="2" userId="43" >
      <name><![CDATA[JAVA aine]]></name>
      <schedule from="2014-02-01" to="2014-03-01"></schedule>
      <homeworks>
        <homework id="1" deadline="2014-02-10T15:30:00Z">
          <name><![CDATA[Kodutöö]]></name>
          <description><![CDATA[Paar progemisülesannet]]></description>
          <comment><![CDATA[Õnneks juba esitatud]]></comment>
          <status>open</status>
        </homework>
      </homeworks>
    </subject>
    <subject id="3" userId="1908934">
      <name><![CDATA[Majanduse aine]]></name>
      <schedule from="2014-02-01" to="2014-06-01"></schedule>
      <homeworks>
        <homework id="1" deadline="2014-02-15T15:30:00Z">
          <name><![CDATA[Kontrolltöö]]></name>
          <description><![CDATA[KT esimese 4 peatüki peale]]></description>
          <comment><![CDATA[]]></comment>
          <status>open</status>
        </homework>
      </homeworks>
    </subject>
    <subject id="4" userId="43">
      <name><![CDATA[Algoritmika]]></name>
      <schedule from="2014-02-01" to="2014-06-01"></schedule>
      <homeworks>
        <homework id="1" deadline="2014-02-15T15:30:00Z">
          <name><![CDATA[Kodune analüüsi üleanne]]></name>
          <description><![CDATA[Vaata materjaöle wikist]]></description>
          <comment><![CDATA[]]></comment>
          <status>open</status>
        </homework>
      </homeworks>
    </subject>
  </subjects>
</database>

Skeemifail: Database.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

  <!-- Email type, validates that value is correct email or empty value, if user has not defined anything -->
  <xs:simpleType name="emailAddress">
    <xs:restriction base="xs:string">
      <xs:pattern value="|^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$"/>
    </xs:restriction>
  </xs:simpleType>

  <!-- Homework status custom type. Restricts values only for defined values -->
  <xs:simpleType name="homeworkStatus">
    <xs:restriction base="xs:string">
      <xs:enumeration value="open"/>
      <xs:enumeration value="in-progress"/>
      <xs:enumeration value="done"/>
    </xs:restriction>
  </xs:simpleType>

  <!-- Mobile number custom type. Restricts mobile numbers to valid numbers, should work also with country code -->
  <xs:simpleType name="mobileNumber">
    <xs:restriction base="xs:string">
      <xs:pattern value="^(\+|\d)[0-9]{7,16}$"/>
    </xs:restriction>
  </xs:simpleType>

  <xs:element name="database">
    <xs:complexType>
      <xs:sequence>
        <!-- Users section, holds list of user entities -->
        <xs:element name="users">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="user">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="fullname" type="xs:string" />
                    <xs:element name="email" type="emailAddress" />
                    <xs:element name="mobile" type="mobileNumber" />
                  </xs:sequence>
                  <xs:attribute name="id" type="xs:unsignedInt" use="required"/>
                  <xs:attribute name="username" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType> 
          <!-- Unique constaraint for user id-s, so that user id will be unique for entire database -->
          <xs:unique name="unique_user_id">
            <xs:selector xpath="user"/>
            <xs:field xpath="@id"/>
          </xs:unique>
        </xs:element>

        <!-- Subjects section, holds list of subject entities -->
        <xs:element name="subjects">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="subject">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="name" type="xs:string" />
                    <xs:element name="schedule">
                      <xs:complexType>
                        <xs:attribute name="from" type="xs:date" use="required"/>
                        <xs:attribute name="to" type="xs:date" use="required" />
                      </xs:complexType>
                    </xs:element>
                    <xs:element name="homeworks">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element maxOccurs="unbounded" name="homework">
                            <xs:complexType>
                              <xs:sequence>
                                <xs:element name="name" type="xs:string" />
                                <xs:element name="description" type="xs:string" />
                                <xs:element name="comment" type="xs:string" nillable="true"/>
                                <xs:element name="status" type="homeworkStatus" default="open"/>
                              </xs:sequence>
                                <xs:attribute name="id" type="xs:unsignedByte" use="required" />
                                <xs:attribute name="deadline" type="xs:dateTime" use="required">
                             </xs:attribute>
                            </xs:complexType>
                          </xs:element>
                        </xs:sequence>
                      </xs:complexType>
                      <!-- Unique constarant for homework id-s, so that homework id will be unique for the current subject, where it belongs -->
                      <xs:unique name="unique_homework_id">
                        <xs:selector xpath="homework"/>
                        <xs:field xpath="@id"/>
                      </xs:unique>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="id" type="xs:unsignedInt" use="required" />
                  <xs:attribute name="userId" type="xs:unsignedInt"  use="required" />
                </xs:complexType>    
              </xs:element>
            </xs:sequence>
          </xs:complexType>
          <!-- Unique constarant for subject id-s, so that subject id will be unique for entire database -->
          <xs:unique name="unique_subject_id">
            <xs:selector xpath="subject"/>
            <xs:field xpath="@id"/>
          </xs:unique>
        </xs:element>
      </xs:sequence>
    </xs:complexType>

    <!-- User id key definition -->
    <xs:key name="UserIdNumber">
      <xs:selector xpath="./users/user" />
      <xs:field xpath="@id" />
    </xs:key>

    <!-- User id key referenc, used for validating userId-s in subjects section, so that subjects have only valid userId-s -->
    <xs:keyref name="UserIdNumberRef" refer="UserIdNumber">
      <xs:selector xpath="./subjects/subject" />
      <xs:field xpath="@userId" />
    </xs:keyref>
  </xs:element>
</xs:schema>

Transformatsioon (xml->html): Overview.xslt

Kuvatakse kasutaja, temaga seotud ained ning kodutööde staatused

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>

  <xsl:decimal-format name="percentFormat" decimal-separator="." grouping-separator=","
   infinity="INFINITY" minus-sign="-" NaN="0" percent="%"
   per-mille="m" zero-digit="0" digit="#" pattern-separator=";" />

  <xsl:output method="html" indent="yes"/>

  <xsl:template match="/">


    <html lang="en">
      <head>
        <meta charset="utf-8"/>
        <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
        <meta name="viewport" content="width=device-width, initial-scale=1"/>
        <title>XSL Transformation Homework</title>

        <!-- Bootstrap -->
        <link href="http://netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css" rel="stylesheet"/>

        <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
        <!--[if lt IE 9]>
              <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
              <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
            <![endif]-->
      </head>
      <body>
        <div class="container">
          <div class="page-header">
            <h1>
              XSLT transformatsioon <small> Inimesed, õppeainded ja nende kodutööd</small>
            </h1>
          </div>
          <div class="panel panel-default">
            <div class="panel-body">
              <xsl:for-each select="//users/user">
                <xsl:variable name="currentUserId" select="./@id"/>
                <h1>
                  <xsl:value-of select="fullname"></xsl:value-of>
                </h1>
                <xsl:for-each select ="//subject[@userId=$currentUserId]">
                  <xsl:variable name="homeworksList" select="./homeworks/homework"></xsl:variable>
                  <xsl:variable name="doneHomeworksList" select="./homeworks/homework[status='done']"></xsl:variable>
                  <xsl:variable name="openHomeworksList" select="./homeworks/homework[status='open']"></xsl:variable>
                  <xsl:variable name="inProgressHomeworksList" select="./homeworks/homework[status='in-progress']"></xsl:variable>

                  <div class="panel panel-info">
                    <div class="panel-heading">
                      <h3 class="panel-title">
                        <xsl:value-of select="name"/>
                      </h3>
                    </div>
                   
                    <div class="panel-body">
                      <h4>Aine kodutööde progress</h4>
                      
                      <div class="progress">
                        <xsl:element name="div">
                          <xsl:variable name="valueString" select="format-number(count($doneHomeworksList) div count($homeworksList), '###.#%', 'percentFormat')"/>
                          <xsl:attribute name="class">progress-bar progress-bar-success</xsl:attribute>
                          <xsl:attribute name="style">
                            <xsl:value-of select="concat('width:', $valueString)"/>
                          </xsl:attribute>
                          Valmis
                        </xsl:element>
                        <xsl:element name="div">
                          <xsl:variable name="valueString" select="format-number(count($inProgressHomeworksList) div count($homeworksList), '###.#%', 'percentFormat')"/>
                          <xsl:attribute name="class">progress-bar progress-bar-warning</xsl:attribute>
                          <xsl:attribute name="style">
                            <xsl:value-of select="concat('width:', $valueString)"/>
                          </xsl:attribute>
                          Pooleli
                        </xsl:element>
                        <xsl:element name="div">
                          <xsl:variable name="valueString" select="format-number(count($openHomeworksList) div count($homeworksList), '###.#%', 'percentFormat')"/>
                          <xsl:attribute name="class">progress-bar progress-bar-danger</xsl:attribute>
                          <xsl:attribute name="style">
                            <xsl:value-of select="concat('width:', $valueString)"/>
                          </xsl:attribute>
                          Alustamata
                        </xsl:element>
                      </div>

                      <h4>Aine kodutööde nimekiri</h4>
                      <xsl:for-each  select="$homeworksList">
                        <ul>
                          <li>
                            <xsl:value-of select="name"/>
                          </li>
                        </ul>
                      </xsl:for-each>

                    </div>
                  </div>
                 
                </xsl:for-each>

              </xsl:for-each>

            </div>

          </div>

        </div>
        <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
        <!-- Include all compiled plugins (below), or include individual files as needed -->
        <script src="http://netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
      </body>
    </html>

  </xsl:template>
</xsl:stylesheet>

Transformatsioon (xml->xml): DatabaseXML.xslt

Näidatakse nö kooli vaadet, kus on kuvatud kõik ained ning ainega seotud kodutööd.

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
    
  <xsl:output method="xml" indent="yes"/>

    <xsl:template match="/">
      <subjects>
         <xsl:for-each select="database/subjects/subject">
           <subject>
                  <xsl:copy-of select="name"></xsl:copy-of>
                  <xsl:copy-of select="schedule"></xsl:copy-of>
                 <homeworks>
                  <xsl:for-each select="homeworks">
                      <xsl:for-each select="homework">
                        <homework>
                          <xsl:attribute name="deadline">
                            <xsl:value-of select="@deadline"/>
                          </xsl:attribute>
                          <xsl:copy-of select="name"/>
                          <xsl:copy-of select="description"/>
                        </homework>
                      </xsl:for-each>
                  </xsl:for-each>    
                 </homeworks>
           </subject> 
         </xsl:for-each>

        </subjects>
    </xsl:template>
</xsl:stylesheet>