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

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

class NotepadModel extends Model{
    public function getNotepadList($condition, $pageSize, $orderby){
        $condition['is_delete']=1;
        $res = M('Course')->where($condition)->field('course_id,user_id,course_flag,course_name,course_join,course_content,course_source,operate_dt')
                                    ->order($orderby)->limit($pageSize)->select();
        $userInfo = array();
        foreach ($res as $key=>$row){
            if (1==2 && $row['course_source']==1){
                $res[$key]['user_name'] = '系统自由记';
                //$res[$key]['user_icon'] = '/Public/img/admin_icon.png';
                $res[$key]['user_icon'] = C('DOMAIN').'/Public/img/admin_icon.png';
                $res[$key]['user_city'] = '';
                $res[$key]['user_province'] = '';
            }else{
                if (isset($userInfo[$row['user_id']])){
                    $info = $userInfo[$row['user_id']];
                    //$res[$key]['user_icon'] = '/Public/img/admin_icon.png';
                    $res[$key]['user_icon'] = C('DOMAIN').'/Public/img/admin_icon.png';
                    $res[$key]['user_city'] = '';
                    $res[$key]['user_province'] = '';
                }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;
    }
    /* public function getNotepadList($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();
    } */
}