| 提交 | 用户 | 时间 | ||
| 2a6f08 | 1 | package com.iailab.module.data.ind.value.service.impl; |
| 潘 | 2 | |
| 3 | import com.iailab.framework.common.pojo.PageResult; | |
| 4 | import com.iailab.framework.common.service.impl.BaseServiceImpl; | |
| 5 | import com.iailab.framework.common.util.object.BeanUtils; | |
| 441d30 | 6 | import com.iailab.framework.tenant.core.context.DataContextHolder; |
| 976e14 | 7 | import com.iailab.module.data.common.xss.SQLFilter; |
| cf757d | 8 | import com.iailab.module.data.ind.item.vo.IndItemValueVO; |
| 2a6f08 | 9 | import com.iailab.module.data.ind.value.dao.IndItemValueDao; |
| cf757d | 10 | import com.iailab.module.data.ind.value.dto.QuerySourceValueDTO; |
| 2a6f08 | 11 | import com.iailab.module.data.ind.value.entity.IndItemValueEntity; |
| 潘 | 12 | import com.iailab.module.data.ind.value.service.IndItemValueService; |
| 13 | import com.iailab.module.data.ind.value.vo.IndItemValuePageReqVO; | |
| 14 | import com.iailab.module.data.ind.value.vo.IndItemValueSaveReqVO; | |
| cf757d | 15 | import org.apache.commons.lang3.StringUtils; |
| 2a6f08 | 16 | import org.springframework.stereotype.Service; |
| 潘 | 17 | |
| cf757d | 18 | import java.util.List; |
| 2a6f08 | 19 | import java.util.UUID; |
| 潘 | 20 | |
| 21 | /** | |
| 22 | * @author PanZhibao | |
| 23 | * @Description | |
| 24 | * @createTime 2024年09月11日 | |
| 25 | */ | |
| 26 | @Service | |
| 27 | public class IndItemValueServiceImpl extends BaseServiceImpl<IndItemValueDao, IndItemValueEntity> implements IndItemValueService { | |
| 28 | ||
| 29 | @Override | |
| 30 | public PageResult<IndItemValueEntity> page(IndItemValuePageReqVO reqVO) { | |
| 31 | return baseDao.selectPage(reqVO); | |
| 32 | } | |
| 33 | ||
| 34 | @Override | |
| 35 | public void create(IndItemValueSaveReqVO createReqVO) { | |
| 36 | IndItemValueEntity entity = BeanUtils.toBean(createReqVO, IndItemValueEntity.class); | |
| 37 | entity.setId(UUID.randomUUID().toString()); | |
| 38 | baseDao.insert(entity); | |
| 39 | } | |
| 40 | ||
| 41 | @Override | |
| 42 | public void update(IndItemValueSaveReqVO updateReqVO) { | |
| 43 | IndItemValueEntity entity = BeanUtils.toBean(updateReqVO, IndItemValueEntity.class); | |
| 44 | baseDao.updateById(entity); | |
| 45 | } | |
| 46 | ||
| 47 | @Override | |
| 48 | public IndItemValueEntity get(String id) { | |
| 49 | return baseDao.selectById(id); | |
| 50 | } | |
| 51 | ||
| 52 | @Override | |
| 53 | public void delete(String id) { | |
| 54 | baseDao.deleteById(id); | |
| 55 | } | |
| cf757d | 56 | |
| 潘 | 57 | /** |
| 58 | * 根据配置的数据源动态查询 | |
| 59 | * @param dto | |
| 60 | * @return | |
| 61 | */ | |
| 62 | @Override | |
| 63 | public List<IndItemValueVO> getSourceValue(QuerySourceValueDTO dto) { | |
| 64 | if (StringUtils.isEmpty(dto.getDataSource())) { | |
| 65 | log.warn("数据源不能为空"); | |
| 66 | return null; | |
| 67 | } | |
| 619626 | 68 | SQLFilter.sqlInject2(dto.getSelectSql()); |
| 潘 | 69 | SQLFilter.sqlInject2(dto.getViewSql()); |
| 70 | SQLFilter.sqlInject2(dto.getWhereSql()); | |
| 71 | SQLFilter.sqlInject2(dto.getGroupSql()); | |
| 72 | SQLFilter.sqlInject2(dto.getGroupSql()); | |
| 441d30 | 73 | DataContextHolder.setDataSourceId(Long.valueOf(dto.getDataSource())); |
| cf757d | 74 | return baseDao.getSourceValue(dto); |
| 潘 | 75 | } |
| 2a6f08 | 76 | } |
