public function single_lesson_handler() { global $post; // Preview Lessons shouldn't ignore this rule. if (WooThemes_Sensei_Utils::is_preview_lesson($post->ID)) { return; } $course_id = get_post_meta($post->ID, '_lesson_course', true); // User already started this course, so ideally, we shouldn't restrict access. if (WooThemes_Sensei_Utils::user_started_course($post->ID, wp_get_current_user()->ID)) { return; } // This happens if the lesson isn't locked itself. if (memberful_can_user_access_post(wp_get_current_user()->ID, $post->ID)) { if (!memberful_can_user_access_post(wp_get_current_user()->ID, $course_id)) { // The user doesn't have access to this post, so he shouldn't have actions on it. remove_all_actions('sensei_lesson_single_meta'); // Now the funky filtering part. remove_action('the_content', 'memberful_wp_protect_content'); add_action('the_content', array($this, 'single_lesson_special_content_filter'), -10); } } else { // The user doesn't have access to this post, so he shouldn't have actions on it. remove_all_actions('sensei_lesson_single_meta'); } }
/** * Sets up the object course query * that will be used int he render method. * * @since 1.9.0 */ protected function setup_course_query() { // course query parameters to be used for all courses $query_args = array('post_type' => 'course', 'post_status' => 'publish', 'posts_per_page' => 1000, 'orderby' => $this->orderby, 'order' => $this->order); // get all the courses that has a product attached $all_courses_query = new WP_Query($query_args); $paid_courses_not_taken = array(); // look through all course and find the purchasable ones that user has not purchased foreach ($all_courses_query->posts as $course) { // only keep the courses with a product including only courses that the user not taking $course_product_id = get_post_meta($course->ID, '_course_woocommerce_product', true); if (is_numeric($course_product_id) && !WooThemes_Sensei_Utils::user_started_course($course->ID, get_current_user_id())) { $paid_courses_not_taken[] = $course->ID; } } // end foreach // setup the course query again and only use the course the user has not purchased. // this query will be loaded into the global WP_Query in the render function. $query_args['post__in'] = $paid_courses_not_taken; $query_args['posts_per_page'] = $this->number; $this->query = new WP_Query($query_args); }
} global $post, $woothemes_sensei, $current_user; // Get User Meta get_currentuserinfo(); // Handle Quiz Completion do_action('sensei_complete_quiz'); // Get Frontend data $user_quiz_grade = $woothemes_sensei->quiz->data->user_quiz_grade; $quiz_lesson = $woothemes_sensei->quiz->data->quiz_lesson; $quiz_grade_type = $woothemes_sensei->quiz->data->quiz_grade_type; $user_lesson_end = $woothemes_sensei->quiz->data->user_lesson_end; $user_lesson_complete = $woothemes_sensei->quiz->data->user_lesson_complete; $lesson_quiz_questions = $woothemes_sensei->quiz->data->lesson_quiz_questions; // Check if the user has started the course $lesson_course_id = absint(get_post_meta($quiz_lesson, '_lesson_course', true)); $has_user_start_the_course = WooThemes_Sensei_Utils::user_started_course($lesson_course_id, $current_user->ID); // Get the meta info $quiz_passmark = absint(get_post_meta($post->ID, '_quiz_passmark', true)); $quiz_passmark_float = (double) $quiz_passmark; ?> <div class="lesson-meta"> <?php // Display user's quiz status $status = WooThemes_Sensei_Utils::sensei_user_quiz_status_message($quiz_lesson, $current_user->ID); echo '<div class="sensei-message ' . $status['box_class'] . '">' . $status['message'] . '</div>'; // Lesson Quiz Meta if (0 < count($lesson_quiz_questions)) { $question_count = 1; ?> <form method="POST" action="<?php echo esc_url(get_permalink());
function savedquest_options() { if (!current_user_can('manage_options')) { wp_die(__('You do not have sufficient permissions to access this page.')); } echo '<div class="wrap" style="background:#fff;">'; if (isset($_GET['tab'])) { $tab = $_GET['tab']; } else { $tab = ""; } saved_admin_tab($tab); if ($tab == "quiztaken" or $tab == "") { ?> <table class="wp-list-table widefat fixed striped pages" width="100%" style="border-spacing: 0; text-align:center;" > <tr> <th>Lesson ID</th> <th>Lesson Title</th> <th>Number Of Questions</th> <th>Question Answered</th> <th>Unanswered Question</th> <th>User</th> <th>User Id</th> <th>DATE And Time</th> </tr> <?php $svequiz = get_option('savequiz_list'); ?> <?php foreach ($svequiz as $quizdata) { ?> <tr> <td><?php echo $quizdata['lesson_id']; ?> </td> <td><?php echo $quizdata['lesson_title']; ?> </td> <td><?php echo $quizdata['total_questtion']; ?> </td> <td><?php echo $quizdata['question_answered']; ?> (<?php echo get_percentage($quizdata['total_questtion'], $quizdata['question_answered']) . "%"; ?> )</td> <td><?php echo $quizdata['remaining_question']; ?> (<?php echo 100 - get_percentage($quizdata['total_questtion'], $quizdata['question_answered']) . "%"; ?> )</td> <td><?php echo $quizdata['fullname']; ?> </td> <td><?php echo $quizdata['user_id']; ?> </td> <td><?php echo $quizdata['DATETIME']; ?> </td> </tr> <?php } ?> </table> <?php } elseif ($tab == "timesession") { $user_last_login_logout = get_option('user_last_login_logout'); ?> <br /><br/> <table class="wp-list-table widefat fixed striped pages" width="100%" style="border-spacing: 0; text-align:center;" > <tr> <th>User ID</th> <th>Full Name</th> <th>Last Login</th> <th>Last Logout</th> <th>Amout of Time Spent</th> <th>Role</th> </tr> <?php $svequiz = get_option('savequiz_list'); ?> <?php foreach ($user_last_login_logout as $last_login_logout) { ?> <?php if ($last_login_logout['user_id'] != "") { ?> <?php $user_info = get_userdata($last_login_logout['user_id']); ?> <tr> <td><?php echo $last_login_logout['user_id']; ?> </td> <td><?php echo $user_info->display_name; ?> </td> <td><?php echo gettime_st($last_login_logout['logintime']); ?> </td> <td><?php echo gettime_st($last_login_logout['logouttime']); ?> </td> <?php if ($last_login_logout['logouttime'] != "") { $date1 = date_create($last_login_logout['logintime']); $date2 = date_create($last_login_logout['logouttime']); $diff = date_diff($date1, $date2); $diftime = $diff->format("%h Hours %i Minute %s Seconds"); } else { $diftime = ""; } ?> <th><?php echo $diftime; ?> </th> <td><?php echo implode(', ', $user_info->roles); ?> </td> </tr> <?php } ?> <?php } ?> </table><br /><br /> <?php } elseif ($tab == "timequizecompleted") { global $woothemes_sensei, $post, $current_user, $wp_query, $learner_user; echo "<table class='wp-list-table widefat fixed striped pages'>"; $allUsers = get_users(); echo "<tr>\r\r\n\t\t\t\t<th>User</th>\r\r\n\t\t\t\t<th>Courses</th>\r\r\n\t\t\t\t<th>Percentage Incomplete</th>\r\r\n\t\t\t\t<th>Percentage Complete</th>\r\r\n\t\t\t\t<th>Percentage Competent</th>\r\r\n\t\t\t\t<th>Percentage Attempted</th>\r\r\n\t\t\t\t<th>Length of time Course Completed</th>\r\r\n\t\t\t </tr>"; foreach ($allUsers as $user) { $args = array('post_type' => 'course'); $courses = get_posts($args); $i = 1; foreach ($courses as $course) { $course_user_grade = WooThemes_Sensei_Utils::sensei_course_user_grade($course->ID, $user->ID); $course_status = WooThemes_Sensei_Utils::user_course_status($course->ID, $user->ID); $course_status_update = get_comment_meta($course_status->comment_ID); if (!empty($course_status)) { $displayed_lessons = array(); $modules = Sensei()->modules->get_course_modules(intval($course->ID)); foreach ($modules as $module) { $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'meta_query' => array(array('key' => '_lesson_course', 'value' => intval($course->ID), 'compare' => '=')), 'tax_query' => array(array('taxonomy' => Sensei()->modules->taxonomy, 'field' => 'id', 'terms' => intval($module->term_id))), 'meta_key' => '_order_module_' . $module->term_id, 'orderby' => 'meta_value_num date', 'order' => 'ASC', 'suppress_filters' => 0); $lessons = get_posts($args); if (count($lessons) > 0) { $html .= '<h3>' . $module->name . '</h3>' . "\n"; $count = 0; foreach ($lessons as $lesson_item) { $lesson_grade = ' n/a'; $has_questions = get_post_meta($lesson_item->ID, '_quiz_has_questions', true); if ($has_questions) { $lesson_status = WooThemes_Sensei_Utils::user_lesson_status($lesson_item->ID, $user->ID); // Get user quiz grade $lesson_grade = get_comment_meta($lesson_status->comment_ID, 'grade', true); if ($lesson_grade) { $lesson_grade .= '%'; } $modulequizdata = get_comment_meta($lesson_status->comment_ID); //echo "<a href='".get_post_permalink($lesson_item->ID)."'>".$lesson_item->post_title."</a><br />"; $modulequestion_asked = count(explode(",", $modulequizdata['questions_asked'][0])); $moduleanswered_quiz = count(unserialize($modulequizdata['quiz_answers'][0])); //echo "number of questions:".$modulequestion_asked."<br />"; //echo "number of Answered:".$moduleanswered_quiz."<br />"; if ($course_status->comment_approved == "complete") { $attempted = "(100%)"; } else { if ($modulequizdata['grade'][0] == "") { if ($lesson_status->comment_approved == "passed") { $attempted = 'P/Q'; } else { if ($modulequestion_asked >= $moduleanswered_quiz) { if ($modulequizdata['quiz_answers'][0] == "") { $attempted = ""; } else { $attempted = "( " . get_percentage($modulequestion_asked, $moduleanswered_quiz) . "% ) Saved"; } } } } else { $attempted = "( " . get_percentage($modulequestion_asked, $moduleanswered_quiz) . "% )"; } //echo "<pre>"; //echo "Attempted:".$attempted."<br />"; //echo $user->user_email."<br />"; //echo $modulequizdata['grade'][0]."<br />"; //echo $modulequizdata['quiz_answers'][0]."<br />"; //print_r($lesson_status); //echo "</pre>"; } } $html .= '<a href="' . esc_url(get_permalink($lesson_item->ID)) . '" title="' . esc_attr(sprintf(__('Start %s', 'woothemes-sensei'), $lesson_item->post_title)) . '">' . esc_html(sprintf(__('%s', 'woothemes-sensei'), $lesson_item->post_title)) . '</a> ' . $attempted . '<br />'; $displayed_lessons[] = $lesson_item->ID; } } } $args = array('post_type' => 'lesson', 'posts_per_page' => -1, 'suppress_filters' => 0, 'meta_key' => '_order_' . $course->ID, 'orderby' => 'meta_value_num date', 'order' => 'ASC', 'meta_query' => array(array('key' => '_lesson_course', 'value' => intval($course->ID))), 'post__not_in' => $displayed_lessons); $lessons = get_posts($args); //echo "Number of lesson in a course: ".count($lessons); if (0 < count($lessons)) { $html .= '<h3>' . __('Other Lessons', 'woothemes-sensei') . '</h3>' . "\n"; } if ($course_status_update['percent'][0] == 100) { $date1 = date_create($course_status_update['start'][0]); $date2 = date_create($course_status->comment_date); $diff = date_diff($date1, $date2); $diftime = $diff->format("%h Hours %i Minute %s Seconds"); } else { $diftime = "course not completed yet."; } $allcourseid[] = $course->ID; $incomplete = 100 - $course_status_update['percent'][0]; echo "<tr><td>"; echo $user->user_email; echo "</td>"; echo "<td>"; echo "<a href='" . get_post_permalink($course->ID) . "'>" . $course->post_title . "</a>"; echo "</td>"; echo "<td>"; echo $incomplete . "%"; echo "</td>"; echo "<td>"; echo $course_status_update['percent'][0] . "%"; echo "</td>"; echo "<td>"; echo $course_user_grade . "%"; echo "</td>"; echo "<td>"; echo $html; $html = ""; foreach ($lessons as $lesson_item) { $lesson_grade = 'n/a'; $has_questions = get_post_meta($lesson_item->ID, '_quiz_has_questions', true); if ($has_questions) { $lesson_status = WooThemes_Sensei_Utils::user_lesson_status($lesson_item->ID, $user->ID); // Get user quiz grade $lesson_grade = get_comment_meta($lesson_status->comment_ID, 'grade', true); if ($lesson_grade) { $lesson_grade .= '%'; } } $quizdata = get_comment_meta($lesson_status->comment_ID); //echo "<h1>Comment</h1>"; //print_r(get_comment_meta( $lesson_status->comment_ID )); //echo "<h1>LESSON STATUS</h1>"; //print_r($lesson_status); echo "<a href='" . get_post_permalink($lesson_item->ID) . "'>" . $lesson_item->post_title . "</a> "; //print_r($quizdata); $question_asked = count(explode(",", $quizdata['questions_asked'][0])); $answered_quiz = count(unserialize($quizdata['quiz_answers'][0])); if ($quizdata['grade'][0] == "") { if ($question_asked > $answered_quiz) { echo "( " . get_percentage($question_asked, $answered_quiz) . "% )"; } } else { echo "(100%)"; } echo '<br />'; } // End For Loop echo "</td>"; echo "<td>"; echo $diftime; echo "</td>"; echo "</tr>"; //echo $course->post_title." (".$course_status_update['percent'][0]."% Complete) (". $incomplete . "% incomplete) (". $course_user_grade . "% Competent)<br />"; $i++; } } } echo "</table>"; } elseif ($tab == "threshold") { //declare the wpdb for custom query global $wpdb; //check for submitted data if (isset($_POST['submittreshold']) && ($_POST['submittreshold'] = "submit")) { // declare users and variables $allUsers = get_users(); $modules_completed = $_POST['completionpermonth']; $courseid = $_POST['course']; $course_name = get_the_title($courseid); $array_to_csv = array(array('Student Name', 'Course Name ')); //user loop ----- loop user get the groups and course the course they take foreach ($allUsers as $user) { //declare course function calls $course_user_grade = WooThemes_Sensei_Utils::sensei_course_user_grade($courseid, $user->ID); $user_course_status = WooThemes_Sensei_Utils::user_course_status($courseid, $user->ID); $course_status_info = get_comment_meta($user_course_status->comment_ID); $started_course = WooThemes_Sensei_Utils::user_started_course($courseid, $user->ID); $course_status = WooThemes_Sensei_Utils::sensei_user_course_status_message($courseid, $user->ID); $completed_course = WooThemes_Sensei_Utils::user_completed_course($user_course_status); //get the user groups $useringroup = new Groups_User($user->ID); $user_groups = $useringroup->__get('groups'); $displayed_lessons = array(); //declare and get module values $modules = Sensei()->modules->get_course_modules(intval($courseid)); $modules_content = Sensei()->modules->course_module_content(intval($courseid)); //echo "<pre>"; //echo $user->user_email."<br />"; //echo "sensei_user_course_status_message: "; //print_r($course_status); //echo "<br />"; //echo "started_course: "."<br />"; $course_status_info['start'][0]; $datenow = date('Y-m-d h:i:s'); $date1 = date_create($course_status_info['start'][0]); $date2 = date_create($datenow); $diff = date_diff($date1, $date2); $diftime = $diff->format("%m"); if ($diftime < 1) { $diftime = 1; } //echo "</pre>"; //module loop per user foreach ($modules as $module) { $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'meta_query' => array(array('key' => '_lesson_course', 'value' => intval($courseid), 'compare' => '=')), 'tax_query' => array(array('taxonomy' => Sensei()->modules->taxonomy, 'field' => 'id', 'terms' => intval($module->term_id))), 'meta_key' => '_order_module_' . $module->term_id, 'orderby' => 'meta_value_num date', 'order' => 'ASC', 'suppress_filters' => 0); $lessons = get_posts($args); $num_of_lesson = count($lessons); //lessson loop per user foreach ($lessons as $lesson_item) { $is_lesson_completed = WooThemes_Sensei_Utils::user_completed_lesson($lesson_item->ID, $user->ID); if ($is_lesson_completed == 1) { $lesson_completed[] = $is_lesson_completed; } } //echo "lesson completed:". count($lesson_completed)."<br />"; if (count($lesson_completed) > 0) { if ($num_of_lesson == count($lesson_completed)) { $completed_modules_per_user[] = 1; $total_module_passed[] = 1; //echo "---Module completed <br />"; } else { //echo "---Module not completed <br />"; } } else { //echo "---Module not completed <br />"; } unset($lesson_completed); unset($completed_modules_per_user); } $overaalltotal_module_passed = count($total_module_passed); //echo $overaalltotal_module_passed . " module being passed"; //loop throughout the user group under a user if (is_array($user_groups)) { foreach ($user_groups as $user_group) { if ($user_group->group_id == $_POST['group']) { if (!empty($user_course_status)) { $modules_completed_from_groups = $user_group->description; if ($modules_completed == "") { $modules_completed = $modules_completed_from_groups; } $num_of_module_x_difftime = $modules_completed * $diftime; //echo "<br />num_of_module_x_difftime:".$num_of_module_x_difftime; if ($overaalltotal_module_passed >= $num_of_module_x_difftime) { $array_to_csv[] = array($user->display_name, $course_name); //$userid_within_group[$user->user_email] = $user->ID; } } } //echo $user_group->group_id."<br />"; } } unset($total_module_passed); } //echo "<pre>"; //echo $modules_completed; //print_r($array_to_csv); //echo "</pre>"; convert_to_csv($array_to_csv, 'report-' . md5(date('Y-m-d h:i:s')) . '.csv', ','); } ?> <div class="form-wrap" style="padding:20px;"> <form action="" method="post"> <div> <label> Group: </label> <?php $groups = $wpdb->get_results('SELECT * FROM `wp_groups_group`'); ?> <select name="group"> <?php foreach ($groups as $group) { echo "<option value='" . $group->group_id . "'>"; echo $group->name; echo "</option>"; } ?> </select> </div> <div> <label> Course: </label> <?php $course = new WP_Query(array('post_type' => 'course')); ?> <select name="course"> <?php // The Loop if ($course->have_posts()) { while ($course->have_posts()) { $course->the_post(); echo '<option value="' . $course->post->ID . '">' . get_the_title() . '</option>'; } } /* Restore original Post Data */ ?> </select> <?php wp_reset_postdata(); ?> </div> <div> <label> How many modules should be completed by now? </label> <input type="text" name="completionpermonth" /> </div><br /><br /> <input type="submit" class="button button-primary" name="submittreshold" value="submit" /> </form> </div> <?php } elseif ($tab == "incremental-progress") { wp_enqueue_script('jquery-ui-datepicker'); wp_enqueue_style('jquery-style', 'http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.2/themes/smoothness/jquery-ui.css'); //declare the wpdb for custom query global $wpdb; //check for submitted data if (isset($_POST['submitincrenmental']) && ($_POST['submitincrenmental'] = "submit")) { // declare users and variables $allUsers = get_users(); $modules_completed = $_POST['completionpermonth']; $courseid = $_POST['course']; $course_name = get_the_title($courseid); $array_to_csv = array(array('Student Name', 'Course Name ', 'Lesson Title')); //user loop ----- loop user get the groups and course the course they take foreach ($allUsers as $user) { //declare course function calls $course_user_grade = WooThemes_Sensei_Utils::sensei_course_user_grade($courseid, $user->ID); $user_course_status = WooThemes_Sensei_Utils::user_course_status($courseid, $user->ID); $course_status_info = get_comment_meta($user_course_status->comment_ID); $started_course = WooThemes_Sensei_Utils::user_started_course($courseid, $user->ID); $course_status = WooThemes_Sensei_Utils::sensei_user_course_status_message($courseid, $user->ID); $completed_course = WooThemes_Sensei_Utils::user_completed_course($user_course_status); //get the user groups $useringroup = new Groups_User($user->ID); $user_groups = $useringroup->__get('groups'); $displayed_lessons = array(); //declare and get module values $modules = Sensei()->modules->get_course_modules(intval($courseid)); $modules_content = Sensei()->modules->course_module_content(intval($courseid)); $course_status_info['start'][0]; $datenow = date('Y-m-d h:i:s'); $date1 = date_create($course_status_info['start'][0]); $date2 = date_create($datenow); $diff = date_diff($date1, $date2); $diftime = $diff->format("%m"); if ($diftime < 1) { $diftime = 1; } //echo "</pre>"; //module loop per user foreach ($modules as $module) { $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'meta_query' => array(array('key' => '_lesson_course', 'value' => intval($courseid), 'compare' => '=')), 'tax_query' => array(array('taxonomy' => Sensei()->modules->taxonomy, 'field' => 'id', 'terms' => intval($module->term_id))), 'meta_key' => '_order_module_' . $module->term_id, 'orderby' => 'meta_value_num date', 'order' => 'ASC', 'suppress_filters' => 0); $lessons = get_posts($args); $num_of_lesson = count($lessons); //lessson loop per user foreach ($lessons as $lesson_item) { $is_lesson_completed = WooThemes_Sensei_Utils::user_completed_lesson($lesson_item->ID, $user->ID); $lesson_status = WooThemes_Sensei_Utils::user_lesson_status($lesson_item->ID, $user->ID); $modulequizdata = get_comment_meta($lesson_status->comment_ID); if (!empty($lesson_status->comment_date)) { echo "<pre>"; //echo $lesson_status->comment_date."<br />"; //echo $_POST['date1']."<br />"; $lesson_completion_date = date("Y-m-d", strtotime($lesson_status->comment_date)); //echo "<br />"; //echo $_POST['date2']."<br />"; //echo "lesson is completed:".$is_lesson_completed."<br />"; //print_r($lesson_item); echo "</pre>"; } if ($is_lesson_completed == 1) { $date1 = strtotime($_POST['date1']); $date2 = strtotime($_POST['date2']); $lesson_completion_date_str = strtotime($lesson_completion_date); if ($lesson_completion_date_str > $date1 && $lesson_completion_date_str < $date2) { //echo "lesson is completed:".$is_lesson_completed."<br />"; //echo "user ".$user->display_name." pass this". $lesson_completion_date; $user_id_onrange[$user->ID] = $lesson_item->post_title; } } } //echo "lesson completed:". count($lesson_completed)."<br />"; } //loop throughout the user group under a user if (is_array($user_groups)) { foreach ($user_groups as $user_group) { if ($user_group->group_id == $_POST['group']) { if (!empty($user_course_status)) { if (array_key_exists($user->ID, $user_id_onrange)) { $array_to_csv[] = array($user->display_name, $course_name, $user_id_onrange[$user->ID]); } } } //echo $user_group->group_id."<br />"; } } } //print_r($user_id_onrange); //echo "<pre>"; //echo $modules_completed; //print_r($array_to_csv); //echo "</pre>"; convert_to_csv($array_to_csv, 'report-incremental-progress' . md5(date('Y-m-d h:i:s')) . '.csv', $headers); } ?> <div class="form-wrap" style="padding:20px;"> <form action="" method="post"> <div> <label> Group: </label> <?php $groups = $wpdb->get_results('SELECT * FROM `wp_groups_group`'); ?> <select name="group"> <?php foreach ($groups as $group) { echo "<option value='" . $group->group_id . "'>"; echo $group->name; echo "</option>"; } ?> </select> </div><br /> <div> <label> Course: </label> <?php $course = new WP_Query(array('post_type' => 'course')); ?> <select name="course"> <?php // The Loop if ($course->have_posts()) { while ($course->have_posts()) { $course->the_post(); echo '<option value="' . $course->post->ID . '">' . get_the_title() . '</option>'; } } /* Restore original Post Data */ ?> </select> <?php wp_reset_postdata(); ?> </div><br /> <div> <label> Date: </label> From<input type="text" id="date1" name="date1" /> to <input type="text" id="date2" name="date2" /> </div><br /><br /> <input type="submit" class="button button-primary" name="submitincrenmental" value="submit" /> </form> </div> <script> jQuery(document).ready(function() { jQuery('#date1').datepicker({ dateFormat : 'yy-mm-dd' }); jQuery('#date2').datepicker({ dateFormat : 'yy-mm-dd' }); }); </script> <?php } elseif ($tab == "total-progress") { //declare the wpdb for custom query global $wpdb; //check for submitted data if (isset($_POST['submittotalprogress']) && ($_POST['submittotalprogress'] = "submit")) { // declare users and variables $allUsers = get_users(); $modules_completed = $_POST['completionpermonth']; $courseid = $_POST['course']; $course_name = get_the_title($courseid); $array_to_csv = array(array('Student Name', 'Course Name', 'Lesson Title')); //user loop ----- loop user get the groups and course the course they take foreach ($allUsers as $user) { //declare course function calls $course_user_grade = WooThemes_Sensei_Utils::sensei_course_user_grade($courseid, $user->ID); $user_course_status = WooThemes_Sensei_Utils::user_course_status($courseid, $user->ID); $course_status_info = get_comment_meta($user_course_status->comment_ID); $started_course = WooThemes_Sensei_Utils::user_started_course($courseid, $user->ID); $course_status = WooThemes_Sensei_Utils::sensei_user_course_status_message($courseid, $user->ID); $completed_course = WooThemes_Sensei_Utils::user_completed_course($user_course_status); //get the user groups $useringroup = new Groups_User($user->ID); $user_groups = $useringroup->__get('groups'); $displayed_lessons = array(); //declare and get module values $modules = Sensei()->modules->get_course_modules(intval($courseid)); $modules_content = Sensei()->modules->course_module_content(intval($courseid)); //echo "<pre>"; //echo $user->user_email."<br />"; //echo "sensei_user_course_status_message: "; //print_r($course_status); //echo "<br />"; //echo "started_course: "."<br />"; $course_status_info['start'][0]; $datenow = date('Y-m-d h:i:s'); $date1 = date_create($course_status_info['start'][0]); $date2 = date_create($datenow); $diff = date_diff($date1, $date2); $diftime = $diff->format("%m"); if ($diftime < 1) { $diftime = 1; } //echo "</pre>"; //module loop per user foreach ($modules as $module) { $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'meta_query' => array(array('key' => '_lesson_course', 'value' => intval($courseid), 'compare' => '=')), 'tax_query' => array(array('taxonomy' => Sensei()->modules->taxonomy, 'field' => 'id', 'terms' => intval($module->term_id))), 'meta_key' => '_order_module_' . $module->term_id, 'orderby' => 'meta_value_num date', 'order' => 'ASC', 'suppress_filters' => 0); $lessons = get_posts($args); $num_of_lesson = count($lessons); //lessson loop per user foreach ($lessons as $lesson_item) { $is_lesson_completed = WooThemes_Sensei_Utils::user_completed_lesson($lesson_item->ID, $user->ID); if ($is_lesson_completed == 1) { $lesson_taken[$user->ID][] = $lesson_item->post_title; } } } $overaalltotal_module_passed = count($total_module_passed); //echo $overaalltotal_module_passed . " module being passed"; //loop throughout the user group under a user if (is_array($user_groups)) { foreach ($user_groups as $user_group) { if ($user_group->group_id == $_POST['group']) { if (!empty($user_course_status)) { $array_to_csv[] = array($user->display_name, $course_name, join("|", $lesson_taken[$user->ID])); //$userid_within_group[$user->user_email] = $user->ID; } } //echo $user_group->group_id."<br />"; } } //echo "<pre>"; //print_r($lesson_taken); //echo "<pre>"; unset($total_module_passed); unset($lesson_taken); } //echo "<pre>"; //echo $modules_completed; //print_r($array_to_csv); //echo "</pre>"; convert_to_csv($array_to_csv, 'report-total-progress' . md5(date('Y-m-d h:i:s')) . '.csv', ','); } ?> <div class="form-wrap" style="padding:20px;"> <form action="" method="post"> <div> <label> Group: </label> <?php $groups = $wpdb->get_results('SELECT * FROM `wp_groups_group`'); ?> <select name="group"> <?php foreach ($groups as $group) { echo "<option value='" . $group->group_id . "'>"; echo $group->name; echo "</option>"; } ?> </select> </div> <div> <label> Course: </label> <?php $course = new WP_Query(array('post_type' => 'course')); ?> <select name="course"> <?php // The Loop if ($course->have_posts()) { while ($course->have_posts()) { $course->the_post(); echo '<option value="' . $course->post->ID . '">' . get_the_title() . '</option>'; } } /* Restore original Post Data */ ?> </select> <?php wp_reset_postdata(); ?> </div> <br /><br /> <input type="submit" class="button button-primary" name="submittotalprogress" value="submit" /> </form> </div> <?php } echo '</div>'; }
/** * Load template for displaying course lessons * @since 1.4.0 * @return void */ public function course_lessons() { global $course, $woothemes_sensei, $current_user; $started_course = WooThemes_Sensei_Utils::user_started_course($course->ID, $current_user->ID); if ($started_course) { $woothemes_sensei->frontend->sensei_get_template('course-results/course-lessons.php'); } }
?> <?php do_action('sensei_lesson_single_title'); ?> <?php $view_lesson = true; wp_get_current_user(); $lesson_prerequisite = absint(get_post_meta($post->ID, '_lesson_prerequisite', true)); if ($lesson_prerequisite > 0) { // Check for prerequisite lesson completions $view_lesson = WooThemes_Sensei_Utils::user_completed_lesson($lesson_prerequisite, $current_user->ID); } $lesson_course_id = get_post_meta($post->ID, '_lesson_course', true); $user_taking_course = WooThemes_Sensei_Utils::user_started_course($lesson_course_id, $current_user->ID); if (current_user_can('administrator')) { $view_lesson = true; $user_taking_course = true; } $is_preview = false; if (WooThemes_Sensei_Utils::is_preview_lesson($post->ID)) { $is_preview = true; $view_lesson = true; } if ($view_lesson) { ?> <section class="entry fix"> <?php if ($is_preview && !$user_taking_course) {
$lesson_course_id = absint(get_post_meta($post->ID, '_lesson_course', true)); $is_preview = WooThemes_Sensei_Utils::is_preview_lesson($post->ID); // Get User Meta get_currentuserinfo(); // Complete Lesson Logic do_action('sensei_complete_lesson'); // Check that the course has been started if ($woothemes_sensei->access_settings() || WooThemes_Sensei_Utils::user_started_course($lesson_course_id, $current_user->ID) || $is_preview) { ?> <section class="lesson-meta" id="lesson_complete"> <?php if (apply_filters('sensei_video_position', 'top', $post->ID) == 'bottom') { do_action('sensei_lesson_video', $post->ID); } ?> <?php do_action('sensei_frontend_messages'); ?> <?php if (!$is_preview || WooThemes_Sensei_Utils::user_started_course($lesson_course_id, $current_user->ID)) { do_action('sensei_lesson_quiz_meta', $post->ID, $current_user->ID); } ?> </section> <?php do_action('sensei_lesson_back_link', $lesson_course_id); } else { do_action('sensei_lesson_course_signup', $lesson_course_id); } // End If Statement do_action('sensei_lesson_meta_extra', $post->ID);
/** * This function shows the WooCommerce cart notice if the user has * added the current course to cart. It does not show if the user is already taking * the course. * * @since 1.0.2 * @return void; */ public function sensei_woocommerce_in_cart_message() { global $post, $woocommerce; $wc_post_id = absint(get_post_meta($post->ID, '_course_woocommerce_product', true)); $user_course_status_id = WooThemes_Sensei_Utils::user_started_course($post->ID, get_current_user_id()); if (0 < intval($wc_post_id) && !$user_course_status_id) { if (sensei_check_if_product_is_in_cart($wc_post_id)) { echo '<div class="sensei-message info">' . sprintf(__('You have already added this Course to your cart. Please %1$s to access the course.', 'woothemes-sensei') . '</div>', '<a class="cart-complete" href="' . $woocommerce->cart->get_checkout_url() . '" title="' . __('complete the purchase', 'woothemes-sensei') . '">' . __('complete the purchase', 'woothemes-sensei') . '</a>'); } // End If Statement } // End If Statement }
public function sensei_course_meta() { global $woothemes_sensei, $post, $current_user; ?> <section class="course-meta"> <?php $is_user_taking_course = WooThemes_Sensei_Utils::user_started_course($post->ID, $current_user->ID); if (is_user_logged_in() && !$is_user_taking_course) { // Get the product ID $wc_post_id = absint(get_post_meta($post->ID, '_course_woocommerce_product', true)); // Check for woocommerce if (WooThemes_Sensei_Utils::sensei_is_woocommerce_activated() && 0 < intval($wc_post_id)) { sensei_wc_add_to_cart($post->ID); } else { sensei_start_course_form($post->ID); } // End If Statement } elseif (is_user_logged_in()) { // Check if course is completed $user_course_status = WooThemes_Sensei_Utils::user_course_status($post->ID, $current_user->ID); $completed_course = WooThemes_Sensei_Utils::user_completed_course($user_course_status); // Success message if ($completed_course) { ?> <div class="status completed"><?php echo apply_filters('sensei_complete_text', __('Completed', 'woothemes-sensei')); ?> </div> <?php $has_quizzes = $woothemes_sensei->post_types->course->course_quizzes($post->ID, true); if (has_filter('sensei_results_links') || $has_quizzes) { ?> <p class="sensei-results-links"> <?php $results_link = ''; if ($has_quizzes) { $results_link = '<a class="view-results" href="' . $woothemes_sensei->course_results->get_permalink($post->ID) . '">' . apply_filters('sensei_view_results_text', __('View results', 'woothemes-sensei')) . '</a>'; } $results_link = apply_filters('sensei_results_links', $results_link); echo $results_link; ?> </p> <?php } ?> <?php } else { ?> <div class="status in-progress"><?php echo apply_filters('sensei_in_progress_text', __('In Progress', 'woothemes-sensei')); ?> </div> <?php } ?> <?php } else { // Get the product ID $wc_post_id = absint(get_post_meta($post->ID, '_course_woocommerce_product', true)); // Check for woocommerce if (WooThemes_Sensei_Utils::sensei_is_woocommerce_activated() && 0 < intval($wc_post_id)) { sensei_wc_add_to_cart($post->ID); } else { // User needs to register wp_register('<div class="status register">', '</div>'); } // End If Statement } // End If Statement ?> </section><?php }
/** * Output the course progress bar * * @param $course_id * @return void */ public function the_progress_meter($course_id = 0, $user_id = 0) { if (empty($course_id)) { global $post; $course_id = $post->ID; } if (empty($user_id)) { $user_id = get_current_user_id(); } if ('course' != get_post_type($course_id) || !get_userdata($user_id) || !WooThemes_Sensei_Utils::user_started_course($course_id, $user_id)) { return; } $percentage_completed = $this->get_completion_percentage($course_id, $user_id); echo $this->get_progress_meter($percentage_completed); }
/** * Start course for user * @since 1.4.8 * @param integer $user_id User ID * @param integer $course_id Course ID * @return mixed boolean or comment_ID */ public static function user_start_course($user_id = 0, $course_id = 0) { $activity_logged = false; if ($user_id && $course_id) { // Check if user is already on the Course $activity_logged = WooThemes_Sensei_Utils::user_started_course($course_id, $user_id); if (!$activity_logged) { // Add user to course $course_metadata = array('start' => current_time('mysql'), 'percent' => 0, 'complete' => 0); $activity_logged = WooThemes_Sensei_Utils::update_course_status($user_id, $course_id, $course_status = 'in-progress', $course_metadata); // Allow further actions if ($activity_logged) { do_action('sensei_user_course_start', $user_id, $course_id); } } } return $activity_logged; }
/** * Output a link to view course. The button text is different depending on the amount of preview lesson available. * * hooked into 'sensei_course_content_inside_after' * * @since 1.9.0 * * @param WP_Post $course */ public function the_course_free_lesson_preview($course) { // Meta data $preview_lesson_count = intval(Sensei()->course->course_lesson_preview_count($course->ID)); $is_user_taking_course = WooThemes_Sensei_Utils::user_started_course($course->ID, get_current_user_id()); if (0 < $preview_lesson_count && !$is_user_taking_course) { ?> <p class="sensei-free-lessons"> <a href="<?php echo get_permalink(); ?> "> <?php _e('Preview this course', 'woothemes-sensei'); ?> </a> - <?php echo sprintf(__('(%d preview lessons)', 'woothemes-sensei'), $preview_lesson_count); ?> </p> <?php } }
function widget($args, $instance) { global $woothemes_sensei, $post, $current_user, $view_lesson, $user_taking_course; $allmodules = 'off'; if (isset($instance['allmodules'])) { $allmodules = $instance['allmodules']; } // If not viewing a lesson/quiz, don't display the widget if (!(is_singular('lesson') || is_singular('quiz'))) { return; } extract($args); if (is_singular('quiz')) { $current_lesson_id = absint(get_post_meta($post->ID, '_quiz_lesson', true)); } else { $current_lesson_id = $post->ID; } // get the course for the current lesson/quiz $lesson_course_id = get_post_meta($current_lesson_id, '_lesson_course', true); // Check if the user is taking the course $is_user_taking_course = WooThemes_Sensei_Utils::user_started_course($lesson_course_id, $current_user->ID); //Check for preview lesson $is_preview = false; if (method_exists('WooThemes_Sensei_Utils', 'is_preview_lesson')) { $is_preview = WooThemes_Sensei_Utils::is_preview_lesson($post->ID); } $course_title = get_the_title($lesson_course_id); $course_url = get_the_permalink($lesson_course_id); $in_module = false; $lesson_module = ''; $lesson_array = array(); if (0 < $current_lesson_id) { // get an array of lessons in the module if there is one if (isset(Sensei()->modules) && has_term('', Sensei()->modules->taxonomy, $current_lesson_id)) { // Get all modules $course_modules = Sensei()->modules->get_course_modules($lesson_course_id); $lesson_module = Sensei()->modules->get_lesson_module($current_lesson_id); $in_module = true; $current_module_title = htmlspecialchars($lesson_module->name); // Display all modules if ('on' == $allmodules) { foreach ($course_modules as $module) { // get all lessons in the module $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'meta_query' => array(array('key' => '_lesson_course', 'value' => intval($lesson_course_id), 'compare' => '=')), 'tax_query' => array(array('taxonomy' => Sensei()->modules->taxonomy, 'field' => 'id', 'terms' => intval($module->term_id))), 'meta_key' => '_order_module_' . intval($module->term_id), 'orderby' => 'meta_value_num date', 'order' => 'ASC'); $lesson_array = array_merge($lesson_array, get_posts($args)); } } else { // Only display current module // get all lessons in the current module $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'meta_query' => array(array('key' => '_lesson_course', 'value' => intval($lesson_course_id), 'compare' => '=')), 'tax_query' => array(array('taxonomy' => Sensei()->modules->taxonomy, 'field' => 'id', 'terms' => $lesson_module)), 'meta_key' => '_order_module_' . intval($lesson_module->term_id), 'orderby' => 'meta_value_num date', 'order' => 'ASC'); $lesson_array = get_posts($args); } } else { // if there's no module, get all lessons in the course $lesson_array = Sensei()->course->course_lessons($lesson_course_id); } } echo $before_widget; ?> <header> <h2 class="course-title"><a href="<?php echo $course_url; ?> "><?php echo $course_title; ?> </a></h2> <?php if ($in_module && 'on' != $allmodules) { ?> <h3 class="module-title"><?php echo $current_module_title; ?> </h3> <?php } ?> </header> <?php $nav_id_array = sensei_get_prev_next_lessons($current_lesson_id); $previous_lesson_id = absint($nav_id_array['prev_lesson']); $next_lesson_id = absint($nav_id_array['next_lesson']); if (0 < $previous_lesson_id || 0 < $next_lesson_id) { ?> <ul class="course-progress-navigation"> <?php if (0 < $previous_lesson_id) { ?> <li class="prev"><a href="<?php echo esc_url(get_permalink($previous_lesson_id)); ?> " title="<?php echo get_the_title($previous_lesson_id); ?> "><span><?php _e('Previous', 'sensei-course-progress'); ?> </span></a></li><?php } ?> <?php if (0 < $next_lesson_id) { ?> <li class="next"><a href="<?php echo esc_url(get_permalink($next_lesson_id)); ?> " title="<?php echo get_the_title($next_lesson_id); ?> "><span><?php _e('Next', 'sensei-course-progress'); ?> </span></a></li><?php } ?> </ul> <?php } ?> <ul class="course-progress-lessons"> <?php $old_module = ''; foreach ($lesson_array as $lesson) { $lesson_id = $lesson->ID; $lesson_title = htmlspecialchars($lesson->post_title); $lesson_url = get_the_permalink($lesson_id); // add 'completed' class to completed lessons $classes = "not-completed"; if (WooThemes_Sensei_Utils::user_completed_lesson($lesson->ID, $current_user->ID)) { $classes = "completed"; } // Lesson Quiz Meta $lesson_quiz_id = Sensei()->lesson->lesson_quizzes($lesson_id); // add 'current' class on the current lesson/quiz if ($lesson_id == $post->ID || $lesson_quiz_id == $post->ID) { $classes .= " current"; } if (isset(Sensei()->modules) && 'on' == $allmodules) { $new_module = Sensei()->modules->get_lesson_module($lesson_id); if ($old_module != $new_module) { ?> <li class="course-progress-module"><h3><?php echo $new_module->name; ?> </h3></li> <?php $old_module = $new_module; } } ?> <li class="course-progress-lesson <?php echo $classes; ?> "> <?php if ($lesson->ID == $post->ID || $lesson_quiz_id == $post->ID) { echo '<span>' . $lesson_title . '</span>'; } else { echo '<a href="' . $lesson_url . '">' . $lesson_title . '</a>'; } ?> </li> <?php } ?> </ul> <?php echo $after_widget; }
* Override this template by copying it to yourtheme/sensei/single-course/course-lessons.php * * @author WooThemes * @package Sensei/Templates * @version 1.0.0 */ if (!defined('ABSPATH')) { exit; } global $post, $woothemes_sensei, $current_user; $html = ''; // Get Course Lessons $course_lessons = Sensei()->course->course_lessons($post->ID); $total_lessons = count($course_lessons); // Check if the user is taking the course $is_user_taking_course = WooThemes_Sensei_Utils::user_started_course($post->ID, $current_user->ID); // Get User Meta get_currentuserinfo(); // exit if no lessons exist if (!($total_lessons > 0)) { return; } $html .= '<section class="course-lessons">'; $html .= '<header>'; $html .= '<h2>' . apply_filters('sensei_lessons_text', __('Lessons', 'woothemes-sensei')) . '</h2>'; $html .= '</header>'; $lesson_count = 1; $lessons_completed = count(Sensei()->course->get_completed_lesson_ids($post->ID, $current_user->ID)); $show_lesson_numbers = false; foreach ($course_lessons as $lesson_item) { //skip lesson that are already in the modules
function sensei_has_user_started_course($post_id = 0, $user_id = 0) { _deprecated_function(__FUNCTION__, '1.7', "WooThemes_Sensei_Utils::user_started_course()"); return WooThemes_Sensei_Utils::user_started_course($post_id, $user_id); }
/** * check_user_permissions function. * * @access public * @param string $page (default: '') * @param array $data (default: array()) * @return void */ public function check_user_permissions($page = '', $data = array()) { // REFACTOR global $current_user, $post; if (!isset($current_user)) { return; } // Get User Meta get_currentuserinfo(); $user_allowed = false; switch ($page) { case 'course-single': // check for prerequisite course or lesson, $course_prerequisite_id = (int) get_post_meta($post->ID, '_course_prerequisite', true); $update_course = $this->woocommerce_course_update($post->ID); // Count completed lessons if (0 < absint($course_prerequisite_id)) { $prerequisite_complete = WooThemes_Sensei_Utils::user_completed_course($course_prerequisite_id, $current_user->ID); } else { $prerequisite_complete = true; } // End If Statement // Handles restrictions if (!$prerequisite_complete && 0 < absint($course_prerequisite_id)) { $this->permissions_message['title'] = get_the_title($post->ID) . ': ' . __('Restricted Access', 'woothemes-sensei'); $course_link = '<a href="' . esc_url(get_permalink($course_prerequisite_id)) . '">' . __('course', 'woothemes-sensei') . '</a>'; $this->permissions_message['message'] = sprintf(__('Please complete the previous %1$s before taking this course.', 'woothemes-sensei'), $course_link); } else { $user_allowed = true; } // End If Statement break; case 'lesson-single': // Check for WC purchase $lesson_course_id = get_post_meta($post->ID, '_lesson_course', true); $update_course = $this->woocommerce_course_update($lesson_course_id); $is_preview = WooThemes_Sensei_Utils::is_preview_lesson($post->ID); if ($this->access_settings() && WooThemes_Sensei_Utils::user_started_course($lesson_course_id, $current_user->ID)) { $user_allowed = true; } elseif ($this->access_settings() && false == $is_preview) { $user_allowed = true; } else { $this->permissions_message['title'] = get_the_title($post->ID) . ': ' . __('Restricted Access', 'woothemes-sensei'); $course_link = '<a href="' . esc_url(get_permalink($lesson_course_id)) . '">' . __('course', 'woothemes-sensei') . '</a>'; $wc_post_id = get_post_meta($lesson_course_id, '_course_woocommerce_product', true); if (WooThemes_Sensei_Utils::sensei_is_woocommerce_activated() && 0 < $wc_post_id) { if ($is_preview) { $this->permissions_message['message'] = sprintf(__('This is a preview lesson. Please purchase the %1$s to access all lessons.', 'woothemes-sensei'), $course_link); } else { $this->permissions_message['message'] = apply_filters('sensei_please_purchase_course_text', sprintf(__('Please purchase the %1$s before starting this Lesson.', 'woothemes-sensei'), $course_link)); } } else { if ($is_preview) { $this->permissions_message['message'] = sprintf(__('This is a preview lesson. Please sign up for the %1$s to access all lessons.', 'woothemes-sensei'), $course_link); } else { /** This filter is documented in class-woothemes-sensei-frontend.php */ $this->permissions_message['message'] = apply_filters('sensei_please_sign_up_text', sprintf(__('Please sign up for the %1$s before starting the lesson.', 'woothemes-sensei'), $course_link)); } } // End If Statement } // End If Statement break; case 'quiz-single': $lesson_id = get_post_meta($post->ID, '_quiz_lesson', true); $lesson_course_id = get_post_meta($lesson_id, '_lesson_course', true); $update_course = $this->woocommerce_course_update($lesson_course_id); if ($this->access_settings() && WooThemes_Sensei_Utils::user_started_course($lesson_course_id, $current_user->ID) || sensei_all_access()) { // Check for prerequisite lesson for this quiz $lesson_prerequisite_id = (int) get_post_meta($lesson_id, '_lesson_prerequisite', true); $user_lesson_prerequisite_complete = WooThemes_Sensei_Utils::user_completed_lesson($lesson_prerequisite_id, $current_user->ID); // Handle restrictions if (sensei_all_access()) { $user_allowed = true; } else { if (0 < absint($lesson_prerequisite_id) && !$user_lesson_prerequisite_complete) { $this->permissions_message['title'] = get_the_title($post->ID) . ': ' . __('Restricted Access', 'woothemes-sensei'); $lesson_link = '<a href="' . esc_url(get_permalink($lesson_prerequisite_id)) . '">' . __('lesson', 'woothemes-sensei') . '</a>'; $this->permissions_message['message'] = sprintf(__('Please complete the previous %1$s before taking this Quiz.', 'woothemes-sensei'), $lesson_link); } else { $user_allowed = true; } // End If Statement } // End If Statement } elseif ($this->access_settings()) { // Check if the user has started the course if (is_user_logged_in() && !WooThemes_Sensei_Utils::user_started_course($lesson_course_id, $current_user->ID) && (isset($this->settings->settings['access_permission']) && true == $this->settings->settings['access_permission'])) { $user_allowed = false; $this->permissions_message['title'] = get_the_title($post->ID) . ': ' . __('Restricted Access', 'woothemes-sensei'); $course_link = '<a href="' . esc_url(get_permalink($lesson_course_id)) . '">' . __('course', 'woothemes-sensei') . '</a>'; $wc_post_id = get_post_meta($lesson_course_id, '_course_woocommerce_product', true); if (WooThemes_Sensei_Utils::sensei_is_woocommerce_activated() && 0 < $wc_post_id) { $this->permissions_message['message'] = sprintf(__('Please purchase the %1$s before starting this Quiz.', 'woothemes-sensei'), $course_link); } else { $this->permissions_message['message'] = sprintf(__('Please sign up for the %1$s before starting this Quiz.', 'woothemes-sensei'), $course_link); } // End If Statement } else { $user_allowed = true; } // End If Statement } else { $this->permissions_message['title'] = get_the_title($post->ID) . ': ' . __('Restricted Access', 'woothemes-sensei'); $course_link = '<a href="' . esc_url(get_permalink(get_post_meta(get_post_meta($post->ID, '_quiz_lesson', true), '_lesson_course', true))) . '">' . __('course', 'woothemes-sensei') . '</a>'; $this->permissions_message['message'] = sprintf(__('Please sign up for the %1$s before taking this Quiz.', 'woothemes-sensei'), $course_link); } // End If Statement break; default: $user_allowed = true; break; } // End Switch Statement /** * filter the permissions message shown on sensei post types. * * @since 1.8.7 * * @param array $permissions_message{ * * @type string $title * @type string $message * * } * @param string $post_id */ $this->permissions_message = apply_filters('sensei_permissions_message', $this->permissions_message, $post->ID); if (sensei_all_access() || WooThemes_Sensei_Utils::is_preview_lesson($post->ID)) { $user_allowed = true; } return apply_filters('sensei_access_permissions', $user_allowed); }
function savedquest_options() { if (!current_user_can('manage_options')) { wp_die(__('You do not have sufficient permissions to access this page.')); } echo '<div class="wrap" style="background:#fff;">'; if (isset($_GET['tab'])) { $tab = $_GET['tab']; } else { $tab = ""; } saved_admin_tab($tab); if ($tab == "quiztaken" or $tab == "") { ?> <table class="wp-list-table widefat fixed striped pages" width="100%" style="border-spacing: 0; text-align:center;" > <tr> <th>Lesson ID</th> <th>Lesson Title</th> <th>Module</th> <th>Number Of Questions</th> <th>Question Answered</th> <th>Unanswered Question</th> <th>User</th> <th>User Id</th> <th>DATE And Time</th> </tr> <?php $svequiz = get_option('savequiz_list'); ?> <?php foreach ($svequiz as $quizdata) { ?> <tr> <td><?php echo $quizdata['lesson_id']; ?> </td> <td><?php echo $quizdata['lesson_title']; ?> </td> <td> <?php $terms = get_the_terms($quizdata['lesson_id'], 'module'); echo $terms[0]->name; //print_r($terms); ?> </td> <td><?php echo $quizdata['total_questtion']; ?> </td> <td><?php echo $quizdata['question_answered']; ?> (<?php echo get_percentage($quizdata['total_questtion'], $quizdata['question_answered']) . "%"; ?> )</td> <td><?php echo $quizdata['remaining_question']; ?> (<?php echo 100 - get_percentage($quizdata['total_questtion'], $quizdata['question_answered']) . "%"; ?> )</td> <td><?php echo $quizdata['fullname']; ?> </td> <td><?php echo $quizdata['user_id']; ?> </td> <td><?php echo $quizdata['DATETIME']; ?> </td> </tr> <?php } ?> </table> <?php } elseif ($tab == "timesession") { $user_last_login_logout = get_option('user_last_login_logout'); ?> <br /><br/> <table class="wp-list-table widefat fixed striped pages" width="100%" style="border-spacing: 0; text-align:center;" > <tr> <th>User ID</th> <th>Full Name</th> <th>Last Login</th> <th>Last Logout</th> <th>Amout of Time Spent</th> <th>Role</th> </tr> <?php $svequiz = get_option('savequiz_list'); ?> <?php foreach ($user_last_login_logout as $last_login_logout) { ?> <?php if ($last_login_logout['user_id'] != "") { ?> <?php $user_info = get_userdata($last_login_logout['user_id']); ?> <tr> <td><?php echo $last_login_logout['user_id']; ?> </td> <td><?php echo $user_info->display_name; ?> </td> <td><?php echo gettime_st($last_login_logout['logintime']); ?> </td> <td><?php echo gettime_st($last_login_logout['logouttime']); ?> </td> <?php if ($last_login_logout['logouttime'] != "") { $date1 = date_create($last_login_logout['logintime']); $date2 = date_create($last_login_logout['logouttime']); $diff = date_diff($date1, $date2); $diftime = $diff->format("%h Hours %i Minute %s Seconds"); } else { $diftime = ""; } ?> <th><?php echo $diftime; ?> </th> <td><?php echo implode(', ', $user_info->roles); ?> </td> </tr> <?php } ?> <?php } ?> </table><br /><br /> <?php } elseif ($tab == "timequizecompleted") { global $woothemes_sensei, $post, $current_user, $wp_query, $learner_user; echo "<table class='wp-list-table widefat fixed striped pages'>"; $allUsers = get_users(); echo "<tr>\n\n\t\t\t\t<th>User</th>\n\n\t\t\t\t<th>Courses</th>\n\n\t\t\t\t<th>Percentage Incomplete</th>\n\n\t\t\t\t<th>Percentage Complete</th>\n\n\t\t\t\t<th>Percentage Competent</th>\n\n\t\t\t\t<th>Percentage Attempted</th>\n\n\t\t\t\t<th>Length of time Course Completed</th>\n\n\t\t\t </tr>"; foreach ($allUsers as $user) { $args = array('post_type' => 'course'); $courses = get_posts($args); $i = 1; foreach ($courses as $course) { $course_user_grade = WooThemes_Sensei_Utils::sensei_course_user_grade($course->ID, $user->ID); $course_status = WooThemes_Sensei_Utils::user_course_status($course->ID, $user->ID); $course_status_update = get_comment_meta($course_status->comment_ID); if (!empty($course_status)) { $displayed_lessons = array(); $modules = Sensei()->modules->get_course_modules(intval($course->ID)); foreach ($modules as $module) { $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'meta_query' => array(array('key' => '_lesson_course', 'value' => intval($course->ID), 'compare' => '=')), 'tax_query' => array(array('taxonomy' => Sensei()->modules->taxonomy, 'field' => 'id', 'terms' => intval($module->term_id))), 'meta_key' => '_order_module_' . $module->term_id, 'orderby' => 'meta_value_num date', 'order' => 'ASC', 'suppress_filters' => 0); $lessons = get_posts($args); if (count($lessons) > 0) { $html .= '<h3>' . $module->name . '</h3>' . "\n"; $count = 0; foreach ($lessons as $lesson_item) { $lesson_grade = ' n/a'; $has_questions = get_post_meta($lesson_item->ID, '_quiz_has_questions', true); if ($has_questions) { $lesson_status = WooThemes_Sensei_Utils::user_lesson_status($lesson_item->ID, $user->ID); // Get user quiz grade $lesson_grade = get_comment_meta($lesson_status->comment_ID, 'grade', true); if ($lesson_grade) { $lesson_grade .= '%'; } $modulequizdata = get_comment_meta($lesson_status->comment_ID); //echo "<a href='".get_post_permalink($lesson_item->ID)."'>".$lesson_item->post_title."</a><br />"; $modulequestion_asked = count(explode(",", $modulequizdata['questions_asked'][0])); $moduleanswered_quiz = count(unserialize($modulequizdata['quiz_answers'][0])); //echo "number of questions:".$modulequestion_asked."<br />"; //echo "number of Answered:".$moduleanswered_quiz."<br />"; //echo "<pre>"; //echo "<h1>".$user->user_email.$lesson_item->post_title."</h1>"; //print_r($course_status ); //echo $course_status->comment_approved; //echo $modulequestion_asked."------".$moduleanswered_quiz; //echo "</pre>"; if ($course_status->comment_approved == "complete") { $attempted = '<span style="color:green;">(100%)</span>'; } else { if ($lesson_status->comment_approved == "passed" || $lesson_status->comment_approved == "graded") { $attempted = '<span style="color:green;">(100%)</span>'; } else { $attempted = ""; } } //echo "<pre>"; //echo "Attempted:".$attempted."<br />"; //echo $user->user_email."<br />"; //echo $modulequizdata['grade'][0]."<br />"; //echo $modulequizdata['quiz_answers'][0]."<br />"; //print_r($lesson_status); //echo "</pre>"; } $html .= '<a href="' . esc_url(get_permalink($lesson_item->ID)) . '" title="' . esc_attr(sprintf(__('Start %s', 'woothemes-sensei'), $lesson_item->post_title)) . '">' . esc_html(sprintf(__('%s', 'woothemes-sensei'), $lesson_item->post_title)) . '</a> ' . $attempted . '<br />'; $displayed_lessons[] = $lesson_item->ID; } } } $args = array('post_type' => 'lesson', 'posts_per_page' => -1, 'suppress_filters' => 0, 'meta_key' => '_order_' . $course->ID, 'orderby' => 'meta_value_num date', 'order' => 'ASC', 'meta_query' => array(array('key' => '_lesson_course', 'value' => intval($course->ID))), 'post__not_in' => $displayed_lessons); $lessons = get_posts($args); //echo "Number of lesson in a course: ".count($lessons); if (0 < count($lessons)) { $html .= '<h3>' . __('Other Lessons', 'woothemes-sensei') . '</h3>' . "\n"; } if ($course_status_update['percent'][0] == 100) { $date1 = date_create($course_status_update['start'][0]); $date2 = date_create($course_status->comment_date); $diff = date_diff($date1, $date2); $diftime = $diff->format("%h Hours %i Minute %s Seconds"); } else { $diftime = "course not completed yet."; } $allcourseid[] = $course->ID; $incomplete = 100 - $course_status_update['percent'][0]; echo "<tr><td>"; echo $user->user_email; echo "</td>"; echo "<td>"; echo "<a href='" . get_post_permalink($course->ID) . "'>" . $course->post_title . "</a>"; echo "</td>"; echo "<td>"; echo $incomplete . "%"; echo "</td>"; echo "<td>"; echo $course_status_update['percent'][0] . "%"; echo "</td>"; echo "<td>"; echo $course_user_grade . "%"; echo "</td>"; echo "<td>"; echo $html; $html = ""; foreach ($lessons as $lesson_item) { $lesson_grade = 'n/a'; $has_questions = get_post_meta($lesson_item->ID, '_quiz_has_questions', true); if ($has_questions) { $lesson_status = WooThemes_Sensei_Utils::user_lesson_status($lesson_item->ID, $user->ID); // Get user quiz grade $lesson_grade = get_comment_meta($lesson_status->comment_ID, 'grade', true); if ($lesson_grade) { $lesson_grade .= '%'; } } $quizdata = get_comment_meta($lesson_status->comment_ID); //echo "<h1>Comment</h1>"; //print_r(get_comment_meta( $lesson_status->comment_ID )); //echo "<h1>LESSON STATUS</h1>"; //print_r($lesson_status); echo "<a href='" . get_post_permalink($lesson_item->ID) . "'>" . $lesson_item->post_title . "</a> "; //print_r($quizdata); $question_asked = count(explode(",", $quizdata['questions_asked'][0])); $answered_quiz = count(unserialize($quizdata['quiz_answers'][0])); $lessonquestion_asked = count(explode(",", $quizdata['questions_asked'][0])); $lessonanswered_quiz = count(unserialize($quizdata['quiz_answers'][0])); if ($course_status->comment_approved == "complete") { echo $attempted = '<span style="color:green;">(100%)</span>'; } else { if ($lesson_status->comment_approved == "passed" || $lesson_status->comment_approved == "graded") { echo $attempted = '<span style="color:green;">(100%)</span>'; } else { echo $attempted = ""; } } /*if($quizdata ['grade'][0]==""){ if($lesson_status->comment_approved=="passed"){ echo $attempted = 'P/Q'; }else{ if($lessonquestion_asked>=$lessonanswered_quiz){ if($modulequizdata['quiz_answers'][0]==""){ $attempted = ""; }else{ echo $attempted = "( ". get_percentage($lessonquestion_asked, $lessonanswered_quiz)."% ) <span style='color:red;'>Saved</span>"; } } } }else{ if($lesson_status->comment_approved=="passed"){ echo $attempted = '100% <span style="color:red;">complete button</span>'; }else{ $percentage = get_percentage($lessonquestion_asked, $lessonanswered_quiz); if((int)$lessonquestion_asked>1){ } } }*/ echo '<br />'; } // End For Loop echo "</td>"; echo "<td>"; echo $diftime; echo "</td>"; echo "</tr>"; //echo $course->post_title." (".$course_status_update['percent'][0]."% Complete) (". $incomplete . "% incomplete) (". $course_user_grade . "% Competent)<br />"; $i++; } } } echo "</table>"; } elseif ($tab == "threshold") { //declare the wpdb for custom query global $wpdb; //check for submitted data if (isset($_POST['submittreshold']) && ($_POST['submittreshold'] = "submit")) { // declare users and variables $completionpermonth = $_POST['completionpermonth']; $courseid = $_POST['course']; $group_id = $_POST['group']; $course_name = get_the_title($courseid); $array_to_csv = array(array('Student Name', 'Course Name', 'Module(s)')); $userincourse = BuddyPress_Sensei_Groups::bp_sensei_get_course_members($courseid); //groups_get_groupmeta //echo $group_attached = groups_get_groupmeta( $group_id, 'bp_course_attached', true)."<br />---"; if ($completionpermonth == "") { $completionpermonth = groups_get_groupmeta($group_id, 'sensei_threshold', true); } /* echo "<pre>"; print_r($userincourse); echo "</pre>"; echo "<pre>"; print_r($user_in_groups); echo "</pre>"; */ $user_in_groups = $wpdb->get_results($wpdb->prepare("SELECT user_id FROM wp_bp_groups_members WHERE group_id = %d", $group_id)); //user loop ----- loop user get the groups and course the course they take foreach ($user_in_groups as $user) { //echo "user_id ".$user->user_id."<br />"; $course_user_grade = WooThemes_Sensei_Utils::sensei_course_user_grade($courseid, $user->user_id); $user_course_status = WooThemes_Sensei_Utils::user_course_status($courseid, $user->user_id); $course_status_info = get_comment_meta($user_course_status->comment_ID); $started_course = WooThemes_Sensei_Utils::user_started_course($courseid, $user->user_id); $course_status = WooThemes_Sensei_Utils::sensei_user_course_status_message($courseid, $user->user_id); $completed_course = WooThemes_Sensei_Utils::user_completed_course($user_course_status); $modules = Sensei()->modules->get_course_modules($courseid); //$modules_content = Sensei()->modules->course_module_content( $courseid ); foreach ($modules as $module) { $module_id = $module->term_id; $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'tax_query' => array(array('taxonomy' => 'module', 'field' => 'id', 'terms' => $module_id)), 'meta_query' => array(array('key' => '_lesson_course', 'value' => $courseid)), 'fields' => 'ids'); $lessons = get_posts($args); $completed = false; $lesson_count = 0; $completed_count = 0; foreach ($lessons as $lesson_id) { $completed = WooThemes_Sensei_Utils::user_completed_lesson($lesson_id, $user->user_id); ++$lesson_count; if ($completed) { ++$completed_count; } } $module_progress = $completed_count / $lesson_count * 100; if ($module_progress == 100) { $module_passed[] = 1; $module_name[] = $module->name; } /* echo "<pre>"; echo $module_progress; echo "---<br />"; //print_r($modules_content); echo "</pre>"; */ } $course_status_info['start'][0]; $datenow = date('Y-m-d h:i:s'); $date1 = date_create($course_status_info['start'][0]); $date2 = date_create($datenow); $diff = date_diff($date1, $date2); $diftime = $diff->format("%m"); if ($diftime < 1) { $diftime = 1; } $num_of_module_x_difftime = $completionpermonth * $diftime; //echo "<br />num_of_module_x_difftime:".$num_of_module_x_difftime; //echo count($module_passed)." module passed<br />"; if (count($module_passed) >= $num_of_module_x_difftime) { $user_info = get_userdata($user->user_id); $array_to_csv[] = array($user_info->display_name, $course_name, join("|", $module_name)); //$userid_within_group[$user->user_email] = $user->ID; } unset($module_name); unset($module_passed); } /* echo "<pre>"; print_r($array_to_csv); echo "</pre>"; */ convert_to_csv($array_to_csv, 'report-' . md5(date('Y-m-d h:i:s')) . '.csv', ','); } ?> <div class="form-wrap" style="padding:20px;"> <form action="" method="post"> <div> <label> Group: </label> <?php $groups = $wpdb->get_results('SELECT * FROM `wp_bp_groups`'); ?> <select name="group"> <?php foreach ($groups as $group) { echo "<option value='" . $group->id . "'>"; echo $group->name; echo "</option>"; } ?> </select> </div> <div> <label> Course: </label> <?php $course = new WP_Query(array('post_type' => 'course')); ?> <select name="course"> <?php // The Loop if ($course->have_posts()) { while ($course->have_posts()) { $course->the_post(); echo '<option value="' . $course->post->ID . '">' . get_the_title() . '</option>'; } } /* Restore original Post Data */ ?> </select> <?php wp_reset_postdata(); ?> </div> <div> <label> How many modules should be completed by now? </label> <input type="text" name="completionpermonth" /> </div><br /><br /> <input type="submit" class="button button-primary" name="submittreshold" value="submit" /> </form> </div> <?php } elseif ($tab == "incremental-progress") { wp_enqueue_script('jquery-ui-datepicker'); wp_enqueue_style('jquery-style', 'http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.2/themes/smoothness/jquery-ui.css'); //declare the wpdb for custom query global $wpdb; //check for submitted data if (isset($_POST['submitincrenmental']) && ($_POST['submitincrenmental'] = "submit")) { // declare users and variables $courseid = $_POST['course']; $group_id = $_POST['group']; $course_name = get_the_title($courseid); $array_to_csv = array(array('Student Name', 'Course Name', 'Percentage Completed', 'Percentage Competent', 'Email')); $userincourse = BuddyPress_Sensei_Groups::bp_sensei_get_course_members($courseid); $user_in_groups = $wpdb->get_results($wpdb->prepare("SELECT user_id FROM wp_bp_groups_members WHERE group_id = %d", $group_id)); //user loop ----- loop user get the groups and course the course they take foreach ($user_in_groups as $user) { //echo "user_id ".$user->user_id."<br />"; $course_user_grade = WooThemes_Sensei_Utils::sensei_course_user_grade($courseid, $user->user_id); $user_course_status = WooThemes_Sensei_Utils::user_course_status($courseid, $user->user_id); $course_status_info = get_comment_meta($user_course_status->comment_ID); $started_course = WooThemes_Sensei_Utils::user_started_course($courseid, $user->user_id); $course_status = WooThemes_Sensei_Utils::sensei_user_course_status_message($courseid, $user->user_id); $completed_course = WooThemes_Sensei_Utils::user_completed_course($user_course_status); $modules = Sensei()->modules->get_course_modules($courseid); //$modules_content = Sensei()->modules->course_module_content( $courseid ); foreach ($modules as $module) { $module_id = $module->term_id; $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'tax_query' => array(array('taxonomy' => 'module', 'field' => 'id', 'terms' => $module_id)), 'meta_query' => array(array('key' => '_lesson_course', 'value' => $courseid)), 'fields' => 'ids'); $lessons = get_posts($args); $completed = false; $lesson_count = 0; $completed_count = 0; foreach ($lessons as $lesson_id) { $completed = WooThemes_Sensei_Utils::user_completed_lesson($lesson_id, $user->user_id); ++$lesson_count; if ($completed) { ++$completed_count; } } $module_progress = $completed_count / $lesson_count * 100; if ($module_progress == 100) { $module_passed[] = 1; } /* echo "<pre>"; echo $module_progress; echo "---<br />"; //print_r($modules_content); echo "</pre>"; */ } if ($course_status_info['percent'][0] != 0) { /* echo $user_course_status->comment_date."dsaddas"."<br />"; */ $date1 = strtotime($_POST['date1']); $date2 = strtotime($_POST['date2']); $lesson_completion_date_str = strtotime($user_course_status->comment_date); if ($lesson_completion_date_str > $date1 && $lesson_completion_date_str < $date2) { //echo "lesson is completed:".$is_lesson_completed."<br />"; //echo "user ".$user->display_name." pass this". $lesson_completion_date; $user_info = get_userdata($user->user_id); $array_to_csv[] = array($user_info->display_name, $course_name, $course_status_info['percent'][0] . '%', $course_user_grade . '%', $user_info->user_email); //$user_id_onrange[$user->ID] = $lesson_item->post_title; } } unset($module_passed); } /* echo "<pre>"; print_r($array_to_csv); echo "</pre>"; */ $daterange1 = $_POST['date1']; $daterange2 = $_POST['date2']; convert_to_csv($array_to_csv, 'report-inc-progress_' . $daterange1 . '_' . $daterange2 . '_group_' . $groupname . '_courseID_' . $courseid . '.csv', $headers); } ?> <div class="form-wrap" style="padding:20px;"> <form action="" method="post" id="incrementalval"> <div> <label> Group: </label> <?php $groups = $wpdb->get_results('SELECT * FROM `wp_bp_groups`'); ?> <select name="group"> <?php foreach ($groups as $group) { echo "<option value='" . $group->id . "'>"; echo $group->name; echo "</option>"; } ?> </select> </div><br /> <div> <label> Course: </label> <?php $course = new WP_Query(array('post_type' => 'course')); ?> <select name="course"> <?php // The Loop if ($course->have_posts()) { while ($course->have_posts()) { $course->the_post(); echo '<option value="' . $course->post->ID . '">' . get_the_title() . '</option>'; } } /* Restore original Post Data */ ?> </select> <?php wp_reset_postdata(); ?> </div><br /> <div> <label> Date: </label> From<input type="text" id="date1" name="date1" required /> to <input type="text" id="date2" name="date2" required /> </div><br /><br /> <input type="submit" class="button button-primary" name="submitincrenmental" value="submit" /> </form> </div> <script> jQuery(document).ready(function() { jQuery('#date1').datepicker({ dateFormat : 'yy-mm-dd' }); jQuery('#date2').datepicker({ dateFormat : 'yy-mm-dd' }); }); </script> <?php } elseif ($tab == "total-progress") { //declare the wpdb for custom query global $wpdb; //check for submitted data if (isset($_POST['submittotalprogress']) && ($_POST['submittotalprogress'] = "submit")) { // declare users and variables $courseid = $_POST['course']; $group_id = $_POST['group']; $course_name = get_the_title($courseid); $array_to_csv = array(array('Student Name', 'Course Name', 'Percentage Completed', 'Percentage Competent', 'Email')); $userincourse = BuddyPress_Sensei_Groups::bp_sensei_get_course_members($courseid); $user_in_groups = $wpdb->get_results($wpdb->prepare("SELECT user_id FROM wp_bp_groups_members WHERE group_id = %d", $group_id)); //user loop ----- loop user get the groups and course the course they take foreach ($user_in_groups as $user) { //echo "user_id ".$user->user_id."<br />"; $course_user_grade = WooThemes_Sensei_Utils::sensei_course_user_grade($courseid, $user->user_id); $user_course_status = WooThemes_Sensei_Utils::user_course_status($courseid, $user->user_id); $course_status_info = get_comment_meta($user_course_status->comment_ID); $started_course = WooThemes_Sensei_Utils::user_started_course($courseid, $user->user_id); $course_status = WooThemes_Sensei_Utils::sensei_user_course_status_message($courseid, $user->user_id); $completed_course = WooThemes_Sensei_Utils::user_completed_course($user_course_status); $modules = Sensei()->modules->get_course_modules($courseid); //$modules_content = Sensei()->modules->course_module_content( $courseid ); foreach ($modules as $module) { $module_id = $module->term_id; $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'tax_query' => array(array('taxonomy' => 'module', 'field' => 'id', 'terms' => $module_id)), 'meta_query' => array(array('key' => '_lesson_course', 'value' => $courseid)), 'fields' => 'ids'); $lessons = get_posts($args); $completed = false; $lesson_count = 0; $completed_count = 0; foreach ($lessons as $lesson_id) { $completed = WooThemes_Sensei_Utils::user_completed_lesson($lesson_id, $user->user_id); ++$lesson_count; if ($completed) { ++$completed_count; } } $module_progress = $completed_count / $lesson_count * 100; if ($module_progress == 100) { $module_passed[] = 1; } } $user_info = get_userdata($user->user_id); if ($user->user_id != 1) { $percentcomplete = $course_status_info['percent'][0]; if ($percentcomplete == "") { $percentcomplete = '0'; } $array_to_csv[] = array($user_info->display_name, $course_name, $percentcomplete . '%', $course_user_grade . '%', $user_info->user_email); } } convert_to_csv($array_to_csv, 'report-total-progress_' . date('Y-m-d') . '_group_' . $groupname . '_courseID_' . $courseid . '.csv', ','); } ?> <div class="form-wrap" style="padding:20px;"> <form action="" method="post"> <div> <label> Group: </label> <?php $groups = $wpdb->get_results('SELECT * FROM `wp_bp_groups`'); ?> <select name="group"> <?php foreach ($groups as $group) { echo "<option value='" . $group->id . "'>"; echo $group->name; echo "</option>"; } ?> </select> </div> <div> <label> Course: </label> <?php $course = new WP_Query(array('post_type' => 'course')); ?> <select name="course"> <?php // The Loop if ($course->have_posts()) { while ($course->have_posts()) { $course->the_post(); echo '<option value="' . $course->post->ID . '">' . get_the_title() . '</option>'; } } /* Restore original Post Data */ ?> </select> <?php wp_reset_postdata(); ?> </div> <br /><br /> <input type="submit" class="button button-primary" name="submittotalprogress" value="submit" /> </form> </div> <?php } elseif ($tab == "master-report") { //declare the wpdb for custom query global $wpdb; global $woothemes_sensei, $post, $current_user, $wp_query, $learner_user; //check for submitted data if (isset($_POST['master-report']) && ($_POST['master-report'] = "submit")) { // declare users and variables $courseid = $_POST['course']; $group_id = $_POST['group']; $course_name = get_the_title($courseid); $array_to_csv = array(array('Student Name', 'Course Name', 'Percentage Completed', 'Percentage Competent', 'Email')); $userincourse = BuddyPress_Sensei_Groups::bp_sensei_get_course_members($courseid); $user_in_groups = $wpdb->get_results($wpdb->prepare("SELECT user_id FROM wp_bp_groups_members WHERE group_id = %d", $group_id)); //user loop ----- loop user get the groups and course the course they take $maincontent = ""; $countloop_user = 0; $lesson_title = "<th align='center'>User</th>"; foreach ($user_in_groups as $user) { $maincontent .= "<tr>"; $user_info = get_userdata($user->user_id); $maincontent .= "<td>" . $user_info->display_name . "</td>"; $course_user_grade = WooThemes_Sensei_Utils::sensei_course_user_grade($courseid, $user->user_id); $user_course_status = WooThemes_Sensei_Utils::user_course_status($courseid, $user->user_id); $course_status_info = get_comment_meta($user_course_status->comment_ID); $started_course = WooThemes_Sensei_Utils::user_started_course($courseid, $user->user_id); $course_status = WooThemes_Sensei_Utils::sensei_user_course_status_message($courseid, $user->user_id); $completed_course = WooThemes_Sensei_Utils::user_completed_course($user_course_status); $modules = Sensei()->modules->get_course_modules($courseid); //$modules_content = Sensei()->modules->course_module_content( $courseid ); foreach ($modules as $module) { $module_id = $module->term_id; $args = array('post_type' => 'lesson', 'post_status' => 'publish', 'posts_per_page' => -1, 'tax_query' => array(array('taxonomy' => 'module', 'field' => 'id', 'terms' => $module_id)), 'meta_query' => array(array('key' => '_lesson_course', 'value' => $courseid)), 'fields' => 'ids', 'order' => 'ASC'); $lessons = get_posts($args); $completed = false; $lesson_count = 0; $completed_count = 0; foreach ($lessons as $lesson_id) { if ($countloop_user != 1) { $lesson_title .= "<th style=\"font-size:10px;\">"; $lesson_title .= get_the_title($lesson_id); $lesson_title .= "</th>"; } // Get quiz pass setting $pass_required = get_post_meta($lesson_id, '_pass_required', true); // Get quiz pass mark $quiz_passmark = abs(round(doubleval(get_post_meta($lesson_id, '_quiz_passmark', true)), 2)); // Get latest quiz answers and grades //$lesson_id = $woothemes_sensei->quiz->get_lesson_id( $lesson_id ); $user_quizzes = $woothemes_sensei->quiz->get_user_answers($lesson_id, $user->user_id); $user_lesson_status = WooThemes_Sensei_Utils::user_lesson_status($lesson_id, $user->user_id); $user_quiz_grade = 0; if (isset($user_lesson_status->comment_ID)) { $user_quiz_grade = get_comment_meta($user_lesson_status->comment_ID, 'grade', true); } // Check again that the lesson is complete $user_lesson_end = WooThemes_Sensei_Utils::user_completed_lesson($user_lesson_status); $completed = WooThemes_Sensei_Utils::user_completed_lesson($lesson_id, $user->user_id); /* echo "<pre>"; echo get_the_title($lesson_id); echo 'pass_required:'."<br />"; print_r($pass_required); echo 'quiz_passmark:<br />'; print_r($quiz_passmark); echo 'user_quizzes:<br />'; print_r($user_quizzes); echo 'user_lesson_status:<br />'; print_r($user_lesson_status); echo 'Percent Competent:<br />'; print_r($user_quiz_grade); echo 'completed--:'.$completed."<br />"; echo 'user_lesson_end--:'.$user_lesson_end."<br />"; echo "_quiz_has_questions:".get_post_meta( $lesson_id, '_quiz_has_questions', true )."<br /><br />"; echo "this is the lersson info-----------------:"; print_r(get_comment_meta( $user_lesson_status->comment_ID )); $lessonquizdata = get_comment_meta( $user_lesson_status->comment_ID ); echo "lessonquizdata---:"; print_r(unserialize($lessonquizdata['quiz_answers'][0])); echo "</pre>"; */ $maincontent .= "<td>"; if ($completed == 1) { $percentcompleted = '100%'; } else { $lessonquizdata = get_comment_meta($user_lesson_status->comment_ID); $lessonquizdata_asked = count(explode(",", $lessonquizdata['questions_asked'][0])); $lessonquizdataanswered_quiz = count(unserialize($lessonquizdata['quiz_answers'][0])); $lquizcounter = 0; foreach ($lessonquizdataanswered_quiz as $lquiz) { if ($lquiz != "") { $lquizcounter++; } } /* echo "<pre>"; echo $lessonquizdata_asked."<br />"; print_r($lessonquizdata); print_r(unserialize($lessonquizdata['quiz_answers'][0])); echo "</pre>"; */ if ($user_lesson_status->comment_approved == "passed" || $user_lesson_status->comment_approved == "graded") { $percentcompleted = '100%'; } else { $percentcompleted = get_percentage($lessonquizdata_asked, $lquizcounter) . '%'; } } $maincontent .= '%S: ' . $percentcompleted . "<br />"; $maincontent .= '%C: ' . $user_quiz_grade . "%"; $maincontent .= "</td>"; ++$lesson_count; if ($completed) { ++$completed_count; } } $module_progress = $completed_count / $lesson_count * 100; if ($module_progress == 100) { $module_passed[] = 1; } } $countloop_user = 1; $user_info = get_userdata($user->user_id); $completionpermonth = groups_get_groupmeta($group_id, 'sensei_threshold', true); if (count($module_passed) >= $completionpermonth) { $ontract = "yes"; } else { $ontract = "no"; } $maincontent .= "<td>" . $ontract . "</td>"; if ($completed_course == 1) { $completed_course = $user_course_status->comment_date; } else { $completed_course = "No"; } $maincontent .= "<td>" . $completed_course . "</td>"; $maincontent .= "</tr>"; unset($module_passed); } echo '<table class="wp-list-table widefat fixed striped pages" style="width:500%; border-spacing: 0; text-align:center;" >'; echo "<tr>"; echo $lesson_title; echo "<td>On Track Or Not</td>"; echo "<td>Course Completed</td>"; echo "</tr>"; echo $maincontent; echo "</table>"; /* echo "<pre>"; print_r($array_to_csv); echo "</pre>"; */ //convert_to_csv($array_to_csv, 'report-total-progress_'.date('Y-m-d').'_group_'.$groupname.'_courseID_'.$courseid.'.csv', ','); } ?> <div class="form-wrap" style="padding:20px;"> <form action="" method="post"> <div> <label> Group: </label> <?php $groups = $wpdb->get_results('SELECT * FROM `wp_bp_groups`'); ?> <select name="group" required> <option value="">- Select One -</option> <?php foreach ($groups as $group) { echo "<option value='" . $group->id . "'>"; echo $group->name; echo "</option>"; } ?> </select> </div> <div> <label> Course: </label> <?php $course = new WP_Query(array('post_type' => 'course')); ?> <select name="course" required> <option value="">- Select One -</option> <?php // The Loop if ($course->have_posts()) { while ($course->have_posts()) { $course->the_post(); echo '<option value="' . $course->post->ID . '">' . get_the_title() . '</option>'; } } /* Restore original Post Data */ ?> </select> <?php wp_reset_postdata(); ?> </div> <br /><br /> <input type="submit" class="button button-primary" name="master-report" value="submit" /> </form> </div> <?php } //end master-report echo '</div>'; }