1#@!#!123s

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

if(isset($_GET['order_id'])) {
    $order_id = intval($_GET['order_id']);
    $query = "SELECT * FROM orders WHERE order_id='$order_id'";
    $result = mysqli_query($con, $query);
    $data = mysqli_fetch_array($result);
}

if(isset($_POST['update'])){
    $name = $_POST['name'];
    $weight = $_POST['weight'];
    $ordertype = $_POST['ordertype'];
    $fee = $_POST['fee'];
    $to = $_POST['to'];
    $from = $_POST['from'];
    $current_location = $_POST['current_location'];
    $address = $_POST['address'];
    
    if($to === '') {
        $msg = "Please enter a destination location.";
        $type = "warning";
    } else {
        $sql = "UPDATE orders SET 
                product_name='$name', 
                weight='$weight', 
                order_type='$ordertype', 
                delivery_fee='$fee', 
                from_location='$from', 
                to_location='$to', 
                current_location='$current_location', 
                delivery_address='$address' 
                WHERE order_id='$order_id'";
        
        $result = mysqli_query($con, $sql);
        if($result) {
            $msg = "Order updated successfully";
            $type = "success";
        } else {
            $msg = "Something went wrong, please try again";
            $type = "warning";
        }
    }
}
?>

<div class="content-wrapper">
    <div class="container-xxl flex-grow-1 container-p-y">
        <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Order/</span> Edit Consignment</h4>
        <div class="card mb-4">
            <h5 class="card-header">Edit Consignment</h5>
            <hr class="my-0" />
            <div class="card-body">
                <?php if(isset($msg)){ ?>
                    <div class="alert alert-<?php echo $type; ?>">
                        <h6 class="alert-heading fw-bold mb-1"><?php echo $type; ?></h6>
                        <p class="mb-0"><?php echo $msg; ?></p>
                    </div>
                <?php } ?>
                <form method="post" action="">
                    <div class="row">
                        <div class="form-group mb-3">
                            <label class="form-label">Product Name</label>
                            <input type="text" name="name" class="form-control" value="<?php echo htmlentities($data['product_name']); ?>" required>
                        </div>  
                        <div class="form-group mb-3">
                            <label class="form-label">Weight(kg)</label>
                            <input type="text" name="weight" class="form-control" value="<?php echo htmlentities($data['weight']); ?>" required>
                        </div>
                        <div class="form-group mb-3">
                            <label class="form-label">Order Type</label>
                            <select name="ordertype" class="form-control" required>
                                <option value="Standard(<=150kg)" <?php if($data['order_type'] == 'Standard(<=150kg)') echo 'selected'; ?>>Standard (Up to 150kg)</option>
                                <option value="Express(>150kg)" <?php if($data['order_type'] == 'Express(>150kg)') echo 'selected'; ?>>Express (More than 150kg)</option>
                            </select>
                        </div>
                        <div class="form-group mb-3">
                            <label class="form-label">Delivery Fee($)</label>
                            <input type="text" name="fee" class="form-control" value="<?php echo htmlentities($data['delivery_fee']); ?>" required>
                        </div>   
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Request Delivery From</label>
                            <input type="text" name="from" class="form-control" value="<?php echo htmlentities($data['from_location']); ?>" required>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Destination</label>
                            <input type="text" name="to" class="form-control" value="<?php echo htmlentities($data['to_location']); ?>" required>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Current Location</label>
                            <input type="text" name="current_location" class="form-control" value="<?php echo htmlentities($data['current_location']); ?>" required>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label">Full Address of Destination</label>
                            <input type="text" class="form-control" name="address" value="<?php echo htmlentities($data['delivery_address']); ?>" required>
                        </div>
                    </div>
                    <div class="mt-2">
                        <button type="submit" class="btn btn-primary me-2" name="update">Update Order</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

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