zhuishuyun_quickapp/app/Http/Controllers/QuickApp/HuaWeiController.php

<?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(){

     
        //

        // 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);

        }

    }


}