123456789101112131415161718192021 |
- <?php
- namespace Admin\Model;
- use Think\Model;
- class FeedbackModel extends Model{
- public function getFbList($condition, $page, $pageSize){
- $condition[] = 'A.words_id = B.words_id';
- $condition[] = 'A.course_id = C.course_id';
- $condition[] = 'A.user_id = D.user_id';
- $condition['A.is_delete'] = 1;
- $fields = 'A.*,B.words_name,C.course_name,D.user_name,D.user_phone';
- return $this->table('t_feedback A, t_words B, t_course C,t_user D')->where($condition)->field($fields)->order('fb_id desc')->limit($page, $pageSize)->select();
- }
-
- public function getFbSysList($condition, $page, $pageSize){
- $condition[] = 'A.user_id = D.user_id';
- $condition['A.is_delete'] = 1;
- $fields = 'A.*,D.user_name,D.user_phone';
- return $this->table('t_feedback A ,t_user D')->where($condition)->field($fields)->order('fb_id desc')->limit($page, $pageSize)->select();
- }
- }
|