search

博客列表 >后台三 账号列表

后台三 账号列表

自由之上
自由之上原创
2021年03月12日 09:19:031000浏览

一、账号列表 模块

1、创建 账号列表 视图模板

resources/views/admins/admin/index.blade.php

  1. <!doctype html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta name="viewport"
  6.           content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
  7.     <meta http-equiv="X-UA-Compatible" content="ie=edge">
  8.     <title>管理员列表</title>
  9.     <link rel="stylesheet" type="text/css" href="/static/layui/css/layui.css">
  10.     <script type="text/javascript" src="/static/layui/layui.js"></script>
  11. </head>
  12. <body style="padding:10px;">
  13. <div style="text-align:right;">
  14.     <button class="layui-btn layui-btn-sm" onclick="add()"><i class="layui-icon layui-icon-addition"></i>添加</button>
  15. </div>
  17. <table class="layui-table">
  18.     <thead>
  19.     <tr>
  20.         <th>ID</th>
  21.         <th>用户名</th>
  22.         <th>角色</th>
  23.         <th>真实姓名</th>
  24.         <th>手机号</th>
  25.         <th>最后登录时间</th>
  26.         <th>状态</th>
  27.         <th>操作</th>
  28.     </tr>
  29.     </thead>
  30.     <tbody>
  31.     @foreach($list as $item)
  32.         <tr>
  33.             <td>{{$item['id']}}</td>
  34.             <td>{{$item['username']}}</td>
  35.             <td>{{isset($groups[$item['gid']])?$groups[$item['gid']]['title']:''}}</td>
  36.             <td>{{$item['real_name']}}</td>
  37.             <td>{{$item['phone']}}</td>
  38.             <td>{{$item['lastlogin']>0?date('Y-m-d H:i:s',$item['lastlogin']):''}}</td>
  39.             <td>{!! $item['status']==0?'<span style="color:green">正常</span>':'<span style="color:red;">禁用</span>' !!}</td>
  40.             <td>
  41.                 <button class="layui-btn layui-btn-xs layui-btn-normal" onclick="edit({{$item['id']}})">修改</button>
  42.                 <button class="layui-btn layui-btn-xs layui-btn-danger" onclick="del({{$item['id']}})">删除</button>
  43.             </td>
  44.         </tr>
  45.     @endforeach
  46.     </tbody>
  47. </table>
  49. <script>
  50.     layui.use(['layer'], function () {
  51.         $ = layui.jquery;
  52.         layer = layui.layer;
  53.     });
  55.     //添加管理员
  56.     function add() {
  57.         layer.open({
  58.             type: 2,
  59.             title: '添加管理员',
  60.             shade: 0.3,
  61.             area: ['500px', '450px'],
  62.             content: '/admins/admin/add'
  63.         });
  64.     }
  66.     //修改管理员
  67.     function edit(id) {
  68.         layer.open({
  69.             type: 2,
  70.             title: '修改管理员',
  71.             shade: 0.3,
  72.             area: ['500px', '450px'],
  73.             content: '/admins/admin/edit?id=' + id
  74.         });
  75.     }
  77.     //删除管理员
  78.     function del(id) {
  79.         layer.confirm('确定要删除吗？', {
  80.             icon: 3,
  81.             btn: ['确定', '取消']
  82.         }, function () {
  83.             $.get('/admins/admin/del', {admin_id: id}, function (res) {
  84.                 if(res.code>0){
  85.                     return layer.alert(res.msg,{icon:2});
  86.                 }
  87.                 layer.msg(res.msg);
  88.                 setTimeout(function () {
  89.                     window.location.reload();
  90.                 },500);
  91.             },'json');
  92.         });
  93.     }
  94. </script>
  96. </body>
  97. </html>

2、提供者
在数据库服务提供者文件中添加函数
app/Providers/DBServiceProvider.php

  1. // 查询数据列表
  2. QueryBuilder::macro('lists', function () {
  3.     $data = $this->get()->toArray();
  4.     foreach ($data as $key => $val) {
  5.         $data[$key] = (array)$val;
  6.     }
  7.     return $data;
  8. });
  10. // 自定义索引
  11. QueryBuilder::macro('cates', function ($index) {
  12.     $data = $this->get()->toArray();
  13.     $res = [];
  14.     foreach ($data as $key => $val) {
  15.         $res[$val->$index] = (array)$val;
  16.     }
  17.     return $res;
  18. });


3、创建 账号列表 控制器

app/Http/Controllers/admins/Admin.php

  1. <?php
  2. namespace App\Http\Controllers\admins;
  3. use App\Http\Controllers\Controller;
  5. /**
  6.  * 账号列表 控制器
  7.  * @package App\Http\Controllers\admins
  8.  */
  9. class Admin extends Controller {
  11. }


4、添加 处理账号列表 函数
app/Http/Controllers/admins/Admin.php

  1. use Illuminate\Support\Facades\DB;
  3. /**
  4. * 管理员列表
  5. * @return \Illuminate\Contracts\View\Factory|\Illuminate\Contracts\View\View
  6. */
  7. public function index() {
  8.   $data['list'] = DB::table('admin')->orderBy('id', 'desc')->lists();
  9.   $data['groups'] = DB::table('admin_group')->cates('gid');
  10.   return view('/admins/admin/index', $data);
  11. }


5、注册 账号列表 路由

  1. use App\Http\Controllers\admins\Admin;
  3. //显示账号列表
  4. Route::get('/admins/admin/index', [Admin::class, 'index']);


6、查看效果

二、添加与保存账号 模块

1、创建 添加账号 视图模板

resources/views/admins/admin/add.blade.php

  1. <!doctype html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta name="viewport"
  6.           content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
  7.     <meta http-equiv="X-UA-Compatible" content="ie=edge">
  8.     <title>添加管理员</title>
  9.     <link rel="stylesheet" type="text/css" href="/static/layui/css/layui.css">
  10.     <script type="text/javascript" src="/static/layui/layui.js"></script>
  11. </head>
  12. <body style="padding:10px;">
  13. <div class="layui-form">
  14.     @csrf
  15.     <div class="layui-form-item">
  16.         <label class="layui-form-label">用户名</label>
  17.         <div class="layui-input-block">
  18.             <input type="text" class="layui-input" name="username">
  19.         </div>
  20.     </div>
  21.     <div class="layui-form-item">
  22.         <label class="layui-form-label">用户角色</label>
  23.         <div class="layui-input-block">
  24.             <select name="gid" id="">
  25.                 @foreach($groups as $item)
  26.                     <option value="{{$item['gid']}}">{{$item['title']}}</option>
  27.                 @endforeach
  28.             </select>
  29.         </div>
  30.     </div>
  31.     <div class="layui-form-item">
  32.         <label class="layui-form-label">登录密码</label>
  33.         <div class="layui-input-block">
  34.             <input type="password" class="layui-input" name="pwd">
  35.         </div>
  36.     </div>
  37.     <div class="layui-form-item">
  38.         <label class="layui-form-label">重复密码</label>
  39.         <div class="layui-input-block">
  40.             <input type="password" class="layui-input" name="repwd">
  41.         </div>
  42.     </div>
  43.     <div class="layui-form-item">
  44.         <label class="layui-form-label">状态</label>
  45.         <div class="layui-input-block">
  46.             <input type="checkbox" lay-skin="primary" title="禁用" name="status">
  47.         </div>
  48.     </div>
  49.     <div class="layui-input-block">
  50.         <button class="layui-btn" onclick="save()">保存</button>
  51.     </div>
  52. </div>
  54. <script>
  55.     layui.use(['layer', 'form'], function () {
  56.         $ = layui.jquery;
  57.         form = layui.form;
  58.         layer = layui.layer;
  59.     });
  61.     //保存
  62.     function save() {
  63.         var username = $('input[name="username"]').val();
  64.         var gid = $('select[name="gid"]').val();
  65.         var pwd = $('input[name="pwd"]').val();
  66.         var repwd = $('input[name="repwd"]').val();
  67.         var status = $('input[name="status"]').is(':checked') ? 1 : 0;
  68.         var _token = $('input[name="_token"]').val();
  69.         if (username == '') {
  70.             return layer.alert('请填写用户名', {icon: 2});
  71.         }
  72.         if (pwd == "") {
  73.             return layer.alert('请填写密码', {icon: 2});
  74.         }
  75.         if (pwd != repwd) {
  76.             return layer.alert('两次密码输入不一致', {icon: 2});
  77.         }
  78.         $.post('/admins/admin/save', {
  79.             username: username,
  80.             gid: gid,
  81.             pwd: pwd,
  82.             status: status,
  83.             _token: _token
  84.         }, function (res) {
  85.             if (res.code > 0) {
  86.                 return layer.alert(res.msg, {icon: 2});
  87.             }
  88.             layer.msg(res.msg);
  89.             setTimeout(function () {
  90.                 parent.window.location.reload();
  91.             }, 1000);
  92.         },'json')
  93.     }
  94. </script>
  96. </body>
  97. </html>

2、 添加与保存账号 控制器处理
app/Http/Controllers/admins/Admin.php

  1. use Illuminate\Http\Request;
  3. /**
  4.  * 添加管理员
  5.  */
  6. public function add() {
  7.     $data['groups'] = DB::table('admin_group')->select('gid', 'title')->lists();
  8.     return view('admins/admin/add', $data);
  9. }
  10.  /**
  11.      * 保存
  12.      */
  13.     public function save(Request $req) {
  14.         $data['username'] = trim($req->username);
  15.         $data['gid'] = (int)$req->gid;
  16.         $data['password'] = password_hash(trim($req->pwd), PASSWORD_DEFAULT);
  17.         $data['status'] = (int)$req->status;
  19.         //查询用户名有没有被注册
  20.         $user = DB::table('admin')->where('username', $data['username'])->first();
  21.         if ($user) {
  22.             return json_encode(array('code' => 1, 'msg' => '该用户已存在'));
  23.         }
  24.         $res = DB::table('admin')->insert($data);
  25.         if (!$res) {
  26.             return json_encode(array('code' => 1, 'msg' => '保存失败'));
  27.         }
  28.         return json_encode(array('code' => 0, 'msg' => '保存成功'));
  29.     }


3、添加与保存账号 注册路由

  1. //添加账号 处理
  2. Route::get('/admins/admin/add', [Admin::class, 'add']);
  3. //保存账号 处理
  4. Route::post('/admins/admin/save', [Admin::class, 'save']);


4、查看效果

待添加完权限菜单再测试

三、编辑与保存账号 模块

1、创建 编辑账号 视图模板

resources/views/admins/admin/edit.blade.php

  1. <!doctype html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta name="viewport"
  6.           content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
  7.     <meta http-equiv="X-UA-Compatible" content="ie=edge">
  8.     <title>修改管理员</title>
  9.     <link rel="stylesheet" type="text/css" href="/static/layui/css/layui.css">
  10.     <script type="text/javascript" src="/static/layui/layui.js"></script>
  11. </head>
  12. <body style="padding:10px;">
  13. <div class="layui-form">
  14.     @csrf
  15.     <input type="hidden" name="admin_id" value="{{$item['id']}}">
  16.     <div class="layui-form-item">
  17.         <label class="layui-form-label">用户名</label>
  18.         <div class="layui-input-block">
  19.             <input type="text" class="layui-input" name="username" value="{{$item['username']}}" disabled>
  20.         </div>
  21.     </div>
  22.     <div class="layui-form-item">
  23.         <lable class="layui-form-label">用户角色</lable>
  24.         <div class="layui-input-block">
  25.             <select name="gid">
  26.                 @foreach($groups as $val)
  27.                     <option value="{{$val['gid']}}" {{$item['gid']==$val['gid']?'selected':''}}>{{$val['title']}}</option>
  28.                 @endforeach
  29.             </select>
  30.         </div>
  31.     </div>
  32.     <div class="layui-form-item">
  33.         <label class="layui-form-label">登录密码</label>
  34.         <div class="layui-input-block">
  35.             <input type="password" class="layui-input" name="pwd" placeholder="留空表示不修改密码">
  36.         </div>
  37.     </div>
  38.     <div class="layui-form-item">
  39.         <label class="layui-form-label">重复密码</label>
  40.         <div class="layui-input-block">
  41.             <input type="password" class="layui-input" name="repwd" placeholder="留空表示不修改密码">
  42.         </div>
  43.     </div>
  44.     <div class="layui-form-item">
  45.         <label class="layui-form-label">状态</label>
  46.         <div class="layui-input-inline">
  47.             <input type="checkbox" lay-skin="primary" name="status" title="禁用"{{$item['status']==1?'checked':''}}>
  48.         </div>
  49.     </div>
  50.     <div class="layui-input-block">
  51.         <button class="layui-btn" onclick="save()">保存</button>
  52.     </div>
  53. </div>
  55. <script>
  56.     layui.use(['layer', 'form'], function () {
  57.         $ = layui.jquery;
  58.         form = layui.form;
  59.         layer = layui.layer;
  60.     });
  62.     //保存
  63.     function save() {
  64.         var admin_id = $('input[name="admin_id"]').val();
  65.         var gid = $('select[name="gid"]').val();
  66.         var pwd = $('input[name="pwd"]').val();
  67.         var repwd = $('input[name="repwd"]').val();
  68.         var status = $('input[name="status"]').is(':checked') ? 1 : 0;
  69.         var _token = $('input[name="_token"]').val();
  71.         if (pwd !== repwd) {
  72.             return layer.alert('两次密码不一致', {icon: 2});
  73.         }
  75.         $.post('/admins/admin/save_edit', {
  76.                 admin_id: admin_id,
  77.                 gid: gid,
  78.                 pwd: pwd,
  79.                 status: status,
  80.                 _token: _token,
  81.             },
  82.             function (res) {
  83.                 console.log("编辑角色结果：", res);
  84.                 if (res.code > 0) {
  85.                     return layer.alert(res.msg, {icon: 2});
  86.                 }
  87.                 layer.msg(res.msg);
  88.                 setTimeout(function () {
  89.                     parent.window.location.reload();
  90.                 }, 1000)
  91.             }, 'json'
  92.         );
  93.     }
  94. </script>
  95. </body>
  96. </html>

2、编辑与保存账号列表 控制器处理
app/Http/Controllers/admins/Admin.php

  1. /**
  2.  * 编辑-角色信息
  3.  */
  4. public function edit(Request $req) {
  5.     $id = (int)$req->id;
  6.     $data['item'] = DB::table('admin')->where('id', $id)->item();
  8.     $data['groups'] = DB::table('admin_group')->select('gid', 'title')->lists();
  9.     return view('admins/admin/edit', $data);
  10. }
  12. /**
  13.  * 保存编辑
  14.  */
  15. public function save_edit(Request $req) {
  16.     $id = (int)$req->admin_id;
  17.     $pwd = trim($req->pwd);
  18.     $data['gid'] = (int)$req->gid;
  19.     $data['status'] = (int)$req->status;
  20.     if ($pwd) {
  21.         $data['password'] = password_hash($pwd, PASSWORD_DEFAULT);
  22.     }
  23.     DB::table('admin')->where('id', $id)->update($data);
  24.     return json_encode(array('code' => 0, 'msg' => '保存成功'));
  25. }


3、编辑与保存注册路由
routes/web.php

  1. //编辑账号 界面 
  2. Route::get('/admins/admin/edit', [Admin::class, 'edit']);
  3. //保存编辑账号 处理
  4. Route::post('/admins/admin/save_edit', [Admin::class, 'save_edit']);


4、查看效果

等做完权限菜单再来检测

四、删除账号 模块

1、删除账号 控制器处理
app/Http/Controllers/admins/Admin.php

  1.  /**
  2.  * 删除
  3.  * @param Request $req
  4.  * @return false|string
  5.  */
  6. public function del(Request $req) {
  7.     $admin_id = (int)$req->admin_id;
  8.     DB::table('admin')->where('id', $admin_id)->delete();
  9.     return json_encode(array('code'=>0,'msg'=>'删除成功'));
  10. }


2、删除账号 注册路由
routes/web.php

  1. //删除账号 处理
  2. Route::get('/admins/admin/del', [Admin::class, 'del']);


3、查看效果

上一条：JQuery初学习之`$()`的参数类型下一条：mysql常用.sql
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多