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'))
@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()
