PROJECT REPORT

PROJECT TRACKING SYSTEM

By
[Link]
([Link]:1922J0839)

Guided by

[Link] [Link]., [Link].,

Assistant Professor of Information Technology,
Bharathidasan College of Arts and Science - Erode.

DEPARTMENT OF INFORMATION TECHNOLOGY

BHARATHIDASAN COLLEGE OF ARTS AND SCIENCE
(Co-Educational Institution Affiliated To Bharathiar University Accredited by NAAC)
Erode - 638116.
MAY 2022
 PROJECT TRACKING SYSTEM
Bonafide work done by

[Link]
([Link]:1922J0839)

Project submitted in partial fulfillment of the requirements for the award of Bachelor of Computer
Applications of Bharathidasan College of Arts and Science affiliated to Bharathiar University,
Coimbatore-46.
.

SIGNATURE OF THE GUIDE SIGNATURE OF THE HOD

SIGNATURE OF THE PRINCIPAL

Submitted for the viva-voce examination held on ………………………

INTERNAL EXAMINER EXTERNAL EXAMINER

 DECLARATION
I hereby declare that the project work entitled "PROJECT TRACKING SYSTEM" done at
Bharathidasan College of Arts and Science, Erode submitted to Bharathiar University in partial
fulfillment of requirements for the award of Bachelor of Computer Applications as a record of work
done by me under the guidance of [Link] [Link]., [Link]., Assistant Professor of
Information Technology, Bharathidasan College of Arts and Science, Erode - 638116.

Place :

Date : Signature of the Candidate

[Link]

([Link]:1922J0839)
 ACKNOWLEDGEMENT

I express my profound gratitude to our Chairman Mr. N.K.K. Periasamy, and our beloved
Treasurer Mr. V.R. Murugan for allowing me to undertake this project work. I express my sincere
thanks to Dr. [Link], Principal, Bharathidasan College of Arts and Science, Erode for given me this
fine opportunity to do the project. I wish to express my grateful thanks to Mr. D. Jayanth, [Link].,
[Link] , M.B.A., Head, Department of Information Technology, Bharathidasan College of Arts and
Science, who has provided all the facilities to complete my project successfully.

At outset hereby I express my heartfelt thanks and deep sense of gratitude to my guide
[Link] [Link]., [Link]., Assistant Professor, Department of Information Technology for her
valuable guidance and useful suggestions throughout the project.

I am extremely happy to thank our Bharathidasan College of Arts and Science Management. I
also thank all the staff members of Information Technology Department who extended their help to
complete my project work successfully. I am also thankful to the computer lab programmers for their
kind co-operation. I also thank our Librarian for the support in completing my project work.

Last but not the least, I proudly thank and express my gratefulness to all my friends for the kind
help rendered by them. I extend my heartfelt gratitude to my parents.

[Link]
 PROJECT TRACKING SYSTEM

SYNOPSIS

Project Tracker is a simple, fast, accurate and easy to use with flexible options for
viewing the essential details. The solution is best suited for individuals working on various
projects, which helps to keep track of all the Projects and their Schedules. Project Scheduler also
helps you to back & restore your work in a file so that you can always have a backup file to be
restored to the application just in case you lose your data accidentally. You can add any number
of schedules to be done for each existing projects using the Project scheduler. In This system
each schedule can be tracked from the start till the end of the Project cycle. You can track the
below details for each schedule:

• Project for whom the schedule is to be done,

• You’re Rate/Hour for this particular work to be done.

• Start and End date of the project.

• Total working hours of a day (adjusted with the break time option).

• Current status and Percentage of work completed (Progress Bar).

• Payment amount pending from the project

The project has been planned to be having the view of distributed architecture, with
centralized storage of the database. The application for the storage of the data has been planned.
Using the constructs of MySQL Server and all the user interfaces have been designed using the
PHP technologies.
 CONTENT
CHAPTER TITLE PAGE
NO
1 INTRODUCTION 1
1.1 ABOUT THE PROJECT 1

2 SYSTEM ANALYSIS 4
2.1 EXISTING SYSTEM 4
2.2 PROPOSED SYSTEM 4
2.3 FEASIBILITY STUDY 5

3 SYSTEM SPECIFICATION 7

3.1 HARDWARE SPECIFICATION 7

3.2 SOFTWARE SPECIFICATION 7

3.3 SOFTWARE DESCRIPTION 8

4 SYSTEM DESIGN 15

15
4.1 INPUT DESIGN
17
4.2 CODE DESIGN
18
4.3 OUTPUT DESIGN
20
4.4 DATABASE DESIGN
4.5 DATA FLOW DIAGRAM 27
5 SYSTEM TESTING 29
6 SYSTEM IMPLEMENTATION 31
7 CONCLUSION 32
8 SCOPE OF FUTURE DEVELOPMENT 33
BIBLIOGRAPHY 34
APPENDIX 35
CODING 35
FORMS 48
REPORTS 53
 CHAPTER 1

INTRODUCTION

1.1 ABOUT THE PROJECT :

The Aim of the Project is latest generation Web Based System for Managing and
Tracking Software Development Projects. It is called "Project Tracking" for a good reason - it
was specifically designed to make software project management hassle free and straightforward.
These robust technologies provide with a scalable and flexible solution to manage and track
projects of any complexity level.

The Project Tracking System was initially developed to document, prioritize and track
the progress of internal Remedy projects by setting milestones and establishing deliverables
required to complete a project. As the application became more robust, other groups became
interested in using Project Tracking to manage their own projects.

The Project Tracking can be displayed in two different modes: Save mode and Search
mode. Save mode is indicated in Project Tracking by the Save button located in the upper right
corner of the form and is used to create or modify requests. Search mode is indicated in Project
Tracking by the Search button located in the upper right corner of the form and is used to find an
existing request.

ADMINISTRATOR :

The administrator is the super user of this application. Anybody except admin cannot enter into
this page. The admin can give authenticate to user & gives privileges that which portion they can access.
The admin can create new users. The administrator has all the information about all the users & about
all the projects. There is two-sub module of administrator

 Projects: - This contains the information about all the projects i.e. project list, and also
information about manager of the project, starting date and completion date etc.

1
 Users: - This contains the information about all the users and role of the users.
 Time Period: - Here Admin will add all the project timings from when the project has
started and when it has to complete and the client to them will give this time. Based on
the timing he will assign the task to the employee.
 Rate / Hours: - Here Admin will decide all the charges for the project and he will assign
the hours for the project in between the employee in how many hour what task to be
completed and what task to be done.

 Project status: - Project Status is decided based on the student and what the task they have
doing in the project is and daily employee has to give the status of the project which was
given to them by the higher authority.

EMPLOYEE:

This module is actual workplace for a member’s or Employee i/e. for authenticates users. In this
module the users take care of his project i.e. how many project he/she handle. I.e. all the documents
about the projects, project activities, starting date & completion date of the project. And assign that to
which team to develop which project, which is the project leader of this project, who is the programmer
etc.

PROJECTS LIST:

This module handles a specific project. In this new project can be added. This handles all the tasks
of the project. Complete List of the project should be add in the organization and the task should be add
in the list by admin.

CLIENT:

This module contains complete information about the client. Client is the person who
provides the project to the organization and he gives the complete starting date and ending date
and all the specification of the project and the specific requirement where the project to be
developed.

2
REPORTS:

This module contains all the information about the reports generated by the Employees,
Status Report and Report based on work of the Employee.

AUTHENTICATION:

This module contains all the information about the authenticated user. User without his
username and password can’t enter into the login if he is only the authenticated user then

he can enter to his login and he can see the all the information related to the project which
he is developing.

3
 CHAPTER 2

SYSTEM ANALYSIS

2.1 EXISTING SYSTEM

In the Existing system the organization are not properly maintained every details. In this
type of system, it becomes difficult to track a particular person status. There is no efficient
search technique. One has to search the whole database for the details of particular error which
might have occurred sometime earlier. It is both time consuming and error prone. The existing
system not efficient to track current status of the project and project task allocation.

2.1.1 DRAWBACKS OF EXISTING SYSTEM

 Cannot Upload and Download the latest updates.

 No use of Web Services and Remoting.
 Risk of mismanagement and of data when the project is under development.
 Less Security.
 No proper coordination between different Applications and Users.
 Fewer Users - Friendly.

2.2 PROPOSED SYSTEM

The proposed system has many advantages over the existing system. The system
maintains the country, state and the status of project. It would not be difficult for the user to
know how much effort spent on the status. It also provides the advantage of maintaining a list
of users who are assigned with the project and details about the resolutions provided by them.
The development of the new system contains the following activities, which try to automate
the entire process keeping in view of the database integration approach.

4
2.2.1 ADVANTAGES OF PROPOSED SYSTEM

 User friendliness is provided in the application with various controls.

 The system makes the overall project management much easier and flexible.
 Readily upload the latest updates, allows user to download the alerts by clicking the
URL.
 There is no risk of data mismanagement at any level while the project development is
under process.
 It provides high level of security with different level of authentication.

2.3 FEASIBILITY STUDY

A feasibility study tests the viability of an idea, a project or even a new business. The
goal of a feasibility study is to place emphasis on potential problems that could occur if a project
is pursued and determine if, after all significant factors are considered, the project should be
pursued. Feasibility studies also allow a business to address where and how it will operate,
potential obstacles, competition and the funding needed to get the business up and
[Link] studies allow companies to determine and organize all of the necessary details
to make a business work. A feasibility study helps identify logistical problems, and nearly all
business-related problems, along with the solutions to alleviate them. Feasibility studies can also
lead to the development of marketing strategies that convince investors or a bank that investing
in the business is a wise choice.

There are several components of a feasibility study:

 Description
 Market feasibility
 Technical feasibility
 Financial feasibility
 Organizational feasibility

5
Description:

A layout of the business, the products and/or services to be offered and how they will be
delivered.

Market feasibility:

It describes the industry, the current and future market potential, competition, sales
estimations and prospective buyers. We will begin by describing what a market and feasibility
study is and its place in the development process. Next, we will examine who uses these studies,
who writes them and what types of market studies exist. Then we will go through the steps in
performing a market study. Next, we provide some advice on delivering the results. We conclude
with a look at common errors made in the process.

Technical feasibility:

It lays out details on how a good or service will be delivered, which includes
transportation, business location, technology needed, materials and labor.

Financial feasibility:

A projection of the amount of funding or startup capital needed, what sources of capital
can and will be used, and what kind of return can be expected on the investment.

Organizational feasibility:

A definition of the corporate and legal structure of the business; this may include
information about the founders, their professional background and the skills they possess
necessary to get the company off the ground and keep it operational. A professional certification
for those who have completed the educational program on life and health insurance research and
planning. The Associate In Research and Planning certification is awarded by the Insurance
Institute of America. It concentrates on market feasibility analysis for insurance companies,
which includes loss projections and risk margins of expected and higher-than-expected levels of
loss.
6
 CHAPTER 3

SYSTEM SPECIFICATION

3.1 HARDWARE SPECIFICATION

PROCESSOR : I3 PROCESSOR

RAM : 4GB

HARD DISK : 500 GB

KEY BOARD : STANDARD 104 KEYS

MONITOR : 15 INCH MONITOR

: OPTICAL MOUSE
MOUSE

3.2 SOFTWARE SPECIFICATION

OPERATING SYSTEM : WINDOWS 10

FRONT END : PHP

BACK END : MY-SQL

7
3.3 SOFTWARE DESCRIPTION FEATURES OF PHP

PHP is a widely-used, open source scripting language used for scripts that are executed
on the server and it is freeware. It is a server side scripting language used to develop attractive
and dynamic web pages. PHP is widely-used, free, and efficient alternative to competitors such
as Microsoft’s [Link] make available with database used with PHP is MYSQL – which is also
an open source which is an added advantage. PHP’s simple programming style, we attempt to
design in a way that enables anyone with basic programming knowledge to learn and shift to
never-ending opportunity available.

PHP started out as a small open source project that evolved as more and more people
found out how useful it was. Rasmus Lerdorf unleashed the first version of PHP way back in
1994.

• PHP is a recursive acronym for "PHP: Hypertext Preprocessor".

• PHP is a server side scripting language that is embedded in HTML. It is used to manage
dynamic content, databases, session tracking, even build entire ecommerce sites.

• It is integrated with a number of popular databases, including MySQL, PostgreSQL,

Oracle, Sybase, Informix, and Microsoft SQL Server.

• PHP is pleasingly zippy in its execution, especially when compiled as an Apache module
on the Unix side. The MySQL server, once started, executes even very complex queries
with huge result sets in record-setting time.

• PHP supports a large number of major protocols such as POP3, IMAP, and LDAP. PHP4
added support for Java and distributed object architectures (COM and CORBA), making
n-tier development a possibility for the first time.

• PHP is forgiving: PHP language tries to be as forgiving as possible.

• PHP Syntax is C-Like.

8
COMMON USES OF PHP

• PHP performs system functions, i.e. from files on a system it can create, open, read, write, and
close them.
• PHP can handle forms, i.e. gather data from files, save data to a file, through email you can send
data, return data to the user.
• You add, delete, modify elements within your database through PHP.
• Access cookies variables and set cookies.
• Using PHP, you can restrict users to access some pages of your website.
• It can encrypt data.

CHARACTERISTICS OF PHP

Five important characteristics make PHP's practical nature possible −

• Simplicity
• Efficiency
• Security
• Flexibility
• Familiarity
In order to develop and run PHP Web pages three vital components need to be installed on your
computer system.

• Web Server − PHP will work with virtually all Web Server software, including
Microsoft's Internet Information Server (IIS) but then most often used is freely available
Apache Server.
• Database − PHP will work with virtually all database software, including Oracle and
Sybase but most commonly used is freely available MySQL database.
• PHP Parser − In order to process PHP script instructions a parser must be installed to
generate HTML output that can be sent to the Web Browser. This tutorial will guide you
how to install PHP parser on your computer.

9
PHP Parser Installation

Before you proceed, it is important to make sure that you have a proper environment
setup on your machine to develop your web programs using PHP. If this displays a page showing
your PHP installation related information, then it means you have PHP and Webserver installed
properly. Otherwise you have to follow given procedure to install PHP on your computer. This
section will guide you to install and configure PHP over the following four platforms:

• PHP Installation on Linux or Unix with Apache

• PHP Installation on Mac OS X with Apache

• PHP Installation on Windows NT/2000/XP with IIS

• PHP Installation on Windows NT/2000/XP with Apache

Apache Configuration

If you are using Apache as a Web Server then this section will guide you to edit Apache
Configuration Files.

[Link] File Configuration

The PHP configuration file, [Link], is the final and most immediate way to affect PHP's
functionality.

Windows IIS Configuration

To configure IIS on your Windows machine you can refer your IIS Reference Manual
shipped along with IIS.

Escaping to PHP
The PHP parsing engine needs a way to differentiate PHP code from other elements in the
page. The mechanism for doing so is known as 'escaping to PHP'. There are four ways to do this.

10
What are HTML tags?

• HTML tags are used to mark-up HTML elements ƒ

• HTML tags are surrounded by the two characters < and >ƒ
• The surrounding characters are called angle brackets ƒ
• HTML tags normally come in pairs like and ƒ
• The first tag in a pair is the start tag, the second tag is the end tag ƒ
• The text between the start and end tags is the element content
• HTML tags are not case sensitive, means the same as
CakePHP

CakePHP is an open-source web framework. It follows the model–view–

controller (MVC) approach and is written in PHP, modeled after the concepts of Ruby on Rails,
and distributed under the MIT License.

CakePHP uses well-known software engineering concepts and software design patterns,
such as convention over configuration, model–view–controller, active record, association data
mapping, and front controller.

FEATURES of PHP

It is most popular and frequently used worldwide scripting language, the main reason of
popularity is; It is open source and very simple.

• Simple

• Faster

• Interpreted

• Open Source

• Case Sensitive

• Simplicity

• Efficiency

• Platform Independent

11
• Security

• Flexibility

Simple

It is very simple and easy to use, compare to other scripting language it is very simple
and easy, this is widely used all over the world.

Interpreted

It is an interpreted language, i.e. there is no need for compilation.

Faster

It is faster than other scripting language e.g. asp and jsp.

Open Source

Open source means you no need to pay for use php, you can free download and use.

Platform Independent

PHP code will be run on every platform, Linux, Unix, Mac OS X, Windows.

Case Sensitive

PHP is case sensitive scripting language at time of variable declaration. In PHP, all
keywords (e.g. if, else, while, echo, etc.), classes, functions, and user-defined functions are
NOT case-sensitive.

Introduction of SQL

Introduction The Structured Query Language (SQL) is the language of databases. SQL
was, is, and will stay for the foreseeable future the database language for relational database

12
servers such as IBM DB2, Microsoft SQL Server, MySQL, Oracle, Progress, Sybase Adaptive
Server, and dozens of others. SQL supports a small but very powerful set of statements for
manipulating, managing, and protecting data stored in a database. This power has resulted in its
tremendous popularity. Almost every database server supports SQL or a dialect of the language.
Currently, SQL products are available for every kind of computer, from a small handheld
computer to a large server, and for every operating system, including Microsoft Windows, Mac
and many UNIX variations.

What is a Database?

A database is a structured collection of data that is used by the application systems of

some given enterprise, and that is managed by a database management system. For the purpose
of this course, think of a database as a collection of tables which are connected to each other. IT
Learning Programme (ITLP) in the University of Oxford offers a course on how to design a
database. This course is a pre-requisite to this course. However, if you did not attend the database
designing course, please read the following paragraphs. As we mentioned, a database is a
collection of tables. Each table is similar to a spreadsheet table in which each row is called a
record and each column is called a field.

What is SQL?

Structured Query Language (SQL) is a relational database language which allows you to
create, delete, access and manipulate databases. The following is a list of the main operations that
can be formulated with SQL:

• Creating new databases

• Deleting a database

• Creating new tables in a database

• Deleting tables from a database

• Creating and removing users (database access control)

13
• Executing queries against a database o retrieving data from a database o inserting records in a
database o updating records in a database o deleting records from a database

• Creating stored procedures in a database

• Setting permissions on tables and procedures

MySQL

MySQL is a Relational Database Management System (“RDBMS”). It is used by most

modern websites and web-based services as a convenient and fast-access storage and retrieval
solution for large volumes of data. A simple example of items which might be stored in a
MySQL database would be a site-registered user’s name with associated password (encrypted for
security), the user registration date, and number of times visited, etc.

MySQL can also be accessed using many tools. It can be easily communicated with via
PHP (PHP Hypertext Preprocessor), a scripting language whose primary focus is to manipulate
HTML for a webpage on the server before it is delivered to a client’s machine. A user can submit
queries to a database via PHP, allowing insertion, retrieval and manipulation of information
into/from the database.

Installation Guide to use MySQL

MySQL can be downloaded from [Link] There are also

several MySQL management tools which can be downloaded and installed to allow the
manipulation of MySQL. These tools mainly provide an interface to operate on MySQL. Many
of these tools are free and provide an easy configuration of MySQL with PHP, e.g., XAMPP,
WampServer, AMPPS . Another free MySQL management system is MySQL workbench. It
provides database administrators and developers an integrated environment for database design
and modelling, SQL development, database administration, database migration. In this course we
will be using XAMPP because it is straightforward to install and use.

14
 CHAPTER 4

SYSTEM DESIGN

4.1 INPUT DESIGN

Input design is a process of converting a user-oriented description of the input to the

computer-based system. This design is important to avoid errors in the input process and show
the correct direction to the management for getting the correct information from the
computerized system.

A source document differs from a turnaround document in that the former contains data that
change the status of a resource while the latter is a machine readable document. Transaction
throughput is the number of error-free transactions entered during a specified time period. A
document should be concise because longer documents contain more data and so take longer to
enter and have a greater chance of data entry errors.

Input design must be in such a way that it must control the amount of input, avoid delay,
etc. It must be simple. The input design must ensure user-friendly screen, with simplicity,
providing ease of viewing & entering the data. Every input data is validating. If the data is not
valid, proper error message are displayed. The main objective of designing input focus on:

 Controlling the amount of input required.

 Avoiding delayed response.
 Controlling errors.
 Keeping process simple.
 Avoiding errors
In this project we have these kinds of inputs,

15
INSERT NEW CLIENT
 In this form is used to add new client details like as Client name, address, Phone no,
country, state, city, gender and etc.

INSERT NEW PROJECT LEADER

 In this form is used to stored new project leaders like as Name, address, Phone no,
Country, state, city , assign username and password also include secret word.
INSERT NEW PROGRAMMER
 In this form is used to stored new programmers like as Name , address , Phone no,
Country , state , city , specialization , assign username and password also include
secret word.
INSERT NEW PROJECT
 In this form is used to insert a new project like as Project Title, project
description, project value, start date, client name, period and technology.
ASSIGN PROJECT
 The assign project form is used to allocate a project to particular member like as In
this form is used to insert a new project like as Project Title, project description,
project value, start date, client name, period and technology.

16
4.2 CODE DESIGN

The primary goal of the code design is to write a source code and internal
documentation for that conformation of the code design it specification. The can be easily
make verification, debugged, tested & modified code design is necessary when ever large
amount of data is processed.

<?php include

'config/[Link]';

require_once '[Link]';

$obj->connect();

session_start();

if($_SESSION['aid'] != '')

The code design should be such that with less amount of coding user can achieve more
result. The speed of the system is more if the coding is less where the data in system is
usable and readable by the system is depending on the coding. In this project coding using
PHP.

17
4.3 OUTPUT DESIGN

Computer output is the most important and direct source of information to the user. Efficient
intelligible output design should improve the system relationship with the user and help in decision
making. Output design generated refers to the results generated by the system. The output of a system
can take many forms. The most common are screen displays, printed forms and graphical drawings.

The output a screen displays the result for each image process in the project and also shows
the newly draw images and images are presented already in the system. These screens are being
built using Visual Basic Tools. The output screens are designed in such a way that they generate
the results necessary for the organization.

The normal procedure in developing a system is to design the output in detail first and then
move back to the input. The output will be in the form of views.

The output from the system is required to communicate the result of processing to the users.
They are also used as the permanent copy for later verifications.

Output Design Consideration

The purpose of outputs has been understood and the efficiency of information contained
should be analyzed and conformed. Then the output have been defined in terms of

 Name of the Output.

 Content
 Format
 Frequency

Name of the Output

Names are given to output information based on the output, which is required.

18
Content

The content of the output must be in such a way that it must prevent redundancy, the data
produced must be accurate and reliable and the output must furnish relevant data.

Format

The format has been designed in analysis according to the user need and in importing
table output formats as standard. It has been based on permanent copy i.e., Hard copy.

Frequency

The frequency of the output should be maintained according to the user’s needs .In this
project we have this kind of output screens,

VIEW CURRENT PROJECT

 View the current project details form is used to identify project current level. In
this form contain many fields such as Project title, started date, client name and
etc.
VIEW PAYMENT DETAILS
 View the payment details form is used to identify project payment details. In this
form contain many fields such as client name, amount and etc.

4.4 DATABASE DESIGN

Database design is the process of producing a detailed data model of a database. This
logical data model contains all the needed logical and physical design choices and physical
storage parameters needed to generate a design in a Data Definition Language, which can then be
used to create a database. A fully attributed data model contains detailed attributes for each entity.

19
 The term database design can be used to describe many different parts of the design of an
overall database system. Principally, and most correctly, it can be thought of as the logical design
of the base data structures used to store the data. In the relational model these are the tables and
views. In an object database the entities and relationships map directly to object classes and
named relationships. However, the term database design could also be used to apply to the
overall process of designing, not just the base data structures, but also the forms and queries used
as part of the overall database application within the database management system (DBMS).

Conceptual schema

Once a database designer is aware of the data which is to be stored within the database,
they must then determine where dependency is within the data. Sometimes when data is changed
you can be changing other data that is not visible. For example, in a list of names and addresses,
assuming a situation where multiple people can have the same address, but one person cannot
have more than one address; the name is dependent upon the address, because if the address is
different, then the associated name is different too. However, the other way around is different.
One attribute can change and not another.

Physical database design

The physical design of the database specifies the physical configuration of the database on
the storage media. This includes detailed specification of data elements, data types, indexing
options and other parameters residing in the DBMS data dictionary. It is the detailed design of a
system that includes modules & the database's hardware & software specifications of the system.

Logically structuring data

Once the relationships and dependencies amongst the various pieces of information have
been determined, it is possible to arrange the data into a logical structure which can then be
mapped into the storage objects supported by the database management system. In the case of
relational databases the storage objects are tables which store data in rows and columns.

Each table may represent an implementation of either a logical object or a relationship

joining one or more instances of one or more logical objects. Relationships between tables may

20
then be stored as links connecting child tables with parents. Since complex logical relationships
are themselves tables they will probably have links to more than one parent.

In an Object database the storage objects correspond directly to the objects used by the
Object-oriented programming language used to write the applications that will manage and
access the data. The relationships may be defined as attributes of the object classes involved or as
methods that operate on the object classes.

21
TABLE STRUCTURE

ADMIN LOGIN

Primary key: Adminloginid

Description: Used to store login details

[Link] FIELD DATA TYPE SIZE CONSTRAINT DESCRIPTION

1 Adminloginid varchar 10 Primary key Admin login

2 password varchar 10 Not null password

CITY DETAILS

Primary key: cityid

Description: Used to store city details

[Link] FIELD DATA TYPE SIZE CONSTRAINT DESCRIPTION

1 cityid int 10 Primary key City id

2 cityname varchar 20 Not null City name

3 Citydescription varchar 30 Not null City description

4 Stateid int 10 Not null State id

5 Countryid int 10 Not null Country id

6 statusid int 10 Not null Status id

22
 CLIENT DETAILS

Primary key: clientid

Description: Used to store client details

[Link] FIELD DATA TYPE SIZE CONSTRAINT DESCRIPTION

1 Clientdetailsid int 10 Not null Client details id

2 Clientid int 10 Primary key Client id

3 address varchar 20 Not null Address

4 cityid int 10 Not null City id

5 stateid int 10 Not null State id

6 countryid int 10 Not null Country id

7 Emailid varchar 20 Not null Email id

8 contactno varchar 10 Not null Contact no

9 statusid int 10 Not null Status id

23
PROJECT DETAILS

Primary key: projectid

Description: Used to store project details

[Link] FIELD DATA TYPE SIZE CONSTRAINT DESCRIPTION

1 projectid int 10 Primary key Project id

2 projectname varchar 20 Not null Project name

3 startingdate datetime 10 Not null Starting date

4 endingdate datetime 10 Not null Ending date

5 Projecttakendate datetime 10 Not null Project taken

date

6 deliverydate int 10 Not null Delivery date

7 projecttypeid int 10 Not null Project type id

8 clientid int 10 Not null Client id

9 statusid int 10 Not null Status id

10 totaltasks int 10 Not null Total tasks

11 completedtasks int 10 Not null Completed tasks

24
DEPARTMENT

Primary key: deptid

Description: Used to store department details

[Link] FIELD DATA TYPE SIZE CONSTRAINT DESCRIPTION

1 deptid int 10 Primary key Department id

2 deptname varchar 20 Not null Department name

3 Deptdescription varchar 30 Not null Description

CLIENT LOGIN

Primary key: clientid

Description: Used to store client login details

[Link] FIELD DATA TYPE SIZE CONSTRAINT DESCRIPTION

1 clientid int 10 Primary key Client id

2 clientloginid varchar 10 Not null Client login id

3 password varchar 10 Not null password

25
PROJECT TYPE

Primary key: projecttypeid

Description: Used to store project type details

[Link] FIELD DATA TYPE SIZE CONSTRAINT DESCRIPTION

1 projecttypeid int 10 Primary key Project type id

2 Projecttypename varchar 20 Not null Project type name

3 description varchar 30 Not null Description

26
4.5DATA FLOW DIAGRAM

LEVEL 1

27
LEVEL 2

28
 CHAPTER 5

SYSTEM TESTING

System testing makes a logical assumption that, if all parts of the systems are correct.
System testing is its utility as a user oriented vehicle before implementation. The best program
is worthless if it does not meet user needs. System testing identifies the errors, presenting the
proposal to the administration and changes the modification and also checks the reliability of
output. Before implementation, the system is tested whether the required software and hardware
are available to run this project.

UNIT TESTING

The primary goal of unit testing is to take the smallest piece of testable software in the
application, isolate it from the remainder of the code, and determine whether it behaves exactly as
you expect. Each unit is tested separately before integrating them into modules to test the
interfaces between modules. Unit testing has proven its value in that a large percentage of defects
are identified during its use.

The procedure level testing is made first. By giving improper inputs, the errors occurred
are noted and eliminated. Then the form level testing is made. For example, storage of data to the
table is in the correct manner. In this system, each form is considered as a separate unit and
tested for errors. Every user input is unit tested for a valid accepted range

INTEGRATION TESTING

Integration testing (sometimes called Integration and Testing, abbreviated "I&T" is the
phase in software testing in which individual software modules are combined and tested as a
group. It occurs after unit testing and before system testing. Integration testing takes as its input
modules that have been unit tested, groups them in larger aggregates, applies tests defined in an
integration test plan to those aggregates, and delivers as its output the integrated system ready for
system testing.

29
 The purpose of integration testing is to verify functional, performance, and reliability
requirements placed on major design items. These "design items", i.e. assemblages (or groups of
units), are exercised through their interfaces using Black box testing, success and error cases
being simulated via appropriate parameter and data inputs.

Testing is done for each module. After testing all the modules, the modules are integrated
and testing of the final system is done with the test data, specially designed to show that the
system will operate successfully in all its aspects conditions. Thus the system testing is a
confirmation that all is correct and an opportunity to show the user that the system works.

VALIDATION TESTING

Validation can be defined in many ways, but a simple definition is that can be reasonable
expected by the clients, which is defined in the software requirement specification, a document
that describes all user visible attribute of the software.

30
 CHAPTER 6

SYSTEM IMPLEMENTATION

Implementation is the most crucial stage in achieving a successful system and giving
the user’s confidence that the new system is workable and effective. Implementation of a
modified application to be replaced an existing one. This type of conversation is relatively easy
to handle, provide there are no major changes in the system.

Each program is tested individually at the time of development using the data and has
verified that this program linked together in the way specified in the programs specification, the
computer system and its environment is tested to the satisfaction of the user. The system that has
been developed is accepted and proved to be satisfactory for the user. And so the system is going
to be implemented very soon. A simple operating procedure is included so that the user can
understand the different functions clearly and quickly.

Initially as a first step the executable form of the application is to be created and
loaded in the common server machine which is accessible to all the user and the server is to be
connected to a network. The final stage is to document the entire system which provides
components and the operating procedures of the system.

System Maintenance

Maintenance is necessary to eliminate errors in the system during its working life and to
tune the system to any variations in its working environment. It has been seen that there are
always some errors found in the system that must be noted and corrected. It also means the
review of the system from time to time. The review of the system is done for:

 Knowing the full capabilities of the system

 Knowing the required changes or the additional requirements
 Studying the performance. If a major change to a system is needed, a new project may
have to be setup to carry out the change. The new project will then process through all the
above life cycle phases.

31
 CHAPTER 7
CONCLUSION

It has been a great pleasure for me to work on this exciting and challenging project. This
project proved good for me as it provided practical knowledge of not only programming in PHP
web based application and no some extent Windows Application and MYSQL Server, but also
about all handling procedure related with “PROJECT TRACKING SYSTEM”. It also
provides knowledge about the latest technology used in developing web enabled application and
client server technology that will be great demand in future. This will provide better
opportunities and guidance in future in developing projects independently.

The project is identified by the merits of the system offered to the user. The merits of this
project are as follows: It’s a web-enabled project. This project offers user to enter the data
through simple and interactive forms. To compress the project time, project managers have to
accelerate some activities at an additional expense during project tracking. Different decisions
will be taken regarding time and cost of each activity for overall network, the set of decisions
that result will contribute to desirable time, cost and realization of time cost trade off problem.

32
 CHAPTER 8

SCOPE OF FUTURE ENHANCEMENT

Tracking is the process of arranging, controlling and optimizing work and workloads in a
production process or manufacturing process. Tracking is used to allocate plant and machinery
resources, plan human resources, plan production processes and purchase materials. Forward
tracking is planning the tasks from the date resources become available to determine the shipping
date or the due date. Backward tracking is planning the tasks from the due date or required-by
date to determine the start date and/or any changes in capacity required.
A schedule or a timetable, as a basic time-management tool, consists of a list of times at
which possible tasks, events, or actions are intended to take place, or of a sequence of events in
the chronological order in which such things are intended to take place. The process of creating a
schedule - deciding how to order these tasks and how to commit resources between the varieties
of possible tasks - is called tracking, and a person responsible for making a particular schedule
may be called a scheduler.

33
 BIBLIOGRAPHY
Websites Referred
 [Link]
 [Link]
 [Link]/php
 [Link]/phpT
 [Link]

Books Referred
 PHP Reference: Beginner to Intermediate PHP5
By Mario Lurig
 Programming PHP
By Kevin Tatroe, Peter MacIntyre, Rasmus Lerdorf
 Php: The Complete Reference By Steven Holzner
 Pro PHP MVC
By Chris Pitt

34
A. SAMPLE CODING

<?php

include 'config/[Link]'; require_once

'[Link]';

$obj->connect(); session_start();

if($_SESSION['aid'] != '')

$ar = $_SESSION['aid'];

$tmp= $obj->selectwhere("user","id='$ar'");

// $pass=0;

// $id = '';

$row = mysql_fetch_array($tmp);

// $chat =$obj->select("chat");

$notification= $obj->selectwhere("noty","uemail='$row[3]'");

$todos= $obj->selectcamp("todos","assign_user_id='$row[3]' and is_completed=''");

$camp= $obj->select("tasking");

$username=""; $campdata =""; while

($tk = mysql_fetch_array($camp))

{ $username =$tk[1];

$myArray = explode(',', $username);

35
 foreach ($myArray as $value) {

if($value == $row[3])

$ttamp=0;

if($ttamp < 5)

$pr =$tk[8];

$clr ="";

if($pr=="High")

$clr = "<b><span style='color: red'>".$pr."</span></b>";

if($pr == "Medium")

$clr = "<b><span style='color: #ffcccc'>".$pr."</span></b>";

if($pr == "Low")

$clr = "<b><span style='color:blue'>".$pr."</span></b>";

$ttamp=$ttamp+1;
36
 $cid = urlencode(encryptor('encrypt', $tk[0]));

$campdata.="<a style='text-decoration: none'

href='campaign_detail.php?id=$cid'/><i class='fa fa-folder-open fa-2x'></i>";

$campdata.="<br>Create by :
".$tk[13]."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br> Campaign Name :
<span style=color:maroon>". $tk[2]."<br></span> Priority : ".
$clr."<br> Detail : <span style=color:maroon>".
$tk[12]."</span><br><br></a><hr style='display: block;height: 1px;border:
0;border-top: 1px solid #ccc;margin: 1em 0; padding: 0;'>";

else

?>

<html lang="en">

<head>

<meta charset="utf-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

37
<meta name="description" content="">

<meta name="author" content="">

<title>OTM</title>

<link href="bower_components/bootstrap/dist/css/[Link]" rel="stylesheet">

<link href="bower_components/metisMenu/dist/[Link]" rel="stylesheet">

<link href="dist/css/[Link]" rel="stylesheet">

<link href="dist/css/[Link]" rel="stylesheet">

<link href="bower_components/morrisjs/[Link]" rel="stylesheet">

<link href="bower_components/font-awesome/css/[Link]"
rel="stylesheet" type="text/css">

<script src="dist/js/[Link]"></script>

<script type="text/javascript" src="js/[Link]">

</script>

<?php // <script
src="[Link] ?>

<link rel="stylesheet" href="dist/css/[Link]" />

<script src="js/[Link]"></script>

<!--pqSelect dependencies-->

<script type="text/javascript" src="js/notification_1.js"></script>

<script type="text/javascript" src="js/[Link]"></script>

<script type="text/javascript" src="js/[Link]"></script>

</head>

38
<body>

<div id="wrapper">

<!-- Navigation -->

<nav class="navbar navbar-default navbar-static-top" role="navigation" style="margin-bottom:

0">

<div class="navbar-header">

<button type="button" class="navbar-toggle" data-toggle="collapse" data-

target=".navbarcollapse">

<span class="sr-only">Toggle navigation</span>

<span class="icon-bar"></span> <span

class="icon-bar"></span> <span

class="icon-bar"></span>

</button>

<a class="navbar-brand" href="[Link]" style="font-family: fantasy;font-size: 50px;color:

#0075b0"><img src="[Link]" width="160px" height="30px"></img></a>

</div>

<!-- /.navbar-header -->

<?php include '[Link]'; ?>

<!-- /.navbar-top-links -->

<?php include '[Link]'; ?>

39
<!-- /.navbar-static-side -->

</nav>

<div id="page-wrapper">

<div class="row">

<div class="col-lg-12">

<h1 class="page-header heading">Recent</h1>

</div>

<!-- /.col-lg-12 -->

</div>

<!-- /.row -->

<!-- /.row -->

<div class="row">

<div class="col-lg-4">

<div class="panel panel-green">

<div class="panel-heading">

Todo's

</div>

<div class="panel-body" style="overflow: scroll;height: 480px;">

<?php

$tdtamp11=0;

while ($tds = mysql_fetch_array($todos)) {

40
 if($tdtamp11 <5)

/* $day ="";

$month = "";

$year = "";

$datedata = explode('/',$tds[6]);

$day =$datedata[0];

$month=$datedata[1];

$year=$datedata[2];

echo date("Y"); echo

date("m"); echo

date("d");

$clr1 ="";

if(date("Y") == $year)

$clr1 = "<b><span style='color: red'>".$pr."</span></b>";

if($pr == "Medium")

$clr1 = "<b><span style='color: #ffcccc'>".$pr."</span></b>";

if($pr == "Low")

$clr1 = "<b><span style='color:blue'>".$pr."</span></b>";

41
 }*/

$tdtamp11=$tdtamp11+1;

$cids = urlencode(encryptor('encrypt', $tds[0]));

echo "<a style='text-decoration: none' href='[Link]?id=$cids'/><i

class='fa fa-folder-open fa-2x'></i>";

echo "<br>Create by : ".$tds[2]."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>

Title : <span style=color:maroon>". $tds[4]."<br></span> Todo Due Date : ".
$tds[6]."<br><br></a>";

?>

<hr style="display: block;height: 1px;border: 0;border-top: 1px solid #ccc;margin: 1em 0;

padding: 0;">

<?php }

else

?>

<?php } ?>

</div>

<div class="panel-footer">

Todo's

</div>

</div>

<!-- /.col-lg-4 -->

42
</div>

<div class="col-lg-4">

<div class="panel panel-yellow">

<div class="panel-heading">

Notification <span style="text-align:center"><a style="color: white;paddingleft:

150px;" href="[Link]">Clear All</a></span>

</div>

<div class="panel-body" style="overflow: scroll;height: 480px;">

<?php

$ntamp=0;

while ($dt = mysql_fetch_array($notification)) {

$ntamp=$ntamp+1; echo $dt[1]."<br><span

style=color:grey;padding-left:140px> Date :". $dt[3]."</span><br>"; ?>

<hr style="display: block;height: 1px;border: 0;border-top: 1px solid #ccc;margin: 1em 0;

padding: 0;">

<?php } ?>

</div>

<div class="panel-footer">

Notification

</div>

</div>

<!-- /.col-lg-4 -->

</div>

<div class="col-lg-4">
43
<div class="panel panel-red">

<div class="panel-heading">

Campaign

</div>

<div class="panel-body" style="overflow: scroll;height: 480px;">

<p ><?php

echo $campdata;

?></p>

</div>

<div class="panel-footer">

Campaign

</div>

</div>

<!-- /.col-lg-4 -->

</div>

</div>

</div>

<?php // <script src="bower_components/jquery/dist/[Link]"></script> ?>

<!-- Bootstrap Core JavaScript -->

<script src="bower_components/bootstrap/dist/js/[Link]"></script>

44
<!-- Metis Menu Plugin JavaScript -->

<script src="bower_components/metisMenu/dist/[Link]"></script>

<!-- Morris Charts JavaScript -->

<script src="bower_components/raphael/[Link]"></script>

<script src="bower_components/morrisjs/[Link]"></script>

<script src="js/[Link]"></script>

<script src="dist/js/[Link]"></script>

</body>

</html>

<?php

} else

{ header("location:[Link]

");

?>

45
B. FORMS

HOME PAGE

46
ADDING GROUP

47
ADDING USER

48
ADDING TASK

49
ADDING GROUP TASK

50
GROUP LIST

51
C. REPORTS

52
GROUP TASK LIST

ADDING MORE FECILITY

53
MESSAGE BOX

54
LOGIN AS USER

55
VIEW TASK LIST

56
MESSAGING TO ADMIN

57
58