一个程序的小问题求助

浏览:489 发布日期:2014/05/20 分类:求助交流
有一个操作数据库的问题请教     //抽奖页
    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();
    }
最佳答案
评论( 相关
后面还有条评论,点击查看>>