FeedbackModel.class.php 942 B

123456789101112131415161718192021
  1. <?php
  2. namespace Admin\Model;
  3. use Think\Model;
  4. class FeedbackModel extends Model{
  5. public function getFbList($condition, $page, $pageSize){
  6. $condition[] = 'A.words_id = B.words_id';
  7. $condition[] = 'A.course_id = C.course_id';
  8. $condition[] = 'A.user_id = D.user_id';
  9. $condition['A.is_delete'] = 1;
  10. $fields = 'A.*,B.words_name,C.course_name,D.user_name,D.user_phone';
  11. 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();
  12. }
  13. public function getFbSysList($condition, $page, $pageSize){
  14. $condition[] = 'A.user_id = D.user_id';
  15. $condition['A.is_delete'] = 1;
  16. $fields = 'A.*,D.user_name,D.user_phone';
  17. return $this->table('t_feedback A ,t_user D')->where($condition)->field($fields)->order('fb_id desc')->limit($page, $pageSize)->select();
  18. }
  19. }