Order.php 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283
  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 addons\shop\model\TemplateMsg;
  12. use addons\shop\model\UserCoupon;
  13. class Order extends Model
  14. {
  15. use SoftDelete;
  16. // 表名
  17. protected $name = 'shop_order';
  18. // 自动写入时间戳字段
  19. protected $autoWriteTimestamp = 'int';
  20. // 定义时间戳字段名
  21. protected $createTime = 'createtime';
  22. protected $updateTime = 'updatetime';
  23. protected $deleteTime = 'deletetime';
  24. // 追加属性
  25. protected $append = [
  26. 'expiretime_text',
  27. 'paytime_text',
  28. 'refundtime_text',
  29. 'shippingtime_text',
  30. 'receivetime_text',
  31. 'canceltime_text',
  32. 'orderstate_text',
  33. 'shippingstate_text',
  34. 'paystate_text',
  35. 'status_text'
  36. ];
  37. public function getOrderstateList()
  38. {
  39. return ['0' => __('Orderstate 0'), '1' => __('Orderstate 1'), '2' => __('Orderstate 2'), '3' => __('Orderstate 3'), '4' => __('Orderstate 4')];
  40. }
  41. public function getShippingstateList()
  42. {
  43. return ['0' => __('Shippingstate 0'), '1' => __('Shippingstate 1'), '2' => __('Shippingstate 2')];
  44. }
  45. public function getPaystateList()
  46. {
  47. return ['0' => __('Paystate 0'), '1' => __('Paystate 1')];
  48. }
  49. public function getStatusList()
  50. {
  51. return ['normal' => __('Status normal'), 'hidden' => __('Status hidden')];
  52. }
  53. public function getExpiretimeTextAttr($value, $data)
  54. {
  55. $value = $value ?: ($data['expiretime'] ?? '');
  56. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  57. }
  58. public function getPaytimeTextAttr($value, $data)
  59. {
  60. $value = $value ?: ($data['paytime'] ?? '');
  61. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  62. }
  63. public function getRefundtimeTextAttr($value, $data)
  64. {
  65. $value = $value ?: ($data['refundtime'] ?? '');
  66. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  67. }
  68. public function getShippingtimeTextAttr($value, $data)
  69. {
  70. $value = $value ?: ($data['shippingtime'] ?? '');
  71. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  72. }
  73. public function getReceivetimeTextAttr($value, $data)
  74. {
  75. $value = $value ?: ($data['receivetime'] ?? '');
  76. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  77. }
  78. public function getCanceltimeTextAttr($value, $data)
  79. {
  80. $value = $value ?: ($data['canceltime'] ?? '');
  81. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  82. }
  83. public function getOrderstateTextAttr($value, $data)
  84. {
  85. $value = $value ?: ($data['orderstate'] ?? '');
  86. $list = $this->getOrderstateList();
  87. return $list[$value] ?? '';
  88. }
  89. public function getShippingstateTextAttr($value, $data)
  90. {
  91. $value = $value ?: ($data['shippingstate'] ?? '');
  92. $list = $this->getShippingstateList();
  93. return $list[$value] ?? '';
  94. }
  95. public function getPaystateTextAttr($value, $data)
  96. {
  97. $value = $value ?: ($data['paystate'] ?? '');
  98. $list = $this->getPaystateList();
  99. return $list[$value] ?? '';
  100. }
  101. public function getStatusTextAttr($value, $data)
  102. {
  103. $value = $value ?: ($data['status'] ?? '');
  104. $list = $this->getStatusList();
  105. return $list[$value] ?? '';
  106. }
  107. protected function setExpiretimeAttr($value)
  108. {
  109. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  110. }
  111. protected function setPaytimeAttr($value)
  112. {
  113. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  114. }
  115. protected function setRefundtimeAttr($value)
  116. {
  117. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  118. }
  119. protected function setShippingtimeAttr($value)
  120. {
  121. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  122. }
  123. protected function setReceivetimeAttr($value)
  124. {
  125. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  126. }
  127. protected function setCanceltimeAttr($value)
  128. {
  129. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  130. }
  131. public static function init()
  132. {
  133. self::afterWrite(function ($row) {
  134. $changeData = $row->getChangedData();
  135. if (isset($changeData['paystate'])) {
  136. if ($changeData['paystate'] == 1) {
  137. \addons\shop\model\OrderGoods::setGoodsSalesInc($row->order_sn);
  138. }
  139. OrderAction::push($row->order_sn, $changeData['paystate'] == 1 ? '更改订单为已支付' : '更改订单为未支付', '管理员');
  140. }
  141. if (isset($changeData['shippingstate'])) {
  142. switch ($changeData['shippingstate']) {
  143. case 1:
  144. //发送通知
  145. TemplateMsg::sendTempMsg(1, $row->order_sn);
  146. $memo = '订单发货成功';
  147. break;
  148. case 2:
  149. $memo = '更改订单已收货';
  150. break;
  151. default:
  152. $memo = '更改订单待发货';
  153. }
  154. OrderAction::push($row->order_sn, $memo, '管理员');
  155. }
  156. if (isset($changeData['orderstate'])) {
  157. $memo = '';
  158. switch ($changeData['orderstate']) {
  159. case 0:
  160. OrderAction::push($row->order_sn, '更改订单为正常', '管理员');
  161. break;
  162. case 1:
  163. //已取消,库存恢复
  164. \addons\shop\model\OrderGoods::setGoodsStocksInc($row->order_sn);
  165. //恢复优惠券
  166. UserCoupon::resetUserCoupon($row->user_coupon_id, $row->order_sn);
  167. OrderAction::push($row->order_sn, '订单取消成功', '管理员');
  168. break;
  169. case 2:
  170. OrderAction::push($row->order_sn, '更改订单为已失效', '管理员');
  171. break;
  172. case 3:
  173. //结束,订单完成,给积分
  174. $config = get_addon_config('shop');
  175. if (isset($config['money_score']) && $config['money_score'] > 0 && $row->shippingstate == 2 && $row->paystate == 1) {
  176. //减去退款金额
  177. $refund = OrderAftersales::where('order_id', $row->id)->where('type', '<>', 3)->where('status', 2)->sum('refund');
  178. $money = bcsub($row['payamount'], $refund, 2);
  179. if ($money > 0) {
  180. $score = bcmul($money, $config['money_score']);
  181. \app\common\model\User::score($score, $row['user_id'], '完成订单奖励' . $score . '积分');
  182. }
  183. }
  184. OrderAction::push($row->order_sn, '更改订单为已完成', '管理员');
  185. break;
  186. }
  187. }
  188. });
  189. }
  190. /**
  191. * 退款
  192. */
  193. public static function refund($order_sn, $paytype, $payamount)
  194. {
  195. $config = Service::getConfig($paytype);
  196. try {
  197. $order = Order::getByOrderSn($order_sn);
  198. if ($paytype == 'wechat') {
  199. $response = Pay::wechat($config)->refund([
  200. 'type' => in_array($order['method'], ['miniapp', 'app']) ? $order['method'] : '',
  201. 'out_trade_no' => $order_sn,
  202. 'out_refund_no' => time(),
  203. 'total_fee' => bcmul($order['payamount'], 100),
  204. 'refund_fee' => bcmul($payamount, 100)
  205. ]);
  206. if (!$response['result_code'] || $response['result_code'] != 'SUCCESS') {
  207. throw new \Exception(($response['err_code'] ?? '') . ':' . ($response['err_code_des'] ?? '未知退款错误'));
  208. }
  209. } elseif ($paytype == 'alipay') {
  210. $response = Pay::alipay($config)->refund([
  211. 'out_trade_no' => $order_sn,
  212. 'refund_amount' => $payamount,
  213. ]);
  214. if (!$response['code'] || $response['code'] != '10000') {
  215. throw new \Exception(($response['code'] ?? '') . ':' . ($response['msg'] ?? '未知退款错误'));
  216. }
  217. }
  218. } catch (\Exception $e) {
  219. Log::write("[shop][refund][{$order_sn}]同步退款失败,失败原因:" . $e->getMessage(), 'refund');
  220. throw new \Exception("同步退款失败,失败原因:" . $e->getMessage());
  221. }
  222. //发送通知
  223. TemplateMsg::sendTempMsg(2, $order_sn);
  224. return true;
  225. }
  226. public function User()
  227. {
  228. return $this->hasOne('\\app\\common\\model\\User', 'id', 'user_id', [], 'LEFT');
  229. }
  230. public function OrderGoods()
  231. {
  232. return $this->hasMany('OrderGoods', 'order_sn', 'order_sn');
  233. }
  234. public function OrderAction()
  235. {
  236. return $this->hasMany('OrderAction', 'order_sn', 'order_sn');
  237. }
  238. }