Sort in python and add an index to improve StackedConfigModel.current…

remove flaky account settings page test

use edx crowdsourcehinter fork

[REVMI-21] Remove CONTENT_TYPE_GATING flag and FEATURE_BASED_ENROLLMENT_GLOBAL_KILL_FLAG flag

Improve the performance of access checking for a specific user in CourseViewList by prefetching data

Merge pull request #19966 from edx/testeng/bokchoy_auto_cache_update_57f631ad1d9b1523d1e35b51c2f8f17b926fd050

Bokchoy db cache update

Add aria-label toggling for play/pause and fill browser buttons

Filter out certificates for nonexistent courses

ARCH-452: Filter certificate list API based on user profile visibility preference.

ENT-1555 updating edx-enterprise to introduce system wide roles

LEARNER-7086. Uses a new model manager for GeneratedCertificate that excludes
certificates whose course_id does not correspond to a valid CourseOverview

REVEM-219 Handle invalid course run key

Merge pull request #19954 from edx/testeng/bokchoy_auto_cache_update_224fa696472c3fd35f4920ce2f428d351c3a948f

Bokchoy db cache update

Remove flaky studio settings test

Remove flaky lms instructor dashboard test

REVMI-67 update description to describe datetime as user local time

Fixed download txt transcript 500

LEARNER-6946 management command to send verification expiry email

Template for email added (email/verification_expiry_email)
The management command filters the SoftwareSecurePhotoVerification model on the basis of following criteria :
-- the verification is approved
-- the start_date < expiry_date < today or specified days have passed to resend email
After the basic filtering batches are created to send email. For each verification in a batch email is sent and email_expiry_date is set to 15 days from today (default days are 15, it can be changed too)
Between each batch there is a delay of sleep_time seconds

Template for email added (email/verification_expiry_email)
The management command filters the SoftwareSecurePhotoVerification model on the basis of following criteria :
-- the verification is approved
-- the start_date < expiry_date < today or specified days have passed to resend email
After the basic filtering batches are created to send email. For each verification in a batch email is sent and
email_expiry_date is set to 15 days from today (default days are 15, it can be changed too)
Between each batch there is a delay of sleep_time seconds

Improve 403 error handling

LEARNER-7136 populate expiry date and add mechanism for new verification

Method approve() is overridden to accommodate new users that will have their verification approved in the future. The approve() method is called from software secure results callback every time a Software Secure Photo Verification is approved.The method overridden now updates expiry_date and then calls super to perform task it was performing before this change.The expiry_date set is the same as the one sent in verification approval email.

In results_callback for sspv the expiry_date and expiry_email_date for the most recent previous verification if exists are also updated to NULL.