<?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(){ ReadRecordService::delReadRecordStatic(341799779, [66643]); echo "<hr>"; die(); // // 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 < 100;"; // $sql = "SELECT id,send_order_id,balance,created_at FROM users WHERE 1 limit 10"; $uids = DB::select($sql); foreach ($uids as $v){ $res = ReadRecordService::getReadRecord($v->id); if ($res){ $res = array_column($res,null,'bid'); $res = $res[66643] ?? []; } if ($res){ if (isset($res['cid']) && in_array($res['cid'],[30300728,30300727,30300726,30300725,30300724,30300723] )){ ReadRecordService::delReadRecordStatic($this->uid, [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); } } }