header('招聘会列表') ->description('') ->body($this->grid()); } /** * Show interface. * * @param mixed $id * @param Content $content * @return Content */ public function show($id, Content $content) { 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.jobfair.jobfair')->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.jobfair.jobfair')->with(['content'=>$this->createForm()])->render()); } /** * Make a grid builder. * * @return Grid */ protected function grid() { $grid = new Grid(new Jobfair); $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 ''.$title.''; })->width(300); $grid->jobfair_type('招聘会类型')->display(function ($jobfair_type) { $managements = JobfairManagement::all()->pluck('name', 'id'); foreach ($managements as $key=>$value){ if($jobfair_type == $key){ return $value; break; } } }); $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 () { $standAudit = 0; $standAuditList = []; $standAuditListName = []; $standSuccess = 0; $standSuccessList = []; $standSuccessListName = []; $standLock = 0; $standLockListName = []; $standFreeList = []; $standNum = 0; $FloorplanStand = FloorplanStand::where('jobfair_id', $this->id)->get(); $JobfairCompany = JobfairCompany::where('jobfair_id', $this->id)->whereIn('audit', [1,2])->get(); if (!$FloorplanStand->isEmpty()) { foreach ($FloorplanStand as $key => $val) { if ($val->type==2) { $standLock++; $standLockListName[]=$val->name; } if ($val->type==1) { $standFreeList[]=$val->id; } $standNum++; } } if (!$JobfairCompany->isEmpty()) { foreach ($JobfairCompany as $key => $val) { if ($val->audit==1) { $standSuccess++; $standSuccessList[]=$val->position_id; $standSuccessListName[]=$val->position; } elseif ($val->audit==2) { $standAudit++; $standAuditList[]=$val->position_id; $standAuditListName[] = $val->position; } } } $standFreeList = array_diff($standFreeList, array_unique(array_merge($standSuccessList, $standAuditList))); $standFreeListName = FloorplanStand::whereIN('id', $standFreeList)->pluck('name')->all(); return '['.count($standFreeList).'] ['.$standAudit.'] ['.$standSuccess.'] ['.$standLock.'] ['.$standNum.']'; }); $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('jobfair_manager_signed') && (get_subsite_id() == 0 || $actions->row['subsite_id']== get_subsite_id())) { $actions->append(''); } $actions->append(''); $actions->append(''); if (Admin::user()->can('jobfair_manager_edit') && (get_subsite_id() == 0 || $actions->row['subsite_id']== get_subsite_id())) { $actions->disableEdit(false); } if (Admin::user()->can('jobfair_manager_delete') && (get_subsite_id() == 0 || $actions->row['subsite_id']== get_subsite_id())) { $actions->disableDelete(false); } }); if (Admin::user()->can('jobfair_manager_delete')) { $grid->tools(function ($tools) { $tools->batch(function ($batch) { $batch->disableDelete(false); }); }); $grid->disableRowSelector(); } $grid->filter(function ($filter) { $filter->like('title', '招聘会标题'); $filter->equal('jobfair_type', '招聘会类型')->select(JobfairManagement::all()->pluck('name', 'id')); $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('jobfair_manager_create')) { $grid->disableCreateButton(false); } return $grid; } /** * Make a show builder. * * @param mixed $id * @return Show */ protected function detail($id) { $show = new Show(Jobfair::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->jobfair_type('招聘会类型')->as(function ($jobfair_type) { $managements = JobfairManagement::all()->pluck('name', 'id'); foreach ($managements as $key=>$value){ if($jobfair_type == $key){ return $value; break; } } }); $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; } /** * Make a form builder. * * @return Form */ protected function form() { $form = new Form(new Jobfair); $form->display('ID'); $form->display('Created at'); $form->display('Updated at'); return $form; } /** * Make a form builder. * * @return Form */ protected function editForm($id) { $Jobfair = Jobfair::findOrFail($id); $JobfairFloorplan = JobfairFloorplan::where(['jobfair_id'=>$Jobfair->id])->get(); $parmArr = ''; foreach ($JobfairFloorplan as $key => $val) { $parmName = []; $FloorplanStand = FloorplanStand::where(['jobfair_id'=>$Jobfair->id,'floorplan_id'=>$val->id])->get(); foreach ($FloorplanStand as $key1 => $val1) { $parmName[$key1]['name'] = $val1->name; $parmName[$key1]['type'] = $val1->type; $parmName[$key1]['left'] = $val1->left; $parmName[$key1]['top'] = $val1->top; $parmName[$key1]['id'] = $val1->id; $parmName[$key1]['equipment_id'] = $val1->equipment_id; $parmName[$key1]['sortindex'] = $val1->sortindex; if ($val1->type==2) { $status = 4; } else { if ($val1->id) { $JobfairCompany = JobfairCompany::where(['position_id'=>$val1->id])->get(); //先给默认值没预定 $status = 1; //有预定开始循环 foreach ($JobfairCompany as $value){ //第一次循环默认没审核 static $status = 1; if ($value) { if($status == 3){ //预定成功直接返回,不做判断 continue; }elseif ($status == 2 && $value->audit == 3) { //未审核并且其他审核未通过,不修改值 continue; }elseif($status == 1){ //第一次进入或未审核 if ($value->audit==1) { $status = 3; } elseif ($value->audit==2) { $status = 2; } else { $status = 1; } } } } } else { $status = 1; } } $parmName[$key1]['status'] = $status; } $parmArr.="
\"\"
编辑"; $jonfair_company = JobfairCompany::where('jobfair_id',$id)->get(); if($jonfair_company->isEmpty()){ $parmArr.=" 删除"; } $parmArr.= "
"; } $form = new Form(new Jobfair()); $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->text('contact', '联系人')->default($Jobfair->contact)->setMustMark(); $form->text('phone', '联系电话')->default($Jobfair->phone)->help('多个号码请用英文半角“,”隔开!')->setMustMark(); $form->select('jobfair_type', '分类')->options(JobfairManagement::all()->pluck('name', 'id'))->default($Jobfair->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 = SubsiteJobfair::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,$parmArr){ $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('不填不限制'); $form->select('areaid', '举办场地')->options(Floorplan::all()->pluck('name', 'id'))->default($Jobfair->areaid)->setMustMark(); $form->html("
".$parmArr."
"); $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(); $form->text('bus', '乘车路线')->default($Jobfair->bus); })->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('more_stand', '预定多个展位')->options([1=>'允许',0=>'不允许'])->default($Jobfair->more_stand)->help('同一家企业允许预订一场招聘会多个展位!'); $form->radio('is_commonweal', '招聘会')->options([1=>'场次',2=>'积分',3=>'公益'])->default($Jobfair->is_commonweal)->help('选择公益招聘会,企业预订免费!')->attribute('class', "is_commonweal"); $form->number('predetermined_point', '预定消耗积分')->min(0)->default($Jobfair->predetermined_point)->help('选择积分招聘会,企业预订则抵扣积分!'); $form->number('jobsfair_num', '预定消耗场次')->min(0)->default($Jobfair->jobsfair_num)->help('选择场次招聘会,企业预订则抵扣场次!'); $form->number('nosign_point', '未签到扣减积分')->min(0)->default($Jobfair->nosign_point)->help('单位:积分'); $form->number('late_point', '迟到早退扣减积分')->min(0)->default($Jobfair->late_point)->help('单位:积分'); $form->number('ordid', '排序')->min(0)->default($Jobfair->ordid)->help('数字越大,排序越靠前'); $form->hidden('_method')->default('put'); $form->html(''); }); $form->disableReset(); return $form->render(); } protected function createForm() { $form = new Form(new Jobfair); $parmArr = ''; if (isset(session('content')['jobfairName'])&&!empty(session('content')['jobfairName'])) { foreach (session('content')['jobfairName'] as $key => $val) { $parmName = []; $mk = json_decode(session('content')['thumbnailId'][$key], true); foreach ($mk as $key1 => $val1) { $parmName[$key1]['name'] = $val1['name']; $parmName[$key1]['type'] = $val1['type']; $parmName[$key1]['left'] = $val1['left']; $parmName[$key1]['top'] = $val1['top']; $parmName[$key1]['id'] = $val1['id']; $parmName[$key1]['equipment_id'] = $val1['equipment_id']; $parmName[$key1]['sortindex'] = $val1['sortindex']; if ($val1['type']==2) { $status = 4; } else { if ($val1['id']) { $JobfairCompany = JobfairCompany::where(['position_id'=>$val1['id']])->first(); if ($JobfairCompany) { if ($JobfairCompany->audit==1) { $status = 3; } elseif ($JobfairCompany->audit==2) { $status = 2; } else { $status = 1; } } else { $status = 1; } } else { $status = 1; } } $parmName[$key1]['status'] = $status; } $parmArr.="
\"\"
编辑 删除
"; } } $form->tab('基本信息',function ($form){ $form->text('title', '招聘会标题')->placeholder('如:2017年5月1日(星期六)医药行业主题招聘会')->default(session('content')['title'])->setMustMark(); $form->text('industry', '行业主题')->default(session('content')['industry']); $form->text('contact', '联系人')->default(session('content')['contact'])->setMustMark(); $form->text('phone', '联系电话')->default(session('content')['phone'])->help('多个号码请用英文半角“,”隔开!')->setMustMark(); $form->select('jobfair_type', '分类')->options(JobfairManagement::all()->pluck('name', 'id'))->default(session('content')['jobfair_type'] ? session('content')['jobfair_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) use($parmArr){ $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']); $form->select('areaid', '举办场地')->options(Floorplan::all()->pluck('name', 'id'))->default(session('content')['areaid'])->setMustMark(); $form->html("
$parmArr
"); $form->text('address', '举办地址')->default(session('content')['address'])->setMustMark(); $form->html(''); $form->html('
', '地图标注')->setMustMark(); $form->text('bus', '乘车路线')->default(session('content')['bus']); })->tab('设置',function ($form){ $form->radio('display', '显示状态')->options([1=>'正常',2=>'暂停'])->default(1); $form->radio('predetermined_status', '预定状态')->options([1=>'允许预订',2=>'停止预订'])->default(1); $form->radio('more_stand', '预定多个展位')->options([1=>'允许',0=>'不允许'])->default(1)->help('同一家企业允许预订一场招聘会多个展位!'); $form->radio('is_commonweal', '招聘会')->options([1=>'场次',2=>'积分',3=>'公益'])->default(3)->help('选择公益招聘会,企业预订免费!')->attribute('class', "is_commonweal"); $form->number('predetermined_point', '预定消耗积分')->min(0)->default(100)->help('选择积分招聘会,企业预订则抵扣积分!'); $form->number('jobsfair_num', '预定消耗场次')->min(0)->default(1)->help('选择场次招聘会,企业预订则抵扣场次!'); $form->number('nosign_point', '未签到扣减积分')->min(0)->default(300)->help('单位:积分'); $form->number('late_point', '迟到早退扣减积分')->min(0)->default(100)->help('单位:积分'); $form->number('ordid', '排序')->min(0)->default(0)->help('数字越大,排序越靠前'); $form->html(''); }); $form->disableReset(); return $form->render(); } public function jobfairAdd(Request $request) { $id = $request->id; if (!$id) { return response()->json(['code'=>0,'info'=>'请选择举办场地!','data'=>'']); } $Floorplan = Floorplan::findOrfail($id)->toArray(); $Floorplan['unique_id'] = md5(uniqid(md5(microtime(true)), true)); return response()->json(['code'=>1,'info'=>'成功!','data'=>$Floorplan]); } public function store(Request $request) { $request->validate([ 'title' => 'required', 'holddate_start' => 'required', 'holddate_end' => 'required', 'predetermined_start' => 'required', 'predetermined_end' => 'required', 'areaid' => 'required', 'address' => 'required', //举办地址。 'contact' => 'required', 'phone' => 'required|max:100', 'jobfair_introduction' => 'required', ],[ 'title.required'=>'请填写标题', '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()]); } $jobfair = []; $jobfair['title'] = $request->title; $jobfair['industry'] = $request->industry; $jobfair['holddate_start'] = strtotime($request->holddate_start); $jobfair['holddate_end'] = strtotime($request->holddate_end); $jobfair['areaid'] = $request->areaid; $jobfair['jobfair_type'] = $request->jobfair_type; $jobfair['showendtime'] = strtotime($request->showendtime); $jobfair['address'] = $request->address; $jobfair['bus'] = $request->bus; $jobfair['contact'] = $request->contact; $apiAddress = $this->apiAddress($request->address); if (!$apiAddress) { admin_toastr('请添加地图标注!!', 'error'); return back()->with(['content'=>$request->all()]); } $jobfair['map_x'] = $apiAddress['lng']; $jobfair['map_y'] = $apiAddress['lat']; $jobfair['phone'] = $request->phone; $jobfair['display'] = $request->display; $jobfair['is_commonweal'] = $request->is_commonweal; $jobfair['predetermined_point'] = $request->predetermined_point; $jobfair['jobsfair_num'] = $request->jobsfair_num; $jobfair['nosign_point'] = $request->nosign_point; $jobfair['late_point'] = $request->late_point; $jobfair['ordid'] = $request->ordid; $jobfair['more_stand'] = $request->more_stand; $jobfair['jobfair_introduction'] = $request->jobfair_introduction; $jobfair['subsite_id'] = get_subsite_id(); $jobfair['predetermined_status'] = $request->predetermined_status; $jobfair['predetermined_start'] = $request->predetermined_start ? strtotime($request->predetermined_start) : $request->predetermined_start; $jobfair['predetermined_end'] = $request->predetermined_end ? strtotime($request->predetermined_end) : $request->predetermined_end; $jobfairName = $request->jobfairName; if (empty($jobfairName)) { admin_toastr('请重新分配举办场地!!', 'error'); return back()->with(['content'=>$request->all()]); } DB::beginTransaction(); try { $Jobfair = Jobfair::create($jobfair); $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'), ); } } SubsiteJobfair::insert($set_data); $jobfairFloorplan = []; foreach ($jobfairName as $key => $val) { $jobfairFloorplan['jobfair_id'] = $Jobfair->id; $jobfairFloorplan['name'] = $val; $jobfairFloorplan['bg_images'] = $request->thumbnailImg[$key]; $JobfairFloor = JobfairFloorplan::create($jobfairFloorplan); $thumbnailId = json_decode($request->thumbnailId[$key], true); $jobfairFloorplanStands = []; foreach ($thumbnailId as $key1 => $val1) { $jobfairFloorplanStands[$key1]['jobfair_id'] = $Jobfair->id; $jobfairFloorplanStands[$key1]['floorplan_id'] = $JobfairFloor->id; $jobfairFloorplanStands[$key1]['name'] = $val1['name']; $jobfairFloorplanStands[$key1]['type'] = $val1['type']; $jobfairFloorplanStands[$key1]['left'] = $val1['left']; $jobfairFloorplanStands[$key1]['top'] = $val1['top']; $jobfairFloorplanStands[$key1]['sortindex'] = $val1['sortindex'] ? $val1['sortindex'] : 1000+$key1; $jobfairFloorplanStands[$key1]['equipment_id'] = $val1['equipment_id']; $jobfairFloorplanStands[$key1]['created_at'] = date('Y-m-d H:i:s'); $jobfairFloorplanStands[$key1]['updated_at'] = date('Y-m-d H:i:s'); } if ($jobfairFloorplanStands) { FloorplanStand::insert($jobfairFloorplanStands); } } DB::commit(); admin_toastr('操作成功!', 'success'); return redirect(route('jobfair.index')); } catch (\Exception $e) { DB::rollback(); admin_toastr($e->getMessage(), 'error'); return back(); } } public function update(Request $request) { $request->validate([ 'title' => 'required', 'holddate_start' => 'required', 'holddate_end' => 'required', 'predetermined_start' => 'required', 'predetermined_end' => 'required', 'areaid' => 'required', 'address' => 'required', //举办地址。 'contact' => 'required', 'phone' => 'required|max:100', 'jobfair_introduction' => 'required', ],[ 'title.required'=>'请填写标题', '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(); } 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(); } } $jobfair_id = $request->id; if (empty($jobfair_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(); } $jobfair = []; $JobfairFloorplanArr = JobfairFloorplan::where('jobfair_id', $jobfair_id)->pluck('id')->toArray(); $FloorplanStandArr = FloorplanStand::where('jobfair_id', $jobfair_id)->pluck('id')->toArray(); $jobfair['title'] = $request->title; $jobfair['industry'] = $request->industry; $jobfair['holddate_start'] = strtotime($request->holddate_start); $jobfair['holddate_end'] = strtotime($request->holddate_end); $jobfair['areaid'] = $request->areaid; $jobfair['jobfair_type'] = $request->jobfair_type; $jobfair['showendtime'] = strtotime($request->showendtime); $jobfair['address'] = $request->address; $jobfair['bus'] = $request->bus; $jobfair['contact'] = $request->contact; $apiAddress = $this->apiAddress($request->address); if (!$apiAddress) { admin_toastr('请添加地图标注!!', 'error'); return back(); } $jobfair['map_x'] = $apiAddress['lng']; $jobfair['map_y'] = $apiAddress['lat']; $jobfair['phone'] = $request->phone; $jobfair['display'] = $request->display; $jobfair['is_commonweal'] = $request->is_commonweal; $jobfair['predetermined_point'] = $request->predetermined_point; $jobfair['jobsfair_num'] = $request->jobsfair_num; $jobfair['nosign_point'] = $request->nosign_point; $jobfair['late_point'] = $request->late_point; $jobfair['ordid'] = $request->ordid; $jobfair['jobfair_introduction'] = $request->jobfair_introduction; $jobfair['more_stand'] = $request->more_stand; 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 = Jobfair::findOrFail($jobfair_id)->subsite_id; $subsiteJobfair = [ [ 'jobfair_id'=>$jobfair_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'] = $jobfair_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); } } } $jobfair['predetermined_status'] = $request->predetermined_status; $jobfair['predetermined_start'] = $request->predetermined_start ? strtotime($request->predetermined_start) : $request->predetermined_start; $jobfair['predetermined_end'] = $request->predetermined_end ? strtotime($request->predetermined_end) : $request->predetermined_end; $Floorplan_id = $request->Floorplan_id ? $request->Floorplan_id : []; DB::beginTransaction(); try { Jobfair::where('id', $jobfair_id)->update($jobfair); if(isset($subsiteJobfair)){ SubsiteJobfair::where('jobfair_id', $jobfair_id)->delete(); SubsiteJobfair::insert($subsiteJobfair); } $jobfairArr = []; $floorStandArrId = []; if ($Floorplan_id) { foreach ($Floorplan_id as $key => $val) { if (in_array($val, $JobfairFloorplanArr)) { JobfairFloorplan::where('id', $val)->update(['name'=>$request->jobfairName[$key]]); $floorplan_id_new = $val; } else { $jobfairArr['name'] = $request->jobfairName[$key]; $jobfairArr['bg_images'] = $request->thumbnailImg[$key]; $jobfairArr['jobfair_id'] = $jobfair_id; $JobfairFloorplan = JobfairFloorplan::create($jobfairArr); $floorplan_id_new = $JobfairFloorplan->id; } $thumbnailId = json_decode($request->thumbnailId[$key], true); $jobfairFloorplanStands = []; if ($thumbnailId) { foreach ($thumbnailId as $key1 => $val1) { if ($val1['id']) { $floorStandArrId[] = $val1['id']; FloorplanStand::where('id', $val1['id'])->update(['name'=>$val1['name'],'type'=>$val1['type'],'left'=>$val1['left'],'top'=>$val1['top']]); } else { $jobfairFloorplanStands[$key1]['jobfair_id'] = $jobfair_id; $jobfairFloorplanStands[$key1]['floorplan_id'] = $floorplan_id_new; $jobfairFloorplanStands[$key1]['name'] = $val1['name']; $jobfairFloorplanStands[$key1]['type'] = $val1['type']; $jobfairFloorplanStands[$key1]['left'] = $val1['left']; $jobfairFloorplanStands[$key1]['top'] = $val1['top']; $jobfairFloorplanStands[$key1]['sortindex'] = isset($val1['sortindex']) ? $val1['sortindex'] : 1000+$key1; $jobfairFloorplanStands[$key1]['equipment_id'] = $val1['equipment_id']; $jobfairFloorplanStands[$key1]['created_at'] = date('Y-m-d H:i:s'); $jobfairFloorplanStands[$key1]['updated_at'] = date('Y-m-d H:i:s'); } } } if ($jobfairFloorplanStands) { FloorplanStand::insert($jobfairFloorplanStands); } } } $floorplan_arr_id = array_diff($JobfairFloorplanArr, $Floorplan_id); if (!empty($floorplan_arr_id)) { JobfairFloorplan::destroy($floorplan_arr_id); } $floorStand_arr_id = array_diff($FloorplanStandArr, $floorStandArrId); if (!empty($floorStand_arr_id)) { FloorplanStand::destroy($floorStand_arr_id); } DB::commit(); admin_toastr('操作成功!', 'success'); return redirect(route('jobfair.index')); } catch (\Exception $e) { DB::rollback(); admin_toastr($e->getMessage(), 'error'); return back(); } } public function signed(Request $request, content $content) { $jobfair_id = $request->id; if (!$jobfair_id) { admin_toastr('招聘会不存在!', 'error'); return back(); } $form = new \Encore\Admin\Widgets\Form();//表单使用admin提供的表单 $form->action(route('jobfair.singedupdate')); $form->hidden('jobfair_id')->default($jobfair_id); $form->text('hash_id', '扫码枪')->placeholder('请将输入法切为英文模式后扫码'); $form->disableReset(); return $content ->header('招聘会签到') ->description('') ->body(view('admin.jobfair.singed')->with(['content'=>$form->render()])); } public function singedUpdate(Request $request) { $jobfair_id = $request->jobfair_id; $hash_id = $request->hash_id; $hash_array = explode('/',$hash_id); $hash_id = $hash_array[count($hash_array)-1]; $res = hashid_decode($hash_id); if(!$res){ admin_toastr('二维码错误!', 'error'); return back(); } if (!$jobfair_id) { admin_toastr('招聘会不存在!', 'error'); return back(); } $Jobfair = Jobfair::findOrFail($jobfair_id); if (!$Jobfair) { admin_toastr('招聘会不存在!', 'error'); return back(); } if (time()>=$Jobfair->holddate_end) { admin_toastr('该招聘会已结束!', 'error'); return back(); } if (time()<=$Jobfair->holddate_start) { if (($Jobfair->holddate_start-time())>3600) { admin_toastr('只能在招聘会开始之前1小时之内签到!', 'error'); return back(); } } if($res['utype'] == 1){ //企业签到 $JobfairCompany = JobfairCompany::where(['company_id'=>$res['id'],'jobfair_id'=>$jobfair_id,'audit'=>1])->first(); if (!$JobfairCompany) { admin_toastr('该参会企业不存在!', 'error'); return back(); } if ($JobfairCompany->type) { admin_toastr('该参会企业已经签到过了!', 'error'); return back(); } $date['type'] = 4; $date['signed_time'] = time(); //允许迟到半小时 if ($Jobfair->holddate_start < strtotime("-30 minute")) { $date['type'] = 1; } //修改状态 $result = JobfairCompany::where(['company_id'=>$res['id'],'jobfair_id'=>$jobfair_id])->update($date); //在jobfair_person_signeds插入数据 $company = Company::find($res['id']); $info['name'] = $company->companyname; $info['address'] = $company->address; $info['jobfairid'] = $jobfair_id; $info['sign_type'] = 2; $info['utype'] = 1; $info['uid'] = $company->id; JobfairPersonSigned::create($info); Cache::put($hash_id, time(),72000); }else { $memberInfo = MemberInfo::where(['uid' => $res['id']])->first(); $info['name'] = $memberInfo->realname; $info['uid'] = $memberInfo->uid; $info['jobfairid'] = $jobfair_id; $info['idcard'] = $memberInfo->id_card; $info['sex'] = $memberInfo->sex; $info['address'] = $memberInfo->householdaddress_cn; $info1 = $this->subIdcard($info['idcard'] ); $info = array_merge($info,$info1); $info['sign_type'] = 2; $result = JobfairPersonSigned::create($info); } if ($result) { admin_toastr('签到成功!', 'success'); return back(); } else { admin_toastr('签到失败!', 'error'); return back(); } } 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 exportPoster(Request $request){ $id = $request->id; $data=array(); $Jobfaircompany = JobfairCompany::where(array('audit'=>1,'jobfair_id'=>$id))->get(); foreach ($Jobfaircompany as $key =>$c){ $company = Company::where('id',$c->company_id)->first(); $data[$key]['company_name'] = $company->companyname; $position_id = FloorplanStand::where('id',$c->position_id)->first()->toArray(); $data[$key]['position_id'] = $position_id['equipment_id']; $jobfair_put_jobs = JobfairPutJob::where(array('jobfair_id'=>$id,'company_id'=>$c->company_id))->get(); $data[$key]['jobs_list']=$jobfair_put_jobs; $company = Company::where('id',$c->company_id)->first(); $data[$key]['contact']=$company->contact; if($company->mobile){ $data[$key]['mobile']=$company->mobile; }else{ $data[$key]['mobile']=$company->landline_tel; } $data[$key]['address']=$company->address; } $jobfarinfo = Jobfair::where('id',$id)->first()->toArray(); $export = new HaibaoExport($jobfarinfo['title'].'海报'); $c = new Collection($data); $export->setCustomerData($c)->export();//这里不需要return } public function exportSignin(Request $request){ $id = $request->id; $info = JobfairCompany::where('jobfair_id',$id)->get()->toArray(); $jobfair = Jobfair::where('id',$id)->first()->toArray(); $data = array(); foreach ($info as $key=>$i){ $data[$key]['position_id'] = $i['position']; $companys = Company::where('id',$i['company_id'])->first(); if($companys){ $data[$key]['companyname'] = $companys->companyname; switch($i['type']){ case 0: $type = '未签到'; break; case 1: $type = '迟到'; break; case 2: $type = '早退'; break; case 3: $type = '迟到/早退'; break; case 4: $type = '已签到'; break; } $data[$key]['type'] = $type; $data[$key]['signed_time'] = $i['signed_time']?date('Y-m-d H:i:s',$i['signed_time']):''; }else{ $data[$key]['position_id'] = ''; $data[$key]['companyname'] = ''; $data[$key]['type'] = ''; $data[$key]['signed_time'] =''; } } array_multisort(array_column($data,'position_id'),SORT_ASC,$data); $export = new QiandaoExport($jobfair['title'].'签到导出'.date('YmdHis',time())); $c = new Collection($data); $export->setCustomerData($c)->export();//这里不需要return } //根据身份证截取信息 protected function subIdcard($idcard) { $data = []; $sexInt = (int)substr($idcard, 16, 1); $data['sex'] = $sexInt % 2 == 0 ? '2' : '1'; $data['birthday'] = substr($idcard,6,4); return $data; } }