<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" 
                xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

  <xsl:key name="cheie1" match="tema/studenti/student" use="@id_student"/>
  <xsl:key name="cheie2" match="/tema/specializare" use="@id_student"/>
  <xsl:template match="/">  
    <html>
      <head>
        <title>Tema 4 IE</title>
        <style type='text/css'>
	  body 
	  {
	    font-family: Verdana, sans-serif;
	    font-size: 3px;
	    margin: 0;
          }
        </style>
      </head>
      <body>      
      <center>
        <h3>Numele si Prenumele tuturor studentilor de la specializarea "Calculatoare"</h3>
          <table border="0" bgcolor="black" cellspacing="1">
            <tr bgcolor="white">
              <th align="center">Nume</th>
              <th align="center">Prenume</th>
            </tr>
            <xsl:for-each select="tema/specializare[text()='Calculatoare']">       
              <xsl:variable name="variabila1" select="@id_student"/>
              <xsl:for-each select="key('cheie1',$variabila1)">
                <tr bgcolor="white">
                  <td><xsl:value-of select="nume"/></td>
                  <td><xsl:value-of select="prenume"/></td>
                </tr>
              </xsl:for-each>            
            </xsl:for-each>
          </table>
        <h3>Caracteristicile Studentilor afisate in culori diferite in functie de grupa si de an</h3>
          <table border="0" cellspacing="1" bgcolor="black">
            <tr bgcolor="white">
              <th align="center">Id Student</th>
              <th align="center">Nume</th>
              <th align="center">Prenume</th>
              <th align="center">Varsta</th>
              <th align="center">Grupa</th>
              <th align="center">An</th>
              <th align="center">Specializare</th>
            </tr>
            <xsl:for-each select="/tema/studenti/student">              
              <xsl:sort select="an"/>
                <xsl:sort select="grupa"/>
                  <xsl:variable name="variabila2" select="@id_student"/>
                  <xsl:variable name="an" select="an"/>
                  <xsl:variable name="grupa" select="grupa"/>
                  <xsl:if test="grupa='311CA' and an='1'">
                    <tr bgcolor="silver">
                      <td>
                        <xsl:value-of select="@id_student"/>                      
                      </td>
                      <td>
                        <xsl:value-of select="nume"/>
                      </td>
                      <td>
                        <xsl:value-of select="prenume"/>
                      </td>
                      <td>
                        <xsl:value-of select="varsta"/>
                      </td>
                      <td>
                        <xsl:value-of select="grupa"/>
                      </td>
                      <td>
                        <xsl:value-of select="an"/>
                      </td>
                      <xsl:for-each select="key('cheie2',$variabila2)">
                        <td>
                          <xsl:value-of select="text()"/>
                        </td>                    
                      </xsl:for-each>
                    </tr>
                  </xsl:if>
                  <xsl:if test="grupa='321CA' and an='2'">
                    <tr bgcolor="olive">
                      <td>
                        <xsl:value-of select="@id_student"/>                      
                      </td>
                      <td>
                        <xsl:value-of select="nume"/>
                      </td>
                      <td>
                        <xsl:value-of select="prenume"/>
                      </td>
                      <td>
                        <xsl:value-of select="varsta"/>
                      </td>
                      <td>
                        <xsl:value-of select="grupa"/>
                      </td>
                      <td>
                        <xsl:value-of select="an"/>
                      </td>
                      <xsl:for-each select="key('cheie2',$variabila2)">
                        <td>
                          <xsl:value-of select="text()"/>
                        </td>                    
                      </xsl:for-each>
                    </tr>
                  </xsl:if>
                  <xsl:if test="grupa='321CB' and an='2'">
                    <tr bgcolor="purple">
                      <td>
                        <xsl:value-of select="@id_student"/>                      
                      </td>
                      <td>
                        <xsl:value-of select="nume"/>
                      </td>
                      <td>
                        <xsl:value-of select="prenume"/>
                      </td>
                      <td>
                        <xsl:value-of select="varsta"/>
                      </td>
                      <td>
                        <xsl:value-of select="grupa"/>
                      </td>
                      <td>
                        <xsl:value-of select="an"/>
                      </td>
                      <xsl:for-each select="key('cheie2',$variabila2)">
                        <td>
                          <xsl:value-of select="text()"/>
                        </td>                    
                      </xsl:for-each>
                    </tr>
                  </xsl:if>
                  <xsl:if test="grupa='331CA' and an='3'">
                    <tr bgcolor="aqua">
                      <td>
                        <xsl:value-of select="@id_student"/>                      
                      </td>
                      <td>
                        <xsl:value-of select="nume"/>
                      </td>
                      <td>
                        <xsl:value-of select="prenume"/>
                      </td>
                      <td>
                        <xsl:value-of select="varsta"/>
                      </td>
                      <td>
                        <xsl:value-of select="grupa"/>
                      </td>
                      <td>
                        <xsl:value-of select="an"/>
                      </td>
                      <xsl:for-each select="key('cheie2',$variabila2)">
                        <td>
                          <xsl:value-of select="text()"/>
                        </td>                    
                      </xsl:for-each>
                    </tr>
                  </xsl:if>
                  <xsl:if test="grupa='341CA' and an='4'">
                    <tr bgcolor="lime">
                      <td>
                        <xsl:value-of select="@id_student"/>                      
                      </td>
                      <td>
                        <xsl:value-of select="nume"/>
                      </td>
                      <td>
                        <xsl:value-of select="prenume"/>
                      </td>
                      <td>
                        <xsl:value-of select="varsta"/>
                      </td>
                      <td>
                        <xsl:value-of select="grupa"/>
                      </td>
                      <td>
                        <xsl:value-of select="an"/>
                      </td>
                      <xsl:for-each select="key('cheie2',$variabila2)">
                        <td>
                          <xsl:value-of select="text()"/>
                        </td>                    
                      </xsl:for-each>
                    </tr>
                  </xsl:if>
                  <xsl:if test="grupa='351C1' and an='5'">
                    <tr bgcolor="teal">
                      <td>
                        <xsl:value-of select="@id_student"/>                      
                      </td>
                      <td>
                        <xsl:value-of select="nume"/>
                      </td>
                      <td>
                        <xsl:value-of select="prenume"/>
                      </td>
                      <td>
                        <xsl:value-of select="varsta"/>
                      </td>
                      <td>
                        <xsl:value-of select="grupa"/>
                      </td>
                      <td>
                        <xsl:value-of select="an"/>
                      </td>
                      <xsl:for-each select="key('cheie2',$variabila2)">
                        <td>
                          <xsl:value-of select="text()"/>
                        </td>                    
                      </xsl:for-each>
                    </tr>
                  </xsl:if>
                  <xsl:if test="grupa='351C2' and an='5'">
                    <tr bgcolor="fucsia">
                      <td>
                        <xsl:value-of select="@id_student"/>                      
                      </td>
                      <td>
                        <xsl:value-of select="nume"/>
                      </td>
                      <td>
                        <xsl:value-of select="prenume"/>
                      </td>
                      <td>
                        <xsl:value-of select="varsta"/>
                      </td>
                      <td>
                        <xsl:value-of select="grupa"/>
                      </td>
                      <td>
                        <xsl:value-of select="an"/>
                      </td>
                      <xsl:for-each select="key('cheie2',$variabila2)">
                        <td>
                          <xsl:value-of select="text()"/>
                        </td>                    
                      </xsl:for-each>
                    </tr>
                  </xsl:if>                                
            </xsl:for-each>              
          </table>
      </center>
      </body>
    </html>
  </xsl:template>
</xsl:stylesheet>