zh_tcwq/inc/web/lqlist.inc.php

<?php
global $_GPC, $_W;
$GLOBALS['frames'] = $this->getMainMenu();
if (!$_GPC['type']) {
	$_GPC['type'] = 'all';
}
$where = " where a.coupons_id=:coupons_id and a.pay_type=2";
$data[':coupons_id'] = $_GPC['id'];
if ($_GPC['type'] == 'ok') {
	$where .= " and a.state=1";
}
if ($_GPC['type'] == 'no') {
	$where .= " and a.state=2";
}
$pageindex = max(1, intval($_GPC['page']));
$pagesize = 10;
$sql = "SELECT a.*,b.name as user_name,b.img as user_img FROM " . tablename('zhtc_usercoupons') . " a" . " left join " . tablename("zhtc_user") . " b on a.user_id=b.id  " . $where . " ORDER BY a.id DESC";
$total = pdo_fetchcolumn("SELECT count(*) FROM " . tablename('zhtc_usercoupons') . " a" . " left join " . tablename("zhtc_user") . " b on a.user_id=b.id " . $where . " ORDER BY a.id DESC", $data);
$select_sql = $sql . " LIMIT " . ($pageindex - 1) * $pagesize . "," . $pagesize;

$list = pdo_fetchall($select_sql, $data);
$pager = pagination($total, $pageindex, $pagesize);
include $this->template('web/lqlist');