lw_test/app/api/controller/Test.php

<?php

namespace app\api\controller;

use think\facade\Db;

class Test
{
    public function t1()
    {
        ajax_success();
        $list = import_exl('1.xlsx',['name','sex','card_type','card_no','company','post','start_time','end_time','level','mobile'],1);
        $level_list = [
            '省特级' => '第一层次',
            '省级A类' => '第一层次',
            '省级B类' => '第二层次',
            '省级C类' => '第三层次',
        ];
        foreach ($list as $k => $v) {
//            $time = explode(' - ',$v['start_time']);
//            $list[$k]['start_time'] = $time[0].' 00:00:00';
//            $list[$k]['end_time'] = $time[1].' 00:00:00';
//            $list[$k]['level'] = str_replace(['泉州','(自主认定)'],'',$v['level']);

//            $list[$k]['start_time'] = str_replace('.','-',$v['start_time']).' 00:00:00';
//            $end = (int) $v['end_time'];
//            if (empty($end)) {
//                $list[$k]['end_time'] = '2099-01-01 00:00:00';
//            } else {
//                $list[$k]['end_time'] = date('Y-m-d H:i:s',strtotime("+{$end} years",strtotime($list[$k]['start_time'])));
//            }
//
//            $list[$k]['level'] = $level_list[$v['level']];

            $list[$k]['start_time'] = '2025-01-01 00:00:00';
            $list[$k]['end_time'] = '2099-01-01 00:00:00';
        }

//        halt($list);

        Db::name('talent')->insertAll($list);
        ajax_success();
    }

}