通过E呼即办数据统计

linwe

2024-05-29 c10d6358b9f014375a13821465bc978d0c0da22e

 src/main/java/org/springblade/modules/property/service/impl/PropertyCompanyCommentServiceImpl.java

@@ -17,13 +17,17 @@
package org.springblade.modules.property.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.apache.logging.log4j.util.Strings;
import org.springblade.common.utils.SpringUtils;
import org.springblade.core.log.exception.ServiceException;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.modules.property.entity.PropertyCompanyCommentEntity;
import org.springblade.modules.property.entity.PropertyCompanyEntity;
import org.springblade.modules.property.entity.PropertyCompanyScoreEntity;
import org.springblade.modules.property.service.IPropertyCompanyScoreService;
import org.springblade.modules.property.service.IPropertyCompanyService;
import org.springblade.modules.property.vo.PropertyCompanyCommentVO;
import org.springblade.modules.property.mapper.PropertyCompanyCommentMapper;
import org.springblade.modules.property.service.IPropertyCompanyCommentService;
@@ -34,6 +38,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springframework.transaction.annotation.Transactional;

import java.math.BigDecimal;
import java.util.Map;

/**
@@ -116,7 +121,22 @@
            // 新增
             propertyCompanyScoreService.save(propertyCompanyScoreEntity);
         }
         // todo 计算物业公司评价平均分
         // t 计算物业公司评价平均分

         QueryWrapper<PropertyCompanyScoreEntity> queryWrapperTwo = new QueryWrapper<>();
         queryWrapperTwo.eq("is_deleted",0).eq("property_company_id",propertyCompanyComment.getPropertyCompanyId());
         // t统计物业公司总评价数
         long count = propertyCompanyScoreService.count(queryWrapperTwo);
         // 统计物业公司总评价分
         Integer score = propertyCompanyScoreService.getScore(propertyCompanyComment.getPropertyCompanyId());
         // 计算评价分
         BigDecimal divide = BigDecimal.valueOf(score).divide(BigDecimal.valueOf(count));
         // 更新物业评价平均分
         PropertyCompanyEntity propertyCompanyEntity = new PropertyCompanyEntity();
         propertyCompanyEntity.setId(propertyCompanyComment.getPropertyCompanyId());
         propertyCompanyEntity.setEvaluateScore(divide);
         IPropertyCompanyService bean = SpringUtils.getBean(IPropertyCompanyService.class);
         bean.updateById(propertyCompanyEntity);
      }
   }
}