有时候我们给网站增加了一些功能,比如在线充值,那么需要在后台能看到用户的充值记录,所以需要添加一个后台菜单。
add_action('admin_menu', 'credit_logs_page');
function credit_logs_page() {
add_menu_page('充值记录', '充值记录', 'manage_options', 'CREDIT_LOGS', 'credit_logs');
add_submenu_page( 'CREDIT_LOGS', '购买记录', '购买记录','manage_options', 'ORDER_LOGS', 'order_logs');
add_submenu_page( 'CREDIT_LOGS', '后台充值', '后台充值','manage_options', 'CREDIT_ADD', 'credit_add');
}
function credit_logs(){
global $wpdb;
$total = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->credits WHERE status=1");
$perpage = 20;
$pages = ceil($total / $perpage);
$page=isset($_GET['paged']) ?intval($_GET['paged']) :1;
$offset = $perpage*($page-1);
$orders=$wpdb->get_results("SELECT * FROM $wpdb->credits where status=1 order by create_date DESC limit $offset,$perpage");
?>
<div class="wrap">
<h1 class="wp-heading-inline">充值记录</h1>
<table class="wp-list-table widefat fixed posts">
<thead>
<tr>
<th width="20%">用户ID</th>
<th width="30%">充值金额</th>
<th width="50%">充值时间</th>
</tr>
</thead>
<tbody>
<?php
if($orders){
foreach ($orders as $order) {
echo "<tr>\n";
echo "<td>".get_user_by("id",$order->user_id)->user_login."</td>";
echo "<td>".$order->price." 元</td>";
echo "<td>".$order->create_date."</td>";
}
}
?>
</tbody>
</table>
<?php echo MBThemes_admin_pagenavi($total,$perpage);?>
</div>
<?php}


0 个评论