<?php /** * ${CARET} * @file:HuaWeiController.php * @Created by gnitif * @Date: 2023/2/6 * @Time: 15:40 */ namespace App\Http\Controllers\QuickApp; use App\Http\Controllers\Controller; use App\Modules\Subscribe\Services\ChapterOrderService; use App\Modules\User\Services\ReadRecordService; use Illuminate\Support\Facades\DB; class HuaWeiController extends Controller { public function index(){ set_time_limit(0); // // die(); $sql = "SELECT id,send_order_id,balance,created_at FROM users WHERE send_order_id in (4007118,4007706,4007708,4007731,4007733,4007793,4007834,4007843,4009806,4012429,4016127,4023097) and LENGTH(openid) > 32 AND created_at > '2023-02-2' and balance > 0 and balance < 100;"; // $sql = "SELECT id,send_order_id,balance,created_at FROM users WHERE 1 limit 10"; $uids = DB::select($sql); if(!is_empty($uids)){ foreach ($uids as $v){ $res = ReadRecordService::getReadRecord($v->id); if (is_empty($res)){ $res = array_column($res,null,'bid'); $res = $res[66643] ?? []; } if (!is_empty($res)){ if (isset($res['cid']) && $v->id > 0 && in_array($res['cid'],[30300728,30300727,30300726,30300725,30300724,30300723] )){ ReadRecordService::delReadRecordStatic($v->id, [66643]); } } // $res = ReadRecordService::getReadRecord(1234598187); echo "<pre><hr> uid => ".$v->id."\t 书币:{$v->balance} \t 注册时间:{$v->created_at} \t 阅读书籍本数:".count($res)."<br> "; // var_export($res); } } } }