工具台账功能

cuijian

2025-06-06 35d9446131124e12616c7b6b9dfd79e23d20e1c9

 lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutStoreDetailController.java

@@ -9,10 +9,14 @@
import java.net.URLDecoder;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.shiro.SecurityUtils;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.common.system.vo.LoginUser;
import org.jeecg.common.util.oConvertUtils;
import org.jeecg.modules.tms.entity.OutStoreDetail;
import org.jeecg.modules.tms.entity.ToolLedger;
import org.jeecg.modules.tms.entity.vo.OutStoreDetailVo;
import org.jeecg.modules.tms.service.IOutStoreDetailService;

@@ -155,12 +159,30 @@
    * 导出excel
    *
    * @param request
    * @param outStoreDetail
    */
    //@RequiresPermissions("org.jeecg.modules:tms_out_store_detail:exportXls")
    @RequestMapping(value = "/exportXls")
    public ModelAndView exportXls(HttpServletRequest request, OutStoreDetail outStoreDetail) {
        return super.exportXls(request, outStoreDetail, OutStoreDetail.class, "工具出库流水");
    public ModelAndView exportXls(HttpServletRequest request) {
      // Step.1 组装查询条件
      Map<String, String[]> parameterMap = request.getParameterMap();
      Page<OutStoreDetailVo> page = new Page<>(1, 1000000);
      LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal();

      // Step.2 获取导出数据
      IPage<OutStoreDetailVo> pageList = outStoreDetailService.queryPageList(page, parameterMap);
      List<OutStoreDetailVo> exportList = pageList.getRecords();

      // Step.3 AutoPoi 导出Excel
      ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
      //此处设置的filename无效 ,前端会重更新设置一下
      mv.addObject(NormalExcelConstants.FILE_NAME, "工具出库流水");
      mv.addObject(NormalExcelConstants.CLASS, OutStoreDetailVo.class);
      //update-begin--Author:liusq  Date:20210126 for：图片导出报错，ImageBasePath未设置--------------------
      ExportParams  exportParams=new ExportParams("工具出库流水" + "报表", "导出人:" + sysUser.getRealname(), "工具出库流水");
      //update-end--Author:liusq  Date:20210126 for：图片导出报错，ImageBasePath未设置----------------------
      mv.addObject(NormalExcelConstants.PARAMS,exportParams);
      mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
      return mv;
    }

    /**
@@ -176,4 +198,23 @@
        return super.importExcel(request, response, OutStoreDetail.class);
    }

    /**
     * 工具台账-出库子页面列表查询
     *
     * @param outStoreDetail
     * @param pageNo
     * @param pageSize
     * @param query
     * @return
     */
    @ApiOperation(value="工具台账-出库子页面列表查询", notes="工具台账-出库子页面列表查询")
    @GetMapping(value = "/outStoreDetailList")
    public Result<?> outStoreDetailList(OutStoreDetail outStoreDetail,
                            @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
                            @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
                            @RequestParam Map<String, String> query) {
       IPage<Map<String, Object>> pageList = outStoreDetailService.outStoreDetailList(pageNo,pageSize, query);
       return Result.OK(pageList);
    }

}