SeibroCorpActionSyncService.cs 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429
  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. // 단계별 독립 실행 — 한 단계의 SEIBro 오류가 다른 단계를 막지 않도록 개별 try/catch.
  66. // 반환 false = 예산 소진(전체 중단). 파싱/HTTP 오류 = 해당 단계만 skip(마커 미기록 → 다음 실행 재시도).
  67. async Task<bool> Phase(string name, Func<CancellationToken, Task<bool>> body)
  68. {
  69. try
  70. {
  71. return await body(ct);
  72. }
  73. catch (Exception ex) when (ex is HttpRequestException or System.Xml.XmlException or FormatException)
  74. {
  75. Logger.LogWarning(ex, "[{Job}] {Phase} SEIBro 오류 — 단계 skip(다음 실행 재시도)", JobName, name);
  76. return true;
  77. }
  78. }
  79. // a) 총회 → b) 상호변경 → c) 대금지급일정 → d) 단주대금 → e) CB/BW 행사 스윕 → f) CB/BW 행사대상 rolling
  80. if (!await Phase("총회", t => RollMeetingsAsync(db, client, cfg, t))) { return true; }
  81. if (!await Phase("상호변경", t => RollNameChangesAsync(db, client, cfg, t))) { return true; }
  82. if (!await Phase("대금지급일정", t => SweepPaymentSchedulesAsync(db, client, cfg, startDate, todayKst, t))) { return true; }
  83. if (!await Phase("단주대금", t => RollOddLotsAsync(db, client, cfg, t))) { return true; }
  84. if (!await Phase("CB/BW행사", t => SweepExercisesAsync(db, client, cfg, startDate, todayKst, t))) { return true; }
  85. // f) CB/BW 행사대상 rolling (void 반환) — 개별 try/catch
  86. await Phase("CB/BW행사대상", async t => { await RollBondTargetsAsync(db, client, cfg, t); return true; });
  87. return true;
  88. }
  89. /// <summary>
  90. /// a) 총회 이벤트 구동 — RightsBaseDate RGT_RACD∈{001,002,003,009} 의 (회사번호, 기준일) 중 GeneralMeeting 미수집·stale 우선.
  91. /// (회사, 기준일) 당 getGmeetInfo + getGmeetMeasureInfo 2콜(각각 Corp 예산 소비). 예산 소진 시 false.
  92. /// </summary>
  93. private async Task<bool> RollMeetingsAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, CancellationToken ct)
  94. {
  95. var triggers = await db.RightsBaseDate.AsNoTracking()
  96. .Where(c => MeetingRacds.Contains(c.RgtRacd))
  97. .Select(c => new { c.IssucoCustno, c.RgtStdDt })
  98. .Distinct()
  99. .ToListAsync(ct);
  100. if (triggers.Count == 0)
  101. {
  102. Logger.LogInformation("[{Job}] 총회 트리거 없음 (RightsBaseDate 총회계열 미적재)", JobName);
  103. return true;
  104. }
  105. // 조회 시도(0행 포함) 마커 기준 정렬(키=custno|stdDt) — 총회 없는 (회사,기준일)도 재조회 회피(#1)
  106. var markers = await SeibroMarkers.LoadFetchMarkersAsync(db, MeetingJobKey, ct);
  107. var targets = triggers.Select(t => (
  108. Key: (t.IssucoCustno, t.RgtStdDt),
  109. LastUpdatedAt: markers.TryGetValue(MeetingKey(t.IssucoCustno, t.RgtStdDt), out var last) ? (DateTime?)last : null
  110. )).ToList();
  111. // getGmeetInfo + getGmeetMeasureInfo = 2콜/트리거 → maxPerRun 은 잔여예산/2 로 산정(각 콜이 개별 TryConsume).
  112. var maxPerRun = quota.Remaining(SeibroCategory.Corp, cfg.CorpBudget) / 2;
  113. var quotaExhausted = false;
  114. var processed = await SeibroRollingSweep.RunAsync(
  115. targets: targets,
  116. fetchAndUpsert: async (key, token) => {
  117. var (custno, stdDt) = key;
  118. var stdDtStr = stdDt.ToString("yyyyMMdd");
  119. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  120. {
  121. quotaExhausted = true;
  122. return;
  123. }
  124. var gmeetXml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getGmeetInfo", [new("ISSUCO_CUSTNO", custno.ToString()), new("RGT_STD_DT", stdDtStr)], Logger, token);
  125. var gmeetRows = SeibroGmeetParser.Parse(SeibroXml.Parse(gmeetXml));
  126. var (gi, gu) = await SeibroCorpActionImport.UpsertGeneralMeetingsAsync(db, gmeetRows, token);
  127. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  128. {
  129. quotaExhausted = true;
  130. return;
  131. }
  132. if (cfg.DelayMs > 0)
  133. {
  134. await Task.Delay(cfg.DelayMs, token);
  135. }
  136. var measureXml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getGmeetMeasureInfo", [new("ISSUCO_CUSTNO", custno.ToString()), new("RGT_STD_DT", stdDtStr)], Logger, token);
  137. var measureRows = SeibroGmeetMeasureParser.Parse(SeibroXml.Parse(measureXml));
  138. var (mi, mu) = await SeibroCorpActionImport.UpsertMeetingAgendasAsync(db, measureRows, token);
  139. await SeibroMarkers.TouchFetchMarkerAsync(db, MeetingJobKey, MeetingKey(custno, stdDt), token); // 2콜 완료(0행 포함) 후 스탬핑
  140. 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);
  141. },
  142. maxPerRun: maxPerRun,
  143. delayMs: cfg.DelayMs,
  144. ct: ct);
  145. Logger.LogInformation("[{Job}] 총회 rolling 완료 — 트리거={Triggers}, 처리={Processed} (maxPerRun={Max})", JobName, targets.Count, processed, maxPerRun);
  146. return !quotaExhausted;
  147. }
  148. /// <summary>
  149. /// b) 상호변경 이벤트 구동 — RightsBaseDate RGT_RACD=204 의 (회사번호, 기준일) 중 CorpNameChange 미수집·stale 우선.
  150. /// getFmnmAltInfo(ISSUCO_CUSTNO, RGT_STD_DT) 1콜(Corp). 예산 소진 시 false.
  151. /// </summary>
  152. private async Task<bool> RollNameChangesAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, CancellationToken ct)
  153. {
  154. var triggers = await db.RightsBaseDate.AsNoTracking()
  155. .Where(c => c.RgtRacd == NameChangeRacd)
  156. .Select(c => new { c.IssucoCustno, c.RgtStdDt })
  157. .Distinct()
  158. .ToListAsync(ct);
  159. if (triggers.Count == 0)
  160. {
  161. Logger.LogInformation("[{Job}] 상호변경 트리거 없음 (RightsBaseDate RGT_RACD=204 미적재)", JobName);
  162. return true;
  163. }
  164. // 조회 시도(0행 포함) 마커 기준 정렬(키=custno|stdDt) — 상호변경 없는 (회사,기준일)도 재조회 회피(#1)
  165. var markers = await SeibroMarkers.LoadFetchMarkersAsync(db, NameChangeJobKey, ct);
  166. var targets = triggers.Select(t => (
  167. Key: (t.IssucoCustno, t.RgtStdDt),
  168. LastUpdatedAt: markers.TryGetValue(MeetingKey(t.IssucoCustno, t.RgtStdDt), out var last) ? (DateTime?)last : null
  169. )).ToList();
  170. var maxPerRun = quota.Remaining(SeibroCategory.Corp, cfg.CorpBudget);
  171. var quotaExhausted = false;
  172. var processed = await SeibroRollingSweep.RunAsync(
  173. targets: targets,
  174. fetchAndUpsert: async (key, token) => {
  175. var (custno, stdDt) = key;
  176. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  177. {
  178. quotaExhausted = true;
  179. return;
  180. }
  181. 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);
  182. var rows = SeibroFmnmAltParser.Parse(SeibroXml.Parse(xml));
  183. var (inserted, updated) = await SeibroCorpActionImport.UpsertNameChangesAsync(db, rows, token);
  184. await SeibroMarkers.TouchFetchMarkerAsync(db, NameChangeJobKey, MeetingKey(custno, stdDt), token);
  185. Logger.LogInformation("[{Job}] 상호변경 ISSUCO_CUSTNO={Custno} RGT_STD_DT={Std} rows={Rows} — inserted={Inserted}, updated={Updated}", JobName, custno, stdDt, rows.Count, inserted, updated);
  186. },
  187. maxPerRun: maxPerRun,
  188. delayMs: cfg.DelayMs,
  189. ct: ct);
  190. Logger.LogInformation("[{Job}] 상호변경 rolling 완료 — 트리거={Triggers}, 처리={Processed} (maxPerRun={Max})", JobName, targets.Count, processed, maxPerRun);
  191. return !quotaExhausted;
  192. }
  193. /// <summary>
  194. /// c) 대금지급일정 날짜 스윕(전 캘린더일, 최신→과거) × 구분{1,3} — 지급일+구분 window delete+insert. 미적재 (일,구분)만.
  195. /// ⚠️ 대금지급일은 배당·단주 지급일이라 주말/휴장 가능성 있어(SeibroDividendSync 판단 동일) 전 캘린더일 스윕. 예산 소진 시 false.
  196. /// </summary>
  197. private async Task<bool> SweepPaymentSchedulesAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, DateOnly startDate, DateOnly today, CancellationToken ct)
  198. {
  199. var fetched = 0;
  200. var first = true;
  201. for (var day = today; day >= startDate; day = day.AddDays(-1))
  202. {
  203. foreach (var tpcd in PayCostTpcds)
  204. {
  205. ct.ThrowIfCancellationRequested();
  206. // 데이터 존재 OR 조회완료 마커(축=tpcd) → 스킵 (지급 없는 (일,구분)도 재조회 회피, 리뷰 결함 #1)
  207. if (await db.PaymentSchedule.AsNoTracking().AnyAsync(c => c.Th1PayTermBeginDt == day && c.PayCostTpcd == tpcd, ct) || await SeibroMarkers.IsSweptAsync(db, PaySchedJobKey, day, tpcd, ct))
  208. {
  209. continue;
  210. }
  211. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  212. {
  213. Logger.LogWarning("[{Job}] 기업 예산({Budget}) 소진 — getCostPaySchedul {Day}/{Tpcd} 부터 중단", JobName, cfg.CorpBudget, day, tpcd);
  214. return false;
  215. }
  216. if (!first && cfg.DelayMs > 0)
  217. {
  218. await Task.Delay(cfg.DelayMs, ct);
  219. }
  220. first = false;
  221. 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);
  222. var rows = SeibroCostPaySchedulParser.Parse(SeibroXml.Parse(xml));
  223. var (inserted, deleted) = await SeibroCorpActionImport.ReplacePaymentScheduleWindowAsync(db, day, tpcd, rows, ct);
  224. await SeibroMarkers.MarkSweptAsync(db, PaySchedJobKey, day, tpcd, ct); // 0행 포함 조회완료 기록
  225. Logger.LogInformation("[{Job}] getCostPaySchedul {Day}/{Tpcd} rows={Rows} — inserted={Inserted}, deleted={Deleted}", JobName, day, tpcd, rows.Count, inserted, deleted);
  226. fetched++;
  227. }
  228. }
  229. Logger.LogInformation("[{Job}] 대금지급일정 스윕 완료 — 창=[{Start}~{End}], fetch={Fetched}콜", JobName, startDate, today, fetched);
  230. return true;
  231. }
  232. /// <summary>
  233. /// d) 단주대금 이벤트 구동 — PaymentSchedule 중 PAY_COST_TPCD=3(단주) 의 (회사번호, 지급일) 중 OddLotPayment 미수집·stale 우선.
  234. /// getOddLotInfo(ISSUCO_CUSTNO, TH1_PAY_TERM_BEGIN_DT) 1콜(Corp). 예산 소진 시 false.
  235. /// </summary>
  236. private async Task<bool> RollOddLotsAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, CancellationToken ct)
  237. {
  238. var triggers = await db.PaymentSchedule.AsNoTracking()
  239. .Where(c => c.PayCostTpcd == OddLotPayCostTpcd)
  240. .Select(c => new { c.IssucoCustno, c.Th1PayTermBeginDt })
  241. .Distinct()
  242. .ToListAsync(ct);
  243. if (triggers.Count == 0)
  244. {
  245. Logger.LogInformation("[{Job}] 단주대금 트리거 없음 (PaymentSchedule 단주(구분3) 미적재)", JobName);
  246. return true;
  247. }
  248. // 조회 시도(0행 포함) 마커 기준 정렬(키=custno|payDate) — 단주 없는 (회사,지급일)도 재조회 회피(#1)
  249. var markers = await SeibroMarkers.LoadFetchMarkersAsync(db, OddLotJobKey, ct);
  250. var targets = triggers.Select(t => (
  251. Key: (t.IssucoCustno, PayDate: t.Th1PayTermBeginDt),
  252. LastUpdatedAt: markers.TryGetValue(MeetingKey(t.IssucoCustno, t.Th1PayTermBeginDt), out var last) ? (DateTime?)last : null
  253. )).ToList();
  254. var maxPerRun = quota.Remaining(SeibroCategory.Corp, cfg.CorpBudget);
  255. var quotaExhausted = false;
  256. var processed = await SeibroRollingSweep.RunAsync(
  257. targets: targets,
  258. fetchAndUpsert: async (key, token) => {
  259. var (custno, payDate) = key;
  260. if (!quota.TryConsume(SeibroCategory.Corp, 1, cfg.CorpBudget))
  261. {
  262. quotaExhausted = true;
  263. return;
  264. }
  265. 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);
  266. var rows = SeibroOddLotParser.Parse(SeibroXml.Parse(xml));
  267. var (inserted, updated) = await SeibroCorpActionImport.UpsertOddLotsAsync(db, custno, payDate, rows, token);
  268. await SeibroMarkers.TouchFetchMarkerAsync(db, OddLotJobKey, MeetingKey(custno, payDate), token);
  269. Logger.LogInformation("[{Job}] 단주대금 ISSUCO_CUSTNO={Custno} 지급일={Pay} rows={Rows} — inserted={Inserted}, updated={Updated}", JobName, custno, payDate, rows.Count, inserted, updated);
  270. },
  271. maxPerRun: maxPerRun,
  272. delayMs: cfg.DelayMs,
  273. ct: ct);
  274. Logger.LogInformation("[{Job}] 단주대금 rolling 완료 — 트리거={Triggers}, 처리={Processed} (maxPerRun={Max})", JobName, targets.Count, processed, maxPerRun);
  275. return !quotaExhausted;
  276. }
  277. /// <summary>
  278. /// e) CB/BW 행사 날짜 스윕(전 캘린더일, 최신→과거) — 권리행사일 window delete+insert. 미적재일만. Stock 예산. 예산 소진 시 false.
  279. /// ⚠️ 권리행사일(RGT_STD_DT)은 영업일 성격이나 스펙상 확정 불가라 전 캘린더일 스윕(보수적). 반환 BOND_ISIN 이 (f) 발견 소스.
  280. /// </summary>
  281. private async Task<bool> SweepExercisesAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, DateOnly startDate, DateOnly today, CancellationToken ct)
  282. {
  283. var fetched = 0;
  284. var first = true;
  285. for (var day = today; day >= startDate; day = day.AddDays(-1))
  286. {
  287. ct.ThrowIfCancellationRequested();
  288. // 데이터 존재 OR 조회완료 마커 → 스킵 (행사 없는 날도 재조회 회피, 리뷰 결함 #1)
  289. if (await db.ConvertibleExercise.AsNoTracking().AnyAsync(c => c.RgtStdDt == day, ct) || await SeibroMarkers.IsSweptAsync(db, ExerciseJobKey, day, null, ct))
  290. {
  291. continue;
  292. }
  293. if (!quota.TryConsume(SeibroCategory.Stock, 1, cfg.StockBudget))
  294. {
  295. Logger.LogWarning("[{Job}] 주식 예산({Budget}) 소진 — getXrcStkOptionXrcInfo {Day} 부터 중단", JobName, cfg.StockBudget, day);
  296. return false;
  297. }
  298. if (!first && cfg.DelayMs > 0)
  299. {
  300. await Task.Delay(cfg.DelayMs, ct);
  301. }
  302. first = false;
  303. var xml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getXrcStkOptionXrcInfo", [new("RGT_STD_DT", day.ToString("yyyyMMdd"))], Logger, ct);
  304. var rows = SeibroXrcStkOptionXrcParser.Parse(SeibroXml.Parse(xml));
  305. var (inserted, deleted) = await SeibroCorpActionImport.ReplaceExerciseWindowAsync(db, day, day, rows, ct);
  306. await SeibroMarkers.MarkSweptAsync(db, ExerciseJobKey, day, null, ct); // 0행 포함 조회완료 기록
  307. Logger.LogInformation("[{Job}] getXrcStkOptionXrcInfo {Day} rows={Rows} — inserted={Inserted}, deleted={Deleted}", JobName, day, rows.Count, inserted, deleted);
  308. fetched++;
  309. }
  310. Logger.LogInformation("[{Job}] CB/BW 행사 스윕 완료 — 창=[{Start}~{End}], fetch={Fetched}일", JobName, startDate, today, fetched);
  311. return true;
  312. }
  313. /// <summary>
  314. /// f) CB/BW 행사대상 rolling per-채권ISIN — (e) ConvertibleExercise 에서 발견된 DISTINCT BondIsin 중 ConvertibleBondTarget 미수집·stale 우선.
  315. /// getXrcStkStatInfo(BOND_ISIN) 1콜(Stock). Wave 4 BondIssuance 미도입이라 발견 소스는 (e) 결과뿐.
  316. /// </summary>
  317. private async Task RollBondTargetsAsync(IAppDbContext db, HttpClient client, AppSettings.SeibroSection cfg, CancellationToken ct)
  318. {
  319. var bondIsins = await db.ConvertibleExercise.AsNoTracking().Select(c => c.BondIsin).Distinct().ToListAsync(ct);
  320. if (bondIsins.Count == 0)
  321. {
  322. Logger.LogInformation("[{Job}] getXrcStkStatInfo 대상 없음 (ConvertibleExercise 비어 있음 — 발견 소스 없음)", JobName);
  323. return;
  324. }
  325. // 조회 시도(0행 포함) 마커 기준 정렬(키=bondIsin) — getXrcStkStatInfo 실샘플 result=0 이라 대상 행이 안 남아 재조회되던 결함(#1) 해소
  326. var markers = await SeibroMarkers.LoadFetchMarkersAsync(db, BondTargetJobKey, ct);
  327. var targets = bondIsins.Select(isin => (Key: isin, LastUpdatedAt: markers.TryGetValue(isin, out var last) ? (DateTime?)last : null)).ToList();
  328. var maxPerRun = quota.Remaining(SeibroCategory.Stock, cfg.StockBudget);
  329. var processed = await SeibroRollingSweep.RunAsync(
  330. targets: targets,
  331. fetchAndUpsert: async (bondIsin, token) => {
  332. if (!quota.TryConsume(SeibroCategory.Stock, 1, cfg.StockBudget))
  333. {
  334. return;
  335. }
  336. var xml = await SeibroHttp.GetStringWithRetryAsync(client, cfg.BaseUrl, cfg.ApiKey, "getXrcStkStatInfo", [new("BOND_ISIN", bondIsin)], Logger, token);
  337. var rows = SeibroXrcStkStatParser.Parse(SeibroXml.Parse(xml));
  338. var (inserted, updated) = await SeibroCorpActionImport.UpsertBondTargetsAsync(db, rows, token);
  339. await SeibroMarkers.TouchFetchMarkerAsync(db, BondTargetJobKey, bondIsin, token);
  340. Logger.LogInformation("[{Job}] getXrcStkStatInfo BOND_ISIN={Bond} rows={Rows} — inserted={Inserted}, updated={Updated}", JobName, bondIsin, rows.Count, inserted, updated);
  341. },
  342. maxPerRun: maxPerRun,
  343. delayMs: cfg.DelayMs,
  344. ct: ct);
  345. Logger.LogInformation("[{Job}] getXrcStkStatInfo rolling 완료 — 대상채권={Targets}, 처리={Processed} (maxPerRun={Max})", JobName, targets.Count, processed, maxPerRun);
  346. }
  347. /// <summary>복합키(회사번호 + 날짜)를 마커 EntityKey 문자열로 결합 — 총회/상호변경/단주 rolling 공용.</summary>
  348. private static string MeetingKey(int custno, DateOnly date)
  349. {
  350. return $"{custno}|{date:yyyyMMdd}";
  351. }
  352. }