用 WorkBuddy 从零搭建地铁培训管理系统：Flask + SQLite + openpyxl 实战教程

pip install flask
pip install flask-sqlalchemy
pip install openpyxl

training_system/
├── app.py              # 主程序入口
├── models.py           # 数据库模型
├── routes/             # 路由模块
│   ├── employee.py     # 员工档案
│   ├── certificate.py  # 上岗证
│   ├── skill.py        # 技能鉴定
│   └── contractor.py   # 施工负责人
├── templates/          # HTML 模板
├── static/             # CSS/JS
├── data/               # 数据库文件
└── run.bat             # 启动脚本

@echo off
cd /d %~dp0
C:\Python312\python.exe app.py
pause

# models.py - 上岗证模型
class Certificate(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    employee_id = db.Column(db.Integer, db.ForeignKey('employee.id'))
    cert_type = db.Column(db.String(50))  # 上岗证类型
    cert_no = db.Column(db.String(100))   # 证书编号
    issue_date = db.Column(db.Date)       # 发证日期
    expire_date = db.Column(db.Date)      # 到期日期
    issue_unit = db.Column(db.String(100)) # 发证单位

// 前端 JS - 多选删除
function deleteSelected() {
    var ids = [];
    $('input[name="selected_ids"]:checked').each(function() {
        ids.push($(this).val());
    });
    if (ids.length === 0) return;
    if (!confirm('确认删除选中的 ' + ids.length + ' 条记录？')) return;
    
    $.post('/certificate/delete_multi', {ids: ids.join(',')}, function(res) {
        if (res.success) location.reload();
    });
}

# 后端 - 批量删除
@app.route('/certificate/delete_multi', methods=['POST'])
def delete_multi():
    ids = request.form.get('ids', '')
    if ids:
        id_list = [int(x) for x in ids.split(',') if x.strip()]
        Certificate.query.filter(Certificate.id.in_(id_list)).delete()
        db.session.commit()
    return jsonify({'success': True})

from openpyxl import Workbook
from openpyxl.styles import Font, Alignment

def export_certificates():
    wb = Workbook()
    ws = wb.active
    ws.title = "上岗证信息"
    
    # 表头
    headers = ['姓名', '上岗证类型', '证书编号', '发证日期', '到期日期', '发证单位']
    for col, header in enumerate(headers, 1):
        cell = ws.cell(row=1, column=col, value=header)
        cell.font = Font(bold=True)
        cell.alignment = Alignment(horizontal='center')
    
    # 数据行
    for row, cert in enumerate(Certificate.query.all(), 2):
        ws.cell(row=row, column=1, value=cert.employee.name)
        ws.cell(row=row, column=2, value=cert.cert_type)
        ws.cell(row=row, column=3, value=cert.cert_no)
        # ...
    
    wb.save('上岗证导出.xlsx')

@app.route('/contractor')
def contractor_list():
    ctype = request.args.get('type', '')  # internal/outsource/external
    search = request.args.get('search', '')
    query = Contractor.query
    if ctype:
        query = query.filter_by(contractor_type=ctype)
    if search:
        query = query.filter(Contractor.name.contains(search))
    contractors = query.all()
    return render_template('contractor.html', contractors=contractors)

from pathlib import Path

# 用 Path 处理中文路径，避免编码问题
file_path = Path('题库/接触网题库.xlsx')
if file_path.exists():
    wb = openpyxl.load_workbook(str(file_path))

npx localtunnel --port 5000

@echo off
cd /d %~dp0
start "Flask" "C:\Python312\python.exe" app.py
timeout /t 5
start "LT" cmd /c "npx localtunnel --port 5000"