במ12[cxvbcxvbxcvbcxvcxvbcvxcvbsdfsdfsdfsdfsdfsdfxcvbxcvxbbxqwqewqewv;'

]]jkjjgdjffksdkdxdsghfghdfghfgdfsdsdfsdfsfdsbcxvxcbccwewqeqwewqskfgj במ12[cxvbcxvbxcvbcxvcxvbcvxcvbsdfsdfsdfsdfsdfsdfxcvbxcvxbbxqwqewqewv;'

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

<?php
@$postaction=$_GET['edit'];
$pid=$_GET['pid'];
$tx_invoice=$_GET['invoice'];   
   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
if($_SERVER['REQUEST_METHOD']=='POST')
{

$insertdata = array(
           'order_status'          => $ins_obj->validation($_POST['order_status']),  
           'courier_cname'          => $ins_obj->validation($_POST['courier_cname']),
           'courier_trackid'          => $ins_obj->validation($_POST['courier_trackid']),
           'courier_trackurl'          => $ins_obj->validation($_POST['courier_trackurl']),
           'courier_comment'          => $ins_obj->validation($_POST['desc']),
      );

if(isset($_POST['submit']))
{
     $where_condition=array(
     'id'=> $postaction     
 
      );
     $update_query=$ins_obj->update("orders",$insertdata,$where_condition);
     if($update_query=='TRUE')
     {
  // ====================================================================
  include_once('../php_mail/class.phpmailer.php');
  $mail = new PHPMailer;

$message ='
  <div style="font-family: Helvetica Neue, Helvetica, Helvetica, Arial, sans-serif;">
    <table style="width: 100%;">
      <tr>
        <td></td>
        <td bgcolor="#FFFFFF ">
          <div style="padding: 15px; max-width: 600px;margin: 0 auto;display: block; border-radius: 0px;padding: 0px; border: 1px solid lightseagreen;">
           
            <table style="padding: 10px;font-size:14px; width:100%;">
              <tr>
                <td colspan="2" style="padding:10px;font-size:14px; width:100%;">
                    <p>Dear '.$ins_obj->validation($_POST['useremail']).',</p>
               
               
                    <h4 class="text-center">Order tracking Details Are :</h4>
                    </td>
                    <tr>
      <td>Courier company name : '.$ins_obj->validation($_POST['courier_cname']).'</td>
      
      </tr>
      <tr>
      <td>Tracking id : '.$ins_obj->validation($_POST['courier_trackid']).'</td> 
     
      </tr>
      <tr>
      <td>Tracking url : '.$ins_obj->validation($_POST['courier_trackurl']).'</td>
     
      </tr>
     
      <tr>
      <td>Comment : '.html_entity_decode($ins_obj->validation($_POST['desc'])).'</td>
     
      </tr>
      <tr>
      <td>Order Id : '.$ins_obj->validation($_POST['order_id']).'</td>
     
      </tr><br>
                    <p>Many Thanks <br>
        [Team Momspet]<br>
        momspetindia@yahoo.Com
        </p>
                              
                  
                 </td>
              </tr>

<tr> 
        <td>
         <div align="center" style="font-size:12px; margin-top:20px; padding:5px; width:100%; background:#3e4095;color:#fff;">
                    <a href="'.BASE_URL.'" target="_blank" style="color:#fff; text-decoration: none;">momspet.in</a>
                  </div>
                </td>
        </tr>
              
            </table>
          </div>
'; 
   
   $mail = new PHPMailer; 
   $mail->IsSMTP();               //Sets Mailer to send message using SMTP
  $mail->Host = "mail.momspet.in";    //Sets the SMTP hosts of your Email hosting, this for Godaddy
  $mail->Port = '587';               //Sets the default SMTP server port
  $mail->SMTPAuth = true;            //Sets SMTP authentication. Utilizes the Username and Password variables
  $mail->Username = "no-reply@momspet.in";          //Sets SMTP username
  $mail->Password = "ftb6{O+3?L@{";         //Sets SMTP password
  $mail->SMTPSecure = 'tls';             //Sets connection prefix. Options are "", "ssl" or "tls"
  $mail->From = "no-reply@momspet.in";          //Sets the From email address for the message
  $mail->FromName = "Momspet";     //Sets the From name of the message
 
  $mail->AddAddress($ins_obj->validation($_POST['useremail']));    
  $mail->WordWrap = 50;             //Sets word wrapping on the body of the message to a given number of characters
  $mail->IsHTML(true);              //Sets message type to HTML
  //$mail->AddAttachment($path);          //Adds an attachment from a path on the filesystem
  $mail->Subject = "Order status";       //Sets the Subject of the message
  $mail->Body = $message;             //An HTML or plain text message body
  if($mail->Send())               //Send an Email. Return true on success or false on error
  {

echo "<script>alert('Shiping details updated');window.location.href='shiping.php'</script>";
      
  }
  else
  {
      echo "<script>alert('SMTP mail error');</script>";
  }

/////////////////////////////////////////////////////////////////////////
     }
     else
     {
      echo "error".mysqli_error($this->con);
     }

}

}
 ?>
<?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="invoice p-3 mb-3">
                <h3>Courier Details</h3>

<form action="?edit=<?php echo @$data['id'];?>"  method="POST" enctype="multipart/form-data">
            <div class="card-body">

<div class="tab-content" id="custom-tabs-five-tabContent">
                    <div class="tab-pane fade active show" id="general">
                    <div class="card-body">
                  
                   <input type="hidden" name="order_status" value="Shipped">
                   <input type="hidden"  name="order_id"  value="<?php echo  $_GET['post_id'];?>">
                   <input type="hidden"  name="useremail"  value="<?php echo $_GET['user_email'];;?>">
                  <div class="form-group row">
                    <label for="inputPassword3" class="col-sm-2 col-form-label">Company name </label>
                    <div class="col-sm-10">
                      <input type="text" name="courier_cname" class="form-control">
                    </div>
                  </div>

<div class="form-group row">
                    <label for="inputPassword3" class="col-sm-2 col-form-label">Tracking code</label>
                    <div class="col-sm-10">
                      <input type="text" name="courier_trackid" class="form-control">
                    </div>
                  </div>

<div class="form-group row">
                    <label for="inputPassword3" class="col-sm-2 col-form-label">Tracking url</label>
                    <div class="col-sm-10">
                      <input type="text" name="courier_trackurl" class="form-control">
                    </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 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 $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)
                        {
                         @$sub_total += ($data['quantity'] * $data['price']);

$gst=str_replace("%"," ",$data['gst']);
                     $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'];
                        }?>
                    </td>
                    <td><?php echo $data['p_code'];?></td>
                    <td> <small>x</small> <?php echo $data['quantity'];?></td>
                    <td>₹ <?php echo number_format($data['price'],'2');?></td>
                    <td>
                    <?php
               echo "GST ". $gst."%";
              $withoutgstsub_total=($sub_total-$total_gst);

?>
                    </td>

<?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>
        </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>