//抽奖页
public function lottery(){
$id = $this->_get('id', 'intval');
$type = $this->_get('type', 'intval');
$wall = $this->getWall($id);
if($type == 1){
$list = M('wxwall_message')->where("wxq_id={$wall['id']} AND isshowed=1 AND from_user <> ''")->order("createtime ASC")->select();
}else{
$list = M('wxwall_message')->where("wxq_id={$wall['id']} AND isshowed=1 AND from_user <> ''")->order("createtime ASC")->group("from_user")->select();
}
// exit(dump($list));
$list = json_encode($this->formatMsg($list));
$this->formatMsg($list);
$this->assign('wall', $wall);
$this->assign('list', $list);
$this->display();
}
public function award(){
$message = M('wxwall_message')->where("id={$_GET['mid']}")->find();
if(empty($message)){
$this->ajaxReturn(0, "参数不正确", 0);
}
$data = array(
'wxq_id' => $message['wxq_id'],
'from_user' => $message['from_user'],
'createtime' => time(),
'status' => 0,
);
$rs = M('wxwall_award')->add($data);
if($rs){
$this->ajaxReturn($rs, "成功", 1);
}else{
$this->ajaxReturn(0, "失败", 0);
}
}
//中奖名单
public function awardList(){
if(!empty($_GET['wid'])){
$wid = $this->_get('wid', 'intval');
if($_GET['type'] == 'del'){
$rss = M('wxwall_award')->where(array('id' => $wid))->delete();
}else{
$rss = M('wxwall_award')->where(array('id' => $wid))->save(array('status' => $_GET['status']));
}
if($rss){
exit($this->success('操作成功'));
}else{
exit($this->success('操作失败'));
}
}
$wxq_id = $this->_get('id', 'intval');
$where['wxq_id'] = $wxq_id;
$db = M('wxwall_award');
$count = $db->where($where)->count();
$page = new Page($count, 5);
$info = $db->where($where)->limit($page->firstRow . ',' . $page->listRows)->order("createtime ASC")->select();
$info = $this->formatMsg($info);
$wall = $this->getWall($wxq_id);
$this->assign('wall', $wall);
$this->assign('page', $page->show());
$this->assign('list', $info);
$this->display();
} 最佳答案