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

tutor / templates / dashboard / earning / statements.php

tutor / templates / dashboard / earning Last commit date

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

statements.php

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