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