python 实现任务管理清单案例

╰半橙微兮° 2022-12-31 06:29 113阅读 0赞

更多编程教程请到：[菜鸟教程][Link 1] https://www.piaodoo.com/

友情链接：

[高州阳光论坛][Link 2]https://www.hnthzk.com/

[人人影视][Link 3]http://www.sfkyty.com/

base.html:

{% extends "bootstrap/base.html" %}

\{% block styles %\}  
\{ \{ super() \}\}  
<link rel=“stylesheet” href="…/static/css/main.css" rel=“external nofollow” >  
\{% endblock %\}

\{% block navbar %\}  
<nav class=“navbar navbar-default”>  
<div class=“container-fluid”>  
  
<div class=“navbar-header”>  
<button type=“button” class=“navbar-toggle collapsed” data-toggle=“collapse”  
data-target="\#bs-example-navbar-collapse-1" aria-expanded=“false”>  
<span class=“sr-only”>Toggle navigation</span>  
<span class=“icon-bar”></span>  
<span class=“icon-bar”></span>  
<span class=“icon-bar”></span>  
</button>  
<a class=“navbar-brand” href=“index.html” rel=“external nofollow” ></a>  
</div>

<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
        <ul class="nav navbar-nav">
           <li><a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ></a></li>
           <li><a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ></a></li>
          <li><a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >首页<span class="sr-only">(current)</span></a></li>
          <li><a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >新闻</a></li>
          <li><a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >国际</a></li>
          <li><a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >国内</a></li>
          <li><a href="/sysinfo/" rel="external nofollow" >系统信息</a></li>
          <li><a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >登陆用户</a></li>
        </ul>
        <ul class="nav navbar-nav navbar-right">
    
          {% if 'user' in session %}
            <li><a href="login.html" rel="external nofollow" ><span class="glyphicon glyphicon-user"></span>
              &nbsp;&nbsp; {
       { session.user }}</a></li>
            <li><a href="/logout/" rel="external nofollow" ><span class="glyphicon glyphicon-log-in"></span>
              &nbsp;&nbsp; 注销 </a></li>
    
          {% else %}
    
            <li><a href="/login/" rel="external nofollow" ><span class="glyphicon glyphicon-log-in"></span>
              &nbsp;&nbsp;登陆</a></li>
            <li><a href="/register/" rel="external nofollow" ><span class="glyphicon glyphicon-log-out"></span>
            &nbsp;&nbsp;注册</a></li>
          {% endif %}
    
    
    
        </ul>
      </div>
    </div>

</nav>  
\{% endblock %\}

\{% block content %\}  
\{\#定义属于自己的block\#\}  
\{% block newcontent %\}

\{% endblock %\}

\{% block footer %\}

<div class="footer">
    
    
      京ICP备11008151号京公网安备11010802014853
    
    </div>

\{% endblock %\}  
\{% endblock %\}

list.html:

{% extends 'base.html' %}

\{% block newcontent %\}  
<div class=“row”>  
<div class=“col-md-6 col-md-offset-3”>  
/*添加任务*/  
<form class=“form-horizontal” action="/todo/add/" method=“post”>  
<div class=“form-group”>  
\{\# 添加框 \#\}  
<div class=“col-sm-9”>  
<input type=“text” class=“form-control” placeholder=“请添加任务” required=“required”  
name=“todo\_name”>  
</div>  
\{\# 选择框 \#\}  
<div class=“col-sm-2”>  
<select class=“form-control” name=“part”>  
\{% for part in parts %\}  
<option value="\{ \{ part.id \}\}">\{ \{ part.name \}\}</option>  
\{% endfor %\}  
</select>  
</div>

{#  添加的按钮       #}
          <div class="col-sm-1">
            <input type="submit" class="btn btn-success" value="添加任务">
          </div>
        </div>
    
      </form>
    
      /*任务显示*/
      <h1>添加任务</h1>
      <table class="table table-bordered">
        <tr>
          <td>任务内容</td>
          <td>创建时间</td>
          <td>状态</td>
          <td>所属部门</td>
          <td>操作</td>
        </tr>
        {% for todo in todos %}
          <tr>
            <td>{
       { todo.name }}</td>
            <td>{
       { todo.add_time }}</td>
            {#    #}
            <td>
              {% if todo.status %}
                 <a href="/todo/undo/{
       { todo.id }}/" rel="external nofollow" class="btn btn-sm btn-success" role="button"><span
              class="glyphicon glyphicon-ok"></span> 已完成</a>
    
              {% else %}
                <a href="/todo/done/{
       { todo.id }}/" rel="external nofollow" class="btn btn-sm btn-warning" role="button"><span
              class="glyphicon glyphicon-remove"></span> 未完成</a>
    
              {% endif %}
    
            </td>
            <td>{
       { todo.department.name }}</td>
            <td><a href="/todo/delete/{
       { todo.id }}/" rel="external nofollow" class="btn btn-sm btn-danger" role="button"><span
              class="glyphicon glyphicon-remove"></span> 删除</a></td>
          </tr>
    
        {% endfor %}
    
    
      </table>
    </div>

</div>

\{% endblock %\}

models.py:

from datetime import datetime
    from flask import Flask
    from flask_sqlalchemy import SQLAlchemy
    from flask_bootstrap import Bootstrap

app = Flask(**name**)  
app.config\[‘SQLALCHEMY\_DATABASE\_URI’\] = ‘mysql+pymysql://root:971203@localhost/Todo’

# SQLAlchemy 将会追踪对象的修改并且发送信号。 #

app.config\[‘SQLALCHEMY\_TRACK\_MODIFICATIONS’\] = True  
db = SQLAlchemy(app)  
bootstrap = Bootstrap(app)  
app.config\[‘SECRET\_KEY’\] = ‘westos’

# 1). 面向对象方式创建表 #

# 2). 分析关系: #

# 部门和用户: 一对多 #

# 用户和任务: 一对多的关系 #

# 用户和用户登录日志: 一对多的关系 #

# 实现一对多(Role(1): User(n))的关系 #

# \- 多的一端写外键 #

# \- 少的一端写反向引用 #

class User(db.Model):  
id = db.Column(db.Integer, autoincrement=True, primary\_key=True)

# unique:用户名唯一, nullable=False指用户名不能为空; #

name = db.Column(db.String(50), unique=True, nullable=False)  
pwd = db.Column(db.String(100))  
email = db.Column(db.String(30), unique=True)  
phone = db.Column(db.String(30), unique=True)  
info = db.Column(db.Text) \# 个人简介  
add\_time = db.Column(db.DateTime, default=datetime.now()) \# 创建时间  
department\_id = db.Column(db.Integer, db.ForeignKey(‘department.id’))  
todos = db.relationship(‘Todo’, backref=‘user’)  
userlogs = db.relationship(‘Userlog’, backref=‘user’)

# 部门id与其他表关联，不能随便写 #

def **repr**(self):  
return ‘<User: %s>’ %(self.name)

# 部门 #

class Department(db.Model):  
id = db.Column(db.Integer, autoincrement=True, primary\_key=True)  
name = db.Column(db.String(50), unique=True, nullable=False)

# 反向引用: user就包含一个属性， department #

users = db.relationship(‘User’, backref=‘department’)  
todos = db.relationship(‘Todo’, backref=‘department’)  
def **repr**(self):  
return ‘<Department: %s>’ %(self.name)

class Todo(db.Model):  
id = db.Column(db.Integer, autoincrement=True, primary\_key=True)  
name = db.Column(db.String(200), nullable=False)  
add\_time = db.Column(db.DateTime, default=datetime.now()) \# 创建时间  
status = db.Column(db.Boolean, default=False) \# 任务状态， 默认为Flase(未完成)  
department\_id = db.Column(db.Integer, db.ForeignKey(‘department.id’))  
user\_id = db.Column(db.Integer,db.ForeignKey(‘user.id’) )

def **repr**(self):  
return ‘<Todo: %s>’ % (self.id)

# 用户登录日志 #

class Userlog(db.Model):  
id = db.Column(db.Integer, autoincrement=True, primary\_key=True)  
add\_time = db.Column(db.DateTime, default=datetime.now()) \# 创建时间  
ip = db.Column(db.String(200), nullable=False) \# 登录ip  
area = db.Column(db.String(200)) \# 用户登录地点  
user\_id = db.Column(db.Integer, db.ForeignKey(‘user.id’)) \# 外键

def **repr**(self):  
return ‘<Userlog: %s>’ % (self.ip)

views.py:

from flask import render_template, request, redirect, url_for, session

from models import app, Todo, db, Department,User  
from mDB import isPasswdOk,isUserExist,addUser  
from forms import LoginForm,RegisterForm  
@app.route(’/’)  
def index():  
return render\_template(‘base.html’)  
@app.route(’/register/’)  
def register():  
form = RegisterForm()  
if form.validate\_on\_submit():  
user = request.form(‘user’)  
passwd = request.form(‘passwd’)  
return render\_template(‘register.html’)

@app.route(’/login/’,methods=\[‘GET’,‘POST’\])  
def login():  
form = LoginForm()

# 如果是post方法并且表单验证通过的话， 返回True; #

if form.validate\_on\_submit():  
\# 1). 获取用户提交的表单信息  
\# print(form.data) 是字典类型， 内容如下:  
\# \{‘user’: ‘westos’, ‘passwd’: ‘westos’, ‘submit’: True \}  
user = form.data\[‘user’\]  
passwd = form.data\[‘passwd’\]  
\# 2. 判断用户名和密码是否正确

if isPasswdOk(user, passwd):
      # 将用户名和密码信息存储到session中;
      session['user'] = user
      session['passwd'] = passwd
      # 如果登陆成功, 跳转到主页;
      return redirect(url_for('todo_list'))
    else:
      # 如果登陆失败, 重新登陆;
      return render_template('login.html',form=form, message="用户名或者密码错误")

return render\_template(‘login.html’, form=form)  
@app.route(’/logout/’)  
def logout():  
session.pop(‘user’,None)  
session.pop(‘passwd’,None)  
return redirect(url\_for(‘todo\_list’))

# 任务的增删改查 #

@app.route(’/todo/add/’, methods=\[‘POST’\])  
def todo\_add():

# 获取提交的任务信息 #

name = request.form\[‘todo\_name’\]  
part = request.form\[‘part’\]

# 添加完成之后， 返回任务列表显示页面 #

u = User.query.filter\_by(name=session\[‘user’\]).first()  
id = u.id  
todo = Todo(name=name, department\_id=part, user\_id=id)  
db.session.add(todo)  
db.session.commit()

return redirect(url\_for(‘todo\_list’))

@app.route(’/todo/delete/<int:id>/’)  
def todo\_delete(id):  
u = Todo.query.filter\_by(id=id).first()  
db.session.delete(u)  
db.session.commit()  
return redirect(url\_for(‘todo\_list’))

@app.route(’/list/’)  
def todo\_list():

# 1). 从数据库中查询 #

todos = Todo.query.all()  
parts = Department.query.all()

return render\_template(‘list.html’,  
todos = todos,  
parts=parts)

# 修改任务的状态(变成已完成状态/变成未完成状态) #

@app.route(’/todo/undo/<int:id>/’)  
def undo(id):  
todo = Todo.query.filter\_by(id=id).first()  
todo.status = False  
db.session.commit()

# 更新状态后， 返回任务列表页 #

return redirect(url\_for(‘todo\_list’))

@app.route(’/todo/done/<int:id>/’)  
def done(id):  
todo = Todo.query.filter\_by(id=id).first()  
todo.status = True  
db.session.commit()

# 更新状态后， 返回任务列表页 #

return redirect(url\_for(‘todo\_list’))

run.py: