<?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">Discount 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">Discount Management</li>
                               
                            </ol>
                        </div>
                    </div>
                </div>
                <!-- END: Breadcrumbs-->
<?php include("config.php");
	$query="select * from liverate where fueltyp='Petrol' order by id desc";
    if(!($result=mysql_query($query))){echo mysql_error($query); exit;}
   $row=mysql_fetch_assoc($result);
   
   $query2="select * from liverate where fueltyp='Diesel' order by id desc";
    if(!($result2=mysql_query($query2))){echo mysql_error($query2); exit;}
   $row2=mysql_fetch_assoc($result2);
   
   ?>
   
                <!-- START: Card Data-->
                <div class="row row-eq-height">
                                 
                    <div class="col-12 mt-3">
                        <div class="card h-100">
                            <div class="card-header">                               
                                <h5 class="card-title">How Much Discount You Want Yo Give As Per Rs.100/- </h5> 
 <h4><font color="blue"> Petrol Rate: Rs. <?php echo $row[live_rate];?>/-  </font> <br>  <font color="green">Diesel Rate: Rs. <?php echo $row2[live_rate];?>/- </font>  </h4>
											
                            </div>
	
               
                         <!--     <div class="card-content">
                                <div class="card-body py-5">                                   
                                     <form class="form-row" action="submit-discount.php" method="post">
                                            
                                                <div class="form-row">
													<div class="form-group col-md-12">
                                                        <label for="inputCity">Select Fuel Type</label>
                                                       <select required class="form-control" name="fueltyp">
													   <option>   Fuel Type </option>
													    <option value="Diesel">  Diesel </option>
														 <option value="Petrol">  Petrol </option>
														
														  </select>
                                                    </div>
												
												<div class="form-group col-md-12">
                                                        <label for="inputCity">Select Card Type</label>
                                                       <select required class="form-control" name="cardtyp">
													   <option>  Card Type </option>
													    <option value="Regular Card">  Regular Card </option>
														 <option value="Farmer/Army/Policeman">  Farmer/Army/Policeman Card </option>
														 
														  </select>
                                                    </div>
												
												
												<div class="form-group col-md-12">
                                                        <label for="inputCity">Discount Rate [ In Paise ]</label>
                                                        <input type="number"  name="discount" class="form-control"  placeholder="Enter Discount Rate" id="discount">
                                                    </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">PETROL/DIESEL Card </h4> 
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example" class="display table dataTable table-striped table-bordered" >
                                        <thead>
                                            <tr>
											 <th>Discount Rate</th>
											<th> </th>
                                            </tr>
                                        </thead>
                                        <tbody>
	<?php
	error_reporting(0);
	include("config.php");
	$query="select * from commission where fueltyp='Diesel' order by id desc";
    if(!($result=mysql_query($query))){echo mysql_error($query); exit;}
    while($row=mysql_fetch_assoc($result)){
		
		
	?>
                <tr>
				<td><font color="blue"><?php echo $row[cardtyp];?></font> -  (<?php echo $row[paise];?> Point Per LTR ) </td>
				                          
			 <td>
				<a class="btn2" title="edit" href="edit-discount.php?flag=edit&id=<?php echo $row[id];?>">
                <i class="fa fa-edit icon-white"></i>
                 
            </a> &nbsp;
			 
       
			</td>	
                                                
                                          
	<?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-->
    </body>
   
</html>