package com.consum.base.controller; import com.consum.base.BaseController; import com.consum.base.core.utils.IdUtil; import com.consum.base.core.utils.MapUtils; import com.consum.base.core.utils.MapperUtil; import com.consum.base.pojo.*; import com.consum.base.pojo.query.TransferQry; import com.consum.base.pojo.response.FormTransferVO; import com.consum.base.pojo.response.FromTransferTemplateInfoVO; import com.consum.base.pojo.response.LWHFromTransferExtendVO; import com.consum.base.pojo.response.TransferInfoVO; import com.consum.base.service.*; import com.consum.model.po.*; import com.consum.model.vo.LWhFormOutputVo; import com.iplatform.model.po.S_user_core; import com.walker.db.page.GenericPager; import com.walker.infrastructure.utils.CollectionUtils; import com.walker.infrastructure.utils.DateUtils; import com.walker.web.ResponseValue; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import org.apache.commons.compress.utils.Lists; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.lang.reflect.Field; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; /** * @Description 调拨管理 * @Author 卢庆阳 * @Date 2023/10/30 */ @RestController @RequestMapping("/pc/l/wh/form/transfer") @Api(tags = "调拨分发管理") public class LWhFormTransferController extends BaseController { @Autowired private LWhFormTransferServiceImpl lWhFormTransferService; @Autowired private LWhProcureModelService lWhProcureModelService; @Autowired private LWhFormTransferCoreService lWhFormTransferCoreService; @Autowired private LWhProcureModelUserServiceImpl lWhProcureModelUserService; @Autowired private LWhProcureModelUserRecordServiceImpl lWhProcureModelUserRecordService; @Autowired private BaseGoodsModelsServiceImpl baseGoodsModelsService; @Autowired private BaseWarehouseServiceImpl baseWarehouseService; /** * @Description 新增 */ @ApiOperation(value = "单据新增", notes = "单据新增") @ApiImplicitParam(name = "param", value = "单据新增", required = true, dataType = "LWhFormTransferParam") @PostMapping("/add") public ResponseValue add(@RequestBody LWhFormTransferParam param) throws Exception { S_user_core currentUser = this.getCurrentUser(); if (currentUser == null) { return ResponseValue.error("登录用户信息不存在"); } List transferGoods = param.getTransferGoods(); if (CollectionUtils.isEmpty(transferGoods)) { return ResponseValue.error("调拨单不能为空"); } int result = this.lWhFormTransferService.add(param, this.getSysInfo()); if (result > 0) { return ResponseValue.success(1); } return ResponseValue.error("新增失败!"); } /** * @Description 列表查询(调拨明细) * @Author 卢庆阳 * @Date 2023/10/30 *

* 1.查询调拨单 *

* 2.查询物品型号 */ @ApiOperation(value = "单据列表查询", notes = "单据列表查询") @ApiImplicitParams({ @ApiImplicitParam(name = "page", value = "页码", required = true, dataType = "int"), @ApiImplicitParam(name = "size", value = "每页条数", required = true, dataType = "int"), @ApiImplicitParam(name = "param", value = "条件参数", required = true, dataType = "TransferQry"), }) @GetMapping("/list") public ResponseValue queryFormTransferList(TransferQry param) { S_user_core currentUser = this.getCurrentUser(); if (currentUser == null) { return ResponseValue.error("登录用户信息不存在"); } GenericPager genericPager = lWhFormTransferService.queryFormTransferList(param); List datas = genericPager.getDatas(); ArrayList result = new ArrayList<>(); if (!CollectionUtils.isEmpty(datas)) { datas.forEach(item -> { FormTransferVO formTransferVO = new FormTransferVO(); BeanUtils.copyProperties(item, formTransferVO); List templateInfoList = Lists.newArrayList(); // 查询型号数量 String sql = "SELECT bgt.id,bgm.GOODS_TEMPLATES_ID,GOODS_NAME,sum( counts ) count FROM " + "l_wh_procure_model pm LEFT JOIN base_goods_models bgm ON pm.BASE_GOODS_MODELS_ID = bgm.id " + "LEFT JOIN base_goods_template bgt ON bgm.GOODS_TEMPLATES_ID = bgt.id " + "WHERE pm.BUSINESS_ID =:id GROUP BY bgm.GOODS_TEMPLATES_ID"; Map paramMap = new HashMap<>(); paramMap.put("id", item.getId()); List> procureModelList = lWhProcureModelService.select(sql, paramMap, new MapperUtil()); for (Map map : procureModelList) { FromTransferTemplateInfoVO procureTemplateInfoVO = MapUtils.convertMapToObj(map, FromTransferTemplateInfoVO.class); templateInfoList.add(procureTemplateInfoVO); } formTransferVO.setFromTransferTemplateInfoList(templateInfoList); result.add(formTransferVO); /*// 查询型号数量 LWhProcureModel lWhProcureModel = new LWhProcureModel(); Integer businessType = item.getBusinessType(); // TODO 调拨=0 分发=1 退回=2 switch (businessType) { case 0: lWhProcureModel.setBusinessType(2); break; case 1: lWhProcureModel.setBusinessType(4); break; } lWhProcureModel.setBusinessId(item.getId()); List models = lWhProcureModelService.select(lWhProcureModel); List lWhProcureModelVoList = new ArrayList<>(); if (!CollectionUtils.isEmpty(models)) { models.forEach(model -> { LWhProcureModelVo lWhProcureModelVo = new LWhProcureModelVo(); BeanUtils.copyProperties(model, lWhProcureModelVo); Long baseGoodsModelsId = model.getBaseGoodsModelsId(); Long businessId = model.getBusinessId(); Long id = model.getId(); LWhProcureModelUser lWhFormTransferUser = new LWhProcureModelUser(); lWhFormTransferUser.setTransBusinessId(businessId); lWhFormTransferUser.setWhProcureModelId(id); lWhFormTransferUser.setBaseGoodsModelsId(baseGoodsModelsId); List procureModelUserList = lWhProcureModelUserService.select(lWhFormTransferUser); lWhProcureModelVo.setProcureModelUsersList(procureModelUserList); lWhProcureModelVoList.add(lWhProcureModelVo); }); } formTransferExtend.setModels(lWhProcureModelVoList); newDatas.add(formTransferExtend);*/ }); } try { Field fieldDatas = GenericPager.class.getDeclaredField("datas"); fieldDatas.setAccessible(true); fieldDatas.set(genericPager, result); } catch (Exception e) { e.printStackTrace(); } return ResponseValue.success(genericPager); } /** * @Description 根据id查询详情 * @Author 卢庆阳 * @Date 2023/10/30 */ @ApiOperation(value = "根据id查询详情", notes = "根据id查询详情") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "调拨单id", required = true, dataType = "Long"), }) @GetMapping("/detail") public ResponseValue getById(Long id) { if (id == null) { return ResponseValue.error("调拨单id为空"); } LWHFromTransferExtendVO vo = this.lWhFormTransferService.getById(id); return ResponseValue.success(vo); } /** * 撤销 * * @author 卢庆阳 * @date 2023/10/31 */ @ApiOperation(value = "撤销", notes = "撤销") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "调拨单id", required = true, dataType = "Long"), }) @PostMapping("/updStatus") public ResponseValue updateStatus(Long id) { if (id == null) { return ResponseValue.error("参数错误"); } int num = this.lWhFormTransferService.updateStatus(id); return num > 0 ? ResponseValue.success(1) : ResponseValue.error("修改失败!"); } /** * @Description 调拨入库 * @Author 卢庆阳 * @Date 2023/10/31 */ @ApiOperation(value = "调拨入库", notes = "调拨入库") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "调拨单id", required = true, dataType = "Long"), }) @PostMapping("/income") public ResponseValue income(Long id) { lWhFormTransferCoreService.doTransferInPut(id, getCurrentUser()); return ResponseValue.success(); } /** * @Description 调拨出库 * @Author 卢庆阳 * @Date 2023/10/31 */ @ApiOperation(value = "调拨出库", notes = "调拨出库") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "调拨单id", required = true, dataType = "Long"), }) @PostMapping("/output") public ResponseValue output(Long id) { // 出库前 设置出库仓库 FinSysTenantUser sysTenantUser = this.getSysInfo(); String agencyId = sysTenantUser.getTenantId(); List baseWarehouseList = baseWarehouseService.getByAgencyId(Long.valueOf(agencyId), (short) 1, (short) 1); if (CollectionUtils.isEmpty(baseWarehouseList)){ return ResponseValue.error("机构无默认仓库!"); } BaseWarehouse baseWarehouse = baseWarehouseList.get(0); Long wareHouseId = baseWarehouse.getId(); String warehouseName = baseWarehouse.getWarehouseName(); LWhFormTransfer lWhFormTransfer = new LWhFormTransfer(id); lWhFormTransfer.setOutWarehouseId(wareHouseId); lWhFormTransfer.setOutWarehouseName(warehouseName); lWhFormTransferService.update(lWhFormTransfer); lWhFormTransferCoreService.doTransferOutPut(id, getCurrentUser()); return ResponseValue.success(); } /** * @Description 导出调拨出库单 * @Author 卢庆阳 * @Date 2023/10/31 */ @GetMapping("/export") public ResponseValue export(Long id) { if (id == null) { return ResponseValue.error("调拨单id为空"); } LWhFormOutputVo vo = this.lWhFormTransferService.export(id, this.getCurrentUser()); return ResponseValue.success(vo); } /** * 部门物品分发列表明细 * * @param transferQry * @return */ @ApiOperation(value = "部门物品分发列表明细", notes = "部门物品分发列表明细") @ApiImplicitParams({ @ApiImplicitParam(name = "transferQryDto", value = "调拨单查询条件", required = true) }) @GetMapping("/department/list") public ResponseValue departmentTransferList(TransferQry transferQry) { S_user_core currentUser = this.getCurrentUser(); if (currentUser == null) { return ResponseValue.error("登录用户信息不存在"); } GenericPager> transferInfoDetailsVoGenericPager = this.lWhFormTransferService.queryTransferInfo(transferQry); return ResponseValue.success(transferInfoDetailsVoGenericPager); } /** * 部门物品使用记录 * * @param procureModelInfoDto * @return */ @PostMapping("/useInfo/update") public ResponseValue infoUpdate(@RequestBody List procureModelInfoDto) { S_user_core currentUser = this.getCurrentUser(); if (currentUser == null) { return ResponseValue.error("登录用户信息不存在"); } if (CollectionUtils.isEmpty(procureModelInfoDto)) { return ResponseValue.error("参数错误"); } for (ProcureModelInfoDto procureModelInfo : procureModelInfoDto) { String transferOrderId = procureModelInfo.getTransferOrderId(); String baseGoodModelId = procureModelInfo.getBaseGoodModelId(); LWhProcureModel lWhProcureModel = new LWhProcureModel(); lWhProcureModel.setBusinessId(Long.valueOf(transferOrderId)); lWhProcureModel.setBaseGoodsModelsId(Long.valueOf(baseGoodModelId)); // 部门分发 lWhProcureModel.setBusinessType(4); List lWhProcureModelList = lWhProcureModelService.select(lWhProcureModel); lWhProcureModelList.forEach(item -> { Long id = item.getId(); LWhProcureModelUser lWhProcureModelUser = new LWhProcureModelUser(); lWhProcureModelUser.setWhProcureModelId(id); List procureModelUserList = lWhProcureModelUserService.select(lWhProcureModelUser); procureModelUserList.forEach(procureModelUser -> { procureModelUser.setNowUserName(procureModelInfo.getUserName()); procureModelUser.setNowUserPhone(procureModelInfo.getPhone()); LWhProcureModelUserRecord lWhProcureModelUserRecord = new LWhProcureModelUserRecord(); lWhProcureModelUserRecord.setId(IdUtil.generateId()); lWhProcureModelUserRecord.setTransBusinessId(Long.valueOf(transferOrderId)); FinSysTenantUser sysInfo = getSysInfo(); lWhProcureModelUserRecord.setOperatorId(sysInfo.getId()); lWhProcureModelUserRecord.setOperatorName(sysInfo.getUserName()); lWhProcureModelUserRecord.setDealTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); lWhProcureModelUserRecordService.insert(lWhProcureModelUserRecord); }); lWhProcureModelUserService.updateBatch(procureModelUserList); }); } return ResponseValue.success(); } /** * 部门物品使用记录 * * @param transferOrderId * @return */ @GetMapping("/use/record") public ResponseValue useRecord(Long transferOrderId) { S_user_core currentUser = this.getCurrentUser(); if (currentUser == null) { return ResponseValue.error("登录用户信息不存在"); } LWhProcureModelUserRecord lWhProcureModelUserRecord = new LWhProcureModelUserRecord(); lWhProcureModelUserRecord.setTransBusinessId(transferOrderId); List modelUserRecords = lWhProcureModelUserRecordService.select(lWhProcureModelUserRecord); List result = Lists.newArrayList(); for (LWhProcureModelUserRecord item : modelUserRecords) { Long id = item.getId(); UseRecordDto useRecordDto = new UseRecordDto(); useRecordDto.setId(id); useRecordDto.setUpdateUserName(item.getOperatorName()); useRecordDto.setUpdateTime(DateUtils.toShowDate(item.getDealTime())); LWhProcureModelUser lWhProcureModelUser = new LWhProcureModelUser(); lWhProcureModelUser.setWhProcureModelId(id); List procureModelUserList = lWhProcureModelUserService.select(lWhProcureModelUser); List recordSkuDtoList = Lists.newArrayList(); procureModelUserList.forEach(procureModelUser -> { UseRecordSkuDto useRecordSkuDto = new UseRecordSkuDto(); BaseGoodsModels baseGoodsModels = new BaseGoodsModels(); baseGoodsModels.setId(procureModelUser.getBaseGoodsModelsId()); BaseGoodsModels baseGoodsModel = baseGoodsModelsService.getByModelNameAndGoodsTemplatesId(baseGoodsModels); String unit = baseGoodsModel.getUnit(); useRecordSkuDto.setBaseUnit(unit); useRecordSkuDto.setBaseGoodModelName(baseGoodsModel.getModelName()); useRecordSkuDto.setCount(procureModelUser.getGoodsNum()); useRecordSkuDto.setPhone(procureModelUser.getNowUserPhone()); useRecordSkuDto.setUserName(procureModelUser.getNowUserName()); recordSkuDtoList.add(useRecordSkuDto); }); useRecordDto.setRecordSkuDtoList(recordSkuDtoList); } return ResponseValue.success(result); } @ApiOperation(value = "查询部门下的分发单", notes = "查询部门下的分发单") @ApiImplicitParams({ @ApiImplicitParam(name = "agencyId", value = "机构id", required = true, dataType = "Long", paramType = "query") }) @GetMapping("/query/detail") public ResponseValue queryDepartmentTransferOrder(Long agencyId) { TransferInfoVO transferInfoVO = new TransferInfoVO(); return ResponseValue.success(transferInfoVO); } }