// +---------------------------------------------------------------------- namespace app\admin\controller; use think\Db; use app\admin\model\MemberList; class Member extends Base { /* * 用户管理 */ public function member_list(){ $key=input('key'); $opentype_check=input('opentype_check',''); $activetype_check=input('activetype_check',''); $membertype_check=input('membertype_check',''); $where=array(); if($opentype_check !== ''){ $where['member_list_open']=$opentype_check; } if($activetype_check !== ''){ $where['user_status']=$activetype_check; } if($membertype_check !== ''){ $where['member_list_groupid']=$membertype_check; } $member_model=new MemberList; $member_list=$member_model->alias('a')->join(config('database.prefix').'member_group b','a.member_list_groupid=b.member_group_id') ->where($where)->where('member_list_username|member_list_tel|member_list_email|member_list_tel2|member_list_tel3','like',"%".$key."%") ->order('member_list_addtime desc')->paginate(config('paginate.list_rows'),false,['query'=>get_query()]); $show=$member_list->render(); $show=preg_replace("(]*page[=|/](\d+).+?>(.+?)<\/a>)","$2",$show); $this->assign('opentype_check',$opentype_check); $this->assign('activetype_check',$activetype_check); $this->assign('membertype_check',$membertype_check); $this->assign('member_list',$member_list); $this->assign('page',$show); $this->assign('val',$key); $member_group=Db::name('member_group')->order('member_group_order')->select(); $this->assign('groups',$member_group); if(request()->isAjax()){ return $this->fetch('ajax_member_list'); }else{ return $this->fetch(); } } /* * 添加用户显示 */ public function member_add(){ $province = Db::name('Region')->where ( array('pid'=>1) )->select (); $this->assign('province',$province); $member_group=Db::name('member_group')->order('member_group_order')->select(); $this->assign('member_group',$member_group); return $this->fetch(); } /* * 添加用户操作 */ public function member_runadd(){ if (!request()->isAjax()){ $this->error('提交方式不正确',url('admin/Member/member_list')); }else{ $member_list_salt=random(10); $sl_data=array( 'member_list_groupid'=>input('member_list_groupid'), 'member_list_username'=>input('member_list_username'), 'first_pwd'=>input('first_pwd'), 'member_list_salt' => $member_list_salt, 'member_list_pwd'=>encrypt_password(input('member_list_pwd'),$member_list_salt), 'member_list_nickname'=>input('member_list_nickname'), 'member_list_province'=>input('member_list_province'), 'member_list_city'=>input('member_list_city'), 'member_list_town'=>input('member_list_town'), 'member_list_sex'=>input('member_list_sex'), 'member_list_tel'=>input('member_list_tel'), 'member_list_email'=>input('member_list_email'), 'member_list_open'=>input('member_list_open',0), 'user_url'=>input('user_url'), 'member_list_addtime'=>time(), 'user_status'=>input('user_status',0), 'signature'=>input('signature'), 'score'=>input('score',0,'intval'), 'coin'=>input('coin',0,'intval'), ); $rst=MemberList::create($sl_data); if($rst!==false){ $this->success('会员添加成功',url('admin/Member/member_list')); }else{ $this->error('会员添加失败',url('admin/Member/member_list')); } } } /* * 修改用户信息界面 */ public function member_edit(){ $province = Db::name('Region')->where ( array('pid'=>1) )->select (); $member_group=Db::name('member_group')->order('member_group_order')->select(); $member_list_edit=Db::name('member_list')->where(array('member_list_id'=>input('member_list_id')))->find(); $city=Db::name('Region')->where ( array('pid'=>$member_list_edit['member_list_province']) )->select (); $town=Db::name('Region')->where ( array('pid'=>$member_list_edit['member_list_city']) )->select (); $this->assign('member_list_edit',$member_list_edit); $this->assign('province',$province); $this->assign('city',$city); $this->assign('town',$town); $this->assign('member_group',$member_group); return $this->fetch(); } /* * 修改用户操作 */ public function member_runedit(){ if (!request()->isAjax()){ $this->error('提交方式不正确',url('admin/Member/member_list')); }else{ $sl_data['member_list_id']=input('member_list_id'); $sl_data['member_list_groupid']=input('member_list_groupid'); $sl_data['member_list_username']=input('member_list_username'); $pwd=input('member_list_pwd'); if (!empty($pwd)){ $member_list_salt=random(10); $sl_data['member_list_salt']=$member_list_salt; $sl_data['member_list_pwd']=encrypt_password($pwd,$member_list_salt); } $sl_data['first_pwd']=input('first_pwd'); $sl_data['member_list_nickname']=input('member_list_nickname'); $sl_data['member_list_province']=input('member_list_province'); $sl_data['member_list_city']=input('member_list_city'); $sl_data['member_list_town']=input('member_list_town'); $sl_data['member_list_sex']=input('member_list_sex'); $sl_data['member_list_tel']=input('member_list_tel'); $sl_data['member_list_nickname2']=input('member_list_nickname2'); $sl_data['member_list_tel2']=input('member_list_tel2'); $sl_data['member_list_tel3']=input('member_list_tel3'); $sl_data['member_list_email']=input('member_list_email'); $sl_data['user_status']=input('user_status',0); $sl_data['member_list_open']=input('member_list_open',0); $sl_data['user_url']=input('user_url'); $sl_data['signature']=input('signature'); $sl_data['score']=input('score',0,'intval'); $sl_data['coin']=input('coin',0,'intval'); $rst=MemberList::update($sl_data); if($rst!==false){ $this->success('会员修改成功',url('admin/Member/member_list')); }else{ $this->error('会员修改失败',url('admin/Member/member_list')); } } } /* * 会员禁止/取消禁止 */ public function member_state(){ $id=input('x'); $member_model=new MemberList; $status=$member_model->where(array('member_list_id'=>$id))->value('member_list_open');//判断当前状态情况 if($status==1){ $statedata = array('member_list_open'=>0); $member_model->where(array('member_list_id'=>$id))->setField($statedata); $this->success('状态禁止'); }else{ $statedata = array('member_list_open'=>1); $member_model->where(array('member_list_id'=>$id))->setField($statedata); $this->success('状态开启'); } } /* * 会员激活/取消激活 */ public function member_active() { $id=input('x'); $member_model=new MemberList; $status=$member_model->where(array('member_list_id'=>$id))->value('user_status');//判断当前状态情况 if($status==1){ $statedata = array('user_status'=>0); $member_model->where(array('member_list_id'=>$id))->setField($statedata); $this->success('未激活'); }else{ $statedata = array('user_status'=>1); $member_model->where(array('member_list_id'=>$id))->setField($statedata); $this->success('已激活'); } } /* * 会员删除 */ public function member_del() { $p=input('p'); $member_list_id=input('member_list_id'); $member_model=new MemberList; $rst=Db::name('admin')->where('member_id',$member_list_id)->find(); if($rst){ $this->error('此会员已关联管理员,请从管理员处删除',url('admin/Member/member_list', array('p' => $p))); }else{ $rst=$member_model->where(array('member_list_id'=>$member_list_id))->delete(); if($rst!==false){ $this->success('会员删除成功',url('admin/Member/member_list', array('p' => $p))); }else{ $this->error('会员删除失败',url('admin/Member/member_list', array('p' => $p))); } } } /* *会员组显示列表 */ public function member_group_list() { $member_group=Db::name('member_group'); $member_group_list=$member_group->order('member_group_order')->select(); $this->assign('member_group_list',$member_group_list); return $this->fetch(); } /* * 会员组添加方法 */ public function member_group_runadd() { if (!request()->isAjax()){ $this->error('提交方式不正确',url('admin/Member/member_group_list')); }else{ $rst=Db::name('member_group')->insert(input('post.')); if($rst!==false){ $this->success('会员组添加成功',url('admin/Member/member_group_list')); }else{ $this->error('会员组添加失败',url('admin/Member/member_group_list')); } } } /* * 会员组删除 */ public function member_group_del() { $member_group_id=input('member_group_id'); if (empty($member_group_id)){ $this->error('会员组ID不存在',url('admin/Member/member_group_list')); } $rst=Db::name('member_group')->where(array('member_group_id'=>input('member_group_id')))->delete(); if($rst!==false){ $this->success('会员组删除成功',url('admin/Member/member_group_list')); }else{ $this->error('会员组删除失败',url('admin/Member/member_group_list')); } } /* * 改变会员组状态 */ public function member_group_state() { $member_group_id=input('x'); if (!$member_group_id){ $this->error('ID:'.$member_group_id.'不存在',url('admin/Member/member_group_list')); } $status=Db::name('member_group')->where(array('member_group_id'=>$member_group_id))->value('member_group_open');//判断当前状态情况 if($status==1){ $statedata = array('member_group_open'=>0); Db::name('member_group')->where(array('member_group_id'=>$member_group_id))->setField($statedata); $this->success('状态禁止'); }else{ $statedata = array('member_group_open'=>1); Db::name('member_group')->where(array('member_group_id'=>$member_group_id))->setField($statedata); $this->success('状态开启'); } } /* * 排序更新 */ public function member_group_order() { if (!request()->isAjax()){ $this->error('提交方式不正确',url('admin/Member/member_group_list')); }else{ $post=input('post.'); foreach ($post as $id => $sort){ Db::name('member_group')->where(array('member_group_id' => $id ))->setField('member_group_order' , $sort); } $this->success('排序更新成功',url('admin/Member/member_group_list')); } } /* * 修改会员组返回值 */ public function member_group_edit() { $member_group_id=input('member_group_id'); $member_group=Db::name('member_group')->where(array('member_group_id'=>$member_group_id))->find(); $sl_data['member_group_id']=$member_group['member_group_id']; $sl_data['member_group_name']=$member_group['member_group_name']; $sl_data['member_group_open']=$member_group['member_group_open']; //$sl_data['member_group_toplimit']=$member_group['member_group_toplimit']; //$sl_data['member_group_bomlimit']=$member_group['member_group_bomlimit']; $sl_data['member_group_order']=$member_group['member_group_order']; $sl_data['code']=1; return json($sl_data); } /* * 修改用户组方法 */ public function member_group_runedit() { if (!request()->isAjax()){ $this->error('提交方式不正确',url('admin/Member/member_group_list')); }else{ $sl_data=array( 'member_group_id'=>input('member_group_id'), 'member_group_name'=>input('member_group_name'), //'member_group_toplimit'=>input('member_group_toplimit'), //'member_group_bomlimit'=>input('member_group_bomlimit'), 'member_group_order'=>input('member_group_order'), ); $rst=Db::name('member_group')->update($sl_data); if($rst!==false){ $this->success('会员组修改成功',url('admin/Member/member_group_list')); }else{ $this->error('会员组修改失败',url('admin/Member/member_group_list')); } } } }