package com.billion.main.bs.controller; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletResponse; import cn.hutool.core.util.ObjectUtil; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.billion.common.utils.StringUtils; import com.billion.common.utils.poi.ExcelUtil; import com.billion.main.bs.domain.BsFormulaChildInfo; import com.billion.main.bs.service.IBsFormulaChildInfoService; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.PutMapping; import org.springframework.web.bind.annotation.DeleteMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import com.billion.common.annotation.Log; import com.billion.common.core.controller.BaseController; import com.billion.common.core.domain.AjaxResult; import com.billion.common.enums.BusinessType; import com.billion.common.core.page.TableDataInfo; /** * 配方配置子信息Controller * * @author Billion * @date 2024-11-26 */ @RestController @RequestMapping("/formulaChildInfo") public class BsFormulaChildInfoController extends BaseController { @Autowired private IBsFormulaChildInfoService bsFormulaChildInfoService; /** * 查询配方配置子信息列表 */ @PreAuthorize("@ss.hasPermi('main:info:list')") @GetMapping("/list") public TableDataInfo list(BsFormulaChildInfo bsFormulaChildInfo) { if(ObjectUtil.isNull(bsFormulaChildInfo.getPageFlag())){ startPage(); } List list = bsFormulaChildInfoService.selectBsFormulaChildInfoList(bsFormulaChildInfo); return getDataTable(list); } /** * 导出配方配置子信息列表 */ @PreAuthorize("@ss.hasPermi('main:info:export')") @Log(title = "配方配置子信息", businessType = BusinessType.EXPORT) @PostMapping("/export") public void export(HttpServletResponse response, BsFormulaChildInfo bsFormulaChildInfo) { List list = bsFormulaChildInfoService.selectBsFormulaChildInfoList(bsFormulaChildInfo); ExcelUtil util = new ExcelUtil(BsFormulaChildInfo.class); util.exportExcel(response, list, "配方配置子信息数据"); } /** * 获取配方配置子信息详细信息 */ @PreAuthorize("@ss.hasPermi('main:info:query')") @GetMapping(value = "/{id}") public AjaxResult getInfo(@PathVariable("id") Long id) { return success(bsFormulaChildInfoService.selectBsFormulaChildInfoById(id)); } /** * 新增配方配置子信息 */ @PreAuthorize("@ss.hasPermi('main:info:add')") @Log(title = "配方配置子信息", businessType = BusinessType.INSERT) @PostMapping public AjaxResult add(@RequestBody BsFormulaChildInfo bsFormulaChildInfo) { return toAjax(bsFormulaChildInfoService.insertBsFormulaChildInfo(bsFormulaChildInfo)); } /** * 修改配方配置子信息 */ @PreAuthorize("@ss.hasPermi('main:info:edit')") @Log(title = "配方配置子信息", businessType = BusinessType.UPDATE) @PutMapping public AjaxResult edit(@RequestBody BsFormulaChildInfo bsFormulaChildInfo) { return toAjax(bsFormulaChildInfoService.updateBsFormulaChildInfo(bsFormulaChildInfo)); } /** * 删除配方配置子信息 */ @PreAuthorize("@ss.hasPermi('main:info:remove')") @Log(title = "配方配置子信息", businessType = BusinessType.DELETE) @DeleteMapping("/{ids}") public AjaxResult remove(@PathVariable Long[] ids) { return toAjax(bsFormulaChildInfoService.deleteBsFormulaChildInfoByIds(ids)); } @PostMapping("/updateCollectData") public AjaxResult updateCollectDataByMaterialCode(@RequestBody Map params) { try { String locationCode = params.get("locationCode"); String inputValue = params.get("inputValue"); // 1. 获取该工位的所有配方数据 LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(BsFormulaChildInfo::getLocationCode, locationCode); List formulaList = bsFormulaChildInfoService.list(queryWrapper); // 2. 查找匹配的记录 boolean found = false; for (BsFormulaChildInfo formula : formulaList) { if (formula.getMaterialCode() != null && inputValue.contains(formula.getMaterialCode())) { // 更新匹配记录的采集值和结果 formula.setCollectData(inputValue); formula.setResults("OK"); bsFormulaChildInfoService.updateById(formula); found = true; break; } } if (!found) { return AjaxResult.error("未找到匹配的物料编码"); } // 3. 返回更新后的完整列表 List updatedList = bsFormulaChildInfoService.list(queryWrapper); return AjaxResult.success(updatedList); } catch (Exception e) { return AjaxResult.error("更新数据失败:" + e.getMessage()); } } }