Skip to content

A
amos-boot-biz
Switch branch/tag
History Find file
  • tianbo's avatar
    fix(tzs): 优化单位层级调整时的数据更新逻辑 · 910769cb
    tianbo authored 
    -针对 tz_base_enterprise_info、tzs_three_systems 和 tzs_two_staffing 表的更新
- 特别处理 tzs_three_systems 表，避免因生成统计数据导致的更新冲突
- 使用 CTE (Common Table Expressions) 实现冲突检测和条件更新
- 删除旧的统计数据，确保数据一致性
    910769cb
Name
Last commit
 Last update
..
AlertCalledMapper.xml Loading commit data...
AlertFormMapper.xml Loading commit data...
AlertFormTypeMapper.xml Loading commit data...
AlertFormValueMapper.xml Loading commit data...
BaseEquipParamDefineMapper.xml Loading commit data...
BaseUnitLicenceMapper.xml Loading commit data...
CategoryOtherInfoMapper.xml Loading commit data...
CylinderAreaDataMapper.xml Loading commit data...
CylinderDateInfoMapper.xml Loading commit data...
CylinderFillingCheckDataUnitMapper.xml Loading commit data...
CylinderFillingCheckMapper.xml Loading commit data...
CylinderFillingDataUnitMapper.xml Loading commit data...
CylinderFillingExamineMapper.xml Loading commit data...
CylinderFillingMapper.xml Loading commit data...
CylinderFillingRecordMapper.xml Loading commit data...
CylinderFillingUnloadDataMapper.xml Loading commit data...
CylinderFillingUnloadDataUnitMapper.xml Loading commit data...
CylinderInfoDataMapper.xml Loading commit data...
CylinderInfoDataUnitMapper.xml Loading commit data...
CylinderInfoMapper.xml Loading commit data...
CylinderInspectionMapper.xml Loading commit data...
CylinderIntegrityDataMapper.xml Loading commit data...
CylinderIntegrityDataUnitMapper.xml Loading commit data...
CylinderTagsDataUnitMapper.xml Loading commit data...
CylinderTagsMapper.xml Loading commit data...
CylinderUnitDataMapper.xml Loading commit data...
CylinderUnitMapper.xml Loading commit data...
CylinderUnloadFakeMapper.xml Loading commit data...
DispatchPaperMapper.xml Loading commit data...
DispatchTaskMapper.xml Loading commit data...
ElevatorAlarmMapper.xml Loading commit data...
ElevatorInsureMapper.xml Loading commit data...
ElevatorInsureRelationMapper.xml Loading commit data...
ElevatorMapper.xml Loading commit data...
ElevatorRelationMapper.xml Loading commit data...
ElevatorStatusMapper.xml Loading commit data...
EndUserMapper.xml Loading commit data...
EquipmentAssociatedMapper.xml Loading commit data...
EquipmentCategoryMapper.xml Loading commit data...
EquipmentIndexInformMapper.xml Loading commit data...
EquipmentIndexMapper.xml Loading commit data...
EquipmentInformMapper.xml Loading commit data...
EquipmentMapper.xml Loading commit data...
EquipmentRegionNumMapper.xml Loading commit data...
EquipmentUseInfoMapper.xml Loading commit data...
IdxUjerMaper.xml Loading commit data...
InformEquipmentMapper.xml Loading commit data...
InformProcessInfoMapper.xml Loading commit data...
InspectionDetectionInfoMapper.xml Loading commit data...
MaintainInfoMapper.xml Loading commit data...
MaintenanceUnitMapper.xml Loading commit data...
MsgLogMapper.xml Loading commit data...
PersonEducationMapper.xml Loading commit data...
PersonQualityMapper.xml Loading commit data...
RegUnitIcMapper.xml Loading commit data...
RegUnitInfoMapper.xml Loading commit data...
RepairConsultMapper.xml Loading commit data...
RescueProcessMapper.xml Loading commit data...
RescueStationMapper.xml Loading commit data...
RiskProcessesMapper.xml Loading commit data...
RiskReportMapper.xml Loading commit data...
ScheduleMapper.xml Loading commit data...
SupervisionInfoMapper.xml Loading commit data...
SupervisoryCodeInfoMapper.xml Loading commit data...
TaskMapper.xml Loading commit data...
TemplateExportMapper.xml Loading commit data...
TemplateMapper.xml Loading commit data...
TestInfoMapper.xml Loading commit data...
ThreeSystemsMapper.xml Loading commit data...
TzBaseEnterpriseInfoMapper.xml Loading commit data...
TzCarcylMapper.xml Loading commit data...
TzCylinderMapper.xml Loading commit data...
TzsBaseIndividualityMapper.xml Loading commit data...
TzsBaseInstitutionMapper.xml Loading commit data...
TzsJgConstructionInfoMapper.xml Loading commit data...
TzsJgDesignInfoMapper.xml Loading commit data...
TzsJgElevatorTechInfoMapper.xml Loading commit data...
TzsJgEnclosureInfoMapper.xml Loading commit data...
TzsJgFileMapper.xml Loading commit data...
TzsJgInspectionInfoMapper.xml Loading commit data...
TzsJgMaintenanceInfoMapper.xml Loading commit data...
TzsJgMapper.xml Loading commit data...
TzsJgOtherInfoMapper.xml Loading commit data...
TzsJgOutterMapper.xml Loading commit data...
TzsJgProduceInfoMapper.xml Loading commit data...
TzsJgRegistrationInfoMapper.xml Loading commit data...
TzsJgStaffBaseInfoMapper.xml Loading commit data...
TzsJgStaffQualifInfoMapper.xml Loading commit data...
TzsJgSuperviseInfoMapper.xml Loading commit data...
TzsJgUseInfoMapper.xml Loading commit data...
TzsTwoStaffingMapper.xml Loading commit data...
TzsUserInfoMapper.xml Loading commit data...
TzsUserPermissionMapper.xml Loading commit data...
UnitInfoApproveMapper.xml Loading commit data...
UnitInfoChangeMapper.xml Loading commit data...
UnitInfoMapper.xml Loading commit data...
UnitPersonMapper.xml Loading commit data...
UseUnitMapper.xml Loading commit data...
ViewJgClaimMapper.xml Loading commit data...
VoiceRecordFileMapper.xml Loading commit data...
VoiceRecordLogMapper.xml Loading commit data...
WechatRelationMapper.xml Loading commit data...