Order.php 7.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237
  1. <?php
  2. namespace app\admin\model\shop;
  3. use addons\shop\library\RefundException;
  4. use think\Exception;
  5. use think\Model;
  6. use traits\model\SoftDelete;
  7. use app\admin\model\shop\OrderAction;
  8. use addons\epay\library\Service;
  9. use Yansongda\Pay\Pay;
  10. use think\Log;
  11. use app\common\Enum\OrderEnum;
  12. use app\common\Enum\StatusEnum;
  13. use app\common\Service\Order\OrderGoodsService;
  14. use app\common\Enum\PayEnum;
  15. class Order extends Model
  16. {
  17. use SoftDelete;
  18. // 表名
  19. protected $name = 'shop_order';
  20. // 自动写入时间戳字段
  21. protected $autoWriteTimestamp = 'int';
  22. // 定义时间戳字段名
  23. protected $createTime = 'createtime';
  24. protected $updateTime = 'updatetime';
  25. protected $deleteTime = 'deletetime';
  26. // 追加属性
  27. protected $append = [
  28. 'expiretime_text',
  29. 'paytime_text',
  30. 'refund_time_text',
  31. 'shipping_time_text',
  32. 'receive_time_text',
  33. 'cancel_time_text',
  34. 'status_text',
  35. 'order_status_text',
  36. 'pay_type_text',
  37. ];
  38. public function getOrderStatusList()
  39. {
  40. return OrderEnum::getOrderStatusList();
  41. }
  42. public function getStatusList()
  43. {
  44. return StatusEnum::getMap();
  45. }
  46. public function getExpiretimeTextAttr($value, $data)
  47. {
  48. $value = $value ?: ($data['expiretime'] ?? '');
  49. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  50. }
  51. public function getPaytimeTextAttr($value, $data)
  52. {
  53. $value = $value ?: ($data['paytime'] ?? '');
  54. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  55. }
  56. public function getRefundtimeTextAttr($value, $data)
  57. {
  58. $value = $value ?: ($data['refundtime'] ?? '');
  59. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  60. }
  61. public function getShippingtimeTextAttr($value, $data)
  62. {
  63. $value = $value ?: ($data['shippingtime'] ?? '');
  64. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  65. }
  66. public function getReceivetimeTextAttr($value, $data)
  67. {
  68. $value = $value ?: ($data['receivetime'] ?? '');
  69. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  70. }
  71. public function getCanceltimeTextAttr($value, $data)
  72. {
  73. $value = $value ?: ($data['canceltime'] ?? '');
  74. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  75. }
  76. public function getOrderStatusTextAttr($value, $data)
  77. {
  78. $value = $value ?: ($data['order_status'] ?? '');
  79. $list = $this->getOrderStatusList();
  80. return $list[$value] ?? '';
  81. }
  82. public function getStatusTextAttr($value, $data)
  83. {
  84. $value = $value ?: ($data['status'] ?? '');
  85. $list = $this->getStatusList();
  86. return $list[$value] ?? '';
  87. }
  88. public function getPayTypeTextAttr($value, $data)
  89. {
  90. $value = $value ?: ($data['pay_type'] ?? '');
  91. return PayEnum::getPayMethodText($value);
  92. }
  93. protected function setExpiretimeAttr($value)
  94. {
  95. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  96. }
  97. protected function setPaytimeAttr($value)
  98. {
  99. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  100. }
  101. protected function setRefundtimeAttr($value)
  102. {
  103. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  104. }
  105. protected function setShippingtimeAttr($value)
  106. {
  107. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  108. }
  109. protected function setReceivetimeAttr($value)
  110. {
  111. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  112. }
  113. protected function setCanceltimeAttr($value)
  114. {
  115. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  116. }
  117. public static function init()
  118. {
  119. self::afterWrite(function ($row) {
  120. $changeData = $row->getChangedData();
  121. if (isset($changeData['order_status'])) {
  122. if ($changeData['order_status'] == OrderEnum::STATUS_SHIP) {
  123. OrderGoodsService::setGoodsSalesInc($row->order_sn);
  124. }
  125. OrderAction::push($row->order_sn, $changeData['order_status'] == OrderEnum::STATUS_PAY ? '更改订单为已支付' : '更改订单为未支付', '管理员');
  126. }
  127. if (isset($changeData['order_status'])) {
  128. switch ($changeData['order_status']) {
  129. case OrderEnum::STATUS_SHIP:
  130. $memo = '订单发货成功';
  131. break;
  132. case OrderEnum::STATUS_CONFIRM:
  133. $memo = '更改订单已收货';
  134. break;
  135. default:
  136. $memo = '更改订单待发货';
  137. }
  138. OrderAction::push($row->order_sn, $memo, '管理员');
  139. }
  140. if (isset($changeData['order_status'])) {
  141. $memo = '';
  142. switch ($changeData['order_status']) {
  143. case OrderEnum::STATUS_CREATE:
  144. OrderAction::push($row->order_sn, '更改订单为正常', '管理员');
  145. break;
  146. case OrderEnum::STATUS_CANCEL:
  147. //已取消,库存恢复
  148. OrderGoodsService::setGoodsStocksInc($row->order_sn);
  149. // //恢复优惠券
  150. // UserCoupon::resetUserCoupon($row->user_coupon_id, $row->order_sn);
  151. OrderAction::push($row->order_sn, '订单取消成功', '管理员');
  152. break;
  153. case OrderEnum::STATUS_ADMIN_CANCEL:
  154. OrderAction::push($row->order_sn, '更改订单为已失效', '管理员');
  155. break;
  156. case OrderEnum::STATUS_AUTO_CONFIRM:
  157. //结束,订单完成,给积分
  158. // $config = get_addon_config('shop');
  159. // if (isset($config['money_score']) && $config['money_score'] > 0 && $row->shippingstate == 2 && $row->paystate == 1) {
  160. // //减去退款金额
  161. // $refund = OrderAftersales::where('order_id', $row->id)->where('type', '<>', 3)->where('status', 2)->sum('refund');
  162. // $money = bcsub($row['payamount'], $refund, 2);
  163. // if ($money > 0) {
  164. // $score = bcmul($money, $config['money_score']);
  165. // \app\common\model\User::score($score, $row['user_id'], '完成订单奖励' . $score . '积分');
  166. // }
  167. // }
  168. // OrderAction::push($row->order_sn, '更改订单为已完成', '管理员');
  169. break;
  170. }
  171. }
  172. });
  173. }
  174. public function User()
  175. {
  176. return $this->hasOne('\\app\\common\\model\\User', 'id', 'user_id', [], 'LEFT');
  177. }
  178. public function OrderAddress()
  179. {
  180. return $this->hasOne('\\app\\common\\model\\OrderAddress', 'order_id', 'id', [], 'LEFT');
  181. }
  182. public function OrderGoods()
  183. {
  184. return $this->hasMany('OrderGoods', 'order_id', 'id');
  185. }
  186. public function OrderAction()
  187. {
  188. return $this->hasMany('OrderAction', 'order_sn', 'order_sn');
  189. }
  190. public function OrderProfile()
  191. {
  192. return $this->hasOne('\\app\\common\\model\\OrderProfile', 'order_id', 'id', [], 'LEFT');
  193. }
  194. }