package org.jeecg.modules.tms.controller;

import java.io.File;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.Arrays;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.modules.tms.entity.*;
import org.jeecg.modules.tms.entity.vo.*;
import org.jeecg.modules.tms.service.*;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import lombok.extern.slf4j.Slf4j;

import org.jeecg.common.system.base.controller.JeecgController;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.jeecg.common.aspect.annotation.AutoLog;

 /**
 * @Description: tms_base_tools
 * @Author: jeecg-boot
 * @Date:   2025-05-09
 * @Version: V1.0
 */
@Api(tags="tms_base_tools")
@RestController
@RequestMapping("/tms/baseTools")
@Slf4j
public class BaseToolsController extends JeecgController<BaseTools, IBaseToolsService> {
	@Autowired
	private IBaseToolsService baseToolsService;

	 @Autowired
	 private IToolsConfigPropertyService toolsConfigPropertyService;

	 @Autowired
	 private IParaHoleToolsService paraHoleToolsService;

	 @Autowired
	 private IParaThreadingToolService paraThreadingToolService;

	 @Autowired
	 private IParaTurningToolsService paraTurningToolsService;

	 @Autowired
	 private IParaMillToolService paraMillToolService;

	 @Autowired
	 private IParaCommonToolService paraCommonToolService;

	 @Autowired
	 private IParaBladeService paraBladeService;
	
	/**
	 * 分页列表查询
	 *
	 * @param baseTools
	 * @param pageNo
	 * @param pageSize
	 * @param req
	 * @return
	 */
	//@AutoLog(value = "tms_base_tools-分页列表查询")
	@ApiOperation(value="tms_base_tools-分页列表查询", notes="tms_base_tools-分页列表查询")
	@GetMapping(value = "/list")
	public Result<IPage<BaseTools>> queryPageList(BaseTools baseTools,
														 @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
														 @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
														 HttpServletRequest req) {
		QueryWrapper<BaseTools> queryWrapper = QueryGenerator.initQueryWrapper(baseTools, req.getParameterMap());
		Page<BaseTools> page = new Page<BaseTools>(pageNo, pageSize);
		IPage<BaseTools> pageList = baseToolsService.page(page, queryWrapper);
		return Result.OK(pageList);
	}


	 /**
	  * 根据分类选择工具
	  *
	  * @param baseTools
	  * @param pageNo
	  * @param pageSize
	  * @param req
	  * @return
	  */
	 @ApiOperation(value="根据分类选择工具", notes="根据分类选择工具")
	 @GetMapping(value = "/queryToolByClassifyId")
	 public Result<?> queryToolByClassifyId(BaseTools baseTools,
													 @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
													 @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
													 HttpServletRequest req) {
		 Map<String, String[]> parameterMap = req.getParameterMap();
		 String[] classifyIds = parameterMap.get("classifyId");
		 if (classifyIds != null && classifyIds.length > 0) {
			 if("1".equals(classifyIds[0])){
				 Page<ParaCommonToolVo> page = new Page<ParaCommonToolVo>(pageNo, pageSize);
				 IPage<ParaCommonToolVo> pageList = baseToolsService.paraCommonToolList(page, parameterMap);
				 return Result.OK(pageList);
			 }else if("2".equals(classifyIds[0])){
				 Page<ParaHolesToolsVo> page = new Page<ParaHolesToolsVo>(pageNo, pageSize);
				 IPage<ParaHolesToolsVo> pageList = baseToolsService.paraHolesToolsList(page, parameterMap);
				 return Result.OK(pageList);
			 }else if("3".equals(classifyIds[0])){
				 Page<ParaThreadingToolVo> page = new Page<ParaThreadingToolVo>(pageNo, pageSize);
				 IPage<ParaThreadingToolVo> pageList = baseToolsService.paraThreadingToolList(page, parameterMap);
				 return Result.OK(pageList);
			 }else if("4".equals(classifyIds[0])){
				 Page<ParaMillToolVo> page = new Page<ParaMillToolVo>(pageNo, pageSize);
				 IPage<ParaMillToolVo> pageList = baseToolsService.paraMillToolList(page, parameterMap);
				 return Result.OK(pageList);
			 }else if("5".equals(classifyIds[0])){
				 Page<ParaTurningToolsVo> page = new Page<ParaTurningToolsVo>(pageNo, pageSize);
				 IPage<ParaTurningToolsVo> pageList = baseToolsService.paraTurningToolsList(page, parameterMap);
				 return Result.OK(pageList);
			 }else if("6".equals(classifyIds[0])){
				 Page<ParaBladeVo> page = new Page<ParaBladeVo>(pageNo, pageSize);
				 IPage<ParaBladeVo> pageList = baseToolsService.paraBladeList(page, parameterMap);
				 return Result.OK(pageList);
			 }else {
				 return Result.error("请选择工具分类");
			 }
		 }else {
			 return Result.error("请选择工具分类");
		 }
	 }

	 /**
	  * 分页列表查询
	  *
	  * @param baseTools
	  * @param pageNo
	  * @param pageSize
	  * @param req
	  * @return
	  */
	 //@AutoLog(value = "tms_base_tools-分页列表查询")
	 @ApiOperation(value="tms_base_tools-分页列表查询", notes="tms_base_tools-分页列表查询")
	 @GetMapping(value = "/paraHolesToolsList")
	 public Result<IPage<ParaHolesToolsVo>> paraHolesToolsList(BaseTools baseTools,
														  @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
														  @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
														  HttpServletRequest req) {
		 Map<String, String[]> parameterMap = req.getParameterMap();
		 Page<ParaHolesToolsVo> page = new Page<ParaHolesToolsVo>(pageNo, pageSize);
		 IPage<ParaHolesToolsVo> pageList = baseToolsService.paraHolesToolsList(page, parameterMap);
		 return Result.OK(pageList);
	 }

	 /**
	  * 分页列表查询
	  *
	  * @param baseTools
	  * @param pageNo
	  * @param pageSize
	  * @param req
	  * @return
	  */
	 //@AutoLog(value = "tms_base_tools-分页列表查询")
	 @ApiOperation(value="tms_base_tools-分页列表查询", notes="tms_base_tools-分页列表查询")
	 @GetMapping(value = "/paraCommonToolList")
	 public Result<IPage<ParaCommonToolVo>> paraCommonToolList(BaseTools baseTools,
																  @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
																  @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
																  HttpServletRequest req) {
		 Map<String, String[]> parameterMap = req.getParameterMap();
		 Page<ParaCommonToolVo> page = new Page<ParaCommonToolVo>(pageNo, pageSize);
		 IPage<ParaCommonToolVo> pageList = baseToolsService.paraCommonToolList(page, parameterMap);
		 return Result.OK(pageList);
	 }

	 /**
	  * 分页列表查询
	  *
	  * @param baseTools
	  * @param pageNo
	  * @param pageSize
	  * @param req
	  * @return
	  */
	 //@AutoLog(value = "tms_base_tools-分页列表查询")
	 @ApiOperation(value="tms_base_tools-分页列表查询", notes="tms_base_tools-分页列表查询")
	 @GetMapping(value = "/paraThreadingToolList")
	 public Result<IPage<ParaThreadingToolVo>> paraThreadingToolList(BaseTools baseTools,
														  @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
														  @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
														  HttpServletRequest req) {
		 Map<String, String[]> parameterMap = req.getParameterMap();
		 Page<ParaThreadingToolVo> page = new Page<ParaThreadingToolVo>(pageNo, pageSize);
		 IPage<ParaThreadingToolVo> pageList = baseToolsService.paraThreadingToolList(page, parameterMap);
		 return Result.OK(pageList);
	 }

	 /**
	  * 分页列表查询
	  *
	  * @param baseTools
	  * @param pageNo
	  * @param pageSize
	  * @param req
	  * @return
	  */
	 //@AutoLog(value = "tms_base_tools-分页列表查询")
	 @ApiOperation(value="tms_base_tools-分页列表查询", notes="tms_base_tools-分页列表查询")
	 @GetMapping(value = "/paraMillToolList")
	 public Result<IPage<ParaMillToolVo>> paraMillToolList(BaseTools baseTools,
														   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
														   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
														   HttpServletRequest req) {
		 Map<String, String[]> parameterMap = req.getParameterMap();
		 Page<ParaMillToolVo> page = new Page<ParaMillToolVo>(pageNo, pageSize);
		 IPage<ParaMillToolVo> pageList = baseToolsService.paraMillToolList(page, parameterMap);
		 return Result.OK(pageList);
	 }

	 /**
	  * 分页列表查询
	  *
	  * @param baseTools
	  * @param pageNo
	  * @param pageSize
	  * @param req
	  * @return
	  */
	 //@AutoLog(value = "tms_base_tools-分页列表查询")
	 @ApiOperation(value="tms_base_tools-分页列表查询", notes="tms_base_tools-分页列表查询")
	 @GetMapping(value = "/paraTurningToolsList")
	 public Result<IPage<ParaTurningToolsVo>> paraTurningToolsList(BaseTools baseTools,
																   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
																   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
																   HttpServletRequest req) {
		 Map<String, String[]> parameterMap = req.getParameterMap();
		 Page<ParaTurningToolsVo> page = new Page<ParaTurningToolsVo>(pageNo, pageSize);
		 IPage<ParaTurningToolsVo> pageList = baseToolsService.paraTurningToolsList(page, parameterMap);
		 return Result.OK(pageList);
	 }

	 /**
	  * 分页列表查询
	  *
	  * @param baseTools
	  * @param pageNo
	  * @param pageSize
	  * @param req
	  * @return
	  */
	 //@AutoLog(value = "tms_base_tools-分页列表查询")
	 @ApiOperation(value="tms_base_tools-分页列表查询", notes="tms_base_tools-分页列表查询")
	 @GetMapping(value = "/paraBladeList")
	 public Result<IPage<ParaBladeVo>> paraBladeList(BaseTools baseTools,
													 @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
													 @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
													 HttpServletRequest req) {
		 Map<String, String[]> parameterMap = req.getParameterMap();
		 Page<ParaBladeVo> page = new Page<ParaBladeVo>(pageNo, pageSize);
		 IPage<ParaBladeVo> pageList = baseToolsService.paraBladeList(page, parameterMap);
		 return Result.OK(pageList);
	 }
	
	/**
	 *   添加
	 *
	 * @param jSONObject
	 * @return
	 */
	@AutoLog(value = "tms_base_tools-添加")
	@ApiOperation(value="tms_base_tools-添加", notes="tms_base_tools-添加")
	//@RequiresPermissions("org.jeecg.modules:tms_base_tools:add")
	@PostMapping(value = "/add")
	public Result<String> add(@RequestBody JSONObject jSONObject) {
		BaseTools baseTools = jSONObject.toJavaObject(BaseTools.class);
		String paramaTableName = jSONObject.getString("paraTypeFlag");
		ToolsConfigProperty toolsConfigProperty = jSONObject.toJavaObject(ToolsConfigProperty.class);
		ParaHoleTools paraHoleTools = jSONObject.toJavaObject(ParaHoleTools.class);
		ParaCommonTool paraCommonTool = jSONObject.toJavaObject(ParaCommonTool.class);
		ParaThreadingTool paraThreadingTool = jSONObject.toJavaObject(ParaThreadingTool.class);
		ParaTurningTools paraTurningTools = jSONObject.toJavaObject(ParaTurningTools.class);
		ParaMillTool paraMillTool = jSONObject.toJavaObject(ParaMillTool.class);
		ParaBlade paraBlade = jSONObject.toJavaObject(ParaBlade.class);
		baseTools.setParamaTableName(paramaTableName);
		if(baseToolsService.save(baseTools)){
			toolsConfigProperty.setToolCode(baseTools.getId());
			toolsConfigPropertyService.save(toolsConfigProperty);
			if("1".equals(paramaTableName)){
				paraCommonTool.setToolCode(baseTools.getId());
				paraCommonToolService.save(paraCommonTool);
			}else if("2".equals(paramaTableName)){
				paraHoleTools.setToolCode(baseTools.getId());
				paraHoleToolsService.save(paraHoleTools);
			}else if("3".equals(paramaTableName)){
				paraThreadingTool.setToolCode(baseTools.getId());
				paraThreadingToolService.save(paraThreadingTool);
			}else if("4".equals(paramaTableName)){
				paraMillTool.setToolCode(baseTools.getId());
				paraMillToolService.save(paraMillTool);
			}else if("5".equals(paramaTableName)){
				paraTurningTools.setToolCode(baseTools.getId());
				paraTurningToolsService.save(paraTurningTools);
			}else if("6".equals(paramaTableName)){
				paraBlade.setToolCode(baseTools.getId());
				paraBladeService.save(paraBlade);
			}
		}
		return Result.OK("添加成功！");
	}
	
	/**
	 *  编辑
	 *
	 * @param jSONObject
	 * @return
	 */
	@AutoLog(value = "tms_base_tools-编辑")
	@ApiOperation(value="tms_base_tools-编辑", notes="tms_base_tools-编辑")
	//@RequiresPermissions("org.jeecg.modules:tms_base_tools:edit")
	@RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
	public Result<String> edit(@RequestBody JSONObject jSONObject) {
		BaseTools baseTools = jSONObject.toJavaObject(BaseTools.class);
		ToolsConfigProperty toolsConfigProperty = jSONObject.toJavaObject(ToolsConfigProperty.class);
		ParaHoleTools paraHoleTools = jSONObject.toJavaObject(ParaHoleTools.class);
		ParaCommonTool paraCommonTool = jSONObject.toJavaObject(ParaCommonTool.class);
		ParaThreadingTool paraThreadingTool = jSONObject.toJavaObject(ParaThreadingTool.class);
		ParaTurningTools paraTurningTools = jSONObject.toJavaObject(ParaTurningTools.class);
		ParaMillTool paraMillTool = jSONObject.toJavaObject(ParaMillTool.class);
		ParaBlade paraBlade = jSONObject.toJavaObject(ParaBlade.class);
		if(baseToolsService.updateById(baseTools)){
			ToolsConfigProperty toolsConfigProperty1 = toolsConfigPropertyService.lambdaQuery().eq(ToolsConfigProperty::getToolCode,baseTools.getId()).one();
			if(toolsConfigProperty1 != null){
				toolsConfigProperty.setId(toolsConfigProperty1.getId());
				toolsConfigProperty.setToolCode(baseTools.getId());
				toolsConfigPropertyService.updateById(toolsConfigProperty);
			}else {
				toolsConfigProperty.setToolCode(baseTools.getId());
				toolsConfigPropertyService.save(toolsConfigProperty);
			}
			if("1".equals(baseTools.getParamaTableName())){
				ParaCommonTool paraCommonTool1 = paraCommonToolService.lambdaQuery().eq(ParaCommonTool::getToolCode,baseTools.getId()).one();
				if(paraCommonTool1 != null){
					paraCommonTool.setId(paraCommonTool1.getId());
					paraCommonTool.setToolCode(baseTools.getId());
					paraCommonToolService.updateById(paraCommonTool);
				}else {
					paraCommonTool.setToolCode(baseTools.getId());
					paraCommonToolService.save(paraCommonTool);
				}
			}else if("2".equals(baseTools.getParamaTableName())){
				ParaHoleTools paraHoleTools1 = paraHoleToolsService.lambdaQuery().eq(ParaHoleTools::getToolCode,baseTools.getId()).one();
				if(paraHoleTools1 != null){
					paraHoleTools.setId(paraHoleTools1.getId());
					paraHoleTools.setToolCode(baseTools.getId());
					paraHoleToolsService.updateById(paraHoleTools);
				}else {
					paraHoleTools.setToolCode(baseTools.getId());
					paraHoleToolsService.save(paraHoleTools);
				}
			}else if("3".equals(baseTools.getParamaTableName())){
				ParaThreadingTool paraThreadingTool1 = paraThreadingToolService.lambdaQuery().eq(ParaThreadingTool::getToolCode,baseTools.getId()).one();
				if(paraThreadingTool1 != null){
					paraThreadingTool.setId(paraThreadingTool1.getId());
					paraThreadingTool.setToolCode(baseTools.getId());
					paraThreadingToolService.updateById(paraThreadingTool);
				}else {
					paraThreadingTool.setToolCode(baseTools.getId());
					paraThreadingToolService.save(paraThreadingTool);
				}
			}else if("4".equals(baseTools.getParamaTableName())){
				ParaMillTool paraMillTool1 = paraMillToolService.lambdaQuery().eq(ParaMillTool::getToolCode,baseTools.getId()).one();
				if(paraMillTool1 != null){
					paraMillTool.setId(paraMillTool1.getId());
					paraMillTool.setToolCode(baseTools.getId());
					paraMillToolService.updateById(paraMillTool);
				}else {
					paraMillTool.setToolCode(baseTools.getId());
					paraMillToolService.save(paraMillTool);
				}
			}else if("5".equals(baseTools.getParamaTableName())){
				ParaTurningTools paraTurningTools1 = paraTurningToolsService.lambdaQuery().eq(ParaTurningTools::getToolCode,baseTools.getId()).one();
				if(paraTurningTools1 != null){
					paraTurningTools.setId(paraTurningTools1.getId());
					paraTurningTools.setToolCode(baseTools.getId());
					paraTurningToolsService.updateById(paraTurningTools);
				}else {
					paraTurningTools.setToolCode(baseTools.getId());
					paraTurningToolsService.save(paraTurningTools);
				}
			}else if("6".equals(baseTools.getParamaTableName())){
				ParaBlade paraBlade1 = paraBladeService.lambdaQuery().eq(ParaBlade::getToolCode,baseTools.getId()).one();
				if(paraBlade1 != null){
					paraBlade.setId(paraBlade1.getId());
					paraBlade.setToolCode(baseTools.getId());
					paraBladeService.updateById(paraBlade);
				}else {
					paraBlade.setToolCode(baseTools.getId());
					paraBladeService.save(paraBlade);
				}
			}
		}
		return Result.OK("编辑成功!");
	}
	
	/**
	 *   通过id删除
	 *
	 * @param id
	 * @return
	 */
	@AutoLog(value = "tms_base_tools-通过id删除")
	@ApiOperation(value="tms_base_tools-通过id删除", notes="tms_base_tools-通过id删除")
	//@RequiresPermissions("org.jeecg.modules:tms_base_tools:delete")
	@DeleteMapping(value = "/delete")
	public Result<String> delete(@RequestParam(name="id",required=true) String id) {
		baseToolsService.removeById(id);
		BaseTools baseTools = baseToolsService.getById(id);
		ToolsConfigProperty toolsConfigProperty = toolsConfigPropertyService.lambdaQuery().eq(ToolsConfigProperty::getToolCode,baseTools.getId()).one();
		if(toolsConfigProperty != null){
			toolsConfigPropertyService.removeById(toolsConfigProperty.getId());
		}
		if("1".equals(baseTools.getParamaTableName())){
			ParaCommonTool paraCommonTool = paraCommonToolService.lambdaQuery().eq(ParaCommonTool::getToolCode,baseTools.getId()).one();
			if(paraCommonTool != null){
				paraCommonToolService.removeById(paraCommonTool.getId());
			}
		}else if("2".equals(baseTools.getParamaTableName())){
			ParaHoleTools paraHoleTools = paraHoleToolsService.lambdaQuery().eq(ParaHoleTools::getToolCode,baseTools.getId()).one();
			if(paraHoleTools != null){
				paraHoleToolsService.removeById(paraHoleTools.getId());
			}
		}else if("3".equals(baseTools.getParamaTableName())){
			ParaThreadingTool paraThreadingTool = paraThreadingToolService.lambdaQuery().eq(ParaThreadingTool::getToolCode,baseTools.getId()).one();
			if(paraThreadingTool != null){
				paraThreadingToolService.removeById(paraThreadingTool.getId());
			}
		}else if("4".equals(baseTools.getParamaTableName())){
			ParaMillTool paraMillTool = paraMillToolService.lambdaQuery().eq(ParaMillTool::getToolCode,baseTools.getId()).one();
			if(paraMillTool != null){
				paraMillToolService.removeById(paraMillTool.getId());
			}
		}else if("5".equals(baseTools.getParamaTableName())){
			ParaTurningTools paraTurningTools = paraTurningToolsService.lambdaQuery().eq(ParaTurningTools::getToolCode,baseTools.getId()).one();
			if(paraTurningTools != null){
				paraTurningToolsService.removeById(paraTurningTools.getId());
			}
		}else if("6".equals(baseTools.getParamaTableName())){
			ParaBlade paraBlade = paraBladeService.lambdaQuery().eq(ParaBlade::getToolCode,baseTools.getId()).one();
			if(paraBlade != null){
				paraBladeService.removeById(paraBlade.getId());
			}
		}
		return Result.OK("删除成功!");
	}
	
	/**
	 *  批量删除
	 *
	 * @param ids
	 * @return
	 */
	@AutoLog(value = "tms_base_tools-批量删除")
	@ApiOperation(value="tms_base_tools-批量删除", notes="tms_base_tools-批量删除")
	//@RequiresPermissions("org.jeecg.modules:tms_base_tools:deleteBatch")
	@DeleteMapping(value = "/deleteBatch")
	public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
		this.baseToolsService.removeByIds(Arrays.asList(ids.split(",")));
		return Result.OK("批量删除成功!");
	}
	
	/**
	 * 通过id查询
	 *
	 * @param id
	 * @return
	 */
	//@AutoLog(value = "tms_base_tools-通过id查询")
	@ApiOperation(value="tms_base_tools-通过id查询", notes="tms_base_tools-通过id查询")
	@GetMapping(value = "/queryById")
	public Result<BaseTools> queryById(@RequestParam(name="id",required=true) String id) {
		BaseTools baseTools = baseToolsService.getById(id);
		if(baseTools==null) {
			return Result.error("未找到对应数据");
		}
		return Result.OK(baseTools);
	}

    /**
    * 导出excel
    *
    * @param request
    * @param baseTools
    */
    //@RequiresPermissions("org.jeecg.modules:tms_base_tools:exportXls")
    @RequestMapping(value = "/exportXls")
    public ModelAndView exportXls(HttpServletRequest request, BaseTools baseTools) {
        return super.exportXls(request, baseTools, BaseTools.class, "tms_base_tools");
    }

    /**
      * 通过excel导入数据
    *
    * @param request
    * @param response
    * @return
    */
    //@RequiresPermissions("tms_base_tools:importExcel")
    @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
    public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
        return super.importExcel(request, response, BaseTools.class);
    }

	 /**
	  * 通过工具id查询
	  *
	  * @param toolCode
	  * @return
	  */
	 @GetMapping(value = "/queryByToolCode")
	 public Result<?> queryByToolCode(@RequestParam(name="toolCode",required=true) String toolCode,@RequestParam(name="paraTypeFlag",required=true) String paraTypeFlag) {
		 if("1".equals(paraTypeFlag)){
			 ParaCommonTool paraCommonTool = paraCommonToolService.lambdaQuery().eq(ParaCommonTool::getToolCode,toolCode).one();
			 return Result.OK(paraCommonTool);
		 }else if("2".equals(paraTypeFlag)){
			 ParaHoleTools paraHoleTools = paraHoleToolsService.lambdaQuery().eq(ParaHoleTools::getToolCode,toolCode).one();
			 return Result.OK(paraHoleTools);
		 }else if("3".equals(paraTypeFlag)){
			 ParaThreadingTool paraThreadingTool = paraThreadingToolService.lambdaQuery().eq(ParaThreadingTool::getToolCode,toolCode).one();
			 return Result.OK(paraThreadingTool);
		 }else if("4".equals(paraTypeFlag)){
			 ParaMillTool paraMillTool = paraMillToolService.lambdaQuery().eq(ParaMillTool::getToolCode,toolCode).one();
			 return Result.OK(paraMillTool);
		 }else if("5".equals(paraTypeFlag)){
			 ParaTurningTools paraTurningTools = paraTurningToolsService.lambdaQuery().eq(ParaTurningTools::getToolCode,toolCode).one();
			 return Result.OK(paraTurningTools);
		 }else if("6".equals(paraTypeFlag)){
			ParaBlade paraBlade = paraBladeService.lambdaQuery().eq(ParaBlade::getToolCode,toolCode).one();
			 return Result.OK(paraBlade);
		 }else {
			 return Result.OK("");
		 }
	 }
	 @GetMapping("/listWithLedgerAndConfig")
	 public Result<IPage<StocktakingPoundVo>> listWithLedgerAndConfig(
			 StocktakingPoundVo stocktakingPoundVo,
			 @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
			 @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
			 HttpServletRequest req) {

		 // 使用 QueryGenerator 构建 QueryWrapper
		 QueryWrapper<StocktakingPoundVo> queryWrapper = QueryGenerator.initQueryWrapper(stocktakingPoundVo, req.getParameterMap());

		 Page<StocktakingPoundVo> page = new Page<>(pageNo, pageSize);
		 IPage<StocktakingPoundVo> resultPage = baseToolsService.pageWithLedgerAndConfig(page, queryWrapper);
		 return Result.OK(resultPage);
	 }



	 @GetMapping("/listWithSharpedAndConfig")
	 public Result<IPage<SharpeeningVo>> listWithSharpedAndConfig(
			 SharpeeningVo sharpeeningVo,
			 @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
			 @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
			 HttpServletRequest req) {

		 // 使用 QueryGenerator 构建 QueryWrapper
		 QueryWrapper<SharpeeningVo> queryWrapper = QueryGenerator.initQueryWrapper(sharpeeningVo, req.getParameterMap());

		 Page<SharpeeningVo> page = new Page<>(pageNo, pageSize);
		 IPage<SharpeeningVo> resultPage = baseToolsService.pageWithSharpedAndConfig(page, queryWrapper);
		 return Result.OK(resultPage);
	 }


	 /**
	  * 导入模板下载
	  *
	  */
	 @RequestMapping(value = "/loadTemplate")
	 public void loadTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException {

		 Map<String,String[]> req = request.getParameterMap();
		 String paraTypeFlag = "";
		 if(req.get("paraTypeFlag") != null){
			 paraTypeFlag = req.get("paraTypeFlag")[0];
		 }
		 if("1".equals(paraTypeFlag)){
			 Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\刀具信息导入模板-通用参数.xlsx"));
			 //导出Workbook
			 //设置响应头
			 String fileName = "刀具信息导入模板-通用参数.xlsx";
			 // 对文件名进行URL编码，防止中文乱码
			 String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
			 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
			 response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
			 // 将Workbook写入响应输出流
			 try { // try-with-resources自动关闭资源
				 workbook.write(response.getOutputStream());
				 response.flushBuffer();
			 } catch (IOException e) {
				 // 异常处理（如记录日志）
				 throw new IOException("下载模板失败", e);
			 }
		 }else if("2".equals(paraTypeFlag)){
			 Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\刀具信息导入模板-孔加工工具.xlsx"));
			 String fileName = "刀具信息导入模板-孔加工工具.xlsx";
			 String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
			 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
			 response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
			 try {
				 workbook.write(response.getOutputStream());
				 response.flushBuffer();
			 } catch (IOException e) {
				 throw new IOException("下载模板失败", e);
			 }
		 }else if("3".equals(paraTypeFlag)){
			 Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\刀具信息导入模板-螺纹工具.xlsx"));
			 String fileName = "刀具信息导入模板-螺纹工具.xlsx";
			 String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
			 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
			 response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
			 try {
				 workbook.write(response.getOutputStream());
				 response.flushBuffer();
			 } catch (IOException e) {
				 throw new IOException("下载模板失败", e);
			 }
		 }else if("4".equals(paraTypeFlag)){
			 Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\刀具信息导入模板-铣削工具.xlsx"));
			 String fileName = "刀具信息导入模板-铣削工具.xlsx";
			 String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
			 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
			 response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
			 try {
				 workbook.write(response.getOutputStream());
				 response.flushBuffer();
			 } catch (IOException e) {
				 throw new IOException("下载模板失败", e);
			 }
		 }else if("5".equals(paraTypeFlag)){
			 Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\刀具信息导入模板-车削工具.xlsx"));
			 String fileName = "刀具信息导入模板-车削工具.xlsx";
			 String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
			 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
			 response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
			 try {
				 workbook.write(response.getOutputStream());
				 response.flushBuffer();
			 } catch (IOException e) {
				 throw new IOException("下载模板失败", e);
			 }
		 }else if("6".equals(paraTypeFlag)){
			 Workbook workbook = WorkbookFactory.create(new File("D:\\opt\\upFiles\\刀具信息导入模板-刀片.xlsx"));
			 String fileName = "刀具信息导入模板-刀片.xlsx";
			 String encodedFileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
			 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
			 response.setHeader("Content-Disposition", "attachment; filename*=UTF-8''" + encodedFileName);
			 try {
				 workbook.write(response.getOutputStream());
				 response.flushBuffer();
			 } catch (IOException e) {
				 throw new IOException("下载模板失败", e);
			 }
		 }

	 }
}