__("PSPerception Lessons", 'perception'), "labels" => array ( "name"=>__("PS Lessons", 'perception'), "singular_name"=>__("Lesson", 'perception'), "add_new_item"=>__("Add New Lesson", 'perception'), 'bp_activity_admin_filter' => __( 'Lessons', 'perception' ), 'bp_activity_front_filter' => __( 'Lessons', 'perception' ), 'bp_activity_new_post' => __( '%1$s created a new Lesson', 'perception' ), 'bp_activity_comments_admin_filter' => __( 'Comments about Lessons', 'perception' ), 'bp_activity_comments_front_filter' => __( 'Lesson Comments', 'perception' ), 'bp_activity_new_comment' => __( '%1$s commented on the Lesson', 'perception' ), ), "public"=> true, "show_ui"=>true, 'show_in_rest' => true, "has_archive"=>true, "rewrite"=> array("slug"=>$lesson_slug, "with_front"=>false), "description"=>__("This will create a new lesson in your PSPerception LMS.",'perception'), "supports"=>array("title", 'editor', 'author', 'thumbnail', 'excerpt', 'comments', 'post-formats', 'buddypress-activity'), 'bp_activity' => array( 'action_id' => 'new_lesson', 'contexts' => array( 'activity', 'member' ), 'comment_action_id' => 'new_lesson_comment', 'position' => 70, ), "taxonomies"=>array("category", 'post_tag'), "show_in_nav_menus"=>'true', 'show_in_menu' => 'perception_options', "register_meta_box_cb"=>array(__CLASS__,"meta_boxes") ); register_post_type( 'perception_lesson', $args ); } static function meta_boxes() { add_meta_box("perception_meta", __("PSPerception Settings", 'perception'), array(__CLASS__, "print_meta_box"), "perception_lesson", 'normal', 'high'); } static function print_meta_box($post) { global $wpdb; $_course = new PSPerceptionLMSCourseModel(); // select all existing courses $courses = $_course -> select(); // which courses do this lesson belong to? $course_id = get_post_meta($post->ID, 'perception_course', true); // module? $use_modules = get_option('perception_use_modules'); if($use_modules) { $module_id = get_post_meta($post->ID, 'perception_module', true); $_module = new PSPerceptionLMSModuleModel(); $modules = $_module->select(0, $course_id); } // other lessons in this course $other_lessons = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->posts} tP JOIN {$wpdb->postmeta} tM ON tM.post_id = tP.ID AND tM.meta_key = 'perception_course' AND tM.meta_value = %d WHERE post_type = 'perception_lesson' AND (post_status='publish' OR post_status='draft') AND ID!=%d ORDER BY ID ASC", $course_id, $post->ID)); $other_lessons = apply_filters('perception-reorder-lessons', $other_lessons); $lesson_access = get_post_meta($post->ID, 'perception_access', true); if(!is_array($lesson_access)) $lesson_access = array(); $lesson_completion = get_post_meta($post->ID, 'perception_completion', true); if(!is_array($lesson_completion)) $lesson_completion = array(); $required_homeworks = get_post_meta($post->ID, 'perception_required_homeworks', true); if(!is_array($required_homeworks)) $required_homeworks = array(); $required_exam = get_post_meta($post->ID, 'perception_required_exam', true); $required_grade = get_post_meta($post->ID, 'perception_required_grade', true); if(!is_array($required_grade)) $required_grade = array($required_grade); // select assignments $homeworks = PSPerceptionLMSHomeworkModel::select($wpdb->prepare(' WHERE lesson_id = %d', $post->ID)); // select quizzes from Watu/WatuPRO $use_exams = get_option('perception_use_exams'); if(!empty($use_exams)) { if($use_exams == 'watu') { $exams_table = $wpdb->prefix.'watu_master'; $grades_table = $wpdb->prefix.'watu_grading'; } if($use_exams == 'watupro') { $exams_table = $wpdb->prefix.'watupro_master'; $grades_table = $wpdb->prefix.'watupro_grading'; } $exams = $wpdb->get_results("SELECT * FROM $exams_table ORDER BY name"); // fill grades $grades = $wpdb->get_results("SELECT * FROM $grades_table ORDER BY id"); // grades of the currently selected exam. Will be filled only if such is selected $required_grades = array(); foreach($exams as $cnt=>$exam) { $exam_grades = array(); foreach($grades as $grade) { if(!empty($exam->reuse_default_grades) and empty($grade->exam_id)) $exam_grades[] = $grade; if(empty($exam->reuse_default_grades) and $grade->exam_id == $exam->ID) $exam_grades[] = $grade; } $exams[$cnt]->grades = $exam_grades; if($required_exam and $required_exam == $exam->ID) $required_grades = $exam_grades; } } $use_points_system = get_option('perception_use_points_system'); $use_grading_system = get_option('perception_use_grading_system'); $award_points = get_post_meta($post->ID, 'perception_award_points', true); if($award_points === '') $award_points = get_option('perception_points_lesson'); wp_nonce_field( plugin_basename( __FILE__ ), 'perception_noncemeta' ); if(@file_exists(get_stylesheet_directory().'/perception/lesson-meta-box.php')) require get_stylesheet_directory().'/perception/lesson-meta-box.php'; else require(PERCEPTION_PATH."/views/lesson-meta-box.php"); } static function save_lesson_meta($post_id) { global $wpdb; if ( defined( 'DOING_AUTOSAVE' ) && DOING_AUTOSAVE ) return; if ( empty($_POST['perception_noncemeta']) or !wp_verify_nonce( $_POST['perception_noncemeta'], plugin_basename( __FILE__ ) ) ) return; if ( !current_user_can( 'edit_post', $post_id ) ) return; if ('perception_lesson' != $_POST['post_type']) return; $use_modules = get_option('perception_use_modules'); update_post_meta($post_id, "perception_course", intval($_POST['perception_course'])); $_POST['perception_module'] = empty($_POST['perception_module']) ? 0 : intval($_POST['perception_module']); if($use_modules) update_post_meta($post_id, "perception_module", $_POST['perception_module']); update_post_meta($post_id, "perception_access", perception_int_array(@$_POST['perception_access'])); update_post_meta($post_id, "perception_completion", @$_POST['perception_completion']); update_post_meta($post_id, "perception_required_homeworks", perception_int_array(@$_POST['perception_required_homeworks'])); $_POST['perception_required_exam'] = empty($_POST['perception_required_exam']) ? 0 : intval($_POST['perception_required_exam']); update_post_meta($post_id, "perception_required_exam", $_POST['perception_required_exam']); update_post_meta($post_id, "perception_required_grade", perception_int_array(@$_POST['perception_required_grade'])); $_POST['perception_watu_transfer_grade'] = empty($_POST['perception_watu_transfer_grade']) ? 0 : intval($_POST['perception_watu_transfer_grade']); update_post_meta($post_id, "perception_watu_transfer_grade", $_POST['perception_watu_transfer_grade']); $_POST['perception_award_points'] = empty($_POST['perception_award_points']) ? 0 : intval($_POST['perception_award_points']); if(isset($_POST['perception_award_points'])) update_post_meta($post_id, "perception_award_points", $_POST['perception_award_points']); } // select lessons in course ID // @param $is_module boolean: shows whether we are looking for course lessons or module lessons. // If the var is true, $course_id is in fact module_id function select($course_id, $format = 'array', $id = null, $ob = 'post_title', $dir = 'ASC', $is_module = false) { global $wpdb; $id_sql = ''; if(!empty($id)) $id_sql = $wpdb->prepare(' AND tP.ID = %d ', $id); if(empty($ob)) { $ob = 'post_title'; $reorder = true; } $parent_type = $is_module ? 'perception_module' : 'perception_course'; $lessons = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->posts} tP JOIN {$wpdb->postmeta} tM ON tM.post_id = tP.ID AND tM.meta_key = '$parent_type' AND tM.meta_value = %d WHERE post_type = 'perception_lesson' AND (post_status='publish' OR post_status='draft') $id_sql ORDER BY $ob $dir", $course_id)); // external reorder? if(!empty($reorder)) $lessons = apply_filters('perception-reorder-lessons', $lessons); if($format == 'array') return $lessons; if($format == 'single') return $lessons[0]; if($format == 'json') echo json_encode($lessons); } // students lessons in a selected course // @param $simplified boolean - when true doesn't assignment and text/exam static function student_lessons($simplified = false, $ob = null, $dir = null, $in_shortcode=false, $show_excerpts = false, $is_module = false, $atts = null) { global $wpdb, $user_ID; // student_id $student_id = (empty($_GET['student_id']) or !current_user_can('perception_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 or module $course = $wpdb -> get_row($wpdb->prepare("SELECT * FROM {$wpdb->posts} WHERE id=%d", $_GET['course_id'])); // am I enrolled? if(!current_user_can('perception_manage') and !$in_shortcode) { $enrolled = $wpdb -> get_var($wpdb->prepare("SELECT id FROM ".PERCEPTION_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", 'perception'); return false; } } // end enrolled check // change student-lesson status? if(!empty($_POST['change_status'])) { $multiuser_access = 'all'; $multiuser_access = PSPerceptionLMSMultiUser :: check_access('students_access'); if($multiuser_access == 'view') wp_die(__('You are not allowed to do this.', 'perception')); $result = PSPerceptionLMSStudentModel :: lesson_status($student->ID, $_POST['lesson_id'], $_POST['status']); if(!$result) $error = __('The lesson cannot be completed because there are unsatisfied requirements', 'perception'); } // select lessons $_lesson = new PSPerceptionLMSLessonModel(); $select_ob = empty($ob) ? 'post_title' : $ob; $lessons = $_lesson->select($course->ID, 'array', null, $ob, $dir, $is_module); $ids = array(0); foreach($lessons as $lesson) $ids[] = $lesson->ID; $id_sql = implode(",", $ids); // select homeworks and match to lessons $homeworks = PSPerceptionLMSHomeworkModel::select("WHERE lesson_id IN ($id_sql)"); // using exams? select them too $use_exams = get_option('perception_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 ".PERCEPTION_STUDENT_LESSONS." WHERE student_id = %d", $student_id)); $use_grading_system = get_option('perception_use_grading_system'); 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, 'perception_required_exam', true); if($required_exam) { $exam = $wpdb->get_row("SELECT tE.*, tP.id as post_id FROM $exams_table tE, {$wpdb->posts} tP WHERE tE.ID = $required_exam AND tP.post_content LIKE CONCAT('%[$shortcode ', tE.ID, ']%') AND 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; $lessons[$cnt]->grade = $l->grade; } } if(empty($status->id)) { $lessons[$cnt]->status = __('Not started', 'perception'); $lessons[$cnt]->statuscode = -1; } else { if($status->status == 1) { $lessons[$cnt]->status = __('Completed on', 'perception') . ' ' . date(get_option('date_format'), strtotime($status->completion_date)); $lessons[$cnt]->statuscode = 1; } else { // in progress $lessons[$cnt]->status = "".__('In progress', 'perception').""; $lessons[$cnt]->statuscode = 0; } } // end defining status } // external reorder? if(empty($ob)) $lessons = apply_filters('perception-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().'/perception/student-lessons.php')) require get_stylesheet_directory().'/perception/student-lessons.php'; else require(PERCEPTION_PATH."/views/student-lessons.php"); } // check if user can access the lesson, mark lesson as started static function access_lesson($content) { global $wpdb, $post, $user_ID; if(@$post->post_type != 'perception_lesson') return $content; $_course = new PSPerceptionLMSCourseModel(); if(!is_user_logged_in()) { //echo $post->ID.'
'; // post excerpt? if(!empty($post->post_excerpt)) return wpautop($post->post_excerpt); return PERCEPTION_NEED_LOGIN_TEXT_LESSON; } // track visit PerceptionTrack::visit('lesson', $post->ID, $user_ID); $course_id = get_post_meta($post->ID, 'perception_course', true); $course = $_course -> select($course_id); // add link to parent course? if(get_option('perception_link_to_course') == 1) { $link = stripslashes(get_option('perception_link_to_course_text')); $course_permalink = get_permalink($course_id); $link = str_replace('{{{course-link}}}', ''.stripslashes($course->post_name).'', $link); $content = $link . $content; } // manager will always access lesson if(current_user_can('perception_manage')) { // class or other restrictions apply? list($no_access, $message) = apply_filters('perception-manager-lesson-access', array(false, ''), $user_ID, $course_id); if(!empty($no_access) and !current_user_can('manage_options')) { if(!empty($post->post_excerpt)) $message .= wpautop($post->post_excerpt); return $message; } self :: mark_accessed(); return $content; } // enrolled in the course? $enrolled = $wpdb -> get_var($wpdb->prepare("SELECT id FROM ".PERCEPTION_COURSES. " WHERE user_id = %d AND course_id = %d AND (status = 'enrolled' OR status='completed')", $user_ID, $course_id)); if(!$enrolled) { if(!empty($post->post_excerpt)) $content = wpautop($post->post_excerpt); else $content = __('In order to see this lesson you first have to be enrolled in the course', 'perception').' "'.$course->post_title.'"'; // self :: mark_accessed(); return $content; // no need to run further queries } // no access due to filters? (Classes from Perception PRO etc) list($no_access, $message) = apply_filters('perception-course-access', array(false, ''), $user_ID, $course_id); if(!empty($no_access)) { if(!empty($post->post_excerpt)) $message .= wpautop($post->post_excerpt); return $message; } // no access due to other lesson restrictions based on filters from other plugins list($no_access, $message) = apply_filters('perception-lesson-access', array(false, ''), $user_ID, $post->ID); if(!empty($no_access)) { if(!empty($post->post_excerpt)) $message .= wpautop($post->post_excerpt); return $message; } // can't access based on module restrictions? if(get_option('perception_use_modules')) { // belongs to module? $module_id = get_post_meta($post->ID, 'perception_module', true); $module = get_post($module_id); $module_access = get_post_meta($module_id, 'perception_access', true); // any not completed? $not_completed_ids = null; if(!empty($module_access)) { foreach($module_access as $mid) { $is_completed = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".PERCEPTION_STUDENT_MODULES." WHERE module_id=%d AND student_id=%d AND status='completed'", $mid, $user_ID)); if(!$is_completed) { // check on the fly, maybe lessons are completed but there are no requirements $_module = new PSPerceptionLMSModuleModel(); if($_module -> is_ready($mid, $user_ID)) { // insert relation here $wpdb->query($wpdb->prepare("INSERT INTO ".PERCEPTION_STUDENT_MODULES." SET module_id=%d, student_id=%d, status='completed', enrollment_date=%s, completion_date=%s", $mid, $user_ID, date('Y-m-d', current_time('timestamp')), date('Y-m-d', current_time('timestamp')) )); $mid = 0; // unset $mid so it's not inserted as not completed } if($mid) $not_completed_ids[] = $mid; } } } if(!empty($not_completed_ids)) { if(!empty($post->post_excerpt)) $content = wpautop($post->post_excerpt); $content = '

'.__('Before accessing a lesson from this module you must complete the following modules:','perception').'

'; foreach($not_completed_ids as $id) { $not_completed = get_post($id); $content .= '
  • '.stripslashes($not_completed->post_title).'
  • '; } $content .= '