package cn.shlanbao.qms.service.impl;
|
|
import org.dromara.common.core.utils.MapstructUtils;
|
import org.dromara.common.core.utils.StringUtils;
|
import org.dromara.common.mybatis.core.page.TableDataInfo;
|
import org.dromara.common.mybatis.core.page.PageQuery;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import lombok.RequiredArgsConstructor;
|
import org.springframework.stereotype.Service;
|
import cn.shlanbao.qms.domain.bo.LbTestResultBo;
|
import cn.shlanbao.qms.domain.vo.LbTestResultVo;
|
import cn.shlanbao.qms.domain.LbTestResult;
|
import cn.shlanbao.qms.mapper.LbTestResultMapper;
|
import cn.shlanbao.qms.service.ILbTestResultService;
|
|
import java.time.LocalDateTime;
|
import java.time.LocalTime;
|
import java.util.*;
|
|
/**
|
* 测试结果Service业务层处理
|
*
|
* @author bsw
|
* @date 2024-12-12
|
*/
|
@RequiredArgsConstructor
|
@Service
|
public class LbTestResultServiceImpl implements ILbTestResultService {
|
|
private final LbTestResultMapper baseMapper;
|
|
/**
|
* 查询测试结果
|
*
|
* @param id 主键
|
* @return 测试结果
|
*/
|
@Override
|
public LbTestResultVo queryById(Long id){
|
return baseMapper.selectVoById(id);
|
}
|
|
/**
|
* 分页查询测试结果列表
|
*
|
* @param bo 查询条件
|
* @param pageQuery 分页参数
|
* @return 测试结果分页列表
|
*/
|
@Override
|
public TableDataInfo<LbTestResultVo> queryPageList(LbTestResultBo bo, PageQuery pageQuery) {
|
LambdaQueryWrapper<LbTestResult> lqw = buildQueryWrapper(bo);
|
Page<LbTestResultVo> result = baseMapper.selectVoPage(pageQuery.build(), lqw);
|
result.getRecords().forEach(row -> {
|
// 将 GB2312 编码转换成UTF-8
|
|
// try {
|
// // String utf8 = new String(row.getJudgeDetail().getBytes(), "UTF-8");
|
// byte[] gb2312s = row.getTestItem().getBytes("ISO-8859-1");
|
// String gb2312 = new String(gb2312s, "gb2312");
|
// row.setTestItem(gb2312);
|
// row.setJudgeDetail(new String(row.getJudgeDetail().getBytes("ISO-8859-1"),"GB2312"));
|
// } catch (UnsupportedEncodingException e) {
|
// throw new RuntimeException(e);
|
// }
|
});
|
return TableDataInfo.build(result);
|
}
|
|
/**
|
* 查询符合条件的测试结果列表
|
*
|
* @param bo 查询条件
|
* @return 测试结果列表
|
*/
|
@Override
|
public List<LbTestResultVo> queryList(LbTestResultBo bo) {
|
if (StringUtils.isNotBlank(bo.getProdModel())) {
|
|
return baseMapper.selectByProdModelAndConditions(bo);
|
} else {
|
LambdaQueryWrapper<LbTestResult> lqw = buildQueryWrapper(bo);
|
return baseMapper.selectVoList(lqw);
|
}
|
}
|
|
/**
|
* 查询分组去重后的所有测试项目
|
*
|
* @return 测试项目列表
|
*/
|
@Override
|
public List<String> queryDistinctTestItems() {
|
return baseMapper.selectDistinctTestItems();
|
}
|
|
private LambdaQueryWrapper<LbTestResult> buildQueryWrapper(LbTestResultBo bo) {
|
Map<String, Object> params = bo.getParams();
|
LambdaQueryWrapper<LbTestResult> lqw = Wrappers.lambdaQuery();
|
lqw.eq(StringUtils.isNotBlank(bo.getBatchCode()), LbTestResult::getBatchCode, bo.getBatchCode());
|
lqw.eq(StringUtils.isNotBlank(bo.getTestNum()), LbTestResult::getTestNum, bo.getTestNum());
|
|
// 修改：处理 testItem 可能是逗号分隔的字符串
|
if (StringUtils.isNotBlank(bo.getTestItem())) {
|
if (bo.getTestItem().contains(",")) {
|
lqw.in(LbTestResult::getTestItem, Arrays.asList(bo.getTestItem().split(",")));
|
} else {
|
lqw.eq(LbTestResult::getTestItem, bo.getTestItem());
|
}
|
}
|
|
lqw.eq(bo.getVoltage() != null, LbTestResult::getVoltage, bo.getVoltage());
|
lqw.eq(bo.getLoadCurrent() != null, LbTestResult::getLoadCurrent, bo.getLoadCurrent());
|
lqw.eq(bo.getStdDistance() != null, LbTestResult::getStdDistance, bo.getStdDistance());
|
lqw.eq(StringUtils.isNotBlank(bo.getInductor()), LbTestResult::getInductor, bo.getInductor());
|
lqw.eq(StringUtils.isNotBlank(bo.getOutput()), LbTestResult::getOutput, bo.getOutput());
|
lqw.eq(bo.getTestValue() != null, LbTestResult::getTestValue, bo.getTestValue());
|
lqw.eq(StringUtils.isNotBlank(bo.getJudgeDetail()), LbTestResult::getJudgeDetail, bo.getJudgeDetail());
|
lqw.eq(StringUtils.isNotBlank(bo.getTestResult()), LbTestResult::getTestResult, bo.getTestResult());
|
// 设置开始时间和结束时间的时分秒
|
if (params.get("beginCreateTime") != null && params.get("endCreateTime") != null) {
|
LocalDateTime beginTime = ((LocalDateTime) params.get("beginCreateTime")).with(LocalTime.MIN);
|
LocalDateTime endTime = ((LocalDateTime) params.get("endCreateTime")).with(LocalTime.MAX);
|
lqw.between(LbTestResult::getCreateTime, beginTime, endTime);
|
}
|
|
lqw.orderByAsc(LbTestResult::getCreateTime);
|
return lqw;
|
}
|
|
/**
|
* 新增测试结果
|
*
|
* @param bo 测试结果
|
* @return 是否新增成功
|
*/
|
@Override
|
public Boolean insertByBo(LbTestResultBo bo) {
|
LbTestResult add = MapstructUtils.convert(bo, LbTestResult.class);
|
validEntityBeforeSave(add);
|
boolean flag = baseMapper.insert(add) > 0;
|
if (flag) {
|
bo.setId(add.getId());
|
}
|
return flag;
|
}
|
|
/**
|
* 修改测试结果
|
*
|
* @param bo 测试结果
|
* @return 是否修改成功
|
*/
|
@Override
|
public Boolean updateByBo(LbTestResultBo bo) {
|
LbTestResult update = MapstructUtils.convert(bo, LbTestResult.class);
|
validEntityBeforeSave(update);
|
return baseMapper.updateById(update) > 0;
|
}
|
|
/**
|
* 保存前的数据校验
|
*/
|
private void validEntityBeforeSave(LbTestResult entity){
|
//TODO 做一些数据校验,如唯一约束
|
}
|
|
/**
|
* 校验并批量删除测试结果信息
|
*
|
* @param ids 待删除的主键集合
|
* @param isValid 是否进行有效性校验
|
* @return 是否删除成功
|
*/
|
@Override
|
public Boolean deleteWithValidByIds(Collection<Long> ids, Boolean isValid) {
|
if(isValid){
|
//TODO 做一些业务上的校验,判断是否需要校验
|
}
|
return baseMapper.deleteByIds(ids) > 0;
|
}
|
|
}
|
