package com.huaheng.pc.config.station.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.huaheng.common.constant.QuantityConstant; import com.huaheng.common.support.Convert; import com.huaheng.common.utils.StringUtils; import com.huaheng.common.utils.Wrappers; import com.huaheng.common.utils.security.ShiroUtils; import com.huaheng.framework.aspectj.lang.annotation.Log; import com.huaheng.framework.aspectj.lang.constant.BusinessType; import com.huaheng.framework.web.controller.BaseController; import com.huaheng.framework.web.domain.AjaxResult; import com.huaheng.framework.web.page.PageDomain; import com.huaheng.framework.web.page.TableDataInfo; import com.huaheng.framework.web.page.TableSupport; import com.huaheng.pc.config.container.domain.Container; import com.huaheng.pc.config.container.service.ContainerService; import com.huaheng.pc.config.containerType.domain.ContainerType; import com.huaheng.pc.config.containerType.service.ContainerTypeService; import com.huaheng.pc.config.location.domain.Location; import com.huaheng.pc.config.location.service.LocationService; import com.huaheng.pc.config.station.domain.Station; import com.huaheng.pc.config.station.domain.StationType; import com.huaheng.pc.config.station.service.StationService; import com.huaheng.pc.inventory.inventoryHeader.domain.InventoryHeader; import com.huaheng.pc.inventory.inventoryHeader.service.InventoryHeaderService; import io.swagger.annotations.ApiParam; import org.apache.shiro.authz.annotation.RequiresPermissions; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.util.*; /** * Created by Enzo Cotter on 2019/10/14. */ @Controller @RequestMapping("/config/station") public class StationLkController extends BaseController { @Resource private StationService stationService; @Resource private ContainerService containerService; @Resource private LocationService locationService; @Resource private InventoryHeaderService inventoryHeaderService; @Resource private ContainerTypeService containerTypeService; private String prefix = "config/station"; @RequiresPermissions("config:station:view") @GetMapping() public String station() { return prefix + "/station"; } @PostMapping("/getStationByCode") @ResponseBody public AjaxResult<Station> getStationByCode(String code){ LambdaQueryWrapper<Station> lambdaQueryWrapper = Wrappers.lambdaQuery(); lambdaQueryWrapper.eq(Station::getCode, code) .orderByDesc(Station::getType) .last("limit 1"); Station station = stationService.getOne(lambdaQueryWrapper); return AjaxResult.success(station); } /** * 查询出库类型 */ @RequiresPermissions("config:station:list") @Log(title = "配置-站台",operating = "站台列表", action = BusinessType.GRANT) @PostMapping("/list") @ResponseBody public TableDataInfo list(@ApiParam(name="station",value="编码、名称") Station station, @ApiParam(name = "createdBegin", value = "起止时间") String createdBegin, @ApiParam(name = "createdEnd", value = "结束时间") String createdEnd) { LambdaQueryWrapper<Station> lambdaQueryWrapper = Wrappers.lambdaQuery(); PageDomain pageDomain = TableSupport.buildPageRequest(); Integer pageNum = pageDomain.getPageNum(); Integer pageSize = pageDomain.getPageSize(); lambdaQueryWrapper.gt(StringUtils.isNotEmpty(createdBegin), Station::getCreated, createdBegin) .lt(StringUtils.isNotEmpty(createdEnd), Station::getCreated, createdEnd) .eq(StringUtils.isNotEmpty(station.getCode()), Station::getCode, station.getCode()) .like(StringUtils.isNotEmpty(station.getName()), Station::getName, station.getName()) .eq(StringUtils.isNotEmpty(station.getType()), Station::getType, station.getType()) .eq(Station::getWarehouseCode, ShiroUtils.getWarehouseCode()); if (StringUtils.isNotNull(pageNum) && StringUtils.isNotNull(pageSize)){ /*使用分页查询*/ Page<Station> page = new Page<>(pageNum, pageSize); IPage<Station> iPage = stationService.page(page, lambdaQueryWrapper); return getMpDataTable(iPage.getRecords(), iPage.getTotal()); } else { List<Station> list = stationService.list(lambdaQueryWrapper); return getDataTable(list); } } /** * 新增站台 */ @GetMapping("/add") public String add() { return prefix + "/add"; } /** * 新增保存站台 */ @RequiresPermissions("config:station:add") @Log(title = "配置-站台",operating = "新增站台", action = BusinessType.INSERT) @PostMapping("/add") @ResponseBody public AjaxResult addSave(Station station) { station.setWarehouseCode(ShiroUtils.getWarehouseCode()); return toAjax(stationService.save(station)); } /** * 修改站台 */ @GetMapping("/edit/{id}") public String edit(@PathVariable("id") Integer id, ModelMap mmap) { Station station = stationService.getById(id); mmap.put("station", station); return prefix + "/edit"; } /** * 修改保存站台 */ @RequiresPermissions("config:station:edit") @Log(title = "配置-站台",operating = "修改站台", action = BusinessType.UPDATE) @PostMapping("/edit") @ResponseBody public AjaxResult editSave(Station station) { station.setLastUpdatedBy(ShiroUtils.getLoginName()); return toAjax(stationService.updateById(station)); } /** * 删除出库 */ @RequiresPermissions("config:station:remove") @Log(title = "配置-站台",operating = "删除站台", action = BusinessType.DELETE) @PostMapping( "/remove") @ResponseBody public AjaxResult remove(String ids) { if (StringUtils.isEmpty(ids)) { return AjaxResult.error("id不能为空"); } List<Integer> list = new ArrayList<>(Arrays.asList(Convert.toIntArray(ids))); return toAjax(stationService.removeByIds(list)); } @PostMapping("/getData") @ResponseBody public Map<String, Object> getData() { LambdaQueryWrapper<Station> queryWrapper = Wrappers.lambdaQuery(); queryWrapper.ne(Station::getType, 1); List<Station> stationList = stationService.list(queryWrapper); List<Map<String, Object>> list = new ArrayList<>(); for (Station station : stationList) { Map<String, Object> resultMap = new HashMap<>(); resultMap.put("id", station.getCode()); resultMap.put("text", station.getName()); list.add(resultMap); } Map<String, Object> map = new HashMap<>(); map.put("results", list); return map; } @PostMapping("/getStationFromType") @ResponseBody public Map<String, Object> getStationFromType(StationType stationType) { String containerCode = stationType.getContainerCode(); int type = Integer.parseInt(stationType.getType()); Container container = containerService.getContainerByCode(containerCode); ContainerType containerType = containerTypeService.getContainerTypeByCode(container.getContainerType(), container.getWarehouseCode()); Map<String, Object> map = new HashMap<>(); if(container == null) { return map; } String locationCode = container.getLocationCode(); if(StringUtils.isEmpty(locationCode)) { return map; } Integer roadway = containerType.getRoadway(); if(StringUtils.isNull(roadway)) { return map; } Location location1 = locationService.getOne(new LambdaQueryWrapper<Location>().eq(Location::getCode, locationCode).eq(Location::getWarehouseCode, ShiroUtils.getWarehouseCode())); if(location1 == null) { return map; } LambdaQueryWrapper<Station> queryWrapper = Wrappers.lambdaQuery(); if(type == QuantityConstant.STATION_PICK_AND_OUT) { queryWrapper.in(Station::getType, QuantityConstant.STATION_OUT, QuantityConstant.STATION_PICK); } else { queryWrapper.eq(Station::getType, type); } queryWrapper.eq(StringUtils.isNotEmpty(location1.getArea()),Station::getArea, location1.getArea()); queryWrapper.eq(Station::getRoadway, roadway); List<Station> stationList = stationService.list(queryWrapper); List<Map<String, Object>> list = new ArrayList<>(); for (Station station : stationList) { Map<String, Object> resultMap = new HashMap<>(); resultMap.put("id", station.getCode()); resultMap.put("text", station.getName()); list.add(resultMap); } map.put("results", list); return map; } @PostMapping("/getStationFromInventory") @ResponseBody public Map<String, Object> getStationFromInventory(String ids) { Map<String, Object> map = new HashMap<>(); InventoryHeader inventoryHeader = inventoryHeaderService.getById(ids); if(inventoryHeader == null) { return map; } String containerCode = inventoryHeader.getContainerCode(); Container container = containerService.getContainerByCode(containerCode); if(container == null) { return map; } ContainerType containerType = containerTypeService.getContainerTypeByCode(container.getContainerType(), container.getWarehouseCode()); if(containerType == null) { return map; } String locationCode = container.getLocationCode(); if(StringUtils.isEmpty(locationCode)) { return map; } LambdaQueryWrapper<Location> locationLambdaQueryWrapper = Wrappers.lambdaQuery(); locationLambdaQueryWrapper.eq(Location::getCode, locationCode) .eq(Location::getWarehouseCode, ShiroUtils.getWarehouseCode()); Location location1 = locationService.getOne(locationLambdaQueryWrapper); if(location1 == null) { return map; } LambdaQueryWrapper<Station> queryWrapper = Wrappers.lambdaQuery(); queryWrapper.eq(Station::getType, QuantityConstant.STATION_PICK); queryWrapper.eq(Station::getArea, location1.getArea()); queryWrapper.eq(StringUtils.isNotNull(containerType.getRoadway()),Station::getRoadway, containerType.getRoadway());//新增巷道字段判断出入口 容器固定在不同巷道 可通过容器类型的巷道判断 List<Station> stationList = stationService.list(queryWrapper); List<Map<String, Object>> list = new ArrayList<>(); for (Station station : stationList) { Map<String, Object> resultMap = new HashMap<>(); resultMap.put("id", station.getCode()); resultMap.put("text", station.getName()); list.add(resultMap); } map.put("results", list); return map; } }