| | |
|---|
| | | @Select("select ROW_NUMBER() OVER (ORDER BY record_id) AS num, filing_number, concat_ws(\" \", inquiry_number,record_id) as inqrid, case_title, public_attribute, (select count(*) as cnt from document_materials where record_id=ar.id) as cnt, remarks from archive_records as ar \n" + |
|---|
| | | "${ew.customSqlSegment}") |
|---|
| | | public List<ArchiveRecordSmall> selectByIds(@Param("ew") LambdaQueryWrapper<ArchiveRecords> queryWrapper); |
|---|
| | | |
|---|
| | | @Select("SELECT COALESCE(SUM(IF(url IS NULL AND file_style != '文字材料', 1, 0)), 0) = 0 AS result from document_materials where `record_id` = #{recordId}") |
|---|
| | | boolean whether(@Param("recordId") Long recordId); |
|---|
| | | } |
|---|
