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
147 lines
15 KiB
HTML
147 lines
15 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-06-08</title>
|
||
<style>
|
||
* { margin:0; padding:0; box-sizing:border-box; }
|
||
body { font-family: 'Microsoft YaHei', 'PingFang SC', sans-serif; background:#0f172a; color:#e2e8f0; padding:20px; }
|
||
.header { text-align:center; padding:30px 0; border-bottom:2px solid #1e3a5f; margin-bottom:30px; }
|
||
.header h1 { color:#c8962e; font-size:28px; }
|
||
.header p { color:#64748b; margin-top:8px; }
|
||
.grid { display:grid; grid-template-columns:repeat(3,1fr); gap:20px; margin-bottom:30px; }
|
||
.card { background:#1e293b; border-radius:12px; padding:20px; border:1px solid #334155; }
|
||
.card h2 { color:#c8962e; font-size:16px; margin-bottom:15px; padding-bottom:10px; border-bottom:1px solid #334155; }
|
||
.metric { display:flex; justify-content:space-between; padding:8px 0; border-bottom:1px solid #1e293b; }
|
||
.metric .label { color:#94a3b8; }
|
||
.metric .value { font-weight:bold; font-size:18px; }
|
||
.value.good { color:#22c55e; }
|
||
.value.warn { color:#f59e0b; }
|
||
.value.bad { color:#ef4444; }
|
||
|
||
.table-wrap { background:#1e293b; border-radius:12px; padding:20px; margin-bottom:20px; border:1px solid #334155; }
|
||
.table-wrap h2 { color:#c8962e; font-size:18px; margin-bottom:15px; }
|
||
table { width:100%; border-collapse:collapse; font-size:13px; }
|
||
th { background:#0f172a; color:#c8962e; padding:10px 8px; text-align:left; position:sticky; top:0; }
|
||
td { padding:8px; border-bottom:1px solid #1e293b; }
|
||
tr:hover { background:#1e3a5f; }
|
||
.bar { display:inline-block; height:8px; border-radius:4px; background:#22c55e; }
|
||
.bar-bg { background:#334155; border-radius:4px; width:100%; height:8px; display:inline-block; }
|
||
.red { color:#ef4444; }
|
||
.orange { color:#f59e0b; }
|
||
.green { color:#22c55e; }
|
||
.num { text-align:right; font-variant-numeric:tabular-nums; }
|
||
.footer { text-align:center; color:#475569; padding:20px; font-size:12px; }
|
||
</style>
|
||
</head>
|
||
<body>
|
||
|
||
<div class="header">
|
||
<h1>🏗️ 中东区域公司 · 技术部月报台账看板</h1>
|
||
<p>数据日期：2026-06-08 | 生成时间：2026-06-09 | 数据来源：OA项管平台</p>
|
||
</div>
|
||
|
||
<!-- KPI Cards -->
|
||
<div class="grid">
|
||
<div class="card">
|
||
<h2>📋 危大方案编审进度</h2>
|
||
<div class="metric"><span class="label">有效方案总数</span><span class="value">135</span></div>
|
||
<div class="metric"><span class="label">超一定规模</span><span class="value">52</span></div>
|
||
<div class="metric"><span class="label">已审批</span><span class="value good">112</span></div>
|
||
<div class="metric"><span class="label">审批率</span><span class="value warn">83%</span></div>
|
||
<div class="metric"><span class="label">预警信号</span><span class="value warn">5</span></div>
|
||
<div class="metric"><span class="label">覆盖项目</span><span class="value">38</span></div>
|
||
</div>
|
||
|
||
<div class="card">
|
||
<h2>🔄 项目启动动态跟踪</h2>
|
||
<div class="metric"><span class="label">跟踪项目数</span><span class="value">80</span></div>
|
||
<div class="metric"><span class="label">总任务数</span><span class="value">5290</span></div>
|
||
<div class="metric"><span class="label">已完成</span><span class="value good">1443</span></div>
|
||
<div class="metric"><span class="label">逾期</span><span class="value bad">803</span></div>
|
||
<div class="metric"><span class="label">完成率</span><span class="value">27%</span></div>
|
||
</div>
|
||
|
||
<div class="card">
|
||
<h2>💰 营业额与产值</h2>
|
||
<div class="metric"><span class="label">活跃在建项目</span><span class="value">47</span></div>
|
||
<div class="metric"><span class="label">签约合同额</span><span class="value">$0万</span></div>
|
||
<div class="metric"><span class="label">本年营业收入</span><span class="value good">$0万</span></div>
|
||
<div class="metric"><span class="label">本月营业收入</span><span class="value">$0万</span></div>
|
||
<div class="metric"><span class="label">累计营业收入</span><span class="value">$0万</span></div>
|
||
</div>
|
||
</div>
|
||
|
||
<!-- 危大方案 Top 15 -->
|
||
<div class="table-wrap">
|
||
<h2>📋 危大方案编审 — 项目排行 Top 15</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><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="orange">🟠1</span></td><td class="num">57%</td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>沙特红海Laheq岛连接路和跨海桥工程</td><td class="num">11</td><td class="num">11</td><td class="num">7</td><td class="num">-</td><td class="num">100%</td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>沙特利雅得南二环路第三标段项目</td><td class="num">10</td><td class="num">10</td><td class="num">2</td><td class="num">-</td><td class="num">100%</td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>阿联酋阿布扎比中岛公园一期1C道桥项目</td><td class="num">7</td><td class="num">7</td><td class="num">3</td><td class="num">-</td><td class="num">100%</td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>沙特吉达市中心综合开发基础设施项目</td><td class="num">7</td><td class="num">7</td><td class="num">3</td><td class="num">-</td><td class="num">100%</td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>沙特吉赞基础下游工业城保税区至人工岛连接桥项目</td><td class="num">6</td><td class="num">6</td><td class="num">3</td><td class="num">-</td><td class="num">100%</td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>阿联酋哈伊马角永利岛连接桥</td><td class="num">6</td><td class="num">6</td><td class="num">1</td><td class="num">-</td><td class="num">100%</td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>阿联酋阿布扎比哈里发工业园B区食品基地工程</td><td class="num">4</td><td class="num">4</td><td class="num">0</td><td class="num">-</td><td class="num">100%</td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>沙特达曼港第一和第二集装箱码头升级改造工程</td><td class="num">3</td><td class="num">3</td><td class="num">2</td><td class="num">-</td><td class="num">100%</td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>沙特红海舒莱亚码头及潜水中心项目</td><td class="num">3</td><td class="num">3</td><td class="num">0</td><td class="num">-</td><td class="num">100%</td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>沙特吉赞基础下游工业城3区1巷独栋别墅一期项目</td><td class="num">3</td><td class="num">3</td><td class="num">2</td><td class="num">-</td><td class="num">100%</td><td>沙特阿拉伯</td></tr>
|
||
<tr><td>沙特利雅得德拉伊耶门二期多功能场馆及办公楼房建项目</td><td class="num">3</td><td class="num">3</td><td class="num">1</td><td class="num">-</td><td class="num">100%</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">-</td><td class="num">0%</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">-</td><td class="num">0%</td><td>阿拉伯联合酋长国</td></tr>
|
||
<tr><td>阿联酋阿布扎比瑞姆岛7号和8号跨海桥工程</td><td class="num">2</td><td class="num">2</td><td class="num">2</td><td class="num">-</td><td class="num">100%</td><td>阿拉伯联合酋长国</td></tr>
|
||
</table></div>
|
||
|
||
<!-- 项目启动跟踪 逾期Top 15 -->
|
||
<div class="table-wrap">
|
||
<h2>🔄 项目启动跟踪 — 逾期项目 Top 15</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">64</td><td class="num">1</td><td class="num"><span class="red">39</span></td><td class="num">2%</td><td><span class="bar-bg"><span class="bar" style="width:1%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>沙特苏盖克电厂缆桩修复工程项目</td><td class="num">66</td><td class="num">21</td><td class="num"><span class="red">32</span></td><td class="num">32%</td><td><span class="bar-bg"><span class="bar" style="width:31%;background:#f59e0b"></span></span></td></tr>
|
||
<tr><td>卡塔尔道路运营及维护框架项目</td><td class="num">66</td><td class="num">6</td><td class="num"><span class="red">30</span></td><td class="num">9%</td><td><span class="bar-bg"><span class="bar" style="width:9%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>阿联酋高铁迪拜段土建项目</td><td class="num">66</td><td class="num">10</td><td class="num"><span class="red">29</span></td><td class="num">15%</td><td><span class="bar-bg"><span class="bar" style="width:15%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>沙特利雅得南二环路第三标段项目</td><td class="num">65</td><td class="num">5</td><td class="num"><span class="red">28</span></td><td class="num">8%</td><td><span class="bar-bg"><span class="bar" style="width:7%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>沙特红海拉赫克岛疏浚吹填工程</td><td class="num">67</td><td class="num">22</td><td class="num"><span class="red">22</span></td><td class="num">33%</td><td><span class="bar-bg"><span class="bar" style="width:32%;background:#f59e0b"></span></span></td></tr>
|
||
<tr><td>阿联酋沙迦卡尔巴摩托艇港开发项目</td><td class="num">66</td><td class="num">5</td><td class="num"><span class="red">22</span></td><td class="num">8%</td><td><span class="bar-bg"><span class="bar" style="width:7%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>阿联酋阿布扎比西部三岛水工项目</td><td class="num">66</td><td class="num">8</td><td class="num"><span class="red">22</span></td><td class="num">12%</td><td><span class="bar-bg"><span class="bar" style="width:12%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>沙特海尔港钢厂前期工作土方工程</td><td class="num">67</td><td class="num">20</td><td class="num"><span class="red">20</span></td><td class="num">30%</td><td><span class="bar-bg"><span class="bar" style="width:29%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>沙特吉达市中心综合开发基础设施项目</td><td class="num">67</td><td class="num">16</td><td class="num"><span class="red">20</span></td><td class="num">24%</td><td><span class="bar-bg"><span class="bar" style="width:23%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>阿联酋阿布扎比马斯努阿岛水工项目</td><td class="num">64</td><td class="num">16</td><td class="num"><span class="red">20</span></td><td class="num">25%</td><td><span class="bar-bg"><span class="bar" style="width:25%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>阿联酋富查伊拉军港扩建附属设施包</td><td class="num">65</td><td class="num">9</td><td class="num"><span class="red">20</span></td><td class="num">14%</td><td><span class="bar-bg"><span class="bar" style="width:13%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>阿联酋阿布扎比沙哈马港升级改造项目</td><td class="num">64</td><td class="num">13</td><td class="num"><span class="red">19</span></td><td class="num">20%</td><td><span class="bar-bg"><span class="bar" style="width:20%;background:#ef4444"></span></span></td></tr>
|
||
<tr><td>沙特穆卡布四方城土方包</td><td class="num">67</td><td class="num">21</td><td class="num"><span class="red">18</span></td><td class="num">31%</td><td><span class="bar-bg"><span class="bar" style="width:31%;background:#f59e0b"></span></span></td></tr>
|
||
<tr><td>沙特红海Laheq岛连接路和跨海桥工程</td><td class="num">67</td><td class="num">21</td><td class="num"><span class="red">17</span></td><td class="num">31%</td><td><span class="bar-bg"><span class="bar" style="width:31%;background:#f59e0b"></span></span></td></tr>
|
||
</table></div>
|
||
|
||
<!-- 营收 Top 15 -->
|
||
<div class="table-wrap">
|
||
<h2>💰 活跃在建项目营收 Top 15</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">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比瑞姆岛7号和8号跨海桥工程</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比沙哈马港升级改造项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比Mina港钢板桩码头改建项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比马斯努阿岛水工项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比水上公共交通站工程</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比BAB油田开发3号标段土建项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋哈伊马角永利岛连接桥</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋迪拜马克图姆国际机场地下结构工程项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比哈里发工业园B区食品基地工程</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋迪拜南城自贸区中外运仓库项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋高铁迪拜段土建项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比汽车基地房建项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比西部三岛水工项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
<tr><td>阿联酋阿布扎比中岛公园一期1C道桥项目</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td class="num">0</td><td></td></tr>
|
||
</table></div>
|
||
|
||
<div class="footer">
|
||
<p>中国港湾中东区域公司 技术部 | 数据来源：OA项管平台 | 自动生成于 2026-06-09</p>
|
||
<p>原始数据路径：Y:\Openclaw_Hub\03.资源\实施项目 wiki\raw\月报数据\2026-06-08\</p>
|
||
</div>
|
||
|
||
</body></html> |