#975: RechnungJdbcService.kt
projectforge-business/src/main/kotlin/org/projectforge/business/fibu/RechnungJdbcService.kt JDBC Service, projectforge-business/src/main/kotlin/org/projectforge/business/fibu/RechnungJdbcService.kt 179 lines · 143 code · 28 comments · 8 blank
Spring @Service that uses raw JDBC (via JdbcTemplate) instead of Hibernate for high-performance bulk data access. Contains two main SQL queries: SELECT_RECHNUNG_WITH_KOST (joins t_fibu_rechnung → t_fibu_rechnung_position → t_fibu_kost_zuweisung) and SELECT_EINGANGS_RECHNUNG_WITH_KOST (same for incoming invoices). The selectRechnungInfos() method assembles full RechnungInfo objects from flat JDBC results. Also provides selectRechnungsPositionenWithAuftragPosition() to fetch positions with their linked order positions. Used by AbstractRechnungCache for building cache data.
Git History
868d6abb7 2026-01-01 Kai Reinhard: 2025 -> 2026
63081666f 2025-01-01 Kai Reinhard: Source file headers: 2024-> 2025.
b4c78b8e6 2024-12-17 Kai Reinhard: RechnungJdbcService: fetch invoice number as well.
f9ed10bf8 2024-12-17 Kai Reinhard: RechnungJdbcService: fetch rechnung.datum (needed by RechnungInfo).
caea043eb 2024-11-14 Kai Reinhard: Migration stuff in progress... (all tests of all packages: OK).
c7e47b6fa 2024-11-11 Kai Reinhard: Migration stuff in progress... (all tests of all packages: OK).
12610fee2 2024-11-09 Kai Reinhard: Migration stuff in progress... (all tests of all packages: OK).
ff2cc4cfa 2024-11-09 Kai Reinhard: Migration stuff in progress... (all tests of all packages: OK).