ecd5914c97
- b2_tracking.py: 差距天数列转str,避免parquet序列化失败 - b3_revenue.py: 列名'含税'→'不含税'(源表实际列名) - b4b_certified_dashboard_2026.py: 修f-string嵌套引号SyntaxError, 补rows_html/country_rows_html=join(rows)变量 - 输出路径: B5统一到dashboard/data/而非05_表达Express/ 产出: dashboard.html / certified_schemes_dashboard.html / 危大方案看板数据工作簿.xlsx / 危大方案编审进度看板.pptx
89 lines
7.1 KiB
HTML
89 lines
7.1 KiB
HTML
<!DOCTYPE html>
|
||
<html lang="zh-CN">
|
||
<head>
|
||
<meta charset="UTF-8">
|
||
<meta name="viewport" content="width=device-width,initial-scale=1.0">
|
||
<title>危大方案编审进度看板 | 2026年开工 | 中东区域公司</title>
|
||
<style>
|
||
*{margin:0;padding:0;box-sizing:border-box}
|
||
body{font-family:'Microsoft YaHei','PingFang SC',sans-serif;background:#0f172a;color:#e2e8f0;padding:24px}
|
||
.header{text-align:center;padding:28px 0;border-bottom:2px solid #1e3a5f;margin-bottom:28px}
|
||
.header h1{color:#c8962e;font-size:26px}
|
||
.header p{color:#64748b;margin-top:6px;font-size:14px}
|
||
.kpi-grid{display:grid;grid-template-columns:repeat(4,1fr);gap:16px;margin-bottom:24px}
|
||
.kpi{background:#1e293b;border-radius:10px;padding:18px;border:1px solid #334155;text-align:center}
|
||
.kpi .num{font-size:32px;font-weight:bold;margin:6px 0}
|
||
.kpi .label{color:#94a3b8;font-size:13px}
|
||
.table-wrap{background:#1e293b;border-radius:10px;padding:20px;margin-bottom:20px;border:1px solid #334155}
|
||
.table-wrap h2{color:#c8962e;font-size:17px;margin-bottom:14px;padding-bottom:10px;border-bottom:1px solid #334155}
|
||
table{width:100%;border-collapse:collapse;font-size:13px}
|
||
th{background:#0f172a;color:#c8962e;padding:9px 8px;text-align:left}
|
||
td{padding:7px 8px;border-bottom:1px solid #1e3a5a}
|
||
tr:hover{background:#1a2e44}
|
||
.num{text-align:right}
|
||
.badge{padding:2px 8px;border-radius:4px;font-size:11px;font-weight:bold}
|
||
.badge-ok{background:#166534;color:#86efac}
|
||
.badge-warn{background:#78350f;color:#fbbf24}
|
||
.badge-alert{background:#7f1d1d;color:#fca5a5}
|
||
.bar-wrap{background:#334155;border-radius:3px;width:100%;height:8px;display:inline-block}
|
||
.bar{display:inline-block;height:8px;border-radius:3px}
|
||
.footer{text-align:center;color:#475569;padding:16px;font-size:12px}
|
||
.note{background:#1a2e44;border-left:3px solid #c8962e;padding:12px 16px;margin-bottom:20px;border-radius:0 8px 8px 0;font-size:13px;color:#94a3b8}
|
||
</style>
|
||
</head>
|
||
<body>
|
||
|
||
<div class="header">
|
||
<h1>🏗️ 危大方案编审进度看板</h1>
|
||
<p>中国港湾中东区域公司 · 2026年开工项目 · 数据日期：2026-06-08</p>
|
||
</div>
|
||
|
||
<div class="kpi-grid">
|
||
<div class="kpi"><div class="label">2026开工方案</div><div class="num" style="color:#c8962e">52</div><div class="label">覆盖12个项目</div></div>
|
||
<div class="kpi"><div class="label">超一定规模</div><div class="num" style="color:#f59e0b">22</div><div class="label">占比 42%</div></div>
|
||
<div class="kpi"><div class="label">已完成审批</div><div class="num" style="color:#f59e0b">29</div><div class="label">23项未完成</div></div>
|
||
<div class="kpi"><div class="label">审批完成率</div><div class="num" style="color:#f59e0b">56%</div><div class="label">29/52</div></div>
|
||
</div>
|
||
|
||
<div class="note">
|
||
📌 <b>状态说明</b>：已完成 = 已审批或已备案；未完成 = 未审批 / 审批中 / 未知。已作废方案已排除。<br>
|
||
📌 <b>范围说明</b>：仅显示分部分项工程计划开工日期在2026年的方案（共52项，占全部有效方案135项的39%）。
|
||
</div>
|
||
|
||
<!-- 项目明细 -->
|
||
<div class="table-wrap">
|
||
<h2>📋 项目明细（按方案总数排序）</h2>
|
||
<table>
|
||
<tr><th>项目名称</th><th class="num">方案</th><th class="num">已完成</th><th class="num">超规</th><th class="num">审批率</th><th>国别</th></tr>
|
||
<tr><td>阿联酋迪拜马克图姆国际机场地下结构工程项目</td><td class="num">35</td><td class="num">20</td><td class="num">13</td><td class="num"><span class="badge badge-warn">57%</span></td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>阿联酋沙迦卡尔巴摩托艇港开发项目</td><td class="num">3</td><td class="num">0</td><td class="num">1</td><td class="num"><span class="badge badge-alert">0%</span></td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>阿联酋阿布扎比汽车基地房建项目</td><td class="num">3</td><td class="num">0</td><td class="num">2</td><td class="num"><span class="badge badge-alert">0%</span></td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>沙特吉赞基础下游工业城5至7号路间矿业区基础设施一期项目</td><td class="num">2</td><td class="num">2</td><td class="num">0</td><td class="num"><span class="badge badge-ok">100%</span></td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>阿联酋阿布扎比汽车基地基础设施项目</td><td class="num">2</td><td class="num">0</td><td class="num">2</td><td class="num"><span class="badge badge-alert">0%</span></td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>沙特利雅得德拉伊耶门二期多功能场馆及办公楼房建项目</td><td class="num">1</td><td class="num">1</td><td class="num">1</td><td class="num"><span class="badge badge-ok">100%</span></td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>沙特利雅得南二环路第三标段项目</td><td class="num">1</td><td class="num">1</td><td class="num">0</td><td class="num"><span class="badge badge-ok">100%</span></td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>卡塔尔道路运营及维护框架项目</td><td class="num">1</td><td class="num">1</td><td class="num">1</td><td class="num"><span class="badge badge-ok">100%</span></td><td>卡塔尔</td></tr>
|
||
<tr><td>沙特吉赞基础下游工业城3区1巷独栋别墅一期项目</td><td class="num">1</td><td class="num">1</td><td class="num">1</td><td class="num"><span class="badge badge-ok">100%</span></td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>沙特达曼港第一和第二集装箱码头升级改造工程</td><td class="num">1</td><td class="num">1</td><td class="num">1</td><td class="num"><span class="badge badge-ok">100%</span></td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>阿联酋阿布扎比哈里发港EGA泊位翻新工程项目</td><td class="num">1</td><td class="num">1</td><td class="num">0</td><td class="num"><span class="badge badge-ok">100%</span></td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>阿联酋阿布扎比哈里发工业园B区食品基地工程</td><td class="num">1</td><td class="num">1</td><td class="num">0</td><td class="num"><span class="badge badge-ok">100%</span></td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr style="font-weight:bold;background:#1a2e44"><td>合计</td><td class="num">52</td><td class="num">29</td><td class="num">22</td><td class="num">56%</td><td></td></tr>
|
||
</table>
|
||
</div>
|
||
|
||
<!-- 按国别 -->
|
||
<div class="table-wrap">
|
||
<h2>🌍 按国别汇总</h2>
|
||
<table>
|
||
<tr><th>国别</th><th class="num">项目数</th><th class="num">方案总数</th><th class="num">已完成</th><th class="num">超规</th><th class="num">审批率</th></tr>
|
||
<tr><td>卡塔尔</td><td class="num">1</td><td class="num">1</td><td class="num">1</td><td class="num">1</td><td class="num"><span class="badge badge-ok">100%</span></td></tr>
|
||
<tr><td>沙特阿拉伯</td><td class="num">5</td><td class="num">6</td><td class="num">6</td><td class="num">3</td><td class="num"><span class="badge badge-ok">100%</span></td></tr>
|
||
<tr><td>阿拉伯联合酋长国</td><td class="num">6</td><td class="num">45</td><td class="num">22</td><td class="num">18</td><td class="num"><span class="badge badge-alert">49%</span></td></tr>
|
||
</table>
|
||
</div>
|
||
|
||
<div class="footer">
|
||
<p>中国港湾中东区域公司 技术部 | 2026开工项目 | 自动生成于 2026-06-08</p>
|
||
</div>
|
||
|
||
</body></html> |