LLMS_Course_Data::get_unenrollments( tring $period = 'current' )
Retrieve the number of unenrollments on a given date.
Parameters Parameters
- $period
-
(tring) (Optional) Date period [current|previous]. Default 'current'.
Default value: 'current'
Return Return
(int)
Source Source
File: includes/class.llms.course.data.php
public function get_unenrollments( $period = 'current' ) {
global $wpdb;
return $wpdb->get_var(
$wpdb->prepare(
"
SELECT DISTINCT COUNT( user_id )
FROM {$wpdb->prefix}lifterlms_user_postmeta
WHERE meta_value != 'enrolled'
AND meta_key = '_status'
AND post_id = %d
AND updated_date BETWEEN %s AND %s
",
$this->post_id,
$this->get_date( $period, 'start' ),
$this->get_date( $period, 'end' )
)
);// db call ok; no-cache ok.
}
Expand full source code Collapse full source code View on GitHub
Changelog Changelog
| Version | Description |
|---|---|
| 3.15.0 | Introduced. |