Preview: addressbook.php
Size: 15.89 KB
/home/urbanman/roadkaraja.in/employee/addressbook.php
<?php
error_reporting(0);
include("common.php");
include("config.php");
?>
<style>
#content-desktop {display: block;}
#content-mobile {display: none;}
@media screen and (max-width: 768px) {#content-desktop {display:none;}
#content-mobile {display: block;}
}
</style>
<style>
div.a {
position: relative;
width: 500px;
height: 120px;
}
div.b {
position: absolute;
left: auto;
width: 300px;
height: 120px;
}
div.c {
position: absolute;
left: 330px;
width: 200px;
height: 120px;
}
.card__space-75 {
width: 75%;
float: left;
}
.card__space-25 {
width: 25%;
float: left;
}
.card_numer {
display: block;
width: 100%;
word-spacing: 4px;
font-size: 20px;
letter-spacing: 8px;
color: #000;
text-align: center;
margin-bottom: 20px;
margin-top: 20px;
}
</style>
<title>Welcome </title>
<!-- START: Main Content-->
<main>
<div class="container-fluid">
<!-- START: Breadcrumbs-->
<!-- END: Breadcrumbs-->
<?php
$query454453="select * from customer where vehicle_number='".$_GET[vnumber]."' || customer_mobile='".$_GET[mnumber]."' ";
if(!($result2432=mysql_query($query454453))){echo mysql_error($query454453); exit;}
$rowdata=mysql_fetch_assoc($result2432);
$query2="select * from customer_product_point where vnumber='".$_GET[vnumber]."' || mobile='".$_GET[mnumber]."'";
if(!($result2=mysql_query($query2))){echo mysql_error($query2); exit;}
$rowdatapoint=mysql_fetch_assoc($result2);
?>
<div class="row">
<div class="col-12 col-sm-4 mt-3">
<div class="card">
<div class="card-body" style="background-image: linear-gradient(to right, #10646f, #00bcd4);border:4px solid #ddd">
<div class="table-responsive">
<img class="card__front-square card__square" src="img/petrol.png" style="width:25px;">
<font color="yellow"><b><?php echo ucwords($rowdata[cardtyp]);?></b></font>
<h1><center><b><font color="yellow"><?php echo strtoupper($rowdata[vehicle_number]);?></font></b></center> </h1>
<?php if($rowdata[customer_name]==''){?>
<center> <font color="red"><b>No Record Found!</b></font> <br/><a href="add-customer.php?m=<?php echo $_GET[vnumber];?>&f=<?php echo $_GET[fueltyp];?>"> <br/>
<button type="button" class="btn" style="border:2px solid red"> Add New Customer</a></button></center>
<meta http-equiv="refresh" content="0.0;url=add-customer.php?vnumber=<?php echo $_GET[vnumber];?>"> <br>
<center><div class="loader"></div> </center>
<?php } else {?>
<div class="card__space-75">
<font color="#fff"><span class="card__label"><small>Card holder</small></span>
<p class="card__info"><b><?php echo ucwords($rowdata[customer_name]);?></b>
</font></p>
</div>
<center>
<p><small><i class="fa fa-phone" aria-hidden="true"></i>
<?php echo $rowdata[customer_mobile];?></small></p>
<?php
$result = mysql_query("SELECT * FROM customer_product_point where vnumber='".$_GET[vnumber]."' || mobile='".$_GET[mnumber]."' ") or die(mysql_error());
while ($rows = mysql_fetch_array($result)) {?>
<?php if($rows['point']=='0'){?><b> </b><?php } else {?>
<p style="font-size:38px;"><center><b><button type="button" class="btn9">Saving Point : <b><?php echo $rows['point']; ?></b></button></b></center></p>
<?php } ?>
</center>
<?php } ?>
<?php } ?>
</div>
</div>
</div>
<br>
<div id="content-desktop">
<?php
$data900="select * from liverate where fueltyp='Petrol'";
if(!($row400=mysql_query($data900))){echo mysql_error($data900); exit;}
$rowpratelive=mysql_fetch_assoc($row400);
$data400="select * from liverate where fueltyp='Diesel'";
if(!($row800=mysql_query($data400))){echo mysql_error($data400); exit;}
$rowdratelive=mysql_fetch_assoc($row800);
?>
<center><button type="button" class="btn7"> Petrol <?php echo $rowpratelive[live_rate];?> Ltr </button>
<button type="button" class="btn88"> Diesel <?php echo $rowdratelive[live_rate];?> Ltr</button>
</center>
</div>
</div>
<?php if($rowdata[customer_name]!=''){
$result = mysql_query("SELECT * FROM customer_product_point where vnumber='".$_GET[vnumber]."' || mobile='".$_GET[mnumber]."' ") or die(mysql_error());
$rows = mysql_fetch_array($result);
?>
<div class="col-12 col-sm-8 mt-3">
<div class="card">
<div class="card-body" style="background-color:#ddd">
<div class="table-responsive">
<form action="submit-product-reward.php" id="reward" method="post">
<p>Fuel Type : <b><?php echo $_GET[fueltyp];?></b></p>
<!-- Fuel ltr-->
<input type="text" style="width:140px;font-size:30px;background-color:#ddd;border-left:0px;border-right:0px;border-top:0px;" name="price" placeholder=" Fuel LTR" onkeypress="return isNumberKey(event)" id="price" > LTR
<br> <br>
<?php
$fueltyp = $_GET[fueltyp];
$data="select * from commission where fueltyp='$fueltyp'";
if(!($row=mysql_query($data))){echo mysql_error($data); exit;}
$rowcomm=mysql_fetch_assoc($row);
//$fueltyp = $_GET[fueltyp];
//$data4="select * from liverate where fueltyp='$fueltyp'";
//if(!($row4=mysql_query($data4))){echo mysql_error($data4); exit;}
//$rowprate=mysql_fetch_assoc($row4);
?>
<!-- START: Commission-->
<input type="hidden" class="form-control" name="input2" style="width:200px;" value="<?php echo $rowcomm[commrate];?>" id="input2" >
<!-- START: petrol live rate-->
<div class="a">
<div class="b"> <p> Add Point </p>
<!-- <input type="number" readonly class="form-control" style="width:200px;" name="output" id="output" value="" > -->
<input type="number" readonly class="form-control" style="width:200px;" name="output" id="output" value="" >
<br>
<select name="paytyp" class="form-control" required>
<option value=""> Payment Type </option>
<option value="Cash Payment"> Cash Payment</option>
<option value="Debit Card"> Debit Card </option>
<option value="Credit Card "> Credit Card </option>
<option value="PhonePe/Paytm/Gpay"> PhonePe/Paytm/Gpay</option>
<option value="Online"> Online</option>
<option value="IOC Xtra Power Fleet Card"> IOC Xtra Power Fleet Card</option>
<option value="BPC Smart Fleet Card"> BPC Smart Fleet Card</option>
<option value="HPC Drivetrac Plus "> HPC Drivetrac Plus </option>
<option value="Other"> Other </option>
</select>
<br>
<input type="hidden" name="wb" value="<?php echo $rows['point']; ?>" id="wb" ></div>
<div class="c"> Total LTR:
<?php if($rows['point']==''){?>
<input type="number" style="font-size:30px;border:0px;font-weight:bold;" readonly class="form-control" style="width:200px;" name="sum" id="sum" value="">
<?php } else {?>
<input type="text" style="font-size:30px;border:0px;font-weight:bold;" readonly class="form-control" style="width:200px;" name="sum" id="sum" value="">
<?php } ?>
<?php if($rows['point']==''){?> <?php } else {?>
<input type="checkbox" checked hidden name="wallet_balance" id="wallet_balance" value="<?php echo $rows['point']; ?>">
<?php } ?></div>
</div>
<br>
<input type="hidden" name="vnumber" value="<?php echo $rowdata[vehicle_number];?>">
<input type="hidden" name="mnumber" value="<?php echo $_GET[mnumber];?>">
<input type="hidden" name="mobile" value="<?php echo $rowdata[customer_mobile];?>">
<input type="hidden" name="cid" value="<?php echo $rowdata[id];?>">
<input type="hidden" name="ftyp" value="<?php echo $_GET[fueltyp];?>">
<input type="hidden" name="prepoint" value="<?php echo $rowdatapoint[point];?>">
<input type="hidden" name="branch" value="<?php echo $_SESSION[branch];?>">
<input type="hidden" name="empmob" value="<?php echo $_SESSION['emp_mobile'];?>">
<input type="hidden" name="empid" value="<?php echo $_SESSION['empid'];?>">
<input type="hidden" name="empname" value="<?php echo $_SESSION['empname'];?>">
<br><br>
<button type="submit" id="reward" class="btn4">Finish</button> <hr>
<?php $id = $rows[id]; if($id==""){?>
<input type="hidden" value="add" name="mode" >
<?php }else{?>
<input type="hidden" value="<?php echo $id;?>" name="id" >
<?php }?>
</div>
</form>
</div>
</div>
</div>
<?php }?>
</div>
</div>
<!-- END: Card DATA-->
<div class="row">
<div class="col-12 mt-3">
<div class="card">
<div class="card-body">
<div class="table-responsive">
<table id="example" class="display table dataTable table-striped table-bordered" >
<thead>
<tr>
<th>#</th>
<th><b>LTR</b> </th>
<th><center> <b>Point</b></center></th>
<th><center> <b>Payment</b></center></th>
<th><b>Purchased<b/></th>
</tr>
</thead>
<tbody>
<?php
$vnumber = $_GET[vnumber];
$mnumber = $_GET[mnumber];
if($vnumber!=''){
$rr="select * from customer_product_point where vnumber = '$vnumber' order by id desc ";
} else {
$rr="select * from customer_product_point where mobile='$mnumber' order by id desc ";
}
if(!($rs=mysql_query($rr))){echo mysql_error($rr); exit;}
$row=mysql_fetch_assoc($rs);
$cid = $row['cid'];
$que5 = sprintf("SELECT * from record WHERE cid = '$cid' order by id desc Limit 5");
if(!($res5=mysql_query($que5))){echo mysql_error($que5); exit;}
while($sr_data=mysql_fetch_assoc($res5)){
$count4++;
$clcnt4++;
?>
<tr>
<td><?php echo $count4;?></td>
<td> <small><?php echo $sr_data['price'];?> LTR </small></td>
<td> <small> <center><button type="button" class="btn9"><?php echo $sr_data['price'];?></button></center> </small></td>
<td> <small><?php echo $sr_data['pay_typ'];?> </small> </td>
<td style="color:green"><small><b><?php echo date('d-m-Y',strtotime($sr_data['purchased'])); ?> <?php echo $sr_data['ptime'];?></b> </small></td>
</tr>
<?php } ?>
</tfoot>
</table>
</div>
</div>
</div>
</div>
</div>
<div class="footer" id="content-mobile">
<?php
$data900="select * from liverate where fueltyp='Petrol'";
if(!($row400=mysql_query($data900))){echo mysql_error($data900); exit;}
$rowpratelive=mysql_fetch_assoc($row400);
$data400="select * from liverate where fueltyp='Diesel'";
if(!($row800=mysql_query($data400))){echo mysql_error($data400); exit;}
$rowdratelive=mysql_fetch_assoc($row800);
?>
Petrol : <b><?php echo $rowpratelive[live_rate];?> Ltr </b>
Diesel : <b><?php echo $rowdratelive[live_rate];?> Ltr </b>
</div>
</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-->
<!-- END: Page Vendor JS-->
<script>
$("#input2,#price,#prate").keyup(function () {
$('#output').val($('#price').val());
// $('#output').val($('#output').val() / $('#price').val());
});
</script>
<script src="//ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
<script>
$('#price').keyup(function(){
var price;
var output;
textone = parseFloat($('#price').val());
texttwo = parseFloat($('#output').val());
var result = textone - texttwo + texttwo;
$('#sum').val(result.toFixed(2));
});
</script>
<!-- START: Page Script JS-->
<script src="dist/js/datatable.script.js"></script>
<style>
.btn44{
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);
}
.btn4{
padding:4px;
background-color:#00bcd4;
color:#fff;
border-radius:2px;
padding-left:20px;padding-right:20px;
border:2px solid #00bcd4;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
width:300px;
}
.btn5{
padding:4px;
background-color:#e3232c;
color:#fff;
border-radius:20px;
padding-left:20px;padding-right:20px;
border:2px solid #e3232c;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
width:150px;
font-size:12px;
}
.btn8{
padding:4px;
font-size:20px;
background-color:#8bc34a;
color:#fff;
border-radius:0px;
letter-spacing: 6px;
padding-left:10px;padding-right:10px;
border:2px solid #8bc34a;
font-weight:bold;
font-family:cambria;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);width:260px;
}
.btn88{
padding:3px;
background-color:#673ab7;
color:#fff;
border-radius:20px;
padding-left:10px;padding-right:10px;
border:2px solid #673ab7;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
}
.btn7{
padding:3px;
background-color:#e3232c;
color:#fff;
border-radius:20px;
padding-left:20px;padding-right:20px;
border:2px solid #e3232c;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
}
.btn9{
padding:4px;
background-color:#ce0d71;
color:#fff;
border-radius:0px;
padding-left:20px;padding-right:20px;
border:2px solid #ce0d71;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
}
.btn99{
padding:4px;
background-color:green;
color:#fff;
border-radius:0px;
padding-left:20px;padding-right:20px;
border:2px solid green;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
}
</style>
<!-- END: Page Script JS-->
</body>
<script>
function isNumberKey(evt) {
var charCode = (evt.which) ? evt.which : event.keyCode;
if (charCode != 46 && charCode > 31
&& (charCode < 48 || charCode > 57))
return false;
return true;
}
</script>
<style>
.footer {
position: fixed;
left: 0;
bottom: 0;
width: 100%;
background-color: red;
color: white;
text-align: center;
}
</style>
</html>
Directory Contents
Dirs: 4 × Files: 18