package cn.ksource.web.facade.knowledge.knowtj;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.annotation.Resource;
|
|
import org.springframework.stereotype.Service;
|
|
import cn.ksource.core.dao.BaseDao;
|
import cn.ksource.core.dao.SqlParameter;
|
import cn.ksource.core.util.ConvertUtil;
|
import cn.ksource.core.util.DateUtil;
|
import cn.ksource.core.util.StringUtil;
|
import cn.ksource.web.Constants;
|
|
@Service("knowledgeTjFacade")
|
public class KnowledgeTjFacadeImpl implements KnowledgeTjFacade {
|
|
@Resource
|
private BaseDao baseDao;
|
|
@Override
|
public Map knowCateTjCol(Map<String,String> params) {
|
params.put("beginTime", params.get("beginTime")+"000000");
|
params.put("endTime", params.get("endTime")+"235959");
|
String cateId = params.get("cateId");
|
if(!StringUtil.isEmpty(cateId) ){
|
String[] cateIds = cateId.split("-");
|
params.put("cateId", cateIds[2]);
|
}
|
List<String> categories = new ArrayList<String>();
|
categories.add("新增");
|
categories.add("置顶");
|
categories.add("精华");
|
Map resMap = new HashMap();
|
StringBuilder sql = new StringBuilder("SELECT COUNT(ID) FROM KM_LIBRARY WHERE STATE = 1 ");
|
|
getsql(params,sql,params.get("type"));
|
int allnum = baseDao.queryForInteger(sql.toString(), params);
|
StringBuilder sql1 = new StringBuilder("SELECT COUNT(ID) FROM KM_LIBRARY WHERE STATE = 1 ");
|
params.put("top", "1");
|
getsql(params,sql1,params.get("type"));
|
int topnum = baseDao.queryForInteger(sql1.toString(), params);
|
StringBuilder sql2 = new StringBuilder("SELECT COUNT(ID) FROM KM_LIBRARY WHERE STATE = 1 ");
|
params.put("top", "");
|
params.put("jh", "1");
|
getsql(params,sql2,params.get("type"));
|
int jhnum = baseDao.queryForInteger(sql2.toString(), params);
|
|
Map tempMap = new HashMap();
|
List<Map> series = new ArrayList<Map>();
|
List tempList = new ArrayList();
|
tempList.add(allnum);
|
tempList.add(topnum);
|
tempList.add(jhnum);
|
tempMap.put("data", tempList);
|
tempMap.put("name", "数量");
|
Map data = new HashMap();
|
data.put("enabled", true);
|
data.put("rotation", 360);
|
data.put("color", "#FFFFFF");
|
data.put("align", "right");
|
data.put("x", 4);
|
data.put("y", 10);
|
Map style = new HashMap();
|
style.put("fontSize", "13px");
|
style.put("textShadow", "5 5 3px black");
|
data.put("style", style);
|
tempMap.put("dataLabels",data);
|
series.add(tempMap);
|
resMap.put("series", series);
|
resMap.put("categories", categories);
|
return resMap;
|
}
|
|
public void getsql(Map<String,String> param,StringBuilder sql,String type){
|
String cateId = param.get("cateId");
|
String startDate = param.get("beginTime");
|
String endDate = param.get("endTime");
|
String top = param.get("top");
|
String jh = param.get("jh");
|
if(!StringUtil.isEmpty(cateId) ){
|
|
if("1".equals(type)){
|
sql.append(" AND CATEGORY_ID = :cateId ");
|
}else if("2".equals(type)){
|
sql.append(" AND THIRDLEVEL_ID = :cateId ");
|
}else if("3".equals(type)){
|
sql.append(" AND THIRD_CATEGORY_ID = :cateId ");
|
}
|
}
|
if(!StringUtil.isEmpty(startDate) ){
|
sql.append(" AND CREATE_TIME >= :beginTime ");
|
}
|
if(!StringUtil.isEmpty(endDate) ){
|
sql.append(" AND CREATE_TIME <= :endTime ");
|
}
|
if(!StringUtil.isEmpty(top) ){
|
sql.append(" AND IS_TOP = 1 ");
|
}
|
if(!StringUtil.isEmpty(jh) ){
|
sql.append(" AND IS_ESSENCE = 1 ");
|
}
|
|
}
|
|
@Override
|
public Map knowUserTjCol(Map<String, String> params) {
|
params.put("beginTime", params.get("beginTime")+"000000");
|
params.put("endTime", params.get("endTime")+"235959");
|
String cateId = params.get("cateId");
|
if(!StringUtil.isEmpty(cateId) ){
|
String[] cateIds = cateId.split("-");
|
params.put("cateId", cateIds[2]);
|
}
|
List<String> categories = new ArrayList<String>();
|
categories.add("创建");
|
categories.add("被顶");
|
categories.add("被踩");
|
categories.add("置顶");
|
categories.add("精华");
|
categories.add("编辑");
|
Map resMap = new HashMap();
|
StringBuilder sql = new StringBuilder("SELECT COUNT(A.ID) FROM KM_LIBRARY A WHERE A.STATE = 1 ");
|
getusersql(params,sql);
|
int allnum = baseDao.queryForInteger(sql.toString(), params);
|
|
StringBuilder sql1 = new StringBuilder("SELECT COUNT(A.ID) FROM KM_LIBRARY A WHERE A.STATE = 1 ");
|
params.put("top", "1");
|
getusersql(params,sql1);
|
int topnum = baseDao.queryForInteger(sql1.toString(), params);
|
|
StringBuilder sql2 = new StringBuilder("SELECT COUNT(A.ID) FROM KM_LIBRARY A WHERE A.STATE = 1 ");
|
params.put("top", "");
|
params.put("jh", "1");
|
getusersql(params,sql2);
|
int jhnum = baseDao.queryForInteger(sql2.toString(), params);
|
|
StringBuilder sqltype = new StringBuilder("SELECT COUNT(C.ID) FROM (SELECT DISTINCT A.ID FROM KM_LIBRARY A,KM_RECORD B WHERE A.STATE = 1 AND A.ID = B.LIBRARY_ID ");
|
params.put("type", ConvertUtil.obj2StrBlank(Constants.KM_SCORE_RULE_TYPE_C));
|
params.put("top", "");
|
params.put("jh", "");
|
getusersql(params,sqltype);
|
sqltype.append(") C");
|
int cainum = baseDao.queryForInteger(sqltype.toString(), params);
|
|
StringBuilder sqltype1 = new StringBuilder("SELECT COUNT(C.ID) FROM (SELECT DISTINCT A.ID FROM KM_LIBRARY A,KM_RECORD B WHERE A.STATE = 1 AND A.ID = B.LIBRARY_ID ");
|
params.put("type", ConvertUtil.obj2StrBlank(Constants.KM_SCORE_RULE_TYPE_D));
|
params.put("top", "");
|
params.put("jh", "");
|
getusersql(params,sqltype1);
|
sqltype1.append(") C");
|
int zannum = baseDao.queryForInteger(sqltype1.toString(), params);
|
|
StringBuilder sqltype2 = new StringBuilder("SELECT COUNT(C.ID) FROM (SELECT DISTINCT A.ID FROM KM_LIBRARY A,KM_RECORD B WHERE A.STATE = 1 AND A.ID = B.LIBRARY_ID ");
|
params.put("type", ConvertUtil.obj2StrBlank(Constants.KM_SCORE_RULE_TYPE_BJ));
|
params.put("top", "");
|
params.put("jh", "");
|
getusersql(params,sqltype2);
|
sqltype2.append(") C");
|
int editnum = baseDao.queryForInteger(sqltype2.toString(), params);
|
|
Map tempMap = new HashMap();
|
List<Map> series = new ArrayList<Map>();
|
List tempList = new ArrayList();
|
tempList.add(allnum);
|
tempList.add(zannum);
|
tempList.add(cainum);
|
tempList.add(topnum);
|
tempList.add(jhnum);
|
tempList.add(editnum);
|
tempMap.put("data", tempList);
|
tempMap.put("name", "数量");
|
Map data = new HashMap();
|
data.put("enabled", true);
|
data.put("rotation", 360);
|
data.put("color", "#FFFFFF");
|
data.put("align", "right");
|
data.put("x", 4);
|
data.put("y", 10);
|
Map style = new HashMap();
|
style.put("fontSize", "13px");
|
style.put("textShadow", "5 5 3px black");
|
data.put("style", style);
|
tempMap.put("dataLabels",data);
|
series.add(tempMap);
|
resMap.put("series", series);
|
resMap.put("categories", categories);
|
return resMap;
|
}
|
|
public void getusersql(Map<String,String> param,StringBuilder sql){
|
String user_id = param.get("user_id");
|
String startDate = param.get("beginTime");
|
String endDate = param.get("endTime");
|
String type = param.get("type");
|
String top = param.get("top");
|
String jh = param.get("jh");
|
if(!StringUtil.isEmpty(type)){
|
if(ConvertUtil.obj2Integer(type) == Constants.KM_SCORE_RULE_TYPE_BJ){
|
if(!StringUtil.isEmpty(type) ){
|
sql.append(" AND B.USER_ID = :user_id ");
|
}
|
}else{
|
if(!StringUtil.isEmpty(user_id) ){
|
sql.append(" AND A.CREATE_USER_ID = :user_id ");
|
}
|
}
|
}else{
|
if(!StringUtil.isEmpty(user_id) ){
|
sql.append(" AND A.CREATE_USER_ID = :user_id ");
|
}
|
}
|
|
if(!StringUtil.isEmpty(startDate) ){
|
sql.append(" AND A.CREATE_TIME >= :beginTime ");
|
}
|
if(!StringUtil.isEmpty(endDate) ){
|
sql.append(" AND A.CREATE_TIME <= :endTime ");
|
}
|
if(!StringUtil.isEmpty(top) ){
|
sql.append(" AND A.IS_TOP = 1 ");
|
}
|
if(!StringUtil.isEmpty(jh) ){
|
sql.append(" AND A.IS_ESSENCE = 1 ");
|
}
|
if(!StringUtil.isEmpty(type) ){
|
sql.append(" AND B.TYPE = :type ");
|
}
|
|
}
|
|
@Override
|
public Map knowDataTjCol(Map<String, String> params) {
|
String beginTime = params.get("beginTime");
|
String bfbeginTime = DateUtil.getMonthAdd(-12, beginTime+"01","yyyyMM" );
|
List<String> categories = new ArrayList<String>();
|
categories.add("01");
|
categories.add("02");
|
categories.add("03");
|
categories.add("04");
|
categories.add("05");
|
categories.add("06");
|
categories.add("07");
|
categories.add("08");
|
categories.add("09");
|
categories.add("10");
|
categories.add("11");
|
categories.add("12");
|
Map resMap = new HashMap();
|
|
|
|
List<Map> series = new ArrayList<Map>();
|
List tempList = new ArrayList();
|
StringBuilder sql = new StringBuilder("SELECT COUNT(ID) AS NUM,DATE_FORMAT(CREATE_TIME,'%m') as TIME FROM KM_LIBRARY WHERE DATE_FORMAT(CREATE_TIME,'%Y') = :time AND STATE = 1 ");
|
if("1".equals(params.get("type"))){
|
sql.append(" AND CATEGORY_ID IS NOT NULL AND CATEGORY_ID <> ''");
|
}else if("2".equals(params.get("type"))){
|
sql.append(" AND THIRDLEVEL_ID IS NOT NULL AND THIRDLEVEL_ID <> ''");
|
}else if("3".equals(params.get("type"))){
|
sql.append(" AND THIRD_CATEGORY_ID IS NOT NULL AND THIRD_CATEGORY_ID <> ''");
|
}
|
sql.append(" GROUP BY DATE_FORMAT(CREATE_TIME,'%Y%m') ORDER BY DATE_FORMAT(CREATE_TIME, '%Y%m') DESC");
|
List<Map> knowList = baseDao.queryForList(sql.toString(),new SqlParameter("time",beginTime));
|
Map cacheMap = new HashMap();
|
for(Map map:knowList){
|
cacheMap.put(map.get("TIME"),map.get("NUM"));
|
}
|
for(String time:categories){
|
if(cacheMap.containsKey(time)){
|
tempList.add(cacheMap.get(time));
|
}else{
|
tempList.add(0);
|
}
|
}
|
Map tempMap = new HashMap();
|
tempMap.put("data", tempList);
|
tempMap.put("name", beginTime);
|
series.add(tempMap);
|
|
List bftempList = new ArrayList();
|
List<Map> bfknowList = baseDao.queryForList(sql.toString(),new SqlParameter("time",DateUtil.format("yyyy", bfbeginTime)));
|
Map cacheMapbf = new HashMap();
|
for(Map map:bfknowList){
|
cacheMapbf.put(map.get("TIME"),map.get("NUM"));
|
}
|
for(String time:categories){
|
if(cacheMapbf.containsKey(time)){
|
bftempList.add(cacheMapbf.get(time));
|
}else{
|
bftempList.add(0);
|
}
|
}
|
Map tempMap1 = new HashMap();
|
tempMap1.put("data", bftempList);
|
tempMap1.put("name", DateUtil.format("yyyy", bfbeginTime));
|
series.add(tempMap1);
|
|
resMap.put("series", series);
|
categories = new ArrayList<String>();
|
categories.add("1月");
|
categories.add("2月");
|
categories.add("3月");
|
categories.add("4月");
|
categories.add("5月");
|
categories.add("6月");
|
categories.add("7月");
|
categories.add("8月");
|
categories.add("9月");
|
categories.add("10月");
|
categories.add("11月");
|
categories.add("12月");
|
resMap.put("categories", categories);
|
return resMap;
|
}
|
|
@Override
|
public List knowcateReportData(Map<String, String> params) {
|
|
String startDate = params.get("beginTime");
|
String endDate = params.get("endTime");
|
params.put("beginTime", startDate+"000000");
|
params.put("endTime", endDate+"235959");
|
StringBuilder sql = new StringBuilder(" ");
|
|
getreportsql( sql, params);
|
|
List<Map> knowList = baseDao.queryForList(sql.toString(),params);
|
sql = new StringBuilder(" ");
|
params.put("top", "1");
|
getreportsql( sql, params);
|
List<Map> knowtopList = baseDao.queryForList(sql.toString(),params);
|
sql = new StringBuilder(" ");
|
params.put("top", "");
|
params.put("jh", "1");
|
getreportsql( sql, params);
|
List<Map> knowjhList = baseDao.queryForList(sql.toString(),params);
|
|
Map cachetopMap = new HashMap();
|
Map cachejhMap = new HashMap();
|
for(Map map:knowtopList){
|
cachetopMap.put(map.get("CATEGORY_ID"), map.get("NUM"));
|
}
|
for(Map map:knowjhList){
|
cachejhMap.put(map.get("CATEGORY_ID"), map.get("NUM"));
|
}
|
for(Map map:knowList){
|
if(cachetopMap.containsKey(map.get("CATEGORY_ID"))){
|
map.put("topnum", cachetopMap.get(map.get("CATEGORY_ID")));
|
}else{
|
map.put("topnum", 0);
|
}
|
if(cachejhMap.containsKey(map.get("CATEGORY_ID"))){
|
map.put("jhnum", cachejhMap.get(map.get("CATEGORY_ID")));
|
}else{
|
map.put("jhnum", 0);
|
}
|
}
|
return knowList;
|
}
|
|
public void getreportsql(StringBuilder sql,Map<String, String> params){
|
String startDate = params.get("beginTime");
|
String endDate = params.get("endTime");
|
sql.append("SELECT COUNT(ID) AS NUM ");
|
if("1".equals(params.get("type"))){
|
sql.append(" ,FIRST_KNOWCATEGORY_ID AS CATEGORY_ID,FIRST_KNOWCATEGORY_NAME AS CATEGORY_NAME");
|
}else if("2".equals(params.get("type"))){
|
sql.append(" ,FIRSTLEVEL_ID AS CATEGORY_ID,FIRSTLEVEL_NAME AS CATEGORY_NAME");
|
}else if("3".equals(params.get("type"))){
|
sql.append(" ,FIRST_CATEGORY_ID AS CATEGORY_ID,FIRST_CATEGORY_NAME AS CATEGORY_NAME");
|
}
|
sql.append(" FROM KM_LIBRARY WHERE STATE = 1 ");
|
|
if(!StringUtil.isEmpty(startDate) ){
|
sql.append(" AND CREATE_TIME >= :beginTime ");
|
}
|
if(!StringUtil.isEmpty(endDate) ){
|
sql.append(" AND CREATE_TIME <= :endTime ");
|
}
|
|
if(!StringUtil.isEmpty(params.get("top")) ){
|
sql.append(" AND IS_TOP = 1 ");
|
}
|
|
if(!StringUtil.isEmpty(params.get("jh")) ){
|
sql.append(" AND IS_ESSENCE = 1 ");
|
}
|
|
if("1".equals(params.get("type"))){
|
sql.append(" AND FIRST_KNOWCATEGORY_ID IS NOT NULL AND FIRST_KNOWCATEGORY_ID <> '' GROUP BY FIRST_KNOWCATEGORY_ID ");
|
}else if("2".equals(params.get("type"))){
|
sql.append(" AND FIRSTLEVEL_ID IS NOT NULL AND FIRSTLEVEL_ID <> '' GROUP BY FIRSTLEVEL_ID ");
|
}else if("3".equals(params.get("type"))){
|
sql.append(" AND FIRST_CATEGORY_ID IS NOT NULL AND FIRST_CATEGORY_ID <> '' GROUP BY FIRST_CATEGORY_ID ");
|
}
|
|
}
|
|
@Override
|
public List knowuserReportData(Map<String, String> params) {
|
StringBuilder sqlUser = new StringBuilder("SELECT * FROM GG_USER WHERE ZT = 1 ");
|
String name = params.get("name");
|
String dj = params.get("dj");
|
if(!StringUtil.isEmpty(params.get("name"))){
|
sqlUser.append(" AND ZSXM LIKE :name");
|
params.put("name", "%"+name+"%");
|
}
|
|
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);
|
}
|
if(!StringUtil.isEmpty(dj)){
|
|
if(ConvertUtil.obj2Integer(dj) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_CJZJ){
|
sqlUser.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(dj) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZJZJ){
|
sqlUser.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(dj) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ){
|
sqlUser.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(dj) == Constants.KM_EXPERT_LEVEL_RULE_TYPE_ZSZJ){
|
sqlUser.append(" AND KM_SCORE >=:score1 ");
|
params.put("score1",ConvertUtil.obj2StrBlank(cacheMap.get(Constants.KM_EXPERT_LEVEL_RULE_TYPE_GJZJ)) );
|
}
|
}
|
List<Map> userList = baseDao.queryForList(sqlUser.toString(),params);
|
|
String startDate = params.get("beginTime");
|
String endDate = params.get("endTime");
|
params.put("beginTime", startDate+"000000");
|
params.put("endTime", endDate+"235959");
|
StringBuilder sql = new StringBuilder(" ");
|
getusersql(sql,params);
|
List<Map> knowList = baseDao.queryForList(sql.toString(),params);
|
sql = new StringBuilder(" ");
|
params.put("top", "1");
|
getusersql(sql,params);
|
List<Map> knowtopList = baseDao.queryForList(sql.toString(),params);
|
sql = new StringBuilder(" ");
|
params.put("top", "");
|
params.put("jh", "1");
|
getusersql(sql,params);
|
List<Map> knowjhList = baseDao.queryForList(sql.toString(),params);
|
|
StringBuilder sql2 = new StringBuilder("SELECT COUNT(C.LIBRARY_ID) AS NUM ,C.USER_ID FROM (SELECT DISTINCT B.LIBRARY_ID,B.USER_ID");
|
sql2.append(" FROM KM_LIBRARY A,KM_RECORD B WHERE A.ID = B.LIBRARY_ID AND A.STATE = 1 ");
|
if(!StringUtil.isEmpty(startDate) ){
|
sql2.append(" AND A.CREATE_TIME >= :beginTime ");
|
}
|
if(!StringUtil.isEmpty(endDate) ){
|
sql2.append(" AND A.CREATE_TIME <= :endTime ");
|
}
|
sql2.append(" AND B.TYPE = :type )C");
|
sql2.append(" GROUP BY C.USER_ID ");
|
params.put("type", ConvertUtil.obj2StrBlank(Constants.KM_SCORE_RULE_TYPE_D));
|
List<Map> knowzanList = baseDao.queryForList(sql2.toString(),params);
|
params.put("type", ConvertUtil.obj2StrBlank(Constants.KM_SCORE_RULE_TYPE_C));
|
List<Map> knowcaiList = baseDao.queryForList(sql2.toString(),params);
|
params.put("type", ConvertUtil.obj2StrBlank(Constants.KM_SCORE_RULE_TYPE_BJ));
|
List<Map> knoweditList = baseDao.queryForList(sql2.toString(),params);
|
Map cachetopMap = new HashMap();
|
Map cachejhMap = new HashMap();
|
Map cachecreateMap = new HashMap();
|
Map cachezanMap = new HashMap();
|
Map cachecaiMap = new HashMap();
|
Map cacheeditMap = new HashMap();
|
for(Map map:knowtopList){
|
cachetopMap.put(map.get("USER_ID"), map.get("NUM"));
|
}
|
for(Map map:knowjhList){
|
cachejhMap.put(map.get("USER_ID"), map.get("NUM"));
|
}
|
for(Map map:knowList){
|
cachecreateMap.put(map.get("USER_ID"), map.get("NUM"));
|
}
|
for(Map map:knowzanList){
|
cachezanMap.put(map.get("USER_ID"), map.get("NUM"));
|
}
|
for(Map map:knowcaiList){
|
cachecaiMap.put(map.get("USER_ID"), map.get("NUM"));
|
}
|
for(Map map:knoweditList){
|
cacheeditMap.put(map.get("USER_ID"), map.get("NUM"));
|
}
|
for(Map map:userList){
|
if(cachetopMap.containsKey(map.get("ID"))){
|
map.put("topnum", cachetopMap.get(map.get("ID")));
|
}else{
|
map.put("topnum", 0);
|
}
|
if(cachejhMap.containsKey(map.get("ID"))){
|
map.put("jhnum", cachejhMap.get(map.get("ID")));
|
}else{
|
map.put("jhnum", 0);
|
}
|
if(cachecreateMap.containsKey(map.get("ID"))){
|
map.put("createnum", cachecreateMap.get(map.get("ID")));
|
}else{
|
map.put("createnum", 0);
|
}
|
if(cachezanMap.containsKey(map.get("ID"))){
|
map.put("zannum", cachezanMap.get(map.get("ID")));
|
}else{
|
map.put("zannum", 0);
|
}
|
if(cachecaiMap.containsKey(map.get("ID"))){
|
map.put("cainum", cachecaiMap.get(map.get("ID")));
|
}else{
|
map.put("cainum", 0);
|
}
|
if(cacheeditMap.containsKey(map.get("ID"))){
|
map.put("editnum", cacheeditMap.get(map.get("ID")));
|
}else{
|
map.put("editnum", 0);
|
}
|
}
|
return userList;
|
}
|
|
public void getusersql(StringBuilder sql,Map<String, String> params){
|
String startDate = params.get("beginTime");
|
String endDate = params.get("endTime");
|
sql.append("SELECT COUNT(ID) AS NUM ,CREATE_USER_ID AS USER_ID ");
|
sql.append(" FROM KM_LIBRARY WHERE STATE = 1 ");
|
if(!StringUtil.isEmpty(startDate) ){
|
sql.append(" AND CREATE_TIME >= :beginTime ");
|
|
}
|
if(!StringUtil.isEmpty(endDate) ){
|
sql.append(" AND CREATE_TIME <= :endTime ");
|
|
}
|
|
if(!StringUtil.isEmpty(params.get("top")) ){
|
sql.append(" AND IS_TOP = 1 ");
|
}
|
|
if(!StringUtil.isEmpty(params.get("jh")) ){
|
sql.append(" AND IS_ESSENCE = 1 ");
|
}
|
|
sql.append("GROUP BY CREATE_USER_ID ");
|
}
|
|
@Override
|
public Map knowdataReportData(Map<String, String> params) {
|
|
Map result = new HashMap();
|
StringBuilder sql = new StringBuilder(" ");
|
String year = params.get("year");
|
params.put("beginTime", year+"01");
|
params.put("endTime", year+"12");
|
getdatasql(sql, params);
|
int allnum = baseDao.queryForInteger(sql.toString(), params);
|
sql = new StringBuilder(" ");
|
params.put("beginTime", year+"01");
|
params.put("endTime", year+"06");
|
getdatasql(sql, params);
|
int sbnnum = baseDao.queryForInteger(sql.toString(), params);
|
sql = new StringBuilder(" ");
|
params.put("beginTime", year+"07");
|
params.put("endTime", year+"12");
|
getdatasql(sql, params);
|
int xbnnum = baseDao.queryForInteger(sql.toString(), params);
|
sql = new StringBuilder(" ");
|
params.put("beginTime", year+"01");
|
params.put("endTime", year+"03");
|
getdatasql(sql, params);
|
int yjdnum = baseDao.queryForInteger(sql.toString(), params);
|
sql = new StringBuilder(" ");
|
params.put("beginTime", year+"04");
|
params.put("endTime", year+"06");
|
getdatasql(sql, params);
|
int ejdnum = baseDao.queryForInteger(sql.toString(), params);
|
sql = new StringBuilder(" ");
|
params.put("beginTime", year+"07");
|
params.put("endTime", year+"09");
|
getdatasql(sql, params);
|
int sjdnum = baseDao.queryForInteger(sql.toString(), params);
|
sql = new StringBuilder(" ");
|
params.put("beginTime", year+"10");
|
params.put("endTime", year+"12");
|
getdatasql(sql, params);
|
int sijdnum = baseDao.queryForInteger(sql.toString(), params);
|
result.put("allnum", allnum);
|
result.put("sbnnum", sbnnum);
|
result.put("xbnnum", xbnnum);
|
result.put("yjdnum", yjdnum);
|
result.put("ejdnum", ejdnum);
|
result.put("sjdnum", sjdnum);
|
result.put("sijdnum", sijdnum);
|
return result;
|
}
|
|
public void getdatasql(StringBuilder sql,Map<String, String> params){
|
String startDate = params.get("beginTime");
|
String endDate = params.get("endTime");
|
sql.append("SELECT COUNT(ID) FROM KM_LIBRARY WHERE STATE = 1 ");
|
|
if(!StringUtil.isEmpty(startDate) ){
|
sql.append(" AND DATE_FORMAT(CREATE_TIME,'%Y%m') >= :beginTime ");
|
|
}
|
if(!StringUtil.isEmpty(endDate) ){
|
sql.append(" AND DATE_FORMAT(CREATE_TIME,'%Y%m') <= :endTime ");
|
|
}
|
if("1".equals(params.get("type"))){
|
sql.append(" AND FIRST_KNOWCATEGORY_ID IS NOT NULL AND FIRST_KNOWCATEGORY_ID <> '' ");
|
}else if("2".equals(params.get("type"))){
|
sql.append(" AND FIRSTLEVEL_ID IS NOT NULL AND FIRSTLEVEL_ID <> '' ");
|
}else if("3".equals(params.get("type"))){
|
sql.append(" AND FIRST_CATEGORY_ID IS NOT NULL AND FIRST_CATEGORY_ID <> '' ");
|
}
|
|
}
|
|
}
|
