<?php
ini_set('display_errors', 0);
include('includes/header.php');

?>
<style>
    .custom-button {
        padding: 10px 20px;
    }

    #url-form {
        display: none;
    }

    .custom-input {
        color: blue;
    }

</style>


<div class="col-md-6 mx-auto">
    <div class="modal fade" id="how2" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">

                </div>
                <div class="modal-body">
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                    <a href="https://www.tvsportguide.com/page/widget/"><button type="button" class="btn btn-primary">Go to webpage</button></a>
                </div>
            </div>
        </div>
    </div>
    <div class="card-body">
        <div class="card ctcard">
            <div class="card-header">
                <center>
                    <h2><i class="fa fa-file-image-o"></i> Advert's Settings</h2>
                </center>
            </div>
            <div class="card-body">

                <?php
                $db = new SQLite3('./api/.db_ads.db');

                if (!$db) {
                    die("Database connection error.");
                }

                $query = "CREATE TABLE IF NOT EXISTS adsstatus (id INTEGER PRIMARY KEY, adstype TEXT)";
                if ($db->exec($query)) {
                } else {
                    echo "Error creating table: " . $db->lastErrorMsg() . "<br>";
                }

                $query = "SELECT COUNT(*) FROM adsstatus";
                $result = $db->querySingle($query);


                if ($_SERVER["REQUEST_METHOD"] == "POST") {
                    $ad_item = $_POST["ad_item"];

                    if (empty($ad_item)) {
                        die("Please select an ad item.");
                    }

                    if ($result === 0) {
                        $updateQuery = "INSERT INTO adsstatus (adstype) VALUES (:ad_item)";
                    } else {
                        $updateQuery = "UPDATE adsstatus SET adstype = :ad_item WHERE id = 1";
                    }

                    $stmt = $db->prepare($updateQuery);
                    $stmt->bindValue(':ad_item', $ad_item, SQLITE3_TEXT);

                    if ($stmt->execute()) {
                        echo "Ad item '$ad_item' has been successfully updated.<br>";

                        // Move o arquivo allads.php conforme a seleção
                        if ($ad_item === "Manualads") {
                            $source = "./Manualads/allads.php";
                            $destination = "./api/allads.php";
                            if (file_exists($source)) {
                                copy($source, $destination);
                            } else {
                                echo "Error: File 'allads.php' not found in 'Manualads' folder.<br>";
                            }
                        } elseif ($ad_item === "Autoads") {
                            $source = "./Autoads/allads.php";
                            $destination = "./api/allads.php";
                            if (file_exists($source)) {
                                copy($source, $destination);
                            } else {
                                echo "Error: File 'allads.php' not found in 'Autoads' folder.<br>";
                            }
                        }
                    } else {
                        echo "Error updating record: " . $db->lastErrorMsg();
                    }
                }
                ?>

                <form method="POST" action="">
                    <div class="ctinput">
                        <label for="ad_item">Select an Ad Item:</label>
                        <select name="ad_item" id="ad_item">
                            <option value="Autoads">Auto ads</option>
                            <option value="Manualads">Manual ads</option>
                        </select>
                    </div>

                    <input type="submit" name="submit" value="Update" class="ctbtn ctuserbtn">
                </form>

                <?php
                $db->close();
                ?>

            </div>
        </div>
    </div>
</div>

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

</body>

</html>
