| | |
|---|
| | | |
|---|
| | | @Select({ |
|---|
| | | "<script>", |
|---|
| | | "SELECT distinct c.*,a.archive_records_id, if(a.user_id=#{userId}, TRUE, FALSE) as tst,b.user_id FROM archiverecordstouser a inner join sys_user b ON a.user_id = b.user_id right join archive_records c on c.record_id=a.archive_records_id ${ew.customSqlSegment} ", |
|---|
| | | "SELECT distinct c.*,a.archive_records_id, if(a.user_id=#{userId}, TRUE, FALSE) as tst,b.user_id FROM archiverecordstouser a inner join sys_user b ON a.user_id = b.user_id right join archive_records c on c.id=a.archive_records_id ${ew.customSqlSegment} ", |
|---|
| | | "<if test= \"userId !=1 \">", |
|---|
| | | "order by tst desc", |
|---|
| | | "</if>", |
|---|
| | |
|---|
| | | 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" + |
|---|
| | | "(select count(*) from archive_records as ac where ac.every_project_name=ar.every_project_name and record_status='录入完成') as finished \n" + |
|---|
| | | " from archive_records as ar GROUP BY every_project_name") |
|---|
| | | "(select count(*) from archive_records as ac where ac.every_project_name=ar.every_project_name and record_status='未上传附件') as unwf,\n" + |
|---|
| | | "(select count(*) from archive_records as ac where ac.every_project_name=ar.every_project_name and record_status='待修改') as dxg,\n" + |
|---|
| | | " (select count(*) from archive_records as ac where ac.every_project_name=ar.every_project_name and record_status='录入完成') as finished\n" + |
|---|
| | | " from archive_records as ar GROUP BY every_project_name\n" + |
|---|
| | | " ") |
|---|
| | | List<AnalysisResult> statisticAyasis(); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("update archive_records set record_status='录入完成' where id=#{id}") |
|---|
| | | public void updateStatusById(@Param("id")Long id); |
|---|
| | | @Select("update archive_records set record_status=#{status} where id=#{id}") |
|---|
| | | public void updateStatusById(@Param("status") String status, @Param("id")Long id); |
|---|
| | | |
|---|
| | | @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}") |
|---|
