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

tutor / templates / dashboard / earning / statements.php

tutor / templates / dashboard / earning Last commit date

chart-body.php 4 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 4 years ago statement.php 4 years ago statements.php 4 years ago

statements.php

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