danci/www.hanlinyuanonline.com/Application/Api/bak/WordsController.class.php

<?php
namespace Api\Controller;
use Common\Controller\ApiController;
class WordsController extends ApiController {
    public function __construct(){
        parent::__construct();
    }
    //获取单词列表
    public function index(){
        $sort = I('sort',1);
        $lastId = I('last_id',0);
        $courseId = I('course_id');
        $pageSize = I('page_size',20);
        $keyword = I('keyword','');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $condition = array('is_delete'=>1,'course_id'=>$courseId);
        if (!empty($keyword)){
            $condition['words_name'] = array('LIKE','%'.$keyword.'%');
        }
        $orderby = '';
        if ($sort==1){
            $orderby = 'words_id asc';
        }else if($sort==2){
            $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$courseId,'user_id'=>$this->userId,'sort_status'=>1))->field('word_ids')->find();
            if ($wordsSortInfo==NULL){
                $data = array('code'=>0,'msg'=>'占未设置乱序','data'=>array());
                $this->returnData($data);exit;
            }
        }
        if ($lastId>0 && $sort==1){
            $condition['words_id'] = array('LT',$lastId);
        }
        $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_show'=>1))->field('course_id,user_id,course_name,course_source,operate_dt')->find();
        if ($courseInfo['course_name']=='易错单词'){
            if ($lastId>0){
                $data = array('code'=>0,'msg'=>'无更多数据','data'=>array());
                $this->returnData($data);exit;
            }
            $errorInfo = M('Test')->where(array('user_id'=>$this->userId))->order('test_id desc')->field('words_error')->find();
            if ($errorInfo==NULL){
                $data = array('code'=>0,'msg'=>'暂无错误单词','data'=>array());
                $this->returnData($data);exit;
            }
            $res = M('Words')->where(array('words_id'=>array('IN',$errorInfo['words_error'])))->order($orderby)->select();
        }else{
            //$join = 'w LEFT JOIN t_words_notepad wn ON w.words_id=wn.words_id';
            if ($sort==1){
                $res = M('Words')->where($condition)->order($orderby)->limit($pageSize)->select();
            }else if($sort==2){
                $wordIdArr = explode(',', $wordsSortInfo['word_ids']);
                if ($lastId!=0){
                    $key = array_search($lastId,$wordIdArr);
                    $key = $key+1;
                }else{
                    $key = 0;
                }
                $wordsIdPage = array_slice($wordIdArr,$key,$pageSize);
                if (empty($wordsIdPage)){
                    $data = array('code'=>0,'msg'=>'无更多数据','data'=>array());
                    $this->returnData($data);exit;
                }
                $wordsIdpageStr = implode(',', $wordsIdPage);
                $condition['words_id'] = array('IN',$wordsIdPage);
                $orderby = 'field(words_id,'. $wordsIdpageStr .')';
                $res = M('Words')->where($condition)->order($orderby)->select();
                //echo M('Words')->getLastSql();exit;
            }
        }
        $wordsList = array();
        foreach ($res as $row){
            $wnRes = M('WordsNotepad')->where(array('words_id'=>$row['words_id'],'user_id'=>$this->userId))->field('wn_content')->find();
            $wnContent = '';
            if ($wnRes!=NULL){
                $wnContent = $wnRes['wn_content'];
            }
            unset($row['is_delete']);
            unset($row['words_source']);
            $row['wn_content'] = $wnContent;
            $wordsList[] = $row;
            /* $wordsList[] = array(
                'words_id' => $row['words_id'],
                'course_id' => $row['course_id'],
                'words_name' => $row['words_name'],
                'wn_content'=>$wnContent,
                'operate_dt' => $row['operate_dt'],
                'words_text' => $this->getWordsText($row),
            ); */
        }
        if ($res==NULL&&$lastId>0){
            $data = array('code'=>0,'msg'=>'无更多数据','data'=>array());
            $this->returnData($data);exit;
        }
        if ($lastId==0){
            if ($courseInfo['user_id']!=$this->userId){
                $fansInfo = M('Fans')->where(array('user_id'=>$this->userId,'fans_user_id'=>$courseInfo['user_id']))->field('fans_id')->find();
                $courseInfo['is_fans'] = $fansInfo==NULL?0:1;
                /* if ($courseInfo['course_source']==1){
                    $courseInfo['user_name'] = '系统课程';
                    $courseInfo['user_icon'] = C('DOMAIN').'/Public/img/admin_icon.png';
                }else{
                    $userInfo = M('User')->where(array('user_id'=>$courseInfo['user_id']))->field('user_name,user_icon,user_sex')->find();
                    $courseInfo['user_name'] = $userInfo['user_name'];
                    $courseInfo['user_icon'] = $userInfo['user_icon'];
                } */
            }else{
                $courseInfo['is_fans'] = 2;
            }
            $userInfo = M('User')->where(array('user_id'=>$courseInfo['user_id']))->field('user_id,user_name,user_icon,user_sex')->find();
            $courseInfo['user_id'] = $userInfo['user_id'];
            $courseInfo['user_sex'] = $userInfo['user_sex'];
            $courseInfo['user_icon'] = $userInfo['user_icon'];
            $courseInfo['user_name'] = $userInfo['user_name'];
        }else{
            $courseInfo = new \stdClass();
        }
        $data = array('code'=>0,'msg'=>'','data'=>$wordsList);
        if ($lastId==0){
            $data['info'] = $courseInfo;
        }
        $this->returnData($data);exit;
    }
    
    //获取指定章节单词列表
    public function part(){
        $sort = I('sort',1);
        $courseId = I('course_id');
        $partNum = I('part_num');
        if (empty($partNum) || $partNum<=0){
            $data = array('code'=>10,'msg'=>'章节ID错误');
            $this->returnData($data);exit;
        }
        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('uw_id,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']);
        }
        if (empty($partInfo['part_num'])){
            $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']);
            M('UserWords')->where(array('uw_id'=>$partInfo['uw_id']))->save(array('part_num'=>$partInfo['part_num']));
        }
        if ($partNum>$partInfo['part_num']){
            $data = array('code'=>10,'msg'=>'章节ID错误');
            $this->returnData($data);exit;
        }
        $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$courseId,'user_id'=>$this->userId,'sort_status'=>1))->field('word_ids')->find();
        if ($wordsSortInfo==NULL){
            $condition = array('is_delete'=>1,'course_id'=>$courseId);
            $orderby = '';
            if ($sort==1){
                $orderby = 'words_id asc';
            }
            $condition['user_id'] = $this->userId;
            //$join = 'w LEFT JOIN t_words_notepad wn ON w.words_id=wn.words_id';
            $res =M('Words')->where($condition)->order($orderby)->limit(($partNum-1)*$partInfo['user_part'], $partInfo['user_part'])->select();
        }else{
            $wordIdArr = explode(',', $wordsSortInfo['word_ids']);
            $wordsIdPage = array_slice($wordIdArr,($partNum-1)*$partInfo['user_part'], $partInfo['user_part']);
            if (empty($wordsIdPage)){
                $data = array('code'=>0,'msg'=>'章节ID错误','data'=>array());
                $this->returnData($data);exit;
            }
            $wordsIdpageStr = implode(',', $wordsIdPage);
            $condition['words_id'] = array('IN',$wordsIdPage);
            $orderby = 'field(words_id,'. $wordsIdpageStr .')';
            $res = M('Words')->where($condition)->order($orderby)->select();
        }
        $wordsList = array();
        foreach ($res as $k=>$row){
            $wnRes = M('WordsNotepad')->where(array('words_id'=>$row['words_id'],'user_id'=>$this->userId))->field('wn_content')->find();
            $wnContent = '';
            if ($wnRes!=NULL){
                $wnContent = $wnRes['wn_content'];
            }
            unset($row['is_delete']);
            unset($row['words_source']);
            $row['wn_content'] = $wnContent;
            //判断读音是否空
            if (empty($row['words_read1'])){
                $row['words_read1'] = $row['words_read2'];
                $row['words_voice1'] = $row['words_voice2'];
            }
            $wordsList[] = $row;
        }
        $data = array('code'=>0,'msg'=>'','data'=>$wordsList);
        $this->returnData($data);exit;
    }
    
    //获取特殊课程指定章节单词列表
    public function specialPart(){
        $sort = I('sort',1);
        $courseId = I('course_id');
        $partNum = I('part_num');
        $wordsArr = array();
        $wordsRes = M('Words')->where(array('course_id'=>$courseId))->group('operate_dt')->order('operate_dt')->field('operate_dt')->select();
        if (function_exists('array_column')){
            $wordsArr = array_column($wordsRes, 'operate_dt');
        }else{
            foreach ($wordsRes as $row){
                $wordsArr[] = $row['operate_dt'];
            }
        }
        if (empty($partNum)){
            if ($wordsRes!=NULL){
                $partNum = $wordsArr[0];
            }else{
                $data = array('code'=>1,'msg'=>'章节ID错误');
                $this->returnData($data);exit;
            }
        }
        
        $partData = array('current_part'=>$partNum,'pre_part'=>'','next_part'=>'');
        $key = array_search($partNum,$wordsArr);
        //获取上一章
        if ($key-1>0){
            $partData['pre_part'] = isset($wordsArr[$key-1])?$wordsArr[$key-1]:'';
        }
        //下一章
        if (isset($wordsArr[$key+1])){
            $partData['next_part'] = $wordsArr[$key+1];
        }
        
        
        $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$courseId,'user_id'=>$this->userId,'sort_status'=>1))->field('word_ids')->find();
        if ($wordsSortInfo==NULL){
            $orderby = '';
            if ($sort==1){
                $orderby = 'words_id asc';
            }
            //$join = 'w LEFT JOIN t_words_notepad wn ON w.words_id=wn.words_id';
            $res =M('Words')->where(array('course_id'=>$courseId,'operate_dt'=>$partNum))->order($orderby)->select();
        }else{
            $wordIdArr = explode(',', $wordsSortInfo['word_ids']);
            $wordsIdpageStr = implode(',', $wordIdArr);
            $condition['words_id'] = array('IN',$wordIdArr);
            $orderby = 'field(words_id,'. $wordsIdpageStr .')';
            $res = M('Words')->where($condition)->order($orderby)->select();
        }
        $wordsList = array();
        foreach ($res as $k=>$row){
            $wnRes = M('WordsNotepad')->where(array('words_id'=>$row['words_id'],'user_id'=>$this->userId))->field('wn_content')->find();
            $wnContent = '';
            if ($wnRes!=NULL){
                $wnContent = $wnRes['wn_content'];
            }
            unset($row['is_delete']);
            unset($row['words_source']);
            $row['wn_content'] = $wnContent;
            //判断读音是否空
            if (empty($row['words_read1'])){
                $row['words_read1'] = $row['words_read2'];
                $row['words_voice1'] = $row['words_voice2'];
            }
            $wordsList[] = $row;
        }
        $data = array('code'=>0,'msg'=>'','data'=>$wordsList,'partData'=>$partData);
        $this->returnData($data);exit;
    }
    
    //添加编辑单词
    public function edit(){
        $courseId = I('course_id');
        $wordsId = I('words_id','');
        $wordsName = I('words_name','');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        
        //判断单词是否重复
        if (empty($wordsId)){
            $wordsInfo = M('Words')->where(array('course_id'=>$courseId,'words_name'=>$wordsName))->field('words_id,words_name')->find();
            if ($wordsInfo!=NUll){
                $data = array('code'=>1,'msg'=>'该课程已经添加过该单词，请勿重复添加!');
                $this->returnData($data);exit;
            }
        }
        
        if (!empty($wordsId)){
            $wordsInfo = M('Words')->where(array('course_id'=>$courseId,'words_name'=>$wordsName))->field('words_id,words_name')->find();
            if ($wordsInfo!=NUll && $wordsInfo['words_id']!=$wordsId){
                $data = array('code'=>1,'msg'=>'该课程已经添加过该单词，请勿重复添加!');
                $this->returnData($data);exit;
            }
        }
        $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
        if ($courseInfo==NULL){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        if (in_array($courseInfo['course_name'], array('易错单词','重点单词'))){
            $data = array('code'=>1,'msg'=>'不能编辑特殊课程单词');
            $this->returnData($data);exit;
        }
        $oldCourseInfo = $courseInfo;
        if ($courseInfo['course_status']==3 || $courseInfo['user_id']!=$this->userId){
            //创建新课程，并把就课程里面的所有的单词添加到新创建的课程中
            $userCourseInfo = M('Course')->where(array('user_id'=>$this->userId))->field('operate_dt')->find();
            if($userCourseInfo!=NULL){
                $time = time() - $userCourseInfo['operate_dt'];
                if ($time<C('COURSE_TIME')){
                    $data = array('code'=>1,'msg'=>'3分钟内无法连续创建课程');
                    $this->returnData($data);exit;
                }
            }
            $oldCourseId = $courseInfo['course_id'];
            if ($courseInfo['user_id']==$this->userId){
                M('Course')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
            }else if($courseInfo['course_source']==1){
                //系统课程
                $sysCourse = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('uw_id')->find();
                if ($sysCourse==NULL){
                    $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
                    if ($userInfo==NULL || empty($userInfo['user_part'])){
                        $userPart = 15;
                        $partNum =ceil($courseInfo['course_num']/15);
                    }else{
                        $userPart = $userInfo['user_part'];
                        $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
                    }
                    $sysCourseInfo = array(
                        'user_id'=>$this->userId,
                        'course_id'=>$courseId,
                        'user_part'=>$userPart,
                        'part_num'=>$partNum,
                        'is_show'=>2,
                        'operate_dt'=>time(),
                    );
                    M('UserWords')->add($sysCourseInfo);
                }else{
                    M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
                }
            }
            //创建课程
            unset($courseInfo['course_id']);
            $courseInfo['course_status'] = 1;
            $courseInfo['operate_dt'] = time();
            $courseInfo['user_id'] = $this->userId;
            $courseInfo['course_source']=2;
            $courseInfo['course_name'] = $courseInfo['course_name'];//$this->getCourseName($courseInfo['course_name']);
            $courseId = M('Course')->add($courseInfo);
            $userWordsInfo = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('uw_id')->find();
            if ($userWordsInfo==NULL){
                $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
                if ($userInfo==NULL || empty($userInfo['user_part'])){
                    $userPart = 15;
                    $partNum =ceil($courseInfo['course_num']/15);
                }else{
                    $userPart = $userInfo['user_part'];
                    $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
                }
                $saveCourseWordsInfo = array(
                    'user_id'=>$this->userId,
                    'course_id'=>$courseId,
                    'user_part'=>$userPart,
                    'part_num'=>$partNum,
                    'operate_dt'=>time(),
                );
                M('UserWords')->add($saveCourseWordsInfo);
            }else{
                M('UserWords')->where(array('uw_id'=>$userWordsInfo['uw_id']))->save(array('course_id'=>$courseId));
                //M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('course_id'=>$courseId));
            }
            //复制单词
            $this->copyWords($oldCourseId,$courseId);
        }else{
            $userWordsInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id')->find();

            if ($userWordsInfo==NULL){
                $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
                if ($userInfo==NULL || empty($userInfo['user_part'])){
                    $userPart = 15;
                    $partNum =ceil($courseInfo['course_num']/15);
                }else{
                    $userPart = $userInfo['user_part'];
                    $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
                }
                $saveCourseWordsInfo = array(
                    'user_id'=>$this->userId,
                    'course_id'=>$courseId,
                    'user_part'=>$userPart,
                    'part_num'=>$partNum,
                    'operate_dt'=>time(),
                );
                M('UserWords')->add($saveCourseWordsInfo);
            }
        }
        
        $wordsKeys = array('n'=>'words_n','pron'=>'words_pron','adj'=>'words_adj','num'=>'words_num','v'=>'words_v','adv'=>'words_adv','art'=>'words_art',
            'prep'=>'words_prep','conj'=>'words_conj','int'=>'words_int','vt'=>'words_vt','vi'=>'words_vi','other'=>'words_other',);
        $saveData['course_id'] = $courseId;
        $saveData['words_name'] = I('words_name','');
        /* $wordsVoice = I('words_voice','');
        $wordsRead = I('words_read','');
        if (substr($wordsVoice,-1)==','){
            $wordsVoice = substr($wordsVoice, 0, -1);
        }
        $wordsVoiceArr = explode(',', $wordsVoice);
        $wordsReadArr = explode(',', $wordsRead);
        for ($i=0;$i<count($wordsVoiceArr);$i++){
            $j = $i+1;
            $saveData['words_read'.$j] = $wordsReadArr[$i];
            $saveData['words_voice'.$j] = $wordsVoiceArr[$i];
        } */
        $saveData['words_voice1'] = I('words_voice1','');
        $saveData['words_read1'] = I('words_read1','');
        $wordsVals = array_values($wordsKeys);
        $checkWords = true;
        foreach ($wordsVals as $keys){
            $saveData[$keys] = I($keys,'');
            if (!empty($saveData[$keys])){
                $checkWords = false;
            }
        }
        if (empty($saveData['words_name'])){
            $data = array('code'=>1,'msg'=>'单词不能为空');
            $this->returnData($data);exit;
        }
        if (empty($saveData['words_voice1'])){
            $data = array('code'=>1,'msg'=>'读音不能为空');
            $this->returnData($data);exit;
        }
        if (empty($saveData['words_read1'])){
            $data = array('code'=>1,'msg'=>'音标不能为空');
            $this->returnData($data);exit;
        }
        if ($checkWords){
            $data = array('code'=>1,'msg'=>'中文释义不能为空');
            $this->returnData($data);exit;
        }
        $saveData['jz_en1'] = I('jz_en1','');
        $saveData['jz_cn1'] = I('jz_cn1','');
        $saveData['jz_en2'] = I('jz_en2','');
        $saveData['jz_cn2'] = I('jz_cn2','');
        $saveData['jz_en3'] = I('jz_en3','');
        $saveData['jz_cn3'] = I('jz_cn3','');
        $saveData['similar_cn'] = I('similar_cn','');
        $saveData['similar_en'] = I('similar_en','');
        $saveData['words_similar'] = I('words_similar');
        $saveData['annotation_cn'] = I('annotation_cn','');
        if (!empty($saveData['jz_en1']) && strpos(strtolower($saveData['jz_en1']), $saveData['words_name'])===FALSE){
            $data = array('code'=>1,'msg'=>'您添加的例句1不包含对应单词，请仔细核对后提交');
            $this->returnData($data);exit;
        }
        if (!empty($saveData['jz_en2']) && strpos(strtolower($saveData['jz_en2']), $saveData['words_name'])===FALSE){
            $data = array('code'=>1,'msg'=>'您添加的例句2不包含对应单词，请仔细核对后提交交');
            $this->returnData($data);exit;
        }
        if (!empty($saveData['jz_en3']) && strpos(strtolower($saveData['jz_en3']), $saveData['words_name'])===FALSE){
            $data = array('code'=>1,'msg'=>'您添加的例句3不包含对应单词，请仔细核对后提交');
            $this->returnData($data);exit;
        }
        if (!empty($saveData['jz_en1']) && empty($saveData['jz_cn1'])){
            $data = array('code'=>1,'msg'=>'您添加的例句1释义不能为空，请仔细核对后提交');
            $this->returnData($data);exit;
        }
        if (!empty($saveData['jz_en2']) && empty($saveData['jz_cn2'])){
            $data = array('code'=>1,'msg'=>'您添加的例句1释义不能为空，请仔细核对后提交');
            $this->returnData($data);exit;
        }
        if (!empty($saveData['jz_en3']) && empty($saveData['jz_cn3'])){
            $data = array('code'=>1,'msg'=>'您添加的例句1释义不能为空，请仔细核对后提交');
            $this->returnData($data);exit;
        }
        
       if (!empty($saveData['words_similar']) && strlen($saveData['words_similar'])>50){
            $data = array('code'=>1,'msg'=>'近义词不能大于50个字节');
            $this->returnData($data);exit;
        }
        
        if (!empty($data['similar_cn']) && strlen($data['similar_cn'])>500){
            $data = array('code'=>1,'msg'=>'英文释义不能大于500个字节');
            $this->returnData($data);exit;
        }
        $saveData['operate_dt'] = time();
        if ($wordsId){
            if ($oldCourseInfo['course_status']==3 || $oldCourseInfo['user_id']!=$this->userId){
                //$wordsId = M('Words')->add($saveData);
                $wordsOldInfo = M('Words')->where(array('words_id'=>$wordsId,))->field('words_id,words_name')->find();
                $wordsNewInfo = M('Words')->where(array('course_id'=>$saveData['course_id'],'words_name'=>$wordsOldInfo['words_name'],))->field('words_id')->find();
                M('Words')->where(array('words_id'=>$wordsNewInfo['words_id']))->save($saveData);
                $returnWordsId = $wordsNewInfo['words_id'];
            }else{
                M('Words')->where(array('words_id'=>$wordsId))->save($saveData);
                $returnWordsId = $wordsId;
            }
        }else{
            $wordsId = M('Words')->add($saveData);
            $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('sort_id,word_ids')->find();
            if ($wordsSortInfo != NULL){
                $wordsSortInfo['word_ids'] = $wordsSortInfo['word_ids'].','.$wordsId;
                M('WordsSort')->where(array('sort_id'=>$wordsSortInfo['sort_id']))->save(array('word_ids'=>$wordsSortInfo['word_ids']));
            }
            M('Course')->where(array('course_id'=>$courseId))->setInc('course_num');
            $returnWordsId = $wordsId;
        }
        
        //重新计算章节信息
        $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
        $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
        if ($userInfo==NULL || empty($userInfo['user_part'])){
            $userPart = 15;
            $partNum =ceil($courseInfo['course_num']/15);
        }else{
            $userPart = $userInfo['user_part'];
            $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
        }
        M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->save(array('part_num'=>$partNum));
        
        $join = 'uw LEFT JOIN t_course c ON uw.course_id=c.course_id';
        $resUserWords = M('UserWords')->join($join)->where(array('c.course_id'=>$saveData['course_id'],'uw.user_id'=>$this->userId,))->field('uw.course_id,uw.user_id,course_join,course_num,course_name,uw_id,uw.user_part,uw.part_num')->find();
        $resUserWords['words_id'] = $returnWordsId;
        $data = array('code'=>0,'msg'=>'单词操作成功','data'=>$resUserWords);
        $this->returnData($data);exit;
        /* $data = array('code'=>0,'msg'=>'单词操作成功','data'=>array('words_id'=>$wordsId,'course_id'=>$courseId));
        $this->returnData($data);exit; */
    }
    
    //把其他课程里面的单词添加到指定课程中
    public function addWordsToCourse(){
        $wordsId = I('words_id');
        $courseId = I('course_id');
        if (empty($wordsId)){
            $data = array('code'=>1,'msg'=>'单词ID错误');
            $this->returnData($data);exit;
        }
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $wordsInfo = M('Words')->where(array('words_id'=>$wordsId,'is_delete'=>1))->find();
        if ($wordsInfo!=NULL && $wordsInfo['course_id']==$courseId){
            $data = array('code'=>1,'msg'=>'已是该课程单词');
            $this->returnData($data);exit;
        }
        $wordsCourseInfo = M('Words')->where(array('words_name'=>$wordsInfo['words_name'],'course_id'=>$courseId))->field('words_id')->find();
        if ($wordsCourseInfo!=NULL){
            $data = array('code'=>1,'msg'=>'已是该课程单词');
            $this->returnData($data);exit;
        }
        $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
        if ($courseInfo==NULL){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        
        if (in_array($courseInfo['course_name'], array('易错单词','重点单词'))){
            $data = array('code'=>1,'msg'=>'不能编辑特殊课程单词');
            $this->returnData($data);exit;
        }
        
        $oldCourseId = 0;
        if ($courseInfo['course_status']==3 || $courseInfo['user_id']!=$this->userId){
            //创建新课程，并把就课程里面的所有的单词添加到新创建的课程中
            $userCourseInfo = M('Course')->where(array('user_id'=>$this->userId))->field('operate_dt')->find();
            if($userCourseInfo!=NULL){
                $time = time() - $userCourseInfo['operate_dt'];
                if ($time<C('COURSE_TIME')){
                    $data = array('code'=>1,'msg'=>'3分钟内无法连续创建课程');
                    $this->returnData($data);exit;
                }
            }
            $oldCourseId = $courseInfo['course_id'];
            if ($courseInfo['user_id']==$this->userId){
                M('Course')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
            }else if($courseInfo['course_source']==1){
                //系统课程
                $sysCourse = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('uw_id')->find();
                if ($sysCourse==NULL){
                    $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
                    if ($userInfo==NULL || empty($userInfo['user_part'])){
                        $userPart = 15;
                        $partNum =ceil($courseInfo['course_num']/15);
                    }else{
                        $userPart = $userInfo['user_part'];
                        $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
                    }
                    $sysCourseInfo = array(
                        'user_id'=>$this->userId,
                        'course_id'=>$courseId,
                        'user_part'=>$userPart,
                        'part_num'=>$partNum,
                        'is_show'=>2,
                        'operate_dt'=>time(),
                    );
                    M('UserWords')->add($sysCourseInfo);
                }else{
                    M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
                }
            }
            //创建课程
            unset($courseInfo['course_id']);
            $courseInfo['course_status'] = 1;
            $courseInfo['operate_dt'] = time();
            $courseInfo['user_id'] = $this->userId;
            $courseInfo['course_source']=2;
            $courseInfo['course_name'] = $this->getCourseName($courseInfo['course_name']);
            $courseId = M('Course')->add($courseInfo);
            //复制单词
            $this->copyWords($oldCourseId,$courseId);
        }
        $wordsInfo['operate_dt'] = time();
        $wordsInfo['course_id'] = $courseId;
        $wordsInfo['words_source'] = 2;
        unset($wordsInfo['words_id']);
        M('Words')->add($wordsInfo);
        M('Course')->where(array('course_id'=>$courseId))->setInc('course_num');
        $data = array('code'=>0,'msg'=>'单词添加成功','data'=>'');
        if (empty($oldCourseId)){
            $data['data']['new_course'] = 0;
        }else{
            $data['data']['new_course'] = 1;
        }
        $this->returnData($data);exit;
    }
    
    //删除单词
    public function del(){
        $wordsId = I('words_id');
        $courseId = I('course_id');
        if (empty($wordsId)){
            $data = array('code'=>1,'msg'=>'单词ID错误');
            $this->returnData($data);exit;
        }
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        $wordsInfo = M('Words')->where(array('words_id'=>$wordsId,'is_delete'=>1))->find();
        if ($wordsInfo!=NULL && $wordsInfo['course_id']!=$courseId){
            $data = array('code'=>1,'msg'=>'不是该课程单词');
            $this->returnData($data);exit;
        }
        $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
        if ($courseInfo==NULL){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        
        if (in_array($courseInfo['course_name'], array('易错单词','重点单词'))){
            $data = array('code'=>1,'msg'=>'不能编辑特殊课程单词');
            $this->returnData($data);exit;
        }
        
        $oldCourseInfo = $courseInfo;
        if ($courseInfo['course_status']==3 || $courseInfo['user_id']!=$this->userId){
            //创建新课程，并把就课程里面的所有的单词添加到新创建的课程中
            $userCourseInfo = M('Course')->where(array('user_id'=>$this->userId))->field('operate_dt')->find();
            if($userCourseInfo!=NULL){
                $time = time() - $userCourseInfo['operate_dt'];
                if ($time<C('COURSE_TIME')){
                    $data = array('code'=>1,'msg'=>'3分钟内无法连续创建课程');
                    $this->returnData($data);exit;
                }
            }
            $oldCourseId = $courseInfo['course_id'];
            if ($courseInfo['user_id']==$this->userId){
                M('Course')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
            }else if($courseInfo['course_source']==1){
                //系统课程
                $sysCourse = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId,'is_show'=>1))->field('uw_id')->find();
                if ($sysCourse==NULL){
                    $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
                    if ($userInfo==NULL || empty($userInfo['user_part'])){
                        $userPart = 15;
                        $partNum =ceil($courseInfo['course_num']/15);
                    }else{
                        $userPart = $userInfo['user_part'];
                        $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
                    }
                    $sysCourseInfo = array(
                        'user_id'=>$this->userId,
                        'course_id'=>$courseId,
                        'user_part'=>$userPart,
                        'part_num'=>$partNum,
                        'is_show'=>2,
                        'operate_dt'=>time(),
                    );
                    M('UserWords')->add($sysCourseInfo);
                }else{
                    M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('is_show'=>2));
                }
            }
            //创建课程
            unset($courseInfo['course_id']);
            $courseInfo['course_status'] = 1;
            $courseInfo['operate_dt'] = time();
            $courseInfo['user_id'] = $this->userId;
            $courseInfo['course_source']=2;
            $courseInfo['course_name'] = $courseInfo['course_name'];//$this->getCourseName($courseInfo['course_name']);
            $courseId = M('Course')->add($courseInfo);
            $userWordsInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id')->find();
            if ($userWordsInfo==NULL){
                $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
                if ($userInfo==NULL || empty($userInfo['user_part'])){
                    $userPart = 15;
                    $partNum =ceil($courseInfo['course_num']/15);
                }else{
                    $userPart = $userInfo['user_part'];
                    $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
                }
                $userOldWordsInfo = M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->field('current_course')->find();
                $saveCourseWordsInfo = array(
                    'user_id'=>$this->userId,
                    'course_id'=>$courseId,
                    'user_part'=>$userPart,
                    'part_num'=>$partNum,
                    'operate_dt'=>time(),
                );
                if ($userOldWordsInfo!=NULL && $userOldWordsInfo['current_course']==2){
                    $saveCourseWordsInfo['current_course'] = 2;
                }
                M('UserWords')->add($saveCourseWordsInfo);
            }else{
                M('UserWords')->where(array('uw_id'=>$userWordsInfo['uw_id']))->save(array('course_id'=>$courseId));
                //M('UserWords')->where(array('course_id'=>$oldCourseId,'user_id'=>$this->userId))->save(array('course_id'=>$courseId));
            }
            //复制单词
            $this->copyWords($oldCourseId,$courseId,$wordsId);
        }else{
            $userWordsInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id')->find();
            if ($userWordsInfo==NULL){
                $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
                if ($userInfo==NULL || empty($userInfo['user_part'])){
                    $userPart = 15;
                    $partNum =ceil($courseInfo['course_num']/15);
                }else{
                    $userPart = $userInfo['user_part'];
                    $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
                }
                $saveCourseWordsInfo = array(
                    'user_id'=>$this->userId,
                    'course_id'=>$courseId,
                    'user_part'=>$userPart,
                    'part_num'=>$partNum,
                    'operate_dt'=>time(),
                );
                M('UserWords')->add($saveCourseWordsInfo);
            }
            M('Words')->where(array('words_id'=>array('IN',$wordsId)))->delete();
        }
        $wordsIdArr = explode(',', $wordsId);
        $num = count($wordsIdArr);
        M('Course')->where(array('course_id'=>$courseId))->setDec('course_num',$num);
        $wordsSortInfo = M('WordsSort')->where(array('course_id'=>$oldCourseInfo['course_id'],'user_id'=>$this->userId))->field('sort_id,word_ids')->find();
        if ($wordsSortInfo != NULL){
            $wordsSortIdArr = explode(',', $wordsSortInfo['word_ids']);
            $wordsSortInfo['word_ids'] = array_shift($wordsSortIdArr,$wordsIdArr);
            M('WordsSort')->where(array('sort_id'=>$wordsSortInfo['sort_id']))->save(array('word_ids'=>$wordsSortInfo['word_ids']));
        }
        //重新计算章节信息
        $userWordsInfo = M('UserWords')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->field('uw_id')->find();
        $userInfo = M('User')->where(array('user_id'=>$this->userId))->field('user_part')->find();
        $courseInfo = M('Course')->where(array('course_id'=>$courseId,'is_delete'=>1))->field('course_id,user_id,course_name,course_num,course_status,course_source')->find();
        if ($userInfo==NULL || empty($userInfo['user_part'])){
            $userPart = 15;
            $partNum =ceil($courseInfo['course_num']/15);
        }else{
            $userPart = $userInfo['user_part'];
            $partNum =ceil($courseInfo['course_num']/$userInfo['user_part']);
        }
        M('UserWords')->where(array('uw_id'=>$userWordsInfo['uw_id']))->save(array('part_num'=>$partNum));

        $join = 'uw LEFT JOIN t_course c ON uw.course_id=c.course_id';
        $resUserWords = M('UserWords')->join($join)->where(array('c.course_id'=>$courseId,'uw.user_id'=>$this->userId,))->field('uw.course_id,uw.user_id,course_join,course_num,course_name,uw_id,uw.user_part,uw.part_num')->find();
        $data = array('code'=>0,'msg'=>'单词删除成功','data'=>$resUserWords);
        $this->returnData($data);exit;
        /*$data = array('code'=>0,'msg'=>'单词删除成功','data'=>'');
        $this->returnData($data);exit;*/
    }
    
    //添加单词笔记
    public function notepad(){
        $wordsId = I('words_id');
        $courseId = I('course_id');
        $wnContent = I('wn_content');
        if(empty($wordsId)){
            $data = array('code'=>1,'msg'=>'单词ID错误');
            $this->returnData($data);exit;
        }
        if(empty($courseId)){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        if (mb_strlen($wnContent,'UTF8')<2 || mb_strlen($wnContent,'UTF8')>80){
            $data = array('code'=>1,'msg'=>'单词笔记2到80个汉字');
            $this->returnData($data);exit;
        }
        $res = M('WordsNotepad')->where(array('words_id'=>$wordsId,'user_id'=>$this->userId))->field('wn_id')->find();
        if ($res==NULL){
            $saveData = array('user_id'=>$this->userId,'words_id'=>$wordsId,'course_id'=>$courseId,'wn_content'=>$wnContent,'operate_dt'=>time());
            $wnId = M('WordsNotepad')->add($saveData);
            $msg = '单词笔记添加成功';
        }else{
            $wnId = $res['wn_id'];
            M('WordsNotepad')->where(array('wn_id'=>$wnId))->save(array('wn_content'=>$wnContent));
            $msg = '单词笔记修改成功';
        }
        $info = M('WordsNotepad')->where(array('wn_id'=>$wnId))->field('user_id,words_id,course_id,wn_content')->find();
        $data = array('code'=>0,'msg'=>$msg,'data'=>$info);
        $this->returnData($data);exit;
    }
    
    //添加错误单词到易错单词课程中
    private function addErrorWords($wordsId){
        $wordsId = rtrim(I('words_id'),',');
        if (empty($wordsId)){
            return false;
        }
        $courseInfo = M('Course')->where(array('user_id'=>$this->userId,'course_name'=>'易错单词','course_flag'=>1))->field('course_id,course_name')->find();
        if ($courseInfo==NULL){
            $courseId = M('Course')->add(array('course_type'=>0,'course_name'=>'易错单词','course_source'=>2,'user_id'=>$this->userId,'operate_dt'=>time()));
        }else if($courseInfo['course_name']=='易错单词'){
            return false;
        }else{
            $courseId = $courseInfo['course_id'];
        }
        $wordsList = M('Words')->where(array('words_id'=>array('IN',$wordsId),'is_delete'=>1))->order('words_id asc')->select();
        //var_dump($wordsList);exit;
        foreach ($wordsList as $words){
            unset($words['words_id']);
            $words['course_id'] = $courseId;
            $words['words_source'] = 2;
            //$words['operate_dt'] = time();
            $words['operate_dt'] = strtotime(date('Y-m-d'));
            M('Words')->add($words);
        }
        return false;
    }
    
    //测试模式上报
    public function test(){
        $testType = I('test_type');
        $wordsId = rtrim(I('words_id'),',');
        //$wordsTotal = I('words_total');
        $wordsError = rtrim(I('words_error'),',');
        //$wordsSuccess = rtrim(I('words_success'));
        //$testNum = I('test_num');
        //$testScore = I('test_score');
        if (!in_array($testType, array(1,2,3,4,5,6))){
            $data = array('code'=>1,'msg'=>'测试模式错误');
            $this->returnData($data);exit;
        }
        if (empty($wordsId)){
            $data = array('code'=>1,'msg'=>'测试单词id错误');
            $this->returnData($data);exit;
        }
        
        $wordsTotal = substr_count($wordsId,',')+1;
        if (empty($wordsError)){
            $wordsErrLen = 0;
        }else{
            $wordsErrLen = substr_count($wordsError,',')+1;
        }
        $wordsSucLen = $wordsTotal-$wordsErrLen;
        $score = round($wordsSucLen/$wordsTotal*100);
        $wordsIdArr = explode(',', $wordsId);
        $wordsErrorArr = explode(',', $wordsError);
        $wordsSuccess = implode(',', array_diff($wordsIdArr, $wordsErrorArr));
        //var_dump($wordsId,$wordsError,$wordsSuccess,$wordsSucLen,$wordsTotal);exit;
        $saveData = array(
            'user_id'=>$this->userId,'test_type'=>$testType,'words_ids'=>$wordsId,
            'words_total'=>$wordsTotal,'words_error'=>$wordsError,'words_success'=>$wordsSuccess,
            'test_num'=>$wordsTotal,'test_score'=>$score,'operate_dt'=>time(),
        );
        M('Test')->add($saveData);
        $this->addErrorWords($wordsError);
        
        $data = array('code'=>0,'msg'=>'单词测试上报成功','data'=>array('score'=>$score));
        $this->returnData($data);exit;
    }
    
    //获取单词信息接口
    public function dict(){
        $wordsName = I('words_name','');
        if (empty($wordsName)){
            $data = array('code'=>1,'msg'=>'单词不能为空');
            $this->returnData($data);exit;
        }
        $wordsKeys = array('n'=>'words_n','pron'=>'words_pron','adj'=>'words_adj','num'=>'words_num','v'=>'words_v','adv'=>'words_adv','art'=>'words_art','prep'=>'words_prep','conj'=>'words_conj','int'=>'words_int','vt'=>'words_vt','vi'=>'words_vi',);
        $httpCurl = new \Org\Net\HttpCurl();
        $url = C('TRANS').'&w='.$wordsName;
        $res = $httpCurl->get($url,'xml');
        $res = json_decode(json_encode(simplexml_load_string($res, 'SimpleXMLElement', LIBXML_NOCDATA)), true);
        /* $url = C('TRANS').'&type=json&w='.$wordsName;
        $res = $httpCurl->get($url); */
        if (!isset($res['key'])){
            $data = array('code'=>1,'msg'=>'单词翻译出错');
            echo json_encode($data);
        }
        $saveData = array();
        if (isset($res['ps'])){
            if (is_array($res['ps'])){
                for ($i=0;$i<count($res['ps']);$i++){
                    $j = $i+1;
                    $saveData['words_read'.$j] = $res['ps'][$i];
                    $saveData['words_voice'.$j] = $res['pron'][$i];
                }
            }else{
                $saveData['words_read1'] = $res['ps'];
                $saveData['words_voice1'] = $res['pron'];
            }
        }else{
            $saveData['words_read1'] = '';
            $saveData['words_voice1'] = '';
        }
        if (isset($res['pos'])){
            if (is_array($res['pos'])){
                foreach ($res['pos'] as $k=>$v){
                    if (isset($wordsKeys[str_replace('.', '', $v)])){
                        $saveData[$wordsKeys[str_replace('.', '', $v)]] = trim($res['acceptation'][$k]);
                    }
                }
            }else{
                if (isset($wordsKeys[str_replace('.', '', $res['pos'])])){
                    $saveData[$wordsKeys[str_replace('.', '', $res['pos'])]] = trim($res['acceptation']);
                }else{
                    $saveData['words_other'] = trim($res['acceptation']);
                }
            }
        }
        if (isset($res['sent'])){
            for ($i=0;$i<count($res['sent']);$i++){
                $j = $i+1;
                if ($j>3){
                    continue;
                }
                $saveData['jz_en'.$j] = trim($res['sent'][$i]['orig']);
                $saveData['jz_cn'.$j] = trim($res['sent'][$i]['trans']);
            }
        }
        $data = array('code'=>0,'msg'=>'','data'=>$saveData);
        $this->returnData($data);exit;
    }
    
    //删除单词笔记
    public function delNote(){
        $wordsId = I('words_id','');
        if (empty($wordsId)){
            $data = array('code'=>1,'msg'=>'单词ID出错');
            echo json_encode($data);
        }
        M('WordsNotepad')->where(array('words_id'=>$wordsId,'user_id'=>$this->userId))->delete();
        $data = array('code'=>0,'msg'=>'删除成功','data'=>'');
        $this->returnData($data);exit;
    }
    
    //单词乱序
    public function sort(){
        $courseId = I('course_id');
        if (empty($courseId) || $courseId<1000000){
            $data = array('code'=>1,'msg'=>'课程ID错误');
            $this->returnData($data);exit;
        }
        //1:乱序,0:取消乱序
        $type = I('type',1);
        if (!in_array($type, array(0,1))){
            $data = array('code'=>0,'msg'=>'类型错误');
            $this->returnData($data);exit;
        }
        $info = M('WordsSort')->where(array('course_id'=>$courseId,'user_id'=>$this->userId))->find();
        if ($type==1){
            if ($info!=NULL){
                if ($info['sort_status']==2){
                    M('WordsSort')->where(array('sort_id'=>$info['sort_id']))->save(array('sort_status'=>1));
                }
                $data = array('code'=>0,'msg'=>'设置乱序成功');
                echo json_encode($data);
            }else{
                $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);
                $data = array('code'=>0,'msg'=>'设置乱序成功');
                echo json_encode($data);
            }
        }else if($type==0){
            if ($info==NULL){
                $data = array('code'=>0,'msg'=>'设置默认排序成功');
                $this->returnData($data);exit;
            }else{
                M('WordsSort')->where(array('sort_id'=>$info['sort_id']))->save(array('sort_status'=>2));
                $data = array('code'=>0,'msg'=>'设置默认排序成功');
                $this->returnData($data);exit;
            }
        }
    }
    
    //添加重点单词课程
    public function addImportantWords(){
        $wordsId = rtrim(I('words_id'),',');
        if (empty($wordsId)){
            return false;
        }
        $courseInfo = M('Course')->where(array('user_id'=>$this->userId,'course_name'=>'重点单词','course_flag'=>1))->field('course_id')->find();
        if ($courseInfo==NULL){
            $courseId = M('Course')->add(array('course_type'=>0,'course_name'=>'重点单词','course_source'=>2,'user_id'=>$this->userId,'operate_dt'=>time()));
        }else{
            $courseId = $courseInfo['course_id'];
        }
        $wordsList = M('Words')->where(array('words_id'=>array('IN',$wordsId),'is_delete'=>1))->order('words_id asc')->select();
        foreach ($wordsList as $words){
            $wordsInfo = M('Words')->where(array('words_name'=>$words['words_name'],'course_id'=>$courseId))->field('words_id')->find();
            if ($wordsInfo){
                continue;
            }
            unset($words['words_id']);
            $words['course_id'] = $courseId;
            $words['words_source'] = 2;
            $words['operate_dt'] = strtotime(date('Y-m-d'));
            M('Words')->add($words);
            M('Course')->where(array('course_id'=>$courseId))->setInc('course_num');
        }
        $data = array('code'=>0,'msg'=>'添加成功');
        $this->returnData($data);exit;
    }
}