Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function training_shortcode_analysis( $atts ) {
- extract( shortcode_atts( array(
- //'item' => null, //itemID
- //'status' => 'active' //active or deleted
- ), $atts ) );
- //Parse attributes if you have any
- //$item = esc_attr(strtolower($item));
- $output = "";
- $courses = array();
- $classes = array();
- $students = array();
- $quizzes = array();
- $queryParameters = array(
- 'post_type' => 'course',
- 'posts_per_page' => '-1',
- );
- $courseQuery = new WP_Query();
- $courseQuery->query($queryParameters);
- if ( $courseQuery->have_posts() ) : while ( $courseQuery->have_posts() ) : $courseQuery->the_post();
- $key = get_the_ID();
- $courses[$key] = get_the_title();
- endwhile; endif;
- //wp_reset_query();
- $queryParameters = array(
- 'post_type' => 'class',
- 'posts_per_page' => '-1',
- );
- $classQuery = new WP_Query();
- $classQuery->query($queryParameters);
- if ( $classQuery->have_posts() ) : while ( $classQuery->have_posts() ) : $classQuery->the_post();
- $key = get_the_ID();
- $classes[$key] = get_the_title();
- endwhile; endif;
- //wp_reset_query();
- $queryParameters = array(
- 'post_type' => 'quiz',
- 'posts_per_page' => '-1',
- );
- $quizQuery = new WP_Query();
- $quizQuery->query($queryParameters);
- if ( $quizQuery->have_posts() ) : while ( $quizQuery->have_posts() ) : $quizQuery->the_post();
- $key = get_the_ID();
- $quizzes[$key] = get_the_title();
- endwhile; endif;
- //wp_reset_query();
- $users = get_users( );
- foreach( $users as $user ) {
- $key = $user->user_login;
- if (isset($user->display_name)) {
- $students[$key] = $user->display_name;
- } else {
- $students[$key] = $user->user_login;
- }
- }
- $output .= "<table id='trainingAnalysis'>";
- $output .= "<thead><tr><th>Course</th><th>Class</th><th>Student</th><th>Quiz</th><th>Percentage</th><th>Date</th></tr></thead><tbody>";
- $resultParamters = array(
- 'post_type' => 'result',
- 'posts_per_page' => '250',
- 'cache_results' => false,
- 'meta_query' => array(
- array(
- 'key' => 'result_quiz',
- 'value' => '269',
- 'compare' => '=',
- )
- )
- );
- $resultQuery = new WP_Query();
- $resultQuery->query($resultParamters);
- //Loop through results
- if ( $resultQuery->have_posts() ) :
- while ( $resultQuery->have_posts() ) : $resultQuery->the_post();
- $resultID = get_the_ID();
- if($courses[get_post_meta( $resultID, 'result_course', true)] && $classes[get_post_meta( $resultID, 'result_class', true)]) {
- $output .= "<tr>";
- $output .= "<td>" . $courses[get_post_meta( $resultID, 'result_course', true)] . "</td>";
- $output .= "<td>" . $classes[get_post_meta( $resultID, 'result_class', true)] . "</td>";
- $output .= "<td>" . $students[get_post_meta( $resultID, 'result_student', true)] . "</td>";
- $output .= "<td>" . $quizzes[get_post_meta( $resultID, 'result_quiz', true)] . "</td>";
- $output .= "<td>" . get_post_meta( $resultID, 'result_percentage', true) . "%</td>";
- $output .= "<td>" . date("d/m/Y @ g:ia", strtotime(get_post_meta( get_the_ID(), 'result_date', true ))-14400) . "</td>";
- }
- endwhile;
- endif;
- $output .= "</table>";
- return $output;
- }
Advertisement
Add Comment
Please, Sign In to add comment