<?php

namespace App\Admin\Controllers\Jobfair;

use App\Http\Controllers\Controller;
use App\Models\Company;
use App\Models\Jobfair\FloorplanStand;
use App\Models\Jobfair\Jobfair;
use App\Models\Jobfair\JobfairCompany;
use App\Models\Jobfair\JobfairFloorplan;
use App\Models\Jobfair\JobfairPutJob;
use App\Models\MembersHandsel;
use App\Models\MembersPoint;
use App\Models\MembersSetmeal;
use App\Models\Pms;
use App\Models\Subsite;
use Encore\Admin\Controllers\HasResourceActions;
use Encore\Admin\Facades\Admin;
use Encore\Admin\Form;
use Encore\Admin\Grid;
use Encore\Admin\Layout\Content;
use Encore\Admin\Show;
use Illuminate\Http\Request;
use App\Admin\Exports\Jobfair\CompanyExport;
use App\Services\Common\SmsService;
use Aix\Sms\Contracts\Smser;
use App\Services\Common\EmailService;
class JobfairCompanyController extends Controller
{
    use HasResourceActions;
    protected $smsService;
    protected $emailService;

    public function __construct(SmsService $smsService,EmailService $emailService)
    {
        $this->smsService = $smsService;
        $this->emailService = $emailService;
    }

    /**
     * Index interface.
     *
     * @param Content $content
     * @return Content
     */
    public function index(Content $content,Request $request)
    {
        $is_export = $request->has('_export_');
        $jobfair_id = isset($request['jobfair_companys']['jobfair_id']) ? $request['jobfair_companys']['jobfair_id'] : false;
        $jobfair_id1 = isset($request->jobfair_id) ? $request->jobfair_id : false;
        $grid=$this->grid($jobfair_id,$jobfair_id1,$is_export)->render();
        return $content
            ->header('参会企业')
            ->description('')
            ->body(view('admin.jobfair.jobfair_company')->with(['grid'=>$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, Request $request)
    {
        return $content
            ->header('参会企业编辑')
            ->description('')
            ->body($this->editForm($request, $id)->edit($id));
    }

    /**
     * Create interface.
     *
     * @param Content $content
     * @return Content
     */
    public function create(Content $content)
    {
        return $content
            ->header('参会企业创建')
            ->description('')
            ->body($this->createForm());
    }

    /**
     * Make a grid builder.
     *
     * @return Grid
     */
    protected function grid($jobfair_id,$jobfair_id1,$is_export)
    {
        $grid = new Grid(new JobfairCompany);
        if($is_export){
            $grid->model()->when(get_subsite_id()>0, function ($query) {
                $query->whereHas('jobfair', function ($query) {
                    $query->where('subsite_id', get_subsite_id());
                });
            })->orderByRaw("FIELD(audit, 2,1,3)")->orderBy('updated_at', 'desc');
        }elseif($jobfair_id || $jobfair_id1){
            $grid->model()->joinFloorplanStand()->when(get_subsite_id()>0, function ($query) {
                $query->whereHas('jobfair', function ($query) {
                    $query->where('subsite_id', get_subsite_id());
                });
            })->when($jobfair_id1==true && $jobfair_id==false,function ($query) use ($jobfair_id1){
                $query->where('jobfair_companys.jobfair_id',$jobfair_id1);
            })
                ->select('jobfair_companys.*','jobfair_floorplan_stands.sortindex')
                ->orderBy("jobfair_floorplan_stands.sortindex");
        }else{
            $grid->model()->when(get_subsite_id()>0, function ($query) {
                $query->whereHas('jobfair', function ($query) {
                    $query->where('subsite_id', get_subsite_id());
                });
            })->orderByRaw("FIELD(audit, 2,1,3)")->orderBy('updated_at', 'desc');
        }


        $grid->column('companys.companyname', '参会企业')->display(function ($companyname) {
            return '<a href="'.route('jobs.company',['id'=>$this->company_id]).'" target="_blank">'.$companyname.'</a>';
        })->width(200);

        $grid->jobs_name('企业职位')->display(function () {
            if($this->jobfairPutJob->isEmpty()){
                return '暂无职位';
            }else{
                return '<a href="'.route('jobfairPutJobs.index',['jobfair_id'=>$this->jobfair_id,'company_id'=>$this->company_id]).'">点击查看</a>';
            }
        });
        $grid->column('jobfair.holddate_start', '举办时间')->display(function ($holddate_start) {
            if($holddate_start){
                return date('Y-m-d H:i',$holddate_start);
            }else{
                return '';
            }

        });
        $grid->column('jobfair.title', '招聘会标题')->display(function ($jobfair_title) {
            return '<a href="'.route('jobfair.show.com',$this->jobfair_id).'" target="_blank">'.$jobfair_title.'</a>';
        })->width(200);
        $grid->type('签到状态')->display(function ($type) {
            if ($type==0) {
                return '<span>未签到</span>';
            } elseif ($type==1) {
                return '<span style="color: #FF3300">迟到</span>';
            } elseif ($type==2) {
                return '<span style="color: #FF3300">早退</span>';
            } elseif ($type==3) {
                return '<span style="color: #FF3300">迟到/早退</span>';
            } elseif ($type==4) {
                return ' <span style="color: #009900">已签到</span>';
            }
        });
//        $grid->column('jobfairFloorPlanStands.floorplan_id', '展位图名称')->display(function ($floorplan_id) {
//            $JobfairFloorplan = JobfairFloorplan::find($floorplan_id);
//            return isset($JobfairFloorplan->name) ? $JobfairFloorplan->name : '未知';
//        })->width(200);
        $grid->column('jobfairFloorPlanStands.name', '展位号');
        $grid->audit('预订状态')->display(function ($audit) {
            if ($audit==1) {
                return ' <span style="color: #009900">预定成功</span>';
            } elseif ($audit==2) {
                return'<span style="color:#FF6600">等待确认</span>';
            } else {
                return '<span style="color: #FF3300">审核未通过</span>';
            }
        });
        $grid->pay_type('支付方式')->display(function ($pay_type) {
            if ($pay_type==1) {
                return '<span style="color: #009900">场次</span>';
            } elseif ($pay_type==2) {
                return '<span style="color: #009900">积分</span>';
            } else {
                return '<span style="color: #009900">公益</span>';
            }
        });
        $grid->etype('预订方式')->display(function ($etype) {
            if ($etype==1) {
                return '<span style="color: #009900">在线预订</span>';
            } elseif ($etype==2) {
                return '<span style="color: #009900">电话预定</span>';
            } else {
                return '<span style="color: #009900">现场预定</span>';
            }
        });
        if(get_subsite_open()){
            $grid->column('jobfair.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->disableCreateButton();
        $grid->actions(function ($actions) use ($grid) {
            if (Admin::user()->can('company_manager_bussiness')) {
                $actions->append("<button class='btn btn-primary btn-xs business' id=".$actions->row['company_id'].">业务</button>");
            }
            if (Admin::user()->can('jobfair_companys_audit')) {
                $actions->append("<button class='btn btn-primary btn-xs jobaudit' data-code=".$actions->row['id'].">审核</button>");
            }
            if (Admin::user()->can('jobfair_companys_edit')) {
                $actions->disableEdit(false);
            }
            if (Admin::user()->can('jobfair_companys_delete')) {
                $actions->disableDelete(false);
            }
        });

        if (Admin::user()->can('jobfair_companys_delete')) {
            $grid->tools(function ($tools) {
                $tools->batch(function ($batch) {
                    $batch->disableDelete(false);
                });
            });
            $grid->disableRowSelector(false);
        }
        if (Admin::user()->can('jobfair_companys_export')) {
            $grid->disableExport(false); //显示导出按钮
            $grid->exporter(new CompanyExport()); //传入自己在第1步创建的导出类
        }

        if (Admin::user()->can('jobfair_companys_create')) {
            $grid->disableCreateButton(false);
        }
        $grid->tools(function ($tools) {
            if (Admin::user()->can('jobfair_companys_audit')) {
                $but = <<<EOT
<div class="btn-group" data-toggle="buttons">
    <label class="btn btn-google btn-sm" id="Audit_Companys" title="参会状态">
        <i class="fa fa-audio-description"></i>
        <input type="radio" class="user-gender">审核企业
    </label>
</div>
EOT;
                $tools->append($but);
            }

            if (Admin::user()->can('jobfair_companys_signed')) {
                $signed = <<<EOT
<div class="btn-group" data-toggle="buttons">
    <label class="btn btn-google btn-sm" id="signed" title="签到">
        <i class="fa fa-audio-description"></i>
        <input type="radio" class="user-gender">签到
    </label>
</div>
EOT;
                $tools->append($signed);
            }
        });
        $grid->filter(function ($filter) {
            // 去掉默认的id过滤器
            $filter->disableIdFilter();
            $filter->column(1/2, function ($filter) {
                $filter->like('companys.companyname', '参会企业');
                $filter->equal('jobfair_companys.jobfair_id', '招聘会标题')->select(Jobfair::select('title', 'id')->when(get_subsite_id()>0,function ($query){
                    $query->whereHas('subsites', function ($query) {
                        $query->where('subsite_jobfairs.subsite_id', get_subsite_id())->where('subsites.effective', 1);
                    });
                })->pluck('title', 'id')->all());
                $filter->equal('jobfair_companys.audit', '预订状态')->select([
                    1=>'预定成功',
                    2=>'等待确认',
                    3=>'审核未通过',
                ]);
                $filter->equal('jobfair_companys.type', '签到状态')->select([
                    0=>'未签到',
                    1=>'迟到',
                    2=>'早退',
                    3=>'迟到/早退',
                    4=>'已签到',
                ]);
                if( get_subsite_id() == 0 && get_subsite_open()){
                    $filter->equal('jobfair.subsite_id', '所属分站')->select(array_column(get_all_subsite(), 'sitename', 'id'));
                }
            });
            $filter->column(1/2, function ($filter) {
                $filter->equal('jobfair_companys.pay_type', '支付方式')->select([
                    1=>'场次',
                    2=>'积分',
                    3=>'公益',
                ]);
                $filter->like('jobfair_companys.position', '预定展位');
                $filter->equal('jobfair_companys.etype', '预订方式')->select([
                    1=>'在线预订',
                    2=>'电话预定',
                    3=>'现场预定'
                ]);
                $filter->where(function ($query) {
                    switch ($this->input) {
                        case 3:
                            $query->whereRaw("jobfair_companys.updated_at>='".date('Y-m-d H:i:s', strtotime('-3 day'))."'");
                            break;
                        case 7:
                            $query->whereRaw("jobfair_companys.updated_at>='".date('Y-m-d H:i:s', strtotime('-7 day'))."'");
                            break;
                        case 30:
                            $query->whereRaw("jobfair_companys.updated_at>='".date('Y-m-d H:i:s', strtotime('-30 day'))."'");
                            break;
                    }
                }, '更新时间', 'updated_at')->select([
                    3=>'三天内',
                    7=>'一周内',
                    30=>'一月内',
                ]);
            });
        });

        return $grid;
    }

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

        $jobfairCompany = JobfairCompany::findOrFail($id);

        $show->id('ID');

        $show->companys()->companyname('参会企业')->as(function ($companys){
            return $companys->companyname;
        });

        $show->jobfair()->title('招聘会标题')->as(function ($jobfair){
            return $jobfair->title;
        });

        $show->type('签到状态')->as(function ($type) {
            if ($type==0) {
                return '未签到';
            } elseif ($type==1) {
                return '迟到';
            } elseif ($type==2) {
                return '早退';
            } elseif ($type==3) {
                return '迟到/早退';
            } elseif ($type==4) {
                return '已签到';
            }
        });

        $show->position('展位号');


        $show->audit('预订状态')->as(function ($audit) {
            if ($audit==1) {
                return '预定成功';
            } elseif ($audit==2) {
                return '等待确认';
            } else {
                return '审核未通过';
            }
        });
        $show->pay_type('支付方式')->as(function ($pay_type) {
            if ($pay_type==1) {
                return '场次';
            } elseif ($pay_type==2) {
                return '积分';
            } else {
                return '公益';
            }
        });
        $show->etype('预订方式')->as(function ($etype) {
            if ($etype==1) {
                return '在线预订';
            } elseif ($etype==2) {
                return '电话预定';
            } else {
                return '现场预定';
            }
        });

        $show->subsite_id('所属分站')->as(function () use ($jobfairCompany) {
            $subsite_id = Jobfair::findOrFail($jobfairCompany->jobfair_id)->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 JobfairCompany);

        $form->display('ID');
        $form->display('Created at');
        $form->display('Updated at');

        return $form;
    }


    protected function createForm()
    {
        $form = new Form(new JobfairCompany);
        $form->select('company_id', '企业名称')->options(
            Company::where('audit', 1)->pluck('companyname', 'id')->all()
        )->rules([
            'required',
        ])->setMustMark();
        $form->select('jobfair_id', '招聘会名称')->options(
            Jobfair::where('display', 1)->where('predetermined_status',1)->where('holddate_end', '>', time())->pluck('title', 'id')->all()
        )->load('position', route('floorplans.floorPlans'))->rules([
            'required',
        ])->setMustMark();
        $form->select('position', '展位图名称')->load('position_id',  route('floorplans.floorPlansId'))->rules([
            'required',
        ])->setMustMark();
        $form->select('position_id', '展位号')->rules([
            'required',
        ])->setMustMark();
        $form->select('etype', '预定方式')->options([3=>'现场预定'])->default(3)->help('现场预定不消耗场次或积分！');
        $form->hidden('pay_type')->default(3);

        $form->saving(function (Form $form){
            $company_id = $form->company_id;
            $Jobfair = Jobfair::findOrFail($form->jobfair_id);
            if ($Jobfair->more_stand==0) {
                $count = JobfairCompany::where(['company_id'=>$company_id,'jobfair_id'=>$form->jobfair_id])->count();
                if ($count>=1) {
                    admin_toastr('同一家企业不可预订一场招聘会多个展位!', 'error');
                    return redirect(route('jobfair.company.create'));
                }
            }
        });

        $form->saved(function (Form $form) {
            $model = $form->model();
            $model->audit = 1;
            $model->position = FloorplanStand::findOrFail($form->position_id)->name;
            $model->note = '该企业现场预定展位！';
            $model->type = 0;
            $model->signed_time = time();
            $model->save();
        });
        return $form;
    }


    /**
     * Make a form builder.
     *
     * @return Form
     */
    protected function editForm($request, $id)
    {
        $form = new Form(new JobfairCompany);
        $jonfairCompany = JobfairCompany::findOrFail($id);
        $request->session()->put('jobfair_plan_id', $jonfairCompany->jobfair_id);
        $form->display('companys.companyname', '企业名称')->setMustMark();
        $form->display('jobfair.title', '招聘会名称')->setMustMark();
        $FloorplanStand = FloorplanStand::with('jobfair_floorPlan')->where('id', $jonfairCompany->position_id)->first();
        $stand_id = isset($FloorplanStand->jobfair_floorPlan->id) ? $FloorplanStand->jobfair_floorPlan->id : '';
        $form->select('position_floor_plans', '展位图名称')->options(JobfairFloorplan::where('jobfair_id', $jonfairCompany->jobfair_id)->pluck('name', 'id')->all())->load('position_id', route('floorplans.floorPlansId'))->default($stand_id)->rules([
            'required',
        ])->setMustMark();
        $list = $this->positionColumn($jonfairCompany->jobfair_id,$stand_id);
        $list[$jonfairCompany->position_id] = $jonfairCompany->position;
        $form->select('position_id', '展位号')->options($list)->default($jonfairCompany->position_id)->rules([
            'required',
        ])->setMustMark();
        $form->hidden('position');
        $form->saving(function (Form $form) {
            $form->position = FloorplanStand::findOrFail($form->position_id)->name;
        });
        return $form;
    }

    /**
     * Store a newly created resource in storage.
     *
     * @return mixed
     */
    public function store()
    {
        return $this->createForm()->store();
    }

    /**
     * Update the specified resource in storage.
     *
     * @param int $id
     *
     * @return \Illuminate\Http\Response|\Symfony\Component\HttpFoundation\Response
     */
    public function update(Request $request, $id)
    {
        $data = $request->all();
        unset($data['position_floor_plans']);
        return $this->editForm($request, $id)->update($id, $data);
    }

    public function auditCompanys(Request $request)
    {
        $id = $request->id;
        $form = new \Encore\Admin\Widgets\Form();
        $form->action(route('jobfair.company.auditr'));
        $form->disableReset();
        $form->hidden('id', 'ID')->default($id);
        $form->radio('audit', '审核')->options([1=>'预订成功',3=>'审核未通过'])->default(1);
        $form->textarea('note', '备注');
        $form->html('<label style="color: rgb(0, 153, 0)"><input type="checkbox" name="pms_notice" value="1" checked="checked">站内信通知</label>');
        return json_encode(['html'=>$form->render(),'detail'=>'审核企业']);
    }

    public function auditCompanysR(Request $request)
    {
        $id = $request->id;
        $audit = $request->audit;
        $note = $request->note;
        $pms_notice = $request->pms_notice;
        if($audit==3){
            if (empty($note)) {
                admin_toastr('参会企业审核未通过必须填写备注！', 'error');
                return back();
            }
        }
        $arr = array_filter(explode(',', $id));
        if (empty($arr)) {
            admin_toastr('请选择参会企业', 'error');
            return back();
        }
        $arr_id = [];
        $JobfairCompany = JobfairCompany::whereHas('jobfair',function ($query){
            $query->where('holddate_end', '>', time());
        })->whereIn('id', $arr)->get();
        if($JobfairCompany->isEmpty()){
            admin_toastr('招聘会已过期', 'error');
            return back();
        }
        \DB::beginTransaction();
        try {
            foreach ($JobfairCompany as $key => $val) {
                if ($audit==1) { //预订成功
                    if ($val->audit==2) {
                        $arr_id[] = $val->id;
                        if($val->companys->mobile && $val->companys->mobile_audit == 1){
                            $this->smsService->sendSms(
                                $val->companys->mobile,
                                Smser::TEMPLATE_JOBFAIR_APPLY_OK,
                                [
                                    'jobfair_name'=>$val->jobfair->title,
                                    'jobfair_time'=>date('Y-m-d H:i',$val->jobfair->holddate_start),
                                    'jobfair_addr'=>$val->jobfair->address,
                                    'position'=>$val->jobfairFloorPlanStands->name,
                                ]);
                        }
                        if($val->companys->email && $val->companys->email_audit == 1){
                            $this->emailService->sendMail($val->companys->email, EmailService::TEMPLATE_JOBFAIR_APPLY_OK,
                                ['title'=>'招聘会预订成功'],
                                [
                                    'jobfair_name'=>$val->jobfair->title,
                                    'jobfair_time'=>date('Y-m-d H:i',$val->jobfair->holddate_start),
                                    'jobfair_addr'=>$val->jobfair->address,
                                    'position'=>$val->jobfairFloorPlanStands->name,
                                ]
                            );
                        }
                    }
                } else { //审核未通过。
                    if ($val->audit==2 || $val->audit==1) {
                        $arr_id[] = $val->id;
                        if($val->companys->mobile && $val->companys->mobile_audit == 1){
                            $this->smsService->sendSms(
                                $val->companys->mobile,
                                Smser::TEMPLATE_JOBFAIR_APPLY_ERROR,
                                [
                                    'jobfair_name'=>$val->jobfair->title
                                ]);
                        }
                        if($val->companys->email && $val->companys->email_audit == 1){
                            $this->emailService->sendMail($val->companys->email, EmailService::TEMPLATE_JOBFAIR_APPLY_ERROR, ['title'=>'招聘会预订失败'], ['jobfair_name'=>$val->jobfair->title]);
                        }
                    }

                    if ($val->jobfair) {
                        if ($val->pay_type==1) {//场次
                            MembersSetmeal::where('uid', $val->company_id)->where('utype', 1)
                                ->increment('jobfair_num', $val->jobfair->jobsfair_num);
                        }elseif ($val->pay_type==2) { //积分
                            MembersPoint::where('uid', $val->company_id)->where('utype', 1)
                                ->increment('points', $val->jobfair->predetermined_point);
                            MembersHandsel::create([
                                'uid'=>$val->company_id,
                                'utype'=>1,
                                'htype_cn'=>'返还预定招聘会的积分',
                                'operate'=>1,
                                'points'=>$val->jobfair->predetermined_point
                            ]);
                        }
                    }
                }
            }

            if ($arr_id) {
                $newReult = JobfairCompany::with(['jobfair', 'companys'])->whereHas('jobfair')
                    ->whereHas('companys')->whereIn('id', $arr_id)->get();
                foreach ($newReult as $key => $val) {
                    if ($val->jobfair && $val->companys) {
                        $newDate[$key]['utype'] = $val->companys->utype;
                        $newDate[$key]['msgtype'] = 2;
                        $newDate[$key]['msgfromuid'] = 0;
                        $newDate[$key]['msgfrom'] = 'admin';
                        $newDate[$key]['msgtoname'] = $val->companys->username;
                        $newDate[$key]['msgtouid'] = $val->companys->id;
                        $title = strstr($val->jobfair->title, '招聘会') ? $val->jobfair->title : $val->jobfair->title . '招聘会';
                        if ($audit == 1) {
                            $newDate[$key]['message'] = '您申请的<a href="' . route('jobfair.show', $val->jobfair->id) . '">' . $title . '</a>' . $val->position . '展位已审核通过，请尽快提交招聘会职位。';
                        } else {
                            $newDate[$key]['message'] = '您申请的<a href="' . route('jobfair.show', $val->jobfair->id) . '">' . $title . '</a>' . $val->position . '展位已审核失败，请尽快查收。失败原因（' . $note . '）';
                        }
                        $newDate[$key]['created_at'] = date('Y-m-d H:i:s');
                        $newDate[$key]['updated_at'] = date('Y-m-d H:i:s');
                    }
                }
                if ($pms_notice && $newDate) {
                    Pms::insert($newDate);
                }
                JobfairCompany::whereIn('id', $arr_id)->update(['audit' => $audit, 'note' => $note]);
            } else {
                admin_toastr('操作失败', 'error');
                return back();
            }

            \DB::commit();
            admin_toastr('操作成功', 'success');
        } catch (\Exception $e) {
            \DB::rollback();
            admin_toastr('操作失败', $e->getMessage());
        }
        return back();
    }


    public function signedCompanys(Request $request)
    {
        $id = $request->id;
        $arr = array_filter(explode(',', $id));
        if (empty($id)) {
            return response()->json(['code'=>0,'info'=>'数据异常！']);
        }
        if (empty($arr)) {
            return response()->json(['code'=>0,'info'=>'请选择参会企业！']);
        }
        $need_id_n = [];
        $need_id_p = [];
        $JobfairCompany = JobfairCompany::with(['jobfair'=>function ($query) {
            $query->where('holddate_start', '<=', time()+7200)->where('holddate_end', '>=', time())->orWhere('holddate_start', '<=', time());
        }])->whereIn('id', $arr)->where('type', 0)->get();
        foreach ($JobfairCompany as $key => $val) {
            if ($val->jobfair) {
                if (time()>=$val->jobfair->holddate_start && time()<=$val->jobfair->holddate_end) {
                    $need_id_n[] = $val->id;
                } else {
                    if (time()<$val->jobfair->holddate_start) {
                        if (($val->jobfair->holddate_start-time())<7200) {
                            $need_id_p[] = $val->id;
                        }
                    }
                }
            }
        }
        if (!$need_id_n&&!$need_id_p) {
            return response()->json(['code'=>0,'info'=>'该企业已签到过或招聘会已结束或签到时间不在招聘会开始时间2小时之内！']);
        }
        \DB::beginTransaction();
        try {
            if ($need_id_n) {
                JobfairCompany::whereIn('id', $need_id_n)->update(['type'=>1,'signed_time'=>time()]);
            }
            if ($need_id_p) {
                JobfairCompany::whereIn('id', $need_id_p)->update(['type'=>4,'signed_time'=>time()]);
            }
            \DB::commit();
            return response()->json(['code'=>1,'info'=>'签到成功！']);
        } catch (\Exception $e) {
            \DB::rollback();
            return response()->json(['code'=>0,'info'=>'签到失败！']);
        }
    }

    public function floorPlans(Request $request)
    {
        $jobfair_id = $request->get('q');
        $request->session()->put('jobfair_plan_id', $jobfair_id);
        return JobfairFloorplan::where('jobfair_id', $jobfair_id)->get(['id','name as text']);
    }

    public function floorPlansId(Request $request)
    {
        $jobfair_id = $request->session()->get('jobfair_plan_id', '');
        $floor_plan_id = $request->get('q');
        if ($jobfair_id) {
            $standFreeList = $this->lastJobfairPosition($jobfair_id, $floor_plan_id);
            return FloorplanStand::whereIN('id', $standFreeList)->get(['id','name as text']);
        }
        return [];
    }

    protected function lastJobfairPosition($jobfair_id, $floor_plan_id)
    {
        $standAudit = 0;
        $standAuditList = [];
        $standSuccess = 0;
        $standSuccessList = [];
        $standLock = 0;
        $standLockList = [];
        $standFreeList = [];
        $standNum = 0;
        $FloorplanStand = FloorplanStand::where('jobfair_id', $jobfair_id)->where('floorplan_id', $floor_plan_id)->get();
        $JobfairCompany = JobfairCompany::where('jobfair_id', $jobfair_id)->whereIn('audit', [1,2])->get();
        if (!$FloorplanStand->isEmpty()) {
            foreach ($FloorplanStand as $key => $val) {
                $standFreeList[]=$val->id;
//                if ($val->type==2) {
//                    $standLock++;
//                    $standLockList[]=$val->id;
//                }
//                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;
                } elseif ($val->audit==2) {
                    $standAudit++;
                    $standAuditList[]=$val->position_id;
                }
            }
        }
        return array_diff($standFreeList, array_unique(array_merge($standSuccessList, $standAuditList)));
    }

    public function positionColumn($jobfair_id, $floor_plan_id)
    {
        $standFreeList = $this->lastJobfairPosition($jobfair_id, $floor_plan_id);
        return FloorplanStand::whereIN('id', $standFreeList)->pluck('name as text','id')->toArray();
    }

    public function destroy($id)
    {
        $ids = array();
        if ($id) {
            $ids = explode(',', $id);
        }
        if (!$ids) {
            return admin_toastr('请勾选需要删除的参展职位', 'error');
        }

        \DB::beginTransaction();
        try {
            JobfairCompany::whereIn('id', $ids)->delete();
            JobfairPutJob::whereIn('exid', $ids)->delete();
            $data = [
                'status'  => true,
                'message' => '删除成功！',
            ];
            \DB::commit();
            return response()->json($data);
        } catch (\Exception $e) {
            \DB::rollback();
            $data = [
                'status'  => false,
                'message' => '删除失败！',
            ];
            return response()->json($data);
        }
    }
}