9169-php/Application/Bibidd/Controller/QQGroupController.class.php

<?php

namespace bibidd\Controller;
use Bibidd\Controller\CommonBaseController;

class QQGroupController extends CommonBaseController
{
    /**
     *  查询QQ列表
     * @return void
     */
    public function search_qq_grop_list()
    {
        $this->checkUserIsExist($_POST['uid']); //检查用户
        $this->addHeaders(); //添加头部请求

        $page = $_POST['page'];
        $one_size = 30; //每頁30行記錄
        $page_one = ($page - 1) * $one_size;
        $uid=$_POST['uid'];

        $sub_sql = M("qq_group_unlock")->where("uid = '$uid' AND qq_group_num = qq_num")->field("id")->buildSql();
        $data_list = M("qq_group")
                    ->field("id,g_name,`status`,qq_free,CASE WHEN qq_free>0 && $sub_sql  is null THEN '*****' ELSE qq_num END AS qq_num")
                    ->LIMIT($page_one, $one_size)
                    ->where("status=0")
                     ->select();

        $data['code'] = '200';
        $data['message'] = 'ok';
        $data['all_num'] = M("qq_group")->where("status=0")->count();
        $data['data'] = $data_list;
        echo json_encode($data);
    }

    /**
     * 解锁QQ群组
     * @return void
     */
    public function un_lock()
    {
        $user_info=  $this->checkUserIsExist($_POST['uid']); //检查用户
        $this->addHeaders(); //添加头部请求

        $uid=$_POST['uid'];
        $id=$_POST['id'];

        $group_info = M("qq_group")->where("id='$id'")->find();
        if(empty($group_info))
        {
            $this->returnDataAndSendMsg("错误群组ID");
            die();
        }
        $qq_num = $group_info['qq_num'];
        $check_info = M("qq_group_unlock")->where("uid=$uid AND qq_group_num='$qq_num'")->find();
        if(!empty($check_info))
        {
            $this->returnDataAndSendMsg("重复解锁");
            die();
        }

        $take_cion = $group_info['qq_free'];
        //判断用户余额是否够
        if($user_info['gold_coins_number']<$take_cion)
        {
            $this->returnDataAndSendMsg("余额不足，请及时充值.");
            die();
        }

        $dec_rs = M("user_info")->where("id='$uid'")->setDec("gold_coins_number",$take_cion);
        if($dec_rs==0)
        {
            $this->returnDataAndSendMsg("余额扣减失败，请稍后重试.");
            die();
        }

        $un_lock_info['uid'] = $uid;
        $un_lock_info['qq_group_num'] = $group_info['qq_num'];
        $un_lock_info['un_lock_at'] = date('Y-m-d H:i:s');
        $un_lock_info['cion_num'] = $take_cion;

        $rs = M("qq_group_unlock")->add($un_lock_info);

        $data['code'] = '200';
        $data['message'] = 'ok';
        $data['data'] = $rs;
        echo json_encode($data);

        //统计消费
        $this->xiaofei_detail($uid,"解锁QQ群组",$qq_num,$take_cion);
    }
}