#
Junjie
2024-08-02 e83dacb5066a86db29dbdc232218d8aba6adc95f
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
package com.zy.asrs.wms.asrs.controller;
 
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.alibaba.fastjson.parser.Feature;
import com.alibaba.fastjson.serializer.SerializerFeature;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zy.asrs.framework.common.Cools;
import com.zy.asrs.framework.common.R;
import com.zy.asrs.wms.asrs.entity.MatField;
import com.zy.asrs.wms.asrs.entity.MatFieldValue;
import com.zy.asrs.wms.asrs.service.MatFieldService;
import com.zy.asrs.wms.asrs.service.MatFieldValueService;
import com.zy.asrs.wms.common.annotation.OperationLog;
import com.zy.asrs.wms.common.domain.BaseParam;
import com.zy.asrs.wms.common.domain.KeyValVo;
import com.zy.asrs.wms.common.domain.PageParam;
import com.zy.asrs.wms.asrs.entity.Mat;
import com.zy.asrs.wms.asrs.service.MatService;
import com.zy.asrs.wms.system.controller.BaseController;
import com.zy.asrs.wms.utils.ExcelUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
 
import javax.servlet.http.HttpServletResponse;
import java.util.*;
 
@RestController
@RequestMapping("/api")
public class MatController extends BaseController {
 
    @Autowired
    private MatService matService;
    @Autowired
    private MatFieldService matFieldService;
    @Autowired
    private MatFieldValueService matFieldValueService;
 
    @PreAuthorize("hasAuthority('asrs:mat:list')")
    @PostMapping("/mat/page")
    public R page(@RequestBody Map<String, Object> map) {
        BaseParam baseParam = buildParam(map, BaseParam.class);
        PageParam<Mat, BaseParam> pageParam = new PageParam<>(baseParam, Mat.class);
        PageParam<Mat, BaseParam> page = matService.page(pageParam, pageParam.buildWrapper(true));
 
        JSONObject data = JSON.parseObject(JSON.toJSONString(page));
 
        List<Mat> records = page.getRecords();
        data.put("records", records);
        for (Mat mat : records) {
            List<MatFieldValue> list = matFieldValueService.list(new LambdaQueryWrapper<MatFieldValue>()
                    .eq(MatFieldValue::getMatId, mat.getId()));
            mat.syncField(list);
        }
 
        return R.ok().add(data);
    }
 
    @PreAuthorize("hasAuthority('asrs:mat:list')")
    @PostMapping("/mat/list")
    public R list(@RequestBody Map<String, Object> map) {
        return R.ok().add(matService.list());
    }
 
    @PreAuthorize("hasAuthority('asrs:mat:list')")
    @GetMapping("/mat/{id}")
    public R get(@PathVariable("id") Long id) {
        return R.ok().add(matService.getById(id));
    }
 
    @PreAuthorize("hasAuthority('asrs:mat:save')")
    @OperationLog("添加商品档案")
    @PostMapping("/mat/save")
    public R save(@RequestBody HashMap<String,Object> param) {
        Mat mat = JSON.parseObject(JSON.toJSONString(param), Mat.class, Feature.DisableCircularReferenceDetect);
        if (!matService.save(mat)) {
            return R.error("添加失败");
        }
        //设置扩展字段
        setMatField(param, mat);
        return R.ok("添加成功");
    }
 
    @PreAuthorize("hasAuthority('asrs:mat:update')")
    @OperationLog("修改商品档案")
    @PostMapping("/mat/update")
    public R update(@RequestBody HashMap<String,Object> param) {
        Mat mat = JSON.parseObject(JSON.toJSONString(param), Mat.class, Feature.DisableCircularReferenceDetect);
        //设置扩展字段
        setMatField(param, mat);
 
        if (!matService.updateById(mat)) {
            return R.error("修改失败");
        }
        return R.ok("修改成功");
    }
 
    @PreAuthorize("hasAuthority('asrs:mat:remove')")
    @OperationLog("删除商品档案")
    @PostMapping("/mat/remove/{ids}")
    public R remove(@PathVariable Long[] ids) {
        if (!matService.removeByIds(Arrays.asList(ids))) {
            return R.error("删除失败");
        }
        return R.ok("删除成功");
    }
 
    @PreAuthorize("hasAuthority('asrs:mat:list')")
    @PostMapping("/mat/query")
    public R query(@RequestParam(required = false) String condition) {
        List<KeyValVo> vos = new ArrayList<>();
        LambdaQueryWrapper<Mat> wrapper = new LambdaQueryWrapper<>();
        if (!Cools.isEmpty(condition)) {
            wrapper.like(Mat::getId, condition);
        }
        matService.page(new Page<>(1, 30), wrapper).getRecords().forEach(
                item -> vos.add(new KeyValVo(item.getId(), item.getId()))
        );
        return R.ok().add(vos);
    }
 
    @PreAuthorize("hasAuthority('asrs:mat:list')")
    @PostMapping("/mat/export")
    public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
        List<Mat> list = matService.parseMat(matService.list());
        List<MatField> matFields = matFieldService.getMatFields();
        ExcelUtil.build(ExcelUtil.create(list, Mat.class, matFields), response);
    }
 
    private void setMatField(HashMap<String, Object> param, Mat mat) {
        //获取扩展字段
        List<MatField> matFields = matFieldService.list();
        for (MatField matField : matFields) {
            if (param.containsKey(matField.getName())) {
                MatFieldValue fieldValue = matFieldValueService.getOne(new LambdaQueryWrapper<MatFieldValue>()
                        .eq(MatFieldValue::getMatId, mat.getId())
                        .eq(MatFieldValue::getFieldId, matField.getId()));
                if (fieldValue == null) {
                    fieldValue = new MatFieldValue();
                    fieldValue.setMatId(mat.getId());
                    fieldValue.setFieldId(matField.getId());
                    fieldValue.setName(matField.getName());
                    fieldValue.setValue(param.get(matField.getName()).toString());
                    matFieldValueService.save(fieldValue);
                }else {
                    fieldValue.setValue(param.get(matField.getName()).toString());
                    matFieldValueService.updateById(fieldValue);
                }
            }
        }
    }
 
}