COMPLAINT MANAGEMENT SYSTEM

PROJECT REPORT
(LAB ON PROJECT)
Submitted in partial fulfillment of the requirements for the award of the degree of

BACHELOR OF COMPUTER APPLICATIONS

at the Bharathiar University

By
SAKTHIVEL.B
MOUNESH.V
(Reg. No.:211CA134) (Reg. No.:211CA125)

RAM PRAKASH.S SUKAN KUMAR.V

(Reg. No.:211CA129) (Reg. No.: 211CA148)

VIJAYAKUMAR.G
(Reg.No.:211CA150)

Under the Guidance of

DR. B. RAMYA, M.C.A., M.Phil., Ph.D.,
Assistant Professor

DEPARTMENT OF COMPUTER APPLICATIONS

Dr. N.G.P. ARTS AND SCIENCE COLLEGE

(An Autonomous Institution, Affiliated to Bharathiar University, Coimbatore)
Approved by Government of Tamil Nadu & Accredited by NAAC with A++Grade (3rd Cycle -3.64 CGPA)
Dr. N.G.P.-Kalapatti Road, Coimbatore-641 048, Tamil Nadu, India.
Website: www.drngpasc.ac.in Email: [email protected]. Phone: +91-422-2369100
I I

NOVEMBER- 2023
 DECLARATION

We,SAKTHIVEL.B(Reg.No.:211CA134),VIJAYAKUMAR.G(Reg.No.:211CA150),RAMPRAKAH.
S(Reg.No.:211CA129),SUKANKUMAR.V(Reg.No.:211CA148),MOUNESH.V(Reg.No.:201CA144),
hereby declare that the lab on project report entitled "COMPLAINT MANAGEMENT SYSTEM"
submitted in partial fulfillment of the requirement for the award of the degree of Bachelor of Computer
Applications at the Bharathiar University is a record of original project work done during the period of
study(2021-24), under the guidance and supervision of Dr. B. RAMYA, M.C.A., M.Phil., Ph.D.,
Assistant Professor, Department of Computer Applications, Dr. N.G.P. Arts and Science College,
Coimbatore – 48 and it has not formed on the basis of award of any Degree/ Diploma/ Associateship/
Fellowship or other similar title to any candidate of any university.

(SAKTHIVEL. B) (VIJAYAKUMAR. G)
Reg. No.:211CA134 Reg. No.: 211CA150

(RAM PRAKASH. S) (SUKAN KUMAR. V)

Reg. No.:211CA129 Reg. No.:211CA148

(MOUNESH. V)
Reg. No.:211CA125

Place: Coimbatore
Date:
 CERTIFICATE

This is to certify that the project, entitled "COMPLAINT MANAGEMENT SYSTEM" submitted in
partial fulfillment of the requirement for the award of the degree of Bachelor of Computer Applications at
the Bharathiar University is a record of original project work done by
SAKTHIVEL.B(Reg.No.:211CA134),RAMPRAKASH.S(Reg.No.:211CA129),MOUNESH.V(Reg.N
o.:211CA125),SUKANKUMAR.V(Reg.No.:211CA148),VIJAYAKUMAR.G(Reg.No.:211CA150)
during the period (2021-2024) during the period (2021-24) of their study in Department of Computer
Applications, Dr.N.G.P. Arts and Science College, Coimbatore-48 under my supervision and guidance,
and the project has not formed the basis for the award of any Degree/ Diploma/ Associateship/ Fellowship
or other similar title to any candidate of any university.

(Dr. B. (Dr. R. Kousalya) (Prof. Dr. K.Ramamurthi)

Ramya) Head of the
Project Guide Principal
Department

Place: Coimbatore
Date:

Viva-voce Examination held on.....................

Internal Examiner
 ACKNOWLEDGEMENT
This project was the most significant accomplishment in our life and it would not have
been possible without the blessing of God almighty and those who supported and believed in
our caliber.

We record a deep sense of gratitude to Dr. NALLA. G. PALANISWAMI, M.D, AB

(USA),Chairman, Chairman, Dr.N.G.P Research and Educational Trust and Dr.THAVAMANI.D.
PALANISWAMI, M.D, AB (USA), Secretary, Dr. N.G.P. Arts and Science College, Coimbatore for
providing us an infrastructure facility to carry out project work successfully.
We record our sincere thanks to Prof. Dr. K. RAMAMURTHI, M.Com., B.L., MBA.,
Ph.D., Principal, Dr. N.G.P. Arts and Science College, Coimbatore, for every help he rendered
before and during the project.

I would like to thank Dr. F. MARY MAGDALENE JANE, Dean, Faculty of Computer
Science for her constructive support throughout our project

We express our sincere thanks to Dr. R. KOUSALYA, M.C.A., M.Phil., Ph.D., Professor
and Head, Department of Computer Applications Dr. N.G.P. Arts and Science College, Coimbatore
for showing sustained interest and providing help throughout the period of our work.

We would like to extend the sincere thanks to my guide Dr. B. RAMYA, M.C.A., M.Phil.,
Ph.D., Assistant Professor, Department of Computer Applications, Dr. N.G.P. Arts and Science
College, Coimbatore. We sincerely thank for her exemplary guidance and encouragement.

We take this opportunity to acknowledge my sincere thanks to all the staff members of
the Department of Computer Science for their constant inspiration, assistance and resourceful
guidance for the completion of this project successfully.

We express our sincere thanks to our family and friends for their encouragement, love,
prayer, moral support, advice and sacrifice without which we would not have been able to
pursue the course of our study.

K. AGATHEESWARAN AKSHAI POULOSE

V. PADMAVATHI N. RAGUPATHI
S. SUBRAMANI
 ACKNOWLEGDEMENT
If words are considered as symbols of approval and tokens of acknowledgement, then the words play the
heralding role of expressing my gratitude to all who have helped me directly and indirectly during my project
work.

I will be ever graceful and thankful to Dr.S.Sudalaimuthu, Vice Chancellor of Karpagam Academy
of Higher Education, for allowing me to do my project with his moral support.

I take this opportunity to express my sincere gratitude and thanks to our beloved, Dr.M.Palanisamy,
Registrar, Karpagam Academy of Higher Education, for allowing me to do my project with his moral support.

I will be ever graceful and thankful to Dr.N.V. Balaji, Dean, Faculty of Arts, Science, Commerce and

Management, Karpagam Academy of Higher Education, for allowing me to do my project with his moral

support.

I will be ever graceful and thankful to Dr.S.Veni, Head, Department of Computer Science for
providing me this opportunity and extending a constant monitoring throughout the course of the project.

I will be ever graceful and thankful to Dr.V.Sangeetha Associate Professor, Internal Guidance for his

valuable guidance and constant monitoring throughout the course of the project

Finally my heart full of thanks all other faculty members, my parents, my friends for their moral support
without which I would not been able to complete this project.
 Abstract

The aim of project is to develop the “Complaint Management System” by using PHP as
Front-End and MySQL as Back-End. This project is used to maintain the good relationship
between people and government. The government can monitor the complaint from the
government people. And also clear the complaint of the people via the system.

The purpose of this project is to provide the solution for different complaint type and
getting reply from the complaint type handling teams.

People may have complaints about its petition type. They will be given an email id for
each complaint where they can send an email when they have a complaint to register. The
emails will get converted to complaints and get assigned to the persons handling that
complaint. The complaints can be assigned to different persons and will get tracked to
closure. The person handling the complaint will have the facility to communicate with the
people via emails through the system.

The Peoples of the site, views general information about the complaint. Peoples will be
given an email id for each complaint, where they can send an email when they have a
complaint to register. Emails will get converted to complaints and get assigned to the
persons handling that product. Persons handling the complaint will have a facility to
communicate with the people via emails through the system.
 TABLE OF CONTENTS

CONTENTS PAGE NO.

1. INTRODUCTION

1.1. Project Overview 1

2. SYSTEM CONFIGURATION

2.1. Hardware Configuration 2

2.2. Software Specification 2
2.3. Software Description 3
2.4. Module Description 5

3. SYSTEM ANALYSIS

3.1. Existing System 6

3.2. Proposed System 7

4. SYSTEM DESIGN

4.1. ER Diagram 8
4.2. Data Flow Diagram 9
4.3. Database Design 12
4.4. Input Design 15
4.5. Output Design 16

5. SYSTEM TESTING & IMPLEMENTATION 17

6. SCOPE FOR FUTURE ENHANCEMENT 20

7. CONCLUSION 21

BIBLIOGRAPHY 22

APPENDICES
A. SCREEN SHOTS 23

B.SAMPLE CODING 28
1. INTRODUCTION

1.1 PROJECT OVERVIEW

The project “Complaint Management System” is monitor to the complaints from the
people. In government sector the Complaint Management System is very important. Because
the people care services is very important.

Complaint Management System is a Web based project developed in PHP and MySQL
which used to manage People complaint Online. User can login, and create complain, view
complain details and track the status of complaint.

It has one Admin module where Admin can login and View all complaint details, assign
the complaint to specific officer to work and check the status of Assigned Complaint.
Admin can create/ Update or Delete officer details, view reports based on Prebuild
Criteria’s.

This project helps to check the complaint type level of government. And this system is
also used to develop the government complaint type level. Complaint monitoring is needed
project for big and top complaint type.

The admin of the system can view, delete and update the complaint status. The people
can login into system and easily the specified answer from the government. This is not
forum type complaint monitoring. This social attached complaint management process. The
government reply the unique answer to the individual people.

1
 2. SYSTEM CONFIGURATION

2.1 SOFTWARE SPECIFICATION

COMPONENTS MINIMUM REQUIREMENTS

OPERATING SYSTEM Microsoft Windows 7 and Above

GRAPHICS Intel HD Graphics

FRONT – END PHP (HTML, CSS, and JavaScript)

BACK – END MySQL

PACKAGES XAMPP & Adobe Dreamweaver

BROWSER Google Chrome

2.2 HARDWARE CONFIGURATION

COMPONENTS MINIMUM REQUIREMENTS

PROCESSOR Intel® Pentium® CPU P6200 @ 2-13GHz

RAM 2.00GB (1.74GB usable).

HARD DISK DRIVE 320GB

CACHE MEMORY 2MB

INTERNET Modem and SIM Slot

BASIC COMPONENTS Battery, Mouse and Standard QWERTY

Keyboard.

2
2.3 SOFTWARE DESCRIPTION
OVERVIEW OF THE FRONT END

PHP HYPERTEXT PROCESSOR

PHP is a Widely-used general-purpose scripting language that is especially for

development and can be embedded into HTML.

The PHP Hypertext Processor allows web developers to create dynamic content that
interacts with database. PHP application is normally on Linux server and in conjunction
with MYSQL database. It provides those servers with functionality similar to that provide to
the window platform by Active server pages technology.

 PHP Stands for: Hypertext Pre-processor

 PHP is server-side scripting language.
 PHP scripting is executed on server.
 PHP support many Databases (MYSQL, Informix, Oracle, and Sybase, Solid,
Generic ODBC, etc.)
 PHP is free to download and use.
 PHP is open source.
 PHP is platform independent language.

PHP FILES

 PHP files may contain text, HTML Tags and scripts.

 PHP files are returned to the browser as plain HTML
 PHP files have a file extension of “.PHP”, “.PHP3”, and “.PHTML”

ADVANTAGES OF PHP

 PHP runs on different platforms (Window, UNIX, Linux, etc.).

 PHP is compatible with almost all servers used today (Apache, IIs, etc.).
 PHP is Free to Download from the official PHP resources: www.php.net
 PHP is easy to learn and runs efficiently on the server side.

3
OVERVIEW OF THE BACK END

MYSQL

‘MYSQL’ the most popular ‘open source’ SQL database management system is
developed, distributed and supported by ‘MYSQL AB’.’MYSQL AB’ is a commercial
government, founded by the MYSQL developers that build its business by providing
services around the ‘MYSQL’ database management system.

‘MYSQL’ is a database management system. A database is a structured collection of

a data. It may be anything from a simple shopping list to a picture gallery or the vast amount
of information in the corporate network.

To add, access, and process data store in a computer database, you need a database
management system such as ‘MYSQL ‘server. Since computer are very good at handling
large amount of data, database management systems play a central role in computing, as
stand- alone utilities or as part of other application.

 MYSQL is Database server.

 MYSQL is ideal for both small and large application.
 MYSQL support standard SQL.
 MYSQL complies on a number of platforms.
 MYSQL is free to download and use.

ADVANTAGES OF MYSQL DATABASE SERVER

The ‘MYSQL’ database server is very fast, reliable and easy to use. If that is what
you are looking for, you should give it a try. ‘MYSQL’ server also has a practical set
features developed in close cooperation with users.

You can find a performance comparison of ‘MYSQL’ server with other database
managers on our benchmark page. ’MYSQL’ was originally developed to handle large
database much faster than existing solution and has been successfully use in highly
demanding production environments for several years.

4
2.4 MODULES DESCRIPTION

1. SYSTEM ADMIN MODULE

The system admin people can login into our system. The admin want to view his profile and if
any new association want to be created the system admin people can create the new
association. If the admin want to modify any association he can delete the association.

2. COMPLAINT ADMIN MODULE

The admin can login into the system if any complaints regarding to the particular product the
admin can view that complaint and forward to the corresponding team members. The admin
can view his profile. He can view the messages send by the particular people.

3. COMPLAINT HANDLING TEAM MODULE

The complaint handling team module can login into the system if any complaints regarding to
the particular product he can view that complaint and give solution to the corresponding
complaint. The admin can view his profile. He can view the messages send by the particular
people and forward the solution to the particular people.

4. USER MODULE

The people module can login into the system if any complaints regarding to the particular
product he can send complaint to regarding admin people the admin can view his profile. The
admin can view the messages send by the particular team handling people.

5. SYSTEM INTERFACE MODULE

This module can generate the unique id because the complaint is different from the other
complaint id. By using this we can identify the particular people and the complaint.

5
 3. SYSTEM STUDY
3.1 EXISTING SYSTEM

The existing Complaint Management system, In Existing System People has to

Visit the Organization whenever they have any complaints regarding the complaint type
of the Organization, this wastes lot of time. The problem is written in paper and will be
submitted as the complaint. Then the officer will look after it and then he will take care
about the people problems. After that the officer will enquire and allocate the problem
to the specified person in that department. The person will enquire the problem and then
rectifies it.

LIMITATIONS IN EXISTING SYSTEM

 Here in the existing system the peoples need to visit the organization.
 The current system is very slow in access.
 The complete current system is manual system and it will not provide any kind
of security to the data.
 The Complaint Management System is designed as forum format. So the people
receive more options for solution. It takes more time to reduce the problem. And
also this is not authority answer from government.

6
3.2 PROPOSED SYSTEM

In the proposed system we have the following new implementations: User of the
system, People of the Complaint Management System. Here any number of groups can
be assumed. The complaints can be assigned to different person and will get tracked to
closure. The person handling the complaint will have the facility to communicate with
the people via emails through the system.

The proposed system is automated process of sending request through the web
based system. The complaints can be sent easily by the people from anywhere. The
services are given through the system or through the email.

ADVANTAGES OVER EXISTING SYSTEM

The Advantages of the proposed system are:

 The proposed system is completely automated system

 The people can easily access their database
 The email facility provides the people interaction
 This also provides security for the people information
 The user receives the unique answer from the government chief officer. So this
answer is easily clear the problem of the brand.
 The website is designed as fully flat user interface type. So the people can easily
access the data and system.
 Admin panel is very easy to access. And the admin can shortlist the problems
based on the time and status mode. This status mode is used to check the people
complaint is cleared or not.

7
 4. SYSTEM DESIGN
4.1 ER DIAGRAM

Username 1
Password

Login

Manage
UID
UName
M
M
User Details
OfustID
OfName

Ofpwd Officer Details Upwd

OfAddre 1
UAddres
Mobno Mobno

Make Complaint

1
Compid
CompDesc Make Complaint

CompTitle CompID

CompType UName

8
4.2 DATA FLOW DIAGRAM
A data-flow diagram (DFD) is a graphical representation of the "flow" of data
through an information system. DFDs can also be used for the visualization of data processing.
On a DFD, data items flow from an external data source or an internal data store to an internal
data store or an external data sink, via an internal process. The purpose of a DFD is:

 To show the scope and boundaries of a system

 To show that the whole system has been considered
 May be used as a communications tool between a systems analyst and any person
who plays a part in the system
 To act as the starting point for redesigning a system

LEVEL 0:

Complaint
Admin Database
Management
System

9
Level 1:
Assign Complaint

Login
Admin Login

Status of the complaint

Details like off id, off name dept

Officer Officer
Details Details
Working on complaint

Register and use name, id

User Details Make

Complaints
Post their Complaints
Comp id type of comp

Make Complaint
Complaint Details
Result from admin

10
LEVEL 2:

Login Details Username Password

In case new Register

Officer Details
Off id, name dept Complaint
Reports
Management
User Details User name System
Complaint descrip

Complaint Details Type of complaint

Status of complaint

11
4.3 DATABASE DESIGN
TABLE NAME: USER DETAILS

TABLE DESCRIPTION: Used to create an account for user

COLUMN DATA SIZE CONSTRAINTS DESCRIPTION

NAMES TYPE

Cid Varchar 15 Primary Key User ID

CName Char 32 Not Null Name of the User

Cpwd Varchar 32 Not Null User Password

CAddress Varchar 50 Not Null User Address

Email Varchar 32 Not Null Email ID of the User

Mobno Number 10 Not Null Mobile Number of the

User

Date Date 20 Not Null Account Created Date

12
TABLE NAME: OFFICER DETAILS

TABLE DESCRIPTION: Used to create an account for officer

COLUMN DATA SIZE CONSTRAINTS DESCRIPTION

NAMES TYPE

Oid Varchar 15 Primary Key Officer ID

OName Char 32 Not Null Name of the Officer

Cpwd Varchar 32 Not Null Officer’s Login Password

O_Dept Varchar 30 Not Null Officer’s Department

Email Varchar 32 Not Null Email ID of the Officer

Mobno Number 10 Not Null Mobile Number of the

Officer

Date Date 20 Not Null Account Created Officer

13
TABLE NAME: MAKE COMPLAINT

TABLE DESCRIPTION: This table is used to send complaint to government.

COLUMN DATA SIZE CONSTRAINTS DESCRIPTION

NAMES TYPE

Cid Varchar 15 Primary Key Complaint ID

CustID Varchar 32 Not Null ID of the User

CName Char 32 Not Null User Name

CompType Varchar 20 Not Null Type of the Complaint

CompTitle Varchar 50 Not Null Title of the Complaint

CompDesc Varchar 100 Not Null Description of the

complaint

Status Number 10 Not Null Send the reply 0 or 1

OffiID Varchar 30 Not Null Officer’s ID

OffiName Char 30 Not Null Name of the Officer

OffiAns Varchar 100 Not Null Answer of the Officer

OffiDept Varchar 20 Not Null Department of the Officer

CreateDate Date 20 Not Null Complaint Created Date

CloseDate Date 20 Not Null Complaint Close Date

14
4.4 INPUT DESIGN
Input is the raw data that is processed to produce output. It should serve specific purpose
effectively such as storing, recording, and retrieving the information. The information for the
input design is obtained from the data flow diagram and the system flowchart.

15
4.5 OUTPUT DESIGN
Output design generally refers to the results and information that are generated by the system
for many end-users. Output is the main reason for developing the system and the basis on
which they evaluate the usefulness of the application. The output is designed in such a way that
is attractive, convenient and informative. As the output are the most sources of the information
to the users better design should improve the system relationship with user and also help in
decision making.

16
5. SYSTEM TESTING AND IMPLEMENTATION
The software which has been developed has to be tested to prove its validity. Testing is
considered to be the least creative phase of the whole cycle of system design. In real sense it is
the phase, which helps to bring out the creativity of the other phases, and makes it shine.

WHITE BOX TESTING

 By using the technique it was tested that all the individual logical paths were executed
at least once.
 All the logical decisions were tested on both their true and false sides.
 All the loops were tested with the data in between the ranges and especially at the
boundary values.
 Here this testing is performed to check the user interface.

BLACK BOX TESTING

 By the use of these techniques the missing functions are identified and placed in their
positions.
 The errors in the interfaces were identified and corrected.
 This technique was also used to identify the initialization and termination errors and
correct them.
 Login : Entering invalid credentials and checking for error messages.
 Login : Entering valid credentials and checking the login.

SOFTWARE TESTING STRATERGIES

Any software has to be tested with pre planned strategies. To carry out the testing in an
efficient manner certain amount of strategic planning has to be done. Any testing strategy must
incorporate test planning, test case design, test execution and the resultant data collection and
evaluation.

17
UNIT TESTING
In Unit testing, we have to test the programs making up the system. The software
units in a system are called modules and routines that are assembled and integrated to
perform a specific function. Unit testing focuses first on the modules, independently of
one another, to locate errors.

This enables to detect errors in coding and logic that are contained within the
module. In the lines of this strategy all the individual functions and modules were put to
the test independently. This method was applied in combination with white and black
box testing techniques to find the errors in each module.

INTEGRATED TESTING
Again this software testing strategy has two different approaches namely the top-
down approach in which the integration is carried out from the top level module to the
bottom and the bottom-up approach in which the integration is carried out from the low
level modules to the top.

The module was tested using the bottom up approach by introducing stubs for the top
level functions. This test was used to identify the errors in the interfaces, the errors in
passing the parameters between the functions and to correct them.

VALIDATION TESTING
Software validation is achieved through a series of black box test that demonstrate
conformity with requirements. Both plan and procedure are designed to ensure that all
functional required area achieved.

Using validation testing we have tested this project. The user should not leave any
input area blank and it is not allowed to enter improper data. Many validations are
needed for each and every file in the form like textbox validations.

SYSTEM TESTING

The software and hardware are integrated and a full range of system tests are
conducted in an attempt to uncover error at the software and hardware interface. Before
the system is released to user, testing is the sole duty of the developer to see that the
system is free from all kinds of bugs.

18
 The main purpose of testing an information system is to find out errors and correct
them. Testing was done in two phases

 Foreground testing
 Background testing

The Foreground testing includes the testing of all kinds of bugs that would be visible
to the user on the screen.

 Testing for validity of inputs.

 Testing whether the help message is displayed properly.
 Testing for the proper flow of sequence.
 Testing whether the system is user friendly.
The background testing includes, whether the database get updated as required. A
message such as “Record Stored Successfully” on the monitor may ensure that data has
really been updated in the required tables.

Table updating and Data Validation test.

 Date Retrieval, Calculation and Report generation test.

 Date and Form Security test.

19
 6.FUTURE ENHANCEMENT
The project is designed in such a way that it is flexible for changes in future user
requirements. Further extensions in the system can be made to submit more reports to the
managements, this will give the clear picture to the management of the process of the
current system. The existing system has good scope for further development and it can be
integrated with the major systems like Complaint Management System application. The
project is designed as a webpage that we can further module in future. As this project is
developed in PHP and HTML languages, which is an open source language and to
retrieve the information stored in the database is because of MYSQL.

The system is currently developed and ready for implementation to include the system
is highly feasible and user friendly. To provide better facility regarding security, it uses
security provider software. It can have an enhancement on proper in the future according
to the user’s requirements.

20
7. CONCLUSION
The project has been computed successfully. It is user friendly and has required options
which can be utilized by the user to perform the desired operations. The system has the
benefits of easy access because it is be developed as a platform independent web application,
so the admin can maintain a proper contact with their users, which may be access anywhere.
All communications between the client or user and administrator has done through the online,
so this communication cost also be reduced. The system has been designed keeping in view
the present and future requirements in mind and made very flexible.

21
 BIBLIOGRAPHY
Reference Books:
1. Dongosselin, “New PHP Program with MySQL”, Course Technology
Publication, 2008.
2. Adam Trachtenberg, “PHP Cook Book”, Orreilly & Associates Publication,
First Edition, 2003.
3. Elias M.Award, “System Analysis and Design”, Galgotia publishers, Second Edition
1997.
4. Robin Nikson, “Learning PHP, MySQL and JavaScript”, Orreilly &
Associates Publication, Third Edition, 2009.
Reference Websites:
1. https://youtu.be/P9V4LUvLNmA
2. https://phpgurukul.com/
3. https://itsourcecode.com/free-projects/php-project/-source-code-php/
4. https://youtu.be/mz-3r8mcfP0
5. https://youtu.be/8-OhyBNHZvU
6. https://youtu.be/K3pPattaoz8
7. https://youtu.be/9ssz5BzCnhM
8. https://ieeexplore.ieee.org/document/8523949
9. https://www.slideshare.net/mobile/miteshpatel414/

22
 APPENDICES
A. SCREEN SHOTS
ADMIN LOGIN

ADMIN ASSIGN COMPLAINT

23
VIEW COMPLAINT DETAILS

STATUS OF THE COMPLAINT

24
REPORTS

OFFICER LOGIN

25
COMPLAINT DETAILS OFFICER VIEW

USER LOGIN

26
NEW USER REGISTRATION

MAKE COMPLAINT

27
B.SAMPLE CODING

<head>

<title>Complain Management System</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<link href="/apps/Complai/include/admin.css" rel="stylesheet" type="text/css">

<link href="/apps/Complai/include/menu.css" rel="stylesheet" type="text/css">

<link href="/apps/Complai/include/main.css" rel="stylesheet" type="text/css">

<script language="JavaScript" type="text/javascript"

src="/apps/Complai/library/common.js"></script>

<script language="JavaScript" type="text/javascript"

src="/apps/Complai/library/complains.js"></script>

</head>

<body>

<br/><br/>

<table width="900" border="0" align="center" cellpadding="0" cellspacing="1"

class="graybox">

<tr>

<td colspan="2"><img src="/apps/Complai/images/complains.jpg" width="900"

height="120"></td>

</tr>

<tr>

<td width="20%" valign="top" class="navArea"><p>&nbsp;</p>

<div id="ddblueblockmenu">

<div class="menutitle">Admin Menu</div>

<ul>

<li><a href="/apps/Complai/">Welcome,&nbsp;<? echo

ucwords($_SESSION['user_name']); ?></a></li>

28
<li><a href="/apps/Complai/view.php?mod=admin&view=compDetails">Assign
Complains</a></li>

<li><a href="/apps/Complai/view.php?mod=admin&view=vDetails">View
Complains</a></li>

<li><a href="/apps/Complai/view.php?mod=admin&view=compCloseDetails">View
Close Complain</a></li>

<li><a href="/apps/Complai/view.php?mod=admin&view=enggDetails">Officer
Details</a></li>

<li><a href="/apps/Complai/view.php?mod=admin&view=custDetails">User
Details</a></li>

<li><a href="/apps/Complai/view.php?mod=admin&view=reports">Reports</a></li>

<li><a href="/apps/Complai/index.php?logOut">Logout</a></li>

</ul>

<div class="menutitle">&nbsp;</div>

</div>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

</td>

<td width="720" valign="top" class="contentArea"><table width="100%" border="0"

cellspacing="0" cellpadding="20">

<tr>

<td>

<p align="center" style="color:#990000;font-size:16px;font-weight:bold;" >Crime

Reporting System</p>

<p align="justify" style="line-height:24px; padding:10px;"><b> Crime Reporting System

(CRS)</b> is a system operated by the city of coimbatore, India. A Complaint
Management System is one of latest productivity enhancement tools used widely by all
organisations wherever there is a need of booking of Complaints via operators and analysis
of Complaints which are made or are pending.

29
<br/><br/>

Lack of paper movements provides Complaint management operations a speed which was
never envisaged in manual mode at all. Software allows a booking operator to book and
lodge Complaint and automatically schedules and prompts operators to source Complaint
to concerned departments. State of the art management information reports on Complaint
details and pending Complaint with reasons and remarks provides management a better
insight to problems and traffic situations of telephone lines. A never before Report
Wizard not only allows you to define specific reports on demand but also allows you
to define your own sorting and analysis parameters which may be more relevant to you
but not programmed by us till now.</p>

<p>&nbsp;</p>

<h3>All Petition Details</h3>

<form action="processLeave.php?action=addUser" method="post" name="frmListUser"

id="frmListUser">

<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1"

class="text">

<tr align="center" id="listTableHeader">

<td width="747">Petition Title</td>

<td width="260">Petition Type </td>

<td width="139">Status</td>

<td width="150">Supports</td>

<td width="150">Image</td>

<td width="150">Are You Support?</td>

</tr>

<tr class="row2" style="height:25px;">

<td>&nbsp;land occupied</td>

<td width="260" align="center">Land Problem</td>

<td width="139" align="center">Working</td>

<td width="150" align="center">0</td>

<td>

30
<img class="img-circle" src="uploads/Signature.jpg" width=100px height=100px> </td>

<td><a href="support.php?id=1" ">I Support</a></td>

</tr>

<tr class="row1" style="height:25px;">

<td>&nbsp;Housing bank loan oriented</td>

<td width="260" align="center">Housing</td>

<td width="139" align="center">Open</td>

<td width="150" align="center">0</td>

<td>

<img class="img-circle" src="uploads/HOME-LOAN.jpg" width=100px height=100px>

</td>

<td><a href="support.php?id=2" ">I Support</a></td>

</tr>

<tr class="row2" style="height:25px;">

<td>&nbsp;Land extension</td>

<td width="260" align="center">Land Problem</td>

<td width="139" align="center">Open</td>

<td width="150" align="center">0</td>

<td>

<img class="img-circle" src="uploads/land.webp" width=100px height=100px> </td>

<td><a href="support.php?id=3" ">I Support</a></td>

</tr>

<tr>

<td colspan="5">&nbsp;</td>

</tr>

<tr>

<td colspan="5" align="right">&nbsp;</td>

31
</tr>

</table>

<p>&nbsp;</p>

</form>

<p>&nbsp;</p>

</td>

</tr>

</table></td>

</tr>

</table>

<p>&nbsp;</p>

</body>

</html>

32