1

hao

2025-05-20 8e24c6fea30d9b179375ee2893710cdec2443b13

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
package com.web.kanban.service.internal;
 
import com.app.base.data.ApiResponseResult;
import com.web.kanban.service.GltKanbanService;
import com.web.kanban.service.HgKanbanService;
import org.apache.camel.api.management.ManagedOperation;
import org.springframework.data.domain.PageRequest;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
 
import java.util.*;
 
@Service(value = "GltKanbanService")
@Transactional(propagation = Propagation.REQUIRED)
public class GltKanbanlmpl extends GltReportPrcUtils implements GltKanbanService {
 
    /**
     * iqc看板
     * @param pageRequest
     * @return
     * @throws Exception
     */
    @Override
    public ApiResponseResult getPRC_KB_IQC(PageRequest pageRequest)throws Exception  {
        List<Object> list = getPRC_KB_IQC_prc("Prc_Kb_Iqc",
                pageRequest.getPageSize(), pageRequest.getPageNumber());
        if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
            return ApiResponseResult.failure(list.get(1).toString());
        }
        Map map = new HashMap();
        map.put("list1", list.get(1));
        map.put("list2", list.get(2));
        map.put("list3", list.get(3));
        map.put("list4", list.get(4));
        map.put("list5", list.get(5));
        return ApiResponseResult.success().data(map);
 
    }
 
    /**
     * 获取仓库看板
     * @param pageRequest
     * @return
     * @throws Exception
     */
    @Override
    public ApiResponseResult getWarehouse(PageRequest pageRequest) throws Exception {
        List<Object> list = getWarehouseKanban("Prc_Kb_Depots");
        if (!list.get(0).toString().equals("0")) {// 存储过程调用失败 //判断返回游标
            return ApiResponseResult.failure(list.get(1).toString());
        }
        Map map = new HashMap();
        map.put("list1", list.get(1));
        map.put("list2", list.get(2));
 
        List li=(List)list.get(2);
        List lt= new ArrayList();
        for (Object o : li) {
            Map str= (Map) o;
            Iterator<String> iter = str.keySet().iterator();
            while(iter.hasNext()){
                Map map1=new HashMap();
                String key=iter.next();
                String value = (String) str.get(key);
                map1.put("name",key);
                map1.put("num",value);
                System.out.println(key+" "+value);
                lt.add(map1);
            }
        }
        map.put("list2", lt);
        map.put("list3", list.get(3));
        map.put("list4", list.get(4));
        map.put("list5", list.get(5));
        System.out.println(map);
        return ApiResponseResult.success().data(map);
    }
 
 
}