| | |
| | | import com.panzhihua.common.model.vos.community.ComActPasswordVo; |
| | | import com.panzhihua.common.model.vos.community.DataCount; |
| | | import com.panzhihua.common.model.vos.partybuilding.ComPbMemberTypeVO; |
| | | import com.panzhihua.common.model.vos.puda.DynamicVO; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | |
| | | + "and a.name LIKE concat( #{pageComActDTO.name}, '%' ) \n" + " </if> " |
| | | + "<if test='pageComActDTO.areaCode != null and pageComActDTO.areaCode.trim() != ""'>" |
| | | + "AND a.area_code = #{pageComActDTO.areaCode} \n" + " </if> " |
| | | + "<if test='pageComActDTO.createAtBegin != null '>" + "AND a.create_at BETWEEN " |
| | | + "<if test='pageComActDTO.createAtBegin != null '>" |
| | | + "AND a.create_at BETWEEN " |
| | | + "#{pageComActDTO.createAtBegin} \n" + "AND #{pageComActDTO.createAtEnd}" + " </if> " + " </where>" |
| | | + " order by a.create_at desc" + "</script>") |
| | | IPage<ComActVO> pageCommunity(Page page, @Param("pageComActDTO") PageComActDTO pageComActDTO); |
| | |
| | | @Select("<script> select community_id,name,lng,lat from com_act where state = 0 <if test='areaCode !=null and areaCode !=""'> and area_code = #{areaCode} </if> </script>") |
| | | List<EventGridCommunityAdminVO> getWestCommunityLists(@Param("areaCode") String areCode); |
| | | |
| | | @Select("select account,plaintext_password as password from com_act where community_id = ${communityId}") |
| | | @Select("select account,plaintext_password as password from com_act where community_id = #{communityId}") |
| | | ComActPasswordVo getCommunityPassword(@Param("communityId") Long communityId); |
| | | |
| | | @Select("select name from com_pb_check_unit where id=#{id}") |