1 / 34

CVS Reporting Design

CVS Reporting Design. Daniel Vikström: Project manager / cvs manager / PDF imp. / cvsql interface design. Carmine Protano: Webb & PDF design & imp. Francesco Severoni: Webb & pdf design & imp. Ahmed kamran: Webb & pdf design imp.

wing-clayton
Download Presentation

CVS Reporting Design

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CVS Reporting Design • Daniel Vikström: Project manager / cvs manager / PDF imp. / cvsql interface design. • Carmine Protano: Webb & PDF design & imp. • Francesco Severoni: Webb & pdf design & imp. • Ahmed kamran: Webb & pdf design imp. • Ivan Treščec: Zagreb team manager / communication / Eclipse Imp. • Mario Mikulaj: Eclipse & reporter design & imp. • Aleta Mladen: Reporter Design

  2. WebbApplication Specifications • Client visits the site and he creates his account by opening a registration page. • He fills the form whith: • Name • Surname • Email • User Position • Username • Password • Retype Password

  3. Webb Application Specifications • He submits the form, and the form will be validated at Client site, if the form is filled correctly, then all information will go to Server site. • On Server site, server scripting language (Jsp) will extract all information from the request query, and store all information in XML file. • Now when the user visits again, he just has to supply username and password. If he supplies correct username and password (which will be checked by our jsp using XML’s data) then he enters into the Main Page of the Site

  4. Use Case

  5. Use Case Description • Actor: User • Register • User Login • Display Report • Customize Report View • Actor: Administrator • Administrator Login • Menage Website

  6. Use Case: Register • Actor: User • Purpose: To get registration • Overview: A user visits the web site and fills the registeration form and finaly he gets registered.

  7. Use Case: User Login • Actor: User • Purpose: To enter in the system • Overview: A user visits the web site and he supplies: • Username • Password And he get entered in the system

  8. Use Case: Display Report • Actor: User • Purpose: User can display reports • Overview: After loging into the system the user is able to display a reports

  9. Use Case: Customize Report View • Actor: User • Purpose: User can customize different reports view • Overview: User inputs some information to customize the report view and finally he gets specific customized report view

  10. Use Case: Administrator Login • Actor: Administrator • Purpose: Administrator can login • Overview: A administrator visits the web site and he supplies: • Username • Password And he get entered in the system

  11. Use Case: Manage Website • Actor: Administrator • Purpose: Administrator can manage web site for example he notify some policies to users • Overview: To update web site and new features

  12. Use Case Description: Register

  13. Use Case Description: User Login

  14. Use Case Description: Display Report

  15. Use Case Description: Customize Report View

  16. Use Case Description: Administrator Login

  17. Use Case Description: Manage Web Site

  18. Class Diagram

  19. Sequence Diagram: Authentication

  20. Sequence Diagram: Registration

  21. Sequence Diagram: Report View

  22. CVS Report Eclipse Plugin

  23. Eclipse plug-in

  24. Template Editor • Allows users to define • Report layout • margins, font, color, alignment ... • User specific information (userInfoEditor) • User name, logo ... • CVS report information (queryEditor) • Dynamical creation of SQL commands • Stores information in XML files

  25. Reporter • Handles creation of PDF and HTML files • Loads information from XML template files • Connects to CVSQL database and executes queries

  26. External resouces • iText (http://www.lowagie.com/iText/) • Free Java library for PDF and HTML generation • JDOM (http://www.jdom.org) • Open-source library for Java-optimized XML data manipulation • CVSQL JDBC (http://www.fer.hr/rasip/dsd)

  27. CVS REPORT XML structure

  28. XML structure userInfo MainXML TableXML reportInfo TextXML

  29. XML structure • Separate files: • easyer implementation • re-use of XML files • modular design • CVSQL returns ResultSet so there is no need for storing data in XML.

  30. Main XML • layout • margins • paperSize • background • ? • userInfoFile • reportInfoFile

  31. userInfo XML • Elements: userName, userProject, userProjectStatus, company • attributes describe how text should look like: • font size • font name • color • style • alignment

  32. reportInfo • Elements: reportTitle, reportDescription, reportDate, reportPeriod, cvsql (query and result description) • same font style attributes like in userInfo • depending if cvsql query result is text or table, we use one of XML files for describing data (tableXML and textXML).

  33. tableXML describes how the result table should look like on report doesn’t store any data, only saves table description textXML if result is text, textXML file describes how text should look like on report TableXML or TextXML

  34. XML and DTD files • www.fer.hr/rasip/dsd • Projects -> CVS Report -> Objectives • XMLs: -DTDs: • main.xml -main.dtd • userInfo.xml -userInfo.dtd • reportInfo.xml -reportInfo.dtd • tableXML.xml -tableXML.dtd • textXML.xml -textXML.dtd

More Related