菜单 学习猿地 - LMONKEY

VIP

开通学习猿地VIP

尊享10项VIP特权 持续新增

知识通关挑战

打卡带练!告别无效练习

接私单赚外块

VIP优先接,累计金额超百万

学习猿地私房课免费学

大厂实战课仅对VIP开放

你的一对一导师

每月可免费咨询大牛30次

领取更多软件工程师实用特权

入驻
295
0

Laravel 数据去重

原创
05/13 14:22
阅读数 85370
public function timingApplyBorrow()
    {
        //截断表数据
        YunUserBorrowList::truncate();

        YunUserEntry::select('id', 'name', 'company_id', 'id_no', 'id_no')->chunk(100, function ($data) {
            $array = [];
            $arr = [];
            foreach ($data as $value) {
                $arr['user_id'] = $value->id;
                $arr['name'] = $value->name;
                $arr['borrow_no'] = $this->is_allow;
                $arr['id_no'] = $value->id_no ?? '';
                $arr['company_name'] = $this->yunCompany($value->company_id);
                $array[] = $arr;
            }

            YunUserBorrowList::insert($array);
        });
        $sql = 'DELETE FROM yun_user_borrow_lists WHERE id_no IN(SELECT id_no FROM (SELECT id_no FROM yun_user_borrow_lists
                GROUP BY id_no HAVING COUNT(id_no) > 1) a) AND id NOT IN(SELECT * FROM (SELECT MIN(id) FROM yun_user_borrow_lists
                GROUP BY id_no HAVING COUNT(id_no) > 1) b)';
        //数据去重
        DB::delete($sql);
        return Helper::jsonSuccessData([], '申请成功,请等候审核');

    }

发表评论

0/200
295 点赞
0 评论
收藏