jucai/app/Admin/Controllers/Jobfair/JobfairController.php

<?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)."&nbsp;至&nbsp;".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;
    }


}