Order.php 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275
  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_mode_text',
  37. 'pay_type_text',
  38. ];
  39. public function getOrderStatusList()
  40. {
  41. return OrderEnum::getOrderStatusList();
  42. }
  43. public function getStatusList()
  44. {
  45. return StatusEnum::getMap();
  46. }
  47. public function getExpiretimeTextAttr($value, $data)
  48. {
  49. $value = $value ?: ($data['expiretime'] ?? '');
  50. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  51. }
  52. public function getPaytimeTextAttr($value, $data)
  53. {
  54. $value = $value ?: ($data['paytime'] ?? '');
  55. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  56. }
  57. public function getRefundtimeTextAttr($value, $data)
  58. {
  59. $value = $value ?: ($data['refundtime'] ?? '');
  60. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  61. }
  62. public function getShippingtimeTextAttr($value, $data)
  63. {
  64. $value = $value ?: ($data['shippingtime'] ?? '');
  65. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  66. }
  67. public function getReceivetimeTextAttr($value, $data)
  68. {
  69. $value = $value ?: ($data['receivetime'] ?? '');
  70. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  71. }
  72. public function getCanceltimeTextAttr($value, $data)
  73. {
  74. $value = $value ?: ($data['canceltime'] ?? '');
  75. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  76. }
  77. public function getOrderStatusTextAttr($value, $data)
  78. {
  79. $value = $value ?: ($data['order_status'] ?? '');
  80. $list = $this->getOrderStatusList();
  81. return $list[$value] ?? '';
  82. }
  83. public function getStatusTextAttr($value, $data)
  84. {
  85. $value = $value ?: ($data['status'] ?? '');
  86. $list = $this->getStatusList();
  87. return $list[$value] ?? '';
  88. }
  89. public function getPayModeTextAttr($value, $data)
  90. {
  91. $value = $value ?: ($data['pay_mode'] ?? '');
  92. return OrderEnum::getPayModeText($value);
  93. }
  94. public function getPayTypeTextAttr($value, $data)
  95. {
  96. $value = $value ?: ($data['pay_type'] ?? '');
  97. return PayEnum::getPayMethodText($value);
  98. }
  99. protected function setExpiretimeAttr($value)
  100. {
  101. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  102. }
  103. protected function setPaytimeAttr($value)
  104. {
  105. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  106. }
  107. protected function setRefundtimeAttr($value)
  108. {
  109. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  110. }
  111. protected function setShippingtimeAttr($value)
  112. {
  113. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  114. }
  115. protected function setReceivetimeAttr($value)
  116. {
  117. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  118. }
  119. protected function setCanceltimeAttr($value)
  120. {
  121. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  122. }
  123. public static function init()
  124. {
  125. self::afterWrite(function ($row) {
  126. $changeData = $row->getChangedData();
  127. if (isset($changeData['order_status'])) {
  128. if ($changeData['order_status'] == OrderEnum::STATUS_SHIP) {
  129. OrderGoodsService::setGoodsSalesInc($row->order_sn);
  130. }
  131. OrderAction::push($row->order_sn, $changeData['order_status'] == OrderEnum::STATUS_PAY ? '更改订单为已支付' : '更改订单为未支付', '管理员');
  132. }
  133. if (isset($changeData['order_status'])) {
  134. switch ($changeData['order_status']) {
  135. case OrderEnum::STATUS_SHIP:
  136. $memo = '订单发货成功';
  137. break;
  138. case OrderEnum::STATUS_CONFIRM:
  139. $memo = '更改订单已收货';
  140. break;
  141. default:
  142. $memo = '更改订单待发货';
  143. }
  144. OrderAction::push($row->order_sn, $memo, '管理员');
  145. }
  146. if (isset($changeData['order_status'])) {
  147. $memo = '';
  148. switch ($changeData['order_status']) {
  149. case OrderEnum::STATUS_CREATE:
  150. OrderAction::push($row->order_sn, '更改订单为正常', '管理员');
  151. break;
  152. case OrderEnum::STATUS_CANCEL:
  153. //已取消,库存恢复
  154. OrderGoodsService::setGoodsStocksInc($row->order_sn);
  155. // //恢复优惠券
  156. // UserCoupon::resetUserCoupon($row->user_coupon_id, $row->order_sn);
  157. OrderAction::push($row->order_sn, '订单取消成功', '管理员');
  158. break;
  159. case OrderEnum::STATUS_ADMIN_CANCEL:
  160. OrderAction::push($row->order_sn, '更改订单为已失效', '管理员');
  161. break;
  162. case OrderEnum::STATUS_AUTO_CONFIRM:
  163. //结束,订单完成,给积分
  164. // $config = get_addon_config('shop');
  165. // if (isset($config['money_score']) && $config['money_score'] > 0 && $row->shippingstate == 2 && $row->paystate == 1) {
  166. // //减去退款金额
  167. // $refund = OrderAftersales::where('order_id', $row->id)->where('type', '<>', 3)->where('status', 2)->sum('refund');
  168. // $money = bcsub($row['payamount'], $refund, 2);
  169. // if ($money > 0) {
  170. // $score = bcmul($money, $config['money_score']);
  171. // \app\common\model\User::score($score, $row['user_id'], '完成订单奖励' . $score . '积分');
  172. // }
  173. // }
  174. // OrderAction::push($row->order_sn, '更改订单为已完成', '管理员');
  175. break;
  176. }
  177. }
  178. });
  179. }
  180. /**
  181. * 退款
  182. */
  183. public static function refund($order_sn, $paytype, $payamount)
  184. {
  185. $config = Service::getConfig($paytype);
  186. try {
  187. $order = Order::getByOrderSn($order_sn);
  188. if ($paytype == 'wechat') {
  189. $response = Pay::wechat($config)->refund([
  190. 'type' => in_array($order['method'], ['miniapp', 'app']) ? $order['method'] : '',
  191. 'out_trade_no' => $order_sn,
  192. 'out_refund_no' => time(),
  193. 'total_fee' => bcmul($order['payamount'], 100),
  194. 'refund_fee' => bcmul($payamount, 100)
  195. ]);
  196. if (!$response['result_code'] || $response['result_code'] != 'SUCCESS') {
  197. throw new \Exception(($response['err_code'] ?? '') . ':' . ($response['err_code_des'] ?? '未知退款错误'));
  198. }
  199. } elseif ($paytype == 'alipay') {
  200. $response = Pay::alipay($config)->refund([
  201. 'out_trade_no' => $order_sn,
  202. 'refund_amount' => $payamount,
  203. ]);
  204. if (!$response['code'] || $response['code'] != '10000') {
  205. throw new \Exception(($response['code'] ?? '') . ':' . ($response['msg'] ?? '未知退款错误'));
  206. }
  207. }
  208. } catch (\Exception $e) {
  209. Log::write("[shop][refund][{$order_sn}]同步退款失败,失败原因:" . $e->getMessage(), 'refund');
  210. throw new \Exception("同步退款失败,失败原因:" . $e->getMessage());
  211. }
  212. //发送通知
  213. // TemplateMsg::sendTempMsg(2, $order_sn);
  214. return true;
  215. }
  216. public function User()
  217. {
  218. return $this->hasOne('\\app\\common\\model\\User', 'id', 'user_id', [], 'LEFT');
  219. }
  220. public function OrderAddress()
  221. {
  222. return $this->hasOne('\\app\\common\\model\\OrderAddress', 'order_id', 'id', [], 'LEFT');
  223. }
  224. public function OrderGoods()
  225. {
  226. return $this->hasMany('OrderGoods', 'order_id', 'id');
  227. }
  228. public function OrderAction()
  229. {
  230. return $this->hasMany('OrderAction', 'order_sn', 'order_sn');
  231. }
  232. }