<?php
/**
 * @package Restrict User Access
 * @author Joachim Jensen <joachim@dev.institute>
 * @license GPLv3
 * @copyright 2020 by Joachim Jensen
 */

defined('ABSPATH') || exit;

if (is_admin()) {
    $rua_db_updater = RUA_App::instance()->get_updater();
    $rua_db_updater->register_version_update('0.4', 'rua_update_to_04');
    $rua_db_updater->register_version_update('0.13', 'rua_update_to_013');
    $rua_db_updater->register_version_update('0.14', 'rua_update_to_014');
    $rua_db_updater->register_version_update('0.15', 'rua_update_to_015');
    $rua_db_updater->register_version_update('0.17', 'rua_update_to_017');
    $rua_db_updater->register_version_update('1.1', 'rua_update_to_11');
    $rua_db_updater->register_version_update('1.2.1', 'rua_update_to_121');
    $rua_db_updater->register_version_update('2.1.2', 'rua_update_to_212');

    /**
     * Enable legacy date module and
     * negated conditions if in use
     *
     * @since 2.1.2
     *
     * @return bool
     */
    function rua_update_to_212()
    {
        global $wpdb;

        $types = WPCACore::types()->get_all();

        $options = array(
             'legacy.date_module'        => array(),
             'legacy.negated_conditions' => array()
        );

        $options['legacy.date_module'] = array_flip((array)$wpdb->get_col("
            SELECT p.post_type FROM $wpdb->posts p
            INNER JOIN $wpdb->posts c on p.ID = c.post_parent
            INNER JOIN $wpdb->postmeta m on c.ID = m.post_id
            WHERE c.post_type = 'condition_group' AND m.meta_key = '_ca_date'
        "));

        $options['legacy.negated_conditions'] = array_flip((array)$wpdb->get_col("
            SELECT p.post_type FROM $wpdb->posts p
            INNER JOIN $wpdb->posts c on p.ID = c.post_parent
            WHERE c.post_type = 'condition_group' AND c.post_status = 'negated'
        "));

        foreach ($types as $type => $val) {
            foreach ($options as $option => $post_types) {
                if (isset($post_types[$type])) {
                    WPCACore::save_option($type, $option, true);
                } elseif (WPCACore::get_option($type, $option, false)) {
                    WPCACore::save_option($type, $option, false);
                }
            }
        }

        return true;
    }

    /**
     * Invalidate broken condition type cache
     * @since 1.2.1
     *
     * @return bool
     */
    function rua_update_to_121()
    {
        update_option('_ca_condition_type_cache', array());

        return true;
    }

    /**
     * Migrate rua-toolbar-hide option to levels
     *
     * @since  1.1
     * @return bool
     */
    function rua_update_to_11()
    {
        $hide_toolbar = get_option('rua-toolbar-hide', false);

        delete_option('rua-toolbar-hide');

        if (!$hide_toolbar) {
            return true;
        }

        $app = RUA_App::instance();
        $levels = $app->get_levels();
        $metadata = $app->level_manager->metadata()->get('hide_admin_bar');

        foreach ($levels as $level) {
            $metadata->update($level->ID, 1);
        }

        return true;
    }

    /**
     * Update to version 0.17
     * Remove role meta for unsynced levels
     *
     * @since  0.17
     * @return boolean
     */
    function rua_update_to_017()
    {
        global $wpdb;

        $wpdb->query("
			DELETE FROM $wpdb->postmeta
			WHERE meta_key = '_ca_role' AND meta_value = '-1'
		");

        return true;
    }

    /**
     * Update to version 0.15
     * Remove old condition settings
     *
     * @since  0.15
     * @return boolean
     */
    function rua_update_to_015()
    {
        global $wpdb;

        $wpdb->query("
			DELETE FROM $wpdb->postmeta
			WHERE meta_value LIKE '_ca_sub_%'
		");

        return true;
    }

    /**
     * Update to version 0.14
     * Simplify auto select option
     *
     * @since  0.14
     * @return boolean
     */
    function rua_update_to_014()
    {
        global $wpdb;

        $group_ids = $wpdb->get_col("SELECT post_id FROM $wpdb->postmeta WHERE meta_value LIKE '_ca_sub_%'");
        foreach ($group_ids as $group_id) {
            add_post_meta($group_id, '_ca_autoselect', 1, true);
        }

        return true;
    }

    /**
     * Update to version 0.13
     * Inherit condition exposure from level
     * Remove level exposure
     *
     * @since  0.13
     * @return boolean
     */
    function rua_update_to_013()
    {
        global $wpdb;

        $wpdb->query("
			UPDATE $wpdb->posts AS c
			INNER JOIN $wpdb->posts AS s ON s.ID = c.post_parent
			INNER JOIN $wpdb->postmeta AS e ON e.post_id = s.ID
			SET c.menu_order = e.meta_value
			WHERE c.post_type = 'condition_group'
			AND e.meta_key = '_ca_exposure'
		");

        $wpdb->query("
			DELETE FROM $wpdb->postmeta
			WHERE meta_key = '_ca_exposure'
		");

        wp_cache_flush();

        return true;
    }

    /**
     * Store userlevel dates with level_id
     * instead of level umeta_id
     *
     * @since  0.4
     * @return boolean
     */
    function rua_update_to_04()
    {
        global $wpdb;

        //Get levels by umeta id and level id
        $levels_by_metaid = $wpdb->get_results("SELECT umeta_id,meta_value FROM $wpdb->usermeta WHERE meta_key = '_ca_level'", OBJECT_K);
        $levels_by_id = array();
        foreach ($levels_by_metaid as $meta_id => $level) {
            $levels_by_id[$level->meta_value] = $meta_id;
        }

        $level_dates = $wpdb->get_results("SELECT user_id,meta_key,meta_value FROM $wpdb->usermeta WHERE meta_key LIKE '_ca_level_%'");
        foreach ($level_dates as $level_date) {
            $level_date_metaid = str_replace('_ca_level_', '', $level_date->meta_key);
            //Check if date exists by level umeta id (old store)
            //If so, move it to new
            if (isset($levels_by_metaid[$level_date_metaid])) {
                update_user_meta($level_date->user_id, '_ca_level_'.$levels_by_metaid[$level_date_metaid]->meta_value, $level_date->meta_value, true);
            }
            //Check if date exists by level id (new store)
            //If not, delete it
            if (!isset($levels_by_id[$level_date_metaid])) {
                delete_user_meta($level_date->user_id, $level_date->meta_key);
            }
        }

        return true;
    }
}