直接上代码
String hql="from MemberCardEntity where memberId='"+mid+"' and (CURDATE()<= deadline OR deadline is NULL)";
List<MemberCardEntity> cards=new ArrayList<MemberCardEntity>();
List<MemberCardEntity> memberCards = systemService.findByQueryString(hql);
for (MemberCardEntity memberCardEntity : memberCards) {
String memberCardType=memberCardEntity.getType();
if("5".equals(memberCardType)){//类型为时限卡
cards.add(memberCardEntity);
}else{
int count=0;
List<MemberItemEntity> items=memberCardEntity.getMemberItems();
if (items!=null&&!items.isEmpty()) {//卡项目不为空
List<MemberItemEntity> itemsTemp=new ArrayList<MemberItemEntity>();//无用的item
for (MemberItemEntity memberItemEntity : items) {
if (memberItemEntity.getNumber()==0) {//项目数量为0