feat: 标准成本导入页面接口

gongchunyi

3 天以前 89601693cac022cd36288f67afc39c079ce70810

feat: 标准成本导入页面接口

 src/main/java/com/ruoyi/production/controller/ProductionSettlementBatchesController.java

@@ -76,5 +76,10 @@
        return AjaxResult.success(totalCosts);
    }

    @GetMapping("/importExcelList/{year}")
    @ApiOperation("标准成本导入台账")
    public AjaxResult importExcelList(@PathVariable String year){
        return AjaxResult.success(productionSettlementBatchesService.importExcelList(year));
    }

}

 src/main/java/com/ruoyi/production/controller/ProductionSettlementDetailsController.java

@@ -1,9 +1,13 @@
package com.ruoyi.production.controller;


import com.ruoyi.framework.web.domain.AjaxResult;
import com.ruoyi.production.service.IProductionSettlementDetailsService;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;

/**
@@ -15,8 +19,17 @@
 * @since 2026-03-30
 */
@RestController
@RequestMapping("/production-settlement-details")
@RequestMapping("/productionSettlementDetails")
@ApiModel(value = "ProductionSettlementDetailsController类", description = "生产成本核算对比明细表 前端控制器")
public class ProductionSettlementDetailsController {

    @Autowired
    private IProductionSettlementDetailsService productionSettlementDetailsService;

    @GetMapping("/getDetailsByBatchId/{batchId}")
    @ApiOperation("根据批次ID获取明细数据")
    public AjaxResult getDetailsByBatchId(@PathVariable Long batchId) {
        return AjaxResult.success(productionSettlementDetailsService.selectByBatchId(batchId));
    }

}

 src/main/java/com/ruoyi/production/service/IProductionSettlementBatchesService.java

@@ -29,4 +29,6 @@
    List<String> getSubjectNames(ProductionSettlementDto dto);

    ProductionSettlementTotalDto getTotalCosts(ProductionSettlementDto dto);

    List<ProductionSettlementBatches> importExcelList(String year);
}

 src/main/java/com/ruoyi/production/service/IProductionSettlementDetailsService.java

@@ -3,6 +3,8 @@
import com.ruoyi.production.pojo.ProductionSettlementDetails;
import com.baomidou.mybatisplus.extension.service.IService;

import java.util.List;

/**
 * <p>
 * 生产成本核算对比明细表 服务类
@@ -13,4 +15,6 @@
 */
public interface IProductionSettlementDetailsService extends IService<ProductionSettlementDetails> {

    List<ProductionSettlementDetails> selectByBatchId(Long batchId);

}

 src/main/java/com/ruoyi/production/service/impl/ProductionSettlementBatchesServiceImpl.java

@@ -493,4 +493,12 @@
        result.setDiffRate(diffRate);
        return result;
    }

    @Override
    public List<ProductionSettlementBatches> importExcelList(String year) {
        return this.lambdaQuery()
                .likeRight(ProductionSettlementBatches::getPeriodTime, year)
                .orderByDesc(ProductionSettlementBatches::getPeriodTime)
                .list();
    }
}

 src/main/java/com/ruoyi/production/service/impl/ProductionSettlementDetailsServiceImpl.java

@@ -6,6 +6,8 @@
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * <p>
 * 生产成本核算对比明细表 服务实现类
@@ -17,4 +19,10 @@
@Service
public class ProductionSettlementDetailsServiceImpl extends ServiceImpl<ProductionSettlementDetailsMapper, ProductionSettlementDetails> implements IProductionSettlementDetailsService {

    @Override
    public List<ProductionSettlementDetails> selectByBatchId(Long batchId) {
        return this.lambdaQuery()
                .eq(ProductionSettlementDetails::getBatchId, batchId)
                .list();
    }
}