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

tutor / templates / dashboard / earning / statements.php

tutor / templates / dashboard / earning Last commit date

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

statements.php

218 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 = 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
118
119	<?php
120
121	if ($statements->count) {
122	?>
123
124	<p class="tutor-dashboard-pagination-results-stats">
125
126	<?php
127	echo sprintf(__('Showing results %d to %d of %d', 'tutor'), $offset +1, min($statements->count, $offset +1+tutor_utils()->count($statements->results)), $statements->count) ;
128	?>
129	</p>
130
131	<div class="tutor-dashboard-statement-table-wrap">
132	<table class="tutor-dashboard-statement-table tutor-table">
133	<tr>
134	<th><?php _e('Course Info', 'tutor'); ?></th>
135	<th><?php _e('Earning', 'tutor'); ?></th>
136	<th><?php _e('Commission', 'tutor'); ?></th>
137	<th><?php _e('Deduct', 'tutor'); ?></th>
138	</tr>
139
140	<?php
141	foreach ($statements->results as $statement){
142	?>
143	<tr>
144	<td>
145
146	<p class="small-text">
147	<span class="statement-order-<?php echo $statement->order_status; ?>"><?php echo $statement->order_status; ?></span>
148	<strong><?php _e('Date:', 'tutor') ?></strong>
149	<i><?php echo date_i18n(get_option('date_format', strtotime($statement->created_at))).' '.date_i18n(get_option('time_format', strtotime($statement->created_at))) ?></i>
150	</p>
151
152	<p>
153	<a href="<?php echo get_the_permalink($statement->course_id); ?>" target="_blank">
154	<?php echo $statement->course_title; ?>
155	</a>
156	</p>
157
158	<p>
159	<strong><?php _e('Price: ', 'tutor'); ?></strong>
160	<?php echo tutor_utils()->tutor_price($statement->course_price_total); ?>
161	</p>
162
163	<p class="small-text"><strong><?php _e('Order ID'); ?> #<?php echo $statement->order_id; ?></strong></p>
164
165	<?php
166	$order = new WC_Order($statement->order_id);
167	echo '<div class="statement-address"> <strong>Purchaser</strong> <address>'.$order->get_formatted_billing_address().'</address></div>';
168	?>
169	</td>
170	<td>
171	<p><?php echo tutor_utils()->tutor_price($statement->instructor_amount); ?></p>
172	<p class="small-text"> <?php _e('As per'); ?> <?php echo $statement->instructor_rate ?> (<?php echo $statement->commission_type ?>) </p>
173	</td>
174
175	<td>
176	<p><?php echo tutor_utils()->tutor_price($statement->admin_amount); ?> </p>
177	<p class="small-text"><?php _e('Rate', 'tutor'); ?> : <?php echo $statement->admin_rate; ?> </p>
178	<p class="small-text"><?php _e('Type', 'tutor'); ?> : <?php echo $statement->commission_type; ?> </p>
179
180	</td>
181
182	<td>
183	<p><?php echo $statement->deduct_fees_name; ?> <?php echo tutor_utils()->tutor_price($statement->deduct_fees_amount); ?>
184	</p>
185	<p class="small-text"><?php _e('Type', 'tutor'); ?> : <?php echo $statement->deduct_fees_type; ?> </p>
186	</td>
187	</tr>
188	<?php
189	}
190	?>
191	</table>
192	</div>
193
194	<?php } else{
195	printf("<span>%s</span>", __('There is not enough sales data to generate a statement', 'tutor'));
196	} ?>
197
198	</div>
199
200	<?php
201
202	if ($statements->count){
203	?>
204	<div class="tutor-pagination">
205	<?php
206	echo paginate_links( array(
207	'format' => '?current_page=%#%',
208	'current' => $current_page,
209	'total' => ceil($statements->count/$per_page)
210	) );
211	?>
212
213	</div>
214
215	<?php
216	}
217
218