jucai/app/Admin/Controllers/Person/MemberController.php

<?php

namespace App\Admin\Controllers\Person;

use App\Admin\Exports\Person\MemberExport;
use App\Http\Controllers\Controller;
use App\Models\CategoryMajor;
use App\Models\CompanyInterView;
use App\Models\Member;
use App\Models\MemberInfo;
use App\Models\MembersHandsel;
use App\Models\MembersLog;
use App\Models\Order;
use App\Models\PersonalJobsApply;
use App\Models\PersonalServiceStickLog;
use App\Models\Resume;
use App\Models\ResumeImg;
use App\Models\SmsRule;
use App\Models\Subsite;
use App\Models\SubsiteResume;
use App\Models\Category;
use App\Models\CategoryDistrict;
use App\Services\Common\SmsService;
use Encore\Admin\Auth\Permission;
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 Encore\Admin\Widgets\Tab;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Cache;
use Illuminate\Validation\Rule;
use App\Admin\Extensions\Form\ValidateForm;
use Illuminate\Support\Facades\DB;
class MemberController extends Controller
{
    use HasResourceActions;

    protected $smsService;

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

    /**
     * Index interface.
     *
     * @param Content $content
     * @return Content
     */
    public function index(Content $content)
    {
        Permission::check('person_member');
        $grid=$this->grid()->render();
        return $content
            ->header('个人会员')
            ->description('列表')
            ->body(view('admin.members.index')->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)
    {
        Permission::check('person_member_edit');
        return $content
            ->header('个人会员')
            ->description('编辑')
            ->body($this->editForm($id)->edit($id));
    }

    /**
     * Create interface.
     *
     * @param Content $content
     * @return Content
     */
    public function create(Content $content)
    {
        Permission::check('person_member_add');
        return $content
            ->header('个人会员')
            ->description('新增')
            ->body($this->form());
    }

    /**
     * Make a grid builder.
     *
     * @return Grid
     */
    protected function grid()
    {
        $grid = new Grid(new Member);


        $grid->model()->when(get_subsite_id()>0, function ($query) {
            $query->where('subsite_id', get_subsite_id());
            $query->whereHas('subsite',function ($query){
                $query->where('effective', 1);
            });
        })->orderBy('id', 'desc');



        $grid->id('ID');
        $grid->username('用户名')->width(200);;
        $grid->mobile('手机')->width(100);
        $grid->email('Email')->width(150);
        if(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 '总站';
            })->width(150);
        }
        $grid->reg_time('注册时间')->display(function ($reg_time) {
            return date('Y-m-d H:i:s', $reg_time);
        })->sortable();
        $grid->last_login_time('最后登录时间')->display(function ($last_login_time) {
            return $last_login_time ? date('Y-m-d H:i:s', $last_login_time) : '';
        })->sortable();
        if (Admin::user()->can('person_member_add')) {
            $grid->disableCreateButton(false);
        }
        $grid->actions(function ($actions) {
            if (Admin::user()->can('perosn_business')) {
                $actions->append("&nbsp;<button class='btn btn-primary btn-xs business' id=".$actions->row['id'].">业务</button>");
            }
            if (Admin::user()->can('person_member_delete')) {
                $actions->disableDelete(false);
            }
            if (Admin::user()->can('person_member_edit')) {
                $actions->disableEdit(false);
            }
        });

        $grid->tools(function ($tools) {

            if (Admin::user()->can('person_member_reset_password')) {
                $but = <<<EOT
<div class="btn-group" data-toggle="buttons">
    <label class="btn btn-google btn-sm" id="update_password" title="重置密码">
        <i class="fa fa-audio-description"></i>
        <input type="radio" class="user-gender">重置密码
    </label>
</div>
EOT;
                $tools->append($but);
            }


        });

        if (Admin::user()->can('person_member_export')) {
            $grid->disableExport(false); //显示导出按钮
            $grid->exporter(new MemberExport()); //传入自己在第1步创建的导出类
        }


        $grid->filter(function ($filter) {

            $filter->column(1/2, function ($filter) {
                $filter->equal('id', '会员ID');
                $filter->like('username', '用户名');
                $filter->like('memberInfo.id_card', '身份证');
                $filter->between('created_at', '注册时间')->datetime();
            });
            $filter->column(1/2, function ($filter) {
                $filter->like('email', 'Email');
                $filter->like('mobile', '手机号码');

                if(get_subsite_id()==0 && get_subsite_open()){
                    $filter->equal('subsite_id', '所属分站')->select(array_column(get_all_subsite(), 'sitename', 'id'));
                }

            });
        });
        return $grid;
    }

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

        $show->username('用户名');
        $show->mobile('mobile', '手机号');
        $show->email('email', '邮箱');
        $show->image('avatars', '用户头像');

        $show->reg_address('注册地址');

        $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('创建时间');
        return $show;
    }

    /**
     * Make a form builder.
     *
     * @return Form
     */
    protected function form()
    {
        $form = new ValidateForm(new Member);
        $form->tab('账号资料',function ($form) {
            $form->text('username', '用户名')->rules('required|between:6,16|regex:/^[a-zA-Z][a-zA-Z0-9]{6,16}+$/|unique:members', [
                'required' => '会员名为必填信息',
                'between' => '会员名长度为6~16个字符',
                'regex' => '会员名为字母或字母+数字',
                'unique' => '会员名已存在'
            ])->setWidth(3)->setMustMark();
            $form->mobile('mobile', '手机号')->rules('required|unique:members', [
                'required' => '手机号为必填信息',
                'unique' => '手机号已存在',
            ])->setWidth(3)->setMustMark();
            $form->radio('mobile_audit', '手机认证')->options([1 => '认证通过', 0 => '未认证'])->default(0);
            $form->email('email', 'Email')->rules('required|unique:members', [
                'required' => 'Email为必填信息',
                'unique' => 'Email已存在'
            ])->setWidth(3)->setMustMark();
            $form->radio('email_audit', '邮箱认证')->options([1 => '认证通过', 0 => '未认证'])->default(0);
            $form->password('password', '密码')->rules('required|confirmed|between:6,16', [
                'required' => '密码为必填信息',
                'between' => '密码长度要求为6~16'
            ])->setWidth(3)->setMustMark();
            $form->password('password_confirmation', '确认密码')->rules('required|between:6,16')->setWidth(3)->setMustMark();
            $form->radio('display_images', '是否显示头像')->options([1 => '显示', 2 => '隐藏'])->default(1);
            $form->image('avatars', '用户头像')->setWidth(4);
        })->tab('基本资料',function ($form) {
            $form->radio('display_name', '是否公开姓名')->setWidth(3)->options([1 => '公开', 3 => '隐藏'])->default(config('aix.personal_set.per_set.per_set.resume_display_default'))->setMustMark();
            $form->text('realname', '姓名')->setWidth(3)->rules('required', [
                'required' => '姓名为必填信息'
            ])->setMustMark();
            $form->radio('sex', '性别')->setWidth(3)->options([1 => '男', 2 => '女'])->default(1)->setMustMark();
            $birthday = [];
            $year = date('Y')-16;
            for($i=1950;$i<$year;$i++){
                $birthday[$i] = $i;
            }
            $form->select('birthday', '出生年份')->setWidth(3)->options($birthday)->default(1990)->setMustMark();
//            $form->select('card_t_cn', '证件类型')->setWidth(3)->options(Category::where('alias','AIX_card_type')->pluck('demand','id'))->rules('required',[
//                'required'=>'请选择证件类型'
//            ])->setMustMark();
            $form->text('id_card', '证件号')->setWidth(3)->rules('required|unique:member_infos', [
                'required' => '证件号为必填信息',
                'unique' => '该证件号已存在'
            ])->setMustMark();
            $form->select('province', '居住地省份')->options(CategoryDistrict::List()->pluck('name', 'id'))->setWidth(3)->load('city',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                'required'=>'请选择居住地省份'
            ])->setMustMark();
            $form->select('city', '居住地城市')->setWidth(3)->load('area',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                'required'=>'请选择居住地城市'
            ])->setMustMark();
//            $form->select('area', '居住地县区')->setWidth(3)->rules('required', [
//                'required'=>'请选择居住地县区'
//            ])->setMustMark();
            $form->select('education', '最高学历')->setWidth(3)->options(Category::where('alias','AIX_education')->pluck('demand','id'))->rules('required', [
                'required'=>'请选择最高学历'
            ])->setMustMark();
            $form->select('major1', '专业方向')->options(CategoryMajor::where('parent_id',0)->pluck('name', 'id'))->setWidth(3)->load('major2',  admin_base_path("/sys/category/categoryMaj"));
//            $form->select('major2', '详细专业')->setWidth(3);
            $form->select('experience', '工作经验')->options(Category::where('alias','AIX_experience')->pluck('demand','id'))->setWidth(3)->rules('required', [
                'required'=>'请选择工作经验'
            ])->setMustMark();
        })->tab('联系方式',function ($form) {
            $form->select('province1', '籍贯所属省份')->options(CategoryDistrict::List()->pluck('name', 'id'))->setWidth(3)->load('city1',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                'required'=>'请选择籍贯所属省份'
            ])->setMustMark();
            $form->select('city1', '籍贯所属城市')->setWidth(3)->load('area1',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                'required'=>'请选择籍贯所属城市'
            ])->setMustMark();
//            $form->select('area1', '籍贯所属县区')->setWidth(3)->rules('required', [
//                'required'=>'请选择相籍贯所属县区'
//            ])->setMustMark();
            $form->number('height', '身高')->setWidth(3);
            $form->select('marriage', '婚姻状况')->options(['1'=>'未婚','2'=>'已婚','3'=>'保密'])->setWidth(3);
            $form->number('qq', 'QQ')->setWidth(3);
            $form->text('weixin', '微信')->setWidth(3);
            $form->hidden('subsite_id', '所属分站')->default(get_subsite_id());
        });
        return $form;
    }

    public function store(Request $request)
    {

        $data = $this->form()->getValidateInput();//这个方法会调用Form自带的验证和表单处理(文件上传等)验证错误会直接返回错误.不需要判断;
        if($data['password'] != $data['password_confirmation']) {
            admin_toastr('两次密码输入不同', 'error');
            return back();
        }
        $member_data = [
            'username' => $data['username'],
            'password' => bcrypt($data['password']),
            'mobile' => $data['mobile'],
            'mobile_audit' => $data['mobile_audit'],
            'email' => $data['email'],
            'email_audit' => $data['email_audit'],
            'avatars' => $data['avatars'],
            'subsite_id' => $data['subsite_id'],
            'reg_time' => time(),
            'reg_ip' => ip2long('127.0.0.1'),
            'last_login_ip' => ip2long('127.0.0.1'),
            'reg_address' => '本机地址',
            'last_login_time' => time(),
            'status' => 1,
        ];
        $member_info_data = [
            'display_name'=>$data['display_name'],
            'realname'=>$data['realname'],
            'sex'=>$data['sex'],
            'sex_cn'=>$data['sex']==1?'男':'女',
            'birthday'=>$data['birthday'],
            'card_t_cn'=>306,
            'id_card'=>$data['id_card'],
            'residence'=>$data['province'].'.'.$data['city'].'.0',
            'education'=>$data['education'],
            'education_cn'=>get_category($data['education']),
            'experience'=>$data['experience'],
            'experience_cn'=>get_category($data['experience']),
            'phone'=>$data['mobile'],
            'email'=>$data['email'],
            'height'=>$data['height'],
            'qq'=>$data['qq'],
            'weixin'=>$data['weixin'],
            'marriage'=>$data['marriage'],
            'images'=>$data['avatars'],
            'marriage_cn'=>$data['marriage']==1?'未婚':($data['marriage']==2?'已婚':'保密'),
            'householdaddress'=>$data['province1'].'.'.$data['city1'].'.0',
        ];
        $member_info_data['residence_cn'] =get_district_cn($member_info_data['residence']);
        $member_info_data['householdaddress_cn'] =get_district_cn($member_info_data['householdaddress']);
        DB::beginTransaction();
        try {
            $member = Member::create($member_data);
            if(!$member){
                throw new \Exception('新增失败');
            }
            $member_info_data['uid'] = $member->id;
            if(!MemberInfo::create($member_info_data)){
                throw new \Exception('新增失败');
            }
            $this->memberSms('sms_quick_register', $data['mobile'],$data['username'], $data['password']);
            DB::commit();
            admin_toastr('新增成功', 'success');
        } catch (\Exception $e) {
            DB::rollback();
            admin_toastr($e->getMessage(), 'error');
            return back();
        }
        return redirect(route("members.index"));
    }

    protected function editForm($id)
    {
        $subsiteArr = [];
        $form = new ValidateForm(new Member);
        $user = Member::findOrFail($id);
        $userinfo = MemberInfo::where('uid',$id)->first();
        if(get_subsite_open()){
            $subsiteArr = array_column(get_all_subsite(), 'sitename', 'id');
        }
        $form->tab('账号资料',function ($form) use($user,$id ,$subsiteArr){
            $form->display('reg_time', '注册时间')->setWidth(2)->with(function ($reg_time) {
                return date('Y-m-d H:i:s', $reg_time);
            });
            $form->display('reg_ip', '注册IP')->setWidth(2)->with(function ($reg_ip) {
                return long2ip($reg_ip);
            });
            $form->display('last_login_time', '最后登录时间')->setWidth(2)->with(function ($last_login_time) {
                return $last_login_time ? date('Y-m-d H:i:s', $last_login_time) : '';
            });
            $form->display('last_login_ip', '最后登录IP')->setWidth(2)->with(function ($last_login_ip) {
                return long2ip($last_login_ip);
            });
            $form->display('reg_address', '注册地址')->setWidth(4);
            $form->html('基本信息');
            $form->text('username', '用户名')->rules(
                [
                    'required',
                    'between:6,16|regex:/^[a-zA-Z][a-zA-Z0-9]{6,16}+$/',
                    Rule::unique('members')->ignore($id),
                ],
                [
                    'required' => '会员名为必填信息',
                    'between' => '会员名长度为6~16个字符',
                    'regex' => '会员名为字母或字母+数字',
                    'unique' => '会员名已存在'
                ]
            )->setWidth(3)->setMustMark();
            $form->mobile('mobile', '手机号')->rules(
                [
                    'required',
                    Rule::unique('members')->ignore($id),
                ],
                [
                    'required' => '手机号码为必填信息',
                    'unique' => '手机号已存在',
                ]
            )->setWidth(4)->setMustMark();
            $form->radio('mobile_audit','手机认证')->options([1=>'认证通过',0=>'未认证'])->default($user->mobile_audit);
            $form->email('email', 'Email')->rules(
                [
                    'required',
                    'regex:/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/',
                    Rule::unique('members')->ignore($id),
                ],
                [
                    'required' => 'email为必填信息',
                    'regex' => 'email格式不正确',
                    'unique' => 'email已存在',
                ]
            )->setWidth(3)->setMustMark();
            $form->radio('email_audit','邮箱认证')->options([1=>'认证通过',0=>'未认证'])->default($user->email_audit);
            $form->switch('status', '用户状态');
            if (get_subsite_id()==0 && get_subsite_open()) {
                $form->radio('subsite_id', '分站')->options($subsiteArr)->default($user->subsite_id);
            } else {
                $form->hidden('subsite_id');
            }
        })->tab('基本资料',function ($form) use ($id,$userinfo){
            $form->radio('display_name', '是否公开姓名')->setWidth(3)->options([1 => '公开', 3 => '隐藏'])->default(isset($userinfo->display_name) ? $userinfo->display_name : '')->rules('required', [
                'required' => '请选择是否公开姓名'
            ])->setMustMark();
            $form->text('realname', '姓名')->setWidth(3)->default(isset($userinfo->realname) ? $userinfo->realname : '')->rules('required', [
                'required' => '姓名为必填信息'
            ])->setMustMark();
            $form->radio('sex', '性别')->setWidth(3)->options([1 => '男', 2 => '女'])->default(isset($userinfo->sex) ? $userinfo->sex : '')->rules('required', [
                'required' => '请选择性别'
            ])->setMustMark();
            $birthday = [];
            $year = date('Y')-16;
            for($i=1950;$i<$year;$i++){
                $birthday[$i] = $i;
            }
            $form->select('birthday', '出生年份')->setWidth(3)->options($birthday)->default(isset($userinfo->birthday) ? $userinfo->birthday : '')->setMustMark();
//            $form->select('card_t_cn', '证件类型')->setWidth(3)->options(Category::where('alias','AIX_card_type')->pluck('demand','id'))->rules('required',[
//                'required'=>'请选择证件类型'
//            ])->default(isset($userinfo->card_t_cn) ? $userinfo->card_t_cn : '')->setMustMark();
            $form->text('id_card', '证件号')->setWidth(3)->rules(
                [
                    'required',
                    Rule::unique('member_infos')->ignore($id,'uid'),
                ],
                [
                    'required' => '证件号为必填信息',
                    'unique' => '证件号已存在',
                ]
            )->default(isset($userinfo->id_card) ? $userinfo->id_card : '')->setMustMark();
            if (isset($userinfo->residence)) {
                $residenceArr = string_to_array('.', $userinfo->residence);
            }
            if(isset($residenceArr)) {
                $form->select('province', '居住地省份')->setWidth(3)->options(CategoryDistrict::List()->pluck('name', 'id'))->setWidth(3)->load('city',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                    'required'=>'请选择居住地省份'
                ])->default(isset($residenceArr[0])?$residenceArr[0]:0)->setMustMark();
                $form->select('city', '居住地城市')->setWidth(3)->options(CategoryDistrict::categoryDis(isset($residenceArr[0])?$residenceArr[0]:0))->load('area',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                    'required'=>'请选择居住地城市'
                ])->default(isset($residenceArr[1])?$residenceArr[1]:0)->setMustMark();
//                $form->select('area', '居住地县区')->setWidth(3)->options(CategoryDistrict::categoryDis(isset($residenceArr[1])?$residenceArr[1]:0))->rules('required', [
//                    'required'=>'请选择居住地县区'
//                ])->default(isset($residenceArr[2])?$residenceArr[2]:0)->setMustMark();
            } else {
                $form->select('province', '居住地省份')->options(CategoryDistrict::List()->pluck('name', 'id'))->setWidth(3)->load('city',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                    'required'=>'请选择居住地省份'
                ])->setMustMark();
                $form->select('city', '居住地城市')->setWidth(3)->load('area',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                    'required'=>'请选择居住地城市'
                ])->setMustMark();
//                $form->select('area', '居住地县区')->setWidth(3)->rules('required', [
//                    'required'=>'请选择居住地县区'
//                ])->setMustMark();
            }
            $form->select('education', '最高学历')->setWidth(3)->options(Category::where('alias','AIX_education')->pluck('demand','id'))->rules('required', [
                'required'=>'请选择最高学历'
            ])->default(isset($userinfo->education) ? $userinfo->education : '')->setMustMark();
            if(isset($userinfo->major)){
                $parent_id = CategoryMajor::where('id',$userinfo->major)->value('parent_id');
                $form->select('major1', '专业方向')->options(CategoryMajor::where('parent_id',0)->pluck('name', 'id'))->setWidth(3)->load('major2',  admin_base_path("/sys/category/categoryMaj"))->default($parent_id);
                //$form->select('major2', '详细专业')->setWidth(3)->options(CategoryMajor::where('parent_id',$parent_id)->pluck('name', 'id'))->default($userinfo->major);
            } else {
                $form->select('major1', '专业方向')->options(CategoryMajor::where('parent_id',0)->pluck('name', 'id'))->setWidth(3)->load('major2',  admin_base_path("/sys/category/categoryMaj"));
                //$form->select('major2', '详细专业')->setWidth(3);
            }
            $form->select('experience', '工作经验')->options(Category::where('alias','AIX_experience')->pluck('demand','id'))->setWidth(3)->rules('required', [
                'required'=>'请选择工作经验'
            ])->default(isset($userinfo->experience) ? $userinfo->experience : '')->setMustMark();
        })->tab('联系方式',function ($form) use ($userinfo){
            if(isset($userinfo->householdaddress)) {
                $householdaddressArr = string_to_array('.', $userinfo->householdaddress);
            }
            if(isset($householdaddressArr)) {
                $form->select('province1', '籍贯所属省份')->setWidth(3)->options(CategoryDistrict::List()->pluck('name', 'id'))->setWidth(3)->load('city1',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                    'required'=>'请选择籍贯所属省份'
                ])->default(isset($householdaddressArr[0])?$householdaddressArr[0]:0)->setMustMark();
                $form->select('city1', '籍贯所属城市')->setWidth(3)->options(CategoryDistrict::categoryDis(isset($householdaddressArr[0])?$householdaddressArr[0]:0))->load('area1',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                    'required'=>'请选择籍贯所属城市'
                ])->default(isset($householdaddressArr[1])?$householdaddressArr[1]:0)->setMustMark();
//                $form->select('area1', '籍贯所属县区')->setWidth(3)->options(CategoryDistrict::categoryDis(isset($householdaddressArr[1])?$householdaddressArr[1]:0))->rules('required', [
//                    'required'=>'请选择相籍贯所属县区'
//                ])->default(isset($householdaddressArr[2])?$householdaddressArr[2]:0)->setMustMark();
            }else {
                $form->select('province1', '籍贯所属省份')->options(CategoryDistrict::List()->pluck('name', 'id'))->setWidth(3)->load('city1',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                    'required'=>'请选择籍贯所属省份'
                ])->setMustMark();
                $form->select('city1', '籍贯所属城市')->setWidth(3)->load('area1',  admin_base_path("/sys/category/categoryDis"))->rules('required', [
                    'required'=>'请选择籍贯所属城市'
                ])->setMustMark();
//                $form->select('area1', '籍贯所属县区')->setWidth(3)->rules('required', [
//                    'required'=>'请选择相籍贯所属县区'
//                ])->setMustMark();
            }
            $form->number('height', '身高')->setWidth(3)->default(isset($userinfo->height) ? $userinfo->height : '');
            $form->select('marriage', '婚姻状况')->options(['1'=>'未婚','2'=>'已婚','3'=>'保密'])->setWidth(3)->default(isset($userinfo->marriage) ? $userinfo->marriage : '');
            $form->number('qq', 'QQ')->setWidth(3)->default(isset($userinfo->qq) ? $userinfo->qq : '');
            $form->text('weixin', '微信')->setWidth(3)->default(isset($userinfo->weixin) ? $userinfo->weixin : '');
        });
        return $form;
    }

    public function update($id)
    {
        $data = $this->editForm($id)->getValidateInput();//这个方法会调用Form自带的验证和表单处理(文件上传等)验证错误会直接返回错误.不需要判断;
        $member_data = [
            'username' => $data['username'],
            'mobile' => $data['mobile'],
            'mobile_audit' => $data['mobile_audit'],
            'email' => $data['email'],
            'email_audit' => $data['email_audit'],
            'subsite_id' => $data['subsite_id'],
            'reg_time' => time(),
            'reg_ip' => ip2long('127.0.0.1'),
            'last_login_ip' => ip2long('127.0.0.1'),
            'reg_address' => '本机地址',
            'last_login_time' => time(),
            'status' => 1,
        ];
        $member_info_data = [
            'display_name'=>$data['display_name'],
            'realname'=>$data['realname'],
            'sex'=>$data['sex'],
            'sex_cn'=>$data['sex']==1?'男':'女',
            'birthday'=>$data['birthday'],
            'card_t_cn'=>306,
            'id_card'=>$data['id_card'],
            'residence'=>$data['province'].'.'.$data['city'].'.0',
            'education'=>$data['education'],
            'education_cn'=>get_category($data['education']),
            'experience'=>$data['experience'],
            'experience_cn'=>get_category($data['experience']),
            'phone'=>$data['mobile'],
            'email'=>$data['email'],
            'height'=>$data['height'],
            'qq'=>$data['qq'],
            'weixin'=>$data['weixin'],
            'marriage'=>$data['marriage'],
            'marriage_cn'=>$data['marriage']==1?'未婚':($data['marriage']==2?'已婚':'保密'),
            'householdaddress'=>$data['province1'].'.'.$data['city1'].'.0',
        ];

        DB::beginTransaction();
        try {
            if (!Member::where('id', $id)->update($member_data)) {
                throw new \Exception('编辑失败');
            }
            if(MemberInfo::where('uid', $id)->first()) {
                if (!MemberInfo::where('uid', $id)->update($member_info_data)) {
                    throw new \Exception('编辑失败');
                }
            }else {
                $member_info_data['uid'] = $id;
                if (!MemberInfo::create($member_info_data)) {
                    throw new \Exception('编辑失败');
                }
            }
            $subsite_id =$data['subsite_id'];
            if ($subsite_id!==null) {
                $resume = Resume::where('uid', $id)->select('id', 'subsite_id')->get()->toArray();
                if (!empty($resume)) {
                    $resume_id = array_column($resume, 'id');
                    $subsite_id_arr = array_unique(array_column($resume, 'subsite_id'));
                    Resume::whereIn('id', $resume_id)->update(['subsite_id'=>$subsite_id]);
                    event_search_update(Resume::class, implode(',', $resume_id), 'update');
                    $SubsiteResume = SubsiteResume::whereIn('resume_id', $resume_id)->where('subsite_id', $subsite_id)->select('id')->get()->toArray();
                    if ($SubsiteResume) {
                        SubsiteResume::destroy(array_column($SubsiteResume, 'id'));
                    }
                    SubsiteResume::whereIn('subsite_id', $subsite_id_arr)->whereIn('resume_id', $resume_id)->update(['subsite_id'=>$subsite_id]);
                }
                event_search_update(Resume::class, [['where','uid', $id]], 'update');
            }
            DB::commit();
            admin_toastr('编辑成功', 'success');
        } catch (\Exception $e) {
            DB::rollback();
            admin_toastr($e->getMessage(), 'error');
            return back();
        }
        return redirect(route("members.index"));
    }

    public function destroy($id)
    {
        if (!$id) {
            $data = [
                'status'  => false,
                'message' => '会员信息不存在！！',
            ];
            return response()->json($data);
        }
        $id_arr =  explode(',', $id);

        \DB::beginTransaction();
        try {
            Member::destroy($id_arr);
            MemberInfo::whereIn('uid', $id_arr)->delete();
            Resume::whereIn('uid', $id_arr)->delete();
            ResumeImg::whereIn('uid', $id_arr)->delete();
            $data = [
                'status'  => true,
                'message' => '删除成功！',
            ];
            $condition = [['whereIn','uid', $id_arr]];
            event_search_update(Resume::class, $condition, 'delete');
            \DB::commit();
            return response()->json($data);
        } catch (\Exception $e) {
            \DB::rollback();
            $data = [
                'status'  => false,
                'message' => '删除失败！',
            ];
            return response()->json($data);
        }
    }

    public function manager($id)
    {
        $member = Member::findOrFail($id);
        if (!$member) {
            return false;
        }
        return redirect()->route('person.resume');
    }

    public function managerInto($id)
    {
        $member = Member::findOrFail($id);
        if (!$member) {
            return false;
        }
        $key=uniqid();
        Cache::put($key, $member, 1);
        $url=route('auth.thirdlogin.background', ['ticket' => $key])."?redirect_url=".urlencode(route('person.index'));
        return redirect($url);
    }

    /**
     *  return json
     */
    public function auditPassword(Request $request)
    {
        $id = $request->id;
        $form = new \Encore\Admin\Widgets\Form();
        $form->action(route('admin.personal.auditPass'));
        $form->disableReset();
        $form->hidden('id', 'ID')->default($id);
        $form->html('<div>重置的新密码为123456，是否重置？</div>');
        return json_encode(['html'=>$form->render(),'detail'=>'重置密码']);
    }

    public function auditPass(Request $request)
    {
        $id = $request->id;
        $arr = array_filter(explode(',', $id));
        if (empty($arr)) {
            admin_toastr('数据异常', 'error');
            return back();
        }
        $result = Member::whereIn('id', $arr)->update(['password'=>\Hash::make(123456)]);
        if ($result) {
            admin_toastr('重置成功', 'success');
        } else {
            admin_toastr('重置失败', 'error');
        }
        return back();
    }

    public function userInfoTab(Content $content, Request $request)
    {
        $uid = $request->uid;
        $utype = 2;
        $type = $request->type;
        if (empty($uid) ) {
            admin_toastr('数据异常', 'error');
            return back();
        }
        $tab = new Tab();

        $title = [
            'points'=>'积分管理',
            'order'=>'充值/订单',
            'subscribe'=>'简历推广',
            'apply'=>'申请的职位',
            'interview'=>'面试邀请',
            'log'=>'会员日志',
        ];

        foreach ($title as $key => $val) {
            switch ($key) {
                case 'points':
                    $grid = new Grid(new MembersHandsel);

                    $grid->model()->when(get_subsite_id()>0, function ($query) {
                        $query->whereHas('members',function ($query){
                            $query->where('subsite_id', get_subsite_id());
                        });
                    })->where(['uid'=>$uid,'utype'=>$utype])->orderBy('id', 'desc');

                    $grid->id('ID');
                    $grid->uid('会员ID');
                    $grid->utype('会员类型')->display(function ($utype) {
                        if ($utype==1) {
                            return '企业';
                        } else {
                            return '个人';
                        }
                    })->width(100);
                    $grid->points('操作积分')->display(function ($points) {
                        if ($this->operate==1) {
                            return "<span style='color:green;'>+".$points."</span>";
                        } else {
                            return "<span style='color:red;'>-".$points."</span>";
                        }
                    })->width(100);
                    $grid->htype_cn('操作说明')->width(150);
                    $grid->created_at('添加时间')->sortable();
                    $grid->updated_at('更新时间')->sortable();
                    $grid->disableTools();
                    $grid->disableActions();
                    $grid->setName($key);
                    $grid->disableRowSelector();
                    $grid->setPaginatorBaseUrl($key);
                    break;
                case 'order':
                    $grid = new Grid(new Order);
                    $grid ->model()->where(['uid'=>$uid,'utype'=>$utype])
                        ->when(get_subsite_id()>0, function ($querys) use ($utype) {
                            if ($utype ==1) {
                                $relations = 'companys';
                            } else {
                                $relations = 'members';
                            }
                            $querys->whereHas($relations, function ($query) {
                                $query->where('subsite_id', get_subsite_id());
                            });
                        })->orderBy('created_at', 'desc')->orderBy("is_pay", 'asc');
                    $grid->id('ID');
                    $grid->is_pay('支付状态')->display(function ($is_pay) {
                        if ($is_pay == 1) {
                            return '待付款';
                        } elseif ($is_pay == 2) {
                            return "已付款";
                        } else {
                            return '已取消';
                        }
                    });
                    $grid->amount('金额')->width(150);
                    if ($utype == 1) {
                        $grid->column('companys.companyname', '企业名称')->width(200);
                    } else {
                        $grid->column('members.username', '会员名称')->width(200);
                    }

                    $grid->service_name('说明')->width(150);;
                    if ($utype == 1) {
                        $grid->column('companys.username', '企业会员')->width(200);
                    } else {
                        $grid->column('members.username', '个人会员')->width(200);
                    }
                    $grid->oid('订单号')->width(200);
                    $grid->payment_cn('支付方式')->width(150);
                    $grid->created_at('申请时间')->sortable();
                    $grid->disableTools();
                    $grid->disableActions();
                    $grid->setName($key);
                    $grid->disableRowSelector();
                    $grid->setPaginatorBaseUrl($key);
                    break;
                case 'subscribe':
                    $grid = new Grid(new PersonalServiceStickLog);
                    $grid->model()->where('resume_uid',$uid)->when(get_subsite_id()>0, function ($query) {
                        $query->whereHas('resume', function ($query) {
                            $query->where('subsite_id', get_subsite_id());
                        });
                    })->orderBy('created_at', 'DESC');

                    $grid->column('resume.fullname', '姓名')->width(200);;

                    $grid->resume_uid('会员ID');
                    $grid->days('推广天数')->width(100);
                    $grid->addtime('开始时间')->display(function ($addtime) {
                        return date('Y-m-d H:i:s', $addtime);
                    })->sortable();
                    $grid->endtime('结束时间')->display(function ($endtime) {
                        return date('Y-m-d H:i:s', $endtime);
                    })->sortable();
                    $grid->disableTools();
                    $grid->disableActions();
                    $grid->setName($key);
                    $grid->disableRowSelector();
                    $grid->setPaginatorBaseUrl($key);
                    break;
                case 'apply':
                    $grid = new Grid(new PersonalJobsApply);
                    $grid->model()->where('personal_uid',$uid)->when(get_subsite_id()>0, function ($query) {
                        $query->whereHas('resumes', function ($query) {
                            $query->where('subsite_id', get_subsite_id());
                        });
                    })->orderBy('id', 'desc');

                    $grid->id('ID');
                    $grid->jobs_name('职位名称')->width(200);

                    $grid->company_name('公司名称')->width(200);

                    $grid->resume_name('简历名称')->width(150);

                    $grid->is_reply('反馈状态')->display(function ($is_reply) {
                        switch ($is_reply) {
                            case 1:
                                $is_reply = '企业未查看';
                                break;
                            case 2:
                                $is_reply = '待反馈';
                                break;
                            case 3:
                                $is_reply = '合适';
                                break;
                            case 4:
                                $is_reply = '不合适';
                                break;
                            case 5:
                                $is_reply = '待定';
                                break;
                            case 6:
                                $is_reply = '未接通';
                                break;
                            default:
                                $is_reply = '企业未查看';
                                break;
                        }
                        return $is_reply;
                    });

                    $grid->column('members.subsite_id', '所属分站')->display(function ($subsite_id) {
                        if ($subsite_id) {
                            $Subsite = Subsite::find($subsite_id);
                            return isset($Subsite->sitename) ? $Subsite->sitename : '未知';
                        }
                        return '总站';
                    })->width(150);
                    $grid->created_at('申请时间')->sortable();
                    $grid->updated_at('更新时间')->sortable();
                    $grid->disableTools();
                    $grid->disableActions();
                    $grid->setName($key);
                    $grid->disableRowSelector();
                    $grid->setPaginatorBaseUrl($key);
                    break;
                case 'interview':
                    $grid = new Grid(new CompanyInterView);
                    $grid->model()->where('resume_uid',$uid)->when(get_subsite_id()>0, function ($query) {
                        $query->whereHas('resumes', function ($query) {
                            $query->where('subsite_id', get_subsite_id());
                        });
                    })->orderBy('id', 'desc');

                    $grid->id('ID');
                    $grid->jobs_name('职位名称')->width(200);

                    $grid->company_name('公司名称')->width(200);

                    $grid->resume_name('简历名称')->width(150);

                    $grid->personal_look('查看状态')->display(function ($personal_look) {
                        switch ($personal_look) {
                            case 1:
                                $personal_look = '未查看';
                                break;
                            case 2:
                                $personal_look = '已查看';
                                break;
                            default:
                                $personal_look = '未查看';
                                break;
                        }
                        return $personal_look;
                    });
                    $grid->interview_time('邀请时间')->display(function ($interview_time) {
                        return date('Y-m-d H:i:s', $interview_time);
                    })->sortable();

                    $grid->column('members.subsite_id', '所属分站')->display(function ($subsite_id) {
                        if ($subsite_id) {
                            $Subsite = Subsite::find($subsite_id);
                            return isset($Subsite->sitename) ? $Subsite->sitename : '未知';
                        }
                        return '总站';
                    })->width(150);
                    $grid->created_at('申请时间')->sortable();
                    $grid->updated_at('更新时间')->sortable();
                    $grid->disableTools();
                    $grid->disableActions();
                    $grid->setName($key);
                    $grid->disableRowSelector();
                    $grid->setPaginatorBaseUrl($key);
                    break;
                case 'log':
                    $grid = new Grid(new MembersLog);
                    $grid->model()->where(['log_uid'=>$uid,'log_utype'=>$utype])->when(get_subsite_id()>0, function ($query) {
                        $query->whereHas('members', function ($query) {
                            $query->where('subsite_id', get_subsite_id());
                        });
                    })->orderBy('id', 'desc');
                    $grid->id('ID');
                    $grid->log_username('用户名')->width(200);
                    $grid->log_value('日志说明')->width(300);
                    $grid->log_ip('ip')->display(function ($log_ip){
                        return long2ip($log_ip);
                    })->width(150);
                    $grid->log_address('登录地址')->width(150);
                    $grid->log_utype('会员类型')->display(function ($log_utype) {
                        if($log_utype==1){
                            return '企业';
                        }else{
                            return '个人';
                        }
                    });
                    $grid->log_source('操作途径')->width(150);
                    $grid->created_at('申请时间')->sortable();
                    $grid->updated_at('更新时间')->sortable();
                    $grid->disableTools();
                    $grid->disableActions();
                    $grid->setName($key);
                    $grid->disableRowSelector();
                    $grid->setPaginatorBaseUrl($key);

                    break;
            }
            $tab->add($val, view('admin.company.content')->with('contents', $grid), $type == $key);

        }
        return $content
            ->header('会员信息')
            ->description('列表')
            ->body($tab);

    }

    protected function memberSms($sms_id, $mobile, $username, $password)
    {
        $SmsRule = SmsRule::where('alias', $sms_id)->first();
        if (isset($SmsRule->status) && !empty($SmsRule->status)) {
            if ($mobile) {
                $this->smsService->sendSms($mobile, $sms_id, ['username'=>$username,'password'=>$password]);
            }
        }
    }

}