lw_test/app/admin/controller/Officer.php

<?php

namespace app\admin\controller;

use app\admin\AdminBaseController;
use app\common\model\OfficerAnswerModel;
use app\common\model\OfficerReviewModel;

class Officer extends AdminBaseController
{
    public function index()
    {
        return view();
    }

    public function listOfficer()
    {
        $list  = OfficerReviewModel::limit(input('limit'))
            ->page(input('page'))
            ->select();
        $count = OfficerReviewModel::count();
        if ($count == 0) {
            ajax_return(1, '未查询到数据');
        }
        list_return($list, $count);
    }

    /**
     * 列表
     */
    public function detail()
    {
        $id = input('id');
        if (empty($id)) {
            return '该测评不存在';
        }

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

    public function listDetail()
    {
        $id    = input('id', 0);
        $list  = OfficerAnswerModel::where('rid', $id)
            ->order('id', 'desc')
            ->limit(input('limit'))
            ->page(input('page'))
            ->append(['status_text'])
            ->select();
        $count = OfficerAnswerModel::count();
        if ($count == 0) {
            ajax_return(1, '未查询到数据');
        }
        list_return($list, $count);
    }

    public function export()
    {
        $id   = input('id', 0);
        $list = OfficerAnswerModel::with(['detail'])
            ->where('rid', $id)
            ->order('id', 'desc')
            ->append(['status_text'])
            ->select();

        if ($list->isEmpty()) {
            return '暂无人答题';
        }

        $xlsCell = [
            ['name', '姓名'],
            ['mobile', '手机号'],
            ['sex', '性别'],
            ['age', '年龄'],
            ['marry', '婚姻状况'],
            ['education', '学历'],
            ['major', '专业'],
            ['seniority', '工龄'],
            ['leader', '担任领导的累计年限'],
            ['industry', '所在行业'],
            ['company', '所在单位'],
            ['job', '职位'],
        ];

        $res = [];
        foreach ($list as $ak => $answer) {
            $item              = [];
            $item['name']      = $answer['name'];
            $item['mobile']    = $answer['mobile'];
            $item['sex']       = $answer['sex'];
            $item['age']       = $answer['age'];
            $item['marry']     = $answer['marry'];
            $item['education'] = $answer['education'];
            $item['major']     = $answer['major'];
            $item['seniority'] = $answer['seniority'];
            $item['leader']    = $answer['leader'];
            $item['industry']  = $answer['industry'];
            if (empty($answer['company_text'])) {
                $item['company'] = $answer['company'];
            } else {
                $item['company'] = $answer['company'] . "（{$answer['company_text']}）";
            }
            if (empty($answer['job_text'])) {
                $item['job'] = $answer['job'];
            } else {
                $item['job'] = $answer['job'] . "（{$answer['job_text']}）";
            }
            foreach ($answer['detail'] as $k => $v) {
                $index = 'part_' . $v['no'];
                if ($ak == 0) {
                    $xlsCell[] = [$index, $index];
                }
                $item[$index] = $v['score'];
            }
            $res[] = $item;
        }

        export_exl("考试明细", $xlsCell, $res);
    }
}