| | |
| | | |
| | | import com.baomidou.mybatisplus.core.toolkit.StringUtils; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.common.util.StrUtils; |
| | | import org.jeecg.modules.mdc.entity.Equipment; |
| | | import org.jeecg.modules.mdc.service.IEquipmentService; |
| | | import org.jeecg.modules.mdc.util.DateUtils; |
| | |
| | | } |
| | | String day = DateUtils.format(DateUtils.plusTime(DateUtils.getNow(), -dayNum), DateUtils.STR_DATE_TIME_SMALL); |
| | | for (Equipment equipment : list) { |
| | | if (StrUtils.isNotBlankOrNull(equipment.getEquipmentid()) && equipment.getEquipmentid().contains("-")) { |
| | | continue; |
| | | } |
| | | if (StringUtils.isNotBlank(equipment.getSavetablename())) { |
| | | String tableName = equipmentService.checkTableExists(equipment.getSavetablename()); |
| | | if (StringUtils.isNotBlank(tableName)) { |
| | | String backupTableName = equipmentService.checkTableExists(equipment.getSavetablename() + "_backup"); |
| | | if (StringUtils.isNotBlank(backupTableName)) { |
| | | Integer num = equipmentService.checkTableDataNum(equipment.getSavetablename(), day); |
| | | if (num > 0) { |
| | | equipmentService.insertTableData(backupTableName, tableName, day); |
| | | equipmentService.deleteTableData(tableName, day); |
| | | } |
| | | equipmentService.insertTableData(backupTableName, tableName, day); |
| | | equipmentService.deleteTableData(tableName, day); |
| | | } else { |
| | | //备份表不存在创建备份表并迁移数据 |
| | | equipmentService.insertNoTableData(tableName + "_backup", tableName, day); |