chart-body.php
6 years ago
earning-report-top-menu.php
6 years ago
report-date_range.php
6 years ago
report-last_month.php
6 years ago
report-last_week.php
6 years ago
report-last_year.php
6 years ago
report-this_month.php
6 years ago
report-this_week.php
6 years ago
report-this_year.php
6 years ago
report.php
6 years ago
statement.php
6 years ago
statements.php
6 years ago
report-last_month.php
116 lines
| 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 | * @package TutorLMS/Templates |
| 11 | * @version 1.4.3 |
| 12 | */ |
| 13 | |
| 14 | global $wpdb; |
| 15 | |
| 16 | $user_id = get_current_user_id(); |
| 17 | |
| 18 | /** |
| 19 | * Getting the Last Month |
| 20 | */ |
| 21 | $start_date = date('Y-m-01 00:00:00', strtotime('last day of last month')); |
| 22 | $end_date = date("Y-m-t 23:59:59", strtotime($start_date)); |
| 23 | |
| 24 | $earning_sum = tutor_utils()->get_earning_sum($user_id, compact('start_date', 'end_date')); |
| 25 | if ( ! $earning_sum){ |
| 26 | echo '<p>'.__('No Earning info available', 'tutor' ).'</p>'; |
| 27 | return; |
| 28 | } |
| 29 | |
| 30 | $complete_status = tutor_utils()->get_earnings_completed_statuses(); |
| 31 | $statuses = $complete_status; |
| 32 | $complete_status = "'".implode("','", $complete_status)."'"; |
| 33 | |
| 34 | /** |
| 35 | * Format Date Name |
| 36 | */ |
| 37 | $begin = new DateTime($start_date); |
| 38 | $end = new DateTime($end_date); |
| 39 | $interval = DateInterval::createFromDateString('1 day'); |
| 40 | $period = new DatePeriod($begin, $interval, $end); |
| 41 | |
| 42 | $datesPeriod = array(); |
| 43 | foreach ($period as $dt) { |
| 44 | $datesPeriod[$dt->format("Y-m-d")] = 0; |
| 45 | } |
| 46 | |
| 47 | /** |
| 48 | * Query This Month |
| 49 | */ |
| 50 | |
| 51 | $salesQuery = $wpdb->get_results( " |
| 52 | SELECT SUM(instructor_amount) as total_earning, |
| 53 | DATE(created_at) as date_format |
| 54 | from {$wpdb->prefix}tutor_earnings |
| 55 | WHERE user_id = {$user_id} AND order_status IN({$complete_status}) |
| 56 | AND (created_at BETWEEN '{$start_date}' AND '{$end_date}') |
| 57 | GROUP BY date_format |
| 58 | ORDER BY created_at ASC ;"); |
| 59 | |
| 60 | $total_earning = wp_list_pluck($salesQuery, 'total_earning'); |
| 61 | $queried_date = wp_list_pluck($salesQuery, 'date_format'); |
| 62 | $dateWiseSales = array_combine($queried_date, $total_earning); |
| 63 | |
| 64 | $chartData = array_merge($datesPeriod, $dateWiseSales); |
| 65 | foreach ($chartData as $key => $salesCount){ |
| 66 | unset($chartData[$key]); |
| 67 | $formatDate = date('d M', strtotime($key)); |
| 68 | $chartData[$formatDate] = $salesCount; |
| 69 | } |
| 70 | $statements = tutor_utils()->get_earning_statements($user_id, compact('start_date', 'end_date', 'statuses')); |
| 71 | |
| 72 | ?> |
| 73 | |
| 74 | <div class="tutor-dashboard-info-cards"> |
| 75 | <div class="tutor-dashboard-info-card" title="<?php _e('All time', 'tutor'); ?>"> |
| 76 | <p> |
| 77 | <span> <?php _e('My Earning', 'tutor'); ?> </span> |
| 78 | <span class="tutor-dashboard-info-val"><?php echo tutor_utils()->tutor_price($earning_sum->instructor_amount); ?></span> |
| 79 | </p> |
| 80 | </div> |
| 81 | <div class="tutor-dashboard-info-card" title="<?php _e('Based on course price', 'tutor'); ?>"> |
| 82 | <p> |
| 83 | <span> <?php _e('All time sales', 'tutor'); ?> </span> |
| 84 | <span class="tutor-dashboard-info-val"><?php echo tutor_utils()->tutor_price($earning_sum->course_price_total); ?></span> |
| 85 | </p> |
| 86 | </div> |
| 87 | <div class="tutor-dashboard-info-card"> |
| 88 | <p> |
| 89 | <span> <?php _e('Deducted Commissions', 'tutor'); ?> </span> |
| 90 | <span class="tutor-dashboard-info-val"><?php echo tutor_utils()->tutor_price($earning_sum->admin_amount); ?></span> |
| 91 | </p> |
| 92 | </div> |
| 93 | |
| 94 | |
| 95 | <?php if ($earning_sum->deduct_fees_amount > 0){ ?> |
| 96 | <div class="tutor-dashboard-info-card" title="<?php _e('Deducted Fees', 'tutor'); ?>"> |
| 97 | <p> |
| 98 | <span> <?php _e('Deducted Fees', 'tutor'); ?> </span> |
| 99 | <span class="tutor-dashboard-info-val"><?php echo tutor_utils()->tutor_price($earning_sum->deduct_fees_amount); ?></span> |
| 100 | </p> |
| 101 | </div> |
| 102 | <?php } ?> |
| 103 | </div> |
| 104 | |
| 105 | <div class="tutor-dashboard-item-group"> |
| 106 | <h4><?php echo sprintf(__("Earning Data for the month of %s", 'tutor'), date("F, Y", strtotime($start_date)));?></h4> |
| 107 | <?php |
| 108 | tutor_load_template('dashboard.earning.chart-body', compact('chartData', 'statements')); |
| 109 | ?> |
| 110 | </div> |
| 111 | |
| 112 | <div class="tutor-dashboard-item-group"> |
| 113 | <h4><?php _e('Sales statements for this period', 'tutor') ?></h4> |
| 114 | <?php tutor_load_template('dashboard.earning.statement', compact('chartData', 'statements')); ?> |
| 115 | </div> |
| 116 |