<?php
namespace App\Admin\Controllers\Jobfair;
use App\Http\Controllers\Controller;
use App\Http\Controllers\Statistics\CompanyController;
use App\Models\Company;
use App\Models\Jobfair\Floorplan;
use App\Models\Jobfair\FloorplanStand;
use App\Models\Jobfair\Jobfair;
use App\Models\Jobfair\JobfairCompany;
use App\Models\Jobfair\JobfairFloorplan;
use App\Models\Jobfair\JobfairManagement;
use App\Models\Jobfair\JobfairPersonSigned;
use App\Models\MemberInfo;
use App\Models\Subsite;
use App\Models\SubsiteJobfair;
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;
use Illuminate\Support\Facades\Cache;
use App\Models\Jobfair\JobfairPutJob;
use App\Admin\Exports\Jobfair\HaibaoExport;
use App\Admin\Exports\Jobfair\QiandaoExport;
use Illuminate\Support\Collection;
class JobfairController 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)
{
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 "<span style='color:#009900'>".date('Y-m-d H:i', $holddate_start)." 至 ".date('Y-m-d H:i', $this->holddate_end)."</span>";
});
$grid->title('招聘会标题')->display(function ($title) {
return '<a href="'.route('jobfair.show.com',$this->id).'" target="_blank">'.$title.'</a>';
})->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 '<span class="vtip" title="空闲展位号['.implode(',', $standFreeListName).']" style="color:#000000;padding-right:10px">['.count($standFreeList).']</span>
<span class="vtip" title="审核中展位号['.implode(',', $standAuditListName).']" style="color:#FFCC33;padding-right:10px">['.$standAudit.']</span>
<span class="vtip" title="预定成功展位号['.implode(',', $standSuccessListName).']" style="color:#CC00CC;padding-right:10px">['.$standSuccess.']</span>
<span class="vtip" title="锁定展位号['.implode(',', $standLockListName).']" style="color:#CCCCCC;padding-right:10px">['.$standLock.']</span>
<span class="vtip" title="展位总数['.$standNum.']" style="color:#3300FF;padding-right:10px">['.$standNum.']</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('jobfair_manager_signed') && (get_subsite_id() == 0 || $actions->row['subsite_id']== get_subsite_id())) {
$actions->append('<a href="'.route('jobfair.signed',['id'=>$actions->row['id']]).'"><button class="btn btn-primary btn-xs business" title="签到" >签到</button></a>');
}
$actions->append('<a href="'.route('jobfair.export_poster',['id'=>$actions->row['id']]).'" target="_blank"><button class="btn btn-primary btn-xs business" title="导出企业海报" >导出企业海报</button></a>');
$actions->append('<a href="'.route('jobfair.export_signin',['id'=>$actions->row['id']]).'" target="_blank"><button class="btn btn-primary btn-xs business" title="导出企业签到" >导出企业签到</button></a>');
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.="<div class=\"jobfair-item\" data-id=".$val->id.">
<div class=\"jobfair-name\" title=\"\"><input type=\"text\" name=\"jobfairName[]\" value=".$val->name." /></div>
<div class=\"imgbox\"><img src=".upload_asset($val->bg_images)." alt=\"\"></div>
<strong class=\"edit\" ls=\"\" data-toggle=\"modal\" data-target=\"#myModal\">编辑</strong>";
$jonfair_company = JobfairCompany::where('jobfair_id',$id)->get();
if($jonfair_company->isEmpty()){
$parmArr.=" <strong class=\"delete\">删除</strong>";
}
$parmArr.= "<input type=\"hidden\" name=\"thumbnailId[]\" value=".json_encode($parmName)." />
<input type=\"hidden\" name=\"thumbnailImg[]\" value=".$val->bg_images." />
<input type=\"hidden\" name=\"Floorplan_id[]\" value=".$val->id." />
</div>";
}
$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("<div id='position_id'>".$parmArr."</div>");
$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();
$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('<template id="thumbnailTpl">
<div class="jobfair-item">
<div class="jobfair-name" title=""><input type="text" name="jobfairName[]" value="" /></div>
<div class="imgbox"><img src="" alt=""></div>
<strong class="edit" ls="" data-toggle="modal" data-target="#myModal">编辑</strong>
<strong class="delete">删除</strong>
<input type="hidden" name="thumbnailId[]" value="" />
<input type="hidden" name="thumbnailImg[]" value="" />
<input type="hidden" name="Floorplan_id[]" value="" />
</div>
</template>');
});
$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.="<div class=\"jobfair-item\" data-id=".session('content')['Floorplan_id'][$key].">
<div class=\"jobfair-name\" title=\"\"><input type=\"text\" name=\"jobfairName[]\" value=".session('content')['jobfairName'][$key]." /></div>
<div class=\"imgbox\"><img src=".upload_asset(session('content')['thumbnailImg'][$key])." alt=\"\"></div>
<strong class=\"edit\" ls=\"\" data-toggle=\"modal\" data-target=\"#myModal\">编辑</strong>
<strong class=\"delete\">删除</strong>
<input type=\"hidden\" name=\"thumbnailId[]\" value=".json_encode($parmName)." />
<input type=\"hidden\" name=\"thumbnailImg[]\" value=".session('content')['thumbnailImg'][$key]." />
<input type=\"hidden\" name=\"Floorplan_id[]\" value=".session('content')['Floorplan_id'][$key]." />
</div>";
}
}
$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("<div id='position_id'>$parmArr</div>");
$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();
$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('<template id="thumbnailTpl">
<div class="jobfair-item">
<div class="jobfair-name" title=""><input type="text" name="jobfairName[]" value="" /></div>
<div class="imgbox"><img src="" alt=""></div>
<strong class="edit" ls="" data-toggle="modal" data-target="#myModal">编辑</strong>
<strong class="delete">删除</strong>
<input type="hidden" name="thumbnailId[]" value="" />
<input type="hidden" name="thumbnailImg[]" value="" />
<input type="hidden" name="Floorplan_id[]" value="" />
</div>
</template>');
});
$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;
}
}