package com.ruoyi.basic.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; 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 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 implements ISupplierService { @Autowired private SupplierManageMapper supplierMapper; /** * 供应商新增 * @param supplierManage * @return */ @Override public void saveSupplier(SupplierManage supplierManage) { supplierMapper.insert(supplierManage); } /** * 供应商删除 * @param ids * @return */ @Override public int delSupplier(List ids) { LambdaQueryWrapper 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 supplierListPage(Page page, SupplierManageDto supplierManageDto) { return supplierMapper.supplierListPage(page,supplierManageDto); } /** * 供应商导出 * @param response * @param supplierManageDto */ @Override public void supplierExport(HttpServletResponse response, SupplierManageDto supplierManageDto) { List supplierManageList = supplierMapper.supplierExportList(supplierManageDto); ExcelUtil util = new ExcelUtil(SupplierManageExcelDto.class); util.exportExcel(response, supplierManageList, "供应商导出"); } @Override public Boolean importData(MultipartFile file) { try { ExcelUtil util = new ExcelUtil(SupplierManageExcelDto.class); List list = util.importExcel(file.getInputStream()); ArrayList 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; } }