/**
* Sets up the object course query
* that will be used int he render method.
*
* @since 1.9.0
*/
protected function setup_course_query()
{
$status_query = array('user_id' => get_current_user_id(), 'type' => 'sensei_course_status');
$course_statuses = WooThemes_Sensei_Utils::sensei_check_for_activity($status_query, true);
// User may only be on 1 Course
if (!is_array($course_statuses)) {
$course_statuses = array($course_statuses);
}
$completed_ids = $active_ids = array();
foreach ($course_statuses as $course_status) {
if (WooThemes_Sensei_Utils::user_completed_course($course_status, get_current_user_id())) {
$completed_ids[] = $course_status->comment_post_ID;
} else {
$active_ids[] = $course_status->comment_post_ID;
}
}
if ('completed' == $this->status) {
$included_courses = $completed_ids;
} elseif ('active' == $this->status) {
$included_courses = $active_ids;
} else {
$included_courses = array_merge($active_ids, $completed_ids);
}
// course query parameters
$query_args = array('post_type' => 'course', 'post_status' => 'publish', 'orderby' => $this->orderby, 'order' => $this->order, 'posts_per_page' => $this->number, 'post__in' => $included_courses);
$this->query = new WP_Query($query_args);
}
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>';
}
/**
* 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);
}
/**
* sensei_check_prerequisite_course function.
*
* @access public
* @param mixed $course_id
* @return void
*/
function sensei_check_prerequisite_course($course_id)
{
global $current_user;
// Get User Meta
get_currentuserinfo();
$course_prerequisite_id = (int) get_post_meta($course_id, '_course_prerequisite', true);
$prequisite_complete = false;
if (0 < absint($course_prerequisite_id)) {
$prequisite_complete = WooThemes_Sensei_Utils::user_completed_course($course_prerequisite_id, $current_user->ID);
} else {
$prequisite_complete = true;
}
// End If Statement
return $prequisite_complete;
}
/**
* Activate single course if already purchases
* @return void
*/
public function activate_purchased_single_course()
{
global $post, $current_user;
if (WooThemes_Sensei_Utils::sensei_is_woocommerce_activated()) {
if (!is_user_logged_in()) {
return;
}
if (!isset($post->ID)) {
return;
}
$user_id = $current_user->ID;
$course_id = $post->ID;
$course_product_id = (int) get_post_meta($course_id, '_course_woocommerce_product', true);
if (!$course_product_id) {
return;
}
$user_course_status = WooThemes_Sensei_Utils::user_course_status(intval($course_id), $user_id);
// Ignore course if already completed
if (WooThemes_Sensei_Utils::user_completed_course($user_course_status)) {
return;
}
// Ignore course if already started
if ($user_course_status) {
return;
}
// Get all user's orders
$order_args = array('post_type' => 'shop_order', 'posts_per_page' => -1, 'post_status' => array('wc-processing', 'wc-completed'), 'meta_query' => array(array('key' => '_customer_user', 'value' => $user_id)), 'fields' => 'ids');
$orders = get_posts($order_args);
foreach ($orders as $order_post_id) {
// Get course product IDs from order
$order = new WC_Order($order_post_id);
$items = $order->get_items();
foreach ($items as $item) {
$product = wc_get_product($item['product_id']);
// handle product bundles
if ($product->is_type('bundle')) {
$bundled_product = new WC_Product_Bundle($product->id);
$bundled_items = $bundled_product->get_bundled_items();
foreach ($bundled_items as $item) {
if ($item->product_id == $course_product_id) {
WooThemes_Sensei_Utils::user_start_course($user_id, $course_id);
return;
}
}
} else {
// handle regular products
if ($item['product_id'] == $course_product_id) {
WooThemes_Sensei_Utils::user_start_course($user_id, $course_id);
return;
}
}
}
}
}
}
/**
* load_user_courses_content generates HTML for user's active & completed courses
* @since 1.4.0
* @param object $user Queried user object
* @param boolean $manage Whether the user has permission to manage the courses
* @return string HTML displayng course data
*/
public function load_user_courses_content($user = false, $manage = false)
{
global $woothemes_sensei, $post, $wp_query, $course, $my_courses_page, $my_courses_section;
// Build Output HTML
$complete_html = $active_html = '';
if ($user) {
$my_courses_page = true;
// Allow action to be run before My Courses content has loaded
do_action('sensei_before_my_courses', $user->ID);
// Logic for Active and Completed Courses
$per_page = 20;
if (isset($woothemes_sensei->settings->settings['my_course_amount']) && 0 < absint($woothemes_sensei->settings->settings['my_course_amount'])) {
$per_page = absint($woothemes_sensei->settings->settings['my_course_amount']);
}
$course_statuses = WooThemes_Sensei_Utils::sensei_check_for_activity(array('user_id' => $user->ID, 'type' => 'sensei_course_status'), true);
// User may only be on 1 Course
if (!is_array($course_statuses)) {
$course_statuses = array($course_statuses);
}
$completed_ids = $active_ids = array();
foreach ($course_statuses as $course_status) {
if (WooThemes_Sensei_Utils::user_completed_course($course_status, $user->ID)) {
$completed_ids[] = $course_status->comment_post_ID;
} else {
$active_ids[] = $course_status->comment_post_ID;
}
}
$active_count = $completed_count = 0;
$active_courses = array();
if (0 < intval(count($active_ids))) {
$my_courses_section = 'active';
$active_courses = $woothemes_sensei->post_types->course->course_query($per_page, 'usercourses', $active_ids);
$active_count = count($active_ids);
}
// End If Statement
$completed_courses = array();
if (0 < intval(count($completed_ids))) {
$my_courses_section = 'completed';
$completed_courses = $woothemes_sensei->post_types->course->course_query($per_page, 'usercourses', $completed_ids);
$completed_count = count($completed_ids);
}
// End If Statement
$lesson_count = 1;
$active_page = 1;
if (isset($_GET['active_page']) && 0 < intval($_GET['active_page'])) {
$active_page = $_GET['active_page'];
}
$completed_page = 1;
if (isset($_GET['completed_page']) && 0 < intval($_GET['completed_page'])) {
$completed_page = $_GET['completed_page'];
}
foreach ($active_courses as $course_item) {
$course_lessons = $woothemes_sensei->post_types->course->course_lessons($course_item->ID);
$lessons_completed = 0;
foreach ($course_lessons as $lesson) {
if (WooThemes_Sensei_Utils::user_completed_lesson($lesson->ID, $user->ID)) {
++$lessons_completed;
}
}
// Get Course Categories
$category_output = get_the_term_list($course_item->ID, 'course-category', '', ', ', '');
$active_html .= '<article class="' . esc_attr(join(' ', get_post_class(array('course', 'post'), $course_item->ID))) . '">';
// Image
$active_html .= $woothemes_sensei->post_types->course->course_image(absint($course_item->ID));
// Title
$active_html .= '<header>';
$active_html .= '<h2><a href="' . esc_url(get_permalink(absint($course_item->ID))) . '" title="' . esc_attr($course_item->post_title) . '">' . esc_html($course_item->post_title) . '</a></h2>';
$active_html .= '</header>';
$active_html .= '<section class="entry">';
$active_html .= '<p class="sensei-course-meta">';
// Author
$user_info = get_userdata(absint($course_item->post_author));
if (isset($woothemes_sensei->settings->settings['course_author']) && $woothemes_sensei->settings->settings['course_author']) {
$active_html .= '<span class="course-author">' . __('by ', 'woothemes-sensei') . '<a href="' . esc_url(get_author_posts_url(absint($course_item->post_author))) . '" title="' . esc_attr($user_info->display_name) . '">' . esc_html($user_info->display_name) . '</a></span>';
}
// End If Statement
// Lesson count for this author
$lesson_count = $woothemes_sensei->post_types->course->course_lesson_count(absint($course_item->ID));
// Handle Division by Zero
if (0 == $lesson_count) {
$lesson_count = 1;
}
// End If Statement
$active_html .= '<span class="course-lesson-count">' . $lesson_count . ' ' . apply_filters('sensei_lessons_text', __('Lessons', 'woothemes-sensei')) . '</span>';
// Course Categories
if ('' != $category_output) {
$active_html .= '<span class="course-category">' . sprintf(__('in %s', 'woothemes-sensei'), $category_output) . '</span>';
}
// End If Statement
$active_html .= '<span class="course-lesson-progress">' . sprintf(__('%1$d of %2$d lessons completed', 'woothemes-sensei'), $lessons_completed, $lesson_count) . '</span>';
$active_html .= '</p>';
$active_html .= '<p class="course-excerpt">' . apply_filters('get_the_excerpt', $course_item->post_excerpt) . '</p>';
$progress_percentage = abs(round(doubleval($lessons_completed) * 100 / $lesson_count, 0));
$active_html .= $this->get_progress_meter($progress_percentage);
$active_html .= '</section>';
if ($manage) {
$active_html .= '<section class="entry-actions">';
$active_html .= '<form method="POST" action="' . esc_url(remove_query_arg(array('active_page', 'completed_page'))) . '">';
$active_html .= '<input type="hidden" name="' . esc_attr('woothemes_sensei_complete_course_noonce') . '" id="' . esc_attr('woothemes_sensei_complete_course_noonce') . '" value="' . esc_attr(wp_create_nonce('woothemes_sensei_complete_course_noonce')) . '" />';
$active_html .= '<input type="hidden" name="course_complete_id" id="course-complete-id" value="' . esc_attr(absint($course_item->ID)) . '" />';
if (0 < absint(count($course_lessons)) && $woothemes_sensei->settings->settings['course_completion'] == 'complete') {
$active_html .= '<span><input name="course_complete" type="submit" class="course-complete" value="' . apply_filters('sensei_mark_as_complete_text', __('Mark as Complete', 'woothemes-sensei')) . '"/></span>';
}
// End If Statement
$course_purchased = false;
if (WooThemes_Sensei_Utils::sensei_is_woocommerce_activated()) {
// Get the product ID
$wc_post_id = get_post_meta(absint($course_item->ID), '_course_woocommerce_product', true);
if (0 < $wc_post_id) {
$course_purchased = WooThemes_Sensei_Utils::sensei_customer_bought_product($user->user_email, $user->ID, $wc_post_id);
}
// End If Statement
}
// End If Statement
if (!$course_purchased) {
$active_html .= '<span><input name="course_complete" type="submit" class="course-delete" value="' . apply_filters('sensei_delete_course_text', __('Delete Course', 'woothemes-sensei')) . '"/></span>';
}
// End If Statement
$active_html .= '</form>';
$active_html .= '</section>';
}
$active_html .= '</article>';
}
// Active pagination
if ($active_count > $per_page) {
$current_page = 1;
if (isset($_GET['active_page']) && 0 < intval($_GET['active_page'])) {
$current_page = $_GET['active_page'];
}
$active_html .= '<nav class="pagination woo-pagination">';
$total_pages = ceil($active_count / $per_page);
$link = '';
if ($current_page > 1) {
$prev_link = add_query_arg('active_page', $current_page - 1);
$active_html .= '<a class="prev page-numbers" href="' . esc_url($prev_link) . '">' . __('Previous', 'woothemes-sensei') . '</a> ';
}
for ($i = 1; $i <= $total_pages; $i++) {
$link = add_query_arg('active_page', $i);
if ($i == $current_page) {
$active_html .= '<span class="page-numbers current">' . $i . '</span> ';
} else {
$active_html .= '<a class="page-numbers" href="' . esc_url($link) . '">' . $i . '</a> ';
}
}
if ($current_page < $total_pages) {
$next_link = add_query_arg('active_page', $current_page + 1);
$active_html .= '<a class="next page-numbers" href="' . esc_url($next_link) . '">' . __('Next', 'woothemes-sensei') . '</a> ';
}
$active_html .= '</nav>';
}
foreach ($completed_courses as $course_item) {
$course = $course_item;
// Get Course Categories
$category_output = get_the_term_list($course_item->ID, 'course-category', '', ', ', '');
$complete_html .= '<article class="' . join(' ', get_post_class(array('course', 'post'), $course_item->ID)) . '">';
// Image
$complete_html .= $woothemes_sensei->post_types->course->course_image(absint($course_item->ID));
// Title
$complete_html .= '<header>';
$complete_html .= '<h2><a href="' . esc_url(get_permalink(absint($course_item->ID))) . '" title="' . esc_attr($course_item->post_title) . '">' . esc_html($course_item->post_title) . '</a></h2>';
$complete_html .= '</header>';
$complete_html .= '<section class="entry">';
$complete_html .= '<p class="sensei-course-meta">';
// Author
$user_info = get_userdata(absint($course_item->post_author));
if (isset($woothemes_sensei->settings->settings['course_author']) && $woothemes_sensei->settings->settings['course_author']) {
$complete_html .= '<span class="course-author">' . __('by ', 'woothemes-sensei') . '<a href="' . esc_url(get_author_posts_url(absint($course_item->post_author))) . '" title="' . esc_attr($user_info->display_name) . '">' . esc_html($user_info->display_name) . '</a></span>';
}
// End If Statement
// Lesson count for this author
$complete_html .= '<span class="course-lesson-count">' . $woothemes_sensei->post_types->course->course_lesson_count(absint($course_item->ID)) . ' ' . apply_filters('sensei_lessons_text', __('Lessons', 'woothemes-sensei')) . '</span>';
// Course Categories
if ('' != $category_output) {
$complete_html .= '<span class="course-category">' . sprintf(__('in %s', 'woothemes-sensei'), $category_output) . '</span>';
}
// End If Statement
$complete_html .= '</p>';
$complete_html .= '<p class="course-excerpt">' . apply_filters('get_the_excerpt', $course_item->post_excerpt) . '</p>';
$complete_html .= $this->get_progress_meter(100);
if ($manage) {
$has_quizzes = $woothemes_sensei->post_types->course->course_quizzes($course_item->ID, true);
// Output only if there is content to display
if (has_filter('sensei_results_links') || $has_quizzes) {
$complete_html .= '<p class="sensei-results-links">';
$results_link = '';
if ($has_quizzes) {
$results_link = '<a class="button view-results" href="' . $woothemes_sensei->course_results->get_permalink($course_item->ID) . '">' . apply_filters('sensei_view_results_text', __('View results', 'woothemes-sensei')) . '</a>';
}
$complete_html .= apply_filters('sensei_results_links', $results_link);
$complete_html .= '</p>';
}
}
$complete_html .= '</section>';
$complete_html .= '</article>';
}
// Active pagination
if ($completed_count > $per_page) {
$current_page = 1;
if (isset($_GET['completed_page']) && 0 < intval($_GET['completed_page'])) {
$current_page = $_GET['completed_page'];
}
$complete_html .= '<nav class="pagination woo-pagination">';
$total_pages = ceil($completed_count / $per_page);
$link = '';
if ($current_page > 1) {
$prev_link = add_query_arg('completed_page', $current_page - 1);
$complete_html .= '<a class="prev page-numbers" href="' . esc_url($prev_link) . '">' . __('Previous', 'woothemes-sensei') . '</a> ';
}
for ($i = 1; $i <= $total_pages; $i++) {
$link = add_query_arg('completed_page', $i);
if ($i == $current_page) {
$complete_html .= '<span class="page-numbers current">' . $i . '</span> ';
} else {
$complete_html .= '<a class="page-numbers" href="' . esc_url($link) . '">' . $i . '</a> ';
}
}
if ($current_page < $total_pages) {
$next_link = add_query_arg('completed_page', $current_page + 1);
$complete_html .= '<a class="next page-numbers" href="' . esc_url($next_link) . '">' . __('Next', 'woothemes-sensei') . '</a> ';
}
$complete_html .= '</nav>';
}
}
// End If Statement
if ($manage) {
$no_active_message = apply_filters('sensei_no_active_courses_user_text', __('You have no active courses.', 'woothemes-sensei'));
$no_complete_message = apply_filters('sensei_no_complete_courses_user_text', __('You have not completed any courses yet.', 'woothemes-sensei'));
} else {
$no_active_message = apply_filters('sensei_no_active_courses_learner_text', __('This learner has no active courses.', 'woothemes-sensei'));
$no_complete_message = apply_filters('sensei_no_complete_courses_learner_text', __('This learner has not completed any courses yet.', 'woothemes-sensei'));
}
ob_start();
?>
<?php
do_action('sensei_before_user_courses');
?>
<?php
if ($manage && (!isset($woothemes_sensei->settings->settings['messages_disable']) || !$woothemes_sensei->settings->settings['messages_disable'])) {
?>
<p class="my-messages-link-container"><a class="my-messages-link" href="<?php
echo get_post_type_archive_link('sensei_message');
?>
" title="<?php
_e('View & reply to private messages sent to your course & lesson teachers.', 'woothemes-sensei');
?>
"><?php
_e('My Messages', 'woothemes-sensei');
?>
</a></p>
<?php
}
?>
<div id="my-courses">
<ul>
<li><a href="#active-courses"><?php
echo apply_filters('sensei_active_courses_text', __('Active Courses', 'woothemes-sensei'));
?>
</a></li>
<li><a href="#completed-courses"><?php
echo apply_filters('sensei_completed_courses_text', __('Completed Courses', 'woothemes-sensei'));
?>
</a></li>
</ul>
<?php
do_action('sensei_before_active_user_courses');
?>
<?php
$course_page_id = intval($woothemes_sensei->settings->settings['course_page']);
if (0 < $course_page_id) {
$course_page_url = get_permalink($course_page_id);
} elseif (0 == $course_page_id) {
$course_page_url = get_post_type_archive_link('course');
}
?>
<div id="active-courses">
<?php
if ('' != $active_html) {
echo $active_html;
} else {
?>
<div class="sensei-message info"><?php
echo $no_active_message;
?>
<a href="<?php
echo $course_page_url;
?>
"><?php
apply_filters('sensei_start_a_course_text', _e('Start a Course!', 'woothemes-sensei'));
?>
</a></div>
<?php
}
// End If Statement
?>
</div>
<?php
do_action('sensei_after_active_user_courses');
?>
<?php
do_action('sensei_before_completed_user_courses');
?>
<div id="completed-courses">
<?php
if ('' != $complete_html) {
echo $complete_html;
} else {
?>
<div class="sensei-message info"><?php
echo $no_complete_message;
?>
</div>
<?php
}
// End If Statement
?>
</div>
<?php
do_action('sensei_after_completed_user_courses');
?>
</div>
<?php
do_action('sensei_after_user_courses');
?>
<?php
return ob_get_clean();
}
/**
* Prints out the course action buttons links
*
* - complete course
* - delete course
*
* @param WP_Post $course
*/
public static function the_course_action_buttons($course)
{
if (is_user_logged_in()) {
?>
<section class="entry-actions">
<form method="POST" action="<?php
echo esc_url(remove_query_arg(array('active_page', 'completed_page')));
?>
">
<input type="hidden"
name="<?php
esc_attr_e('woothemes_sensei_complete_course_noonce');
?>
"
id="<?php
esc_attr_e('woothemes_sensei_complete_course_noonce');
?>
"
value="<?php
esc_attr_e(wp_create_nonce('woothemes_sensei_complete_course_noonce'));
?>
"
/>
<input type="hidden" name="course_complete_id" id="course-complete-id" value="<?php
esc_attr_e(intval($course->ID));
?>
" />
<?php
if (0 < absint(count(Sensei()->course->course_lessons($course->ID))) && Sensei()->settings->settings['course_completion'] == 'complete') {
?>
<span><input name="course_complete" type="submit" class="course-complete" value="<? echo apply_filters( 'sensei_mark_as_complete_text', __( 'Mark as Complete', 'woothemes-sensei' ) ); ?>/></span>
<?php
}
// End If Statement
$course_purchased = false;
if (WooThemes_Sensei_Utils::sensei_is_woocommerce_activated()) {
// Get the product ID
$wc_post_id = get_post_meta(intval($course->ID), '_course_woocommerce_product', true);
if (0 < $wc_post_id) {
$user = wp_get_current_user();
$course_purchased = WooThemes_Sensei_Utils::sensei_customer_bought_product($user->user_email, $user->ID, $wc_post_id);
}
// End If Statement
}
// End If Statement
if (!$course_purchased && !WooThemes_Sensei_Utils::user_completed_course($course->ID, get_current_user_id())) {
?>
<span><input name="course_complete" type="submit" class="course-delete" value="<?php
echo apply_filters('sensei_delete_course_text', __('Delete Course', 'woothemes-sensei'));
?>
"/></span>
<?php
}
// End If Statement
$has_quizzes = Sensei()->course->course_quizzes($course->ID, true);
$results_link = '';
if ($has_quizzes) {
$results_link = '<a class="button view-results" href="' . Sensei()->course_results->get_permalink($course->ID) . '">' . apply_filters('sensei_view_results_text', __('View results', 'woothemes-sensei')) . '</a>';
}
// Output only if there is content to display
if (has_filter('sensei_results_links') || $has_quizzes) {
?>
<p class="sensei-results-links">
<?php
echo apply_filters('sensei_results_links', $results_link);
?>
</p>
<?php
}
// end if has filter
?>
</form>
</section>
<?php
}
// end if is user logged in
}
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>';
}
