Php 自定义 laravel artisan 命令处理大型嵌套文件 struct 和大型数据集

1. 获取所有超过50天的文件夹名称

2. 从文件夹名称获取所有用户ID

3. 用户是否完成签入DB

4. 仅删除已完成的用户文件夹

    collect(Storage::directories('data/'))
    ->filter(function ($directory) {
        $directoryDate = Str::after($directory, '/');
   
        // check directory is older than 50 days
        if (Carbon::parse($directoryDate)->lte(now()->subDays(50))) {
            // get all user ids from directoryDate folder
            $userids = collect(Storage::directories('data/'.$directoryDate))
            ->map(function ($userDirectory) use ($directoryDate) {
                return Str::after($userDirectory, 'data/'.$directoryDate.'/');
            });
            // check whether the user is completed or not. return only completed user ids onlys
            // instead using one query for one folder we are doing it in single query. it will reduce read operation in db
            $complete_duser_ids = User::where('is_complete',1)->wherein('id', $userids->all())->get()->pluck('id')->toArray();
   
            // delete the user folder who completed
            foreach ($complete_duser_ids as $completed_user) {
                Storage::deleteDirectory('data/'.$directoryDate.'/'.$completed_user);
            }
        }
   
   
    });
   

我们正在获取所有用户文件夹ID，然后签入数据库.一旦我们得到要删除的信息，查询将只返回已完成的用户.您可以在计划作业(job)上使用此逻辑.