[DfE] 2251-backfill-cansponsorstudentvisa-and-cansponsorskilledvisa-values-for-providers-who-have-been-recently-onboarded

2251-backfill-cansponsorstudentvisa-and-cansponsorskilledvisa-values-for-providers-who-have-been-recently-onboarded.rb

provider_codes = ["3M2","6H5","3E3","4M4","","D5D","7D7","3G3","2M1","7H7","8I8","7G7","8J8","7J7","6J6","4L4","5L5",
"3B2","3L2","3K3","3L1","3O3","5K5","4W4","2T3","5E5","5B5","5U5","5F5","4R4","4T4","2W1","6H6","6T6","8T8","4P2","2W2",
"3J3","3DR","8F8","5G5","5S3","4W6","4R1","2H5"]

providers = RecruitmentCycle.current.next.providers.where(provider_code: provider_codes)

providers.update!(can_sponsor_skilled_worker_visa: false, can_sponsor_student_visa: false)

# There is a validation issue with UKPRN
provider = RecruitmentCycle.current.next.providers.where(provider_code: "1TW")

provider.save!(can_sponsor_skilled_worker_visa: false, can_sponsor_student_visa:false, validate: false)

notes.rb

###
provider = RecruitmentCycle.current.providers.find_by(provider_code: "15D")


#######################################

RecruitmentCycle.current.next.providers.where(id: Provider.where(can_sponsor_skilled_worker_visa: nil).or(Provider.where(can_sponsor_student_visa: nil))).count

RecruitmentCycle.current.providers.where(id: Provider.where(can_sponsor_skilled_worker_visa: nil).or(Provider.where(can_sponsor_student_visa: nil))).count
Provider.where(can_sponsor_skilled_worker_visa: nil).or(Provider.where(can_sponsor_student_visa: nil)).count



next_provider = RecruitmentCycle.current.next.providers.find_by(provider_code:)


recruitment_cycle = RecruitmentCycle.current
a = provider_codes.map do |provider_code|
  provider = recruitment_cycle.providers.find_by(provider_code:)


  suppport_link = "https://qa.publish-teacher-training-courses.service.gov.uk/support/2023/providers/#{provider.id}" if provider.present?
  provider_link = "https://qa.publish-teacher-training-courses.service.gov.uk/publish/organisations/#{provider.provider_code}/#{provider.recruitment_cycle.year}/courses" if provider.present?

  {
    provider_code:,
    exists: provider.present?,
    valid: provider&.valid?,
    suppport_link:,
    provider_link:,
  }
end

recruitment_cycle = RecruitmentCycle.current.next

b = provider_codes.map do |provider_code|
  provider = recruitment_cycle.providers.find_by(provider_code:)


  suppport_link = "https://qa.publish-teacher-training-courses.service.gov.uk/support/2023/providers/#{provider.id}" if provider.present?
  provider_link = "https://qa.publish-teacher-training-courses.service.gov.uk/publish/organisations/#{provider.provider_code}/#{provider.recruitment_cycle.year}/courses" if provider.present?

  {
    provider_code:,
    exists: provider.present?,
    valid: provider&.valid?,
    suppport_link:,
    provider_link:,
  }
end

items = b

CSV.open("#{Rails.configuration.database_configuration["development"]["database"]}-backflip.csv", "wb") do |csv|
  csv << items.first.keys
  items.each do |hash|
    csv << hash.values
  end
end