fix : MySQL=》DMSQL

cy

2022-06-23 b83c40548208609d0d6826be13d742c28a784806

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
package cn.ksource.web.controller.wechat.uwyw.stats;
 
import java.util.List;
import java.util.Map;
 
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
 
import cn.ksource.beans.SC_PARTNER_CUSTOMER_INFO;
import cn.ksource.core.util.JsonUtil;
import cn.ksource.core.util.StringUtil;
import cn.ksource.core.web.WebUtil;
import cn.ksource.web.facade.tj.CiStatisFacade;
 
@Controller
@RequestMapping("/uwyw/stats/uConfigStats")
public class UConfigStatsController {
    
    @Resource
    private CiStatisFacade ciStatisFacade;
    
    /**
     * 配置统计首页
     * @param request
     * @return
     */
    @RequestMapping("/uconfigStatsIndex.html")
    public String uconfigStatsIndex(HttpServletRequest request){
        return "/business/wechat/uwyw/stats/uConfigStats/uconfigStatsIndex";
    }
    
    /**
     * 查询条件
     * @param request
     * @return
     */
    @RequestMapping("/configSearchIndex.html")
    public String configSearchIndex(Model model,HttpServletRequest request){
        List lv1List = ciStatisFacade.getCiCategoryList( null);
        model.addAttribute("lv1List", lv1List);
        return "/business/wechat/uwyw/stats/uConfigStats/configSearchIndex";
    }
    
    /**
     * 获取设备分类下拉列表
     * @param request
     * @param response
     */
    @RequestMapping("/getCategotyList.html")
    public void getCategotyList(HttpServletRequest request,HttpServletResponse response){
        String lv1Id = request.getParameter("lv1Id");
        List list = ciStatisFacade.getCiCategoryList(lv1Id);
        WebUtil.write(response, JsonUtil.list2Json(list));
    }
    
    @RequestMapping("/configStatsJump.html")
    public String configStatsJump(HttpServletRequest request){
        String statsType = request.getParameter("statsType");
        if(statsType.equals("type")){
            return "forward:/uwyw/stats/uConfigStats/uconfigTypePie.html";
        }else if(statsType.equals("flreport")){
            return "forward:/uwyw/stats/uConfigStats/uciTypeTable.html?queryType=TABLE";
        }else if(statsType.equals("csreport")){
            return "forward:/uwyw/stats/uConfigStats/uciMainufacturerTable.html";
        }else if(statsType.equals("pzreport")){
            return "forward:/uwyw/stats/uConfigStats/uciCountTable.html";
        }
        return "forward:/uwyw/stats/uConfigStats/configStatsIndex.html";
    }
    
    /**
     * 
     * @param model
     * @param request
     * @param response
     */
    @RequestMapping("/uconfigTypePie.html")
    public String uconfigTypePie(Model model,HttpServletRequest request,HttpServletResponse response){
        String cusId = WebUtil.getUserWywCusId(request);
        String lv1Id = request.getParameter("lv1Id");
        String lv2Id = request.getParameter("lv2Id");
        String queryType = request.getParameter("queryType");
        if(!StringUtil.isEmpty(cusId)){
            Map resMap = ciStatisFacade.getCiTypeChart(cusId,lv1Id,lv2Id,queryType);
            model.addAttribute("chartJsonStr", JsonUtil.map2Json(resMap));
        }
        return "/business/wechat/uwyw/stats/uConfigStats/uconfigTypePie";
    }
    
    @RequestMapping("/uciTypeTable.html")
    public String uciTypeTable(Model model,HttpServletRequest request,HttpServletResponse response){
        String cusId = WebUtil.getUserWywCusId(request);
        String lv1Id = request.getParameter("lv1Id");
        String lv2Id = request.getParameter("lv2Id");
        String queryType = request.getParameter("queryType");
        if(!StringUtil.isEmpty(cusId)){
            Map resMap = ciStatisFacade.getCiTypeChart(cusId,lv1Id,lv2Id,queryType);
            model.addAttribute("resMap", resMap);
            
            SC_PARTNER_CUSTOMER_INFO cus = new SC_PARTNER_CUSTOMER_INFO(cusId).getInstanceById();
            model.addAttribute("cusName",cus.getShort_name());
        }
        //System.out.println("---------------"+JsonUtil.map2Json(rootMap));
        return "/business/wechat/uwyw/stats/uConfigStats/uciTypeTable";
    }
    
    @RequestMapping("/uciMainufacturerTable.html")
    public String ciMainufacturerTable(Model model,HttpServletRequest request,HttpServletResponse response){
        String queryType = request.getParameter("queryType");
        String cusId = WebUtil.getUserWywCusId(request);
        if(!StringUtil.isEmpty(queryType)){
            Map resMap = ciStatisFacade.getCiMainufacturerChart(cusId,queryType);
            Map rootMap = (Map)resMap.get("rootMap");
            List<Map> lebalList = (List<Map>)resMap.get("lebalList");
            model.addAttribute("rootMap",rootMap);
            model.addAttribute("lebalList",lebalList);
            
            SC_PARTNER_CUSTOMER_INFO cus = new SC_PARTNER_CUSTOMER_INFO(cusId).getInstanceById();
            model.addAttribute("cusName",cus.getShort_name());
        }
        return "/business/wechat/uwyw/stats/uConfigStats/uciMainufacturerTable";
    }
    
    @RequestMapping("/uciCountTable.html")
    public String ciCountTable(Model model,HttpServletRequest request,HttpServletResponse response){
        String cusId = WebUtil.getUserWywCusId(request);
        if(!StringUtil.isEmpty(cusId)){
            Map resMap = ciStatisFacade.getCiCountChart(cusId);
            Map rootMap = (Map)resMap.get("rootMap");
            model.addAttribute("rootMap",rootMap);
            
            SC_PARTNER_CUSTOMER_INFO cus = new SC_PARTNER_CUSTOMER_INFO(cusId).getInstanceById();
            model.addAttribute("cusName",cus.getShort_name());
        }
        //System.out.println("---------------"+JsonUtil.map2Json(rootMap));
        return "/business/wechat/uwyw/stats/uConfigStats/uciCountTable";
    }
 
}