MAINHACK

Viewing / Editing File: show_bill.php

<?php

$id=$_REQUEST['id'];include('header.php');
$show=new Oops($db);
$bid=base64_decode($_REQUEST['bid']);

?>
<div class="main-panel">
	<div class="content">
		<div class="container-fluid">
			<div class="row">	
<div class="col-md-12">
<div class="card">
	<div class="card-header">
		<div class="card-title">Order Details</div>
	</div>
<?php  
  $total1=0;
        $stmt1=$show->readwithdata('place_order','order_id',$bid);
        $num1=$stmt1->rowCount();
        if($num1>0){
	    while($row=$stmt1->fetch(PDO::FETCH_ASSOC)){

$pro_id=$row['order_id'];	
$cname=$row['user_id'];
$date=$row['date'];
$amt=$row['amount'];
$phone=$row['phon'];
$add=$row['address'];
$st=$row['status'];
$points=$row['points'];
$email=$row['email'];
$pincode=$row['pincode'];
$status=$row['status'];
$client_name=$row['client_name'];
$gst=$row['gst'];
$dcharge=$row['delivery_charge'];	
$covi=$row['convenience'];				
	
?>
	
		<div class="card-body">
			
	<h6>Customer Details</h6>	
		
		 <div class="form-group form-show-validation row">
          	 <div class="col-md-3">
            <label>Order details & Time </label>
			<input type="text" class="form-control" name="product_name" readonly value="<?=date('d-m-Y h:i a',strtotime($date))?>" placeholder="Title">
             </div>

<div class="col-md-3">
            <label>Customer Name </label>
			<input type="text" class="form-control" name="product_name" value="<?=$client_name?>" readonly placeholder="Title">
             </div> 
              <div class="col-md-3">
            <label>Customer Phone </label>
			<input type="text" class="form-control" name="product_name" value="<?=$phone?>" readonly placeholder="Title">
             </div> 
               <div class="col-md-3">
            <label>Customer Email </label>
			<input type="text" class="form-control" name="product_name" value="<?=$email?>" readonly placeholder="Title">
             </div>
		    </div> 
		    
		<div class="form-group form-show-validation row">
          	<div class="col-md-6">
            <label>Address</label>
			<input type="text" class="form-control" name="product_name" value="<?=$add?>" readonly placeholder="Title">
             </div> 
         
			<div class="col-md-3">
            <label>Pincode </label>
			<input type="text" class="form-control" name="product_name" value="<?=$pincode?>" readonly placeholder="Title">
             </div> 
            
             
		</div>
		<hr>
			<h6>Delivery Details</h6>

<div class="form-group form-show-validation row">
          	 <div class="col-md-3">
            <label>Delivery Agent</label>
			<input type="text" class="form-control" name="product_name" readonly value="<?=$row['delivery_agent']?>" placeholder="Title">
             </div>

<div class="col-md-3">
            <label>Phone </label>
			<input type="text" class="form-control" name="product_name" value="<?=$row['phone']?>" readonly placeholder="Title">
             </div> 
            	<div class="col-md-2">
            <label>Order Status</label>
			<input type="text" class="form-control" name="product_name" value="<?=$row['order_status']?>" readonly placeholder="Title">
             </div> 
		    	<div class="col-md-3">
            <label>Payment Mode </label>
			<input type="text" class="form-control" name="product_name" value="<?=$row['pay_status']?>" readonly placeholder="Title">
             </div> 
            
		    </div> 
		    
	
             
		</div>  	
<h4>Details</h4>

<hr>		
<?php } }

$stmt13=$show->readwithdata('datalog','order_id',$bid);
        $num13=$stmt13->rowCount();
        if($num13>0){
            ?>
        <table class="display table table-striped table-hover">
           <thead><tr><th>Time</th> <th>Status</th></tr></thead> 
<?php            
	    while($row=$stmt13->fetch(PDO::FETCH_ASSOC)){
?>
<tbody>
<tr><td><?=date('d-m-Y h:i a',strtotime($row['time']))?></td><td><?=$row['status']?></td></tr>
</tbody>
<?php } }?>
</table>

<hr>
  
		
		
			<div class="form-group form-show-validation row" >		
		 	
					<table id="basic-datatables" class="display table table-striped table-hover">
				<thead>
				        <tr>
				    <th>Sl No   </th>
                    <th>Product Name</th> 
                    <th>Qty</th>
                    
                    <th>Product Price </th>
                    <th> Total </th>          
				        </tr>
				    </thead>
				    <tbody>
<?php
$stmt12=$show->readwithdata('bill','order_id',$bid);
$num12=$stmt12->rowCount();
//echo $num12;
if($num12>0){
	while($row12=$stmt12->fetch(PDO::FETCH_ASSOC)){
		$total=intval($row12['quantity']*$row12['price']);
		$total1+=$total;
        $pname=$row12['product_name'];
        $quantity=$row12['quantity'];
        $price=$row12['price'];
	  ?>   				 
				 
				     <tr>
                    <td>1.</td>
                    <td><?=$pname?> </td>
                    <td><?=$quantity?></td>
                    <td><?=$price?></td>
                    <td><?=$total?></td>
                                
                </tr>

<tr><td colspan="3"></td><td>Item Total</td><td><?=$total1?></td></tr>
		<tr><td colspan="3"></td><td>GST & Restaurant Charges</td><td><?=$gst?></td></tr>
		<tr><td colspan="3"></td><td>Handling Charges (Standard)</td><td><?=$dcharge?></td></tr>
          <tr><td colspan="3"></td><td>Convenience Charge</td><td><?=$covi?>
          <tr><td colspan="3"></td><td>Total</td><td><?=$amt?>
      </td></tr>     
           	<?php } } ?>
	
				        </tbody>
				    
				</table>
					
					     		
				
				</div>

<div class="card-action">
			<div class="row">
				<div class="col-md-12">
					<a href="all_bill.php" class="btn btn-success" name="back">Back</a>
					<button class="btn btn-danger">Cancel</button>
				</div>										
			</div>
		</div>
</div>
</form>
</div>

</div>
			</div>
		</div>
	</div>
</div>

</div>		
		<?php 
		
		include('footer.php');
		?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: show_bill.php

Server Info

System Features

User Info