| | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | @Mapper |
| | |
| | | List<AnalysisResult> statisticAyasis(); |
| | | |
| | | |
| | | @Select("update archive_records set record_status=#{status} where id=#{id}") |
| | | public void updateStatusById(@Param("status") String status, @Param("id")Long id); |
| | | @Select("update archive_records set record_status=#{status}, create_time=#{date} where id=#{id}") |
| | | public void updateStatusById(@Param("status") String status, @Param("id")Long id ,@Param("date") Date date); |
| | | |
| | | @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}") |