video_system/app/Http/Controllers/TestsController.php

<?php
/**
 * Created by PhpStorm.
 * User: qiuzijian
 * Date: 2021-05-18
 * Time: 15:09
 */

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Config;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Input;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Redis;
use Modules\Camera\Entities\CameraList;
use Modules\Camera\Enum\CameraEnum;
use Modules\Camera\Http\Controllers\Api\HaiKangController;
use Modules\Camera\Jobs\CameraDownload;
use Modules\Camera\Services\CameraServices;
use Modules\Mine\Entities\MineListExt;
use Modules\Mine\Services\MineServices;

class TestsController {

    public function test()
    {
        $arr = CameraList::where('mine_id', 40)->where('index_code', '!=', NULL)->get()->toArray();
        dd($arr);
        $query = CameraList::where('index_code', '!=', '')->groupBy('index_code')->select(
            [
                DB::raw('count(*) as q_count'),
                'index_code'
            ]
        )->get()->toArray();

        foreach ($query as $key => $val) {
            if ($val['q_count'] > 1) {
                $list = CameraList::where('index_code', $val['index_code'])->get()->toArray();
                foreach ($list as $k => $v) {
                    if ($k > 0) {
                        CameraList::where('id', $v['id'])->delete();
                    }
                }
            }
        }
    }
}