<?php

namespace Payplug\PayplugWoocommerce\Model;

class Lock
{
    /**
     * create Lock table
     */
    public static function create_lock_table(): void
    {
        global $wpdb;

        $sql = 'CREATE TABLE  IF NOT EXISTS `' . $wpdb->base_prefix . 'woocommerce_payplug_lock` (';
        $sql .= ' `payment_id` VARCHAR(50) NOT NULL,';
        $sql .= ' `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,';
        $sql .= ' PRIMARY KEY (`payment_id`));';

        $table_name = $wpdb->base_prefix . 'woocommerce_payplug_lock';
        require_once ABSPATH . 'wp-admin/includes/upgrade.php';
        maybe_create_table($table_name, $sql);

        $result = $wpdb->get_row(
            $wpdb->prepare(
                "SELECT count(column_name) as column_exists FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '{$wpdb->base_prefix}woocommerce_payplug_lock' AND column_name = %s ",
                ['id']
            )
        );

        if (!empty($result) && !$result->column_exists) {
            static::update_lock_table();
        }
    }

    /**
     * update table
     */
    public static function update_lock_table(): void
    {
        global $wpdb;

        $sql = "ALTER TABLE `{$wpdb->base_prefix}woocommerce_payplug_lock` ";
        $sql .= ' ADD COLUMN `id` INT NOT NULL AUTO_INCREMENT FIRST,';
        $sql .= ' DROP PRIMARY KEY,';
        $sql .= ' ADD PRIMARY KEY (`id`);';
        $wpdb->query($sql);
    }

    /**
     * @param $payment_id
     *
     * @return bool|int
     */
    public static function insert_lock($payment_id)
    {
        global $wpdb;
        $wpdb->hide_errors();
        $lock_table_exists = self::check_table_exists();
        if (!$lock_table_exists) {
            self::create_lock_table();
        }
        $wpdb->insert($wpdb->base_prefix . 'woocommerce_payplug_lock', ['payment_id' => $payment_id]);

        return $wpdb->insert_id;
    }

    /**
     * @param $id
     *
     * @return bool
     */
    public static function delete_lock($id)
    {
        global $wpdb;
        $table_name = $wpdb->base_prefix . 'woocommerce_payplug_lock';
        $wpdb->query($wpdb->prepare("DELETE FROM {$table_name} WHERE id = %s OR created < NOW() - INTERVAL 1 DAY;", [$id]));

        return true;
    }

    /**
     * @param $payment_id
     *
     * @return bool
     */
    public static function delete_lock_by_payment_id($payment_id)
    {
        global $wpdb;
        $table_name = $wpdb->base_prefix . 'woocommerce_payplug_lock';
        $wpdb->query($wpdb->prepare("DELETE FROM {$table_name} WHERE payment_id = %s OR created < NOW() - INTERVAL 1 DAY;", [$payment_id]));

        return true;
    }

    /**
     * @param $payment_id
     * @param $id
     *
     * @return bool
     */
    public static function locked($payment_id, $id)
    {
        global $wpdb;

        $table_name = $wpdb->base_prefix . 'woocommerce_payplug_lock';

        // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
        $result = $wpdb->get_row($wpdb->prepare("SELECT id FROM {$table_name} WHERE `payment_id` = %s AND `id` <> %s ", [$payment_id, $id]));

        if (empty($result)) {
            return false;
        }

        return true;
    }

    /**
     * @param $id
     *
     * @return bool|int
     */
    public static function get_lock_by_payment_id($payment_id)
    {
        global $wpdb;

        $table_name = $wpdb->base_prefix . 'woocommerce_payplug_lock';

        // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
        $result = $wpdb->get_row($wpdb->prepare("SELECT id FROM {$table_name} WHERE payment_id = %s", [$payment_id]));
        if (!$result) {
            return false;
        }

        return $result;
    }

    public static function delete_lock_table(): void
    {
        global $wpdb;

        $table_name = $wpdb->base_prefix . 'woocommerce_payplug_lock';
        $sql = "DROP TABLE IF EXISTS $table_name;";
        $wpdb->query($sql);
    }

    public static function check_table_exists()
    {
        global $wpdb;
        $table_name = $wpdb->base_prefix . 'woocommerce_payplug_lock';
        $table_exists = $wpdb->get_var($wpdb->prepare(
            'SHOW TABLES LIKE %s',
            $table_name
        ));

        return $table_exists === $table_name;
    }
}