| 1 |
<?php |
| 2 |
global $wpdb; |
| 3 |
$table_name = $wpdb->prefix . 'wpc_tracking'; |
| 4 |
$sql = "SELECT DISTINCT user_id FROM $table_name"; |
| 5 |
$results = $wpdb->get_results($sql); |
| 6 |
$user_count = $wpdb->num_rows; |
| 7 |
|
| 8 |
?> |
| 9 |
|
| 10 |
<?php do_action('wpc_after_dashboard_data'); ?> |
| 11 |
<div class="wpc-flex-container"> |
| 12 |
<div class="wpc-flex-content wpc-flex-content-large"> |
| 13 |
<div class="wpc-flex-container"> |
| 14 |
|
| 15 |
<div class="wpc-flex-4 wpc-material wpc-fade"> |
| 16 |
<h2 class="wpc-material-heading" style="text-align: center;">Active Students</h2> |
| 17 |
<div class="wpc-meta-lg wpc-center" style="color: #FCD46C;"><?php echo (int) $user_count; ?></div> |
| 18 |
</div> |
| 19 |
|
| 20 |
<div class="wpc-flex-4 wpc-material wpc-fade"> |
| 21 |
<h2 class="wpc-material-heading" style="text-align: center;">Courses</h2> |
| 22 |
<div class="wpc-meta-lg wpc-center" style="color: #E21772;"><?php echo (int) wp_count_posts('course')->publish; ?></div> |
| 23 |
</div> |
| 24 |
|
| 25 |
<div class="wpc-flex-4 wpc-material wpc-fade"> |
| 26 |
<h2 class="wpc-material-heading" style="text-align: center;">Lessons</h2> |
| 27 |
<div class="wpc-meta-lg wpc-center" style="color: #89D6E2;"><?php echo (int) wp_count_posts('lesson')->publish; ?></div> |
| 28 |
</div> |
| 29 |
|
| 30 |
</div> |
| 31 |
|
| 32 |
<div class="wpc-flex-container"> |
| 33 |
|
| 34 |
<div class="wpc-flex-12 wpc-material wpc-fade"> |
| 35 |
<h2 class="wpc-material-heading"><?php esc_html_e('Tracking Data', 'wp-courses'); ?></h2> |
| 36 |
<?php include 'charts/chart-tracking-data.php'; ?> |
| 37 |
</div> |
| 38 |
|
| 39 |
<div class="wpc-flex-6 wpc-material wpc-fade"> |
| 40 |
<h2 class="wpc-material-heading"><?php esc_html_e('Popular Courses by % Viewed or Completed', 'wp-courses'); ?></h2> |
| 41 |
<?php include 'charts/chart-popular-courses.php'; ?> |
| 42 |
</div> |
| 43 |
|
| 44 |
<div class="wpc-flex-6 wpc-material wpc-fade"> |
| 45 |
<h2 class="wpc-material-heading"><?php esc_html_e('Most Active Users', 'wp-courses'); ?></h2> |
| 46 |
<?php include 'charts/chart-most-active-users.php'; ?> |
| 47 |
</div> |
| 48 |
|
| 49 |
</div> |
| 50 |
|
| 51 |
</div> |
| 52 |
|
| 53 |
</div> |
| 54 |
|
| 55 |
|
| 56 |
|
| 57 |
|
| 58 |
|
