danci/www.hanlinyuanonline.com/Application/Api/Controller/CourseController.class.php

<?php
namespace Api\Controller;
use Common\Controller\ApiController;
class CourseController extends ApiController {
    public function __construct(){
        parent::__construct();
    }
    
    //获取课程列表
    public function index(){
        $sort = I('sort',1);
        $lastId = I('last_id',0);
		$user_id = I('user_id',0);
        //$pageSize = I('page_size',1000);
		$pageSize=1000;
        $keyword = I('keyword','');
        $condition = array('course_status'=>3,'course_flag'=>1,'course_source'=>1,'is_delete'=>1);
        if (!empty($keyword)){
            $condition['course_name'] = array('LIKE','%'.$keyword.'%');
        }
        if ($lastId>0){
            $condition['course_id'] = array('LT',$lastId);
        }
		if (!empty($user_id)){
            $condition['user_id'] = $user_id;
        }
        //$count = M('Course')->where($condition)->count();
        $orderby = '';
        if ($sort==1){
            $orderby = 'course_join desc';
        }else if($sort==2){
            $orderby = 'operate_dt desc';
        }
        $res = D('Course')->getCourseList($condition, $pageSize, $orderby, $this->userId);
        if ($res!=NULL){
            $userWordsRes = $this->square();
            foreach ($res as $key=>$row){
				$Count = M('course_reply')->where(array('course_id'=>$row['course_id']))->count();
				$res[$key]['reply'] = $Count==NULL?0:$Count;
				$Count = M('course_praise')->where(array('course_id'=>$row['course_id']))->count();
				$res[$key]['praise'] = $Count==NULL?0:$Count;
                if (in_array($row['course_id'], $userWordsRes) || $row['user_id']==$this->userId){
                    $res[$key]['is_add'] = 1;
                }else{
                    $res[$key]['is_add'] = 0;
                }
            }
        }
        if ($lastId>0){
            $data = array('code'=>0,'msg'=>'无更多数据','data'=>array());
            $this->returnData($data);exit;
        }
        $data = array('code'=>0,'msg'=>'','data'=>$res);
        $this->returnData($data);exit;
    }
    
    
    //获取已经添加的课程或者自由记
    private function square($uwType=0){
        $condition = array('user_id'=>$this->userId,'is_show'=>1);
        if (!empty($uwType)){
            $condition['uw_type'] = $uwType;
        }
        $res = M('UserWords')->where($condition)->field('course_id')->select();
        if ($res==NULL){
            return array();
        }
        $arr = array();
        foreach ($res as $r){
            $arr[] = $r['course_id'];
        }
        return $arr;
    }
    
    //添加课程到我的课程
    public function favorite(){
        $courseId = I('course_id');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
        $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1,'course_status'=>3))->field('course_num,course_id,user_id')->find();
        if ($courseInfo==NULL){
            $data = array('code'=>1,'msg'=>'等审核通过了才可以添加');
            $this->returnData($data);exit;
        }
        if ($courseInfo['user_id']==$this->userId){
            $data = array('code'=>1,'msg'=>'自己添加的课程无需添加');
            $this->returnData($data);exit;
        }
        //判断用户是否已经添加过该课程
        $userInfo = M('UserWords')->where(array('course_id'=>$courseId,'is_delete'=>1,'user_id'=>$this->userId,'is_show'=>1))->field('uw_id')->find();
        if ($userInfo!=NULL){
            $data = array('code'=>1,'msg'=>'已经添加过该课程，请勿重复添加');
            $this->returnData($data);exit;
        }
        $partNum = ceil($courseInfo['course_num']/$userInfo['user_part']);
        if (empty($userInfo['user_part'])){
            $userInfo['user_part'] = 15;
        }
        if (empty($userInfo['user_part'])){
            $userInfo['user_part'] = 15;
        }
        M('UserWords')->add(array('course_id'=>$courseId,'user_id'=>$this->userId,'user_part'=>$userInfo['user_part'],'part_num'=>$partNum,'operate_dt'=>time()));
        M('Course')->where(array('course_id'=>$courseId))->setInc('course_join');
        $data = array('code'=>0,'msg'=>'已添加至我的课程中','data'=>'');
        $this->returnData($data);exit;
    }
    
    //添加最近学习课程
    public function studyCourseAdd(){
        $courseId = I('course_id');
        if (empty($courseId)){
            $data = array('code'=>1,'msg'=>'收藏ID错误');
            $this->returnData($data);exit;
        }
        $courseIdArr = explode(',', $courseId);
        if (count($courseIdArr)<=0){
            $data = array('code'=>1,'msg'=>'收藏ID错误');
            $this->returnData($data);exit;
        }
        $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
        foreach ($courseIdArr as $cid){
            $info = M('UserWords')->where(array('user_id'=>$this->userId,'course_id'=>$cid,'uw_type'=>2,'is_show'=>1))->field('uw_id')->find();
            if ($info==NULL){
                $courseInfo = M('Course')->where(array('course_id'=>$cid))->field('course_num')->find();
                $partNum = ceil($courseInfo['course_num']/$userInfo['user_part']);
                if (empty($userInfo['user_part'])){
                    $userInfo['user_part'] = 15;
                }
                if (empty($userInfo['user_part'])){
                    $userInfo['user_part'] = 15;
                }
                M('UserWords')->add(array('user_id'=>$this->userId,'course_id'=>$cid,'user_part'=>$userInfo['user_part'],'part_num'=>$partNum,'uw_type'=>2,'operate_dt'=>time()));
                M('Course')->where(array('course_id'=>$cid))->setInc('course_join');
            }else{
                M('UserWords')->where(array('uw_id'=>$info['uw_id']))->save(array('uw_type'=>2));
            }
        }
        $data = array('code'=>0,'msg'=>'添加成功','data'=>'');
        $this->returnData($data);exit;
    }
    
    //删除我的课程
    public function del(){
        $courseId = I('course_id');
        $courseId = rtrim($courseId,',');
        if (empty($courseId)){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $info = M('UserWords')->where(array('course_id'=>array('IN',$courseId),'user_id'=>$this->userId))->field('user_id,course_id,uw_type')->find();
        if ($info['uw_type']==2){
            M('UserWords')->where(array('course_id'=>array('IN',$courseId),'user_id'=>$this->userId))->save(array('uw_type'=>1));
        }else if($info['uw_type']==1){
            M('UserWords')->where(array('course_id'=>array('IN',$courseId),'user_id'=>$this->userId))->delete();
        }
        $courseInfo = M('Course')->where(array('course_id'=>array('IN',$courseId)))->field('course_id,course_status,user_id')->select();
        foreach ($courseInfo as $row){
            if ($row['user_id'] != $this->userId){
                $data = array('code'=>0,'msg'=>'课程删除成功');
                $this->returnData($data);exit;
            }
            if ($row['course_status']==3){
                $data = array('code'=>1,'msg'=>'课程已审核到单词广场，无法删除');
                $this->returnData($data);exit;
            }
        }
        M('Words')->where(array('course_id'=>array('IN', $courseId)))->delete();
        M('Course')->where(array('course_id'=>array('IN',$courseId)))->delete();
        $data = array('code'=>0,'msg'=>'课程删除成功');
        $this->returnData($data);exit;
    }
    
    //清空收藏课程或者自由记信息表
    public function delCourse(){
        //$courseId = I('course_id');
        $currentCourse = I('current_course','2');
        M('UserWords')->where(array('current_course'=>$currentCourse,'user_id'=>$this->userId))->delete();
        $data = array('code'=>0,'msg'=>'删除成功');
        $this->returnData($data);exit;
    }
    
    //删除最近学习的课程
    public function studyCourseDel(){
        $courseId = I('course_id');
        $type = I('type',1);
        if (empty($courseId) || $courseId<=1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $info = M('UserWords')->where(array('course_id'=>array('IN',$courseId),'user_id'=>$this->userId))->field('user_id,course_id')->find();
        if ($info==NULL || $info['user_id']!=$this->userId){
            $data = array('code'=>1,'msg'=>'删除失败');
            $this->returnData($data);exit;
        }
        if ($type==1){
            M('UserWords')->where(array('course_id'=>array('IN',$courseId),'user_id'=>$this->userId))->save(array('uw_type'=>1));
        }else if($type==2){
            M('UserWords')->where(array('course_id'=>array('IN',$courseId),'user_id'=>$this->userId))->delete();
            /* $couseInfo = M('Course')->where(array('course_id'=>$info['course_id']))->field('user_id,course_status')->find();
            if ($couseInfo!=NULL && $couseInfo['course_status']!=3 && $couseInfo['user_id']==$this->userId){
                M('Course')->where(array('course_id'=>$info['course_id']))->delete();
                M('Words')->where(array('course_id'=>$info['course_id']))->delete();
            } */
        }
        $data = array('code'=>0,'msg'=>'删除成功','data'=>'');
        $this->returnData($data);exit;
    }
    
    //修改课程名称
    public function edit(){
        $courseId = I('course_id');
        $courseName = I('course_name');
		$course_intro = I('course_intro');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        if (mb_strlen($courseName,'UTF8')<2 || mb_strlen($courseName,'UTF8')>12){
            $data = array('code'=>1,'msg'=>'课程名称2到12个汉字');
            $this->returnData($data);exit;
        }
        $info = M('Course')->where(array('course_id'=>$courseId))->field('user_id,course_status')->find();
        if ($info==NULL || $info['user_id']!=$this->userId ){
            $data = array('code'=>1,'msg'=>'课程名称不能修改');
            $this->returnData($data);exit;
        }
        M('Course')->where(array('course_id'=>$courseId))->save(array('course_name'=>$courseName,'course_intro'=>$course_intro));
        $data = array('code'=>0,'msg'=>'课程修改成功','data'=>'');
        $this->returnData($data);exit;
    }
    //新增课程
    public function add(){
        $courseName = I('course_name');
		$course_intro = I('course_intro');
        if ($courseName=='易错单词'){
            $data = array('code'=>1,'msg'=>'该课程名称不能创建');
            $this->returnData($data);exit;
        }
        if (mb_strlen($courseName,'UTF8')<2 || mb_strlen($courseName,'UTF8')>12){
            $data = array('code'=>1,'msg'=>'课程名称2到12个汉字');
            $this->returnData($data);exit;
        }
        $res = M('Course')->where(array('course_name'=>$courseName,'is_delete'=>1))->field('course_id')->find();
        if ($res!=NULL){
            $courseName = $this->getCourseName($courseName);
        }
        $courseId = M('Course')->add(array('course_type'=>0,'course_name'=>$courseName,'course_intro'=>$course_intro,'course_source'=>2,'user_id'=>$this->userId,'operate_dt'=>time()));
        $info = M('Course')->where(array('course_id'=>$courseId))->field('course_id,user_id,course_name,course_intro,course_join,course_content,course_source,operate_dt')->find();
        $data = array('code'=>0,'msg'=>'课程添加成功','data'=>$info);
        $this->returnData($data);exit;
    }
    
    //合并课程
    public function merge(){
        $courseId = rtrim(I('course_id'),',');
        $courseName = I('course_name');
        $courseIdArr = explode(',', $courseId);
        if (mb_strlen($courseName,'UTF8')<2 || mb_strlen($courseName,'UTF8')>12){
            $data = array('code'=>1,'msg'=>'课程名称2到12个汉字');
            $this->returnData($data);exit;
        }
        $res = M('Course')->where(array('course_name'=>$courseName,'is_delete'=>1))->field('course_id')->find();
        if ($res!=NULL){
            $courseName = $this->getCourseName($courseName);
        }
        $courseNum = M('Words')->where(array('course_id'=>array('IN',$courseId)))->count(); 
        $courseNewId = M('Course')->add(array('course_type'=>0,'user_id'=>$this->userId,'course_source'=>2,'course_num'=>$courseNum,'course_name'=>$courseName,'operate_dt'=>time()));
        foreach ($courseIdArr as $cid){
            $info = M('Course')->where(array('course_id'=>$cid,'is_delete'=>1))->field('course_id,user_id,course_status')->find();
            if ($info['user_id']!=$this->userId || $info['course_status']==3){
                //复制一份课程下面的单词
                $this->copyWords($cid,$courseNewId);
            }
            if ($info['user_id']==$this->userId && $info['course_status']==3){
                //同样复制一份课程下面的单词
                $this->copyWords($cid,$courseNewId);
            }
            if ($info['user_id']==$this->userId && $info['course_status']!=3){
                //自己未上到单词广场的课程，直接删除。同时把删除的课程单词，同步到新的课程
                M('Course')->where(array('course_id'=>$cid))->delete();
                M('UserWords')->where(array('course_id'=>$cid,'user_id'=>$this->userId))->delete();
                M('Words')->where(array('course_id'=>$cid))->save(array('course_id'=>$courseNewId));
            }
        }
        $courseInfo = M('Course')->where(array('course_id'=>$courseNewId))
                                                    ->field('course_id,user_id,course_name,course_join,course_content,course_source,operate_dt')->find();
        $data = array('code'=>0,'msg'=>'课程合并成功','data'=>$courseInfo);
        $this->returnData($data);exit;
    }
    
    //设置单章节的单词数量
    public function part(){
        $uwId = I('uw_id');
        //1:乱序,0:取消乱序
        $type = I('type',0);
        $userPart = I('user_part',15);
        $courseId = I('course_id');
        $partNum = I('part_num');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        if ($userPart<=0 || $partNum<=0){
            $data = array('code'=>1,'msg'=>'章节数错误');
            $this->returnData($data);exit;
        }
        if (!in_array($type, array(0,1))){
            $data = array('code'=>0,'msg'=>'类型错误');
            $this->returnData($data);exit;
        }
        $courseInfo = M('Course')->where(array('course_id'=>$courseId))->field('course_num')->find();
        $partNum1 = ceil($courseInfo['course_num']/$userPart);
        if ($partNum1!=$partNum){
            $data = array('code'=>1,'msg'=>'章节数错误');
            $this->returnData($data);exit;
        }
        if (empty($userPart)){
            $userPart = 15;
        }
        M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->save(array('user_part'=>$userPart,'part_num'=>$partNum1));

        M('User')->where(array('user_id'=>$this->userId))->save(array('user_part'=>$userPart));
        
        //设置乱序
        $info = M('WordsSort')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->find();
        if ($type==1){
            if ($info['sort_status']==2){
                M('WordsSort')->where(array('sort_id'=>$info['sort_id']))->save(array('sort_status'=>1));
            }
            if ($info==NULL){
                $wordsInfo = M('Words')->where(array('course_id'=>$courseId))->order('RAND()')->field('words_id')->select();
                if (function_exists('array_column')){
                    $wordsIdArr = array_column($wordsInfo, 'words_id');
                }else{
                    foreach ($wordsInfo as $row){
                        $wordsIdArr[] = $row['words_id'];
                    }
                }
                $saveData = array(
                    'user_id'=>$this->userId,
                    'course_id'=>$courseId,
                    'word_ids'=>implode(',', $wordsIdArr),
                    'operate_dt'=>time(),
                );
                M('WordsSort')->add($saveData);
            }
        }else if($type==0){
            if ($info!=NULL){
                M('WordsSort')->where(array('sort_id'=>$info['sort_id']))->save(array('sort_status'=>2));
            }
        }
        
        
        
        $data = array('code'=>0,'msg'=>'章节设置成功','data'=>'');
        $this->returnData($data);exit;
    }
    
    //获取课程的章节数
    public function getPart(){
        $courseId = I('course_id');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $partInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('user_part,part_num')->find();
        if ($partInfo==NULL){
            $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_num')->find();
            $partInfo['user_part'] = 15;
            $partInfo['part_num'] = ceil($courseInfo['course_num']/$partInfo['user_part']);
        }
        $res = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_join,course_num,operate_dt')->find();
        $res['part_num'] = $partInfo['part_num'];
        $res['user_part'] = empty($partInfo['user_part'])?'0':$partInfo['user_part'];
        $info = M('WordsSort')->where(array('course_id'=>$res['course_id'],'user_id'=>$this->userId,'sort_status'=>1))->field('sort_id')->find();
        if ($info!=NULL){
            $res['set_sort'] = 1;
        }else{
            $res['set_sort'] = 0;
        }
        $data = array('code'=>0,'msg'=>'','data'=>$res);
        $this->returnData($data);exit;
    }
    
    //获取特殊课程的章节
    public function getSpecialPart(){
        $courseId = I('course_id');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $res = M('Words')->where(array('course_id'=>$courseId))->group('operate_dt')->field('operate_dt')->order('operate_dt asc')->select();
        if ($res==NULL){
            $part = array();
        }else{
            foreach ($res as $r){
                $year = date('Y',$r['operate_dt']);
                $part[$year]['year'] = $year;
                $part[$year]['dates'][] =  $r['operate_dt'];
            }
        }
        $data = array('code'=>0,'msg'=>'','data'=>array_values($part));
        $this->returnData($data);exit;
    }
    
    //删除章节
    public function delPart(){
        $courseId = I('course_id');
        M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->save(array('user_part'=>15,'part_num'=>0,'current_part'=>1));
        $data = array('code'=>0,'msg'=>'删除章节成功','data'=>'');
        $this->returnData($data);exit;
    }
    
    //上传到单词广场
    public function upSquare(){
        $courseId = I('course_id','');
        if (empty($courseId)){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $courseId = rtrim($courseId,',');
        M('Course')->where(array('course_id'=>array('IN',$courseId),'user_id'=>$this->userId))->save(array('course_status'=>2));
        $data = array('code'=>0,'msg'=>'上传成功，请等待管理员审核！','data'=>'');
        $this->returnData($data);exit;
    }
    
    //获取课程信息
    public function info(){
        $courseId = I('course_id');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $info = M('Course')->where(array('course_id'=>$courseId))->field('course_id,user_id,course_name,course_intro,course_join,course_content,course_flag,course_source,operate_dt')->find();
        $res = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id')->find();
        if ($res==NULL && $info['user_id']!=$this->userId){
            $info['is_add'] = 0;
            $info['is_course'] = 0;
        }else{
            $info['is_add'] = 1;
            $info['is_course'] = 1;
        }
        if ($info['user_id']!=$this->userId){
            $fansInfo = M('Fans')->where(array('user_id'=>$this->userId,'fans_user_id'=>$info['user_id']))->field('fans_id')->find();
            $info['is_fans'] = $fansInfo==NULL?0:1;
        }else{
            $info['is_fans'] = 2;
        }
		
		
        $userInfo = M('User')->where(array('user_id'=>$info['user_id']))->field('user_id,user_name,user_icon')->find();
        $info['user_icon'] = $userInfo['user_icon'];
        $info['user_name'] = $userInfo['user_name'];
		$replyCount = M('course_reply')->where(array('course_id'=>$courseId))->count();
		$info['reply'] = $replyCount==NULL?0:$replyCount;
		$Count = M('course_praise')->where(array('course_id'=>$courseId))->count();
		$info['praise'] = $Count==NULL?0:$Count;
		$Count = M('course_praise')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->count();
		$info['is_praise'] = $Count?1:0;
        $data = array('code'=>0,'msg'=>'','data'=>$info);
        $this->returnData($data);exit;
    }
    
    //记录学习模式，学习到的最后一个单词
    public function studyWords(){
        //$partId = I('part_id');
        $wordsId = I('words_id');
        $courseId = I('course_id');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        if (empty($wordsId)){
            $data = array('code'=>1,'msg'=>'单词ID错误');
            $this->returnData($data);exit;
        }
        /* if (empty($partId)){
            $data = array('code'=>1,'msg'=>'章节ID错误');
            $this->returnData($data);exit;
        } */
        $info = M('StudyWords')->where(array('user_id'=>$this->userId))->field('study_id')->find();
        if ($info == NULL){
            M('StudyWords')->add(array('words_id'=>$wordsId,'course_id'=>$courseId,'part_id'=>0,'user_id'=>$this->userId,'operate_dt'=>time(),));
        }else{
            M('StudyWords')->where(array('study_id'=>$info['study_id']))->save(array('words_id'=>$wordsId,'course_id'=>$courseId,'part_id'=>0,));
        }
        $data = array('code'=>0,'msg'=>'','data'=>'记录成功');
        $this->returnData($data);exit;
    }
	//评论列表
	public function reply_list(){
		$courseId = I('course_id');
		if (empty($courseId)){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
		$lastId = I('last_id','');
		if(!$lastId){
			$lastId=10000000;
		}
		$pageSize = I('page_size',20);
   
        $res = M('course_reply')->join('left join t_user as a on a.user_id = t_course_reply.user_id')->join('left join t_user as b on b.user_id = t_course_reply.reply_user_id')->join('left join t_course_reply_praise on t_course_reply_praise.cr_id = t_course_reply.cr_id')->where(array('t_course_reply.is_delete'=>1,'t_course_reply.reply_cr_id'=>0,'t_course_reply.course_id'=>$courseId,'t_course_reply.cr_id'=>array('LT',$lastId)))->group('t_course_reply.cr_id')->field('t_course_reply.*,a.user_name,a.user_icon,a.forbidden,b.forbidden as reply_forbidden,b.user_name as reply_user_name,count(t_course_reply_praise.cr_id) as praise')->order('t_course_reply.operate_dt desc')->limit('0,'.$pageSize)->select();
		$arr=array();
		foreach($res as $k=>$v){
			if(!$v['cr_id']){
				unset($res[$k]);
			}else{
				$arr[]=$v['cr_id'];
				$res[$k]['reply_list']=array();
			}
			if($v['forbidden']>time()){
				$res[$k]['is_forbidden']=1;
			}else{
				$res[$k]['is_forbidden']=0;
			}
			
			
		}
		if($arr){
			$res2 = M('course_reply')->join('left join t_user as a on a.user_id = t_course_reply.user_id')->join('left join t_user as b on b.user_id = t_course_reply.reply_user_id')->join('left join t_course_reply_praise on t_course_reply_praise.cr_id = t_course_reply.cr_id')->where("t_course_reply.course_id='$courseId' and t_course_reply.is_delete=1 and t_course_reply.reply_cr_id in ( ".implode(',',$arr).")" )->group('t_course_reply.cr_id')->field('t_course_reply.*,a.user_name,a.user_icon,b.user_name as reply_user_name,count(t_course_reply_praise.cr_id) as praise')->order('t_course_reply.operate_dt desc')->select();;
		}else{
			$res2=array();
		}
		$praiseInfo = M('course_reply_praise')->where(array('is_delete'=>1,'user_id'=>$this->userId))->field('cr_id')->select();
		
        $praise_arr=array();
		
		foreach($praiseInfo as $k=>$v){
			$praise_arr[]=$v['cr_id'];
		}
		
		foreach($res as $k=>$v){
			foreach($res2 as $m=>$n){
				if($n['forbidden']>time()){
					$res2[$m]['is_forbidden']=1;
				}else{
					$res2[$m]['is_forbidden']=0;
				}
				if(in_array($n['cr_id'],$praise_arr)){
					$res2[$m]['is_praise']=1;
				}else{
					$res2[$m]['is_praise']=0;
				}
				if($n['reply_cr_id']==$v['cr_id']){
					array_unshift($res[$k]['reply_list'],$res2[$m]);
				}
			}
			if(in_array($v['cr_id'],$praise_arr)){
				$res[$k]['is_praise']=1;
			}else{
				$res[$k]['is_praise']=0;
			}
		}
		$data = array('code'=>0,'msg'=>'','data'=>$res);
        $this->returnData($data);exit;
    }
	//评论点赞
    public function reply_praise(){
        $cr_id = I('cr_id');
        if (empty($cr_id)){
            $data = array('code'=>1,'msg'=>'评论ID错误');
            $this->returnData($data);exit;
        }
		$replyInfo = M('course_reply')->where(array('cr_id'=>$cr_id,'is_delete'=>1))->field('cr_id,course_id')->find();
        if (!$replyInfo){
            $data = array('code'=>1,'msg'=>'该评论不存在');
            $this->returnData($data);exit;
        }
		$course_reply_praise = M('course_reply_praise')->where(array('cr_id'=>$cr_id,'is_delete'=>1,'user_id'=>$this->userId))->field('cr_id')->find();
        if ($course_reply_praise!=NULL){
            $data = array('code'=>1,'msg'=>'已经点赞过该评论');
            $this->returnData($data);exit;
        }
	$courseId=$replyInfo['course_id'];
		$userInfo = M('user')->where(array('user_id'=>$this->userId))->field('*')->find();
		$noticeContent = $userInfo['user_name'].'点赞了您的评论！';
		$res = M('course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('user_id,course_type')->find();
		$uid=$res['user_id'];
		if($uid){
			$reply_content=$replyInfo['reply_content'];
			$temp=array('course_id'=>$courseId,'reply_content'=>$reply_content,'course_type'=>$res['course_type']);
			M('Notice')->add(array('ref_user_id'=>$uid,'user_id'=>$this->userId,'notice_flag'=>0,'notice_status'=>1,'notice_type'=>4,'notice_title'=>'点赞消息','notice_content'=>$noticeContent,'operate_dt'=>time(),'extra'=>json_encode($temp)));
			M('User')->where(array('user_id'=>$uid))->setInc('praise_notice');
			$data = json_encode(array('type'=>4,'msg'=>$noticeContent,'data'=>array('title'=>$noticeContent,'course_id'=>$courseId,'course_content'=>$reply_content)));
			$this->umengPush($uid, $data);
		}
		M('course_reply_praise')->add(array('cr_id'=>$cr_id,'user_id'=>$this->userId,'operate_dt'=>time()));
        $data = array('code'=>0,'msg'=>'评论点赞成功');
        $this->returnData($data);exit;
    }
	//取消评论点赞
    public function reply_praise_cancel(){
        $cr_id = I('cr_id');
		$cr_id = rtrim($cr_id,',');
        if (empty($cr_id)){
            $data = array('code'=>1,'msg'=>'ID错误');
            $this->returnData($data);exit;
        }
		M('course_reply_praise')->where(array('cr_id'=>array('IN',$cr_id),'user_id'=>$this->userId))->delete();
        $data = array('code'=>0,'msg'=>'取消点赞成功');
        $this->returnData($data);exit;
    }
    //编辑社区评论
    public function reply_edit(){
		$courseId = I('course_id','');
		$reply_user_id = I('reply_user_id','0');
		$reply_cr_id = I('reply_cr_id','0');
		$reply_content = I('reply_content','');
		
		$userInfo = M('user')->where(array('user_id'=>$this->userId))->field('*')->find();
		if($userInfo['forbidden']>time()){
			$data = array('code'=>1,'msg'=>'用户被禁言','data'=>array());
            $this->returnData($data);exit;
		}
		if(!$reply_content){
			$data = array('code'=>1,'msg'=>'评论内容必须','data'=>array());
            $this->returnData($data);exit;
		}
		if ( mb_strlen($reply_content,'UTF8')>140){
			$data = array('code'=>1,'msg'=>'评论内容限制140个汉字','data'=>array());
            $this->returnData($data);exit;
		}
		M('course_reply')->add(array('course_id'=>$courseId,'user_id'=>$this->userId,'reply_user_id'=>$reply_user_id,'reply_cr_id'=>$reply_cr_id,'reply_content'=>$reply_content,'operate_dt'=>time()));
		$noticeContent = $userInfo['user_name'].'评论了您的课程！';
		$res = M('course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('user_id,course_type')->find();
		$uid=$res['user_id'];
		if($uid){
			$temp=array('course_id'=>$courseId,'reply_content'=>$reply_content,'course_type'=>$res['course_type']);
			M('Notice')->add(array('ref_user_id'=>$uid,'user_id'=>$this->userId,'notice_flag'=>0,'notice_status'=>1,'notice_type'=>3,'notice_title'=>'评论消息','notice_content'=>$noticeContent,'operate_dt'=>time(),'extra'=>json_encode($temp)));
			M('User')->where(array('user_id'=>$uid))->setInc('reply_notice');
			$data = json_encode(array('type'=>3,'msg'=>$noticeContent,'data'=>array('title'=>$noticeContent,'course_id'=>$courseId,'course_content'=>$reply_content)));
			$this->umengPush($uid, $data);
		}
		
		$data = array('code'=>0,'msg'=>'评论发布成功');
        $this->returnData($data);exit;
	}
	//点赞
    public function praise(){
        $courseId = I('course_id');
        if (empty($courseId)){
            $data = array('code'=>1,'msg'=>'ID错误');
            $this->returnData($data);exit;
        }
		$praiseInfo = M('course_praise')->where(array('course_id'=>$courseId,'is_delete'=>1,'user_id'=>$this->userId))->field('cp_id')->find();
        if ($praiseInfo!=NULL){
            $data = array('code'=>1,'msg'=>'已经点赞过该课程');
            $this->returnData($data);exit;
        }
	$userInfo = M('user')->where(array('user_id'=>$this->userId))->field('*')->find();
		$noticeContent = $userInfo['user_name'].'点赞了您的课程！';
		$res = M('course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('user_id,course_type')->find();
		$uid=$res['user_id'];
		if($uid){
			$reply_content='';
			$temp=array('course_id'=>$courseId,'reply_content'=>$reply_content,'course_type'=>$res['course_type']);
			M('Notice')->add(array('ref_user_id'=>$uid,'user_id'=>$this->userId,'notice_flag'=>0,'notice_status'=>1,'notice_type'=>4,'notice_title'=>'点赞消息','notice_content'=>$noticeContent,'operate_dt'=>time(),'extra'=>json_encode($temp)));
			M('User')->where(array('user_id'=>$uid))->setInc('praise_notice');
			$data = json_encode(array('type'=>4,'msg'=>$noticeContent,'data'=>array('title'=>$noticeContent,'course_id'=>$courseId,'course_content'=>$reply_content)));
			$this->umengPush($uid, $data);
		}
		M('course_praise')->add(array('course_id'=>$courseId,'user_id'=>$this->userId,'operate_dt'=>time()));
        $data = array('code'=>0,'msg'=>'课程点赞成功');
        $this->returnData($data);exit;
    }
	//取消点赞
    public function praise_cancel(){
        $courseId = I('course_id');
		$courseId = rtrim($courseId,',');
        if (empty($courseId)){
            $data = array('code'=>1,'msg'=>'ID错误');
            $this->returnData($data);exit;
        }
		M('course_praise')->where(array('course_id'=>array('IN',$courseId),'user_id'=>$this->userId))->delete();
        $data = array('code'=>0,'msg'=>'取消点赞成功');
        $this->returnData($data);exit;
    }	
	//删除我的评论
    public function reply_del(){
        $cr_id = I('cr_id');
        $cr_id = rtrim($cr_id,',');
        if (empty($cr_id)){
            $data = array('code'=>1,'msg'=>'ID错误');
            $this->returnData($data);exit;
        }
        M('course_reply')->where(array('cr_id'=>array('IN',$cr_id),'user_id'=>$this->userId))->delete();
        $data = array('code'=>0,'msg'=>'评论删除成功');
        $this->returnData($data);exit;
    }
}