| | |
| | | "localhost", |
| | | 8087, |
| | | |
| | | |
| | | "http" |
| | | |
| | | ) |
| | |
| | | .isNull(ZfProperty::getIsHide) |
| | | ); |
| | | } |
| | | if (zfProperty.getHasAttachment() != null && zfProperty.getHasAttachment().equals("是")) { |
| | | if (zfProperty.getHasAttachment() != null) { |
| | | if (zfProperty.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | else { |
| | | lqw.apply("(url IS NULL OR url = '')"); |
| | | } } |
| | | // lqw.in(StringUtils.isNotEmpty(zfEconomy.getCompanionList()),ZfEconomy::getCompanion,zfEconomy.getCompanionList()); |
| | | // if (zfEconomy.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfEconomy.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); |
| | | } |
| | | } |
| | |
| | | .isNull(TravelCount::getIsHide) |
| | | ); |
| | | } |
| | | if (travelCount.getHasAttachment() != null && travelCount.getHasAttachment().equals("是")) { |
| | | 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); |
| | | } |
| | | } |
| | |
| | | .isNull(ZfClean::getIsHide) |
| | | ); |
| | | } |
| | | if (zfClean.getHasAttachment() != null && zfClean.getHasAttachment().equals("是")) { |
| | | if (zfClean.getHasAttachment() != null) { |
| | | if (zfClean.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | else { |
| | | lqw.apply("(url IS NULL OR url = '')"); |
| | | } } |
| | | // lqw.in(StringUtils.isNotEmpty(zfClean.getCompanionList()),zfClean::getCompanion,zfClean.getCompanionList()); |
| | | // if (zfClean.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfClean.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); |
| | | } |
| | | } |
| | |
| | | .isNull(ZfCollection::getIsHide) |
| | | ); |
| | | } |
| | | if (zfCollection.getHasAttachment() != null && zfCollection.getHasAttachment().equals("是")) { |
| | | 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); |
| | | } |
| | | } |
| | |
| | | .isNull(ZfDoctor::getIsHide) |
| | | ); |
| | | } |
| | | if (zfDoctor.getHasAttachment() != null && zfDoctor.getHasAttachment().equals("是")) { |
| | | if (zfDoctor.getHasAttachment() != null) { |
| | | if (zfDoctor.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | }// lqw.like(StringUtils.isNotEmpty(zfDoctor.getCompanion()),ZfDoctor::getCompanion,zfDoctor.getCompanion()); |
| | | |
| | | } |
| | | else { |
| | | lqw.apply("(url IS NULL OR url = '')"); |
| | | } } |
| | | if (CollectionUtils.isNotEmpty(zfDoctor.getCompanionList())) { |
| | | List<String> companionList = zfDoctor.getCompanionList(); |
| | | |
| | |
| | | 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); |
| | | } |
| | | } |
| | |
| | | .isNull(ZfEconomy::getIsHide) |
| | | ); |
| | | } |
| | | if (zfEconomy.getHasAttachment() != null && zfEconomy.getHasAttachment().equals("是")) { |
| | | if (zfEconomy.getHasAttachment() != null) { |
| | | if (zfEconomy.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | else { |
| | | lqw.apply("(url IS NULL OR url = '')"); |
| | | } } |
| | | // lqw.in(StringUtils.isNotEmpty(zfEconomy.getCompanionList()),ZfEconomy::getCompanion,zfEconomy.getCompanionList()); |
| | | // if (zfEconomy.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfEconomy.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); |
| | | } |
| | | } |
| | |
| | | .isNull(ZfEquipment::getIsHide) |
| | | ); |
| | | } |
| | | if (zfEquipment.getHasAttachment() != null && zfEquipment.getHasAttachment().equals("是")) { |
| | | if (zfEquipment.getHasAttachment() != null) { |
| | | if (zfEquipment.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | else { |
| | | lqw.apply("(url IS NULL OR url = '')"); |
| | | } |
| | | |
| | | } |
| | | // lqw.in(StringUtils.isNotEmpty(zfEquipment.getCompanionList()),zfEquipment::getCompanion,zfEquipment.getCompanionList()); |
| | | // if (zfEquipment.getYear() != 0) { |
| | |
| | | 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); |
| | | } |
| | | } |
| | |
| | | lqw.like(!StringUtils.isEmpty(zfEvent.getPeople()), ZfEvent::getPeople, zfEvent.getPeople()); |
| | | |
| | | } |
| | | if (zfEvent.getHasAttachment() != null && zfEvent.getHasAttachment().equals("是")) { |
| | | if (zfEvent.getHasAttachment() != null) { |
| | | if (zfEvent.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | else { |
| | | lqw.apply("(url IS NULL OR url = '')"); |
| | | } |
| | | |
| | | } |
| | | // lqw.in(StringUtils.isNotEmpty(ZfEvent.getCompanionList()),ZfEvent::getCompanion,ZfEvent.getCompanionList()); |
| | | // if (ZfEvent.getYear() != 0) { |
| | |
| | | if (!companionList.isEmpty()) { |
| | | // 确保所有参与人都在companion字段中 |
| | | for (String companion : companionList) { |
| | | System.out.println("[[[[["+companion); |
| | | lqw.apply( |
| | | "FIND_IN_SET({0}, REPLACE(REPLACE(people, ' ', ''), ',', ',')) > 0", |
| | | "FIND_IN_SET({0}, REPLACE(REPLACE(REPLACE(people, ' ', ''), ',', ','),';',',')) > 0", |
| | | companion); |
| | | } |
| | | } |
| | |
| | | zfEvent.setHappenEndTime(happenEndTime); |
| | | |
| | | System.out.println("--------------"+companion+"-----------------"); |
| | | String[] split = companion.trim().replace(" ", "").replace(",", ",").split(","); |
| | | String[] split = companion.trim().replace(" ", "").replace(",", ",").replace(";",",").split(","); |
| | | |
| | | System.out.println(Arrays.toString(split)); |
| | | List<String> list = Arrays.asList(split); |
| | | |
| | | zfEvent.setCompanionList(list); |
| | |
| | | .isNull(ZfPet::getIsHide) |
| | | ); |
| | | } |
| | | if (zfPet.getHasAttachment() != null && zfPet.getHasAttachment().equals("是")) { |
| | | if (zfPet.getHasAttachment() != null) { |
| | | if (zfPet.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | else { |
| | | lqw.apply("(url IS NULL OR url = '')"); |
| | | } } |
| | | // lqw.in(StringUtils.isNotEmpty(zfPet.getCompanionList()),zfPet::getCompanion,zfPet.getCompanionList()); |
| | | // if (zfPet.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfPet.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); |
| | | } |
| | | } |