Merge "Fix sql injection vulnerability"
[portal.git] / ecomp-portal-BE-common / src / main / java / org / onap / portalapp / portal / service / LanguageServiceImpl.java
1 /**
2  * Copyright (C) 2019 CMCC, Inc. and others. All rights reserved.
3  *
4  * Licensed under the Apache License, Version 2.0 (the "License");
5  * you may not use this file except in compliance with the License.
6  * You may obtain a copy of the License at
7  *
8  *     http://www.apache.org/licenses/LICENSE-2.0
9  *
10  * Unless required by applicable law or agreed to in writing, software
11  * distributed under the License is distributed on an "AS IS" BASIS,
12  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13  * See the License for the specific language governing permissions and
14  * limitations under the License.
15  */
16 package org.onap.portalapp.portal.service;
17
18 import com.alibaba.fastjson.JSONObject;
19
20 import antlr.StringUtils;
21
22 import org.onap.portalapp.portal.domain.EPUser;
23 import org.onap.portalapp.portal.domain.Language;
24 import org.onap.portalsdk.core.service.DataAccessService;
25 import org.springframework.beans.factory.annotation.Autowired;
26 import org.springframework.stereotype.Service;
27
28 import java.util.HashMap;
29 import java.util.List;
30 import java.util.Map;
31
32 @Service
33 public class LanguageServiceImpl implements LanguageService {
34
35     @Autowired
36     private DataAccessService dataAccessService;
37
38     @Override
39     public JSONObject getLanguages() {
40         List<Language> languages = (List<Language>) dataAccessService.executeNamedQuery("queryLanguage",null,new HashMap());
41         JSONObject result = new JSONObject();
42         result.put("languageList",languages);
43         return result;
44     }
45
46     @Override
47     public String setUpUserLanguage(Integer languageId, String loginId) throws Exception{
48         Map<String,Object> params = new HashMap<>();
49         params.put("login_id",loginId);
50         params.put("language_id",languageId);
51         dataAccessService.executeNamedQuery("updateFnUser",params,new HashMap());
52         return "success";
53     }
54
55     @Override
56     public JSONObject getUserLanguage(String loginId) {
57         // get language_id from fn_user by loginId
58         JSONObject result = new com.alibaba.fastjson.JSONObject();
59         HashMap getUserParams = new HashMap();
60         getUserParams.put("login_id", loginId);
61         List<EPUser> userList= null;
62
63         try {
64             userList = dataAccessService.executeNamedQuery("getEPUserByLoginId", getUserParams, new HashMap());
65             if (userList != null && userList.size() > 0) {
66                 EPUser user = userList.get(0);
67                 int languageId = user.getLanguageId();
68                 result.put("languageId", languageId);
69
70                 // get language name and alias from fn_language by languageId
71                 HashMap<String,String> getLangParams = new HashMap();
72                 getLangParams.put("language_id", String.valueOf(languageId));
73                 List<Language> languageList = null;
74
75                 languageList = dataAccessService.executeNamedQuery("queryLanguageByLanguageId", getLangParams, new HashMap());
76                 if (languageList != null && languageList.size() > 0) {
77                     result.put("languageName", languageList.get(0).getLanguageName());
78                     result.put("languageAlias", languageList.get(0).getLanguageAlias());
79                 }
80             }
81         } catch (Exception e) {
82             e.printStackTrace();
83         }
84         return result;
85     }
86 }