| | |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
|---|
| | | import com.ruoyi.domain.DocumentMaterials; |
|---|
| | | import com.ruoyi.domain.vo.DocumentMaterialFileStyle; |
|---|
| | | import com.ruoyi.domain.vo.DocumentMaterialsFileList; |
|---|
| | | import com.ruoyi.domain.vo.DocumentMaterialsVo; |
|---|
| | | import com.ruoyi.domain.vo.DocumentMaterialsVoLarge; |
|---|
| | | import com.ruoyi.domain.vo.*; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | |
|---|
| | | |
|---|
| | | //查询卷内目录 |
|---|
| | | @Select( |
|---|
| | | "select ROW_NUMBER() OVER (ORDER BY page_number) AS num, document_number, creator,title, date, page_number,dm.remarks, ar.record_id, publicity from document_materials as dm, archive_records as ar \n" + |
|---|
| | | "select ROW_NUMBER() OVER (ORDER BY page_number) AS num, document_number, creator,title, date, page_number,dm.remarks, ar.record_id, publicity, file_style, dm.retention_period from document_materials as dm, archive_records as ar \n" + |
|---|
| | | " WHERE ar.id = dm.record_id and page_number IN (\n" + |
|---|
| | | " SELECT MIN(page_number)\n" + |
|---|
| | | " FROM document_materials where record_id=#{recordId}\n" + |
|---|
| | | " GROUP BY stage, title) and ar.id =#{recordId} order by page_number ;") |
|---|
| | | List<DocumentMaterialsVo> getArchiveMatInfo(@Param("recordId") int recordId); |
|---|
| | | |
|---|
| | | //查询卷内目录的详细信息 |
|---|
| | | @Select( |
|---|
| | | "select ROW_NUMBER() OVER (ORDER BY page_number) AS num, document_number, creator,title, date, page_number, publicity, file_style, stage,is_attachment,is_diagram, dm.retention_period,is_sensitive,is_canceled,dm.remarks from document_materials as dm, archive_records as ar \n" + |
|---|
| | | " WHERE ar.id = dm.record_id and page_number IN (\n" + |
|---|
| | | " SELECT MIN(page_number)\n" + |
|---|
| | | " FROM document_materials where record_id=#{recordId}\n" + |
|---|
| | | " GROUP BY stage, title) and ar.id =#{recordId} order by page_number ;") |
|---|
| | | List<DocumentMaterialsVoMid> getArchiveMatInfoAll(@Param("recordId") int recordId); |
|---|
| | | |
|---|
| | | @Select( "select ROW_NUMBER() OVER (ORDER BY page_number) AS num,ar.record_id, file_number, \n" + |
|---|
| | | " document_number, creator, title, date, page_number, page_order, \n" + |
|---|
