SeibroCorpActionSyncService.cs 24 KB

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