Docstoc

futsal_management_report

Document Sample
futsal_management_report Powered By Docstoc
					Futsal Court Management System



                                 Proposal




     Futsal Court Management
              System
                        (Web Application)


                  Muhammed Afifi Ibrahim
                    Badruz Nasrin Basri




                                            1
MDec – PHP 5 Developer Training                                                                      Futsal Court Management Centre




TABLE OF CONTENTS


1      INTRODUCTION .................................................................................................................... 5
    1.1        ABOUT FUTSAL .................................................................................................................. 5
    1.2        SYSTEM BACKGROUND ....................................................................................................... 6
    1.3        PROJECT SCOPE .................................................................................................................. 7
    1.4        OBJECTIVES ....................................................................................................................... 8
2      MOTIVATIONS ..........................................................................................................................10
    2.1        WHY ..................................................................................................................................10
    2.2        WHO..................................................................................................................................10
3      SYSTEM DESIGN ..................................................................................................................11
    3.1     INTRODUCTION ..................................................................................................................11
       3.1.1 System Development Tools ............................................................................................11
    3.2     SOFTWARE AND HARDWARE REQUIREMENT .......................................................................12
       3.2.1 Software Requirement ...................................................................................................12
       3.2.2 Hardware Requirement .................................................................................................13
    3.3     SYSTEM ARCHITECTURE ....................................................................................................14
    3.4     SYSTEM FLOWCHART ..............................................................................................................16
       3.4.1 For Overall Process .......................................................................................................16
    3.5     SYSTEM DEVELOPMENT LIFE CYCLE(SDLC) ..................................................................................18

4      FEATURES .................................................................................................................................19
    4.1        USER LEVEL AND SECURITY .......................................................................................................19
    4.2        PROFILE MANAGEMENT ..........................................................................................................19
    4.3        BOOKING MANAGEMENT ........................................................................................................19
    4.4        MANAGES SUPPLIER..........................................................................................................19
    4.5        MANAGES COURT .............................................................................................................19
    4.6        MANAGES COURT MAINTENANCE .....................................................................................19
    4.7        MANAGES SALES REPORT ..................................................................................................20
5      SYSTEM SCREENSHOT.......................................................................................................21
    5.1        INTRODUCTION .....................................................................................................................21
    5.2        MANAGER MODULE ...............................................................................................................21

6      BOOKING MANAGEMENT .........................................................................................................25
    6.1        FLOWCHART .........................................................................................................................25
    6.2        DATE SELECT ........................................................................................................................26
    6.3        COURT SELECT ......................................................................................................................26
    6.4        TIME SELECT ........................................................................................................................27
    6.5        BOOKING DETAILS .................................................................................................................27
                                                                                                                                                     1
MDec – PHP 5 Developer Training                                                                     Futsal Court Management Centre




    CONFIRMATION PAGE .........................................................................................................................28
7      REPORT.....................................................................................................................................29
    7.1        SUMMARIZE SALES REPORT ......................................................................................................29
    7.2        COURT REPORT .....................................................................................................................29
    7.3        REFRESHMENT REPORT ...........................................................................................................30
8      TESTING ................................................................................................................................31
    8.1        MANAGEMENT LOGIN ............................................................................................................31
    8.2        ADD NEW STAFF ...................................................................................................................32
    8.3        COPYRIGHT ..........................................................................................................................33
    8.4        SEARCH FUNCTION.................................................................................................................34

9      CONCLUSION .......................................................................................................................35




                                                                                                                                                   2
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




EXECUTIVE SUMMARY

        Nowadays, web application system is very popular among Malaysia citizen.

Through the web application, people can easily get or give the information faster with

less hassle. As vision 2020 which claims to make transform Malaysia to high

technology country, people who has involved in the business activity they must have

a web application system for their company. This is because by using the web

application system, people can get immediate feedback to the business and stay in

touch with the particular company. With the web application system people can serve

through internet application and it allows workers to work from home or they can

manage their business in any places that they want. These activities provide reliability,

flexibility and save time.


        Hence, the title of the proposed project is “Futsal Court Management Centre”

and this is a new application that provides good service for the futsal business. A

Futsal Court Management Centre is a web application system which designs to handle

practically all aspects of the futsal business transaction including court booking and

management. This system is very flexibly configurable according to business

requirements. A Futsal Court Management Centre will help futsal business owner to

monitor and manipulate their daily futsal business. The system provides user accurate,

comprehensive, systematic, planned and documented information.


        Besides, the system lets futsal business owner to manage information of the

customer. In order to make a court booking, customers can reserve thru phone or they

                                                                                         3
MDec – PHP 5 Developer Training                           Futsal Court Management Centre




can directly go to the futsal centre. The information about the customers and their

booking transactions are stored into a database and all of the information will be kept

as a reference for the company. Besides that the system allows the company to offer

better services to the customer. They also can use the information that they gather to

improve their marketing and sales strategies.


        Basically, the develop system will be implemented in 2 Modules which are

Manager module and Staff Module. The Futsal Court Management Centre provides

particular features in each Module which are Court Booking, managing futsal

business, managing supplier, and managing employee information. Different Modules

of the system have a specification authority to access the system functions and

different role on managing the Futsal Court Management Centre. We believe that

futsal business owner may have a better management system in order to managing

their futsal business in more efficiency and effective way if they use the proposed

system. The system able to integrate with a future technology environment and it

makes management site easy to manage just on the fingertips.


        The Futsal Court Management Centre was developed by using programming

language of PHP and MySQL which is include in EasyPHP package. The challenge

that we met was designing an accurate system, features that implement into system

and data flow system which integrated all modules. In overcoming the problem during

the developing the system, we had obtained a commitment to ensure that the

designation of the system and data flow achieve the objectives during the progress of

developing the system.
                                                                                       4
MDec – PHP 5 Developer Training                            Futsal Court Management Centre




1 INTRODUCTION


        With the evolving technologies of the computers and Internet, the web

application system trend began to emerge be it in the industrial or the business area.

One of the most apparent advantage of web application system to traditional method is

that business can be managed where and when is demanded. What was time and place

bounded instruction, is now free, exploratory and self paced constructive approach.




1.1 About Futsal



        Futsal is a variant of football (soccer) that is played on a smaller playing

surface and mainly played indoors. Its name is derived from the Portuguese futebol de

salão and the Spanish fútbol de salón (and colloquially fútbol sala), which can be

translated as "hall football." During the sport's second world championships held in

Madrid in 1985, the name fútbol de salón was used. Since then, all other names have

been officially and internationally changed to futsal.


        Futsal is played between two teams of five players, one of whom is the

goalkeeper. Unlimited substitutes per team are permitted. Unlike some other forms of

indoor football, the game is played on a hard court surface delimited by lines; walls or

boards are not used. Futsal is also played with a smaller ball with less bounce than a


                                                                                        5
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




regulation football. The rules create an emphasis on improvisation, creativity and

technique as well as ball control and passing in small spaces.




1.2 System Background



          The main purpose of the system is to provide a good service for the customer

and easy management for the futsal business owner. The system can manage the

process of customer and management data. This will help the futsal business owner to

manage and monitor all their business operation in proper way. The system also helps

users to make a booking in efficiency and effective way.



          On the management site, the manager is responsible to update the court

information by either available or not available. The manager allows deleting,

updating and inserting the information for the court.



          Besides that, the system will help the manager to have an account for checking

the maintenance of court, managing the supplier records and also view all the sales

report.




                                                                                         6
MDec – PHP 5 Developer Training                            Futsal Court Management Centre




1.3 Project Scope



          After doing some research, this project is designed to be used by all futsal

companies in order to manage their business transaction as a whole, manage customer

booking and also report generated. The system is developed to be used by the

Manager and Staff of the company. All of the user information will be recorded into a

database and keeping as a reference by the company in the future for improvement

and also error-tracking.



          As a whole, there are two main components in our system, and they are:

                 Web application

                 Database system



          The web application is an application which is designed to allow manager and

staff to place customer booking virtually. They will also be able to check the status of

the customer booking and also make any amendments to the booking without much

hassle.



          The database system is used to connect the web application to make it a

system. The database will store customer booking from the developed systems. This

database will make checking status of booking and sales easier and it is also a

paperless solution for the whole system.

                                                                                        7
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




        In order to ensure the successfulness of this system, full co-operation are

needed from the users of the system to understand their need and expectation of the

system. Futsal Court Management Centre staff who will use this system can select the

functions that they need to use by stroking some keys of the keyboard and clicking

using the mouse to select and fill in all the appropriate fields in the interface provided

by the system.




1.4 Objectives



        The main objective of the Futsal Court Management Centre is to give the

customer more easier way to make a court booking and also make futsal business

owner easy to manage their daily business transaction.



The primary objectives to develop this system are:-



For Futsal business owner:



    1. Manage resource efficiently

        The Futsal Court Management Centre will help to reduce the expenses cost of

    the company resources such as man power and paperwork.



    2. Manage court maintenance effectively
                                                                                         8
MDec – PHP 5 Developer Training                            Futsal Court Management Centre




        The management staff can easily manage the maintenance of the court such as

        field changes, spotlight changes and so on.



    3. Enhanced data storing system

        Data of the customer booking will be directly store into the Futsal Court

        Management Centre database system and make the management staff easy to

        manage the customer data. So, there will be nothing missed out or

        misinterpreted by the staff when preparing the booking list.



    4. To create a better billing system

        The management staff can easily prepare the payment receipt after customer

        pays at the counter.




                                                                                        9
MDec – PHP 5 Developer Training                                 Futsal Court Management Centre




2 Motivations
2.1 Why
Futsal court management system is a system created to simplyfy the management especially
the booking management of the courts. Using the system managers and staffs can add, view,
edit or cancel booking of the courts in the fustal center. Compared to most of futsal center in
Malaysia nowadays that only used log book to record,this booking system the advantages of
using the system is :

    1. Booking and be managed easily- only short time needed to add booking and view
       current booking.
    2. Booking can be even made a month earlier.
    3. No syncronization issue between staff and if the system is hosted online, staff can
       even add and edit booking outside office.
    4. Enviromental friendly – paperless.
    5. Low development cost and literally zero maintanance cost.

2.2 Who
The system was developed specially for company that manage fustal courts.




                                                                                             10
MDec – PHP 5 Developer Training                           Futsal Court Management Centre




3 SYSTEM DESIGN

3.1     Introduction




      After conducted some literature research and review on the current system, the

results come out with the proper solutions to achieve all goals that have targeted in

this project. This chapter will covered the data modeling of the proposed system.

Besides, the features solution of propose system has been represented in details using

a graphical diagram such as System Flowchart. The entire diagram referred to get a

sense of the overall structures of the Futsal Court Management Centre System.




3.1.1 System Development Tools

        There is several development tools being brought together for this web

application system. PHP programming is used as Futsal Court Management Centre

System authoring tool. The Futsal Court Management Centre System will be divided

into small files or „chunks‟ especially on the booking and management site. The basic

login page of Futsal Court Management Centre System will be medium in size to

allow faster content delivery.


        MySQL is used to generate SQL statements and codes to allow communication

between the system and the database. The Futsal Court Management Centre System

database contains several records for example record of the Customers Booking, Staff,
                                                                                      11
MDec – PHP 5 Developer Training                            Futsal Court Management Centre




Manager, Court Information, and the others. SQL statements have to be embedded

inside another file extension in order to allow database to communicate with it. In this

case, SQL statements will be created within PHP files.


        The result generated from the query will then be accessed by database files to

be used inside Futsal Court Management Centre System. PHPMyAdmin is a tool

written in PHP intended to handle the management of MySQL over the Web. It will

monitor and managed these queries between files. The Apache HTTP Server helps to

maintain an open-source HTTP server for operating systems. Futsal Court

Management Centre System will use this server protocol when implementing it online.




3.2 Software and Hardware Requirement


3.2.1 Software Requirement


        Microsoft Visio


         Microsoft Visio used to draw software diagram such as Flowchart. The

         software can design different type of diagram.


        Microsoft Word


         Microsoft Word is used keep document and work as word processor.


        Microsoft MySQL


                                                                                       12
MDec – PHP 5 Developer Training                          Futsal Court Management Centre




         Microsoft MySQL Server used to manage database for the system.


        EasyPHP


         EasyPHP is a software package that used to host our develop system.


        Dreamweaver MX


        The software used to design the Graphical User Interface (GUI) of the

        proposed system and edit the PHP script.




3.2.2 Hardware Requirement
The hardware that we use to develop the system is show as below:


        ITEM        DESCRIPTION

            1.      Intel Dual Core Processor

            2.      3.0GB of RAM

            3.      320GB Hard Disk Drive

            4.      Graphic Card: NVIDIA PX7600GS

            5.      Realtek RTL8168C(P) PCI – E Gigabit Ethernet NIC

            6.      DVD - Rom

            7.      Keyboard & Mouse

            8.      LCD Monitor

            9.      Stereo speaker




                            Table 1-1. Hardware Requirement
                                                                                     13
    MDec – PHP 5 Developer Training                                                     Futsal Court Management Centre




    3.3 System Architecture

              All of the above tools can be mapped into below diagram list of the figures to

    see how each of them is connected. This will also define the system architecture.



                                                    Back-end of the system
                                                                                                     Futsal Court
                                                                                                     Management
                          Search in                                      Request page                   Centre
                                                                                                     System Main
                                                                                                         Page
                  Return requested file                              Return requested page

                                          Web Server
        Futsal Court                                                                                                User (Staff/Manager)
     Management Centre                           Generate php page                           Return page
   System Parent Directory                                                   .php

       PHP Files (.php)

                                                          Execute SQL statement
             Send SQL statement to be                                                   Customer
             executed                                                                   Booking            Supplier          Court
                                                               Return data
                                                                                         Record            Record            Record
                                          Apache Server
                                                                                        Database
Internet/Intranet Server                                              Database Server for Futsal Court Management Centre System




                 Figure 2-1. The diagram of Futsal Court Management Centre System

                                               for back-end architecture

              In Figure 2-1, the process starts when a user requests for a page from the main

    Futsal Court Management Centre System page. Since the most challenging issue when

    delivering contents online is the long amount of time to download, Futsal Court

    Management Centre System has been divided into small „chunks‟ of files and these

    can make the content delivery more faster for the user when they using the system.




                                                                                                                                14
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




        When a user requests for an interface file, the web server will look for the file

in the parent directory of Futsal Court Management Centre System and upon finding

that file, it will be returned back to the main page. However, when there is a request

for data, PHP files will be invoked. When this happens, the file will be sent to Apache

Server for the SQL statements to be executed. The data will be searched from within

the appropriate databases.


        Once the data is found, it will be returned back to Apache Server and a new

php file will be generated to be returned to the main page. Futsal Court Management

Centre System will extract the data returned in the new generated file and display it on

the screen.




                                                                                        15
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




3.4 System Flowchart

3.4.1 For Overall Process


             START




         Go to Login Page
          Of the system




        Input Username and
             Password




         Verify Username
                                            Display Error
          and Password
                                              Message
            Matched?                No




       Yes


     User (Staff and Manager)
                                                                         Futsal
     manages the Futsal Court              Save User Data
                                                                        Database
       Management Centre
              System




                                  Logout




                                  END




        Figure 2-2. Flowchart for overall process of Futsal Court Management
                                    Centre System

                                                                                        16
MDec – PHP 5 Developer Training                              Futsal Court Management Centre




        Figure 2-2 above shows the system flowchart for Futsal Court Management

Centre System. It provides with a roadmap of events that happens when a user begins

entering the system until the end. Upon entering the system, they will come to the

Main login page where it will be able to login into the system after key in their

Username and Password.


        A registered user who had successfully logged in to Futsal Court Management

Centre System will be taken them to their own progress tasks or modules on what the

particular user can do from the start until up to their last visit. After they had finished

with their works, they will click on the logout button to leave the system.




                                                                                         17
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




3.5 System Development Life Cycle(SDLC)


      In order to develped this system the SDLC model that have been chosen is

Waterfall model. This is because it it easier for us to follow the step of which part of

the system have to do first. Besides, the error tracking is moreeasy to detect and fix.




            System Analysis



                 System Design



                          System Development
                          and Modification

                                   System Integration



                                           System
                                           Implementation




                                                                                          18
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




4 Features
4.1 User level and security
The system make use of sessions to make sure only approved user can access the system.
There are two user level of the system.

No    Level            Features

1     Manager             1.   Booking Management
                          2.   Edit profile
                          3.   Court Management
                          4.   Staff Management
                          5.   Supplier Management
                          6.   Courts Maintainance
                          7.   Sales Report
2     Staff               1.   Booking Management
                          2.   Edit profile



4.2 Profile Management
     1. Edit profile

4.3 Booking Management
     1. Add booking
     2. Edit booking
     3. Cancel booking

4.4 MANAGES SUPPLIER
     1. Add New Supplier
     2. Update Supplier Info
     3. Delete Supplier Info

4.5 MANAGES COURT
     1. Add New Court
     2. Edit Court Info
     3. Delete Court Info

4.6 MANAGES COURT MAINTENANCE
     1. Add Court Maintenance
     2. Edit Court Maintenance
     3. Delete Court Maintenance
                                                                                         19
MDec – PHP 5 Developer Training   Futsal Court Management Centre




4.7 MANAGES SALES REPORT
    1. Summarize Sales Report
    2. Court Report
    3. Refreshment Report




                                                              20
MDec – PHP 5 Developer Training                           Futsal Court Management Centre




5 SYSTEM SCREENSHOT

5.1 Introduction


         Basically, the system is categorized into two user modules, which are Staff

Module and Manager Module. We have decided to use EasyPHP package which

included PHP and MySQL for developing environment. The PHP scripting language

is used to design the user interface for client sides and generated information; obtain

scripting command for the server. The MySQL server is server sides of the system

which providing database for the system to manages the information within the user

interface and Futsal Court Management Centre System.




5.2 Manager Module


         Manager is the highest access ability module in the Futsal Court Management

Centre System which has the authority on adding, viewing, editing or updating and

deleting the system information. Manager helps to manage staff information, customer

information, court booking, supplier information, maintenance, view sales report, and

so on.




                                                                                      21
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




                       Figure 3-1. Main Page of Manager Module.




                           Figure 3-2. New Staff Registrations.

                                                                                        22
MDec – PHP 5 Developer Training                           Futsal Court Management Centre




                 Figure 3-3. Search Engine that used when to update the

                                   database records.




    Figure 3-4. Allow manager to delete certain data from the particular database.
                                                                                      23
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




                   Figure 3-5. Manager can print their businees report.




                                                                                        24
MDec – PHP 5 Developer Training   Futsal Court Management Centre




6 Booking Management
6.1 Flowchart




                                                              25
MDec – PHP 5 Developer Training                                    Futsal Court Management Centre




6.2 Date Select




User can choose date up to one month later from current date. To choose the date, simply
click on the calendar.



6.3 Court select




This will view all the courts and its locations. To choose the court just click on the court.



                                                                                                26
MDec – PHP 5 Developer Training                               Futsal Court Management Centre




6.4 Time Select




User can choose the time session in this page. As usually booked by customer nowadays
customer can choose time session of the selected date morning session of next day.

Available session wull be green colored and can be selected while booked session will be red
in color and can not be selected.

6.5 Booking Details




Customer’s name and contact number will be recorded in this page. The Payment Type,
Booking Type also been selected in this page for future reference.

Customer extra request such as refreshment also can be selected in this page.
                                                                                          27
MDec – PHP 5 Developer Training                                Futsal Court Management Centre




Confirmation Page




This page will view the receipt and confirmation of the booking. The booking will be stored in
the system once the ‘main’ button clicked. The booking also can be cancel in this page.




                                                                                            28
MDec – PHP 5 Developer Training                                   Futsal Court Management Centre




7 REPORT
7.1 Summarize Sales Report




This page will view all Booking ID, Date, Customer ID, Customer Name, Price and total Price
related to total sales in the system. This page will also give the user option to export the file
to excel.

7.2 Court Report




This page will view all Booking ID, Date, Court ID, Start Date, Start Time, End Date, End Time
and related to court booking in the system. This page will also give the user option to export
the file to excel.
                                                                                                29
MDec – PHP 5 Developer Training                                Futsal Court Management Centre




7.3 Refreshment Report




This page will view all Booking ID, Date, Type, Quantity and Price related to refresment sales
in the system. This page will also give the user option to export the




                                                                                           30
MDec – PHP 5 Developer Training                             Futsal Court Management Centre




8 TESTING


8.1 Management Login




           Event                    Event            What should happen           Pass/Fail
Wrong username and           Click Login button   Invalid Username or               Pass
password                                          Password
Correct Manager              Click Login button   Redirect to Manager page          Pass
username and password
Correct Staff username       Click Login button   Redirect to Staff page            Pass
and password
In login state               Click Login button   Successful Login                  Pass


                             Figure 8-1: Management Login Testing




                                                                                        31
MDec – PHP 5 Developer Training                               Futsal Court Management Centre




8.2 Add New Staff




                              Figure 8-2 : Add New Staff Testing




          Event                      Event               What should happen          Pass/Fail

When box(es) is empty         Click Add New          Staff                             Pass
                              button                 Enter Staff Surname

When Office Extension         Click Add New          Staff
Number entered contain an     button                 Enter Staff Extension             Pass
Alphabet                                             Number in Numeric Format

Complete information          Click Add New          Staff
inserted into every single    button                 New staff record successfully     Pass
boxes                                                added




                                                                                          32
MDec – PHP 5 Developer Training                                   Futsal Court Management Centre




8.3 Copyright




          Event                        Event              What should happen             Pass/Fail

System Coding cannot be
view or copy by the user          Right Click Mouse          Coding protected              Pass
when they Right Click on                                       (Copyright)
Mouse



                                  Figure 8-3 : Coding Protected




                                                                                              33
MDec – PHP 5 Developer Training                               Futsal Court Management Centre




8.4 Search Function




          Event                      Event               What should happen          Pass/Fail

When box(es) is empty         Click Search button            Enter Staff ID            Pass


When records not exists       Click Search button      No Recors Found In The          Pass
                                                           Staff Database

                              Figure 8-4: Search Function Testing




                                                                                          34
MDec – PHP 5 Developer Training                              Futsal Court Management Centre




9 CONCLUSION


        We have chosen to develop the Futsal Court Management Centre System not

just merely for the sake of doing a project. In fact, we believe that it is indeed a useful

system in the coming future. It is where it really can help people who are doing the

futsal business. Otherwise, we have done a lot of online research about the futsal

system on the internet. Most of the system that we found they are only provides

service for the customer to do online reservation which mean they are not included or

focus on the management site.      From there we gather the information about how to

make the application to have its very own niche so that it will have its own identity.


        However as a students, we choose to do this title because we need to learn new

programming languages, such as PHP and MySQL database. We realized that PHP

language is an easy and common one, but from our point of view, in this mass online

era, web-based language is as important as the offline languages such as C++ and

Visual Basic, and we need to know and utilize them. At the same time, we had learnt

more about Javacript and Html language since we had been exposed with PHP

knowledge in order to complete our main objective in this project.


        Our System was developed using the powerful web application system builder

which is PHP Technology Framework, so this project shows the design and

implementation of a Futsal Court Management Centre System enabled futsal business

owner to provide good service to the customers when they want to manage their court


                                                                                         35
MDec – PHP 5 Developer Training                           Futsal Court Management Centre




booking. This system will provide beneficial features to the user especially for people

who involved in a futsal business and it is useful to those who are looking forward for

a more paperless and systematic business management process.


        The development of this project uses PHP programming language and MySQL

database that can improve web technology in terms of ease of use in development,

scalability and maintainability. The system is designed using PHP and MySQL tools

because it can increase the loading speed of the web page and content delivery for the

web user.


        The Futsal Court Management Centre System details module are implemented

to help the futsal business owner to manage and monitor all their business operation in

proper way. By using this system, customer can easily choose and quickly get the

reservation about any court they want which is one of our objectives.


        The system made convenience enough for future integration with online

booking interface which enables customer to directly reserve after viewing a court. By

implementing the Futsal Court Management Centre System we believe that it can be

replaced the current system that have in the market.




                                                                                      36

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:46
posted:8/15/2012
language:Latin
pages:37
Description: futsal management report. futsal system management