李林
2023-10-07 658d4927d468c47208fd012d9128b09249c07eff
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
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
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
package com.chinaztt.mes.plan.controller;
 
import cn.hutool.core.collection.CollectionUtil;
import com.alibaba.excel.EasyExcel;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.chinaztt.mes.basic.service.IfsLogService;
import com.chinaztt.mes.common.wrapper.QueryWrapperUtil;
import com.chinaztt.mes.plan.dto.ManufacturingOrderDTO;
import com.chinaztt.mes.plan.dto.MoStructureComponentDTO;
import com.chinaztt.mes.plan.dto.UploadRefreshIfsOrderNoResultDTO;
import com.chinaztt.mes.plan.entity.ManufacturingOrderOperationTemplate;
import com.chinaztt.mes.plan.excel.ManufacturingOderUploadData;
import com.chinaztt.mes.plan.excel.ManufacturingOrderUploadListener;
import com.chinaztt.mes.plan.service.ManufacturingOrderService;
import com.chinaztt.ztt.common.core.util.R;
import com.chinaztt.ztt.common.log.annotation.SysLog;
import com.chinaztt.ztt.common.security.annotation.Inner;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
 
import javax.servlet.http.HttpServletResponse;
import javax.validation.Valid;
import javax.validation.constraints.NotNull;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
 
 
/**
 * 制造订单表
 *
 * @author cxf
 * @date 2020-09-24 14:26:01
 */
@RestController
@AllArgsConstructor
@RequestMapping("/plan/manufacturingOrder")
@Api(value = "manufacturingOrder", tags = "制造订单表管理")
@Slf4j
public class ManufacturingOrderController {
 
    private final ManufacturingOrderService manufacturingOrderService;
 
    private IfsLogService ifsLogService;
 
    /**
     * 分页查询
     *
     * @param page                  分页对象
     * @param manufacturingOrderDTO 制造订单表
     * @return
     */
    @ApiOperation(value = "分页查询", notes = "分页查询")
    @GetMapping("/page")
    @PreAuthorize("@pms.hasPermission('plan_manufacturingorder_view')")
    public R getManufacturingOrderPage(Page page, ManufacturingOrderDTO manufacturingOrderDTO) {
        List<Long> list = new ArrayList<>();
        if (CollectionUtil.isNotEmpty(manufacturingOrderDTO.getCustomerList())) {
            list = manufacturingOrderDTO.getCustomerList();
        }
        return R.ok(manufacturingOrderService.getManufacturingOrderPage(page, QueryWrapperUtil.gen(manufacturingOrderDTO), list));
    }
 
    /**
     * 车间订单导出
     *
     * @return
     */
    @ApiOperation(value = "车间订单导出", notes = "车间订单导出")
    @GetMapping("/export")
    public void export(HttpServletResponse response, ManufacturingOrderDTO manufacturingOrderDTO) throws IOException {
        List<Long> list = new ArrayList<>();
        if (CollectionUtil.isNotEmpty(manufacturingOrderDTO.getCustomerList())) {
            list = manufacturingOrderDTO.getCustomerList();
        }
        manufacturingOrderService.export(response, QueryWrapperUtil.gen(manufacturingOrderDTO),list);
    }
 
    /**
     * 分页查询制造订单报表
     *
     * @param page                  分页查询制造订单报表
     * @param manufacturingOrderDTO 分页查询制造订单报表
     * @return
     */
    @ApiOperation(value = "分页查询制造订单报表", notes = "分页查询制造订单报表")
    @GetMapping("/statementPage")
    public R getStatementPage(Page page, ManufacturingOrderDTO manufacturingOrderDTO) {
        return R.ok(manufacturingOrderService.getStatementPage(page, QueryWrapperUtil.gen(manufacturingOrderDTO)));
    }
 
    /**
     * @param page
     * @param manufacturingOrderDTO
     * @return
     */
    @ApiOperation(value = "分页查询未排产制造订单", notes = "分页查询未排产制造订单")
    @GetMapping("/apsPage")
    @PreAuthorize("@pms.hasPermission('plan_manufacturingorder_view')")
    public R getApsManufacturingOrderPage(Page page, ManufacturingOrderDTO manufacturingOrderDTO) {
        List<Long> list = new ArrayList<>();
        if (CollectionUtil.isNotEmpty(manufacturingOrderDTO.getCustomerList())) {
            list = manufacturingOrderDTO.getCustomerList();
        }
        manufacturingOrderDTO.setPlanned(false);
        return R.ok(manufacturingOrderService.getManufacturingOrderPage(page, QueryWrapperUtil.gen(manufacturingOrderDTO), list));
    }
 
    /**
     * 通过id查询制造订单表
     *
     * @param id id
     * @return R
     */
    @ApiOperation(value = "通过id查询", notes = "通过id查询")
    @GetMapping("/{id}")
    @PreAuthorize("@pms.hasPermission('plan_manufacturingorder_view')")
    public R getById(@PathVariable("id") Long id) {
        return R.ok(manufacturingOrderService.selectById(id));
    }
 
    /**
     * 根据零件判断是否存在工艺路线/工艺结构
     *
     * @param partId partId
     * @return R
     */
    @ApiOperation(value = "根据零件判断是否存在工艺路线/工艺结构", notes = "根据零件判断是否存在工艺路线/工艺结构")
    @GetMapping("/checkPart/{partId}/{workshopTypeCode}")
    public R checkPart(@PathVariable("partId") Long partId, @PathVariable("workshopTypeCode") String workshopTypeCode) {
        return R.ok(manufacturingOrderService.checkPart(partId, workshopTypeCode));
    }
 
    /**
     * 新增制造订单表
     *
     * @param manufacturingOrderDTO 制造订单表
     * @return R
     */
    @ApiOperation(value = "新增制造订单表", notes = "新增制造订单表")
    @SysLog("新增制造订单表")
    @PostMapping
    @PreAuthorize("@pms.hasPermission('plan_manufacturingorder_add')")
    public R save(@RequestBody ManufacturingOrderDTO manufacturingOrderDTO) {
        return manufacturingOrderService.fullSave(manufacturingOrderDTO);
    }
 
    /**
     * 从主计划新增车间订单
     *
     * @param manufacturingOrderDTO 制造订单表
     * @return R
     */
    @ApiOperation(value = "从主计划新增车间订单", notes = "从主计划新增车间订单")
    @SysLog("从主计划新增车间订单")
    @PostMapping("/saveFromSchdule")
    public R saveFromSchdule(@RequestBody ManufacturingOrderDTO manufacturingOrderDTO) {
        return manufacturingOrderService.fullSave(manufacturingOrderDTO);
    }
 
    /**
     * 修改制造订单表
     *
     * @param manufacturingOrderDTO 制造订单表
     * @return R
     */
    @ApiOperation(value = "修改制造订单表", notes = "修改制造订单表")
    @SysLog("修改制造订单表")
    @PutMapping
    @PreAuthorize("@pms.hasPermission('plan_manufacturingorder_edit')")
    public R updateById(@RequestBody ManufacturingOrderDTO manufacturingOrderDTO) {
        return manufacturingOrderService.updateDtoById(manufacturingOrderDTO);
    }
 
    /**
     * 通过id删除制造订单表
     *
     * @param id id
     * @return R
     */
    @ApiOperation(value = "通过id删除制造订单表", notes = "通过id删除制造订单表")
    @SysLog("通过id删除制造订单表")
    @DeleteMapping("/{id}")
    @PreAuthorize("@pms.hasPermission('plan_manufacturingorder_del')")
    public R removeById(@PathVariable Long id) {
        return R.ok(manufacturingOrderService.removeById(id));
    }
 
    /**
     * 状态变更
     *
     * @param ids
     * @return R
     */
    @ApiOperation(value = "状态变更", notes = "状态变更")
    @SysLog("状态变更")
    @PostMapping("/changeState/{event}")
    public R changeMarkPlanned(@RequestBody List<Long> ids, @PathVariable String event) {
        return R.ok(manufacturingOrderService.changeState(ids, event));
    }
 
    /**
     * 根据制造订单id和工艺id校验该制造订单对应的工艺是否一致
     *
     * @param manufacturingOrderDTO 制造订单表
     * @return
     */
    @ApiOperation(value = "根据制造订单id和工艺id校验该制造订单对应的工艺是否一致", notes = "根据制造订单id和工艺id校验该制造订单对应的工艺是否一致")
    @GetMapping("/checkout")
    public R checkoutManufacturingOrder(ManufacturingOrderDTO manufacturingOrderDTO) {
        return R.ok(manufacturingOrderService.checkoutManufacturingOrder(manufacturingOrderDTO));
    }
 
    /**
     * 根据工艺id和工序id获取复制的工序模板
     *
     * @param manufacturingOrderDTO 制造订单表
     * @return
     */
    @ApiOperation(value = "根据工艺id和工序id获取复制的工序模板", notes = "根据工艺id和工序id获取复制的工序模板")
    @GetMapping("/planRoutingOperationTemplate")
    public R getOperationTemplate(ManufacturingOrderDTO manufacturingOrderDTO) {
        return R.ok(manufacturingOrderService.getOperationTemplate(manufacturingOrderDTO));
    }
 
    /**
     * 根据复制工序模板的id删除工序模板
     *
     * @param id id
     * @return R
     */
    @ApiOperation(value = "根据复制工序模板的id删除工序模板", notes = "根据复制工序模板的id删除工序模板")
    @SysLog("根据复制工序模板的id删除工序模板")
    @DeleteMapping("/deleteRoutingTemplate/{id}")
    public R deleteRoutingTemplate(@PathVariable Long id) {
        return R.ok(manufacturingOrderService.deleteRoutingTemplate(id));
    }
 
    /**
     * 修改制造订单模板
     *
     * @param manufacturingOrderOperationTemplate 修改制造订单模板
     * @return R
     */
    @ApiOperation(value = "修改制造订单模板", notes = "修改制造订单模板")
    @SysLog("修改制造订单模板")
    @PutMapping("updateTemplate")
    public R updateTemplate(@RequestBody ManufacturingOrderOperationTemplate manufacturingOrderOperationTemplate) {
        return R.ok(manufacturingOrderService.updateTemplate(manufacturingOrderOperationTemplate));
    }
 
    /**
     * 根据工艺工序id关联添加工序模板
     *
     * @param manufacturingOrderDTO
     * @return
     */
    @ApiOperation(value = "根据工艺工序id关联添加工序模板", notes = "根据工艺工序id关联添加工序模板")
    @PostMapping("/addRoutingTemplate")
    public R addOperationTemplate(@RequestBody ManufacturingOrderDTO manufacturingOrderDTO) {
        return R.ok(manufacturingOrderService.addOperationTemplate(manufacturingOrderDTO));
    }
 
    /**
     * 根据工艺工序id和工序模板id获取工序参数
     *
     * @param manufacturingOrderDTO 制造订单表
     * @return
     */
    @ApiOperation(value = "根据工艺工序id和工序模板id获取工序参数", notes = "根据工艺工序id和工序模板id获取工序参数")
    @GetMapping("/planRoutingOperationTemplateParam")
    public R getOperationTemplateParam(ManufacturingOrderDTO manufacturingOrderDTO) {
        return R.ok(manufacturingOrderService.getOperationTemplateParam(manufacturingOrderDTO));
    }
 
    /**
     * 根据复制工序参数的id删除工序参数
     *
     * @param id id
     * @return R
     */
    @ApiOperation(value = "根据复制工序参数的id删除工序参数", notes = "根据复制工序参数的id删除工序参数")
    @SysLog("根据复制工序参数的id删除工序参数")
    @DeleteMapping("/deleteRoutingTemplateParam/{id}")
    public R deleteRoutingTemplateParam(@PathVariable Long id) {
        return R.ok(manufacturingOrderService.deleteRoutingTemplateParam(id));
    }
 
    /**
     * 根据工艺工序id和工序模板id关联添加工序参数
     *
     * @param manufacturingOrderDTO
     * @return
     */
    @ApiOperation(value = "根据工艺工序id和工序模板id关联添加工序参数", notes = "根据工艺工序id和工序模板id关联添加工序参数")
    @PostMapping("/addRoutingTemplateParam")
    public R addOperationTemplateParam(@RequestBody ManufacturingOrderDTO manufacturingOrderDTO) {
        return R.ok(manufacturingOrderService.addOperationTemplateParam(manufacturingOrderDTO));
    }
 
    /**
     * 工序参数的参数值的修改
     *
     * @param manufacturingOrderDTO 工艺
     * @return R
     */
    @ApiOperation(value = "工序参数的参数值的修改", notes = "工序参数的参数值的修改")
    @SysLog("工序参数的参数值的修改")
    @PutMapping("routingTemplateParam")
    public R updateRoutingTemplateParamById(@RequestBody ManufacturingOrderDTO manufacturingOrderDTO) {
        return R.ok(manufacturingOrderService.updateRoutingTemplateParamById(manufacturingOrderDTO));
    }
 
    /**
     * bom切换,查询相关信息
     *
     * @param bomId
     * @return
     */
    @GetMapping("/bomSelectChange/{bomId}")
    public R bomSelectChange(@PathVariable Long bomId) {
        return R.ok(manufacturingOrderService.bomSelectChange(bomId));
    }
 
    /**
     * 通过制造订单id查询客户订单
     *
     * @param id id
     * @return R
     */
    @ApiOperation(value = "通过制造订单id查询客户订单", notes = "通过制造订单id查询客户订单")
    @GetMapping("/getCustomer/{id}")
    public R getCustomer(@PathVariable("id") Long id) {
        return R.ok(manufacturingOrderService.getCustomer(id));
    }
 
    /**
     * 通过制造订单id和零件id找到产出所需数量
     *
     * @param id     制造订单id
     * @param partId 零件id
     * @return
     */
    @ApiOperation(value = "通过制造订单id和零件id找到产出所需数量")
    @GetMapping("/getQpaNumber")
    public R getQpaNumber(@Valid @NotNull Long id, @Valid @NotNull Long partId) {
        return R.ok(manufacturingOrderService.getQpaNumber(id, partId));
    }
 
    /**
     * ifs查询车间订单申请
     *
     * @param manufacturingOrderDTO partNo           零件编号
     *                              partName         零件描述
     *                              workshopTypeCode 车间订单类型
     *                              state            状态
     *                              createUser       计划人
     * @return
     */
    @ApiOperation(value = "ifs查询车间订单申请")
    @GetMapping("/queryShopOrderReqStd")
    public R queryShopOrderReqStd(ManufacturingOrderDTO manufacturingOrderDTO) {
        return manufacturingOrderService.queryShopOrderReqStd(manufacturingOrderDTO);
    }
 
    /**
     * ifs车间订单更新/新增接口
     *
     * @param ids
     * @return
     */
    @ApiOperation(value = "ifs车间订单更新/新增接口")
    @PostMapping("/importShopOrderStd")
    public R importShopOrderStd(@RequestBody List<Long> ids) {
        return manufacturingOrderService.importShopOrderStd(ids);
    }
 
 
    /**
     * ifs车间订单物料更新
     *
     * @param ids
     * @return
     */
    @ApiOperation(value = "ifs车间订单物料更新")
    @PostMapping("/modifyShopMaterialAllocStd")
    public R modifyShopMaterialAllocStd(@RequestBody List<Long> ids) {
        return manufacturingOrderService.modifyShopMaterialAllocStd(ids);
    }
 
    /**
     * ifs车间订单工序更新
     *
     * @param ids
     * @return
     */
    @ApiOperation(value = "ifs车间订单工序更新")
    @PostMapping("/modifyShopOperationStd")
    public R modifyShopOperationStd(@RequestBody List<Long> ids) {
        return manufacturingOrderService.modifyShopOperationStd(ids);
    }
 
 
    /**
     * 批量创建车间订单
     *
     * @param manufacturingOrderDTOS
     * @return
     */
    @ApiOperation(value = "批量创建车间订单")
    @PostMapping("/addBatch")
    public R addBatch(@RequestBody List<ManufacturingOrderDTO> manufacturingOrderDTOS) {
        return manufacturingOrderService.addBatch(manufacturingOrderDTOS);
    }
 
 
    /**
     * 车间订单BOM修改
     *
     * @param moStructureComponentDTO
     * @return
     */
    @ApiOperation(value = "车间订单BOM修改")
    @PutMapping("/updateMoBom")
    public R updateMoBom(@RequestBody MoStructureComponentDTO moStructureComponentDTO) {
        return R.ok(manufacturingOrderService.updateMoBom(moStructureComponentDTO));
    }
 
    /**
     * 删除车间订单bom节点
     *
     * @param id
     * @return
     */
    @ApiOperation(value = "删除车间订单")
    @DeleteMapping("/delMoBom/{id}")
    public R delMoBom(@PathVariable("id") Long id) {
        return R.ok(manufacturingOrderService.delMoBom(id));
    }
 
    /**
     * 新增车间订单bom节点
     *
     * @param moStructureComponent bom节点
     * @return
     */
    @ApiOperation(value = "新增车间订单bom节点")
    @PostMapping("/addMoBomCompont")
    public R addMoBomCompont(@RequestBody MoStructureComponentDTO moStructureComponent) {
        return R.ok(manufacturingOrderService.addMoBomCompont(moStructureComponent));
    }
 
    /**
     * 判断车间订单是否可以合并
     *
     * @param ids bom节点
     * @return
     */
    @ApiOperation(value = "判断车间订单是否可以合并")
    @PostMapping("/mergeCheck")
    public R mergeCheck(@RequestBody List<Long> ids) {
        return R.ok(manufacturingOrderService.mergeCheck(ids));
    }
 
    /**
     * 后台拼接合并车间订单
     *
     * @param id  目标订单id
     * @param ids 被合并订单id
     * @return
     */
    @ApiOperation(value = "订单合并数据")
    @PostMapping("/mergeOrder/{id}")
    public R mergeOrder(@PathVariable("id") Long id, @RequestBody List<Long> ids) {
        return R.ok(manufacturingOrderService.mergeOrder(id, ids));
    }
 
    /**
     * 合并后的车间订单
     *
     * @return
     */
    @PostMapping("/mergeUpdate")
    public R mergeUpdate(@RequestBody ManufacturingOrderDTO manufacturingOrderDTO) {
        return R.ok(manufacturingOrderService.mergeUpdate(manufacturingOrderDTO));
    }
 
    /**
     * 月结拆单后,更新车间订单和ifs缓存中的ifs订单号
     * @return
     */
    @PostMapping("/refreshIfsOrderNo")
    public R refreshIfsOrderNo() {
        try {
            manufacturingOrderService.refreshIfsOrderNo();
        } catch (Exception e) {
            log.error(e.getMessage(), e);
        }
        manufacturingOrderService.refreshIfsLogOrderNo();
        return R.ok();
    }
 
    @Inner(value = false)
    @PostMapping("/uploadRefreshIfsOrderNo")
    @ApiOperation(value = "上传文件更新月结ifs订单号")
    public R uploadRefreshIfsOrderNo(@RequestParam("file") MultipartFile file) {
        try {
            List<UploadRefreshIfsOrderNoResultDTO> resultDTOList = new ArrayList<>();
            EasyExcel.read(file.getInputStream(), ManufacturingOderUploadData.class,
                    new ManufacturingOrderUploadListener(manufacturingOrderService, resultDTOList)).sheet().doRead();
            manufacturingOrderService.refreshIfsLogOrderNo();
            return R.ok(resultDTOList);
        } catch (Exception e) {
            log.error(e.getMessage(), e);
            return R.failed(e.getMessage());
        }
    }
}