bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php

error_reporting (0);

include "dbc.php";

page_protect();
?>
<?php include'header.php';?>
      <div class="main-bar">
        <h3><i class="fa fa-archive"></i>&nbsp; Orders</h3>
      </div>
       
    </header>
     
  </div>
  
  <?php include'admin_admin.php';?>
  
  <div id="content">
    <div class="outer">
      <div class="inner bg-light lter">
        <style>
              .form-control.col-lg-6 {
                width: 50% !important;
              }
            </style>
        <div class="row">
          <div class="col-lg-12">
            <div class="box">
             <header>
                <h5>View Orders</h5>
                <div class="toolbar"></div>
              </header>
              <div class="row">
                <div class="col-lg-12">
                  <div class="box">
                    <div id="collapse4" class="body">
                    <?php include 'msg_display.php'?>
						 <table id="datatable-responsive" class="table table-bordered table-condensed table-hover table-striped">
						  <thead>
							  <tr>
								  <th>S.NO</th>
                                  <th>Order Id</th>
								  <th>Customer</th>
								  <th>Order Status</th>
                                  <th>Payment Status</th>
                                  <th>Total</th>
                                  <th>Date Added</th>
                                  <th>Date Modified</th>
  								  <th>Action</th>
							  </tr>
						  </thead>   
						  <tbody>
                          <?php 
						  $sno=1;
						  $status = mysqli_real_escape_string($link,$_GET['status']);
						  if($status != ""){
						      $cond = "and order_status='$status'";
						  }
						  else
						  {
						      $cond = "";
						  }
						  $sel_order = mysqli_query($link,"select * from shopping_tbl where id>0 $cond group by order_id order by id desc ");
						  while($rw_order = mysqli_fetch_object($sel_order)){?>
                          	<tr>
								<td><?php echo $sno;?></td>
                                <td><?php echo $order_id = $rw_order->order_id;?></td>
                                <td class="center">
									<?php 
									$cust = $rw_order->customer_details;
									$cus = explode(",",$cust);
									$name = $cus[0];
									$mobile = $cus[1];
									$email = $cus[2]; 
									?>
                                    <?php echo $name; ?><br><?php echo $mobile; ?><br><?php echo $email; ?>
                                </td>
								<td class="center"><?php echo $rw_order->order_status; ?></td>
								<td class="center"><?php echo $rw_order->payment_status; ?></td>
                                <td class="center"><?php echo $rw_order->grand_total; ?></td>
                                <td class="center"><?php echo $rw_order->order_date; ?></td>
                                <td class="center"><?php echo $rw_order->order_modified; ?></td>
								<td class="center">
                                
                       			<a class="btn btn-info" title="View Order Details" href="view_order_details.php?order_id=<?php echo $order_id; ?>" style="color:#fff"><i class="fa fa-eye"></i> View</a> 
                                <a class="btn btn-info" title="Update Order Details" href="edit_order_details.php?order_id=<?php echo $order_id; ?>" style="color:#fff"><i class="fa fa-edit"></i> Update</a>
                                <?php
                               	$inv_no = $rw_order->inv_no;
								if($inv_no == ""){
								?>
                                <a class="btn btn-info" title="View/Print Invoice" href="view_orders.php?order_id=<?php echo $order_id; ?>&inv=yes" style="color:#fff"><i class="icon-ok"></i> Generate Invoice</a>	
								<?php	
								}
								else
								{
								?>
                                <a class="btn btn-info" title="View/Print Invoice" href="invoice.php?order_id=<?php echo $order_id; ?>" target="_blank" style="color:#fff"><i class="icon-ok"></i> View Invoice</a>
                                <?php		
								} 
								?>
                       			 
                       			    
                       			</td>
							</tr>
							<?php $sno++; } ?>
						  </tbody>
					  </table>            
					</div>
				</div>
			
			</div>

<?php
		if($_GET['inv']=='yes'){
  		$order_id = $_GET['order_id']; 
 		//$maxdeliv = $db->maxOfAll("inv_no","shopping_tbl");
        //$count = mysql_num_rows(mysql_query("select max( from shopping_tbl"));
		//$maxdeliv=$count+1;
		list($maxdeliv) = mysqli_fetch_row(mysqli_query($link,"select `sno` from shopping_tbl where order_id='$order_id'"));
		$year=date("Y");
        $inv_no="Inv/".$year."/".$maxdeliv;		 
	  	$updtstatus="UPDATE shopping_tbl SET inv_no='$inv_no',inv_date=NOW() WHERE order_id='$order_id' ";  
		$rsult_sts = mysqli_query($link,$updtstatus) or die("Cannot Update");
		echo "<script>window.location.href='view_orders.php'</script>";
		 
		}
		?>          
           
	</div>
	
			
		</div>
		</div>
		
	<div class="modal hide fade" id="myModal">
		<div class="modal-header">
			<button type="button" class="close" data-dismiss="modal">×</button>
			<h3>Settings</h3>
		</div>
		<div class="modal-body">
			<p>Here settings can be configured...</p>
		</div>
		<div class="modal-footer">
			<a href="#" class="btn" data-dismiss="modal">Close</a>
			<a href="#" class="btn btn-primary">Save changes</a>
		</div>
	</div>
                    
            </div>
            
                
                  
                </div>
                
                
                
                
                
                
                
              </div>
            </div>
            
            
          </div>
        </div>
      </div>
      <div id="right" class="bg-light lter">
        <div class="alert alert-danger">
          <button type="button" class="close" data-dismiss="alert">&times;</button>
          <strong>Warning!</strong>  Best check yo self, you're not looking too good.
        </div>

<div class="well well-small dark">
          <ul class="list-unstyled">
            <li>Visitor <span class="inlinesparkline pull-right">1,4,4,7,5,9,10</span> 
            </li>
            <li>Online Visitor <span class="dynamicsparkline pull-right">Loading..</span> 
            </li>
            <li>Popularity <span class="dynamicbar pull-right">Loading..</span> 
            </li>
            <li>New Users <span class="inlinebar pull-right">1,3,4,5,3,5</span> 
            </li>
          </ul>
        </div>

<div class="well well-small dark">
          <button class="btn btn-block">Default</button>
          <button class="btn btn-primary btn-block">Primary</button>
          <button class="btn btn-info btn-block">Info</button>
          <button class="btn btn-success btn-block">Success</button>
          <button class="btn btn-danger btn-block">Danger</button>
          <button class="btn btn-warning btn-block">Warning</button>
          <button class="btn btn-inverse btn-block">Inverse</button>
          <button class="btn btn-metis-1 btn-block">btn-metis-1</button>
          <button class="btn btn-metis-2 btn-block">btn-metis-2</button>
          <button class="btn btn-metis-3 btn-block">btn-metis-3</button>
          <button class="btn btn-metis-4 btn-block">btn-metis-4</button>
          <button class="btn btn-metis-5 btn-block">btn-metis-5</button>
          <button class="btn btn-metis-6 btn-block">btn-metis-6</button>
        </div>

<div class="well well-small dark">
          <span>Default</span> <span class="pull-right"><small>20%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-info" style="width: 20%"></div>
          </div>
          <span>Success</span> <span class="pull-right"><small>40%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-success" style="width: 40%"></div>
          </div>
          <span>warning</span> <span class="pull-right"><small>60%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-warning" style="width: 60%"></div>
          </div>
          <span>Danger</span> <span class="pull-right"><small>80%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-danger" style="width: 80%"></div>
          </div>
        </div>
      </div>
    </div>
    <?php include'footer.php';?>