2 * Copyright (C) 2019 CMCC, Inc. and others. All rights reserved.
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
8 * http://www.apache.org/licenses/LICENSE-2.0
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.
16 package org.onap.portalapp.portal.service;
18 import com.alibaba.fastjson.JSONObject;
20 import antlr.StringUtils;
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;
28 import java.util.HashMap;
29 import java.util.List;
33 public class LanguageServiceImpl implements LanguageService {
36 private DataAccessService dataAccessService;
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);
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());
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;
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);
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;
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());
81 } catch (Exception e) {