| | |
|---|
| | | .isNull(ZfCollection::getIsHide) |
|---|
| | | ); |
|---|
| | | } |
|---|
| | | if (zfCollection.getHasAttachment() != null && zfCollection.getHasAttachment().equals("是")) { |
|---|
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
|---|
| | | } |
|---|
| | | if (zfCollection.getHasAttachment() != null) { |
|---|
| | | if (zfCollection.getHasAttachment().equals("是")) { |
|---|
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
|---|
| | | } |
|---|
| | | else { |
|---|
| | | lqw.apply("(url IS NULL OR url = '')"); |
|---|
| | | } } |
|---|
| | | // lqw.in(StringUtils.isNotEmpty(zfCollection.getCompanionList()),zfCollection::getCompanion,zfCollection.getCompanionList()); |
|---|
| | | // if (zfCollection.getYear() != 0) { |
|---|
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfCollection.getYear()); |
|---|
| | |
|---|
| | | if (!companionList.isEmpty()) { |
|---|
| | | // 确保所有参与人都在companion字段中 |
|---|
| | | for (String companion : companionList) { |
|---|
| | | lqw.apply("FIND_IN_SET({0}, REPLACE(REPLACE(owner, ' ', ''), '，', ',')) > 0", |
|---|
| | | lqw.apply("FIND_IN_SET({0}, REPLACE(REPLACE(REPLACE(people, ' ', ''), '，', ','),';',',')) > 0", |
|---|
| | | companion); |
|---|
| | | } |
|---|
| | | } |
|---|
