ActivityController.php 53 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410
  1. <?php
  2. namespace App\Http\Controllers\Game;
  3. use App\dao\Estatisticas\RechargeWithDraw;
  4. use App\Facade\TableName;
  5. use App\Game\GlobalUserInfo;
  6. use App\Game\RePayConfig;
  7. use App\Game\Services\AgentService;
  8. use App\Game\Services\LZCompressor\LZString as LZ;
  9. use App\Game\Services\OuroGameService;
  10. use App\Game\Services\RouteService;
  11. use App\Game\Services\ServerService;
  12. use App\Game\WebActivity;
  13. use App\Game\WebChannelConfig;
  14. use App\Http\Controllers\Controller;
  15. use App\Game\RedEnvelopeConfig;
  16. use App\Game\RedEnvelopeLog;
  17. use App\Http\helper\Helper;
  18. use App\Http\helper\NumConfig;
  19. use App\Jobs\AfEvent;
  20. use App\Models\AccountsInfo;
  21. use App\Models\Order;
  22. use App\Models\PrivateMail;
  23. use App\Models\RecordUserDataStatistics;
  24. use App\Models\Treasure\GameScoreInfo;
  25. use App\Notification\TelegramBot;
  26. use App\Services\OrderServices;
  27. use App\Services\HolidayWheelService;
  28. use App\Services\ChristmasWheelService;
  29. use App\Services\PayConfig;
  30. use App\Services\SmartFastPay;
  31. use App\Services\StoredProcedure;
  32. use App\Util;
  33. use App\Utility\SetNXLock;
  34. use Illuminate\Http\Request;
  35. use Carbon\Carbon;
  36. use Illuminate\Support\Facades\DB;
  37. use Illuminate\Support\Facades\Hash;
  38. use Illuminate\Support\Facades\Log;
  39. use Illuminate\Support\Facades\Redis;
  40. use PDO;
  41. class ActivityController extends Controller
  42. {
  43. public function index()
  44. {
  45. }
  46. /**
  47. * 节假日大转盘 - 获取配置与用户状态
  48. */
  49. public function holidayWheelInfo(Request $request)
  50. {
  51. $user = $request->user();
  52. $userId = $user ? $user->UserID : 0;
  53. $service = new HolidayWheelService();
  54. $info = $service->getWheelInfo($userId);
  55. return apiReturnSuc($info);
  56. }
  57. /**
  58. * 节假日大转盘 - 抽奖
  59. */
  60. public function holidayWheelSpin(Request $request)
  61. {
  62. $user = $request->user();
  63. if (!$user) {
  64. // return apiReturnFail('请先登录');
  65. return apiReturnFail(['web.activity.login_required', __('messages.web.activity.login_required')]); // 请先登录
  66. }
  67. $service = new HolidayWheelService();
  68. try {
  69. $result = $service->spin($user->UserID);
  70. return apiReturnSuc($result);
  71. } catch (\Throwable $e) {
  72. \Log::error('holiday wheel spin failed', [
  73. 'user_id' => $user->UserID,
  74. 'error' => $e->getMessage(),
  75. ]);
  76. return apiReturnFail($e->getMessage());
  77. }
  78. }
  79. /**
  80. * 圣诞大转盘 - 获取配置与用户状态
  81. */
  82. public function christmasWheelInfo(Request $request)
  83. {
  84. $user = $request->user();
  85. $userId = $user ? $user->UserID : 0;
  86. $service = new ChristmasWheelService();
  87. $info = $service->getWheelInfo($userId);
  88. return apiReturnSuc($info);
  89. }
  90. /**
  91. * 圣诞大转盘 - 抽奖
  92. */
  93. public function christmasWheelSpin(Request $request)
  94. {
  95. $user = $request->user();
  96. if (!$user) {
  97. return apiReturnFail(['web.activity.login_required', __('messages.web.activity.login_required')]); // 请先登录
  98. }
  99. $service = new ChristmasWheelService();
  100. try {
  101. $result = $service->spin($user->UserID);
  102. return apiReturnSuc($result);
  103. } catch (\Throwable $e) {
  104. \Log::error('christmas wheel spin failed', [
  105. 'user_id' => $user->UserID,
  106. 'error' => $e->getMessage(),
  107. ]);
  108. return apiReturnFail($e->getMessage());
  109. }
  110. }
  111. public function List(Request $request)
  112. {
  113. return apiReturnSuc(['list'=>WebActivity::query()->whereRaw(RouteService::getStateToWhereRaw($request))->get()->toArray()]);
  114. }
  115. public function GetProtectNum(Request $request)
  116. {
  117. $user=$request->user();
  118. if(ServerService::GetGlobalServerInfoByGUID($user->GlobalUID)['Subsite']=='Europe'){
  119. //欧洲暂时封闭
  120. return apiReturnSuc();
  121. }
  122. $UserID=$user->UserID;
  123. $res=DB::connection('sqlsrv')->select("exec QPAccountsDB.dbo.GSP_GP_QueryProtect $UserID");
  124. return apiReturnSuc($res);
  125. }
  126. public function AddProtectNum(Request $request)
  127. {
  128. $user=$request->user();
  129. $UserID=$user->UserID;
  130. if(ServerService::GetGlobalServerInfoByGUID($user->GlobalUID)['Subsite']=='Europe'){
  131. //欧洲暂时封闭
  132. return apiReturnSuc();
  133. }
  134. $dbh = DB::connection()->getPdo();
  135. $sql="
  136. set nocount on use QPAccountsDB;
  137. DECLARE @return_value INT;
  138. EXEC @return_value = QPAccountsDB.dbo.GSP_GP_AddProtect @dwUserID = $UserID;
  139. SELECT @return_value as ReturnValue;";
  140. $stmt = $dbh->prepare($sql);
  141. $stmt->execute();
  142. $result = $stmt->fetch(\PDO::FETCH_ASSOC);
  143. // dd($user,$result);
  144. // 获取返回值和错误描述
  145. $returnValue = $result['ReturnValue']??0;
  146. // $result=DB::connection('sqlsrv')->select('EXEC @return_value = QPAccountsDB.dbo.GSP_GP_AddProtect @dwUserID = '.$UserID.'; SELECT @return_value AS ReturnValue;');
  147. // 获取返回值
  148. // $returnValue = $result[1]->ReturnValue;
  149. if ($returnValue == 0) {
  150. return apiReturnSuc($result);
  151. } else if ($returnValue == 1) {
  152. return apiReturnFail(['web.protect.score_limit','Score limit reached']);
  153. } else if ($returnValue == 3) {
  154. return apiReturnFail(['web.protect.times_limit','Protect times limit reached']);
  155. } else {
  156. return apiReturnFail(['web.withdraw.try_again_later','Unknown error']);
  157. }
  158. }
  159. public function GetCheckInInfoConfig(Request $request)
  160. {
  161. $user=$request->user();
  162. $UserID=$user->UserID;
  163. $res=DB::connection('sqlsrv')->select("exec QPAccountsDB.dbo.GSP_GP_GetUserSignInInfo $UserID");
  164. $res2=DB::table('QPAccountsDB.dbo.UserSignInInfo')->where('UserID',$UserID)->first();
  165. $max=count($res);
  166. $res2=(array)$res2;
  167. if($res2['NextDayNumber']>$max) {
  168. $res2['NextDayNumber']= $res2['NextDayNumber'] % $max + 1;
  169. $res2['RecordDay']='';
  170. for($i=0;$i<$max;$i++) {
  171. $res2['RecordDay'].=$i<($res2['NextDayNumber']-1)?'1':'0';
  172. }
  173. }
  174. $res2['config']=$res;
  175. return apiReturnSuc($res2);
  176. }
  177. public function GetCheckInInfo(Request $request)
  178. {
  179. $user=$request->user();
  180. $UserID=$user->UserID;
  181. try {
  182. // 定义输出参数
  183. $errorDescribe = '';
  184. // 调用存储过程
  185. // $result = DB::connection('sqlsrv')->select('
  186. // use QPAccountsDB;
  187. // DECLARE @strErrorDescribe NVARCHAR(127);
  188. // DECLARE @return_value INT;
  189. // EXEC @return_value = QPAccountsDB.dbo.GSP_GP_UserSignIn @dwUserID = $UserID, @strErrorDescribe = @strErrorDescribe OUTPUT;
  190. // SELECT @return_value as ReturnValue, @strErrorDescribe as ErrorDescribe;
  191. // ', [$UserID]);
  192. //
  193. $dbh = DB::connection()->getPdo();
  194. $sql="
  195. set nocount on use QPAccountsDB;
  196. DECLARE @strErrorDescribe NVARCHAR(127);
  197. DECLARE @return_value INT;
  198. EXEC @return_value = QPAccountsDB.dbo.GSP_GP_UserSignIn @dwUserID = $UserID, @strErrorDescribe = @strErrorDescribe OUTPUT;
  199. SELECT @return_value as ReturnValue, @strErrorDescribe as ErrorDescribe;";
  200. $stmt = $dbh->prepare($sql);
  201. $stmt->execute();
  202. $result = $stmt->fetch(\PDO::FETCH_ASSOC);
  203. // dd($user,$result);
  204. // 获取返回值和错误描述
  205. $returnValue = $result['ReturnValue']??0;
  206. // $errorDescribe = $result['ErrorDescribe'];
  207. // 根据返回值和错误描述处理
  208. switch ($returnValue) {
  209. case 1:
  210. return apiReturnFail(['web.checkin.user_signin_error', 'Failed to get user sign-in information']);
  211. case 2:
  212. return apiReturnFail(['web.checkin.user_already_signed_in', 'You have already signed in today']);
  213. case 3:
  214. return apiReturnFail(['web.checkin.signin_event_ended', 'The sign-in activity has ended']);
  215. case 4:
  216. return apiReturnFail(['web.checkin.signin_data_error', 'Failed to read sign-in data']);
  217. case 5:
  218. return apiReturnFail(['web.checkin.recharge_required', 'Recharge is required to sign in'],[],777);
  219. case 0:
  220. $this->triggerSignIn($UserID);
  221. return apiReturnSuc($result);
  222. default:
  223. return apiReturnFail(['web.checkin.unknown_error', 'Unknown error']);
  224. }
  225. } catch (\Exception $e) {
  226. TelegramBot::getDefault()->sendProgramNotify("Game Checkin:", $e->getMessage());
  227. // 捕获异常并返回错误响应
  228. return apiReturnFail(['web.checkin.exception_occurred', 'An error occurred while processing your request'], [], 500);
  229. }
  230. }
  231. public function RedConfig(Request $request){
  232. $config=Redis::get("RedEnvelopeConfig");
  233. if(!$config){
  234. $config=RedEnvelopeConfig::query()->get();
  235. Redis::set("RedEnvelopeConfig",json_encode($config));
  236. Redis::expire("RedEnvelopeConfig",600);
  237. }else{
  238. $config=json_decode($config,true);
  239. }
  240. return apiReturnSuc($config);
  241. }
  242. public function RedCheck(Request $request)
  243. {
  244. $maxRedpack=24680;
  245. $currentDateTime = Carbon::now();
  246. $currentTime = $currentDateTime->format('H:i:s');
  247. // 查找当前时间段内的红包配置
  248. $config = RedEnvelopeConfig::where('StartTime', '<=', $currentTime)
  249. ->where('EndTime', '>=', $currentTime)
  250. ->first();
  251. if ($config) {
  252. $getted=false;
  253. if($request->user()) {
  254. $userID=$request->user()->UserID;
  255. $checkKey = "redpack_$userID";
  256. $getted=Redis::exists($checkKey);
  257. }
  258. return apiReturnSuc(['status' => $getted?-1:1,'max'=>$maxRedpack]);
  259. } else {
  260. // 计算下一个红包时间
  261. $nextConfig = RedEnvelopeConfig::where('StartTime', '>', $currentTime)
  262. ->orderBy('StartTime', 'asc')
  263. ->first();
  264. if (!$nextConfig) {
  265. // 如果今天没有更多红包时间段,则查找明天的第一个红包时间段
  266. $nextConfig = RedEnvelopeConfig::orderBy('StartTime', 'asc')->first();
  267. $nextTime = Carbon::tomorrow()->setTimeFromTimeString($nextConfig->StartTime);
  268. } else {
  269. $nextTime = Carbon::today()->setTimeFromTimeString($nextConfig->StartTime);
  270. }
  271. $diffMinutes = $currentDateTime->diffInSeconds($nextTime);
  272. return apiReturnSuc(['status' => 0,'max'=>$maxRedpack, 'next_in_seconds' => $diffMinutes],['activity.redpack.please_wait','Please wait until next time.']);
  273. }
  274. }
  275. public function RedReceive(Request $request)
  276. {
  277. return apiReturnSuc(['status' => -1,'amount'=>0]);
  278. $user=$request->user();
  279. $userID = $user->UserID;
  280. $currentDateTime = Carbon::now();
  281. $currentTime = $currentDateTime->format('H:i:s');
  282. $checkKey="redpack_$userID";
  283. if(Redis::exists($checkKey)){
  284. return apiReturnSuc(['status' => -1,'amount'=>0]);
  285. }
  286. // 查找当前时间段内的红包配置
  287. $config = RedEnvelopeConfig::where('StartTime', '<=', $currentTime)
  288. ->where('EndTime', '>=', $currentTime)
  289. ->first();
  290. if ($config) {
  291. // 在红包活动时间段内,生成红包金额
  292. $amount = $this->generateRedEnvelopeAmount($user,$config);
  293. if(is_array($amount))return $amount;
  294. // 记录领取日志
  295. RedEnvelopeLog::create([
  296. 'UserID' => $userID,
  297. 'ReceivedAt' => $currentDateTime,
  298. 'Amount' => $amount,
  299. 'Comment' => '红包雨活动'
  300. ]);
  301. Redis::set($checkKey,1);
  302. Redis::expire($checkKey,3600);
  303. return apiReturnSuc(['amount' => $amount,'status' => 1]);
  304. } else {
  305. // 不在红包活动时间段内
  306. return apiReturnFail(['web.activity.redpack_not_available','There is no RedPack']);
  307. }
  308. }
  309. /**
  310. * @param $user
  311. * @param RedEnvelopeConfig $config
  312. * @return array|int
  313. */
  314. private function generateRedEnvelopeAmount($user, $config)
  315. {
  316. //超过限额
  317. if($config->PrizePool>=3000){
  318. return 0;
  319. }
  320. $UserID=$user->UserID;
  321. // $recharinfo=DB::connection('write')->table('QPAccountsDB.dbo.YN_VIPAccount')
  322. // ->where('UserID', $UserID)->first();
  323. // // 根据用户的充值金额决定红包金额
  324. $userTotal = DB::connection('write')->table('QPRecordDB.dbo.RecordUserTotalStatistics')
  325. ->where('UserID', $UserID)
  326. ->first();
  327. $deposit = 0;
  328. $withdraw = 0;
  329. $revenue = 0;
  330. if($userTotal){
  331. $deposit = $userTotal->Recharge;
  332. $withdraw = $userTotal->Withdraw;
  333. $revenue = $userTotal->Revenue;
  334. }
  335. $amount = 0;
  336. if ($deposit == 0) {
  337. // 未充值用户无法领取红包
  338. return apiReturnFail(['web.activity.redpack_no_recharge', 'message' => 'You need deposit first!']);
  339. } elseif ($deposit < 50) {
  340. // 50以下
  341. if (rand(1, 100) <= 50) {
  342. $amount=0;
  343. } else {
  344. $amount = rand(1, 2);
  345. }
  346. } elseif ($deposit < 100) {
  347. // 50-100
  348. if (rand(1, 100) <= 40) {
  349. $amount=0;
  350. } else {
  351. $amount = rand(1, 5);
  352. }
  353. } elseif ($deposit < 500) {
  354. // 100-500
  355. if (rand(1, 100) <= 25) {
  356. $amount=0;
  357. } else {
  358. $amount = rand(5, 10);
  359. }
  360. } elseif ($deposit < 1000) {
  361. // 500-1000
  362. if (rand(1, 100) <= 20) {
  363. $amount=0;
  364. } else {
  365. $amount = rand(5, 15);
  366. }
  367. } elseif ($deposit < 5000) {
  368. // 1000-5000
  369. if (rand(1, 100) <= 10) {
  370. $amount=0;
  371. } else {
  372. $amount = rand(10, 30);
  373. }
  374. } elseif ($deposit < 20000) {
  375. // 5000-20000
  376. $amount = rand(20, 100);
  377. } elseif ($deposit < 200000) {
  378. // 20000-200000
  379. $amount = rand(100, 150);
  380. } else {
  381. // 200000以上
  382. $amount = rand(100, 300);
  383. }
  384. if($amount){
  385. //平台资产》充 减半
  386. if($withdraw + $revenue > $deposit*100 && $deposit>1000){
  387. $rate = max(($withdraw + $revenue) / ($deposit*100) * 2,2);
  388. $amount = intval($amount/$rate);
  389. }
  390. //出》入 0
  391. if($withdraw > $deposit*100){
  392. $amount = 0;
  393. }
  394. }
  395. if($amount){
  396. $config->increment('PrizePool', $amount);
  397. OuroGameService::AddScore($UserID,$amount*NumConfig::NUM_VALUE,OuroGameService::REASON_RedEnvelope);
  398. // OuroGameService::AddDrawBase($UserID,$amount*100,2);
  399. }
  400. return $amount;
  401. }
  402. public function repayFirst()
  403. {
  404. $str="10014268,2000,BRA2851903748065310014268
  405. 10014270,2000,BRA2855489212693610014270
  406. 10014271,2000,BRA2852393071882610014271
  407. 10014274,1000,BRA2853030100749910014274
  408. 10014276,1000,BRA2853245554392310014276
  409. 10014277,2000,BRA2853344779876810014277
  410. 10014277,2000,BRA2855290186893810014277
  411. 10014277,2000,BRA2864525856913410014277
  412. 10014281,1000,BRA2854641828657010014281
  413. 10014282,2000,BRA2854744724737410014282
  414. 10014285,2000,BRA2855039889866610014285
  415. 10014287,2000,BRA2855391649287010014287
  416. 10014288,1000,BRA2855464384803010014288
  417. 10014292,2000,BRA2856246492161510014292
  418. 10014297,1000,BRA2857229048633010014297
  419. 10014300,2000,BRA2858261561088610014300
  420. 10014301,2000,BRA2858433689840310014301
  421. 10014302,1000,BRA2858522897364510014302
  422. 10014305,2000,BRA2859083559189210014305
  423. 10014306,2000,BRA2859074387476010014306
  424. 10014308,2000,BRA2859253433784710014308
  425. 10014309,2000,BRA2859266221396810014309
  426. 10014311,1000,BRA2859721671820010014311
  427. 10014314,2000,BRA2860714714541810014314
  428. 10014316,2000,BRA2861078506701410014316
  429. 10014318,2000,BRA2861340050408610014318
  430. 10014324,2000,BRA2863987369403910014324
  431. 10014326,2000,BRA2862573151411810014326
  432. 10014327,2000,BRA2862997500499910014327
  433. 10014330,1000,BRA2863297592217210014330
  434. 10014332,2000,BRA2863120608306010014332
  435. 10014335,1000,BRA2975317980447310014335
  436. 10014339,2000,BRA2864730304211810014339
  437. 10014351,2000,BRA2869670282797610014351
  438. 10014352,2000,BRA2971319703907510014352
  439. 10014358,2000,BRA2973553150552010014358
  440. 10014372,2000,BRA2995159192410010014372
  441. 10014373,2000,BRA2995376698241510014373
  442. 10014375,2000,BRA2996350286730710014375
  443. 10014383,2000,BRA2902200217093410014383";
  444. $arr=explode("\n",$str);
  445. $sort=[];
  446. $g201 = DB::table('agent.dbo.recharge_gear')->where('gift_id', 201)->select('gift_id', 'money', 'give', 'favorable_price', 'second_give')->first();
  447. $g211 = DB::table('agent.dbo.recharge_gear')->where('gift_id', 211)->select('gift_id', 'money', 'give', 'favorable_price', 'second_give')->first();
  448. foreach ($arr as $k=>$v){
  449. [$UserID,$amount,$sn]=explode(',',$v);
  450. if(isset($sort[$UserID]))continue;
  451. $sort[$UserID]=$amount;
  452. if($amount==1000)$first=$g201;
  453. else $first=$g211;
  454. if ($first && $first->second_give > 0) {
  455. $bonus = '30000,' . $amount;
  456. PrivateMail::sendMail(2, $UserID, "Suplemento de erro de primeiro depósito", "Nós adicionamos para você, por favor, aceite.", $bonus, $sn, $amount);
  457. $fpkey = 'Firstpay_' . $UserID;
  458. $data = (array)$first;
  459. $data['buytime'] = time();
  460. $data['czReason'] = 1;
  461. $data['cjReason'] = 45;
  462. Redis::set($fpkey, json_encode($data));
  463. DB::table(TableName::agent() . 'guide_payment')->updateOrInsert([
  464. 'UserID' => $UserID,
  465. 'GiftID' => $amount==1000?201:211,
  466. 'CreateTime' => now()
  467. ], ['UserID' => $UserID]);
  468. }
  469. }
  470. dd($sort);
  471. }
  472. public static function decrypt($str){
  473. if (!isset($str)||!$str||empty($str)) {
  474. # code...
  475. return '';
  476. }
  477. $str=implode("+",explode(" ",$str));
  478. try {
  479. $destr=LZ::decompressFromBase64($str);
  480. }catch (\Exception $exception){
  481. Util::WriteLog('gamelz',$str);
  482. TelegramBot::getDefault()->sendProgramNotify("Game LZ decrypt:".$str);
  483. TelegramBot::getDefault()->sendProgramNotify("Game LZ decrypt:", $exception->getMessage().$exception->getTraceAsString());
  484. $destr=$str;
  485. }
  486. return $destr;
  487. }
  488. // ==================== VIP提现诱导功能 ====================
  489. /**
  490. * 获取用户VIP提现任务进度
  491. */
  492. public function getVipWithdrawTasks(Request $request)
  493. {
  494. $user = $request->user();
  495. $userId = $user->UserID;
  496. // 检查用户是否已充值
  497. $user_recharge = DB::table(TableName::QPAccountsDB() . 'YN_VIPAccount')
  498. ->where('UserID', $userId)
  499. ->value('Recharge') ?: 0;
  500. if ($user_recharge <= 0 &&!$request->input('is_test', 0)) {
  501. // return apiReturnFail('请先充值后再查看任务-'.$userId);
  502. return apiReturnFail(['web.vip_task.recharge_first', __('messages.web.vip_task.recharge_first')]); // 请先充值后再查看任务
  503. }
  504. // 获取用户任务数据
  505. $taskData = $this->getUserTaskData($userId);
  506. // 获取任务配置
  507. $taskConfig = $this->getTaskConfig();
  508. // 判断奖励状态:0-不能领取, 1-待领取, 2-已领取
  509. $stage1_reward_status = 0; // 不能领取
  510. if ($taskData['stage1_completed']) {
  511. $stage1_reward_status = $taskData['stage1_withdrawn'] ? 2 : 1; // 已领取 : 待领取
  512. }
  513. $stage2_reward_status = 0; // 不能领取
  514. if ($taskData['stage1_completed']) { // 阶段2需要阶段1完成才能解锁
  515. if ($taskData['stage2_completed']) {
  516. $stage2_reward_status = $taskData['stage2_withdrawn'] ? 2 : 1; // 已领取 : 待领取
  517. }
  518. }
  519. $stage3_task1_status = 0; // 不能领取
  520. if ($taskData['stage2_completed']) { // 阶段3需要阶段2完成才能解锁
  521. // 循环任务:基于累计下注判断是否可领取(不使用已领取状态)
  522. if (($taskData['stage3_current_bet'] ?? 0) >= 6000) {
  523. $stage3_task1_status = 1; // 待领取
  524. }
  525. }
  526. // 构建阶段1任务列表
  527. $stage1Tasks = [];
  528. foreach ($taskConfig['stage1']['tasks'] as $taskCfg) {
  529. $taskKey = $taskCfg['id'];
  530. $progressKey = $taskCfg['progress_key'];
  531. $completed = $taskData[$taskKey] ?? false;
  532. $stage1Tasks[] = [
  533. 'id' => $taskCfg['id'],
  534. 'title' => $taskCfg['title'],
  535. 'type' => $taskCfg['type'],
  536. 'completed' => $completed,
  537. 'status' => $completed ? 1 : 0,
  538. // 'status_text' => $completed ? '已完成' : '未完成',
  539. 'status_text' => $completed ? __('messages.web.vip_task.completed') : __('messages.web.vip_task.not_completed'), // 已完成 : 未完成
  540. 'progress' => intval(min($taskData[$progressKey] ?? 0,$taskCfg['target'])),
  541. 'target' => $taskCfg['target']
  542. ];
  543. }
  544. // 构建任务结构
  545. $tasks = [
  546. 'stage1' => [
  547. 'stage' => 1,
  548. // 'title' => '阶段任务1',
  549. 'title' => __('messages.web.vip_task.stage1_title'), // 阶段任务1
  550. 'reward' => $taskConfig['stage1']['reward'],
  551. 'completed' => $taskData['stage1_completed'],
  552. 'reward_status' => $stage1_reward_status,
  553. // 'reward_status_text' => ['不能领取', '待领取', '已领取'][$stage1_reward_status],
  554. 'reward_status_text' => [__('messages.web.vip_task.cannot_claim'), __('messages.web.vip_task.can_claim'), __('messages.web.vip_task.claimed')][$stage1_reward_status], // 不能领取, 待领取, 已领取
  555. 'can_claim' => $stage1_reward_status === 1,
  556. 'tasks' => $stage1Tasks
  557. ],
  558. 'stage2' => [
  559. 'stage' => 2,
  560. // 'title' => '阶段任务2',
  561. 'title' => __('messages.web.vip_task.stage2_title'), // 阶段任务2
  562. 'reward' => $taskConfig['stage2']['reward'],
  563. 'unlocked' => $taskData['stage1_completed'],
  564. 'completed' => $taskData['stage2_completed'],
  565. 'reward_status' => $stage2_reward_status,
  566. // 'reward_status_text' => ['不能领取', '待领取', '已领取'][$stage2_reward_status],
  567. 'reward_status_text' => [__('messages.web.vip_task.cannot_claim'), __('messages.web.vip_task.can_claim'), __('messages.web.vip_task.claimed')][$stage2_reward_status], // 不能领取, 待领取, 已领取
  568. 'can_claim' => $stage2_reward_status === 1,
  569. 'tasks' => array_map(function($taskCfg) use ($taskData) {
  570. $taskKey = $taskCfg['id'];
  571. $progressKey = $taskCfg['progress_key'];
  572. $completed = $taskData[$taskKey] ?? false;
  573. return [
  574. 'id' => $taskCfg['id'],
  575. 'title' => $taskCfg['title'],
  576. 'type' => $taskCfg['type'],
  577. 'completed' => $completed,
  578. 'status' => $completed ? 1 : 0,
  579. // 'status_text' => $completed ? '已完成' : '未完成',
  580. 'status_text' => $completed ? __('messages.web.vip_task.completed') : __('messages.web.vip_task.not_completed'), // 已完成 : 未完成
  581. 'progress' => intval(min($taskData[$progressKey] ?? 0,$taskCfg['target'])),
  582. 'target' => $taskCfg['target']
  583. ];
  584. }, $taskConfig['stage2']['tasks'])
  585. ],
  586. 'stage3' => [
  587. 'stage' => 3,
  588. // 'title' => '阶段任务3(循环任务)',
  589. 'title' => __('messages.web.vip_task.stage3_title'), // 阶段任务3(循环任务)
  590. 'unlocked' => $taskData['stage2_completed'],
  591. 'is_loop' => true,
  592. 'current_loop' => $taskData['stage3_loop_count'],
  593. 'tasks' => array_map(function($taskCfg) use ($taskData, $stage3_task1_status) {
  594. $taskKey = $taskCfg['id'];
  595. $progressKey = $taskCfg['progress_key'];
  596. $completed = $taskData[$taskKey] ?? false;
  597. $rewardStatus = $taskKey === 'stage3_task1' ? $stage3_task1_status : 0;
  598. return [
  599. 'id' => $taskCfg['id'],
  600. 'title' => $taskCfg['title'],
  601. 'type' => $taskCfg['type'],
  602. 'reward' => $taskCfg['reward'],
  603. 'completed' => $completed,
  604. 'reward_status' => $rewardStatus,
  605. // 'reward_status_text' => ['不能领取', '待领取', '可重复领取'][$rewardStatus],
  606. 'reward_status_text' => [__('messages.web.vip_task.cannot_claim'), __('messages.web.vip_task.can_claim'), __('messages.web.vip_task.repeatable')][$rewardStatus], // 不能领取, 待领取, 可重复领取
  607. 'can_claim' => $rewardStatus === 1,
  608. 'progress' => intval(min($taskData[$progressKey] ?? 0,$taskCfg['target'])),
  609. 'target' => $taskCfg['target']
  610. ];
  611. }, $taskConfig['stage3']['tasks'])
  612. ]
  613. ];
  614. return apiReturnSuc($tasks);
  615. }
  616. /**
  617. * 领取任务奖励(提现)
  618. */
  619. public function claimVipWithdrawReward(Request $request)
  620. {
  621. $user = $request->user();
  622. $userId = $user->UserID;
  623. $stage = (int)$request->input('stage');
  624. $taskId = $request->input('task_id', '');
  625. $redisLockKey = "vip_withdraw_claim_{$userId}";
  626. if (!Redis::set($redisLockKey, 1, 'EX', 10, 'NX')) {
  627. // return apiReturnFail('操作太频繁,请稍后再试');
  628. return apiReturnFail(['web.vip_task.operation_frequent', __('messages.web.vip_task.operation_frequent')]); //'操作太频繁,请稍后再试'
  629. }
  630. try {
  631. // 获取用户任务数据
  632. $taskData = $this->getUserTaskData($userId);
  633. $rewardAmount = 0;
  634. // 阶段1
  635. if ($stage === 1) {
  636. if (!$taskData['stage1_completed']) {
  637. Redis::del($redisLockKey);
  638. // return apiReturnFail('任务未完成');
  639. return apiReturnFail(['web.vip_task.task_not_completed', __('messages.web.vip_task.task_not_completed')]); // 任务未完成
  640. }
  641. if ($taskData['stage1_withdrawn']) {
  642. Redis::del($redisLockKey);
  643. return apiReturnFail(['web.vip_task.reward_claimed', __('messages.web.vip_task.reward_claimed')]); // 奖励已领取
  644. // return apiReturnFail('奖励已领取');
  645. }
  646. $rewardAmount = 10;
  647. $this->updateTaskProgress($userId, 'stage1_withdrawn', 1);
  648. }
  649. // 阶段2
  650. elseif ($stage === 2) {
  651. if (!$taskData['stage2_completed']) {
  652. Redis::del($redisLockKey);
  653. // return apiReturnFail('任务未完成');
  654. return apiReturnFail(['web.vip_task.task_not_completed', __('messages.web.vip_task.task_not_completed')]); // 任务未完成
  655. }
  656. if ($taskData['stage2_withdrawn']) {
  657. Redis::del($redisLockKey);
  658. return apiReturnFail(['web.vip_task.reward_claimed', __('messages.web.vip_task.reward_claimed')]); // 奖励已领取
  659. // return apiReturnFail('奖励已领取');
  660. }
  661. $rewardAmount = 10;
  662. $this->updateTaskProgress($userId, 'stage2_withdrawn', 1);
  663. }
  664. // 阶段3
  665. elseif ($stage === 3) {
  666. $taskId = 'stage3_task1';
  667. if ($taskId === 'stage3_task1') {
  668. // 每满600可领取20,领取后扣除600下注进度
  669. if (($taskData['stage3_current_bet'] ?? 0) < 6000) {
  670. Redis::del($redisLockKey);
  671. return apiReturnFail('任务未完成');
  672. }
  673. $rewardAmount = 20;
  674. $this->updateTaskProgress($userId, 'stage3_current_bet', max(0, ($taskData['stage3_current_bet'] - 6000)));
  675. } else {
  676. Redis::del($redisLockKey);
  677. return apiReturnFail(['web.vip_task.invalid_task', __('messages.web.vip_task.invalid_task')]); // 无效的任务
  678. }
  679. } else {
  680. Redis::del($redisLockKey);
  681. return apiReturnFail(['web.vip_task.invalid_stage', __('messages.web.vip_task.invalid_stage')]); // 无效的阶段
  682. // return apiReturnFail('无效的阶段');
  683. }
  684. // 添加提现额度到用户账户
  685. if ($rewardAmount > 0) {
  686. $dbh = DB::connection()->getPdo();
  687. $score=$rewardAmount*NumConfig::NUM_VALUE;
  688. $sql="DECLARE @return_value int
  689. set nocount on use QPAccountsDB
  690. EXEC @return_value = GSP_GR_GetFreeWithDraw '$userId','$score'
  691. SELECT 'ReturnValue' = @return_value";
  692. $stmt = $dbh->prepare($sql);
  693. $stmt->execute();
  694. $retval = $stmt->fetch(\PDO::FETCH_ASSOC);
  695. try {
  696. // set @ret = 1 --可提额度不足
  697. // set @ret = 2 --低于最低可提现金额
  698. // set @ret = 3 --高于最高可提现金额
  699. // set @ret = 4 --超过每天提现次数上限
  700. // set @ret = 5 --身上钱不够
  701. // set @ret = 6 --开在游戏里面
  702. // set @ret = 7 --未充值的用户TX额度
  703. if (isset($retval['ReturnValue'])) {
  704. $ReturnValue = $retval['ReturnValue'];
  705. // set @ret = 1 -- Insufficient withdrawal amount
  706. // set @ret = 2 -- Lower than the minimum withdrawal amount
  707. // set @ret = 3 -- Higher than the maximum withdrawal amount
  708. // set @ret = 4 -- Exceeded the daily withdrawal limit
  709. // set @ret = 5 -- Not enough money on hand
  710. // set @ret = 6 -- Opened in the game
  711. // set @ret = 7 -- Undeposited user TX amount
  712. $errors = [
  713. [],
  714. ['web.withdraw.no_withdraw_value', "The withdrawable amount is not enough"],
  715. ['web.withdraw.too_low', 'Lower than the minimum withdrawal amount'],
  716. ['web.withdraw.too_high', 'Higher than the maximum withdrawal amount'],
  717. ['web.withdraw.day_max', 'Exceeded the daily withdrawal limit'],
  718. ['web.withdraw.no_enouth_score', 'Not enough money on hand'],
  719. ['web.withdraw.in_game', 'Sorry, You\'re in game for now'],
  720. ['web.withdraw.no_deposit', ' You need deposit first!'],
  721. ];
  722. return apiReturnFail($errors[$ReturnValue], [], $ReturnValue == 7 ? 777 : 301);
  723. }else{
  724. //return apiReturnSuc($retval);
  725. }
  726. }catch (\Exception $e){
  727. // TelegramBot::getDefault()->sendProgramNotify("WithDraw Error:", var_export($retval,true).':'.$e->getTraceAsString());
  728. //return apiReturnSuc($retval);
  729. }
  730. // 记录日志
  731. \Log::info('VIP提现任务奖励', [
  732. 'user_id' => $userId,
  733. 'stage' => $stage,
  734. 'task_id' => $taskId,
  735. 'amount' => $rewardAmount
  736. ]);
  737. }
  738. Redis::del($redisLockKey);
  739. return apiReturnSuc([
  740. 'amount' => $rewardAmount,
  741. // 'message' => "成功领取 {$rewardAmount} 提现额度"
  742. 'message' => __('messages.web.vip_task.claim_success', ['amount' => $rewardAmount]) // "成功领取 {$rewardAmount} 提现额度"
  743. ]);
  744. } catch (\Exception $e) {
  745. Redis::del($redisLockKey);
  746. \Log::error('VIP提现任务领取失败', [
  747. 'user_id' => $userId,
  748. 'error' => $e->getMessage()
  749. ]);
  750. return apiReturnFail(['web.vip_task.claim_failed', __('messages.web.vip_task.claim_failed', ['error' => $e->getMessage()])]); // 领取失败:
  751. // return apiReturnFail('领取失败:' . $e->getMessage());
  752. }
  753. }
  754. /**
  755. * 获取用户任务数据(从Redis和数据库)
  756. */
  757. private function getUserTaskData($userId)
  758. {
  759. $redisKey = "vip_withdraw_task_{$userId}";
  760. $data = Redis::get($redisKey);
  761. if ($data) {
  762. $taskData = json_decode($data, true);
  763. } else {
  764. // 从数据库加载任务数据
  765. $dbData = DB::table('agent.dbo.vip_withdraw_tasks')
  766. ->where('user_id', $userId)
  767. ->first();
  768. if ($dbData) {
  769. $taskData = json_decode($dbData->task_data, true);
  770. } else {
  771. // 初始化任务数据
  772. $taskData = $this->initUserTaskData($userId);
  773. }
  774. }
  775. // 实时更新统计数据
  776. $this->updateRealTimeStats($userId, $taskData);
  777. // 检查任务完成状态
  778. $this->checkTaskCompletion($taskData);
  779. // 保存到数据库(持久化)
  780. $this->saveUserTaskData($userId, $taskData);
  781. // 保存到Redis(缓存24小时)
  782. Redis::setex($redisKey, 86400, json_encode($taskData));
  783. return $taskData;
  784. }
  785. /**
  786. * 保存用户任务数据到数据库
  787. */
  788. private function saveUserTaskData($userId, $taskData)
  789. {
  790. try {
  791. DB::table('agent.dbo.vip_withdraw_tasks')->updateOrInsert(
  792. ['user_id' => $userId],
  793. [
  794. 'task_data' => json_encode($taskData, JSON_UNESCAPED_UNICODE),
  795. 'updated_at' => date('Y-m-d H:i:s')
  796. ]
  797. );
  798. } catch (\Exception $e) {
  799. \Log::error('VIP提现任务数据保存失败', [
  800. 'user_id' => $userId,
  801. 'error' => $e->getMessage()
  802. ]);
  803. }
  804. }
  805. /**
  806. * 获取任务配置
  807. */
  808. private function getTaskConfig()
  809. {
  810. return [
  811. 'stage1' => [
  812. 'reward' => 10,
  813. 'tasks' => [
  814. [
  815. 'id' => 'stage1_task1',
  816. 'title' => 'Claim daily bonus once',
  817. 'type' => 'sign_in',
  818. 'target' => 1,
  819. 'progress_key' => 'sign_in_count'
  820. ],
  821. [
  822. 'id' => 'stage1_task2',
  823. 'title' => 'Bet amount reaches 100',
  824. 'type' => 'bet_amount',
  825. 'target' => 100,
  826. 'progress_key' => 'total_bet'
  827. ],
  828. [
  829. 'id' => 'stage1_task3',
  830. 'title' => 'Deposit once more',
  831. 'type' => 'recharge',
  832. 'target' => 1,
  833. 'progress_key' => 'recharge_count'
  834. ]
  835. ]
  836. ],
  837. 'stage2' => [
  838. 'reward' => 10,
  839. 'tasks' => [
  840. [
  841. 'id' => 'stage2_task1',
  842. 'title' => 'Try 6 different games',
  843. 'type' => 'play_games',
  844. 'target' => 6,
  845. 'progress_key' => 'played_games_count'
  846. ],
  847. [
  848. 'id' => 'stage2_task2',
  849. 'title' => 'Bet amount reaches 3000',
  850. 'type' => 'bet_amount',
  851. 'target' => 3000,
  852. 'progress_key' => 'total_bet'
  853. ],
  854. [
  855. 'id' => 'stage2_task3',
  856. 'title' => 'Start inviting once',
  857. 'type' => 'invite',
  858. 'target' => 1,
  859. 'progress_key' => 'invite_count'
  860. ]
  861. ]
  862. ],
  863. 'stage3' => [
  864. 'tasks' => [
  865. [
  866. 'id' => 'stage3_task1',
  867. 'title' => 'Bet amount reaches 6000',
  868. 'type' => 'bet_amount',
  869. 'target' => 6000,
  870. 'reward' => 20,
  871. 'progress_key' => 'stage3_current_bet'
  872. ]
  873. ]
  874. ]
  875. ];
  876. }
  877. /**
  878. * 初始化用户任务数据
  879. */
  880. private function initUserTaskData($userId)
  881. {
  882. return [
  883. // 阶段1任务
  884. 'stage1_task1' => false,
  885. 'stage1_task2' => false,
  886. 'stage1_task3' => false,
  887. 'stage1_completed' => false,
  888. 'stage1_withdrawn' => false,
  889. // 阶段2任务
  890. 'stage2_task1' => false,
  891. 'stage2_task2' => false,
  892. 'stage2_task3' => false,
  893. 'stage2_completed' => false,
  894. 'stage2_withdrawn' => false,
  895. // 阶段3任务(循环)
  896. 'stage3_task1' => false,
  897. 'stage3_task1_withdrawn' => false,
  898. 'stage3_loop_count' => 0,
  899. 'stage3_current_bet' => 0,
  900. 'stage3_available_amount' => 0,
  901. // 统计数据
  902. 'total_bet' => 0,
  903. 'recharge_count' => 0,
  904. 'played_games_count' => 0,
  905. 'invite_count' => 0,
  906. 'sign_in_count' => 0
  907. ];
  908. }
  909. /**
  910. * 更新实时统计数据
  911. */
  912. private function updateRealTimeStats($userId, &$taskData)
  913. {
  914. $userTotalStatistics = DB::table('QPRecordDB.dbo.RecordUserTotalStatistics')
  915. ->where('UserID', $userId)
  916. ->first();
  917. // 获取总下注金额
  918. $totalBet =$userTotalStatistics ?$userTotalStatistics->TotalBet: 0;
  919. $taskData['total_bet'] = $totalBet / NumConfig::NUM_VALUE;
  920. // 获取充值次数
  921. $rechargeCount = $userTotalStatistics?$userTotalStatistics->RechargeTimes:0;
  922. $taskData['recharge_count'] = min(max($rechargeCount-1,0),1);
  923. // 获取玩过的游戏数量(去重)
  924. $playedGames = DB::table('QPRecordDB.dbo.RecordUserGameCount')
  925. ->where('UserID', $userId)
  926. ->distinct()
  927. ->count('GameID');
  928. $taskData['played_games_count'] = $playedGames;
  929. // 邀请人数从Redis读取(通过 triggerInvite 方法触发)
  930. if (!isset($taskData['invite_count'])) {
  931. $taskData['invite_count'] = 0;
  932. }
  933. // 签到次数从Redis读取(通过 triggerSignIn 方法触发)
  934. if (!isset($taskData['sign_in_count'])) {
  935. $taskData['sign_in_count'] = 0;
  936. }
  937. // 如存在未充值前的签到标记,且在同一天内完成充值,则补记签到
  938. $pendingKey = "vip_withdraw_sign_pending_{$userId}";
  939. $pendingSign = Redis::get($pendingKey);
  940. if ($pendingSign && $pendingSign == date('Ymd')) {
  941. $userRecharge = DB::table(TableName::QPAccountsDB() . 'YN_VIPAccount')
  942. ->where('UserID', $userId)
  943. ->value('Recharge') ?: 0;
  944. if ($userRecharge > 0) {
  945. if (($taskData['sign_in_count'] ?? 0) < 1) {
  946. $taskData['sign_in_count'] = 1;
  947. }
  948. \Log::info('VIP提现任务-签到补记成功(同日充值)', [
  949. 'user_id' => $userId,
  950. 'sign_in_count' => $taskData['sign_in_count']
  951. ]);
  952. }
  953. }
  954. if ($pendingSign) {
  955. Redis::del($pendingKey);
  956. }
  957. // 如存在“未充值前的签到标记”,且用户已完成充值,则补记签到次数
  958. $pendingKey = "vip_withdraw_sign_pending_{$userId}";
  959. if (Redis::exists($pendingKey)) {
  960. $userRecharge = DB::table(TableName::QPAccountsDB() . 'YN_VIPAccount')
  961. ->where('UserID', $userId)
  962. ->value('Recharge') ?: 0;
  963. if ($userRecharge > 0) {
  964. if (($taskData['sign_in_count'] ?? 0) < 1) {
  965. $taskData['sign_in_count'] = 1;
  966. }
  967. Redis::del($pendingKey);
  968. \Log::info('VIP提现任务-签到补记成功', [
  969. 'user_id' => $userId,
  970. 'sign_in_count' => $taskData['sign_in_count']
  971. ]);
  972. }
  973. }
  974. // 阶段3累计下注:基于总下注的增量进行累加(非时间周期)
  975. if (!isset($taskData['stage3_current_bet'])) {
  976. $taskData['stage3_current_bet'] = 0;
  977. }
  978. if (!isset($taskData['stage3_last_total_bet'])) {
  979. $taskData['stage3_last_total_bet'] = $totalBet; // 记录原始总下注(原始单位)
  980. }
  981. // 计算本次新增下注(转为金额单位)
  982. $deltaBet = $totalBet - ($taskData['stage3_last_total_bet'] ?? 0);
  983. if ($deltaBet > 0) {
  984. $taskData['stage3_current_bet'] += ($deltaBet / NumConfig::NUM_VALUE);
  985. $taskData['stage3_last_total_bet'] = $totalBet;
  986. }
  987. }
  988. /**
  989. * 检查任务完成状态
  990. */
  991. private function checkTaskCompletion(&$taskData)
  992. {
  993. // 阶段1任务检查
  994. $taskData['stage1_task1'] = $taskData['sign_in_count'] >= 1;
  995. $taskData['stage1_task2'] = $taskData['total_bet'] >= 100;
  996. $taskData['stage1_task3'] = $taskData['recharge_count'] >= 1;
  997. $taskData['stage1_completed'] = $taskData['stage1_task1'] &&
  998. $taskData['stage1_task2'] &&
  999. $taskData['stage1_task3'];
  1000. // 阶段2任务检查
  1001. if ($taskData['stage1_completed']) {
  1002. $taskData['stage2_task1'] = $taskData['played_games_count'] >= 6;
  1003. $taskData['stage2_task2'] = $taskData['total_bet'] >= 3000;
  1004. $taskData['stage2_task3'] = $taskData['invite_count'] >= 1;
  1005. $taskData['stage2_completed'] = $taskData['stage2_task1'] &&
  1006. $taskData['stage2_task2'] &&
  1007. $taskData['stage2_task3'];
  1008. }
  1009. // 阶段3任务检查(循环):基于累计下注,不使用时间周期
  1010. if ($taskData['stage2_completed']) {
  1011. $taskData['stage3_task1'] = ($taskData['stage3_current_bet'] ?? 0) >= 6000;
  1012. }
  1013. }
  1014. /**
  1015. * 更新任务进度
  1016. */
  1017. private function updateTaskProgress($userId, $key, $value)
  1018. {
  1019. $redisKey = "vip_withdraw_task_{$userId}";
  1020. $data = Redis::get($redisKey);
  1021. if ($data) {
  1022. $taskData = json_decode($data, true);
  1023. $taskData[$key] = $value;
  1024. // ✅ 保存到数据库(持久化)
  1025. $this->saveUserTaskData($userId, $taskData);
  1026. // ✅ 更新Redis缓存(24小时)
  1027. Redis::setex($redisKey, 86400, json_encode($taskData));
  1028. }
  1029. }
  1030. /**
  1031. * 重置阶段3循环任务
  1032. */
  1033. private function resetStage3Tasks($userId)
  1034. {
  1035. $redisKey = "vip_withdraw_task_{$userId}";
  1036. $data = Redis::get($redisKey);
  1037. if ($data) {
  1038. $taskData = json_decode($data, true);
  1039. $taskData['stage3_task1'] = false;
  1040. $taskData['stage3_task1_withdrawn'] = false;
  1041. $taskData['stage3_current_bet'] = 0;
  1042. $taskData['stage3_cycle_start'] = (int)date('Ymd');
  1043. $taskData['stage3_loop_count'] = ($taskData['stage3_loop_count'] ?? 0) + 1;
  1044. // ✅ 保存到数据库(持久化)
  1045. $this->saveUserTaskData($userId, $taskData);
  1046. // ✅ 更新Redis缓存(24小时)
  1047. Redis::setex($redisKey, 86400, json_encode($taskData));
  1048. }
  1049. }
  1050. /**
  1051. * 手动触发签到(供其他地方调用)
  1052. * 注意:只有充值用户才会计数
  1053. */
  1054. public function triggerSignIn($userId)
  1055. {
  1056. // 检查用户是否已充值(仅用于记录日志,不再阻断签到进度)
  1057. $user_recharge = DB::table(TableName::QPAccountsDB() . 'YN_VIPAccount')
  1058. ->where('UserID', $userId)
  1059. ->value('Recharge') ?: 0;
  1060. $hasRecharge = $user_recharge > 0;
  1061. $pendingKey = "vip_withdraw_sign_pending_{$userId}";
  1062. if (!$hasRecharge) {
  1063. // 未充值用户,先把签到标记在Redis中,等待充值后结算(仅限同一天)
  1064. Redis::setex($pendingKey, 86400, date('Ymd')); // 标记签到日期
  1065. \Log::info('VIP提现任务-签到记录(待充值)', [
  1066. 'user_id' => $userId,
  1067. 'note' => '用户尚未充值,签到标记已暂存Redis',
  1068. 'redis_key' => $pendingKey
  1069. ]);
  1070. return true;
  1071. }
  1072. // 用户已充值,如存在待结算签到标记,检查是否为同一天
  1073. $pendingSign = Redis::get($pendingKey);
  1074. if ($pendingSign && $pendingSign == date('Ymd')) {
  1075. // 同一天内补记签到次数(若尚未计数)
  1076. $redisKey = "vip_withdraw_task_{$userId}";
  1077. $data = Redis::get($redisKey);
  1078. if ($data) {
  1079. $taskData = json_decode($data, true);
  1080. if (($taskData['sign_in_count'] ?? 0) < 1) {
  1081. $taskData['sign_in_count'] = 1;
  1082. $this->saveUserTaskData($userId, $taskData);
  1083. Redis::setex($redisKey, 86400, json_encode($taskData));
  1084. }
  1085. } else {
  1086. $dbData = DB::table('agent.dbo.vip_withdraw_tasks')
  1087. ->where('user_id', $userId)
  1088. ->first();
  1089. if ($dbData) {
  1090. $taskData = json_decode($dbData->task_data, true);
  1091. } else {
  1092. $taskData = $this->initUserTaskData($userId);
  1093. }
  1094. if (($taskData['sign_in_count'] ?? 0) < 1) {
  1095. $taskData['sign_in_count'] = 1;
  1096. $this->saveUserTaskData($userId, $taskData);
  1097. }
  1098. Redis::setex($redisKey, 86400, json_encode($taskData));
  1099. }
  1100. \Log::info('VIP提现任务-签到补记成功(同日充值)', [
  1101. 'user_id' => $userId
  1102. ]);
  1103. }
  1104. Redis::del($pendingKey);
  1105. $redisKey = "vip_withdraw_task_{$userId}";
  1106. $data = Redis::get($redisKey);
  1107. if ($data) {
  1108. $taskData = json_decode($data, true);
  1109. $taskData['sign_in_count'] = ($taskData['sign_in_count'] ?? 0) + 1;
  1110. // ✅ 保存到数据库(持久化)
  1111. $this->saveUserTaskData($userId, $taskData);
  1112. // ✅ 更新Redis缓存(24小时)
  1113. Redis::setex($redisKey, 86400, json_encode($taskData));
  1114. \Log::info('VIP提现任务-签到触发成功', [
  1115. 'user_id' => $userId,
  1116. 'sign_in_count' => $taskData['sign_in_count']
  1117. ]);
  1118. return true;
  1119. } else {
  1120. // 如果Redis没有数据,从数据库加载或初始化
  1121. $dbData = DB::table('agent.dbo.vip_withdraw_tasks')
  1122. ->where('user_id', $userId)
  1123. ->first();
  1124. if ($dbData) {
  1125. $taskData = json_decode($dbData->task_data, true);
  1126. } else {
  1127. $taskData = $this->initUserTaskData($userId);
  1128. }
  1129. $taskData['sign_in_count'] = ($taskData['sign_in_count'] ?? 0) + 1;
  1130. // ✅ 保存到数据库(持久化)
  1131. $this->saveUserTaskData($userId, $taskData);
  1132. // ✅ 更新Redis缓存(24小时)
  1133. Redis::setex($redisKey, 86400, json_encode($taskData));
  1134. \Log::info('VIP提现任务-签到触发成功(首次)', [
  1135. 'user_id' => $userId,
  1136. 'sign_in_count' => 1
  1137. ]);
  1138. return true;
  1139. }
  1140. }
  1141. /**
  1142. * 手动触发邀请(供其他地方调用)
  1143. * 注意:只有充值用户且阶段1完成后才会计数
  1144. */
  1145. public function triggerInvite($userId)
  1146. {
  1147. // 检查用户是否已充值
  1148. $user_recharge = DB::table(TableName::QPAccountsDB() . 'YN_VIPAccount')
  1149. ->where('UserID', $userId)
  1150. ->value('Recharge') ?: 0;
  1151. if ($user_recharge <= 0) {
  1152. \Log::info('VIP提现任务-邀请触发失败', [
  1153. 'user_id' => $userId,
  1154. 'reason' => '用户未充值'
  1155. ]);
  1156. return false;
  1157. }
  1158. $redisKey = "vip_withdraw_task_{$userId}";
  1159. $data = Redis::get($redisKey);
  1160. if ($data) {
  1161. $taskData = json_decode($data, true);
  1162. // 检查阶段1是否完成
  1163. if (!isset($taskData['stage1_completed']) || !$taskData['stage1_completed']) {
  1164. // 阶段1未完成,不计数
  1165. \Log::info('VIP提现任务-邀请触发失败', [
  1166. 'user_id' => $userId,
  1167. 'reason' => '阶段1未完成',
  1168. 'stage1_completed' => $taskData['stage1_completed'] ?? false
  1169. ]);
  1170. return false;
  1171. }
  1172. // 阶段1已完成,增加邀请计数
  1173. $taskData['invite_count'] = ($taskData['invite_count'] ?? 0) + 1;
  1174. // ✅ 保存到数据库(持久化)
  1175. $this->saveUserTaskData($userId, $taskData);
  1176. // ✅ 更新Redis缓存(24小时)
  1177. Redis::setex($redisKey, 86400, json_encode($taskData));
  1178. \Log::info('VIP提现任务-邀请触发成功', [
  1179. 'user_id' => $userId,
  1180. 'invite_count' => $taskData['invite_count']
  1181. ]);
  1182. return true;
  1183. } else {
  1184. // 如果Redis没有数据,从数据库加载
  1185. $dbData = DB::table('agent.dbo.vip_withdraw_tasks')
  1186. ->where('user_id', $userId)
  1187. ->first();
  1188. if ($dbData) {
  1189. $taskData = json_decode($dbData->task_data, true);
  1190. // 检查阶段1是否完成
  1191. if (!isset($taskData['stage1_completed']) || !$taskData['stage1_completed']) {
  1192. \Log::info('VIP提现任务-邀请触发失败', [
  1193. 'user_id' => $userId,
  1194. 'reason' => '阶段1未完成'
  1195. ]);
  1196. return false;
  1197. }
  1198. // 增加邀请计数
  1199. $taskData['invite_count'] = ($taskData['invite_count'] ?? 0) + 1;
  1200. // ✅ 保存到数据库(持久化)
  1201. $this->saveUserTaskData($userId, $taskData);
  1202. // ✅ 更新Redis缓存(24小时)
  1203. Redis::setex($redisKey, 86400, json_encode($taskData));
  1204. \Log::info('VIP提现任务-邀请触发成功(从数据库加载)', [
  1205. 'user_id' => $userId,
  1206. 'invite_count' => $taskData['invite_count']
  1207. ]);
  1208. return true;
  1209. } else {
  1210. // 用户数据不存在或阶段1未完成
  1211. \Log::info('VIP提现任务-邀请触发失败', [
  1212. 'user_id' => $userId,
  1213. 'reason' => '用户数据不存在或阶段1未完成'
  1214. ]);
  1215. return false;
  1216. }
  1217. }
  1218. }
  1219. }