if params.dig(:order) == 'move_by_desc'
    super.where(is_retired: false).includes(:parking_statuses).where(parking_statuses: {id: parking_hash.values}).order("move_by desc")
  elsif params.dig(:order) == 'move_by_asc'
    super.where(is_retired: false).includes(:parking_statuses).where(parking_statuses: {id: parking_hash.values}).order("move_by asc")
  else
    super.where(is_retired: false).order_by_name.includes(:parking_statuses, :jobs, :trips, trips: :user)
  end
end

column :Last_Location_parked do |car|
 begin 
  best_in_place car, :last_location_parked, type: :input, url: update_data_admin_fleet_info_path(car)
 rescue=> e
 end 
end
# Job.where(state: 'complete').order("updated_at DESC")
column :possession, sortable: true do |car|
  active_job = car.jobs.where(state: "complete").order("updated_at DESC").first
  if active_job&.title == "Delivery"
    active_job&.trip&.user&.name
  else
    "Upshift"
  end
end

column :Trip_End_Time do |car|
  active_job = car.jobs.where(state: "complete").order("updated_at DESC").first
  active_job.trip&.stop_date&.strftime("%A %m/%d %I:%M %p ") if active_job.present?
end

column "move_by", sortable: true do |car|
  begin
  best_in_place car, :move_by, type: :input, url: update_data_admin_fleet_info_path(car)
 rescue=> e
 end
end

column :parking_notes do |car|
  car.parking_statuses&.last&.notes
end

column "Current Mileage" do |car|
  job = car.jobs.where(state: "complete", title: ['Delivery', 'Pickup (Member Absent)']).order("updated_at DESC").first
  if job&.title == "Delivery"
    start_miles = JobTask.where(job_id: job.id, task_id: Task.where(name: "Record mileage")&.first&.id)&.last&.job_task_responses&.last&.response
    if start_miles.nil?
      start_miles = job&.trip&.y_risk_datum&.start_miles
    end
    start_miles == nil ? 00 : start_miles.to_i
  else
    start_miles = JobTask.where(job_id: job&.id, task_id: Task.where(name: "Record mileage")&.first&.id)&.last&.job_task_responses&.last&.response
     if start_miles.nil?
      start_miles = job&.trip&.y_risk_datum&.start_miles
    end
    start_miles == nil ? 00 : start_miles.to_i
  end
end

column "Meter Reading" do |car|
  car.parking_statuses&.last&.meter_reading
end

column :Cleanliness do |car|
  delivery_job_id = car.jobs.where(state: "complete").order("updated_at DESC").first
  clean_task_id = Task.where(name: "Check cleanliness")&.first&.id
  JobTask.where(job_id: delivery_job_id, task_id: clean_task_id)&.last&.job_task_responses&.last&.response
  car.jobs.joins(:job_tasks => [:job_task_responses]).where("job_tasks.task_id =?", Task.find_by(name: "Check cleanliness").id).select("job_task_responses.response").last&.response
end

column :Fuel_Status do |car|
  # delivery_job_id = car.jobs.where(title: "Pickup (Member Absent)", state: "complete").last&.id
  delivery_job_id = car.jobs.where(title: "Pickup (Member Absent)", state: "complete").order("updated_at DESC").first

  gas_task_id = Task.where(name: "Enter cost of fuel")&.first&.id
  if JobTask.where(job_id: delivery_job_id, task_id: gas_task_id).last&.job_task_responses&.last&.response.to_i > 0
    "Full"
  else
    delivery_job_id&.trip&.user&.name
  end
end

column :Last_Damage_Report do |car|
    final_url = "#{request.base_url}/admin/damage_reports?q[car_id_eq]=#{car.id}&commit=Filter&car_id_eq=#{car.id}&order=id_desc"
    link_to('Damage Report',final_url)
  end
  actions
end

show do |car|

  attributes_table do
    row :id
    row :booked
    row :name
    row :created_at
    row :updated_at
    row :vin
    row :make
    row :model
    row :photo_url
    row :upshift_uuid
    row :address_id
    row :license_plate
    row :ota_vehicle_id
    row :is_retired   
  end
  panel 'Media' do
    table_for car&.parking_statuses&.last&.parking_status_medias&.includes(:media), class: 'index_table' do

      column :parking_status_id
      column :media do |car|
    link_to (image_tag car&.parking_status&.parking_status_medias&.last&.media.url, style: "width: 130px; height: 100px"),car&.parking_status&.parking_status_medias&.last&.media.url, target: '_blank' if  car&.parking_status&.parking_status_medias&.last.media.present?
      end
    end
  end
end