<?php
/**
 * modules/locations/add_locations.php
 */

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $location_code = strtoupper($db->escape($_POST['location_code']));
    $location_name = $db->escape($_POST['location_name']);
    $status        = $db->escape($_POST['status']);
    $created_by    = (int)$_SESSION['user_id'];

    // Check for duplicate code
    $check_sql = "SELECT LOCATION_ID FROM TBL_LOCATIONS WHERE LOCATION_CODE = '$location_code'";
    if (mysqli_num_rows($db->query($check_sql)) > 0) {
        header("Location: index.php?s=" . encrypt_url('mod=locations&page=add_locations') . "&status=duplicate");
        exit;
    }

    $sql = "INSERT INTO TBL_LOCATIONS (LOCATION_CODE, LOCATION_NAME, STATUS, CREATED_BY) 
            VALUES ('$location_code', '$location_name', '$status', $created_by)";
    
    if ($db->query($sql)) {
        header("Location: index.php?s=" . encrypt_url('mod=locations&page=list_locations') . "&status=added");
        exit;
    }
}
?>

<section class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1 class="font-weight-bold text-primary"><i class="fas fa-plus-circle mr-2"></i>Add New Location</h1>
            </div>
            <div class="col-sm-6 text-right">
                <a href="index.php?s=<?php echo encrypt_url('mod=locations&page=list_locations'); ?>" class="btn btn-default shadow-sm">
                    <i class="fas fa-arrow-left mr-1"></i> Back to List
                </a>
            </div>
        </div>
    </div>
</section>

<section class="content">
    <div class="container-fluid">
        <form action="" method="POST">
            <div class="card card-outline card-primary shadow-sm">
                <div class="card-header bg-white">
                    <h3 class="card-title font-weight-bold text-primary">Location Details</h3>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-3 form-group">
                            <label class="text-secondary">Location Code <span class="text-danger">*</span></label>
                            <input type="text" name="location_code" class="form-control" placeholder="e.g. LAK" required style="text-transform: uppercase;">
                            <small class="text-muted">Short 3-4 letter code.</small>
                        </div>
                        <div class="col-md-5 form-group">
                            <label class="text-secondary">Location Name <span class="text-danger">*</span></label>
                            <input type="text" name="location_name" class="form-control" placeholder="e.g. Lakhra Coal Mine" required>
                        </div>
                        <div class="col-md-4 form-group">
                            <label class="text-secondary">Status</label>
                            <select name="status" class="form-control">
                                <option value="ACTIVE">ACTIVE</option>
                                <option value="INACTIVE">INACTIVE</option>
                            </select>
                        </div>
                    </div>
                </div>
                <div class="card-footer bg-white text-right">
                    <button type="submit" class="btn btn-primary px-5 font-weight-bold shadow-sm">
                        <i class="fas fa-save mr-2"></i> SAVE LOCATION
                    </button>
                </div>
            </div>
        </form>
    </div>
</section>