3¥/home/jenkins/.jenkins/workspace/dev-simplified-onboarding-distributedcache/lib-database/src/commonMain/kotlin/com/ustadmobile/core/db/dao/ClazzEnrolmentDaoCommon.kt ClazzEnrolmentDaoCommon_instanceSORT_FIRST_NAME_ASC_1SORT_FIRST_NAME_DESC_1SORT_LAST_NAME_ASC_1SORT_LAST_NAME_DESC_1SORT_DATE_REGISTERED_ASC_1SORT_DATE_REGISTERED_DESC_1SORT_DATE_LEFT_ASC_1SORT_DATE_LEFT_DESC_1FILTER_ACTIVE_ONLY_1%WITH_CURRENTLY_ENROLED_STUDENTS_SQL_1À WITH CurrentlyEnrolledPersonUids(enroledPersonUid) AS (SELECT DISTINCT ClazzEnrolment.clazzEnrolmentPersonUid AS enroledPersonUid FROM ClazzEnrolment WHERE ClazzEnrolment.clazzEnrolmentClazzUid = :clazzUid AND ClazzEnrolment.clazzEnrolmentRole = 1000 AND :time BETWEEN ClazzEnrolment.clazzEnrolmentDateJoined AND ClazzEnrolment.clazzEnrolmentDateLeft) "SELECT_ENROLMENT_TYPE_BY_UID_SQL_1¢ SELECT ClazzEnrolment.clazzEnrolmentRole FROM ClazzEnrolment WHERE ClazzEnrolment.clazzEnrolmentUid = :clazzEnrolmentUid +PERMISSION_REQUIRED_BY_CLAZZENROLMENT_UID_1ú CASE ( SELECT ClazzEnrolment.clazzEnrolmentRole FROM ClazzEnrolment WHERE ClazzEnrolment.clazzEnrolmentUid = :clazzEnrolmentUid ) WHEN 1000 THEN 8 ELSE 8 END 3SELECT_ACCOUNT_PERSON_UID_IS_STUDENT_IN_CLAZZ_UID_19 (SELECT EXISTS( SELECT 1 FROM ClazzEnrolment WHERE ClazzEnrolment.clazzEnrolmentClazzUid = :clazzUid AND ClazzEnrolment.clazzEnrolmentPersonUid = :accountPersonUid AND ClazzEnrolment.clazzEnrolmentRole = 1000)) SELECT_BY_UID_AND_ROLE_SQL_1Ž SELECT * FROM (SELECT Person.*, PersonPicture.*, (SELECT MIN(ClazzEnrolment.clazzEnrolmentDateJoined) FROM ClazzEnrolment WHERE Person.personUid = ClazzEnrolment.clazzEnrolmentPersonUid) AS earliestJoinDate, (SELECT MAX(ClazzEnrolment.clazzEnrolmentDateLeft) FROM ClazzEnrolment WHERE Person.personUid = ClazzEnrolment.clazzEnrolmentPersonUid) AS latestDateLeft, (SELECT ClazzEnrolment.clazzEnrolmentRole FROM ClazzEnrolment WHERE Person.personUid = ClazzEnrolment.clazzEnrolmentPersonUid AND ClazzEnrolment.clazzEnrolmentClazzUid = :clazzUid AND ClazzEnrolment.clazzEnrolmentActive ORDER BY ClazzEnrolment.clazzEnrolmentDateLeft DESC LIMIT 1) AS enrolmentRole FROM Person LEFT JOIN PersonPicture ON PersonPicture.personPictureUid = Person.personUid WHERE Person.personUid IN (SELECT DISTINCT ClazzEnrolment.clazzEnrolmentPersonUid FROM ClazzEnrolment WHERE ClazzEnrolment.clazzEnrolmentClazzUid = :clazzUid AND ClazzEnrolment.clazzEnrolmentActive AND ClazzEnrolment.clazzEnrolmentRole = :roleId AND (:filter != 1 OR (:currentTime BETWEEN ClazzEnrolment.clazzEnrolmentDateJoined AND ClazzEnrolment.clazzEnrolmentDateLeft))) /* Begin permission check */ AND ( ( ( /* If the accountPersonUid is the owner of the course, all permissions are granted */ (COALESCE( (SELECT _Clazz_Permission.clazzOwnerPersonUid FROM Clazz _Clazz_Permission WHERE _Clazz_Permission.clazzUid = :clazzUid), 0) = :accountPersonUid) /* If there is a CoursePermission entity that is for the course as per the clazzUid parameter that is granted to the person directly or to the enrolmentRole that the person has in the course, then permission is granted. */ OR EXISTS(SELECT CoursePermission.cpUid FROM CoursePermission LEFT JOIN ClazzEnrolment ClazzEnrolment_ForAccountPerson ON CoursePermission.cpToEnrolmentRole != 0 AND ClazzEnrolment_ForAccountPerson.clazzEnrolmentUid = (SELECT COALESCE( (SELECT _ClazzEnrolment_AccountPersonInner.clazzEnrolmentUid FROM ClazzEnrolment _ClazzEnrolment_AccountPersonInner WHERE _ClazzEnrolment_AccountPersonInner.clazzEnrolmentClazzUid = CoursePermission.cpClazzUid AND _ClazzEnrolment_AccountPersonInner.clazzEnrolmentPersonUid = :accountPersonUid AND _ClazzEnrolment_AccountPersonInner.clazzEnrolmentActive ORDER BY _ClazzEnrolment_AccountPersonInner.clazzEnrolmentDateLeft DESC LIMIT 1), 0)) WHERE CoursePermission.cpClazzUid = :clazzUid AND (CoursePermission.cpToPersonUid = :accountPersonUid OR CoursePermission.cpToEnrolmentRole = ClazzEnrolment_ForAccountPerson.clazzEnrolmentRole) AND (CoursePermission.cpPermissionsFlag & :permission ) > 0) OR EXISTS(SELECT SystemPermission.spUid FROM SystemPermission WHERE SystemPermission.spToPersonUid = :accountPersonUid AND (SystemPermission.spPermissionsFlag & :permission ) > 0) ) ) OR Person.personUid = :accountPersonUid ) /* End permission check */ AND Person.firstNames || ' ' || Person.lastName LIKE :searchText GROUP BY Person.personUid, PersonPicture.personPictureUid) AS CourseMember ORDER BY CASE(:sortOrder) WHEN 1 THEN CourseMember.firstNames WHEN 3 THEN CourseMember.lastName ELSE '' END ASC, CASE(:sortOrder) WHEN 2 THEN CourseMember.firstNames WHEN 4 THEN CourseMember.lastName ELSE '' END DESC, CASE(:sortOrder) WHEN 7 THEN CourseMember.earliestJoinDate WHEN 9 THEN CourseMember.latestDateLeft ELSE 0 END ASC, CASE(:sortOrder) WHEN 8 THEN CourseMember.earliestJoinDate WHEN 10 THEN CourseMember.latestDateLeft ELSE 0 END DESC +PERSON_UIDS_FOR_PAGED_GRADEBOOK_QUERY_CTE_1R PersonUids(personUid) AS ( SELECT CourseMember.personUid FROM (SELECT Person.*, (SELECT MIN(ClazzEnrolment.clazzEnrolmentDateJoined) FROM ClazzEnrolment WHERE Person.personUid = ClazzEnrolment.clazzEnrolmentPersonUid) AS earliestJoinDate, (SELECT MAX(ClazzEnrolment.clazzEnrolmentDateLeft) FROM ClazzEnrolment WHERE Person.personUid = ClazzEnrolment.clazzEnrolmentPersonUid) AS latestDateLeft, (SELECT ClazzEnrolment.clazzEnrolmentRole FROM ClazzEnrolment WHERE Person.personUid = ClazzEnrolment.clazzEnrolmentPersonUid AND ClazzEnrolment.clazzEnrolmentClazzUid = :clazzUid AND ClazzEnrolment.clazzEnrolmentActive ORDER BY ClazzEnrolment.clazzEnrolmentDateLeft DESC LIMIT 1) AS enrolmentRole FROM Person WHERE Person.personUid IN (SELECT DISTINCT ClazzEnrolment.clazzEnrolmentPersonUid FROM ClazzEnrolment WHERE ClazzEnrolment.clazzEnrolmentClazzUid = :clazzUid AND ClazzEnrolment.clazzEnrolmentActive AND ClazzEnrolment.clazzEnrolmentRole = :roleId AND (:filter != 1 OR (:currentTime BETWEEN ClazzEnrolment.clazzEnrolmentDateJoined AND ClazzEnrolment.clazzEnrolmentDateLeft))) /* Begin permission check */ AND ( (( /* If the accountPersonUid is the owner of the course, all permissions are granted */ (COALESCE( (SELECT _Clazz_Permission.clazzOwnerPersonUid FROM Clazz _Clazz_Permission WHERE _Clazz_Permission.clazzUid = :clazzUid), 0) = :accountPersonUid) /* If there is a CoursePermission entity that is for the course as per the clazzUid parameter that is granted to the person directly or to the enrolmentRole that the person has in the course, then permission is granted. */ OR EXISTS(SELECT CoursePermission.cpUid FROM CoursePermission LEFT JOIN ClazzEnrolment ClazzEnrolment_ForAccountPerson ON CoursePermission.cpToEnrolmentRole != 0 AND ClazzEnrolment_ForAccountPerson.clazzEnrolmentUid = (SELECT COALESCE( (SELECT _ClazzEnrolment_AccountPersonInner.clazzEnrolmentUid FROM ClazzEnrolment _ClazzEnrolment_AccountPersonInner WHERE _ClazzEnrolment_AccountPersonInner.clazzEnrolmentClazzUid = CoursePermission.cpClazzUid AND _ClazzEnrolment_AccountPersonInner.clazzEnrolmentPersonUid = :accountPersonUid AND _ClazzEnrolment_AccountPersonInner.clazzEnrolmentActive ORDER BY _ClazzEnrolment_AccountPersonInner.clazzEnrolmentDateLeft DESC LIMIT 1), 0)) WHERE CoursePermission.cpClazzUid = :clazzUid AND (CoursePermission.cpToPersonUid = :accountPersonUid OR CoursePermission.cpToEnrolmentRole = ClazzEnrolment_ForAccountPerson.clazzEnrolmentRole) AND (CoursePermission.cpPermissionsFlag & 128 ) > 0) OR EXISTS(SELECT SystemPermission.spUid FROM SystemPermission WHERE SystemPermission.spToPersonUid = :accountPersonUid AND (SystemPermission.spPermissionsFlag & 128 ) > 0) ) ) OR Person.personUid = :accountPersonUid ) /* End permission check */ AND Person.firstNames || ' ' || Person.lastName LIKE :searchText GROUP BY Person.personUid) AS CourseMember ORDER BY CASE(:sortOrder) WHEN 1 THEN CourseMember.firstNames WHEN 3 THEN CourseMember.lastName ELSE '' END ASC, CASE(:sortOrder) WHEN 2 THEN CourseMember.firstNames WHEN 4 THEN CourseMember.lastName ELSE '' END DESC, CASE(:sortOrder) WHEN 7 THEN CourseMember.earliestJoinDate WHEN 9 THEN CourseMember.latestDateLeft ELSE 0 END ASC, CASE(:sortOrder) WHEN 8 THEN CourseMember.earliestJoinDate WHEN 10 THEN CourseMember.latestDateLeft ELSE 0 END DESC LIMIT :studentsLimit OFFSET :studentsOffset ) ClazzEnrolmentDaoCommon!get_SORT_FIRST_NAME_ASC_uiz2kk_k$protoOf"get_SORT_FIRST_NAME_DESC_mxs51a_k$ get_SORT_LAST_NAME_ASC_qs7cum_k$!get_SORT_LAST_NAME_DESC_m2yybw_k$&get_SORT_DATE_REGISTERED_ASC_cdy0er_k$'get_SORT_DATE_REGISTERED_DESC_suoft7_k$ get_SORT_DATE_LEFT_ASC_bkyss2_k$!get_SORT_DATE_LEFT_DESC_3wg5ao_k$ get_FILTER_ACTIVE_ONLY_23n62h_k$1get_WITH_CURRENTLY_ENROLED_STUDENTS_SQL_vl6cpi_k$-get_SELECT_ENROLMENT_TYPE_BY_UID_SQL_594x3_k$7get_PERMISSION_REQUIRED_BY_CLAZZENROLMENT_UID_yuq0ok_k$?get_SELECT_ACCOUNT_PERSON_UID_IS_STUDENT_IN_CLAZZ_UID_mgtoyj_k$(get_SELECT_BY_UID_AND_ROLE_SQL_270ura_k$7get_PERSON_UIDS_FOR_PAGED_GRADEBOOK_QUERY_CTE_uyteql_k$#ClazzEnrolmentDaoCommon_getInstance;com.ustadmobile.core.db.dao/ClazzEnrolmentDaoCommon|null[0]Cic#94:com.ustadmobile.core.db.dao/ClazzEnrolmentDaoCommon|null[0]-1(kotlin.js/protoOf|8514483458758599133[0]+kotlin.js/objectMeta|8329516420247412592[0] objectMeta0kotlin.js/setMetadataFor|-3190451995726208444[0]setMetadataForCic#94:com.ustadmobile.core.db.dao/ClazzEnrolmentDaoCommon|null[0]-0kotlin/Any|null[0]Any4   ! " # $%&'(-/2ClazzEnrolmentDaoCommoncom.ustadmobile.core.db.dao   $  $ $ %  % %# ##$ $$) ))* **# ## $ $$ #  ##"4  "4"4 +1  +1+11:  1:1:<B  <B<BX+ X+X+œ: œ:œ:                                        !  "   #  $" " " %"  &+ + + '+  (1 1 1 )1  *< < < +<  ,X X X -X  .œ œ œ /œ   0)*+,1.200131321)*0