1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jefflc.online / admin /
Filename : consignments.php
back
<?php
session_start();
error_reporting(0);
include('../../config/tr_config.php');
include('includes/checklogin.php');
check_login();
$title="Dashboard";
include 'includes/header.php'; 
include 'includes/sidebar.php';

ini_set('display_errors', 1);
error_reporting(E_ALL);

if(isset($_GET['del']))
{
    mysqli_query($con,"delete from `orders` where order_id = '".$_GET['id']."'");
    $_SESSION['msg']="Consignment Deleted !!";
}
?>

<div class="container-fluid py-4">
    <div class="card" style="padding:30px;">
        <h5 class="card-header">Consignments</h5>
        <div class="table-responsive table-wrapper-top text-nowrap">
            <table class="table table-bordered" id="dataTables-example">
                <?php
                $query="SELECT * FROM `orders` ";
                $result=mysqli_query($con,$query);
                $cnt=+1;
                if(mysqli_num_rows($result)>0){
                ?>
                <thead>
                    <tr>
                        <th class="">SN</th>
                        <th class="">Tracking ID</th>
                        <th class="">From</th>
                        <th class="">To</th>
                        <th class="">Current Location</th>
                        <th class="">Status</th>
                        <th class="text-secondary opacity-7"></th>
                    </tr>
                </thead>
                <tbody>
                <?php 
                while($row=mysqli_fetch_array($result))
                {
                ?>
                    <tr>
                        <td><?php echo $cnt++;?></td>
                        <td>
                            <p class="text-xs font-weight-bold mb-0"><?php echo htmlentities($row['tracking_id']);?></p>
                        </td>
                        <td>
                            <p class="text-xs font-weight-bold mb-0"><?php echo htmlentities($row['from_location']);?></p>       
                        </td>
                        <td>
                            <p class="text-xs font-weight-bold mb-0"><?php echo htmlentities($row['to_location']);?></p>
                        </td>
                        <td>
                            <p class="text-xs font-weight-bold mb-0"><?php echo htmlentities($row['current_location']);?></p>
                        </td>
                        <td>
                            <p class="text-xs font-weight-bold mb-0" style="text-align:center;">
                                <?php echo htmlentities($row['status']);?>
                            </p>
                        </td>
                        <td class="align-middle">
                            <a href="edit-consignment.php?order_id=<?php echo $row['order_id'];?>" class="btn btn-sm btn-info" data-toggle="tooltip" data-original-title="Edit Order">
                                Edit
                            </a>
                            <a href="update-details.php?id=<?php echo $row['order_id'];?>" class="btn btn-sm btn-warning" data-toggle="tooltip" data-original-title="Update Status">
                                Update Details
                            </a>
                            <a href="history.php?id=<?php echo $row['order_id'];?>" class="btn btn-sm btn-primary" data-toggle="tooltip" data-original-title="Update Status">
                                History
                            </a>
                            <a href="update-status.php?id=<?php echo $row['order_id'];?>" class="btn btn-sm btn-secondary" data-toggle="tooltip" data-original-title="Update Status">
                                Update Status
                            </a>
                            <a href="consignments.php?id=<?php echo $row['order_id'];?>&del=delete" 
                               onClick="return confirm('Are you sure you want to delete?')" class="btn btn-sm btn-danger">
                                Delete
                            </a>
                        </td>
                    </tr>
                <?php } 
                }else{
                    echo" <div class='empty-data'> No Consignment yet </div> ";
                }
                ?>  
                </tbody>
            </table>
        </div>
    </div>
</div>

<?php include('includes/footer.php');?>