LLMS_Course_Data::get_engagements( string $type, string $period = 'current' )
Retrieve # of engagements related to the course awarded within the period
Parameters Parameters
- $type
-
(string) (Required) Engagement type [email|certificate|achievement].
- $period
-
(string) (Optional) Date period [current|previous]. Default is 'current'.
Default value: 'current'
Return Return
(int)
Source Source
File: includes/class.llms.course.data.php
public function get_engagements( $type, $period = 'current' ) { global $wpdb; $ids = implode( ',', $this->get_all_ids() ); // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared return $wpdb->get_var( $wpdb->prepare( " SELECT DISTINCT COUNT( user_id ) FROM {$wpdb->prefix}lifterlms_user_postmeta WHERE meta_key = %s AND post_id IN ( {$ids} ) AND updated_date BETWEEN %s AND %s ", '_' . $type, $this->get_date( $period, 'start' ), $this->get_date( $period, 'end' ) ) );// db call ok; no-cache ok. // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared }
Expand full source code Collapse full source code View on GitHub
Changelog Changelog
Version | Description |
---|---|
3.15.0 | Introduced. |