class WeeklyReport(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
content = db.Column(db.Text, nullable=False)
submission_date = db.Column(db.DateTime, default=datetime.utcnow)
student_id = db.Column(db.Integer, db.ForeignKey('student.id'))
<form action="/submit_weekly_report" method="post">
<input type="text" name="title" placeholder="周报标题" required>
<textarea name="content" placeholder="周报内容" required></textarea>
<button type="submit">提交</button>
</form>
@app.route('/view_reports')
def view_reports():
reports = WeeklyReport.query.all()
return render_template('view_reports.html', reports=reports)
report_count = WeeklyReport.query.filter(
WeeklyReport.submission_date.between(start_date, end_date)
).count()
