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