# 任务:根据我下方的需求生成开发清单,如有疑问则向我提问,如有更好的建议则向我提出
## 在hqzcsj\templates\hqzcsj_zongcha.html的"获取提请文书"中新增一个数据源,表名为zq_zfba_wenshu
### 接口情况:
- 1. 请求网址:http://68.26.7.47:1999/com/api/v1/com/model/getQueryPageData
- 2. 请求数据:
    access_token: 859e608f-e8d3-4333-9ef0-3adb67d4cd1e
    quickFilter: C75050E4832B4F5C882B7AE04B11FAC3
    modelId: 3014B3FB4791461998A87D794ED94077
    where: {"rules":[{"field":"AJBH","op":"like","value":"","type":"string","format":""},{"field":"WS_ID","op":"like","value":"","type":"string","format":"","linkOp":"or"},{"field":"WSZH","op":"like","value":"","type":"string","format":""},{"field":"XGRY_XM","op":"like","value":"","type":"string","format":""},{"field":"DYCS","op":"between","value":"0|999","type":"number","format":""},{"field":"DYSJ","op":"between","value":"|","type":"date","format":"yyyy/MM/dd HH:mm:ss"},{"field":"CBDW_MC","op":"like","value":"","type":"string","format":"","linkOp":"or"},{"field":"CBDW_BH_1","op":"like","value":"","type":"string","format":""},{"field":"CBR_XM","op":"like","value":"","type":"string","format":""},{"field":"KJSJ","op":"between","value":"2025/01/01 00:00:00|","type":"date","format":"yyyy/MM/dd HH:mm:ss"},{"field":"SPSJ","op":"between","value":"|","type":"date","format":"yyyy/MM/dd HH:mm:ss"},{"field":"WSZT","op":"like","value":"03","type":"string","format":"","linkOp":"or"}],"op":"and"}
    mark: yshdws
    modelName: 已审核的文书SZ
    pkName: ID
    modelMark: yshdws
    resType: 02
    funcMark: yshdws
    funcId: 6CDD88E5222140A1B66E608814697B84
    resId: 17CF516331DE4DF6800761D9452BAAEF
    page: 1
    pagesize: 
    sortname: KJSJ,LRSJ,SPSJ,DYSJ
    sortorder: desc,desc,asc,asc
- 3. 返回数据:
    {
        "msg": "查询成功！",
        "code": 200,
        "success": true,
        "Total": 203277,
        "Data": {},
        "Rows": [
            {
                "AJMC": "12.02生产、销售假冒注册商标的商品案",
                "WSZH": "XX（X）XXX〔2026〕316074号",
                "WSZTName": "审批通过",
                "DYCS": "0",
                "XGRY_XM": "XX",
                "CBDW_MC": "XX县公安局治安管理大队",
                "ZJZ": "5E3AC18211D5447D8E06CD40781E1C6B",
                "DYSJ": "",
                "SPR_XM": "XXX",
                "WS_ID": "79976ACB5FB34BC682925BD26AC82531",
                "AJBH": "AXXXX220600002025126001",
                "SPSJ": "2026-02-27 17:09:47",
                "KJSJ": "2026-02-27 17:09:00",
                "WSMC": "询问通知书(XXX)",
                "BD_ID": "63F5BFD37C4F469499E0F553957ED8D1",
                "ID": "4BC9A583D9B5A12FE06317E21D447C68",
                "CBR_XM": "XXX,XXX",
                "WSZT": "03",
                "LRSJ": "2026-02-27 17:05:44"
            },
# 任务:根据我下方的需求生成开发清单,如有疑问则向我提问,如有更好的建议则向我提出
## 在"未成年人10率"中新增一列"责令加强监护数"
    + 显示格式为'X1/X2',X1为数据源中"实开文书数"的和(SUM),X2为数据源中"应开文书数"的和(SUM),
    + 地区列格式为'445302','445303','445321','445322','445381'
    数据源为
    ```sql
    WITH Case_Required AS (
        -- 1. 统计每个案件【应该】开多少份文书（按案件编号分组，数一数有几个不同的人员编号）
        SELECT 
            "案件编号",
            "地区",
            COUNT(*) AS 应开文书数
        FROM (
            SELECT
                "ajxx_join_ajxx_ajbh" AS "案件编号",
                LEFT(COALESCE("ajxx_join_ajxx_cbdw_bh_dm", ''), 6) AS "地区",
                "xyrxx_lrsj" AS "录入时间"
            FROM ywdata.v_wcnr_wfry_jbxx_base
        ) vw
        WHERE "录入时间" BETWEEN '2026-01-01' AND '2026-02-28'
        -- 这里假设视图中全是未成年人。如果视图包含成年人，需加上类似 WHERE cast("年龄" as integer) < 18 的条件
        GROUP BY "案件编号",  "地区"
    ),
    Case_Actual AS (
        -- 2. 统计每个案件【实际】开了多少份《家庭教育指导通知书》
        SELECT 
            ajbh AS 案件编号,
            COUNT(DISTINCT id) AS 实开文书数
        FROM ywdata.zq_zfba_jtjyzdtzs2
        -- 注意：如果有作废的文书，可以在这里过滤，例如：WHERE "wszt" = '有效' 或 "WSZTName" = '审批通过'
        GROUP BY ajbh
    )
    -- 3. 关联核对，找出没开够的案件
    SELECT 
        r."地区",
        r."案件编号",
        r.应开文书数,
        COALESCE(a.实开文书数, 0) AS 实开文书数,
        (r.应开文书数 - COALESCE(a.实开文书数, 0)) AS 漏开文书数
    FROM Case_Required r
    LEFT JOIN Case_Actual a ON r."案件编号" = a.案件编号
    -- 核心过滤逻辑：实开数 < 应开数 的案件
    ORDER BY 漏开文书数 DESC, r."地区";
    ```