Userproduct.php 662 B

123456789101112131415161718192021222324252627282930
  1. <?php
  2. namespace app\admin\model;
  3. use think\Model;
  4. class Userproduct extends Model
  5. {
  6. public function getUserproduct($condition)
  7. {
  8. $select = [
  9. 'userProduct_dayNumber',
  10. 'userProduct_buyTime',
  11. 'userProduct_identity',
  12. 'userProduct_maturityTime',
  13. 'user_email',
  14. 'product_name',
  15. ];
  16. $result = $this
  17. ->field($select)
  18. ->alias('a')
  19. ->join('user b', 'a.user_id = b.user_id')
  20. ->join('product c', 'a.product_id = c.product_id')
  21. ->where($condition)
  22. ->paginate(10);
  23. return $result;
  24. }
  25. }