Skip to content

A
amos-boot-biz
Switch branch/tag
History Find file
  • tianbo's avatar
    refactor(amos-boot-module-jg): 优化使用登记列表查询 SQL · 41f3ac0e
    tianbo authored 
    - 重构了 getListPage1 查询，使用 WITH 子句优化复杂查询结构
- 将设备过滤条件和公共主表过滤条件分离，提高可读性
- 使用 EXISTS 子查询替代左连接，提升查询性能
- 优化了字符串聚合和类别映射的处理方式
- 调整了排序和分页逻辑，提高查询效率
    41f3ac0e
Name
Last commit
 Last update
..
CommonMapper.xml Loading commit data...
IdxBizJgPipelineDeleteHistoryMapper.xml Loading commit data...
JgBizChangeLogMapper.xml Loading commit data...
JgCertificateChangeRecordEqMapper.xml Loading commit data...
JgCertificateChangeRecordMapper.xml Loading commit data...
JgCertificateReplenishEqMapper.xml Loading commit data...
JgCertificateReplenishMapper.xml Loading commit data...
JgChangeRegistrationNameEqMapper.xml Loading commit data...
JgChangeRegistrationNameMapper.xml Loading commit data...
JgChangeRegistrationReformEqMapper.xml Loading commit data...
JgChangeRegistrationReformMapper.xml Loading commit data...
JgChangeRegistrationTransferEqMapper.xml Loading commit data...
JgChangeRegistrationTransferMapper.xml Loading commit data...
JgChangeRegistrationUnitEqMapper.xml Loading commit data...
JgChangeRegistrationUnitMapper.xml Loading commit data...
JgChangeVehicleRegistrationUnitEqMapper.xml Loading commit data...
JgChangeVehicleRegistrationUnitMapper.xml Loading commit data...
JgEnableDisableEqMapper.xml Loading commit data...
JgEnableDisableMapper.xml Loading commit data...
JgEquipInsuranceMapper.xml Loading commit data...
JgEquipTransferEqMapper.xml Loading commit data...
JgEquipTransferMapper.xml Loading commit data...
JgInstallationNoticeEqMapper.xml Loading commit data...
JgInstallationNoticeMapper.xml Loading commit data...
JgMaintainNoticeEqMapper.xml Loading commit data...
JgMaintainNoticeMapper.xml Loading commit data...
JgMaintenanceContractEqMapper.xml Loading commit data...
JgMaintenanceContractMapper.xml Loading commit data...
JgOperateLogMapper.xml Loading commit data...
JgOverDesignServiceLifeEqMapper.xml Loading commit data...
JgOverDesignServiceLifeMapper.xml Loading commit data...
JgReformNoticeEqMapper.xml Loading commit data...
JgReformNoticeMapper.xml Loading commit data...
JgRegistrationHistoryMapper.xml Loading commit data...
JgRelationEquipMapper.xml Loading commit data...
JgResumeInfoMapper.xml Loading commit data...
JgScrapCancelEqMapper.xml Loading commit data...
JgScrapCancelMapper.xml Loading commit data...
JgTransferNoticeEqMapper.xml Loading commit data...
JgTransferNoticeMapper.xml Loading commit data...
JgUseRegistrationEqMapper.xml Loading commit data...
JgUseRegistrationManageMapper.xml Loading commit data...
JgUseRegistrationMapper.xml Loading commit data...
JgVehicleInformationEqMapper.xml Loading commit data...
JgVehicleInformationMapper.xml Loading commit data...
SafetyProblemTracingMapper.xml Loading commit data...
ShCarEquMapper.xml Loading commit data...
ShCarMapper.xml Loading commit data...
TzsJgColumnReminderRuleMapper.xml Loading commit data...