SeibroCorpActionSyncService.cs 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444
  1. using Application.Abstractions.Data;
  2. using Application.Helpers;
  3. using Microsoft.EntityFrameworkCore;
  4. using Microsoft.Extensions.DependencyInjection;
  5. using Microsoft.Extensions.Logging;
  6. using Microsoft.Extensions.Options;
  7. using SharedKernel;
  8. namespace Infrastructure.StockData;
  9. /// <summary>
  10. /// SEIBro 기업행위·총회 수집 (Wave 3) — 기본 07:20 KST(SupplySync 07:00 다음 슬롯), `Seibro:CorpActionSync` 게이트.
  11. /// 총회·상호변경·대금·단주 4단계는 기업(Corp) 예산(Seibro:CorpBudget), CB/BW 행사 2단계는 주식(Stock) 예산(Seibro:StockBudget)을 공유한다.
  12. ///
  13. /// a) 총회 이벤트 구동: RightsBaseDate(Wave 1 적재)의 RGT_RACD∈{001,002,003,009} 인 (회사번호, 기준일) →
  14. /// getGmeetInfo + getGmeetMeasureInfo(Corp). rolling(미수집 (회사,기준일) 우선).
  15. /// b) 상호변경 이벤트 구동: RightsBaseDate RGT_RACD=204 인 (회사번호, 기준일) → getFmnmAltInfo(Corp) rolling.
  16. /// c) PaymentSchedule: getCostPaySchedul 날짜 스윕(TH1_PAY_TERM_BEGIN_DT) × PAY_COST_TPCD{1,3}(Corp) — 지급일+구분 window delete+insert.
  17. /// d) OddLotPayment: PaymentSchedule 중 PayCostTpcd=3(단주) 인 (회사번호, 지급일) → getOddLotInfo(Corp) rolling.
  18. /// e) ConvertibleExercise: getXrcStkOptionXrcInfo 날짜 스윕(RGT_STD_DT=권리행사일)(Stock) — 권리행사일 window delete+insert.
  19. /// 반환된 BOND_ISIN 이 (f)의 발견 소스.
  20. /// f) ConvertibleBondTarget: (e)에서 발견된 DISTINCT BondIsin → getXrcStkStatInfo(BOND_ISIN)(Stock) rolling.
  21. /// (Wave 4 BondIssuance 는 아직 없으니 (e) 결과만 시드 — 발견 소스 단일.)
  22. ///
  23. /// 실패/0행 = 정상 빈결과. HTTP·파싱 오류 = 경고 + false(RetryDelay 후 재시도). quota 소진 = 정상 종료(true). ApiKey 미설정 시 skip.
  24. /// ⚠️ getXrcStk* 실샘플이 result="0" 이라 CB/BW 필드 매핑은 스펙 기준 — 운영 첫 수집 시 로그로 확인.
  25. /// </summary>
  26. internal sealed class SeibroCorpActionSyncService(
  27. IServiceScopeFactory scopeFactory,
  28. IHttpClientFactory httpClientFactory,
  29. SeibroQuota quota,
  30. IOptions<AppSettings> settings,
  31. ILogger<SeibroCorpActionSyncService> logger
  32. ) : DailyScheduledService(logger)
  33. {
  34. // 총회계열 권리사유코드 (RGT_RACD) — getGmeetInfo/getGmeetMeasureInfo 트리거
  35. private static readonly string[] MeetingRacds = ["001", "002", "003", "009"];
  36. // 상호변경 권리사유코드 (RGT_RACD) — getFmnmAltInfo 트리거
  37. private const string NameChangeRacd = "204";
  38. // 대금지급구분 (PAY_COST_TPCD) — 1배당금 3단주대금
  39. private static readonly string[] PayCostTpcds = ["1", "3"];
  40. private const string OddLotPayCostTpcd = "3";
  41. // 마커 job 키 (리뷰 결함 #1) — 정상 0행/조용한 날 재조회·starvation 해소
  42. private const string MeetingJobKey = "corp-meeting"; // rolling (FetchMarker, key=custno|stdDt)
  43. private const string NameChangeJobKey = "corp-namechange"; // rolling (FetchMarker, key=custno|stdDt)
  44. private const string OddLotJobKey = "corp-oddlot"; // rolling (FetchMarker, key=custno|payDate)
  45. private const string BondTargetJobKey = "cb-target"; // rolling (FetchMarker, key=bondIsin)
  46. private const string PaySchedJobKey = "corp-paysched"; // date-sweep (SweptDate, Discriminator=tpcd)
  47. private const string ExerciseJobKey = "cb-exercise"; // date-sweep (SweptDate)
  48. protected override string JobName => "SeibroCorpActionSync";
  49. protected override TimeOnly TargetTime => ParseTime(settings.Value.Seibro.CorpActionSyncTime, new TimeOnly(7, 20));
  50. protected override int MaxRetryCount => 2;
  51. protected override TimeSpan RetryDelay => TimeSpan.FromHours(2);
  52. protected override async Task<bool> RunOnceAsync(DateOnly todayKst, CancellationToken ct)
  53. {
  54. var cfg = settings.Value.Seibro;
  55. if (string.IsNullOrWhiteSpace(cfg.ApiKey))
  56. {
  57. Logger.LogWarning("[{Job}] Seibro:ApiKey 미설정 — 수집 skip", JobName);
  58. return true;
  59. }
  60. using var scope = scopeFactory.CreateScope();
  61. var db = scope.ServiceProvider.GetRequiredService<IAppDbContext>();
  62. var client = httpClientFactory.CreateClient(SeibroHttp.ClientName);
  63. var years = cfg.BackfillYears > 0 ? cfg.BackfillYears : 3;
  64. var startDate = todayKst.AddYears(-years);
  65. try
  66. {
  67. // a) 총회 이벤트 구동 (Corp)
  68. if (!await RollMeetingsAsync(db, client, cfg, ct))
  69. {
  70. return true;
  71. }
  72. // b) 상호변경 이벤트 구동 (Corp)
  73. if (!await RollNameChangesAsync(db, client, cfg, ct))
  74. {
  75. return true;
  76. }
  77. // c) 대금지급일정 날짜 스윕 × 구분{1,3} (Corp)
  78. if (!await SweepPaymentSchedulesAsync(db, client, cfg, startDate, todayKst, ct))
  79. {
  80. return true;
  81. }
  82. // d) 단주대금 이벤트 구동 (Corp)
  83. if (!await RollOddLotsAsync(db, client, cfg, ct))
  84. {
  85. return true;
  86. }
  87. // e) CB/BW 행사 날짜 스윕 (Stock) — (f)의 발견 소스
  88. if (!await SweepExercisesAsync(db, client, cfg, startDate, todayKst, ct))
  89. {
  90. return true;
  91. }
  92. // f) CB/BW 행사대상 rolling per-채권ISIN (Stock)
  93. await RollBondTargetsAsync(db, client, cfg, ct);
  94. return true;
  95. }
  96. catch (Exception ex) when (ex is HttpRequestException or System.Xml.XmlException or FormatException)
  97. {
  98. Logger.LogWarning(ex, "[{Job}] SEIBro 호출/파싱 실패 — run 중단, {Delay} 후 재시도 (최대 {Max}회)", JobName, RetryDelay, MaxRetryCount);
  99. return false;
  100. }
  101. }
  102. /// <summary>
  103. /// a) 총회 이벤트 구동 — RightsBaseDate RGT_RACD∈{001,002,003,009} 의 (회사번호, 기준일) 중 GeneralMeeting 미수집·stale 우선.
  104. /// (회사, 기준일) 당 getGmeetInfo + getGmeetMeasureInfo 2콜(각각 Corp 예산 소비). 예산 소진 시 false.
  105. /// </summary>
  106. private async Task<bool> RollMeetingsAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, CancellationToken ct)
  107. {
  108. var triggers = await db.RightsBaseDate.AsNoTracking()
  109. .Where(c => MeetingRacds.Contains(c.RgtRacd))
  110. .Select(c => new { c.IssucoCustno, c.RgtStdDt })
  111. .Distinct()
  112. .ToListAsync(ct);
  113. if (triggers.Count == 0)
  114. {
  115. Logger.LogInformation("[{Job}] 총회 트리거 없음 (RightsBaseDate 총회계열 미적재)", JobName);
  116. return true;
  117. }
  118. // 조회 시도(0행 포함) 마커 기준 정렬(키=custno|stdDt) — 총회 없는 (회사,기준일)도 재조회 회피(#1)
  119. var markers = await SeibroMarkers.LoadFetchMarkersAsync(db, MeetingJobKey, ct);
  120. var targets = triggers.Select(t => (
  121. Key: (t.IssucoCustno, t.RgtStdDt),
  122. LastUpdatedAt: markers.TryGetValue(MeetingKey(t.IssucoCustno, t.RgtStdDt), out var last) ? (DateTime?)last : null
  123. )).ToList();
  124. // getGmeetInfo + getGmeetMeasureInfo = 2콜/트리거 → maxPerRun 은 잔여예산/2 로 산정(각 콜이 개별 TryConsume).
  125. var maxPerRun = quota.Remaining(SeibroCategory.Corp, cfg.CorpBudget) / 2;
  126. var quotaExhausted = false;
  127. var processed = await SeibroRollingSweep.RunAsync(
  128. targets: targets,
  129. fetchAndUpsert: async (key, token) => {
  130. var (custno, stdDt) = key;
  131. var stdDtStr = stdDt.ToString("yyyyMMdd");
  132. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  133. {
  134. quotaExhausted = true;
  135. return;
  136. }
  137. var gmeetXml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getGmeetInfo", [new("ISSUCO_CUSTNO", custno.ToString()), new("RGT_STD_DT", stdDtStr)], Logger, token);
  138. var gmeetRows = SeibroGmeetParser.Parse(SeibroXml.Parse(gmeetXml));
  139. var (gi, gu) = await SeibroCorpActionImport.UpsertGeneralMeetingsAsync(db, gmeetRows, token);
  140. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  141. {
  142. quotaExhausted = true;
  143. return;
  144. }
  145. if (cfg.DelayMs > 0)
  146. {
  147. await Task.Delay(cfg.DelayMs, token);
  148. }
  149. var measureXml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getGmeetMeasureInfo", [new("ISSUCO_CUSTNO", custno.ToString()), new("RGT_STD_DT", stdDtStr)], Logger, token);
  150. var measureRows = SeibroGmeetMeasureParser.Parse(SeibroXml.Parse(measureXml));
  151. var (mi, mu) = await SeibroCorpActionImport.UpsertMeetingAgendasAsync(db, measureRows, token);
  152. await SeibroMarkers.TouchFetchMarkerAsync(db, MeetingJobKey, MeetingKey(custno, stdDt), token); // 2콜 완료(0행 포함) 후 스탬핑
  153. Logger.LogInformation("[{Job}] 총회 ISSUCO_CUSTNO={Custno} RGT_STD_DT={Std} — 총회 ins={Gi}/upd={Gu}, 안건 ins={Mi}/upd={Mu}", JobName, custno, stdDtStr, gi, gu, mi, mu);
  154. },
  155. maxPerRun: maxPerRun,
  156. delayMs: cfg.DelayMs,
  157. ct: ct);
  158. Logger.LogInformation("[{Job}] 총회 rolling 완료 — 트리거={Triggers}, 처리={Processed} (maxPerRun={Max})", JobName, targets.Count, processed, maxPerRun);
  159. return !quotaExhausted;
  160. }
  161. /// <summary>
  162. /// b) 상호변경 이벤트 구동 — RightsBaseDate RGT_RACD=204 의 (회사번호, 기준일) 중 CorpNameChange 미수집·stale 우선.
  163. /// getFmnmAltInfo(ISSUCO_CUSTNO, RGT_STD_DT) 1콜(Corp). 예산 소진 시 false.
  164. /// </summary>
  165. private async Task<bool> RollNameChangesAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, CancellationToken ct)
  166. {
  167. var triggers = await db.RightsBaseDate.AsNoTracking()
  168. .Where(c => c.RgtRacd == NameChangeRacd)
  169. .Select(c => new { c.IssucoCustno, c.RgtStdDt })
  170. .Distinct()
  171. .ToListAsync(ct);
  172. if (triggers.Count == 0)
  173. {
  174. Logger.LogInformation("[{Job}] 상호변경 트리거 없음 (RightsBaseDate RGT_RACD=204 미적재)", JobName);
  175. return true;
  176. }
  177. // 조회 시도(0행 포함) 마커 기준 정렬(키=custno|stdDt) — 상호변경 없는 (회사,기준일)도 재조회 회피(#1)
  178. var markers = await SeibroMarkers.LoadFetchMarkersAsync(db, NameChangeJobKey, ct);
  179. var targets = triggers.Select(t => (
  180. Key: (t.IssucoCustno, t.RgtStdDt),
  181. LastUpdatedAt: markers.TryGetValue(MeetingKey(t.IssucoCustno, t.RgtStdDt), out var last) ? (DateTime?)last : null
  182. )).ToList();
  183. var maxPerRun = quota.Remaining(SeibroCategory.Corp, cfg.CorpBudget);
  184. var quotaExhausted = false;
  185. var processed = await SeibroRollingSweep.RunAsync(
  186. targets: targets,
  187. fetchAndUpsert: async (key, token) => {
  188. var (custno, stdDt) = key;
  189. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  190. {
  191. quotaExhausted = true;
  192. return;
  193. }
  194. var xml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getFmnmAltInfo", [new("ISSUCO_CUSTNO", custno.ToString()), new("RGT_STD_DT", stdDt.ToString("yyyyMMdd"))], Logger, token);
  195. var rows = SeibroFmnmAltParser.Parse(SeibroXml.Parse(xml));
  196. var (inserted, updated) = await SeibroCorpActionImport.UpsertNameChangesAsync(db, rows, token);
  197. await SeibroMarkers.TouchFetchMarkerAsync(db, NameChangeJobKey, MeetingKey(custno, stdDt), token);
  198. Logger.LogInformation("[{Job}] 상호변경 ISSUCO_CUSTNO={Custno} RGT_STD_DT={Std} rows={Rows} — inserted={Inserted}, updated={Updated}", JobName, custno, stdDt, rows.Count, inserted, updated);
  199. },
  200. maxPerRun: maxPerRun,
  201. delayMs: cfg.DelayMs,
  202. ct: ct);
  203. Logger.LogInformation("[{Job}] 상호변경 rolling 완료 — 트리거={Triggers}, 처리={Processed} (maxPerRun={Max})", JobName, targets.Count, processed, maxPerRun);
  204. return !quotaExhausted;
  205. }
  206. /// <summary>
  207. /// c) 대금지급일정 날짜 스윕(전 캘린더일, 최신→과거) × 구분{1,3} — 지급일+구분 window delete+insert. 미적재 (일,구분)만.
  208. /// ⚠️ 대금지급일은 배당·단주 지급일이라 주말/휴장 가능성 있어(SeibroDividendSync 판단 동일) 전 캘린더일 스윕. 예산 소진 시 false.
  209. /// </summary>
  210. private async Task<bool> SweepPaymentSchedulesAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, DateOnly startDate, DateOnly today, CancellationToken ct)
  211. {
  212. var fetched = 0;
  213. var first = true;
  214. for (var day = today; day >= startDate; day = day.AddDays(-1))
  215. {
  216. foreach (var tpcd in PayCostTpcds)
  217. {
  218. ct.ThrowIfCancellationRequested();
  219. // 데이터 존재 OR 조회완료 마커(축=tpcd) → 스킵 (지급 없는 (일,구분)도 재조회 회피, 리뷰 결함 #1)
  220. if (await db.PaymentSchedule.AsNoTracking().AnyAsync(c => c.Th1PayTermBeginDt == day && c.PayCostTpcd == tpcd, ct) || await SeibroMarkers.IsSweptAsync(db, PaySchedJobKey, day, tpcd, ct))
  221. {
  222. continue;
  223. }
  224. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  225. {
  226. Logger.LogWarning("[{Job}] 기업 예산({Budget}) 소진 — getCostPaySchedul {Day}/{Tpcd} 부터 중단", JobName, cfg.CorpBudget, day, tpcd);
  227. return false;
  228. }
  229. if (!first && cfg.DelayMs > 0)
  230. {
  231. await Task.Delay(cfg.DelayMs, ct);
  232. }
  233. first = false;
  234. var xml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getCostPaySchedul", [new("TH1_PAY_TERM_BEGIN_DT", day.ToString("yyyyMMdd")), new("PAY_COST_TPCD", tpcd)], Logger, ct);
  235. var rows = SeibroCostPaySchedulParser.Parse(SeibroXml.Parse(xml));
  236. var (inserted, deleted) = await SeibroCorpActionImport.ReplacePaymentScheduleWindowAsync(db, day, tpcd, rows, ct);
  237. await SeibroMarkers.MarkSweptAsync(db, PaySchedJobKey, day, tpcd, ct); // 0행 포함 조회완료 기록
  238. Logger.LogInformation("[{Job}] getCostPaySchedul {Day}/{Tpcd} rows={Rows} — inserted={Inserted}, deleted={Deleted}", JobName, day, tpcd, rows.Count, inserted, deleted);
  239. fetched++;
  240. }
  241. }
  242. Logger.LogInformation("[{Job}] 대금지급일정 스윕 완료 — 창=[{Start}~{End}], fetch={Fetched}콜", JobName, startDate, today, fetched);
  243. return true;
  244. }
  245. /// <summary>
  246. /// d) 단주대금 이벤트 구동 — PaymentSchedule 중 PAY_COST_TPCD=3(단주) 의 (회사번호, 지급일) 중 OddLotPayment 미수집·stale 우선.
  247. /// getOddLotInfo(ISSUCO_CUSTNO, TH1_PAY_TERM_BEGIN_DT) 1콜(Corp). 예산 소진 시 false.
  248. /// </summary>
  249. private async Task<bool> RollOddLotsAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, CancellationToken ct)
  250. {
  251. var triggers = await db.PaymentSchedule.AsNoTracking()
  252. .Where(c => c.PayCostTpcd == OddLotPayCostTpcd)
  253. .Select(c => new { c.IssucoCustno, c.Th1PayTermBeginDt })
  254. .Distinct()
  255. .ToListAsync(ct);
  256. if (triggers.Count == 0)
  257. {
  258. Logger.LogInformation("[{Job}] 단주대금 트리거 없음 (PaymentSchedule 단주(구분3) 미적재)", JobName);
  259. return true;
  260. }
  261. // 조회 시도(0행 포함) 마커 기준 정렬(키=custno|payDate) — 단주 없는 (회사,지급일)도 재조회 회피(#1)
  262. var markers = await SeibroMarkers.LoadFetchMarkersAsync(db, OddLotJobKey, ct);
  263. var targets = triggers.Select(t => (
  264. Key: (t.IssucoCustno, PayDate: t.Th1PayTermBeginDt),
  265. LastUpdatedAt: markers.TryGetValue(MeetingKey(t.IssucoCustno, t.Th1PayTermBeginDt), out var last) ? (DateTime?)last : null
  266. )).ToList();
  267. var maxPerRun = quota.Remaining(SeibroCategory.Corp, cfg.CorpBudget);
  268. var quotaExhausted = false;
  269. var processed = await SeibroRollingSweep.RunAsync(
  270. targets: targets,
  271. fetchAndUpsert: async (key, token) => {
  272. var (custno, payDate) = key;
  273. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  274. {
  275. quotaExhausted = true;
  276. return;
  277. }
  278. var xml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getOddLotInfo", [new("ISSUCO_CUSTNO", custno.ToString()), new("TH1_PAY_TERM_BEGIN_DT", payDate.ToString("yyyyMMdd"))], Logger, token);
  279. var rows = SeibroOddLotParser.Parse(SeibroXml.Parse(xml));
  280. var (inserted, updated) = await SeibroCorpActionImport.UpsertOddLotsAsync(db, custno, payDate, rows, token);
  281. await SeibroMarkers.TouchFetchMarkerAsync(db, OddLotJobKey, MeetingKey(custno, payDate), token);
  282. Logger.LogInformation("[{Job}] 단주대금 ISSUCO_CUSTNO={Custno} 지급일={Pay} rows={Rows} — inserted={Inserted}, updated={Updated}", JobName, custno, payDate, rows.Count, inserted, updated);
  283. },
  284. maxPerRun: maxPerRun,
  285. delayMs: cfg.DelayMs,
  286. ct: ct);
  287. Logger.LogInformation("[{Job}] 단주대금 rolling 완료 — 트리거={Triggers}, 처리={Processed} (maxPerRun={Max})", JobName, targets.Count, processed, maxPerRun);
  288. return !quotaExhausted;
  289. }
  290. /// <summary>
  291. /// e) CB/BW 행사 날짜 스윕(전 캘린더일, 최신→과거) — 권리행사일 window delete+insert. 미적재일만. Stock 예산. 예산 소진 시 false.
  292. /// ⚠️ 권리행사일(RGT_STD_DT)은 영업일 성격이나 스펙상 확정 불가라 전 캘린더일 스윕(보수적). 반환 BOND_ISIN 이 (f) 발견 소스.
  293. /// </summary>
  294. private async Task<bool> SweepExercisesAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, DateOnly startDate, DateOnly today, CancellationToken ct)
  295. {
  296. var fetched = 0;
  297. var first = true;
  298. for (var day = today; day >= startDate; day = day.AddDays(-1))
  299. {
  300. ct.ThrowIfCancellationRequested();
  301. // 데이터 존재 OR 조회완료 마커 → 스킵 (행사 없는 날도 재조회 회피, 리뷰 결함 #1)
  302. if (await db.ConvertibleExercise.AsNoTracking().AnyAsync(c => c.RgtStdDt == day, ct) || await SeibroMarkers.IsSweptAsync(db, ExerciseJobKey, day, null, ct))
  303. {
  304. continue;
  305. }
  306. if (!quota.TryConsume(SeibroCategory.Stock, 1, cfg.StockBudget))
  307. {
  308. Logger.LogWarning("[{Job}] 주식 예산({Budget}) 소진 — getXrcStkOptionXrcInfo {Day} 부터 중단", JobName, cfg.StockBudget, day);
  309. return false;
  310. }
  311. if (!first && cfg.DelayMs > 0)
  312. {
  313. await Task.Delay(cfg.DelayMs, ct);
  314. }
  315. first = false;
  316. var xml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getXrcStkOptionXrcInfo", [new("RGT_STD_DT", day.ToString("yyyyMMdd"))], Logger, ct);
  317. var rows = SeibroXrcStkOptionXrcParser.Parse(SeibroXml.Parse(xml));
  318. var (inserted, deleted) = await SeibroCorpActionImport.ReplaceExerciseWindowAsync(db, day, day, rows, ct);
  319. await SeibroMarkers.MarkSweptAsync(db, ExerciseJobKey, day, null, ct); // 0행 포함 조회완료 기록
  320. Logger.LogInformation("[{Job}] getXrcStkOptionXrcInfo {Day} rows={Rows} — inserted={Inserted}, deleted={Deleted}", JobName, day, rows.Count, inserted, deleted);
  321. fetched++;
  322. }
  323. Logger.LogInformation("[{Job}] CB/BW 행사 스윕 완료 — 창=[{Start}~{End}], fetch={Fetched}일", JobName, startDate, today, fetched);
  324. return true;
  325. }
  326. /// <summary>
  327. /// f) CB/BW 행사대상 rolling per-채권ISIN — (e) ConvertibleExercise 에서 발견된 DISTINCT BondIsin 중 ConvertibleBondTarget 미수집·stale 우선.
  328. /// getXrcStkStatInfo(BOND_ISIN) 1콜(Stock). Wave 4 BondIssuance 미도입이라 발견 소스는 (e) 결과뿐.
  329. /// </summary>
  330. private async Task RollBondTargetsAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, CancellationToken ct)
  331. {
  332. var bondIsins = await db.ConvertibleExercise.AsNoTracking().Select(c => c.BondIsin).Distinct().ToListAsync(ct);
  333. if (bondIsins.Count == 0)
  334. {
  335. Logger.LogInformation("[{Job}] getXrcStkStatInfo 대상 없음 (ConvertibleExercise 비어 있음 — 발견 소스 없음)", JobName);
  336. return;
  337. }
  338. // 조회 시도(0행 포함) 마커 기준 정렬(키=bondIsin) — getXrcStkStatInfo 실샘플 result=0 이라 대상 행이 안 남아 재조회되던 결함(#1) 해소
  339. var markers = await SeibroMarkers.LoadFetchMarkersAsync(db, BondTargetJobKey, ct);
  340. var targets = bondIsins.Select(isin => (Key: isin, LastUpdatedAt: markers.TryGetValue(isin, out var last) ? (DateTime?)last : null)).ToList();
  341. var maxPerRun = quota.Remaining(SeibroCategory.Stock, cfg.StockBudget);
  342. var processed = await SeibroRollingSweep.RunAsync(
  343. targets: targets,
  344. fetchAndUpsert: async (bondIsin, token) => {
  345. if (!quota.TryConsume(SeibroCategory.Stock, 1, cfg.StockBudget))
  346. {
  347. return;
  348. }
  349. var xml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getXrcStkStatInfo", [new("BOND_ISIN", bondIsin)], Logger, token);
  350. var rows = SeibroXrcStkStatParser.Parse(SeibroXml.Parse(xml));
  351. var (inserted, updated) = await SeibroCorpActionImport.UpsertBondTargetsAsync(db, rows, token);
  352. await SeibroMarkers.TouchFetchMarkerAsync(db, BondTargetJobKey, bondIsin, token);
  353. Logger.LogInformation("[{Job}] getXrcStkStatInfo BOND_ISIN={Bond} rows={Rows} — inserted={Inserted}, updated={Updated}", JobName, bondIsin, rows.Count, inserted, updated);
  354. },
  355. maxPerRun: maxPerRun,
  356. delayMs: cfg.DelayMs,
  357. ct: ct);
  358. Logger.LogInformation("[{Job}] getXrcStkStatInfo rolling 완료 — 대상채권={Targets}, 처리={Processed} (maxPerRun={Max})", JobName, targets.Count, processed, maxPerRun);
  359. }
  360. /// <summary>복합키(회사번호 + 날짜)를 마커 EntityKey 문자열로 결합 — 총회/상호변경/단주 rolling 공용.</summary>
  361. private static string MeetingKey(int custno, DateOnly date)
  362. {
  363. return $"{custno}|{date:yyyyMMdd}";
  364. }
  365. }