function gdlr_lms_payment_evidence_option() { global $wpdb; $temp_sql = "SELECT id, course_id, student_id, payment_info, payment_date, attachment FROM " . $wpdb->prefix . "gdlrpayment "; $temp_sql .= "WHERE payment_status = 'submitted'"; $results = $wpdb->get_results($temp_sql); ?> <div class="wrap"> <h2><?php _e('Evidence Of Payment', 'gdlr-lms'); ?> </h2> <?php if (empty($results)) { echo '<div style="margin-top: 20px;">' . __('No record found', 'gdlr-lms') . '</div>'; return; } ?> <table class="gdlr-lms-table"> <tr> <th><?php _e('Name', 'gdlr-lms'); ?> </th> <th><?php _e('Course', 'gdlr-lms'); ?> </th> <th><?php _e('Code', 'gdlr-lms'); ?> </th> <th><?php _e('Submitted Date', 'gdlr-lms'); ?> </th> <th><?php _e('Total Price', 'gdlr-lms'); ?> </th> <th><?php _e('View Attachment', 'gdlr-lms'); ?> </th> </tr> <?php foreach ($results as $result) { $payment_info = unserialize($result->payment_info); $payment_info['code'] = empty($payment_info['code']) ? '' : $payment_info['code']; $student_info = get_userdata($result->student_id); echo '<tr>'; echo '<td class="evidence-of-payment-name">'; echo $student_info->first_name . ' ' . $student_info->last_name; echo '<div class="evidence-of-payment-name-hover" >'; foreach ($payment_info as $key => $value) { echo '<div class="evidence-of-payment-info">'; echo '<span class="head">' . $key . ' :</span>'; if ($key == 'price') { echo '<span class="tail">' . gdlr_lms_money_format($value) . '</span>'; } else { echo '<span class="tail">' . $value . '</span>'; } echo '</div>'; } echo '</div>'; // evd-of-payment-name-hover echo '</td>'; // evd-of-payment-name echo '<td>' . $result->course_id . '</td>'; echo '<td>' . $payment_info['code'] . '</td>'; echo '<td>' . gdlr_lms_date_format($result->payment_date) . '</td>'; echo '<td>' . gdlr_lms_money_format($payment_info['price']) . '</td>'; echo '<td>'; echo '<a data-rel="gdlr-lms-lightbox" data-lb-open="evidence-validation" >' . __('View Attachment', 'gdlr-lms') . '</a>'; gdlr_lms_lightbox_evidence_form($result, $payment_info); echo '</td>'; echo '</tr>'; } ?> </table> </div> <?php }
function gdlr_lms_transaction_option() { ?> <div class="wrap"> <h2><?php _e('Transaction List', 'gdlr-lms'); ?> </h2> <form class="gdlr-lms-transaction-form" method="GET" action=""> <div class="gdlr-lms-transaction-form-row"> <span class="gdlr-lms-head"><?php _e('Search transaction by :', 'gdlr-lms'); ?> </span> <div class="gdlr-combobox-wrapper"> <select name="selector" > <option value="name" <?php echo !empty($_GET['selector']) && $_GET['selector'] == 'name' ? 'selected' : ''; ?> ><?php _e('Name', 'gdlr-lms'); ?> </option> <option value="code" <?php echo !empty($_GET['selector']) && $_GET['selector'] == 'code' ? 'selected' : ''; ?> ><?php _e('Code', 'gdlr-lms'); ?> </option> </select> </div> <div class="clear"></div> </div> <div class="gdlr-lms-transaction-form-row"> <span class="gdlr-lms-head"><?php _e('Keywords :', 'gdlr-lms'); ?> </span> <input type="text" name="keywords" value="<?php echo !empty($_GET['keywords']) ? $_GET['keywords'] : ''; ?> " /> <input type="hidden" name="page" value="lms-transaction" /> <input type="submit" value="<?php _e('Search!', 'gdlr-lms'); ?> " /> <div class="clear"></div> </div> </form> <table class="gdlr-lms-table"> <tr> <th><?php _e('ID', 'gdlr-lms'); ?> </th> <th><?php _e('Name', 'gdlr-lms'); ?> </th> <th><?php _e('Course', 'gdlr-lms'); ?> </th> <th><?php _e('Type', 'gdlr-lms'); ?> </th> <th><?php _e('Price', 'gdlr-lms'); ?> </th> <th><?php _e('Status', 'gdlr-lms'); ?> </th> <th><?php _e('Code', 'gdlr-lms'); ?> </th> <th><?php _e('Booked/Paid Date', 'gdlr-lms'); ?> </th> </tr> <?php global $wpdb; $temp_sql = "SELECT id, course_id, student_id, payment_info, payment_status, payment_date, price "; $temp_sql .= "FROM " . $wpdb->prefix . "gdlrpayment "; $temp_sql .= "WHERE price != 0 "; if (!empty($_GET['selector']) && !empty($_GET['keywords'])) { if ($_GET['selector'] == 'name') { $user_array = array(0); $users = new WP_User_Query(array('meta_query' => array('relation' => 'OR', array('key' => 'first_name', 'value' => $_GET['keywords'], 'compare' => 'LIKE'), array('key' => 'last_name', 'value' => $_GET['keywords'], 'compare' => 'LIKE')))); $users_found = $users->get_results(); foreach ($users_found as $user) { if (!in_array($user->ID, $user_array)) { $user_array[] = $user->ID; } } $users = new WP_User_Query(array('search' => '*' . esc_attr($_GET['keywords']) . '*', 'search_columns' => array('user_login', 'user_nicename'))); $users_found = $users->get_results(); foreach ($users_found as $user) { if (!in_array($user->ID, $user_array)) { $user_array[] = $user->ID; } } $temp_sql .= 'AND student_id IN (' . implode(",", $user_array) . ') '; } else { if ($_GET['selector'] == 'code') { $temp_sql .= 'AND payment_info LIKE \'%' . $_GET['keywords'] . '%\' '; } } } $temp_sql .= "ORDER BY id desc"; $results = $wpdb->get_results($temp_sql); // handle pagination global $gdlr_lms_option; $record_num = count($results); $current_page = empty($_GET['paged']) ? 1 : intval($_GET['paged']); $record_per_page = empty($gdlr_lms_option['transaction-record']) ? 30 : intval($gdlr_lms_option['transaction-record']); $max_num_page = ceil($record_num / $record_per_page); for ($i = $record_per_page * ($current_page - 1); $i < $record_num && $i < $record_per_page * $current_page; $i++) { $result = $results[$i]; $course_val = gdlr_lms_decode_preventslashes(get_post_meta($result->course_id, 'gdlr-lms-course-settings', true)); $course_options = empty($course_val) ? array() : json_decode($course_val, true); $payment_info = unserialize($result->payment_info); $payment_info['code'] = empty($payment_info['code']) ? '' : $payment_info['code']; $student_info = get_userdata($result->student_id); echo '<tr>'; echo '<td>' . $result->id . '</td>'; echo '<td class="evidence-of-payment-name">'; echo $student_info->first_name . ' ' . $student_info->last_name; echo '<div class="evidence-of-payment-name-hover" >'; foreach ($payment_info as $key => $value) { echo '<div class="evidence-of-payment-info">'; echo '<span class="head">' . $key . ' :</span>'; if ($key == 'price') { echo '<span class="tail">' . gdlr_lms_money_format($value) . '</span>'; } else { echo '<span class="tail">' . $value . '</span>'; } echo '</div>'; } echo '</div>'; // evd-of-payment-name-hover echo '</td>'; // evd-of-payment-name echo '<td>' . $course_options['course-code'] . $result->course_id . '</td>'; echo '<td>'; echo $course_options['online-course'] == 'enable' ? __('Online', 'gdlr-lms') : __('Onsite', 'gdlr-lms'); echo '</td>'; echo '<td>' . gdlr_lms_money_format(number_format_i18n($result->price, 2)) . '</td>'; echo '<td>' . $result->payment_status . '</td>'; echo '<td>' . $payment_info['code'] . '</td>'; echo '<td>' . gdlr_lms_date_format($result->payment_date) . '</td>'; echo '</tr>'; } ?> </table> <?php // print pagination if ($max_num_page > 1) { $page_var = $_GET; echo '<div class="gdlr-lms-pagination">'; if ($current_page > 1) { $page_var['paged'] = intval($current_page) - 1; echo '<a class="prev page-numbers" href="' . esc_url(add_query_arg($page_var)) . '" >'; echo __('‹ Previous', 'gdlr-lms') . '</a>'; } for ($i = 1; $i <= $max_num_page; $i++) { $page_var['paged'] = $i; if ($i == $current_page) { echo '<span class="page-numbers current" href="' . esc_url(add_query_arg($page_var)) . '" >' . $i . '</span>'; } else { echo '<a class="page-numbers" href="' . esc_url(add_query_arg($page_var)) . '" >' . $i . '</a>'; } } if ($current_page < $max_num_page) { $page_var['paged'] = intval($current_page) + 1; echo '<a class="next page-numbers" href="' . esc_url(add_query_arg($page_var)) . '" >'; echo __('Next ›', 'gdlr-lms') . '</a>'; } echo '</div>'; } ?> </div> <?php }
function gdlr_lms_print_course_info($course_options, $options = array('instructor', 'type', 'date', 'place', 'seat'), $additional_code = '') { echo '<div class="gdlr-lms-course-info">'; foreach ($options as $value) { switch ($value) { case 'instructor': if (!empty($course_options['author_id'])) { $user_info = get_user_meta($course_options['author_id']); $author_id = $course_options['author_id']; } else { global $post; $user_info = get_user_meta($post->post_author); $author_id = $post->post_author; } if (!empty($user_info)) { echo '<div class="gdlr-lms-info" >'; echo '<span class="head">' . __('Instructor', 'gdlr-lms') . '</span>'; //echo '<span class="tail">' . $user_info['first_name'][0] . ' ' . $user_info['last_name'][0] . '</span>'; echo '<span class="tail"><a href="' . get_author_posts_url($author_id) . '" >' . $user_info['first_name'][0] . ' ' . $user_info['last_name'][0] . '</a></span>'; echo '</div>'; } break; case 'type': if (!empty($course_options['online-course'])) { echo '<div class="gdlr-lms-info" >'; echo '<span class="head">' . __('Type', 'gdlr-lms') . '</span>'; echo '<span class="tail">'; if ($course_options['online-course'] == 'enable') { echo __('Online Course', 'gdlr-lms'); } else { echo __('Onsite Course', 'gdlr-lms'); } echo '</span>'; echo '</div>'; } break; case 'date': if (!empty($course_options['start-date'])) { echo '<div class="gdlr-lms-info" >'; echo '<span class="head">' . __('Date', 'gdlr-lms') . '</span>'; echo '<span class="tail">' . gdlr_lms_date_format($course_options['start-date']); echo empty($course_options['end-date']) ? '' : ' - ' . gdlr_lms_date_format($course_options['end-date']); echo '</span>'; echo '</div>'; } break; case 'time': if (!empty($course_options['course-time'])) { echo '<div class="gdlr-lms-info" >'; echo '<span class="head">' . __('Time', 'gdlr-lms') . '</span>'; echo '<span class="tail">' . $course_options['course-time'] . '</span>'; echo '</div>'; } break; case 'place': if ($course_options['online-course'] == 'disable' && !empty($course_options['location'])) { echo '<div class="gdlr-lms-info" >'; echo '<span class="head">' . __('Place', 'gdlr-lms') . '</span>'; echo '<span class="tail">' . $course_options['location'] . '</span>'; echo '</div>'; } break; case 'price': $price = empty($course_options['discount-price']) ? $course_options['price'] : $course_options['discount-price']; echo '<div class="gdlr-lms-info" >'; echo '<span class="head">' . __('Price', 'gdlr-lms') . '</span>'; echo '<span class="tail">'; echo empty($price) ? __('Free', 'gdlr-lms') : gdlr_lms_money_format($price); echo '</span>'; echo '</div>'; break; case 'seat': if ($course_options['online-course'] == 'disable' && !empty($course_options['max-seat'])) { echo '<div class="gdlr-lms-info" >'; echo '<span class="head">' . __('Seat', 'gdlr-lms') . '</span>'; echo '<span class="tail">' . intval($course_options['booked-seat']) . '/' . intval($course_options['max-seat']) . '</span>'; echo '</div>'; } break; case 'rating': gdlr_lms_print_course_rating(get_the_ID()); break; } } echo $additional_code; echo '</div>'; }