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; } }