File "add_piso_wifi_client.php"

Full Path: /home/leadltht/fastlinkinternet.com/administrator/data-provider/admin/add_piso_wifi_client.php
File size: 6.02 KB
MIME-type: text/x-php
Charset: utf-8

<?php
session_start();
include 'header.php'; // Include the header file which includes the navigation

// Database connection
$conn = new mysqli("server329", "leadltht_prazey1982", "prazey1982123456", "leadltht_fastlinkinternet");

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $name = $_POST['name'];
    $area = $_POST['area']; // Use 'area' instead of 'area_id'
    $cutoff_day = $_POST['cutoff_day'];
    $installation_date = $_POST['installation_date'];
    $last_harvested_date = $_POST['last_harvested_date'];
    $client_share = $_POST['client_share']; // New field for Client % Share

    if (empty($last_harvested_date)) {
        $last_harvested_date = NULL;
    }

    // Prepare the insert query with the new client_share field
    $query = "INSERT INTO clients (name, area, cutoff_day, installation_date, last_harvested_date, client_share) VALUES (?, ?, ?, ?, ?, ?)";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("ssissi", $name, $area, $cutoff_day, $installation_date, $last_harvested_date, $client_share);

    if ($stmt->execute()) {
        $message = "Client added successfully.";
    } else {
        $message = "Error: " . $stmt->error;
    }

    $stmt->close();
}

$areas_query = "SELECT id, area_name FROM piso_wifi_areas";
$areas_result = $conn->query($areas_query);
?>

<div class="content-wrapper">
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-12 text-center">
                    <h1 class="m-5">Add New Piso WiFi Client</h1>
                </div>
            </div>
        </div>
    </div>
    <section class="content">
        <div class="container-fluid">
            <?php if (isset($message)) echo "<div class='alert alert-info'>$message</div>"; ?>
            <div class="row justify-content-center">
                <div class="col-md-4">
                    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post" class="needs-validation" novalidate>
                        <div class="form-group">
                            <label for="name">Client Name:</label>
                            <input type="text" id="name" name="name" class="form-control" required>
                            <div class="invalid-feedback">Please provide a client name.</div>
                        </div>

                        <div class="form-group">
                            <label for="area">Area:</label>
                            <select id="area" name="area" class="form-control" required>
                                <?php while ($row = $areas_result->fetch_assoc()) { ?>
                                    <option value="<?php echo $row['area_name']; ?>"><?php echo $row['area_name']; ?></option>
                                <?php } ?>
                            </select>
                            <div class="invalid-feedback">Please select an area.</div>
                        </div>

                        <div class="form-group">
                            <label for="cutoff_day">Harvest Day (1-31):</label>
                            <input type="number" id="cutoff_day" name="cutoff_day" class="form-control" min="1" max="31" required>
                            <div class="invalid-feedback">Please provide a cutoff day between 1 and 31.</div>
                        </div>

                        <div class="form-group">
                            <label for="installation_date">Installation Date:</label>
                            <input type="date" id="installation_date" name="installation_date" class="form-control" required>
                            <div class="invalid-feedback">Please provide an installation date.</div>
                        </div>

                        <div class="form-group">
                            <label for="client_share">Client % Share:</label>
                            <select id="client_share" name="client_share" class="form-control" required>
                                <?php for ($i = 0; $i <= 50; $i += 5) { ?>
                                    <option value="<?php echo $i; ?>"><?php echo $i; ?>%</option>
                                <?php } ?>
                            </select>
                            <div class="invalid-feedback">Please select a client share percentage.</div>
                        </div>
                        <button type="submit" class="btn btn-primary">Add Client</button>
                        <a href="https://fastlinkinternet.com/administrator/data-provider/admin/?page=piso_wifi_client_lists" class="btn btn-secondary ml-2">Back to Piso WiFi Client Lists</a>
                    </form>
                </div>
            </div>
        </div>
    </section>
</div>

<?php
$areas_result->free();
$conn->close();
include 'footer.php'; // Include the footer file
?>

<!-- Add Bootstrap and validation scripts -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
<script>
    (function() {
        'use strict';
        window.addEventListener('load', function() {
            var forms = document.getElementsByClassName('needs-validation');
            var validation = Array.prototype.filter.call(forms, function(form) {
                form.addEventListener('submit', function(event) {
                    if (form.checkValidity() === false) {
                        event.preventDefault();
                        event.stopPropagation();
                    }
                    form.classList.add('was-validated');
                }, false);
            });
        }, false);
    })();
</script>