<?php
/**
 * Plugin Name: Fgc Take A Month Off
 * Plugin URI: http://fgc.vn
 * Description: Fgc Take A Month Off
 * Author: Phuong An.
 * Author URI: http://fgc.vn
 * Version: 1.0
 *
 * Copyright 2016 Prospress, Inc.  (email : freedoms@prospress.com)
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @package		Woocommerce
 * @author		Phuong An <phuongantt.na@gmail.com>
 * @since		1.0
 */
add_action('wp_loaded', 'fgc_check_logged_in_take_month_off_page', 20);

function fgc_check_logged_in_take_month_off_page() {
    $request_uri = $_SERVER["REQUEST_URI"];
    if (strpos($request_uri, '/take-month-off') !== false) {
        if (get_current_user_id() == 0) {
            fgc_redirect_back();
        }
    }
}

add_action('wp_loaded', 'fgc_set_take_month_off', 20);

function fgc_set_take_month_off() {
    if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'set-take-month-off') {
        $user_id = get_current_user_id();
        global $wpdb;

        $query = "SELECT * FROM `" . $wpdb->prefix . "woocommerce_take_month_off` WHERE `user_id` = $user_id AND `is_take_month_off` = 1";
        $results = $wpdb->get_results($query);
        if (empty($results)) {
            $subscription_and_key = fgc_set_subcription_key($user_id);
            if ($subscription_and_key) {
                $subscription_key = $subscription_and_key['subscription_key'];
                $subscription = $subscription_and_key['subscription'];
                $wc_subscription = $subscription_and_key['wc_subcription'];

                $current_next_payment_time = $wc_subscription->get_time('next_payment');

                if ($current_next_payment_time > 0) {
//                Put on hold
                    WC_Subscriptions_Manager::put_subscription_on_hold($user_id, $subscription_key);
//                Set next payment time
                    $next_payment = wcs_add_months($current_next_payment_time, 1);

                    WC_Subscriptions_Manager::set_next_payment_date($subscription_key, $user_id, $next_payment);

                    $next_payment2 = strtotime(date('Y-m-d', $next_payment));
                    $date_active = strtotime('+30 days', strtotime(date('Y-m-d'))); //30 * 24 * 3600 + current_time('timestamp', true);
                    if ($date_active > $next_payment2) {
                        $date_active = strtotime('-3 days', $next_payment2);
                    }
//                Set reactive time
                    global $wpdb;

                    $query = "INSERT INTO `" . $wpdb->prefix . "woocommerce_take_month_off` (`user_id`, `subscription_key`, `is_take_month_off`,`date_active`) VALUES ($user_id, '$subscription_key', 1,$date_active);";
//                  Insert new recod
                    $result = $wpdb->query($query);
                    if ($result) {
                        $stringTime = gmdate("dS F Y", $next_payment);
                        fgc_update_order_comment_after_take_month_off($subscription_key);
                        fgc_add_tag_after_take_month_off($user_id);
                        setcookie("isSetTakeMonthOff", '1', time() + 3600, '/');
                        do_action('fgc_set_take_month_off', $wc_subscription);
                        ?>
                        Your wish is our command, enjoy your month off. Your next payment will be on <?php echo gmdate("dS F Y", $next_payment) ?>.<br/><br/>
                        <a class="ok button btnrow" href="/my-account">OK</a>
                        <?php
                    } else {
                        echo 'Can not insert to ' . $wpdb->prefix . "woocommerce_take_month_off";
                    }
                } else {
                    echo 'Next payment time is invalid.';
                }
            } else {
                echo 'Not found subscription.';
            }
        } else {
            echo 'You are taking month off now.';
        }
        exit();
    }
}

add_action('wp_loaded', 'fgc_set_reactive_subscriptions', 20);

function fgc_set_reactive_subscriptions() {
    if (isset($_REQUEST['cr_action']) && $_REQUEST['cr_action'] == 'reactive-take-month-off') {
        echo 'Start reactive:<br/>';
        global $wpdb;
        $query = "SELECT * FROM `" . $wpdb->prefix . "woocommerce_take_month_off` WHERE `is_take_month_off` = 1 AND `date_active` < " . strtotime("tomorrow");
        $results = $wpdb->get_results($query);
        foreach ($results as $result) {
            if (WC_Subscriptions_Manager::activate_subscription($result->user_id, $result->subscription_key)) {
                $query_update = "UPDATE `" . $wpdb->prefix . "woocommerce_take_month_off` SET `is_take_month_off` = 0 WHERE `user_id` = " . $result->user_id;
                $result_update = $wpdb->query($query_update);
                if ($result_update) {
                    echo '<br/>Reactive successfull for subscription of ';
                } else {
                    echo '<br/>Can update on database with ';
                }
            } else {
                echo '<br/>Can not active subscription of ';
            }
            echo 'user_id: ' . $result->user_id . ' , subscription_key: ' . $result->subscription_key;
        }
        echo '<br/><br/>Complete.';
        exit();
    }
}

add_action('wp_loaded', 'fgc_update_data_take_month_off', 20);

function fgc_update_data_take_month_off() {
    if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'updateDataTakeMonthOff') {
        echo '<pre>';
        echo 'Start update:<br/>';
        global $wpdb;
        $query = "SELECT * FROM `" . $wpdb->prefix . "postmeta` WHERE `meta_key` = '_set_on_re_active' AND `meta_value` > " . strtotime("now");
        $results = $wpdb->get_results($query);
        foreach ($results as $result) {
            $order = new WC_Order($result->post_id);
            $user_id = $order->user_id;

            $subscriptions = WC_Subscriptions_Manager::get_users_subscriptions($user_id);
            $subscription_key = '';
            foreach ($subscriptions as $subscription) {
                if ($subscription['status'] == 'on-hold') {
                    $subscription_key = WC_Subscriptions_Manager::get_subscription_key($subscription['order_id'], $subscription['product_id']);
                    $date_active = $result->meta_value;
                    $query_check_exist = "SELECT * FROM `" . $wpdb->prefix . "woocommerce_take_month_off` WHERE `subscription_key` = '$subscription_key' AND `is_take_month_off` = 1 ";
                    $results_check_exist = $wpdb->get_results($query_check_exist);
                    if (count($results_check_exist) == 0) {
                        $query_insert = "INSERT INTO `" . $wpdb->prefix . "woocommerce_take_month_off` (`user_id`, `subscription_key`, `is_take_month_off`,`date_active`) VALUES ($user_id, '$subscription_key', 1,$date_active);";
//                  Insert new recod
                        $result_insert = $wpdb->query($query_insert);
                        if ($result_insert) {
                            echo '<br/>' . $query_insert;
                        } else {
                            echo '<br/>Cant update for order: ' . $result->post_id;
                        }
                    } else {
                        echo '<br/>A subscription can not have two take month off at same time.';
                    }
                    break;
                }
            }
        }
        echo '<br/><br/>Complete.';
        exit();
    }
    if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'updateTakeMonthOffTag') {
        echo '<pre>';
        echo 'Start update:<br/>';
        global $wpdb;
        $query = "SELECT * FROM `" . $wpdb->prefix . "postmeta` WHERE `meta_key` = '_set_on_re_active' ";
        $results = $wpdb->get_results($query);
        foreach ($results as $result) {
            $order = new WC_Order($result->post_id);
            $user_id = $order->user_id;
            if ($user_id > 0 && $user_id != '') {
                $date_active = (int) $result->meta_value;
                FGC_ActiveCampaign::add_tag_by_user_id('SUBSCRIPTION: Take Month Off', $user_id);
                echo '<br/>Take Month Off: ' . $user_id;
                if ($date_active > strtotime("now")) {
                    FGC_ActiveCampaign::add_tag_by_user_id('SUBSCRIPTION: On Hold', $user_id);
                    echo '<br/>On Hold: ' . $user_id;
                }
            } else {
                echo '<br/>user_id: ' . $user_id;
            }
        }
        echo '<br/><br/>Complete.';
        exit();
    }
    if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'checkTakeMonthOffNote') {
        echo '<pre>';
        echo 'Start update:<br/>';
        fgc_update_order_comment_after_take_month_off('10451_308');
        echo '<br/><br/>Complete.';
        exit();
    }
}

add_action('woocommerce_payment_complete', 'fgc_set_take_month_off_after_upgrade_downgrade', 30);

function fgc_set_take_month_off_after_upgrade_downgrade($order_id) {
    $order = new WC_Order($order_id);
    $user_id = $order->user_id;
    global $wpdb;
    $query = "SELECT * FROM `" . $wpdb->prefix . "woocommerce_take_month_off` WHERE `user_id` = $user_id AND `is_take_month_off` = 1";
    $results = $wpdb->get_results($query);
    if (!empty($results)) {
        WC_Subscriptions_Manager::put_subscription_on_hold($user_id, $results[0]->subscription_key);
    }
}

function fgc_redirect_back() {
    echo '<META HTTP-EQUIV = "Refresh" Content = "0; URL=' . get_site_url() . '/login-page' . '">';
    exit();
}

function fgc_set_subcription_key($user_id = 0) {
    $subscriptions = WC_Subscriptions_Manager::get_users_subscriptions($user_id);
    $subscription_key = '';
    foreach ($subscriptions as $subscription) {
        if ($subscription['status'] == 'active') {
            $subscription_key = WC_Subscriptions_Manager::get_subscription_key($subscription['order_id'], $subscription['product_id']);
            if ($subscription_key != '') {
                $wc_subscription = wcs_get_subscription_from_key($subscription_key);
                return array('subscription_key' => $subscription_key, 'subscription' => $subscription, 'wc_subcription' => $wc_subscription);
            }
        }
    }
    return false;
}

function fgc_update_order_comment_after_take_month_off($subscription_key) {
    $wc_subscription = wcs_get_subscription_from_key($subscription_key);
    $subscription_id = $wc_subscription->id;

    global $wpdb;
    $query = "SELECT `comment_ID` FROM `wp_comments` WHERE `comment_post_ID` = $subscription_id AND `comment_content` = 'Status changed from Active to On hold.' AND `comment_type` = 'order_note' ";
    $result = $wpdb->get_results($query);
    if (!empty($result)) {
        $comment_id = $result[0]->comment_ID;
        $query_update = "UPDATE `wp_comments` SET `comment_content` = 'Status changed from Active to On hold by user.'  WHERE `comment_ID` = $comment_id ";
        $wpdb->query($query_update);
    }
}

function fgc_add_tag_after_take_month_off($user_id) {
    FGC_ActiveCampaign::add_tag_by_user_id('SUBSCRIPTION: Take Month Off', $user_id);
    FGC_ActiveCampaign::add_tag_by_user_id('SUBSCRIPTION: On Hold', $user_id);
}

function fgc_remove_tag_after_reactive($user_id) {
    FGC_ActiveCampaign::remove_tag_by_user_id('SUBSCRIPTION: On Hold', $user_id);
}

global $wpdb;
$take_month_off_db_version = '1.1';

$fgc_installed_ver = get_option("take_month_off_db_version");

if ($fgc_installed_ver != $take_month_off_db_version) {

    $table_name_new1 = $wpdb->prefix . 'woocommerce_take_month_off';

    $sql1 = "CREATE TABLE IF NOT EXISTS `$table_name_new1` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `user_id` BIGINT(20) NULL,
  `subscription_key` VARCHAR(255) NULL,
  `date_active` BIGINT NULL,
  `is_take_month_off` TINYINT(1) NULL,
  PRIMARY KEY (`id`));";

    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
    dbDelta($sql1);

    update_option("take_month_off_db_version", $take_month_off_db_version);
}