lw_test/app/home/controller/Index.php

<?php

namespace app\home\controller;

use app\common\model\OfficerReviewTitleModel;
use app\common\model\PreviousModel;
use app\common\model\ReservedModel;
use app\home\HomeBaseController;

class Index extends HomeBaseController
{
    public function index()
    {
        $reserved = ReservedModel::where('status', ReservedModel::STATUS_SHOW)
            ->order(['priority' => 'desc', 'id' => 'desc'])
            ->select();

        $previous = PreviousModel::where('status', ReservedModel::STATUS_SHOW)
            ->order(['priority' => 'desc', 'id' => 'desc'])
            ->limit(15)
            ->select();
        $previous_list = [];
        foreach ($previous as $k => $v) {
            $item = floor($k / 3);
            $previous_list[$item][] = $v;
        }

        return view('', [
            'reserved' => $reserved,
            'previous_list' => $previous_list,
        ]);
    }

    public function t1()
    {
        return '';
        $str  = '';
        $arr  = json_decode($str, true);
        $no   = 292;
        $rid  = 3;
        $rsid = 9;
        foreach ($arr as $v) {
            OfficerReviewTitleModel::create([
                'rid'    => $rid,
                'rsid'   => $rsid,
                'no'     => $no,
                'title'  => $v['title'],
                'option' => json_encode($v['options'], JSON_UNESCAPED_UNICODE),
            ]);
            $no++;
        }

        return '完成';
    }

    public function t2()
    {
        $old_file = '1.xls';
        $data     = ['id', 'name', 'card_type', 'idcard', 'sex', 'birthday', 'mobile', 'tag', 'company', 'street', 'industry', 'job', 'graduate', 'level', 'people'];
        $old_list = import_exl($old_file, $data, 1);

        $companys = [];
        foreach ($old_list as $v) {
            $companys[$v['company']][] = $v['people'];
        }

        $companys2 = [];
        foreach ($companys as $k => $v) {
            $item = array_filter(array_unique($v));
            if (count($item) > 1) {
                $companys2[$k] = $item;
            }
        }
        halt($companys2);
    }
}