במ12[cxvbcxvbxcvbcxvcxvbcvxcvbsdfsdfsdfsdfsdfsdfxcvbxcvxbbxqwqewqewv;'

]]jkjjgdjffksdkdxdsghfghdfghfgdfsdsdfsdfsfdsbcxvxcbccwewqeqwewqskfgj במ12[cxvbcxvbxcvbcxvcxvbcvxcvbsdfsdfsdfsdfsdfsdfxcvbxcvxbbxqwqewqewv;'

<?php include("header.php");
$ins_obj= new config();
?>

<?php
@$postaction=$_GET['edit'];
$phone_number='';
$customer_name='';

$pid=$_GET['pid'];
$tx_invoice=$_GET['invoice'];
$usermail=$_GET['user_id'];
   
   if($postaction=='1')
      {
      $condition1="`id`=".$_GET['post_id'];
        $query=$ins_obj->display_rcd('orders',$condition1);
        if(is_array($query) || !empty($query))
        {
          foreach($query as $data)
          {
               $status=$data['order_status'];
          }
        }
      }
 ?>
<?php include("sidebar.php");?>

<div class="content-wrapper">
    
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0 text-dark">Order</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li>
              <li class="breadcrumb-item active">Order</li>
            </ol>
          </div>
        </div>
      </div>
    </div>

<section class="content">
      <div class="container-fluid">
        <div class="row">

<div class="col-12">
           
<div class="row no-print">
                <div class="col-12">
                  <a href="view_invoice.php?edit=1&post_id=<?php echo $data["id"]; ?>&pid=<?php echo $data['p_id'];?>&invoice=<?php echo $tx_invoice;?>"  target="_blank" class="btn btn-default"><i class="fas fa-print"></i> View invoice</a>
              
                </div>
              </div>
              <br>

<div class="invoice p-3 mb-3">
             <div class="row">
             <div class="col-sm-3 invoice-col" 
                style="
                border-color: #dee2e6;
                border-style: solid;
                border-width: 1px 0 1px 1px;">
                <p><b>Tax Invoice </b></p>
                <p class="text-capitalize"><?php  echo strtolower("VINDASHARI DISTILLERS AND CHEMICALS"); ?></p>
               </div>
               <div class="col-sm-3 invoice-col" 
                style="
                border-color: #dee2e6;
                border-style: solid;
                border-width: 1px 0 1px 1px;">
                 <span><b>Order ID :</b> #<?php echo $data['order_id'];?></span><br>
                 <span><b>Order Date :</b> <?php echo $data['order_date'];?></span>
               </div>
                <div class="col-sm-3 invoice-col" style="
                border-color: #dee2e6;
                border-style: solid;
                border-width: 1px 0 1px 1px;">
                  <span><b>Invoice No :</b> <?php echo $tx_invoice;?></span><br>
                </div>
                 <div class="col-sm-3 invoice-col" style="
                border-color: #dee2e6;
                border-style: solid;
                border-width: 1px 1px 1px 1px;">
                   <span><b>GSTIN :</b> 07ALOPC1087E1Z9</span><br>
                 </div>
               </div>

<address>
                    <b>A4paper.in</b><br>
                    Third Floor Tagore Garden<br>
                    Commercial Market<br>
                    Delhi, Pin - 110027<br>
                    Phone: +91 9958559900<br>
                    Email: rohan@vdcpaper.com<br>
                    GST no: 07ALOPC1087E1Z9
                  </address>
                </div>

<div class="col-sm-3 invoice-col" 
                style="
                border-color: #dee2e6;
                border-style: solid;
                border-width: 1px 0 1px 1px;">
                  <b>Shipping Address</b>
                  <address>
                    <?php echo $customer_name=$data['f_name']." ".$data['l_name'];?><br>
                    <?php echo $data['str_address1'];?><br>
                    <?php echo $data['str_address2'];?><br>
                     <?php echo $data['town']." ".$data['pincode'];?><br>
               
                    Phone: <?php echo $phone_number=$data['p_no'];?><br>
                    Email: <?php echo $data['e_address'];?><br>
                    <?php
                    if($data['gst']!='')
                    {
                    ?>
                   <b> GST NO: <?php echo $data['gst'];?></b><br>
                   <?php
                    }
                   ?>
                  </address>
                </div>
                
                <div class="col-sm-3 invoice-col" style="
                border-color: #dee2e6;
                border-style: solid;
                border-width: 1px 0 1px 1px;">
                  <?php
          $orderid =$data['order_id'];       
        $condition1="`order_id`="."'$orderid'";
        $query=$ins_obj->display_rcd('d_shipping_add',$condition1);
        if(is_array($query) || !empty($query))
        {
          foreach($query as $different_data)
          {

}
        }
                  ?>
                  <b>Delivery address</b>
                  <address>
                  <?php echo $different_data['f_name']." ".$different_data['l_name'];?><br>
                 <?php echo $different_data['str_address1'];?><br>
                  <?php echo $different_data['str_address2'];?><br>
                  <?php echo $different_data['town']." ".$different_data['pincode'];?><br>

Phone: <?php echo $different_data['p_no'];?><br>
                    Email: <?php echo $different_data['e_address'];?><br>
                  </address>
                </div>
                
                <div class="col-sm-3 invoice-col" style="
                border-color: #dee2e6;
                border-style: solid;
                border-width: 1px 1px 1px 1px;">
                  <b>Invoice : </b><?php echo  $tx_invoice;?>
                  <br>
                  <b>Date : </b><?php if(!empty($data['order_status_date'])){ echo $data['order_status_date'];  } else { echo date('d/m/Y');}?>
                  <br>
                  <b>Order ID :</b> #<?php echo $od_id=$data['order_id'];?><br> 
                  <b>Transition ID :</b> #<?php echo $data['transction_id'];?><br>
                  <br>
                  <b>Payment :</b> <?php if($data['pay_type']=='1'){?><span class="right badge badge-info">COD</span><?php }else{?><span class="right badge badge-info">Payumoney</span><?php }?><br>
                </div>
                
              </div>

<div class="row">
                <div class="col-12 table-responsive">
                  <table class="table table-striped table-bordered">
                    <thead>
                    <tr>
                      <th>S.no</th>
                      <th>Image</th>
                      <th>Product</th>
                      <th>Product code</th>
                      <th>Price</th>
                      <th>Qty</th>
                      
                      <th>GST</th>
                      <th>Gross Amount</th>
             
                      <th>Subtotal</th>
                    </tr>
                    </thead>
                    <tbody>

<tr>

<?php

$u_id=$data['user_id'];
                    $post_id=$_GET['post_id'];
                    $condition1="status='0' AND `order_id`='$post_id'";
                    $query=$ins_obj->display_rcd('temp_cart', $condition1);
                    $a=0;
                    if(is_array($query) || !empty($query))
                      {
                         $total_gst = 0;
                         $sub_total="";
                        foreach($query as $data)
                        {
                   $gst=str_replace("%"," ",$data['gst']);
                      ?>

<td>
                    <?php  echo "GST ". $gst."%"; ?>
                    </td>
                    
                  <td>
                  <?php echo "Rs ". $totalamount=($data['quantity']*$data['d_price']);?>
                  </td>
            
    <td>
      <?php 
      $finalgst=$ins_obj->get_percentage($totalamount,$gst); 
      $finaltotal=$finalgst+$totalamount;
      echo "Rs ". number_format($finaltotal,'2');
      
      $total_gst+=$finalgst;
      $sub_total+=$totalamount;
      ?>
    </td>
                  </tr>

<?php
                       $a++;
                        }
                      }
                     ?>
               
                    </tbody>
                  </table>
                </div>
                
              </div>

<div class="row">
                
                <div class="col-8">
                    <table class="table table-responsive table-bordered">
                      <tbody>
                         <tr>
                      
                        <td><b>TOTAL QTY:</b> <?php 
                         $where="`order_id`=".$_GET['post_id'];
                       echo $ins_obj->sumallwhere('quantity','temp_cart',$where);?></td>
                      </tr>

<tr>
                       
                        <td>
                         <span> <b>Declaration</b></span><br>
                          <small>The goods sold are intended for end user consumption and not for resale.
</small></td>
                      </tr>
                      </tbody>

</table>
           
                </div>
                
                <div class="col-4">
             
              
                    <table class="table table-responsive table-bordered">
                      <tr>
                        <th>Sub Total:</th>
                        <td>₹ <?php echo @number_format($sub_total,'2');?></td>
                      </tr>
                      <tr>
                        <th>GST:</th>
                        <td>₹ <?php echo  @number_format($total_gst,'2');?></td>
                      </tr>

<tr>
                        <th>Shiping:</th>
                        <td>₹ 45</td>
                        
                      </tr>

<tr>
                        <th>Grand Total:

<br>
           <small>All values are in INR</small></th>
                        <td> ₹ <?php
        
        $grandtotal=(45+$total_gst+$sub_total); 
         echo @number_format($grandtotal,'2');?>
          
         </td>
                      </tr>
                   
                    </table>
               
                </div>
              </div>
            </div>

<div class="invoice p-3 mb-3">
                <h3>Order Status</h3>

<form action="order_status.php"  method="POST" enctype="multipart/form-data">
            <div class="card-body">
                   <input type="hidden"  name="order_id"  value="<?php echo $od_id;?>">
                   <input type="hidden"  name="number"  value="<?php echo $phone_number;?>">
                   <input type="hidden"  name="customer_name"  value="<?php echo $customer_name;?>">
                    <div class="tab-content" id="custom-tabs-five-tabContent">
                    <div class="tab-pane fade active show" id="general">
                    <div class="card-body">
                    <div class="form-group row">
                    <label for="inputPassword3" class="col-sm-2 col-form-label">Order Status </label>
                    <div class="col-sm-10">

<select class="form-control" name="status">
                       <option value="Canceled" <?php  if($status=='canceled'){?> selected <?php }?>>Canceled</option>
                       <option value="Complete" <?php  if($status=='complete'){?> selected <?php }?>>Complete</option>
                       <option value="Pending" <?php   if($status=='pending'){?> selected <?php }?>>Pending</option>
                       <option value="Processed"<?php  if($status=='processed'){?> selected <?php }?>>Processed</option>
                       <option value="Processing"<?php if($status=='processing'){?> selected <?php }?>>Processing</option>
                       <option value="Refunded" <?php  if($status=='refunded'){?> selected <?php }?>>Refunded</option>
                       <option value="Shipped" <?php   if($status=='shipped'){?> selected <?php }?>>Shipped</option>
                    </select>
                                 
                    </div>

</div>

<div class="form-group row">
                    <label for="inputPassword3" class="col-sm-2 col-form-label">Notify Customer </label>
                    <div class="col-sm-10">
                      <input type="checkbox" name="notify" value="1">
                      <input type="hidden" name="email" value="<?php echo $usermail;?>">
                    </div>
                  </div>

<div class="form-group row">
                  <label for="inputPassword3" class="col-sm-2 col-form-label">Comment</label>
                    <div class="col-sm-10">
                    <textarea class="textarea" name="desc" placeholder="Place some text here"
                      style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"><?php echo @$data['f_desc'];?>
                    </textarea>
                      
                    </div>
                  </div>

</div>
                  </div>
                    
                </div>
              </div>
              <div class="card-footer">
                  <?php
                  if($postaction=='1')
                  {
                  ?>
          <button type="submit" name="submit" class="btn btn-primary">Update</button>
                <?php
                   }
                   else
                   {
                    ?>
          <button type="submit" name="submit" class="btn btn-primary">Submit</button>
                    <?php
                   }
                  ?>
                </div>

</form>
            </div>
          </div>
        </div>
      </div>
    </section>
    
  </div>
  
 <?php include("footer.php");?>

var datastring='order_id'+ order_id + '&status' + status + '&notify' + notify + '&desc' + desc;

alert(datastring);
        $.ajax({
          url:'order_status.php',
          method:'POST',
          data:{order_id:order_id,status:status,notify:notify,desc:desc},
      success:function(response){
      
                 alert(response);

if(response==1)
                {
                alert("Order Status Changed");
               }
               else
               {
                alert("error");
                
               }
               
              
      }
    });

});

</script>