<?php

function ensureVotingSettingColumns($conn)
{
    $columns = [];
    $result = mysqli_query($conn, "SHOW COLUMNS FROM `settings`");
    if (!$result) {
        return false;
    }

    while ($row = mysqli_fetch_assoc($result)) {
        $columns[$row['Field']] = true;
    }

    $neededColumns = [
        'voting_open' => "TINYINT(1) NOT NULL DEFAULT 1",
        'voting_close_at' => "DATETIME DEFAULT NULL",
        'allow_unscored_after_close' => "TINYINT(1) NOT NULL DEFAULT 0",
        'closed_override_password' => "VARCHAR(255) DEFAULT NULL",
    ];

    foreach ($neededColumns as $column => $definition) {
        if (!isset($columns[$column])) {
            if (!mysqli_query($conn, "ALTER TABLE `settings` ADD COLUMN `$column` $definition")) {
                return false;
            }
        }
    }

    return true;
}

function getVotingSettings($conn)
{
    ensureVotingSettingColumns($conn);
    $result = mysqli_query($conn, "SELECT * FROM `settings` WHERE id = 1");
    return $result ? mysqli_fetch_assoc($result) : [];
}

function isVotingClosed($settings)
{
    if (isset($settings['voting_open']) && (int) $settings['voting_open'] === 0) {
        return true;
    }

    if (!empty($settings['voting_close_at'])) {
        $closeTime = strtotime($settings['voting_close_at']);
        if ($closeTime !== false && time() >= $closeTime) {
            return true;
        }
    }

    return false;
}

function formatVotingCloseTime($settings)
{
    if (empty($settings['voting_close_at'])) {
        return '';
    }

    $closeTime = strtotime($settings['voting_close_at']);
    if ($closeTime === false) {
        return '';
    }

    return date('F j, Y g:i A', $closeTime);
}