Ejemplo n.º 1
0
    function bp_course_get_course_quiz_submissions($course_id)
    {
        $quizes = bp_course_get_curriculum_quizes($course_id);
        if (!empty($quizes)) {
            ?>
			<div class="submissions_form">
				<select id="fetch_quiz">
				<?php 
            foreach ($quizes as $quiz_id) {
                ?>
					<option value="<?php 
                echo $quiz_id;
                ?>
"><?php 
                echo get_the_title($quiz_id);
                ?>
</option>
					<?php 
            }
            ?>
				</select>
				<select id="fetch_status">
					<option value="0"><?php 
            echo _x('Pending evaluation', 'Quiz status', 'vibe');
            ?>
</option>
					<option value="1"><?php 
            echo _x('Evaluation complete', 'Quiz status', 'vibe');
            ?>
</option>
				</select>
				<?php 
            wp_nonce_field('quiz_submissions', 'quiz_submissions');
            ?>
				<a id="fetch_quiz_submissions" class="button"><?php 
            echo _x('Get', 'get quiz submissions button', 'vibe');
            ?>
</a>
			</div>
			<script>
				jQuery(document).ready(function($){
					$('#fetch_quiz_submissions').on('click',function(){
						var parent = $(this).parent();
						$('.quiz_students').remove();
						$('.message').remove();
						$.ajax({
	                      	type: "POST",
	                      	url: ajaxurl,
	                      	data: { action: 'fetch_quiz_submissions', 
	                              	security: $('#quiz_submissions').val(),
	                              	quiz_id:$('#fetch_quiz').val(),
	                              	status:$('#fetch_status').val(),
	                            	},
	                      	cache: false,
	                      	success: function (html) {
	                      		parent.after(html);
	                      		$('#quiz').trigger('loaded');
	                      	}
	                    });
					});
				});
			</script>
			<?php 
        } else {
            ?>
			<div class="message">
				<p><?php 
            echo _x('No Quiz found !', 'No quizzes in course, error on course submissions', 'vibe');
            ?>
</p>
			</div>
			<?php 
        }
    }
Ejemplo n.º 2
0
function bp_course_get_quiz_submission_count($course_id)
{
    global $wpdb;
    $quizes = bp_course_get_curriculum_quizes($course_id);
    $quiz_ids = implode(',', $quizes);
    $count = $wpdb->get_var("SELECT count(*) FROM {$wpdb->postmeta} as p LEFT JOIN {$wpdb->usermeta} as u ON p.meta_key = u.user_id WHERE p.meta_value LIKE '0' AND u.meta_key = p.post_id AND p.post_id IN ({$quiz_ids})");
    return empty($count) ? 0 : $count;
}