CourseModel.class.php 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. namespace Admin\Model;
  3. use Think\Model;
  4. class CourseModel extends Model{
  5. /* public function getCourseList($condition, $page, $pageSize, $orderby){
  6. $condition[] = 'A.user_id = B.user_id';
  7. $condition['A.is_delete'] = 1;
  8. $fields = 'A.*,B.user_name,B.user_nickname,B.user_phone';
  9. return $this->table('t_course A, t_user B')->where($condition)->field($fields)->order($orderby)->limit($page, $pageSize)->select();
  10. } */
  11. public function getCourseList($condition, $page, $pageSize, $orderby){
  12. $condition['is_delete']=1;
  13. $res = M('Course')->where($condition)->field('course_id,course_status,user_id,course_flag,course_name,course_join,course_num,course_source,operate_dt')
  14. ->order($orderby)->limit($page, $pageSize)->select();
  15. $userInfo = array();
  16. foreach ($res as $key=>$row){
  17. if ($row['course_source']==1){
  18. $res[$key]['user_name'] = '系统课程';
  19. //$res[$key]['user_icon'] = C('DOMAIN').'/Public/img/admin_icon.png';
  20. $res[$key]['user_icon'] = '/Public/img/admin_icon.png';
  21. $res[$key]['user_city'] = '';
  22. $res[$key]['user_province'] = '';
  23. }else{
  24. if (isset($userInfo[$row['user_id']])){
  25. $info = $userInfo[$row['user_id']];
  26. }else{
  27. $info = M('User')->where(array('user_id'=>$row['user_id']))->field('user_name,user_phone,user_icon,user_city,user_province')->find();
  28. $userInfo[$row['user_id']] = $info;
  29. }
  30. $res[$key]['user_name'] = $info['user_name'];
  31. $res[$key]['user_phone'] = $info['user_phone'];
  32. $res[$key]['user_icon'] = $info['user_icon'];
  33. $res[$key]['user_city'] = $info['user_city'];
  34. $res[$key]['user_province'] = $info['user_province'];
  35. }
  36. }
  37. return $res;
  38. }
  39. }