llms_update_3120_update_order_end_dates()

Add end dates to LifterLMS Orders which have a length but no saved end date

Contents

Return Return

(void)

Top ↑

Source Source

File: includes/functions/updates/llms-functions-updates-3120.php

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
function llms_update_3120_update_order_end_dates() {
 
    global $wpdb;
 
    $ids = $wpdb->get_col(
        "SELECT posts.ID
         FROM {$wpdb->posts} AS posts
         JOIN {$wpdb->postmeta} AS meta1 ON meta1.post_id = posts.ID AND meta1.meta_key = '_llms_billing_length'
         LEFT JOIN {$wpdb->postmeta} AS meta2 ON meta2.post_id = posts.ID AND meta2.meta_key = '_llms_date_billing_end'
         WHERE posts.post_type = 'llms_order'
           AND meta2.meta_value IS NULL
           AND meta1.meta_value > 0;"
    ); // db call ok; no-cache ok.
 
    foreach ( $ids as $id ) {
 
        $order = llms_get_post( $id );
        if ( ! is_a( $order, 'LLMS_Order' ) ) {
            continue;
        }
 
        $order->maybe_schedule_payment( true );
 
    }
 
}

Expand full source code Collapse full source code View on GitHub

Top ↑

Uses Uses

Uses
Uses Description
includes/llms.functions.core.php: llms_get_post()

Retrieve the LLMS Post Model for a give post by ID or WP_Post Object

Top ↑

Changelog Changelog

Changelog
Version Description
3.12.0 Introduced.

Top ↑

User Contributed Notes User Contributed Notes

You must log in before being able to contribute a note or feedback.