From c10d6358b9f014375a13821465bc978d0c0da22e Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Wed, 29 May 2024 17:17:08 +0800
Subject: [PATCH] 通过E呼即办数据统计

---
 src/main/java/org/springblade/modules/house/service/impl/UserHouseLabelServiceImpl.java |   72 ++++++++++++++++++++++++++++++++---
 1 files changed, 65 insertions(+), 7 deletions(-)

diff --git a/src/main/java/org/springblade/modules/house/service/impl/UserHouseLabelServiceImpl.java b/src/main/java/org/springblade/modules/house/service/impl/UserHouseLabelServiceImpl.java
index 31d7406..ee504de 100644
--- a/src/main/java/org/springblade/modules/house/service/impl/UserHouseLabelServiceImpl.java
+++ b/src/main/java/org/springblade/modules/house/service/impl/UserHouseLabelServiceImpl.java
@@ -17,19 +17,23 @@
 package org.springblade.modules.house.service.impl;
 
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.apache.logging.log4j.util.Strings;
+import org.springblade.core.tool.utils.BeanUtil;
 import org.springblade.modules.house.dto.UserHouseLabelDTO;
 import org.springblade.modules.house.entity.UserHouseLabelEntity;
-import org.springblade.modules.house.vo.HouseholdLabelVO;
+import org.springblade.modules.house.excel.UserHouseLabelExcel;
 import org.springblade.modules.house.mapper.UserHouseLabelMapper;
 import org.springblade.modules.house.service.IUserHouseLabelService;
+import org.springblade.modules.house.vo.HouseholdLabelVO;
 import org.springblade.modules.label.entity.LabelEntity;
 import org.springblade.modules.label.service.ILabelService;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
-import com.baomidou.mybatisplus.core.metadata.IPage;
 
 import java.util.List;
+import java.util.Objects;
 
 /**
  * 住户-标签 服务实现类
@@ -51,20 +55,23 @@
 
 	/**
 	 * 住户-标签 自定义新增或修改
+	 *
 	 * @param householdLabel
 	 * @return
 	 */
 	@Override
 	public boolean saveOrUpdateHouseholdLabel(UserHouseLabelEntity householdLabel) {
 		// 查询标签名称
-		LabelEntity labelEntity = labelService.getById(householdLabel.getLabelId());
-		householdLabel.setLabelName(labelEntity.getLabelName());
+		if (!Strings.isBlank(householdLabel.getLabelName())) {
+			LabelEntity labelEntity = labelService.getById(householdLabel.getLabelId());
+			householdLabel.setLabelName(labelEntity.getLabelName());
+		}
 		// 判断同一个住户同一个标签是否已存在,已存在则更新,不存在则新增
 		QueryWrapper<UserHouseLabelEntity> queryWrapper = new QueryWrapper<>();
-		queryWrapper.eq("household_id",householdLabel.getHouseholdId())
-			.eq("label_id",householdLabel.getLabelId());
+		queryWrapper.eq("household_id", householdLabel.getHouseholdId())
+			.eq("label_id", householdLabel.getLabelId());
 		UserHouseLabelEntity one = getOne(queryWrapper);
-		if (null != one){
+		if (null != one) {
 			householdLabel.setId(one.getId());
 			// 更新
 			return updateById(householdLabel);
@@ -78,4 +85,55 @@
 		List<Integer> userLabelList = baseMapper.getUserLabelList(userHouseLabelDTO);
 		return userLabelList;
 	}
+
+	@Override
+	public void importUserHouseLabel(List<UserHouseLabelExcel> data, Boolean isCovered) {
+		data.forEach(houseHoldExcel -> {
+			UserHouseLabelEntity userHouseLabelEntity = Objects.requireNonNull(BeanUtil.copy(houseHoldExcel, UserHouseLabelEntity.class));
+			this.save(userHouseLabelEntity);
+		});
+	}
+
+	@Override
+	public IPage<HouseholdLabelVO> statisticalLabels(IPage<HouseholdLabelVO> page, HouseholdLabelVO householdLabel) {
+		return page.setRecords(baseMapper.statisticalLabels(page, householdLabel));
+	}
+
+	@Override
+	public IPage<HouseholdLabelVO> getCommunityStatisticalLabels(IPage<HouseholdLabelVO> page, HouseholdLabelVO householdLabel) {
+		return page.setRecords(baseMapper.getCommunityStatisticalLabels(page, householdLabel));
+	}
+
+	/**
+	 * 房屋-标签 房屋自定义新增或修改
+	 *
+	 * @param userHouseLabelEntity
+	 * @return
+	 */
+	@Override
+	public boolean saveOrUpdateHouseLabel(UserHouseLabelEntity userHouseLabelEntity) {
+		// 查询标签名称
+		LabelEntity labelEntity = labelService.getById(userHouseLabelEntity.getLabelId());
+		if (labelEntity != null) {
+			userHouseLabelEntity.setLabelName(labelEntity.getLabelName());
+		}
+		// 先删除之前的房屋绑定的标签
+		QueryWrapper<UserHouseLabelEntity> queryWrapper = new QueryWrapper<>();
+		queryWrapper.eq("house_code", userHouseLabelEntity.getHouseCode())
+			.eq("lable_type", 2);
+		// 删除
+		remove(queryWrapper);
+		// 插入
+		return save(userHouseLabelEntity);
+	}
+
+	/**
+	 * 查询对应的label集合信息
+	 * @param labelName
+	 * @return
+	 */
+	@Override
+	public List<UserHouseLabelEntity> getLabelList(String labelName) {
+		return baseMapper.getLabelList(labelName);
+	}
 }

--
Gitblit v1.9.3