services:
  wordpress:
    image: wordpress:php8.3
    restart: always
    volumes:
      - './html/plugins:/var/www/html/wp-content/plugins'
      - './html/uploads:/var/www/html/wp-content/uploads'
      - './html/public_static:/var/www/html/public_static'
      - './php/php.ini:/usr/local/etc/php/php.ini'
    ports:
      - '60080:80'
    environment:
      TZ: "Asia/Shanghai"
      WORDPRESS_DB_NAME: 'wordpress'
      WORDPRESS_DB_USER: 'root'
      WORDPRESS_DB_PASSWORD: '********'
      WORDPRESS_DB_HOST: 'mysql'
      WORDPRESS_CONFIG_EXTRA: |
        define( 'WP_MEMORY_LIMIT', '1024M' );
        define( 'WP_MAX_MEMORY_LIMIT', '2048M' );
        define( 'WP_SITEURL', 'https://<your-domain>' );
        define( 'WP_HOME', 'https://<your-domain>' );
        define( 'WP_CACHE', true );
        define( 'WP_ENVIRONMENT_TYPE', 'production' );
        
  mysql:
    image: mysql:latest
    restart: always
    volumes:
      - 'mysql-data:/var/lib/mysql'
    environment:
      MYSQL_DATABASE: 'wordpress'
      MYSQL_ROOT_PASSWORD: '********'

volumes:
  mysql-data:

<div class="user-name">{{name}}</div>
<div class="report-date">{{date}}</div>
<div class="data-value">{{some_data}}</div>

from datetime import datetime
import os
import psycopg
from pydantic import BaseModel
from jinja2 import Environment, FileSystemLoader

# 定义教师列表
teachers = ["张三", "李四", "王五"]

# 配置Jinja2模板环境
template_dir = os.path.join(os.path.dirname(__file__), 'static')
env = Environment(loader=FileSystemLoader(template_dir))
template = env.get_template('index.html')

# 定义数据模型
class ReportData(BaseModel):
    name: str
    date: str = datetime.now().strftime("%Y-%m-%d %H:%M")
    some_data: int = 0

# 连接数据库
conn = psycopg.connect("postgresql://<user>:<pwd>@<host>:5432/<database>")
cur = conn.cursor()

# 为每位教师生成报告
for teacher in teachers:
    report_data = ReportData(name=teacher)
    
    # 查询教师数据
    cur.execute("""
        SELECT .... AS some_data FROM table
        WHERE "teacherName" = %s 
        AND "startTime" BETWEEN '2024-01-01' AND '2024-12-31';
    """, [teacher])
    
    record = cur.fetchone()
    if record:
        report_data.some_data = record[0]
    
    # 渲染模板
    output = template.render(report_data.model_dump())
    
    # 保存HTML文件
    with open(f'static/{teacher}.html', 'w', encoding="utf-8") as f:
        f.write(output)

cur.close()
conn.close()

from datetime import datetime
import os
import uuid
import psycopg
from pydantic import BaseModel
from jinja2 import Environment, FileSystemLoader
from qcloud_cos import CosConfig, CosS3Client
from dagster_dingtalk import DingTalkAppClient

# 初始化COS客户端
cos_client = CosS3Client(
    CosConfig(
        Region="ap-guangzhou",
        SecretId="<your-secretid>",
        SecretKey="<your-secretkey>"
    )
)

# 初始化钉钉客户端
dt_client = DingTalkAppClient(
    app_id="<your-app_id>",
    client_id="<your-client_id>",
    client_secret="<your-client_secret>"
)

# 配置模板和数据库
teachers = ["张三", "李四", "王五"]
template_dir = os.path.join(os.path.dirname(__file__), 'static')
env = Environment(loader=FileSystemLoader(template_dir))
template = env.get_template('index.html')

class ReportData(BaseModel):
    name: str
    date: str = datetime.now().strftime("%Y-%m-%d %H:%M")
    some_data: int = 0

conn = psycopg.connect("postgresql://<user>:<pwd>@<host>:5432/<database>")
cur = conn.cursor()

# 为每位教师生成并推送报告
for teacher in teachers:
    # 创建报告数据对象
    report_data = ReportData(name=teacher)
    
    # 查询数据
    cur.execute("""
        SELECT .... AS some_data FROM table
        WHERE "teacherName" = %s 
        AND "startTime" BETWEEN '2024-01-01' AND '2024-12-31';
    """, [teacher])
    
    record = cur.fetchone()
    if record:
        report_data.some_data = record[0]
    
    # 渲染模板
    output = template.render(report_data.model_dump())
    
    # 生成唯一文件名（UUID后12位）
    uuid_str = str(uuid.uuid4())[-12:]
    
    # 上传到COS
    cos_client.put_object(
        Bucket='<your-bucket>',
        Body=output.encode('utf-8'),
        Key=f'{uuid_str}.html',
        EnableMD5=False
    )
    
    # 构建钉钉消息
    msg = {
        "msgtype": "action_card",
        "action_card": {
            "title": "你的年度教学报告来啦！快来查看吧！",
            "markdown": "![](<cover-image-url>)\n"
                       f"\n### {teacher}老师，您的2024年度教学报告已生成！快来查看吧！",
            "single_title": "点击查看",
            "single_url": f"https://<your-domain>/{uuid_str}.html"
        }
    }
    
    # 发送钉钉通知
    dt_client.即时通信.工作通知.发送工作通知(
        to_all_user=False,
        user_list=[user_id],
        msg=msg
    )

cur.close()
conn.close()