@@ -20,8 +20,8 @@ discard block |
||
20 | 20 | /** |
21 | 21 | * Constructor |
22 | 22 | * @since 1.3.0 |
23 | - * |
|
24 | - * @param $file |
|
23 | + * |
|
24 | + * @param $file |
|
25 | 25 | */ |
26 | 26 | public function __construct ( $file ) { |
27 | 27 | $this->name = __( 'Grading', 'woothemes-sensei' ); |
@@ -230,7 +230,7 @@ discard block |
||
230 | 230 | /** |
231 | 231 | * Outputs Grading general headers |
232 | 232 | * @since 1.3.0 |
233 | - * @param array $args |
|
233 | + * @param array $args |
|
234 | 234 | * @return void |
235 | 235 | */ |
236 | 236 | public function grading_headers( $args = array( 'nav' => 'default' ) ) { |
@@ -282,7 +282,7 @@ discard block |
||
282 | 282 | } |
283 | 283 | if ( isset( $_GET['user_id'] ) && 0 < intval( $_GET['user_id'] ) ) { |
284 | 284 | |
285 | - $user_name = Sensei_Learner::get_full_name( $_GET['user_id'] ); |
|
285 | + $user_name = Sensei_Learner::get_full_name( $_GET['user_id'] ); |
|
286 | 286 | $title .= ' <span class="user-title">> ' . $user_name . '</span>'; |
287 | 287 | |
288 | 288 | } // End If Statement |
@@ -316,7 +316,7 @@ discard block |
||
316 | 316 | } |
317 | 317 | if ( isset( $_GET['user'] ) && 0 < intval( $_GET['user'] ) ) { |
318 | 318 | |
319 | - $user_name = Sensei_Learner::get_full_name( $_GET['user'] ); |
|
319 | + $user_name = Sensei_Learner::get_full_name( $_GET['user'] ); |
|
320 | 320 | $title .= ' <span class="user-title">> ' . $user_name . '</span>'; |
321 | 321 | |
322 | 322 | } // End If Statement |
@@ -365,15 +365,15 @@ discard block |
||
365 | 365 | public function count_statuses( $args = array() ) { |
366 | 366 | global $wpdb; |
367 | 367 | |
368 | - /** |
|
369 | - * Filter fires inside Sensei_Grading::count_statuses |
|
370 | - * |
|
371 | - * Alter the the post_in array to determine which posts the |
|
372 | - * comment query should be limited to. |
|
373 | - * @since 1.8.0 |
|
374 | - * @param array $args |
|
375 | - */ |
|
376 | - $args = apply_filters( 'sensei_count_statuses_args', $args ); |
|
368 | + /** |
|
369 | + * Filter fires inside Sensei_Grading::count_statuses |
|
370 | + * |
|
371 | + * Alter the the post_in array to determine which posts the |
|
372 | + * comment query should be limited to. |
|
373 | + * @since 1.8.0 |
|
374 | + * @param array $args |
|
375 | + */ |
|
376 | + $args = apply_filters( 'sensei_count_statuses_args', $args ); |
|
377 | 377 | |
378 | 378 | if ( 'course' == $args['type'] ) { |
379 | 379 | $type = 'sensei_course_status'; |
@@ -385,7 +385,7 @@ discard block |
||
385 | 385 | |
386 | 386 | $query = "SELECT comment_approved, COUNT( * ) AS total FROM {$wpdb->comments} WHERE comment_type = %s "; |
387 | 387 | |
388 | - // Restrict to specific posts |
|
388 | + // Restrict to specific posts |
|
389 | 389 | if ( isset( $args['post__in'] ) && !empty( $args['post__in'] ) && is_array( $args['post__in'] ) ) { |
390 | 390 | $query .= ' AND comment_post_ID IN (' . implode( ',', array_map( 'absint', $args['post__in'] ) ) . ')'; |
391 | 391 | } |
@@ -520,148 +520,148 @@ discard block |
||
520 | 520 | return $html; |
521 | 521 | } // End lessons_drop_down_html() |
522 | 522 | |
523 | - /** |
|
524 | - * The process grading function handles admin grading submissions. |
|
525 | - * |
|
526 | - * This function is hooked on to admin_init. It simply accepts |
|
527 | - * the grades as the Grader selected theme and saves the total grade and |
|
528 | - * individual question grades. |
|
529 | - * |
|
530 | - * @return bool |
|
531 | - */ |
|
532 | - public function admin_process_grading_submission() { |
|
523 | + /** |
|
524 | + * The process grading function handles admin grading submissions. |
|
525 | + * |
|
526 | + * This function is hooked on to admin_init. It simply accepts |
|
527 | + * the grades as the Grader selected theme and saves the total grade and |
|
528 | + * individual question grades. |
|
529 | + * |
|
530 | + * @return bool |
|
531 | + */ |
|
532 | + public function admin_process_grading_submission() { |
|
533 | 533 | |
534 | - // NEEDS REFACTOR/OPTIMISING, such as combining the various meta data stored against the sensei_user_answer entry |
|
535 | - if( ! isset( $_POST['sensei_manual_grade'] ) |
|
536 | - || ! wp_verify_nonce( $_POST['_wp_sensei_manual_grading_nonce'], 'sensei_manual_grading' ) |
|
537 | - || ! isset( $_GET['quiz_id'] ) |
|
538 | - || $_GET['quiz_id'] != $_POST['sensei_manual_grade'] ) { |
|
534 | + // NEEDS REFACTOR/OPTIMISING, such as combining the various meta data stored against the sensei_user_answer entry |
|
535 | + if( ! isset( $_POST['sensei_manual_grade'] ) |
|
536 | + || ! wp_verify_nonce( $_POST['_wp_sensei_manual_grading_nonce'], 'sensei_manual_grading' ) |
|
537 | + || ! isset( $_GET['quiz_id'] ) |
|
538 | + || $_GET['quiz_id'] != $_POST['sensei_manual_grade'] ) { |
|
539 | 539 | |
540 | - return false; //exit and do not grade |
|
540 | + return false; //exit and do not grade |
|
541 | 541 | |
542 | - } |
|
542 | + } |
|
543 | 543 | |
544 | - $quiz_id = $_GET['quiz_id']; |
|
545 | - $user_id = $_GET['user']; |
|
544 | + $quiz_id = $_GET['quiz_id']; |
|
545 | + $user_id = $_GET['user']; |
|
546 | 546 | |
547 | 547 | |
548 | - $questions = Sensei_Utils::sensei_get_quiz_questions( $quiz_id ); |
|
549 | - $quiz_lesson_id = Sensei()->quiz->get_lesson_id( $quiz_id ); |
|
550 | - $quiz_grade = 0; |
|
551 | - $count = 0; |
|
552 | - $quiz_grade_total = $_POST['quiz_grade_total']; |
|
553 | - $all_question_grades = array(); |
|
554 | - $all_answers_feedback = array(); |
|
548 | + $questions = Sensei_Utils::sensei_get_quiz_questions( $quiz_id ); |
|
549 | + $quiz_lesson_id = Sensei()->quiz->get_lesson_id( $quiz_id ); |
|
550 | + $quiz_grade = 0; |
|
551 | + $count = 0; |
|
552 | + $quiz_grade_total = $_POST['quiz_grade_total']; |
|
553 | + $all_question_grades = array(); |
|
554 | + $all_answers_feedback = array(); |
|
555 | 555 | |
556 | - foreach( $questions as $question ) { |
|
556 | + foreach( $questions as $question ) { |
|
557 | 557 | |
558 | - ++$count; |
|
559 | - $question_id = $question->ID; |
|
558 | + ++$count; |
|
559 | + $question_id = $question->ID; |
|
560 | 560 | |
561 | - if( isset( $_POST[ 'question_' . $question_id ] ) ) { |
|
561 | + if( isset( $_POST[ 'question_' . $question_id ] ) ) { |
|
562 | 562 | |
563 | - $question_grade = 0; |
|
564 | - if( $_POST[ 'question_' . $question_id ] == 'right' ) { |
|
563 | + $question_grade = 0; |
|
564 | + if( $_POST[ 'question_' . $question_id ] == 'right' ) { |
|
565 | 565 | |
566 | - $question_grade = $_POST[ 'question_' . $question_id . '_grade' ]; |
|
566 | + $question_grade = $_POST[ 'question_' . $question_id . '_grade' ]; |
|
567 | 567 | |
568 | - } |
|
568 | + } |
|
569 | 569 | |
570 | - // add data to the array that will, after the loop, be stored on the lesson status |
|
571 | - $all_question_grades[ $question_id ] = $question_grade; |
|
570 | + // add data to the array that will, after the loop, be stored on the lesson status |
|
571 | + $all_question_grades[ $question_id ] = $question_grade; |
|
572 | 572 | |
573 | - // tally up the total quiz grade |
|
574 | - $quiz_grade += $question_grade; |
|
573 | + // tally up the total quiz grade |
|
574 | + $quiz_grade += $question_grade; |
|
575 | 575 | |
576 | - } // endif |
|
576 | + } // endif |
|
577 | 577 | |
578 | - // Question answer feedback / notes |
|
579 | - $question_feedback = ''; |
|
580 | - if( isset( $_POST[ 'questions_feedback' ][ $question_id ] ) ){ |
|
578 | + // Question answer feedback / notes |
|
579 | + $question_feedback = ''; |
|
580 | + if( isset( $_POST[ 'questions_feedback' ][ $question_id ] ) ){ |
|
581 | 581 | |
582 | - $question_feedback = wp_unslash( $_POST[ 'questions_feedback' ][ $question_id ] ); |
|
582 | + $question_feedback = wp_unslash( $_POST[ 'questions_feedback' ][ $question_id ] ); |
|
583 | 583 | |
584 | - } |
|
585 | - $all_answers_feedback[ $question_id ] = $question_feedback; |
|
584 | + } |
|
585 | + $all_answers_feedback[ $question_id ] = $question_feedback; |
|
586 | 586 | |
587 | - } // end for each $questions |
|
587 | + } // end for each $questions |
|
588 | 588 | |
589 | - //store all question grades on the lesson status |
|
590 | - Sensei()->quiz->set_user_grades( $all_question_grades, $quiz_lesson_id , $user_id ); |
|
589 | + //store all question grades on the lesson status |
|
590 | + Sensei()->quiz->set_user_grades( $all_question_grades, $quiz_lesson_id , $user_id ); |
|
591 | 591 | |
592 | - //store the feedback from grading |
|
593 | - Sensei()->quiz->save_user_answers_feedback( $all_answers_feedback, $quiz_lesson_id , $user_id ); |
|
592 | + //store the feedback from grading |
|
593 | + Sensei()->quiz->save_user_answers_feedback( $all_answers_feedback, $quiz_lesson_id , $user_id ); |
|
594 | 594 | |
595 | - // $_POST['all_questions_graded'] is set when all questions have been graded |
|
596 | - // in the class sensei grading user quiz -> display() |
|
597 | - if( $_POST['all_questions_graded'] == 'yes' ) { |
|
595 | + // $_POST['all_questions_graded'] is set when all questions have been graded |
|
596 | + // in the class sensei grading user quiz -> display() |
|
597 | + if( $_POST['all_questions_graded'] == 'yes' ) { |
|
598 | 598 | |
599 | - // set the users total quiz grade |
|
599 | + // set the users total quiz grade |
|
600 | 600 | if ( 0 < intval( $quiz_grade_total ) ) { |
601 | - $grade = abs( round( ( doubleval( $quiz_grade ) * 100 ) / ( $quiz_grade_total ), 2 ) ); |
|
601 | + $grade = abs( round( ( doubleval( $quiz_grade ) * 100 ) / ( $quiz_grade_total ), 2 ) ); |
|
602 | 602 | } |
603 | 603 | else { |
604 | 604 | $grade = 0; |
605 | 605 | } |
606 | - Sensei_Utils::sensei_grade_quiz( $quiz_id, $grade, $user_id ); |
|
607 | - |
|
608 | - // Duplicating what Frontend->sensei_complete_quiz() does |
|
609 | - $pass_required = get_post_meta( $quiz_id, '_pass_required', true ); |
|
610 | - $quiz_passmark = abs( round( doubleval( get_post_meta( $quiz_id, '_quiz_passmark', true ) ), 2 ) ); |
|
611 | - $lesson_metadata = array(); |
|
612 | - if ( $pass_required ) { |
|
613 | - // Student has reached the pass mark and lesson is complete |
|
614 | - if ( $quiz_passmark <= $grade ) { |
|
615 | - $lesson_status = 'passed'; |
|
616 | - } |
|
617 | - else { |
|
618 | - $lesson_status = 'failed'; |
|
619 | - } // End If Statement |
|
620 | - } |
|
621 | - // Student only has to partake the quiz |
|
622 | - else { |
|
623 | - $lesson_status = 'graded'; |
|
624 | - } |
|
625 | - $lesson_metadata['grade'] = $grade; // Technically already set as part of "WooThemes_Sensei_Utils::sensei_grade_quiz()" above |
|
606 | + Sensei_Utils::sensei_grade_quiz( $quiz_id, $grade, $user_id ); |
|
607 | + |
|
608 | + // Duplicating what Frontend->sensei_complete_quiz() does |
|
609 | + $pass_required = get_post_meta( $quiz_id, '_pass_required', true ); |
|
610 | + $quiz_passmark = abs( round( doubleval( get_post_meta( $quiz_id, '_quiz_passmark', true ) ), 2 ) ); |
|
611 | + $lesson_metadata = array(); |
|
612 | + if ( $pass_required ) { |
|
613 | + // Student has reached the pass mark and lesson is complete |
|
614 | + if ( $quiz_passmark <= $grade ) { |
|
615 | + $lesson_status = 'passed'; |
|
616 | + } |
|
617 | + else { |
|
618 | + $lesson_status = 'failed'; |
|
619 | + } // End If Statement |
|
620 | + } |
|
621 | + // Student only has to partake the quiz |
|
622 | + else { |
|
623 | + $lesson_status = 'graded'; |
|
624 | + } |
|
625 | + $lesson_metadata['grade'] = $grade; // Technically already set as part of "WooThemes_Sensei_Utils::sensei_grade_quiz()" above |
|
626 | 626 | |
627 | - Sensei_Utils::update_lesson_status( $user_id, $quiz_lesson_id, $lesson_status, $lesson_metadata ); |
|
627 | + Sensei_Utils::update_lesson_status( $user_id, $quiz_lesson_id, $lesson_status, $lesson_metadata ); |
|
628 | 628 | |
629 | - if( in_array( $lesson_status, array( 'passed', 'graded' ) ) ) { |
|
629 | + if( in_array( $lesson_status, array( 'passed', 'graded' ) ) ) { |
|
630 | 630 | |
631 | - /** |
|
632 | - * Summary. |
|
633 | - * |
|
634 | - * Description. |
|
635 | - * |
|
636 | - * @since 1.7.0 |
|
637 | - * |
|
638 | - * @param int $user_id |
|
639 | - * @param int $quiz_lesson_id |
|
640 | - */ |
|
641 | - do_action( 'sensei_user_lesson_end', $user_id, $quiz_lesson_id ); |
|
631 | + /** |
|
632 | + * Summary. |
|
633 | + * |
|
634 | + * Description. |
|
635 | + * |
|
636 | + * @since 1.7.0 |
|
637 | + * |
|
638 | + * @param int $user_id |
|
639 | + * @param int $quiz_lesson_id |
|
640 | + */ |
|
641 | + do_action( 'sensei_user_lesson_end', $user_id, $quiz_lesson_id ); |
|
642 | 642 | |
643 | - } // end if in_array |
|
643 | + } // end if in_array |
|
644 | 644 | |
645 | - }// end if $_POST['all_que... |
|
645 | + }// end if $_POST['all_que... |
|
646 | 646 | |
647 | - if( isset( $_POST['sensei_grade_next_learner'] ) && strlen( $_POST['sensei_grade_next_learner'] ) > 0 ) { |
|
647 | + if( isset( $_POST['sensei_grade_next_learner'] ) && strlen( $_POST['sensei_grade_next_learner'] ) > 0 ) { |
|
648 | 648 | |
649 | - $load_url = add_query_arg( array( 'message' => 'graded' ) ); |
|
649 | + $load_url = add_query_arg( array( 'message' => 'graded' ) ); |
|
650 | 650 | |
651 | - } elseif ( isset( $_POST['_wp_http_referer'] ) ) { |
|
651 | + } elseif ( isset( $_POST['_wp_http_referer'] ) ) { |
|
652 | 652 | |
653 | - $load_url = add_query_arg( array( 'message' => 'graded' ), $_POST['_wp_http_referer'] ); |
|
653 | + $load_url = add_query_arg( array( 'message' => 'graded' ), $_POST['_wp_http_referer'] ); |
|
654 | 654 | |
655 | - } else { |
|
655 | + } else { |
|
656 | 656 | |
657 | - $load_url = add_query_arg( array( 'message' => 'graded' ) ); |
|
657 | + $load_url = add_query_arg( array( 'message' => 'graded' ) ); |
|
658 | 658 | |
659 | - } |
|
659 | + } |
|
660 | 660 | |
661 | - wp_safe_redirect( esc_url_raw( $load_url ) ); |
|
662 | - exit; |
|
661 | + wp_safe_redirect( esc_url_raw( $load_url ) ); |
|
662 | + exit; |
|
663 | 663 | |
664 | - } // end admin_process_grading_submission |
|
664 | + } // end admin_process_grading_submission |
|
665 | 665 | |
666 | 666 | public function get_redirect_url() { |
667 | 667 | // Parse POST data |
@@ -706,398 +706,398 @@ discard block |
||
706 | 706 | } // End If Statement |
707 | 707 | } // End sensei_grading_notices() |
708 | 708 | |
709 | - /** |
|
710 | - * Grade quiz automatically |
|
711 | - * |
|
712 | - * This function grades each question automatically if there all questions are auto gradable. If not |
|
713 | - * the quiz will not be auto gradable. |
|
714 | - * |
|
715 | - * @since 1.7.4 |
|
716 | - * |
|
717 | - * @param integer $quiz_id ID of quiz |
|
718 | - * @param array $submitted questions id ans answers { |
|
719 | - * @type int $question_id |
|
720 | - * @type mixed $answer |
|
721 | - * } |
|
722 | - * @param integer $total_questions Total questions in quiz (not used) |
|
723 | - * @param string $quiz_grade_type Optional defaults to auto |
|
724 | - * |
|
725 | - * @return int $quiz_grade total sum of all question grades |
|
726 | - */ |
|
727 | - public static function grade_quiz_auto( $quiz_id = 0, $submitted = array(), $total_questions = 0, $quiz_grade_type = 'auto' ) { |
|
728 | - |
|
729 | - if( ! ( intval( $quiz_id ) > 0 ) || ! $submitted |
|
730 | - || $quiz_grade_type != 'auto' ) { |
|
731 | - return false; // exit early |
|
732 | - } |
|
733 | - |
|
734 | - |
|
735 | - $user_id = get_current_user_id(); |
|
736 | - $lesson_id = Sensei()->quiz->get_lesson_id( $quiz_id ) ; |
|
737 | - $quiz_autogradable = true; |
|
738 | - |
|
739 | - /** |
|
740 | - * Filter the types of question types that can be automatically graded. |
|
741 | - * |
|
742 | - * This filter fires inside the auto grade quiz function and provides you with the default list. |
|
743 | - * |
|
744 | - * @param array { |
|
745 | - * 'multiple-choice', |
|
746 | - * 'boolean', |
|
747 | - * 'gap-fill'. |
|
748 | - * } |
|
749 | - */ |
|
750 | - $autogradable_question_types = apply_filters( 'sensei_autogradable_question_types', array( 'multiple-choice', 'boolean', 'gap-fill' ) ); |
|
751 | - |
|
752 | - $grade_total = 0; |
|
753 | - $all_question_grades = array(); |
|
754 | - foreach( $submitted as $question_id => $answer ) { |
|
755 | - |
|
756 | - // check if the question is autogradable, either by type, or because the grade is 0 |
|
757 | - $question_type = Sensei()->question->get_question_type( $question_id ); |
|
709 | + /** |
|
710 | + * Grade quiz automatically |
|
711 | + * |
|
712 | + * This function grades each question automatically if there all questions are auto gradable. If not |
|
713 | + * the quiz will not be auto gradable. |
|
714 | + * |
|
715 | + * @since 1.7.4 |
|
716 | + * |
|
717 | + * @param integer $quiz_id ID of quiz |
|
718 | + * @param array $submitted questions id ans answers { |
|
719 | + * @type int $question_id |
|
720 | + * @type mixed $answer |
|
721 | + * } |
|
722 | + * @param integer $total_questions Total questions in quiz (not used) |
|
723 | + * @param string $quiz_grade_type Optional defaults to auto |
|
724 | + * |
|
725 | + * @return int $quiz_grade total sum of all question grades |
|
726 | + */ |
|
727 | + public static function grade_quiz_auto( $quiz_id = 0, $submitted = array(), $total_questions = 0, $quiz_grade_type = 'auto' ) { |
|
728 | + |
|
729 | + if( ! ( intval( $quiz_id ) > 0 ) || ! $submitted |
|
730 | + || $quiz_grade_type != 'auto' ) { |
|
731 | + return false; // exit early |
|
732 | + } |
|
733 | + |
|
734 | + |
|
735 | + $user_id = get_current_user_id(); |
|
736 | + $lesson_id = Sensei()->quiz->get_lesson_id( $quiz_id ) ; |
|
737 | + $quiz_autogradable = true; |
|
738 | + |
|
739 | + /** |
|
740 | + * Filter the types of question types that can be automatically graded. |
|
741 | + * |
|
742 | + * This filter fires inside the auto grade quiz function and provides you with the default list. |
|
743 | + * |
|
744 | + * @param array { |
|
745 | + * 'multiple-choice', |
|
746 | + * 'boolean', |
|
747 | + * 'gap-fill'. |
|
748 | + * } |
|
749 | + */ |
|
750 | + $autogradable_question_types = apply_filters( 'sensei_autogradable_question_types', array( 'multiple-choice', 'boolean', 'gap-fill' ) ); |
|
751 | + |
|
752 | + $grade_total = 0; |
|
753 | + $all_question_grades = array(); |
|
754 | + foreach( $submitted as $question_id => $answer ) { |
|
755 | + |
|
756 | + // check if the question is autogradable, either by type, or because the grade is 0 |
|
757 | + $question_type = Sensei()->question->get_question_type( $question_id ); |
|
758 | 758 | $achievable_grade = Sensei()->question->get_question_grade( $question_id ); |
759 | 759 | // Question has a zero grade, so skip grading |
760 | 760 | if ( 0 == $achievable_grade ) { |
761 | 761 | $all_question_grades[ $question_id ] = $achievable_grade; |
762 | 762 | } |
763 | - elseif ( in_array( $question_type, $autogradable_question_types ) ) { |
|
764 | - // Get user question grade |
|
765 | - $question_grade = Sensei_Utils::sensei_grade_question_auto( $question_id, $question_type, $answer, $user_id ); |
|
766 | - $all_question_grades[ $question_id ] = $question_grade; |
|
767 | - $grade_total += $question_grade; |
|
763 | + elseif ( in_array( $question_type, $autogradable_question_types ) ) { |
|
764 | + // Get user question grade |
|
765 | + $question_grade = Sensei_Utils::sensei_grade_question_auto( $question_id, $question_type, $answer, $user_id ); |
|
766 | + $all_question_grades[ $question_id ] = $question_grade; |
|
767 | + $grade_total += $question_grade; |
|
768 | 768 | |
769 | - } else { |
|
769 | + } else { |
|
770 | 770 | |
771 | - // There is a question that cannot be autograded |
|
772 | - $quiz_autogradable = false; |
|
771 | + // There is a question that cannot be autograded |
|
772 | + $quiz_autogradable = false; |
|
773 | 773 | |
774 | - } // end if in_array( $question_type... |
|
774 | + } // end if in_array( $question_type... |
|
775 | 775 | |
776 | - }// end for each question |
|
776 | + }// end for each question |
|
777 | 777 | |
778 | - // Only if the whole quiz was autogradable do we set a grade |
|
779 | - if ( $quiz_autogradable ) { |
|
778 | + // Only if the whole quiz was autogradable do we set a grade |
|
779 | + if ( $quiz_autogradable ) { |
|
780 | 780 | |
781 | - $quiz_total = Sensei_Utils::sensei_get_quiz_total( $quiz_id ); |
|
781 | + $quiz_total = Sensei_Utils::sensei_get_quiz_total( $quiz_id ); |
|
782 | 782 | // Check for zero total from grades |
783 | 783 | if ( 0 < $quiz_total ) { |
784 | - $grade = abs( round( ( doubleval( $grade_total ) * 100 ) / ( $quiz_total ), 2 ) ); |
|
784 | + $grade = abs( round( ( doubleval( $grade_total ) * 100 ) / ( $quiz_total ), 2 ) ); |
|
785 | 785 | } |
786 | 786 | else { |
787 | 787 | $grade = 0; |
788 | 788 | } |
789 | - Sensei_Utils::sensei_grade_quiz( $quiz_id, $grade, $user_id, $quiz_grade_type ); |
|
789 | + Sensei_Utils::sensei_grade_quiz( $quiz_id, $grade, $user_id, $quiz_grade_type ); |
|
790 | 790 | |
791 | - } else { |
|
791 | + } else { |
|
792 | 792 | |
793 | - $grade = new WP_Error( 'autograde', __( 'This quiz is not able to be automatically graded.', 'woothemes-sensei' ) ); |
|
793 | + $grade = new WP_Error( 'autograde', __( 'This quiz is not able to be automatically graded.', 'woothemes-sensei' ) ); |
|
794 | 794 | |
795 | - } |
|
796 | - |
|
797 | - // store the auto gradable grades. If the quiz is not auto gradable the grades can be use as the default |
|
798 | - // when doing manual grading. |
|
799 | - Sensei()->quiz-> set_user_grades( $all_question_grades, $lesson_id, $user_id ); |
|
795 | + } |
|
800 | 796 | |
801 | - return $grade; |
|
797 | + // store the auto gradable grades. If the quiz is not auto gradable the grades can be use as the default |
|
798 | + // when doing manual grading. |
|
799 | + Sensei()->quiz-> set_user_grades( $all_question_grades, $lesson_id, $user_id ); |
|
802 | 800 | |
803 | - } // End grade_quiz_auto() |
|
801 | + return $grade; |
|
804 | 802 | |
805 | - /** |
|
806 | - * Grade question automatically |
|
807 | - * |
|
808 | - * This function checks the question typ and then grades it accordingly. |
|
809 | - * |
|
810 | - * @since 1.7.4 |
|
811 | - * |
|
812 | - * @param integer $question_id |
|
813 | - * @param string $question_type of the standard Sensei question types |
|
814 | - * @param string $answer |
|
815 | - * @param int $user_id |
|
816 | - * |
|
817 | - * @return int $question_grade |
|
818 | - */ |
|
819 | - public static function grade_question_auto( $question_id = 0, $question_type = '', $answer = '', $user_id = 0 ) { |
|
820 | - |
|
821 | - if( intval( $user_id ) == 0 ) { |
|
822 | - |
|
823 | - $user_id = get_current_user_id(); |
|
824 | - |
|
825 | - } |
|
826 | - |
|
827 | - if( ! ( intval( $question_id ) > 0 ) ) { |
|
828 | - |
|
829 | - return false; |
|
830 | - |
|
831 | - } |
|
832 | - |
|
833 | - |
|
834 | - Sensei()->question->get_question_type( $question_id ); |
|
835 | - |
|
836 | - /** |
|
837 | - * Applying a grade before the auto grading takes place. |
|
838 | - * |
|
839 | - * This filter is applied just before the question is auto graded. It fires in the context of a single question |
|
840 | - * in the sensei_grade_question_auto function. It fires irrespective of the question type. If you return a value |
|
841 | - * other than false the auto grade functionality will be ignored and your supplied grade will be user for this question. |
|
842 | - * |
|
843 | - * @param int $question_grade default false |
|
844 | - * @param int $question_id |
|
845 | - * @param string $question_type one of the Sensei question type. |
|
846 | - * @param string $answer user supplied question answer |
|
847 | - */ |
|
848 | - $question_grade = apply_filters( 'sensei_pre_grade_question_auto', false, $question_id, $question_type, $answer ); |
|
803 | + } // End grade_quiz_auto() |
|
849 | 804 | |
850 | - if ( false !== $question_grade ) { |
|
805 | + /** |
|
806 | + * Grade question automatically |
|
807 | + * |
|
808 | + * This function checks the question typ and then grades it accordingly. |
|
809 | + * |
|
810 | + * @since 1.7.4 |
|
811 | + * |
|
812 | + * @param integer $question_id |
|
813 | + * @param string $question_type of the standard Sensei question types |
|
814 | + * @param string $answer |
|
815 | + * @param int $user_id |
|
816 | + * |
|
817 | + * @return int $question_grade |
|
818 | + */ |
|
819 | + public static function grade_question_auto( $question_id = 0, $question_type = '', $answer = '', $user_id = 0 ) { |
|
851 | 820 | |
852 | - return $question_grade; |
|
821 | + if( intval( $user_id ) == 0 ) { |
|
853 | 822 | |
854 | - } |
|
823 | + $user_id = get_current_user_id(); |
|
855 | 824 | |
856 | - // auto grading core |
|
857 | - if( in_array( $question_type , array( 'multiple-choice' , 'boolean' ) ) ){ |
|
825 | + } |
|
858 | 826 | |
859 | - $right_answer = (array) get_post_meta( $question_id, '_question_right_answer', true ); |
|
827 | + if( ! ( intval( $question_id ) > 0 ) ) { |
|
860 | 828 | |
861 | - if( 0 == get_magic_quotes_gpc() ) { |
|
862 | - $answer = wp_unslash( $answer ); |
|
863 | - } |
|
864 | - $answer = (array) $answer; |
|
865 | - if ( is_array( $right_answer ) && count( $right_answer ) == count( $answer ) ) { |
|
866 | - // Loop through all answers ensure none are 'missing' |
|
867 | - $all_correct = true; |
|
868 | - foreach ( $answer as $check_answer ) { |
|
869 | - if ( !in_array( $check_answer, $right_answer ) ) { |
|
870 | - $all_correct = false; |
|
871 | - } |
|
872 | - } |
|
873 | - // If all correct then grade |
|
874 | - if ( $all_correct ) { |
|
875 | - $question_grade = Sensei()->question->get_question_grade( $question_id ); |
|
876 | - } |
|
877 | - } |
|
829 | + return false; |
|
878 | 830 | |
879 | - } elseif( 'gap-fill' == $question_type ){ |
|
831 | + } |
|
880 | 832 | |
881 | - $question_grade = self::grade_gap_fill_question( $question_id ,$answer ); |
|
882 | 833 | |
883 | - } else{ |
|
834 | + Sensei()->question->get_question_type( $question_id ); |
|
884 | 835 | |
885 | - /** |
|
886 | - * Grading questions that are not auto gradable. |
|
887 | - * |
|
888 | - * This filter is applied the context of ta single question within the sensei_grade_question_auto function. |
|
889 | - * It fires for all other questions types. It does not apply to 'multiple-choice' , 'boolean' and gap-fill. |
|
890 | - * |
|
891 | - * @param int $question_grade default zero |
|
892 | - * @param int $question_id |
|
893 | - * @param string $question_type one of the Sensei question type. |
|
894 | - * @param string $answer user supplied question answer |
|
895 | - */ |
|
896 | - $question_grade = ( int ) apply_filters( 'sensei_grade_question_auto', $question_grade, $question_id, $question_type, $answer ); |
|
836 | + /** |
|
837 | + * Applying a grade before the auto grading takes place. |
|
838 | + * |
|
839 | + * This filter is applied just before the question is auto graded. It fires in the context of a single question |
|
840 | + * in the sensei_grade_question_auto function. It fires irrespective of the question type. If you return a value |
|
841 | + * other than false the auto grade functionality will be ignored and your supplied grade will be user for this question. |
|
842 | + * |
|
843 | + * @param int $question_grade default false |
|
844 | + * @param int $question_id |
|
845 | + * @param string $question_type one of the Sensei question type. |
|
846 | + * @param string $answer user supplied question answer |
|
847 | + */ |
|
848 | + $question_grade = apply_filters( 'sensei_pre_grade_question_auto', false, $question_id, $question_type, $answer ); |
|
897 | 849 | |
898 | - } // end if $question_type |
|
850 | + if ( false !== $question_grade ) { |
|
899 | 851 | |
900 | - return $question_grade; |
|
901 | - } // end grade_question_auto |
|
852 | + return $question_grade; |
|
902 | 853 | |
903 | - /** |
|
904 | - * Grading logic specifically for the gap fill questions |
|
905 | - * |
|
906 | - * @since 1.9.0 |
|
907 | - * @param $question_id |
|
908 | - * @param $user_answer |
|
909 | - * |
|
910 | - * @return bool | int false or the grade given to the user answer |
|
911 | - */ |
|
912 | - public static function grade_gap_fill_question( $question_id, $user_answer ){ |
|
854 | + } |
|
913 | 855 | |
914 | - $right_answer = get_post_meta( $question_id, '_question_right_answer', true ); |
|
915 | - $gapfill_array = explode( '||', $right_answer ); |
|
856 | + // auto grading core |
|
857 | + if( in_array( $question_type , array( 'multiple-choice' , 'boolean' ) ) ){ |
|
916 | 858 | |
917 | - if( 0 == get_magic_quotes_gpc() ) { // deprecated from PHP 5.4 but we still support PHP 5.2 |
|
918 | - $user_answer = wp_unslash( $user_answer ); |
|
919 | - } |
|
859 | + $right_answer = (array) get_post_meta( $question_id, '_question_right_answer', true ); |
|
920 | 860 | |
921 | - /** |
|
922 | - * case sensitive grading filter |
|
923 | - * |
|
924 | - * alter the value simply use this code in your plugin or the themes functions.php |
|
925 | - * add_filter( 'sensei_gap_fill_case_sensitive_grading','__return_true' ); |
|
926 | - * |
|
927 | - * @param bool $do_case_sensitive_comparison default false. |
|
928 | - * |
|
929 | - * @since 1.9.0 |
|
930 | - */ |
|
931 | - $do_case_sensitive_comparison = apply_filters('sensei_gap_fill_case_sensitive_grading', false ); |
|
861 | + if( 0 == get_magic_quotes_gpc() ) { |
|
862 | + $answer = wp_unslash( $answer ); |
|
863 | + } |
|
864 | + $answer = (array) $answer; |
|
865 | + if ( is_array( $right_answer ) && count( $right_answer ) == count( $answer ) ) { |
|
866 | + // Loop through all answers ensure none are 'missing' |
|
867 | + $all_correct = true; |
|
868 | + foreach ( $answer as $check_answer ) { |
|
869 | + if ( !in_array( $check_answer, $right_answer ) ) { |
|
870 | + $all_correct = false; |
|
871 | + } |
|
872 | + } |
|
873 | + // If all correct then grade |
|
874 | + if ( $all_correct ) { |
|
875 | + $question_grade = Sensei()->question->get_question_grade( $question_id ); |
|
876 | + } |
|
877 | + } |
|
932 | 878 | |
933 | - if( $do_case_sensitive_comparison ){ |
|
879 | + } elseif( 'gap-fill' == $question_type ){ |
|
934 | 880 | |
935 | - // Case Sensitive Check that the 'gap' is "exactly" equal to the given answer |
|
936 | - if ( trim(($gapfill_array[1])) == trim( $user_answer ) ) { |
|
881 | + $question_grade = self::grade_gap_fill_question( $question_id ,$answer ); |
|
937 | 882 | |
938 | - return Sensei()->question->get_question_grade( $question_id ); |
|
883 | + } else{ |
|
939 | 884 | |
940 | - } else if (@preg_match('/' . $gapfill_array[1] . '/i', null) !== FALSE) { |
|
885 | + /** |
|
886 | + * Grading questions that are not auto gradable. |
|
887 | + * |
|
888 | + * This filter is applied the context of ta single question within the sensei_grade_question_auto function. |
|
889 | + * It fires for all other questions types. It does not apply to 'multiple-choice' , 'boolean' and gap-fill. |
|
890 | + * |
|
891 | + * @param int $question_grade default zero |
|
892 | + * @param int $question_id |
|
893 | + * @param string $question_type one of the Sensei question type. |
|
894 | + * @param string $answer user supplied question answer |
|
895 | + */ |
|
896 | + $question_grade = ( int ) apply_filters( 'sensei_grade_question_auto', $question_grade, $question_id, $question_type, $answer ); |
|
941 | 897 | |
942 | - if (preg_match('/' . $gapfill_array[1] . '/i', $user_answer)) { |
|
898 | + } // end if $question_type |
|
943 | 899 | |
944 | - return Sensei()->question->get_question_grade($question_id); |
|
900 | + return $question_grade; |
|
901 | + } // end grade_question_auto |
|
945 | 902 | |
946 | - }else{ |
|
903 | + /** |
|
904 | + * Grading logic specifically for the gap fill questions |
|
905 | + * |
|
906 | + * @since 1.9.0 |
|
907 | + * @param $question_id |
|
908 | + * @param $user_answer |
|
909 | + * |
|
910 | + * @return bool | int false or the grade given to the user answer |
|
911 | + */ |
|
912 | + public static function grade_gap_fill_question( $question_id, $user_answer ){ |
|
947 | 913 | |
948 | - return false; |
|
914 | + $right_answer = get_post_meta( $question_id, '_question_right_answer', true ); |
|
915 | + $gapfill_array = explode( '||', $right_answer ); |
|
949 | 916 | |
950 | - } |
|
917 | + if( 0 == get_magic_quotes_gpc() ) { // deprecated from PHP 5.4 but we still support PHP 5.2 |
|
918 | + $user_answer = wp_unslash( $user_answer ); |
|
919 | + } |
|
951 | 920 | |
952 | - }else{ |
|
921 | + /** |
|
922 | + * case sensitive grading filter |
|
923 | + * |
|
924 | + * alter the value simply use this code in your plugin or the themes functions.php |
|
925 | + * add_filter( 'sensei_gap_fill_case_sensitive_grading','__return_true' ); |
|
926 | + * |
|
927 | + * @param bool $do_case_sensitive_comparison default false. |
|
928 | + * |
|
929 | + * @since 1.9.0 |
|
930 | + */ |
|
931 | + $do_case_sensitive_comparison = apply_filters('sensei_gap_fill_case_sensitive_grading', false ); |
|
953 | 932 | |
954 | - return false; |
|
933 | + if( $do_case_sensitive_comparison ){ |
|
955 | 934 | |
956 | - } |
|
935 | + // Case Sensitive Check that the 'gap' is "exactly" equal to the given answer |
|
936 | + if ( trim(($gapfill_array[1])) == trim( $user_answer ) ) { |
|
957 | 937 | |
958 | - }else{ |
|
938 | + return Sensei()->question->get_question_grade( $question_id ); |
|
959 | 939 | |
960 | - // Case Sensitive Check that the 'gap' is "exactly" equal to the given answer |
|
961 | - if ( trim(strtolower($gapfill_array[1])) == trim(strtolower( $user_answer )) ) { |
|
940 | + } else if (@preg_match('/' . $gapfill_array[1] . '/i', null) !== FALSE) { |
|
962 | 941 | |
963 | - return Sensei()->question->get_question_grade( $question_id ); |
|
942 | + if (preg_match('/' . $gapfill_array[1] . '/i', $user_answer)) { |
|
964 | 943 | |
965 | - } else if (@preg_match('/' . $gapfill_array[1] . '/i', null) !== FALSE) { |
|
944 | + return Sensei()->question->get_question_grade($question_id); |
|
966 | 945 | |
967 | - if (preg_match('/' . $gapfill_array[1] . '/i', $user_answer)) { |
|
946 | + }else{ |
|
968 | 947 | |
969 | - return Sensei()->question->get_question_grade( $question_id ); |
|
948 | + return false; |
|
970 | 949 | |
971 | - }else{ |
|
950 | + } |
|
972 | 951 | |
973 | - return false; |
|
952 | + }else{ |
|
974 | 953 | |
975 | - } |
|
954 | + return false; |
|
976 | 955 | |
977 | - }else{ |
|
956 | + } |
|
957 | + |
|
958 | + }else{ |
|
959 | + |
|
960 | + // Case Sensitive Check that the 'gap' is "exactly" equal to the given answer |
|
961 | + if ( trim(strtolower($gapfill_array[1])) == trim(strtolower( $user_answer )) ) { |
|
962 | + |
|
963 | + return Sensei()->question->get_question_grade( $question_id ); |
|
964 | + |
|
965 | + } else if (@preg_match('/' . $gapfill_array[1] . '/i', null) !== FALSE) { |
|
966 | + |
|
967 | + if (preg_match('/' . $gapfill_array[1] . '/i', $user_answer)) { |
|
968 | + |
|
969 | + return Sensei()->question->get_question_grade( $question_id ); |
|
970 | + |
|
971 | + }else{ |
|
972 | + |
|
973 | + return false; |
|
974 | + |
|
975 | + } |
|
978 | 976 | |
979 | - return false; |
|
977 | + }else{ |
|
978 | + |
|
979 | + return false; |
|
980 | + |
|
981 | + } |
|
982 | + |
|
983 | + } |
|
984 | + |
|
985 | + } |
|
986 | + |
|
987 | + /** |
|
988 | + * Counts the lessons that have been graded manually and automatically |
|
989 | + * |
|
990 | + * @since 1.9.0 |
|
991 | + * @return int $number_of_graded_lessons |
|
992 | + */ |
|
993 | + public static function get_graded_lessons_count(){ |
|
980 | 994 | |
981 | - } |
|
995 | + global $wpdb; |
|
982 | 996 | |
983 | - } |
|
997 | + $comment_query_piece[ 'select'] = "SELECT COUNT(*) AS total"; |
|
998 | + $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
999 | + $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_lesson_status') AND ( {$wpdb->wp_commentmeta}.meta_key = 'grade')"; |
|
1000 | + $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
984 | 1001 | |
985 | - } |
|
1002 | + $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1003 | + $number_of_graded_lessons = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
986 | 1004 | |
987 | - /** |
|
988 | - * Counts the lessons that have been graded manually and automatically |
|
989 | - * |
|
990 | - * @since 1.9.0 |
|
991 | - * @return int $number_of_graded_lessons |
|
992 | - */ |
|
993 | - public static function get_graded_lessons_count(){ |
|
1005 | + return $number_of_graded_lessons; |
|
1006 | + } |
|
994 | 1007 | |
995 | - global $wpdb; |
|
1008 | + /** |
|
1009 | + * Add together all the graded lesson grades |
|
1010 | + * |
|
1011 | + * @since 1.9.0 |
|
1012 | + * @return double $sum_of_all_grades |
|
1013 | + */ |
|
1014 | + public static function get_graded_lessons_sum(){ |
|
996 | 1015 | |
997 | - $comment_query_piece[ 'select'] = "SELECT COUNT(*) AS total"; |
|
998 | - $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
999 | - $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_lesson_status') AND ( {$wpdb->wp_commentmeta}.meta_key = 'grade')"; |
|
1000 | - $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
1016 | + global $wpdb; |
|
1001 | 1017 | |
1002 | - $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1003 | - $number_of_graded_lessons = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
1018 | + $comment_query_piece[ 'select'] = "SELECT SUM({$wpdb->commentmeta}.meta_value) AS meta_sum"; |
|
1019 | + $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
1020 | + $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_lesson_status') AND ( {$wpdb->commentmeta}.meta_key = 'grade')"; |
|
1021 | + $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
1004 | 1022 | |
1005 | - return $number_of_graded_lessons; |
|
1006 | - } |
|
1023 | + $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1024 | + $sum_of_all_grades = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
1007 | 1025 | |
1008 | - /** |
|
1009 | - * Add together all the graded lesson grades |
|
1010 | - * |
|
1011 | - * @since 1.9.0 |
|
1012 | - * @return double $sum_of_all_grades |
|
1013 | - */ |
|
1014 | - public static function get_graded_lessons_sum(){ |
|
1026 | + return $sum_of_all_grades; |
|
1015 | 1027 | |
1016 | - global $wpdb; |
|
1028 | + } |
|
1017 | 1029 | |
1018 | - $comment_query_piece[ 'select'] = "SELECT SUM({$wpdb->commentmeta}.meta_value) AS meta_sum"; |
|
1019 | - $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
1020 | - $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_lesson_status') AND ( {$wpdb->commentmeta}.meta_key = 'grade')"; |
|
1021 | - $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
1030 | + /** |
|
1031 | + * Get the sum of all grades for the given user. |
|
1032 | + * |
|
1033 | + * @since 1.9.0 |
|
1034 | + * @param $user_id |
|
1035 | + * @return double |
|
1036 | + */ |
|
1037 | + public static function get_user_graded_lessons_sum( $user_id ){ |
|
1038 | + global $wpdb; |
|
1022 | 1039 | |
1023 | - $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1024 | - $sum_of_all_grades = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
1040 | + $clean_user_id = esc_sql( $user_id); |
|
1041 | + $comment_query_piece[ 'select'] = "SELECT SUM({$wpdb->commentmeta}.meta_value) AS meta_sum"; |
|
1042 | + $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
1043 | + $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_lesson_status') AND ( {$wpdb->commentmeta}.meta_key = 'grade') AND {$wpdb->comments}.user_id = {$clean_user_id} "; |
|
1044 | + $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
1025 | 1045 | |
1026 | - return $sum_of_all_grades; |
|
1046 | + $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1047 | + $sum_of_all_grades = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
1027 | 1048 | |
1028 | - } |
|
1049 | + return $sum_of_all_grades; |
|
1050 | + } |
|
1029 | 1051 | |
1030 | - /** |
|
1031 | - * Get the sum of all grades for the given user. |
|
1032 | - * |
|
1033 | - * @since 1.9.0 |
|
1034 | - * @param $user_id |
|
1035 | - * @return double |
|
1036 | - */ |
|
1037 | - public static function get_user_graded_lessons_sum( $user_id ){ |
|
1038 | - global $wpdb; |
|
1052 | + /** |
|
1053 | + * Get the sum of all user grades for the given lesson. |
|
1054 | + * |
|
1055 | + * @since 1.9.0 |
|
1056 | + * |
|
1057 | + * @param int lesson_id |
|
1058 | + * @return double |
|
1059 | + */ |
|
1060 | + public static function get_lessons_users_grades_sum( $lesson_id ){ |
|
1039 | 1061 | |
1040 | - $clean_user_id = esc_sql( $user_id); |
|
1041 | - $comment_query_piece[ 'select'] = "SELECT SUM({$wpdb->commentmeta}.meta_value) AS meta_sum"; |
|
1042 | - $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
1043 | - $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_lesson_status') AND ( {$wpdb->commentmeta}.meta_key = 'grade') AND {$wpdb->comments}.user_id = {$clean_user_id} "; |
|
1044 | - $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
1062 | + global $wpdb; |
|
1045 | 1063 | |
1046 | - $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1047 | - $sum_of_all_grades = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
1064 | + $clean_lesson_id = esc_sql( $lesson_id); |
|
1065 | + $comment_query_piece[ 'select'] = "SELECT SUM({$wpdb->commentmeta}.meta_value) AS meta_sum"; |
|
1066 | + $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
1067 | + $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_lesson_status') AND ( {$wpdb->commentmeta}.meta_key = 'grade') AND {$wpdb->comments}.comment_post_ID = {$clean_lesson_id} "; |
|
1068 | + $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
1048 | 1069 | |
1049 | - return $sum_of_all_grades; |
|
1050 | - } |
|
1070 | + $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1071 | + $sum_of_all_grades = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
1051 | 1072 | |
1052 | - /** |
|
1053 | - * Get the sum of all user grades for the given lesson. |
|
1054 | - * |
|
1055 | - * @since 1.9.0 |
|
1056 | - * |
|
1057 | - * @param int lesson_id |
|
1058 | - * @return double |
|
1059 | - */ |
|
1060 | - public static function get_lessons_users_grades_sum( $lesson_id ){ |
|
1073 | + return $sum_of_all_grades; |
|
1061 | 1074 | |
1062 | - global $wpdb; |
|
1075 | + }//get_lessons_user_grades_sum |
|
1063 | 1076 | |
1064 | - $clean_lesson_id = esc_sql( $lesson_id); |
|
1065 | - $comment_query_piece[ 'select'] = "SELECT SUM({$wpdb->commentmeta}.meta_value) AS meta_sum"; |
|
1066 | - $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
1067 | - $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_lesson_status') AND ( {$wpdb->commentmeta}.meta_key = 'grade') AND {$wpdb->comments}.comment_post_ID = {$clean_lesson_id} "; |
|
1068 | - $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
1077 | + /** |
|
1078 | + * Get the sum of all user grades for the given course. |
|
1079 | + * |
|
1080 | + * @since 1.9.0 |
|
1081 | + * |
|
1082 | + * @param int $course_id |
|
1083 | + * @return double |
|
1084 | + */ |
|
1085 | + public static function get_course_users_grades_sum( $course_id ){ |
|
1069 | 1086 | |
1070 | - $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1071 | - $sum_of_all_grades = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
1087 | + global $wpdb; |
|
1072 | 1088 | |
1073 | - return $sum_of_all_grades; |
|
1089 | + $clean_course_id = esc_sql( $course_id); |
|
1090 | + $comment_query_piece[ 'select'] = "SELECT SUM({$wpdb->commentmeta}.meta_value) AS meta_sum"; |
|
1091 | + $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
1092 | + $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_course_status') AND ( {$wpdb->commentmeta}.meta_key = 'percent') AND {$wpdb->comments}.comment_post_ID = {$clean_course_id} "; |
|
1093 | + $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
1074 | 1094 | |
1075 | - }//get_lessons_user_grades_sum |
|
1095 | + $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1096 | + $sum_of_all_grades = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
1076 | 1097 | |
1077 | - /** |
|
1078 | - * Get the sum of all user grades for the given course. |
|
1079 | - * |
|
1080 | - * @since 1.9.0 |
|
1081 | - * |
|
1082 | - * @param int $course_id |
|
1083 | - * @return double |
|
1084 | - */ |
|
1085 | - public static function get_course_users_grades_sum( $course_id ){ |
|
1086 | - |
|
1087 | - global $wpdb; |
|
1088 | - |
|
1089 | - $clean_course_id = esc_sql( $course_id); |
|
1090 | - $comment_query_piece[ 'select'] = "SELECT SUM({$wpdb->commentmeta}.meta_value) AS meta_sum"; |
|
1091 | - $comment_query_piece[ 'from'] = " FROM {$wpdb->comments} INNER JOIN {$wpdb->commentmeta} ON ( {$wpdb->comments}.comment_ID = {$wpdb->commentmeta}.comment_id ) "; |
|
1092 | - $comment_query_piece[ 'where'] = " WHERE {$wpdb->comments}.comment_type IN ('sensei_course_status') AND ( {$wpdb->commentmeta}.meta_key = 'percent') AND {$wpdb->comments}.comment_post_ID = {$clean_course_id} "; |
|
1093 | - $comment_query_piece[ 'orderby'] = " ORDER BY {$wpdb->comments}.comment_date_gmt DESC "; |
|
1098 | + return $sum_of_all_grades; |
|
1094 | 1099 | |
1095 | - $comment_query = $comment_query_piece['select'] . $comment_query_piece['from'] . $comment_query_piece['where'] . $comment_query_piece['orderby']; |
|
1096 | - $sum_of_all_grades = intval( $wpdb->get_var( $comment_query, 0, 0 ) ); |
|
1097 | - |
|
1098 | - return $sum_of_all_grades; |
|
1099 | - |
|
1100 | - }//get_lessons_user_grades_sum |
|
1100 | + }//get_lessons_user_grades_sum |
|
1101 | 1101 | |
1102 | 1102 | } // End Class |
1103 | 1103 |