jucai/app/Admin/Controllers/Jobfairout/JobfairoutController.php

<?php

namespace App\Admin\Controllers\Jobfairout;

use App\Http\Controllers\Controller;
use App\Models\Jobfairout\Jobfairout;
use App\Models\Jobfairout\JobfairoutCompany;
use App\Models\Jobfairout\JobfairoutFeedback;
use App\Models\Jobfairout\JobfairoutPutJob;
use App\Models\Jobfairout\JobfairoutReserve;
use App\Models\Jobfairout\JobfairoutSchool;
use App\Models\SubsiteJobfairout;
use App\Admin\Exports\Jobfairout\PersonExport;
use App\Admin\Exports\Jobfairout\JobsExport;
use App\Admin\Exports\Jobfairout\FeedbackExport;
use App\Models\Subsite;
use Encore\Admin\Controllers\HasResourceActions;
use Encore\Admin\Facades\Admin;
use Encore\Admin\Form;
use Encore\Admin\Grid;
use Encore\Admin\Layout\Content;
use Encore\Admin\Show;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
class JobfairoutController extends Controller
{
    use HasResourceActions;

    /**
     * Index interface.
     *
     * @param Content $content
     * @return Content
     */
    public function index(Content $content)
    {
        return $content
            ->header('赴外招聘会列表')
            ->description('')
            ->body($this->grid());
    }

    /**
     * Show interface.
     *
     * @param mixed $id
     * @param Content $content
     * @return Content
     */
    public function show($id, Content $content)
    {
//        dd(\request()->route());
        return $content
            ->header('招聘会详情')
            ->description('')
            ->body($this->detail($id));
    }

    /**
     * Edit interface.
     *
     * @param mixed $id
     * @param Content $content
     * @return Content
     */
    public function edit($id, Content $content)
    {
        return $content
            ->header('赴外招聘会编辑')
            ->description('')
            ->body(view('admin.jobfairout.jobfairout')->with(['content'=>$this->editForm($id)])->render());
    }

    /**
     * Create interface.
     *
     * @param Content $content
     * @return Content
     */
    public function create(Content $content)
    {
        return $content
            ->header('赴外招聘会创建')
            ->description('带*号必填项')
            ->body(view('admin.jobfairout.jobfairout')->with(['content'=>$this->createForm()])->render());
    }

    /**
     * Make a grid builder.
     *
     * @return Grid
     */
    protected function grid()
    {
        $grid = new Grid(new Jobfairout);

        $grid->model()->when(get_subsite_id()>0, function ($query) {
            $query->where('subsite_id',get_subsite_id());
        })->orderBy('id', 'desc');

        $grid->holddate_start('举办时间')->display(function ($holddate_start) {
            return "<span style='color:#009900'>".date('Y-m-d H:i', $holddate_start)."&nbsp;至&nbsp;".date('Y-m-d H:i', $this->holddate_end)."</span>";
        });
        $grid->title('招聘会标题')->display(function ($title) {
            return "<a target='_blank' href='".route('jobfairout.show.com',$this->id)."'>".$title."</a>";
        })->width(300);

        $grid->type('赴外类型')->display(function ($type) {
            return $type==1?'本市':'赴外';
        });

        $grid->predetermined_status('预定状态')->display(function ($predetermined_status) {
            if ($predetermined_status==1) {
                if($this->predetermined_end > time()  && $this->predetermined_start < time()){
                    return "允许预订";
                }elseif($this->predetermined_start > time()){
                    return "未开始";
                }else{
                    return "停止预订";
                }
            } else {
                return "停止预订";
            }
        });

        $grid->mstatus('预定情况')->display(function () {
            $standSuccess = JobfairoutCompany::where(['audit'=>1,'jobfair_id'=>$this->id])->count();
            $standAudit = JobfairoutCompany::where(['audit'=>2,'jobfair_id'=>$this->id])->count();
            $standFree = $this->number - $standSuccess - $standAudit;
            return '<span class="vtip" title="空闲展位数" style="color:#000000;padding-right:10px">['.$standFree.']</span>
		            <span class="vtip" title="审核中展位数" style="color:#FFCC33;padding-right:10px">['.$standAudit.']</span>
		            <span class="vtip" title="预定成功展位数" style="color:#CC00CC;padding-right:10px">['.$standSuccess.']</span>
		            <span class="vtip" title="展位总数" style="color:#3300FF;padding-right:10px">['.$this->number.']</span>';
        });
        $grid->showendtime('显示截止时间')->display(function ($showendtime) {
            return $showendtime ? date('Y-m-d H:i:s', $showendtime) : '不限制';
        });

        if(get_subsite_id() == 0 && get_subsite_open()){
            $grid->subsite_id('所属分站')->display(function ($subsite_id) {
                if ($subsite_id) {
                    $Subsite = Subsite::find($subsite_id);
                    return isset($Subsite->sitename) ? $Subsite->sitename : '未知';
                }
                return '总站';
            });
        }

        $grid->created_at('创建时间');
        $grid->actions(function ($actions) use ($grid) {
            if (Admin::user()->can('jobfairout_index_person')) {
                $actions->append('<button class="btn btn-primary btn-xs poster" title="导出参会人" onclick="window.open(\''.route('jobfairout.export.person',['id'=>$actions->row['id']]).'\')" >导出参会人</button>');
            }
            if (Admin::user()->can('jobfairout_index_jobs')) {
                $actions->append('<button class="btn btn-primary btn-xs jobs" title="导出职位" onclick="window.open(\''.route('jobfairout.export.jobs',['id'=>$actions->row['id']]).'\')" >导出职位</button>');
            }
            if (Admin::user()->can('jobfairout_index_feedback')) {
                $actions->append('<button class="btn btn-primary btn-xs feedback" title="导出反馈表" onclick="window.open(\'' . route('jobfairout.export.feedback', ['id' => $actions->row['id']]) . '\')" >导出反馈表</button>');
            }
            if (Admin::user()->can('jobfairout_index_poster')) {
                $actions->append('<button class="btn btn-primary btn-xs poster" title="查看海报" onclick="window.open(\'' . route('jobfairout.poster', ['id' => $actions->row['id']]) . '\')" >查看海报</button>');
            }
            if (Admin::user()->can('jobfairout_index_edit') && (get_subsite_id() == 0 || $actions->row['subsite_id']== get_subsite_id())) {
                $actions->disableEdit(false);
            }
            if (Admin::user()->can('jobfairout_index_delete') && (get_subsite_id() == 0 || $actions->row['subsite_id']== get_subsite_id())) {
                $actions->disableDelete(false);
            }
        });

        $grid->filter(function ($filter) {
            $filter->like('title', '招聘会标题');

            $filter->equal('type', '招聘会类型')->select(['1'=>'本市','2'=>'赴外']);

            $filter->equal('predetermined_status', '预定状态')->select([
                1  => '允许预订',
                2  => '停止预订',
            ]);
            $filter->between('created_at', '创建时间')->datetime();
            if(get_subsite_id() == 0 && get_subsite_open()){
                $filter->equal('subsite_id', '所属分站')->select(array_column(get_all_subsite(), 'sitename', 'id'));
            }
        });
        if (Admin::user()->can('jobfairout_index_create')) {
            $grid->disableCreateButton(false);
        }
        return $grid;
    }

    /**
     * Make a show builder.
     *
     * @param mixed $id
     * @return Show
     */
    protected function detail($id)
    {
        $show = new Show(Jobfairout::findOrFail($id));

        $show->id('ID');

        $show->holddate_start('举办时间')->as(function ($holddate_start) {
            return date('Y-m-d H:i:s', $holddate_start).'至'.date('Y-m-d H:i:s', $this->holddate_end);
        });
        $show->title('招聘会标题')->as(function ($title) {
            return $title;
        });
        $show->type('招聘会类型')->as(function ($type) {
            return $type==1?'本市':'赴外';
        });

        $show->predetermined_status('预定状态')->as(function ($predetermined_status) {
            if ($predetermined_status==1) {
                if($this->predetermined_end > time()  && $this->predetermined_start < time()){
                    return "允许预订";
                }elseif($this->predetermined_start > time()){
                    return "未开始";
                }else{
                    return "停止预订";
                }
            } else {
                return "停止预订";
            }
        });

        $show->showendtime('显示截止时间')->as(function ($showendtime) {
            return $showendtime ? date('Y-m-d H:i:s', $showendtime) : '不限制';
        });

        $show->subsite_id('所属分站')->as(function ($subsite_id) {
            if ($subsite_id) {
                $Subsite = Subsite::find($subsite_id);
                return isset($Subsite->sitename) ? $Subsite->sitename : '未知';
            }
            return '总站';
        });
        $show->created_at('创建时间');
        $show->updated_at('更新时间');
        return $show;
    }

    protected function createForm()
    {
        $form = new Form(new Jobfairout);
        $form->tab('基本信息',function ($form){
            $form->text('title', '招聘会标题')->placeholder('如：2017年5月1日(星期六)医药行业主题招聘会')->default(session('content')['title'])->setMustMark();
            $form->text('industry', '行业主题')->default(session('content')['industry']);
            $form->url('url', '招聘会链接地址')->default(session('content')['url']);
            $form->number('number', '展位数量')->min(1)->default(1)->help('展位数量');
            $form->text('contact', '联系人')->default(session('content')['contact'])->setMustMark();
            $form->text('phone', '联系电话')->default(session('content')['phone'])->help('多个号码请用英文半角“,”隔开!')->setMustMark();
            $form->select('type', '赴外类型')->options(['1'=>'本市','2'=>'赴外'])->default(session('content')['type'] ? session('content')['type'] : 1);
            if (get_subsite_id()==0) {
                $subsites = Subsite::where(array('effective'=>1))->orderBy('order', 'asc')->get()->pluck('sitename', 'id')->toArray();
            } else {
                $subsites = Subsite::where(array(array('effective','=',1),array('id','<>', get_subsite_id())))->orderBy('order', 'asc')->get()->pluck('sitename', 'id')->toArray();
                $subsites[0] = '总站';
            }
            if ($subsites && get_subsite_open()) {
                $form->multipleSelect('subsites', '同步分站')->options($subsites);
            }
            $form->hidden('subsite_id')->value(get_subsite_id());
            $form->editor('jobfair_introduction', '招聘会简介')->default(session('content')['jobfair_introduction'])->setMustMark();
        })->tab('举办信息',function ($form){
            $form->datetime('holddate_start', '举办开始时间')->format('YYYY-MM-DD HH:mm:ss')->default(session('content')['holddate_start'])->setMustMark();
            $form->datetime('holddate_end', '举办结束时间')->format('YYYY-MM-DD HH:mm:ss')->default(session('content')['holddate_end'])->setMustMark();
            $form->datetime('predetermined_start', '预定开始时间')->format('YYYY-MM-DD HH:mm:ss')->default(session('content')['predetermined_start'])->setMustMark();
            $form->datetime('predetermined_end', '预定结束时间')->format('YYYY-MM-DD HH:mm:ss')->default(session('content')['predetermined_end'])->setMustMark();
            $form->datetime('showendtime', '显示截止时间')->format('YYYY-MM-DD HH:mm:ss')->help('不填不限制')->default(session('content')['showendtime']);
            $schools = JobfairoutSchool::pluck('name', 'id')->toArray();
            $form->multipleSelect('school_id', '选择高校')->options($schools);
            $form->text('address', '举办地址')->default(session('content')['address'])->setMustMark();
            $form->html('<div id="searchResultPanel" style="border:1px solid #C0C0C0;height:100px; display:none;"></div>');
            $form->html(' <div class="fr">
            <input name="map_x" type="hidden" id="x" value="'.subsite_config('aix.system.map.map.map_x').'">
            <input name="map_y" type="hidden" id="y" value="'.subsite_config('aix.system.map.map.map_y').'">
            <input name="map_zoom" type="hidden" id="zoom" value="'.subsite_config('aix.system.map.map.max_level').'">
            <div class="form-control" style=height:380px;border:1px solid  #CCCCCC; cursor: pointer;" id="container"></div></div>', '地图标注')->setMustMark();
        })->tab('设置',function ($form){
            $form->radio('display', '显示状态')->options([1=>'正常',2=>'暂停'])->default(1);
            $form->radio('predetermined_status', '预定状态')->options([1=>'允许预订',2=>'停止预订'])->default(1);
            $form->radio('is_commonweal', '招聘会')->options([1=>'场次',2=>'积分',3=>'公益'])->default(3)->help('选择公益招聘会,企业预订免费!')->attribute('class', "is_commonweal");
            $form->number('predetermined_point', '预定消耗积分')->min(1)->default(100)->help('选择积分招聘会,企业预订则抵扣积分!');
            $form->number('jobsfair_num', '预定消耗场次')->min(1)->default(1)->help('选择场次招聘会,企业预订则抵扣场次!');
            $form->number('nosign_point', '未签到扣减积分')->min(1)->default(300)->help('单位：积分');
            $form->number('late_point', '迟到早退扣减积分')->min(1)->default(100)->help('单位：积分');
            $form->number('ordid', '排序')->min(0)->default(0)->help('数字越大，排序越靠前');
        });
        $form->disableReset();
        return $form->render();
    }

    /**
     * Make a form builder.
     *
     * @return Form
     */
    protected function editForm($id)
    {
        $Jobfair = Jobfairout::findOrFail($id);
        $form = new Form(new Jobfairout());
        $form->hidden('id')->default($Jobfair->id);
        $form->tab('基本信息',function ($form) use($Jobfair,$id){
            $form->text('title', '招聘会标题')->placeholder('如：2017年5月1日(星期六)医药行业主题招聘会')->default($Jobfair->title)->setMustMark();
            $form->text('industry', '行业主题')->default($Jobfair->industry);
            $form->url('url', '招聘会链接地址')->default($Jobfair->url);
            $form->number('number', '展位数量')->min(1)->default($Jobfair->number)->help('展位数量');
            $form->text('contact', '联系人')->default($Jobfair->contact)->setMustMark();
            $form->text('phone', '联系电话')->default($Jobfair->phone)->help('多个号码请用英文半角“,”隔开!')->setMustMark();
            $form->select('type', '赴外类型')->options(['1'=>'本市','2'=>'赴外'])->default($Jobfair->type);
            if ($Jobfair->subsite_id==0) {
                $subsites = Subsite::where(array('effective'=>1))->orderBy('order', 'asc')->get()->pluck('sitename', 'id')->toArray();
            } else {
                $subsites = Subsite::where(array(array('effective','=',1),array('id','<>', $Jobfair->subsite_id)))->orderBy('order', 'asc')->get()->pluck('sitename', 'id')->toArray();
                $subsites[0] = '总站';
            }
            if ($subsites && get_subsite_open()) {
                $relations = SubsiteJobfairout::where(array('jobfair_id'=>$id))->get()->pluck('subsite_id')->toArray();
                $form->multipleSelect('subsite_id', '同步分站')->options($subsites)->default($relations);
            }
            $form->editor('jobfair_introduction', '招聘会简介')->default($Jobfair->jobfair_introduction)->setMustMark();
        })->tab('举办信息',function ($form) use($Jobfair){
            $form->datetime('holddate_start', '举办开始时间')->format('YYYY-MM-DD HH:mm:ss')->default($Jobfair->holddate_start ? date('Y-m-d H:i:s', $Jobfair->holddate_start) : '')->setMustMark();
            $form->datetime('holddate_end', '举办结束时间')->format('YYYY-MM-DD HH:mm:ss')->default($Jobfair->holddate_end ? date('Y-m-d H:i:s', $Jobfair->holddate_end) : '')->setMustMark();
            $form->datetime('predetermined_start', '预定开始时间')->format('YYYY-MM-DD HH:mm:ss')->default($Jobfair->predetermined_start ? date('Y-m-d H:i:s', $Jobfair->predetermined_start) : '')->setMustMark();
            $form->datetime('predetermined_end', '预定结束时间')->format('YYYY-MM-DD HH:mm:ss')->default($Jobfair->predetermined_end ? date('Y-m-d H:i:s', $Jobfair->predetermined_end) : '')->setMustMark();
            $form->datetime('showendtime', '显示截止时间')->format('YYYY-MM-DD HH:mm:ss')->default($Jobfair->showendtime ? date('Y-m-d H:i:s', $Jobfair->showendtime) : '')->help('不填不限制');
            $schools = JobfairoutSchool::pluck('name', 'id')->toArray();
            $form->multipleSelect('school_id', '选择高校')->options($schools)->default(explode(',',$Jobfair->school_id));
            $form->text('address', '举办地址')->default($Jobfair->address)->setMustMark();
            $form->html('<div id="searchResultPanel" style="border:1px solid #C0C0C0;height:100px; display:none;"></div>');
            $map_x = $Jobfair->map_x ? $Jobfair->map_x : subsite_config('aix.system.map.map.map_x');
            $map_y = $Jobfair->map_y ? $Jobfair->map_y : subsite_config('aix.system.map.map.map_y');
            $form->html(' <div class="fr">
            <input name="map_x" type="hidden" id="x" value="'.$map_x.'">
            <input name="map_y" type="hidden" id="y" value="'.$map_y.'">
            <input name="map_zoom" type="hidden" id="zoom" value="'.subsite_config('aix.system.map.map.max_level').'">
            <div class="form-control" style="height:380px;border:1px solid  #CCCCCC; cursor: pointer;" id="container"></div>
        </div>', '地图标注')->setMustMark();
        })->tab('设置',function ($form) use($Jobfair){
            $form->radio('display', '显示状态')->options([1=>'正常',2=>'暂停'])->default($Jobfair->display);
            $form->radio('predetermined_status', '预定状态')->options([1=>'允许预订',2=>'停止预订'])->default($Jobfair->predetermined_status);
            $form->radio('is_commonweal', '招聘会')->options([1=>'场次',2=>'积分',3=>'公益'])->default($Jobfair->is_commonweal)->help('选择公益招聘会,企业预订免费!')->attribute('class', "is_commonweal");
            $form->number('predetermined_point', '预定消耗积分')->min(1)->default($Jobfair->predetermined_point)->help('选择积分招聘会,企业预订则抵扣积分!');
            $form->number('jobsfair_num', '预定消耗场次')->min(1)->default($Jobfair->jobsfair_num)->help('选择场次招聘会,企业预订则抵扣场次!');
            $form->number('nosign_point', '未签到扣减积分')->min(1)->default($Jobfair->nosign_point)->help('单位：积分');
            $form->number('late_point', '迟到早退扣减积分')->min(1)->default($Jobfair->late_point)->help('单位：积分');
            $form->number('ordid', '排序')->min(0)->default($Jobfair->ordid)->help('数字越大，排序越靠前');
            $form->hidden('_method')->default('put');
        });
        $form->disableReset();
        return $form->render();
    }

    public function store(Request $request)
    {
        $request->validate([
            'title' => 'required',
            'number' => 'required|integer',
            'holddate_start' => 'required',
            'holddate_end' => 'required',
            'predetermined_start' => 'required',
            'predetermined_end' => 'required',
            'address' => 'required', //举办地址。
            'contact' => 'required',
            'phone' => 'required|max:100',
            'jobfair_introduction' => 'required',
        ],[
            'title.required'=>'请填写标题',
            'number.required'=>'请填写展位数量',
            'number.integer'=>'展位数量必须为数字',
            'holddate_start.required'=>'请填写举办开始时间',
            'holddate_end.required'=>'请填写举办结束时间',
            'predetermined_start.required'=>'请填写预定开始时间',
            'predetermined_end.required'=>'请填写预定结束时间',
            'areaid.required'=>'请填写举办场地',
            'address.required'=>'请填写举办地址',
            'contact.required'=>'请填写联系人',
            'phone.required'=>'请填写联系方式',
            'phone.max'=>'联系方式最多不超过100字',
            'jobfair_introduction.required'=>'请填写简介',
        ]);
        if ( preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->holddate_start) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->holddate_end) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->predetermined_start) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->predetermined_end) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->showendtime) ) {
            admin_toastr('举办/预定时间不能含有中文！', 'error');
            return back()->with(['content'=>$request->all()]);
        }

        if ( preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->phone) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->predetermined_point) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->jobsfair_num) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->nosign_point) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->late_point) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->ordid) ) {
            admin_toastr('积分/场次/联系电话不能含有中文！', 'error');
            return back()->with(['content'=>$request->all()]);
        }
        foreach (explode(',',$request->phone) as $value){
            if(!(preg_match ('/^1[3-9]{1}[0-9]{9}$/', $value) || preg_match ('/^([0-9]{3,4}-)?[0-9]{7,8}$/', $value))){
                admin_toastr('请输入正确的联系电话', 'error');
                return back()->with(['content'=>$request->all()]);
            }
        }

        if ($request->holddate_start >= $request->holddate_end) {
            admin_toastr('举办开始时间不能大于结束时间!!', 'error');
            return back()->with(['content'=>$request->all()]);
        }
        if ($request->predetermined_start >= $request->holddate_start) {
            admin_toastr('预订开始时间不能大于举办开始时间!!', 'error');
            return back()->with(['content'=>$request->all()]);
        }
        if ($request->predetermined_start >= $request->predetermined_end) {
            admin_toastr('预订开始时间不能大于结束时间!!', 'error');
            return back()->with(['content'=>$request->all()]);
        }
        if ($request->predetermined_end > $request->holddate_end) {
            admin_toastr('预订结束时间不能大于举办结束时间!!', 'error');
            return back()->with(['content'=>$request->all()]);
        }
        $jobfairout = [];
        $jobfairout['title'] = $request->title;
        $jobfairout['industry'] = $request->industry;
        $jobfairout['holddate_start'] = strtotime($request->holddate_start);
        $jobfairout['holddate_end'] = strtotime($request->holddate_end);
        $jobfairout['type'] = $request->type;
        $jobfairout['showendtime'] = strtotime($request->showendtime);
        $jobfairout['address'] = $request->address;
        $jobfairout['contact'] = $request->contact;
        $apiAddress = $this->apiAddress($request->address);
        if (!$apiAddress) {
            admin_toastr('请添加地图标注!!', 'error');
            return back()->with(['content'=>$request->all()]);
        }
        $jobfairout['map_x'] = $apiAddress['lng'];
        $jobfairout['map_y'] = $apiAddress['lat'];
        $jobfairout['phone'] = $request->phone;
        $jobfairout['display'] = $request->display;
        $jobfairout['is_commonweal'] = $request->is_commonweal;
        $jobfairout['predetermined_point'] = $request->predetermined_point;
        $jobfairout['jobsfair_num'] = $request->jobsfair_num;
        $jobfairout['nosign_point'] = $request->nosign_point;
        $jobfairout['late_point'] = $request->late_point;
        $jobfairout['ordid'] = $request->ordid;
        $jobfairout['number'] = $request->number;
        $jobfairout['jobfair_introduction'] = $request->jobfair_introduction;
        $jobfairout['subsite_id'] = get_subsite_id();
        $jobfairout['predetermined_status'] = $request->predetermined_status;
        $jobfairout['predetermined_start'] = $request->predetermined_start ? strtotime($request->predetermined_start) : $request->predetermined_start;
        $jobfairout['predetermined_end'] = $request->predetermined_end ? strtotime($request->predetermined_end) : $request->predetermined_end;
        $school_id = array_filter($request->school_id);
        $jobfairout['school_id'] = implode(',',$school_id);
        $jobfairout['url'] = $request->url;
        DB::beginTransaction();
        try {
            $Jobfair = Jobfairout::create($jobfairout);
            $subsites = \Illuminate\Support\Facades\Request::input('subsites');
            if (get_subsite_id() == 0 && $subsites) {
                $subsites = array_merge(array(get_subsite_id()), $subsites);
            } else {
                $subsites = array(get_subsite_id());
            }
            $set_data = array();
            foreach ($subsites as $k => $v) {
                if ($v !== null) {
                    $set_data[] = array(
                        'jobfair_id' => $Jobfair->id,
                        'subsite_id'=> $v,
                        'created_at'=>date('Y-m-d H:i:s'),
                        'updated_at'=>date('Y-m-d H:i:s'),
                    );
                }
            }
            SubsiteJobfairout::insert($set_data);
            DB::commit();
            admin_toastr('操作成功!', 'success');
            return redirect(route('jobfairout.index'));
        } catch (\Exception $e) {
            DB::rollback();
            admin_toastr($e->getMessage(), 'error');
            return back();
        }
    }

    public function update(Request $request)
    {
        $request->validate([
            'title' => 'required',
            'number' => 'required|integer',
            'holddate_start' => 'required',
            'holddate_end' => 'required',
            'predetermined_start' => 'required',
            'predetermined_end' => 'required',
            'address' => 'required', //举办地址。
            'contact' => 'required',
            'phone' => 'required|max:100',
            'jobfair_introduction' => 'required',
        ],[
            'title.required'=>'请填写标题',
            'number.required'=>'请填写展位数量',
            'number.integer'=>'展位数量必须为数字',
            'holddate_start.required'=>'请填写举办开始时间',
            'holddate_end.required'=>'请填写举办结束时间',
            'predetermined_start.required'=>'请填写预定开始时间',
            'predetermined_end.required'=>'请填写预定结束时间',
            'address.required'=>'请填写举办地址',
            'contact.required'=>'请填写联系人',
            'phone.required'=>'请填写联系方式',
            'phone.max'=>'联系方式最多不超过100字',
            'jobfair_introduction.required'=>'请填写简介',
        ]);

        if ( preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->holddate_start) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->holddate_end) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->predetermined_start) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->predetermined_end) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->showendtime) ) {
            admin_toastr('举办/预定时间不能含有中文！', 'error');
            return back();
        }
        if ( preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->phone) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->predetermined_point) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->jobsfair_num) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->nosign_point) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->late_point) || preg_match ("/[\x{4e00}-\x{9fa5}]/u", $request->ordid) ) {
            admin_toastr('积分/场次/联系电话不能含有中文！', 'error');
            return back();
        }
        foreach (explode(',',$request->phone) as $value){
            if(!(preg_match ('/^1[3-9]{1}[0-9]{9}$/', $value) || preg_match ('/^([0-9]{3,4}-)?[0-9]{7,8}$/', $value))){
                admin_toastr('请输入正确的联系电话', 'error');
                return back();
            }
        }
        $jobfairout_id = $request->id;
        if (empty($jobfairout_id)) {
            admin_toastr('招聘会不存在!', 'error');
            return back();
        }
        if ($request->holddate_start >= $request->holddate_end) {
            admin_toastr('举办开始时间不能大于结束时间!!', 'error');
            return back();
        }
        if ($request->predetermined_start >= $request->predetermined_end) {
            admin_toastr('预订开始时间不能大于结束时间!!', 'error');
            return back();
        }
        if ($request->predetermined_end > $request->holddate_end) {
            admin_toastr('预订结束时间不能大于举办结束时间!!', 'error');
            return back();
        }

        $jobfairout = [];
        $jobfairout['title'] = $request->title;
        $jobfairout['industry'] = $request->industry;
        $jobfairout['holddate_start'] = strtotime($request->holddate_start);
        $jobfairout['holddate_end'] = strtotime($request->holddate_end);
        $jobfairout['type'] = $request->type;
        $jobfairout['type'] = $request->type;
        $jobfairout['showendtime'] = strtotime($request->showendtime);
        $jobfairout['address'] = $request->address;
        $jobfairout['contact'] = $request->contact;
        $apiAddress = $this->apiAddress($request->address);
        if (!$apiAddress) {
            admin_toastr('请添加地图标注!!', 'error');
            return back();
        }
        $jobfairout['map_x'] = $apiAddress['lng'];
        $jobfairout['map_y'] = $apiAddress['lat'];
        $jobfairout['phone'] = $request->phone;
        $jobfairout['display'] = $request->display;
        $jobfairout['is_commonweal'] = $request->is_commonweal;
        $jobfairout['predetermined_point'] = $request->predetermined_point;
        $jobfairout['jobsfair_num'] = $request->jobsfair_num;
        $jobfairout['nosign_point'] = $request->nosign_point;
        $jobfairout['late_point'] = $request->late_point;
        $jobfairout['ordid'] = $request->ordid;
        $jobfairout['jobfair_introduction'] = $request->jobfair_introduction;
        $school_id = array_filter($request->school_id);
        $jobfairout['school_id'] = implode(',',$school_id);
        $jobfairout['url'] = $request->url;
        $jobfairout['number'] = $request->number;
        if(is_array($request->subsite_id)){
            $subsiteArr = $request->subsite_id;
            $subsite_id = [];
            foreach ($subsiteArr as $key => $val) {
                if ($val!==null) {
                    $subsite_id[] = $val;
                }
            }
            $own_subsite_id = Jobfairout::findOrFail($jobfairout_id)->subsite_id;
            $subsiteJobfair = [
                [
                    'jobfair_id'=>$jobfairout_id,
                    'subsite_id'=> $own_subsite_id,
                    'created_at'=>date('Y-m-d H:i:s'),
                    'updated_at'=>date('Y-m-d H:i:s'),
                ]
            ];

            if ($subsite_id) {
                $subsiteArr = [];
                foreach ($subsite_id as $key => $val) {
                    $subsiteArr[$key]['jobfair_id'] = $jobfairout_id;
                    $subsiteArr[$key]['subsite_id'] = $val;
                    $subsiteArr[$key]['created_at'] = date('Y-m-d H:i:s');
                    $subsiteArr[$key]['updated_at'] = date('Y-m-d H:i:s');
                }
                if (in_array($own_subsite_id, $subsite_id)) {
                    $subsiteJobfair = $subsiteArr;
                } else {
                    $subsiteJobfair = array_merge($subsiteJobfair, $subsiteArr);
                }
            }
        }
        $jobfairout['predetermined_status'] = $request->predetermined_status;
        $jobfairout['predetermined_start'] = $request->predetermined_start ? strtotime($request->predetermined_start) : $request->predetermined_start;
        $jobfairout['predetermined_end'] = $request->predetermined_end ? strtotime($request->predetermined_end) : $request->predetermined_end;
        DB::beginTransaction();
        try {
            Jobfairout::where('id', $jobfairout_id)->update($jobfairout);
            if(isset($subsiteJobfair)){
                SubsiteJobfairout::where('jobfair_id', $jobfairout_id)->delete();
                SubsiteJobfairout::insert($subsiteJobfair);
            }
            DB::commit();
            admin_toastr('操作成功!', 'success');
            return redirect(route('jobfairout.index'));
        } catch (\Exception $e) {
            DB::rollback();
            admin_toastr($e->getMessage(), 'error');
            return back();
        }
    }

    public function destroy($id)
    {
        if (Jobfairout::destroy($id)) {
            $data = [
                'status'  => true,
                'message' => trans('admin.delete_succeeded'),
            ];
        } else {
            $data = [
                'status'  => false,
                'message' => trans('admin.delete_failed'),
            ];
        }
        return response()->json($data);
    }

    protected function apiAddress($address)
    {
        $url='https://api.map.baidu.com/geocoder/v2/?address='.$address.'&output=json&ak='.subsite_config('aix.system.map.map.map_ak')."&s=1";
        if ($result=file_get_contents($url)) {
            $data = array();
            $res= json_decode($result, true);
            if ($res['status']==0) {
                $results = $res['result'];
                $data['lng'] = $results['location']['lng'];
                $data['lat'] = $results['location']['lat'];
            }
            return $data;
        }
    }

    public function jobfairoutPoster(Request $request)
    {
        $id = $request->id;
        $poster = JobfairoutCompany::where('jobfair_id',$id)->get();
        $jonfairout_title= Jobfairout::where('id',$id)->value('title');
        return view('admin.jobfairout.jobfair_poster',['poster'=>$poster,'jonfairout_title'=>$jonfairout_title]);
    }

    public function exportPerson(Request $request){
        $id = $request->id;
        $Jobfair_reserve =  JobfairoutReserve::where(array('jobfair_id'=>$id))->orderBy('company_id')->get();
        $export = new PersonExport();
        $export->setCustomerData($Jobfair_reserve)->export();//这里不需要return
    }

    public function exportJobs(Request $request){
        $id = $request->id;
        $Jobs = JobfairoutPutJob::where(['jobfair_id'=>$id,'audit'=>1])->orderBy('exid')->get();
        $export = new JobsExport();
        $export->setCustomerData($Jobs)->export();//这里不需要return
    }

    public function exportFeedback(Request $request){
        $id = $request->id;
        $feedback = JobfairoutFeedback::where(['jobfair_id'=>$id])->get();
        foreach ($feedback as &$value)
        {
            $value['resumeNum'] = explode(',',$value['resumeNum']);
            $value['agreeNum'] = explode(',',$value['agreeNum']);
            $value['signNum'] = explode(',',$value['signNum']);
        }
        $export = new FeedbackExport();
        $export->setCustomerData($feedback)->export();//这里不需要return


    }
}