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 "".date('Y-m-d H:i', $holddate_start)." 至 ".date('Y-m-d H:i', $this->holddate_end).""; }); $grid->title('招聘会标题')->display(function ($title) { return "id)."'>".$title.""; })->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 '['.$standFree.'] ['.$standAudit.'] ['.$standSuccess.'] ['.$this->number.']'; }); $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(''); } if (Admin::user()->can('jobfairout_index_jobs')) { $actions->append(''); } if (Admin::user()->can('jobfairout_index_feedback')) { $actions->append(''); } if (Admin::user()->can('jobfairout_index_poster')) { $actions->append(''); } 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(''); $form->html('
', '地图标注')->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(''); $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('
', '地图标注')->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 } }