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>';
}
