Blame view

src/main/java/com/huaheng/pc/config/station/controller/StationLkController.java 14.6 KB
1
2
3
4
5
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;
6
import com.huaheng.common.constant.QuantityConstant;
7
8
import com.huaheng.common.support.Convert;
import com.huaheng.common.utils.StringUtils;
周鸿 authored
9
import com.huaheng.common.utils.Wrappers;
10
11
12
13
14
15
16
17
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;
游杰 authored
18
19
import com.huaheng.pc.config.container.domain.Container;
import com.huaheng.pc.config.container.service.ContainerService;
tongzhonghao authored
20
21
import com.huaheng.pc.config.containerType.domain.ContainerType;
import com.huaheng.pc.config.containerType.service.ContainerTypeService;
游杰 authored
22
23
import com.huaheng.pc.config.location.domain.Location;
import com.huaheng.pc.config.location.service.LocationService;
24
import com.huaheng.pc.config.station.domain.Station;
游杰 authored
25
import com.huaheng.pc.config.station.domain.StationType;
26
import com.huaheng.pc.config.station.service.StationService;
游杰 authored
27
28
import com.huaheng.pc.inventory.inventoryHeader.domain.InventoryHeader;
import com.huaheng.pc.inventory.inventoryHeader.service.InventoryHeaderService;
29
30
import io.swagger.annotations.ApiParam;
import org.apache.shiro.authz.annotation.RequiresPermissions;
31
import org.junit.Test;
32
33
34
35
36
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
游杰 authored
37
import java.util.*;
38
39
40
41
42
43

/**
 * Created by Enzo Cotter on 2019/10/14.
 */
@Controller
@RequestMapping("/config/station")
周鸿 authored
44
public class StationLkController extends BaseController {
45
46
47

    @Resource
    private StationService stationService;
游杰 authored
48
49
50
51
52
53
    @Resource
    private ContainerService containerService;
    @Resource
    private LocationService locationService;
    @Resource
    private InventoryHeaderService inventoryHeaderService;
tongzhonghao authored
54
55
    @Resource
    private ContainerTypeService containerTypeService;
56
57
58
59
60
61
62
63
64

    private String prefix = "config/station";

    @RequiresPermissions("config:station:view")
    @GetMapping()
    public String station() {
        return prefix + "/station";
    }
65
66
    @PostMapping("/getStationByCode")
    @ResponseBody
67
    public AjaxResult<Station> getStationByCode(String code) {
68
69
70
71
72
73
74
75
        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);
    }
76
77
78
79
    /**
     * 查询出库类型
     */
    @RequiresPermissions("config:station:list")
80
    @Log(title = "配置-站台", operating = "站台列表", action = BusinessType.GRANT)
81
82
    @PostMapping("/list")
    @ResponseBody
83
    public TableDataInfo list(@ApiParam(name = "station", value = "编码、名称") Station station,
84
85
86
87
88
89
90
91
92
                              @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())
93
                .like(StringUtils.isNotEmpty(station.getName()), Station::getName, station.getName())
94
95
96
                .eq(StringUtils.isNotEmpty(station.getType()), Station::getType, station.getType())
                .eq(Station::getWarehouseCode, ShiroUtils.getWarehouseCode());
97
        if (StringUtils.isNotNull(pageNum) && StringUtils.isNotNull(pageSize)) {
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
            /*使用分页查询*/
            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")
120
    @Log(title = "配置-站台", operating = "新增站台", action = BusinessType.INSERT)
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
    @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")
142
    @Log(title = "配置-站台", operating = "修改站台", action = BusinessType.UPDATE)
143
144
145
146
147
148
149
150
151
152
153
    @PostMapping("/edit")
    @ResponseBody
    public AjaxResult editSave(Station station) {
        station.setLastUpdatedBy(ShiroUtils.getLoginName());
        return toAjax(stationService.updateById(station));
    }

    /**
     * 删除出库
     */
    @RequiresPermissions("config:station:remove")
154
155
    @Log(title = "配置-站台", operating = "删除站台", action = BusinessType.DELETE)
    @PostMapping("/remove")
156
157
158
159
160
161
162
163
164
    @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));
    }
游杰 authored
165
166
167
168
    @PostMapping("/getData")
    @ResponseBody
    public Map<String, Object> getData() {
        LambdaQueryWrapper<Station> queryWrapper = Wrappers.lambdaQuery();
169
        queryWrapper.ne(Station::getType, 1);
游杰 authored
170
171
172
173
174
175
176
177
178
179
180
181
182
        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;
    }
游杰 authored
183
184
游杰 authored
185
186
187
    @PostMapping("/getStationFromType")
    @ResponseBody
    public Map<String, Object> getStationFromType(StationType stationType) {
188
189
190
        String containerCode = stationType.getContainerCode();
        int type = Integer.parseInt(stationType.getType());
        Container container = containerService.getContainerByCode(containerCode);
tongzhonghao authored
191
        ContainerType containerType = containerTypeService.getContainerTypeByCode(container.getContainerType(), container.getWarehouseCode());
游杰 authored
192
        Map<String, Object> map = new HashMap<>();
193
        if (container == null) {
游杰 authored
194
195
196
            return map;
        }
        String locationCode = container.getLocationCode();
197
        if (StringUtils.isEmpty(locationCode)) {
游杰 authored
198
199
            return map;
        }
tongzhonghao authored
200
        Integer roadway = containerType.getRoadway();
201
        if (StringUtils.isNull(roadway)) {
tongzhonghao authored
202
203
            return map;
        }
204
205

        Location location1 = locationService.getOne(new LambdaQueryWrapper<Location>().eq(Location::getCode, locationCode).eq(Location::getWarehouseCode, ShiroUtils.getWarehouseCode()));
206
        if (location1 == null) {
游杰 authored
207
208
209
210
            return map;
        }

        LambdaQueryWrapper<Station> queryWrapper = Wrappers.lambdaQuery();
211
212
213
214
215
        if (type == QuantityConstant.STATION_PICK_AND_OUT) {
            queryWrapper.in(Station::getType,
                    QuantityConstant.STATION_OUT, QuantityConstant.STATION_PICK);
        }
        if (type == QuantityConstant.STATION_OUT) {
216
217
            queryWrapper.in(Station::getType,
                    QuantityConstant.STATION_OUT, QuantityConstant.STATION_PICK);
游杰 authored
218
        } else {
219
            queryWrapper.eq(Station::getType, type);
游杰 authored
220
        }
221
        queryWrapper.eq(StringUtils.isNotEmpty(location1.getArea()), Station::getArea, location1.getArea());
tongzhonghao authored
222
        queryWrapper.eq(Station::getRoadway, roadway);
游杰 authored
223
224
225
        List<Station> stationList = stationService.list(queryWrapper);

        List<Map<String, Object>> list = new ArrayList<>();
游杰 authored
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
        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);
241
        if (inventoryHeader == null) {
游杰 authored
242
243
244
            return map;
        }
        String containerCode = inventoryHeader.getContainerCode();
游杰 authored
245
        Container container = containerService.getContainerByCode(containerCode);
246
        if (container == null) {
游杰 authored
247
248
            return map;
        }
tongzhonghao authored
249
250

        ContainerType containerType = containerTypeService.getContainerTypeByCode(container.getContainerType(), container.getWarehouseCode());
251
        if (containerType == null) {
tongzhonghao authored
252
253
254
            return map;
        }
游杰 authored
255
        String locationCode = container.getLocationCode();
256
        if (StringUtils.isEmpty(locationCode)) {
游杰 authored
257
258
259
260
261
262
            return map;
        }
        LambdaQueryWrapper<Location> locationLambdaQueryWrapper = Wrappers.lambdaQuery();
        locationLambdaQueryWrapper.eq(Location::getCode, locationCode)
                .eq(Location::getWarehouseCode, ShiroUtils.getWarehouseCode());
        Location location1 = locationService.getOne(locationLambdaQueryWrapper);
263
        if (location1 == null) {
游杰 authored
264
265
266
267
            return map;
        }

        LambdaQueryWrapper<Station> queryWrapper = Wrappers.lambdaQuery();
268
        queryWrapper.eq(Station::getType, QuantityConstant.STATION_PICK);
游杰 authored
269
        queryWrapper.eq(Station::getArea, location1.getArea());
270
        queryWrapper.eq(StringUtils.isNotNull(containerType.getRoadway()), Station::getRoadway, containerType.getRoadway());//新增巷道字段判断出入口 容器固定在不同巷道 可通过容器类型的巷道判断
游杰 authored
271
272
273
274
275
276
277
278
279
280
281
282
        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;
    }
周鸿 authored
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319

    @PostMapping("/getStationByContainer")
    @ResponseBody
    public Map<String, Object> getStationByContainer(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 area=containerType.getArea();

        LambdaQueryWrapper<Station> queryWrapper = Wrappers.lambdaQuery();
        if (type == QuantityConstant.STATION_PICK_AND_OUT) {
            queryWrapper.in(Station::getType,
                    QuantityConstant.STATION_OUT, QuantityConstant.STATION_PICK);
        }
        if (type == QuantityConstant.STATION_OUT) {
            queryWrapper.in(Station::getType,
                    QuantityConstant.STATION_OUT, QuantityConstant.STATION_PICK);
        } else {
            queryWrapper.eq(Station::getType, type);
        }
        queryWrapper.eq(Station::getArea, area);
        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;
    }
320
321
322

    @PostMapping("/getStationByContainers")
    @ResponseBody
周鸿 authored
323
    public Map<String, Object> getStationByContainers(@RequestBody StationType stationType) {
324
        Map<String, Object> map = new HashMap<>();
325
        List<Station> stationList =  stationService.getStationByContainers(stationType.getContainerCode(),stationType.getType(),stationType.getStationType());
326
327
328
329
330
331
332
333
334
335
        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;
    }
周鸿 authored
336
337
338
339
    @PostMapping("/getStationByArea")
    @ResponseBody
    public Map<String, Object> getStationByArea(@RequestBody StationType stationType) {
        Map<String, Object> map = new HashMap<>();
周鸿 authored
340
        List<Station> stationList = stationService.getStationByArea(stationType.getArea(), stationType.getType(), stationType.getStationType(), stationType.getContainerCode());
周鸿 authored
341
342
343
344
345
346
347
348
349
350
        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;
    }
351
}