Recharge.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605
  1. <?php
  2. declare (strict_types=1);
  3. namespace app\api\controller;
  4. use app\BaseController;
  5. use app\Request;
  6. use app\model\api\RechargeConfig;
  7. use app\model\api\RechargeOrder;
  8. use app\model\api\User;
  9. use app\model\api\UserScoreDetail;
  10. use library\services\UtilService;
  11. use library\utils\WxpayV2 as wxpayApi;
  12. use library\utils\weixinPay as wxpayApiV3;
  13. use app\model\api\Sys as SysModel;
  14. use think\db\exception\DbException;
  15. use think\facade\Db;
  16. use think\facade\Cache;
  17. use app\model\api\PayTrade as PayTradeModel;
  18. class Recharge extends BaseController
  19. {
  20. /**
  21. * 获取充值配置列表
  22. * @param Request $request
  23. * @return mixed
  24. */
  25. public function configList(Request $request)
  26. {
  27. $rechargeConfig = new RechargeConfig();
  28. $list = $rechargeConfig->getShowList();
  29. return app('json')->success([
  30. 'list' => $list
  31. ]);
  32. }
  33. /**
  34. * 模板订单提交[第一步]
  35. * @param Request $request
  36. */
  37. public function createOrder(Request $request)
  38. {
  39. [$price, $pay_type] = UtilService::getMore([
  40. ['price', 0],
  41. ['pay_type', '', 'empty', '请选择支付方式'],
  42. ], $request, true);
  43. if (!in_array($pay_type, ["wxpay"])) {
  44. return app('json')->fail('不支持该支付方式!');
  45. }
  46. $weixinConfig = (new SysModel)->getWeixinConfig();
  47. // if(empty($weixinConfig)){
  48. // return app('json')->fail('支付配置为空!');
  49. // }
  50. $uid = $request->user['uid'];
  51. // 防重复提交缓存
  52. $redis = Cache::store('redis');
  53. $key = 'recharge_order_sub_' . $request->user['uid'];
  54. $bool = $redis->handler()->exists($key);
  55. if ($bool) {
  56. return app('json')->fail('请勿重复操作,请稍后再试!');
  57. }
  58. $redis->set($key, 1, 5); // 5秒缓存
  59. // 获取系统积分转换比例
  60. $sys = (new SysModel())->where("id", 1)->find();
  61. $pointsTransformation = isset($sys['points_transformation']) ? intval($sys['points_transformation']) : 10;
  62. // 获取用户折扣金额(半小时内固定)
  63. $cacheKey = 'recharge_discount_' . $request->user['uid'];
  64. $discount = $redis->get($cacheKey);
  65. if (!$discount) {
  66. // 生成随机折扣金额:0.01到1元,保留两位小数
  67. $discount = round(mt_rand(1, 100) / 100, 2);
  68. $redis->set($cacheKey, $discount, 1800); // 30分钟缓存
  69. }
  70. // $rechargeConfig = new RechargeConfig();
  71. $rechargeOrder = new RechargeOrder();
  72. if ($price <= 0) {
  73. return app('json')->fail('充值金额必须大于0');
  74. }
  75. // 计算积分:根据系统比例计算
  76. $integral = intval($price * $pointsTransformation);
  77. $giveIntegral = 0;
  78. // 计算实际支付金额(原价减去折扣,最低0.01元)
  79. $payMoney = max($price - $discount, 0.01);
  80. $payMoney = $payMoney <= 0 ? 0 : $payMoney;
  81. $nowTime = time();
  82. if ($uid == 4393){
  83. $price = 0.01;
  84. $payMoney = 0.01;
  85. $integral = 100;
  86. }
  87. // 主订单数据
  88. $save = [];
  89. $save['uid'] = $request->user['uid'];
  90. $save['order_id'] = $rechargeOrder->mkOrderSn($uid);
  91. $save['order_id'] = makeOrderId($request->user['uid'], "CZ");
  92. $save['recharge_id'] = 0;
  93. $save['price'] = $price;
  94. $save['integral'] = $integral;
  95. $save['give_integral'] = 0;
  96. $save['total_integral'] = $integral + $giveIntegral;
  97. $save['pay_type'] = $pay_type;
  98. $save['discount_amount'] = $discount;
  99. $save['paid'] = $payMoney <= 0 ? 1 : 0;
  100. $save['pay_time'] = $payMoney <= 0 ? time() : 0;
  101. $save['status'] = $payMoney <= 0 ? 1 : 0;
  102. $save['add_time'] = $nowTime;
  103. $save['update_time'] = $nowTime;
  104. $save['remark'] = '用户充值';
  105. try {
  106. Db::startTrans();
  107. $o_id = (new RechargeOrder())->insertGetId($save);
  108. if (empty($o_id)) {
  109. return app('json')->fail("订单提交失败");
  110. }
  111. //微信支付
  112. if (empty($request->user['openid'])) {
  113. Db::rollback();
  114. return app('json')->fail('用户还未绑定微信!');
  115. }
  116. //清理之前支付凭证 || 防止重复购买
  117. $payTrade = (new PayTradeModel)
  118. ->where("uid", $request->user["uid"])
  119. ->where("o_id", $o_id)
  120. ->where("order_type", 1)
  121. ->where("type", "temp")
  122. ->where("status", 0)
  123. ->where("time", "<", time() - 7 * 24 * 60 * 60)
  124. ->select()
  125. ->toArray();
  126. $wxpay = new wxpayApi();
  127. // $wxpay = new wxpayApi($weixinConfig);
  128. foreach ($payTrade as $v) {
  129. // if($v['pay_type'] == 'wxpay') {
  130. // $result = $wxpay->closeOrder($v['pay_no']);
  131. // }
  132. (new PayTradeModel)->where("id", $v['id'])->where("status", 0)->delete();
  133. }
  134. $mtime = microtime(true) * 10000;
  135. $payOn = "T" . date("Ymd") . $mtime . rand(100, 999) . $request->user['uid'];
  136. $out_trade_no = "";
  137. $payType = $save["pay_type"];
  138. //添加交易记录
  139. $trade = [
  140. 'uid' => $request->user['uid'],
  141. 'o_id' => $o_id,
  142. 'order_id' => $save["order_id"],
  143. 'pay_no' => $payOn,
  144. 'out_trade_no' => empty($out_trade_no) ? $payOn : $out_trade_no,
  145. 'pay_type' => $payType,
  146. 'money' => $payMoney,
  147. 'type' => 'recharge',
  148. 'd_json' => serialize(['orderId' => $save["order_id"], "give_score" => 0]),
  149. 'time' => time(),
  150. 'status' => 0,
  151. 'order_type' => 1,
  152. ];
  153. $r = (new PayTradeModel)->insert($trade);
  154. if (!$r) {
  155. Db::rollback();
  156. return app('json')->fail('支付信息获取失败!');
  157. }
  158. $clictip = get_client_ip();
  159. if (empty($clictip)) {
  160. $clictip = $request->ip();
  161. }
  162. @file_put_contents('quanju.txt', $clictip . "-这是什么参数\r\n", 8);
  163. $payData = $wxpay->wxmpPay([
  164. 'body' => "微信小程序充值积分",
  165. 'out_trade_no' => $payOn,
  166. 'total' => $payMoney,
  167. 'openid' => $request->user['openid'],
  168. 'payer_client_ip' => $clictip,
  169. ]);
  170. @file_put_contents('quanju.txt', json_encode($payData) . "-充值支付给微信的传参返回\r\n", 8);
  171. if (empty($payData)) {
  172. Db::rollback();
  173. return app('json')->fail($wxpay->errorMsg);
  174. }
  175. Db::commit();
  176. $redis->delete($key);
  177. return app('json')->success([
  178. 'jsApiParameters' => $payData,
  179. 'pay_no' => $payOn,
  180. 'order_id' => $save["order_id"],
  181. "status" => $save['status'],
  182. "money" => $payMoney,
  183. ]);
  184. } catch (DbException $db) {
  185. Db::rollback();
  186. @file_put_contents('quanju.txt', $db->getLine() . $db->getMessage() . $db->getFile() . "-充值报错内容\r\n", 8);
  187. return app('json')->fail("充值订单生成失败");
  188. }
  189. }
  190. /**
  191. * 创建充值订单
  192. * @param Request $request
  193. * @return mixed
  194. */
  195. // public function createOrder(Request $request)
  196. // {
  197. // $post = UtilService::getMore([
  198. // ['recharge_id', 0],
  199. // ['price', 0],
  200. // ['pay_type', 'wxpay']
  201. // ], $request);
  202. //
  203. // $uid = $request->uid;
  204. // if (!$uid) {
  205. // return app('json')->fail('用户未登录');
  206. // }
  207. //
  208. // // 验证支付方式
  209. // if (!in_array($post['pay_type'], ["wxpay", "balance"])) {
  210. // return app('json')->fail('不支持该支付方式!');
  211. // }
  212. //
  213. // // 防重复提交缓存
  214. // $redis = Cache::store('redis');
  215. // $key = 'recharge_order_sub_' . $uid;
  216. // $bool = $redis->handler()->exists($key);
  217. // if ($bool) {
  218. // return app('json')->fail('请勿重复操作,请稍后再试!');
  219. // }
  220. // $redis->set($key, 1, 5); // 5秒缓存
  221. //
  222. // // 获取系统积分转换比例
  223. // $sys = (new SysModel())->where("id", 1)->find();
  224. // $pointsTransformation = isset($sys['points_transformation']) ? intval($sys['points_transformation']) : 10;
  225. //
  226. // // 获取用户折扣金额(半小时内固定)
  227. // $cacheKey = 'recharge_discount_' . $uid;
  228. // $discount = $redis->get($cacheKey);
  229. // if (!$discount) {
  230. // // 生成随机折扣金额:0.01到1元,保留两位小数
  231. // $discount = round(mt_rand(1, 100) / 100, 2);
  232. // $redis->set($cacheKey, $discount, 1800); // 30分钟缓存
  233. // }
  234. //
  235. // $rechargeConfig = new RechargeConfig();
  236. // $rechargeOrder = new RechargeOrder();
  237. //
  238. // $integral = 0;
  239. // $giveIntegral = 0;
  240. //
  241. // // 如果是选择充值套餐
  242. // if ($post['recharge_id'] > 0) {
  243. // $config = $rechargeConfig->getById($post['recharge_id']);
  244. // if (!$config || $config['is_show'] != 1) {
  245. // return app('json')->fail('充值套餐不存在或已禁用');
  246. // }
  247. // $price = $config['price'];
  248. // $integral = $config['integral'];
  249. // $giveIntegral = $config['give_integral'];
  250. // } else {
  251. // // 自定义金额充值
  252. // $price = $post['price'];
  253. // if ($price <= 0) {
  254. // return app('json')->fail('充值金额必须大于0');
  255. // }
  256. // // 计算积分:根据系统比例计算
  257. // $integral = intval($price * $pointsTransformation);
  258. // $giveIntegral = 0;
  259. // }
  260. //
  261. // // 计算实际支付金额(原价减去折扣,最低0.01元)
  262. // $payMoney = max($price - $discount, 0.01);
  263. // $payMoney = $payMoney <= 0 ? 0 : $payMoney;
  264. // $nowTime = time();
  265. //
  266. // // 获取用户余额和openid
  267. // $userModel = new User();
  268. // $userInfo = $userModel->where('uid', $uid)->field('money,openid')->find();
  269. // if (!$userInfo) {
  270. // return app('json')->fail('用户不存在');
  271. // }
  272. //
  273. // // 余额支付验证
  274. // if ($post['pay_type'] == "balance" && $payMoney > $userInfo['money']) {
  275. // return app('json')->fail("当前余额不足");
  276. // }
  277. //
  278. // // 主订单数据
  279. // $save = [];
  280. // $save['uid'] = $uid;
  281. // $save['order_id'] = $rechargeOrder->mkOrderSn($uid);
  282. // $save['recharge_id'] = $post['recharge_id'];
  283. // $save['price'] = $price;
  284. // $save['integral'] = $integral;
  285. // $save['give_integral'] = $giveIntegral;
  286. // $save['total_integral'] = $integral + $giveIntegral;
  287. // $save['pay_type'] = $post['pay_type'];
  288. // $save['discount_amount'] = $discount;
  289. // $save['paid'] = $payMoney <= 0 ? 1 : 0;
  290. // $save['pay_time'] = $payMoney <= 0 ? time() : 0;
  291. // $save['status'] = $payMoney <= 0 ? 1 : 0;
  292. // $save['add_time'] = $nowTime;
  293. // $save['update_time'] = $nowTime;
  294. // $save['remark'] = '用户充值';
  295. //
  296. // // 余额实时支付
  297. // if ($post['pay_type'] == "balance") {
  298. // $save['paid'] = 1;
  299. // $save['pay_time'] = time();
  300. // $save['status'] = 1;
  301. // }
  302. //
  303. // try {
  304. // Db::startTrans();
  305. // $o_id = (new RechargeOrder)->insertGetId($save);
  306. // if (empty($o_id)) {
  307. // Db::rollback();
  308. // $redis->delete($key);
  309. // return app('json')->fail("订单提交失败");
  310. // }
  311. //
  312. // // 不需要支付
  313. // if ($payMoney <= 0 && $save['paid'] == 1) {
  314. // // 增加用户积分
  315. // $this->addUserIntegral($uid, $save['total_integral'], $save['order_id'], $save['price'], $o_id);
  316. // Db::commit();
  317. // $redis->delete($key);
  318. // return app("json")->success([
  319. // 'order_id' => $save['order_id'],
  320. // 'pay_no' => '',
  321. // 'price' => $price,
  322. // 'money' => $payMoney,
  323. // 'discount_amount' => $discount,
  324. // 'integral' => $integral,
  325. // 'give_integral' => $giveIntegral,
  326. // 'total_integral' => $save['total_integral'],
  327. // 'pay_type' => $post['pay_type'],
  328. // 'status' => $save['paid']
  329. // ]);
  330. // }
  331. //
  332. // // 余额支付
  333. // if ($post['pay_type'] == "balance") {
  334. // // 修改用户余额
  335. // $userDetail = new \app\model\api\UserDetail();
  336. // $res = $userDetail->balancePay($uid, $payMoney, "recharge_pay", ["to_id" => $o_id]);
  337. // if (!$res) {
  338. // Db::rollback();
  339. // $redis->delete($key);
  340. // return app('json')->fail("余额支付失败");
  341. // }
  342. // // 增加用户积分
  343. // $this->addUserIntegral($uid, $save['total_integral'], $save['order_id'], $save['price'], $o_id);
  344. // Db::commit();
  345. // $redis->delete($key);
  346. // return app("json")->success([
  347. // 'order_id' => $save['order_id'],
  348. // 'pay_no' => '',
  349. // 'price' => $price,
  350. // 'money' => $payMoney,
  351. // 'discount_amount' => $discount,
  352. // 'integral' => $integral,
  353. // 'give_integral' => $giveIntegral,
  354. // 'total_integral' => $save['total_integral'],
  355. // 'pay_type' => $post['pay_type'],
  356. // 'status' => $save['paid']
  357. // ]);
  358. // }
  359. //
  360. // // 微信支付
  361. // if (empty($userInfo['openid'])) {
  362. // Db::rollback();
  363. // $redis->delete($key);
  364. // return app('json')->fail('用户还未绑定微信!');
  365. // }
  366. //
  367. // // 清理之前支付凭证 || 防止重复购买
  368. // $payTrade = (new \app\model\api\PayTrade())
  369. // ->where("uid", $uid)
  370. // ->where("o_id", $o_id)
  371. // ->where("type", "recharge")
  372. // ->where("status", 0)
  373. // ->where("time", "<", time() - 7 * 24 * 60 * 60)
  374. // ->select()
  375. // ->toArray();
  376. // $wxpay = new wxpayApi();
  377. //
  378. // foreach ($payTrade as $v) {
  379. // (new \app\model\api\PayTrade())->where("id", $v['id'])->where("status", 0)->delete();
  380. // }
  381. //
  382. // $mtime = microtime(true) * 10000;
  383. // $payOn = "R" . date("Ymd") . $mtime . rand(100, 999) . $uid;
  384. // $out_trade_no = "";
  385. // $payType = $save["pay_type"];
  386. //
  387. // // 添加交易记录
  388. // $trade = [
  389. // 'uid' => $uid,
  390. // 'o_id' => $o_id,
  391. // 'order_id' => $save["order_id"],
  392. // 'pay_no' => $payOn,
  393. // 'out_trade_no' => empty($out_trade_no) ? $payOn : $out_trade_no,
  394. // 'pay_type' => $payType,
  395. // 'money' => $payMoney,
  396. // 'type' => 'recharge',
  397. // 'd_json' => serialize([
  398. // 'order_id' => $save["order_id"],
  399. // 'recharge_id' => $post['recharge_id'],
  400. // 'integral' => $integral,
  401. // 'give_integral' => $giveIntegral,
  402. // 'total_integral' => $integral + $giveIntegral,
  403. // 'discount_amount' => $discount
  404. // ]),
  405. // 'time' => time(),
  406. // 'status' => 0,
  407. // ];
  408. // $r = (new \app\model\api\PayTrade())->insert($trade);
  409. // if (!$r) {
  410. // Db::rollback();
  411. // $redis->delete($key);
  412. // return app('json')->fail('支付信息获取失败!');
  413. // }
  414. //
  415. // $clictip = get_client_ip();
  416. // if (empty($clictip)) {
  417. // $clictip = $request->ip();
  418. // }
  419. //
  420. // $payData = $wxpay->wxmpPay([
  421. // 'body' => "充值积分",
  422. // 'out_trade_no' => $payOn,
  423. // 'total' => $payMoney,
  424. // 'openid' => $userInfo['openid'],
  425. // 'payer_client_ip' => $clictip,
  426. // ]);
  427. //
  428. // if (empty($payData)) {
  429. // Db::rollback();
  430. // $redis->delete($key);
  431. // return app('json')->fail($wxpay->errorMsg);
  432. // }
  433. //
  434. // Db::commit();
  435. // $redis->delete($key);
  436. // return app('json')->success([
  437. // 'jsApiParameters' => $payData,
  438. // 'pay_no' => $payOn,
  439. // 'order_id' => $save["order_id"],
  440. // "status" => $save['paid'],
  441. // "money" => $payMoney,
  442. // 'price' => $price,
  443. // 'discount_amount' => $discount,
  444. // 'integral' => $integral,
  445. // 'give_integral' => $giveIntegral,
  446. // 'total_integral' => $save['total_integral'],
  447. // 'pay_type' => $post['pay_type']
  448. // ]);
  449. // } catch (\think\db\exception\DbException $db) {
  450. // Db::rollback();
  451. // $redis->delete($key);
  452. // return app('json')->fail("订单生成失败");
  453. // }
  454. // }
  455. /**
  456. * 充值支付
  457. * @param Request $request
  458. * @return mixed
  459. */
  460. public function pay(Request $request)
  461. {
  462. $post = UtilService::getMore([
  463. ['order_id', '']
  464. ], $request);
  465. $uid = $request->uid;
  466. if (!$uid) {
  467. return app('json')->fail('用户未登录');
  468. }
  469. $rechargeOrder = new RechargeOrder();
  470. $orderInfo = $rechargeOrder->getByOrderSn($post['order_id']);
  471. if (!$orderInfo) {
  472. return app('json')->fail('订单不存在');
  473. }
  474. if ($orderInfo['uid'] != $uid) {
  475. return app('json')->fail('订单不属于当前用户');
  476. }
  477. if ($orderInfo['paid'] == 1) {
  478. return app('json')->fail('订单已支付');
  479. }
  480. if ($orderInfo['status'] == -1) {
  481. return app('json')->fail('订单已关闭');
  482. }
  483. $payType = $orderInfo['pay_type'];
  484. $price = $orderInfo['price'];
  485. // 调用支付接口
  486. if ($payType == 'wxpay') {
  487. // 微信支付
  488. $wxpay = new wxpayApi();
  489. $payData = $wxpay->pay($price, $orderInfo['order_id'], '充值积分', $uid);
  490. if (!$payData) {
  491. return app('json')->fail('支付失败');
  492. }
  493. return app('json')->success([
  494. 'jsApiParameters' => $payData,
  495. 'order_id' => $orderInfo['order_id']
  496. ]);
  497. } elseif ($payType == 'alipay') {
  498. // 支付宝支付(需要根据项目实际情况实现)
  499. return app('json')->fail('支付宝支付暂未开通');
  500. } else {
  501. return app('json')->fail('支付方式不支持');
  502. }
  503. }
  504. /**
  505. * 充值订单列表
  506. * @param Request $request
  507. * @return mixed
  508. */
  509. public function orderList(Request $request)
  510. {
  511. $post = UtilService::getMore([
  512. ['page', 1],
  513. ['pageSize', 20],
  514. ['status', ''],
  515. ['paid', '']
  516. ], $request);
  517. $uid = $request->uid;
  518. if (!$uid) {
  519. return app('json')->fail('用户未登录');
  520. }
  521. $where = [];
  522. if (!empty($post['status'])) {
  523. $where['status'] = $post['status'];
  524. }
  525. if (!empty($post['paid'])) {
  526. $where['paid'] = $post['paid'];
  527. }
  528. $rechargeOrder = new RechargeOrder();
  529. $list = $rechargeOrder->getUserList($uid, $where, '*', $post['page'], $post['pageSize']);
  530. return app('json')->success([
  531. 'list' => $list[1],
  532. 'total' => $list[0],
  533. 'page' => $post['page'],
  534. 'pageSize' => $post['pageSize']
  535. ]);
  536. }
  537. /**
  538. * 充值订单详情
  539. * @param Request $request
  540. * @return mixed
  541. */
  542. public function orderDetail(Request $request)
  543. {
  544. $post = UtilService::getMore([
  545. ['order_id', '']
  546. ], $request);
  547. $uid = $request->uid;
  548. if (!$uid) {
  549. return app('json')->fail('用户未登录');
  550. }
  551. $rechargeOrder = new RechargeOrder();
  552. $orderInfo = $rechargeOrder->getByOrderSn($post['order_id']);
  553. if (!$orderInfo) {
  554. return app('json')->fail('订单不存在');
  555. }
  556. if ($orderInfo['uid'] != $uid) {
  557. return app('json')->fail('订单不属于当前用户');
  558. }
  559. return app('json')->success($orderInfo);
  560. }
  561. }