CinemaOrderDetail.php 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. <?php
  2. namespace app\admin\model;
  3. use support\Db;
  4. use support\Model;
  5. /**
  6. * 悦活影院订单详情
  7. * Class Users
  8. * @package app\admin\model
  9. */
  10. class CinemaOrderDetail extends Model
  11. {
  12. /**
  13. *
  14. * The table associated with the model.
  15. *
  16. * @var string
  17. */
  18. protected $table = 'life_cinema_order_detail';
  19. public $timestamps = false;
  20. /**
  21. * Notes:获取产品列表
  22. * @param string $keywords
  23. * @param int $page
  24. * @param int $limit
  25. * @return array
  26. * User: ZQ
  27. * Date: 2022/10/13
  28. */
  29. public static function getOrderList(int $page, int $limit,$keywords)
  30. {
  31. $list = static::select('*')
  32. ->with(['user'])
  33. ->when($keywords != '', function ($query) use ($keywords){
  34. $query->where('order_sn', 'like', '%' . $keywords . '%');
  35. })
  36. ->orderBy('order_create_time','DESC')
  37. ->forPage($page, $limit)
  38. ->get();
  39. $count = static::when($keywords != '', function ($query) use ($keywords){
  40. $query->where('order_sn', 'like', '%' . $keywords . '%');
  41. })->count();
  42. return [$list, $count];
  43. }
  44. public function Attr(){
  45. return $this->hasMany(MedicalCareProductAttr::class,'attr_product_id','product_id')->where(['attr_is_delete'=>0]);
  46. }
  47. //关联店铺
  48. public function Shop(){
  49. return $this->belongsTo(MerchantShop::class,'order_shop_id','shop_id');
  50. }
  51. //获取器修改产品标签
  52. public function User(){
  53. return $this->belongsTo(User::class,'order_user_id','user_id');
  54. }
  55. }