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

<?php
namespace Api\Controller;
use Think\Controller;
class IndexController extends Controller {
    //官网课程
    public function course(){
        $sort = I('sort',1);
        $page = I('page');
        $keyword = I('keyword','','trim');
        $pageSize = I('page_size',10);
        $condition = array('course_status'=>3,'course_flag'=>1,'is_show'=>1,'a.is_delete'=>1);
        if (!empty($keyword)){
            $condition['course_name|user_name'] = array('LIKE','%'.$keyword.'%');
        }
        $orderby = '';
        if ($sort==1){
            $orderby = 'course_join desc';
        }else if($sort==2){
            $orderby = 'course_id desc';
        }
        $join = 'a LEFT JOIN __USER__ b ON a.user_id=b.user_id';
        $count = M('Course')->join($join)->where($condition)->count();
        $field = 'user_name,user_phone,user_icon,course_id,a.user_id,course_flag,course_name,course_join,course_num,course_source,a.operate_dt';
        $res = M('Course')->join($join)->where($condition)->field($field)->order($orderby)->page($page,$pageSize)->select();
        $data = array('code'=>0,'msg'=>'','data'=>['total'=>$count,'list'=>$res]);
        $this->returnData($data);exit;
    }
    
    //官网自由记
    public function notepad(){
        $sort = I('sort',1);
        $page = I('page');
        $keyword = I('keyword','','trim');
        $pageSize = I('page_size',10);
        $condition = array('course_status'=>3,'course_flag'=>2,'a.is_delete'=>1);
        if (!empty($keyword)){
            $condition['course_name|user_name'] = array('LIKE','%'.$keyword.'%');
        }
        $orderby = '';
        if ($sort==1){
            $orderby = 'course_join desc';
        }else if($sort==2){
            $orderby = 'course_id desc';
        }
        $join = 'a LEFT JOIN __USER__ b ON a.user_id=b.user_id';
        $count = M('Course')->join($join)->where($condition)->count();
        $field = 'user_name,user_phone,user_icon,course_id,a.user_id,course_flag,course_name,course_content,course_join,course_num,course_source,a.operate_dt';
        $res = M('Course')->join($join)->where($condition)->field($field)->order($orderby)->page($page,$pageSize)->select();
        $data = array('code'=>0,'msg'=>'','data'=>['total'=>$count,'list'=>$res]);
        $this->returnData($data);exit;
    }
    
    //获取单词列表
    public function words(){
        $sort = I('sort',1);
        $page = I('page');
        $courseId = I('course_id');
        $pageSize = I('page_size',10);
        $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';
        }
        $count = M('Words')->where($condition)->count();
        $res = M('Words')->where($condition)->order($orderby)->page($page,$pageSize)->select();
        $wordsList = array();
        foreach ($res  as $row){
            $wordsList[] = array(
                'words_id' => $row['words_id'],
                'course_id' => $row['course_id'],
                'words_name' => $row['words_name'],
                'words_voice' => $row['words_voice'],
                'words_read' => $row['words_read'],
                'operate_dt' => $row['operate_dt'],
                'words_text' => $this->getWordsText($row),
            );
        }
        $data = array('code'=>0,'msg'=>'','data'=>['total'=>$count,'list'=>$wordsList]);
        $this->returnData($data);exit;
    }
    
    //自由记详情
    public function notepadInfo(){
        $courseId = I('course_id');
        $info = M('Course')->where(['course_id'=>$courseId])->field('course_id,course_name,course_content')->find();
        $data = array('code'=>0,'msg'=>'','data'=>$info);
        $this->returnData($data);exit;
    }
    
    //单词详情
    public function wordsInfo(){
        $wordsId = I('words_id');
        $info = M('Words')->where(['words_id'=>$wordsId])->find();
        $wordsPreId = '';
        $wordsNextId = '';
        if (!empty($info['course_id'])){
            $info = M('Words')->where(array('words_id'=>$wordsId))->find();
            $wordsPreInfo = M('Words')->where(array('course_id'=>$info['course_id'],'words_id'=>array('LT',$wordsId)))->order('words_id desc')->field('words_id')->find();
            if ($wordsPreInfo!=null){
                $wordsPreId = $wordsPreInfo['words_id'];
            }
            $wordsNextInfo = M('Words')->where(array('course_id'=>$info['course_id'],'words_id'=>array('GT',$wordsId)))->order('words_id asc')->field('words_id')->find();
            if ($wordsNextInfo!=null){
                $wordsNextId = $wordsNextInfo['words_id'];
            }
            $list  = M('Words')->where(array('course_id'=>$info['course_id'],'words_id'=>array('GT',$wordsId)))->limit(9)->order('words_id asc')->field('course_id,words_id,words_name')->select();
        }
        $data = array('info'=>$info,'pre_id'=>$wordsPreId,'next_id'=>$wordsNextId,'list'=>$list);
        $data = array('code'=>0,'msg'=>'','data'=>$data);
        $this->returnData($data);exit;
    }
    
    //获取单词释义字符串
    public function getWordsText($row){
        $str = '';
        $wordsKeys = array('words_n','words_pron','words_adj','words_num','words_v','words_adv','words_art','words_prep','words_conj','words_int','words_vt','words_vi','words_other',);
        foreach ($wordsKeys as $key){
            if (!empty($row[$key])){
                $arr = explode('_', $key);
                $str .= $arr[1].'.'.$row[$key];
            }
        }
        return $str;
    }
    
    private function returnData($data){
        header('Content-Type:application/json; charset=utf-8');
        header("Access-Control-Allow-Origin: *");
        exit(json_encode($data));
    }
}