במ12[cxvbcxvbxcvbcxvcxvbcvxcvbsdfsdfsdfsdfsdfsdfxcvbxcvxbbxqwqewqewv;'

]]jkjjgdjffksdkdxdsghfghdfghfgdfsdsdfsdfsfdsbcxvxcbccwewqeqwewqskfgj במ12[cxvbcxvbxcvbcxvcxvbcvxcvbsdfsdfsdfsdfsdfsdfxcvbxcvxbbxqwqewqewv;'

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

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

$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>
              </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> 09AAJCM5963A1XD</span><br>
                 </div>
               </div>

<div class="row invoice-info" id="printTable" style="margin-bottom: 10px;">
                <div class="col-sm-3 invoice-col" 
                style="
                border-color: #dee2e6;
                border-style: solid;
                border-width: 1px 0 1px 1px;">
                 <strong> From</strong>
                  <address>
                    Mom's Pet<br>
                    3/1/26, Site-IV<br>
                    Sahibabad Industrial Area<br>
                    Ghaziabad - 201010. (India)<br>
                    Phone: 0120-4123058<br>
                    Email: momspetindia@yahoo.com<br>
                    GST no: 09AAJCM5963A1XD
                  </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 $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 $data['p_no'];?><br>
                    Email: <?php echo $data['e_address'];?><br>
                  </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 echo date('d/m/yy');?>
                  <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>Qty</th>
                      <th>Price</th>
                      <th>Description</th>
                      <th>Gross Amount</th>
                      <th>Discount</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)
                        {

?>
                         
                    <?php if($data['price']=='undefined')
                         {
                          $attibute_value=$data['attributes'];
                          $extra_attri="`status`='1' AND `o_name`="."'$attibute_value'";
                          $extra_attri_query=$ins_obj->display_rcd('options',$extra_attri);
                            if(is_array($extra_attri_query) || !empty($extra_attri_query))
                               {
                                 foreach ($extra_attri_query as $extra_attri_value)
                               {
                                     $attribute_id=$extra_attri_value['o_id'];
                               }

}

$lost_attri="`p_id`=".$data['p_id']." AND `size`="."'$attribute_id'";
                          $lost_attri_query=$ins_obj->display_rcd('multi_options',$lost_attri);
                            if(is_array($lost_attri_query) || !empty($lost_attri_query))
                               {
                                 foreach ($lost_attri_query as $lost_attri_value)
                               {
                                
                               }
                                $lostprice=$lost_attri_value['price'];

}
                           
                             
                         }

<?php                    
                          if($data['price']=='undefined')
                          {

@$sub_total += ($data['quantity'] * $lostprice);
                          }
                          else
                          {
                           @$sub_total += ($data['quantity'] * $data['price']);
                          }

$gst=str_replace("%"," ",$data['gst']);
                      
                      if($data['price']=='undefined')
                          {
                     $gst_sub=$ins_obj->getPercentOfNumber($lostprice,$gst);
                      }
                      else
                      {
                        $gst_sub=$ins_obj->getPercentOfNumber($data['price'],$gst);
                      }

$dd = ($gst_sub*$data['quantity']);
                     $total_gst += $dd;
                      ?>
                    <td><?php echo $a+1;?></td>
                    <td><img width="100" height="75" src="upload/<?php echo $data['img'];?>"></td>
                    <td>
                        <?php echo $data['p_name'];?>
                        <?php 
                        if(!empty($data['attributes'])){
                            echo "<br>Size : ".$data['attributes'];
                        }
                        else
                          {
                            echo "<br>standard size";
                          }?>
                          <br>
                            <?php 
                     $color_condition="`status`='1' AND `color_id`=".$data['color_attribute'];
                      $color_query=$ins_obj->display_rcd('color',$color_condition);
                      if(is_array($color_query) || !empty($color_query))
                      {
                        foreach ($color_query as $ava_color)
                      {
                          ?>
                          <br><span style="background: <?php echo $ava_color['color_code'];?>;" class="colorspan"></span>
                          <?php
                       }
                  }  
                ?>
                    </td>
                    <td><?php echo $data['p_code'];?></td>
                    <td> <small>x</small> <?php echo $data['quantity'];?></td>
                   
                    <td> 
                      <?php 
                    if($data['price']=='undefined')
                     {
                    
                    echo "₹ ". number_format($lostprice,'2');
                     }
                    else
                     {
                      
                    echo "₹ ". number_format($data['price'],'2');
                     }

?></td>

<td>
                    <?php
                 echo "GST ". $gst."%";
                $withoutgstsub_total=($sub_total-$total_gst);

?>
                    </td>

<td>
                  <?php 
                  if($data['price']=='undefined')
                  {
                   $totalamount=($data['quantity']*$lostprice);  
                   echo "₹". number_format($totalamount,'2');
                  }
                  else
                  {
                    $totalamount=($data['quantity']*$data['price']);  
                    echo "₹". number_format($totalamount,'2');
                  }

</td>>
                    <td>0</td>
                 <td>
                  <?php 
                  if($data['price']=='undefined')
                  {
                   $totalamount=($data['quantity']*$lostprice);  
                   echo "₹". number_format($totalamount,'2');
                  }
                  else
                  {
                    $totalamount=($data['quantity']*$data['price']);  
                    echo "₹". number_format($totalamount,'2');
                  }

</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($withoutgstsub_total,'2');?></td>
                      </tr>
                      <tr>
                        <th>GST:</th>
                        <td>₹ <?php echo  @number_format($total_gst,'2');?></td>
                      </tr>

<tr>
                        <th>Grand Total:

<br>
           <small>All values are in INR</small></th>
                        <td> ₹ <?php
        
        $grandtotal=($withoutgstsub_total+$total_gst); 
         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;?>">
                    <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>