static function print_meta_box($post)
{
global $wpdb;
// select lessons in this course
$_lesson = new NamasteLMSLessonModel();
$lessons = $_lesson->select($post->ID);
// required lessons
$required_lessons = get_post_meta($post->ID, 'namaste_required_lessons', true);
if (!is_array($required_lessons)) {
$required_lessons = array();
}
// enrollment - for now free or admin approved, in the future also paid
$enroll_mode = get_post_meta($post->ID, 'namaste_enroll_mode', true);
$fee = get_post_meta($post->ID, 'namaste_fee', true);
$currency = get_option('namaste_currency');
$use_points_system = get_option('namaste_use_points_system');
//get award points for compliting the course
$award_points = get_post_meta($post->ID, 'namaste_award_points', true);
if ($award_points === '') {
$award_points = get_option('namaste_points_course');
}
do_action('namaste_single_course_points_print', $post);
// other courses
$other_courses = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->posts} tP\t\t\t\n\t\t\tWHERE post_type = 'namaste_course' AND (post_status='publish' OR post_status='draft') \n\t\t\tAND ID!=%d ORDER BY post_title", $post->ID));
// course will be accessible after these course(s) are completed
$course_access = get_post_meta($post->ID, 'namaste_access', true);
if (!is_array($course_access)) {
$course_access = array();
}
$unenroll_allowed = get_post_meta($post->ID, 'namaste_unenroll', true);
wp_nonce_field(plugin_basename(__FILE__), 'namaste_noncemeta');
if (@file_exists(get_stylesheet_directory() . '/namaste/course-meta-box.php')) {
require get_stylesheet_directory() . '/namaste/course-meta-box.php';
} else {
require NAMASTE_PATH . "/views/course-meta-box.php";
}
}
static function cleanup($course_id, $student_id)
{
global $wpdb;
$wpdb->query($wpdb->prepare("DELETE FROM " . NAMASTE_STUDENT_COURSES . " \n\t\t \tWHERE course_id = %d AND user_id=%d", $course_id, $student_id));
$wpdb->query($wpdb->prepare("DELETE FROM " . NAMASTE_STUDENT_LESSONS . " WHERE student_id= %d AND lesson_id IN (SELECT ID FROM {$wpdb->posts} tP JOIN {$wpdb->postmeta} tM ON tM.post_id = tP.ID AND tM.meta_key = 'namaste_course' AND tM.meta_value = %d WHERE post_type = 'namaste_lesson');", $student_id, $course_id));
// delete solutions
$wpdb->query($wpdb->prepare("DELETE FROM " . NAMASTE_STUDENT_HOMEWORKS . " WHERE student_id=%d\n\t\t\tAND homework_id IN (SELECT id FROM " . NAMASTE_HOMEWORKS . " WHERE course_id=%d)", $student_id, $course_id));
// cleanup exams data?
$use_exams = get_option('namaste_use_exams');
if ($use_exams and get_option('namaste_cleanup_exams') == 'yes') {
// select all exam IDs of related lessons
$_lesson = new NamasteLMSLessonModel();
$lessons = $_lesson->select($course_id);
$exam_ids = array(0);
foreach ($lessons as $lesson) {
$exam_id = get_post_meta($lesson->ID, 'namaste_required_exam', true);
if (!empty($exam_id)) {
$exam_ids[] = $exam_id;
}
}
// now delete
if ($use_exams == 'watu') {
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}watu_takings WHERE user_id=%d AND exam_id IN (" . implode(',', $exam_ids) . ")", $student_id));
}
if ($use_exams == 'watupro') {
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}watupro_taken_exams WHERE user_id=%d AND exam_id IN (" . implode(',', $exam_ids) . ")", $student_id));
$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}watupro_student_answers WHERE user_id=%d AND exam_id IN (" . implode(',', $exam_ids) . ")", $student_id));
}
}
}
static function student_lessons($simplified = false, $ob = null, $dir = null, $in_shortcode = false)
{
global $wpdb, $user_ID;
// student_id
$student_id = (empty($_GET['student_id']) or !current_user_can('namaste_manage')) ? $user_ID : $_GET['student_id'];
// select this student
$student = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->users} WHERE ID=%d", $student_id));
// select this course
$course = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->posts} WHERE id=%d", $_GET['course_id']));
// am I enrolled?
if (!current_user_can('namaste_manage') and !$in_shortcode) {
$enrolled = $wpdb->get_var($wpdb->prepare("SELECT id FROM " . NAMASTE_STUDENT_COURSES . " WHERE user_id = %d AND course_id = %d AND (status = 'enrolled' OR status = 'completed')", $student_id, $course->ID));
if (!$enrolled) {
_e("You must enroll in the course first before you can see the lessons", 'namaste');
return false;
}
}
// end enrolled check
// change student-lesson status?
if (!empty($_POST['change_status'])) {
$multiuser_access = 'all';
$multiuser_access = NamasteLMSMultiUser::check_access('students_access');
if ($multiuser_access == 'view') {
wp_die(__('You are not allowed to do this.', 'namaste'));
}
$result = NamasteLMSStudentModel::lesson_status($student->ID, $_POST['lesson_id'], $_POST['status']);
if (!$result) {
$error = __('The lesson cannot be completed because there are unsatisfied requirements', 'namaste');
}
}
// select lessons
$_lesson = new NamasteLMSLessonModel();
$select_ob = empty($ob) ? 'post_title' : $ob;
$lessons = $_lesson->select($course->ID, 'array', null, $ob, $dir);
$ids = array(0);
foreach ($lessons as $lesson) {
$ids[] = $lesson->ID;
}
$id_sql = implode(",", $ids);
// select homeworks and match to lessons
$homeworks = NamasteLMSHomeworkModel::select("WHERE lesson_id IN ({$id_sql})");
// using exams? select them too
$use_exams = get_option('namaste_use_exams');
$exams_table = $use_exams == 'watu' ? $wpdb->prefix . 'watu_master' : $wpdb->prefix . 'watupro_master';
$shortcode = $use_exams == 'watu' ? 'WATU' : 'WATUPRO';
// select student-lesson relation so we can match status
$student_lessons = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . NAMASTE_STUDENT_LESSONS . "\r\n\t\t\tWHERE student_id = %d", $student_id));
foreach ($lessons as $cnt => $lesson) {
$lesson_homeworks = array();
foreach ($homeworks as $homework) {
if ($homework->lesson_id == $lesson->ID) {
$lesson_homeworks[] = $homework;
}
}
$lessons[$cnt]->homeworks = $lesson_homeworks;
if ($use_exams) {
$required_exam = get_post_meta($lesson->ID, 'namaste_required_exam', true);
if ($required_exam) {
$exam = $wpdb->get_row("SELECT tE.*, tP.id as post_id FROM {$exams_table} tE, {$wpdb->posts} tP\r\n\t\t\t\t\t\tWHERE tE.ID = {$required_exam} AND tP.post_content LIKE CONCAT('%[{$shortcode} ', tE.ID, ']%')\r\n\t\t\t\t\t\tAND tP.post_status='publish' AND post_title!=''");
$lessons[$cnt]->exam = $exam;
}
}
// status
$status = null;
foreach ($student_lessons as $l) {
if ($l->lesson_id == $lesson->ID) {
$status = $l;
}
}
if (empty($status->id)) {
$lessons[$cnt]->status = __('Not started', 'namaste');
$lessons[$cnt]->statuscode = -1;
} else {
if ($status->status == 1) {
$lessons[$cnt]->status = __('Completed on', 'namaste') . ' ' . date(get_option('date_format'), strtotime($status->completion_date));
$lessons[$cnt]->statuscode = 1;
} else {
// in progress
$lessons[$cnt]->status = "<a href='#' onclick='namasteInProgress(" . $lesson->ID . ", " . $student_id . ");return false;'>" . __('In progress', 'namaste') . "</a>";
$lessons[$cnt]->statuscode = 0;
}
}
// end defining status
}
// external reorder?
if (empty($ob)) {
$lessons = apply_filters('namaste-reorder-lessons', $lessons);
}
// enqueue thickbox
wp_enqueue_script('thickbox', null, array('jquery'));
wp_enqueue_style('thickbox.css', '/' . WPINC . '/js/thickbox/thickbox.css', null, '1.0');
if (@file_exists(get_stylesheet_directory() . '/namaste/student-lessons.php')) {
require get_stylesheet_directory() . '/namaste/student-lessons.php';
} else {
require NAMASTE_PATH . "/views/student-lessons.php";
}
}
static function lessons($atts)
{
global $post;
$status = @$atts[0];
$course_id = empty($atts[1]) ? $post->ID : $atts[1];
$ob = empty($atts[2]) ? '' : "tP." . $atts[2];
$dir = empty($atts[3]) ? 'ASC' : $atts[3];
$list_tag = empty($atts[4]) ? 'ul' : $atts[4];
// validate the user input
if ($list_tag != 'ul' && $list_tag != 'ol') {
$list_tag = 'ul';
}
// are we in the course desc page or in a lesson of this course?
$post = get_post($course_id);
if ($post->post_type == 'namaste_lesson') {
$course_id = get_post_meta($course_id, 'namaste_course', true);
}
// when status column is NOT passed we have a simple task and won't call the student_lessons() method
// this is because the student_lessons() method is for logged in users only.
if (empty($status) or !is_user_logged_in()) {
$_lesson = new NamasteLMSLessonModel();
$lessons = $_lesson->select($course_id, 'array', null, $ob, $dir);
$content = "<" . $list_tag . ">";
foreach ($lessons as $lesson) {
$content .= "<li><a href='" . get_permalink($lesson->ID) . "'>" . $lesson->post_title . "</a></li>";
}
$content .= "</" . $list_tag . ">";
return $content;
}
// status column is requested so we'll have to call the model method
ob_start();
$_GET['course_id'] = $course_id;
$simplified = empty($status) ? 2 : 1;
// simplified is always at least 1 when called as shortcode. But will be 2 if status column is not requested
NamasteLMSLessonModel::student_lessons($simplified, $ob, $dir, true);
$content = ob_get_contents();
ob_end_clean();
return $content;
}
static function full_select($id)
{
global $wpdb;
$_course = new NamasteLMSCourseModel();
$_lesson = new NamasteLMSLessonModel();
// select this homework and lesson
$homework = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . NAMASTE_HOMEWORKS . "\n\t\t\tWHERE id=%d", $id));
// select course
$course = $_course->select($homework->course_id);
// select lesson
$lesson = $_lesson->select($course->ID, 'single', $homework->lesson_id);
return array($homework, $course, $lesson);
}
function namaste_ajax()
{
global $wpdb, $user_ID;
$type = empty($_POST['type']) ? $_GET['type'] : $_POST['type'];
switch ($type) {
case 'lessons_for_course':
$_lesson = new NamasteLMSLessonModel();
echo $_lesson->select($_POST['course_id'], 'json', null, 'ID');
break;
// load notes for student homework
// load notes for student homework
case 'load_notes':
// unless I am manager I can see other user's notes
if ($user_ID != $_GET['student_id'] and !current_user_can('namaste_manage')) {
wp_die('You are not allowed to see these notes.', 'namaste');
}
// select notes
$notes = $wpdb->get_results($wpdb->prepare("SELECT tN.*, tU.user_login as username\n\t\t\t FROM " . NAMASTE_HOMEWORK_NOTES . " tN JOIN {$wpdb->users} tU ON tU.ID = tN.teacher_id\n\t\t\t\tWHERE homework_id=%d AND student_id=%d ORDER BY tN.id DESC", $_GET['homework_id'], $_GET['student_id']));
// select homework
$homework = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . NAMASTE_HOMEWORKS . " WHERE id=%d", $_GET['homework_id']));
if (@file_exists(get_stylesheet_directory() . '/namaste/homework-notes.php')) {
require get_stylesheet_directory() . '/namaste/homework-notes.php';
} else {
require NAMASTE_PATH . "/views/homework-notes.php";
}
break;
// show lesson progress
// show lesson progress
case 'lesson_progress':
// if i am not manager I can see only my own todo
if (!current_user_can('namaste_manage') and $user_ID != $_GET['student_id']) {
die(__("You are not allowed to view this", 'namaste'));
}
// select lesson and student
$lesson = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->posts} WHERE ID=%d", $_GET['lesson_id']));
$student = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->users} WHERE ID=%d", $_GET['student_id']));
$todo = NamasteLMSLessonModel::todo($_GET['lesson_id'], $_GET['student_id']);
if (@file_exists(get_stylesheet_directory() . '/namaste/lesson-todo.php')) {
require get_stylesheet_directory() . '/namaste/lesson-todo.php';
} else {
require NAMASTE_PATH . "/views/lesson-todo.php";
}
break;
// display payment screen for a course
// display payment screen for a course
case 'course_payment':
// select course
$course = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->posts} WHERE ID=%d", $_GET['course_id']));
$fee = get_post_meta($course->ID, 'namaste_fee', true);
$fee = apply_filters('namaste-coupon-applied', $fee);
$currency = get_option('namaste_currency');
$accept_other_payment_methods = get_option('namaste_accept_other_payment_methods');
$accept_paypal = get_option('namaste_accept_paypal');
$paypal_id = get_option('namaste_paypal_id');
if ($accept_other_payment_methods) {
$other_payment_methods = stripslashes(get_option('namaste_other_payment_methods'));
$other_payment_methods = str_replace('{{course-id}}', $course->ID, $other_payment_methods);
$other_payment_methods = str_replace('{{course-name}}', $course->post_title, $other_payment_methods);
$other_payment_methods = str_replace('{{user-id}}', $_GET['student_id'], $other_payment_methods);
$other_payment_methods = str_replace('{{amount}}', $fee, $other_payment_methods);
$other_payment_methods = str_replace('{{item-type}}', 'course', $other_payment_methods);
$other_payment_methods = do_shortcode($other_payment_methods);
}
// return URL
$paypal_return = get_option('namaste_paypal_return');
if (empty($paypal_return)) {
$paypal_return = get_permalink($course->ID);
}
if (!strstr($paypal_return, 'http')) {
$paypal_return = 'http://' . $paypal_return;
}
if (@file_exists(get_stylesheet_directory() . '/namaste/course-pay.php')) {
require get_stylesheet_directory() . '/namaste/course-pay.php';
} else {
require NAMASTE_PATH . "/views/course-pay.php";
}
break;
// set student's grade for a course or lesson
// set student's grade for a course or lesson
case 'set_grade':
if (!current_user_can('namaste_manage')) {
die(__('You are not allowed to grade', 'namaste'));
}
if ($_POST['grade_what'] == 'course') {
$table = NAMASTE_STUDENT_COURSES;
$field = 'course_id';
$student_field = 'user_id';
do_action('namaste_graded_course', $_POST['student_id'], $_POST['item_id'], $_POST['grade']);
} else {
$table = NAMASTE_STUDENT_LESSONS;
$field = 'lesson_id';
$student_field = 'student_id';
do_action('namaste_graded_lesson', $_POST['student_id'], $_POST['item_id'], $_POST['grade']);
}
// now update the grade
$wpdb->query($wpdb->prepare("UPDATE {$table} SET grade=%s WHERE {$field}=%d AND {$student_field}=%d", $_POST['grade'], $_POST['item_id'], $_POST['student_id']));
break;
}
exit;
}
static function manage()
{
global $wpdb;
$_course = new NamasteLMSCourseModel();
$_lesson = new NamasteLMSLessonModel();
// select grades
$grades = explode(",", stripslashes(get_option('namaste_grading_system')));
// select courses
$courses = $_course->select();
$courses = apply_filters('namaste-homeworks-select-courses', $courses);
// if course is selected, select in progress students in the course,
// select lessons and homeworks in it too
if (!empty($_GET['course_id'])) {
do_action('namaste-check-permissions', 'course', $_GET['course_id']);
$this_course = $_course->select($_GET['course_id']);
$lessons = $_lesson->select($_GET['course_id']);
$lids = array(0);
foreach ($lessons as $lesson) {
$lids[] = $lesson->ID;
}
$students = $wpdb->get_results($wpdb->prepare("SELECT tU.*, tS.status as namaste_status, tS.grade as course_grade \n\t\t \t\tFROM {$wpdb->users} tU JOIN " . NAMASTE_STUDENT_COURSES . " tS \n\t\t \t\tON tS.user_id = tU.ID AND tS.course_id=%d AND (tS.status='enrolled' OR status='completed')\n\t\t \t\tORDER BY user_nicename", $_GET['course_id']));
$stids = array(0);
foreach ($students as $student) {
$stids[] = $student->ID;
}
// select student-lessons and student-homeworks for this course so we can have the grades
$student_lessons = $wpdb->get_results("SELECT * FROM " . NAMASTE_STUDENT_LESSONS . "\n\t\t\t\tWHERE lesson_id IN (" . implode(',', $lids) . ") AND student_id IN (" . implode(',', $stids) . ")\n\t\t\t\tORDER BY id");
$student_homeworks = $wpdb->get_results("SELECT tSH.*, tH.lesson_id as lesson_id FROM " . NAMASTE_STUDENT_HOMEWORKS . " tSH\n\t\t\t\tJOIN " . NAMASTE_HOMEWORKS . " tH ON tH.id = tSH.homework_id\n\t\t\t\tWHERE tH.lesson_id IN (" . implode(',', $lids) . ") AND tSH.student_id IN (" . implode(',', $stids) . ") \n\t\t\t\tORDER BY id");
// now match everything together so we have it ready for the table
foreach ($students as $cnt => $student) {
$lesson_grades = array();
$lesson_ids = array();
foreach ($lessons as $lesson) {
foreach ($student_lessons as $student_lesson) {
if ($student_lesson->student_id == $student->ID and $student_lesson->lesson_id == $lesson->ID) {
// get homework grades
$homework_grades = array();
$lesson_ids[] = $lesson->ID;
foreach ($student_homeworks as $student_homework) {
if ($student_homework->student_id != $student->ID) {
continue;
}
if ($student_homework->lesson_id != $lesson->ID) {
continue;
}
if (empty($student_homework->grade)) {
continue;
}
$homework_grades[] = $student_homework->grade;
}
// end foreach student_homeworks
$lesson_grades[] = array('homework_grades' => $homework_grades, "final_grade" => $student_lesson->grade, 'lesson_id' => $student_lesson->lesson_id);
}
// end student & lesson match
}
// end foreach $student_lessons
}
// end foreach $lesson
$students[$cnt]->lesson_grades = $lesson_grades;
$students[$cnt]->lesson_ids = $lesson_ids;
}
// end foreach $student
}
// end if $_GET[course_id]
if (@file_exists(get_stylesheet_directory() . '/namaste/gradebook.html.php')) {
require get_stylesheet_directory() . '/namaste/gradebook.html.php';
} else {
require NAMASTE_PATH . "/views/gradebook.html.php";
}
}
