GANTT CHART - PHP and MySQL Project on Electricity Billing System

January February March

Requirement

Code of Bill.php Form:

<?php

include_once("includes/header.php");

if($_REQUEST[bill_id]) {

$SQL="SELECT * FROM `bill` WHERE bill_id = $_REQUEST[bill_id]";

$rs=mysql_query($SQL) or die(mysql_error());

$data=mysql_fetch_assoc($rs);

}

</div>

<h4 class="heading colr">Creating Electricity Bill</h4>

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

<div class="msg"><?=$_REQUEST['msg']?

></div>

<?php } ?>

<li class="txt">Connection Number</li>

<select name="bill_connection_id"

id="bill_connection_id" class="bar" required/>

</select>

</li>

</ul>

<li class="txt">Bill For Month</li>

<select name="bill_month" id="bill_month"

class="bar" required/>

<?php echo

get_new_optionlist("month","month_id","month_name",$data[bill_month]); ?>

</select>

</li>

</ul>

<li class="txt">Current Reading</li>

<li class="inputfield"><input

name="bill_current_reading" id="bill_current_reading" type="text" class="bar"

required value="<?=$data[bill_current_reading]?>"/></li>

</ul>

<li class="txt">Previous Reading</li>

<li class="inputfield"><input

name="bill_previous_reading" id="bill_previous_reading" type="text" class="bar"

required value="<?=$data[bill_previous_reading]?>"/></li>

</ul>

<li class="txt">Total Units</li>

<li class="inputfield"><input

name="bill_total_units" id="bill_total_units" type="text" class="bar" required value="<?=$data[bill_total_units]?>"/></li>

</ul>

<li class="txt">Charge Per Unit</li>

<li class="inputfield"><input

name="bill_charge_per_unit" id="bill_charge_per_unit" type="text" class="bar"

required value="<?=$data[bill_charge_per_unit]?>"/></li>

</ul>

<li class="txt">Fix Charges</li>

<li class="inputfield"><input

name="bill_fix_charges" id="bill_fix_charges" type="text" class="bar" required value="<?=$data[bill_fix_charges]?>"/></li>

</ul>

<li class="inputfield"><input name="bill_tax" id="bill_tax" type="text" class="bar" required value="<?

=$data[bill_tax]?>"/></li>

</ul>

<li class="txt">Final Amount</li>

<li class="inputfield"><input

name="bill_final_amout" id="bill_final_amout" type="text" class="bar" required value="<?=$data[bill_final_amout]?>"/></li>

</ul>

<li class="txt">Description</li>

<li class="textfield"><textarea

name="bill_description" cols="" rows="6" required><?=$data[bill_description]?

></textarea></li>

</ul>

<li class="textfield"><input type="submit"

value="Submit" class="simplebtn"></li>

<li class="textfield"><input type="reset"

value="Reset" class="resetbtn"></li>

</ul>

<input type="hidden" name="act"

value="save_bill">

<input type="hidden" name="bill_id" value="<?

=$data[bill_id]?>">

</form>

</div>

<?php include_once("includes/sidebar.php"); ?>

</div>

<?php include_once("includes/footer.php"); ?>

Code of billing-confirmation.php Form

<?php

include_once("includes/header.php");

/// Update the booking status /////

$date = date("F j, Y");

$SQL = "UPDATE bill SET bill_payment_status = 1, bill_payment_date = '$date' WHERE bill_id = '$_REQUEST[bill_id]'";

$rs = mysql_query($SQL) or die(mysql_error());

/// Get the booking details /////

if($_REQUEST[bill_id]) {

$SQL="SELECT * FROM `bill`,`connection`,`user`,`month` WHERE bill_month = month_id AND connection_customer_id = user_id AND

bill_connection_id = connection_id AND bill_id = $_REQUEST[bill_id]";

$rs=mysql_query($SQL) or die(mysql_error());

$data=mysql_fetch_assoc($rs);

border:1px solid #101746;

} th {

font-size:12px;

<h4 class="heading colr">Bill Payment Receipt (Your bill payment was successfull !!!)</h4>

<div>

<tr>

<th>Payment Refrence ID</th>

<td>10000<?=$data[bill_id]?

</tr>

<th>Total Units Consumed</th>

</tr>

<tr>

<th>Charge Per Unit</th>

<td><?

<th>Total Amount Paid</th>

<td><?

=$data[bill_final_amout]?>.00/-</td>

</tr>

</table>

<li class="textfield"><input type="button" value="Print Receipt" class="simplebtn"

onClick="window.print()"></li>

</ul>

</div>

<?php include_once("includes/sidebar.php"); ?>

</div>

<?php include_once("includes/footer.php"); ?>

Code of bill-report.php

<?php

include_once("includes/header.php");

include_once("includes/db_connect.php");

if($_SESSION['user_details']['user_level_id'] == 2)

$SQL="SELECT * FROM `bill`,`month`,`connection`,`user` WHERE user_id = connection_customer_id AND bill_month = month_id AND user_id = ".

$_SESSION['user_details']['user_id'];

else

$SQL="SELECT * FROM `bill`,`month` WHERE bill_month = month_id";

$rs=mysql_query($SQL) or die(mysql_error());

function delete_bill(bill_id) {

if(confirm("Do you want to delete the bill?")) {

<h4 class="heading colr">Electricity Bill Report</h4>

<?php

if($_REQUEST['msg']) {

<?php }

<tbody>

<td scope="col">Connection ID</td>

<td scope="col">Month</td>

<td scope="col">Total Units</td>

<td scope="col">Total Bill</td>

<td scope="col">Payment Status</td>

<td scope="col">Action</td>

</tr>

<?php

$sr_no=1;

while($data = mysql_fetch_assoc($rs)) {

<tr>

<td>

<?php if($data[bill_payment_status] != 1) echo 'Not Paid'; else echo 'Paid';?>

</td>

<?php if($data[bill_payment_status] == 1) { ?>

<a href="billing-confirmation.php?

bill_id=<?php echo $data[bill_id] ?>">Receipt | </a>

<?php } ?>

<?php if($_SESSION['user_details']

['user_level_id'] == 1) { ?>

<a href="bill.php?bill_id=<?php echo

$data[bill_id] ?>">Edit</a> | <a href="Javascript:delete_bill(<?=$data[bill_id]?

>)">Delete</a> </td>

<?php } elseif($data[bill_payment_status]

== 1) { ?>

<a href="#">Bill Already Paid</a>

<?php } else{ ?>

<a href="make_payment.php?

bill_id=<?php echo $data[bill_id] ?>">Pay Bill</a>

<?php } ?>

</div>

</form>

</div>

<?php include_once("includes/footer.php"); ?>

Code of category.php

<?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);

}

</div>

<h4 class="heading colr">Electricity Connection Category Entry Form</h4>

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

<div class="msg"><?=$_REQUEST['msg']?

></div>

<?php } ?>

<form action="lib/category.php"

enctype="multipart/form-data" method="post" name="frm_type">

<li class="txt">Category Name</li>

<li class="inputfield"><input

name="category_name" id="category_name" type="text" class="bar" required value="<?=$data[category_name]?>"/></li>

</ul>

<li class="txt">Description</li>

<li class="textfield"><textarea name="category_description" cols="" rows="6" required><?

=$data[category_description]?></textarea></li>

</ul>

<li class="textfield"><input type="submit"

value="Submit" class="simplebtn"></li>

<li class="textfield"><input type="reset"

value="Reset" class="resetbtn"></li>

</ul>

<input type="hidden" name="act"

value="save_category">

<input type="hidden" name="category_id"

value="<?=$data[category_id]?>">

</form>

</div>

<?php include_once("includes/sidebar.php"); ?>

</div>

<?php include_once("includes/footer.php"); ?>

Code of category-report.php

<?php

include_once("includes/header.php");

include_once("includes/db_connect.php");

$SQL="SELECT * FROM `category`";

$rs=mysql_query($SQL) or die(mysql_error());

function delete_category(category_id) {

if(confirm("Do you want to delete the category?")) {

<h4 class="heading colr">Electricity Connection Category Report</h4>

<?php

if($_REQUEST['msg']) {

<?php }

<form name="frm_category" action="lib/category.php"

method="post">

<tbody>

<td scope="col">Action</td>

</tr>

<?php

$sr_no=1;

while($data = mysql_fetch_assoc($rs)) {

category_id=<?php echo $data[category_id] ?>">Edit</a> | <a

href="Javascript:delete_category(<?=$data[category_id]?>)">Delete</a> </td>

</td>

</tr>

</table>

</div>

</form>

</div>

<?php include_once("includes/footer.php"); ?>

Code of Connection.php form

<?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);

}

</div>

<h4 class="heading colr">Connection Entry Form</h4>

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

<div class="msg"><?=$_REQUEST['msg']?

></div>

<?php } ?>

<form action="lib/connection.php"

enctype="multipart/form-data" method="post" name="frm_type">

<li class="txt">Select Category</li>

<select

<?php echo

<li class="txt">Select Customer</li>

<select name="connection_customer_id"

id="connection_customer_id" class="bar" required style="width:208px"/>

<?php echo get_new_optionlist("user","user_id","user_name",

$data[connection_customer_id],"user_level_id = 2"); ?>

</select>

</li>

</ul>

<li class="txt">Bill Units</li>

<li class="inputfield"><input

name="connection_bill_unit" id="connection_bill_unit" type="text" class="bar"

required value="<?=$data[connection_bill_unit]?>"/></li>

</ul>

<li class="txt">Company Name</li>

<li class="inputfield"><input

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

class="bar" required value="<?=$data[connection_company_name]?>"/></li>

</ul>

<li class="txt">Occupation</li>

<li class="inputfield"><input name="connection_occupation" id="connection_occupation" type="text"

class="bar" required value="<?=$data[connection_occupation]?>"/></li>

</ul>

<li class="txt">Email</li>

<li class="inputfield"><input

name="connection_add_email" id="connection_add_email" type="text" class="bar"

required value="<?=$data[connection_add_email]?>"/></li>

</ul>

<li class="txt">Landline</li>

<li class="inputfield"><input

name="connection_add_landline" id="connection_add_landline" type="text"

class="bar" required value="<?=$data[connection_add_landline]?>"/></li>

</ul>

<li class="txt">Mobile</li>

<li class="inputfield"><input name="connection_add_mobile" id="connection_add_mobile" type="text"

class="bar" required value="<?=$data[connection_add_mobile]?>"/></li>

</ul>

<li class="txt">Request Load</li>

<li class="inputfield"><input

name="connection_request_load" id="connection_request_load" type="text"

class="bar" required value="<?=$data[connection_request_load]?>"/></li>

</ul>

<li class="txt">Contract Demand</li>

<li class="inputfield"><input

</ul>

<h4 class="heading colr" style="clear:both; font-size:12px;">Connection Address Details</h4>

<li class="inputfield"><input

name="connection_plot" id="connection_plot" type="text" class="bar" required value="<?=$data[connection_plot]?>"/></li>

</ul>

<li class="txt">Address</li>

<li class="inputfield"><input

name="connection_address" id="connection_address" type="text" class="bar"

required value="<?=$data[connection_address]?>"/></li>

</ul>

<select name="connection_add_city"

id="connection_add_city" class="bar" required style="width:208px"/>

<?php echo

get_new_optionlist("city","city_id","city_name",$data[connection_add_city]); ?>

<select name="connection_add_state"

id="connection_add_state" class="bar" required style="width:208px"/>

<?php echo

get_new_optionlist("state","state_id","state_name",$data[connection_add_state]); ?

</select>

</li>

</ul>

<li class="txt">Pincode</li>

<li class="inputfield"><input

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

class="bar" required value="<?=$data[connection_add_pincode]?>"/></li>

</ul>

<h4 class="heading colr" style="clear:both; font-size:12px;">Other Connection Details</h4>

<li class="txt">Description</li>

<li class="textfield"><textarea name="connection_description" cols="" rows="6" required

style="width:300px"><?=$data[connection_description]?></textarea></li>

</ul>

<?php if($_SESSION['user_details']['user_level_id']

== 1) { ?>

<li class="textfield"><input type="submit"

value="Submit" class="simplebtn"></li>

<li class="textfield"><input type="reset"

value="Reset" class="resetbtn"></li>

</ul>

<?php } ?>

<input type="hidden" name="act"

value="save_connection">

<input type="hidden" name="connection_id"

</div>

<?php include_once("includes/sidebar.php"); ?>

</div>

<?php include_once("includes/footer.php"); ?>

Code of Connection-report.php

<?php

include_once("includes/header.php");

include_once("includes/db_connect.php");

if($_SESSION['user_details']['user_level_id'] == 2)

$SQL="SELECT * FROM `connection`,`user`,`category` WHERE

connection_category_id = category_id AND connection_customer_id = user_id AND user_id = ".$_SESSION['user_details']['user_id'];

else

$SQL="SELECT * FROM `connection`,`user`,`category` WHERE connection_category_id = category_id AND connection_customer_id = user_id";

$rs=mysql_query($SQL) or die(mysql_error());

function delete_connection(connection_id) {

if(confirm("Do you want to delete the connection?")) {

<h4 class="heading colr">Electricity Connection Report</h4>

<?php

if($_REQUEST['msg']) {

<?php }

<form name="frm_connection" action="lib/connection.php"

method="post">

<tbody>

<td scope="col">Request Load</td>

<td scope="col">Connection Type</td>

<td scope="col">Action</td>

</tr>

<?php

$sr_no=1;

while($data = mysql_fetch_assoc($rs)) {

<tr>

<td><?=$data[connection_request_load]?

></td>

<?php if($_SESSION['user_details']

['user_level_id'] == 1) { ?>

<a href="connection.php?

In document PHP and MySQL Project on Electricity Billing System (Page 41-108)