danci/www.hanlinyuanonline.com/Application/Api/Model/CourseModel.class.php

<?php
namespace Api\Model;
use Think\Model;

class CourseModel extends Model{
    /* public function getCourseList($condition, $pageSize, $orderby){
        $join = array(
            'LEFT JOIN t_user B ON t_course.user_id=B.user_id ',
            'LEFT JOIN t_user_words C ON t_course.course_id=C.course_id'
        );
        $condition['t_course.is_delete'] = 1;
        $fields = 't_course.course_id,t_course.user_id,t_course.course_name,t_course.course_num,t_course.course_join,t_course.course_source,t_course.operate_dt,B.user_name,B.user_phone,C.uw_id as is_join';
        return $this->join($join)->where($condition)->field($fields)->order($orderby)->limit($pageSize)->select();
    } */
    
    public function  getCourseList($condition, $pageSize, $orderby, $userId){
        $condition['is_delete']=1;
        $res = M('Course')->where($condition)->field('course_id,user_id,course_flag,course_name,course_join,course_num,course_source,operate_dt')
                                    ->order($orderby)->limit($pageSize)->select();
        /* $unShowRes = M('UserWords')->where(array('user_id'=>$userId,'is_show'=>2))->field('course_id')->find();
        if (function_exists('array_column')){
            $courseIdArr = array_column($unShowRes, 'course_id');
        }else{
            foreach ($unShowRes as $r){
                $courseIdArr[] = $r['course_id'];
            }
        } */
        $userInfo = array();
        foreach ($res as $key=>$row){
            if (1==2 && $row['course_source']==1){
                $res[$key]['user_name'] = '系统课程';
                $res[$key]['user_icon'] = C('DOMAIN').'/Public/img/admin_icon.png';
                //$res[$key]['user_icon'] = '/Public/img/admin_icon.png';
                $res[$key]['user_city'] = '';
                $res[$key]['user_province'] = '';
            }else{
                /* if (in_array($row['course_id'], $courseIdArr)){
                    unset($res[$key]);
                    continue;
                } */
                if (isset($userInfo[$row['user_id']])){
                    $info = $userInfo[$row['user_id']];
                }else{
                    $info = M('User')->where(array('user_id'=>$row['user_id']))->field('user_name,user_phone,user_icon,user_city,user_province')->find();
                    $userInfo[$row['user_id']] = $info;
                }
                $res[$key]['user_name'] = $info['user_name'];
                $res[$key]['user_phone'] = $info['user_phone'];
                $res[$key]['user_icon'] = $info['user_icon'];
                $res[$key]['user_city'] = $info['user_city'];
                $res[$key]['user_province'] = $info['user_province'];
            }
        }
        return $res;
    }
}