lw_test/app/admin/controller/Grade.php

<?php

namespace app\admin\controller;

use app\admin\AdminBaseController;
use app\common\model\GradeModel;
use app\common\service\QrcodeService;

class Grade extends AdminBaseController
{

    /**
     * 列表
     */
    public function index()
    {
        $file_url = QrcodeService::getQrcode('grade_index', url('/mobile/grade/login'), 600);
        return view('', [
            'is_final_list' => GradeModel::IS_FINAL,
            'file_url'       => $file_url,
        ]);
    }

    public function listGrade()
    {
        $map   = $this->dealEqualInput(['is_final'], $this->dealLikeInput(['name', 'no', 'company']));
        $list  = GradeModel::where($map)
            ->order(['rank' => 'asc'])
            ->limit(input('limit'))
            ->page(input('page'))
            ->append(['is_final_text'])
            ->select();
        $count = GradeModel::where($map)->count();
        if ($count == 0) {
            ajax_return(1, '未查询到数据');
        }
        list_return($list, $count);
    }

    public function delGrade()
    {
        $id_arr = input('id_arr/a');
        GradeModel::destroy($id_arr);
        ajax_return();
    }

    /**
     * 编辑
     */
    public function gradeForm()
    {
        $id   = input('id/d, 0');
        $info = GradeModel::find($id);

        return view('', [
            'info'          => $info,
            'is_final_list' => GradeModel::IS_FINAL,
        ]);
    }

    public function editGrade()
    {
        $data = input('post.');

        if (empty($data['id'])) {
            GradeModel::create($data);
        } else {
            GradeModel::update($data, ['id' => $data['id']]);
        }

        ajax_return();
    }

    /**
     * 用户导入
     */
    public function import()
    {
        return view('public/import', [
            'url'           => url('grade/importPost'),
            'last_table'    => 'lay-grade-index-table',
            'template_file' => '/static/common/exl/grade.xls',
        ]);
    }

    /**
     * 用户导入提交
     */
    public function importPost()
    {
        $file_url = input('file_url/s', "");
        if (!file_exists($file_url)) {
            ajax_return(1, '文件不存在');
        }

        //初始化数据
        $data = ['no', 'name', 'company', 'theory_score', 'computer_score', 'total_score', 'rank', 'is_final'];
        $list = import_exl($file_url, $data, 1);
        if (empty($list)) {
            ajax_return(1, '请上传有数据的文件');
        }

        foreach ($list as &$v) {
            $v['total_score'] = $v['theory_score'] + $v['computer_score'];
            $v['name'] = str_replace(' ','',$v['name']);
        }
        unset($v);

        GradeModel::insertAll($list);
        ajax_return(0);
    }
}