@@ -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 | |