| | |
|---|
| | | + "FROM\n" + "com_pb_dyn d\n" + "LEFT JOIN com_pb_dyn_user u ON d.id = u.dyn_id left join com_act t on d.community_id = t.community_id\n" |
|---|
| | | + "where d.type=#{partyBuildingComPbDynVO.type} \n" |
|---|
| | | + "<if test='partyBuildingComPbDynVO.communityId != null and partyBuildingComPbDynVO.communityId != 0'>" |
|---|
| | | + "and d.community_id = #{partyBuildingComPbDynVO.communityId} \n" + " </if> " |
|---|
| | | + "and d.community_id = ${partyBuildingComPbDynVO.communityId} \n" + " </if> " |
|---|
| | | + "<if test='partyBuildingComPbDynVO.dynType != null and partyBuildingComPbDynVO.dynType != 0'>" |
|---|
| | | + "and d.dyn_type = #{partyBuildingComPbDynVO.dynType} \n" + " </if> " |
|---|
| | | + "<if test='partyBuildingComPbDynVO.policyType != null and partyBuildingComPbDynVO.policyType != 0'>" |
|---|
