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

<?php
namespace Api\Controller;
use Common\Controller\ApiController;
class WebController extends ApiController {
    public function __construct(){
        parent::__construct();
    }
    
    /**
     * 我添加的课程
     */
    public function myAddCourse(){
        $sort = I('sort',1);
        $page = I('page');
        $keyword = I('keyword','','trim');
        $pageSize = I('page_size',10);
        $condition = array(
            'uw.user_id'=>$this->userId,
            'uw.is_delete'=>1,
            'uw.is_show'=>1,
            //'c.course_status'=>3,
            'c.course_flag'=>1,
            'c.is_delete'=>1,
        );
        if (!empty($keyword)){
            $condition['course_name'] = array('LIKE','%'.$keyword.'%');
        }
        $join = 'uw LEFT JOIN t_course c ON uw.course_id=c.course_id';
        $field = 'c.course_id,c.user_id,c.course_name,c.course_num,c.course_join,c.course_flag,c.course_status,uw.operate_dt,uw.uw_id,uw.uw_type';
        $count = M('UserWords')->join($join)->where($condition)->count();
        $res1 = M('UserWords')->join($join)->where($condition)->field($field)->order('uw_id desc')->page($page,$pageSize)->select();
        $res = array();
        foreach ($res1 as $r){
            if ($r['course_name']=='易错单词' || $r['course_name']=='重点单词'){
                $r['is_special'] = 1;
            }else{
                $r['is_special'] = 0;
            }
            $r['is_add'] = 1;
            $res[] = $r;
        }
        $data = array('code'=>0,'msg'=>'','data'=>['total'=>$count,'list'=>$res]);
        $this->returnData($data);exit;
    }

    /**
     * 我上传的课程
     */
    public function myUpCourse(){
        $sort = I('sort',1);
        $page = I('page');
        $keyword = I('keyword','','trim');
        $pageSize = I('page_size',10);
        $courseStatus = I('course_status');
        $condition = array('is_delete'=>1,'user_id'=>$this->userId,'is_show'=>1);
        if (!empty($keyword)){
            $condition['course_name'] = array('LIKE','%'.$keyword.'%');
        }
        if (!empty($courseStatus) && $courseStatus==1){
            $condition['course_status'] = array('IN','2,3');
        }
        //$count = M('Course')->where($condition)->count();
        $orderby = '';
        if ($sort==1){
            $orderby = 'course_join desc';
        }else if($sort==2){
            $orderby = 'course_id desc';
        }
        $count = M('Course')->where($condition)->count();
        $field = 'course_id,user_id,course_flag,course_name,course_join,course_num,course_source,operate_dt';
        $res = M('Course')->where($condition)->field($field)->order($orderby)->page($page,$pageSize)->select();
        foreach ($res as $key=>$row){
            $res[$key]['is_add'] = 1;
        }
        $data = array('code'=>0,'msg'=>'','data'=>['total'=>$count,'list'=>$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 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();
        $userWordsRes = $this->square();
        foreach ($res as $key=>$row){
            if (in_array($row['course_id'], $userWordsRes) || $row['user_id']==$this->userId){
                $res[$key]['is_add'] = 1;
            }else{
                $res[$key]['is_add'] = 0;
            }
        }
        $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();
        $userWordsRes = $this->square();
        foreach ($res as $key=>$row){
            if (in_array($row['course_id'], $userWordsRes) || $row['user_id']==$this->userId){
                $res[$key]['is_add'] = 1;
            }else{
                $res[$key]['is_add'] = 0;
            }
        }
        $data = array('code'=>0,'msg'=>'','data'=>['total'=>$count,'list'=>$res]);
        $this->returnData($data);exit;
    }
}