public List queryCourseByCoachIdAndUserId(long coachId, List idList) {\n List courseDtoList = courseInfoMapper.selectJoinList(CourseDto.class,\n new MPJLambdaWrapper()\n .selectAll(CourseInfo.class)\n .selectAll(UpdateTime.class)\n .innerJoin(UpdateTime.class,UpdateTime::getUpdateTimeId,CourseInfo::getUpdateTimeId)\n .eq(UpdateTime::getCoachId,coachId)\n .isNull(CourseInfo::getUserId)\n .or()\n .in(CourseInfo::getUserId,idList)\n .last("ORDER BY t1.course_date DESC, t1.start_reservation_time DESC, t.submit_time DESC")\n );\n return courseDtoList;\n}

Java MyBatis Plus Query Courses by Coach ID and User IDs

原文地址: https://www.cveoy.top/t/topic/qasS 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录