ProductOrder.php 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  1. <?php
  2. namespace app\common\model;
  3. use think\Model;
  4. class ProductOrder extends Model
  5. {
  6. // 表名
  7. protected $table = 'product_order';
  8. // 自动写入时间戳字段
  9. protected $autoWriteTimestamp = 'int';
  10. // 定义时间戳字段名
  11. protected $createTime = 'create_time';
  12. protected $updateTime = 'update_time';
  13. protected $deleteTime = false;
  14. // 追加属性
  15. protected $append = [
  16. 'create_time_text',
  17. 'update_time_text'
  18. ];
  19. const Ordered = 0;
  20. const Paid = 1;
  21. const Transferred = 2;
  22. const Shipped = 3;
  23. const Cancelled = 4;
  24. const Closure = 5;
  25. const Popular = 0; //热销
  26. const Transfer = 1; //转让
  27. const Giveaway = 2; //赠送
  28. /*
  29. * 订单状态 '已下单', 1=>'已付款', 2=>'已转让', 3=>'提货', 4=>'已取消', 5=>'完成'];
  30. */
  31. public $order_status = [
  32. '-1' => '全部',
  33. self::Ordered => '已下单',
  34. self::Paid => '已付款',
  35. self::Transferred => '已转让',
  36. self::Shipped => '提货',
  37. self::Cancelled => '已取消',
  38. self::Closure => '关闭',
  39. ];
  40. /**
  41. * @param int $orderId 订单id
  42. * @param array $orderInfo 订单详情
  43. * @param int $typeId 订单类型
  44. * @param int $userId 用户id
  45. * @param int $fromUser 来源id
  46. * @param float $fees 手续费
  47. * @param float $fees 抢购价
  48. */
  49. public static function setCreateOrder(int $orderId, $orderInfo, $typeId, $userId, $fromUser, string $orderNo, float $fees, float $price): object
  50. {
  51. return self::create([
  52. 'order_id' => $orderId,
  53. 'product_id' => $orderInfo['product_id'],
  54. 'type_id' => $typeId,
  55. 'status' => self::Paid,
  56. 'area_id' => $orderInfo['area_id'],
  57. 'order_no' => $orderNo,
  58. 'user_id' => $userId,
  59. 'from_user' => $fromUser,
  60. 'price' => $orderInfo['price'],
  61. 'popular_price'=> $price,
  62. 'fees' => $fees,
  63. 'num' => 1
  64. ]);
  65. }
  66. public static function getStatusList()
  67. {
  68. return [self::Ordered => __('已下单'), self::Paid => __('已付款'), self::Transferred => __('已转让'),
  69. self::Shipped => __('提货'), self::Cancelled => __('已取消'), self::Closure => __('关闭')];
  70. }
  71. //全部类型:
  72. public static function getStatusAll()
  73. {
  74. return [
  75. ['type_id'=>self::Popular, 'status'=> self::Paid, 'text' => __('已购买')],
  76. ['type_id'=>self::Transfer, 'status'=> self::Transferred,'text' => __('转让中')],
  77. ['type_id'=>self::Giveaway, 'status'=> self::Closure, 'text' => __('已赠送')],
  78. ['type_id'=>self::Transfer, 'status'=> self::Closure, 'text' => __('已转让')],
  79. ['type_id'=>self::Popular, 'status' => self::Shipped, 'text' => __('已提货')],
  80. ['type_id'=>self::Transfer, 'status'=> self::Cancelled,'text' => __('已取消')]
  81. ];
  82. }
  83. //产品
  84. public function products()
  85. {
  86. return $this->hasOne('ProductLists', 'id', 'product_id', [], 'LEFT')->setEagerlyType(0);
  87. }
  88. //用户 user_id
  89. public function users()
  90. {
  91. return $this->hasOne('UserModel', 'id', 'user_id', [], 'LEFT')->setEagerlyType(0);
  92. }
  93. //区域
  94. public function areas()
  95. {
  96. return $this->hasOne('ProductArea', 'id', 'area_id', [], 'LEFT')->setEagerlyType(0);
  97. }
  98. //提货地址
  99. public function address()
  100. {
  101. return $this->hasOne('UserArea', 'order_id', 'id', [], 'LEFT')->setEagerlyType(0);
  102. }
  103. public function getCreateTimeTextAttr($value, $data)
  104. {
  105. $value = $value ? $value : (isset($data['create_time']) ? $data['create_time'] : '');
  106. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  107. }
  108. public function getUpdateTimeTextAttr($value, $data)
  109. {
  110. $value = $value ? $value : (isset($data['update_time']) ? $data['update_time'] : '');
  111. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  112. }
  113. protected function setCreateTimeAttr($value)
  114. {
  115. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  116. }
  117. protected function setUpdateTimeAttr($value)
  118. {
  119. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  120. }
  121. }