jucai/app/Http/Controllers/Web/Recruit/ApiController.php

<?php

namespace App\Http\Controllers\Web\Recruit;

use App\Http\Controllers\Web\WebBaseController;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Storage;
use App\Repositories\PmsRepository;
use PhpOffice\PhpWord\TemplateProcessor;
use App\Services\Common\SmsService;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\IOFactory;
use App\Exceptions\ResponseException;
use PhpOffice\PhpSpreadsheet\Cell\DataType;

class ApiController extends WebBaseController
{
    protected $pmsRepository;
    private $smsService;

    public function __construct(PmsRepository $pmsRepository, SmsService $smsService)
    {
        $this->pmsRepository = $pmsRepository;
        $this->smsService    = $smsService;
        header('Access-Control-Allow-Origin:*');
        header('Access-Control-Allow-Methods:GET,POST,PUT,DELETE');
        header('Access-Control-Allow-Headers:Origin, Content-Type, Cookie, Accept, X-CSRF-TOKEN');
        header('Access-Control-Allow-Credentials:true');

    }

    /**
     * 获得当前登录 的用户对象
     * @return false|mixed|string
     */
    public function getUser()
    {
//        $res['isLogin'] = 1;
//        $res['status'] = 1;
//        $res['user'] = [
//            'name'  => 'test',
//            'pmsNum'    => 1
//        ];
//
//        return response()->json($res);

        $user = parent::getLoginUser();
        $res  = [];
        if (!$user) {
            $res['isLogin'] = 0;
            $res['status']  = 1;
            $res['user']    = null;
        } else {
            $condition4 = [
                'msgtouid' => $user->id,
                'utype'    => $user->utype,
                'new'      => 1,
            ];
            $pms        = $this->pmsRepository->getPmsCount($condition4);
            switch ($user->utype) {
                case '1':
                    $name = $user->companyname;
                    break;
                case '2':
                    $memberService = app('App\Services\Person\MemberService');
                    $name          = $memberService->getName();
                    break;
            }

            $res['isLogin'] = 1;
            $res['status']  = 1;
            $res['user']    = [
                'name'   => $name,
                'pmsNum' => $pms,
            ];

        }
        return json_encode($res);
    }

    public function getSignupUser()
    {
        $user = parent::getLoginUser();
//        $user = new \StdClass();
//        $user->id = 59041;
        if (!$user) {
            return response()->json(['isLogin' => 0, 'status' => 0, 'user' => null, 'msg' => '您尚未登录']);
        }

        return $user;
    }

    public function userCheck()
    {
        $user = parent::getLoginUser();
        if (!$user) {
            $res = ['isLogin' => 0, 'status' => 0, 'user' => $user, 'msg' => '您尚未登录', 'ret' => false];
            return $res;
        }
        $admin = ['59041', '161303', '159761', '148935', '150282'];
        if (!in_array($user->id, $admin)) {
            $res = ['isLogin' => 1, 'status' => 0, 'user' => null, 'msg' => '您没有权限', 'url' => 'http://www.jucai.gov.cn', 'ret' => false];
            return $res;
        }
        return ['ret' => true, 'user' => $user];
    }

    /**
     * 上传文件的方法
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function upload(Request $request)
    {
        $file = $request->file('file');
        if ($file->isValid()) { //判断文件是否存在
            //获取文件的扩展名
            $ext = $file->getClientOriginalExtension();

            if (!in_array(strtolower($ext), ['jpg', 'jpeg', 'png', 'doc', 'docx', 'pdf'])) {
                $res['status'] = 0;
                $res['msg']    = '文件格式不正确';
            } else {
                //获取文件的绝对路径
                $path = $file->getRealPath();

                $oldname = $file->getClientOriginalName();

                //定义文件名
                $filename = 'storage/recruit/' . uniqid() . mt_rand(10000, 99999) . '.' . $ext;

                //存储文件。disk里面的public。总的来说，就是调用disk模块里的public配置
                Storage::disk('public')->put($filename, file_get_contents($path));

                $res['status']   = 1;
                $res['filename'] = $oldname;
                $res['path']     = "/storage/" . $filename;
                $res['msg']      = '上传成功';
            }
        } else {
            $res['status'] = 0;
            $res['msg']    = '上传失败';
        }
        return response()->json($res);
    }

    /**
     * 专用型招考报名保存
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function save(Request $request)
    {
        $user     = $this->getSignupUser();
        $uid      = $user->id;
        $rules    = [
            'realname'            => 'required',
            'sex'                 => 'required',
            'birthday'            => 'required',
            'native_place'        => 'required',
            'post_id'             => 'required',
            'political_attitudes' => 'required',
            'edu_type'            => 'required',
            'education'           => 'required',
            'school'              => 'required',
            'degree'              => 'required',
            'pro'                 => 'required',
            'address'             => 'required',
            'mobile'              => 'required',
            'email'               => 'required',
            'nation'              => 'required',
            'card'                => 'required',
            'house_register'      => 'required',
            'resume'              => 'required',
            //'family' => 'required',
            'avatar'              => 'required',
            'front_card'          => 'required',
            'back_card'           => 'required',
            'concat_name'         => 'required',
            'concat_mobile'       => 'required',
            //'diploma_img' => 'required',
            //'degree_img' => 'required',
            //'xuexin_img' => 'required'
        ];
        $messages = [
            'realname.required'            => '请填写姓名',
            'sex.required'                 => '请填写性别',
            'birthday.required'            => '请填写出生日期',
            'native_place.required'        => '请填写籍贯',
            'political_attitudes.required' => '请填写政治面貌',
            'edu_type.required'            => '请选择教育类型',
            'education.required'           => '请输入学历',
            'school.required'              => '请输入毕业院校',
            'degree.required'              => '请输入学位',
            'pro.required'                 => '请输入专业',
            'address.required'             => '请填写通信地址',
            'mobile.required'              => '请填写手机号码',
            'email.required'               => '请填写电子邮箱',
            'post_id.required'             => '请选择报名岗位',
            'nation.required'              => '请填写民族',
            'card.required'                => '请填写身份证号码',
            'house_register.required'      => '请填写户籍所在地',
            'resume.required'              => '请填写个人简历',
            //'family.required' => '请填写家庭成员及主要社会关系',
            'avatar.required'              => '请上传彩色免冠照',
            'front_card.required'          => '请上传身份证正面照',
            'back_card.required'           => '请上传身份证反面照',
            'concat_name.required'         => '请填写联系人姓名',
            'concat_mobile.required'       => '请填写联系人手机号码',
            //'diploma_img.required' => '请上传毕业证书照',
            //'degree_img.required' => '请上传学位证书',
            //'xuexin_img.required' => '请上传学信网证书'
        ];
        //根据招聘场次不同验证所需要的材料
        $rid = $request->input('rid');
        switch (intval($rid)) {
            case 6:
                //根据报名岗位判断
                $post = $request->input('post_id');
                if (in_array($post, [14, 15, 16, 17, 18, 20, 21, 23, 24])) {
                    $rules['work_approve']             = 'required';
                    $messages['work_approve.required'] = '您所报名的岗位需要上传工作经历证明';
                }
                if (in_array($post, [14, 18, 20, 21, 25, 29, 30])) {
                    $rules['work_pro_img']             = 'required';
                    $messages['work_pro_img.required'] = '您所报名的岗位需要上传职(执)业资格证书、专业技术资格（职务）证书';
                }
                if ($post == 28) {
                    $rules['join_time']                = 'required';
                    $messages['join_time.required']    = '您所报名的岗位需要填写入党时间，格式为年月';
                    $rules['work_approve']             = 'required';
                    $messages['work_approve.required'] = '您所报名的岗位需要党员证明';
                }
                if (in_array($post, [19, 20, 27])) {
                    $rules['sex']             = 'required|accepted';
                    $messages['sex.accepted'] = '您所报名的岗位限制男性报名';

                }
                break;
        }

        $res         = [
            'status' => 0,
            'data'   => '',
            'msg'    => '',
        ];
        $create_data = $request->all();
        $validator   = Validator::make($create_data, $rules, $messages);

        if ($validator->fails()) {
            $msg        = $validator->errors()->all();
            $res['msg'] = $msg[0];
            echo json_encode($res);
        } else {
            $data   = $request->only('realname', 'sex', 'birthday', 'avatar', 'post_id', 'nation', 'native_place', 'political_attitudes', 'titles', 'work', 'house_register', 'join_time', 'edu_type', 'education', 'school', 'degree', 'pro', 'address', 'card', 'mobile', 'email', 'concat_name', 'concat_mobile', 'resume', 'training', 'rewards_and_punishments', 'introduce', 'front_card', 'back_card', 'diploma_img', 'degree_img', 'xuexin_img', 'work_pro_img', 'work_approve', 'operation', 'rid', 'id');
            $family = $request->input('family');
            //对入库数据处理
            $data['birthday'] = strtotime($data['birthday']);
            switch ($data['edu_type']) {
                case '1':
                case 1:
                case '全日制教育':
                    $data['edu_type'] = 1;
                    break;
                case '2':
                case 2:
                case '在职教育':
                    $data['edu_type'] = 2;
                    break;
            }

            if ($data['operation'] == 2) {
                $data['status'] = 1;
                $data['check']  = 0;
                $msg            = '报名成功，请等待审核';
            } else {
                $data['status'] = 0;
                $data['check']  = 0;
                $msg            = '保存成功';
            }
            unset($data['operation']);

            //处理工作证明
            if (is_array($data['work_approve'])) {
                $imgs = [];
                foreach ($data['work_approve'] as $k => $v) {
                    if (is_array($v)) {
                        array_push($imgs, $v['url']);
                    } else {
                        array_push($imgs, $v);
                    }
                }
                $data['work_approve'] = implode(',', $imgs);
            }

            //处理职业资格或职称证明
            if (is_array($data['work_pro_img'])) {
                $imgs = [];
                foreach ($data['work_pro_img'] as $k => $v) {
                    if (is_array($v)) {
                        array_push($imgs, $v['url']);
                    } else {
                        array_push($imgs, $v);
                    }
                }
                $data['work_pro_img'] = implode(',', $imgs);
            }

            //判断是否已经有存在的报名记录
            if (array_key_exists('id', $data) && $data['id'] > 0) {
                //如果已经存在记录
                $id   = $data['id'];
                $info = DB::table('recruit_entry')->where('id', $id)->where('uid', $uid)->first();
                if (!$info) {
                    return response()->json(['status' => 0, 'msg' => '没有权限修改']);
                }
                unset($data['id']);
                DB::table('recruit_entry')->where('id', $id)->update($data);
                if ($family) {
                    foreach ($family as $v) {
                        if (array_key_exists('id', $v)) {
                            $item = DB::table('recruit_family')->find($v['id']);
                            if ($item) {
                                if ($item->uid == $uid) {
                                    $data = [
                                        'appellation'         => $v['appellation'],
                                        'realname'            => $v['realname'],
                                        'birthday'            => strtotime($v['birthday']),
                                        'political_attitudes' => $v['political_attitudes'],
                                        'work'                => $v['work'],
                                    ];
                                    DB::table('recruit_family')->where('id', $v['id'])->update($data);
                                }
                            }
                        } else {
                            $item                        = [];
                            $item['appellation']         = $v['appellation'];
                            $item['realname']            = $v['realname'];
                            $item['birthday']            = strtotime($v['birthday']);
                            $item['political_attitudes'] = $v['political_attitudes'];
                            $item['work']                = $v['work'];
                            $item['eid']                 = $info->id;
                            $item['uid']                 = $uid;
                            DB::table('recruit_family')->insert($item);
                        }
                    }
                }
            } else {
                //以证件号码进行二次判断
                $info = DB::table('recruit_entry')->where('card', $data['card'])->first();
                if ($info) {
                    if ($info->uid != $uid) {
                        return response()->json(['status' => 0, 'msg' => '该证件已通过其他账号报名，请检查']);
                    }
                    $id = $info->id;
                    DB::table('recruit_entry')->where('id', $info->id)->update($data);
                    if ($family) {
                        foreach ($family as $v) {
                            if (array_key_exists('id', $v)) {
                                $item = DB::table('recruit_family')->find($v['id']);
                                if ($item) {
                                    if ($item->uid == $uid) {
                                        $data = [
                                            'appellation'         => $v['appellation'],
                                            'realname'            => $v['realname'],
                                            'birthday'            => strtotime($v['birthday']),
                                            'political_attitudes' => $v['political_attitudes'],
                                            'work'                => $v['work'],
                                        ];
                                        DB::table('recruit_family')->where('id', $v['id'])->update($data);
                                    }
                                }
                            } else {
                                $item                        = [];
                                $item['appellation']         = $v['appellation'];
                                $item['realname']            = $v['realname'];
                                $item['birthday']            = strtotime($v['birthday']);
                                $item['political_attitudes'] = $v['political_attitudes'];
                                $item['work']                = $v['work'];
                                $item['eid']                 = $info->id;
                                $item['uid']                 = $uid;
                                DB::table('recruit_family')->insert($item);
                            }
                        }
                    }
                } else {
                    $data['uid']        = $uid;
                    $data['createtime'] = time();
                    $id                 = DB::table('recruit_entry')->insertGetId($data);
                    if ($family) {
                        foreach ($family as $v) {
                            $item                        = [];
                            $item['appellation']         = $v['appellation'];
                            $item['realname']            = $v['realname'];
                            $item['birthday']            = strtotime($v['birthday']);
                            $item['political_attitudes'] = $v['political_attitudes'];
                            $item['work']                = $v['work'];
                            $item['eid']                 = $id;
                            $item['uid']                 = $uid;
                            DB::table('recruit_family')->insert($item);
                        }
                    }
                }
            }
            return response()->json($res = ['status' => 1, 'data' => $id, 'msg' => $msg]);
        }
    }

    /**
     * 查看可以报名的场次
     * @param Request $request
     */
    public function signup_list(Request $request)
    {
        $page  = $request->input('page');
        $title = $request->input('title');
        if ($title) {
            $where[] = ['name', 'like', '%' . $title . '%'];
        }
        $where[] = ['status', '=', 1];
        $where[] = ['step', '=', 1];//仅可查看可以报名的
        $total   = DB::table('recruit')->where($where)->count();
        $result  = DB::table('recruit')->where($where)->offset(10 * ($page - 1))->limit(10 * $page)->get()->toArray();
        $list    = [];
        if ($result) {
            foreach ($result as $k => $v) {
                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;
                    case '9':
                        $step = '结束';
                        break;
                    default:
                        $step = '准备中';
                        break;
                }
                $item = [
                    'id'    => $v->id,
                    'name'  => $v->name,
                    'start' => date("Y-m-d", $v->start),
                    'end'   => date("Y-m-d", $v->end),
                    'step'  => $step,
                ];
                array_push($list, $item);
            }
            $res = [
                'status' => 1,
                'data'   => [
                    'list'  => $list,
                    'total' => $total,
                ],
                'msg'    => '暂无数据',
            ];
            echo json_encode($res);
        } else {
            $res = [
                'status' => 1,
                'data'   => [
                    'list'  => [],
                    'total' => 0,
                ],
                'msg'    => '暂无数据',
            ];
            echo json_encode($res);
        }
    }

    /**
     * 获取招考报名的详细信息
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function signup_detail(Request $request)
    {
        $user = $this->getSignupUser();
        $uid  = $user->id;

        $id = $request->input('id');
        if (!$id) {
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '请指定招考场次',
            ];
            return response()->json($res);
        } else {
            $info = DB::table('recruit')->find($id);
            if (!$info) {
                $res = [
                    'status' => 0,
                    'data'   => '',
                    'msg'    => '找不到对应的招考场次',
                ];
                return response()->json($res);
            } else {

                switch ($info->type) {
                    case '2':
                        $enterprise      = [];
                        $enterprise_list = DB::table('recruit_enterprise')->where('rid', $info->id)->get()->toArray();
                        foreach ($enterprise_list as $k => $v) {
                            $sub_opt = [];
                            $sub     = DB::table('recruit_enterprise_post')->where('eid', $v->id)->where('rid', $info->id)->get()->toArray();
                            foreach ($sub as $key => $val) {
                                $item = [
                                    'value' => $val->id,
                                    'label' => $val->code . " " . $val->name,
                                ];
                                array_push($sub_opt, $item);
                            }
                            $item = [
                                'value' => $v->id,
                                'label' => $v->label,
                                'post'  => $sub_opt,
                            ];
                            array_push($enterprise, $item);
                        }
                        $info->post = $enterprise;
                        $entry      = DB::table('recruit_internship')->where('rid', $info->id)->where('uid', $uid)->first();

                        if ($entry) {
                            $entry->birthday   = date("Y-m-d", $entry->birthday);
                            $entry->check_time = date("Y-m-d", $entry->check_time);
                            $entry->sex        = (string)$entry->sex;
                            $entry->class      = (string)$entry->class;
                            if ($info->step >= 3) {
                                //TODO  笔试
                            }
                            if ($info->step >= 4) {
                                $interview        = DB::table('recruit_exam_interview')->where('recruit_id', $info->id)->where('entry_id', $entry->id)->first();
                                $entry->interview = $interview;
                            }
                            $info->entry = $entry;
                        } else {
                            if (time() > $info->end) {
                                return response()->json(['status' => 0, 'msg' => '报名已截止']);
                            }
                        }
                        break;
                    default:

                        $post       = DB::table('recruit_post1')->where('rid', $info->id)->get()->toArray();
                        $info->post = $post;
                        $entry      = DB::table('recruit_entry')->where('rid', $info->id)->where('uid', $uid)->first();
                        if (!$entry && time() > $info->end) {
                            return response()->json(['status' => 0, 'msg' => '报名已截止']);
                        }
                        if ($entry) {
                            $entry->birthday   = date("Y-m-d", $entry->birthday);
                            $entry->check_time = date("Y-m-d", $entry->check_time);
                            switch ($entry->edu_type) {
                                case 1:
                                    $entry->edu_type = '全日制教育';
                                    break;
                                case 2:
                                    $entry->edu_type = '在职教育';
                                    break;
                                default:
                                    break;
                            }
                            //处理工作证明
                            if (!empty($entry->work_approve)) {
                                $imgs                = explode(',', $entry->work_approve);
                                $entry->work_approve = [];
                                foreach ($imgs as $v) {
                                    $item['url'] = $v;
                                    array_push($entry->work_approve, $item);
                                }
                            }

                            //处理职业资格和职称
                            if (!empty($entry->work_pro_img)) {
                                $imgs                = explode(',', $entry->work_pro_img);
                                $entry->work_pro_img = [];
                                foreach ($imgs as $v) {
                                    $item['url'] = $v;
                                    array_push($entry->work_pro_img, $item);
                                }
                            }
                            $family = DB::table('recruit_family')->where('eid', $entry->id)->get()->toArray();
                            foreach ($family as $k => $v) {
                                $family[$k]->birthday = date("Y-m-d", $v->birthday);
                            }
                            $entry->family = $family;
                            $entry->sex    = (string)$entry->sex;
                            $info->entry   = $entry;
                        }
                        break;
                }

                $res = [
                    'status' => 1,
                    'data'   => $info,
                    'msg'    => '获取招考信息成功',
                ];
                return response()->json($res);
            }
        }
    }

    /**
     * 报名记录查询
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function recruit_list(Request $request)
    {

        $res = $this->userCheck();
        if (!$res['ret']) {
            return response()->json($res);
        }
        $page  = $request->input('page');
        $title = $request->input('title');
        $where = [];
        if ($title) {
            $where[] = ['name', '=', $title];
        }
        $where[] = ['status', '>=', 0];
        $total   = DB::table('recruit')->where($where)->count();
        $result  = DB::table('recruit')->where($where)->offset(10 * ($page - 1))->limit(10)->get()->toArray();
        $list    = [];
        if ($result) {
            foreach ($result as $k => $v) {
                $item = [
                    'id'       => $v->id,
                    'name'     => $v->name,
                    'start'    => date("Y-m-d H:i:s", $v->start),
                    'end'      => date("Y-m-d H:i:s", $v->end),
                    'status'   => $v->status,
                    'post_sum' => DB::table('recruit_post1')->where('rid', $v->id)->count(),
                    'type'     => $v->type,
                ];
                array_push($list, $item);
            }
            $res = [
                'status' => 1,
                'data'   => [
                    'list'  => $list,
                    'total' => $total,
                ],
                'msg'    => '暂无数据',
            ];
            echo json_encode($res);
        } else {
            $res = [
                'status' => 1,
                'data'   => [
                    'list'  => [],
                    'total' => 0,
                ],
                'msg'    => '暂无数据',
            ];
            echo json_encode($res);
        }
    }

    /**
     * 添加招考报名场次
     * @param Request $request
     */
    public function add_recruit(Request $request)
    {
        $type = $request->input('type');
        switch ($type) {
            case '1':
                $rules    = [
                    'name'      => 'required',
                    'start'     => 'required',
                    'end'       => 'required',
                    'status'    => 'required',
                    'post_data' => 'required',
                ];
                $messages = [
                    'name.required'      => '请填写招考名称',
                    'start.required'     => '请填写招考开始时间',
                    'end.required'       => '请填写招考结束时间',
                    'status.required'    => '请填写招考状态',
                    'post_data.required' => '请填写招聘岗位',
                ];
                break;
            case '2':
                $rules    = [
                    'name'            => 'required',
                    'start'           => 'required',
                    'end'             => 'required',
                    'status'          => 'required',
                    'enterprise_post' => 'required',
                ];
                $messages = [
                    'name.required'            => '请填写招考名称',
                    'start.required'           => '请填写招考开始时间',
                    'end.required'             => '请填写招考结束时间',
                    'status.required'          => '请填写招考状态',
                    'enterprise_post.required' => '请填写招聘岗位',
                ];
                break;
            default:
                $rules    = [];
                $messages = [];
                break;
        }

        $res         = [
            'status' => 0,
            'data'   => '',
            'msg'    => '',
        ];
        $create_data = $request->all();
        $validator   = Validator::make($create_data, $rules, $messages);

        if ($validator->fails()) {
            $msg        = $validator->errors()->all();
            $res['msg'] = $msg[0];
            echo json_encode($res);
        } else {
            $data['name']   = $request->input('name');
            $data['start']  = strtotime($request->input('start'));
            $data['end']    = strtotime($request->input('end'));
            $data['status'] = $request->input('status');
            $data['type']   = $type;
            if ($data['name']) {
                $id = DB::table('recruit')->insertGetId($data);
                switch ($type) {
                    case '1':
                        $post_data = $request->input('post_data');
                        $post      = [];
                        foreach ($post_data as $k => $v) {
                            $item = [
                                'name' => $v['name'],
                                'code' => $v['code'],
                                'rid'  => $id,
                            ];
                            array_push($post, $item);
                        }
                        DB::table('recruit_post1')->insert($post);
                        break;
                    case '2':
                        $enterprise = $request->input('enterprise_post');
                        foreach ($enterprise as $k => $v) {
                            $enterprise_data      = [];
                            $enterprise_data      = [
                                'rid'   => $id,
                                'label' => $v['label'],
                            ];
                            $eid                  = DB::table('recruit_enterprise')->insertGetId($enterprise_data);
                            $enterprise_post_data = [];
                            foreach ($v['children'] as $key => $value) {
                                $item = [];
                                $item = [
                                    'eid'  => $eid,
                                    'rid'  => $id,
                                    'code' => $value['code'],
                                    'name' => $value['name'],
                                ];
                                array_push($enterprise_post_data, $item);
                            }
                            DB::table('recruit_enterprise_post')->insert($enterprise_post_data);
                        }
                        break;
                }

                if ($id) {
                    $res['status'] = 1;
                    $res['msg']    = '新增成功';
                    $res['data']   = $id;
                    echo json_encode($res);
                } else {
                    $res['msg'] = '新增失败！';
                    echo json_encode($res);
                }
            }
        }

    }

    /**修改招考报名场次
     * @param Request $request
     */
    public function edit_recruit(Request $request)
    {
        if ($request->method() == "POST") {
            $input = $request->all();
            if (!array_key_exists('id', $input)) {
                $res['status'] = 0;
                $res['msg']    = '请指定要修改的招考数据';
                $res['data']   = '';
                echo json_encode($res);
            } else {
                $rules    = [
                    'name'      => 'required',
                    'start'     => 'required',
                    'end'       => 'required',
                    'status'    => 'required',
                    'post_data' => 'required',
                ];
                $messages = [
                    'name.required'      => '请填写招考名称',
                    'start.required'     => '请填写招考开始时间',
                    'end.required'       => '请填写招考结束时间',
                    'status.required'    => '请填写招考状态',
                    'post_data.required' => '请填写招聘岗位',
                ];

                $res       = [
                    'status' => 0,
                    'data'   => '',
                    'msg'    => '',
                ];
                $validator = Validator::make($input, $rules, $messages);
                if ($validator->fails()) {
                    $msg        = $validator->errors()->all();
                    $res['msg'] = $msg[0];
                    echo json_encode($res);
                } else {
                    $id   = $input['id'];
                    $data = [
                        'name'   => $input['name'],
                        'start'  => strtotime($input['start']),
                        'end'    => strtotime($input['end']),
                        'status' => $input['status'],
                    ];
                    DB::table('recruit')->where('id', $id)->update($data);
                    $post_data = $input['post_data'];
                    foreach ($post_data as $item) {
                        if (array_key_exists('id', $item)) {
                            DB::table('recruit_post1')->where('id', $item['id'])->update(['name' => $item['name'], 'code' => $item['code']]);
                        } else {
                            $item['rid'] = $id;
                            DB::table('recruit_post1')->insert($item);
                        }
                    }
                    $res = [
                        'status' => 1,
                        'data'   => '',
                        'msg'    => '更新招考数据成功',
                    ];
                    echo json_encode($res);
                }
            }
        } else {
            $id   = $request->input('id');
            $info = DB::table('recruit')->find($id);
            if (!$info) {
                $res = [
                    'status' => 0,
                    'data'   => '',
                    'msg'    => '找不到该记录，请刷新页面',
                ];
                echo json_encode($res);
            } else {
                $post = DB::table('recruit_post1')->where('rid', '=', $info->id)->get()->toArray();
                $item = [
                    'id'        => $info->id,
                    'name'      => $info->name,
                    'type'      => (string)$info->type,
                    'start'     => date("Y-m-d H:i:s", $info->start),
                    'end'       => date("Y-m-d H:i:s", $info->end),
                    'status'    => (string)$info->status,
                    'post_data' => $post,
                ];
                $res  = [
                    'status' => 1,
                    'data'   => $item,
                    'msg'    => '',
                ];
                echo json_encode($res);
            }
        }
    }

    /**
     * 获取招考的详细信息
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function get_recruit_detail(Request $request)
    {
        $res = $this->userCheck();
        if (!$res['ret']) {
            return response()->json($res);
        }
        $id     = $request->input('id');
        $title  = $request->input('title');
        $status = $request->input('status', 99);
        $page   = $request->input('page', 1);
        if (!$id) {
            $res = [
                'status' => 0,
                'data'   => [],
                'msg'    => '参数错误',
            ];
            return response()->json($res);
        }
        $where = [
            ['rid', $id],
        ];
        if (!empty($title)) {
            $where[] = ['realname', 'like', "%{$title}%"];
        }
        switch ($status) {
            case '0':
                $where[] = ['status', '=', 1];
                $where[] = ['check', '=', 0];
                break;
            case '1':
            case '2':
                $where[] = ['status', '=', 1];
                $where[] = ['check', '=', 1];
                break;
            default:
                $where[] = ['status', '=', 1];
                break;
        }

        $total = DB::table('recruit_entry')->where($where)->count();
        $list  = DB::table('recruit_entry')->where($where)->offset(10 * ($page - 1))->limit(10)->get()->toArray();
        $data  = [];
        if ($list) {
            foreach ($list as $k => $v) {
                $post = DB::table('recruit_post1')->find($v->post_id);
                $item = [
                    'id'       => $v->id,
                    'avatar'   => $v->avatar,
                    'realname' => $v->realname,
                    'sex'      => $v->sex == 1 ? '男' : '女',
                    'birthday' => date("Y-m-d", $v->birthday),
                    'phone'    => $v->mobile,
                    'email'    => $v->email,
                    'post'     => $post->code . ' ' . $post->name,
                    'word_url' => $v->word_url,
                ];
                array_push($data, $item);
            }
        }
        $res = [
            'status' => 1,
            'data'   => [
                'list'  => $data,
                'total' => $total,
            ],
            'msg'    => '',
        ];
        return response()->json($res);
    }

    /**
     * 查看某个报名的详细信息
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function get_user_recruit(Request $request)
    {
        $res = $this->userCheck();
        if (!$res['ret']) {
            return response()->json($res);
        }
        $id = $request->input('id');
        if (!$id) {
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '请指定报名数据',
            ];
            return response()->json($res);
        } else {
            $entry = DB::table('recruit_entry')->find($id);
            if (!$entry) {
                $res = [
                    'status' => 0,
                    'data'   => '',
                    'msg'    => '找不到对应的报名数据',
                ];
                return response()->json($res);
            } else {
                $entry->birthday   = date("Y-m-d", $entry->birthday);
                $entry->check_time = date("Y-m-d", $entry->check_time);
                switch ($entry->edu_type) {
                    case 1:
                        $entry->edu_type = '全日制教育';
                        break;
                    case 2:
                        $entry->edu_type = '在职教育';
                        break;
                    default:
                        break;
                }
                if (!empty($entry->work_approve)) {
                    $entry->work_approve = explode(',', $entry->work_approve);
                }
                if (!empty($entry->work_pro_img)) {
                    $entry->work_pro_img = explode(',', $entry->work_pro_img);
                }
                $family = DB::table('recruit_family')->where('eid', $entry->id)->get()->toArray();
                foreach ($family as $k => $v) {
                    $family[$k]->birthday = date("Y-m-d", $v->birthday);
                }
                $entry->family = $family;
                $entry->sex    = $entry->sex == 1 ? '男' : '女';
                $post          = DB::table('recruit_post1')->where('rid', $entry->rid)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');
                $entry->post   = $post[$entry->post_id];

                $res = [
                    'status' => 1,
                    'data'   => $entry,
                    'msg'    => '获取招考信息成功',
                ];
                return response()->json($res);
            }
        }
    }

    /**
     * 查看某个报名的详细信息（大学生实习专场）
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function get_user_internship(Request $request)
    {
        $user = parent::getLoginUser();
        if (!$user) {
            return response()->json(['isLogin' => 0, 'status' => 0, 'user' => null, 'msg' => '您尚未登录']);
        }

        $admin = ['59041', '164809', '164189', '164601'];
        if (!in_array($user->id, $admin)) {
            return response()->json(['isLogin' => 1, 'status' => 0, 'user' => null, 'msg' => '您没有权限', 'url' => 'http://www.jucai.gov.cn']);
        }
        $id = $request->input('id');
        if (!$id) {
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '请指定报名数据',
            ];
            return response()->json($res);
        } else {
            $entry = DB::table('recruit_internship')->find($id);
            if (!$entry) {
                $res = [
                    'status' => 0,
                    'data'   => '',
                    'msg'    => '找不到对应的报名数据',
                ];
                return response()->json($res);
            } else {
                $entry->birthday   = date("Y-m-d", $entry->birthday);
                $entry->check_time = date("Y-m-d", $entry->check_time);
                $entry->sex        = $entry->sex == 1 ? '男' : '女';
                $entry->adjust     = $entry->adjust == 1 ? '接受' : '不接受';
                switch ($entry->class) {
                    case '1':
                        $entry->class = '大三在校生';
                        break;
                    case '2':
                        $entry->class = '大四在校生';
                        break;
                    case '3':
                        $entry->class = '硕士在校生';
                        break;
                    case '4':
                        $entry->class = '博士在校生';
                        break;
                    default:
                        $entry->class = '';
                        break;
                }
//                $enterprise = DB::table('recruit_enterprise')->pluck('label','id');
//                $enterprise_post = DB::table('recruit_enterprise_post')->where('rid',$entry->rid)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');
//                $entry->enterprise = $enterprise[$entry->enterprise];
//                $entry->post = $enterprise_post[$entry->post];

                //$post = DB::table('recruit_post1')->where('rid',$entry->rid)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');
                //$entry->post = $post[$entry->post];


                $res = [
                    'status' => 1,
                    'data'   => $entry,
                    'msg'    => '获取招考信息成功',
                ];
                return response()->json($res);
            }
        }
    }

    /**
     * 报名信息的审核
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function check_user_recruit(Request $request)
    {

        $res = $this->userCheck();
        if (!$res['ret']) {
            return response()->json($res);
        }
        $id = $request->input('id');
        if (!$id) {
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '请指定审核数据',
            ];
            return response()->json($res);
        }
        $info = DB::table('recruit_entry')->where('id', $id)->first();
        if (!$info) {
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '指定审核的数据不存在',
            ];
            return response()->json($res);
        }

        $status = $request->input('status');
        if ($status) {
            //审核通过，生成word版简历
            $post    = DB::table('recruit_post1')->where('rid', $info->rid)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');
            $post    = $post[$info->post_id];
            $word    = [
                'data' => [
                    'realname'                => $info->realname,
                    'sex'                     => $info->sex == 1 ? '男' : '女',
                    'birthday'                => date("Y-m-d", $info->birthday),
                    'nation'                  => $info->nation,
                    'native_place'            => $info->native_place,
                    'post'                    => $post,
                    'political_attitudes'     => $info->political_attitudes,
                    'join_time'               => $info->join_time,
                    'titles'                  => $info->titles,
                    'work'                    => $info->work,
                    'house_register'          => $info->house_register,
                    'edu_type'                => $info->edu_type == 1 ? '全日制教育' : '在职教育',
                    'education'               => $info->education,
                    'school'                  => $info->school,
                    'degree'                  => $info->degree,
                    'pro'                     => $info->pro,
                    'address'                 => $info->address,
                    'card'                    => $info->card,
                    'mobile'                  => $info->mobile,
                    'email'                   => $info->email,
                    'concat_name'             => $info->concat_name,
                    'concat_mobile'           => $info->concat_mobile,
                    'resume'                  => $info->resume,
                    'training'                => $info->training,
                    'rewards_and_punishments' => $info->rewards_and_punishments,
                    'introduce'               => $info->introduce,
                ],
                'id'   => $info->id,
            ];
            $recruit = DB::table('recruit')->where('id', $info->rid)->first();
            $this->fetch_word($word, $info->avatar, $recruit->name);
            $data['status'] = 1;
            $data['check']  = 2;
            $this->smsService->sendSms($info->mobile, 'sms_register_success', []);
        } else {
            $data['status'] = 0;
            $data['check']  = 1;
            $this->smsService->sendSms($info->mobile, 'sms_register_fail', ['msg' => $request->input('remark')]);
        }
        $data['check_time'] = time();
        $data['remark']     = $request->input('remark');
        $data['ticket']     = $request->input('ticket', '');
        $data['seat']       = $request->input('seat', '');
        $data['ex_area']    = $request->input('ex_area', '');
        $data['ex_name']    = $request->input('ex_name', '');
        $data['ex_address'] = $request->input('ex_address', '');
        $data['ex_time']    = $request->input('ex_time', '');
        $data['ex_subject'] = $request->input('ex_subject', '');

        DB::table('recruit_entry')->where('id', $id)->update($data);
        $res = [
            'status' => 1,
            'data'   => [
                'id' => $info->rid,
            ],
            'msg'    => '审核成功',
        ];
        return response()->json($res);
    }

    /**
     * 大学生专用报名保存
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function internship_save(Request $request)
    {
        $user = parent::getLoginUser();
        if (!$user) {
            return response()->json(['isLogin' => 0, 'status' => 0, 'user' => null]);
        } else {
            $uid = $user->id;
        }
        if (time() > 1592904600) {
            return response()->json(['status' => 0, 'msg' => '报名已截止']);
        }
        //$uid = 1;
        $rules    = [
            'realname'            => 'required',
            'sex'                 => 'required',
            'birthday'            => 'required',
            'nation'              => 'required',
            'native_place'        => 'required',
            'political_attitudes' => 'required',
            'healthy'             => 'required',
            'mobile'              => 'required',
            'card'                => 'required',
            'school'              => 'required',
            'department'          => 'required',
            'pro'                 => 'required',
            'class'               => 'required',
            'concat_name'         => 'required',
            'concat_relationship' => 'required',
            'concat_mobile'       => 'required',
            'enterprise'          => 'required',
            'post'                => 'required',
            'code'                => 'required',
            'adjust'              => 'required',
            'edu'                 => 'required',
            'resume'              => 'required',
            'self_evaluation'     => 'required',
            'avatar'              => 'required',
            'front_card'          => 'required',
            'back_card'           => 'required',
            'student_img'         => 'required',
        ];
        $messages = [
            'realname.required'            => '请填写姓名',
            'sex.required'                 => '请填写性别',
            'birthday.required'            => '请填写出生日期',
            'nation.required'              => '请填写民族',
            'native_place.required'        => '请填写籍贯',
            'political_attitudes.required' => '请填写政治面貌',
            'healthy.required'             => '请输入健康状况',
            'mobile.required'              => '请填写手机号码',
            'card.required'                => '请填写身份证号码',
            'school.required'              => '请输入毕业院校',
            'department.required'          => '请输入院系',
            'pro.required'                 => '请输入专业',
            'class.required'               => '请选择年级',
            'concat_name.required'         => '请填写联系人姓名',
            'concat_relationship.required' => '请填写联系人关系',
            'concat_mobile.required'       => '请填写联系人手机号码',
            'enterprise'                   => '请填写报名单位',
            'post.required'                => '请填写报名岗位',
            'code'                         => '请填写岗位编号',
            'adjust.required'              => '请选择是否接受调剂',
            'edu.required'                 => '请填写学习经历',
            'resume.required'              => '请填写个人简历',
            'self_evaluation.required'     => '请简单做下自我评价',
            'avatar.required'              => '请上传1寸彩色免冠照',
            'front_card.required'          => '请上传身份证正面照',
            'back_card.required'           => '请上传身份证反面照',
            'student_img'                  => '请上传学生证',
        ];

        $res         = [
            'status' => 0,
            'data'   => '',
            'msg'    => '',
        ];
        $create_data = $request->all();
        $validator   = Validator::make($create_data, $rules, $messages);

        if ($validator->fails()) {
            $msg        = $validator->errors()->all();
            $res['msg'] = $msg[0];
            echo json_encode($res);
        } else {
            $data = $request->only('realname', 'sex', 'birthday', 'avatar', 'nation', 'native_place', 'political_attitudes', 'titles', 'healthy', 'school', 'department', 'pro', 'class', 'card', 'mobile', 'concat_name', 'concat_relationship', 'concat_mobile', 'adjust', 'resume', 'edu', 'self_evaluation', 'front_card', 'back_card', 'student_img', 'operation', 'rid', 'id', 'enterprise', 'post', 'code');
            //对入库数据处理
            $data['birthday'] = strtotime($data['birthday']);
            if ($data['operation'] == 2) {
                $data['status'] = 1;
                $data['check']  = 0;
                $msg            = '报名成功，请等待审核';
            } else {
                $data['status'] = 0;
                $msg            = '保存成功';
            }
            unset($data['operation']);
            if (array_key_exists('id', $data) && $data['id'] > 0) {
                //如果已经存在记录
                $id   = $data['id'];
                $info = DB::table('recruit_internship')->where('id', $id)->where('uid', $uid)->first();
                if (!$info) {
                    return response()->json(['status' => 0, 'msg' => '没有权限修改']);
                }
                unset($data['id']);
                DB::table('recruit_internship')->where('id', $id)->update($data);

            } else {
                $data['uid'] = $uid;
                $id          = DB::table('recruit_internship')->insertGetId($data);
            }

            $res = [
                'status' => 1,
                'data'   => $id,
                'msg'    => $msg,
            ];
            echo json_encode($res);
        }
    }

    /**
     * 报名信息的审核（大学生实习）
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function check_user_internship(Request $request)
    {
        $user = parent::getLoginUser();
        if (!$user) {
            return response()->json(['isLogin' => 0, 'status' => 0, 'user' => null, 'msg' => '您尚未登录']);
        }

        $admin = ['59041', '164809', '164189', '164601'];
        if (!in_array($user->id, $admin)) {
            return response()->json(['isLogin' => 1, 'status' => 0, 'user' => null, 'msg' => '您没有权限', 'url' => 'http://www.jucai.gov.cn']);
        }
        $id = $request->input('id');
        if (!$id) {
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '请指定审核数据',
            ];
            return response()->json($res);
        }
        $info = DB::table('recruit_internship')->where('id', $id)->first();
        if (!$info) {
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '指定审核的数据不存在',
            ];
            return response()->json($res);
        }

        $status = $request->input('status');
        if ($status) {
            $data['status'] = 1;
            $data['check']  = 2;
        } else {
            $data['status'] = 0;
            $data['check']  = 1;
        }
        $data['check_time'] = time();
        $data['remark']     = $request->input('remark', '');
        $data['ticket']     = $request->input('ticket', '');
        $data['seat']       = $request->input('seat', '');
        $data['ex_area']    = $request->input('ex_area', '');
        $data['ex_name']    = $request->input('ex_name', '');
        $data['ex_address'] = $request->input('ex_address', '');
        $data['ex_time']    = $request->input('ex_time', '');
        $data['ex_subject'] = $request->input('ex_subject', '');

        DB::table('recruit_internship')->where('id', $id)->update($data);
        $res = [
            'status' => 1,
            'data'   => [
                'id' => $info->rid,
            ],
            'msg'    => '审核成功',
        ];
        return response()->json($res);
    }

    /**
     * 大学生实习专场的详情
     * @param Request $request
     * @return \Illuminate\Http\JsonResponse
     */
    public function get_internship_detail(Request $request)
    {
        $user = parent::getLoginUser();
        if (!$user) {
            return response()->json(['isLogin' => 0, 'status' => 0, 'user' => null, 'msg' => '您尚未登录']);
        }

        $admin = ['59041', '164809', '164189', '164601'];
        if (!in_array($user->id, $admin)) {
            return response()->json(['isLogin' => 1, 'status' => 0, 'user' => null, 'msg' => '您没有权限', 'url' => 'http://www.jucai.gov.cn']);
        }

        $id     = $request->input('id');
        $title  = $request->input('title');
        $status = $request->input('status', 99);
        $page   = $request->input('page', 1);
        if (!$id) {
            $res = [
                'status' => 0,
                'data'   => [],
                'msg'    => '参数错误',
            ];
            return response()->json($res);
        }
        $where = [
            ['rid', $id],
        ];
        if (!empty($title)) {
            $where[] = ['realname', 'like', "%{$title}%"];
        }
        if ($status != "99") {
            if ($status) {
                $where[] = ['check', '>', 0];
            } else {
                $where[] = ['check', '=', 0];
            }
        }

        $total = DB::table('recruit_internship')->where($where)->count();
        $list  = DB::table('recruit_internship')->where($where)->offset(10 * ($page - 1))->limit(10)->get()->toArray();
        $data  = [];
        if ($list) {
//            $enterprise = DB::table('recruit_enterprise')->pluck('label', 'id');
//            $enterprise_post = DB::table('recruit_enterprise_post')->where('rid',$id)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');
            foreach ($list as $k => $v) {
                $item = [
                    'id'         => $v->id,
                    'avatar'     => $v->avatar,
                    'realname'   => $v->realname,
                    'sex'        => $v->sex == 1 ? '男' : '女',
                    'birthday'   => date("Y-m-d", $v->birthday),
                    'phone'      => $v->mobile,
                    'school'     => $v->school,
                    'department' => $v->department,
                    'pro'        => $v->pro,
                    'enterprise' => $v->enterprise,
                    'post'       => $v->post,
                ];
                switch ($v->class) {
                    case '1':
                        $item['class'] = '大三在校生';
                        break;
                    case '2':
                        $item['class'] = '大四在校生';
                        break;
                    case '3':
                        $item['class'] = '硕士在校生';
                        break;
                    case '4':
                        $item['class'] = '博士在校生';
                        break;
                    default:
                        $item['class'] = '';
                        break;
                }
//                $item['enterprise'] = $enterprise[$v->enterprise];
//                $item['post'] = $enterprise_post[$v->post];
                array_push($data, $item);
            }
        }
        $res = [
            'status' => 1,
            'data'   => [
                'list'  => $data,
                'total' => $total,
            ],
            'msg'    => '',
        ];
        exit(json_encode($res));
    }

    public function get_sign_form(Request $request)
    {
        $id = $request->input('id');
        if (!$id) {
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '请指定考场',
            ];
            return response()->json($res);
        }
        $info = DB::table('recruit')->find($id);
        if (!$info) {
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '找不到该记录，请刷新页面',
            ];
            return response()->json($res);
        } else {
            $alias = $info->alias;
            $list  = DB::table('recruit_' . $alias)->where('rid', $id)->where('ticket', '!=', '')->orderByRaw('seat+0 asc')->get();

            $res = [
                'status' => 1,
                'data'   => $list,
                'msg'    => '查询成功',
            ];
            return response()->json($res);
        }
    }

    public function fetch_word($data = null, $avatar = '', $title = '')
    {
        if ($data != null) {
            //指定模板文件
            $templateProcessor = new TemplateProcessor(base_path() . '/public/word/example.docx');
            //通过setValue 方法给模板赋值
            $templateProcessor->setValue('title', $title);
            $data['data']['resume']                  = str_replace("\r\n", '<w:br/>', $data['data']['resume']);
            $data['data']['training']                = str_replace("\r\n", '<w:br/>', $data['data']['training']);
            $data['data']['rewards_and_punishments'] = str_replace("\r\n", '<w:br/>', $data['data']['rewards_and_punishments']);
            $data['data']['introduce']               = str_replace("\r\n", '<w:br/>', $data['data']['introduce']);
            foreach ($data['data'] as $k => $v) {
                $templateProcessor->setValue($k, $v);
            }
            $family = DB::table('recruit_family')->where('eid', $data['id'])->get()->toArray();
            if ($family) {
                $count = count($family);
                $templateProcessor->cloneRow('family_appellation', $count);
                $i = 1;
                foreach ($family as $k => &$v) {
                    $templateProcessor->setValue('family_appellation#' . $i, $v->appellation);
                    $templateProcessor->setValue('family_realname#' . $i, $v->realname);
                    $templateProcessor->setValue('family_birthday#' . $i, date("Y-m-d", $v->birthday));
                    $templateProcessor->setValue('family_political_attitudes#' . $i, $v->political_attitudes);
                    $templateProcessor->setValue('family_work#' . $i, $v->work);
                    $i++;
                }
            }
            $templateProcessor->setImageValue('avatar', ['src' => $avatar]);
            $filename = uniqid();
            $word_url = "/word/{$filename}.docx";
            DB::table('recruit_entry')->where('id', $data['id'])->update(['word_url' => $word_url]);
            $templateProcessor->saveAs(base_path() . '/public' . $word_url);//另存为
        }
    }

    public function word_to_zip()
    {

    }

    public function strtotime($time)
    {
        $result = strtotime($time);
        if (empty($result)) {
            $date   = new \DateTime($time);
            $result = $date->format('U');
        }
        return $result;
    }

    public function date($utc_time)
    {
        $mydate2 = new \DateTime('@' . $utc_time);
        return $mydate2->format('Y-m-d');
    }

    public function export(Request $request)
    {
        $res = $this->userCheck();
        if (!$res['ret']) {
            return response()->json($res);
        }
        $rid     = $request->input('rid');
        $recruit = DB::table('recruit')->find($rid);
        if (!$recruit) {
            throw new ResponseException('指定的招聘场次不存在！', [], 404);
        }
        $post = DB::table('recruit_post1')->where('rid', $rid)->selectRaw('id, CONCAT(code," ",name) as post')->pluck('post', 'id');
        if (!$post) {
            throw new ResponseException('招聘岗位丢失，请检查！', [], 404);
        }
        $list = DB::table('recruit_entry')->where('rid', $rid)->orderBy('id', 'desc')->get()->toArray();
        if (!$list) {
            throw new ResponseException('太遗憾了，还没有人报名！', [], 404);
        }
        foreach ($list as &$item) {
            $item->post = $post[$item->post_id];
            $family     = DB::table('recruit_family')->where('eid', $item->id)->get()->toArray();
            $family_arr = [];
            foreach ($family as $k => $v) {
                $birthday = date("Y-m-d", $v->birthday);
                $str      = "{$v->appellation} {$v->realname} {$birthday} {$v->political_attitudes} {$v->work}";
                array_push($family_arr, $str);
            }
            $item->family = implode("\r\n", $family_arr);
        }
        $spreadsheet = new Spreadsheet();
        $sheet       = $spreadsheet->getActiveSheet();
        $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;//再将新变量加入到数组里

        foreach ($list as $item) {
            $sheet->setCellValueByColumnAndRow(1, $row, $item->realname);
            $sheet->setCellValueByColumnAndRow(2, $row, $item->sex == 0 ? '女' : '男');
            $sheet->setCellValueByColumnAndRow(3, $row, date("Y-m-d", $item->birthday));
            $sheet->setCellValueByColumnAndRow(4, $row, $item->avatar);
            $sheet->setCellValueByColumnAndRow(5, $row, $item->nation);
            $sheet->setCellValueByColumnAndRow(6, $row, $item->native_place);
            $sheet->setCellValueByColumnAndRow(7, $row, $item->post);
            $sheet->setCellValueByColumnAndRow(8, $row, $item->political_attitudes);
            $sheet->setCellValueByColumnAndRow(9, $row, $item->join_time);
            $sheet->setCellValueByColumnAndRow(10, $row, $item->titles);
            $sheet->setCellValueByColumnAndRow(11, $row, $item->work);
            $sheet->setCellValueByColumnAndRow(12, $row, $item->house_register);
            $sheet->setCellValueByColumnAndRow(13, $row, $item->edu_type == 1 ? '全日制教育' : '在职教育');
            $sheet->setCellValueByColumnAndRow(14, $row, $item->education);
            $sheet->setCellValueByColumnAndRow(15, $row, $item->school);
            $sheet->setCellValueByColumnAndRow(16, $row, $item->degree);
            $sheet->setCellValueByColumnAndRow(17, $row, $item->pro);
            $sheet->setCellValueByColumnAndRow(18, $row, $item->address);
            $sheet->setCellValueExplicitByColumnAndRow(19, $row, $item->card, DataType::TYPE_STRING);
            $sheet->setCellValueExplicitByColumnAndRow(20, $row, $item->mobile, DataType::TYPE_STRING);
            $sheet->setCellValueByColumnAndRow(21, $row, $item->email);
            $sheet->setCellValueByColumnAndRow(22, $row, $item->concat_name);
            $sheet->setCellValueExplicitByColumnAndRow(23, $row, $item->concat_mobile, DataType::TYPE_STRING);
            $sheet->setCellValueByColumnAndRow(24, $row, $item->resume);
            $sheet->setCellValueByColumnAndRow(25, $row, $item->training);
            $sheet->setCellValueByColumnAndRow(26, $row, $item->rewards_and_punishments);
            $sheet->setCellValueByColumnAndRow(27, $row, $item->introduce);
            $sheet->setCellValueByColumnAndRow(28, $row, $item->family);
            $sheet->setCellValueByColumnAndRow(29, $row, $item->front_card);
            $sheet->setCellValueByColumnAndRow(30, $row, $item->back_card);
            $sheet->setCellValueByColumnAndRow(31, $row, $item->diploma_img);
            $sheet->setCellValueByColumnAndRow(32, $row, $item->degree_img);
            $sheet->setCellValueByColumnAndRow(33, $row, $item->xuexin_img);
            $sheet->setCellValueByColumnAndRow(34, $row, $item->work_pro_img);
            $sheet->setCellValueByColumnAndRow(35, $row, $item->work_approve);
            if ($item->status == 0) {
                if ($item->check == 0) {
                    $status = '只是暂存，尚未提交';
                } else {
                    $status = '审核未通过';
                }
            } else {
                if ($item->check == 0) {
                    $status = '待审核';
                } else {
                    $status = '审核通过';
                }

            }
            $sheet->setCellValueByColumnAndRow(36, $row, $status);
            $sheet->setCellValueByColumnAndRow(37, $row, $item->remark);
            $sheet->setCellValueByColumnAndRow(38, $row, empty($item->word_url) ? '' : "http://www.jucai.gov.cn/" . $item->word_url);
            $sheet->setCellValueByColumnAndRow(38, $row, $item->ticket_status == 0 ? '未打印' : "已打印");
            $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');


    }

    public function look_ticket(Request $request)
    {
        $user = $this->getSignupUser();
        $uid  = $user->id;
        DB::table('recruit_entry')->where('uid', $uid)->update(['ticket_status' => 1]);
    }

    public function ticket_download(Request $request)
    {
        $user = $this->getSignupUser();
        $uid  = $user->id;
        $info = DB::table('recruit_entry')->where('uid',$uid)->where('rid',6)->first();
        $ticket = DB::table('wy_face')->where('card',$info->card)->first();
        if($ticket){
            $res = [
                'status' => 1,
                'data'   => '/pdf/wyticket_' . $ticket->realname . '_' . $ticket->card.'_' . $ticket->post . '.pdf',
                'msg'    => '查询成功',
            ];
            return response()->json($res);
        }else{
            $res = [
                'status' => 0,
                'data'   => '',
                'msg'    => '暂无面试准考证需打印',
            ];
            return response()->json($res);
        }
    }
}