# Code Start

data =
PropertyExternalDriveFolder.where(last_sync_completed_date: nil).
  joins(:owner).where(users: { google_sync_permission: true }
).each_with_object({}) do |rv_google_folder, hash|
  coll = Services::GoogleDriveSync::GoogleUtilityMethods.new(rv_google_folder).google_collection

  max_file = coll.files.select(&:size).sort { |f1, f2| f1.size <=> f2.size }.last

  next unless max_file

  hash[rv_google_folder.id] = {
    owner: rv_google_folder.owner.email,
    size: "#{(max_file.size / (1024*1024).to_f).round(2)} MB",
    title: max_file.title
  }
end

puts data.values.sort { |h1, h2| h1[:owner] <=> h2[:owner]  }

# Code End

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

# Log Start

{:owner=>"admin@soldmylisting.com", :size=>"37.69 MB",    :title=>"drive-download-20180727T170007Z-001.zip"}
{:owner=>"admin@soldmylisting.com", :size=>"20.72 MB",    :title=>"114 Bridge St - Executed Exclusive Right to List.pdf"}
{:owner=>"brooke@mybeachagent.com", :size=>"11059.35 MB", :title=>"Aerial Video_1.mov"}
{:owner=>"brooke@mybeachagent.com", :size=>"0.91 MB",     :title=>"Fairways at Vandergrift- Deed Restrictions.pdf"}
{:owner=>"brooke@mybeachagent.com", :size=>"9628.49 MB",  :title=>"9130 N Old State Aerial.mov"}
{:owner=>"brooke@mybeachagent.com", :size=>"8783.68 MB",  :title=>"Aerial Video 2.mov"}

# Log End