if ($adjacents <= 0) {
$adjacents = 2;
}
$reload = $_SERVER['PHP_SELF'] . "?tpages=" . $tpages . "&adjacents=" . $adjacents;
$from = ($page - 1) * $rpp;
$members = $db->query("SELECT * FROM `wm_admin_c` limit {$from},{$rpp}")->fetchall();
?>
<table width="100%" border=0 align=center cellpadding=2 cellspacing=1 bordercolor="#799AE1" class=tableBorder>
<tbody>
<tr>
<th align=center colspan=4 style="height: 23px">会员信息</th>
</tr>
<tr bgcolor="#DEE5FA">
<td align="center" colspan="4" align="center" class=txlrow>
<font color="#FF0000"><?php
echo paginate_three($reload, $page, $tpages, $adjacents);
?>
</font>
</td>
</tr>
<tr bgcolor="#799AE1">
<td width="25%" class=txlHeaderBackgroundAlternate>会员昵称</td>
<td width="25%" class=txlHeaderBackgroundAlternate>Email</td>
<td width="25%" class=txlHeaderBackgroundAlternate>注册时间</td>
<td width="25%" class=txlHeaderBackgroundAlternate>会员积分</td>
</tr>
<?php
foreach ($members as $mem) {
?>
<tr>
<td class=txlrow><?php
// results per page
$adjacents = intval($_GET['adjacents']);
if (!$_GET['tpages']) {
$count = $db->query("SELECT count(`id`) FROM `wm_grade` WHERE `shopid`='{$shopid}' and `speed`='0'")->fetchColumn();
$tpages = $count ? ceil($count / $rpp) : 1;
// total pages, last page number
} else {
$tpages = $_GET['tpages'];
}
if ($adjacents <= 0) {
$adjacents = 2;
}
$from = ($page - 1) * $rpp;
$dinpj = $db->query("SELECT `wm_grade`.*,`wm_admin_c`.`nickname` FROM `wm_grade`,`wm_admin_c` WHERE `wm_grade`.`shopid`='{$shopid}' and `wm_grade`.`speed` ='0' and `wm_grade`.email=`wm_admin_c`.email ORDER BY `postdate` DESC limit {$from},{$rpp}")->fetchall();
$reload = $_SERVER['PHP_SELF'] . "?tpages=" . $tpages . "&adjacents=" . $adjacents . "&shopid=" . $shopid . "&tag=" . $tag;
$smarty->assign("paginate", paginate_three($reload, $page, $tpages, $adjacents));
foreach ($dinpj as $key => $pjrow) {
$dininfo = $db->query("select `dinname`,`dinprice`,`isellout` from wm_dininfo where dinid='" . $pjrow['gradeid'] . "'")->fetch();
$dinpj[$key]['dinname'] = $dininfo['dinname'];
$dinpj[$key]['dinprice'] = $dininfo['dinprice'];
$dinpj[$key]['isellout'] = $dininfo['isellout'];
}
//餐品评价结束
}
$smarty->assign("dinpj", $dinpj);
$smarty->assign("yysj", $yysj);
$smarty->assign("shopinfo", $shopinfo);
$smarty->assign("dinners", $dinners);
$smarty->assign("shops", $dintypes);
echo "<div id='sidebar'>";
$smarty->assign("shopcart", $cart->display_cart($jcart));
