<?php

namespace app\home\controller;

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()
    {
        $str= file_get_contents('1.json');
        $arr = json_decode($str,true);

        $xlsCell = [
            ['ID', '编号'],
            ['Content', '素材内容'],
        ];
        export_exl("厂房-整句", $xlsCell, $arr['data'],['ID']);
    }

    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);
    }
}