# Create Location Excel
file = "#{Rails.root}/public/test_location.csv"
column_headers = ["country", "state", "city", "area"]

csv = CSV.open(file, 'w', write_headers: true, headers: column_headers) do |writer|
  10.times do
    Faker::Config.locale = 'en-IND'
    country = Faker::Address.country
    state   = Faker::Address.state
    city    = Faker::Address.city
    area    = Faker::Address.street_address

    writer << [country, state, city, area]
  end
end

# Create Manager Excel
file = "#{Rails.root}/public/test_manager.csv"
column_headers = ["name",	"email", "mobile", "username", "password"]

csv = CSV.open(file, 'w', write_headers: true, headers: column_headers) do |writer|
  100.times do
    Faker::Config.locale = 'en-IND'
    name     = Faker::Name.name
    email    = Faker::Internet.email
    mobile   = Faker::PhoneNumber.phone_number.gsub('-','')
    username = Faker::Internet.user_name
    password = 'test123'


    writer << [name, email, mobile, username, password]
  end
end

# Create Learners Excel
file = "#{Rails.root}/public/test_learner.csv"
column_headers = ["name",	"email",	"password",	"mobile",	"username",	"manager_username",	"team_name",	"location_name"]

csv = CSV.open(file, 'w', write_headers: true, headers: column_headers) do |writer|
  Sq::UserProfile.where(:"access_roles".in => [User::AccessRole::SQ_MANAGER]).each do |manager|
    100.times do

      Faker::Config.locale = 'en-IND'
      name     = Faker::Name.name
      email    = Faker::Internet.email
      password = 'test123'
      mobile   = Faker::PhoneNumber.phone_number.gsub('-','')
      username = Faker::Internet.user_name
      manager_username = manager.user_document["username"]
      team_name = "Engineering"
      location_name = Sq::Location.all.sample.name

      writer << [name, email, password, mobile, username, manager_username, team_name, location_name]
    end
  end
end