Order.php 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\model\CouponConfig;
  4. use app\common\model\DiscountActivity;
  5. use app\common\model\GroupActivity;
  6. use app\common\model\GroupGoods;
  7. use app\common\model\GroupGoodsItem;
  8. use app\common\model\GroupLeader;
  9. use app\common\model\OrderBill;
  10. use app\common\model\OrderComment;
  11. use app\common\model\ReductionActivity;
  12. use app\common\model\SeckillActivity;
  13. use app\common\model\SeckillGoods;
  14. use app\common\model\SeckillGoodsItem;
  15. use app\common\model\ShoppingTrolley;
  16. use app\common\model\DeliveryAddress;
  17. use app\common\model\StoreGoods;
  18. use app\common\model\StoreGoodsItem;
  19. use app\common\model\GoodsOrder;
  20. use app\common\model\GoodsOrderItem;
  21. use app\common\model\StoreOrderRefund;
  22. use app\common\model\User;
  23. use app\common\model\UserCouponList;
  24. use app\common\model\UserMessage;
  25. use app\common\model\UserWallet;
  26. use app\common\service\Activity;
  27. use app\common\service\ExpressService;
  28. use app\common\service\OrderCallback;
  29. use EasyWeChat\Factory;
  30. use library\tools\Data;
  31. use think\cache\driver\Redis;
  32. use think\Db;
  33. use think\Exception;
  34. use function EasyWeChat\Kernel\data_get;
  35. /**
  36. * @title 订单
  37. * @controller Order
  38. * @group base
  39. */
  40. class Order extends Base
  41. {
  42. public $int_rate = 100;
  43. public function initialize()
  44. {
  45. parent::initialize();
  46. parent::checkLogin();
  47. }
  48. /**
  49. * @title 订单确认页面(立即购买)
  50. * @desc 订单确认页面
  51. * @author qc
  52. * @url /api/Order/confirmOrderImmediately
  53. * @method GET
  54. * @header name:Authorization require:1 desc:Token
  55. * @param name:goods_id type:int require:1 default:0 desc:商品id
  56. * @param name:spec_id type:int require:1 default:0 desc:商品多规格的规格id
  57. * @param name:num type:int default:1 desc:数量
  58. * @return name:name type:string default:-- desc:商品名称
  59. * @return name:cover type:string default:-- desc:商品封面图
  60. * @return name:desc type:string default:-- desc:商品简述(副标题)
  61. * @return name:freight_type type:int default:-- desc:运费类型0固定金额,1运费模板
  62. * @return name:freight_id type:int default:-- desc:模板id(freight_type=1)
  63. * @return name:postage type:float default:-- desc:运费(freight_type=0)
  64. * @return name:share_money type:float default:-- desc:分享返利金额
  65. * @return name:total_price type:float default:-- desc:订单金额
  66. * @return name:total_group type:float default:-- desc:拼团订单金额
  67. * @return name:total_seckill type:float default:-- desc:秒杀订单金额
  68. * @return name:total_discount type:float default:-- desc:折扣订单金额
  69. * @return name:item_list type:array default:-- desc:商品多规格列表
  70. * @return name:item_list.spec_info type:array default:-- desc:规格型号设置;
  71. * @return name:item_list.goods_no type:string default:-- desc:规格货号
  72. * @return name:item_list.goods_title:string default:-- desc:规格标题
  73. * @return name:item_list.cover type:string default:-- desc:规格封面
  74. * @return name:item_list.stock type:int default:-- desc:剩余库存
  75. * @return name:item_list.original_price type:float default:-- desc:原价
  76. * @return name:item_list.sell_price type:float default:-- desc:售价
  77. * @return name:item_list.seckill_price type:float default:-- desc:秒杀价(没有秒杀活动=售价)
  78. * @return name:item_list.group_price type:float default:-- desc:拼团价(没有拼团活动=售价)
  79. * @return name:item_list.discount_price type:float default:-- desc:折扣价(没有折扣活动=售价)
  80. * @return name:discount type:array default:-- desc:折扣活动详情(为空:商品没有正在进行的折扣活动)
  81. * @return name:seckill type:array default:-- desc:秒杀活动详情(为空:商品没有正在进行的秒杀活动)
  82. * @return name:seckill.start_time type:string default:-- desc:开始时间
  83. * @return name:seckill.end_time type:string default:-- desc:结束时间
  84. * @return name:group type:array default:-- desc:拼团活动
  85. * @return name:group.start_time type:string default:-- desc:开始时间
  86. * @return name:group.end_time type:string default:-- desc:结束时间
  87. * @return name:group.full_num type:int default:-- desc:成团人数
  88. * @return name:reduction type:array default:-- desc:满减活动
  89. * @return name:reduction.id type:int default:-- desc:满减活动id
  90. * @return name:reduction.title type:string default:-- desc:满减标题
  91. * @return name:reduction.start_time type:string default:-- desc:满减开始时间
  92. * @return name:reduction.end_time type:string default:-- desc:满减结束时间
  93. * @return name:reduction.act_set type:array default:-- desc:满减设置
  94. * @return name:reduction.act_set.full type:float default:-- desc:满多少
  95. * @return name:reduction.act_set.reduction type:float default:-- desc:减多少
  96. * @return name:goods_discount type:array default:-- desc:商品优惠
  97. * @return name:goods_discount.order_cash type:float default:-- desc:积分最高抵扣订单金额
  98. * @return name:goods_discount.coupon_list type:array default:-- desc:优惠券列表(单品可以只让用一张)
  99. * @return name:coupon_list.id type:int default:-- desc:优惠券列表id
  100. * @return name:coupon_list.low_amount type:float default:-- desc:订单最低金额
  101. * @return name:coupon_list.amount type:float default:-- desc:可抵扣金额
  102. * @return name:add_info type:array default:-- desc:默认收货地址(设置才有)
  103. * @return name:add_info.pro_id type:int default:-- desc:省id
  104. * @return name:add_info.city_id type:int default:-- desc:市id
  105. * @return name:add_info.county_id type:int default:-- desc:县区id
  106. * @return name:add_info.pro_name type:string default:-- desc:省名
  107. * @return name:add_info.city_name type:string default:-- desc:市名
  108. * @return name:add_info.county_name type:string default:-- desc:县区名
  109. * @return name:add_info.street_name type:string default:-- desc:街道名称
  110. * @return name:add_info.detail type:string default:-- desc:详细地址
  111. * @return name:add_info.phone type:string default:-- desc:联系电话
  112. * @return name:add_info.name type:string default:-- desc:联系人
  113. *
  114. */
  115. public function confirmOrderImmediately()
  116. {
  117. $user_id = $this->user_id;
  118. $goods_id = input('get.goods_id');
  119. $spec_id = input('get.spec_id');
  120. $num = input('get.num',1);
  121. $act_type = input('get.act_type',0);
  122. $act_id = input('get.act_id',0);
  123. $field = 'id,name,cover,desc,low_price,status,is_deleted,level_set,freight_type,postage';
  124. $goods_info = StoreGoods::with(['itemList'=>function($query)use($spec_id){
  125. return $query->where('id',$spec_id);
  126. }])->field($field)->where('id',$goods_id)->find()->toArray();
  127. $act_data = Activity::goodsActivityList($goods_id);
  128. $goods_info['item_list'] = $goods_info['item_list'][0];
  129. // 秒杀价格
  130. $goods_info['item_list']['seckill_price'] = $goods_info['item_list']['sell_price'];
  131. if(!empty($act_data['seckill']['goods'])){
  132. foreach ($act_data['seckill']['goods']['item'] as $sv){
  133. if($sv['spec_id'] == $spec_id){
  134. $goods_info['item_list']['seckill_price'] = $sv['seckill_price'];
  135. break;
  136. }
  137. }
  138. }
  139. // 拼团价格
  140. $goods_info['item_list']['group_price'] = $goods_info['item_list']['sell_price'];
  141. if(!empty($act_data['group']['goods'])){
  142. foreach ($act_data['group']['goods']['item'] as $gv){
  143. if($gv['spec_id'] == $spec_id){
  144. $goods_info['item_list']['group_price'] = $gv['group_price'];
  145. break;
  146. }
  147. }
  148. }
  149. // 折扣活动
  150. $goods_info['item_list']['discount_price'] = $goods_info['item_list']['sell_price'];
  151. if(!empty($act_data['discount']['act'])){
  152. $goods_info['item_list']['discount_price'] = bcmul($goods_info['item_list']['sell_price'],$act_data['discount']['act']['discount']/100,2);
  153. }
  154. $level_set = $goods_info['level_set'] ? json_decode($goods_info['level_set'],true):[];
  155. // 商品优惠信息
  156. $goods_discount = [
  157. 'order_cash' => 0,
  158. 'express_cash' => 0,
  159. 'coupon_list'=> [],
  160. ];
  161. $user_info = User::field('u.id,u.level_id,w.integral,money')->alias('u')
  162. ->leftJoin('UserWallet w','u.id = w.user_id')
  163. ->where('u.id',$this->user_id)->find()->toArray();
  164. if($user_info['level_id'] > 0 && !empty($level_set))
  165. {
  166. $goods_discount['order_cash'] = isset($level_set[$user_info['level_id']]) ? $level_set[$user_info['level_id']]['integral_cash']:0;
  167. // $goods_discount['express_cash'] = isset($level_set[$user_info['level_id']]) ? $level_set[$user_info['level_id']]['integral_freight']:0;
  168. }
  169. // 优惠券 全场限时 || 全场不限时 || 商品券限时 || 商品券不限时
  170. $goods_discount['coupon_list'] = UserCouponList::where(function ($query)use($goods_id,$user_id){
  171. return $query->where([['user_id','=',$user_id],['status','=',0],['coupon_type','=',0],['type','=',1],['end','> time',date('Y-m-d')],['start','< time',date('Y-m-d')]]);
  172. })->whereOr(function ($query)use($goods_id,$user_id){
  173. return $query->where([['user_id','=',$user_id],['status','=',0],['coupon_type','=',0],['type','=',0]]);
  174. })->whereOr(function ($query)use($goods_id,$user_id){
  175. return $query->where([['user_id','=',$user_id],['status','=',0],['coupon_type','=',1],['goods_id','=',$goods_id]]);
  176. })->select()->toArray();
  177. $goods_info['total_price']= bcmul($goods_info['item_list']['sell_price'],$num,2);
  178. $goods_info['total_seckill']= bcmul($goods_info['item_list']['seckill_price'],$num,2);
  179. $goods_info['total_group']= bcmul($goods_info['item_list']['group_price'],$num,2);
  180. $goods_info['total_discount']= bcmul($goods_info['item_list']['discount_price'],$num,2);
  181. $add_info = DeliveryAddress::where(['user_id'=>$this->user_id,'is_mr'=>1])->find();
  182. $this->success('ok',['goods_info'=>$goods_info,
  183. 'seckill'=>$act_data['seckill']['act'],
  184. 'group'=>$act_data['group']['act'],
  185. 'discount'=>$act_data['discount']['act'],
  186. 'goods_discount'=>$goods_discount,
  187. 'user_info'=>$user_info,
  188. 'reduction'=>ReductionActivity::getAct(),
  189. 'add_info' =>$add_info ? $add_info->toArray():'',
  190. ]);
  191. }
  192. /**
  193. * @title 生成订单(立即购买)
  194. * @desc 立即购买场景
  195. * @author qc
  196. * @url /api/Order/createOrderImmediately
  197. * @method POST
  198. * @header name:Authorization require:1 desc:Token
  199. * @param name:goods_id type:int require:1 default:0 desc:商品id
  200. * @param name:spec_id type:int require:1 default:0 desc:商品多规格的规格id
  201. * @param name:num type:int default:1 desc:数量
  202. * @param name:act_type type:int default:0 desc:活动类型(0正常购买,1限时秒杀(抢购),2拼团,3折扣)
  203. * @param name:act_id type:int default:0 desc:活动id(活动类型act_type>0必传)
  204. * @param name:leader_id type:int default:0 desc:参与团的id(为0是新开团)
  205. * @param name:share_user type:int default:0 desc:分享人(谁分享给你的)
  206. * @param name:integral_order type:int default:0 desc:积分(抵扣订单的)
  207. * @param name:coupon_id type:int default:0 desc:优惠券id
  208. * @param name:add_id type:int default:1 desc:收货地址id
  209. * @param name:pay_city type:int default:0 desc:本次登录的城市
  210. * @return name:order_id type:int default:1 desc:订单id
  211. */
  212. public function createOrderImmediately()
  213. {
  214. $goods_id = input('post.goods_id');
  215. $spec_id = input('post.spec_id');
  216. $num = input('post.num');
  217. $add_id = input('post.add_id');
  218. $act_type = input('post.act_type',0);
  219. $act_id = input('post.act_id',0);
  220. $share_user = input('post.share_user',0);
  221. $integral_order = input('post.integral_order',0);
  222. $integral_express = input('post.integral_express',0);
  223. $coupon_id = input('post.coupon_id',0);// 优惠券id
  224. $leader_id = input('post.leader_id',0);// 参与拼团的id
  225. if(!$goods_id || !$spec_id) $this->error('请选择商品');
  226. if($num <=0 ) $this->error('数量有误');
  227. if(!$add_id ) $this->error('请选择收货地址');
  228. Db::startTrans();
  229. try {
  230. $add_info = DeliveryAddress::find($add_id)->toArray();
  231. $order_insert = [
  232. 'user_id' => $this->user_id,
  233. 'order_no' => get_order_sn(),
  234. 'goods_num' => $num,
  235. 'pro_name' => $add_info['pro_name'],
  236. 'city_name' => $add_info['city_name'],
  237. 'county_name' => $add_info['county_name'],
  238. 'street_name' => $add_info['street_name'],
  239. 'user_name' => $add_info['name'],
  240. 'add_detail' => $add_info['detail'],
  241. 'phone' => $add_info['phone'],
  242. 'act_type' => $act_type,
  243. 'act_id' => $act_id,
  244. 'share_user' => $share_user,
  245. 'leader_id' => $leader_id,
  246. 'cl_ids' => $coupon_id,
  247. 'express_cash' => 0,
  248. 'coupon_cash' => 0,
  249. ];
  250. $goods_info = StoreGoods::with(['itemList'=>function($query)use($spec_id){
  251. return $query->where('id',$spec_id)->where('is_deleted',0);
  252. }])->where('id',$goods_id)->where('is_deleted',0)->where('status',1)->find();
  253. if(!$goods_info) throw new Exception('商品已下架');
  254. $goods_info = $goods_info->toArray();
  255. if(empty($goods_info['item_list'])) throw new Exception('该规格已下架');
  256. if($goods_info['item_list'][0]['stock'] < $num) throw new Exception('库存不足');
  257. $order_insert['original_price'] = bcmul($num,$goods_info['item_list'][0]['original_price'],2);// 原价
  258. $true_cost = $goods_info['item_list'][0]['sell_price'];//实际售价
  259. $spec_info = $goods_info['item_list'][0];
  260. // 秒杀购买
  261. if($act_type == 1){
  262. if(!$act_id) $this->exception('参数错误');
  263. $act_info = SeckillActivity::where('id',$act_id)->find()->toArray();
  264. if($act_info['status'] != 1 || $act_info['is_deleted'] == 1 || strtotime($act_info['end_time'])<time()) $this->exception('活动已结束');
  265. if(strtotime($act_info['start_time']) > time()) $this->exception('活动尚未开始请耐心等待');
  266. // 商品详情
  267. $seckill_goods_id = SeckillGoods::where(['goods_id'=>$goods_id,'act_id'=>$act_id])->value('id');
  268. if(!$seckill_goods_id) $this->exception('商品信息错误');
  269. $item = SeckillGoodsItem::where(['act_id'=>$act_id,'goods_id'=>$goods_id,'spec_id'=>$spec_id])->find()->toArray();
  270. if($item['status'] != 1) $this->exception('商品已下架');
  271. // redis 验证库存
  272. // $redis_prefix = 'SECKILL_'.$act_id.'_'.$item['id'];
  273. // $redis = new Redis();
  274. //$redis_stock = $redis->get($redis_prefix.'_stock',0);
  275. // if($redis_stock <= 0 || $redis_stock < $num || $item['stock'] < $num) $this->exception('库存不足');
  276. //$redis->dec($redis_prefix.'_stock',$num);// 扣减redis库存
  277. $true_cost = $item['seckill_price'];
  278. }
  279. //拼团购买
  280. if($act_type == 2){
  281. if(!$act_id) $this->exception('参数错误');
  282. $act_info = GroupActivity::where('id',$act_id)->find()->toArray();
  283. if($act_info['status'] != 1 || $act_info['is_deleted'] == 1 || strtotime($act_info['end_time'])<time()) $this->exception('活动已结束');
  284. if(strtotime($act_info['start_time']) > time()) $this->exception('活动尚未开始请耐心等待');
  285. $group_goods_id = GroupGoods::where(['goods_id'=>$goods_id,'act_id'=>$act_id])->value('id');
  286. if(!$group_goods_id) $this->exception('商品信息错误');
  287. $item = GroupGoodsItem::where(['act_id'=>$act_id,'goods_id'=>$goods_id,'spec_id'=>$spec_id])->find()->toArray();
  288. if($item['status'] != 1) $this->exception('商品已下架');
  289. // redis 验证库存
  290. /* $redis_prefix = 'GROUP_'.$act_id.'_';
  291. $redis = new Redis();
  292. $redis_stock = $redis->get($redis_prefix.$item['id'].'_stock',0);
  293. if($redis_stock <= 0 || $redis_stock < $num || $item['stock'] < $num) $this->exception('库存不足');
  294. */
  295. if($leader_id){
  296. // if($redis->get($redis_prefix.$leader_id,0)) $this->exception('该团已有团员参与');
  297. // $redis->set($redis_prefix.$leader_id,1);
  298. GroupLeader::where(['id'=>$leader_id])->update(['status'=>3]);
  299. }
  300. // $redis->dec($redis_prefix.'_stock',$num);// 扣减redis库存
  301. $true_cost = $item['group_price'];
  302. }
  303. // 折扣购买
  304. if($act_type == 3){
  305. if(!$act_id) $this->exception('参数错误');
  306. $act_info = DiscountActivity::where('id',$act_id)->find()->toArray();
  307. if($act_info['status'] != 1 || $act_info['is_deleted'] == 1 || strtotime($act_info['end_time'])<time()) $this->exception('活动已结束');
  308. if(strtotime($act_info['start_time']) > time()) $this->exception('活动尚未开始请耐心等待');
  309. $true_cost = bcmul($goods_info['item_list'][0]['sell_price'] , $act_info['discount']/100,2);
  310. }
  311. $price_goods = bcmul($num,$true_cost,2); // 需要支付商品价格
  312. // 积分抵扣金额
  313. $total_integral = $integral_order + $integral_express;// 积分使用数量
  314. if($total_integral > 0){
  315. $wallet_integral = UserWallet::where(['user_id'=>$this->user_id])->value('integral');
  316. if($total_integral > $wallet_integral) $this->exception('积分不足');
  317. }
  318. $integral_cash = bcdiv($total_integral,$this->int_rate,2);// 积分抵扣订单金额(全部)
  319. if($integral_express >0) $order_insert['express_cash'] = bcdiv($integral_express,$this->int_rate,2);// 积分抵扣运费金额
  320. // 优惠券
  321. if($coupon_id){
  322. $coupon_info = UserCouponList::where(function ($query)use($coupon_id){
  323. return $query->where([['id','=',$coupon_id],['status','=',0],['coupon_type','=',0],['type','=',1],['end','> time',date('Y-m-d')],['start','< time',date('Y-m-d')]]);
  324. })->whereOr(function ($query)use($coupon_id){
  325. return $query->where([['id','=',$coupon_id],['status','=',0],['coupon_type','=',0],['type','=',0]]);
  326. })->whereOr(function ($query)use($goods_id,$coupon_id){
  327. return $query->where([['id','=',$coupon_id],['status','=',0],['coupon_type','=',1],['goods_id','=',$goods_id],['type','=',1],['end','> time',date('Y-m-d')],['start','< time',date('Y-m-d')]]);
  328. })->whereOr(function ($query)use($goods_id,$coupon_id){
  329. return $query->where([['id','=',$coupon_id],['status','=',0],['coupon_type','=',1],['goods_id','=',$goods_id],['type','=',0]]);
  330. })->find();
  331. if(!$coupon_info) $this->exception('优惠券过期');
  332. if($coupon_info->low_amount < $price_goods) $this->exception('优惠券使用限制');
  333. UserCouponList::where('id',$coupon_id)->update(['status'=>1]);
  334. $order_insert['cl_ids'] = $coupon_id;
  335. $order_insert['coupon_cash'] = $coupon_info->amount; // 优惠券抵扣金额
  336. }
  337. // 获取运费信息
  338. $exp_data = ExpressService::getGoodsExpressPrice($goods_info,$add_info,$num);
  339. if($exp_data['code'] != 200 ) throw new Exception($exp_data['msg']);
  340. $price_express = $exp_data['freight']; // 商品运费
  341. if($price_express < $order_insert['express_cash'] ) $this->exception('运费抵扣金额有误');
  342. $redu_money = ReductionActivity::getReduction($price_goods);// 商品满减
  343. $total_discount = $integral_cash + $order_insert['coupon_cash'] + $redu_money;
  344. //订单金额 = 商品金额 + 运费 - (积分抵扣 + 优惠券 + 满减)
  345. $order_money = bcsub($price_goods+$price_express,$total_discount ,2);
  346. if($order_money < 0) $this->exception('订单金额有误');
  347. $order_insert['price_total'] = $order_money;
  348. $order_insert['price_goods'] = $price_goods;
  349. $order_insert['price_express'] = $price_express;
  350. $order_insert['integral'] = $total_integral;
  351. $order_insert['total_discount'] = $total_discount ;
  352. $order_insert['redu_money'] = $redu_money;
  353. $order_info = GoodsOrder::create($order_insert);
  354. // 扣除积分
  355. if($total_integral) UserWallet::userIntegralChange($this->user_id,$total_integral,'订单抵扣',1,-1,$order_info->id);
  356. $order_item = [
  357. 'user_id' => $this->user_id,
  358. 'order_id' => $order_info->id,
  359. 'goods_id' => $goods_id,
  360. 'goods_no' => $spec_info['goods_no'],
  361. 'goods_spec' => $spec_info['goods_spec'],
  362. 'goods_name' => $goods_info['name'],
  363. 'spec_title' => $spec_info['spec_title'],
  364. 'spec_id' => $spec_info['id'],
  365. 'is_combo' => $goods_info['is_combo'],
  366. 'cover' => $goods_info['cover'],
  367. 'original_price' => $spec_info['original_price'],
  368. 'sell_price' => $true_cost,
  369. 'pay_price' => $order_money,
  370. 'num' => $num,
  371. 'belong' => StoreGoods::getGoodsBelong($goods_id),
  372. ];
  373. GoodsOrderItem::create($order_item);
  374. StoreGoods::where('id',$goods_id)->setDec('stock',$num);
  375. StoreGoodsItem::where('id',$spec_id)->setDec('stock',$num);
  376. /* switch ($act_type){
  377. case 0: // 商城购买
  378. StoreGoods::where('id',$goods_id)->setDec('stock',$num);
  379. StoreGoodsItem::where('id',$spec_id)->setDec('stock',$num);
  380. break;
  381. case 1: // 秒杀购买
  382. SeckillGoodsItem::where('id',$item['id'])->setDec('stock',$num);
  383. break;
  384. case 2:// 拼团购买
  385. GroupGoodsItem::where('id',$item['id'])->setDec('stock',$num);
  386. break;
  387. }*/
  388. Db::commit();
  389. }catch (\Exception $e){
  390. $this->is_commit = false;
  391. $this->ret_msg = $e->getMessage();
  392. Db::rollback();
  393. }
  394. $this->is_commit ? $this->success('添加成功',['order_id'=>$order_info->id]):$this->error($this->ret_msg);
  395. }
  396. /**
  397. * @title 订单支付
  398. * @desc 订单支付
  399. * @author qc
  400. * @url /api/Order/payOrder
  401. * @method POST
  402. * @header name:Authorization require:1 desc:Token
  403. * @param name:order_id type:int require:1 default:0 desc:订单id
  404. * @param name:pay_type type:int require:1 default:0 desc:支付方式(1微信小程序 ,2佣金余额 ,3移动支付(支付宝),4移动支付(微信),5pc(微信扫码),6pc(支付宝扫码))
  405. * @return name:config type:array default:0 desc:小程序支付配置
  406. * @return name:config.appId type:string default:-- desc:公众账号ID(小程序支付)
  407. * @return name:config.signType type:string default:-- desc:签名类型(小程序支付)
  408. * @return name:config.paySign type:string default:-- desc:签名(小程序支付)
  409. * @return name:config.nonceStr type:string default:-- desc:随机字符串(小程序支付&&APP支付)
  410. * @return name:config.timestamp type:string default:-- desc:时间戳小程序支付&&APP支付)
  411. * @return name:config.partnerid type:string default:-- desc:商户号(App支付)
  412. * @return name:config.prepayid type:string default:-- desc:唯一支付号(App支付)
  413. * @return name:config.package type:string default:-- desc:package(App支付)
  414. * @return name:config.sign type:string default:-- desc:签名(App支付)
  415. * @return name:code_url type:string default:-- desc:付款码url
  416. */
  417. public function payOrder()
  418. {
  419. $order_id = input('post.order_id');
  420. $pay_type = input('post.pay_type');
  421. $order_info = GoodsOrder::with('orderItem')->where('id',$order_id)->find()->toArray();
  422. if($order_info['status'] != 0) $this->error('订单状态错误');
  423. if($order_info['cancel_state'] != 0 || $order_info['is_deleted'] != 0) $this->error('订单异常');
  424. if($order_info['price_total'] <= 0) $this->error('订单金额错误');
  425. $pay_no = $order_info['pay_no'] ? $order_info['pay_no'] : get_order_sn();// 支付单号
  426. if(!$order_info['pay_no']) GoodsOrder::where('id',$order_id)->update(['pay_no'=>$pay_no]);
  427. $user_info = User::with('wallet')->where('id',$this->user_id)->find()->toArray();
  428. $ret_data = ['pay_status'=>0,'config'=>[],'code_url'=>''];
  429. Db::startTrans();
  430. try {
  431. switch ($pay_type){
  432. case 1://微信小程序
  433. $notify_url = $this->request->root(true) . '/api/we_chat_pay/goodsOrderNotify';
  434. $pay_config = WeChatPay::wxPay('订单支付',$pay_no,$order_info['price_total'],$notify_url,'JSAPI',$user_info['openid']);
  435. if($pay_config['code'] != 200) $this->exception($pay_config['msg']);
  436. $ret_data['config'] = $pay_config['config'];
  437. break;
  438. case 2://佣金余额
  439. if($user_info['wallet']['money'] < $order_info['price_total'])$this->exception('余额不足');
  440. // 扣除余额
  441. UserWallet::userMoneyChange($this->user_id,$order_info['price_total'],'订单支付',1,-1,$order_id);
  442. // 支付完成后回调
  443. $back_res = OrderCallback::goodsOrderCallBack($order_info,$pay_type);
  444. if(!$back_res['ret_val']) $this->exception($back_res['msg']);
  445. $ret_data['pay_status'] = 1;
  446. break;
  447. case 3://移动支付(支付宝)
  448. break;
  449. case 4: //4移动支付(微信)
  450. $notify_url = $this->request->root(true) . '/api/we_chat_pay/goodsOrderNotify';
  451. $pay_config = WeChatPay::wxPay('订单支付',$pay_no,$order_info['price_total'],$notify_url,'APP');
  452. if($pay_config['code'] != 200) $this->exception($pay_config['msg']);
  453. $ret_data['config'] = $pay_config['config'];
  454. break;
  455. case 5: //pc(微信扫码)
  456. $notify_url = $this->request->root(true) . '/api/we_chat_pay/goodsOrderNotify';
  457. $app = Factory::payment(config('app.wx_pay'));
  458. $result = $app->order->unify([
  459. 'body' => '微信扫码支付',
  460. 'out_trade_no' => $pay_no,
  461. 'total_fee' => $order_info['price_total'] * 100,
  462. 'notify_url' => $notify_url, // 支付结果通知网址,如果不设置则会使用配置里的默认地址
  463. 'trade_type' => 'NATIVE', // 请对应换成你的支付方式对应的值类型
  464. ]);
  465. if(!isset($result['code_url'])) $this->exception($result['err_code_des']?$result['err_code_des']:'获取付款码失败');
  466. $ret_data['code_url'] = $result['code_url'];
  467. break;
  468. case 6: //pc(支付宝扫码)
  469. break;
  470. }
  471. Db::commit();
  472. }catch (\Exception $e){
  473. $this->is_commit = false;
  474. $this->ret_msg = $e->getMessage();
  475. Db::rollback();
  476. }
  477. $this->transReturn($ret_data);
  478. }
  479. /**
  480. * @title 获取订单详情
  481. * @desc 获取订单详情
  482. * @author qc
  483. * @method GET
  484. * @url /api/Order/getOrderDetail
  485. * @header name:Authorization require:1 desc:Token
  486. * @param name:order_id type:int default:-- desc:订单id
  487. * @return name:id type:int default:-- desc:订单id
  488. * @return name:order_no type:string default:-- desc:订单号
  489. * @return name:price_total type:float default:-- desc:待支付金额(所以优惠完价格+运费)
  490. * @return name:price_goods type:float default:-- desc:商品金额
  491. * @return name:price_express type:float default:-- desc:运费金额
  492. * @return name:original_total type:float default:-- desc:总原价(下划线)
  493. * @return name:original_total type:float default:-- desc:总原价(下划线)
  494. * @return name:pay_state type:int default:-- desc:支付状态(0未支付1已支付)
  495. * @return name:pay_type type:int default:-- desc:支付方式(1微信2余额3支付宝)
  496. * @return name:pay_no type:string default:-- desc:支付号
  497. * @return name:pay_at type:string default:-- desc:支付时间
  498. * @return name:cancel_state type:int default:-- desc:取消状态(0未取消1已取消)
  499. * @return name:cancel_at type:string default:-- desc:取消时间
  500. * @return name:cancel_desc type:string default:-- desc:取消原因
  501. * @return name:cancel_desc type:string default:-- desc:取消原因
  502. * @return name:refund_state type:int default:-- desc:退款状态(0未申请1待审核,2审核拒绝,3审核通过)
  503. * @return name:express_state type:int default:-- desc:发货状态(0未发货,1已发货,2已签收)
  504. * @return name:express_company_title type:string default:-- desc:发货快递公司名称
  505. * @return name:express_send_no type:string default:-- desc:物流单号
  506. * @return name:express_send_at type:string default:-- desc:发货时间
  507. * @return name:status type:int default:-- desc:订单状态(0待支付,1已支付(待发货),2已发货(待收货),3已收货(待评论)4已完成,8已退款,9取消)
  508. * @return name:create_at type:string default:-- desc:下单时间
  509. * @return name:integral type:string default:-- desc:使用积分数量
  510. * @return name:cl_ids type:string default:-- desc:使用优惠券id串
  511. * @return name:coupon_cash type:string default:-- desc:使用优惠券抵扣金额
  512. * @return name:blance type:string default:-- desc:使用余额支付金额(余额抵扣)
  513. * @return name:redu_money type:float default:-- desc:订单满减金额
  514. * @return name:remark type:string default:-- desc:订单备注
  515. * @return name:goods_num type:int default:-- desc:订单商品总数量
  516. * @return name:pro_name type:string default:-- desc:省名称(收货地址)
  517. * @return name:city_name type:string default:-- desc:市名称(收货地址)
  518. * @return name:county_name type:string default:-- desc:县区名称(收货地址)
  519. * @return name:street_name type:string default:-- desc:街道名称(收货地址)
  520. * @return name:add_detail type:string default:-- desc:详细地址(收货地址)
  521. * @return name:user_name type:string default:-- desc:收货人
  522. * @return name:phone type:string default:-- desc:收货人联系电话
  523. * @return name:act_type type:int default:-- desc:活动类型0无1秒杀2拼团
  524. * @return name:act_id type:int default:-- desc:活动id
  525. * @return name:share_user type:int default:-- desc:分享人id
  526. * @return name:order_item type:array default:-- desc:订单商品列表(按商品id分组)
  527. * @return name:order_item.name type:float default:-- desc:商品名
  528. * @return name:order_item.cover type:float default:-- desc:商品图
  529. * @return name:order_item.sell_price type:float default:-- desc:购买价格
  530. * @return name:order_item.goods_spec type:float default:-- desc:规格
  531. * @return name:order_item.num type:int default:-- desc:数量
  532. */
  533. public function getOrderDetail()
  534. {
  535. $order_id = input('get.order_id');
  536. $detail = GoodsOrder::where('id',$order_id)->find()->toArray();
  537. $detail['order_item'] = (new GoodsOrderItem())->getOrderItem($order_id);
  538. $this->success('',['detail'=>$detail]);
  539. }
  540. }