lidongdong
2023-09-04 b2fce0dc7dc4ea5dec9792a2bc3ceb9d33d6e07b
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComPropertyDao.java
@@ -4,11 +4,17 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.community.ComActSocialOrgVO;
import com.panzhihua.common.model.vos.community.ComActAnnouncementVO;
import com.panzhihua.common.model.vos.community.ComPropertyVO;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.common.model.vos.community.StatisticsCommVO;
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenAlarmStatisticsInfo;
import com.panzhihua.common.model.vos.property.ComPropertyAlarmVO;
import com.panzhihua.common.model.vos.property.ComPropertyEquipmentVO;
import com.panzhihua.service_community.entity.ComProperty;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
 * (ComProperty)表数据库访问层
@@ -25,4 +31,80 @@
     * @return
     */
    IPage<ComPropertyVO> pageList(Page page, @Param("commonPage") CommonPage commonPage);
    /**
     * 居民自治大屏统计数据获取
     * @param communityId
     * @return
     */
    List<StatisticsCommVO> getRepairPolylineDate(@Param("communityId") Long communityId);
    /**
     * 报事报修date之前的累计数量
     * @param communityId
     * @param date
     * @return
     */
    StatisticsCommVO getRepairTotalPolylineDate(@Param("communityId") Long communityId, @Param("date") String date);
    List<StatisticsCommVO> getEventAddPolylineData(@Param("communityId") Long communityId);
    StatisticsCommVO getEventTotalPolylineDate(@Param("communityId") Long communityId, @Param("date") String date);
    /**
     * 杨家坪定制页面-居家养老基础数据
     * @param communityId
     * @return
     */
    BigScreenAlarmStatisticsInfo getAlarmBaseData(@Param("communityId") Long communityId);
    /**
     * 异常报警新增折线数据
     * @param communityId
     * @return
     */
    List<StatisticsCommVO> retrieveAbnormalAddPolylineData(@Param("communityId") Long communityId);
    /**
     * 异常报警累计折线数据
     * @param communityId
     * @param date
     * @return
     */
    StatisticsCommVO retrieveAbnormalTotalPolylineData(@Param("communityId") Long communityId, @Param("date") String date);
    /**
     * 一键求助服务新增折线数据
     * @param communityId
     * @return
     */
    List<StatisticsCommVO> retrieveServiceAddPolylineData(@Param("communityId") Long communityId);
    /**
     * 一键求助服务累计折线数据
     * @param communityId
     * @param date
     * @return
     */
    StatisticsCommVO retrieveServiceTotalPolylineData(@Param("communityId") Long communityId, @Param("date") String date);
    /**
     * 获取报警记录
     * @param page
     * @param type
     * @param status
     * @param communityId
     * @return
     */
    IPage<ComPropertyAlarmVO> getAbnormalList(@Param("page") Page page, @Param("type") Integer type,
                                              @Param("status") Integer status, @Param("communityId") Long communityId);
    /**
     * 获取报警设备点位图
     * @param communityId
     * @return
     */
    List<ComPropertyEquipmentVO> getAlarmPointMapData(@Param("communityId") Long communityId);
    IPage<ComActAnnouncementVO> noticeList(Page page, @Param("propertyId") Long propertyId);
}