新增农事查询统计接口

Administrator

2022-05-19 30c3d4510aa688dbcaa8797517b6bcd06c61aaaa

新增农事查询统计接口

 src/main/java/org/springblade/modules/farm/controller/FarmingRecordController.java

@@ -122,4 +122,13 @@
        return R.status(farmService.removeByIds(Func.toLongList(ids)));
    }

    /**
     * 查询统计本年农事记录操作总数
     * @return
     */
    @GetMapping("/getFarmingCount")
    public R getFarmingCount(){
        return R.data(farmService.getFarmingCount());
    }

}

 src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.java

@@ -39,4 +39,10 @@
     * @return
     */
    List<FarmingRecordVO> selectFarmingRecordPage(@Param("page") IPage page,@Param("farmingRecord") FarmingRecordVO farm);

    /**
     * 查询统计本年农事记录操作总数
     * @return
     */
    Integer getFarmingCount();
}

 src/main/java/org/springblade/modules/farm/mapper/FarmingRecordMapper.xml

@@ -23,4 +23,11 @@
            and sfr.operator = #{farmingRecord.operator}
        </if>
    </select>

    <!--查询统计本年农事记录操作总数-->
    <select id="getFarmingCount" resultType="java.lang.Integer">
        select ifnull(count(*),0) count from sys_farming_record
        where 1=1
        and YEAR(time)=YEAR(NOW())
    </select>
</mapper>

 src/main/java/org/springblade/modules/farm/service/FarmingRecordService.java

@@ -21,4 +21,10 @@
     * @return
     */
    IPage<FarmingRecordVO> selectFarmingRecordPage(IPage<FarmingRecordVO> page, FarmingRecordVO farm);

    /**
     * 查询统计本年农事记录操作总数
     * @return
     */
    Object getFarmingCount();
}

 src/main/java/org/springblade/modules/farm/service/impl/FarmRecordServiceImpl.java

@@ -25,4 +25,14 @@
    public IPage<FarmingRecordVO> selectFarmingRecordPage(IPage<FarmingRecordVO> page, FarmingRecordVO farm) {
        return page.setRecords(baseMapper.selectFarmingRecordPage(page, farm));
    }


    /**
     * 查询统计本年农事记录操作总数
     * @return
     */
    @Override
    public Object getFarmingCount() {
        return baseMapper.getFarmingCount();
    }
}