fgc-change-renewal-time.php
2.2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?php
/**
* Plugin Name: Fgc Change Renewal Time
* Plugin URI: http://fgc.vn
* Description: Fgc Change Renewal Time
* 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
* @since 1.0
*/
if (isset($_REQUEST['cr_action']) && $_REQUEST['cr_action'] == 'changeRenewalTime') {
global $wpdb;
$query = "SELECT * FROM `" . $wpdb->prefix . "postmeta` WHERE `meta_key` = '_schedule_next_payment' AND `meta_value` != 0";
$results = $wpdb->get_results($query);
if (!empty($results)) {
echo '<pre>';
$oneHour = 3600;
$tomorrow = strtotime('tomorrow');
foreach ($results as $result) {
$next_payment_date = strtotime($result->meta_value);
if ($tomorrow < $next_payment_date) {
var_dump($result);
$time_diff = ($next_payment_date - $tomorrow) % ($oneHour * 24);
$time_at_10AM_AEDT = $next_payment_date - $time_diff - $oneHour;
$new_payment_date = date("Y-m-d H:i:s", $time_at_10AM_AEDT);
$query_update = "UPDATE `wp_postmeta` SET `meta_value` = '" . $new_payment_date . "' WHERE `meta_id` = " . $result->meta_id;
if ($wpdb->query($query_update)) {
$success = 'success';
} else {
$success = 'fail';
}
echo 'Update ' . $success . ' for meta_id = ' . $result->meta_id . '<br/>';
}
}
}
exit();
}