shishengliang/ln-bi
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
369 Commits 5 Branches 0 Tags
main
Commit Graph

369 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
kkfluous
17c839a35e feat(mileage): add statistic-time sorting and refresh control
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-07-23 15:44:01 +08:00
kkfluous
99b4efda6d chore: release v1.1.13
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-07-23 15:12:36 +08:00
kkfluous
6b72f0ce3c feat(mileage): default to instrument-only source 2026-07-23 15:12:36 +08:00
kkfluous
b0c8d6a5b8 chore: release v1.1.12
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-07-23 14:11:57 +08:00
kkfluous
d8773ff0a0 feat(mileage): add OneOS source priority controls 2026-07-23 14:11:52 +08:00
kkfluous
becacecc67 chore: release v1.1.11
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-07-23 12:29:29 +08:00
kkfluous
67f3ec7306 perf(mileage): filter single-vehicle range queries 2026-07-23 12:27:23 +08:00
kkfluous
3f29bed5fa feat: integrate OneOS mileage APIs and release v1.1.10
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-07-23 12:19:11 +08:00
kkfluous
4d523cbce0 feat(mileage): add daily mileage columns to main export sheet
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
- '车辆汇总' sheet now includes per-day mileage columns for date ranges
- Daily columns shown as 'MM-DD里程(km)' between base info and summary cols
- Freeze pane fixed at 7 base columns for horizontal scrolling
- '每日明细' sheet retained as detailed backup
- Bump version to 1.1.9
 2026-07-15 14:30:16 +08:00
kkfluous
2b31f8efe8 feat(mileage): add brand multi-select filter and customer fuzzy search
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
- Add brand multi-select filter (BatchMultiSelect) with 17 brand options
- Replace customer select with SearchableSelect for fuzzy search
- Server-side: add brand to vehicle-info SQL, cache, filters, and monitoring
- Customer filter now uses case-insensitive includes match on server side
- Add brand column to fullscreen table header and body
- Mobile-adaptive: compact inputs, constrained widths, scrollable dropdowns
- Bump version to 1.1.8
 2026-07-15 14:25:11 +08:00
kkfluous
ae4b5d30e7 fix: restore mobile navigation typography
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-07-13 22:02:49 +08:00
kkfluous
392a36a0ec feat: add vehicle and hydrogen heatmaps
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-07-13 21:44:03 +08:00
lingniu
a558db5795 Polish mobile BI filters and summaries
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-27 22:43:43 +08:00
lingniu
b0caa5afcb feat: polish BI dashboards and bump version
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-27 21:59:33 +08:00
lingniu
5377d2c225 chore: ignore local worktrees 2026-06-23 16:09:54 +08:00
kkfluous
654573ac4b merge palladium 18t color variant
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-23 13:32:29 +08:00
kkfluous
43f94ed1b8 fix asset vehicle source grouping
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-23 13:16:32 +08:00
kkfluous
fb5789d705 update asset refresh status
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-18 14:18:40 +08:00
kkfluous
94a6e0a75e update asset validation banner
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-18 14:04:27 +08:00
kkfluous
67c5f9d281 support mileage batch multi-select
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-18 10:18:35 +08:00
kkfluous
91202bdf71 fix asset module database migration
All checks were successful
ci/woodpecker/manual/woodpecker Pipeline was successful
Details
2026-06-17 11:53:39 +08:00
kkfluous
c13f341d5e feat(ui): 页面标题区分能源BI与资产BI，资产页增加OneOS迁移提示滚动条
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-11 15:30:21 +08:00
kkfluous
6962c4ff1c feat(db): hydrogen 和 mileage 数据库连接支持 Docker 环境变量注入
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
mileage-db.ts 改为从环境变量读取，硬编码值作为 fallback；
docker-compose.yml 新增加氢站库和里程库的连接参数。
 2026-06-09 17:18:32 +08:00
kkfluous
6b7f0eedd9 Revert "fix(mileage): 已到期年度按期末里程统计"
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
This reverts commit feb950dd59.
 2026-06-03 15:40:13 +08:00
kkfluous
5bb3ceb47a fix(mileage): 交投高里程车辆标红
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-03 15:10:36 +08:00
kkfluous
cc778f3701 fix(mileage): 导出保留里程小数
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-03 14:54:30 +08:00
kkfluous
74d6efe261 Revert "fix(mileage): 区分年度累计里程和计入完成" 
This reverts commit 3f0edfaaf5.
 2026-06-03 14:53:54 +08:00
kkfluous
a124e31fab Revert "fix(mileage): 未到期年度累计对齐实时监控" 
This reverts commit a3dfe7ab8c.
 2026-06-03 14:53:54 +08:00
kkfluous
a3dfe7ab8c fix(mileage): 未到期年度累计对齐实时监控
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-03 11:32:50 +08:00
kkfluous
3f0edfaaf5 fix(mileage): 区分年度累计里程和计入完成
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-03 11:18:48 +08:00
kkfluous
feb950dd59 fix(mileage): 已到期年度按期末里程统计
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-03 11:13:40 +08:00
kkfluous
5e1c12eba2 fix(mileage): 减少车型展开时页面抖动
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-02 16:01:47 +08:00
kkfluous
ae24bc7647 fix(mileage): 已到期年度显示考核期末日期
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-02 15:50:35 +08:00
kkfluous
0a372e4290 fix(mileage): 消除年度完成日期歧义
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-02 15:48:01 +08:00
kkfluous
1e08d1ea62 fix(mileage): 标注年度已进入车辆数
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-02 15:34:25 +08:00
kkfluous
2d82918d73 fix(mileage): 年度考核区间按批次展示
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-02 15:33:08 +08:00
kkfluous
482243e052 feat(mileage): 支持车型按考核年度查看
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-06-02 15:30:13 +08:00
kkfluous
f1a69c8271 Correct hydrogen daily vehicle split
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-05-28 22:19:08 +08:00
kkfluous
1d2c3a0cd5 Switch hydrogen BI to ledger data source
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-05-28 16:47:43 +08:00
lnljyang
e7ba5315e1 拆分菜单 通过url区分访问
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details
2026-05-14 17:44:04 +08:00
kkfluous
69168abdf8 chore(mileage): 粤AGP5681 运营区域改为华东区域
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-05-12 15:36:54 +08:00
kkfluous
7e6fd491b0 fix(mileage): 当日未对接但有历史 totalKm 的车今日里程显示 0 不是「未对接」
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
承接上一笔修复：兜底拿到 totalKm 后，今日里程也应该理解为 0（这车
在系统里有数据，只是今天没增量），而不是再贴「未对接」标签。

涉及：
- MonitoringView 表格 + 卡片：dailyKm 显示与对应颜色 / amber 点
- xlsx-export「今日里程」列

判定改成 (isDataSynced || totalKm != null)；
isOnline / 在线-离线 标签不变（基于 dailyKm > 0，与本次语义无关）。

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-05-07 15:27:23 +08:00
kkfluous
1c57eb4a58 fix(mileage): 累计里程展示不再被「未对接」状态盖掉
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
后端 cache 已用 fetchLatestPgTotalMileageMap 在当日 source=NONE 时
回填该车 ln_vehicle_day_total_pg 最近一条 total_mileage，但前端
表格 / 卡片 / Excel 都用 isDataSynced && totalKm != null 判定，
未对接车被锁回「未对接」文案。

调整为：
- 今日里程仍按 isDataSynced 显示「未对接」（今天确实没增量）
- 累计里程只看 totalKm 是否为 null，未对接但有历史值的车现在能显示

实测 粤A03423F：source=NONE / dailyKm=0 / totalKm=9205.6
原来「总: 未对接」→ 现在显示 9205.6 km

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-05-07 15:20:33 +08:00
kkfluous
331ad1a1da fix(mileage): totalKm 当日为空时回填该车 ln_vehicle_day_total_pg 最近一条
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
视图 v_vehicle_daily_stats.total_km 仅当日有 TBOX 记录才有值，
否则原样为 NULL。新增 fetchLatestPgTotalMileageMap 在应用层按车牌
取最近一条非空 total_mileage（queryDateMileage 限定 dates <= 查询日，
保证历史日不取未来值），插入 gpsTotal → latestPgTotal → bizTotal 的
回退链，让 totalKm 显示连续。

MySQL 5.7 无窗口函数，用 INNER JOIN + GROUP BY MAX(dates) 取每车最近一条；
本地 dev 实测 1004 辆车 cache 刷新 ~16s，不再有 SQL 解析错。

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-05-07 15:17:16 +08:00
shishengliang
05c99fc57a revert 1357296f28
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
revert fix(mileage): totalKm 当日为空时回填该车 ln_vehicle_day_total_pg 最近一条

视图 v_vehicle_daily_stats.total_km 仅当日有 TBOX 记录才有值，
否则原样为 NULL。新增 fetchLatestPgTotalMileageMap 在应用层按车牌
取最近一条非空 total_mileage（queryDateMileage 限定 dates <= 查询日，
保证历史日不取未来值），插入 gpsTotal → latestPgTotal → bizTotal 的
回退链，让 totalKm 显示连续。

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-05-07 07:13:16 +00:00
kkfluous
1357296f28 fix(mileage): totalKm 当日为空时回填该车 ln_vehicle_day_total_pg 最近一条
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
视图 v_vehicle_daily_stats.total_km 仅当日有 TBOX 记录才有值，
否则原样为 NULL。新增 fetchLatestPgTotalMileageMap 在应用层按车牌
取最近一条非空 total_mileage（queryDateMileage 限定 dates <= 查询日，
保证历史日不取未来值），插入 gpsTotal → latestPgTotal → bizTotal 的
回退链，让 totalKm 显示连续。

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-05-07 15:07:39 +08:00
kkfluous
433a75f9d1 fix(mileage): 7天里程趋势忽略负值脏数据
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
v_vehicle_daily_stats.daily_km 偶发负值（粤A00828F 在 5.1 录得 -82061km），
源于里程表回滚 / 换 GPS 设备。SQL 聚合时把负值置 0，避免一辆脏数据车
拖垮整组的当日趋势柱。

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-05-03 10:33:25 +08:00
kkfluous
0193e78f18 fix(auth): 能源管理仅 BI-LEADER-ENERGY 与「所有权限」可访问
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
收紧准入：之前 FULL_ACCESS_ROLES（含 数智中心 / BI-Leader）会自动通过。
现在只接受 BI-LEADER-ENERGY 或「所有权限」两类角色。

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-04-30 18:16:42 +08:00
kkfluous
2a851fc243 feat(auth): 能源管理放开全量权限角色访问
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
BI-LEADER-ENERGY 之外，FULL_ACCESS_ROLES（所有权限/数智中心/BI-Leader）
也可访问能源管理模块。

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-04-30 18:03:05 +08:00
kkfluous
6142af7617 fix(auth): 能源管理仅 BI-LEADER-ENERGY 可访问，移除全量权限旁路
All checks were successful
ci/woodpecker/push/woodpecker Pipeline was successful
Details 
与智能调度的口径一致：模块访问需要专属角色，全量权限角色不再自动通过。
本地开发 dev mock 用户已含 BI-LEADER-ENERGY，调试不受影响。

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
 2026-04-30 18:02:21 +08:00