コード例 #1
0
ファイル: list.php プロジェクト: show123456/taiyou
    $have_cent = (int) $_POST['have_cent'];
    $id = (int) $_POST['id'];
    $memberModel->query("update member set have_cent='{$have_cent}' where customer_id='{$customer_id}' and id='{$id}'");
    echo $have_cent;
    die;
}
//sql
$filter = array();
$filter['where'] = "customer_id = {$customer_id}";
$filter['order'] = "id desc";
$filter['order'] .= $status ? ',status asc' : ',status desc';
if ($have_cent) {
    $filter['order'] .= ',have_cent desc';
}
//result
$result = $memberModel->paginate($filter, '*', $page, 10);
$pager = $result['pager'];
//pager
if ($pager['count'] > $pager['size']) {
    $pagerhtml = new SubPages($pager['size'], $pager['count'], $pager['current'], $pager['range'], 2, '');
    $smarty->assign("pagerhtml", $pagerhtml);
}
foreach ($result['data'] as $key => $row) {
    $result['data'][$key]['subscribe_time'] = date('Y-m-d', $row['subscribe_time']);
    $result['data'][$key]['unsubscribe_time'] = date('Y-m-d', $row['unsubscribe_time']);
    $result['data'][$key]['status'] = $memberModel->getStatus($row['status']);
}
//smarty
$smarty->assign("memberlist", $result['data']);
$smarty->assign('statusUri', Helper_Page::status(!$status));
//排序uri拼装