cirandas.net

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

class FbesPlugin::EnterprisesController < PublicController

  def search
    if id_sies = params[:id_sies]
      @enterprises = environment.enterprises.where 'data LIKE ?', "%id_sies: #{id_sies}%"
    elsif name = params[:name]
      @enterprises = environment.enterprises.where 'LOWER(name) LIKE ?', "%#{name.downcase}%"
    elsif foundation_year = params[:foundation_year]
      @enterprises = environment.enterprises.where 'data LIKE ?', "%foundation_year: #{foundation_year}%"
    elsif activation_code = params[:activation_code]
      task = Task.find_by_code activation_code
      @enterprises = [task.enterprise] rescue []
    elsif contact_person = params[:contact_person]
      @enterprises = environment.enterprises.where 'data LIKE ?', "%contact_person: %#{contact_person.downcase}%"
    elsif contact_email = params[:contact_email]
      @enterprises = environment.enterprises.where 'data LIKE ?', "%contact_email: %#{contact_email.downcase}%"
    end

    respond_to do |format|
      format.csv do
        csv = CSV.generate do |csv|
          @enterprises.map do |enterprise|
            csv << [
              enterprise.name, url_for(enterprise.url),
              (enterprise.activation_task.code rescue ''), enterprise.foundation_year,
              enterprise.contact_person, enterprise.contact_email
            ]
          end
        end
        render text: csv
      end
    end
  end

  protected

  # inherit routes from core skipping use_relative_controller!
  def url_for options
    options[:controller] = "/#{options[:controller]}" if options.is_a? Hash and options[:controller] and not options[:controller].to_s.starts_with? '/'
    super options
  end
  helper_method :url_for

end