statements.php — Tutor LMS – eLearning and online course solution 1.9.10

tutor / templates / dashboard / earning / statements.php

tutor / templates / dashboard / earning Last commit date

chart-body.php 5 years ago earning-report-top-menu.php 4 years ago report-date_range.php 4 years ago report-last_month.php 4 years ago report-last_week.php 4 years ago report-last_year.php 4 years ago report-this_month.php 4 years ago report-this_week.php 4 years ago report-this_year.php 4 years ago report.php 5 years ago statement.php 4 years ago statements.php 4 years ago

statements.php

223 lines

1	<?php
2	/**
3	* Template for displaying Instructor Statements
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	if ( ! defined( 'ABSPATH' ) )
15	exit;
16
17	$sub_page = 'this_month';
18	if ( ! empty($_GET['time_period'])){
19	$sub_page = sanitize_text_field($_GET['time_period']);
20	}
21	if ( ! empty($_GET['date_range_from']) && ! empty($_GET['date_range_to'])){
22	$sub_page = 'date_range';
23	}
24	?>
25	<div class="tutor-dashboard-inline-links">
26	<ul>
27	<li><a href="<?php echo tutor_utils()->get_tutor_dashboard_page_permalink('earning'); ?>"> <?php _e('Earning'); ?></a>
28	</li>
29	<li><a href="<?php echo tutor_utils()->get_tutor_dashboard_page_permalink('earning/report'); ?>"> <?php _e('Report', 'tutor'); ?> </a></li>
30	<li class="active">
31	<a href="<?php echo tutor_utils()->get_tutor_dashboard_page_permalink('earning/statements'); ?>">
32	<?php _e('Statements', 'tutor'); ?> </a>
33	</li>
34	</ul>
35	</div>
36	<?php
37	tutor_load_template('dashboard.earning.earning-report-top-menu', compact('sub_page'));
38
39	$user_id = get_current_user_id();
40
41	$complete_status = tutor_utils()->get_earnings_completed_statuses();
42	$statuses = $complete_status;
43	$complete_status = "'".implode("','", $complete_status)."'";
44
45	$statements = false;
46
47	//Pagination Variable
48	$per_page = 1;//tutor_utils()->get_option('statement_show_per_page', 20);
49	$current_page = max( 1, tutor_utils()->avalue_dot('current_page', $_GET) );
50	$offset = ($current_page-1)*$per_page;
51
52
53	switch ($sub_page){
54
55	case 'last_year':
56	$year = date('Y', strtotime('-1 year'));
57	$dataFor = 'yearly';
58
59	$statements = tutor_utils()->get_earning_statements($user_id, compact('year', 'dataFor', 'per_page', 'offset'));
60	break;
61
62	case 'this_year':
63	$year = date('Y');
64	$dataFor = 'yearly';
65
66	$statements = tutor_utils()->get_earning_statements($user_id, compact('year', 'dataFor', 'per_page', 'offset'));
67	break;
68
69	case 'last_month':
70	$start_date = date("Y-m", strtotime('-1 month'));
71	$start_date = $start_date.'-1';
72	$end_date = date("Y-m-t", strtotime($start_date));
73
74	$statements = tutor_utils()->get_earning_statements($user_id, compact('start_date', 'end_date', 'per_page', 'offset'));
75	break;
76
77	case 'this_month':
78
79	$start_date = date("Y-m-01");
80	$end_date = date("Y-m-t");
81
82	$statements = tutor_utils()->get_earning_statements($user_id, compact('start_date', 'end_date', 'per_page', 'offset'));
83	break;
84
85	case 'last_week':
86
87	$previous_week = strtotime("-1 week +1 day");
88	$start_date = strtotime("last sunday midnight",$previous_week);
89	$end_date = strtotime("next saturday",$start_date);
90	$start_date = date("Y-m-d",$start_date);
91	$end_date = date("Y-m-d",$end_date);
92
93	$statements = tutor_utils()->get_earning_statements($user_id, compact('start_date', 'end_date', 'per_page', 'offset'));
94	break;
95
96
97	case 'this_week':
98	$start_date = date("Y-m-d", strtotime("last sunday midnight"));
99	$end_date = date("Y-m-d", strtotime("next saturday"));
100
101	$statements = tutor_utils()->get_earning_statements($user_id, compact('start_date', 'end_date', 'per_page', 'offset'));
102	break;
103
104	case 'date_range':
105
106	$start_date = sanitize_text_field(tutor_utils()->avalue_dot('date_range_from', $_GET));
107	$end_date = sanitize_text_field(tutor_utils()->avalue_dot('date_range_to', $_GET));
108
109	$statements = tutor_utils()->get_earning_statements($user_id, compact('start_date', 'end_date', 'per_page', 'offset'));
110	break;
111	}
112
113	?>
114
115	<div class="tutor-dashboard-item-group">
116	<h4><?php _e('Statements', 'tutor'); ?></h4>
117	<?php
118
119	if ($statements->count) {
120	?>
121
122	<p class="tutor-dashboard-pagination-results-stats">
123
124	<?php
125	echo sprintf(__('Showing results %d to %d of %d', 'tutor'), $offset +1, min($statements->count, $offset +1+tutor_utils()->count($statements->results)), $statements->count) ;
126	?>
127	</p>
128
129	<div class="tutor-dashboard-statement-table-wrap">
130	<table class="tutor-dashboard-statement-table tutor-table">
131	<tr>
132	<th><?php _e('Course Info', 'tutor'); ?></th>
133	<th><?php _e('Earning', 'tutor'); ?></th>
134	<th><?php _e('Commission', 'tutor'); ?></th>
135	<th><?php _e('Deduct', 'tutor'); ?></th>
136	</tr>
137
138	<?php
139	foreach ($statements->results as $statement){
140	?>
141	<tr>
142	<td>
143
144	<p class="small-text">
145	<span class="statement-order-<?php echo $statement->order_status; ?>"><?php echo $statement->order_status; ?></span>
146	<strong><?php _e('Date:', 'tutor') ?></strong>
147	<i><?php echo date_i18n(get_option('date_format'), strtotime($statement->created_at)).' '.date_i18n(get_option('time_format'), strtotime($statement->created_at)); ?></i>
148	</p>
149
150	<p>
151	<a href="<?php echo get_the_permalink($statement->course_id); ?>" target="_blank">
152	<?php echo $statement->course_title; ?>
153	</a>
154	</p>
155
156	<p>
157	<strong><?php _e('Price: ', 'tutor'); ?></strong>
158	<?php echo tutor_utils()->tutor_price($statement->course_price_total); ?>
159	</p>
160
161	<p class="small-text"><strong><?php _e('Order ID'); ?> #<?php echo $statement->order_id; ?></strong></p>
162
163	<?php
164	$order = wc_get_order($statement->order_id);
165	if($order && is_object($order)) {
166	$billing_address = $order->get_formatted_billing_address();
167	if($billing_address) {
168	echo '<div class="statement-address">
169	<strong>' . __('Purchaser', 'tutor') . ': </strong> <address>' . $billing_address . '</address>
170	</div>';
171	}
172	}
173	?>
174	</td>
175	<td>
176	<p><?php echo tutor_utils()->tutor_price($statement->instructor_amount); ?></p>
177	<p class="small-text"> <?php _e('As per'); ?> <?php echo $statement->instructor_rate ?> (<?php echo $statement->commission_type ?>) </p>
178	</td>
179
180	<td>
181	<p><?php echo tutor_utils()->tutor_price($statement->admin_amount); ?> </p>
182	<p class="small-text"><?php _e('Rate', 'tutor'); ?> : <?php echo $statement->admin_rate; ?> </p>
183	<p class="small-text"><?php _e('Type', 'tutor'); ?> : <?php echo $statement->commission_type; ?> </p>
184
185	</td>
186
187	<td>
188	<p><?php echo $statement->deduct_fees_name; ?> <?php echo tutor_utils()->tutor_price($statement->deduct_fees_amount); ?>
189	</p>
190	<p class="small-text"><?php _e('Type', 'tutor'); ?> : <?php echo $statement->deduct_fees_type; ?> </p>
191	</td>
192	</tr>
193	<?php
194	}
195	?>
196	</table>
197	</div>
198
199	<?php } else{
200	printf("<span>%s</span>", __('There is not enough sales data to generate a statement', 'tutor'));
201	} ?>
202
203	</div>
204
205	<?php
206
207	if ($statements->count){
208	?>
209	<div class="tutor-pagination">
210	<?php
211	echo paginate_links( array(
212	'format' => '?current_page=%#%',
213	'current' => $current_page,
214	'total' => ceil($statements->count/$per_page)
215	) );
216	?>
217
218	</div>
219
220	<?php
221	}
222
223