Online electricity billing project report..pdf

The proposed application ONLINE ELECTRICITY BILLING SYSTEM is aimed to develop a web application for the various activities being carried out by the BESCOM. The BESCOM is managed by the BESCOM officers who are supposed to get all the required information which are needed to generate an electricity bill for customers for their usage of electricity.

1. ONLINE ELECTRICITY BILLING SYSTEM




1. INTRODUCTION


The proposed application ONLINE ELECTRICITY BILLING SYSTEM is aimed to develop
a web application for the various activities being carried out by the BESCOM. The BESCOM is managed
by the BESCOM officers who are supposed to get all the required information which are needed to
generate an electricity bill for customers for their usage of electricity.
The proposed application is implemented in order to reduce the paper work and help in easier
record maintenance, by having the data stored in database. Hence helps in easy retrieval of data. The
system proposed also reduces the chances of data loss. It provides an easy, maintained and systematic
environment for Admin for generating bills. It is an internet based system where customers can use the
system and check their electricity bill balance.

1.1 SCOPE OF THE PROJECT
 The project is a web based application where users can get instant electricity bill and pay them
online via credit card. The system automates the conventional process of paying electricity bill
by visiting the place.
 The system would be having two login forms; one for admin and the other for users. Admin
can view user account details and can even add or update their account. Admin has to feed the
system with electricity usage data into respective users account.
 The system calculates the electricity bill for every user and updates the information in their account
every month. Users can view their electricity bill and pay on the spot before month end.
1.2 ADVANTAGES:
 The system excludes the need of maintaining paper electricity bill as all the electricity bill
records are managed electronically.
 Users need not visit the office for bill payment.
 Usage of this system saves human efforts and resources.

2. ONLINE ELECTRICITY BILLING SYSTEM




2. REQUIREMENTS

2.1 HARDWARE REQUIREMENTS:
 Minimum of 1 GB RAM.
 Pentium IV or higher.
 Hard disk space minimum 20GB.
 Operating system- Windows XP and above



2.2 SOFTWARE REQUIREMENTS:
 Front end: HTML, CSS, Java Script.
 HTML: HTML is used to create and save web document.eg: Notepad/Notepad++.
 CSS: (Cascading Style Sheets) Create attractive Layout.
 JavaScript: It is a programming language, commonly use with web browsers.
 Back end: PHP, MYSQL.
 PHP: Hypertext Preprocessor (PHP) is a technology that allows software developers to
create dynamically generated web pages, in HTML, XML, or other document types, as per
client request. PHP is open source software.
 MYSQL: MYSQL is a database, widely used for accessing querying, updating and managing
data in databases.
 Servers Requirement: XAMPP Server

3. ONLINE ELECTRICITY BILLING SYSTEM





3. DESIGN


3.1 DATAFLOW DIAGRAM




Figure3.1: Admin module creates customer details . By doing this a new customer will be able to make
online payments henceforth.


Figure3.2 Customer can login into the system. The customer enters the required information into the system,
and press the submit button. The system will process the details entered by the customer and fetch the related
data to the customer.















Login data entry
Select
menu
Related Data
View bill

database

customer

admin login
Database
Add
readings
Create
customer

4. ONLINE ELECTRICITY BILLING SYSTEM





3.2 USE-CASE DIAGRAM






Figure3.3:In this phase admin will maintain and view all the details regarding registered people
Customer can pay the bill and also can be able to view the status whether the payments are cleared
or not.


login
registration
signin
signup
Admin
update
account
payment
logout
Edit profile Customer
rrno
About us
Reach us

5. ONLINE ELECTRICITY BILLING SYSTEM


3.3 E-R DIAGRAM


Figure 3.4: Illustrates how entities are related to each other and the relation between them.
















addr
email
user
accno
nn
name
customer
rr
no
admin
mob no balance
pwd
currentread
ing
electric
bill
prereading
units date
Bill amt

6. VENDOR
CUSTOMER
ONLINE ELECTRICITY BILLING SYSTEM

3.4 ACTIVITY DIAGRAM

















Figure3.5: It depicts modules such as customer and admin which explains the activity with respect to our
application.




Admin Login
GENERATE BILLING
FETCH THE UNITS USED
GENERATE RECEIPTS

7. ONLINE ELECTRICITY BILLING SYSTEM




4. IMPLEMENTATION
4.1 MODULE DESCRIPTION
Admin-form:
In this module the admin can login to the system to perform their operation. Admin can see the current
status of the customer. The system should give permission to only administrator to view the registered customers.
Customer-form:
In this module the customer can register by providing the details i.e. username and password, and then they
can login by their username and password to check their current status and payment of bills.
4.2 SAMPLE CODE
Code for admin page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Keep it Simple</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/style.css"/>
</head>
<body>
<div id="container">
<div id="header"> <a href="http://all-free-download.com/free-website-templates/">bescom.com</a>
</div>
<div id="menu"> <a href="index.php"></a>
&nbsp; &nbsp; &nbsp;
<strong>&nbsp; <a href="account.php"> CREATE CUSTOMER ACCOUNT</a> &nbsp; &nbsp; &nbsp;
&nbsp;
<a href="transaction.php">ADD READINGS</a> &nbsp; &nbsp; &nbsp; &nbsp; <a
href="search.php">SEARCH</a> &nbsp; &nbsp; &nbsp; &nbsp;

8. ONLINE ELECTRICITY BILLING SYSTEM




<a href="index.php">SIGNOUT</a></strong></div>
<div id="sidebar">
<h1>Welcome Administrator</h1>
</div>
<div id="main">
<p align="right"><img src="images/191.jpg" width="545" height="329" /></p>
</div>
<div id="footer"><span class="separator">|</span>&nbsp;</div>
</div>
xc <div align=center></div>
</body>
</html>


Code for account page

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Keep it Simple</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/style.css"/>
</head>
<body>
<div id="container">
<div id="header">
<a href="http://all-free-download.com/free-website-templates/">bescom.com</a></div>
<div id="menu">
<a href="index.php"></a> &nbsp; &nbsp; &nbsp;
<strong>&nbsp;<a href="adminhomepage.php">Back</a>

9. ONLINE ELECTRICITY BILLING SYSTEM




&nbsp; &nbsp; &nbsp; &nbsp;</strong>
</div>
<div id="sidebar">
<h1>Welcome New User</h1>
</div>
<div id="main">
<form id="form1" name="form1" method="post" action="accountsave.php">
<p>&nbsp;</p>
<table width="553" border="1">
<tr>
<td>RRNo</td>
<td><?php
$mysqli= new mysqli("localhost", "root", "", "ele");
if ($mysqli->connect_errno)
{
echo "Failed to connect to MySQL: (". $db->connect_errno . ") " . $db->connect_error;
}
$sql="select * from account";
$result=$mysqli->query($sql);
$cnt=$result->num_rows ;
$cnt=$cnt+1001;
$cnt="RR-".$cnt;
setcookie("RR",$cnt);
echo $cnt;

</td>
?>


<td width="234" rowspan="12"><img src="images/reg1.jpg" width="234" height="234" /></td>
</tr>
<tr>
<td width="126">Customer type</td>
<td width="171"><label>

10. ONLINE ELECTRICITY BILLING SYSTEM




<select name="select">
<option value="Residential">Residential</option>
<option value="Commercial">Commercial</option>
</select>
</label></td>
</tr>
<tr>
<td>Customer name</td>
<td><label>
<input name="textfield2" type="text" required="required"/>
</label></td>
</tr>
<tr>
<td height="28">Mobile No</td>
<td><label>
<input name="textfield22" type="text" required="required"/>
</label></td>
</tr>
<tr>
<td>Address</td>
<td><textarea name="textarea"></textarea></td>
</tr>
<tr>
<td>Date of Billing </td>
<td><input name="textfield222" type="date" required="required"/></td>
</tr>
<tr>
<td>Email</td>
<td><input name="textfield223" type="text" required="required"/></td>
</tr>
<tr>

11. ONLINE ELECTRICITY BILLING SYSTEM




<td>Acno</td>


<td>
<?php
$mysqli= new mysqli("localhost", "root", "", "ele");
if ($mysqli->connect_errno)
{
echo "Failed to connect to MySQL: (". $db->connect_errno . ") " . $db->connect_error;

12. ONLINE ELECTRICITY BILLING SYSTEM







5.1. TYPES OF TESTING
5. TESTING
 Testing begins at the module level and works outward towards the integration of the entire computer
based system.
 Different testing techniques are appropriate at different level of time.
 Testing and debugging are different activities, but debugging must be accommodated in any testing
strategy.
System testing:
System testing is the stage of implementation, which aims at ensuring that the system works
accurately and efficiently before actual operation commences.
The electricity billing system project report basically deals with the paying bill; since it is a web
application the problems of single tier could be resolved. This project is an executive information system
that could be used for entering, calculating and monitoring the billing details of electricity.

5.2 TEST CASES

Test
case
ID
Test
Scenario
Test Steps Test Data Expected
Result
Actual
Result
Pass/fail
1 Check admin
login with valid
data
1. Goto site
http://Localhost/e
lectricitybilling/a
dmin.php
2. Enter username
3.Enter password
4.click submit
Username=
Admin,
Password=
Admin123
Admin
should login
into admin
page
As expected Pass

13. ONLINE ELECTRICITY BILLING SYSTEM


2 Check admin
login with
invalid data
1. Goto site
http://Localhost/e
lectricitybilling/a
dmin.php
2. Enter userid
3.Enter password
4.click submit
Username=
Admin,
Password=
Admin123
Admin
should not
login into
admin page
As expected Fail

14. ONLINE ELECTRICITY BILLING SYSTEM







Test
case
ID
Test
Scenario
Test Steps Test Data Expected
Result
Actual
Result
Pass/fail
3 Check
customer login
with valid data
1. Goto site
http://Localhost/e
lectricitybilling/c
ustomersignup.ph
p
2. Enter username
3. Enter password
4.click submit
Username=
username,
Password=
password
Customer
should login
into
customersig
nup page
As expected Pass
4 Check
customer login
with invalid
data
1. Goto site
http://Localhost/e
lectricitybilling/c
ustomersignup.ph
p
2. Enter username
3.Enter password
4.click submit
Username=
customer,
Password=
password
customer
should not
login into
customersig
nup page
As expected Fail



4.3 DATABASE TABLE:


Login table:

Name data type
Username Varchar
Password Varchar

15. ONLINE ELECTRICITY BILLING SYSTEM







Billing details:



Name Data type
Id Varchar
Emailid Varchar
Password Varchar
Fname Varchar
Mobileno Varchar
Cardno Varchar

16. ONLINE ELECTRICITY BILLING SYSTEM






Home page:
6. SCREENSHOTS






Figure6.1: admin and customer can login to the system to perform their operations.


Admin login page:



Figure6.2: A module is for admin to login.

17. ONLINE ELECTRICITY BILLING SYSTEM

18. ONLINE ELECTRICITY BILLING SYSTEM




Customer registration page:


Figure6.3: The customer to register by providing the details such as name, address, email id etc.

Admin home page:



Figure 6.4: The admin home page module where admin will be able to provide new electricity line to a
new customer by the create customer account module.

19. ONLINE ELECTRICITY BILLING SYSTEM




7. CONCLUSION

The system have automated the online electricity billing system for generate the electricity bill. We
have stated that the project facilitates the provision of safe, authenticated and web based electricity billing system.
Earlier the people had to visit the respective places to pay their bills. With this implemented application, customers
can pay the bills online from anywhere. Also, this system is faster than the earlier methods of manually entering
data, calculating and validating data or who have paid the bill. The system is generalized and ensures to reduce
manual error by reducing manual efforts. Every system has been taken to make the working of the project
comfortable as possible for the customers. We learned so many things and gained a lot of knowledge about
development field.

20. ONLINE ELECTRICITY BILLING SYSTEM




8. FUTURE ENHANCEMENT

Online Electricity Billing System works well with the existing benefits that have been provided in this
system. It is designed keeping in mind the essential features that are important to this project. It is not that,
it includes all the functions, there are pros and cons. Some of them are: Customers are expected to
remember date of billing and payment. Transaction is not designed similar to payment gateway which
includes the necessary options such as Internet-Banking, Credit card, Debit card. Implementation of the
logic of online payment is done in a basic way. The above limitations can be implemented in future.
Further, add-ons to be imposed can also be accomplished.

21. ONLINE ELECTRICITY BILLING SYSTEM




9. BIBLIOGRAPHY


Books Reference:


1. PHP Complete reference by Steven Holzner
2. World Wide Web by Robert W. Sebesta


Web References:
 www.w3schools.com
 www.phptpoint.com
 http://en.wikipedia.org/wiki/PHP

Author References :
Acharya, Kamal. "STUDENT INFORMATION MANAGEMENT
SYSTEM." Authorea Preprints (2023).
Acharya, Kamal. "Library Management System." Available at SSRN
4807104 (2019).
ACHARYA, KAMAL, et al. "LIBRARY MANAGEMENT SYSTEM." (2019).
Acharya, Kamal. "Online bus reservation system project report." Authorea
Preprints (2024).
Acharya, Kamal. "Online bus reservation system project report." (2024).
Acharya, Kamal. “Online Bus Reservation System.” SSRN ElectroNIC ASIA
Journal (2024): n. pag.
Acharya, Kamal. “Student Information Management System Project.” SSRN
ElectroNIC ASIA Journal (2024): n. pag.
Acharya, Kamal. “ATTENDANCE MANAGEMENT SYSTEM.” International
Research Journal of Modernization in Engineering Technology and
Science (2023): n. pag.
Acharya, Kamal. “College Information Management System.” SSRN ElectroNIC
ASIA Journal (2024): n. pag.
Acharya, Kamal, Attendance Management System Project (April 28, 2024).
Available at
SSRN: https://ssrn.com/abstract=4810251 or http://dx.doi.org/10.2139/ssrn.4810
251
Acharya, Kamal, Online Food Order System (May 2, 2024). Available at
SSRN: https://ssrn.com/abstract=4814732 or http://dx.doi.org/10.2139/ssrn.4814
732
Acharya, Kamal, University management system project. (May 1, 2024). Available
at
SSRN: https://ssrn.com/abstract=4814103 or http://dx.doi.org/10.2139/ssrn.4814

22. ONLINE ELECTRICITY BILLING SYSTEM


103
Acharya, Kamal, Online banking management system. (May 1, 2024). Available at
SSRN: https://ssrn.com/abstract=4813597 or http://dx.doi.org/10.2139/ssrn.4813
597

23. ONLINE ELECTRICITY BILLING SYSTEM

24. ONLINE ELECTRICITY BILLING SYSTEM

25. ONLINE ELECTRICITY BILLING SYSTEM