Order.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387
  1. <?php
  2. namespace app\data\controller\api;
  3. use app\data\model\BaseUserPayment;
  4. use app\data\model\DataUser;
  5. use app\data\model\DataUserVipOrder;
  6. use app\data\model\ShopGoodsCart;
  7. use app\data\model\ShopGoods;
  8. use app\data\model\ShopGoodsItem;
  9. use app\data\model\ShopOrder;
  10. use app\data\model\ShopOrderItem;
  11. use app\data\model\ShopOrderPay;
  12. use app\data\model\ShopOrderSend;
  13. use app\data\service\OrderService;
  14. use app\data\service\PaymentService;
  15. use think\admin\Controller;
  16. use hg\apidoc\annotation\Title;
  17. use hg\apidoc\annotation\Method;
  18. use hg\apidoc\annotation\Param;
  19. use hg\apidoc\annotation\Returned;
  20. use hg\apidoc\annotation\Header;
  21. use app\data\model\SystemUser;
  22. use think\facade\Db;
  23. use Yansongda\Pay\Pay;
  24. /**
  25. * 商品订单接口
  26. * Class Order
  27. * @package app\data\controller\api
  28. */
  29. class Order extends Auth
  30. {
  31. protected $noNeedLogin=['order_list','text','uploadmore','order_create'];
  32. /**
  33. * @Title("商品规格下单")
  34. * @Method("post")
  35. * @Param("admin_id",desc="商家id")
  36. * @Param("item_id",desc="规格id")
  37. * @Param("num",desc="数量")
  38. * @Param ("address_id",desc="地址id")
  39. */
  40. public function order_create(){
  41. $user = $this->getUser();
  42. // $user = ['id'=>40];
  43. $item_id =input('item_id');
  44. $address_id=input('address_id');
  45. $number = input('num');
  46. $pay_no =$this->pay_no($user['id']);
  47. $item_total = ShopGoodsItem::mk()->where('id',$item_id)->value('stock_total');
  48. if($number>$item_total){
  49. $this->error('商品没有库存了');
  50. }
  51. $data=[
  52. 'uuid'=>$user['id'],
  53. 'address_id'=>$address_id,
  54. 'item_id'=>$item_id,
  55. 'num'=>$number,
  56. 'pay_no'=>$pay_no
  57. ];
  58. $shop_order_model = new ShopOrder();
  59. $order_id = $shop_order_model->order_create($data);
  60. $order_money = ShopOrder::mk()->where(array('uuid'=>$user['id'],'payment_trade'=>$pay_no))->sum('payment_amount');
  61. $pay_data=[
  62. 'pay_no'=>$pay_no,
  63. 'money'=>$order_money,
  64. 'status'=>1,
  65. 'create_at'=>date('Y-m-d H:i:s')
  66. ];
  67. ShopOrderPay::mk()->insert($pay_data);
  68. $info = ['order_id'=>$order_id,'pay_no'=>$pay_no];
  69. $this->success('快去支付吧',$info);
  70. }
  71. /**
  72. * @Title("购物车下单")
  73. * @Method("post")
  74. * @Param("cart_ids",desc="购物车id(数组)")
  75. * @Param ("address_id",desc="地址id")
  76. */
  77. public function crat_create(){
  78. $user =$this->getUser();
  79. $cart_ids = input('cart_ids');
  80. $item_ids = ShopGoodsCart::mk()->whereIn('id',$cart_ids)->select();
  81. foreach ($item_ids as &$v){
  82. $item_total = ShopGoodsItem::mk()->where('id',$v['item_id'])->field('stock_total,goods_spec')->find();
  83. if($v['num']>$item_total['stock_total']){
  84. $this->error($item_total['goods_spec'].'规格没有库存了');
  85. }
  86. }
  87. $address_id = input('address_id');
  88. $pay_no =$this->pay_no($user['id']);
  89. $data=[
  90. 'uuid'=>$user['id'],
  91. 'cart_ids'=>$cart_ids,
  92. 'address_id'=>$address_id,
  93. 'pay_no'=>$pay_no
  94. ];
  95. $shop_order_model = new ShopOrder();
  96. $shop_order_model->cart_create($data);
  97. $order_money = ShopOrder::mk()->where(array('uuid'=>$user['id'],'payment_trade'=>$pay_no))->sum('payment_amount');
  98. $pay_data=[
  99. 'pay_no'=>$pay_no,
  100. 'money'=>$order_money,
  101. 'status'=>1,
  102. 'create_at'=>date('Y-m-d H:i:s')
  103. ];
  104. ShopOrderPay::mk()->insert($pay_data);
  105. ShopGoodsCart::mk()->whereIn('id',$cart_ids)->delete();
  106. $this->success('快去支付吧',$pay_no);
  107. }
  108. /**
  109. * @Title("商城下单支付")
  110. * @Method("post")
  111. * @Header("api-name",type="string",require=1,default="",desc="访问类型")
  112. * @Header("api-token",type="string",require=1,default="",desc="token")
  113. * @Param("pay_code",type="string",require=1,default="",desc="支付方式code")
  114. * @Param("pay_no",type="string",require=1,default="",desc="下单支付单号")
  115. * @Param("type",type="string",require=1,default="",desc="支付类型 alipay/wechat")
  116. */
  117. public function order_pay(){
  118. $user = $this->getUser();
  119. $data = $this->_vali([
  120. 'pay_code.require'=>'支付code有误',
  121. 'pay_no.require'=>'支付订单好不能为空',
  122. 'type.require'=>'支付类型不能为空'
  123. ]);
  124. $code = $data['pay_code'];
  125. $pay_type = $data['type'];
  126. $pay_no = $data['pay_no'];
  127. $pay_money= ShopOrderPay::mk()->where(['status' => 1, 'pay_no'=>$pay_no])->value('money');
  128. if(empty($pay_money)){
  129. $this->error('找不到订单');
  130. }
  131. ShopOrderPay::mk()->where(['status' => 1, 'pay_no'=>$pay_no])->save(['pay_type'=>$pay_type]);
  132. $all_price = $pay_money;
  133. $order_no = $pay_no;
  134. $error = 1;
  135. Db::startTrans();
  136. $retrun_data = [];
  137. try {
  138. if (stripos($pay_type, 'alipay') === 0) {
  139. $notify_name = 'orderzfb';
  140. $payment_type = '支付宝支付';
  141. } elseif (stripos($pay_type, 'wechat') === 0) {
  142. $notify_name = 'orderwx';
  143. $payment_type = '微信支付';
  144. }
  145. ShopOrder::mk()->where('payment_trade',$order_no)->save(['payment_type'=>$payment_type]);
  146. $notify_url = sysuri("@data/api.notify/{$notify_name}/scene/order/param/{$code}", [], false, true);
  147. $parm = ['uuid'=>$this->uuid];
  148. $pay =PaymentService::instance($code)->create($user['openid1'],$order_no,$all_price,'商品下单支付','商品下单支付','','',$notify_url,$parm);
  149. $retrun_data['order_no'] = $order_no;
  150. $pay['packages'] = isset($pay['package']) ? $pay['package'] : '';
  151. $retrun_data['pay'] = $pay;
  152. $retrun_data['success'] = isset($pay['result']) && $pay['result']=='success' ? 1 : 0;
  153. Db::commit();
  154. } catch (\Exception $e) {
  155. dump($e);
  156. // 回滚事务
  157. Db::rollback();
  158. $error = 0;
  159. $errorinfo = '未知错误';
  160. }
  161. if ($error){
  162. $this->success('成功',$retrun_data);
  163. }
  164. $this->error($errorinfo);
  165. }
  166. /**
  167. * @Title("我的订单")
  168. * @Method("post")
  169. * @Header("api-name",type="string",require=1,default="",desc="访问类型")
  170. * @Header("api-token",type="string",require=1,default="",desc="token")
  171. * @Param("order_name",desc="搜索名称")
  172. * @Param ("status",desc="1全部 2 待支付 3代发货 4 待收货 5退款/已退款")
  173. */
  174. public function order_list(){
  175. $user = $this->getUser();
  176. $status = input('status',1);
  177. if(!empty($status)){
  178. switch ($status){
  179. case 1:
  180. $array = [0,1,2,3,4,5,6,7];
  181. break;
  182. case 2:
  183. $array = [2];
  184. break;
  185. case 3:
  186. $array = [4];
  187. break;
  188. case 4:
  189. $array = [5];
  190. break;
  191. case 5:
  192. $array = [6,7];
  193. break;
  194. }
  195. }
  196. $query = ShopOrder::mQuery()->like('order_name');
  197. $list = $query ->where('uuid',$user['id'])
  198. ->whereIn('status',$array)->order('id desc')->page(true, false, false, 10);
  199. foreach ($list['list'] as $k=>$v){
  200. $list['list'][$k]['time']=0;
  201. if($list['list'][$k]['status']==2){
  202. $list['list'][$k]['time'] = strtotime($list['list'][$k]['create_at'])+30*60-time();
  203. }
  204. $list['list'][$k]['admin_name']= SystemUser::mk()->where('id',$list['list'][$k]['admin_id'])->value('nickname');
  205. $list['list'][$k]['goods_item']=ShopOrderItem::mk()->where('order_no',$list['list'][$k]['order_no'])->select();
  206. foreach ($list['list'][$k]['goods_item'] as &$vv){
  207. $vv['item_id'] = ShopGoodsItem::mk()->where('goods_sku',$vv['goods_sku'])->value('id');
  208. }
  209. $list['list'][$k]['goods_id'] = ShopGoods::mk()->where('code',$list['list'][$k]['goods_item'][0]['goods_code'])->value('id');
  210. }
  211. $this->success('我的订单列表',$list);
  212. }
  213. /**
  214. * @Title ("订单详情")
  215. * @Method ("post")
  216. * @Param ("order_id",desc="订单id")
  217. * @return void
  218. * @throws \think\db\exception\DataNotFoundException
  219. * @throws \think\db\exception\DbException
  220. * @throws \think\db\exception\ModelNotFoundException
  221. */
  222. public function order_info(){
  223. $user = $this->getUser();
  224. $order_id = input('order_id');
  225. $list = ShopOrder::mk()->where('uuid',$user['id'])->where('id',$order_id)->find();
  226. if($list['status']==2){
  227. $list['time'] = strtotime($list['create_at'])+30*60-time();
  228. }
  229. $list['goods_item']=ShopOrderItem::mk()->where('order_no',$list['order_no'])->select();
  230. $list['user_address']=ShopOrderSend::mk()->where('order_no',$list['order_no'])->find();
  231. $list['admin_name']= SystemUser::mk()->where('id',$list['admin_id'])->value('nickname');
  232. $list['admin_headimag']= SystemUser::mk()->where('id',$list['admin_id'])->value('headimg');
  233. $list['user_info']=DataUser::mk()->where('id',$list['uuid'])->field('headimg,nickname')->find();
  234. $this->success('店铺订单列表',$list);
  235. }
  236. /**
  237. * @Title ("提醒发货")
  238. * @Method ("post")
  239. * @Param ("order_id",desc="订单id")
  240. * @return void
  241. */
  242. public function remind(){
  243. $user = $this->getUser();
  244. $order_id = input('order_id');
  245. ShopOrder::mk()->where('uuid',$user['id'])->where('id',$order_id)->save(['remind'=>1]);
  246. $this->success('已提醒发货');
  247. }
  248. /**
  249. * @Title ("取消订单")
  250. * @Method ("post")
  251. * @Param ("order_id",desc="订单id")
  252. * @Param ("cancel_remark",desc="取消原因")
  253. * @return void
  254. */
  255. public function cancel_order(){
  256. $user = $this->getUser();
  257. $order_id = input('order_id');
  258. $cancel_remark = input('cancel_remark');
  259. ShopOrder::mk()->where('uuid',$user['id'])->where('id',$order_id)->save(['status'=>0,'cancel_remark'=>$cancel_remark]);
  260. $this->success('已取消订单');
  261. }
  262. /**
  263. * @Title ("申请退款")
  264. * @Method ("post")
  265. * @Param ("type",desc="退款类型")
  266. * @Param ("status",desc="收货状态")
  267. * @Param ("order_id",desc="订单id")
  268. * @Param ("reason",desc="退款原因")
  269. * @Param("desc",desc="描述")
  270. * @param ("images",desc="图片")
  271. */
  272. public function refund(){
  273. $user = $this->getUser();
  274. $refund_type = input('type');
  275. $goods_status = input('status','已收货');
  276. $order_id = input('order_id');
  277. $refund_money = ShopOrder::mk()->where(array('uuid'=>$user['id'],'id'=>$order_id))->value('payment_amount');
  278. $refund_reason = input('reason');
  279. $images = input('images');
  280. if(empty($refund_reason)){
  281. $this->error('退款原因不能为空');
  282. }
  283. $refund_desc = input('desc');
  284. $refund_data = [
  285. 'refund_money'=>$refund_money,
  286. 'refund_reason'=>$refund_reason,
  287. 'refund_desc'=>$refund_desc,
  288. 'refund_nr'=>$images,
  289. 'refund_type'=>$refund_type,
  290. 'goods_status'=>$goods_status,
  291. 'refund_status'=>1,
  292. 'status'=>7,
  293. 'refund_time'=>date('Y-m-d H:i:s')
  294. ];
  295. ShopOrder::mk()->where(array('uuid'=>$user['id'],'id'=>$order_id))->save($refund_data);
  296. $this->success('退款已提交');
  297. }
  298. /**
  299. * @Title ("填写退回物流信息")
  300. * @Method ("post")
  301. * @Param ("express_name",desc="快递公司")
  302. * @Param ("express_no",desc="快递单号")
  303. * @return void
  304. */
  305. public function refund_return(){
  306. $user = $this->getUser();
  307. $order_id = input("order_id");
  308. $express_name = input('express_name');
  309. $express_no = input('express_no');
  310. ShopOrder::mk()->where(array('uuid'=>$user['id'],'order_id'=>$order_id))->save(['express_name'=>$express_name,'express_no'=>$express_no]);
  311. $this->success("退款退货物流信息");
  312. }
  313. /**
  314. * @Title ("撤销退款申请表")
  315. * @Method ("post")
  316. * @Param ("order_id",desc="订单号")
  317. * @return void
  318. * @throws \think\db\exception\DataNotFoundException
  319. * @throws \think\db\exception\DbException
  320. * @throws \think\db\exception\ModelNotFoundException
  321. */
  322. public function cancel_refund(){
  323. $user = $this->getUser();
  324. $order_id = input('order_id');
  325. $refund_order = ShopOrder::mk()->where(array('uuid'=>$user['id'],'id'=>$order_id,'status'=>6))->find();
  326. if(empty($refund_order)){
  327. $this->error('订单信息错误');
  328. }
  329. ShopOrder::mk()->where(array('uuid'=>$user['id'],'order_id'=>$order_id))->save(['status'=>3]);
  330. $this->success('订单退款申请已撤回');
  331. }
  332. public function pay_no($uuid){
  333. $time_str = date('YmdHi');
  334. $pay_no = 'PAY'.$time_str . rand(00000,99999).$uuid;
  335. return $pay_no;
  336. }
  337. public function refund_order(){
  338. $config = [
  339. 'app_id' => '2021003161685907',
  340. 'notify_url' => '',
  341. 'return_url' => '',
  342. 'ali_public_key' =>'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0+yqR2nQ7uZBHoHeeLspwvZcB/jgMyjAxkJk7Dm9IR5VhTTSXNQYmOOjs+g628G52xxHQ/Z1pPK3dFshqIBTQC0VrrTyWFhypb8veKeo5RFzgWKvl1awvOdf5r6qXM6b3OjaBYqiqvpLdpZdVkEY9rLOwh6LM8XKYE3CfM466KypxYBrUeXRmDhweWVScSuOJGuhmd1O2RI2TIHjosxG10v4/s3nfNZ+aGQ+UnASRZbJ0GyyFlqyJ+mZGyAJBahWI4YYG6ZJMp2YNNUAWeb++gVG1Zw+HYMG57C0W6PCZ0LvS454ZRyx72WP+nKi7LMj8fkintEPbOkRd3M/OF42gQIDAQAB',
  343. 'private_key' =>'MIIEogIBAAKCAQEA0+yqR2nQ7uZBHoHeeLspwvZcB/jgMyjAxkJk7Dm9IR5VhTTSXNQYmOOjs+g628G52xxHQ/Z1pPK3dFshqIBTQC0VrrTyWFhypb8veKeo5RFzgWKvl1awvOdf5r6qXM6b3OjaBYqiqvpLdpZdVkEY9rLOwh6LM8XKYE3CfM466KypxYBrUeXRmDhweWVScSuOJGuhmd1O2RI2TIHjosxG10v4/s3nfNZ+aGQ+UnASRZbJ0GyyFlqyJ+mZGyAJBahWI4YYG6ZJMp2YNNUAWeb++gVG1Zw+HYMG57C0W6PCZ0LvS454ZRyx72WP+nKi7LMj8fkintEPbOkRd3M/OF42gQIDAQABAoIBACIGS0hv6sWQXkAhpbBIjGnq19fH02cjUeAC5OUwV/crQZvDYUraGqDhW3UVAe4qakaNgbudpEG5Xk7mGr9M6xDQrDyCfK5GdRG7YknC0VEFvj+1sm9f0bxigXkwf3WrDkcnc2mUWo2M5fTCK3YfuXxSNPPhp4PGa7mOgn07NyYH1+Zt4YZO6fBiHSqsgJo8tevWtjvrnc0cg2cUpDWQ41oGQRwD8S6QprOyCTAmCIsNNhlM19ebeFxG+8v0T3YQ9sWEMkdIXReGhEQbOxVeorp9rmViEf/EsZHV9QAWcZk2fAMwSCeC3CIBeorNdAAVxLUHNQP6slPDCQeCtFeWhIkCgYEA6uX5QetZkGQoKHZ5MEQt6AhLN3dPPv8E28kAT9UZcqMASMjyICzRvAeUPDuBrdy7lkufMo4GLYF5sFII4seMmxeHZCB0zdsnqNpoosXQFsK1tR9Q08E5tety/y8VfuONnyHICIV8wEgFtcHxYwCP9itiYpaiFdMhiuWrlGie8gMCgYEA5vZa1WitoSEVvf4c9QBWcw1eBC1P+oVgTmhBaYNRx1X6WZbP7NEqiYjwZOnXprTq8Gd8jIOHkDBOhtve3THiY4tpa1g3Kni0d9RHshYRKa9YTnAqDL4f7D8QC1mH8hDq26FsPMkehGQixVa5CwpP7Tu3KBY0Xmm4CFUPDhIZMCsCgYBx2UzaGkuqpCCim+lY73Kgh4SNOZJ7Ifck32L7TnmrCj3VCS/xUEfHLpU2LFFKBzYUPkrGofd0jtCAGQKdh8IqWVkRunliXNn4CQO2ANI+ddjEFI2EVJ64AYoXDKcKfRfjDOh62NgCCeZalcl9BoS/938T8ZZVpaMYQwDKSXrgKQKBgBCXegcCshZ1Lf6sFqBzGcLCHxLlvm0cz8JSMwDFckaDoqx07RLyI8Almj9lnRxYutfyVzww5rgxADMn8Gargrvr8/LGL5BZg31oPo5Ij4sTEaDw5dRshBaQoTJviBiXpoeInSHwwMR5/RV4GWr1nrBILewvTCvMJHBUy/QS0MRpAoGAe8GMTvLMjgJPnBJK6+p6vNDrpsZTNDlMhSrGFyxskwCeLZpSBFejN12HVoDXuypeA2KO7j6DXR4VxDyS8P0hUlc+iE9IHklT+PMxIuR88x6rqAL/a3DO+QkfYSb0IODLM0UlAFCp6/k7Lt73lkF9sJ4JRP4Fw3R3ddskYu33CzI=',
  344. 'log' => [ // optional
  345. 'file' => './logs/alipay.log',
  346. 'level' => 'info', // 建议生产环境等级调整为 info,开发环境为 debug
  347. 'type' => 'single', // optional, 可选 daily.
  348. 'max_file' => 30, // optional, 当 type 为 daily 时有效,默认 30 天
  349. ],
  350. 'http' => [ // optional
  351. 'timeout' => 5.0,
  352. 'connect_timeout' => 5.0,
  353. // 更多配置项请参考 [Guzzle](https://guzzle-cn.readthedocs.io/zh_CN/latest/request-options.html)
  354. ],
  355. // 'mode' => 'dev', // optional,设置此参数,将进入沙箱模式
  356. ];
  357. $order = [
  358. 'out_trade_no' => 'PAY2023021616109243658',
  359. 'refund_amount' => '0.01',
  360. ];
  361. $result = Pay::alipay($config)->refund($order);
  362. print_r(json_decode($result,true));die;
  363. }
  364. }