springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/bigscreen/WestScreenStatics.java
@@ -28,4 +28,10 @@ private Integer reserve; @ApiModelProperty("邻里圈") private Integer neighbor; @ApiModelProperty("一起议") private Integer discuss; @ApiModelProperty("日活跃") private Integer dayUser; @ApiModelProperty("累计用户") private Integer countUser; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/DateUtils.java
@@ -848,6 +848,21 @@ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); return sdf.format(calendar.getTime()) + " 23:59:59"; } /** * 获取当前月最后一天 * * @return */ public static Date getLastDayOfMonth() { Calendar calendar = Calendar.getInstance(); calendar.add(Calendar.MONTH, 1); calendar.set(Calendar.DAY_OF_MONTH, 0); // 格式化日期 return calendar.getTime(); } /** * 获取当前时间（年月日） springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
@@ -9,8 +9,10 @@ import com.baomidou.mybatisplus.core.conditions.Wrapper; import com.baomidou.mybatisplus.core.conditions.segments.MergeSegments; import com.panzhihua.common.model.vos.community.bigscreen.WestScreenStatics; import com.panzhihua.common.model.vos.community.screen.civil.*; import com.panzhihua.common.utlis.*; import com.panzhihua.service_community.util.WxDataUtil; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Value; import org.springframework.context.annotation.Bean; @@ -7740,7 +7742,11 @@ @Override public R westScreenStatics() { return R.ok(this.comMngPopulationDAO.westScreenStatics()); WestScreenStatics westScreenStatics=this.comMngPopulationDAO.westScreenStatics(); WxDataUtil wxDataUtil=new WxDataUtil(); westScreenStatics.setDayUser(wxDataUtil.getDayUser()); westScreenStatics.setCountUser(wxDataUtil.getMonthUser()); return R.ok(westScreenStatics); } @Override springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/util/ResultEntity.java
New file @@ -0,0 +1,12 @@ package com.panzhihua.service_community.util; import lombok.Data; /** * @author zzj */ @Data public class ResultEntity { private Integer key; private Integer value; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/util/WxDataUtil.java
New file @@ -0,0 +1,62 @@ package com.panzhihua.service_community.util; import cn.hutool.core.date.DateUtil; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.panzhihua.common.utlis.*; import java.util.Date; /** * 微信活跃用户工具类 * @author zzj */ public class WxDataUtil { WxXCXTempSend wxXCXTempSend=new WxXCXTempSend(); String accessToken; { try { accessToken = wxXCXTempSend.getAccessToken(); } catch (Exception e) { e.printStackTrace(); } } public Integer getDayUser(){ try { String dayUrl="https://api.weixin.qq.com/datacube/getweanalysisappiddailyretaininfo?access_token="+accessToken; WxRequestEntity wxRequestEntity=new WxRequestEntity(); wxRequestEntity.setAccess_token(accessToken); String date=DateUtil.format(DateUtil.offsetDay(new Date(),-1),"yyyyMMdd"); wxRequestEntity.setBegin_date(date); wxRequestEntity.setEnd_date(date); String result=HttpClientUtil.httpPost(dayUrl, JSONObject.toJSONString(wxRequestEntity)); if(StringUtils.isNotEmpty(result)&result.contains("visit_uv")){ JSONArray jsonArray=(JSONArray) JSONObject.parseObject(result).get("visit_uv"); JSONObject jsonObject=(JSONObject)jsonArray.get(0); return jsonObject.getInteger("value"); } } catch (Exception e) { e.printStackTrace(); } return null; } public Integer getMonthUser(){ try { String dayUrl="https://api.weixin.qq.com/datacube/getweanalysisappidmonthlyvisittrend?access_token="+accessToken; WxRequestEntity wxRequestEntity=new WxRequestEntity(); wxRequestEntity.setAccess_token(accessToken); wxRequestEntity.setBegin_date(DateUtil.format(DateUtil.offsetMonth(DateUtils.getFirstDayOfMonth(),-1),"yyyyMMdd")); wxRequestEntity.setEnd_date(DateUtil.format(DateUtil.offsetMonth(DateUtils.getLastDayOfMonth(),-1),"yyyyMMdd")); String result=HttpClientUtil.httpPost(dayUrl, JSONObject.toJSONString(wxRequestEntity)); if(StringUtils.isNotEmpty(result)&result.contains("session_cnt")){ JSONArray resultEntity= (JSONArray) JSONObject.parseObject(result).get("list"); JSONObject resultObject= (JSONObject) resultEntity.get(0); return resultObject.getInteger("session_cnt"); } } catch (Exception e) { e.printStackTrace(); } return null; } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/util/WxRequestEntity.java
New file @@ -0,0 +1,13 @@ package com.panzhihua.service_community.util; import lombok.Data; /** * @author zzj */ @Data public class WxRequestEntity { private String access_token; private String begin_date; private String end_date; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml
@@ -827,7 +827,9 @@ (select count(*) from com_act_reserve t LEFT JOIN com_act_reserve_record t1 on t.id = t1.reserve_id LEFT JOIN com_act t2 on t.community_id = t2.community_id where (title like '%居家隔离%' or title like '%返攀登记%' or title like '%来攀登记%') and t2.area_code ='510423' and t1.status = 2 ) reserve, (select (select count(*) from com_act_activity t LEFT JOIN com_act t1 on t.community_id = t1.community_id where status !=6 and status !=1 and t1.area_code ='510423')+(select count(id) from com_pb_activity t LEFT JOIN com_act t1 on t.community_id = t1.community_id where status !=6 and status !=1 and t1.area_code ='510423')) activity, (select count(*) from com_act_neighbor_circle t LEFT JOIN com_act t1 on t.community_id = t1.community_id where is_del =2 and status=2 and t1.area_code ='510423') neighbor where is_del =2 and status=2 and t1.area_code ='510423') neighbor, (select count(*) from com_act_discuss t LEFT JOIN com_act t1 on t.community_id = t1.community_id where is_del =2 and t1.area_code ='510423') discuss </select> <select id="getBasicsList" resultType="com.panzhihua.common.model.vos.community.screen.event.EventPopulationBasicsStatisticsVO">
