【Flask微电影】17.网站会员管理：查看会员和删除

个人博客，欢迎查看：https://blog.starmeow.cn/

Github地址：https://github.com/xyliurui/FlaskMovie

会员管理

创建用户头像保存路径

在app/__init__.py中增加配置文件

app.config['USER_IMAGE'] = os.path.join(os.path.abspath(os.path.dirname(__file__)), 'static/user/')  # 存放用户头像的路径

准备一些测试头像放在static/user/中，然后添加一些数据到user表中

mysql> use movie;
Database changed
mysql> select * from user;
Empty set (0.00 sec)

mysql> insert into
user(name, pwd, email, phone, info, face, uuid)
values
('逗起我', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user01.com', '12800128001', '个人简介', '01.jpg', 'd4d9772d0cb84f6b911a50670f55f395'),
('繁体', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user02.com', '12800128002', '个人简介', '02.jpg', '1fbd3079f1fb44afa7ddd9d212798d18'),
('立体', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user03.com', '12800128003', '个人简介', '03.jpg', '3f7f53f88d894f2cad96e8af4662322d'),
('突然变', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user04.com', '12800128004', '个人简介', '04.jpg', '256974f28e7a43809da96a716957921d'),
('刮胡刀', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user05.com', '12800128005', '个人简介', '05.jpg', '294a495e56474c1ea13962f602aed98d'),
('开机号', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user06.com', '12800128006', '个人简介', '06.jpg', 'd4b67132023b4f3c903c8e3e2b8e84e6'),
('萨达', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user07.com', '12800128007', '个人简介', '07.jpg', '7a3956518f034920a312877899afae0e'),
('认为他', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user08.com', '12800128008', '个人简介', '08.jpg', '1c5e5f7a4e564cffafd827c96e05bc2d'),
('话筒', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user09.com', '12800128009', '个人简介', '09.jpg', '1dd3276fdc8440ff92a537a00c13d07a'),
('机柜号', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user10.com', '12800128010', '个人简介', '10.jpg', 'b4fb51f547b8490188c5a889e26bbb06'),
('珀尔', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user11.com', '12800128011', '个人简介', '11.jpg', '94150271639b4e04855c365691cf3a47'),
('条纹', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user12.com', '12800128012', '个人简介', '12.jpg', '137b329d6e874e93b74082b2c133fad0'),
('与虎添翼', 'pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f', 'user@user13.com', '12800128013', '个人简介', '13.jpg', 'c116ef9e419c447fa06991237f4ece87');

Query OK, 13 rows affected (0.08 sec)
Records: 13  Duplicates: 0  Warnings: 0

mysql> select * from user\G;
*************************** 1. row ***************************
      id: 40
    name: 逗起我
     pwd: pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f
   email: user@user01.com
   phone: 12800128001
    info: 个人简介
    face: 01.jpg
add_time: NULL
    uuid: d4d9772d0cb84f6b911a50670f55f395
*************************** 2. row ***************************
      id: 41
    name: 繁体
     pwd: pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f
   email: user@user02.com
   phone: 12800128002
    info: 个人简介
    face: 02.jpg
add_time: NULL
    uuid: 1fbd3079f1fb44afa7ddd9d212798d18
*************************** 3. row ***************************
      id: 42
    name: 立体
     pwd: pbkdf2:sha256:50000$56hTmVhd$fa3c7d54ead0495e344f
   email: user@user03.com
   phone: 12800128003
    info: 个人简介
    face: 03.jpg
add_time: NULL
    uuid: 3f7f53f88d894f2cad96e8af4662322d
*************************** 4. row ***************************
# 。。。。

呃，忘了添加时间了

mysql> update user set add_time='2018-10-21 12:12:12';

Query OK, 13 rows affected (0.05 sec)
Rows matched: 13  Changed: 13  Warnings: 0

会员列表

修改user_list会员列表视图

@admin.route("/user/list/<int:page>/")
@admin_login_require
def user_list(page=None):
    if page is None:
        page = 1
    page_users = User.query.paginate(page=page, per_page=10)
    return render_template('admin/user_list.html', page_users=page_users)

修改user_list.html会员列表模板

<div class="box-body table-responsive no-padding">
    {% include 'admin/alert_info.html' %}

    <table class="table table-hover">
        <tbody>
        <tr>
            <th>编号</th>
            <th>昵称</th>
            <th>邮箱</th>
            <th>手机</th>
            <th>头像</th>
            <th>状态</th>
            <th>注册时间</th>
            <th>操作事项</th>
        </tr>
        {% for user in page_users.items %}
            <tr>
                <td>{{ user.id }}</td>
                <td>{{ user.name }}</td>
                <td>{{ user.email }}</td>
                <td>{{ user.phone }}</td>
                <td>
                    <img src="{{ url_for('static', filename='user/'+user.face) }}" width="50px" data-src="holder.js/50x50" class="img-responsive center-block" alt="">
                </td>
                <td>正常/冻结</td>
                <td>{{ user.add_time }}</td>
                <td>
                    <a class="label label-success" href="{{ url_for('admin.user_view') }}">查看</a>
                    &nbsp;
                    <a class="label label-info">解冻</a>
                    &nbsp;
                    <a class="label label-warning">冻结</a>
                    &nbsp;
                    <a class="label label-danger">删除</a>
                </td>
            </tr>
        {% endfor %}
        </tbody>
    </table>
</div>
<div class="box-footer clearfix">
    {% import 'admin/pagination.html' as pg %}
    {{ pg.render_pagination(page_users, 'admin.user_list') }}
</div>

image.png

会员详情

修改user_view会员详情视图

@admin.route("/user/view/<int:user_id>/")
@admin_login_require
def user_view(user_id=None):
    user = User.query.get_or_404(user_id)
    return render_template('admin/user_view.html', user=user)

修改user_view.html会员详情模板

修改user_list.html会员列表显示详情链接

<a class="label label-success" href="{{ url_for('admin.user_view', user_id=user.id) }}">查看</a>

修改user_view.html会员详情

<table class="table table-hover">
    <tbody>
    <tr>
        <td class="td_bd">编号：</td>
        <td>{{ user.id }}</td>
    </tr>
    <tr>
        <td class="td_bd">昵称：</td>
        <td>{{ user.name }}</td>
    </tr>
    <tr>
        <td class="td_bd">邮箱：</td>
        <td>{{ user.email }}</td>
    </tr>
    <tr>
        <td class="td_bd">手机：</td>
        <td>{{ user.phone }}</td>
    </tr>
    <tr>
        <td class="td_bd">头像：</td>
        <td>
            <img src="{{ url_for('static', filename='user/'+user.face) }}" data-src="holder.js/100x100" class="img-responsive" alt="">
        </td>
    </tr>
    <tr>
        <td class="td_bd">注册时间：</td>
        <td>{{ user.add_time }}</td>
    </tr>
    <tr>
        <td class="td_bd">唯一标志符：</td>
        <td>{{ user.uuid }}</td>
    </tr>
    <tr>
        <td class="td_bd">个性简介：</td>
        <td>{{ user.info }}</td>
    </tr>
    </tbody>
</table>

image.png

会员删除

增加user_delete删除会员视图

@admin.route("/user/delete/<int:delete_id>/")
@admin_login_require
def user_delete(delete_id=None):
    user = User.query.get_or_404(delete_id)
    # 删除同时要从磁盘中删除封面文件
    file_save_path = app.config['USER_IMAGE']  # 头像上传保存路径
    # 如果存在将进行删除，不判断，如果文件不存在删除会报错
    if os.path.exists(os.path.join(file_save_path, user.face)):
        os.remove(os.path.join(file_save_path, user.face))

    # 删除数据库，提交修改
    db.session.delete(user)
    db.session.commit()
    # 删除后闪现消息
    flash('删除会员成功！', category='ok')
    return redirect(url_for('admin.user_list', page=1))

修改user_list.html删除会员链接

<a class="label label-danger" href="{{ url_for('admin.user_delete', delete_id=user.id) }}">删除</a>

image.png