1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jefflc.online /
Filename : tracking-result.php
back
<?php
session_start();
if(!isset($_POST['trackingId'])){
    header("Location:tracking.php");
 }
error_reporting(0);
include('../config/tr_config.php');
include 'includes/header.php';   

if(!isset($_POST['trackingId'])){
    header("Location:tracking.php");
 }
 
// Set the timezone to Africa/Lagos
date_default_timezone_set('Africa/Lagos');

$tid=$_POST['trackingId'];
?>
<section class="inner-banner py-5">
    <style>
        .inner-banner {
            background-image:url(assets/images/inner-banner.jpg);
        }
    </style>
    <div class="w3l-breadcrumb py-lg-5">
        <div class="container pt-5 pb-sm-4 pb-2 AboutPageBanner">

                                    
                <h4 class="inner-text-title font-weight-bold pt-5">Tracking Result</h4>
            
                <ul class="breadcrumbs-custom-path ">
                <a href="index.php" rel="nofollow">Home</a>&nbsp;&nbsp;&#187;&nbsp;&nbsp;Tracking Result     
               </ul>
                        
        </div>
    </div>
</section>
<!-- //inner banner -->


<!-- AboutPage about section -->

<section>
    </section>
<?php 

$menu_query="SELECT * FROM orders WHERE tracking_id='$tid' "  ;
$result=mysqli_query($con,$menu_query);

if(mysqli_num_rows($result)>0){
  while($row=mysqli_fetch_assoc($result)){

    $order_id=$row['order_id'];
    $user_id=$row['user_id'];
    $tracking_id=$row['tracking_id'];
    $from_location=$row['from_location'];
    $to_location=$row['to_location'];
    $current_location=$row['current_location'];
    $status=$row['status'];
    $delivery_address=$row['delivery_address'];
    $creation_date=$row['creationDate'];
    $updation_date=$row['updationDate'];

?>

<section class="w3l-bottom-grids-6 py-5">
    <div class="container pt-lg-5 pt-md-4 pt-2 HomePageServices">
      <div class="container">
<a href="tracking.php">
<h6 class="track-another">TRACK ANOTHER SHIPMENT</h6> </a>
<h2 class="tracking-id"><?php echo $tracking_id;?> </h2>

<p class="tracking-status"><?php echo $status;?></p>
<?php 
                                   // date_from must be from 3rd day (from order date)
                                   // date_to must be the next 5th days
                                    $placed_date = date('jS F, Y \a\t g:ia', strtotime($creation_date));
                                    $updated_date = date('jS F, Y \a\t g:ia', strtotime($updation_date));
                                   
                                   ?>
<p class="updation-date"><?php echo $placed_date;?></p>

<h5 style="text-align:center;text-transform:uppercase;margin-top:10px;color:#00243d;">
Currently at: <?php echo $current_location;?></h5>
            <div class="location-container">

   <div class="location-left">
       <h5>FROM</h5>
       <p><?php echo $from_location;?> </p>
  </div>

  <div class="location-right">
       <h5>TO</h5>
       <p><?php echo $to_location;?> </p>
  </div>
           </div>

      <div class="track-order">
        <div class="col-md-12 col-12 order-header p-2" style="background:#0e0e0e;">
          <div class="row">
            <div class="col-md-4 col-12">
             Order ID: <span><?php echo $tracking_id;?></span>
            </div>
            <div class="col-md-3 col-12">Order Placed on  <?php echo $placed_date;?></div>
          </div>
          <!-- <p><a href="#">See order detail</a></p> -->
        </div>
        <div class="col-md-12 col-12 order-body">
          <div class="sim-card">
          <?php 
                                        if($status !=="Delivered"){
                                            ?>
        <div class="order-track">
          <h4 style="margin-bottom:5px;">Out for Delivery</h4>
           <?php 

$progress_query="SELECT * FROM `progress` WHERE order_id='$order_id' AND `status`='Out for Delivery' "  ;
$result1=mysqli_query($con,$progress_query);

if(mysqli_num_rows($result1)>0){
  while($row1=mysqli_fetch_assoc($result1)){
   
    $date=$row1['date'];
    $formatted_date = date('jS F, Y \a\t g:ia', strtotime($date));

?>
    <div class="order-track-step">
      <div class="order-track-status">
        <span class="order-track-status-dot <?php echo $row1['type'];?>"></span>
        <span class="order-track-status-line <?php echo $row1['type'];?>"></span>
      </div>
      <div class="order-track-text">
        <p class="order-track-text-stat"><?php echo $row1['title'];?></p>
        <span class="order-track-text-sub"><?php echo $row1['message'];?></span>
        <br>
        <span class="order-track-text-sub" style="font-size:15px;"><?php echo $formatted_date;?></span>

      </div>
    </div>

<?php 
  }}
?>
             
          
</div>
                                        <?php
                                         }
                                        ?> 
          <?php 
                                        if($status=="Delivered"){
                                            ?>

            <div class="order-track">
            <div class="title-row">
   <img src="assets/images/success-green-check-mark-icon.webp" style="width:25px;">
   <h4>Delivered</h4>

    </div>
           <?php 

$progress_query="SELECT * FROM `progress` WHERE order_id='$order_id' AND `status`='Out for Delivery'  ORDER BY `id` DESC  LIMIT 1 "  ;
$result1=mysqli_query($con,$progress_query);

if(mysqli_num_rows($result1)>0){
  while($row1=mysqli_fetch_assoc($result1)){
    $date = $row1['date'];
    $formatted_date = date('jS F, Y \a\t g:ia', strtotime($date));
    
?>
    <div class="order-track-step">
      <div class="order-track-status">
      </div>
      <div class="order-track-text">
        <p class="order-track-text-stat"><?php echo $row1['title'];?></p>
        <span class="order-track-text-sub"><?php echo $row1['message'];?></span>
        <br>
        <span class="order-track-text-sub" style="font-size:15px;"><?php echo $formatted_date;?></span>
      </div>
    </div>

    <a href="tracking-history.php?trackingId=<?php echo $tracking_id?>" 
    style="margin-top:-30px;font-weight:bold;color:#f7951e;font-size:16px;margin-left:20px;">
    See All Tracking History </a>
<?php 
  }}
?>
                                        <?php
                                         }
                                        ?> 
          
        
      

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

<?php }

  }else{?>

                                    <div style="height:300px;padding-top:50px;display:flex;flex-direction:column;
                                    align-items;center;justify-content:center;"> 
                                   <div>
                                   <h5 style="font-size:15px;text-align:center;line-height:25px;">  
                                    <span style="color:#ff0000;font-size:16px;"> INVALID TRACKING ID</span>
                                    <br>
                                    Please ensure you entered the correct tracking ID and try again
                                    <br><br>
                                    <a class="btn btn-common" href="tracking.php">
                                        <i class="fas fa-shipping-fast"></i> Track</a>
                                    </h5>
                                  
                                  
                                    </div>

                                    </div>

<?php 

  }?>
<?php
include 'includes/footer.php';   
?>