src/main/java/com/lf/server/config/ScheduleConfig.java
@@ -69,10 +69,10 @@ jsonObject.put("resUseCount", scheduleService.countResStatus()); // 用户登录状态 sys_login // jsonObject.put("userLoginCount", scheduleService.userLoginCount()); jsonObject.put("userLoginCount", scheduleService.userLoginCount()); // 资源操作状态 sys_operate // jsonObject.put("operateCount", scheduleService.operateCount()); jsonObject.put("operateCount", scheduleService.operateCount()); // 资源调用状态
@@ -30,6 +30,10 @@ private Timestamp optime; private int count; public int getId() { return id; } @@ -101,4 +105,12 @@ public void setOptime(Timestamp optime) { this.optime = optime; } public int getCount() { return count; } public void setCount(int count) { this.count = count; } } src/main/java/com/lf/server/entity/sys/OperateEntity.java
@@ -35,6 +35,8 @@ private String bak; private int count; public int getId() { return id; } @@ -130,4 +132,12 @@ public void setBak(String bak) { this.bak = bak; } public int getCount() { return count; } public void setCount(int count) { this.count = count; } } src/main/java/com/lf/server/mapper/sys/LoginMapper.java
@@ -93,4 +93,13 @@ * @return */ public List<LoginEntity> selectLoginAll(); /** * 用户登录状态 * * @return */ public List<LoginEntity> selectLoginCounts(); } src/main/java/com/lf/server/mapper/sys/OperateMapper.java
@@ -92,4 +92,12 @@ */ public List<OperateEntity> selectOperateAll(); /** * 查询所有 * * @return */ public List<OperateEntity> operateCount(); } src/main/java/com/lf/server/mapper/sys/ResMapper.java
@@ -104,4 +104,7 @@ * @return */ public List<ResEntity> selectResAll(); } src/main/java/com/lf/server/service/all/ScheduleService.java
@@ -1,10 +1,14 @@ package com.lf.server.service.all; import com.lf.server.entity.all.RedisCacheKey; import com.lf.server.entity.sys.LoginEntity; import com.lf.server.entity.sys.OperateEntity; import com.lf.server.entity.sys.ResEntity; import com.lf.server.entity.sys.UserEntity; import com.lf.server.helper.FileHelper; import com.lf.server.helper.StringHelper; import com.lf.server.service.sys.LoginService; import com.lf.server.service.sys.OperateService; import com.lf.server.service.sys.ResService; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; @@ -35,6 +39,12 @@ public class ScheduleService { @Autowired private ResService resService; @Autowired private LoginService loginService; @Autowired private OperateService operateService; @Autowired private RedisTemplate<String, Object> redisTemplate; @@ -197,4 +207,53 @@ return jsonObject; } /** * 资源操作状态 * * @return */ public JSONObject operateCount() { List<OperateEntity> list = operateService.operateCount(); JSONObject jsonObject = new JSONObject(); if (list.isEmpty()) { return null; } else { List<JSONObject> lister = new ArrayList<JSONObject>(); for (OperateEntity key : list) { JSONObject map = new JSONObject(); map.put("count", key.getCount()); map.put("modular2", key.getModular2()); lister.add(map); } jsonObject.put("operateCount", lister); return jsonObject; } } /** * 用户登录状态 * * @return */ public JSONObject userLoginCount() { List<LoginEntity> list = loginService.selectLoginCounts(); JSONObject jsonObject = new JSONObject(); if (list.isEmpty()) { return null; } else { List<JSONObject> lister = new ArrayList<JSONObject>(); for (LoginEntity key : list) { JSONObject map = new JSONObject(); map.put("count", key.getCount()); map.put("optime", key.getOptime()); lister.add(map); } jsonObject.put("userLoginCount", lister); return jsonObject; } } } src/main/java/com/lf/server/service/sys/LoginService.java
@@ -84,4 +84,13 @@ return le; } /** * 用户登录状态 * @return */ @Override public List<LoginEntity> selectLoginCounts(){ return loginMapper.selectLoginCounts(); } } src/main/java/com/lf/server/service/sys/OperateService.java
@@ -67,4 +67,9 @@ public List<OperateEntity> selectOperateAll() { return operateMapper.selectOperateAll(); } @Override public List<OperateEntity> operateCount() { return operateMapper.operateCount(); } } src/main/java/com/lf/server/service/sys/ResService.java
@@ -1,5 +1,6 @@ package com.lf.server.service.sys; import com.lf.server.entity.sys.LoginEntity; import com.lf.server.entity.sys.ResEntity; import com.lf.server.helper.StringHelper; import com.lf.server.mapper.sys.ResMapper; @@ -76,4 +77,5 @@ public List<ResEntity> selectResAll() { return resMapper.selectResAll(); } } src/main/resources/mapper/sys/LoginMapper.xml
@@ -83,4 +83,9 @@ <update id="updateLogin"> update lf.sys_login set appid=#{appid},ip=#{ip},type=#{type},status=#{status},descr=#{descr},userid=#{userid},optime=now() where id=#{id} </update> <select id="selectLoginCounts" resultType="com.lf.server.entity.sys.LoginEntity"> select to_char(optime,'yyyy-mm-dd') as optime ,count(*) from lf.sys_login where optime between (select optime - interval '30 day') and optime group by to_char(optime,'yyyy-mm-dd') order by to_char(optime,'yyyy-mm-dd') desc; </select> </mapper> src/main/resources/mapper/sys/OperateMapper.xml
@@ -78,4 +78,8 @@ <update id="updateOperate"> update lf.sys_operate set modular1=#{modular1},modular2=#{modular2},url=#{url},ip=#{ip},exec=#{exec},clazz=#{clazz},type=#{type},userid=#{userid},optime=now(),bak=#{bak} where id=#{id} </update> <select id="operateCount" resultType="com.lf.server.entity.sys.OperateEntity"> select modular2, count(*) from lf.sys_operate group by modular2 ; </select> </mapper>
