package com.ruoyi.basic.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.basic.dto.SupplierManageDto;
|
import com.ruoyi.basic.excel.SupplierManageExcelDto;
|
import com.ruoyi.basic.mapper.SupplierManageMapper;
|
import com.ruoyi.basic.pojo.Customer;
|
import com.ruoyi.basic.pojo.SupplierManage;
|
import com.ruoyi.basic.service.ISupplierService;
|
import com.ruoyi.common.utils.SecurityUtils;
|
import com.ruoyi.common.utils.poi.ExcelUtil;
|
import com.ruoyi.framework.web.domain.AjaxResult;
|
import com.ruoyi.purchase.mapper.PurchaseLedgerMapper;
|
import com.ruoyi.purchase.pojo.PurchaseLedger;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.time.LocalDate;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
@Service
|
public class SupplierServiceImpl extends ServiceImpl<SupplierManageMapper,SupplierManage> implements ISupplierService {
|
|
@Autowired
|
private SupplierManageMapper supplierMapper;
|
@Autowired
|
private PurchaseLedgerMapper purchaseLedgerMapper;
|
|
/**
|
* 供应商新增
|
* @param supplierManage
|
* @return
|
*/
|
@Override
|
public void saveSupplier(SupplierManage supplierManage) {
|
LambdaQueryWrapper<SupplierManage> supplierManageLambdaQueryWrapper = new LambdaQueryWrapper<>();
|
supplierManageLambdaQueryWrapper.eq(SupplierManage::getSupplierName,supplierManage.getSupplierName());
|
if (supplierMapper.selectCount(supplierManageLambdaQueryWrapper) > 0) {
|
throw new RuntimeException("供应商已存在");
|
}
|
supplierMapper.insert(supplierManage);
|
}
|
|
/**
|
* 供应商删除
|
* @param ids
|
* @return
|
*/
|
@Override
|
public int delSupplier(List<Integer> ids) {
|
List<PurchaseLedger> purchaseLedgers = purchaseLedgerMapper.selectList(new QueryWrapper<PurchaseLedger>().lambda().in(PurchaseLedger::getSupplierId, ids));
|
if (purchaseLedgers.size() > 0) {
|
throw new RuntimeException("供应商已存在采购合同");
|
}
|
LambdaQueryWrapper<SupplierManage> delWrapper = new LambdaQueryWrapper<>();
|
delWrapper.in(SupplierManage::getId, ids);
|
|
return supplierMapper.delete(delWrapper);
|
}
|
|
/**
|
* 供应商详情
|
* @param id
|
* @return
|
*/
|
@Override
|
public SupplierManage supplierDetail(Integer id) {
|
return supplierMapper.selectById(id);
|
}
|
|
/**
|
* 供应商修改
|
* @param supplierManage
|
* @return
|
*/
|
@Override
|
public int supplierUpdate(SupplierManage supplierManage) {
|
return supplierMapper.updateById(supplierManage);
|
}
|
|
/**
|
* 供应商分页查询
|
* @param page
|
* @param supplierManageDto
|
* @return
|
*/
|
@Override
|
public IPage<SupplierManage> supplierListPage(Page page, SupplierManageDto supplierManageDto) {
|
return supplierMapper.supplierListPage(page,supplierManageDto);
|
}
|
|
/**
|
* 供应商导出
|
* @param response
|
* @param supplierManageDto
|
*/
|
@Override
|
public void supplierExport(HttpServletResponse response, SupplierManageDto supplierManageDto) {
|
List<SupplierManageExcelDto> supplierManageList = supplierMapper.supplierExportList(supplierManageDto);
|
ExcelUtil<SupplierManageExcelDto> util = new ExcelUtil<SupplierManageExcelDto>(SupplierManageExcelDto.class);
|
util.exportExcel(response, supplierManageList, "供应商导出");
|
}
|
|
@Override
|
public Boolean importData(MultipartFile file) {
|
|
try {
|
ExcelUtil<SupplierManageExcelDto> util = new ExcelUtil<SupplierManageExcelDto>(SupplierManageExcelDto.class);
|
List<SupplierManageExcelDto> list = util.importExcel(file.getInputStream());
|
ArrayList<SupplierManage> supplierManages = new ArrayList<>();
|
list.stream().forEach(dto -> {
|
SupplierManage supplierManage = new SupplierManage();
|
BeanUtils.copyProperties(dto,supplierManage);
|
supplierManage.setMaintainTime(LocalDate.now());
|
Long userId = SecurityUtils.getLoginUser().getUser().getUserId();
|
|
supplierManage.setMaintainUserId(Integer.parseInt(userId+""));
|
supplierManages.add(supplierManage);
|
});
|
|
this.saveOrUpdateBatch(supplierManages);
|
return true;
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
return false;
|
}
|
}
|
