auto-sync.js 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. 'use strict';
  2. // 经营数据定时自动同步
  3. // ----------------------------------------------------------------------------
  4. // 每分钟检查一次:到达配置时间(默认 06:00,本地时区)且今天还没跑过、
  5. // 商家客户端调试端口在线时,自动同步「昨日」数据进本地数据湖。
  6. // - 客户端不在线 → 每分钟重试,当天在线的任意时刻补跑(跨夜作废)
  7. // - 同步失败也计为已跑(避免分钟级重试刷屏);次日再试
  8. // - 默认关闭,config.json → autoSync.enabled 开启;手动同步不受影响
  9. // - 同步记录照常写入数据湖 syncs,可在「数据报表 → 同步记录」里查看
  10. const fs = require('fs');
  11. const path = require('path');
  12. const naposService = require('../../napos-service.js');
  13. const { pushSummary } = require('./aitable.js');
  14. /** YYYYMMDD → YYYY-MM-DD(日志可读) */
  15. function ymdDash(v) { return String(v || '').replace(/^(\d{4})(\d{2})(\d{2})$/, '$1-$2-$3'); }
  16. function todayYmd() {
  17. const d = new Date();
  18. const z = (n) => String(n).padStart(2, '0');
  19. return `${d.getFullYear()}${z(d.getMonth() + 1)}${z(d.getDate())}`;
  20. }
  21. function ymdShift(ymd, delta) {
  22. const d = new Date(Number(ymd.slice(0, 4)), Number(ymd.slice(4, 6)) - 1, Number(ymd.slice(6, 8)));
  23. d.setDate(d.getDate() + delta);
  24. const z = (n) => String(n).padStart(2, '0');
  25. return `${d.getFullYear()}${z(d.getMonth() + 1)}${z(d.getDate())}`;
  26. }
  27. function createAutoSyncService(ctx) {
  28. const { config, workspace, logs } = ctx;
  29. const stateFile = () => path.join(workspace.getWorkspaceRoot(), '.genpic', 'auto-sync.json');
  30. function loadState() {
  31. try {
  32. const parsed = JSON.parse(fs.readFileSync(stateFile(), 'utf8'));
  33. return parsed && typeof parsed.lastRunDate === 'string' ? parsed : {};
  34. } catch {
  35. return {};
  36. }
  37. }
  38. function saveState(state) {
  39. try {
  40. const file = stateFile();
  41. fs.mkdirSync(path.dirname(file), { recursive: true });
  42. const temp = `${file}.${process.pid}.tmp`;
  43. fs.writeFileSync(temp, JSON.stringify(state, null, 2), 'utf8');
  44. fs.renameSync(temp, file);
  45. } catch { /* 状态落盘失败不阻断同步 */ }
  46. }
  47. let running = false; // 本服务的单飞标记(与 naposService 的 SYNC_BUSY 双保险)
  48. async function tick() {
  49. const cfg = config.autoSync || {};
  50. if (!cfg.enabled) return;
  51. if (running) return;
  52. if (naposService.syncSnapshot().running) return; // 手动同步进行中,让路
  53. const time = /^\d{1,2}:\d{2}$/.test(String(cfg.time || '')) ? cfg.time : '06:00';
  54. const [hh, mm] = time.split(':').map(Number);
  55. const now = new Date();
  56. const nowMinutes = now.getHours() * 60 + now.getMinutes();
  57. const schedMinutes = Math.min(23, Math.max(0, hh)) * 60 + Math.min(59, Math.max(0, mm));
  58. if (nowMinutes < schedMinutes) return;
  59. const today = todayYmd();
  60. const state = loadState();
  61. if (state.lastRunDate === today) return;
  62. let status;
  63. try {
  64. status = await naposService.naposStatus();
  65. } catch {
  66. return; // 探测异常,下一分钟再试
  67. }
  68. if (!status.connected) return; // 客户端不在线,等待在线时刻补跑
  69. running = true;
  70. const from = ymdShift(today, -1);
  71. saveState({ ...state, lastRunDate: today, lastTriggeredAt: new Date().toISOString() });
  72. logs.pushSystemLog(`自动同步开始:昨日(${ymdDash(from)})经营数据`, 'info');
  73. try {
  74. const snap = await naposService.runSync({ from, to: from, scope: 'all' });
  75. if (snap.error) {
  76. logs.pushSystemLog(`自动同步失败:${snap.error}`, 'error');
  77. } else {
  78. logs.pushSystemLog(
  79. `自动同步完成:${snap.entity ? snap.entity.name + ',' : ''}新增 ${snap.added} 行、更新 ${snap.updated} 行、失败 ${snap.failed} 项`,
  80. snap.failed > 0 ? 'warn' : 'success'
  81. );
  82. // 同步完成后:若启用钉钉 AI 表格,自动把增量推送云端(失败不影响本地同步结果)。
  83. // 与手动同步路由同款 fire-and-forget;此前定时同步不推云端属遗漏。
  84. if (snap.entity && ctx.config.aitable && ctx.config.aitable.enabled && ctx.aitable) {
  85. ctx.aitable.pushLake(snap.entity.key).then((r) => {
  86. logs.pushSystemLog(`推送云端完成:${r.account ? r.account + ',' : ''}${pushSummary(r)}`, 'success');
  87. }).catch((e) => {
  88. logs.pushSystemLog(`推送云端失败:${e.message || e}`, 'error');
  89. });
  90. }
  91. }
  92. } catch (e) {
  93. logs.pushSystemLog(`自动同步失败:${e.message || e}`, 'error');
  94. } finally {
  95. running = false;
  96. }
  97. }
  98. const timer = setInterval(() => { tick().catch(() => {}); }, 60 * 1000);
  99. timer.unref();
  100. return {
  101. /** 立即执行一次检查(供测试/手动触发) */
  102. tickNow: tick,
  103. stop: () => clearInterval(timer),
  104. };
  105. }
  106. module.exports = { createAutoSyncService };