Project Report of Electricity Billing System Page 1

---

Project Report of Electricity Billing System 
 
Page - 147 
 

No. Of Rooms

 

id="drop_off" type="text" required/>

 
 
 

No. Of Persons

 
id="drop_off" type="text" required/> 
 
 

No. Of Childs

 

id="drop_off" type="text" required/>

 
 
 
 

 

 

---

Project Report of Electricity Billing System 
 
Page - 148 

value="Search Room" >

 

>

 
 
 
value=""> 
 

 
 

 

Choose Your Room

 
 
 

 

---

Project Report of Electricity Billing System 
 
Page - 149 
while($data = mysql_fetch_assoc($rs)) 
{ 
?> 

 
 
src="" alt="" /> 

 
 
bold"> 
Room Type : 

Max Adults : 

Max Childs : 

 

---

Project Report of Electricity Billing System 
 
Page - 150 
border-left:1px solid #cccccc"> 
href="booking_details.php?room_id=&book_from_date=om_date'];?>&book_to_date=&book_no_rooms=ok_no_rooms'];?>&book_no_persons=&book_no_childs=EQUEST['book_no_childs'];?>" >Book The Room Now 

 
 
 
 
 
 
 
 
 

 
 

---

Project Report of Electricity Billing System 
 
Page - 151 

---

Project Report of Electricity Billing System 
 
Page - 152 
Coding for Category.php 
include_once("includes/header.php");
if($_REQUEST[category_id]) 
{ 
$SQL="SELECT * FROM `category` WHERE category_id = $_REQUEST[category_id]"; 
$rs=mysql_query($SQL) or die(mysql_error()); 
$data=mysql_fetch_assoc($rs); 
} 
?> 
 

 
 
 
 

---

Project Report of Electricity Billing System 
 
Page - 153 
 

Electricity Connection Category Entry 
Form

 
 

 
 
method="post" name="frm_type"> 
 

Category Name

 

id="category_name" type="text" required value=""/>

 
 
 

Description

 

name="category_description" cols="" rows="6" 
required>

 
 

---

Project Report of Electricity Billing System 
 
Page - 154 
 
 

 

 

value="Submit" >

 

>

 
 
 
value=""> 
 

 
 
 

 
 

---

Project Report of Electricity Billing System 
 
Page - 155 

---

Project Report of Electricity Billing System 
 
Page - 156 
Coding for Category-Report.php 
include_once("includes/header.php");
include_once("includes/db_connect.php");
$SQL="SELECT * FROM `category`"; 
$rs=mysql_query($SQL) or die(mysql_error()); 
?> 
 
 

 
 
 

 
 

Electricity Connection Category Report

 
if($_REQUEST['msg']) {
?> 

 
} 

---

Project Report of Electricity Billing System 
 
Page - 158 
?> 
 
 
 
 
 
 
Name 
Action 
 
$sr_no=1; 
while($data = mysql_fetch_assoc($rs)) 
{ 
?> 
 

---

Project Report of Electricity Billing System 
 
Page - 159 

 
 
 
$data[category_id] ?>">Edit | href="Javascript:delete_category()">Delete  
 
 
 
 

ID

 

 
 
 
 
 
 

---

Project Report of Electricity Billing System 
 
Page - 160 

 

 

---

Project Report of Electricity Billing System 
 
Page - 161 
Coding for Change-Password.php 

 

 
 
 
 
 

Change Your Account Password

 
 
 
 

New Password

 

name="user_new_password" type="password" required />

 
 

---

Project Report of Electricity Billing System 
 
Page - 162 
 

Confirm Password

 

name="user_confirm_password" type="password" required />

 
 
 
 

 

 

value="Change Password" >

 

value="Reset" >

 
 
value="change_password"> 
 

 
 

---

Project Report of Electricity Billing System 
 
Page - 163 
 

 
 

---

Project Report of Electricity Billing System 
 
Page - 164 
Coding for Connection.php 
include_once("includes/header.php");
if($_REQUEST[connection_id]) 
{ 
$SQL="SELECT * FROM `connection` WHERE connection_id = 
$_REQUEST[connection_id]"; 
$rs=mysql_query($SQL) or die(mysql_error()); 
$data=mysql_fetch_assoc($rs); 
} 
?> 
 

 
 
 
 

---

Project Report of Electricity Billing System 
 
Page - 165 
 

Connection Entry Form

 
 

 
 
method="post" name="frm_type"> 
 

Select Category

 

 
id="connection_category_id" required /> 
get_new_optionlist("category","category_id","category_name",$data[connection_category_id]); ?> 
 

 
 
 

---

Project Report of Electricity Billing System 
 
Page - 166 

Select Customer

 

 
id="connection_customer_id" required /> 
get_new_optionlist("user","user_id","user_name",$data[connection_customer_id],"user_level_id = 2"); 
?> 
 

 
 
 

Bill Units

 

name="connection_bill_unit" id="connection_bill_unit" type="text" required 
value=""/>

 
 
 

Company Name

 

name="connection_company_name" id="connection_company_name" type="text" required 

---

Project Report of Electricity Billing System 
 
Page - 167 
value=""/> 
 
 

Occupation

 

name="connection_occupation" id="connection_occupation" type="text" required 
value=""/>

 
 
 

Email

 

name="connection_add_email" id="connection_add_email" type="text" required 
value=""/>

 
 
 

Landline

 

name="connection_add_landline" id="connection_add_landline" type="text" required 
value=""/>

 

---

Project Report of Electricity Billing System 
 
Page - 168 
 
 

Mobile

 

name="connection_add_mobile" id="connection_add_mobile" type="text" required 
value=""/>

 
 
 

Request Load

 

name="connection_request_load" id="connection_request_load" type="text" required 
value=""/>

 
 
 

Contract Demand

 

name="connection_contract_demand" id="connection_contract_demand" type="text"
required value=""/>

 
 

---

Project Report of Electricity Billing System 
 
Page - 169 

size:12px;">Connection Address Details

 
 

Plot No

 

id="connection_plot" type="text" required value=""/>

 
 
 

Address

 

name="connection_address" id="connection_address" type="text" required 
value=""/>

 
 
 

City

 

 
id="connection_add_city" required /> 

---

Project Report of Electricity Billing System 
 
Page - 170 
get_new_optionlist("city","city_id","city_name",$data[connection_add_city]); ?> 
 
 
 
 

State

 

 
id="connection_add_state" required /> 
get_new_optionlist("state","state_id","state_name",$data[connection_add_state]); ?> 
 

 
 
 

Pincode

 

name="connection_add_pincode" id="connection_add_pincode" type="text" required 

---

Project Report of Electricity Billing System 
 
Page - 171 
value=""/> 
 

size:12px;">Other Connection Details

 
 

Description

 

name="connection_description" cols="" rows="6" required 
>

 
 
 
 
 

 

 

value="Submit" >

 

>

 
 

---

Project Report of Electricity Billing System 
 
Page - 172 
 
 
value=""> 
 

 
 
 

 
 

 

---

Project Report of Electricity Billing System 
 
Page - 173 
Conclusion of the Project Electricity Billing System: 
Our project is only a humble venture to satisfy the needs to manage their project 
work. Several user friendly coding have also adopted. This package shall prove to be a 
powerful package in satisfying all the requirements of the school. The objective of 
software planning is to provide a frame work that enables the manger to make 
reasonable estimates made within a limited time frame at the beginning of the software 
project and should be updated regularly as the project progresses.
At the end it is 
concluded that we have made effort on following points… 

A description of the background and context of the project and its relation to work 
already done in the area. 

Made statement of the aims and objectives of the project. 

The description of Purpose, Scope, and applicability. 

We define the problem on which we are working in the project. 

We describe the requirement Specifications of the system and the actions that 
can be done on these things. 

We understand the problem domain and produce a model of the system, which 
describes operations that can be performed on the system. 

We included features and operations in detail, including screen layouts. 

We designed user interface and security issues related to system. 

Finally the system is implemented and tested according to test cases. 

---

Project Report of Electricity Billing System 
 
Page - 174 
Future Scope of the Project: 
In a nutshell, it can be summarized that the future scope of the project circles 
around maintaining information regarding: 

 
We can add printer in future. 

 
We can give more advance software for Electricity Billing System including more 
facilities

 
We will host the platform on online servers to make it accessible worldwide 

 
Integrate multiple load balancers to distribute the loads of the system 

 
Create the master and slave database structure to reduce the overload of the 
database queries 

 
Implement the backup mechanism for taking backup of codebase and database 
on regular basis on different servers
The above mentioned points are the enhancements which can be done to increase 
the applicability and usage of this project. Here we can maintain the records of 
Customer and Bill. Also, as it can be seen that now-a-days the players are versatile, i.e. 
so there is a scope for introducing a method to maintain the Electricity Billing System. 
Enhancements can be done to maintain all the Customer, Bill, Connection, Electricity, 
Payment. 
We have left all the options open so that if there is any other future requirement 
in the system by the user for the enhancement of the system then it is possible to 
implement them.In the last we would like to thanks all the persons involved in the 
development of the system directly or indirectly. We hope that the project will serve its 
purpose for which it is develop there by underlining success of process. 

---

Project Report of Electricity Billing System 
 
Page - 175 
Limitation of Project on Electricity Billing System 
Although I have put my best efforts to make the software flexible, easy to operate 
but limitations cannot be ruled out even by me. Though the software presents a broad 
range of options to its users some intricate options could not be covered into it; partly 
because of logistic and partly due to lack of sophistication. Paucity of time was also 
major constraint, thus it was not possible to make the software foolproof and dynamic. 
Lack of time also compelled me to ignore some part such as storing old result of the 
candidate etc. 
Considerable efforts have made the software easy to operate even for the people 
not related to the field of computers but it is acknowledged that a layman may find it a 
bit problematic at the first instance. The user is provided help at each step for his 
convenience in working with the software. 
List of limitations which is available in the Electricity Billing System: 

 
Excel export has not been developed for Customer, Bill due to some criticality. 

 
The transactions are executed in off-line mode, hence on-line data for Connection, 
Electricity capture and modification is not possible. 

 
Off-line reports of Customer, Payment, Connection cannot be generated due to 
batch mode execution. 
 
 

---

Project Report of Electricity Billing System 
 
Page - 176 
References and Bibliography: 

Google for problem solving 

http://www.javaworld.com/javaworld/jw-01-1998/jw-01-Credentialreview.html 

Database Programming with JDBC and Java by O'Reilly 

Head First Java 2nd Edition 

http://www.jdbc-tutorial.com/ 

Java and Software Design Concepts by Apress 

https://www.tutorialspoint.com/java/ 

http://www.javatpoint.com/java-tutorial 

https://docs.oracle.com/javase/tutorial/ 

http://www.wampserver.com/en/ 

http://www.JSP.net/ 

http://www.tutorialspoint.com/mysql/ 

httpd.apache.org/docs/2.0/misc/tutorials.html