package com.ruoyi.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
|
import com.ruoyi.common.core.domain.AjaxResult;
|
import com.ruoyi.common.utils.MapUtils;
|
import com.ruoyi.common.utils.StringUtils;
|
import com.ruoyi.common.utils.poi.ExcelUtil;
|
import com.ruoyi.domain.ArchiveCategory;
|
import com.ruoyi.domain.ArchivePlaceName;
|
import com.ruoyi.domain.ArchiveProjectName;
|
|
import com.ruoyi.mapper.ArchiveProjectNameMapper;
|
import com.ruoyi.service.IArchiveProjectNameService;
|
import org.springframework.stereotype.Service;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.time.LocalDateTime;
|
import java.time.ZoneId;
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
|
@Service
|
public class ArchiveProjectNameServiceImpl extends ServiceImpl<ArchiveProjectNameMapper, ArchiveProjectName> implements IArchiveProjectNameService {
|
|
private LambdaQueryWrapper<ArchiveProjectName> buildCondition(ArchiveProjectName archiveProjectName){
|
LambdaQueryWrapper<ArchiveProjectName> lqw = new LambdaQueryWrapper<>();
|
lqw.like(!StringUtils.isEmpty(archiveProjectName.getName()), ArchiveProjectName::getName, archiveProjectName.getName());
|
lqw.orderByDesc(ArchiveProjectName::getCreateTime);
|
System.out.println("ssssssssssssddd0000000000000000");
|
return lqw;
|
|
}
|
|
|
@Override
|
public AjaxResult selectDataList(ArchiveProjectName archiveProjectName, Integer pageNum, Integer pageSize) {
|
LambdaQueryWrapper<ArchiveProjectName> lqw = buildCondition(archiveProjectName);
|
|
|
Page<ArchiveProjectName> zfClanPage = new Page<>(pageNum, pageSize);
|
Page<ArchiveProjectName> pageResult = page(zfClanPage, lqw);
|
|
List<ArchiveProjectName> beanRecords = pageResult.getRecords();//得到查询出来的数据
|
|
|
|
// List<ArchiveRecords> beanRecords = list(lqw);
|
// log.info("从数据库中查到的为:{}", beanRecords);
|
// return markOwnData(familyId, fatherFaId, motherFaId, beanRecords);
|
HashMap<String, Object> data = MapUtils.getResult(pageResult, beanRecords);
|
|
System.out.println(data);
|
return AjaxResult.success(data);
|
}
|
|
|
@Override
|
public ArchiveProjectName selectArchiveProjectNameById(Long id) {
|
LambdaQueryWrapper<ArchiveProjectName> lqw = new LambdaQueryWrapper<>();
|
System.out.println(id);
|
lqw.eq(id!=null, ArchiveProjectName::getId, id);
|
List<ArchiveProjectName> records = list(lqw);
|
if(!records.isEmpty())
|
return records.get(0);
|
else
|
return null;
|
}
|
|
@Override
|
public List<ArchiveProjectName> selectArchiveProjectNameList(ArchiveProjectName archiveProjectName) {
|
LambdaQueryWrapper<ArchiveProjectName> lambdaQueryWrapper = buildCondition(archiveProjectName);
|
List<ArchiveProjectName> beanRecords = list(lambdaQueryWrapper);
|
System.out.println(beanRecords.size());
|
return beanRecords;
|
}
|
|
@Override
|
public int insertArchiveProjectName(ArchiveProjectName archiveProjectName) {
|
LocalDateTime time = LocalDateTime.now();
|
|
Date date = Date.from(time.atZone(ZoneId.systemDefault()).toInstant());
|
archiveProjectName.setCreateTime(date);
|
boolean res = this.save(archiveProjectName);
|
if(res)
|
return 1;
|
else
|
return 0;
|
}
|
|
@Override
|
public int updateArchiveProjectName(ArchiveProjectName archiveProjectName) {
|
boolean result = updateById(archiveProjectName);
|
if(result)
|
return 1;
|
else
|
return 0;
|
}
|
|
@Override
|
public int deleteArchiveProjectNameByIds(Long[] ids) {
|
if (this.removeByIds(Arrays.asList(ids))) {
|
return 1;
|
}
|
else
|
return 0;
|
|
}
|
|
@Override
|
public int deleteArchiveProjectNameById(Long id) {
|
return 0;
|
}
|
|
@Override
|
public AjaxResult importExcel(MultipartFile file) {
|
ExcelUtil<ArchiveProjectName> util = new ExcelUtil<>(ArchiveProjectName.class);
|
List<ArchiveProjectName> dataList = null;
|
try {
|
dataList = util.importExcel(file.getInputStream());
|
} catch (Exception e) {
|
throw new RuntimeException("没有按照规则导入数据");
|
}
|
|
assert dataList != null;
|
|
for (ArchiveProjectName archiveCategory : dataList) {
|
// physcialService.mySave(physcial);
|
this.insertArchiveProjectName(archiveCategory);
|
}
|
|
return AjaxResult.success(); }
|
}
|
