| | |
| | | + |
| | | "<if test='comActActivityVO.areaCode !=null '>" + "AND ca.area_code = ${comActActivityVO.areaCode} " + " </if> " |
| | | + |
| | | |
| | | "<if test='comActActivityVO.checkUnitId !=null '>" + "AND a.check_unit_id = #{comActActivityVO.checkUnitId} " + " </if> " |
| | | + |
| | | "<if test='comActActivityVO.activityName != null and comActActivityVO.activityName.trim() != ""'>" |
| | | + " and a.activity_name like concat(#{comActActivityVO.activityName},'%') " + " </if> " |
| | | + "<if test='comActActivityVO.status != null and comActActivityVO.status !=0 and comActActivityVO.isIng==null'>" |
| | |
| | | /** |
| | | * 根据社工id查询活动列表 |
| | | * @param page |
| | | * @param id |
| | | * @param commonPage |
| | | * @return |
| | | */ |
| | | IPage<ActActivityListVO> selectActivityBySocialWorker(Page page,@Param("id")Long id); |
| | | IPage<ComActActivityVO> selectActivityBySocialWorker(Page page,@Param("commonPage") CommonPage commonPage); |
| | | |
| | | /** |
| | | * [方法描述] 根据社区ID查询所属城市所在区区域代码, |
| | |
| | | * @return 活动列表 |
| | | */ |
| | | List<ComActActivityVO> selectListByCommunityId(@Param("communityId") Long communityId,@Param("date") String date,@Param("phone")String phone); |
| | | |
| | | /** |
| | | * 获取项目活动 |
| | | * @param page |
| | | * @param comActActivityVO |
| | | * @return |
| | | */ |
| | | IPage<ComActActivityVO> pageProjectActivity(@Param("page") Page page, @Param("comActActivityVO") ComActActivityVO comActActivityVO); |
| | | } |