AnsPress_Dashboard::anspress_latesta()
Description #
Show latest answers.
Source #
File: admin/views/dashboard.php
public static function anspress_latesta() { global $answers, $wpdb; $results = $wpdb->get_results( "SELECT date_format(post_date, '%d %a') as post_day, post_date, count(ID) as post_count from {$wpdb->posts} WHERE post_status IN('publish', 'private_post', 'moderate') AND post_type = 'answer' AND post_date > (NOW() - INTERVAL 1 MONTH) GROUP BY post_day ORDER BY post_date ASC" ); // phpcs:ignore WordPress.DB $days = array(); $counts = array(); foreach ( (array) $results as $r ) { $days[] = $r->post_day; $counts[] = $r->post_count; } ?> <?php if ( $results ) : ?> <?php endif; ?> <div class="main"> <?php $answers = ap_get_answers( array( 'ap_order_by' => 'newest', 'showposts' => 5, 'question_id' => 'all', ) ); ?> <?php if ( ap_have_answers() ) : ?> <ul class="post-list"> <?php while ( ap_have_answers() ) : ap_the_answer(); ?> <li> <a target="_blank" href="<?php the_permalink(); ?>"><?php echo esc_html( get_the_title() ); ?></a> - <span class="posted"><?php echo esc_html( get_the_date() ); ?></span> </li> <?php endwhile; ?> </ul> <?php endif; ?> <?php wp_reset_postdata(); ?> </div> <?php }
Expand full source code Collapse full source code View on GitHub: admin/views/dashboard.php:147
Add your comment