isAjax()){ $param = input('param.'); $limit = $param['pageSize']; $offset = (($param['pageNumber'] - 1) * $limit); $where = []; if (strlen($param['searchText'])) { if($param['account'] == 'account_name'){ $where['account_name'] = ['like', '%' . $param['searchText'] . '%']; } if($param['account'] == 'nick_name'){ $where['nick_name'] = ['like', '%' . $param['searchText'] . '%']; } } //标签 if ($param['label_id'] != '' && $param['label_id'] != 0) { $where['label_id'] = $param['label_id']; } if (strlen($param['start']) && strlen($param['end']) && $param['start'] <= $param['end']) { $start = strtotime($param['start']); $end = strtotime($param['end'] . ' 23:59:59'); $return['total'] = db('accounts')->where($where)->whereBetween('add_time', [$start, $end])->count(); //总数据 } $result = db('accounts')->whereBetween('add_time', [$start, $end])->where($where)->limit($offset, $limit)->order('add_time', 'desc')->select(); //所有客服 $users = db('users')->select(); //所有标签 $label = db('accountslabel')->select(); foreach($result as $key=>$vo){ $result[$key]['add_time'] = date('Y-m-d H:i:s',$result[$key]['add_time']); $result[$key]['last_login_time'] = date('Y-m-d H:i:s',$result[$key]['last_login_time']); for($i=0;$imakeBtn($vo['id']); } //$return['total'] = db('accounts')->count(); //总数据 $return['rows'] = $result; return json($return); } //所有标签 $label = db('accountslabel')->select(); if(!empty($label)){ $option = '会员标签'; for($i=0;$i'.$label[$i]['name'].''; } $labeloption = ''.$option.''; } $this->assign([ 'label' => $label, 'labeloption' => $labeloption, 'status' => config('kf_status') ]); return $this->fetch(); } //用户信息导出 public function toexcel() { $param = input('param.'); $start = $param['start']; $end = $param['end']; $where = []; if(!empty($param['label_id'])){ $where['label_id'] = $param['label_id']; } if($param['account'] == 'account_name'){ if(!empty($param['username'])){ $where['account_name'] = ['like', '%' . $param['username'] . '%']; } } if($param['account'] == 'nick_name'){ if(!empty($param['username'])){ $where['nick_name'] = ['like', '%' . $param['username'] . '%']; } } $result = db('accounts')->whereBetween('add_time', [strtotime($start), strtotime($end . ' 23:59:59')])->where($where)->order('add_time', 'desc')->select(); //所有标签 $label = db('accountslabel')->select(); foreach($result as $key=>$vo){ $result[$key]['add_time'] = date('Y-m-d H:i:s',$result[$key]['add_time']); $result[$key]['last_login_time'] = date('Y-m-d H:i:s',$result[$key]['last_login_time']); $result[$key]['label'] = ''; for($j=0;$joutdata('会员数据导出', $result, $head, $key); return true; } // 重置用户密码为 123456 public function resetPwd() { if(request()->isAjax()){ $id = input('param.id/d'); $password = md5('123456' . config('salt')); try{ db('accounts')->where('id', $id)->update(['password' => $password]); }catch(\Exception $e){ return json(['code' => -1, 'data' => '', 'msg' => $e->getMessage()]); } return json(['code' => 1, 'data' => 'accounts/index', 'msg' => '重置密码成功']); } } // 编辑用户 public function edit() { if(request()->isAjax()){ $param = input('post.'); $info = array(); $rules = '/^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/'; if(!empty($param['account_email'])){ if(!preg_match($rules,$param['account_email'])){ return json(['code' => -9, 'data' => '', 'msg' => '请输入正确的邮箱']); } } if(!empty($param['account_phone'])){ if(!preg_match("/^1[34578]\d{9}$/", $param['account_phone'])){ return json(['code' => -10, 'data' => '', 'msg' => '请输入正确的手机号码']); } } if($param['label_id'] == 0){ return json(['code' => -10, 'data' => '', 'msg' => '请选择用户标签']); } $info['nick_name'] = $param['nick_name']; $info['account_email'] = $param['account_email']; $info['account_phone'] = $param['account_phone']; $info['address'] = $param['address']; $info['label_id'] = $param['label_id']; $info['remark'] = $param['remark']; if(!empty($param['user_id']) && $param['user_id'] != 0){ $info['user_id'] = $param['user_id']; } $update = array(); $update['nick_name'] = $param['nick_name']; $update['email'] = $param['account_email']; $update['phone'] = $param['account_phone']; try{ db('accounts')->where('id', $param['id'])->update($info); $accounts = db('accountsmessage')->where('account_id', $param['id'])->select(); if(!empty($accounts)){ db('accountsmessage')->where('account_id', $param['id'])->update($update); } }catch(\Exception $e){ return json(['code' => -6, 'data' => '', 'msg' => $e->getMessage()]); } return json(['code' => 1, 'data' => url('accounts/index'), 'msg' => '编辑用户成功']); } $id = input('param.id/d'); $info = db('accounts')->where('id', $id)->find(); $label = db('accountslabel')->where('id', $info['label_id'])->find(); $info['label'] = $label['name']; //所有标签 $label = db('accountslabel')->select(); //服务记录 //前一个月的时间戳 $start = time()-2592000; //当前时间戳 $end = time(); $service_log = db('service_log a')->join('users b','a.kf_id=b.id')->field('a.servicelog_id,a.start_time,b.user_name')->whereBetween('a.start_time', [$start, $end])->where('a.user_id', $id)->order('a.start_time','desc')->select(); for($i=0;$iselect(); $this->assign([ 'info' => $info, 'users' => $users, 'label' => $label, 'service_log' => $service_log, 'status' => config('kf_status') ]); return $this->fetch(); } // 删除用户 public function delAccount() { if(request()->isAjax()){ $id = input('param.id/d'); try{ db('accounts')->where('id', $id)->delete(); }catch(\Exception $e){ return json(['code' => -1, 'data' => '', 'msg' => $e->getMessage()]); } return json(['code' => 1, 'data' => 'accounts/index', 'msg' => '删除客服成功']); } } // 生成按钮 private function makeBtn($id) { //$operate = ' 重置密码'; $operate = ' 编辑 '; // $operate .= ''; // $operate .= ' 删除 '; return $operate; } // 用户标签列表 public function label() { if(request()->isAjax()){ $param = input('param.'); $limit = $param['pageSize']; $offset = (($param['pageNumber'] - 1) * $limit); $where = []; // if (strlen($param['searchText'])) { // $where['name'] = ['like', '%' . $param['searchText'] . '%']; // } $result = db('accountslabel')->where($where)->limit($offset, $limit)->order('id', 'asc')->select(); foreach($result as $key=>$vo){ $result[$key]['add_time'] = date('Y-m-d H:i:s',$result[$key]['add_time']); // 生成操作按钮 if($vo['id'] != 1){ $result[$key]['operate'] = $this->makeBtnLabel($vo['id']); }else{ $result[$key]['operate'] = $operate = ' 编辑 '; } } $return['total'] = db('accountslabel')->count(); //总数据 $return['rows'] = $result; return json($return); } $this->assign([ 'socket' => config('socket'), ]); return $this->fetch(); } // 添加用户标签 public function addlabel() { if (request()->isAjax()) { $param = input('post.'); $has = db('accountslabel')->where('name',$param['name'])->find(); if(!empty($has)){ return json(['code' => -1, 'data' => '', 'msg' => '此用户标签已存在']); } $info = array(); $info['name'] = $param['name']; $info['add_time'] = time(); try { db('accountslabel')->insert($info); } catch (\Exception $e) { return json(['code' => -2, 'data' => '', 'msg' => $e->getMessage()]); } return json(['code' => 1, 'data' => '', 'msg' => '添加用户标签成功']); } $this->assign([ 'status' => config('kf_status'), 'socket' => config('socket'), ]); return $this->fetch(); } // 编辑用户标签 public function editlabel() { // 菜单id $id = input('param.id/d'); if (request()->isAjax()) { $param = input('post.'); $has = db('accountslabel')->where('name',$param['name'])->where('id','<>',$id)->find(); if(!empty($has)){ return json(['code' => -1, 'data' => '', 'msg' => '此用户标签已存在']); } $info = array(); $info['name'] = $param['name']; try { db('accountslabel')->where('id', $param['id'])->update($info); } catch (\Exception $e) { return json(['code' => -2, 'data' => '', 'msg' => $e->getMessage()]); } return json(['code' => 1, 'data' => '', 'msg' => '编辑用户标签成功']); } $label = db('accountslabel')->where('id',$id)->find(); $this->assign([ 'label' => $label, 'id' => $id, 'socket' => config('socket'), 'status' => config('kf_status') ]); return $this->fetch(); } // 删除用户标签 public function delLabel() { if (request()->isAjax()) { //留言类型id $id = input('param.id/d'); try { db('accounts')->where('label_id', $id)->update(['label_id'=>1]); db('accountslabel')->where('id', $id)->delete(); } catch (\Exception $e) { return json(['code' => -1, 'data' => '', 'msg' => $e->getMessage()]); } return json(['code' => 1, 'data' => '', 'msg' => '删除用户标签成功']); } } // 生成标签按钮 private function makeBtnLabel($id) { $operate = ' 编辑 '; $operate .= ''; $operate .= ' 删除 '; return $operate; } }