Preview: add-fuel-rate.php
Size: 8.82 KB
/home/urbanman/roadkaraja.in/admin/add-fuel-rate.php
<?php
error_reporting(0);
include("common.php");
?>
<!-- START: Main Content-->
<main>
<div class="container-fluid">
<!-- START: Breadcrumbs-->
<div class="row ">
<div class="col-12 align-self-center">
<div class="sub-header mt-3 py-3 px-3 align-self-center d-sm-flex w-100 rounded">
<div class="w-sm-100 mr-auto"><h4 class="mb-0">Fuel Management</h4></div>
<ol class="breadcrumb bg-transparent align-self-center m-0 p-0">
<li class="breadcrumb-item">Home</li>
<li class="breadcrumb-item">Fuel Management</li>
</ol>
</div>
</div>
</div>
<!-- END: Breadcrumbs-->
<!-- START: Card Data-->
<!-- <div class="row row-eq-height">
<div class="col-12 mt-3">
<div class="card h-100">
<div class="card-header">
<h4 class="card-title">Today Petrol/Diesel Rate </h4>
<?php if($_GET[flag]=='exist'){?> <font color="red"> <b>Sorry! Already Added Record. Now update record.</b> </font> <?php } ?>
</div>
<div class="card-content">
<div class="card-body py-5">
<form class="form-row" action="submit-rate.php" method="post">
<div class="form-row">
<div class="form-group col-md-6">
<label for="inputCity">Fuel Type</label>
<select name="fueltyp" id="fueltyp" class="form-control" required>
<option>Select Fuel Type</option>
<option value="Diesel">Diesel</option>
<option value="Petrol">Petrol</option>
</select>
</div>
<div class="form-group col-md-6">
<label for="inputCity">Amount Per Ltr</label>
<input type="number" required name="ltramt" class="form-control" placeholder="Enter Amount Per Ltr" id="ltramt">
</div>
<div class="form-group input-primary col-sm-12 mb-4">
<input type="submit" class="btn btn-primary" value="Submit"> </button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>-->
<div class="row">
<div class="col-6 mt-3">
<div class="card">
<div class="card-header justify-content-between align-items-center">
<h4 class="card-title">Today Petrol Rate </h4>
</div>
<div class="card-body">
<div class="table-responsive">
<table id="example" class="display table dataTable table-striped table-bordered" >
<tbody>
<?php
error_reporting(0);
include("config.php");
$query="select * from liverate where fueltyp='Petrol' order by id desc";
if(!($result=mysql_query($query))){echo mysql_error($query); exit;}
while($row=mysql_fetch_assoc($result)){
?>
<tr>
<td><center><font color="blue"><h2><?php echo $row[live_rate];?>/- LTR</font> </h2></center> </td>
</tr>
<tr>
<td><center>Last Update Date: <font color="blue"><?php echo date('d-m-Y',strtotime($row['udate'])); ?></font> </center> </td>
</tr>
<tr>
<td><center><a href="edit-fuel-rate.php?id=<?php echo $row[id];?>"><button class="btn4" type="button">Update Rate</button></a></center> </td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="col-6 mt-3">
<div class="card">
<div class="card-header justify-content-between align-items-center">
<h4 class="card-title"> Today Diesel Rate </h4>
</div>
<div class="card-body">
<div class="table-responsive">
<table id="example" class="display table dataTable table-striped table-bordered" >
<tbody>
<?php
error_reporting(0);
include("config.php");
$query_Diesel="select * from liverate where fueltyp='Diesel' order by id desc";
if(!($result4=mysql_query($query_Diesel))){echo mysql_error($query_Diesel); exit;}
while($rowD=mysql_fetch_assoc($result4)){
?>
<tr>
<td><center><font color="blue"><h2><?php echo $rowD[live_rate];?>/- LTR</font> </h2></center> </td>
</tr>
<tr>
<td><center>Last Update Date: <font color="blue"> <?php echo date('d-m-Y',strtotime($rowD['udate'])); ?></font> </center> </td>
</tr>
<tr>
<td><center><a href="edit-fuel-rate.php?id=<?php echo $rowD[id];?>"><button class="btn4" type="button">Update Rate</button></a></center> </td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- END: Card DATA-->
</div>
</main>
<!-- END: Content-->
<!-- START: Back to top-->
<a href="#" class="scrollup text-center">
<i class="icon-arrow-up"></i>
</a>
<!-- END: Back to top-->
<!-- START: Template JS-->
<script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
<script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
<script src="dist/vendors/moment/moment.js"></script>
<!-- <script src="dist/vendors/bootstrap/js/bootstrap.bundle.min.js"></script> -->
<script src="dist/vendors/slimscroll/jquery.slimscroll.min.js"></script>
<script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script>
<!-- END: Template JS-->
<!-- START: APP JS-->
<script src="dist/js/app.js"></script>
<!-- END: APP JS-->
<style>
.btn4{
padding:4px;
background-color:#00bcd4;
color:#fff;
border-radius:20px;
padding-left:20px;padding-right:20px;
border:2px solid #00bcd4;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
width:150px;
}
</style>
</body>
</html>
Directory Contents
Dirs: 4 × Files: 78