jucai/app/Admin/Controllers/Recruit/RecruitController.php

<?php

namespace App\Admin\Controllers\Recruit;

use App\Http\Controllers\Controller;
use App\Admin\Extensions\Form\ValidateForm;
use App\Models\Member;
use App\Models\Pms;
use App\Models\Recruit;
use App\Models\RecruitAppointDetail;
use App\Models\RecruitAppointExpandSpecial;
use App\Models\RecruitPost;
use App\Models\RecruitAppointInfo;
use App\Models\RecruitSubjoin;
use App\Models\RecruitAppointLog;
use App\Models\RecruitTicketField;
use dir\Dir;
use Encore\Admin\Grid;
use Encore\Admin\Form;
use Encore\Admin\Show;
use Encore\Admin\Layout\Content;
use Encore\Admin\Facades\Admin;
use Encore\Admin\Auth\Permission;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Storage;
use App\Models\Admin\AdminUser;
use PhpOffice\PhpWord\TemplateProcessor;
use Chumper\Zipper\Zipper;
use App\Models\RecruitTicket;
use App\Services\Common\SmsService;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
use PhpOffice\PhpWord\IOFactory as WordIOFactory;
use PhpOffice\PhpWord\Settings;
use App\Jobs\TicketJob;

class RecruitController extends Controller
{
    private $smsService;

    public function __construct(SmsService $smsService)
    {
        $this->smsService = $smsService;
    }

    /**
     * 招考报名首页
     * @param Content $content
     * @return Content
     */
    public function index(Content $content)
    {
        return $content
            ->header('招考报名管理')
            ->description('')
            ->body($this->grid());
    }

    /**
     * 新增招考报名表单页.
     *
     * @param Content $content
     * @return Content
     */
    public function create(Content $content)
    {
        Permission::check('recruit_manager_create');
        return $content
            ->header('新增招聘场次')
            ->description('新增')
            ->body(view('admin.recruit.index')->with(['grid' => $this->form()->render(), 'id' => '0']));
    }

    /**
     * Edit interface.
     *
     * @param mixed $id
     * @param Content $content
     * @return Content
     */
    public function edit($id, Content $content)
    {
        Permission::check('recruit_manager_edit');
        $grid = $this->form()->edit($id)->render();
        return $content
            ->header('招考管理')
            ->description('编辑')
            ->body(view('admin.recruit.index')->with(['grid' => $grid, 'id' => $id]));
    }

    /**
     * Show interface.
     *
     * @param mixed $id
     * @param Content $content
     * @return Content
     */
    public function show($id, Content $content)
    {
        return redirect('/ST3IXxKlOa4eGEv0eTw0CfORI9444Mgj/recruit/index');
    }

    public function detail($id)
    {
        $show = new Show(Recruit::findOrFail($id));
//        $recruit = Recruit::findOrFail($id);
        $show->title('标题');
        $show->created_at('创建时间');
        return $show;
    }

    /**
     * 获得招考场次的岗位
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function getRecruitPost(Request $request)
    {
        $id = $request->id;
        $recruit = Recruit::find($id);
        $post = RecruitPost::where('recruit_id', $id)->get();
        return response()->json(['post' => $post, 'recruit' => $recruit], '200');
    }

    /**
     * Make a grid builder.
     *
     * @return Grid
     */
    protected function grid()
    {
        $grid = new Grid(new Recruit);
        $grid->model()->orderBy('created_at', 'DESC');
        $grid->model()->paginate(20);
        if (Admin::user()->can('recruit_manager_create')) {
            $grid->disableCreateButton(false);
        }
        $grid->perPages([10, 20, 30, 40, 50, 100]);
        $grid->id('ID');
        $grid->name('招考场次名称');
        $grid->column('current','当前阶段')->display(function ($current) {
            switch ($current){
                case '1':
                    return '报名';
                    break;
                case '2':
                    return '审核';
                    break;
                case '3':
                    return '笔试';
                    break;
                case '4':
                    return '上机测试';
                    break;
                case '5':
                    return '面试';
                    break;
                case '6':
                    return '复试';
                    break;
                case '7':
                    return '体验';
                    break;
                case '8':
                    return '政审';
                    break;
                case '9':
                    return '公示';
                    break;
                case '0':
                    return '已结束';
                    break;
            }
        });
        $grid->column('status','状态')->display(function ($status) {
            return $status ? '显示' : '隐藏';
        });

        $grid->created_at('创建时间');
        $grid->actions(function ($actions) {
            $actions->append('<a href="/ST3IXxKlOa4eGEv0eTw0CfORI9444Mgj/recruit/appoint_list?id=' . $actions->row['id'] . '"  class="btn btn-primary btn-xs" >报名管理</a>');
            $actions->disableEdit(false);
            $actions->disableDelete(false);
            $actions->disableView();
        });


        return $grid;
    }

    /**
     * 新增/修改招考场次的表单
     *
     * @return Form
     */
    protected function form()
    {
        $form = new ValidateForm(new Recruit);

        $form->tab('基础信息', function ($form) {
            $form->text('name', '招考场次名称')->rules('required|between:4,61', [
                'required' => '请填写招考场次名称',
                'between' => '招考场次名称长度为2~30个字符'
            ])->setWidth(5)->setMustMark();
            $form->text('company', '招聘主体')->rules('required|between:4,61', [
                'required' => '请填写招聘主体',
                'between' => '招聘主体长度为2~30个字符'
            ])->setWidth(5)->setMustMark();
            $form->text('name_en', '英文标识')->setWidth(5)->help('同一个招聘单位，发布的招聘场次若不在同一天，允许一样，若为空则自动生成');
            $form->image('small_img', '缩略图')->uniqueName()->setWidth(3);
            $form->switch('status', '状态')->default(1)->setMustMark();
            $form->radio('current', '当前进展')->options([1 => '报名', 2 => '审核', 3 => '笔试', 4 => '上机测试', 5 => '面试', 6 => '复试', 7 => '体检', 8 => '政审', 9 => '公示',0 => '已结束'])->default(1)->setMustMark();
            $form->checkbox('step', '招考流程')->options([1 => '报名', 2 => '审核', 3 => '笔试', 4 => '上机测试', 5 => '面试', 6 => '复试', 7 => '体检', 8 => '政审', 9 => '公示'])->default([1, 2])->setMustMark();
            $form->datetimeRange('apply_start', 'apply_end', '报名日期')->rules('required', array('required' => '报名日期必须设置'))->setMustMark();
            $form->datetimeRange('audit_start', 'audit_end', '审核日期');
            $form->datetimeRange('preliminary_start', 'preliminary_end', '笔试时间');
            $form->datetimeRange('computer_start', 'computer_end', '上机时间');
            $form->datetimeRange('interview_start', 'interview_end', '面试时间');
            $form->datetimeRange('reexamine_start', 'reexamine_end', '复试时间');
            $form->datetimeRange('health_start', 'health_end', '体检时间');
            $form->datetimeRange('political_start', 'political_end', '政审时间');
            $form->datetimeRange('publicity_start', 'publicity_end', '公示时间');
            $form->editor('introduction', '招考正文')->rules('required', array('required' => '招考正文不能为空。'))->setMustMark();
            $form->text('contact', '联系人');
            $form->text('phone', '联系电话');
            $form->text('host_address', '联系地址');
            //$form->switch('predetermined_status', '是否允许报名')->states($display_option)->default(1)->setMustMark();
            $form->number('ordid', '排序')->default(0);
            $form->multipleFile('addFile', '附件')->move('storage/app/public/recruit/' . time());
        })->tab('报名表单与条件', function ($form) {
            $form->checkbox('forms', '报名表单模块')->options(['basic' => '基础信息模块','expand_special' => '扩展模块-加分','detail' => '详情介绍模块','identification' => '身份证明上传模块','education_certification' => '学历证明上传模块','other_certification' => '其他证明上传模块', 'remark' => '备注模块'])->default(['basic'])->setMustMark();
            $form->text('limit_times', '报名次数限制')->rules('required|regex:/^\d+$/', [
                'required' => '报名限制次数必须填写',
                'regex' => '次数必须为数字'
            ])->default(1)->help('同一个场次允许同时报名几个岗位，直接输入数字即可');
            $form->text('post_times', '审核次数限制')->rules('required|regex:/^\d+$/', [
                'required' => '审核限制次数必须填写',
                'regex' => '次数必须为数字'
            ])->default(1)->help('允许提交审核的次数，直接输入数字即可');
            $form->radio('pay_switch', '缴费报名')->options([0 => '否', 1 => '是'])->default(0);
        })->tab('笔试', function ($form) {
            $form->radio('pen_ticket_type', '准考证类型')->options([-1 => '不需要',1 => '纸质', 2 => '短信'])->default(-1);
            $form->text('pen_ticket_content', '准考证内容')->help('当类型为纸质时，此处填入准考证模板的路径，当类型为短信时，此处填入短信标识');
            $form->listbox('pen_ticket_field', '模板字段')->options(RecruitTicketField::ticketFieldData('pen'))->attribute('hight', '200px')->help('仅纸质准考证需要，非ex开头的字段将自动渲染');
        })->tab('上机', function ($form) {
            $form->radio('computer_ticket_type', '准考证类型')->options([-1 => '不需要',1 => '纸质', 2 => '短信'])->default(-1);
            $form->text('computer_ticket_content', '准考证内容')->help('当类型为纸质时，此处填入准考证模板的路径，当类型为短信时，此处填入短信标识');
            $form->listbox('computer_ticket_field', '模板字段')->options(RecruitTicketField::ticketFieldData('computer'))->attribute('hight', '200px')->help('仅纸质准考证需要，非ex开头的字段将自动渲染');
        })->tab('面试', function ($form) {
            $form->radio('face_ticket_type', '准考证类型')->options([-1 => '不需要',1 => '纸质', 2 => '短信'])->default(-1);
            $form->text('face_ticket_content', '准考证内容')->help('当类型为纸质时，此处填入准考证模板的路径，当类型为短信时，此处填入短信标识');
            $form->listbox('face_ticket_field', '模板字段')->options(RecruitTicketField::ticketFieldData('face'))->attribute('hight', '200px')->help('仅纸质准考证需要，非ex开头的字段将自动渲染');
        })->tab('复试', function ($form) {
            $form->radio('reexamine_ticket_type', '准考证类型')->options([-1 => '不需要',1 => '纸质', 2 => '短信'])->default(-1);
            $form->text('reexamine_ticket_content', '准考证内容')->help('当类型为纸质时，此处填入准考证模板的路径，当类型为短信时，此处填入短信标识');
            $form->listbox('reexamine_field', '模板字段')->options(RecruitTicketField::ticketFieldData('reexamine'))->attribute('hight', '200px')->help('仅纸质准考证需要，非ex开头的字段将自动渲染');
        });

        return $form;
    }

    /**
     * Make a form builder.
     *
     * @return Form
     */
    public function store(Request $request)
    {
        $verify = $this->form()->getValidateInput();//这个方法会调用Form自带的验证和表单处理(文件上传等)验证错误会直接返回错误.不需要判断;
        $postCode = $request->input('postcode', []);
        $postName = $request->input('postname', []);
        if (count($postCode) == 0 or (count($postCode) >= 1 and $postCode[0] == null)) {
            return admin_toastr('请填写招考岗位', 'error');
        }
        if (count($postName) == 0 or (count($postName) >= 1 and $postName[0] == null)) {
            return admin_toastr('请填写招考岗位名称', 'error');
        }
        $data = [];
        $data['name'] = $verify['name'];
        $data['company'] = $verify['company'];
        $data['name_en'] = (array_key_exists('name_en',$verify) && !empty($verify['name_en'])) ? $verify['name_en'] : uniqid();
        if(array_key_exists('small_img',$verify)){
            $data['small_img'] = $verify['small_img'];
        }else{
            $data['small_img'] = theme_asset('app/images/index/recruit_index.jpg');
        }
        $data['status'] = $verify['status'];
        $data['current'] = $verify['current'];
        $data['step'] = implode(',',array_filter($verify['step']));
        $data['apply_start'] = $verify['apply_start'] ? $verify['apply_start'] : null;//报名时间
        $data['apply_end'] = $verify['apply_end'] ? $verify['apply_end'] : null;
        $data['audit_start'] = $verify['audit_start'] ? $verify['audit_start'] : null;//审核时间
        $data['audit_end'] = $verify['audit_end'] ? $verify['audit_end'] : null;
        $data['preliminary_start'] = $verify['preliminary_start'] ? $verify['preliminary_start'] : null;//笔试时间
        $data['preliminary_end'] = $verify['preliminary_end'] ? $verify['preliminary_end'] : null;
        $data['computer_start'] = $verify['computer_start'] ? $verify['computer_start'] : null;//上机时间
        $data['computer_end'] = $verify['computer_end'] ? $verify['computer_end'] : null;
        $data['interview_start'] = $verify['interview_start'] ? $verify['interview_start'] : null;//面试时间
        $data['interview_end'] = $verify['interview_end'] ? $verify['interview_end'] : null;
        $data['reexamine_start'] = $verify['reexamine_start'] ? $verify['reexamine_start'] : null;//复试时间
        $data['reexamine_end'] = $verify['reexamine_end'] ? $verify['reexamine_end'] : null;
        $data['health_start'] = $verify['health_start'] ? $verify['health_start'] : null;//体检时间
        $data['health_end'] = $verify['health_end'] ? $verify['health_end'] : null;
        $data['political_start'] = $verify['political_start'] ? $verify['political_start'] : null;//政审时间
        $data['political_end'] = $verify['political_end'] ? $verify['political_end'] : null;
        $data['publicity_start'] = $verify['publicity_start'] ? $verify['publicity_start'] : null;//公示时间
        $data['publicity_end'] = $verify['publicity_end'] ? $verify['publicity_end'] : null;
        $data['introduction'] = $verify['introduction'];
        $data['host_address'] = $verify['host_address'];
        $data['contact'] = $verify['contact'];
        $data['phone'] = $verify['phone'];
        $data['ordid'] = $verify['ordid'];
        $data['limit_times'] = $verify['limit_times'];
        $data['post_times'] = $verify['post_times'];
        $data['pay_switch'] = $verify['pay_switch'];
        $data['pen_ticket_type'] = $verify['pen_ticket_type'];
        $data['pen_ticket_content'] = $verify['pen_ticket_content'];
        $data['pen_ticket_status'] = 0;
        $data['computer_ticket_type'] = $verify['computer_ticket_type'];
        $data['computer_ticket_content'] = $verify['computer_ticket_content'];
        $data['computer_ticket_status'] = 0;
        $data['computer_ticket_field'] = implode(',',$verify['computer_ticket_field']);
        $data['face_ticket_type'] = $verify['face_ticket_type'];
        $data['face_ticket_content'] = $verify['face_ticket_content'];
        $data['face_ticket_status'] = 0;
        $data['face_ticket_field'] = implode(',',$verify['face_ticket_field']);

        $fileCharater = $request->input('addFile');
        DB::beginTransaction();//检查数据库事务
        try {
            $recruit = Recruit::create($data);
            $recruit_id = $recruit->id;

            //添加招聘岗位
            $postcode_array = $request->postcode;
            $postname_array = $request->postname;
            $postnumber_array = $request->postnumber;
            $limit_array = $request->postlimit;
            $countnum = count($postcode_array);
            for ($i = 0; $i < $countnum; $i++) {
                $data = array();
                if ($postcode_array[$i] !== '' and $postname_array[$i] !== '') {
                    $data['code'] = $postcode_array[$i];
                    $data['name'] = $postname_array[$i];
                    $data['number'] = $postnumber_array[$i];
                    $data['limit'] = $limit_array[$i];
                    $data['status'] = 1;
                    $data['recruit_id'] = $recruit_id;
                    RecruitPost::create($data);
                }
            }

            if (!empty($fileCharater)) {
                foreach ($fileCharater as $f => $fv) {
                    $picpath = 'recruit/' . date('Ymd', time()) . '/';
                    //获取文件的扩展名
                    $ext = $fv->getClientOriginalExtension();
                    //获取文件的绝对路径
                    $path = $fv->getRealPath();
                    //定义文件名
                    $filename = time() . rand(100, 999) . '.' . $ext;
                    //存储文件。disk里面的public。总的来说，就是调用disk模块里的public配置
                    Storage::disk('public')->put($picpath . $filename, file_get_contents($path));
                    $data = $picpath . $filename;
                    $create_arr = [
                        'recruit_id' => $recruit_id,
                        'subjoin_name' => $fv->getClientOriginalName(),
                        'subjoin_path' => $data,
                        'subjoin_addtime' => time()
                    ];
                    RecruitSubjoin::create($create_arr);
                }
            }
            DB::commit();//检查数据库事务
        } catch (\Exception $e) {
            DB::rollback();
            return admin_toastr($e->getMessage(), 'error');
        }

    }

    /**
     * 更新报名场次信息
     * @param $id
     * @param Request $request
     */
    public function update($id, Request $request)
    {
        $verify = $this->Form()->getValidateInput();//这个方法会调用Form自带的验证和表单处理(文件上传等)验证错误会直接返回错误.不需要判断;
        $postCode = $request->input('postcode', []);
        $postName = $request->input('postname', []);
        if (count($postCode) == 0 or (count($postCode) >= 1 and $postCode[0] == null)) {
            return admin_toastr('请填写招考岗位', 'error');
        }
        if (count($postName) == 0 or (count($postName) >= 1 and $postName[0] == null)) {
            return admin_toastr('请填写招考岗位名称', 'error');
        }
        $recruit_id = $id;
        $data = [];
        $data['name'] = $verify['name'];
        $data['company'] = $verify['company'];
        $data['name_en'] = (array_key_exists('name_en',$verify) && !empty($verify['name_en'])) ? $verify['name_en'] : uniqid();
        if(array_key_exists('small_img',$verify)){
            $data['small_img'] = $verify['small_img'];
        }else{
            $data['small_img'] = theme_asset('app/images/index/recruit_index.jpg');
        }
        $data['status'] = $verify['status'];
        $data['current'] = $verify['current'];
        $data['step'] = implode(',',array_filter($verify['step']));
        $data['apply_start'] = $verify['apply_start'] ? $verify['apply_start'] : null;//报名时间
        $data['apply_end'] = $verify['apply_end'] ? $verify['apply_end'] : null;
        $data['audit_start'] = $verify['audit_start'] ? $verify['audit_start'] : null;//审核时间
        $data['audit_end'] = $verify['audit_end'] ? $verify['audit_end'] : null;
        $data['preliminary_start'] = $verify['preliminary_start'] ? $verify['preliminary_start'] : null;//笔试时间
        $data['preliminary_end'] = $verify['preliminary_end'] ? $verify['preliminary_end'] : null;
        $data['computer_start'] = $verify['computer_start'] ? $verify['computer_start'] : null;//上机时间
        $data['computer_end'] = $verify['computer_end'] ? $verify['computer_end'] : null;
        $data['interview_start'] = $verify['interview_start'] ? $verify['interview_start'] : null;//面试时间
        $data['interview_end'] = $verify['interview_end'] ? $verify['interview_end'] : null;
        $data['reexamine_start'] = $verify['reexamine_start'] ? $verify['reexamine_start'] : null;//复试时间
        $data['reexamine_end'] = $verify['reexamine_end'] ? $verify['reexamine_end'] : null;
        $data['health_start'] = $verify['health_start'] ? $verify['health_start'] : null;//体检时间
        $data['health_end'] = $verify['health_end'] ? $verify['health_end'] : null;
        $data['political_start'] = $verify['political_start'] ? $verify['political_start'] : null;//政审时间
        $data['political_end'] = $verify['political_end'] ? $verify['political_end'] : null;
        $data['publicity_start'] = $verify['publicity_start'] ? $verify['publicity_start'] : null;//公示时间
        $data['publicity_end'] = $verify['publicity_end'] ? $verify['publicity_end'] : null;
        $data['introduction'] = $verify['introduction'];
        $data['host_address'] = $verify['host_address'];
        $data['contact'] = $verify['contact'];
        $data['phone'] = $verify['phone'];
        $data['ordid'] = $verify['ordid'];
        $data['limit_times'] = $verify['limit_times'];
        $data['post_times'] = $verify['post_times'];
        $data['pay_switch'] = $verify['pay_switch'];
        $data['forms'] = implode(',',array_filter($verify['forms']));
        $data['pen_ticket_type'] = $verify['pen_ticket_type'];
        $data['pen_ticket_content'] = $verify['pen_ticket_content'];
        $data['pen_ticket_status'] = 0;
        $data['pen_ticket_field'] = implode(',',$verify['pen_ticket_field']);
        $data['computer_ticket_type'] = $verify['computer_ticket_type'];
        $data['computer_ticket_content'] = $verify['computer_ticket_content'];
        $data['computer_ticket_status'] = 0;
        $data['computer_ticket_field'] = implode(',',$verify['computer_ticket_field']);
        $data['face_ticket_type'] = $verify['face_ticket_type'];
        $data['face_ticket_content'] = $verify['face_ticket_content'];
        $data['face_ticket_status'] = 0;
        $data['face_ticket_field'] = implode(',',$verify['face_ticket_field']);
        $ids = RecruitPost::where('recruit_id', $recruit_id)->pluck('id');
        $fileCharater = $request->input('addFile');
        DB::beginTransaction();//检查数据库事务
        try {
            Recruit::where('id', $recruit_id)->update($data);
            $postcode_array = $request->postcode;
            $postname_array = $request->postname;
            $postnumber_array = $request->postnumber;
            $limit_array = $request->postlimit;
            $postid_arr = $request->postid_arr;
            $countnum = count($postcode_array);
            if ($countnum > 0) {
                $ids = RecruitPost::where('recruit_id', $recruit_id)->pluck('id');
                if (count($postid_arr) == 0) {//没有提交岗位代表删除岗位
                    RecruitPost::where('recruit_id', $recruit_id)->delete();
                } else {
                    foreach ($ids as $key => $value) {
                        if (!in_array($value, $postid_arr)) {
                            $post_is_create = RecruitAppointInfo::where('post_id', $value)->first();
                            if (empty($post_is_create)) {
                                //有报名信息的岗位不能删除
                                RecruitPost::destroy($value);
                            }
                        }
                    }
                }
                for ($i = 0; $i < $countnum; $i++) {
                    $data = array();
                    if ($postcode_array[$i] !== '' and $postname_array[$i] !== '') {
                        if (isset($postid_arr[$i])) {
                            $post_id = $postid_arr[$i];
                            $data['code'] = $postcode_array[$i];
                            $data['name'] = $postname_array[$i];
                            $data['number'] = $postnumber_array[$i];
                            $data['limit'] = $limit_array[$i];
                            $data['recruit_id'] = $recruit_id;
                            RecruitPost::where('id', $post_id)->update($data);
                        } else {
                            $data['code'] = $postcode_array[$i];
                            $data['name'] = $postname_array[$i];
                            $data['number'] = $postnumber_array[$i];
                            $data['limit'] = $limit_array[$i];
                            $data['recruit_id'] = $recruit_id;
                            RecruitPost::create($data);
                        }
                    }
                }
            } else {
                RecruitPost::where('recruit_id', $recruit_id)->delete();
            }
            $fileCharater = $request->file('addFile');
            if (!empty($fileCharater)) {
                RecruitSubjoin::where('recruit_id', $recruit_id)->delete();
                foreach ($fileCharater as $f => $fv) {
                    $picpath = 'zhaokaopic/' . date('Ymd', time()) . '/';
                    //获取文件的扩展名
                    $ext = $fv->getClientOriginalExtension();
                    //获取文件的绝对路径
                    $path = $fv->getRealPath();
                    //定义文件名
                    $filename = time() . rand(100, 999) . '.' . $ext;
                    //存储文件。disk里面的public。总的来说，就是调用disk模块里的public配置
                    Storage::disk('public')->put($picpath . $filename, file_get_contents($path));
                    $data = $picpath . $filename;
                    $create_arr = [
                        'recruit_id' => $recruit_id,
                        'subjoin_name' => $fv->getClientOriginalName(),
                        'subjoin_path' => $data,
                        'subjoin_addtime' => time()
                    ];
                    RecruitSubjoin::create($create_arr);
                }
            }
            DB::commit();
            return admin_toastr('操作成功!', 'success');

        } catch (\Exception $e) {
            DB::rollback();
            return admin_toastr($e->getMessage(), 'error');
        }
    }

    /**
     * 删掉指定招考场次
     * @param $id
     */
    public function destroy($id)
    {
        Permission::check('recruit_manager_del');
        $info = Recruit::find($id);
        if($info){
            if($info->delete()){
                //RecruitAppointInfo::where('recruit_id', $id)->delete();  //todo保留
                return response()->json(['status' => 1, 'message' => '删除成功！'], '200');
            }else{
                return response()->json(['status' => 0, 'message' => '删除失败！'], '200');
            }
        }else{
            return response()->json(['status' => 0, 'message' => '找不到记录！'], '200');
        }
        //Recruit::find($id)->delete();


    }

    /**
     * 报名管理
     * @param Content $content
     * @param Request $request
     * @return Content|\Illuminate\Http\RedirectResponse
     */
    public function appointList(Content $content, Request $request)
    {
        Permission::check('recruit_appoint_list');
        $id = $request->id;
        $recruit = Recruit::find($id);
        if (empty($recruit)) {
            return back();
        }

        $search_data = $request->all();
        $where = [];
        $where[] = ['audit','>',0];
        if (isset($search_data['id']) || session('manage_search_data')['id']) {
            if (isset($search_data['page'])) {
                if (session('search_data')) {
                    $where = session('managewhere');
                    unset($search_data['page']);
                    $search_data = session('manage_search_data');

                }
            }
            foreach ($search_data as $k => $v) {

                if ($k == 'realname') {
                    $where[] = [$k, 'like', "%$v%"];
                } elseif ($k == 'id') {
                    $where[] = ['recruit_appoint_info.recruit_id', '=', $v];
                } elseif($k == 'print_bs'){
                    $where[] = ['recruit_ticket.ex_type', '=', 1];
                    $where[] = ['recruit_ticket.ex_status', '=', $v];
                } elseif($k == 'print_js'){
                    $where[] = ['recruit_ticket.ex_type', '=', 2];
                    $where[] = ['recruit_ticket.ex_status', '=', $v];
                } elseif($k == 'print_ms'){
                    $where[] = ['recruit_ticket.ex_type', '=', 3];
                    $where[] = ['recruit_ticket.ex_status', '=', $v];
                } elseif ($k != '_pjax' and $k != 'page' && $k != 'perpage') {
                    $where[] = [$k, '=', $v];
                }
            }
            session(['managewhere' => $where]);
            session(['manage_search_data' => $search_data]);
            session()->save();
        }

        $session_data = session('search_data');
        if(isset($session_data['perpage'])){
            $perpage = $session_data['perpage'];
        }else{
            $perpage = 20;
        }

        $list = RecruitAppointInfo::where($where)
            ->join('recruit_post', 'recruit_appoint_info.post_id', '=', 'recruit_post.id', 'left')
            ->join('recruit_ticket', 'recruit_ticket.appoint_id', '=', 'recruit_appoint_info.id','left')
            ->select('recruit_appoint_info.*', 'recruit_post.code', 'recruit_post.name')
            ->orderBy('recruit_appoint_info.updated_at','desc')
            ->paginate($perpage);

        foreach ($list as $k => $v){
            if($v->sex == 0){
                $list[$k]['sex'] = '女';
            }else{
                $list[$k]['sex'] = '男';
            }
            switch ($v->political_affiliation){
                case '01':
                    $list[$k]['political_affiliation'] = '中共党员';
                    break;
                case '02':
                    $list[$k]['political_affiliation'] = '中共预备党员';
                    break;
                case '03':
                    $list[$k]['political_affiliation'] = '共青团员';
                    break;
                case '04':
                    $list[$k]['political_affiliation'] = '民革党员';
                    break;
                case '05':
                    $list[$k]['political_affiliation'] = '民盟盟员';
                    break;
                case '06':
                    $list[$k]['political_affiliation'] = '民建会员';
                    break;
                case '07':
                    $list[$k]['political_affiliation'] = '民进会员';
                    break;
                case '08':
                    $list[$k]['political_affiliation'] = '农工党党员';
                    break;
                case '09':
                    $list[$k]['political_affiliation'] = '致公党党员';
                    break;
                case '10':
                    $list[$k]['political_affiliation'] = '九三学社社员';
                    break;
                case '11':
                    $list[$k]['political_affiliation'] = '台盟盟员';
                    break;
                case '12':
                    $list[$k]['political_affiliation'] = '无党派人士';
                    break;
                case '13':
                    $list[$k]['political_affiliation'] = '群众';
                    break;
            }
            $list[$k]['pen_print'] = 0;
            $list[$k]['computer_print'] = 0;
            $list[$k]['face_print'] = 0;
            $list[$k]['reexamine_print'] = 0;
            $tickets = RecruitTicket::where('appoint_id',$v->id)->get();
            if($tickets){
                foreach ($tickets as $tk => $tv){
                    if($tv->ex_type == 1){
                        $list[$k]['pen_print'] = $tv->ex_status;
                    }
                    if($tv->ex_type == 2){
                        $list[$k]['computer_print'] = $tv->ex_status;
                    }
                    if($tv->ex_type == 3){
                        $list[$k]['face_print'] = $tv->ex_status;
                    }
                    if($tv->ex_type == 4){
                        $list[$k]['reexamine_print'] = $tv->ex_status;
                    }
                }
            }
        }

        $post_data = RecruitPost::where('recruit_id',$id)->where('status',1)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');

        return $content
            ->header('报名管理')
            ->description('招考人员信息列表')
            ->body(view('admin.recruit.appoint_list')->with([
                'list' => $list,
                'search_data' => $search_data,
                'recruit' => $recruit,
                'post' => $post_data
            ]));
    }

    /**
     * 查看报名详细信息
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     * @throws \Throwable
     */
    public function getUserinfo(Request $request)
    {
        Permission::check('recruit_getUserinfo');
        $id = $request->id;
        $data = RecruitAppointInfo::where('recruit_appoint_info.id',$id)
                ->join('recruit_post', 'recruit_appoint_info.post_id', '=', 'recruit_post.id', 'left')
                ->join('recruit_appoint_expand_special', 'recruit_appoint_info.id', '=', 'recruit_appoint_expand_special.recruit_appoint_id', 'left')
                ->join('recruit_appoint_detail', 'recruit_appoint_detail.recruit_appoint_id', '=', 'recruit_appoint_info.id', 'left')
                ->select('recruit_appoint_info.*', 'recruit_post.name', 'recruit_post.code', 'recruit_appoint_detail.train', 'recruit_appoint_detail.rewards_and_punishments', 'recruit_appoint_detail.introduce', 'recruit_appoint_expand_special.point_apply', 'recruit_appoint_expand_special.condition', 'recruit_appoint_expand_special.material')
                ->first();
        $recruit = Recruit::where('id',$data->recruit_id)->first();
        $recruit->forms = explode(',', $recruit->forms);
        $data->family = json_decode($data->family);
        if ($data->family) {
            foreach ($data->family as $k => $v) {
                $v->political_affiliation = RecruitAppointInfo::$political_affiliation[$v->political_affiliation];
            }
        }

        //layer相册层
        $photos = [
            'material'=>[],
            'identification'=>[],
            'education_certification'=>[],
            'other_certification'=>[],
        ];

        if(in_array('expand_special',$recruit->forms)){
            if(json_decode($data->material)){
                $data->material = json_decode($data->material);
                $photo_data = [];
                foreach ($data->material as $k => $v) {
                    $photo_data[] = [
                        'alt' => $v->name,
                        'pid' => $v->uid,
                        'src' => $v->response->path,
                    ];
                }
                $photos['material'] = [
                    'title' => '申请加分佐证材料',
                    'id' => 1,
                    'start' => 0,
                    'data' =>$photo_data
                ];
            }else{
                $data->material = [];
            }
        }
        if(in_array('identification',$recruit->forms)){
            if(json_decode($data->identification)){
                $data->identification = json_decode($data->identification);
                $photo_data = [];
                foreach ($data->identification as $k => $v) {
                    $photo_data[] = [
                        'alt' => $v->name,
                        'pid' => $v->uid,
                        'src' => $v->response->path,
                    ];
                }
                $photos['identification'] = [
                    'title' => '身份证明',
                    'id' => 1,
                    'start' => 0,
                    'data' =>$photo_data
                ];
            }else{
                $data->identification = [];
            }
        }
        if(in_array('education_certification',$recruit->forms)){
            if(json_decode($data->education_certification)){
                $data->education_certification = json_decode($data->education_certification);
                $photo_data = [];
                foreach ($data->education_certification as $k => $v) {
                    $photo_data[] = [
                        'alt' => $v->name,
                        'pid' => $v->uid,
                        'src' => $v->response->path,
                    ];
                }
                $photos['education_certification'] = [
                    'title' => '学历证明',
                    'id' => 1,
                    'start' => 0,
                    'data' =>$photo_data
                ];
            }else{
                $data->education_certification = [];
            }
        }
        if(in_array('other_certification',$recruit->forms)){
            if(json_decode($data->other_certification)){
                $data->other_certification = json_decode($data->other_certification);
                $photo_data = [];
                foreach ($data->other_certification as $k => $v) {
                    $photo_data[] = [
                        'alt' => $v->name,
                        'pid' => $v->uid,
                        'src' => $v->response->path,
                    ];
                }
                $photos['other_certification'] = [
                    'title' => '其他证明',
                    'id' => 1,
                    'start' => 0,
                    'data' =>$photo_data
                ];
            }else{
                $data->other_certification = [];
            }
        }

        $html = view('admin.recruit.manageajax_userinfo')->with(['appointinfo' => $data,'recruit' => $recruit,'photos'=>$photos])->render();
        return response()->json(['code' => 1, 'data' => $html]);
    }

    /**
     * 第一阶段（报名审核）
     * @param Request $request
     * @return \Illuminate\Contracts\Routing\ResponseFactory|\Illuminate\Http\Response|mixed|\Psr\Container\ContainerInterface|\Symfony\Component\HttpFoundation\Response|\think\Response
     * @throws \Throwable
     */
    public function ajax_audit(Request $request)
    {
        Permission::check('recruit_ajax_audit');
        $ids = $request->ids;
        $view_data['ids'] = $ids;
        return response(['data' => view('admin.recruit.ajax_audit')->with($view_data)->render(), 'status' => 1], '200');
    }

    /**
     * 报名记录审核处理
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function appoint_audit(Request $request)
    {
        $ids = $request->ids;
        if (!is_array($ids)) {
            $ids = explode(",", $ids);
        }
        if (empty($ids)) {
            return response()->json(['status' => 0, 'msg' => '请选择审核记录！'], '200');
        }
        $audit = $request->audit;
        $exam_flow_path = $request->exam_flow_path;
        $reason = $request->reason;
        if(empty($audit)){
            return response()->json(['status' => 0, 'msg' => '请选择审核状态！'], '200');
        }
        if($audit == '3' && empty($exam_flow_path)){
            return response()->json(['status' => 0, 'msg' => '请选择审核后的考试流程！'], '200');
        }
        if($audit != '3' && empty($reason)){
            return response()->json(['status' => 0, 'msg' => '请输入审核原因！'], '200');
        }
        $message = [];
        switch ($audit){
            case '1':
                //撤回至未审核
                foreach ($ids as $k => $v){
                    $appointinfo = RecruitAppointInfo::where('id', $v)->first();
                    if(!$appointinfo || intval($appointinfo->audit) === 1){
                        continue;
                    }
                    //设置该报名的各个状态
                    $appointinfo_data = [
                        'current' => 1,
                        'audit' =>  1,
                        'pen_audit' => -1,
                        'computer_audit' => -1,
                        'face_audit' => -1,
                        'reexamine_audit' => -1,
                        'inspect_audit' => -1,
                        'political_audit' => -1,
                        'employ_audit' => -1
                    ];
                    RecruitAppointInfo::where('id', $v)->update($appointinfo_data);
                    //写日志
                    $log = [
                        'type'  =>  2,
                        'step' => 1,
                        'appoint_id' => $v,
                        'uid' => Admin::user()->id,
                        'log' => '撤回至未审核状态，原因是：'.$reason
                    ];
                    RecruitAppointLog::create($log);
                    $message[$v] = '您此次的报名需要重新审核，原因是：'.$reason;
                }
                break;
            case '2':
                //审核未通过
                foreach ($ids as $k => $v){
                    $appointinfo = RecruitAppointInfo::where('id', $v)->first();
                    if(!$appointinfo || intval($appointinfo->audit) === 2){
                        continue;
                    }
                    //设置该报名的各个状态
                    $appointinfo_data = [
                        'current' => 1,
                        'audit' =>  2,
                        'pen_audit' => -1,
                        'computer_audit' => -1,
                        'face_audit' => -1,
                        'reexamine_audit' => -1,
                        'inspect_audit' => -1,
                        'political_audit' => -1,
                        'employ_audit' => -1
                    ];
                    RecruitAppointInfo::where('id', $v)->update($appointinfo_data);
                    //写日志
                    $log = [
                        'type'  =>  2,
                        'step' => 1,
                        'appoint_id' => $v,
                        'uid' => Admin::user()->id,
                        'log' => '审核未通过，原因是：'.$reason
                    ];
                    RecruitAppointLog::create($log);
                    $message[$v] = '您此次报名审核未通过，原因是：'.$reason;
                    $this->smsService->sendSms($appointinfo->mobile,'sms_recruit_register_error',array('reason'=>$reason));
                }
                break;
            case '3':
                //审核通过
                foreach ($ids as $k => $v){
                    $appointinfo = RecruitAppointInfo::where('id', $v)->first();
                    if(!$appointinfo || intval($appointinfo->audit) === 3){
                        continue;
                    }
                    $recruit = Recruit::where('id',$appointinfo->recruit_id)->first();
                    $step = explode(',',$recruit->step);
                    $step_str = [
                        'pen' => '未设置此条报名记录的笔试信息',
                    ];
                    if(in_array('3',$step)){
                        //场次有设置笔试
                        if(in_array('pen',$exam_flow_path)){
                            $step_str['pen'] = '该场次需要笔试，已设置此条报考需要参与笔试';
                            $pen_audit = -1;
                        }else{
                            $step_str['pen'] = '该场次需要笔试，此条报考可跳过笔试';
                            $pen_audit = 3;
                        }
                    }else{
                        $step_str['pen'] = '该场次不需要笔试';
                        $pen_audit = 3;
                    }
                    if(in_array('4',$step)){
                        //场次有设置上机
                        if(in_array('computer',$exam_flow_path)){
                            $step_str['computer'] = '该场次需要上机，已设置此条报考需要参与上机';
                            $computer_audit = -1;
                        }else{
                            $step_str['computer'] = '该场次需要上机，此条报考可跳过上机';
                            $computer_audit = 3;
                        }
                    }else{
                        $step_str['computer'] = '该场次不需要上机';
                        $computer_audit = 3;
                    }
                    if(in_array('5',$step)){
                        //场次有设置上机
                        if(in_array('face',$exam_flow_path)){
                            $step_str['face'] = '该场次需要面试，已设置此条报考需要参与面试';
                            $face_audit = -1;
                        }else{
                            $step_str['face'] = '该场次需要面试，此条报考可跳过面试';
                            $face_audit = 3;
                        }
                    }else{
                        $step_str['face'] = '该场次不需要面试';
                        $face_audit = 3;
                    }
                    if(in_array('6',$step)){
                        //场次有设置复试
                        if(in_array('reexamine',$exam_flow_path)){
                            $step_str['reexamine'] = '该场次需要复试，已设置此条报考需要参与复试';
                            $reexamine_audit = -1;
                        }else{
                            $step_str['reexamine'] = '该场次需要复试，此条报考可跳过复试';
                            $reexamine_audit = 3;
                        }
                    }else{
                        $step_str['reexamine'] = '该场次不需要复试';
                        $reexamine_audit = 3;
                    }
                    //设置该报名的各个状态
                    $appointinfo_data = [
                        'current' => 2,//审核成功后进入考试流程
                        'audit' =>  3,
                        'pen_audit' => $pen_audit,
                        'computer_audit' => $computer_audit,
                        'face_audit' => $face_audit,
                        'reexamine_audit' => $reexamine_audit,
                        'inspect_audit' => -1,
                        'political_audit' => -1,
                        'employ_audit' => -1
                    ];
                    RecruitAppointInfo::where('id', $v)->update($appointinfo_data);
                    $reason = $reason ?? '符合报考条件';
                    //写日志
                    $log = [
                        'type'  =>  2,
                        'step' => 1,
                        'appoint_id' => $v,
                        'uid' => Admin::user()->id,
                        'log' => '审核通过，原因是：' . $reason,
                        'admin_log' => implode('；',$step_str)
                    ];
                    RecruitAppointLog::create($log);
                    $message[$v] = '您此次报名审核已通过，原因是：' . $reason;
                    $this->smsService->sendSms($appointinfo->mobile,'sms_recruit_register_success',array('reason'=>$reason));
                    $this->fetch_word(['recruit_id'=>$appointinfo->recruit_id,'appoint_id'=>$appointinfo->id]);
                }
                break;
        }

        //站内信
        foreach ($ids as $key => $val) {
            if(array_key_exists($val,$message)){
                $user_info = Member::where('id', $appointinfo->uid)->first();
                Pms::write_pmsnotice($user_info->id, $user_info->username, $message[$val]);
            }else{
                continue;
            }
        }
        return response()->json(['status' => 1, 'msg' => '操作成功！', 'data' => 'ok']);
    }

    public function fetchWord(Request $request)
    {
        $recruit_id = $request->recruit_id;
        $appoint_id = $request->appoint_id;
        if(!empty($recruit_id) && !empty($appoint_id)){

            $this->fetch_word(['recruit_id'=>$recruit_id,'appoint_id'=>$appoint_id]);
            return response()->json(['status' => 1, 'msg' => '生成Word简历成功！', 'data' => 'ok']);
        }else{
            return response()->json(['status' => 0, 'msg' => '参数缺失！', 'data' => 'fail']);
        }
    }

    /**
     * 查看审核日志
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function showLog(Request $request)
    {
        Permission::check('recruit_show_log');
        $id = $request->id;
        $logs = RecruitAppointLog::where('appoint_id', $id)->orderBy('created_at', 'desc')->get()->toArray();
        $str = "";
        if ($logs) {
            $str .= "<table class='table'><tr style='background:#F0F8FD'><td>审核时间</td><td>操作级别</td><td>记录类型</td><td>触发操作的人员</td><td>审核描述</td></tr>";
            foreach ($logs as $k => $v) {
                switch ($v['type']){
                    case '1':
                        $level = '系统级操作';
                        $user = '系统';
                        break;
                    case '2':
                        $level = '审核系列操作';
                        $admin = AdminUser::where('id',$v['uid'])->first();
                        $user = $admin->name;
                        break;
                    case '3':
                        $level = '用户自行操作';
                        $member = Member::where('id',$v['uid'])->first();
                        $user = $member->username;
                        break;
                }
                switch ($v['step']){
                    case '1':
                        $step = '报名及审核';
                        break;
                    case '2':
                        $step = '笔试';
                        break;
                    case '3':
                        $step = '面试';
                        break;
                    case '4':
                        $step = '上机';
                        break;
                    case '5':
                        $step = '复审';
                        break;
                    case '6':
                        $step = '体检';
                        break;
                    case '7':
                        $step = '政审';
                        break;
                    case '8':
                        $step = '录用';
                        break;
                }
                $str .= "<tr><td>" . $v['created_at'] . "</td><td>" . $level . "</td><td>" . $step . "</td><td>" . $user . "</td><td>" . $v['log'] . "</td></tr>\r\n";
            }
            $str .= "</table>";
        } else {
            $str = "抱歉，暂未有审核记录";
        }
        return response()->json(['code' => 1, 'data' => $str]);
    }

    /**
     * 生成word版简历
     * @param null $data
     * @throws \PhpOffice\PhpWord\Exception\CopyFileException
     * @throws \PhpOffice\PhpWord\Exception\CreateTemporaryFileException
     * @throws \PhpOffice\PhpWord\Exception\Exception
     */
    public function fetch_word($data = null)
    {
        if($data != null && array_key_exists('recruit_id',$data) && array_key_exists('appoint_id',$data)){
            $recruit = Recruit::where('id',$data['recruit_id'])->first();
            $appoint = RecruitAppointInfo::where('id',$data['appoint_id'])->first();

            $templateProcessor = new TemplateProcessor(base_path() . '/public/word/example.docx');
            //通过setValue 方法给模板赋值
            $templateProcessor->setValue('title', $recruit->name);
            $templateProcessor->setValue('realname', $appoint->realname);
            $templateProcessor->setValue('realname', $appoint->realname);
            $templateProcessor->setValue('sex', $appoint->sex == 0 ? '女' : '男');
            $templateProcessor->setValue('birthday', $appoint->birthday);
            $templateProcessor->setValue('nation', $appoint->nation);
            $templateProcessor->setValue('native_place', $appoint->native_place);
            $templateProcessor->setValue('card', $appoint->card);
            switch ($appoint->political_affiliation){
                case '01':
                    $templateProcessor->setValue('political_affiliation', '中共党员');
                    break;
                case '02':
                    $templateProcessor->setValue('political_affiliation', '中共预备党员');
                    break;
                case '03':
                    $templateProcessor->setValue('political_affiliation', '共青团员');
                    break;
                case '04':
                    $templateProcessor->setValue('political_affiliation', '民革党员');
                    break;
                case '05':
                    $templateProcessor->setValue('political_affiliation', '民盟盟员');
                    break;
                case '06':
                    $templateProcessor->setValue('political_affiliation', '民建会员');
                    break;
                case '07':
                    $templateProcessor->setValue('political_affiliation', '民进会员');
                    break;
                case '08':
                    $templateProcessor->setValue('political_affiliation', '农工党党员');
                    break;
                case '09':
                    $templateProcessor->setValue('political_affiliation', '致公党党员');
                    break;
                case '10':
                    $templateProcessor->setValue('political_affiliation', '九三学社社员');
                    break;
                case '11':
                    $templateProcessor->setValue('political_affiliation', '台盟盟员');
                    break;
                case '12':
                    $templateProcessor->setValue('political_affiliation', '无党派人士');
                    break;
                case '13':
                    $templateProcessor->setValue('political_affiliation', '群众');
            }
            $templateProcessor->setValue('join_time', $appoint->join_time);
            $templateProcessor->setValue('house_register', $appoint->house_register);
            switch ($appoint->edu_type){
                case '1':
                    $templateProcessor->setValue('edu_type', '全日制');
                    break;
                case '2':
                    $templateProcessor->setValue('edu_type', '在职教育');
                    break;
            }
            $templateProcessor->setValue('education', $appoint->education);
            $templateProcessor->setValue('school', $appoint->school);
            $templateProcessor->setValue('degree', $appoint->degree);
            $templateProcessor->setValue('pro', $appoint->pro);
            $templateProcessor->setValue('mobile', $appoint->mobile);
            $templateProcessor->setValue('email', $appoint->email);
            $templateProcessor->setValue('address', $appoint->address);
            $post_data = RecruitPost::where('id',$appoint->post_id)->first();
            $templateProcessor->setValue('post', $post_data->code . " " . $post_data->name);
            $templateProcessor->setValue('work',  $appoint->work);
            $templateProcessor->setValue('titles',  $appoint->titles);
            $templateProcessor->setValue('concat_name',  $appoint->concat_name);
            $templateProcessor->setValue('concat_mobile',  $appoint->concat_mobile);
            $forms = explode(',', $recruit->forms);
            if(in_array('expand_special',$forms)){
                $special = RecruitAppointExpandSpecial::where('recruit_appoint_id',$appoint->id)->first();
                $templateProcessor->cloneBlock('special_block',1);
                $templateProcessor->setValue('point_apply', $special->point_apply == 0 ? '否' : '是');
                $templateProcessor->setValue('condition', $special->condition);
                if($material = json_decode($special->material)){
                    foreach ($material as $k => $v){
                        $templateProcessor->setImageValue('material#'.($k+1),['src' => 'https://www.jucai.gov.cn/'.$v->url]);
                    }
                }
            }else{
                $templateProcessor->cloneBlock('special_block',0);
            }
            $templateProcessor->setValue('resume',  str_replace("\n",'<w:br/>',$appoint->resume));
            if(in_array('detail',$forms)){
                $detail = RecruitAppointDetail::where('recruit_appoint_id',$appoint->id)->first();
                $templateProcessor->cloneBlock('detail_block',1);
                $templateProcessor->setValue('train',  str_replace("\n",'<w:br/>',$detail->train));
                $templateProcessor->setValue('rewards_and_punishments',  str_replace("\n",'<w:br/>',$detail->rewards_and_punishments));
                $templateProcessor->setValue('introduce',  str_replace("\n",'<w:br/>',$detail->introduce));
            }else{
                $templateProcessor->cloneBlock('detail_block',0);
            }
            if($family = json_decode($appoint->family,true)){
                $templateProcessor->cloneRow('family_relation',count($family));
                $i = 1;
                foreach ($family as $k => $v){
                    $templateProcessor->setValue('family_relation#'.$i, $v['relation']);
                    $templateProcessor->setValue('family_realname#'.$i, $v['realname']);
                    $templateProcessor->setValue('family_birthday#'.$i, $v['birthday']);
                    switch ($v['political_affiliation']){
                        case '01':
                            $political_affiliation = '中共党员';
                            break;
                        case '02':
                            $political_affiliation = '中共预备党员';
                            break;
                        case '03':
                            $political_affiliation = '共青团员';
                            break;
                        case '04':
                            $political_affiliation = '民革党员';
                            break;
                        case '05':
                            $political_affiliation = '民盟盟员';
                            break;
                        case '06':
                            $political_affiliation = '民建会员';
                            break;
                        case '07':
                            $political_affiliation = '民进会员';
                            break;
                        case '08':
                            $political_affiliation = '农工党党员';
                            break;
                        case '09':
                            $political_affiliation = '致公党党员';
                            break;
                        case '10':
                            $political_affiliation = '九三学社社员';
                            break;
                        case '11':
                            $political_affiliation = '台盟盟员';
                            break;
                        case '12':
                            $political_affiliation = '无党派人士';
                            break;
                        case '13':
                            $political_affiliation = '群众';
                    }
                    $templateProcessor->setValue('family_political_affiliation#'.$i, $political_affiliation);
                    $templateProcessor->setValue('family_work#'.$i, $v['work']);
                    $i++;
                }
            }
            $templateProcessor->setImageValue('avatar',['path' => 'http://www.jucai.gov.cn/'.$appoint->avatar, 'width' => 200, 'height' => 150]);

            $filename = $appoint->realname . '_' . $appoint->card.'_' . $post_data->code . $post_data->name;

            if(!is_dir(base_path() . "/storage/app/public/recruit/word/" . $recruit->name_en)){
                Storage::makeDirectory("public/recruit/word/{$recruit->name_en}");
            }

            $word_url = "/{$filename}.docx";
            $appoint->word_url = "/storage/recruit/word/" . $recruit->name_en .$word_url;
            $appoint->save();
            $templateProcessor->saveAs(base_path() . "/storage/app/public/recruit/word/" . $recruit->name_en . $word_url);//另存为
        }
    }

    /**
     * 将报名资料导出成ZIP压缩包
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     * @throws \Exception
     */
    public function out_zip(Request $request)
    {//TODO 数据太大，无法压缩，得做成异步
        Permission::check('recruit_out_excel');
        $recruit_id = $request->id;
        $recruit = Recruit::find($recruit_id);
        if (empty($recruit)) {
            return response()->json(['status' => 0, 'msg' => '找不到对应的招考场次'], 200);
        }

        $data = $request->all();
        $where = [];
        $where[] = ['audit','>',0];
        $where[] = ['recruit_appoint_info.recruit_id', '=', $data['id']];
        $param = parse_url($data['where']);
        parse_str($param['query'],$param);
        if (is_array($param)) {
            unset($param['id']);
            foreach ($param as $k => $v) {
                if ($k == 'realname') {
                    $where[] = [$k, 'like', "%$v%"];
                } elseif ($k != '_pjax' and $k != 'page' && $k != 'perpage') {
                    $where[] = [$k, '=', $v];
                }
            }
        }
        $select = ['recruit_appoint_info.*', 'recruit_post.code', 'recruit_post.name'];
        $model = RecruitAppointInfo::where($where)->join('recruit_post', 'recruit_appoint_info.post_id', '=', 'recruit_post.id', 'left');
        if(in_array('expand_special',explode(',', $recruit->forms))){
            $model->join('recruit_appoint_expand_special', 'recruit_appoint_expand_special.recruit_appoint_id', '=', 'recruit_appoint_info.id', 'left');
            $special_select = ['recruit_appoint_expand_special.point_apply','recruit_appoint_expand_special.condition','recruit_appoint_expand_special.material'];
            $select = array_merge($select,$special_select);
        }
        if(in_array('detail',explode(',', $recruit->forms))){
            $model->join('recruit_appoint_detail', 'recruit_appoint_detail.recruit_appoint_id', '=', 'recruit_appoint_info.id', 'left');
            $detail_select = ['recruit_appoint_detail.train','recruit_appoint_detail.rewards_and_punishments','recruit_appoint_detail.introduce'];
            $select = array_merge($select,$detail_select);
        }

        $list = $model->select($select)
            ->orderBy('recruit_appoint_info.updated_at','desc')
            ->get();

        if(!is_dir(base_path() . "/storage/app/public/recruit/zip")){
            Storage::makeDirectory("public/recruit/zip");
        }

        if (file_exists(base_path() . '/storage/app/public/recruit/zip/' . $recruit->company . '.zip')) {
            unlink(base_path() . '/storage/app/public/recruit/zip/' . $recruit->company . '.zip');
        }

        if($list){
//            foreach ($list as $key => $value){
//                $path = base_path() . "/storage/app/public/recruit/zip/{$recruit->company}/{$value->realname}_{$value->card}/";
//                if(!is_dir($path)){
//                    Storage::makeDirectory("public/recruit/zip/{$recruit->company}/{$value->realname}_{$value->card}");
//                }
//                if(in_array('expand_special',explode(',', $recruit->forms))){
//                    $special = RecruitAppointExpandSpecial::where('recruit_appoint_id',$value->id)->first();
//                    $material = json_decode($special['material'],true);
//                    if($material){
//                        foreach ($material as $k => $v){
//                            $old_path = base_path() . "/public/" . $v['url'];
//                            if (file_exists($old_path)) {
//                                $basename = basename($old_path);
//                                $new_path = $path . $basename; //iconv("UTF-8", "GBK", $p->picture_name);
//                                copy($old_path, $new_path); //拷贝到新目录
//                            }
//                        }
//                    }
//                }
//                if(in_array('identification',explode(',', $recruit->forms))){
//                    $identification = json_decode($value->identification,true);
//                    if($identification){
//                        foreach ($identification as $k => $v){
//                            $old_path = base_path() . "/public/"  . $v['url'];
//                            if (file_exists($old_path)) {
//                                $basename = basename($old_path);
//                                $new_path = $path . $basename; //iconv("UTF-8", "GBK", $p->picture_name);
//                                copy($old_path, $new_path); //拷贝到新目录
//                            }
//                        }
//                    }
//                }
//                if(in_array('education_certification',explode(',', $recruit->forms))){
//                    $education_certification = json_decode($value->education_certification,true);
//                    if($education_certification){
//                        foreach ($education_certification as $k => $v){
//                            $old_path = base_path() . "/public/"  . $v['url'];
//                            if (file_exists($old_path)) {
//                                $basename = basename($old_path);
//                                $new_path = $path . $basename; //iconv("UTF-8", "GBK", $p->picture_name);
//                                copy($old_path, $new_path); //拷贝到新目录
//                            }
//                        }
//                    }
//                }
//                if(in_array('other_certification',explode(',', $recruit->forms))){
//                    $other_certification = json_decode($value->other_certification,true);
//                    if($other_certification){
//                        foreach ($other_certification as $k => $v){
//                            $old_path = base_path() . "/public/"  . $v['url'];
//                            if (file_exists($old_path)) {
//                                $basename = basename($old_path);
//                                $new_path = $path . $basename; //iconv("UTF-8", "GBK", $p->picture_name);
//                                copy($old_path, $new_path); //拷贝到新目录
//                            }
//                        }
//                    }
//                }
//                copy(base_path() . "/public/" . $value->word_url, $path . basename($value->word_url));
//            }

            $savename = base_path() . "/storage/app/public/recruit/zip/{$recruit->company}.zip";
            $zipper = new Zipper();
            $folder = base_path() . "/storage/app/public/recruit/zip/{$recruit->company}/";//$public_path  被压缩的文件名
            $zipper->make($savename)->add($folder)->close();//public_path($reduce_path)  压缩之后的文件名
//            header("Content-Type: application/zip");
//            header("Content-Transfer-Encoding: Binary");
//            header("Content-Length: " . filesize($savename));
//            header("Content-Disposition: attachment; filename=\"" . $savename . "\"");
//
//            readfile($savename);
//            exit;
            return response()->json(['status' => 1, 'msg' => "/zip/{$recruit->name}.zip" ], 200);
        }else{
            return response()->json(['status' => 0, 'msg' => '没有搜索到相关人员'], 200);
        }


    }

    /**
     * 准考证生成界面
     *
     * @param Content $content
     * @param Request $request
     * @return Content
     */
    public function ticket(Content $content, Request $request)
    {
        $recruit_id = $request->id;
        $recruit = Recruit::find($recruit_id);
        return $content
            ->header('准考证管理')
            ->description('')
            ->body(view('admin.recruit.ticket')->with(['recruit'=>$recruit]));
    }

    /**
     * 导出excel汇总表
     * @param Content $content
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     */
    public function out_excel(Content $content, Request $request)
    {
        Permission::check('recruit_out_excel');
        $id = $request->id;
        $recruit = Recruit::find($id);
        if (empty($recruit)) {
            return response()->json(['status' => 0, 'msg' => '找不到对应的招考场次'], 200);
        }

        $data = $request->all();
        $where = [];
        $where[] = ['audit','>',0];
        $where[] = ['recruit_appoint_info.recruit_id', '=', $data['id']];
        $param = parse_url($data['where']);
        parse_str($param['query'],$param);
        if (is_array($param)) {
            unset($param['id']);
            foreach ($param as $k => $v) {
                if ($k == 'realname') {
                    $where[] = [$k, 'like', "%$v%"];
                } elseif ($k != '_pjax' and $k != 'page' && $k != 'perpage') {
                    $where[] = [$k, '=', $v];
                }
            }
        }

        $select = ['recruit_appoint_info.*', 'recruit_post.code', 'recruit_post.name'];
        $model = RecruitAppointInfo::where($where)->join('recruit_post', 'recruit_appoint_info.post_id', '=', 'recruit_post.id', 'left');
        if(in_array('expand_special',explode(',', $recruit->forms))){
            $model->join('recruit_appoint_expand_special', 'recruit_appoint_expand_special.recruit_appoint_id', '=', 'recruit_appoint_info.id', 'left');
            $special_select = ['recruit_appoint_expand_special.point_apply','recruit_appoint_expand_special.condition','recruit_appoint_expand_special.material'];
            $select = array_merge($select,$special_select);
        }
        if(in_array('detail',explode(',', $recruit->forms))){
            $model->join('recruit_appoint_detail', 'recruit_appoint_detail.recruit_appoint_id', '=', 'recruit_appoint_info.id', 'left');
            $detail_select = ['recruit_appoint_detail.train','recruit_appoint_detail.rewards_and_punishments','recruit_appoint_detail.introduce'];
            $select = array_merge($select,$detail_select);
        }

        $list = $model->select($select)
                ->orderBy('recruit_appoint_info.updated_at','desc')
                ->get();

        if(count($list)){
            $spreadsheet = new Spreadsheet();
            $sheet = $spreadsheet->getActiveSheet();
            $header = ['姓名','性别','生日','头像','民族','籍贯','报考岗位','政治面貌','入党时间','职称或职业资格','现工作单位及职务','户籍所在地','学历','学校','学位','所学专业','通信地址','身份证号码','联系电话','电子邮箱','紧急联系人','紧急联系电话'];
            if(in_array('expand_special',explode(',', $recruit->forms))){
                $special = ['是否申请加分','符合哪一项加分条件','加分佐证材料'];
                $header = array_merge($header,$special);
            }
            if(in_array('detail',explode(',', $recruit->forms))){
                $detail = ['个人简历','培训学习经历','奖惩情况','个人介绍'];
            }else{
                $detail = ['个人简历'];
            }
            $header = array_merge($header,$detail);
            $header[] = '家庭成员及其社会关系';
            if(in_array('identification',explode(',', $recruit->forms))){
                $header[] = '身份证明';
            }
            if(in_array('education_certification',explode(',', $recruit->forms))){
                $header[] = '学历证明';
            }
            if(in_array('other_certification',explode(',', $recruit->forms))){
                $header[] = '其他证明';
            }
            $header[] = '审核状态';
            $header[] = '审核意见';
//            if(in_array('3',explode(',', $recruit->step))){
//                $header = array_merge($header,['笔试准考证打印','笔试审核状态','笔试结果']);
//            }
//            if(in_array('4',explode(',', $recruit->step))){
//                $header = array_merge($header,['上机准考证打印','上机审核状态','上机结果']);
//            }
//            if(in_array('5',explode(',', $recruit->step))){
//                $header = array_merge($header,['面试准考证打印','面试审核状态','面试结果']);
//            }
//            if(in_array('6',explode(',', $recruit->step))){
//                $header = array_merge($header,['复试准考证打印','复试审核状态','复试结果']);
//            }
//            if(in_array('7',explode(',', $recruit->step))){
//                $header = array_merge($header,['体检审核状态','体检结果']);
//            }
//            if(in_array('8',explode(',', $recruit->step))){
//                $header = array_merge($header,['政审状态','政审结果']);
//            }
            $header[] = 'word简历的下载地址';

            foreach ($header as $key => $value) {
                $sheet->setCellValueByColumnAndRow($key+1, 1, $value);
            }
            $row = 2;
            $sheet->getStyle('S')->getNumberFormat()->setFormatCode('0');
            $length = count($list);//算出该数组的长度
            $last = $list[$length-1];//取出最后一个数组的值，复制给新变量，-1是因为第一个数组元素下表为0
            unset($list[$length-1]);//将最后一个数组注销
            $list[] = $last;//再将新变量加入到数组里
            $data = [];
            foreach ($list as $k => $v) {
                switch ($v->political_affiliation) {
                    case '01':
                        $political_affiliation = '中共党员';
                        break;
                    case '02':
                        $political_affiliation = '中共预备党员';
                        break;
                    case '03':
                        $political_affiliation = '共青团员';
                        break;
                    case '04':
                        $political_affiliation = '民革党员';
                        break;
                    case '05':
                        $political_affiliation = '民盟盟员';
                        break;
                    case '06':
                        $political_affiliation = '民建会员';
                        break;
                    case '07':
                        $political_affiliation = '民进会员';
                        break;
                    case '08':
                        $political_affiliation = '农工党党员';
                        break;
                    case '09':
                        $political_affiliation = '致公党党员';
                        break;
                    case '10':
                        $political_affiliation = '九三学社社员';
                        break;
                    case '11':
                        $political_affiliation = '台盟盟员';
                        break;
                    case '12':
                        $political_affiliation = '无党派人士';
                        break;
                    case '13':
                        $political_affiliation = '群众';
                        break;
                    default:
                        $political_affiliation = '未知';
                        break;
                }
                $item = [
                    $v->realname,
                    $v->sex == 0 ? '女' : '男',
                    $v->birthday,
                    "https://www.jucai.gov.cn" . $v->avatar,
                    $v->nation,
                    $v->native_place,
                    $v->code . $v->name,
                    $political_affiliation,
                    $v->join_time,
                    $v->titles,
                    $v->work,
                    $v->house_register,
                    $v->education,
                    $v->school,
                    $v->degree,
                    $v->pro,
                    $v->address,
                    '\''.$v->card,
                    $v->mobile,
                    $v->email,
                    $v->concat_name,
                    $v->concat_mobile
                ];
                if (in_array('expand_special', explode(',', $recruit->forms))) {
                    $material = json_decode($v->material, true);
                    $materials = [];
                    if($material){
                        foreach ($material as $key => $value) {
                            array_push($materials, "https://www.jucai.gov.cn" . $value['response']['path']);
                        }
                    }
                    $special = [
                        $v->point_apply == 0 ? '否' : '是',
                        $v->condition,
                        implode("\r\n", $materials)
                    ];
                    $item = array_merge($item, $special);
                }
                if (in_array('detail', explode(',', $recruit->forms))) {
                    $detail = [
                        $v->resume,
                        $v->train,
                        $v->rewards_and_punishments,
                        $v->introduce
                    ];
                } else {
                    $detail = [$v->resume];
                }
                $item = array_merge($item, $detail);
                $family = json_decode($v->family, true);
                $familys = [];
                foreach ($family as $val){
                    switch ($val['political_affiliation']) {
                        case '01':
                            $political_affiliation = '中共党员';
                            break;
                        case '02':
                            $political_affiliation = '中共预备党员';
                            break;
                        case '03':
                            $political_affiliation = '共青团员';
                            break;
                        case '04':
                            $political_affiliation = '民革党员';
                            break;
                        case '05':
                            $political_affiliation = '民盟盟员';
                            break;
                        case '06':
                            $political_affiliation = '民建会员';
                            break;
                        case '07':
                            $political_affiliation = '民进会员';
                            break;
                        case '08':
                            $political_affiliation = '农工党党员';
                            break;
                        case '09':
                            $political_affiliation = '致公党党员';
                            break;
                        case '10':
                            $political_affiliation = '九三学社社员';
                            break;
                        case '11':
                            $political_affiliation = '台盟盟员';
                            break;
                        case '12':
                            $political_affiliation = '无党派人士';
                            break;
                        case '13':
                            $political_affiliation = '群众';
                            break;
                        default:
                            $political_affiliation = '未知';
                            break;
                    }
                    $familys[] = "称谓：" . $val['relation'] . "；姓名：".$val['realname'] . '；生日：'.$val['birthday'].'；政治面貌：'.$political_affiliation.'；职业：'.$val['work'];
                }
                $item[] = implode("\r\n", $familys);
                if (in_array('identification', explode(',', $recruit->forms))) {
                    $identification = json_decode($v->identification, true);
                    $identifications = [];
                    foreach ($identification as $val){
                        array_push($identifications,"https://www.jucai.gov.cn" . $val['response']['path']);
                    }
                    array_push($item, implode("\r\n", $identifications));
                }
                if (in_array('education_certification', explode(',', $recruit->forms))) {
                    $education_certification = json_decode($v->education_certification, true);
                    $education_certifications = [];
                    foreach ($education_certification as $val){
                        array_push($education_certifications,"https://www.jucai.gov.cn" . $val['response']['path']);
                    }
                    array_push($item, implode("\r\n", $education_certifications));
                }
                if (in_array('other_certification', explode(',', $recruit->forms))) {
                    $other_certification = json_decode($v->other_certification, true);
                    $other_certifications = [];
                    if($other_certification){
                        foreach ($other_certification as $val){
                            array_push($other_certifications,"https://www.jucai.gov.cn" . $val['response']['path']);
                        }
                    }

                    array_push($item, implode("\r\n", $other_certifications));
                }
                switch (intval($v->audit)){
                    case 1:
                        $item[] = '审核中';
                        $item[] = '';
                        break;
                    case 2:
                    case 3:
                        $log = RecruitAppointLog::where('appoint_id', $v->id)->where('step', 1)->where('type', 2)->orderBy('created_at', 'desc')->first();
                        if ($log) {
                            $log_arr = explode('，',$log->log);
                            $item[] = $log_arr[0];
                            $item[] = $log_arr[1];
                        } else {
                            $item[] = '';
                            $item[] = '';
                        }
                        break;
                    default:
                        $item[] = '';
                        $item[] = '';
                        break;
                }


                if(empty($v->word_url)){
                    $item[] = "暂无";
                }else{
                    $item[] = "https://www.jucai.gov.cn/" . $v->word_url;     
                }
                
                array_push($data,$item);
            }

            foreach($data as $k => $v){
                for ($i = 0;$i<count($v);$i++){
                    if($i == 18 || $i == 19 || $i == 22){
                        $sheet->setCellValueExplicitByColumnAndRow($i+1, $row, $v[$i], DataType::TYPE_STRING);
                    }else{
                        $sheet->setCellValueByColumnAndRow($i+1, $row, $v[$i]);
                    }
                }
                $row++;
            }
            $file_name = $recruit->name . date("Y-m-d",time());
            header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
            header('Content-Disposition: attachment;filename="'.$file_name.'.xlsx"');
            header('Cache-Control: max-age=0');
            // If you're serving to IE 9, then the following may be needed
            header('Cache-Control: max-age=1');
            // If you're serving to IE over SSL, then the following may be needed
            header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
            header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
            header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
            header('Pragma: public'); // HTTP/1.0
            $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
            $writer->save('php://output');

        }else{
            return response()->json(['status' => 0, 'msg' => '没有搜索到相关人员'], 200);
        }

    }

    /**
     * 座位贴
     * @param Content $content
     * @param Request $request
     * @return Content
     */
    public function seat_sticker(Content $content, Request $request){
        $recruit_id = $request->id;
        $list = RecruitAppointInfo::where(['recruit_appoint_info.recruit_id' => $recruit_id,'recruit_appoint_info.audit' => 3, 'recruit_ticket.ex_type' => 1])
            ->join('recruit_ticket', 'recruit_ticket.appoint_id', '=', 'recruit_appoint_info.id','left')
            ->select('recruit_appoint_info.*','recruit_ticket.*')
            ->orderBy('recruit_ticket.ex_seat','asc')
            ->get();
        $data = [];
        foreach ($list as $k => $v){
            $room = $v->ex_room == null ? 'empty' : $v->ex_room;
            if(!array_key_exists($room,$data)){
                $data[$room] = [];
            }
            $item = [
                'avatar' => $v->avatar,
                'seat' => $v->ex_seat,
                'realname' => $v->realname,
                'number' => $v->ex_number
            ];
            array_push($data[$room],$item);
        }
        //dd($data);
        return $content->body(view('admin.recruit.seat_sticker')->with(['data' => $data]));
    }


    public function sign_table(Content $content, Request $request){
        $recruit_id = $request->id;
        $list = RecruitAppointInfo::where(['recruit_appoint_info.recruit_id' => $recruit_id,'recruit_appoint_info.audit' => 3, 'recruit_ticket.ex_type' => 1])
            ->join('recruit_ticket', 'recruit_ticket.appoint_id', '=', 'recruit_appoint_info.id','left')
            ->select('recruit_appoint_info.*','recruit_ticket.*')
            ->orderBy('recruit_ticket.ex_seat','asc')
            ->get();
        $data = [];
        foreach ($list as $k => $v){
            $room = $v->ex_room == null ? 'empty' : $v->ex_room;
            if(!array_key_exists($room,$data)){
                $data[$room] = [];
            }
            $item = [
                'avatar' => $v->avatar,
                'seat' => $v->ex_seat,
                'realname' => $v->realname
            ];
            array_push($data[$room],$item);
        }
        return $content->body(view('admin.recruit.sign_table')->with(['data' => $data]));
    }

    /**
     * 上传成绩页面
     *
     * @access public
     */
    public function ajax_record(Request $request)
    {
        $recruit_id = $request->input('recruit_id');
        if(!$recruit_id){
            return response()->json(['status' => 0, 'msg' => '请指定招考场次'], 200);
        }
        $recruit = Recruit::where('id',$recruit_id)->first();
        if(empty($recruit)){
            return response()->json(['status' => 0, 'msg' => '找不到对应招考场次'], 200);
        }

        $view_data = [
            'recruit'   =>  $recruit
        ];
        return response(['data' => view('admin.recruit.ajax_record')->with($view_data)->render(), 'status' => 1], '200');
    }

    public function update_record(Request $request)
    {
        $data = $request->all();
        if(!array_key_exists('recruit_id',$data) || !$data['recruit_id']){
            return response()->json(['status' => 0, 'msg' => '请指定招考场次'], 200);
        }
        $recruit = Recruit::where('id',$data['recruit_id'])->first();
        if(empty($recruit)){
            return response()->json(['status' => 0, 'msg' => '找不到对应招考场次'], 200);
        }
        if(array_key_exists('pen_data',$data)){
            $ticket_url = base_path() . "/storage/app/public/recruit/ticket/" . uniqid() . '.xlsx';
            if(move_uploaded_file($_FILES['pen_data']['tmp_name'],$ticket_url)){
                $spreadsheet = IOFactory::load($ticket_url);
                $sheet = $spreadsheet->getActiveSheet();
                $rowCount = $sheet->getHighestRow();
                $record = [];
                for($row = 2;$row<=$rowCount;$row++){
                    $record[$sheet->getCell("A{$row}")->getValue()] = [
                        'id' => $sheet->getCell("A{$row}")->getValue(),
                        'realname' => $sheet->getCell("B{$row}")->getValue(),
                        'card' => $sheet->getCell("C{$row}")->getValue(),
                        'ex_number' => $sheet->getCell("E{$row}")->getValue(),
                        'record' => $sheet->getCell("F{$row}")->getValue(),
                        'next' => $sheet->getCell("G{$row}")->getValue()
                    ];
                }
                Recruit::where('id',$data['recruit_id'])->update(['pen_status' => 1]);
                $record = new TicketJob($data['recruit_id'],'pen_result',$record);
                dispatch($record);
                return response()->json(['status' => 1, 'msg' => '成绩上传成功'], 200);
            }else{
                return response()->json(['status' => 0, 'msg' => '成绩上传失败'], 200);
            }
        }
    }

    public function create_record_template(Request $request){
        $recruit_id = $request->input('recruit_id');
        if(!$recruit_id){
            return response()->json(['status' => 0, 'msg' => '请指定招考场次'], 200);
        }
        $recruit = Recruit::where('id',$recruit_id)->first();
        if(empty($recruit)){
            return response()->json(['status' => 0, 'msg' => '找不到对应招考场次'], 200);
        }
        $type = $request->input('type','pen');
        switch ($type){
            case 'pen':
                $list = RecruitAppointInfo::where('recruit_appoint_info.recruit_id',$recruit_id)->where('recruit_appoint_info.audit',3)->where('recruit_appoint_info.pen_audit',-1)->join('recruit_ticket', 'recruit_appoint_info.id', '=', 'recruit_ticket.appoint_id')->select('recruit_appoint_info.*','recruit_ticket.ex_number')->orderBy('post_id','asc')->get();
                $post_data = RecruitPost::where('recruit_id',$recruit_id)->where('status',1)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');
                $data = [];
                foreach ($list as $k => $v){
                    $item = [
                        $v->id,
                        $v->realname,
                        $v->card,
                        $post_data[$v->post_id],
                        $v->ex_number
                    ];
                    array_push($data,$item);
                }
                $spreadsheet = IOFactory::load(base_path() . '/storage/app/public/recruit/ticket/template/record_data_template.xlsx');
                $sheet = $spreadsheet->getActiveSheet();

                $row = 2;
                foreach($data as $k => $v){
                    for ($i = 0;$i<count($v);$i++){
                        if($i == 2 || $i == 4){
                            $sheet->setCellValueExplicitByColumnAndRow($i+1, $row, $v[$i], DataType::TYPE_STRING);
                        }else{
                            $sheet->setCellValueByColumnAndRow($i+1, $row, $v[$i]);
                        }
                    }
                    $row++;
                }

                $file_name = $recruit->company . "_成绩表模板";
                header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
                header('Content-Disposition: attachment;filename="'.$file_name.'.xlsx"');
                header('Cache-Control: max-age=0');
                // If you're serving to IE 9, then the following may be needed
                header('Cache-Control: max-age=1');
                // If you're serving to IE over SSL, then the following may be needed
                header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
                header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
                header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
                header('Pragma: public'); // HTTP/1.0
                $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
                $writer->save('php://output');

                break;
        }
    }

    public function create_ticket(Request $request)
    {
        $data = $request->only('recruit_id','type','channel','content','keys');
        //dd($data);
    }

    public function test(Request $request){


//        $ids = [6,7,121,47,181,66,108,138,21,212,177,130,114,27,63,31,51];
//        $data = RecruitAppointInfo::whereIn('id',$ids)->get();
//        $post_data = RecruitPost::where('recruit_id',1)->where('status',1)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');
//
//
//        foreach ($data as $k => $v){
//            $templateProcessor = new TemplateProcessor(base_path() . "/storage/app/public/recruit/ticket/template/jjhc_face_ticket.docx");
//            $templateProcessor->setValue('realname', $v->realname);
//            $templateProcessor->setValue('card', $v->card);
//            $templateProcessor->setValue('post', $post_data[$v->post_id]);
//            $name = 'jjhc';
//            $date = '2020-11-30';
//            if(!is_dir(base_path() . "/storage/app/public/recruit/ticket/word/{$date}/{$name}/face")){
//                Storage::makeDirectory("public/recruit/ticket/word/{$date}/{$name}/face");
//            }
//            $filename = $v->realname . '_' . $v->card . '_' . $post_data[$v->post_id];
//            $word_url = base_path() . "/storage/app/public/recruit/ticket/word/{$date}/{$name}/face/" . $filename . '.docx';
//            $templateProcessor->saveAs($word_url);//另存为
//        }



//        $templateProcessor = new TemplateProcessor(base_path() . "/storage/app/public/recruit/ticket/template/jjhc_pen_ticket.docx");
//
//
//        $templateProcessor->setImageValue('avatar',['path' => 'https://www.jucai.gov.cn/storage/-1ae05561c7f32869.jpg', 'width' => 200, 'height' => 150]);
//        $templateProcessor->saveAs(base_path() . "/storage/app/public/recruit/ticket/template/test.docx");//另存为
        //shell_exec('libreoffice6.4 --headless --convert-to pdf:writer_pdf_Export ' . base_path() . "/storage/app/public/recruit/ticket/template/test.docx " . base_path() ."/storage/app/public/recruit/ticket/template/test.pdf");

        //libreoffice --headless --convert-to pdf:writer_pdf_Export /data/wwwroot/jucai/storage/app/public/recruit/word/2020-11-30/jjhc/pen/*.docx --outdir /data/wwwroot/jucai/storage/app/public/recruit/pdf/2020-11-30/jjhc/pen
    }
}