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

<?php

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

class ChiguaPinglunController extends CommonBaseController
{

    /**
     *  查询评论列表
     * @return void
     */
    public function query_list()
    {
        $this->addHeaders(); //添加头部请求
        $this->checkUserIsExist($_POST['uid']); //检查用户

        //视频id
        $vid= $_POST['vid'];
        $page = $_POST['page'];
        $one_size = $_POST['pageSize']; //每頁30行記錄
        $page_one = ($page - 1) * $one_size;

        if(empty($one_size) || empty($vid))
        {
            $this->returnDataAndSendMsg("请传入视频ID和页大小");
            die();
        }

        $data_list = M("chigua_pinglun")->field("user_id,user_name,user_grade,v_id,comment_content,status_,date_format(creater_at,'%Y-%m-%d %H:%i') AS creater_at")->where("v_id = '$vid' AND status_=0")->order("user_grade DESC")->LIMIT($page_one, $one_size)->select();
        $data['code'] = '200';
        $data['message'] = 'ok';
        $data['all_num'] =M("chigua_pinglun")->where("v_id = '$vid' AND status_=0")->count();
        $data['data'] = $data_list;
        echo json_encode($data);
    }

    /**
     * 评论
     * @return void
     */
    public function comment()
    {
        $this->addHeaders(); //添加头部请求
        $this->checkUserIsExist($_POST['uid']); //检查用户

        $uid= $_POST['uid'];
        $vid= $_POST['vid'];
        $comment_content =  $_POST['content'];

        //条件检查
        if(empty($vid))
        {
            $this->returnDataAndSendMsg("被评论的视频标识不能空.");
            die();
        }
        if(empty($comment_content) || mb_strlen($comment_content)>50)
        {
            $this->returnDataAndSendMsg("请控制评论内容长度在50个字符以内.");
            die();
        }

        //判断是否在禁言范围
       $jin_info =  M("chigua_jinyan")->where("user_id = '$uid'  AND TO_DAYS(creater_at)>=TO_DAYS(NOW()) - days_")->find();
        if(!empty($jin_info))
        {
            if($jin_info['days_']>=99999)
            {
                $this->returnDataAndSendMsg("由于您评论内容违规已被永久禁言.");
                die();
            }
            $this->returnDataAndSendMsg("由于您评论内容违规已被禁言".$jin_info['days_']."天.");
            die();
        }

        $userInfo = M("user_info")->where("id='$uid'")->find();
        $ping_lun_info['user_id']=$uid;
        $ping_lun_info['user_name']=$userInfo['name'];
        $ping_lun_info['v_id']=$vid;
        $ping_lun_info['creater_at']=date('Y-m-d H:i:s');
        $ping_lun_info['comment_content']=$comment_content;
        //用户等级
        $user_all_pay_money = M("pay_test")->field("SUM(amount) as all_amount")->where("uid='$uid' and order_type='已支付'")->find();

        if(empty($user_all_pay_money['all_amount']) || $user_all_pay_money['all_amount']<50)
        {
            //没有充值过
            $ping_lun_info['user_grade']='1';
        }

        if($user_all_pay_money['all_amount']>=50 && $user_all_pay_money['all_amount']<100)
        {
            //没有充值过
            $ping_lun_info['user_grade']='2';
        }

        if($user_all_pay_money['all_amount']>=100 && $user_all_pay_money['all_amount']<200)
        {
            //没有充值过
            $ping_lun_info['user_grade']='3';
        }

        if($user_all_pay_money['all_amount']>=200 && $user_all_pay_money['all_amount']<300)
        {
            //没有充值过
            $ping_lun_info['user_grade']='4';
        }

        if($user_all_pay_money['all_amount']>=300 && $user_all_pay_money['all_amount']<400)
        {
            //没有充值过
            $ping_lun_info['user_grade']='5';
        }

        if($user_all_pay_money['all_amount']>=400 && $user_all_pay_money['all_amount']<500)
        {
            //没有充值过
            $ping_lun_info['user_grade']='6';
        }

        if($user_all_pay_money['all_amount']>=500 && $user_all_pay_money['all_amount']<600)
        {
            //没有充值过
            $ping_lun_info['user_grade']='7';
        }

        if($user_all_pay_money['all_amount']>=600 && $user_all_pay_money['all_amount']<700)
        {
            //没有充值过
            $ping_lun_info['user_grade']='8';
        }

        if($user_all_pay_money['all_amount']>=700 && $user_all_pay_money['all_amount']<800)
        {
            //没有充值过
            $ping_lun_info['user_grade']='9';
        }

        if($user_all_pay_money['all_amount']>=800)
        {
            //没有充值过
            $ping_lun_info['user_grade']='10';
        }

        $rs = M("chigua_pinglun")->add($ping_lun_info);
        //更新视频表数量
        M("upload_videos_list")->where("id='$vid'")->setInc("comment_num",1);

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

    }

}