lw_test/app/admin/controller/Couple.php

<?php

namespace app\admin\controller;

use app\admin\AdminBaseController;

class Couple extends AdminBaseController
{

    public function index()
    {
        return view();
    }

    public function import()
    {
        return view();
    }

    public function match()
    {
        $old_file = input('old_file/s', "");
        if (!file_exists($old_file)) {
            return '旧名单文件不存在';
        }
        $new_file = input('new_file/s', "");
        if (!file_exists($new_file)) {
            return '新名单文件不存在';
        }

        //初始化数据
        $data     = ['id', 'name', 'company', 'level', 'street', 'mobile', 'people'];
        $old_list = import_exl($old_file, $data, 1);
        $new_list = import_exl($new_file, $data, 1);
        if (empty($old_list)) {
            return '旧名单文件无数据';
        }
        if (empty($new_list)) {
            return '新名单文件无数据';
        }

        //数据处理
        $old_idcard = array_column($old_list, 'mobile');
        $new_idcard = array_column($new_list, 'mobile');
        $delete     = array_diff($old_idcard, $new_idcard);
        $add        = array_diff($new_idcard, $old_idcard);
        $list       = array_intersect($new_idcard, $old_idcard);

        //旧名单重整
        $old_people_by_mobile  = [];
        $old_people_by_company = [];
        foreach ($old_list as $v) {
            $old_people_by_mobile[$v['mobile']]   = $v['people'];
            $old_people_by_company[$v['company']] = $v['people'];
        }

        //匹配名单
        $res = [];
        foreach ($delete as $k => $v) {
            $item           = $old_list[$k];
            $item['status'] = '过期';
            $res[]          = $item;
        }

        foreach ($add as $k => $v) {
            $item           = $new_list[$k];
            $item['status'] = '新增';
            $item['people'] = $old_people_by_company[$v['company']] ?? '';
            $res[]          = $item;
        }

        foreach ($list as $k => $v) {
            $item           = $new_list[$k];
            $item['status'] = '续期';
            $item['people'] = $old_people_by_mobile[$v];
            $res[]          = $item;
        }

        $xlsCell = [
            ['id', '序号'],
            ['name', '姓名'],
            ['company', '单位名称'],
            ['level', '人才层次'],
            ['street', '所属镇街'],
            ['mobile', '联系方式'],
            ['people', '挂钩人员'],
            ['status', '状态'],
        ];
        export_exl("人才挂钩名单匹配记录", $xlsCell, $res);
    }

}