<?php
include("connection.php");

if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    header("Location: viewpackages.php");
    exit;
}

$id = intval($_GET['id']);

// Fetch data
$sql = "SELECT * FROM `package` WHERE `id` = '$id'";
$query = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($query);

if (!$row) {
    echo "Package not found.";
    exit;
}

// Decode JSON
$packages = json_decode($row['packages'], true);

if (isset($_POST['update'])) {

    // Main fields
    $title = mysqli_real_escape_string($con, $_POST['heading']);
    $price = mysqli_real_escape_string($con, $_POST['price']);
    $month = mysqli_real_escape_string($con, $_POST['month']);

    // Dynamic fields
    $headings = isset($_POST['heading_arr']) ? $_POST['heading_arr'] : [];
    $paras    = isset($_POST['para']) ? $_POST['para'] : [];

    $new_packages = [];

    for ($i = 0; $i < count($headings); $i++) {
        if (!empty($headings[$i]) && !empty($paras[$i])) {
            $new_packages[] = [
                'heading' => mysqli_real_escape_string($con, $headings[$i]),
                'para'    => mysqli_real_escape_string($con, $paras[$i])
            ];
        }
    }

    $packages_json = json_encode($new_packages, JSON_UNESCAPED_UNICODE);

    // Update query
    $sql1 = "UPDATE `package` SET 
                `heading` = '$title',
                `price` = '$price',
                `month` = '$month',
                `packages` = '$packages_json'
            WHERE `id` = '$id'";

    $query1 = mysqli_query($con, $sql1);

    if ($query1) {
        header("Location: viewpackages.php");
        exit();
    } else {
        echo "Update failed: " . mysqli_error($con);
    }
}
?>


<?php
include("header.php")
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8" />
    <title>packagesUpdate</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
    <meta content="Themesbrand" name="author" />
    <!-- App favicon -->
    <!-- <link rel="shortcut icon" href="assets/images/favicon.ico" /> -->

    <!-- Plugins css -->
    <link href="assets/libs/dropzone/dropzone.css" rel="stylesheet" type="text/css" />
    <link rel="stylesheet" type="text/css" href="https://use.fontawesome.com/releases/v5.8.1/css/all.css">
    <link rel="shortcut icon" href="./assets/logo/fav.png" />

    <!-- Bootstrap Css -->
    <link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />
    <!-- Icons Css -->
    <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
    <!-- App Css-->
    <link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />
    <!-- App js -->
    <!-- <script src="assets/js/plugin.js"></script> -->
    <style>
        .form .input {
            width: 100%;
            background: white;
            border: none;
            padding: 15px 20px;
            border-radius: 20px;
            margin-bottom: 9px;
            margin-top: 15px;
            box-shadow: rgba(0, 0, 0, 0.24) 0px 3px 8px;
            border-inline: 2px solid transparent;
        }

        input[name='Image'] {
            display: none;

        }

        div#upload {
            cursor: pointer;

        }

        ::-webkit-file-upload-button {
            display: none;
        }

        /* 
        .form .input::-moz-placeholder {
            color: rgb(170, 170, 170);
        }

        .form .input::placeholder {
            color: rgb(170, 170, 170);
        }

        .form .input:focus {
            outline: none;
            border-inline: 2px solid #12b1d1;
        } */

        .filepath {
            display: none;
        }

        img[alt="img"] {
            width: clamp(50px, 15%, 100px);
            aspect-ratio: 1/0.70;
        }
    </style>
</head>

<body data-sidebar="dark">
    <!-- <body data-layout="horizontal" data-topbar="dark"> -->

    <!-- Begin page -->
    <div id="layout-wrapper">

        <div class="w-80 ">
            <div class="page-content" style="width: 80%;margin-left: 260px;">
                <div class="container">
                    <!-- start page title -->
                    <div class="row">
                        <div class="col-12">
                            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                                <h4 class="mb-sm-0 font-size-18">packagesUpdate</h4>


                            </div>
                        </div>
                    </div>
                    <!-- end page title -->

                    <div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">

                                    <div>
                                        <form method="POST">

                                            <div class="row mb-3">
                                                <div class="col-lg-4">
                                                    <label>Heading</label>
                                                    <input type="text" class="form-control" name="heading"
                                                        value="<?= htmlspecialchars($row['heading']); ?>" required>
                                                </div>

                                                <div class="col-lg-4">
                                                    <label>Price</label>
                                                    <input type="text" class="form-control" name="price"
                                                        value="<?= htmlspecialchars($row['price']); ?>" required>
                                                </div>

                                                <div class="col-lg-4">
                                                    <label>Per Month</label>
                                                    <input type="text" class="form-control" name="month"
                                                        value="<?= htmlspecialchars($row['month']); ?>" required>
                                                </div>
                                            </div>

                                            <h4>Packages</h4>

                                            <div id="serviceWrapper">

                                                <button type="button" class="btn btn-primary mb-3" onclick="addOption()">+ Add Service</button>

                                                <?php
                                                if (!empty($packages)) {
                                                    foreach ($packages as $entry) {

                                                        $heading_val = $entry['heading'] ?? '';
                                                        $para_val = $entry['para'] ?? '';
                                                ?>

                                                        <div class="row mb-3 service-row">

                                                            <div class="col-md-5">
                                                                <input type="text" class="form-control"
                                                                    name="heading_arr[]"
                                                                    value="<?= htmlspecialchars($heading_val) ?>"
                                                                    placeholder="Enter heading">
                                                            </div>

                                                            <div class="col-md-5">
                                                                <input type="text" class="form-control"
                                                                    name="para[]"
                                                                    value="<?= htmlspecialchars($para_val) ?>"
                                                                    placeholder="Enter para">
                                                            </div>

                                                            <div class="col-md-2">
                                                                <button type="button" class="btn btn-danger w-100"
                                                                    onclick="this.closest('.service-row').remove()">
                                                                    Remove
                                                                </button>
                                                            </div>

                                                        </div>

                                                <?php
                                                    }
                                                }
                                                ?>

                                            </div>

                                            <div class="text-center mt-4">
                                                <button type="submit" name="update" class="btn btn-success">Update</button>
                                                <a href="viewpackages.php" class="btn btn-secondary">Cancel</a>
                                            </div>

                                        </form>

                                    </div>

                                </div>
                            </div>
                        </div>
                        <!-- end col -->
                    </div>
                    <!-- end row -->
                </div>
                <!-- container-fluid -->
            </div>
            <!-- End Page-content -->


        </div>
        <!-- end main content-->
    </div>
    <!-- END layout-wrapper -->




    <!-- JAVASCRIPT -->
    <script src="assets/libs/jquery/jquery.min.js"></script>
    <script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
    <script src="assets/libs/metismenu/metisMenu.min.js"></script>
    <script src="assets/libs/simplebar/simplebar.min.js"></script>
    <script src="assets/libs/node-waves/waves.min.js"></script>

    <!-- Plugins js -->
    <script src="assets/libs/dropzone/dropzone-min.js"></script>

    <!-- Form file upload init js -->
    <script src="assets/js/pages/form-file-upload.init.js"></script>

    <script src="assets/js/app.js"></script>
    <script src="./ck editor/ckeditor.js"></script>
   <script>
function addOption() {
    const wrapper = document.getElementById('serviceWrapper');

    const newRow = document.createElement('div');
    newRow.classList.add('row', 'mb-3', 'service-row');

    newRow.innerHTML = `
        <div class="col-md-5">
            <input type="text" name="heading_arr[]" class="form-control" placeholder="Enter heading">
        </div>

        <div class="col-md-5">
            <input type="text" name="para[]" class="form-control" placeholder="Enter para">
        </div>

        <div class="col-md-2">
            <button type="button" class="btn btn-danger w-100"
                onclick="this.closest('.service-row').remove()">
                Remove
            </button>
        </div>
    `;

    wrapper.appendChild(newRow);
}
</script>
</body>

</html>