Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 后台三 账号列表
Blogger Information
Blog 41
fans 0
comment 0
visits 25299
Special Recommendation
More>
Related recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
后台三 账号列表
自由之上
Original
1001 people have browsed it

一、账号列表 模块

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、查看效果

Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post