def managefiles
    @searchval = ''
    @title = ' - Manage Files'
    @folder = Painting.select("DISTINCT folder").where(:company_id => current_user.company_id, :deleted => nil, :versioned => nil).order("folder ASC, name ASC")
    @allfiles = Painting.select("DISTINCT folder, name, id").where(:company_id => current_user.company_id, :deleted => nil).order("name ASC")
    #@allfiles = Painting.select("folder, name, id").order("name DESC")
  end