package com.ruoyi.purchase.controller;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ruoyi.common.utils.poi.ExcelUtil;
|
import com.ruoyi.framework.aspectj.lang.annotation.Log;
|
import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
|
import com.ruoyi.framework.web.controller.BaseController;
|
import com.ruoyi.framework.web.domain.AjaxResult;
|
import com.ruoyi.framework.web.page.TableDataInfo;
|
import com.ruoyi.purchase.dto.PurchaseLedgerDto;
|
import com.ruoyi.purchase.mapper.PurchaseLedgerTemplateMapper;
|
import com.ruoyi.purchase.mapper.SalesLedgerProductTemplateMapper;
|
import com.ruoyi.purchase.pojo.PurchaseLedger;
|
import com.ruoyi.purchase.pojo.PurchaseLedgerTemplate;
|
import com.ruoyi.purchase.pojo.SalesLedgerProductTemplate;
|
import com.ruoyi.purchase.service.IPurchaseLedgerService;
|
import com.ruoyi.sales.pojo.SalesLedgerProduct;
|
import com.ruoyi.sales.service.ISalesLedgerProductService;
|
import com.ruoyi.sales.service.ISalesLedgerService;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import io.swagger.annotations.ApiParam;
|
import lombok.AllArgsConstructor;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.FileNotFoundException;
|
import java.io.IOException;
|
import java.io.InputStream;
|
import java.io.OutputStream;
|
import java.math.BigDecimal;
|
import java.net.URLEncoder;
|
import java.util.List;
|
import java.util.Optional;
|
import java.util.stream.Collectors;
|
|
/**
|
* 采购台账Controller
|
*
|
* @author ruoyi
|
* @date 2025-05-09
|
*/
|
@RestController
|
@RequestMapping("/purchase/ledger")
|
@AllArgsConstructor
|
@Api(tags = "采购台账")
|
@Slf4j
|
public class PurchaseLedgerController extends BaseController {
|
private IPurchaseLedgerService purchaseLedgerService;
|
|
private ISalesLedgerService salesLedgerService;
|
private ISalesLedgerProductService salesLedgerProductService;
|
|
private PurchaseLedgerTemplateMapper purchaseLedgerTemplateMapper;
|
|
private SalesLedgerProductTemplateMapper salesLedgerProductTemplateMapper;
|
|
|
/**
|
* 导入采购台账
|
*/
|
@Log(title = "导入采购台账", businessType = BusinessType.INSERT)
|
@PostMapping("/import")
|
@ApiOperation("导入采购台账")
|
public AjaxResult importData(@RequestParam("file")
|
@ApiParam(value = "Excel文件", required = true)
|
MultipartFile file) {
|
return purchaseLedgerService.importData(file);
|
}
|
|
@ApiOperation("导出采购台账模板")
|
@PostMapping("/exportTemplate")
|
public void exportTemplate(HttpServletResponse response) {
|
// 1. 模板文件在resources/static下的路径
|
String templatePath = "static/采购台账导入模板.xlsx";
|
|
// 2. 获取模板文件的输入流
|
try (InputStream inputStream = this.getClass().getClassLoader().getResourceAsStream(templatePath)) {
|
if (inputStream == null) {
|
throw new FileNotFoundException("模板文件不存在：" + templatePath);
|
}
|
|
// 3. 设置响应头，触发浏览器下载
|
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
|
response.setCharacterEncoding("utf-8");
|
String fileName = URLEncoder.encode("采购台账导入模板.xlsx", "utf-8").replaceAll("\\+", "%20");
|
response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName);
|
|
// 4. 将模板文件写入响应输出流
|
try (OutputStream outputStream = response.getOutputStream()) {
|
byte[] buffer = new byte[1024];
|
int len;
|
while ((len = inputStream.read(buffer)) > 0) {
|
outputStream.write(buffer, 0, len);
|
}
|
outputStream.flush();
|
}
|
} catch (IOException e) {
|
log.error("导出销售台账模板失败", e);
|
// 若模板文件读取失败，返回错误提示
|
try {
|
response.getWriter().write("模板导出失败：" + e.getMessage());
|
} catch (IOException ex) {
|
log.error("响应输出错误", ex);
|
}
|
}
|
}
|
|
/**
|
* 查询采购台账列表
|
*/
|
@GetMapping("/list")
|
public TableDataInfo list(PurchaseLedger purchaseLedger) {
|
startPage();
|
List<PurchaseLedger> list = purchaseLedgerService.selectPurchaseLedgerList(purchaseLedger);
|
return getDataTable(list);
|
}
|
|
/**
|
* 导出采购台账列表
|
*/
|
@Log(title = "采购台账", businessType = BusinessType.EXPORT)
|
@PostMapping("/export")
|
public void export(HttpServletResponse response, PurchaseLedger purchaseLedger) {
|
List<PurchaseLedger> list = purchaseLedgerService.selectPurchaseLedgerList(purchaseLedger);
|
ExcelUtil<PurchaseLedger> util = new ExcelUtil<PurchaseLedger>(PurchaseLedger.class);
|
util.exportExcel(response, list, "【请填写功能名称】数据");
|
}
|
|
/**
|
* 导出来票登记列表
|
*/
|
@Log(title = "导出来票登记列表", businessType = BusinessType.EXPORT)
|
@PostMapping("/exportOne")
|
public void exportOne(HttpServletResponse response, PurchaseLedger purchaseLedger) {
|
Page page = new Page();
|
page.setCurrent(-1);
|
page.setSize(-1);
|
IPage<PurchaseLedgerDto> purchaseLedgerDtoIPage = purchaseLedgerService.selectPurchaseLedgerListPage(page, new PurchaseLedgerDto());
|
ExcelUtil<PurchaseLedgerDto> util = new ExcelUtil<PurchaseLedgerDto>(PurchaseLedgerDto.class);
|
util.exportExcel(response, purchaseLedgerDtoIPage.getRecords(), "导出来票登记列表");
|
}
|
|
/**
|
* 新增修改采购台账
|
*/
|
@Log(title = "采购台账", businessType = BusinessType.INSERT)
|
@PostMapping("/addOrEditPurchase")
|
public AjaxResult addOrEditPurchase(@RequestBody PurchaseLedgerDto purchaseLedgerDto) throws Exception {
|
return toAjax(purchaseLedgerService.addOrEditPurchase(purchaseLedgerDto));
|
}
|
|
/**
|
* 查询采购模板
|
*/
|
@ApiOperation("/查询采购模板")
|
@GetMapping("/getPurchaseTemplateList")
|
public AjaxResult getPurchaseTemplateList() {
|
List<PurchaseLedgerTemplate> purchaseLedgers = purchaseLedgerTemplateMapper.selectList(null);
|
purchaseLedgers.forEach(purchaseLedgerDto1 -> {
|
LambdaQueryWrapper<SalesLedgerProductTemplate> queryWrapper = new LambdaQueryWrapper<>();
|
queryWrapper.eq(SalesLedgerProductTemplate::getSalesLedgerId, purchaseLedgerDto1.getId())
|
.eq(SalesLedgerProductTemplate::getType, 2);
|
List<SalesLedgerProductTemplate> list = salesLedgerProductTemplateMapper.selectList(queryWrapper);
|
if (!list.isEmpty()) {
|
purchaseLedgerDto1.setProductList(list);
|
}
|
});
|
return AjaxResult.success(purchaseLedgers);
|
}
|
/**
|
* 修改采购台账审批状态
|
*/
|
@PostMapping("/updateApprovalStatus")
|
public AjaxResult addOrEditPurchase(@RequestBody PurchaseLedger purchaseLedger){
|
return toAjax(purchaseLedgerService.updateById(purchaseLedger));
|
}
|
/**
|
* 查询采购台账和产品父子列表
|
*/
|
@GetMapping("/getPurchaseById")
|
public PurchaseLedgerDto getPurchaseById(PurchaseLedgerDto purchaseLedgerDto) {
|
return purchaseLedgerService.getPurchaseById(purchaseLedgerDto);
|
}
|
|
/**
|
* 查询采购台账和产品父子列表
|
*/
|
@GetMapping("/getPurchaseByCode")
|
public PurchaseLedgerDto getPurchaseByCode(PurchaseLedgerDto purchaseLedgerDto) {
|
return purchaseLedgerService.getPurchaseByCode(purchaseLedgerDto);
|
}
|
|
/**
|
* 删除采购台账
|
*/
|
@Log(title = "采购台账", businessType = BusinessType.DELETE)
|
@DeleteMapping("/delPurchase")
|
public AjaxResult remove(@RequestBody Long[] ids) {
|
return toAjax(purchaseLedgerService.deletePurchaseLedgerByIds(ids));
|
}
|
|
/**
|
* 查询销售合同号
|
*/
|
@GetMapping("/getSalesNo")
|
public List getSalesNo() {
|
return salesLedgerService.getSalesNo();
|
}
|
|
|
/**
|
* 根据销售合同查询产品信息
|
*/
|
@GetMapping("/getProductBySalesNo")
|
public AjaxResult getProductBySalesNo(Long id) {
|
return AjaxResult.success(purchaseLedgerService.getProductBySalesNo(id));
|
}
|
|
/**
|
* 查询采购合同号
|
*/
|
@GetMapping("/getPurchaseNo")
|
public List getPurchasesNo() {
|
return purchaseLedgerService.getPurchasesNo();
|
}
|
|
/**
|
* 根据id查询采购合同号
|
*/
|
@GetMapping("/getPurchaseNoById")
|
public AjaxResult getPurchaseNoById(Long id) {
|
return AjaxResult.success(purchaseLedgerService.getPurchaseNoById(id));
|
}
|
|
/**
|
* 根据采购合同号查询产品
|
*/
|
@GetMapping("/getProduct")
|
public List getProduct(PurchaseLedgerDto purchaseLedgerDto) {
|
return purchaseLedgerService.getProduct(purchaseLedgerDto);
|
}
|
|
/**
|
* 根据采购合同号查询产品
|
*/
|
@GetMapping("/getInfo")
|
public AjaxResult getInfo(PurchaseLedgerDto purchaseLedgerDto) {
|
return AjaxResult.success(purchaseLedgerService.getInfo(purchaseLedgerDto));
|
}
|
|
/**
|
* 查询采购台账列表
|
*/
|
@GetMapping("/listPage")
|
public AjaxResult listPage(Page page, PurchaseLedgerDto purchaseLedger) {
|
return AjaxResult.success(purchaseLedgerService.selectPurchaseLedgerListPage(page, purchaseLedger));
|
}
|
|
@ApiOperation("生成采购序列号")
|
@GetMapping("/createPurchaseNo")
|
@Log(title = "生成采购序列号", businessType = BusinessType.OTHER)
|
public AjaxResult createPurchaseNo() {
|
return AjaxResult.success("生成成功",purchaseLedgerService.getPurchaseNo());
|
}
|
}
|
