report-last_year.php
| 1 | <?php |
| 2 | /** |
| 3 | * Template for displaying instructors earnings |
| 4 | * |
| 5 | * @since v.1.1.2 |
| 6 | * |
| 7 | * @author Themeum |
| 8 | * @url https://themeum.com |
| 9 | */ |
| 10 | |
| 11 | global $wpdb; |
| 12 | |
| 13 | $user_id = get_current_user_id(); |
| 14 | |
| 15 | /** |
| 16 | * Getting the Last Month |
| 17 | */ |
| 18 | $year = date('Y', strtotime('-1 year')); |
| 19 | $dataFor = 'yearly'; |
| 20 | |
| 21 | $earning_sum = tutor_utils()->get_earning_sum($user_id, compact('year', 'dataFor')); |
| 22 | |
| 23 | if ( ! $earning_sum){ |
| 24 | echo '<p>'.__('No Earning info available', 'tutor' ).'</p>'; |
| 25 | return; |
| 26 | } |
| 27 | |
| 28 | $complete_status = tutor_utils()->get_earnings_completed_statuses(); |
| 29 | $statuses = $complete_status; |
| 30 | $complete_status = "'".implode("','", $complete_status)."'"; |
| 31 | |
| 32 | |
| 33 | /** |
| 34 | * Query This Month |
| 35 | */ |
| 36 | |
| 37 | $salesQuery = $wpdb->get_results( " |
| 38 | SELECT SUM(instructor_amount) as total_earning, |
| 39 | MONTHNAME(created_at) as month_name |
| 40 | from {$wpdb->prefix}tutor_earnings |
| 41 | WHERE user_id = {$user_id} AND order_status IN({$complete_status}) |
| 42 | AND YEAR(created_at) = {$year} |
| 43 | GROUP BY MONTH (created_at) |
| 44 | ORDER BY MONTH(created_at) ASC ;"); |
| 45 | |
| 46 | $total_earning = wp_list_pluck($salesQuery, 'total_earning'); |
| 47 | $months = wp_list_pluck($salesQuery, 'month_name'); |
| 48 | $monthWiseSales = array_combine($months, $total_earning); |
| 49 | |
| 50 | /** |
| 51 | * Format yearly |
| 52 | */ |
| 53 | $emptyMonths = array(); |
| 54 | for ($m=1; $m<=12; $m++) { |
| 55 | $emptyMonths[date('F', mktime(0,0,0,$m, 1, date('Y')))] = 0; |
| 56 | } |
| 57 | $chartData = array_merge($emptyMonths, $monthWiseSales); |
| 58 | |
| 59 | $statements = tutor_utils()->get_earning_statements($user_id, compact('year', 'dataFor', 'statuses')); |
| 60 | |
| 61 | ?> |
| 62 | |
| 63 | <div class="tutor-dashboard-info-cards"> |
| 64 | <div class="tutor-dashboard-info-card" title="<?php _e('All time', 'tutor'); ?>"> |
| 65 | <p> |
| 66 | <span> <?php _e('My Earning', 'tutor'); ?> </span> |
| 67 | <span class="tutor-dashboard-info-val"><?php echo tutor_utils()->tutor_price($earning_sum->instructor_amount); ?></span> |
| 68 | </p> |
| 69 | </div> |
| 70 | <div class="tutor-dashboard-info-card" title="<?php _e('Based on course price', 'tutor'); ?>"> |
| 71 | <p> |
| 72 | <span> <?php _e('All time sales', 'tutor'); ?> </span> |
| 73 | <span class="tutor-dashboard-info-val"><?php echo tutor_utils()->tutor_price($earning_sum->course_price_total); ?></span> |
| 74 | </p> |
| 75 | </div> |
| 76 | <div class="tutor-dashboard-info-card"> |
| 77 | <p> |
| 78 | <span> <?php _e('Deducted Commissions', 'tutor'); ?> </span> |
| 79 | <span class="tutor-dashboard-info-val"><?php echo tutor_utils()->tutor_price($earning_sum->admin_amount); ?></span> |
| 80 | </p> |
| 81 | </div> |
| 82 | |
| 83 | |
| 84 | <?php if ($earning_sum->deduct_fees_amount > 0){ ?> |
| 85 | <div class="tutor-dashboard-info-card" title="<?php _e('Deducted Fees', 'tutor'); ?>"> |
| 86 | <p> |
| 87 | <span> <?php _e('Deducted Fees', 'tutor'); ?> </span> |
| 88 | <span class="tutor-dashboard-info-val"><?php echo tutor_utils()->tutor_price($earning_sum->deduct_fees_amount); ?></span> |
| 89 | </p> |
| 90 | </div> |
| 91 | <?php } ?> |
| 92 | </div> |
| 93 | |
| 94 | |
| 95 | |
| 96 | |
| 97 | |
| 98 | <div class="tutor-dashboard-item-group"> |
| 99 | <h4><?php echo sprintf(__("Earning Data for the year of %s", 'tutor-report'), $year);?></h4> |
| 100 | <?php |
| 101 | tutor_load_template('dashboard.earning.chart-body', compact('chartData', 'statements')); |
| 102 | ?> |
| 103 | </div> |
| 104 | |
| 105 | <div class="tutor-dashboard-item-group"> |
| 106 | <h4><?php _e('Sales statements for this period', 'tutor') ?></h4> |
| 107 | <?php tutor_load_template('dashboard.earning.statement', compact('chartData', 'statements')); ?> |
| 108 | </div> |
| 109 |