Inter-Ligas Intranet System

Vilniaus Gedimino Technikos Universitetas Director Jefe de proyecto ( Vilnius Gediminas Universitetas): Mindaugas Rybokas Director Jefe de proyecto(UPV): Juan Carlos Ruiz García Fecha: 18-06-11 Titulación: Ingeniería Técnica en Informática de Gestión INTER-LIGAS INTRANET SYSTEM + Developed by: Emilio Mora López Keywords: Leagues + soccer + Planning + Manager + Ranking + Match + Team Players + Results + Intranet + Extranet + Average + Statistics + Web + Joomla + Joomleague + Jquery + Charts CONTENTS TABLE 1.PROYECT PLAN – INTRODUCTION …………………………..……………..3 1.1.1.Project participants…………………………….…………….………....5 1.1.2.Project result ……………………………………………..………………....5 1.1.3.Product users…………………………………………………..……………5 1.1.4.Project justification……………………………………………..............5 1.2. PROJECT SCHEDULE…………………………………………………………6 1.2.1 LIST OF ACTIVITIES………………………………………………………..6 1.2.2 GANT DIAGRAM + CRITICAL PATH………………………………….7 1.3 PROJECT RESOURCE LIST………………………………………………….8 1.4 PROJECT RISK MANAGEMENT PLAN…………………………….……9 1.5.Project Plan Changes …………………………………………………….10 2.REQUIREMENTS SPECIFICATION DOCUMENT…………………..….11 2.1. Project round-up………………………………………………………...…11 2.1.1. User problem and the rationale for project design…11 2.1.2. Project Objectives…………………………….………….…...11 2.1.3. Clients…………………………………………………..…..………11 2.1.4. Buyers……………………………………………………………...12 2.1.5. Other interested parties…………………………………...12 2.1.6. Users……………………………………………………………..….12 2.2. Project limits……………………………………………..…………………..12 2.2.1. Bounded solutions……………………………………………..12 2.2.2. System development time …………………………………12 1. Hiring the project working personal.......................................14 2. Appserv installation.................................................................15 3. Install joomla template............................................................16 4. Joomleague intallation............................................................18 5. Install Forum to Report Changes..........................................18 6. Tortoise Installation................................................................19 2.2.3. Development of the system budget……………….…20 2.3. System Requirements…………………………………………………..20 2.3.1. System requirements for appearance……………..20 2.3.2. Usability Requirements…………………………………..20 2.3.4. For system maintenance………………………………....21 2.3.5. Requirements for safety…………………………………..21 2.4. Use case diagram……………………………………………..………….22 2.5. Data Chart……………………………………………………………..…….22 2.6. Project Output……………………………………………………………..23 2.6.1. Existing solutions…………………………………..23 2.6.2. User documentation and training………….23 2.6.3. Prospective requirements……………………..23 2.7. Changes in the requirements specification document ………....23 3.SYSTEM DESIGN DOCUMENT………………………………………………24 3.1. Joomla ERD (Entity Relationship Diagram)…………………24 3.2. Detailed system design (Joomleague Component)………25 3.2.1. System architecture description………………………25 3.2.2. Database tables……………………………………………….26 4. TEST PLAN………………………………………………………………………….27 4.1. Test Process Review……………………………………………………….27 4.1.1. Test Objectives………………………………………………….27 4.2. Test cases…………………………………………………………………..….27 4.2.1 Last Bugs solved………………………………………………..28 4.3. Test Results……………………………………………………………………28 5. USER DOCUMENTATION………………………………………………………..….29 5.1. System Administrator Guide…………………………………………..29 5.2. User Guide………………………………………………………………………29 6. VIABILITY AND CONCLUSIONS………………………………………………...29 7.VOVABULARY……………………………………………………………………….….….30 8.BIBLIOGRAPHY…………………………………………………………………….…….30 5 1.PROYECT PLAN - INTRODUCTION INTER-LIGAS INTRANET SYSTEM The company is dedicated to promoting open source programs that work with open source. The company detected within the current market needs of this and offers free installation and use without having to buy licenses, fully customized programs and led to the end user. The main objective is to bring regional leagues leagues above, providing a level of presentation and follow-up activities, which motivates the components of these categories. Our project starts with creating an intranet, from open source, which encompasses information from the regional leagues of cities, communities, and finally if the project is successful, by country. The information to be highlighted are the schedules, results, information about teams and players, with statistics showing a prediction of the matches and tournaments to play based on the records. Each club has a section of the intranet led their teams with an administrative panel where you manage your information in a personalized way. The image information is divided completely optional but recommended, as it aims to share relevant information of interest from clubs at: • Pitch and performance (changing rooms, facilities, image type field optional.) • Equipment categories and related links involving a season with their general and specific statistics. • Players that make up each team with averages of attack, defense, passing, cards, free throws, shots, etc. .. Open flash chart integrated into modules JoomLeague and solving the current problem of compatibility with templates using Warp5, as there is a conflict of bookstores.  A list of all players (with filter for leagues, tournaments and communities) show a top 20 or 30 (yet to be decided) ordered medium, obtained by surveys in an early version and votes in real time, in future versions as the project evolves. This function is explained later.  Players will implement a search engine with filters. We must not dismiss the idea that if we survey a reliable and we implement the voting system in real time by phone, a figure appears automatically in the system scout, covering the top players and clubs offer offers, even coaches and referees. The best players of the season, cities, or communities, and divisions, can be named best player, top scorer, played more minutes and less fouls committed to sportsmanship, best goalkeeper and more .. 6  Results of days within each league. • Ranking. Until now there is a first test version, with sample data where there have been some changes to the styles, can be found here. For now visible in Firefox with html5 standards. In this ranking or rating color display equipment amounting to above and the relegation places. As the project progresses a flash map that you can select the different communities, so the menu will lead to different clubs and every team will have a shortcut url to show section within the intranet. As innovative and differentiating features include the Android application programming for the mobile version of the intranet, much smaller than the original version, including voting or distribution of game titles as they can be man of the match, keeper of the meeting , and other securities to devise, and the interface that allows you give your opinions on blogs, allowing downloads of pictures and short videos of the games. The application displays a list of all players of the game and the division of securities, together with the surveys found on the intranet web version, make up half of the players who placed in the list of best players of the season thereby promote the effort with sportsmanship, also the lowest reward misconduct, or less cards per time played. The representation of information by clubs, will be much greater, since you can access statistics and resources that the current website of the sports federation. You will open the area of communication between federations, since the idea is to cover the whole country, and even able to translate and versions for different countries. The issues that the product is the clarity with which the viewer will see the games as they can be reviewed at all times via mobile, as is the classification, the mean and reviews of each player, photos, and make your own evaluation voting or commenting on the meeting. The latter is not a problem but if it helps in the attitude with which we can follow a game, when you have this information. The visiting players, in the case of not knowing the local computer facilities may visit through a virtual tour that provides intranet and to describe the characteristics of the team facing middle and expected result being a motivating factor for this, the possibility of breaking up the odds. The market need is unclear, because we are accustomed to the yawning gap between football's 1 st and 2 nd division with the regional categories, which are relegated to the background, where no one works in the same way to reach bringing them together, and above all, incentive motivation of the younger age categories. We could say that there is a need but there is an opportunity to enhance, and create enthusiasm for football at all levels. 7 1.1.1.Project participants Participants: 4 informatics who will share the work according to their knowledge (escalations) and work experience to develop. (Responsabilities will change according this parameters). All workers must be certified as a computer engineer or have a experiance that replace this degree in the specialty programming with php, mysql, apache, html, xhtml, javascript, ajax. Programs to use are the most common text editors a local environment for working with data packets and database tables. 1.1.2.Project result The result is a finished and functioning software product according to end user requirements that are likely to be composed of an intranet that encompasses all the information prior agreed with an administrative panel that the user will access a user name and password, and whereby you can create and update the information. 1.1.3.Product users The software provides an interface where you create players and football teams within a club, then view them via web, with other clubs. The system is very intuitive and no preparation is necessary but if it is recommended a mini-tutorial provided by the company for free. 1.1.4.Project justification I selected this topic because I am working on developing a similar project in Spain, and it seemed interesting to talk to better understand the development and help the company in an optimum development. 1.2.Project Objectives 1. Ending a fully functional version of the project start on time 1.1 Set times for completion of version 1.0 of the draft 1.2 Distribute work efficiently, more qualified personnel assigned to more complex tasks. 1.2.1 Define the most difficult tasks 1.2.2 Defining the specialization of each worker 2.Create a multitasking work environment 2.1 Create an operational server 2.2 Ensure better communication between workers easily 2.2.1 Install forums with didactic material and store details of the work 2.3 Using the same versions of domestic programs 3. Maintain direct contact with users (helpdesk) 3.1 Assign a commercial relationships and to explain the operation of projects 4.Adjust prices so that there is very little competition 4.1 Market full study 8 1.2. Project Schedule 1.2.1 List of activities 9 1.2.2 Gant diagram + Critical Path 16 All packages download from Official Binary Release. AppServ objective just make easy to setup. We do not provide anything else more than Official Binary Release package. Becuase we think the Official Binary Release work better than compile by individual or third-party binary. AppServ have only special configuration when install, Apache configure httpd.conf, MySQL configure my.ini, PHP configure php.ini. AppServ can guaranty any package from AppServ can work stable like Official of Apache, PHP, MySQL Release. Objective of AppServ Just Easy to install. You can setup web server, database server in 1 minute.For some question AppServ can be Real Production Web Server or Database Server. We can tell you Yes !! 100% can make AppServ to provide Production Server. But Windows OS is not good enough for heavy load on you web or database server.Windows OS architecture use more memory and CPU usage its recommend you to use Linux/Unix OS to service heavy load of work. Because Linux/Unix OS have more speed and use less memory and CPU usage. If you compare hit when use Windows OS and Linux/Unix OS you must be found a very difference speed. e.g. Windows can handle 1000 users per second but Linux/Unix OS can handle more than 1000 users per second and eat a little memory and cpu. Appserv url: http://www.appservnetwork.com/ 3.Install joomla template INSTALLING THE WORK ENVIROMENT All workers will have to have computers installed in their working environment as follows: We Need the engine joomla, working in our online server, pero not is NECESSARY for Workers to Have Their laptops joomla working in activitie Because the number 5, about Installing TortoiseSVN ins and They CAN take the repository from the server, But we will talk about this later. Actually, There Are Two Ways to get this installation done: ----- Option 1 ----- Option to install the engine in the local working environment and once running, using backups, upload to the server, which is not recommended because sometimes lose features to be replicating an entire database with all relevant calls in the code and routes (although the widespread joomla routes so that they can be updated with just a few clicks) What would happen if the installation of the backup on the server give problems? Well, here we enfrentariamo a top priority problems, since we could not continue with the development of applications and we should jump to the installation option 2, seeing facilities required to repeat modules already had done. We therefore recommend this installation directly on the server as indicated in option 2. 17 ------ Option 2 ------ Or install directly on the server version of joomla that we as a repository, and will be the version of the end user dispondrá.Y after that get off the repository TortoiseSVN support (activity 5) for a development version in our local environment. What would happen if once installed and running our version of Joomla, it was not possible to connect to the server and not allow us to copy the repository to the local environment where they can work? This is another problem of priority 1 because it would mean more work in having to individually install joomla + JoomLeague, and changes to the server could perform only a single person to oversee all the work. It would appear the figure of a server administrator, responsible for the upgrade and provides a virtual environment where the other developers would make the changes and may make copies of the repositories. Our Threshold in the times of this task has not had this type of additional difficulties and therefore this activity appears, and according to Gant diagram can be developed over a period of 3 days. IMPORTANT: (IN GANT CHART WE HAVE NOT HAD IN MIND THE TIME OF INSTALLATION OF THE MODULE TO MANAGE THE BACKUP, BACKUP AKEEBA THAT IS PROBABLY NOT A KEY UNIT DEVELOPMENT PROJECT, BUT BACK TO THE SERVICE. ) UPDATE: COMPONENT AKEEBA BACKUP ALLREADY INSTALLED AND WORKING (COST: 0 DAYS) Joomla is a CMS. A content management system is software that keeps track of every piece of content on your Web site, much like your local public library keeps track of books and stores them. Content can be simple text, photos, music, video, documents, or just about anything you can think of. A major advantage of using a CMS is that it requires almost no technical skill or knowledge to manage. Since the CMS manages all your content, you don't have to. Joomla is an award-winning content management system (CMS), which enables you to build Web sites and powerful online applications. Many aspects, including its ease-ofuse and extensibility, have made Joomla the most popular Web site software available. Best of all, Joomla is an open source solution that is freely available to everyone. Joomla main url: http://www.joomla.org/ Joomla demo url: http://demo.joomla.org/ 18 4. Joomleague intallation INSTALLING THE WORK ENVIROMENT All workers will have to have computers installed in their working environment as follows: JoomLeague is a full-featured league/competition management component with integrated prediction game for Joomla. Joomleague is currently available for either Joomla!® 1.0 and 1.5 and works with almost any server configuration tested on. Created in 2005 when a league management component was needed for Joomla. Lgmngr a Mambo CMS was used a base and after adapting it to work with Joomla!® and extending the features it was released under the GPL for the first time. After finishing up JoomLeague 0.93 a crisis in the development caused the team to split up and JoomLeague 1.5 was a fact. Started from scratch a lot of coding was in place but after about a year of coding it came to a halt again, this time because of inactivity. A couple of months later it was picked back up and after a good period of bugfixing, implementing new features and enhancing the core this is where we currently are. Ready to launch the first Alpha and keep on working on makeing JoomLeague better and more user-friendly. Joomleague url: http://www.joomleague.net/ 5.Install Forum to Report Changes. Activities This is Not supposed to have any errors and we CAN make it work in a while so we CAN finish it in 2 days. What if the installation gives errors? We can find another module within all existing joomla extensions but the best solution would work on the resolution of errors since it is the best forum we can find for free, and working within our own database, and also is fully compatible with the latest version of joomla UPDATE: Finally we used the assembler for the update and change log because it is an automated system saves us work. Thanks to the repository we have taken this step in the installation of the work environment. More information on the assembler and the use of tortoise in the Url provided in the bibliography. 19 6.Tortoise Installation INSTALLING THE WORK ENVIROMENT All workers will have to have computers installed in their working environment as follows: We choose this tool to make the Project Easier to update and make all workers can have the same version of the project when we begin to modify code. This is the most popular and probably one of the best that exists in the network. The tool creates a copy of the operational intranet server for each developer, and is by Tortoise we can directly update the content on our intranet or project. As seen in previous sections, the malfunction of this tool can be a significant increase in the critical path of our project. Hence the 8 days of installation and testing. What if, by human error, will update an unstable version of the intranet, or to update, conflicted other modules or functionality? If the result is a complete unusable, it would be advisable to re-install over the last backup we have. If the problem is the conflicts and discovered later, the solution would be to try to fix it, if possible, would restore the last backup that is available. If the problem is detected early conflicts, we must first consider whether the changes are essential for the proper development of the project, if not essential we can discard or alternatives, for example find a module or piece of code that the same functionality but that does not conflict with other modules. TortoiseSVN is an easy-to-use SCM / source control software for Microsoft Windows and possibly the best standalone Apache™ Subversion® client there is. It is implemented as a Windows shell extension, which makes it integrate seamlessly into the Windows explorer. Since it's not an integration for a specific IDE you can use it with whatever development tools you like. Tortoise url: http://tortoisesvn.net/ 20 2.2.3. Development of the system budget This section Provides the Estimated / expected Development Costs of the system numerical terms (cash). Because we are a subsidiary of an existing company is not spending the time to register a company. Try to make the project cost is 0 €. Pending only the financial rewards for programmers somehow finally seeing their work rewarded. Points during the project which may require a financial contribution: • Joomla modules or components that are not shareware (commercial version of the product) • External programming to support the project. • Hire a web host that offers more benefits than the current hosting (free and flawless for now) • Ccommercial contracts and programmers in different communities for the instruction of joomla - JoomLeague and subsequent implantation in sports centers. • Possible creation of a helpdesk We are checking “Plan Avanza” continiusly checking for grants 2.3. System requirements This section provides the system posed by the completion of a non-functional requirements. Each non-functional requirements in the form: 2.3.1. System requirements for appearance We will formulate the requirements of the user interface or backend. Using username and password, the user will access the administrative panel, with restricted permissions for each user. The user must have the capacity (previous tutorial) to create change data of players - teams. Create and elmininar new players, assigning players to teams, etc. Encourage maintenance of their own information within the intranet, work to update profile pictures of players or monitor the relevant information. 2.3.2. Usability Requirements System requirements for the use of simplicity: We assume that each component of the company has an own computer with the minimum requirements or recommended for the development of the application. Preferable to mind an Intel Core 2 Duo processor with enough hard drive capacity. No need to buy new equipment for making the working environment. 21 2.3.4. For system maintenance System requirements for the maintenance and support after it is handed over to the consumer: As the intranet is running on a external hosting company, we can use the service from any computer with internet service. If you use a helpdesk that has to be active in a given period of time may be needed is a PC with internet connection, but would hire a staff job with fixed position and do not want to work with negative economic margins. 2.3.5. Requirements for safety • Confidentiality - The data in the system to Protect Against Unauthorized access; • Integrity (Integrity) - the unique system of data Transmitted by the source (derived from) the data, while Ensuring the Legality of Their use; • Accessibility - access to data Within a fixed time of Legitimate users. We will try to introduce a minimum of personal data unless there is a user's personal request to store them. All data conform to the rules of data protection law of personal character. Data protection principles 1. Personal data shall be processed fairly and lawfully and, in particular, shall not be processed unless1. at least one of the conditions in Schedule 2 is met, and 2. in the case of sensitive personal data, at least one of the conditions in Schedule 3 is also met. 2. Personal data shall be obtained only for one or more specified and lawful purposes, and shall not be further processed in any manner incompatible with that purpose or those purposes. 3. Personal data shall be adequate, relevant and not excessive in relation to the purpose or purposes for which they are processed. 4. Personal data shall be accurate and, where necessary, kept up to date. 5. Personal data processed for any purpose or purposes shall not be kept for longer than is necessary for that purpose or those purposes. 6. About the rights of individuals e.g. You have the right to have data about you removed. 7. Appropriate technical and organizational measures shall be taken against unauthorized or unlawful processing of personal data and against accidental loss or destruction of, or damage to, personal data. 8. Personal data shall not be transferred to a country or territory outside the European economic area unless that country or territory ensures an adequate level of protection for the rights and freedoms of data subjects in relation to the processing of personal data. 22 2.4. Use case diagram 2.5. Data Chart 23 2.6. Project Output 2.6.1. Existing solutions In this section, we will consider that you are creating similar software. The evaluation shall provide the following: product name, product brand, price (if paid product), product features a list of the pluses and minuses. There is a soccer federation for communities. It is an intranet that manages the meetings (dates and results are produced) as well as the management of the ranking but not as specific as that offered by our company because as original data, to view a simple list of players, Users must connect with each club's official website, which is not required from our intranet, and also inter-league shows each player's personal statistics and general, each team, with half of both. Also shown the preview match from these statistics, to motivate the players, you were able to surprise with the forecast results. 2.6.2. User documentation and training 1st What level of user documentation is needed? There will be a help section in the frontend of the intranet. In addition, a course of about an hour is given to familiarize the client with the backend or administrative panel showing you how to register a player, assign it to a computer, edit or delete records in the database. The system access will be limited by categories of administration and management. 2nd Consumers Are Involved in the preparation of documentation? It takes into account whether the clubs have a computer that can handle the administration of JoomLeague, so that the course is more enjoyable and reduced, assuming that some basic ideas were known in advance. It is not necessary to take into account more parameters than the correct intrsuccion staff. 3rd Who Will Be Responsible for Preparing and Updating the documentation? The same users or informatic responsible within each club. 2.6.3. Prospective requirements The outlook for new modules within the application will be using openchart (opensource) to show the statistics of the players as they are playing games and make half with overall team statistics. 2.7. Changes in the requirements specification document All changes are recorded, versioned within the application stored in the Assembla repository managed by tortoise. 24 3.SYSTEM DESIGN DOCUMENT 3.1. Joomla ERD (Entity Relationship Diagram) 25 3.2. Detailed system design (Joomleague Component) 3.2.1. System architecture description Function name and purpose Features Input Features a description of the algorithm Output Options Function display : Display the view from club info. ( $tpl = null ) Display the clubinfo listview - Function edit: displays select & logos ( $tpl = null ) Set page title Edit Club Info model build the html select list for countries build the html select list for playgrounds display logo - Function _getShowClubInfoLink : Get the show club info link () Get the show club info link $link Function save: save query into database () save query into database - Function showranking: display ranking view () Get the view name from the query string Get the view Get the joomleague model - Function showresults : Show the football matches results () Get the view name from the query string Get the view Get the joomleague model - Function getClub : Get the club name () Contains the query to Get the club name $club Function getGoogleMap : Get the googlemaps coordenades ( $mapconfig, $address_string = "" ) Get the googlemaps coordenades $gm Function getTeamPlayer: Get Team Player () Contains the query to Get Team Player $player Function computeRanking : Manage home, away & total rank tables () Get the url and divisions for ranking tables & creates ranking objects -