Pay.php 50 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use app\common\library\Email;
  5. use app\common\library\Ems as Emslib;
  6. use blockchain\TronService;
  7. use blockchain\Web3Service;
  8. use fast\Random;
  9. use GuzzleHttp\Exception\RequestException;
  10. use think\Exception;
  11. use think\Validate;
  12. use think\Db;
  13. use app\common\model\MoneyLog;
  14. use Tron\Address;
  15. /**
  16. * 会员接口
  17. */
  18. class Pay extends Api
  19. {
  20. protected $noNeedLogin = ['notify', 'notifycz', 'notifydsf'];
  21. protected $noNeedRight = '*';
  22. public function _initialize()
  23. {
  24. parent::_initialize();
  25. $this->Usermodel = model('User');
  26. }
  27. public function index()
  28. {
  29. // // 启动事务
  30. // Db::startTrans();
  31. // try {
  32. if (input('id', 0) > 0) {
  33. $id = input('id');
  34. $data = Db::name('task')->where('id', $id)->find();
  35. if ($data) {
  36. $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  37. Db::name('task')->where('id', $id)->update(['out_trade_no' => $number, 'buytype' => input('buytype')]);
  38. $data = Db::name('task')->where('id', $id)->find();
  39. } else {
  40. $this->error(__('订单数据不对'));
  41. }
  42. } else {
  43. $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  44. if (!input('price')) {
  45. $this->error(__('金额不对'));
  46. }
  47. $datapost = input('param.');//订单数据
  48. $datapost['buzs'] = htmlspecialchars_decode($datapost['buzs']);
  49. if (input('endtime') == '数量完成自动结束') {
  50. $endtimesjc = 100000000000;
  51. } else {
  52. $endtimesjc = strtotime(input('endtime'));
  53. }
  54. $up = [
  55. 'type' => input('type'),
  56. 'uid' => input('uid'),
  57. 'name' => input('name'),
  58. 'rwurl' => input('rwurl'),
  59. 'buz' => $datapost['buzs'],
  60. 'price' => input('price'),
  61. 'sum' => input('sum'),
  62. 'sumsy' => input('sum'),
  63. 'endtime' => input('endtime'),
  64. 'subtime' => input('subtime'),
  65. 'shetime' => input('shetime'),
  66. 'endtimesjc' => $endtimesjc,
  67. 'buytype' => input('buytype'),
  68. 'zprice' => input('price') * input('sum'),
  69. 'out_trade_no' => $number,
  70. 'createtime' => time(),
  71. ];
  72. $id = Db::name('task')->insertGetId($up);
  73. $data = $up;
  74. }
  75. $site = config('site');
  76. $amount = $data['zprice'];
  77. if (!$amount) {
  78. $this->error(__('金额不对'));
  79. }
  80. // 异步通知地址
  81. $notify_url = $site['zfb']['notifyurl'];
  82. // 订单标题
  83. $subject = 'wool订单';
  84. // 订单详情
  85. $body = 'wool致力于打造最好的移动服务平台';
  86. // 订单号,示例代码使用时间值作为唯一的订单ID号
  87. if ($data['buytype'] == '支付宝') {
  88. $this->allpay($amount, $subject, $body, $number, $notify_url);
  89. } else if ($data['buytype'] == '余额') {
  90. $this->yuepay($amount, input('uid'), $id);
  91. }
  92. // // 提交事务
  93. // Db::commit();
  94. // } catch (\Exception $e) {
  95. // // 回滚事务
  96. // var_dump($e);
  97. // Db::rollback();
  98. // }
  99. }
  100. public function videopay()
  101. {
  102. $datavideo_order = Db::name('video_order')->where(['sid' => input('id'), 'uid' => input('uid'), 'lx' => 2])->find();
  103. $datavideo_order1 = Db::name('video_order')->where(['sid' => input('id'), 'uid' => input('uid'), 'lx' => 1])->find();
  104. $sad = 1;
  105. $lx = input('lx');
  106. if ($datavideo_order1) {
  107. if ($datavideo_order1['type'] == 2) {
  108. $sad = 2;
  109. $this->error(__('已经全集购买'));
  110. }
  111. }
  112. if ($datavideo_order and $lx == 2) {
  113. if ($datavideo_order['type'] == 2) {
  114. $this->error(__('已经单集购买'));
  115. }
  116. $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  117. $price = input('priceq');
  118. $pricebuy = input('pricebuy');
  119. if (input('lx') == 2) {
  120. $price = input('priced');
  121. $pricebuy = input('pricebuy');
  122. }
  123. $up = [
  124. 'type' => 1,
  125. 'lx' => $lx,//1 全章购买 2单集购买
  126. 'uid' => input('uid'),
  127. 'name' => input('namet'),
  128. 'img' => input('img'),
  129. 'price' => $price,
  130. 'sum' => input('sum'),
  131. 'sid' => input('pid'),
  132. 'smid' => input('smid'),
  133. 'paytype' => input('buytype'),
  134. 'zprice' => $pricebuy * input('sum'),
  135. 'out_trade_no' => $number,
  136. ];
  137. Db::name('video_order')->where(['id' => $datavideo_order['id']])->update($up);
  138. $id = $datavideo_order['id'];
  139. $data = $up;
  140. } else {
  141. $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  142. if (!input('pricebuy')) {
  143. $this->error(__('金额不对'));
  144. }
  145. $price = input('priceq');
  146. $pricebuy = input('pricebuy');
  147. if (input('lx') == 2) {
  148. $price = input('priced');
  149. $pricebuy = input('pricebuy');
  150. }
  151. $up = [
  152. 'type' => 1,
  153. 'lx' => $lx,//1 全章购买 2单集购买
  154. 'uid' => input('uid'),
  155. 'name' => input('namet'),
  156. 'img' => input('img'),
  157. 'price' => $price,
  158. 'sum' => input('sum'),
  159. 'sid' => input('pid'),
  160. 'smid' => input('smid'),
  161. 'paytype' => input('buytype'),
  162. 'zprice' => $pricebuy * input('sum'),
  163. 'out_trade_no' => $number,
  164. 'createtime' => time(),
  165. 'updatetime' => time(),
  166. ];
  167. //$this->error($up);
  168. $id = Db::name('video_order')->insertGetId($up);
  169. $data = $up;
  170. }
  171. $site = config('site');
  172. $amount = $data['zprice'];
  173. if (!$amount) {
  174. $this->error(__('金额不对'));
  175. }
  176. // 异步通知地址
  177. $notify_url = $site['zfb']['notifyurl'];
  178. // 订单标题
  179. $subject = 'wool订单';
  180. // 订单详情
  181. $body = 'wool致力于打造最好的移动服务平台';
  182. // 订单号,示例代码使用时间值作为唯一的订单ID号
  183. //var_dump($data['paytype']);
  184. if ($data['paytype'] == '支付宝') {
  185. $this->allpay($amount, $subject, $body, $number, $notify_url);
  186. } else if ($data['paytype'] == '余额') {
  187. $this->videoyuepay($amount, input('uid'), $id);
  188. } else if ($data['paytype'] == '微信') {
  189. $wxlx = input('wxlx');
  190. if ($wxlx == 'wxxcx') {
  191. $openid = input('openid');
  192. if (!$openid) {
  193. $this->error(__('openid不对'));
  194. }
  195. $this->paywxxcx($id, $number, $amount, $openid);
  196. } else if ($wxlx == 'wxh5') {
  197. $buytype = '微信h5';
  198. $this->paywxh5($id, $number, $amount, $buytype);
  199. } else if ($wxlx == 'wxgzh') {
  200. $buytype = '微信公众号';
  201. $this->paywxh5($id, $number, $amount, $buytype);
  202. }
  203. } else if ($data['paytype'] == '汇聚') {
  204. $paid_price = 0;
  205. // if ($recharId) {
  206. // $data = SystemGroupData::getDateValue($recharId);
  207. // if ($data === false) {
  208. // return app('json')->fail('您选择的充值方式已下架!');
  209. // } else {
  210. // $paid_price = $data['give_money'] ?? 0;
  211. // }
  212. // }
  213. // $rechargeOrder = UserRecharge::addRecharge($request->uid(), $price, 'huifu', $paid_price);
  214. $recharge = Huifu::wxJsPay(session('openid'), $number, $price, $paid_price, 'video_pay');
  215. // return app('json')->successful(['type' => $from, 'data' => $recharge]);
  216. }
  217. }
  218. public function paywxh5($oid, $number, $amount, $buytype)
  219. {
  220. $site = config('site');
  221. $user = $this->auth->getUser();
  222. if (!$user) {
  223. $this->error(__('user不对'));
  224. }
  225. if ($amount <= 0) {
  226. $this->error(__('金额不对'));
  227. }
  228. $up = [
  229. 'type' => 1,
  230. 'uid' => $user['id'],
  231. 'tdnum' => input('tdnum'),//支付通道
  232. 'amount' => $amount,
  233. 'out_trade_no' => $number,
  234. 'createtime' => time(),
  235. 'buytype' => $buytype,
  236. 'oid' => $oid,
  237. ];
  238. $id = Db::name('paylog')->insertGetId($up);
  239. $urls = $site['imgurl'] . '/index/paydsf/wxh5?out_trade_no=' . $number;
  240. if ($buytype == '微信公众号') {
  241. $urls = $site['imgurl'] . '/index/index/pay?id=' . $id;
  242. }
  243. $this->success('订单提交成功 正在跳转支付', $urls);
  244. }
  245. public function paywxxcx($oid, $number, $amount, $openid)
  246. {
  247. $site = config('site');
  248. $user = $this->auth->getUser();
  249. if (!$user) {
  250. $this->error(__('user不对'));
  251. }
  252. if ($amount <= 0) {
  253. $this->error(__('金额不对'));
  254. }
  255. $up = [
  256. 'type' => 1,
  257. 'uid' => $user['id'],
  258. 'amount' => $amount,
  259. 'out_trade_no' => $number,
  260. 'createtime' => time(),
  261. 'buytype' => '微信小程序',
  262. 'oid' => $oid,
  263. ];
  264. $id = Db::name('paylog')->insertGetId($up);
  265. $modelxcx = new \app\api\controller\Paywx;
  266. $trs = $modelxcx->wxxcx($number, $amount, $openid);
  267. $this->success('提交成功', $trs);
  268. }
  269. public function videoyuepay($money, $user_id, $id)//余额支付
  270. {
  271. $user = $this->Usermodel::get($user_id);
  272. if ($user && $money != 0) {
  273. $data = Db::name('video_order')->where('id', $id)->find();
  274. if ($user->money < $money) {
  275. $this->error(__('余额不足'));
  276. }
  277. $before = $user->money;
  278. $after = $user->money - $money;
  279. if ($data['type'] == 1) {
  280. Db::startTrans();
  281. try {
  282. //更新会员信息
  283. $user->save(['money' => $after]);
  284. //写入日志
  285. MoneyLog::create(['user_id' => $user_id, 'money' => $money, 'before' => $before, 'after' => $after, 'memo' => '用户消费']);
  286. Db::name('video_order')->where('id', $id)->update(['type' => 2, 'paytype' => '余额', 'ftime' => time()]);
  287. $this->yongjin($id, $user_id, $money, '级消费佣金结算');//佣金结算
  288. $this->dailiyongjin($id, $data['sid'], $data['smid'], $user_id, $money, '佣金结算');//后台代理佣金结算
  289. Db::commit();
  290. $this->success(__('操作成功'));
  291. } catch (Exception $e) {
  292. Db::rollback();
  293. $this->error($e->getMessage());
  294. }
  295. } else if ($data['type'] > 1) {
  296. $this->error(__('已经支付'));
  297. }
  298. } else {
  299. $this->error(__('金额不对'));
  300. }
  301. }
  302. public function yuepay($money, $user_id, $id)//余额支付
  303. {
  304. $user = $this->Usermodel::get($user_id);
  305. if ($user && $money != 0) {
  306. $data = Db::name('task')->where('id', $id)->find();
  307. if ($user->money < $money) {
  308. $this->error(__('余额不足'));
  309. }
  310. $before = $user->money;
  311. $after = $user->money - $money;
  312. //更新会员信息
  313. $user->save(['money' => $after]);
  314. //写入日志
  315. MoneyLog::create(['user_id' => $user_id, 'money' => $money, 'before' => $before, 'after' => $after, 'memo' => '用户消费']);
  316. if ($data['paytype'] == 1) {
  317. $up = [
  318. 'paytype' => 2,
  319. 'buytype' => '余额',
  320. 'ftime' => time()
  321. ];
  322. if (Db::name('task')->where('id', $id)->update($up)) {
  323. $this->success(__('操作成功'));
  324. }
  325. } else if ($data['paytype'] > 1) {
  326. $this->error(__('已经支付'));
  327. }
  328. } else {
  329. $this->error(__('金额不对'));
  330. }
  331. }
  332. public function czpay()
  333. {
  334. $site = config('site');
  335. $user = $this->auth->getUser();
  336. if (!$user) {
  337. $this->error(__('user不对'));
  338. }
  339. $number = date('ymdh', time()) . rand(10000, 99999);//订单编
  340. $amount = input('total', 0);
  341. $notify_url = $site['zfb']['notifyurlcz'];
  342. // 订单标题
  343. $subject = 'wool充值';
  344. // 订单详情
  345. $body = 'wool致力于打造最好的移动服务平台';
  346. if ($amount <= 0) {
  347. $this->error(__('金额不对'));
  348. }
  349. $up = [
  350. 'type' => 1,
  351. 'uid' => $user['id'],
  352. 'amount' => input('total'),
  353. 'out_trade_no' => $number,
  354. 'createtime' => time(),
  355. ];
  356. $id = Db::name('paylog')->insertGetId($up);
  357. if (input('type', 'allpay') == 'iap') {
  358. $this->success('请求成功', $number);
  359. } else {
  360. $this->allpay($amount, $subject, $body, $number, $notify_url);
  361. }
  362. }
  363. public function dsfczpay()
  364. {
  365. $site = config('site');
  366. $user = $this->auth->getUser();
  367. if (!$user) {
  368. $this->error(__('user不对'));
  369. }
  370. $number = date('ymdh', time()) . rand(10000, 99999);//订单编
  371. $amount = input('total', 0);
  372. if ($amount <= 0) {
  373. $this->error(__('金额不对'));
  374. }
  375. $up = [
  376. 'type' => 1,
  377. 'uid' => $user['id'],
  378. 'tdnum' => input('tdnum'),
  379. 'amount' => $amount,
  380. 'out_trade_no' => $number,
  381. 'createtime' => time(),
  382. 'buytype' => isset($site['dsfzf']['zfname']) ? $site['dsfzf']['zfname'] : '',
  383. ];
  384. $id = Db::name('paylog')->insertGetId($up);
  385. $urls = $site['imgurl'] . '/index/paydsf?out_trade_no=' . $number;
  386. $this->success('订单提交成功 正在跳转支付', $urls);
  387. }
  388. public function czpayiaptz()
  389. {
  390. $out_trade_no = input('out_trade_no');
  391. $order = Db::name('paylog')->where('out_trade_no', $out_trade_no)->find();
  392. //$this->dingding_log($order);
  393. if ($order['type'] == 1) {
  394. $up = [
  395. 'type' => 2,
  396. 'payment' => null,
  397. 'trade_no' => null,
  398. 'buyer' => null,
  399. 'buytype' => '苹果',
  400. 'ftime' => time()
  401. ];
  402. Db::startTrans();
  403. try {
  404. $this->money($order['amount'], $order['uid'], 0, $sxf = 0);
  405. Db::name('paylog')->where('out_trade_no', $out_trade_no)->update($up);
  406. Db::commit();
  407. $this->success('支付成功');
  408. } catch (Exception $e) {
  409. Db::rollback();
  410. $this->error($e->getMessage());
  411. }
  412. } else {
  413. $this->success('已经支付');
  414. }
  415. }
  416. public function allpay($amount, $subject, $body, $out_trade_no, $notify_url)//支付宝支付
  417. {
  418. $total = floatval($amount);
  419. if (!$total) {
  420. $this->error(__('金额不对'));
  421. }
  422. //require_once('/vendor/alipayrsa2/AopSdk.php');
  423. //Vendor('AopSdk.alipayrsa2');
  424. // require_once './vendor/alipayrsa2/aop/AopClient.php';
  425. // require_once './vendor/alipayrsa2/aop/request/AlipayTradeAppPayRequest.php';
  426. vendor('alipayrsa2.AopSdk');
  427. $site = config('site');
  428. $aop = new \AopClient;
  429. $aop->gatewayUrl = "https://openapi.alipay.com/gateway.do";
  430. $aop->appId = $site['zfb']['appId'];
  431. //开发者私钥去头去尾去回车,一行字符串
  432. $aop->rsaPrivateKey = $site['zfb']['rsaPrivateKey'];
  433. $aop->format = "json";
  434. $aop->charset = "UTF-8";
  435. $aop->signType = "RSA2";
  436. //请填写支付宝公钥,一行字符串
  437. $aop->alipayrsaPublicKey = $site['zfb']['alipayrsaPublicKey'];
  438. //实例化具体API对应的request类,类名称和接口名称对应,当前调用接口名称:alipay.trade.app.pay
  439. $request = new \AlipayTradeAppPayRequest();
  440. //SDK已经封装掉了公共参数,这里只需要传入业务参数
  441. $bizcontent = "{\"body\":\"" . $body . "\","
  442. . "\"subject\": \"" . $subject . "\","
  443. . "\"out_trade_no\": \"" . $out_trade_no . "\","
  444. . "\"timeout_express\": \"30m\","
  445. . "\"total_amount\": \"" . $total . "\","
  446. . "\"product_code\":\"QUICK_MSECURITY_PAY\""
  447. . "}";
  448. $request->setNotifyUrl($notify_url);
  449. $request->setBizContent($bizcontent);
  450. //这里和普通的接口调用不同,使用的是sdkExecute
  451. $response = $aop->sdkExecute($request);
  452. // 注意:这里不需要使用htmlspecialchars进行转义,直接返回即可
  453. //$this->success(__('获取成功'),$response);
  454. echo $response;
  455. }
  456. //支付宝回调
  457. public function notify()
  458. {
  459. if ($_POST) {
  460. //Db::transaction(function () {
  461. if ($_POST['trade_status'] == 'TRADE_SUCCESS' or $_POST['trade_status'] == 'TRADE_FINISHED') {//处理交易完成或者支付成功的通知 //获取订单号
  462. $out_trade_no = $_POST['out_trade_no'];//交易号
  463. $trade_no = $_POST['trade_no'];//订单支付时间
  464. $gmt_payment = $_POST['gmt_payment'];//转换为时间戳
  465. $order = Db::name('task')->where('out_trade_no', $out_trade_no)->find();
  466. if ($order['paytype'] == 1) {
  467. $up = [
  468. 'paytype' => 2,
  469. 'payment' => $gmt_payment,
  470. 'trade_no' => $trade_no,
  471. 'buyer' => $_POST['buyer_logon_id'],
  472. 'buytype' => '支付宝',
  473. 'ftime' => time()
  474. ];
  475. if (Db::name('task')->where('out_trade_no', $out_trade_no)->update($up)) {
  476. echo 'success';
  477. }
  478. } else {
  479. echo 'success';
  480. }
  481. }
  482. //});
  483. }
  484. }
  485. public function notifycz()
  486. {
  487. if ($_POST) {
  488. //$this->dingding_log($_POST);
  489. //Db::transaction(function () {
  490. if ($_POST['trade_status'] == 'TRADE_SUCCESS' or $_POST['trade_status'] == 'TRADE_FINISHED') {//处理交易完成或者支付成功的通知 //获取订单号
  491. $out_trade_no = $_POST['out_trade_no'];//交易号
  492. $trade_no = $_POST['trade_no'];//订单支付时间
  493. $gmt_payment = $_POST['gmt_payment'];//转换为时间戳
  494. $order = Db::name('paylog')->where('out_trade_no', $out_trade_no)->find();
  495. //$this->dingding_log($order);
  496. if ($order['type'] == 1) {
  497. $up = [
  498. 'type' => 2,
  499. 'payment' => $gmt_payment,
  500. 'trade_no' => $trade_no,
  501. 'buyer' => $_POST['buyer_logon_id'],
  502. 'buytype' => '支付宝',
  503. 'ftime' => time()
  504. ];
  505. Db::startTrans();
  506. try {
  507. $this->money($order['amount'], $order['uid'], 0, $sxf = 0);
  508. Db::name('paylog')->where('out_trade_no', $out_trade_no)->update($up);
  509. Db::commit();
  510. echo 'success';
  511. } catch (Exception $e) {
  512. Db::rollback();
  513. $this->error($e->getMessage());
  514. }
  515. } else {
  516. echo 'success';
  517. }
  518. }
  519. //});
  520. }
  521. }
  522. public function notifydsf()//第三方充值回调
  523. {
  524. $this->dingding_log($_REQUEST);
  525. //Db::transaction(function () {
  526. $returncode = isset($_REQUEST["returncode"]) ? $_REQUEST["returncode"] : 1;
  527. if ($returncode == "00") {//处理交易完成或者支付成功的通知 //获取订单号
  528. $out_trade_no = isset($_REQUEST["orderid"]) ? $_REQUEST["orderid"] : '';
  529. $order = Db::name('paylog')->where('out_trade_no', $out_trade_no)->find();
  530. $this->dingding_log($order);
  531. if ($order['type'] == 1) {
  532. $up = [
  533. 'type' => 2,
  534. 'ftime' => time()
  535. ];
  536. Db::startTrans();
  537. try {
  538. $this->money($order['amount'], $order['uid'], 0, $sxf = 0);
  539. Db::name('paylog')->where('out_trade_no', $out_trade_no)->update($up);
  540. Db::commit();
  541. echo 'OK';
  542. } catch (Exception $e) {
  543. Db::rollback();
  544. $this->error($e->getMessage());
  545. }
  546. } else {
  547. echo 'OK';
  548. }
  549. }
  550. //});
  551. }
  552. public function money($money, $user_id, $id, $sxf = 0)
  553. {
  554. $user = $this->Usermodel::get($user_id);
  555. if ($user && $money != 0) {
  556. $before = $user->money;
  557. $after = $user->money + $money;
  558. //更新会员信息
  559. $user->save(['money' => $after]);
  560. //写入日志
  561. MoneyLog::create(['user_id' => $user_id, 'money' => $money, 'before' => $before, 'after' => $after, 'fid' => $id, 'sxf' => $sxf, 'memo' => '用户充值']);
  562. } else {
  563. $this->error(__('金额不对'));
  564. }
  565. }
  566. public function dingding_log($content)
  567. {
  568. $r = $_SERVER['DOCUMENT_ROOT'] . '/api_log/' . date('Y-m-d_H-i-s', time()) . '.txt';
  569. $fp = fopen($r, 'w+');
  570. fwrite($fp, "执行日期:" . date('Y-m-d H:i:s', time()) . ' ' . var_export($content, true));
  571. fclose($fp);
  572. }
  573. public function FromXml($xml)
  574. {
  575. //将XML转为array
  576. //禁止引用外部xml实体
  577. libxml_disable_entity_loader(true);
  578. $values = json_decode(json_encode(simplexml_load_string($xml, 'SimpleXMLElement', LIBXML_NOCDATA)), true);
  579. return $values;
  580. }
  581. public function sharepay()
  582. {
  583. // $datavideo_order=Db::name('video_share')->where(['vid'=>input('id'),'uid'=>input('uid')])->find();
  584. // $datavideo_order1=Db::name('video_share')->where(['sid'=>input('id'),'uid'=>input('uid'),'lx'=>1])->find();
  585. // $lx=input('lx');
  586. $num = input('num'); //购买的版权数量
  587. $uid = input('uid');
  588. $vid = input('vid');
  589. $user = Db::name('user')->where('id', $uid)->find();
  590. if (empty($user)){
  591. $this->error(__('用户不存在'));
  592. }
  593. if (empty($num)){
  594. $this->error(__('请输入数量'));
  595. }
  596. // 验证数量
  597. $user_num = Db::name('video_user')->where('uid', $uid)->where('vid', $vid)->find();
  598. if ($user_num) {
  599. $cs_num = $user_num['share'] + $num;
  600. if ($cs_num > 10 || $num > 10) {
  601. $this->error(__('单剧集购买版权不能超过10份'));
  602. }
  603. }
  604. $user_share = Db::name('videolist')->where('id', $vid)->value('share');
  605. if (empty($user_share)){
  606. $this->error(__('短剧不存在'));
  607. }
  608. $user_shares = bcsub($user_share , $num, 0);
  609. if ($user_shares < 0) {
  610. $this->error(__('该局总版权只剩下' . $user_share . '份'));
  611. }
  612. // if($datavideo_order){
  613. // if($datavideo_order['type']==2){
  614. // $this->error(__('该订单已支付'));
  615. // }
  616. // $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  617. // $price=input('priceq');
  618. // $pricebuy=input('pricebuy');
  619. // if(input('lx')==2){
  620. // $price=input('priced');
  621. // $pricebuy=input('pricebuy');
  622. // }
  623. // $up=[
  624. // 'type'=>1,
  625. // 'lx'=>$lx,//1 全章购买 2单集购买
  626. // 'uid'=>input('uid'),
  627. // 'name'=>input('namet'),
  628. // 'img'=>input('img'),
  629. // 'price'=>$price,
  630. // 'sum'=>input('sum'),
  631. // 'sid'=>input('pid'),
  632. // 'smid'=>input('smid'),
  633. // 'paytype'=>input('buytype'),
  634. // 'zprice'=>$pricebuy*input('sum'),
  635. // 'out_trade_no'=>$number,
  636. // ];
  637. // Db::name('video_order')->where(['id'=>$datavideo_order['id']])->update($up);
  638. // $id=$datavideo_order['id'];
  639. // $data=$up;
  640. // }else{
  641. $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  642. // if (!input('pricebuy')) {
  643. // $this->error(__('金额不对'));
  644. // }
  645. // $price = input('price');
  646. $price = Db::name('videolist')->where('id', input('vid'))->value('sharesprice');;
  647. // $pricebuy = input('pricebuy');
  648. // if(input('lx')==2){
  649. // $price=input('priced');
  650. // $pricebuy=input('pricebuy');
  651. // }
  652. // 获取当前时间的时间戳
  653. $now = time();
  654. // 计算三年后的时间戳
  655. $threeYearsLater = strtotime('+3 years', $now);
  656. $vname = Db::name('videolist')->where('id', input('vid'))->value('name');
  657. $total_price = $price * $num;
  658. $up = [
  659. 'type' => 1,
  660. 'uid' => input('uid'),
  661. 'vid' => input('vid'),
  662. 'vname' => $vname,
  663. 'num' => input('num'),
  664. 'price' => $price,
  665. 'total_price' => $total_price,
  666. 'paytype' => input('buytype'),
  667. 'out_trade_no' => $number,
  668. 'createtime' => time(),
  669. 'endtime' => $threeYearsLater,
  670. 'updatetime' => time(),
  671. ];
  672. //$this->error($up);
  673. $id = Db::name('video_share')->insertGetId($up);
  674. $data = $up;
  675. // }
  676. $site = config('site');
  677. $amount = $price;
  678. // $amount = $data['zprice'];
  679. // if (!$amount) {
  680. // $this->error(__('金额不对'));
  681. // }
  682. // 异步通知地址
  683. $notify_url = $site['zfb']['notifyurl'];
  684. // 订单标题
  685. $subject = 'wool订单';
  686. // 订单详情
  687. $body = 'wool致力于打造最好的移动服务平台';
  688. // 订单号,示例代码使用时间值作为唯一的订单ID号
  689. //var_dump($data['paytype']);
  690. if ($data['paytype'] == '支付宝') {
  691. $this->allpay($amount, $subject, $body, $number, $notify_url);
  692. } else if ($data['paytype'] == '余额') {
  693. $this->shareyuepay($amount, input('uid'), $id);
  694. } else if ($data['paytype'] == '微信') {
  695. $wxlx = input('wxlx');
  696. if ($wxlx == 'wxxcx') {
  697. $openid = input('openid');
  698. if (!$openid) {
  699. $this->error(__('openid不对'));
  700. }
  701. $this->paywxxcx($id, $number, $amount, $openid);
  702. } else if ($wxlx == 'wxh5') {
  703. $buytype = '微信h5';
  704. $this->paywxh5($id, $number, $amount, $buytype);
  705. } else if ($wxlx == 'wxgzh') {
  706. $buytype = '微信公众号';
  707. $this->paywxh5($id, $number, $amount, $buytype);
  708. } else if ($data['paytype'] == '汇聚') {
  709. $paid_price = 0;
  710. // if ($recharId) {
  711. // $data = SystemGroupData::getDateValue($recharId);
  712. // if ($data === false) {
  713. // return app('json')->fail('您选择的充值方式已下架!');
  714. // } else {
  715. // $paid_price = $data['give_money'] ?? 0;
  716. // }
  717. // }
  718. // $rechargeOrder = UserRecharge::addRecharge($request->uid(), $price, 'huifu', $paid_price);
  719. $recharge = Huifu::wxJsPay(session('openid'), $number, $price, $paid_price, 'share_pay');
  720. // return app('json')->successful(['type' => $from, 'data' => $recharge]);
  721. }
  722. }
  723. }
  724. // 判断订单的用户是否有上级以及判断推荐等级
  725. public function grade_sell($out_trade_no)
  726. {
  727. $order = Db::name('video_share')->where('out_trade_no', $out_trade_no)->find();
  728. $site = config('site');
  729. if ($order) {
  730. $user = Db::name('user')->where('id', $order['uid'])->find();
  731. while ($user['pid'] != 1) { //默认账号pid为1
  732. $user = Db::name('user')->where('id', $user['pid'])->find(); //上级用户信息
  733. $grade = $user['grade'];
  734. $video_user = Db::name('video_user')->where('uid', $user['id'])->where('vid', $order['vid'])->find();
  735. if (empty($video_user)) { //如果上级没有购买过该视频版权
  736. $up = [
  737. 'vid' => $order['vid'],
  738. 'vname' => $order['vname'],
  739. 'uid' => $user['id'],
  740. 'share' => 0,
  741. 'contribution' => 0,
  742. 'income' => 0,
  743. 'createtime' => time(),
  744. ];
  745. $id = Db::name('VideoUser')->insertGetId($up); //添加用户版权
  746. }
  747. $contribution = 0;
  748. $check = 0;
  749. // $sell = $video_user['sell'] + $order['num'];
  750. $sell = $user['sell'] + $order['num'];
  751. // switch ($video_user['grade']) {
  752. switch ($user['grade']) {
  753. case 0:
  754. $contribution = $site['gxz']['普通会员'] * $order['num'];
  755. if ($sell >= 30) {
  756. $check = 1;
  757. $sell = $sell - 30;
  758. }
  759. break;
  760. case 1:
  761. $contribution = $site['gxz']['初级合伙人'] * $order['num'];
  762. if ($sell >= 300) {
  763. $check = 1;
  764. $sell = $sell - 300;
  765. }
  766. break;
  767. case 2:
  768. $contribution = $site['gxz']['高级合伙人'] * $order['num'];
  769. if ($sell >= 3000) {
  770. $check = 1;
  771. $sell = $sell - 3000;
  772. }
  773. break;
  774. case 3:
  775. $contribution = $site['gxz']['董事'] * $order['num'];
  776. default:
  777. }
  778. if ($check == 1) {
  779. // $grade = $video_user['grade'] + 1;
  780. $grade = $user['grade'] + 1;
  781. }
  782. $after = $video_user['contribution'] + $contribution;
  783. // $res = Db::name('video_user')->where('uid', $user['id'])->where('vid', $order['vid'])->update(['sell' => $sell, 'contribution' => $after, 'grade' => $grade]);
  784. $res = Db::name('video_user')->where('uid', $user['id'])->where('vid', $order['vid'])->update(['contribution' => $after]);
  785. $res2 = Db::name('user')->where('id', $user['id'])->update(['grade' => $grade, 'sell' => $sell]);
  786. $up = [
  787. 'vid' => $order['vid'],
  788. 'vname' => $order['vname'],
  789. 'uid' => $user['uid'],
  790. 'link_id' => $order['id'],
  791. 'num' => $contribution,
  792. 'after' => $contribution,
  793. 'content' => '下级用户购买版权,获得贡献值',
  794. 'createtime' => time(),
  795. 'pm' => 0,
  796. ];
  797. $id = Db::name('VideoContributionRecord')->insertGetId($up);
  798. }
  799. }
  800. }
  801. // 添加贡献值记录 订单id
  802. public function share_record($id)
  803. {
  804. $order = Db::name('video_share')->where('id', $id)->find();
  805. if ($order) {
  806. $user = Db::name('video_user')->where('uid', $order['uid'])->where('vid', $order['vid'])->find();
  807. $contribution = $order['num'] + $user['contribution'];
  808. $up = [
  809. 'vid' => $order['vid'],
  810. 'vname' => $order['vname'],
  811. 'uid' => $user['uid'],
  812. 'link_id' => $order['id'],
  813. 'num' => $order['num'],
  814. 'after' => $contribution,
  815. 'content' => '用户购买版权,获得贡献值',
  816. 'createtime' => time(),
  817. 'pm' => 0,
  818. ];
  819. $id = Db::name('VideoContributionRecord')->insertGetId($up);
  820. $share = $user['share'] + $order['num'];
  821. // 添加版权和贡献值
  822. $res = Db::name('video_user')->where('uid', $user['uid'])->where('vid', $order['vid'])->update(['contribution' => $contribution, 'share' => $share]);
  823. }
  824. }
  825. public function shareyuepay($money, $user_id, $id)//版权余额支付
  826. {
  827. $user = $this->Usermodel::get($user_id);
  828. if ($user) {
  829. $data = Db::name('video_share')->where('id', $id)->find();
  830. if ($user->money < $money) {
  831. $this->error(__('余额不足'));
  832. }
  833. $before = $user->money;
  834. $after = $user->money - $money;
  835. if ($data['type'] == 1) {
  836. Db::startTrans();
  837. try {
  838. //更新会员信息
  839. $user->save(['money' => $after]);
  840. //写入日志
  841. MoneyLog::create(['user_id' => $user_id, 'money' => $money, 'before' => $before, 'after' => $after, 'memo' => '用户消费']);
  842. Db::name('video_share')->where('id', $id)->update(['type' => 2, 'paytype' => '余额', 'pay_time' => time()]);
  843. $video_user = Db::name('video_user')->where('uid', $user_id)->where('vid', $data['vid'])->find();
  844. if (empty($video_user)) { //判断用户是否购买过该视频版权
  845. $up = [
  846. 'vid' => $data['vid'],
  847. 'vname' => $data['vname'],
  848. 'uid' => $data['uid'],
  849. 'share' => $data['num'],
  850. 'contribution' => $data['num'],
  851. 'income' => 0,
  852. 'createtime' => time(),
  853. ];
  854. $id = Db::name('VideoUser')->insertGetId($up);
  855. }
  856. $this->share_record($id);//添加贡献值记录
  857. $this->yongjin($id, $user_id, $money, '级消费佣金结算');//佣金结算
  858. $this->dailiyongjin($id, $data['vid'], 0, $user_id, $money, '佣金结算');//后台代理佣金结算
  859. $this->grade_sell($data['out_trade_no']);//判断订单的用户是否有上级以及判断推荐等级)
  860. // 扣除短剧总版权
  861. $shares = Db::name('videolist')->where('id', $data['vid'])->value('share');
  862. $share = $shares - $data['num'];
  863. Db::name('videolist')->where('id', $data['vid'])->update(['share' => $share]);
  864. Db::commit();
  865. $this->success(__('操作成功'));
  866. } catch (Exception $e) {
  867. Db::rollback();
  868. $this->error($e->getMessage());
  869. }
  870. } else if ($data['type'] > 1) {
  871. $this->error(__('已经支付'));
  872. }
  873. } else {
  874. $this->error(__('用户不存在'));
  875. }
  876. }
  877. // u币充值(展示二维码)
  878. public function recharge()
  879. {
  880. $uid = input('uid');
  881. $recharge_type = input('type');
  882. $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  883. $user = Db::name('user')->where('id', $uid)->find();
  884. if (empty($user)) {
  885. $this->error(__('用户不存在'));
  886. }
  887. // $data = [
  888. // 'order_id'=> $number,
  889. // 'uid' => $uid,
  890. // 'paid' => 0,
  891. // 'add_time' => time()
  892. // ];
  893. $return = [];
  894. $address = Db::name('user_usdt_address')->where('uid', $uid)->find();
  895. if ($recharge_type == 'trx') {
  896. // $data['recharge_type']='trx';
  897. $return['address'] = $address['trx_address'];
  898. $return['16_address'] = $address['trx_16_address'];
  899. } elseif ($recharge_type == 'bsc') {
  900. // $data['recharge_type']='bsc';
  901. $return['address'] = $address['bsc_address'];
  902. }
  903. // Db::name('user_recharge')->insert($data);
  904. Db::name('user_usdt_address')->where('uid', $uid)->update(['last_recharge' => time()]);
  905. $this->success($return);
  906. }
  907. // 查询u币转账记录
  908. public function search_recharge()
  909. {
  910. $site = config('site');
  911. $email = new Email();
  912. $time = strtotime("-1 hours", time());
  913. $user_address = Db::name('user_usdt_address')->where('last_recharge', '>', $time)->order('last_recharge desc')->select();
  914. @file_put_contents("usdt.txt",json_encode($user_address). "-一小时内有过充值行为的人\r\n", 8);
  915. foreach ($user_address as $k => $v) {
  916. $user_info = Db::name('user')->where('id', $v['uid'])->find();
  917. // trx部分
  918. $service = TronService::instance('usdt');
  919. $time =bcmul($v['last_time'], 1000, 0);
  920. $info = $service->getTransfer($v['trx_address'], $time);
  921. @file_put_contents("usdt.txt",json_encode($info). "-trx转账记录\r\n", 8);
  922. foreach ($info['data'] as $k2 => $v2){
  923. $transaction_id = $v2['transaction_id'];
  924. $value =bcdiv($v2['value'], 1000000, 8);
  925. // $value3 = bcdiv($value, bcpow(10, get_token_info('bsc', 'USDT', 'decimal')), 12);
  926. // @file_put_contents("usdt.txt",$value3. "-另一种转换方式\r\n", 8);
  927. $be = DB::name('user_recharge')->where('hash', $transaction_id)->find();
  928. if ($be) { //hash重复
  929. continue;
  930. }
  931. $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  932. $data = [
  933. 'order_id' => $number,
  934. 'uid' => $v['uid'],
  935. 'paid' => 1,
  936. 'price' => $value,
  937. 'hash' => $transaction_id,
  938. 'recharge_type' => 'trx',
  939. 'pay_time' => time(),
  940. 'add_time' => time()
  941. ];
  942. Db::name('user_recharge')->insert($data);
  943. Db::name('user_usdt_address')->where('uid', $v['uid'])->update(['last_time' => time()]);
  944. $money = bcadd($user_info['money'], $value, 8);
  945. Db::name('user')->where('id', $v['uid'])->update(['money' => $money]);
  946. MoneyLog::create(['user_id' => $v['uid'], 'money' => $value, 'before' => $user_info['money'], 'after' => $money, 'memo' => '用户trx余额充值']);
  947. // 邮件
  948. @file_put_contents("usdt.txt",$site['mail_to']. "-邮箱\r\n", 8);
  949. $result = $email->to($site['mail_to'])
  950. ->subject('用户充值通知')
  951. ->message('用户'.$user_info['nickname'].'在trx交易链上充值了'.$value)
  952. ->send();
  953. }
  954. // bsc部分
  955. $service = Web3Service::instance('bsc', 'usdt', '');
  956. $info = $service->getLastTransfer([], [$v['bsc_address']], $v['last_time']);
  957. @file_put_contents("usdt.txt",json_encode($info). "-bsc转账记录\r\n", 8);
  958. foreach ($info as $k2 => $v2) {
  959. $value = $v2->params['value']->toString(); //金额
  960. $value2 = bcdiv($value, bcpow(10, get_token_info('bsc', 'USDT', 'decimal')), 12);
  961. $transactionHash = $v2->transactionHash;
  962. $be = DB::name('user_recharge')->where('hash', $transactionHash)->find();
  963. if ($be) { //hash重复
  964. continue;
  965. }
  966. $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  967. $data = [
  968. 'order_id' => $number,
  969. 'uid' => $v['uid'],
  970. 'paid' => 1,
  971. 'price' => $value2,
  972. 'hash' => $transactionHash,
  973. 'recharge_type' => 'bsc',
  974. 'pay_time' => time(),
  975. 'add_time' => time()
  976. ];
  977. Db::name('user_recharge')->insert($data);
  978. Db::name('user_usdt_address')->where('uid', $v['uid'])->update(['last_time' => time()]);
  979. $money = bcadd($user_info['money'], $value2, 8);
  980. Db::name('user')->where('id', $v['uid'])->update(['money' => $money]);
  981. MoneyLog::create(['user_id' => $v['uid'], 'money' => $value2, 'before' => $user_info['money'], 'after' => $money, 'memo' => '用户bsc余额充值']);
  982. $result = $email->to($site['mail_to'])
  983. ->subject('用户充值通知')
  984. ->message('用户'.$user_info['nickname'].'在bsc交易链上充值了'.$value.'币')
  985. ->send();
  986. }
  987. }
  988. $this->success('查询完成');
  989. }
  990. public function withdrawal(){
  991. $uid = input('uid');
  992. $address = input('address');
  993. $type = input('type');
  994. $img = input('img');
  995. $price = input('price');
  996. if (empty($address)&&empty($img)){
  997. $this->error(__('请上传地址或上传收款码'));
  998. }
  999. Db::name('txjl')->insert(['uid' => $uid, 'address' => $address, 'type' => $type, 'img' => $img,'money'=> $price,'iscl'=>1]);
  1000. $this->success('提交成功');
  1001. }
  1002. public function test()
  1003. {
  1004. // $email = new Email();
  1005. // $site = config('site');
  1006. // $user_info['nickname']= '昔拉';
  1007. // $value=11;
  1008. // $result = $email->to($site['mail_to'])
  1009. // ->subject('用户充值通知')
  1010. // ->message('用户'.$user_info['nickname'].'在trx交易链上充值了'.$value.'币')
  1011. // ->send();
  1012. // var_dump($result);
  1013. // die();
  1014. $a= self::base58ToHex('TQ1MKAJqumx3XaFiMtnajGxrE2nFaMhsGu');
  1015. $b = self::base58ToHex('TFRpdAs4SP1uoWcq8Kkx4769QQnJJGyPUX');
  1016. // var_dump($a);
  1017. // var_dump($b);die();
  1018. $service = TronService::instance('usdt');
  1019. $trxBalance = $service->balance('TQ1MKAJqumx3XaFiMtnajGxrE2nFaMhsGu'); //trx主币查询
  1020. var_dump($trxBalance);
  1021. $trcGasAddress = new Address(
  1022. 'TQ1MKAJqumx3XaFiMtnajGxrE2nFaMhsGu',
  1023. '0xed6a4d8cf092bee064b8fdd828980bdaf16700c483c5abfd6affb300c09a5423',
  1024. // '4199f98810123e30a27100af641ccdf03e37bca669'
  1025. $a
  1026. );
  1027. $balance = $service->tokenBalance($trcGasAddress); //trx代币查询
  1028. var_dump($balance);
  1029. $address = new Address(
  1030. 'TFRpdAs4SP1uoWcq8Kkx4769QQnJJGyPUX',
  1031. '0xf322ad257024b72be5a7bf09cbb58aec0bd89ee6de8bdd9858d4bcbdc0c84427',
  1032. // '413be12e20eb06a9110999b6566437f90da137bebb'
  1033. $b
  1034. );
  1035. $balance = $service->tokenBalance($address); //trx代币查询
  1036. var_dump($balance);
  1037. // $res2 = $service->transfer($address, $trcGasAddress, 0.1); //主币转账
  1038. // var_dump($res2);
  1039. // $tx_id = $res2['data']->txID;
  1040. // var_dump($tx_id);
  1041. $res = $service->tokenTransfer($trcGasAddress, $address, 0.0002); //代币转账
  1042. var_dump($res);
  1043. $tx_id = $res['data']->txID;
  1044. var_dump($tx_id);
  1045. $up = [
  1046. 'order_id' => $tx_id,
  1047. 'type' => 'trx',
  1048. 'is_gas' => 1,
  1049. 'from_address' => 'TQ1MKAJqumx3XaFiMtnajGxrE2nFaMhsGu',
  1050. 'to_address' => 'TFRpdAs4SP1uoWcq8Kkx4769QQnJJGyPUX',
  1051. 'createtime' => time(),
  1052. ];
  1053. $id = Db::name('summary_log')->insertGetId($up);
  1054. die();
  1055. // bsc
  1056. $service = Web3Service::instance('bsc', 'usdt','ba46d817b91ee27b701e1a02d2f2540ab8641d262650b6aaafe8caf2fa7b6d15');
  1057. $balance = $service->getTokenBalance('0xbfc3b2193653ebf94bfa3fe586627b9c01f26db9'); //bsc代币余额
  1058. var_dump($balance);
  1059. $gas_balance =$service->getBalance('0xbfc3b2193653ebf94bfa3fe586627b9c01f26db9'); //bsc主币余额
  1060. var_dump($gas_balance);
  1061. $res = $service->transferToken('0x83105BDFAc1a15DF3C22D019Ac2F2937AC1Ef098', 2);
  1062. var_dump($res);
  1063. // $site = config('site');
  1064. // var_dump($site['gxz']['普通会员']);
  1065. // var_dump($site['gxz']['初级合伙人']);
  1066. // var_dump($site['gxz']['高级合伙人']);
  1067. // var_dump($site['gxz']['董事']);
  1068. die();
  1069. $service = Web3Service::instance('bsc', 'usdt', '');
  1070. $info = $service->getLastTransfer([], ['0xbfc3b2193653ebf94bfa3fe586627b9c01f26db9'], 1748293200);
  1071. $user_info = Db::name('user')->where('id', 1571)->find();
  1072. foreach ($info as $k2 => $v2) {
  1073. $value = $v2->params['value']->toString(); //金额
  1074. $value2 = bcdiv($value, bcpow(10, get_token_info('bsc', 'TUSD', 'decimal')), 12);
  1075. $transactionHash = $v2->transactionHash;
  1076. $be = DB::name('user_recharge')->where('hash', $transactionHash)->find();
  1077. if ($be) { //hash重复
  1078. continue;
  1079. }
  1080. $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  1081. $data = [
  1082. 'order_id' => $number,
  1083. 'uid' => $user_info['id'],
  1084. 'paid' => 1,
  1085. 'price' => $value2,
  1086. 'hash' => $transactionHash,
  1087. 'recharge_type' => 'bsc',
  1088. 'pay_time' => time(),
  1089. 'add_time' => time()
  1090. ];
  1091. Db::name('user_recharge')->insert($data);
  1092. Db::name('user_usdt_address')->where('uid', $user_info['id'])->update(['last_time' => time()]);
  1093. $money = bcadd($user_info['money'], $value2, 8);
  1094. Db::name('user')->where('id', $user_info['id'])->update(['money' => $money]);
  1095. MoneyLog::create(['user_id' => $user_info['id'], 'money' => $value2, 'before' => $user_info['money'], 'after' => $money, 'memo' => '用户bsc余额充值']);
  1096. }
  1097. // foreach ($info as $k => $v) {
  1098. // $value = $v->params['value']->toString();
  1099. // var_dump($value);
  1100. // $transactionHash = $v->transactionHash;
  1101. // var_dump($transactionHash);
  1102. // $value = bcdiv($value, bcpow(10, get_token_info('bsc', 'TUSD', 'decimal')), 12); //把后面的0去掉
  1103. // var_dump($value);
  1104. // }
  1105. var_dump($info);
  1106. die();
  1107. // trx TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t
  1108. // $service = TronService::instance('usdt');
  1109. //
  1110. // $info = $service->getTransfer('TFRpdAs4SP1uoWcq8Kkx4769QQnJJGyPUX', 1748293200000);
  1111. // $user_info = Db::name('user')->where('id', 1571)->find();
  1112. // foreach ($info['data'] as $k2 => $v2){
  1113. // $transaction_id = $v2['transaction_id'];
  1114. // $value =bcdiv($v2['value'], 1000000, 0);
  1115. // $be = DB::name('user_recharge')->where('hash', $transaction_id)->find();
  1116. // if ($be) { //hash重复
  1117. // continue;
  1118. // }
  1119. // $number = date('ymdh', time()) . rand(10000, 99999);//订单编号
  1120. // $data = [
  1121. // 'order_id' => $number,
  1122. // 'uid' => 1571,
  1123. // 'paid' => 1,
  1124. // 'price' => $value,
  1125. // 'hash' => $transaction_id,
  1126. // 'type' => 'trx',
  1127. // 'pay_time' => time(),
  1128. // 'add_time' => time()
  1129. // ];
  1130. // Db::name('user_recharge')->insert($data);
  1131. // Db::name('user_usdt_address')->where('uid', 1571)->update(['last_time' => time()]);
  1132. // $money = bcadd($user_info['money'], $value, 18);
  1133. // Db::name('user')->where('id', 1571)->update(['money' => $money]);
  1134. // MoneyLog::create(['user_id' => 1571, 'money' => $value, 'before' => $user_info['money'], 'after' => $money, 'memo' => '用户trx余额充值']);
  1135. //
  1136. // }
  1137. // var_dump($info);die();
  1138. }
  1139. public static function base58ToHex($base58) {
  1140. // TRON 专用 Base58 字符集
  1141. $alphabet = '123456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz';
  1142. // 1. 将 Base58 转换为十进制大数
  1143. $num = '0';
  1144. for ($i = 0; $i < strlen($base58); $i++) {
  1145. $char = $base58[$i];
  1146. $pos = strpos($alphabet, $char);
  1147. if ($pos === false) {
  1148. throw new Exception("无效的 Base58 字符: $char");
  1149. }
  1150. $num = bcmul($num, '58');
  1151. $num = bcadd($num, (string)$pos);
  1152. }
  1153. // 2. 将十进制大数转换为十六进制
  1154. $hex = '';
  1155. while ($num !== '0') {
  1156. $remainder = bcmod($num, '16');
  1157. $hex = dechex((int)$remainder) . $hex;
  1158. $num = bcdiv($num, '16', 0);
  1159. }
  1160. // 3. 添加前导零(每个前导'1'对应一个00)
  1161. $leadingZeros = '';
  1162. for ($i = 0; $i < strlen($base58) && $base58[$i] === '1'; $i++) {
  1163. $leadingZeros .= '00';
  1164. }
  1165. // 4. 组合并确保长度为50字符(25字节)
  1166. $hex = $leadingZeros . $hex;
  1167. $hex = str_pad($hex, 50, '0', STR_PAD_LEFT);
  1168. // 5. 提取地址部分并添加 TRON 前缀
  1169. // 跳过版本字节(0x41)和校验码(最后4字节)
  1170. $addressPart = substr($hex, 2, 40); // 取20字节地址
  1171. return '41' . $addressPart; // TRON 地址以0x41开头
  1172. }
  1173. }