feat: 统一档案随访周期 followupPeriod
儿保档案详情和专科档案生成配置新增 followupPeriod;配置生成妇保/儿保档案时同步写入随访周期;新增对应数据库字段脚本。
| | |
| | | @ApiModelProperty(value = "é«å±å¿ä¸æ¡-æé访æ¶é´") |
| | | private Date plannedFollowTime; |
| | | |
| | | /** éè®¿å¨æ */ |
| | | @ApiModelProperty(value = "éè®¿å¨æ") |
| | | private String followupPeriod; |
| | | |
| | | /** é«å±å¿ä¸æ¡-çé¿åè²æ£æµ */ |
| | | @ApiModelProperty(value = "é«å±å¿ä¸æ¡-çé¿åè²æ£æµ") |
| | | private String hrcGrowthDevelopmentMonitoring; |
| | |
| | | @ApiModelProperty(value = "æ¡£æ¡ç±»å: å¦ç§æ¡£æ¡ç±»å(1 æ©åå
³ç±2 å´ç»ç»æMHI),å¿ç§æ¡£æ¡ç±»å(1è¥å
»æ§ç¾ç
2å¦ä¹ å°é¾ 3é«å±å¿ä¸æ¡)") |
| | | private String archiveType; |
| | | |
| | | /** éè®¿å¨æ */ |
| | | @Excel(name = "éè®¿å¨æ") |
| | | @ApiModelProperty(value = "éè®¿å¨æ") |
| | | private String followupPeriod; |
| | | |
| | | /** ç§å®¤Codeéå(JSONæ ¼å¼ï¼å¦ ["D001","D002"]) */ |
| | | @ApiModelProperty(value = "ç§å®¤Codeéå(JSONæ ¼å¼ï¼å¦ [\"D001\",\"D002\"])") |
| | | private String deptCodes; |
| | |
| | | PatSpecificArchiveGenerateConfig config, String campusid) { |
| | | PatMaternityArchiveDetail detail = new PatMaternityArchiveDetail(); |
| | | detail.setArchiveType(config.getArchiveType()); |
| | | detail.setFollowupPeriod(config.getFollowupPeriod()); |
| | | detail.setSourceType(SOURCE_TYPE_OUTHOSP); |
| | | fillCommonDetail(detail, patMedOuthosp, patArchive, campusid); |
| | | if (patArchive != null) { |
| | |
| | | PatSpecificArchiveGenerateConfig config, String campusid) { |
| | | PatChildArchiveDetail detail = new PatChildArchiveDetail(); |
| | | detail.setArchiveType(config.getArchiveType()); |
| | | detail.setFollowupPeriod(config.getFollowupPeriod()); |
| | | detail.setSourceType(SOURCE_TYPE_OUTHOSP); |
| | | fillCommonChildDetail(detail, patMedOuthosp, patArchive, campusid); |
| | | detail.setParentPhone(patArchive != null |
| | |
| | | <result property="highRiskChildType" column="high_risk_child_type"/> |
| | | <result property="highRiskChildName" column="high_risk_child_name"/> |
| | | <result property="plannedFollowTime" column="planned_follow_time"/> |
| | | <result property="followupPeriod" column="followup_period"/> |
| | | <result property="hrcGrowthDevelopmentMonitoring" column="hrc_growth_development_monitoring"/> |
| | | <result property="hrcNeurologicalEvaluation" column="hrc_neurological_evaluation"/> |
| | | <result property="hrcInterventionRecords" column="hrc_intervention_records"/> |
| | |
| | | high_risk_child_type, |
| | | high_risk_child_name, |
| | | planned_follow_time, |
| | | followup_period, |
| | | hrc_growth_development_monitoring, |
| | | hrc_neurological_evaluation, |
| | | hrc_intervention_records, |
| | |
| | | and del_flag = '0' |
| | | <if test="archiveid != null">and archiveid = #{archiveid}</if> |
| | | <if test="archiveType != null and archiveType != ''">and archive_type = #{archiveType}</if> |
| | | <if test="followupPeriod != null and followupPeriod != ''">and followup_period = #{followupPeriod}</if> |
| | | <if test="sourceType != null and sourceType != ''">and source_type = #{sourceType}</if> |
| | | <if test="outhospno != null and outhospno != ''">and outhospno = #{outhospno}</if> |
| | | <if test="inhospno != null and inhospno != ''">and inhospno = #{inhospno}</if> |
| | |
| | | <if test="highRiskChildType != null">high_risk_child_type,</if> |
| | | <if test="highRiskChildName != null">high_risk_child_name,</if> |
| | | <if test="plannedFollowTime != null">planned_follow_time,</if> |
| | | <if test="followupPeriod != null">followup_period,</if> |
| | | <if test="hrcGrowthDevelopmentMonitoring != null">hrc_growth_development_monitoring,</if> |
| | | <if test="hrcNeurologicalEvaluation != null">hrc_neurological_evaluation,</if> |
| | | <if test="hrcInterventionRecords != null">hrc_intervention_records,</if> |
| | |
| | | <if test="highRiskChildType != null">#{highRiskChildType},</if> |
| | | <if test="highRiskChildName != null">#{highRiskChildName},</if> |
| | | <if test="plannedFollowTime != null">#{plannedFollowTime},</if> |
| | | <if test="followupPeriod != null">#{followupPeriod},</if> |
| | | <if test="hrcGrowthDevelopmentMonitoring != null">#{hrcGrowthDevelopmentMonitoring},</if> |
| | | <if test="hrcNeurologicalEvaluation != null">#{hrcNeurologicalEvaluation},</if> |
| | | <if test="hrcInterventionRecords != null">#{hrcInterventionRecords},</if> |
| | |
| | | <if test="highRiskChildType != null">high_risk_child_type = #{highRiskChildType},</if> |
| | | <if test="highRiskChildName != null">high_risk_child_name = #{highRiskChildName},</if> |
| | | <if test="plannedFollowTime != null">planned_follow_time = #{plannedFollowTime},</if> |
| | | <if test="followupPeriod != null">followup_period = #{followupPeriod},</if> |
| | | <if test="hrcGrowthDevelopmentMonitoring != null">hrc_growth_development_monitoring = #{hrcGrowthDevelopmentMonitoring},</if> |
| | | <if test="hrcNeurologicalEvaluation != null">hrc_neurological_evaluation = #{hrcNeurologicalEvaluation},</if> |
| | | <if test="hrcInterventionRecords != null">hrc_intervention_records = #{hrcInterventionRecords},</if> |
| | |
| | | <result property="deptType" column="dept_type"/> |
| | | <result property="deptCategory" column="dept_category"/> |
| | | <result property="archiveType" column="archive_type"/> |
| | | <result property="followupPeriod" column="followup_period"/> |
| | | <result property="deptCodes" column="dept_codes"/> |
| | | <result property="icd10Codes" column="icd10_codes"/> |
| | | <result property="remark" column="remark"/> |
| | |
| | | dept_type, |
| | | dept_category, |
| | | archive_type, |
| | | followup_period, |
| | | dept_codes, |
| | | icd10_codes, |
| | | remark, |
| | |
| | | <if test="deptType != null and deptType != ''">and dept_type = #{deptType}</if> |
| | | <if test="deptCategory != null and deptCategory != ''">and dept_category = #{deptCategory}</if> |
| | | <if test="archiveType != null and archiveType != ''">and archive_type = #{archiveType}</if> |
| | | <if test="followupPeriod != null and followupPeriod != ''">and followup_period = #{followupPeriod}</if> |
| | | <if test="orgid != null and orgid != ''">and orgid = #{orgid}</if> |
| | | <if test="campusid != null and campusid != ''">and campusid = #{campusid}</if> |
| | | <if test="params.beginTime != null and params.beginTime != ''"> |
| | |
| | | <if test="deptType != null">dept_type,</if> |
| | | <if test="deptCategory != null">dept_category,</if> |
| | | <if test="archiveType != null">archive_type,</if> |
| | | <if test="followupPeriod != null">followup_period,</if> |
| | | <if test="deptCodes != null">dept_codes,</if> |
| | | <if test="icd10Codes != null">icd10_codes,</if> |
| | | <if test="remark != null">remark,</if> |
| | |
| | | <if test="deptType != null">#{deptType},</if> |
| | | <if test="deptCategory != null">#{deptCategory},</if> |
| | | <if test="archiveType != null">#{archiveType},</if> |
| | | <if test="followupPeriod != null">#{followupPeriod},</if> |
| | | <if test="deptCodes != null">#{deptCodes},</if> |
| | | <if test="icd10Codes != null">#{icd10Codes},</if> |
| | | <if test="remark != null">#{remark},</if> |
| | |
| | | <if test="deptType != null">dept_type = #{deptType},</if> |
| | | <if test="deptCategory != null">dept_category = #{deptCategory},</if> |
| | | <if test="archiveType != null">archive_type = #{archiveType},</if> |
| | | <if test="followupPeriod != null">followup_period = #{followupPeriod},</if> |
| | | <if test="deptCodes != null">dept_codes = #{deptCodes},</if> |
| | | <if test="icd10Codes != null">icd10_codes = #{icd10Codes},</if> |
| | | <if test="remark != null">remark = #{remark},</if> |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | -- ============================================================================= |
| | | -- éè®¿å¨æç»ä¸å段 followup_period |
| | | -- æ¶åï¼ |
| | | -- 1. pat_child_archive_detailï¼å¿ä¿æ¡£æ¡è¯¦æ
ï¼ |
| | | -- 2. pat_specific_archive_generate_configï¼ä¸ç§æ¡£æ¡çæé
ç½®ï¼ |
| | | -- 说æï¼å¦ä¿æ¡£æ¡è¯¦æ
pat_maternity_archive_detail å·²æ followup_periodï¼æ éé夿·»å ã |
| | | -- dateï¼2026-11-09 |
| | | -- ============================================================================= |
| | | |
| | | ALTER TABLE pat_child_archive_detail |
| | | ADD COLUMN followup_period varchar(100) NULL COMMENT 'éè®¿å¨æ' AFTER planned_follow_time; |
| | | |
| | | ALTER TABLE pat_specific_archive_generate_config |
| | | ADD COLUMN followup_period varchar(100) NULL COMMENT 'éè®¿å¨æ' AFTER archive_type; |