| | |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | |
|---|
| | | import java.util.Date; |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | @Mapper |
|---|
| | |
|---|
| | | @Select("UPDATE `archivesys`.`archive_records` SET `inquiry_number` = '', `case_title` = NULL, `public_attribute` = NULL, `preparation_unit` = NULL, `preparation_date` = NULL, `retention_period` = NULL, `security_classification` = NULL, `page_count` = NULL, `filing_number` = NULL, `construction_unit` = NULL, `construction_address` = NULL, `project_name` = '', `project_number` = NULL, `scanning_company` = NULL, `archive_room_number` = NULL, `microfilm_number` = NULL, `remarks` = NULL, `historical_reference_number` = NULL, `record_status` = '待修改', `every_project_name` = NULL WHERE `id` = #{id}") |
|---|
| | | Long updateAllInfoById(@Param("id") Long id); |
|---|
| | | |
|---|
| | | @Select("select record_id,archive_room_number,microfilm_number,inquiry_number,case_title,preparation_date,preparation_unit,retention_period,security_classification from archive_records where id=#{id}") |
|---|
| | | @Select("select record_id,page_count,archive_room_number,microfilm_number,inquiry_number,case_title,preparation_date,preparation_unit,retention_period,security_classification from archive_records where id=#{id}") |
|---|
| | | ArchiveInfoVo findByRecordId(@Param("id") Long id); |
|---|
| | | |
|---|
| | | @Select("SELECT every_project_name, count(*) as cnt, (select count(*) from archive_records as ac where ac.every_project_name=ar.every_project_name and record_status='未录入') as unfinished,\n" + |
|---|
| | |
|---|
| | | 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}") |
|---|
