package com.panzhihua.service_dangjian.service.impl;
|
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.panzhihua.common.model.dtos.partybuilding.*;
|
import com.panzhihua.common.model.vos.R;
|
import com.panzhihua.common.model.vos.partybuilding.PhotoMicroWishData;
|
import com.panzhihua.common.utlis.StringUtils;
|
import com.panzhihua.service_dangjian.dao.StreetBigScreenDAO;
|
import com.panzhihua.service_dangjian.service.StreetBigScreenService;
|
import org.springframework.stereotype.Service;
|
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.time.LocalDate;
|
import java.time.format.DateTimeFormatter;
|
import java.time.temporal.TemporalAdjusters;
|
import java.util.ArrayList;
|
import java.util.Calendar;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* @program: springcloud_k8s_panzhihuazhihuishequ
|
* @description: 党组织
|
* @author: huang.hongfa weixin hhf9596 qq 959656820
|
* @create: 2020-11-30 11:40
|
**/
|
@Service
|
public class StreetBigScreenServiceImpl extends ServiceImpl<StreetBigScreenDAO, ComActDTO>
|
implements StreetBigScreenService
|
{
|
|
|
@Override
|
public R getCommunityId(String streetId)
|
{
|
if(StringUtils.isEmpty(streetId))
|
{
|
return R.fail("街道id不能为空");
|
}
|
return R.ok(baseMapper.getCommunityId(streetId));
|
}
|
|
/**
|
* 获取核心指标数据
|
* @param streetId
|
* @return
|
*/
|
@Override
|
public R getCoreData(String streetId,String communityId,String type,String starTime,String endTime)
|
{
|
if(StringUtils.isEmpty(streetId) && StringUtils.isEmpty(communityId) )
|
{
|
return R.fail("街道id或社区id不能为空");
|
}
|
|
//获取小程序用户数量
|
int userNum=0;
|
//获取实有人口总数
|
int ActualPopNum=0;
|
//获取小区总数
|
int VillageNum=0;
|
//获取志愿者总数
|
int VolunteerNum=0;
|
|
if(StringUtils.equals(type,"1"))
|
{
|
//按年份
|
// int year=Calendar.getInstance().get(Calendar.YEAR);
|
//获取小程序用户数量
|
userNum= baseMapper.getUserNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//获取实有人口总数
|
ActualPopNum= baseMapper.getActualPopNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//获取小区总数
|
VillageNum= baseMapper.getVillageNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//获取志愿者总数
|
VolunteerNum= baseMapper.getVolunteerNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
}
|
else if(StringUtils.equals(type,"2"))
|
{
|
//按月份
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date = null;
|
try {
|
date = sdf.parse(starTime+"-01");
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
Calendar calendar = Calendar.getInstance();
|
calendar.setTime(date);
|
calendar.set(Calendar.DAY_OF_MONTH, calendar.getActualMaximum(Calendar.DAY_OF_MONTH));
|
Date lastDay = calendar.getTime();
|
// 获取当前月份的第一天
|
String firstDayOfMonth = starTime+"-01";
|
// // 获取当前月份的最后一天
|
String lastDayOfMonth = sdf.format(lastDay);
|
|
//获取小程序用户数量
|
userNum= baseMapper.getUserNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//获取实有人口总数
|
ActualPopNum= baseMapper.getActualPopNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//获取小区总数
|
VillageNum= baseMapper.getVillageNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//获取志愿者总数
|
VolunteerNum= baseMapper.getVolunteerNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
}
|
else if(StringUtils.equals(type,"3"))
|
{
|
//按天份
|
// DateTimeFormatter newformatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
|
// String data=LocalDate.now().format(newformatter);
|
userNum= baseMapper.getUserNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//获取实有人口总数
|
ActualPopNum= baseMapper.getActualPopNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//获取小区总数
|
VillageNum= baseMapper.getVillageNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//获取志愿者总数
|
VolunteerNum= baseMapper.getVolunteerNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
}
|
else if(StringUtils.equals(type,"4"))
|
{
|
//按时间范围
|
userNum= baseMapper.getUserNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//获取实有人口总数
|
ActualPopNum= baseMapper.getActualPopNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//获取小区总数
|
VillageNum= baseMapper.getVillageNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//获取志愿者总数
|
VolunteerNum= baseMapper.getVolunteerNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
}
|
else
|
{
|
//type为空 查全部
|
userNum= baseMapper.getUserNum(streetId,communityId,null,null);
|
//获取实有人口总数
|
ActualPopNum= baseMapper.getActualPopNum(streetId,communityId,null,null);
|
//获取小区总数
|
VillageNum= baseMapper.getVillageNum(streetId,communityId,null,null);
|
//获取志愿者总数
|
VolunteerNum= baseMapper.getVolunteerNum(streetId,communityId,null,null);
|
}
|
|
StreetCoreData streetCoreData=new StreetCoreData();
|
streetCoreData.setUserNum(userNum);
|
streetCoreData.setVillageNum(VillageNum);
|
streetCoreData.setActualPopNum(ActualPopNum);
|
streetCoreData.setVolunteerNum(VolunteerNum);
|
|
return R.ok(streetCoreData);
|
}
|
|
|
/**
|
* 获取三务三资数据
|
* @param streetId
|
* @param communityId
|
* @param type
|
* @param starTime
|
* @param endTime
|
* @return
|
*/
|
@Override
|
public R getThreeNum(String streetId, String communityId,String type,String starTime, String endTime)
|
{
|
if(StringUtils.isEmpty(streetId) && StringUtils.isEmpty(communityId) )
|
{
|
return R.fail("街道id或社区id不能为空");
|
}
|
|
int partyAffairsNum=0;
|
int serviceNum=0;
|
int financeNum=0;
|
int fundNum=0;
|
int propertyNum=0;
|
int naturalResourcesNum=0;
|
int villageEconomyNum=0;
|
|
if(StringUtils.equals(type,"1"))
|
{
|
//按年份
|
// int year=Calendar.getInstance().get(Calendar.YEAR);
|
partyAffairsNum=baseMapper.getThreeNum(streetId,communityId,"党务公开",starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
serviceNum=baseMapper.getThreeNum(streetId,communityId,"服务公开",starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
financeNum=baseMapper.getThreeNum(streetId,communityId,"财务公开",starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
fundNum=baseMapper.getThreeNum(streetId,communityId,"资金公开",starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
propertyNum=baseMapper.getThreeNum(streetId,communityId,"资产公开",starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
naturalResourcesNum=baseMapper.getThreeNum(streetId,communityId,"资源公开",starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
villageEconomyNum=baseMapper.getThreeNum(streetId,communityId,"村集体经济组织项目",starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
}
|
else if(StringUtils.equals(type,"2"))
|
{
|
|
try {
|
//按月份
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date = sdf.parse(starTime+"-01");
|
Calendar calendar = Calendar.getInstance();
|
calendar.setTime(date);
|
calendar.set(Calendar.DAY_OF_MONTH, calendar.getActualMaximum(Calendar.DAY_OF_MONTH));
|
Date lastDay = calendar.getTime();
|
// 获取当前月份的第一天
|
String firstDayOfMonth = starTime+"-01";
|
// // 获取当前月份的最后一天
|
String lastDayOfMonth = sdf.format(lastDay);
|
|
partyAffairsNum=baseMapper.getThreeNum(streetId,communityId,"党务公开",firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
serviceNum=baseMapper.getThreeNum(streetId,communityId,"服务公开",firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
financeNum=baseMapper.getThreeNum(streetId,communityId,"财务公开",firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
fundNum=baseMapper.getThreeNum(streetId,communityId,"资金公开",firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
propertyNum=baseMapper.getThreeNum(streetId,communityId,"资产公开",firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
naturalResourcesNum=baseMapper.getThreeNum(streetId,communityId,"资源公开",firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
villageEconomyNum=baseMapper.getThreeNum(streetId,communityId,"村集体经济组织项目",firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
|
// 获取并打印第一天的日期
|
|
|
|
|
}
|
else if(StringUtils.equals(type,"3"))
|
{
|
//按天份
|
// DateTimeFormatter newformatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
|
// String data=LocalDate.now().format(newformatter);
|
|
partyAffairsNum=baseMapper.getThreeNum(streetId,communityId,"党务公开",starTime+" 00:00:00",starTime+" 23:59:59");
|
serviceNum=baseMapper.getThreeNum(streetId,communityId,"服务公开",starTime+" 00:00:00",starTime+" 23:59:59");
|
financeNum=baseMapper.getThreeNum(streetId,communityId,"财务公开",starTime+" 00:00:00",starTime+" 23:59:59");
|
fundNum=baseMapper.getThreeNum(streetId,communityId,"资金公开",starTime+" 00:00:00",starTime+" 23:59:59");
|
propertyNum=baseMapper.getThreeNum(streetId,communityId,"资产公开",starTime+" 00:00:00",starTime+" 23:59:59");
|
naturalResourcesNum=baseMapper.getThreeNum(streetId,communityId,"资源公开",starTime+" 00:00:00",starTime+" 23:59:59");
|
villageEconomyNum=baseMapper.getThreeNum(streetId,communityId,"村集体经济组织项目",starTime+" 00:00:00",starTime+" 23:59:59");
|
}
|
else if(StringUtils.equals(type,"4"))
|
{
|
//按时间范围
|
partyAffairsNum=baseMapper.getThreeNum(streetId,communityId,"党务公开",starTime+" 00:00:00",endTime+" 23:59:59");
|
serviceNum=baseMapper.getThreeNum(streetId,communityId,"服务公开",starTime+" 00:00:00",endTime+" 23:59:59");
|
financeNum=baseMapper.getThreeNum(streetId,communityId,"财务公开",starTime+" 00:00:00",endTime+" 23:59:59");
|
fundNum=baseMapper.getThreeNum(streetId,communityId,"资金公开",starTime+" 00:00:00",endTime+" 23:59:59");
|
propertyNum=baseMapper.getThreeNum(streetId,communityId,"资产公开",starTime+" 00:00:00",endTime+" 23:59:59");
|
naturalResourcesNum=baseMapper.getThreeNum(streetId,communityId,"资源公开",starTime+" 00:00:00",endTime+" 23:59:59");
|
villageEconomyNum=baseMapper.getThreeNum(streetId,communityId,"村集体经济组织项目",starTime+" 00:00:00",endTime+" 23:59:59");
|
|
}
|
else
|
{
|
partyAffairsNum=baseMapper.getThreeNum(streetId,communityId,"党务公开",null,null);
|
serviceNum=baseMapper.getThreeNum(streetId,communityId,"服务公开",null,null);
|
financeNum=baseMapper.getThreeNum(streetId,communityId,"财务公开",null,null);
|
fundNum=baseMapper.getThreeNum(streetId,communityId,"资金公开",null,null);
|
propertyNum=baseMapper.getThreeNum(streetId,communityId,"资产公开",null,null);
|
naturalResourcesNum=baseMapper.getThreeNum(streetId,communityId,"资源公开",null,null);
|
villageEconomyNum=baseMapper.getThreeNum(streetId,communityId,"村集体经济组织项目",null,null);
|
}
|
|
ThreeNumData threeNumData=new ThreeNumData();
|
threeNumData.setPartyAffairsNum(partyAffairsNum);
|
threeNumData.setServiceNum(serviceNum);
|
threeNumData.setFinanceNum(financeNum);
|
threeNumData.setFundNum(fundNum);
|
threeNumData.setPropertyNum(propertyNum);
|
threeNumData.setNaturalResourcesNum(naturalResourcesNum);
|
threeNumData.setVillageEconomyNum(villageEconomyNum);
|
|
threeNumData.setThreeServiceNum(partyAffairsNum+serviceNum+financeNum);
|
threeNumData.setThreeFundNum(fundNum+propertyNum+naturalResourcesNum);
|
|
|
return R.ok(threeNumData);
|
}
|
|
|
/**
|
* 双报到双服务
|
* @param streetId
|
* @param communityId
|
* @param type
|
* @param starTime
|
* @param endTime
|
* @return
|
*/
|
@Override
|
public R getDoubleRegistration(String streetId, String communityId, String type, String starTime, String endTime)
|
{
|
if(StringUtils.isEmpty(streetId) && StringUtils.isEmpty(communityId) )
|
{
|
return R.fail("街道id或社区id不能为空");
|
}
|
|
//旧的报道需求问题统计数 2.问题清单 3.需求清单
|
Integer OleProblemNum=0;
|
Integer OleNeedNum=0;
|
//旧的报道需求问题统计数 1问题清单 2需求清单
|
Integer NewProblemNum=0;
|
Integer NewNeedNum=0;
|
//获取旧双报道服务时间
|
Double OldTime=0.0;
|
//获取新双报道服务时间
|
Double NewTime=0.0;
|
//党建动态数据
|
Integer PartyBuildingNum=0;
|
//报到单位总计数据
|
Integer UnitNum=0;
|
//报到党员总计数据
|
Integer MemberNum=0;
|
|
Integer fuwuNum=0;
|
|
if(StringUtils.equals(type,"1"))
|
{
|
//按年份
|
// int year=Calendar.getInstance().get(Calendar.YEAR);
|
//旧的报道需求问题统计数 2.问题清单 3.需求清单
|
OleProblemNum=baseMapper.getOleNeedProblemNum("2",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
OleNeedNum=baseMapper.getOleNeedProblemNum("3",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//旧的报道需求问题统计数 1问题清单 2需求清单
|
NewProblemNum=baseMapper.getNewNeedProblemNum("1",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
NewNeedNum=baseMapper.getNewNeedProblemNum("2",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//获取旧双报道服务时间
|
OldTime=baseMapper.getOldTime(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//获取新双报道服务时间
|
NewTime=baseMapper.getNewTime(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//党建动态数据
|
PartyBuildingNum=baseMapper.getPartyBuildingNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//报到单位总计数据
|
UnitNum=baseMapper.getUnitNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//报到党员总计数据
|
MemberNum=baseMapper.getMemberNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
|
fuwuNum=baseMapper.getRegistNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
}
|
else if(StringUtils.equals(type,"2"))
|
{
|
//按月份
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date = null;
|
try {
|
date = sdf.parse(starTime+"-01");
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
Calendar calendar = Calendar.getInstance();
|
calendar.setTime(date);
|
calendar.set(Calendar.DAY_OF_MONTH, calendar.getActualMaximum(Calendar.DAY_OF_MONTH));
|
Date lastDay = calendar.getTime();
|
// 获取当前月份的第一天
|
String firstDayOfMonth = starTime+"-01";
|
// // 获取当前月份的最后一天
|
String lastDayOfMonth = sdf.format(lastDay);
|
|
//旧的报道需求问题统计数 2.问题清单 3.需求清单
|
OleProblemNum=baseMapper.getOleNeedProblemNum("2",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
OleNeedNum=baseMapper.getOleNeedProblemNum("3",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//旧的报道需求问题统计数 1问题清单 2需求清单
|
NewProblemNum=baseMapper.getNewNeedProblemNum("1",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
NewNeedNum=baseMapper.getNewNeedProblemNum("2",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//获取旧双报道服务时间
|
OldTime=baseMapper.getOldTime(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//获取新双报道服务时间
|
NewTime=baseMapper.getNewTime(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//党建动态数据
|
PartyBuildingNum=baseMapper.getPartyBuildingNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//报到单位总计数据
|
UnitNum=baseMapper.getUnitNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//报到党员总计数据
|
MemberNum=baseMapper.getMemberNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
fuwuNum=baseMapper.getRegistNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
}
|
else if(StringUtils.equals(type,"3"))
|
{
|
//按天份
|
// DateTimeFormatter newformatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
|
// String data=LocalDate.now().format(newformatter);
|
|
//旧的报道需求问题统计数 2.问题清单 3.需求清单
|
OleProblemNum=baseMapper.getOleNeedProblemNum("2",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
OleNeedNum=baseMapper.getOleNeedProblemNum("3",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//旧的报道需求问题统计数 1问题清单 2需求清单
|
NewProblemNum=baseMapper.getNewNeedProblemNum("1",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
NewNeedNum=baseMapper.getNewNeedProblemNum("2",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//获取旧双报道服务时间
|
OldTime=baseMapper.getOldTime(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//获取新双报道服务时间
|
NewTime=baseMapper.getNewTime(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//党建动态数据
|
PartyBuildingNum=baseMapper.getPartyBuildingNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//报到单位总计数据
|
UnitNum=baseMapper.getUnitNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//报到党员总计数据
|
MemberNum=baseMapper.getMemberNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
fuwuNum=baseMapper.getRegistNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
}
|
else if(StringUtils.equals(type,"4"))
|
{
|
//按时间范围
|
//旧的报道需求问题统计数 2.问题清单 3.需求清单
|
OleProblemNum=baseMapper.getOleNeedProblemNum("2",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
OleNeedNum=baseMapper.getOleNeedProblemNum("3",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//旧的报道需求问题统计数 1问题清单 2需求清单
|
NewProblemNum=baseMapper.getNewNeedProblemNum("1",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
NewNeedNum=baseMapper.getNewNeedProblemNum("2",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//获取旧双报道服务时间
|
OldTime=baseMapper.getOldTime(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//获取新双报道服务时间
|
NewTime=baseMapper.getNewTime(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//党建动态数据
|
PartyBuildingNum=baseMapper.getPartyBuildingNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//报到单位总计数据
|
UnitNum=baseMapper.getUnitNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//报到党员总计数据
|
MemberNum=baseMapper.getMemberNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
fuwuNum=baseMapper.getRegistNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
|
}
|
else
|
{
|
//旧的报道需求问题统计数 2.问题清单 3.需求清单
|
OleProblemNum=baseMapper.getOleNeedProblemNum("2",streetId,communityId,null,null);
|
OleNeedNum=baseMapper.getOleNeedProblemNum("3",streetId,communityId,null,null);
|
//旧的报道需求问题统计数 1问题清单 2需求清单
|
NewProblemNum=baseMapper.getNewNeedProblemNum("1",streetId,communityId,null,null);
|
NewNeedNum=baseMapper.getNewNeedProblemNum("2",streetId,communityId,null,null);
|
//获取旧双报道服务时间
|
OldTime=baseMapper.getOldTime(streetId,communityId,null,null);
|
//获取新双报道服务时间
|
NewTime=baseMapper.getNewTime(streetId,communityId,null,null);
|
//党建动态数据
|
PartyBuildingNum=baseMapper.getPartyBuildingNum(streetId,communityId,null,null);
|
//报到单位总计数据
|
UnitNum=baseMapper.getUnitNum(streetId,communityId,null,null);
|
//报到党员总计数据
|
MemberNum=baseMapper.getMemberNum(streetId,communityId,null,null);
|
fuwuNum=baseMapper.getRegistNum(streetId,communityId,null,null);
|
}
|
|
|
if(NewTime==null)
|
{
|
NewTime=0.0;
|
}
|
if(OldTime==null)
|
{
|
OldTime=0.0;
|
}
|
|
DoubleRegistrationData doubleRegistrationData=new DoubleRegistrationData();
|
//报道需求统计数
|
doubleRegistrationData.setNeedNum(NewNeedNum+OleNeedNum);
|
//报道问题
|
doubleRegistrationData.setProblemNum(OleProblemNum+NewProblemNum);
|
//获取旧双报道服务时间
|
doubleRegistrationData.setTimes(OldTime+NewTime);
|
//党建动态数据
|
doubleRegistrationData.setPartyBuildingNum(PartyBuildingNum);
|
//报到单位总计数据
|
doubleRegistrationData.setUnitNum(UnitNum);
|
//报到党员总计数据
|
doubleRegistrationData.setMemberNum(MemberNum);
|
//报到服务次数
|
doubleRegistrationData.setAllNum(NewNeedNum+OleNeedNum+OleProblemNum+NewProblemNum+fuwuNum);
|
|
|
return R.ok(doubleRegistrationData);
|
}
|
|
/**
|
* 随手拍 微心愿
|
* @param streetId
|
* @param communityId
|
* @param type
|
* @param starTime
|
* @param endTime
|
* @return
|
*/
|
@Override
|
public R getPhotoMicroWish(String streetId, String communityId, String type, String starTime, String endTime)
|
{
|
|
//随手拍
|
List<PhotoMicroWishData> photoList=new ArrayList<>();
|
//微心愿
|
List<PhotoMicroWishData> microWishList=new ArrayList<>();
|
|
// List<PhotoMicroWishData> list=new ArrayList<>();
|
|
|
int photoNum=0;
|
|
int microWishNum=0;
|
|
if(StringUtils.equals(type,"1"))
|
{
|
//按年份
|
// int year=Calendar.getInstance().get(Calendar.YEAR);
|
|
//随手拍
|
photoList=baseMapper.getPhotoMicroWishData("1","%Y",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//微心愿
|
microWishList=baseMapper.getPhotoMicroWishData("2","%Y",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
|
photoNum=baseMapper.getPhotoAllNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
microWishNum=baseMapper.getMicroWishAllNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
}
|
else if(StringUtils.equals(type,"2"))
|
{
|
//按月份
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date = null;
|
try {
|
date = sdf.parse(starTime+"-01");
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
Calendar calendar = Calendar.getInstance();
|
calendar.setTime(date);
|
calendar.set(Calendar.DAY_OF_MONTH, calendar.getActualMaximum(Calendar.DAY_OF_MONTH));
|
Date lastDay = calendar.getTime();
|
// 获取当前月份的第一天
|
String firstDayOfMonth = starTime+"-01";
|
// // 获取当前月份的最后一天
|
String lastDayOfMonth = sdf.format(lastDay);
|
|
photoList=baseMapper.getPhotoMicroWishData("1","%Y-%m",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
microWishList=baseMapper.getPhotoMicroWishData("2","%Y-%m",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
|
photoNum=baseMapper.getPhotoAllNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
microWishNum=baseMapper.getMicroWishAllNum(streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
|
}
|
else if(StringUtils.equals(type,"3"))
|
{
|
//按天份
|
// DateTimeFormatter newformatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
|
// String data=LocalDate.now().format(newformatter);
|
|
photoList=baseMapper.getPhotoMicroWishData("1","%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
microWishList=baseMapper.getPhotoMicroWishData("2","%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
|
photoNum=baseMapper.getPhotoAllNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
microWishNum=baseMapper.getMicroWishAllNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
}
|
else if(StringUtils.equals(type,"4"))
|
{
|
photoList=baseMapper.getPhotoMicroWishData("1","%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
microWishList=baseMapper.getPhotoMicroWishData("2","%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
|
photoNum=baseMapper.getPhotoAllNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
microWishNum=baseMapper.getMicroWishAllNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
}
|
else
|
{
|
photoList=baseMapper.getPhotoMicroWishData("1","%Y-%m",streetId,communityId,null,null);
|
microWishList=baseMapper.getPhotoMicroWishData("2","%Y-%m",streetId,communityId,null,null);
|
|
photoNum=baseMapper.getPhotoAllNum(streetId,communityId,null,null);
|
microWishNum=baseMapper.getMicroWishAllNum(streetId,communityId,null,null);
|
}
|
|
// for (int a=0;a<microWishList.size();a++)
|
// {
|
// int num=0;
|
// for (int b=0;b<photoList.size();b++)
|
// {
|
// if(photoList.get(b).getTiems().equals(microWishList.get(a).getTiems()))
|
// {
|
// photoList.get(b).setMicroNum(microWishList.get(a).getPhotoNum());
|
// }
|
// else
|
// {
|
// num++;
|
// }
|
// }
|
//
|
// if(num>=photoList.size())
|
// {
|
// PhotoMicroWishData data=new PhotoMicroWishData();
|
// data.setMicroNum(microWishList.get(a).getPhotoNum());
|
// data.setCreateAt(microWishList.get(a).getCreateAt());
|
// data.setTiems(microWishList.get(a).getTiems());
|
// data.setPhotoNum("0");
|
// list.add(data);
|
// }
|
//
|
// }
|
//
|
// photoList.addAll(list);
|
//
|
// if(photoList!=null && photoList.size()>1)
|
// {
|
// Collections.sort(photoList, new Comparator<PhotoMicroWishData>() {
|
// @Override
|
// public int compare(PhotoMicroWishData o1, PhotoMicroWishData o2) {
|
// return o1.getCreateAt().compareTo(o2.getCreateAt());
|
// }
|
// });
|
// }
|
|
|
PhotoMicroWish photoMicroWish=new PhotoMicroWish();
|
photoMicroWish.setPhotoList(photoList);
|
photoMicroWish.setMicroWishList(microWishList);
|
photoMicroWish.setPhotoNum(photoNum);
|
photoMicroWish.setMicroWishNum(microWishNum);
|
return R.ok(photoMicroWish);
|
}
|
|
/**
|
* 社区活动、议事投票、问卷调查、社区动态发布趋势
|
* @param streetId
|
* @param communityId
|
* @param type
|
* @param starTime
|
* @param endTime
|
* @return
|
*/
|
@Override
|
public R getAllData(String streetId, String communityId, String type, String starTime, String endTime)
|
{
|
//议事投票
|
List<PhotoMicroWishData> discussList=new ArrayList<>();
|
//问卷调查
|
List<PhotoMicroWishData> questnaireNumList=new ArrayList<>();
|
//社区动态
|
List<PhotoMicroWishData> nommunityDynNumList=new ArrayList<>();
|
//社区活动
|
List<PhotoMicroWishData> nommunityActNumList=new ArrayList<>();
|
|
|
//议事投票数量")
|
int discussNum=0;
|
|
//问卷调查数量")
|
int questnaireNum=0;
|
|
//社区动态数量")
|
int nommunityDynNum=0;
|
|
//社区活动数量")
|
int nommunityActNum=0;
|
|
if(StringUtils.equals(type,"1"))
|
{
|
//按年份
|
// int year=Calendar.getInstance().get(Calendar.YEAR);
|
|
//* 社区活动统计
|
nommunityActNumList=baseMapper.getNommunityActNumList("%Y",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//社区动态
|
nommunityDynNumList=baseMapper.getNommunityDynNumList("%Y",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//问卷调查
|
questnaireNumList=baseMapper.getQuestnaireNumList("%Y",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
//议事投票
|
discussList=baseMapper.getDiscussNumList("%Y",streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
|
|
//议事投票数量")
|
discussNum=baseMapper.getDiscussNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
|
//问卷调查数量")
|
questnaireNum=baseMapper.getQuestnaireNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
|
//社区动态数量")
|
nommunityDynNum=baseMapper.getNommunityDynNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
|
//社区活动数量")
|
nommunityActNum=baseMapper.getNommunityActNum(streetId,communityId,starTime+"-01-01 00:00:00",starTime+"-12-31 23:59:59");
|
|
|
}
|
else if(StringUtils.equals(type,"2"))
|
{
|
//按月份
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date = null;
|
try {
|
date = sdf.parse(starTime+"-01");
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
Calendar calendar = Calendar.getInstance();
|
calendar.setTime(date);
|
calendar.set(Calendar.DAY_OF_MONTH, calendar.getActualMaximum(Calendar.DAY_OF_MONTH));
|
Date lastDay = calendar.getTime();
|
// 获取当前月份的第一天
|
String firstDayOfMonth = starTime+"-01";
|
// // 获取当前月份的最后一天
|
String lastDayOfMonth = sdf.format(lastDay);
|
|
//* 社区活动统计
|
nommunityActNumList=baseMapper.getNommunityActNumList("%Y-%m",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//社区动态
|
nommunityDynNumList=baseMapper.getNommunityDynNumList("%Y-%m",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//问卷调查
|
questnaireNumList=baseMapper.getQuestnaireNumList("%Y-%m",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
//议事投票
|
discussList=baseMapper.getDiscussNumList("%Y-%m",streetId,communityId,firstDayOfMonth+" 00:00:00",lastDayOfMonth+" 23:59:59");
|
|
}
|
else if(StringUtils.equals(type,"3"))
|
{
|
//按天份
|
// DateTimeFormatter newformatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
|
// String data=LocalDate.now().format(newformatter);
|
|
//* 社区活动统计
|
nommunityActNumList=baseMapper.getNommunityActNumList("%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//社区动态
|
nommunityDynNumList=baseMapper.getNommunityDynNumList("%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//问卷调查
|
questnaireNumList=baseMapper.getQuestnaireNumList("%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
//议事投票
|
discussList=baseMapper.getDiscussNumList("%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
|
|
//议事投票数量")
|
discussNum=baseMapper.getDiscussNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
|
//问卷调查数量")
|
questnaireNum=baseMapper.getQuestnaireNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
|
//社区动态数量")
|
nommunityDynNum=baseMapper.getNommunityDynNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
|
//社区活动数量")
|
nommunityActNum=baseMapper.getNommunityActNum(streetId,communityId,starTime+" 00:00:00",starTime+" 23:59:59");
|
|
|
|
}
|
else if(StringUtils.equals(type,"4"))
|
{
|
//* 社区活动统计
|
nommunityActNumList=baseMapper.getNommunityActNumList("%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//社区动态
|
nommunityDynNumList=baseMapper.getNommunityDynNumList("%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//问卷调查
|
questnaireNumList=baseMapper.getQuestnaireNumList("%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
//议事投票
|
discussList=baseMapper.getDiscussNumList("%Y-%m-%d",streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
|
|
//议事投票数量")
|
discussNum=baseMapper.getDiscussNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
|
//问卷调查数量")
|
questnaireNum=baseMapper.getQuestnaireNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
|
//社区动态数量")
|
nommunityDynNum=baseMapper.getNommunityDynNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
|
//社区活动数量")
|
nommunityActNum=baseMapper.getNommunityActNum(streetId,communityId,starTime+" 00:00:00",endTime+" 23:59:59");
|
}
|
else
|
{
|
//* 社区活动统计
|
nommunityActNumList=baseMapper.getNommunityActNumList("%Y-%m",streetId,communityId,null,null);
|
//社区动态
|
nommunityDynNumList=baseMapper.getNommunityDynNumList("%Y-%m",streetId,communityId,null,null);
|
//问卷调查
|
questnaireNumList=baseMapper.getQuestnaireNumList("%Y-%m",streetId,communityId,null,null);
|
//议事投票
|
discussList=baseMapper.getDiscussNumList("%Y-%m",streetId,communityId,null,null);
|
|
|
|
//议事投票数量")
|
discussNum=baseMapper.getDiscussNum(streetId,communityId,null,null);
|
|
//问卷调查数量")
|
questnaireNum=baseMapper.getQuestnaireNum(streetId,communityId,null,null);
|
|
//社区动态数量")
|
nommunityDynNum=baseMapper.getNommunityDynNum(streetId,communityId,null,null);
|
|
//社区活动数量")
|
nommunityActNum=baseMapper.getNommunityActNum(streetId,communityId,null,null);
|
|
}
|
|
AllData allData=new AllData();
|
allData.setDiscussList(discussList);
|
allData.setNommunityActNumList(nommunityActNumList);
|
allData.setNommunityDynNumList(nommunityDynNumList);
|
allData.setQuestnaireNumList(questnaireNumList);
|
allData.setQuestnaireNum(questnaireNum);
|
allData.setNommunityDynNum(nommunityDynNum);
|
allData.setNommunityActNum(nommunityActNum);
|
allData.setDiscussNum(discussNum);
|
|
return R.ok(allData);
|
}
|
|
|
}
|
