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

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

class NotepadModel extends Model{
    /* public function getNotepadeList($condition, $page, $pageSize, $orderby){
        $condition[] = 'A.user_id = B.user_id';
        $condition['A.is_delete'] = 1;
        $condition['A.course_flag'] = 2;
        $fields = 'A.*,B.user_name,B.user_nickname,B.user_phone';
        return $this->table('t_course A, t_user B')->where($condition)->field($fields)->order($orderby)->limit($page, $pageSize)->select();
    } */
    public function  getNotepadeList($condition, $page, $pageSize, $orderby){
        $condition['is_delete']=1;
        $res = M('Course')->where($condition)->field('course_id,course_status,user_id,course_flag,course_name,course_join,course_num,course_source,operate_dt')
        ->order($orderby)->limit($page, $pageSize)->select();
        $userInfo = array();
        foreach ($res as $key=>$row){
            if ($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 (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;
    }
}