package cn.ksource.web.facade.wechat.ewyw;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.LinkedList;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.servlet.http.HttpServletRequest;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import cn.ksource.beans.KM_LIBRARY;
|
import cn.ksource.beans.KM_LIBRARY_KNOWLEDGE_ACCESS;
|
import cn.ksource.beans.KM_LIBRARY_KNOWLEDGE_ACCESS_TEMP;
|
import cn.ksource.beans.KM_LIBRARY_TEMP;
|
import cn.ksource.beans.SC_WORKFLOW_INCIDENT;
|
import cn.ksource.beans.SC_WORKFLOW_INCIDENT_LOCAL;
|
import cn.ksource.beans.SC_WORKFLOW_QUESTION;
|
import cn.ksource.core.dao.BaseDao;
|
import cn.ksource.core.dao.SqlParameter;
|
import cn.ksource.core.page.PageInfo;
|
import cn.ksource.core.util.AjaxUtil;
|
import cn.ksource.core.util.ConvertUtil;
|
import cn.ksource.core.util.DateUtil;
|
import cn.ksource.core.util.StringUtil;
|
import cn.ksource.core.web.ClientUtil;
|
import cn.ksource.core.web.SysInfoMsg;
|
import cn.ksource.core.web.WebUtil;
|
import cn.ksource.web.Constants;
|
import cn.ksource.web.facade.knowledge.knowledgeDeal.KnowledgeDealFacade;
|
import cn.ksource.web.Constants;
|
import cn.ksource.web.service.device.DeviceService;
|
import cn.ksource.web.service.file.FileService;
|
import cn.ksource.web.service.knowledge.KmService;
|
import cn.ksource.web.service.order.OrderService;
|
|
|
@Service("ewKnowledgeFacade")
|
public class EwKnowledgeFacadeImpl implements EwKnowledgeFacade {
|
|
@Autowired
|
private BaseDao baseDao;
|
|
@Autowired
|
private KmService kmService;
|
|
@Autowired
|
private FileService fileService;
|
|
@Autowired
|
private OrderService orderService;
|
|
@Autowired
|
private DeviceService deviceService;
|
|
@Autowired
|
private KnowledgeDealFacade knowledgeDealFacade;
|
|
|
@Override
|
public Integer queryNewKwCount(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("SELECT COUNT(ID) FROM KM_LIBRARY WHERE STATE = 1 ");
|
return baseDao.queryForInteger(sql.toString(), params);
|
}
|
|
@Override
|
public PageInfo queryNewKwData(PageInfo pageInfo, Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("SELECT ID,TITLE,TAG,SUMMARY,UPDATE_DATE,HITS,CREATE_USER_ID,CREATE_USER_NAME,CREATE_TIME,FILE_ID FROM KM_LIBRARY WHERE STATE = 1 ");
|
sql.append(" ORDER BY UPDATE_DATE DESC");
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
|
List<Map> datas = info.getDatas();
|
if(datas.size()>0){
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:datas){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
info.setDatas(datas);
|
return info;
|
}
|
|
@Override
|
public Map queryKnowledgeInfo(String id,String userId) {
|
String selectSql = "SELECT * FROM KM_LIBRARY WHERE ID = :id ";
|
Map param = new HashMap();
|
param.put("id", id);
|
Map kw = baseDao.queryForMap(selectSql,new SqlParameter("id",id));
|
//得到审批状态
|
String audit_state = baseDao.queryForString("SELECT AUDIT_STATE FROM KM_LIBRARY_TEMP WHERE ORIGINAL_ID = :id",new SqlParameter("id",id));
|
kw.put("AUDIT_STATE", audit_state);
|
param.put("type", Constants.KM_SCORE_RULE_TYPE_D);
|
int zan = baseDao.queryForInteger("SELECT COUNT(ID) FROM KM_RECORD WHERE LIBRARY_ID = :id AND TYPE = :type ", param);
|
param.put("type", Constants.KM_SCORE_RULE_TYPE_C);
|
int cai = baseDao.queryForInteger("SELECT COUNT(ID) FROM KM_RECORD WHERE LIBRARY_ID = :id AND TYPE = :type ", param);
|
kw.put("ZANNUM", zan);
|
kw.put("CAINUM", cai);
|
if(null!=kw && kw.size()>0) {
|
List<Map> mylist = kmService.getmyFavourite(userId);
|
List<Map> myrecord = kmService.getmyknowRecord(userId);
|
for(Map mymap :mylist){
|
if(kw.get("ID").equals(mymap.get("LIBRARY_ID"))){
|
kw.put("favourite", 1);
|
}
|
}
|
for(Map mymap :myrecord){
|
if(kw.get("ID").equals(mymap.get("LIBRARY_ID"))){
|
if(ConvertUtil.obj2Integer(mymap.get("TYPE")) == Constants.KM_SCORE_RULE_TYPE_D){
|
kw.put("zan", 1);
|
}
|
if(ConvertUtil.obj2Integer(mymap.get("TYPE")) == Constants.KM_SCORE_RULE_TYPE_C){
|
kw.put("cai", 1);
|
}
|
}
|
}
|
String tag = ConvertUtil.obj2StrBlank(kw.get("TAG"));
|
String[] tags = tag.split("\\s");
|
List<String> tagList = new ArrayList();
|
for(int i=0;i<tags.length;i++){
|
if(!StringUtil.isEmpty(tags[i])){
|
tagList.add(tags[i]);
|
}
|
}
|
kw.put("tag_list", tagList);
|
List<Map> fileList = fileService.getFileList(ConvertUtil.obj2StrBlank(kw.get("FILE_ID")));
|
//知识关联
|
List<Map> knowList = queryLinkKnows(id,"");
|
kw.put("files", fileList);
|
kw.put("filesize", fileList.size());
|
kw.put("knowsize", knowList.size());
|
}
|
return kw;
|
}
|
|
@Override
|
public Map queryKnowledgeInfoSh(String id,String userId) {
|
String selectSql = "SELECT A.*,B.ID BID FROM KM_LIBRARY_TEMP A LEFT JOIN KM_LIBRARY B ON A.ORIGINAL_ID = B.ID WHERE A.ID = :id ";
|
Map param = new HashMap();
|
param.put("id", id);
|
Map kw = baseDao.queryForMap(selectSql,new SqlParameter("id",id));
|
//得到正式表的编号
|
String contentState = ConvertUtil.obj2Str(kw.get("CONTENT_STATE"));
|
if(!contentState.equals("1")){
|
param.put("id", kw.get("BID"));
|
}
|
param.put("type", Constants.KM_SCORE_RULE_TYPE_D);
|
int zan = baseDao.queryForInteger("SELECT COUNT(ID) FROM KM_RECORD WHERE LIBRARY_ID = :id AND TYPE = :type ", param);
|
param.put("type", Constants.KM_SCORE_RULE_TYPE_C);
|
int cai = baseDao.queryForInteger("SELECT COUNT(ID) FROM KM_RECORD WHERE LIBRARY_ID = :id AND TYPE = :type ", param);
|
kw.put("ZANNUM", zan);
|
kw.put("CAINUM", cai);
|
if(null!=kw && kw.size()>0) {
|
List<Map> mylist = kmService.getmyFavourite(userId);
|
List<Map> myrecord = kmService.getmyknowRecord(userId);
|
for(Map mymap :mylist){
|
if(kw.get("ID").equals(mymap.get("LIBRARY_ID"))){
|
kw.put("favourite", 1);
|
}
|
}
|
for(Map mymap :myrecord){
|
if(kw.get("ID").equals(mymap.get("LIBRARY_ID"))){
|
if(ConvertUtil.obj2Integer(mymap.get("TYPE")) == Constants.KM_SCORE_RULE_TYPE_D){
|
kw.put("zan", 1);
|
}
|
if(ConvertUtil.obj2Integer(mymap.get("TYPE")) == Constants.KM_SCORE_RULE_TYPE_C){
|
kw.put("cai", 1);
|
}
|
}
|
}
|
String tag = ConvertUtil.obj2StrBlank(kw.get("TAG"));
|
String[] tags = tag.split("\\s");
|
List<String> tagList = new ArrayList();
|
for(int i=0;i<tags.length;i++){
|
if(!StringUtil.isEmpty(tags[i])){
|
tagList.add(tags[i]);
|
}
|
}
|
kw.put("tag_list", tagList);
|
List<Map> fileList = fileService.getFileList(ConvertUtil.obj2StrBlank(kw.get("ID")));
|
//知识关联
|
List<Map> knowList = queryLinkKnowsTemp(id);
|
kw.put("files", fileList);
|
kw.put("filesize", fileList.size());
|
kw.put("knowsize", knowList.size());
|
}
|
return kw;
|
}
|
|
@Override
|
public List queryLinkKnows(String knowId,String type) {
|
//知识关联
|
String linksql = "";
|
List<Map> knowList = new ArrayList<Map>();
|
if(StringUtil.isEmpty(type)){
|
linksql = "select B.* from KM_LIBRARY_KNOWLEDGE A,KM_LIBRARY B where A.KNOWLEDGE_ID = B.ID AND A.LIBRARY_ID=:library_id ";
|
knowList = baseDao.queryForList(linksql, new SqlParameter("library_id", knowId));
|
}else{
|
linksql = "select B.* from KM_LIBRARY_KNOWLEDGE_TEMP A,KM_LIBRARY_TEMP B where A.KNOWLEDGE_ID = B.ID AND A.LIBRARY_ID=:library_id ";
|
knowList = baseDao.queryForList(linksql, new SqlParameter("library_id", knowId));
|
}
|
|
if(knowList.size()>0){
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:knowList){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
return knowList;
|
}
|
|
@Override
|
public List queryLinkKnowsTemp(String knowId) {
|
//知识关联
|
String linksql = "select B.* from KM_LIBRARY_KNOWLEDGE_TEMP A,KM_LIBRARY B where A.KNOWLEDGE_ID = B.ID AND A.LIBRARY_ID=:library_id ";
|
List<Map> knowList = baseDao.queryForList(linksql, new SqlParameter("library_id", knowId));
|
|
if(knowList.size()>0){
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:knowList){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
return knowList;
|
}
|
|
@Override
|
public List queryFiles(String fileId) {
|
List<Map> files = fileService.getFileList(fileId);
|
if(null!=files && files.size()>0) {
|
for(Map file : files) {
|
file.put("FILE_SIZE", StringUtil.getFileSize(ConvertUtil.obj2Double(file.get("FILE_SIZE"))));
|
|
String fileFormat = ConvertUtil.obj2StrBlank(file.get("FILE_FORMAT"));
|
String docSuffer = StringUtil.wechateDocSuffer(fileFormat);
|
file.put("SUFFER", docSuffer);
|
|
}
|
}
|
return files;
|
}
|
|
@Override
|
public Map companyCiCate(String pid) {
|
StringBuffer sql=new StringBuffer("SELECT A.ID,A.NAME,A.CODE,A.LV JB,A.PID FROM CMDB_CI_CATEGORY A WHERE A.STATE = 1 AND A.CATE_TYPE=1 ");
|
Map paraMap = new HashMap();
|
if(StringUtil.isEmpty(pid)){
|
sql.append(" AND A.LV = 1 ");
|
}
|
sql.append(" ORDER BY A.LV,A.SERIAL ");
|
List<Map> categoryList = baseDao.queryForList(sql.toString(),paraMap);
|
|
if(!StringUtil.isEmpty(pid)){
|
List<Map> resultList = new LinkedList<Map>();
|
Map cacheMap = new HashMap();
|
Map<String, Map> yjgnCache = new HashMap<String, Map>();
|
Map<String, Map> ejgnCache = new HashMap<String, Map>();
|
|
for (Map map : categoryList) {
|
|
//一级树
|
if (map.get("JB").toString().equalsIgnoreCase("2") && pid.equals(map.get("PID"))) {
|
cacheMap.put(map.get("ID"), map);
|
yjgnCache.put(map.get("ID").toString(), map);
|
List<Map> ejgnList = new LinkedList<Map>();
|
map.put("ejTree", ejgnList);
|
resultList.add(map);
|
continue;
|
}
|
//二级树
|
if (map.get("JB").toString().equalsIgnoreCase("3") && cacheMap.containsKey(map.get("PID"))) {
|
Map yjgnMap = yjgnCache.get(map.get("PID").toString());
|
List<Map> list = (List<Map>)yjgnMap.get("ejTree");
|
list.add(map);
|
|
ejgnCache.put(map.get("ID").toString(), map);
|
continue;
|
}
|
}
|
categoryList = resultList;
|
}
|
|
Map resultMap = new HashMap();
|
resultMap.put("datas", categoryList);
|
resultMap.put("flag", 0);
|
resultMap.put(ClientUtil.SUCCESS, true);
|
resultMap.put(ClientUtil.MSG, "成功");
|
|
return resultMap;
|
}
|
|
@Override
|
public Map companyKnowCate(String pid) {
|
StringBuffer sql= new StringBuffer(" SELECT A.ID,A.TITLE,A.TAG P_ID,A.LEVEL FROM KM_LIBRARY_CATEGORY A WHERE A.STATE=1 ");
|
if(StringUtil.isEmpty(pid)){
|
sql.append(" AND A.LEVEL = 1 ");
|
}
|
sql.append(" ORDER BY A.LEVEL,A.TITLE ");
|
List<Map> categoryList = baseDao.queryForList(sql.toString());
|
if(!StringUtil.isEmpty(pid)){
|
List<Map> resultList = new LinkedList<Map>();
|
Map cacheMap = new HashMap();
|
Map<String, Map> yjgnCache = new HashMap<String, Map>();
|
Map<String, Map> ejgnCache = new HashMap<String, Map>();
|
|
for (Map map : categoryList) {
|
|
//一级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("2") && pid.equals(map.get("P_ID"))) {
|
cacheMap.put(map.get("ID"), map);
|
yjgnCache.put(map.get("ID").toString(), map);
|
List<Map> ejgnList = new LinkedList<Map>();
|
map.put("ejTree", ejgnList);
|
resultList.add(map);
|
continue;
|
}
|
//二级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("3") && cacheMap.containsKey(map.get("P_ID"))) {
|
Map yjgnMap = yjgnCache.get(map.get("P_ID").toString());
|
List<Map> list = (List<Map>)yjgnMap.get("ejTree");
|
list.add(map);
|
|
ejgnCache.put(map.get("ID").toString(), map);
|
continue;
|
}
|
}
|
categoryList = resultList;
|
}
|
Map resultMap = new HashMap();
|
resultMap.put("datas", categoryList);
|
resultMap.put("flag", 0);
|
resultMap.put(ClientUtil.SUCCESS, true);
|
resultMap.put(ClientUtil.MSG, "成功");
|
|
return resultMap;
|
}
|
|
@Override
|
public Map companyServiceCate(String pid) {
|
StringBuffer sql = new StringBuffer();
|
sql.append("SELECT ID,CATEGORY_NAME,CATEGORY_CODE,LEVEL,P_ID FROM SC_SERVCE_CATEGORY WHERE STATE = 1 AND TYPE = 2 ");
|
if(StringUtil.isEmpty(pid)){
|
sql.append(" AND LEVEL = 1 ");
|
}
|
sql.append(" ORDER BY LEVEL,SERIAL ");
|
|
List<Map> categoryList = baseDao.queryForList(sql.toString());
|
|
if(!StringUtil.isEmpty(pid)){
|
List<Map> resultList = new LinkedList<Map>();
|
Map cacheMap = new HashMap();
|
Map<String, Map> yjgnCache = new HashMap<String, Map>();
|
Map<String, Map> ejgnCache = new HashMap<String, Map>();
|
|
for (Map map : categoryList) {
|
|
//一级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("2") && pid.equals(map.get("P_ID"))) {
|
cacheMap.put(map.get("ID"), map);
|
yjgnCache.put(map.get("ID").toString(), map);
|
List<Map> ejgnList = new LinkedList<Map>();
|
map.put("ejTree", ejgnList);
|
resultList.add(map);
|
continue;
|
}
|
//二级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("3") && cacheMap.containsKey(map.get("P_ID"))) {
|
Map yjgnMap = yjgnCache.get(map.get("P_ID").toString());
|
List<Map> list = (List<Map>)yjgnMap.get("ejTree");
|
list.add(map);
|
|
ejgnCache.put(map.get("ID").toString(), map);
|
continue;
|
}
|
}
|
categoryList = resultList;
|
}
|
Map resultMap = new HashMap();
|
resultMap.put("datas", categoryList);
|
resultMap.put("flag", 0);
|
resultMap.put(ClientUtil.SUCCESS, true);
|
resultMap.put(ClientUtil.MSG, "成功");
|
|
return resultMap;
|
}
|
|
|
@Override
|
public Integer queryCompanyNewKwCount(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("SELECT COUNT(ID) ");
|
if(StringUtil.isEmpty(params.get("cusId"))){
|
sql.append("FROM KM_LIBRARY WHERE STATE = 1 ");
|
}else{
|
sql.append("FROM (SELECT A.* FROM KM_LIBRARY A,KM_LIBRARY_KNOWLEDGE_ACCESS B WHERE A.ID = B.KNOWLEDGE_ID AND B.CUSTOMER_ID = :cusId ) k ");
|
}
|
return baseDao.queryForInteger(sql.toString(),params);
|
}
|
|
@Override
|
public PageInfo queryCompanyNewKwData(PageInfo pageInfo,
|
Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("SELECT k.ID,k.TITLE,k.TAG,k.SUMMARY,k.UPDATE_DATE,k.HITS,k.CREATE_USER_ID,k.CREATE_USER_NAME,k.CREATE_TIME,k.FILE_ID ");
|
if(StringUtil.isEmpty(params.get("cusId"))){
|
sql.append("FROM KM_LIBRARY k WHERE STATE = 1 ");
|
}else{
|
sql.append("FROM (SELECT A.* FROM KM_LIBRARY A,KM_LIBRARY_KNOWLEDGE_ACCESS B WHERE A.ID = B.KNOWLEDGE_ID AND B.CUSTOMER_ID = :cusId ) k ");
|
}
|
|
sql.append(" ORDER BY k.UPDATE_DATE DESC ");
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
|
List<Map> datas = info.getDatas();
|
if(datas.size()>0){
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:datas){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
info.setDatas(datas);
|
return info;
|
}
|
|
@Override
|
public List<Map> companyCiCatenum(Map<String, String> params) {
|
String pid = params.get("pid");
|
String cusId = params.get("cusId");
|
StringBuffer sql=new StringBuffer("SELECT A.ID,A.NAME,A.CODE,A.LV JB,A.PID,COUNT(B.ID) AS NUM FROM CMDB_CI_CATEGORY A LEFT JOIN ");
|
if(StringUtil.isEmpty(params.get("cusId"))){
|
sql.append(" KM_LIBRARY B ON B.THIRDLEVEL_ID = A.ID AND B.STATE = 1 WHERE A.STATE = 1 ");
|
}else{
|
sql.append(" (SELECT C.* FROM KM_LIBRARY C,KM_LIBRARY_KNOWLEDGE_ACCESS D WHERE C.ID = D.KNOWLEDGE_ID AND D.CUSTOMER_ID = :cusId ) B ON B.THIRDLEVEL_ID = A.ID AND B.STATE = 1 WHERE A.STATE=1 ");
|
}
|
sql.append(" and a.cate_type=1 GROUP BY A.ID ORDER BY A.LV,A.SERIAL ");
|
List<Map> categoryList = baseDao.queryForList(sql.toString(),params);
|
|
List<Map> resultList = new LinkedList<Map>();
|
if(!StringUtil.isEmpty(pid)){
|
Map cacheMap = new HashMap();
|
Map<String, Map> yjgnCache = new HashMap<String, Map>();
|
Map<String, Map> ejgnCache = new HashMap<String, Map>();
|
for (Map map : categoryList) {
|
if (map.get("JB").toString().equalsIgnoreCase("2")&&map.get("PID").equals(pid)) {
|
for(Map map1 : categoryList){
|
int num = ConvertUtil.obj2Int(map.get("NUM"));
|
if(map.get("ID").equals(map1.get("PID"))){
|
num += ConvertUtil.obj2Int(map1.get("NUM"));
|
map.put("NUM", num);
|
}
|
}
|
}
|
}
|
for (Map map : categoryList) {
|
|
//一级树
|
if (map.get("JB").toString().equalsIgnoreCase("2") && pid.equals(map.get("PID"))) {
|
cacheMap.put(map.get("ID"), map);
|
yjgnCache.put(map.get("ID").toString(), map);
|
List<Map> ejgnList = new LinkedList<Map>();
|
map.put("ejTree", ejgnList);
|
resultList.add(map);
|
continue;
|
}
|
//二级树
|
if (map.get("JB").toString().equalsIgnoreCase("3") && cacheMap.containsKey(map.get("PID"))) {
|
Map yjgnMap = yjgnCache.get(map.get("PID").toString());
|
List<Map> list = (List<Map>)yjgnMap.get("ejTree");
|
list.add(map);
|
|
ejgnCache.put(map.get("ID").toString(), map);
|
continue;
|
}
|
}
|
}
|
|
|
return resultList;
|
}
|
|
@Override
|
public List<Map> companyKnowCatenum(Map<String, String> params) {
|
String pid = params.get("pid");
|
String cusId = params.get("cusId");
|
StringBuffer sql= new StringBuffer(" SELECT A.ID,A.TITLE,A.TAG P_ID,A.LEVEL ,COUNT(B.ID) AS NUM FROM KM_LIBRARY_CATEGORY A LEFT JOIN ");
|
if(StringUtil.isEmpty(params.get("cusId"))){
|
sql.append(" KM_LIBRARY B ON B.CATEGORY_ID = A.ID AND B.STATE = 1 WHERE A.STATE=1 ");
|
}else{
|
sql.append(" (SELECT C.* FROM KM_LIBRARY C,KM_LIBRARY_KNOWLEDGE_ACCESS D WHERE C.ID = D.KNOWLEDGE_ID AND D.CUSTOMER_ID = :cusId ) B ON B.CATEGORY_ID = A.ID AND B.STATE = 1 WHERE A.STATE=1 ");
|
}
|
sql.append(" GROUP BY A.ID ORDER BY A.LEVEL,A.TITLE ");
|
List<Map> categoryList = baseDao.queryForList(sql.toString(),params);
|
List<Map> resultList = new LinkedList<Map>();
|
if(!StringUtil.isEmpty(pid)){
|
Map cacheMap = new HashMap();
|
Map<String, Map> yjgnCache = new HashMap<String, Map>();
|
Map<String, Map> ejgnCache = new HashMap<String, Map>();
|
for (Map map : categoryList) {
|
if (map.get("LEVEL").toString().equalsIgnoreCase("2")&&map.get("P_ID").equals(pid)) {
|
for(Map map1 : categoryList){
|
int num = ConvertUtil.obj2Int(map.get("NUM"));
|
if(map.get("ID").equals(map1.get("P_ID"))){
|
num += ConvertUtil.obj2Int(map1.get("NUM"));
|
map.put("NUM", num);
|
}
|
}
|
}
|
}
|
for (Map map : categoryList) {
|
|
//一级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("2") && pid.equals(map.get("P_ID"))) {
|
cacheMap.put(map.get("ID"), map);
|
yjgnCache.put(map.get("ID").toString(), map);
|
List<Map> ejgnList = new LinkedList<Map>();
|
map.put("ejTree", ejgnList);
|
resultList.add(map);
|
continue;
|
}
|
//二级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("3") && cacheMap.containsKey(map.get("P_ID"))) {
|
Map yjgnMap = yjgnCache.get(map.get("P_ID").toString());
|
List<Map> list = (List<Map>)yjgnMap.get("ejTree");
|
list.add(map);
|
|
ejgnCache.put(map.get("ID").toString(), map);
|
continue;
|
}
|
}
|
}
|
|
return resultList;
|
}
|
|
@Override
|
public List<Map> companyServiceCatenum(Map<String, String> params) {
|
String pid = params.get("pid");
|
String cusId = params.get("cusId");
|
StringBuffer sql = new StringBuffer();
|
sql.append("SELECT A.ID,A.CATEGORY_NAME,A.CATEGORY_CODE,A.LEVEL,A.P_ID,COUNT(B.ID) AS NUM FROM SC_SERVCE_CATEGORY A LEFT JOIN ");
|
if(StringUtil.isEmpty(params.get("cusId"))){
|
sql.append(" KM_LIBRARY B ON B.THIRD_CATEGORY_ID = A.ID AND B.STATE = 1 WHERE A.STATE = 1 AND A.TYPE = 2 ");
|
}else{
|
sql.append(" (SELECT C.* FROM KM_LIBRARY C,KM_LIBRARY_KNOWLEDGE_ACCESS D WHERE C.ID = D.KNOWLEDGE_ID AND D.CUSTOMER_ID = :cusId ) B ON B.THIRD_CATEGORY_ID = A.ID AND B.STATE = 1 WHERE A.STATE=1 AND A.TYPE = 2 ");
|
}
|
sql.append(" GROUP BY A.ID ORDER BY A.LEVEL,A.SERIAL ");
|
|
List<Map> categoryList = baseDao.queryForList(sql.toString(),params);
|
|
List<Map> resultList = new LinkedList<Map>();
|
if(!StringUtil.isEmpty(pid)){
|
Map cacheMap = new HashMap();
|
Map<String, Map> yjgnCache = new HashMap<String, Map>();
|
Map<String, Map> ejgnCache = new HashMap<String, Map>();
|
for (Map map : categoryList) {
|
if (map.get("LEVEL").toString().equalsIgnoreCase("2")&&map.get("P_ID").equals(pid)) {
|
for(Map map1 : categoryList){
|
int num = ConvertUtil.obj2Int(map.get("NUM"));
|
if(map.get("ID").equals(map1.get("P_ID"))){
|
num += ConvertUtil.obj2Int(map1.get("NUM"));
|
map.put("NUM", num);
|
}
|
}
|
}
|
}
|
for (Map map : categoryList) {
|
|
//一级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("2") && pid.equals(map.get("P_ID"))) {
|
cacheMap.put(map.get("ID"), map);
|
yjgnCache.put(map.get("ID").toString(), map);
|
List<Map> ejgnList = new LinkedList<Map>();
|
map.put("ejTree", ejgnList);
|
resultList.add(map);
|
continue;
|
}
|
//二级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("3") && cacheMap.containsKey(map.get("P_ID"))) {
|
Map yjgnMap = yjgnCache.get(map.get("P_ID").toString());
|
List<Map> list = (List<Map>)yjgnMap.get("ejTree");
|
list.add(map);
|
|
ejgnCache.put(map.get("ID").toString(), map);
|
continue;
|
}
|
}
|
}
|
|
return resultList;
|
}
|
|
|
@Override
|
public Integer knowListBycateIdCount(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("SELECT COUNT(k.ID) ");
|
if(StringUtil.isEmpty(params.get("cusId"))){
|
sql.append("FROM KM_LIBRARY k WHERE STATE = 1 ");
|
}else{
|
sql.append("FROM (SELECT A.* FROM KM_LIBRARY A,KM_LIBRARY_KNOWLEDGE_ACCESS B WHERE A.ID = B.KNOWLEDGE_ID AND B.CUSTOMER_ID = :cusId ) k WHERE STATE = 1 ");
|
}
|
queryknowListIf(params,sql);
|
return baseDao.queryForInteger(sql.toString(),params);
|
}
|
|
@Override
|
public PageInfo knowListBycateIdData(PageInfo pageInfo,
|
Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("SELECT k.ID,k.TITLE,k.TAG,k.SUMMARY,k.UPDATE_DATE,k.HITS,k.CREATE_USER_ID,k.CREATE_USER_NAME,k.CREATE_TIME,k.FILE_ID ");
|
if(StringUtil.isEmpty(params.get("cusId"))){
|
sql.append("FROM KM_LIBRARY k WHERE STATE = 1 ");
|
}else{
|
sql.append("FROM (SELECT A.* FROM KM_LIBRARY A,KM_LIBRARY_KNOWLEDGE_ACCESS B WHERE A.ID = B.KNOWLEDGE_ID AND B.CUSTOMER_ID = :cusId ) k WHERE STATE = 1 ");
|
}
|
queryknowListIf(params,sql);
|
sql.append(" ORDER BY k.UPDATE_DATE DESC ");
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
|
List<Map> datas = info.getDatas();
|
if(datas.size()>0){
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:datas){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
info.setDatas(datas);
|
return info;
|
}
|
|
private void queryknowListIf(Map<String, String> params, StringBuilder sql) {
|
if("1".equals(params.get("type"))){
|
sql.append(" AND CATEGORY_ID = :categoryId ");
|
}else if("2".equals(params.get("type"))){
|
sql.append(" AND THIRDLEVEL_ID = :categoryId ");
|
}else{
|
sql.append(" AND THIRD_CATEGORY_ID = :categoryId ");
|
}
|
}
|
|
@Override
|
public PageInfo queryMyEditKwData(PageInfo pageInfo,Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("select k.ID,k.TITLE,k.TAG,K.CREATE_USER_NAME,K.CREATE_TIME,k.CATEGORY_NAME ,k.FILE_ID,f.EDITOR_DATE,k.HITS from KM_LIBRARY_UPDATER f,KM_LIBRARY k ");
|
sql.append("where f.LIBRARY_ID=k.ID and k.STATE=1 and f.USER_ID=:userId and f.TYPE = 2 ");
|
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
|
List<Map> datas = info.getDatas();
|
if(datas.size()>0){
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:datas){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
info.setDatas(datas);
|
return info;
|
}
|
|
@Override
|
public Integer queryMyEditKwCount(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("select k.ID,k.TITLE,k.TAG,K.CREATE_USER_NAME,K.CREATE_TIME,k.CATEGORY_NAME ,k.FILE_ID,f.EDITOR_DATE,k.HITS from KM_LIBRARY_UPDATER f,KM_LIBRARY k ");
|
sql.append("where f.LIBRARY_ID=k.ID and k.STATE=1 and f.USER_ID=:userId and f.TYPE = 2 ");
|
String countSql = "select count(*) from ("+sql.toString() + ") t ";
|
return baseDao.queryForInteger(countSql.toString(),params);
|
}
|
|
@Override
|
public PageInfo queryMyFavoriteKwData(PageInfo pageInfo,Map<String, String> params) {
|
StringBuilder builder = new StringBuilder();
|
getMyFavoriteKwSql(builder);
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, builder.toString(), params);
|
List<Map> datas = info.getDatas();
|
if(datas.size()>0){
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:datas){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
info.setDatas(datas);
|
return info;
|
}
|
|
/**
|
* 获取我收藏的知识列表
|
* @param builder
|
*/
|
private void getMyFavoriteKwSql(StringBuilder builder){
|
builder.append(" SELECT L.ID,L.TITLE,L.TAG,L.SUMMARY,L.CREATE_USER_NAME,L.CREATE_TIME,L.UPDATE_DATE,L.HITS,L.FILE_ID FROM KM_LIBRARY L,KM_LIBRARY_FAVORITE F ");
|
builder.append(" WHERE L.ID = F.LIBRARY_ID AND F.CREATE_USER_id = :userId ORDER BY L.UPDATE_DATE DESC ");
|
}
|
|
@Override
|
public Integer queryMyFavoriteKwCount(Map<String, String> params) {
|
StringBuilder builder = new StringBuilder();
|
getMyFavoriteKwSql(builder);
|
String countSql = "select count(*) from ("+builder.toString() + ") t ";
|
return baseDao.queryForInteger(countSql.toString(),params);
|
}
|
|
@Override
|
public PageInfo queryMyKwData(PageInfo pageInfo,Map<String, String> params) {
|
StringBuilder builder = new StringBuilder();
|
getMyKwSql(builder);
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, builder.toString(), params);
|
List<Map> datas = info.getDatas();
|
if(datas.size()>0){
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:datas){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
info.setDatas(datas);
|
return info;
|
}
|
|
/**
|
* 获取我的知识列表
|
* @param builder
|
*/
|
private void getMyKwSql(StringBuilder builder){
|
builder.append(" SELECT ID,TITLE,TAG,SUMMARY,CREATE_USER_NAME,CREATE_TIME,UPDATE_DATE,HITS,FILE_ID FROM KM_LIBRARY ");
|
builder.append(" WHERE CREATE_USER_id = :userId ORDER BY UPDATE_DATE DESC ");
|
}
|
|
@Override
|
public Integer queryMyKwCount(Map<String, String> params) {
|
StringBuilder builder = new StringBuilder();
|
getMyKwSql(builder);
|
String countSql = "select count(*) from ("+builder.toString() + ") t ";
|
return baseDao.queryForInteger(countSql.toString(),params);
|
}
|
|
@Override
|
public Map queryProjectSeviceList(HttpServletRequest request) {
|
String sl = request.getParameter("sl");
|
|
String dept = ConvertUtil.obj2StrBlank(WebUtil.getWywEngineerLoginUser(request).get("YJBMBH"));
|
String sql="SELECT * FROM SC_SERVCE_CATEGORY WHERE STATE = 1 AND TYPE = 2 ORDER BY LEVEL,SERIAL ";
|
|
List<Map> categoryList = baseDao.queryForList(sql,new SqlParameter().addValue("dept", dept));
|
|
Map slMap = new HashMap();
|
if(StringUtil.notEmpty(sl)) {
|
String[] sls = sl.split(",");
|
for(String s : sls) {
|
slMap.put(s, s);
|
}
|
}
|
|
Map result = new HashMap();
|
|
List<Map> resultList = new LinkedList<Map>();
|
|
Map<String, Map> yjgnCache = new HashMap<String, Map>();
|
Map<String, Map> ejgnCache = new HashMap<String, Map>();
|
Map<String, Map> sjgnCache = new HashMap<String, Map>();
|
|
for (Map map : categoryList) {
|
|
//一级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("1")) {
|
yjgnCache.put(map.get("ID").toString(), map);
|
List<Map> ejgnList = new LinkedList<Map>();
|
map.put("ejTree", ejgnList);
|
resultList.add(map);
|
continue;
|
}
|
//二级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("2")) {
|
Map yjgnMap = yjgnCache.get(map.get("P_ID").toString());
|
List<Map> list = (List<Map>)yjgnMap.get("ejTree");
|
map.put("sjTree", new LinkedList<Map>());
|
list.add(map);
|
|
ejgnCache.put(map.get("ID").toString(), map);
|
continue;
|
}
|
//三级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("3")) {
|
if(null!=map.get("P_ID")){
|
|
if(slMap.containsKey(map.get("ID"))) {
|
slMap.put(map.get("ID"), map.get("CATEGORY_NAME"));
|
map.put("check", 1);
|
} else {
|
map.put("check", 2);
|
}
|
|
Map ejgnMap = ejgnCache.get(map.get("P_ID").toString());
|
List<Map> list = (List<Map>)ejgnMap.get("sjTree");
|
list.add(map);
|
}
|
}
|
}
|
Map resultMap = new HashMap();
|
resultMap.put("categoryList", resultList);
|
resultMap.put("slMap", slMap);
|
return resultMap;
|
}
|
|
@Override
|
public Map categoryListTree(HttpServletRequest request) {
|
String deptId = ConvertUtil.obj2StrBlank(WebUtil.getWywEngineerLoginUser(request).get("YJBMBH"));
|
String userId = WebUtil.getWywEngineerLoginUser(request).get("ID").toString();
|
String company = request.getParameter("company");
|
String dept = request.getParameter("dept");
|
String sql="SELECT * FROM KM_LIBRARY_CATEGORY WHERE STATE = 1 ";
|
sql +=" ORDER BY LEVEL,SERIAL ";
|
Map slMap = new HashMap();
|
String sl = request.getParameter("sl");
|
if(StringUtil.notEmpty(sl)) {
|
String[] sls = sl.split(",");
|
for(String s : sls) {
|
slMap.put(s, s);
|
}
|
}
|
List<Map> categoryList = baseDao.queryForList(sql);
|
|
Map result = new HashMap();
|
|
List<Map> resultList = new LinkedList<Map>();
|
|
Map<String, Map> yjgnCache = new HashMap<String, Map>();
|
Map<String, Map> ejgnCache = new HashMap<String, Map>();
|
Map<String, Map> sjgnCache = new HashMap<String, Map>();
|
|
for (Map map : categoryList) {
|
|
//一级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("1")) {
|
yjgnCache.put(map.get("ID").toString(), map);
|
List<Map> ejgnList = new LinkedList<Map>();
|
map.put("ejTree", ejgnList);
|
resultList.add(map);
|
continue;
|
}
|
//二级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("2")) {
|
Map yjgnMap = yjgnCache.get(map.get("TAG").toString());
|
List<Map> list = (List<Map>)yjgnMap.get("ejTree");
|
map.put("sjTree", new LinkedList<Map>());
|
list.add(map);
|
|
ejgnCache.put(map.get("ID").toString(), map);
|
continue;
|
}
|
//三级树
|
if (map.get("LEVEL").toString().equalsIgnoreCase("3")) {
|
if(null!=map.get("TAG")){
|
if(slMap.containsKey(map.get("ID"))) {
|
slMap.put(map.get("ID"), map.get("TITLE"));
|
map.put("check", 1);
|
} else {
|
map.put("check", 2);
|
}
|
|
Map ejgnMap = ejgnCache.get(map.get("TAG").toString());
|
List<Map> list = (List<Map>)ejgnMap.get("sjTree");
|
list.add(map);
|
}
|
}
|
}
|
Map resultMap = new HashMap();
|
resultMap.put("categoryList", resultList);
|
resultMap.put("slMap", slMap);
|
return resultMap;
|
}
|
|
@Override
|
public Map saveKnowledge(HttpServletRequest request,
|
KM_LIBRARY_TEMP km_library_temp) {
|
Map resultMap = new HashMap();
|
resultMap.put("result", 2);
|
Map user = WebUtil.getWywEngineerLoginUser(request);
|
String changeId = request.getParameter("changeId");
|
String bustype = request.getParameter("bustype");
|
String sh = request.getParameter("sh");
|
String add = String.valueOf(request.getAttribute("add"));
|
if(!"1".equals(sh)){
|
if(StringUtil.isEmpty(add)){
|
km_library_temp.setContent_state(1);
|
}else{
|
km_library_temp.setContent_state(2);
|
km_library_temp.setId(null);
|
}
|
}
|
String version = request.getParameter("version");
|
|
String userId = ConvertUtil.obj2StrBlank(user.get("ID"));
|
String userName = ConvertUtil.obj2StrBlank(user.get("ZSXM"));
|
|
String serivceListId = request.getParameter("serivceListId");
|
String serivceList = request.getParameter("serivceList");
|
String category_id = request.getParameter("category_id");
|
String categoryList = request.getParameter("categoryList");
|
String thirdlevel_id = request.getParameter("thirdlevel_id");
|
String thirdlevelList = request.getParameter("thirdlevelList");
|
|
String first_category_id = new String();
|
String first_category_name = new String();
|
String second_category_id = new String();
|
String second_category_name = new String();
|
String third_category_id = new String();
|
String third_category_name = new String();
|
String categoryid = new String();
|
String category_name = new String();
|
String first_knowcategory_id = new String();
|
String first_knowcategory_name = new String();
|
String second_knowcategory_id = new String();
|
String second_knowcategory_name = new String();
|
String third_level_id = new String();
|
String third_level_name = new String();
|
String first_level_id = new String();
|
String first_level_name = new String();
|
String second_level_id = new String();
|
String second_level_name = new String();
|
if(StringUtil.notEmpty(serivceListId) && StringUtil.notEmpty(serivceList)) {
|
String[] serivceListIds = serivceListId.split("-");
|
String[] serivceLists = serivceList.split("-");
|
if(serivceListIds.length>0){
|
first_category_id = serivceListIds[0];
|
first_category_name = serivceLists[0];
|
second_category_id = serivceListIds[1];
|
second_category_name = serivceLists[1];
|
third_category_id = serivceListIds[2];
|
third_category_name = serivceLists[2];
|
}
|
}
|
if(StringUtil.notEmpty(category_id) && StringUtil.notEmpty(categoryList)) {
|
String[] categoryListIds = category_id.split("-");
|
String[] categoryLists = categoryList.split("-");
|
if(categoryListIds.length>0){
|
first_knowcategory_id = categoryListIds[0];
|
first_knowcategory_name = categoryLists[0];
|
second_knowcategory_id = categoryListIds[1];
|
second_knowcategory_name = categoryLists[1];
|
categoryid = categoryListIds[2];
|
category_name = categoryLists[2];
|
}
|
}
|
if(StringUtil.notEmpty(thirdlevel_id) && StringUtil.notEmpty(thirdlevelList)) {
|
String[] thirdListIds = thirdlevel_id.split("-");
|
String[] thirdLists = thirdlevelList.split("-");
|
if(thirdListIds.length>0){
|
first_level_id = thirdListIds[0];
|
first_level_name = thirdLists[0];
|
second_level_id = thirdListIds[1];
|
second_level_name = thirdLists[1];
|
third_level_id = thirdListIds[2];
|
third_level_name = thirdLists[2];
|
}
|
}
|
//待审核
|
Integer auditState = Constants.KM_LIBRARY_TEMP_AUDIT_STATE_DSH;
|
Map shuser = knowledgeDealFacade.getSpMap(categoryid);
|
String shId = ConvertUtil.obj2StrBlank(shuser.get("AUDITOR_ID"));
|
String shName = "";
|
if(StringUtil.isEmpty(shId)){
|
shuser = knowledgeDealFacade.getDefaultSpMap();
|
shId = ConvertUtil.obj2StrBlank(shuser.get("AUDITOR_ID"));
|
if(!StringUtil.isEmpty(shId)){
|
shName = ConvertUtil.obj2StrBlank(shuser.get("AUDITOR_NAME"));
|
}
|
}else{
|
shName = ConvertUtil.obj2StrBlank(shuser.get("AUDITOR_NAME"));
|
}
|
if(!StringUtil.isEmpty(shId)){
|
|
//是否用户可见
|
Integer access_type = ConvertUtil.obj2Integer(request.getParameter("isKj"));
|
|
long createTime = DateUtil.getCurrentDate14();
|
km_library_temp.setFirst_knowcategory_id(first_knowcategory_id).setFirst_knowcategory_name(first_knowcategory_name)
|
.setSecond_knowcategory_id(second_knowcategory_id).setSecond_knowcategory_name(second_knowcategory_name)
|
.setCategory_id(categoryid).setCategory_name(category_name)
|
.setFirstlevel_id(first_level_id).setFirstlevel_name(first_level_name)
|
.setSecondlevel_id(second_level_id).setSecondlevel_name(second_level_name)
|
.setThirdlevel_id(third_level_id).setThirdlevel_name(third_level_name)
|
.setFirst_category_id(first_category_id).setFirst_category_name(first_category_name)
|
.setSecond_category_id(second_category_id).setSecond_category_name(second_category_name)
|
.setThird_category_id(third_category_id).setThird_category_name(third_category_name)
|
.setUpdate_date(createTime).setUpdater_id(userId).setUpdate_name(userName).setHits(0).setIs_editor(ConvertUtil.obj2Integer(request.getParameter("is_editor")));
|
if(StringUtil.isBlank(km_library_temp.getId())){
|
km_library_temp.setCreate_user_id(userId).setCreate_user_name(userName).setCreate_time(createTime);
|
}
|
km_library_temp.setState(ConvertUtil.obj2Integer(1)).setAudit_state(auditState).setAudit_userid(shId).setAudit_username(shName).setAccess_type(access_type).insertOrUpdate();
|
if(ConvertUtil.obj2Integer(km_library_temp.getContent_state()) == 1){
|
km_library_temp.setBefore_version(null).setAfter_version(1).setVersion("1").update();
|
}else{
|
KM_LIBRARY kn = new KM_LIBRARY(request.getParameter("id")).getInstanceById();
|
km_library_temp.setCreate_user_id(kn.getCreate_user_id()).setCreate_user_name(kn.getCreate_user_name()).setCreate_time(kn.getCreate_time());
|
km_library_temp.setOriginal_id(request.getParameter("id")).setVersion((ConvertUtil.obj2Integer(version)+1)+"").setAfter_version(ConvertUtil.obj2Integer(version)+1).setBefore_version(ConvertUtil.obj2Integer(version)).update();
|
}
|
|
//修改的时候不更新这些消息
|
if(ConvertUtil.obj2Integer(km_library_temp.getContent_state()) == 1){
|
//添加用户权限信息
|
String cusId = request.getParameter("cusId");
|
String cusList = request.getParameter("cusList");
|
if(access_type == 1 ){ //需要设置权限
|
KM_LIBRARY_KNOWLEDGE_ACCESS_TEMP access_temp = new KM_LIBRARY_KNOWLEDGE_ACCESS_TEMP();
|
//每次重新存之前先删除先前的数据
|
baseDao.execute("DELETE FROM KM_LIBRARY_KNOWLEDGE_ACCESS WHERE KNOWLEDGE_ID = :knowId", new SqlParameter("knowId",km_library_temp.getId()));
|
String[] cusIdArray = cusId.split(",");
|
String[] cusListArray = cusList.split(",");
|
for (int i = 0; i < cusIdArray.length; i++) {
|
access_temp = new KM_LIBRARY_KNOWLEDGE_ACCESS_TEMP();
|
access_temp.setKnowledge_id(km_library_temp.getId()).setCustomer_id(cusIdArray[i]).setCustomer_name(cusListArray[i]).insert();
|
}
|
}
|
|
|
//添加关联知识
|
//删除已存在的关联知识
|
baseDao.execute("DELETE FROM KM_LIBRARY_KNOWLEDGE_TEMP WHERE LIBRARY_ID = :business_id ", new SqlParameter("business_id",km_library_temp.getId()));
|
String[] knowId = request.getParameterValues("knowId");
|
if(null!=knowId && knowId.length>0) {
|
List<SqlParameter> paramList = new ArrayList<SqlParameter>();
|
for(String str : knowId) {
|
SqlParameter sqlParameter = new SqlParameter();
|
sqlParameter.put("id", StringUtil.getUUID());
|
sqlParameter.put("library_id", km_library_temp.getId());
|
sqlParameter.put("knowledge_id", str);
|
paramList.add(sqlParameter);
|
}
|
String insertSql = "INSERT INTO KM_LIBRARY_KNOWLEDGE_TEMP(ID,LIBRARY_ID,KNOWLEDGE_ID) VALUES (:id,:library_id,:knowledge_id)";
|
baseDao.executeBatch(insertSql, paramList);
|
}
|
|
}
|
|
//提交工单时上传文档附件
|
//fileService.uploadFile(request,km_library_temp.getId(),Constants.GG_FOLDERS_KNOWFOLDERS,Constants.FILE_STATE_SHTG,null);
|
SysInfoMsg msg = new SysInfoMsg("2",shName,"知识审核");
|
resultMap.put("msg", msg);
|
resultMap.put("result", 1);
|
//转知识
|
if(!StringUtil.isEmpty(changeId)){
|
if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT == ConvertUtil.obj2Int(bustype)){
|
SC_WORKFLOW_INCIDENT incident = new SC_WORKFLOW_INCIDENT(changeId);
|
incident.setKnowledgeid(km_library_temp.getId()).update();
|
}else if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_QUESTION == ConvertUtil.obj2Int(bustype)){
|
SC_WORKFLOW_QUESTION question = new SC_WORKFLOW_QUESTION(changeId);
|
question.setKnowledgeid(km_library_temp.getId()).update();
|
}else if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT_LOCAL == ConvertUtil.obj2Int(bustype)){
|
SC_WORKFLOW_INCIDENT_LOCAL zcyw = new SC_WORKFLOW_INCIDENT_LOCAL(changeId);
|
zcyw.setKnowledgeid(km_library_temp.getId()).update();
|
}
|
}
|
}else{
|
resultMap.put("nouser", 1);
|
}
|
|
return resultMap;
|
|
}
|
|
@Override
|
public int knowtypeCount(Map<String, String> params) {
|
String type = params.get("type");
|
StringBuilder sql = new StringBuilder("SELECT COUNT(ID) FROM KM_LIBRARY WHERE STATE = 1 ");
|
if("jh".equals(type)){
|
sql.append(" AND IS_ESSENCE = 1 ");
|
}
|
if("top".equals(type)){
|
sql.append(" AND IS_TOP = 1 ");
|
}
|
return baseDao.queryForInteger(sql.toString(), params);
|
}
|
|
@Override
|
public PageInfo knowtypeData(PageInfo pageInfo, Map<String, String> params) {
|
String type = params.get("type");
|
StringBuilder sql = new StringBuilder("SELECT ID,TITLE,TAG,SUMMARY,CREATE_USER_NAME,HITS,CREATE_TIME,FILE_ID FROM KM_LIBRARY WHERE STATE = 1 ");
|
if("new".equals(type)){
|
sql.append(" ORDER BY CREATE_TIME DESC ");
|
}
|
if("jh".equals(type)){
|
sql.append(" AND IS_ESSENCE = 1 ORDER BY CREATE_TIME DESC ");
|
}
|
if("top".equals(type)){
|
sql.append(" AND IS_TOP = 1 ORDER BY CREATE_TIME DESC ");
|
}
|
if("hot".equals(type)){
|
sql.append(" ORDER BY HITS DESC ");
|
}
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
|
List<Map> knowList = info.getDatas();
|
if(knowList.size()>0){
|
for (Map map : knowList) {
|
map.put("CREATE_TIME", DateUtil.format("yyyy-MM-dd HH:mm:ss", map.get("CREATE_TIME")));
|
//标签
|
String tag = ConvertUtil.obj2Str(map.get("TAG"));
|
if (tag != null) {
|
String[] tags = tag.split("\\s");
|
List<String> tagList = new ArrayList();
|
for(int i=0;i<tags.length;i++){
|
if(!StringUtil.isEmpty(tags[i])){
|
tagList.add(tags[i]);
|
}
|
}
|
map.put("tagList", tagList);
|
}
|
}
|
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:knowList){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
info.setDatas(knowList);
|
return info;
|
}
|
|
@Override
|
public int queryUserCount(Map<String, String> params) {
|
String sql1 = "SELECT * FROM KM_EXPERT_LEVEL_RULE ORDER BY SCORE ";
|
List<Map> list = baseDao.queryForList(sql1);
|
Map cacheMap = new HashMap();
|
for(Map map:list){
|
int score = ConvertUtil.obj2Int(map.get("SCORE"));
|
cacheMap.put(map.get("TYPE"),score);
|
}
|
String type = params.get("type");
|
StringBuilder sql = new StringBuilder("SELECT COUNT(ID) FROM GG_USER WHERE ZT = 1 ");
|
if(!StringUtil.isEmpty(type)){
|
|
if(ConvertUtil.obj2Integer(type) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ){
|
sql.append(" AND KM_SCORE >=:score1 AND KM_SCORE< :score2 ");
|
params.put("score1",ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ)) );
|
params.put("score2", ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ)));
|
}else if(ConvertUtil.obj2Integer(type) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ){
|
sql.append(" AND KM_SCORE >=:score1 AND KM_SCORE< :score2 ");
|
params.put("score1",ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ)) );
|
params.put("score2", ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ)));
|
}else if(ConvertUtil.obj2Integer(type) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ){
|
sql.append(" AND KM_SCORE >=:score1 AND KM_SCORE< :score2 ");
|
params.put("score1",ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ)) );
|
params.put("score2", ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ)));
|
}else if(ConvertUtil.obj2Integer(type) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ){
|
sql.append(" AND KM_SCORE >=:score1 ");
|
params.put("score1",ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ)) );
|
}
|
}
|
|
return baseDao.queryForInteger(sql.toString(), params);
|
}
|
|
@Override
|
public PageInfo queryUserData(PageInfo pageInfo, Map<String, String> params) {
|
String sql1 = "SELECT * FROM KM_EXPERT_LEVEL_RULE ORDER BY SCORE ";
|
List<Map> list = baseDao.queryForList(sql1);
|
Map cacheMap = new HashMap();
|
for(Map map:list){
|
int score = ConvertUtil.obj2Int(map.get("SCORE"));
|
cacheMap.put(map.get("TYPE"),score);
|
}
|
String type = params.get("type");
|
StringBuilder sql = new StringBuilder("SELECT * FROM GG_USER WHERE ZT = 1 ");
|
if(!StringUtil.isEmpty(type)){
|
|
if(ConvertUtil.obj2Integer(type) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ){
|
sql.append(" AND KM_SCORE >=:score1 AND KM_SCORE< :score2 ");
|
params.put("score1",ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ)) );
|
params.put("score2", ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ)));
|
}else if(ConvertUtil.obj2Integer(type) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ){
|
sql.append(" AND KM_SCORE >=:score1 AND KM_SCORE< :score2 ");
|
params.put("score1",ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ)) );
|
params.put("score2", ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ)));
|
}else if(ConvertUtil.obj2Integer(type) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ){
|
sql.append(" AND KM_SCORE >=:score1 AND KM_SCORE< :score2 ");
|
params.put("score1",ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ)) );
|
params.put("score2", ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ)));
|
}else if(ConvertUtil.obj2Integer(type) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ){
|
sql.append(" AND KM_SCORE >=:score1 ");
|
params.put("score1",ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ)) );
|
}
|
}
|
|
sql.append(" ORDER BY KM_SCORE DESC ");
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
|
List<Map> userList = info.getDatas();
|
|
for(Map map:userList){
|
if(StringUtil.isEmpty(ConvertUtil.obj2StrBlank(map.get("KM_SCORE")))){
|
map.put("KM_SCORE", 0);
|
}
|
int score = ConvertUtil.obj2Int(map.get("KM_SCORE"));
|
if(cacheMap.size()!=0){
|
|
|
if(score < ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ))){
|
map.put("DQDJ", "");
|
map.put("djtype", "");
|
}
|
if(score >= ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ))
|
&& score< ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ))){
|
map.put("DQDJ", Constants.getmapKM_EXPERT_LEVEL_RULE_TYPE_Label(Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ));
|
map.put("djtype", Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ);
|
}
|
if(score >= ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ))
|
&& score< ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ))){
|
map.put("DQDJ", Constants.getmapKM_EXPERT_LEVEL_RULE_TYPE_Label(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ));
|
map.put("djtype", Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ);
|
}
|
if(score >= ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ))
|
&& score< ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ))){
|
map.put("DQDJ", Constants.getmapKM_EXPERT_LEVEL_RULE_TYPE_Label(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ));
|
map.put("djtype", Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ);
|
}
|
if(score >= ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ))){
|
map.put("DQDJ", Constants.getmapKM_EXPERT_LEVEL_RULE_TYPE_Label(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ));
|
map.put("djtype", Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ);
|
}
|
}
|
}
|
|
for(Map map:userList){
|
if(StringUtil.isEmpty(ConvertUtil.obj2StrBlank(map.get("KM_SCORE")))){
|
map.put("KM_SCORE", 0);
|
}
|
int score = ConvertUtil.obj2Int(map.get("KM_SCORE"));
|
if(cacheMap.size()!=0){
|
|
|
if(score < ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ))){
|
map.put("DQDJ", "");
|
map.put("djtype", "");
|
}
|
if(score >= ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ))
|
&& score< ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ))){
|
map.put("DQDJ", Constants.getmapKM_EXPERT_LEVEL_RULE_TYPE_Label(Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ));
|
map.put("djtype", Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ);
|
}
|
if(score >= ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ))
|
&& score< ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ))){
|
map.put("DQDJ", Constants.getmapKM_EXPERT_LEVEL_RULE_TYPE_Label(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ));
|
map.put("djtype", Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ);
|
}
|
if(score >= ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ))
|
&& score< ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ))){
|
map.put("DQDJ", Constants.getmapKM_EXPERT_LEVEL_RULE_TYPE_Label(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ));
|
map.put("djtype", Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ);
|
}
|
if(score >= ConvertUtil.obj2Int(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ))){
|
map.put("DQDJ", Constants.getmapKM_EXPERT_LEVEL_RULE_TYPE_Label(Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ));
|
map.put("djtype", Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ);
|
}
|
}
|
}
|
info.setDatas(userList);
|
return info;
|
}
|
|
@Override
|
public int getMyKnowCount(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("SELECT COUNT(DISTINCT K.ID) FROM KM_LIBRARY K LEFT JOIN KM_LIBRARY_TEMP F ON K.ID = F.ORIGINAL_ID WHERE 1=1 ");
|
return baseDao.queryForInteger(sql.toString(), params);
|
}
|
@Override
|
public PageInfo getMyKnowData(Map<String, String> params, PageInfo pageInfo) {
|
StringBuilder sql = new StringBuilder("SELECT DISTINCT K.*,K.STATE K_STATE,F.AUDIT_STATE STATE FROM KM_LIBRARY K LEFT JOIN KM_LIBRARY_TEMP F ON K.ID = F.ORIGINAL_ID WHERE 1=1 ");
|
sql.append(" ORDER BY K.STATE,K.CREATE_TIME DESC");
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
|
List<Map> knowList = info.getDatas();
|
if(knowList.size()>0){
|
for (Map map : knowList) {
|
map.put("CREATE_TIME", DateUtil.format("yyyy-MM-dd HH:mm:ss", map.get("CREATE_TIME")));
|
//标签
|
String tag = ConvertUtil.obj2Str(map.get("TAG"));
|
if (tag != null) {
|
String[] tags = tag.split("\\s");
|
List<String> tagList = new ArrayList();
|
for(int i=0;i<tags.length;i++){
|
if(!StringUtil.isEmpty(tags[i])){
|
tagList.add(tags[i]);
|
}
|
}
|
map.put("tagList", tagList);
|
}
|
}
|
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:knowList){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
info.setDatas(knowList);
|
return info;
|
}
|
|
@Override
|
public Integer queryKnowledgeShCount(Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("SELECT COUNT(DISTINCT K.ID) FROM ( ");
|
sql.append("( SELECT ID, TITLE, TAG, SUMMARY, CONTENT, CATEGORY_ID, CATEGORY_NAME, CREATE_USER_ID, CREATE_USER_NAME, CREATE_TIME, STATE, VERSION, HITS, IS_EDITOR, THIRDLEVEL_NAME, THIRDLEVEL_ID, FIRST_CATEGORY_ID, FIRST_CATEGORY_NAME, SECOND_CATEGORY_ID, SECOND_CATEGORY_NAME, THIRD_CATEGORY_ID, THIRD_CATEGORY_NAME, UPDATE_DATE, UPDATER_ID, UPDATE_NAME, SECOND_KNOWCATEGORY_ID, SECOND_KNOWCATEGORY_NAME, FIRST_KNOWCATEGORY_ID, FIRST_KNOWCATEGORY_NAME, SECONDLEVEL_NAME, SECONDLEVEL_ID, FIRSTLEVEL_NAME, FIRSTLEVEL_ID, ACCESS_TYPE, AUDIT_STATE ,AUDIT_USERID FROM km_library_temp ) ");
|
sql.append(" UNION ALL( SELECT ID, TITLE, TAG, SUMMARY, CONTENT, CATEGORY_ID, CATEGORY_NAME, CREATE_USER_ID, CREATE_USER_NAME, CREATE_TIME, STATE, VERSION, HITS, IS_EDITOR, THIRDLEVEL_NAME, THIRDLEVEL_ID, FIRST_CATEGORY_ID, FIRST_CATEGORY_NAME, SECOND_CATEGORY_ID, SECOND_CATEGORY_NAME, THIRD_CATEGORY_ID, THIRD_CATEGORY_NAME, UPDATE_DATE, UPDATER_ID, UPDATE_NAME, SECOND_KNOWCATEGORY_ID, SECOND_KNOWCATEGORY_NAME, FIRST_KNOWCATEGORY_ID, FIRST_KNOWCATEGORY_NAME, SECONDLEVEL_NAME, SECONDLEVEL_ID, FIRSTLEVEL_NAME, FIRSTLEVEL_ID, ACCESS_TYPE, 2 AS AUDIT_STATE,AUDIT_USERID FROM km_library )");
|
sql.append(") K WHERE K.STATE=1 AND K.AUDIT_USERID=:loginUserId");
|
return baseDao.queryForInteger(sql.toString(), params);
|
}
|
|
@Override
|
public PageInfo queryKnowledgeShData(PageInfo pageInfo,
|
Map<String, String> params) {
|
StringBuilder sql = new StringBuilder("SELECT k.* FROM ( ");
|
sql.append("( SELECT ID, TITLE, TAG, SUMMARY, CONTENT, CATEGORY_ID, CATEGORY_NAME, CREATE_USER_ID, CREATE_USER_NAME, CREATE_TIME, STATE, VERSION, HITS, IS_EDITOR, THIRDLEVEL_NAME, THIRDLEVEL_ID, FIRST_CATEGORY_ID, FIRST_CATEGORY_NAME, SECOND_CATEGORY_ID, SECOND_CATEGORY_NAME, THIRD_CATEGORY_ID, THIRD_CATEGORY_NAME, UPDATE_DATE, UPDATER_ID, UPDATE_NAME, SECOND_KNOWCATEGORY_ID, SECOND_KNOWCATEGORY_NAME, FIRST_KNOWCATEGORY_ID, FIRST_KNOWCATEGORY_NAME, SECONDLEVEL_NAME, SECONDLEVEL_ID, FIRSTLEVEL_NAME, FIRSTLEVEL_ID, ACCESS_TYPE, AUDIT_STATE ,AUDIT_USERID FROM km_library_temp ) ");
|
sql.append(" UNION ALL( SELECT ID, TITLE, TAG, SUMMARY, CONTENT, CATEGORY_ID, CATEGORY_NAME, CREATE_USER_ID, CREATE_USER_NAME, CREATE_TIME, STATE, VERSION, HITS, IS_EDITOR, THIRDLEVEL_NAME, THIRDLEVEL_ID, FIRST_CATEGORY_ID, FIRST_CATEGORY_NAME, SECOND_CATEGORY_ID, SECOND_CATEGORY_NAME, THIRD_CATEGORY_ID, THIRD_CATEGORY_NAME, UPDATE_DATE, UPDATER_ID, UPDATE_NAME, SECOND_KNOWCATEGORY_ID, SECOND_KNOWCATEGORY_NAME, FIRST_KNOWCATEGORY_ID, FIRST_KNOWCATEGORY_NAME, SECONDLEVEL_NAME, SECONDLEVEL_ID, FIRSTLEVEL_NAME, FIRSTLEVEL_ID, ACCESS_TYPE, 2 AS AUDIT_STATE,AUDIT_USERID FROM km_library )");
|
sql.append(" ) K WHERE K.STATE=1 AND K.AUDIT_USERID=:loginUserId AND K.AUDIT_STATE = 1");
|
sql.append(" ORDER BY K.AUDIT_STATE,K.CREATE_TIME DESC");
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
|
|
List<Map> knowList = info.getDatas();
|
if(knowList.size()>0){
|
for (Map map : knowList) {
|
map.put("CREATE_TIME", DateUtil.format("yyyy-MM-dd HH:mm:ss", map.get("CREATE_TIME")));
|
//标签
|
String tag = ConvertUtil.obj2Str(map.get("TAG"));
|
if (tag != null) {
|
String[] tags = tag.split("\\s");
|
List<String> tagList = new ArrayList();
|
for(int i=0;i<tags.length;i++){
|
if(!StringUtil.isEmpty(tags[i])){
|
tagList.add(tags[i]);
|
}
|
}
|
map.put("tagList", tagList);
|
}
|
}
|
|
List<Map> filesList = baseDao.queryForList("SELECT * FROM GG_FILES");
|
Map cachefile = new HashMap();
|
|
for(Map file:filesList){
|
if(!cachefile.containsKey(file.get("BUSINESS_ID"))){
|
cachefile.put(file.get("BUSINESS_ID"), file);
|
}
|
}
|
for(Map map:knowList){
|
if(cachefile.containsKey(map.get("FILE_ID"))){
|
map.put("isfiles", "1");
|
}else{
|
map.put("isfiles", "0");
|
}
|
}
|
}
|
info.setDatas(knowList);
|
return info;
|
}
|
|
@Override
|
public Map getKnowledgeMsgById(String id) {
|
Map knowMap = new KM_LIBRARY(id).getBeanMapById();
|
List<Map> knowList = baseDao.queryForList("SELECT B.* FROM KM_LIBRARY_KNOWLEDGE A,KM_LIBRARY B WHERE A.KNOWLEDGE_ID = B.ID AND A.LIBRARY_ID = :business_id", new SqlParameter("business_id",id));
|
knowMap.put("knows", knowList);
|
//用户可见权限 用户
|
List<Map> cusList = baseDao.queryForList("SELECT * FROM KM_LIBRARY_KNOWLEDGE_ACCESS WHERE KNOWLEDGE_ID = :id", new SqlParameter().addValue("id", knowMap.get("ID")));
|
String cusIdStr = new String();
|
String cusListStr = new String();
|
if(cusList.size() > 0){
|
for (Map map : cusList) {
|
cusIdStr += map.get("CUSTOMER_ID") + ",";
|
cusListStr += map.get("CUSTOMER_NAME") + ",";
|
}
|
knowMap.put("cusId", cusIdStr.substring(0, cusIdStr.length()-1));
|
knowMap.put("cusList", cusListStr.substring(0, cusListStr.length()-1));
|
}else{
|
knowMap.put("cusId", cusIdStr);
|
knowMap.put("cusList", cusListStr);
|
}
|
//组织三级分类数据
|
String category_id = knowMap.get("FIRST_KNOWCATEGORY_ID").toString() + "-" + knowMap.get("SECOND_KNOWCATEGORY_ID") + "-" + knowMap.get("CATEGORY_ID");
|
String categoryList = knowMap.get("FIRST_KNOWCATEGORY_NAME").toString() + "-" + knowMap.get("SECOND_KNOWCATEGORY_NAME") + "-" + knowMap.get("CATEGORY_NAME");
|
String serivceListId = knowMap.get("FIRST_CATEGORY_ID").toString() + "-" + knowMap.get("SECOND_CATEGORY_ID") + "-" + knowMap.get("THIRD_CATEGORY_ID");
|
String serivceList = knowMap.get("FIRST_CATEGORY_NAME").toString() + "-" + knowMap.get("SECOND_CATEGORY_NAME") + "-" + knowMap.get("THIRD_CATEGORY_NAME");
|
String thirdlevel_id = knowMap.get("FIRSTLEVEL_ID").toString() + "-" + knowMap.get("SECONDLEVEL_ID") + "-" + knowMap.get("THIRDLEVEL_ID");
|
String thirdlevelList = knowMap.get("FIRSTLEVEL_NAME").toString() + "-" + knowMap.get("SECONDLEVEL_NAME") + "-" + knowMap.get("THIRDLEVEL_NAME");
|
knowMap.put("category_id", category_id);
|
knowMap.put("categoryList", categoryList);
|
knowMap.put("serivceListId", serivceListId);
|
knowMap.put("serivceList", serivceList);
|
knowMap.put("thirdlevel_id", thirdlevel_id);
|
knowMap.put("thirdlevelList", thirdlevelList);
|
//是否用户可见变量名字替换
|
String tempStr = knowMap.get("ACCESS_TYPE").toString();
|
knowMap.put("isKj", tempStr);
|
//文件
|
List<Map> fileList = fileService.getFileList(ConvertUtil.obj2StrBlank(knowMap.get("FILE_ID")));
|
knowMap.put("fileList", fileList);
|
return knowMap;
|
}
|
|
@Override
|
public Map getLibraryShById(String libraryId, String userId) {
|
//基本信息
|
StringBuilder sql = new StringBuilder("select k.*,c.IS_ESSENCE,c.IS_TOP,c.FILE_ID ");
|
sql.append("from KM_LIBRARY_TEMP k LEFT JOIN KM_LIBRARY c ON k.ORIGINAL_ID = c.ID ");
|
sql.append(" WHERE k.ID = :id ");
|
SqlParameter param = new SqlParameter();
|
param.addValue("id", libraryId);
|
|
Map map = baseDao.queryForMap(sql.toString(), param);
|
if(!StringUtil.isEmpty(ConvertUtil.obj2StrBlank(map.get("ORIGINAL_ID")))){
|
param.put("type", Constants.KM_SCORE_RULE_TYPE_D);
|
param.addValue("id", map.get("ORIGINAL_ID"));
|
int zan = baseDao.queryForInteger("SELECT COUNT(ID) FROM KM_RECORD WHERE LIBRARY_ID = :id AND TYPE = :type ", param);
|
param.put("type", Constants.KM_SCORE_RULE_TYPE_C);
|
int cai = baseDao.queryForInteger("SELECT COUNT(ID) FROM KM_RECORD WHERE LIBRARY_ID = :id AND TYPE = :type ", param);
|
map.put("ZANNUM", zan);
|
map.put("CAINUM", cai);
|
List<Map> mylist = kmService.getmyFavourite(userId);
|
List<Map> myrecord = kmService.getmyknowRecord(userId);
|
for(Map mymap :mylist){
|
if(map.get("ORIGINAL_ID").equals(mymap.get("LIBRARY_ID"))){
|
map.put("favourite", 1);
|
}
|
}
|
for(Map mymap :myrecord){
|
if(map.get("ORIGINAL_ID").equals(mymap.get("LIBRARY_ID"))){
|
if(ConvertUtil.obj2Integer(mymap.get("TYPE")) == Constants.KM_SCORE_RULE_TYPE_D){
|
map.put("zan", 1);
|
}
|
if(ConvertUtil.obj2Integer(mymap.get("TYPE")) == Constants.KM_SCORE_RULE_TYPE_C){
|
map.put("cai", 1);
|
}
|
}
|
}
|
}
|
|
//标签
|
String tag = ConvertUtil.obj2Str(map.get("TAG"));
|
if (tag != null) {
|
String[] tags = tag.split("\\s");
|
List<String> tagList = new ArrayList();
|
for(int i=0;i<tags.length;i++){
|
if(!StringUtil.isEmpty(tags[i])){
|
tagList.add(tags[i]);
|
}
|
}
|
map.put("tag_list", tagList);
|
|
}
|
|
//附件
|
List<Map> fileList = fileService.getFileList(ConvertUtil.obj2StrBlank(map.get("ID")));
|
map.put("file_list",fileList );
|
|
|
//知识关联
|
String linksql = "select B.ID,B.TITLE from KM_LIBRARY_KNOWLEDGE A,KM_LIBRARY B where A.KNOWLEDGE_ID = B.ID AND A.LIBRARY_ID=:library_id ";
|
List<Map> linkList = baseDao.queryForList(linksql, new SqlParameter("library_id", new KM_LIBRARY_TEMP(libraryId).getInstanceById().getOriginal_id()));
|
map.put("link_list", linkList);
|
map.put("filesize", fileList.size());
|
map.put("knowsize", linkList.size());
|
return map;
|
}
|
|
@Override
|
public Map getFileFoldersById(String id) {
|
String sql = "SELECT * FROM GG_FOLDERS WHERE ID = :id";
|
|
return baseDao.queryForMap(sql, new SqlParameter("id",id));
|
}
|
|
@Override
|
public Map getKnowMsgByOrderId(String orderId, String bustype) {
|
Map knowmsg = new HashMap();
|
Map ordermsg = new HashMap();
|
Map param = new HashMap();
|
param.put("orderId", orderId);
|
if(!StringUtil.isEmpty(bustype)&&!StringUtil.isEmpty(orderId)){
|
if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT == ConvertUtil.obj2Int(bustype)){
|
knowmsg = baseDao.queryForMap("SELECT A.*,B.WFSTATE,B.BUSINESSTYPE FROM SC_WORKFLOW_INCIDENT A,WORKFLOW_BASE B WHERE A.ID = B.BUSINESS_ID AND A.ID = :orderId ", param);
|
knowmsg.put("CONTENT", "解决方案："+knowmsg.get("RESOLVE")+" 优化建议："+knowmsg.get("SUGGEST"));
|
}else if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_QUESTION == ConvertUtil.obj2Int(bustype)){
|
knowmsg = baseDao.queryForMap("SELECT A.*,B.WFSTATE,B.BUSINESSTYPE FROM SC_WORKFLOW_QUESTION A,WORKFLOW_BASE B WHERE A.ID = B.BUSINESS_ID AND A.ID = :orderId ", param);
|
knowmsg.put("CONTENT", "根本原因："+knowmsg.get("TRUE_REASON")+" 解决方案："+knowmsg.get("RESOLVE")+" 优化建议："+knowmsg.get("SUGGEST"));
|
}else if(Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT_LOCAL == ConvertUtil.obj2Int(bustype)){
|
knowmsg = baseDao.queryForMap("SELECT A.*,B.WFSTATE,B.BUSINESSTYPE FROM SC_WORKFLOW_INCIDENT_LOCAL A,WORKFLOW_BASE B WHERE A.ID = B.BUSINESS_ID AND A.ID = :orderId ", param);
|
knowmsg.put("CONTENT", "解决方案："+knowmsg.get("RESOLVE")+" 优化建议："+knowmsg.get("SUGGEST"));
|
}
|
knowmsg.put("TITLE", knowmsg.get("NAME"));
|
knowmsg.put("changeId", orderId);
|
knowmsg.put("bustype", bustype);
|
knowmsg.put("serivceListId", knowmsg.get("FIRST_CATEGORY_ID")+"-"+knowmsg.get("SECOND_CATEGORY_ID")+"-"+knowmsg.get("THIRD_CATEGORY_ID"));
|
knowmsg.put("serivceList", knowmsg.get("FIRST_CATEGORY_NAME")+"-"+knowmsg.get("SECOND_CATEGORY_NAME")+"-"+knowmsg.get("THIRD_CATEGORY_NAME"));
|
List<Map> filelist = fileService.getFileList(ConvertUtil.obj2StrBlank(knowmsg.get("FILE_ID")));
|
for(Map file:filelist){
|
file.put("ID", "");
|
}
|
knowmsg.put("knows", filelist);
|
}
|
return knowmsg;
|
}
|
|
@Override
|
public List queryLinkKnow(HttpServletRequest request) {
|
String title = request.getParameter("title");
|
String keyword = request.getParameter("keyword");
|
String knowIds = request.getParameter("knowIds");
|
String sql;
|
SqlParameter parameter =new SqlParameter();
|
sql = "SELECT A.*,B.TITLE AS NAME FROM KM_LIBRARY A,KM_LIBRARY_CATEGORY B WHERE A.CATEGORY_ID = B.ID AND A.STATE =1 ";
|
parameter.addValue("userId", WebUtil.getWywEngineerLoginUser(request).get("ID"));
|
|
|
if (!StringUtil.isEmpty(knowIds)) {
|
String knowid[] = knowIds.split("-");
|
String para="";
|
for(int i=0;i<knowid.length;i++){
|
if(i<knowid.length-1){
|
para+=knowid[i]+"','";
|
}else if(i==knowid.length-1){
|
para+=knowid[i];
|
}
|
}
|
sql += " and A.ID NOT IN ('"+para+"') ";
|
}
|
if (!StringUtil.isEmpty(title)) {
|
sql+="and A.TITLE like :title ";
|
parameter.addValue("title", "%" + title + "%");
|
}
|
|
if (!StringUtil.isEmpty(keyword)) {
|
sql += " and A.TAG LIKE :keyword ";
|
parameter.addValue("keyword", "%"+keyword+"%");
|
}
|
|
sql += " ORDER BY B.ID";
|
List<Map> knows = baseDao.queryForList(sql,parameter);
|
|
return knows;
|
}
|
|
@Override
|
public void saveKnowledge(HttpServletRequest request, KM_LIBRARY km_library) {
|
String serivceListId = request.getParameter("serivceListId");
|
String serivceList = request.getParameter("serivceList");
|
String category_id = request.getParameter("category_id");
|
String categoryList = request.getParameter("categoryList");
|
String thirdlevel_id = request.getParameter("thirdlevel_id");
|
String thirdlevelList = request.getParameter("thirdlevelList");
|
String first_category_id = new String();
|
String first_category_name = new String();
|
String second_category_id = new String();
|
String second_category_name = new String();
|
String third_category_id = new String();
|
String third_category_name = new String();
|
String categoryid = new String();
|
String category_name = new String();
|
String first_knowcategory_id = new String();
|
String first_knowcategory_name = new String();
|
String second_knowcategory_id = new String();
|
String second_knowcategory_name = new String();
|
String third_level_id = new String();
|
String third_level_name = new String();
|
String first_level_id = new String();
|
String first_level_name = new String();
|
String second_level_id = new String();
|
String second_level_name = new String();
|
if(StringUtil.notEmpty(serivceListId) && StringUtil.notEmpty(serivceList)) {
|
String[] serivceListIds = serivceListId.split("-");
|
String[] serivceLists = serivceList.split("-");
|
first_category_id = serivceListIds[0];
|
first_category_name = serivceLists[0];
|
second_category_id = serivceListIds[1];
|
second_category_name = serivceLists[1];
|
third_category_id = serivceListIds[2];
|
third_category_name = serivceLists[2];
|
}
|
if(StringUtil.notEmpty(category_id) && StringUtil.notEmpty(categoryList)) {
|
String[] categoryListIds = category_id.split("-");
|
String[] categoryLists = categoryList.split("-");
|
if(categoryListIds.length>0){
|
first_knowcategory_id = categoryListIds[0];
|
first_knowcategory_name = categoryLists[0];
|
second_knowcategory_id = categoryListIds[1];
|
second_knowcategory_name = categoryLists[1];
|
categoryid = categoryListIds[2];
|
category_name = categoryLists[2];
|
}
|
}
|
if(StringUtil.notEmpty(thirdlevel_id) && StringUtil.notEmpty(thirdlevelList)) {
|
String[] thirdListIds = thirdlevel_id.split("-");
|
String[] thirdLists = thirdlevelList.split("-");
|
if(thirdListIds.length>0){
|
first_level_id = thirdListIds[0];
|
first_level_name = thirdLists[0];
|
second_level_id = thirdListIds[1];
|
second_level_name = thirdLists[1];
|
third_level_id = thirdListIds[2];
|
third_level_name = thirdLists[2];
|
}
|
}
|
Integer access_type = ConvertUtil.obj2Integer(request.getParameter("isKj"));
|
|
km_library.setFirst_knowcategory_id(first_knowcategory_id).setFirst_knowcategory_name(first_knowcategory_name)
|
.setSecond_knowcategory_id(second_knowcategory_id).setSecond_knowcategory_name(second_knowcategory_name)
|
.setCategory_id(categoryid).setCategory_name(category_name)
|
.setFirstlevel_id(first_level_id).setFirstlevel_name(first_level_name)
|
.setSecondlevel_id(second_level_id).setSecondlevel_name(second_level_name)
|
.setThirdlevel_id(third_level_id).setThirdlevel_name(third_level_name)
|
.setFirst_category_id(first_category_id).setFirst_category_name(first_category_name)
|
.setSecond_category_id(second_category_id).setSecond_category_name(second_category_name)
|
.setThird_category_id(third_category_id).setThird_category_name(third_category_name)
|
.setAccess_type(access_type);
|
|
km_library.insertOrUpdate();
|
//添加用户权限信息
|
String cusId = request.getParameter("cusId");
|
String cusList = request.getParameter("cusList");
|
if(access_type == 1){ //需要设置权限
|
KM_LIBRARY_KNOWLEDGE_ACCESS access = new KM_LIBRARY_KNOWLEDGE_ACCESS();
|
//每次重新存之前先删除先前的数据
|
baseDao.execute("DELETE FROM KM_LIBRARY_KNOWLEDGE_ACCESS WHERE KNOWLEDGE_ID = :knowId", new SqlParameter("knowId",km_library.getId()));
|
String[] cusIdArray = cusId.split(",");
|
String[] cusListArray = cusList.split(",");
|
for (int i = 0; i < cusIdArray.length; i++) {
|
access = new KM_LIBRARY_KNOWLEDGE_ACCESS();
|
access.setKnowledge_id(km_library.getId()).setCustomer_id(cusIdArray[i]).setCustomer_name(cusListArray[i]).insert();
|
}
|
}
|
|
//添加关联知识
|
//删除已存在的关联知识
|
baseDao.execute("DELETE FROM KM_LIBRARY_KNOWLEDGE WHERE LIBRARY_ID = :business_id ", new SqlParameter("business_id",km_library.getId()));
|
String[] knowId = request.getParameterValues("knowId");
|
if(null!=knowId && knowId.length>0) {
|
List<SqlParameter> paramList = new ArrayList<SqlParameter>();
|
for(String str : knowId) {
|
SqlParameter sqlParameter = new SqlParameter();
|
sqlParameter.put("id", StringUtil.getUUID());
|
sqlParameter.put("library_id", km_library.getId());
|
sqlParameter.put("knowledge_id", str);
|
paramList.add(sqlParameter);
|
}
|
String insertSql = "INSERT INTO KM_LIBRARY_KNOWLEDGE(ID,LIBRARY_ID,KNOWLEDGE_ID) VALUES (:id,:library_id,:knowledge_id)";
|
baseDao.executeBatch(insertSql, paramList);
|
}
|
//如果为空，给file_id赋值
|
km_library = new KM_LIBRARY().setId(km_library.getId()).getInstanceById();
|
if(StringUtil.isEmpty(km_library.getFile_id())){
|
km_library.setFile_id(km_library.getId()).update();
|
}
|
}
|
|
}
|
