Project Report of Electricity Billing System Page 1
- Bu səhifədəki naviqasiya:
- Bill Payment Receipt (Your bill payment was successfull !!!)
- Electricity Bill Report
- Selected Room Details
- Book Your Room (Review Your Booking Details)
- Booking Report
|
Page - 116 } ?> Project Report of Electricity Billing System Page - 117 } Bill Payment Receipt (Your bill payment was
|
| Payment Refrence ID | 10000 |
|---|---|
| Payment Date | |
| Customer Name | |
| Mobile | |
| Bill Month | |
| Current Reading |
Units |
| Previous Reading |
Units |
| Total Units Consumed |
Units |
| Charge Per Unit | .00/- |
| Fix Charge | .00/-
|
| Tax | .00/- |
Project Report of Electricity Billing System
Page - 122
Project Report of Electricity Billing System
Page - 123
Coding for Bill-Report.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());
?>
Electricity Bill Report
if($_REQUEST['msg']) {
?>
Project Report of Electricity Billing System
Page - 125
}
?>
| ID | |||||
|
Paid'; else echo 'Paid';?> |
Project Report of Electricity Billing System
Page - 129
Coding for Booking-Details.php
include_once("includes/header.php");
if($_REQUEST[room_id])
{
$SQL="SELECT * FROM room,category WHERE room_category_id = category_id AND
room_id = $_REQUEST[room_id]";
$rs=mysql_query($SQL) or die(mysql_error());
$data=mysql_fetch_assoc($rs);
}
$R = $_REQUEST;
$userData = $_SESSION['user_details'];
?>
Project Report of Electricity Billing System
Page - 131
text-align:center;
boder:1px solid;
margin:1px;
border:1px solid #101746;
}
th {
font-weight:bold;
color:#ffffff;
font-size:12px;
background-color:#bf3c22;
padding:5px;
}
Project Report of Electricity Billing System
Page - 132
Selected Room Details
>
| Price Per Day | /- |
|---|---|
| Room Type | |
| Max Adults | |
| Max Childs | |
| Number of Beds |
Book Your Room (Review Your Booking
Details)
Project Report of Electricity Billing System
Page - 135
Project Report of Electricity Billing System
Page - 136
Project Report of Electricity Billing System
Page - 137
Project Report of Electricity Billing System
Page - 138
Coding for Booking-Report.php
include_once("includes/header.php");
include_once("includes/db_connect.php");
if($_SESSION['user_details']['user_level_id'] == 2)
{
$SQL = "SELECT * FROM book,room,category WHERE room_category_id = category_id
AND book_room_id = room_id AND book_user_id = '$_SESSION[user_details][user_id]'";
}
else
{
$SQL = "SELECT * FROM book,room,category WHERE room_category_id = category_id
AND book_room_id = room_id";
}
$rs = mysql_query($SQL) or die(mysql_error());
?>
Project Report of Electricity Billing System
Page - 140
Booking Report
if($_REQUEST['msg']) {
?>
}
?>
| Booking ID | |||||||
| 10000 | /- | Adults | Children |
Project Report of Electricity Billing System
Page - 143
Project Report of Electricity Billing System
Page - 144
Coding for Book-Room.php
print_r($_REQUEST);
include_once("includes/header.php");
if($_SESSION['login'] != 1) {
header("Location:login.php?msg=Login first to book your room !!!");
}
$R = $_REQUEST;
if(isset($R['book_from_date'])) {
$SQL="SELECT * FROM room,category where room_category_id = category_id";
$rs=mysql_query($SQL) or die(mysql_error());
}
global $SERVER_PATH;
?>
Yüklə 3,34 Mb.
Dostları ilə paylaş:
