Netgroup

From ICO wiki
Revision as of 21:37, 20 March 2016 by Iteras (talk | contribs) (→‎XSLT)
Jump to navigationJump to search

Liikmed

  • Indrek Nurja
  • Imre Teras
  • Kristjan Kotto
  • Marek Kivikink

Idee

Ideeks on luua nn. "Middleman" teenus oksjoni või esemete müügiga tegelevatele veebisaitidele, mis vähendaks kliendi ja müüja vahelist pettuse riski.

Kasutatav tehnoloogia

Rakenduse sisu

"Must have":

"Nice to have":

Andmebaas

XML Fail

<?xml version="1.0" encoding="utf-8" ?>
<System>
  <Person personId ="0" >
    <Role roleType ="admin"></Role>
    <PersonData>
      <UserName><![CDATA[Ompzu]]></UserName>
      <FirstName><![CDATA[Imre]]></FirstName>
      <LastName><![CDATA[Teras]]></LastName>
      <PersonPosts></PersonPosts>
    </PersonData>
    <Posts postId ="0" category="Technology" date="20.03.2016" public="False">
      <PostTitle><![CDATA[First posts' title]]></PostTitle>
      <PostContent>
        <PostPictures>
          <Picture pictureId ="0"><![CDATA[!!!Picture not found!!!]]></Picture>    
      </PostPictures>
        <PostDescription><![CDATA[Lorem ipsum dolor sit amet, malesuada dictumst proin integer leo orci, phasellus vulputate arcu mauris sodales praesent, laoreet nisl sed vulputate, leo arcu euismod netus. Sodales venenatis purus tellus, leo sem ac dui vel nunc, lorem eleifend purus nullam duis, consectetuer lacus dui.]]></PostDescription>
      </PostContent>
    </Posts>
  </Person>
<Person personId ="1">
    <Role roleType ="admin"></Role>
    <PersonData>
      <UserName><![CDATA[GlobalAlite]]></UserName>
      <FirstName><![CDATA[Intzz]]></FirstName>
      <LastName><![CDATA[Nurja]]></LastName>
      <PersonPosts></PersonPosts>
    </PersonData>
    <Posts postId ="0" category="Car" date="20.03.2016" public="False">
      <PostTitle><![CDATA[Globals First posts' title]]></PostTitle>
      <PostContent>
        <PostPictures>
          <Picture pictureId ="1"><![CDATA[!!!Picture not existing!!!]]></Picture>
          <Picture pictureId ="2"><![CDATA[!!!Picture not existing!!!]]></Picture>
          <Picture pictureId ="3"><![CDATA[!!!Picture not existing!!!]]></Picture>
        </PostPictures>
        <PostDescription><![CDATA[Lorem ipsum dolor sit amet, malesuada dictumst proin integer leo orci, phasellus vulputate arcu mauris sodales praesent, laoreet nisl sed vulputate, leo arcu euismod netus. Sodales venenatis purus tellus, leo sem ac dui vel nunc, lorem eleifend purus nullam duis, consectetuer lacus dui.]]></PostDescription>
      </PostContent>
    </Posts>
  </Person>
<Person personId ="2">
    <Role roleType ="user"></Role>
    <PersonData>
      <UserName><![CDATA[KoitJoome]]></UserName>
      <FirstName><![CDATA[Marek]]></FirstName>
      <LastName><![CDATA[Kiviking]]></LastName>
      <PersonPosts></PersonPosts>
    </PersonData>
    <Posts postId ="0" category="toys" date="20.03.2016" public="False">
      <PostTitle><![CDATA[Koits First posts' title]]></PostTitle>
      <PostContent>
        <PostPictures>
          <Picture pictureId ="4"><![CDATA[!!!Picture not existing!!!]]></Picture>
          <Picture pictureId ="5"><![CDATA[!!!Picture not existing!!!]]></Picture>
        </PostPictures>
        <PostDescription><![CDATA[Lorem ipsum dolor sit amet, malesuada dictumst proin integer leo orci, phasellus vulputate arcu mauris sodales praesent, laoreet nisl sed vulputate, leo arcu euismod netus. Sodales venenatis purus tellus, leo sem ac dui vel nunc, lorem eleifend purus nullam duis, consectetuer lacus dui.]]></PostDescription>
      </PostContent>
    </Posts>
  </Person>
</System>

XSD Fail

<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
 <xs:element name="System">
   <xs:complexType>
     <xs:sequence>
       <xs:element maxOccurs="unbounded" name="Person">
         <xs:complexType>
           <xs:sequence>
             <xs:element name="Role">
               <xs:complexType>
                 <xs:attribute name="roleType" type="xs:string" use="required" />
               </xs:complexType>
             </xs:element>
             <xs:element name="PersonData">
               <xs:complexType>
                 <xs:sequence>
                   <xs:element name="UserName" type="xs:string" />
                   <xs:element name="FirstName" type="xs:string" />
                   <xs:element name="LastName" type="xs:string" />
                   <xs:element name="PersonPosts" />
                 </xs:sequence>
               </xs:complexType>
             </xs:element>
             <xs:element name="Posts">
               <xs:complexType>
                 <xs:sequence>
                   <xs:element name="PostTitle" type="xs:string" />
                   <xs:element name="PostContent">
                     <xs:complexType>
                       <xs:sequence>
                         <xs:element name="PostPictures">
                           <xs:complexType>
                             <xs:sequence>
                               <xs:element maxOccurs="unbounded" name="Picture">
                                 <xs:complexType>
                                   <xs:simpleContent>
                                     <xs:extension base="xs:string">
                                       <xs:attribute name="pictureId" type="xs:unsignedByte" use="required" />
                                     </xs:extension>
                                   </xs:simpleContent>
                                 </xs:complexType>
                               </xs:element>
                             </xs:sequence>
                           </xs:complexType>
                         </xs:element>
                         <xs:element name="PostDescription" type="xs:string" />
                       </xs:sequence>
                     </xs:complexType>
                   </xs:element>
                 </xs:sequence>
                 <xs:attribute name="postId" type="xs:unsignedByte" use="required" />
                 <xs:attribute name="category" type="xs:string" use="required" />
                 <xs:attribute name="date" type="xs:string" use="required" />
                 <xs:attribute name="public" type="xs:string" use="required" />
               </xs:complexType>
             </xs:element>
           </xs:sequence>
           <xs:attribute name="personId" type="xs:unsignedByte" use="required" />
         </xs:complexType>
       </xs:element>
     </xs:sequence>
   </xs:complexType>
 </xs:element>
</xs:schema>

XSLT - kuvab kõik kasutajate postitused koos selle sisuga

<?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="html" indent="yes"/>

    <xsl:template match="/">
      <html>
        <head>
          <title>
            <H1>Posts by persons</H1>
          </title>
        </head>
        <body>
          <H1>Posts by Persons</H1>
          <ul>
            <xsl:for-each select="/System/Person">
              <li>
                <xsl:value-of select="PersonData/UserName"/>
                <ul>
                  <xsl:for-each select="Posts">
                    <li>
                      <xsl:value-of select="PostTitle"/>
                      <p>
                        <xsl:value-of select="PostContent/PostDescription"/>
                      </p>
                     
                      <ul>

                        <xsl:for-each select="PostContent/PostPictures/Picture">
                          <li>
                            <xsl:value-of select="."/>
                          </li>
                        </xsl:for-each>
                      </ul>
                    </li>
                  </xsl:for-each>
                </ul>
              </li>
            </xsl:for-each>
          </ul>
        </body>
      </html>
      
    </xsl:template>
</xsl:stylesheet>

Ajakava

8.02.2016

  • Meeskonna loomine
  • Lubaduse tegemine, et alustame projektiga varakult

19.02.2016

  • Imre õrritas meeskonnakaaslasi miljoniideega, ning lubas varsti rohkem infot jagada

21.02.2016

  • Imre tuli lagedale oma ideega, uurisime tiimiga ja tundus täitsa normaalne idee.

26.02.2016

  • Imre on teinud ASP.net raames projekti natuke uurinud, puurinud, teinud valmis andmebaasi

20.03.2016

Imre tegi XML, XSLT ja XSD failid

Indrek tegi Wiki lehe