__("PSPerception Homeworks", 'perception'), "labels" => array ( "name"=>__("Homeworks", 'perception'), "singular_name"=>__("Homework", 'perception'), "add_new_item"=>__("Add New Homework", 'perception'), 'bp_activity_admin_filter' => __( 'Homeworks', 'perception' ), 'bp_activity_front_filter' => __( 'Homeworks', 'perception' ), 'bp_activity_new_post' => __( '%1$s created a new Homework', 'perception' ), 'bp_activity_comments_admin_filter' => __( 'Comments about Homeworks', 'perception' ), 'bp_activity_comments_front_filter' => __( 'Homework Comments', 'perception' ), 'bp_activity_new_comment' => __( '%1$s commented on the Homework', 'perception' ), ), "public"=> true, "show_ui"=>false, "has_archive"=>false, "rewrite"=> array("slug"=>$homework_slug, "with_front"=>false), "description"=>__("This will create a new post with homeworks for a lesson in your PSPerception LMS.",'perception'), "supports"=>array("title", 'editor', 'author', 'thumbnail', 'excerpt', 'comments', 'post-formats', 'buddypress-activity'), 'bp_activity' => array( 'action_id' => 'new_homework', 'contexts' => array( 'activity', 'member' ), 'comment_action_id' => 'new_homework_comment', 'position' => 70, ), "taxonomies"=>array("category", 'post_tag'), "show_in_nav_menus"=>'false', 'show_in_menu' => false, ); register_post_type( 'perception_homework', $args ); } static function manage() { global $wpdb, $user_ID; $_course = new PSPerceptionLMSCourseModel(); $_lesson = new PSPerceptionLMSLessonModel(); $multiuser_access = 'all'; $multiuser_access = PSPerceptionLMSMultiUser :: check_access('homework_access'); // select courses $courses = $_course -> select(); $courses = apply_filters('perception-homeworks-select-courses', $courses); // if course and lesson are selected, populate two variables for displaying titles etc if(!empty($_GET['course_id'])) $this_course = $_course -> select($_GET['course_id']); if(!empty($_GET['lesson_id'])) $this_lesson = $_lesson -> select($_GET['course_id'], 'single', $_GET['lesson_id']); // sanitize / prepare vars $_GET['course_id'] = intval(@$_GET['course_id']); $_GET['lesson_id'] = intval(@$_GET['lesson_id']); $accept_files = empty($_POST['accept_files']) ? 0 : 1; $award_points = intval(@$_POST['award_points']); $auto_grade_lesson = empty($_POST['auto_grade_lesson']) ? 0 : 1; switch(@$_GET['do']) { case 'add': // apply permissions from other plugins do_action('perception-check-permissions', 'course', $_GET['course_id']); if(!empty($_POST['ok']) and check_admin_referer('perception_homework')) { $wpdb->query($wpdb->prepare("INSERT INTO ".PERCEPTION_HOMEWORKS." SET course_id=%d, lesson_id=%d, title=%s, description=%s, accept_files=%d, award_points=%d, editor_id=%d, limit_by_date=%d, accept_date_from=%s, accept_date_to=%s, auto_grade_lesson=%d", $_GET['course_id'], $_GET['lesson_id'], sanitize_text_field($_POST['title']), perception_strip_tags($_POST['description']), $accept_files, $award_points, $user_ID, intval(@$_POST['limit_by_date']), sanitize_text_field($_POST['accept_date_from']), sanitize_text_field($_POST['accept_date_to']), $auto_grade_lesson)); $id = $wpdb->insert_id; do_action('perception_add_homework', $id); self :: create_homework_post($_GET['lesson_id']); //$_SESSION['perception_flash'] = __('Homework added', 'perception'); perception_redirect("admin.php?page=perception_homeworks&course_id=$_GET[course_id]&lesson_id=$_GET[lesson_id]"); } perception_enqueue_datepicker(); if(@file_exists(get_stylesheet_directory().'/perception/homework.php')) require get_stylesheet_directory().'/perception/homework.php'; else require(PERCEPTION_PATH."/views/homework.php"); break; case 'edit': // apply permissions from other plugins do_action('perception-check-permissions', 'homework', $_GET['id']); if($multiuser_access == 'own') { $homework = self::select($wpdb->prepare(' WHERE id=%d ', $_GET['id'])); $homework = $homework[0]; if($homework->editor_id != $user_ID) wp_die(__('You are not allowed to edit or delete this assignment', 'perception')); } if(!empty($_POST['del']) and check_admin_referer('perception_homework')) { self::delete($_GET['id']); //$_SESSION['perception_flash'] = __('Homework deleted', 'perception'); perception_redirect("admin.php?page=perception_homeworks&course_id=$_GET[course_id]&lesson_id=$_GET[lesson_id]"); } if(!empty($_POST['ok']) and check_admin_referer('perception_homework')) { $wpdb->query($wpdb->prepare("UPDATE ".PERCEPTION_HOMEWORKS." SET course_id=%d, lesson_id=%d, title=%s, description=%s, accept_files=%d, award_points=%d, limit_by_date=%d, accept_date_from=%s, accept_date_to=%s, auto_grade_lesson=%d WHERE id=%d", $_GET['course_id'], $_GET['lesson_id'], sanitize_text_field($_POST['title']), perception_strip_tags($_POST['description']), $accept_files, $award_points, intval(@$_POST['limit_by_date']), sanitize_text_field($_POST['accept_date_from']), sanitize_text_field($_POST['accept_date_to']), $auto_grade_lesson, $_GET['id'])); do_action('perception_save_homework', $_GET['id']); //$_SESSION['perception_flash'] = __('Homework saved', 'perception'); perception_redirect("admin.php?page=perception_homeworks&course_id=$_GET[course_id]&lesson_id=$_GET[lesson_id]"); } // select homework $homework = self::select($wpdb->prepare(' WHERE id=%d ', $_GET['id'])); $homework = $homework[0]; perception_enqueue_datepicker(); if(@file_exists(get_stylesheet_directory().'/perception/homework.php')) require get_stylesheet_directory().'/perception/homework.php'; else require(PERCEPTION_PATH."/views/homework.php"); break; default: // if course is selected, find lessons if(!empty($_GET['course_id'])) { $lessons = $_lesson->select($_GET['course_id'], 'array', null, ''); } // list existing homeworks if course and lesson are selected if(!empty($_GET['course_id']) and !empty($_GET['lesson_id'])) { // apply permissions from other plugins - this allows other plugins to die here if user can't access the course do_action('perception-check-permissions', 'course', $_GET['course_id']); $own_sql = ''; if($multiuser_access == 'own') $own_sql = $wpdb->prepare(" AND tH.editor_id=%d ", $user_ID); $homeworks = $wpdb->get_results($wpdb->prepare("SELECT tH.*, COUNT(tS.id) as solutions FROM ".PERCEPTION_HOMEWORKS." tH LEFT JOIN ".PERCEPTION_STUDENT_HOMEWORKS." tS ON tS.homework_id = tH.id WHERE tH.course_id=%d AND tH.lesson_id=%d $own_sql GROUP BY tH.id ORDER BY tH.title", $_GET['course_id'], $_GET['lesson_id'])); } if(@file_exists(get_stylesheet_directory().'/perception/homeworks.php')) require get_stylesheet_directory().'/perception/homeworks.php'; else require(PERCEPTION_PATH."/views/homeworks.php"); break; } } // shows homeworks assigned to a lesson static function lesson_homeworks($in_shortcode = false) { global $wpdb, $user_ID, $post; // not my own homeworks? I need to have manage caps then $manager_mode = false; if($user_ID != $_GET['student_id']) { if(!current_user_can('perception_manage')) wp_die(__('You are not allowed to see this page', 'perception')); } $student = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->users} WHERE ID=%d", intval($_GET['student_id']))); if(current_user_can('perception_manage')) $manager_mode = true; // select lesson $lesson = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->posts} WHERE ID=%d", intval($_GET['lesson_id']))); if(empty($lesson->ID)) return __('Invalid lesson ID.', 'perception'); // course ID $course_id = get_post_meta($lesson->ID, 'perception_course', true); // select the homeworks assigned to this lesson $homeworks = self :: select($wpdb->prepare("WHERE lesson_id = %d", $lesson->ID)); $ids = array(0); foreach($homeworks as $homework) $ids[] = $homework->id; $id_sql = implode(", ", $ids); // select & match student solutions for each homework $solutions = $wpdb -> get_results( $wpdb->prepare("SELECT * FROM ".PERCEPTION_STUDENT_HOMEWORKS." WHERE student_id = %d AND homework_id IN ($id_sql) ORDER BY id", intval($_GET['student_id'])) ); // select & match notes for each homework $notes = $wpdb -> get_results($wpdb->prepare("SELECT * FROM ".PERCEPTION_HOMEWORK_NOTES." WHERE homework_id IN ($id_sql) AND student_id = %d", intval($_GET['student_id']))); foreach($homeworks as $cnt=>$homework) { $homework_solutions = array(); $homework_notes = array(); foreach($solutions as $solution) { if($solution -> homework_id == $homework->id) $homework_solutions[] = $solution; } foreach($notes as $note) { if($note->homework_id == $homework->id) $homework_notes[] = $note; } // define homework status - if even 1 solution is approved, the homework status is true $homeworks[$cnt]->status = false; foreach($homework_solutions as $solution) { if($solution->status == 'approved') $homeworks[$cnt]->status = true; } $homeworks[$cnt]->solutions = $homework_solutions; $homeworks[$cnt]->notes = $homework_notes; } $dateformat = get_option('date_format'); 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/lesson-homeworks.php')) require get_stylesheet_directory().'/perception/lesson-homeworks.php'; else require(PERCEPTION_PATH."/views/lesson-homeworks.php"); } // select homeworks static function select($where) { global $wpdb; $homeworks = $wpdb -> get_results("SELECT * FROM ".PERCEPTION_HOMEWORKS." $where ORDER BY id"); return $homeworks; } // delete homework // for the moment delete only the DB record, but for the future // consider deleting the solutions along with their files static function delete($id) { global $wpdb; $id = intval($id); $wpdb->query($wpdb->prepare("DELETE FROM ".PERCEPTION_HOMEWORKS." WHERE id=%d", $id)); } // full select homework - with lesson and course (used in few places) static function full_select($id) { global $wpdb; $_course = new PSPerceptionLMSCourseModel(); $_lesson = new PSPerceptionLMSLessonModel(); $id = intval($id); // select this homework and lesson $homework = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".PERCEPTION_HOMEWORKS." WHERE 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); } // grade the homework. If required, set the homework grade as lesson grade too // @param $grade - string, the grade // @param $id - int, the solution ID static function set_grade($grade, $id) { global $wpdb; $grade = sanitize_text_field($grade); $id = intval($id); $wpdb->query($wpdb->prepare("UPDATE ".PERCEPTION_STUDENT_HOMEWORKS." SET grade=%s WHERE id=%d", $grade, $id)); do_action('perception_graded_homework', $id, $grade); // now check if the homework should also grade the lesson $solution = $wpdb->get_row($wpdb->prepare("SELECT student_id, homework_id FROM ".PERCEPTION_STUDENT_HOMEWORKS." WHERE id=%d", $id)); $homework = $wpdb->get_row($wpdb->prepare("SELECT lesson_id, auto_grade_lesson FROM ".PERCEPTION_HOMEWORKS." WHERE id=%d", $solution->homework_id)); if($homework->auto_grade_lesson) { $wpdb->query($wpdb->prepare("UPDATE ".PERCEPTION_STUDENT_LESSONS." SET grade=%s WHERE lesson_id=%d AND student_id=%d", $grade, $homework->lesson_id, $solution->student_id)); do_action('perception_graded_lesson', $solution->student_id, $homework->lesson_id, $grade); } } // end set_grade() // creates custom Homework post with the shortcode for that lesson IF it doesn't already exist static function create_homework_post($lesson_id) { global $wpdb; // check if post exists $post_exists = $wpdb->get_var("SELECT ID FROM {$wpdb->posts} WHERE post_status = 'publish' AND post_date < NOW() AND post_content LIKE '%[perception-assignments lesson_id=\"".$lesson_id."\"%' ORDER BY ID DESC"); if(empty($post_exists)) { $lesson = get_post($lesson_id); $my_post = array( 'post_type' => 'perception_homework', 'post_title' => sprintf(__('Homework for Lesson %s', 'perception'), stripslashes($lesson->post_title)), 'post_content' => '[perception-assignments lesson_id="'.$lesson_id.'"]', 'post_status' => 'publish', 'post_category' => array( 8,39 ) ); wp_insert_post( $my_post ); } } // end create_homework_post }