Preview: addressbook - Copy.php
Size: 15.61 KB
/home/urbanman/roadkaraja.in/employee/addressbook - Copy.php
<?php
error_reporting(0);
include("common.php");
include("config.php");
?>
<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-->
<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">Loyality Management </h4></div>
</div>
</div>
</div>
<!-- END: Breadcrumbs-->
<?php
$query454453="select * from customer where customer_mobile='".$_GET[mobile]."'";
if(!($result2432=mysql_query($query454453))){echo mysql_error($query454453); exit;}
$rowdata=mysql_fetch_assoc($result2432);
$query2="select * from customer_product_point where mobile='".$_GET[mobile]."'";
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-header d-flex justify-content-between align-items-center">
<h4 class="card-title">Loyality Card</h4>
</div>
<div class="card-body" style="background-image: linear-gradient(to right, #1599ca , #90e3db);">
<div class="table-responsive">
<img class="card__front-square card__square" src="img/petrol.png" style="width:30px;">
<font color="#fff"><b><?php echo ucwords($rowdata[cardtyp]);?></b></font>
<p class="card_numer"><b><?php echo $_GET[mobile];?></b></p>
<?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[mobile];?>&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?mobile=<?php echo $_GET[mobile];?>"> <br>
<center><div class="loader"></div> </center>
<?php } else {?>
<div class="card__space-75">
<span class="card__label"><small>Card holder</small></span>
<p class="card__info"><?php echo ucwords($rowdata[customer_name]);?> <br> <small>DOB: </small> <?php echo date('d M, Y',strtotime($rowdata['dob'])); ?> </p>
<p><?php echo strtoupper($rowdata[vehicle_number]);?> </p>
</div>
<center>
<p><small>Saving Point</small></p>
<?php
$result = mysql_query("SELECT * FROM customer_product_point where mobile='".$_GET[mobile]."' ") or die(mysql_error());
while ($rows = mysql_fetch_array($result)) {?>
<?php if($rows['point']==''){?><b>Rs. 0 </b><?php } else {?>
<p style="font-size:38px;"><center><b><button type="button" class="btn9"><?php echo $rows['point']; ?></button></b></center></p>
<?php } ?>
</center>
<?php } ?>
<?php } ?>
</div>
</div>
</div>
<br>
<?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>
<?php if($rowdata[customer_name]!=''){
$result = mysql_query("SELECT * FROM customer_product_point where mobile='".$_GET[mobile]."' ") or die(mysql_error());
$rows = mysql_fetch_array($result);
?>
<div class="col-12 col-sm-8 mt-3">
<div class="card">
<div class="card-header d-flex justify-content-between align-items-center">
<h4 class="card-title">Loyality Management</h4>
</div>
<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:120px;font-size:20px;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/Online"> PhonePe/Online</option>
<option value="Balance Payment"> Balance Payment</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="mobile" value="<?php echo $_GET[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];?>">
<button type="submit" id="reward" class="btn4">Finish</button> <hr>
<a href="welcome.php"><button type="button" id="reward" class="btn5">Add New Customer</button></a>
<?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-header justify-content-between align-items-center">
<h4 class="card-title">Old Entry </h4>
</div>
<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
$mobile = $_GET[mobile];
$rr="select * from customer_product_point where mobile = '$mobile' order by id desc ";
if(!($rs=mysql_query($rr))){echo mysql_error($rr); exit;}
$row=mysql_fetch_assoc($rs);
$que5 = sprintf("SELECT * from record WHERE cid = '%s' order by id desc" ,$row['cid']);
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><?php echo $sr_data['price'];?> LTR </td>
<td> <center><button type="button" class="btn9"><?php echo $sr_data['price'];?></button></center></td>
<td><?php echo $sr_data['pay_typ'];?> </td>
<td style="color:green"><b><?php echo date('d M Y',strtotime($sr_data['purchased'])); ?> </b></td>
</tr>
<?php } ?>
</tfoot>
</table>
</div>
</div>
</div>
</div>
</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-->
<!-- START: Page Vendor JS-->
<script src="dist/vendors/datatable/js/jquery.dataTables.min.js"></script>
<script src="dist/vendors/datatable/js/dataTables.bootstrap4.min.js"></script>
<script src="dist/vendors/datatable/jszip/jszip.min.js"></script>
<script src="dist/vendors/datatable/pdfmake/pdfmake.min.js"></script>
<script src="dist/vendors/datatable/pdfmake/vfs_fonts.js"></script>
<script src="dist/vendors/datatable/buttons/js/dataTables.buttons.min.js"></script>
<script src="dist/vendors/datatable/buttons/js/buttons.bootstrap4.min.js"></script>
<script src="dist/vendors/datatable/buttons/js/buttons.colVis.min.js"></script>
<script src="dist/vendors/datatable/buttons/js/buttons.flash.min.js"></script>
<script src="dist/vendors/datatable/buttons/js/buttons.html5.min.js"></script>
<script src="dist/vendors/datatable/buttons/js/buttons.print.min.js"></script>
<!-- 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: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;
}
.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:20px;padding-right:20px;
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:8px;
background-color:#673ab7;
color:#fff;
border-radius:20px;
padding-left:20px;padding-right:20px;
border:2px solid #673ab7;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
}
.btn7{
padding:8px;
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:#e91e63;
color:#fff;
border-radius:20px;
padding-left:20px;padding-right:20px;
border:2px solid #e91e63;
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>
</html>
Directory Contents
Dirs: 4 × Files: 18