| @@ -11,9 +11,9 @@ | ||
| 11 | 11 | /** |
| 12 | 12 | * @return array |
| 13 | 13 | */ |
| 14 | 14 | public function get_defaults() { |
| 15 | - $values = array( | |
| 15 | + return array( | |
| 16 | 16 | 'sub_id' => array( |
| 17 | 17 | 'sanitize' => 'sanitize_text_field', |
| 18 | 18 | 'default' => '', |
| 19 | 19 | ), |
| @@ -68,15 +68,17 @@ | ||
| 68 | 68 | 'meta_value' => array( |
| 69 | 69 | 'sanitize' => 'maybe_serialize', |
| 70 | 70 | 'default' => '', |
| 71 | 71 | ), |
| 72 | + 'test' => array( | |
| 73 | + 'sanitize' => 'sanitize_text_field', | |
| 74 | + 'default' => null, | |
| 75 | + ), | |
| 72 | 76 | ); |
| 73 | - | |
| 74 | - return $values; | |
| 75 | 77 | } |
| 76 | 78 | |
| 77 | 79 | /** |
| 78 | - * @return array|object|null | |
| 80 | + * @return array | |
| 79 | 81 | */ |
| 80 | 82 | public function get_overdue_subscriptions() { |
| 81 | 83 | global $wpdb; |
| 82 | 84 | return $wpdb->get_results( |
| @@ -86,8 +88,25 @@ | ||
| 86 | 88 | AND next_bill_date < %s |
| 87 | 89 | AND (status = 'active' OR status = 'future_cancel')", |
| 88 | 90 | 3, |
| 89 | 91 | gmdate( 'Y-m-d' ) |
| 92 | + ) | |
| 93 | + ); | |
| 94 | + } | |
| 95 | + | |
| 96 | + /** | |
| 97 | + * Get all active or future_cancel subscriptions without next_bill_date check. | |
| 98 | + * | |
| 99 | + * @since 6.32 | |
| 100 | + * | |
| 101 | + * @return array | |
| 102 | + */ | |
| 103 | + public function get_active_subscriptions() { | |
| 104 | + global $wpdb; | |
| 105 | + return $wpdb->get_results( | |
| 106 | + $wpdb->prepare( | |
| 107 | + "SELECT * FROM %i WHERE (status = 'active' OR status = 'future_cancel')", | |
| 108 | + $wpdb->prefix . 'frm_subscriptions' | |
| 90 | 109 | ) |
| 91 | 110 | ); |
| 92 | 111 | } |
| 93 | 112 | } |