<% module_namespacing do -%>
class <%= leospaced? ? (base_namespaces << controller_class_name).join('/').camelize : controller_class_name %>Controller < ApplicationController
  helper_method :sort_column, :sort_direction
  <%= "before_filter :authenticate_user!#{CRLF}" if authentication? -%>
  <%= "load_and_authorize_resource#{CRLF}" if authorization? -%>
  <%#= "before_filter :load_parents#{CRLF}" if nested? -%>
before_filter :load_before

  def load_before
    @remote = <%= options.remote? %>
  <% base_parent_resources.each do |parent| -%>
  @<%= parent %> = <%= parent.classify %>.find params[:<%= parent %>_id]
  <% end -%>
end

  # GET <%= route_url %>
  # GET <%= route_url %>.json
  def index
    @<%= singular_table_name %> = <%= orm_class.build(class_name) %>
    conditions_fields = []
    conditions_values = []

    <%- base_parent_resources.each do |parent| -%>
      <%- if attributes.map(&:name).include? parent -%>
    conditions_fields << "#{<%= class_name %>.table_name}.<%= parent %>_id = ?"
    conditions_values << @<%= parent %>.id
      <%- end -%>
    <%- end -%>

    if params[:<%= singular_table_name %>]
      <%- attributes.each do |attribute| -%>
      <%- attr_name = case attribute.type
                 when :references, :belongs_to then "#{attribute.name}_id"
                 else attribute.name
              end -%>
      <%- conditions_operator_sign = case attribute.type
        when :string, :text then "LIKE"
        else "="
      end -%>
      <%- conditions_operator_value = case attribute.type
         when :string, :text then "%"
         else ""
      end -%>
      <% unless nested? && (attribute.type == :references || attribute.type == :belongs_to) -%>

      if params[:<%= singular_table_name %>][:<%= attr_name %>] && params[:<%= singular_table_name %>][:<%= attr_name %>].length>0
        conditions_fields << "#{<%= class_name %>.table_name}.<%= attr_name %> <%= conditions_operator_sign %> ?"
        conditions_values << "<%= conditions_operator_value %>#{params[:<%= singular_table_name %>][:<%= attr_name %>]}<%= conditions_operator_value %>"
        @<%= singular_table_name %>.<%= attr_name %> = params[:<%= singular_table_name %>][:<%= attr_name %>]
      end
      <%- end -%>
      <%- end -%>

    end

    conditions = [conditions_fields.join(' and ')] + conditions_values

    request.format = :csv if params[:commit] == 'Csv'
    
    @<%= plural_table_name %> = case request.format
    when 'text/html', 'text/javascript'
      <%= class_name %>.where(conditions).order("#{sort_column} #{sort_direction}")<%= ".page(params[:page])" if pagination? %>
    else
      <%= class_name %>.where(conditions)
    end

    respond_to do |format|
      format.html # index.html.erb
      format.json { render <%= key_value :json, "@#{plural_table_name}" %> }
      format.csv do
        send_data(Utility::export(:collection => @<%= plural_table_name %>,
                  #:column => [:column_name ],
                  :i18n => true
                  ),
          :type => 'text/csv; charset=utf-8; header=present',
          :filename => "#{CONFIG[:application][:name]}_#{t('models.<%= plural_table_name %>')}_#{Time.now.strftime("%Y%m%d")}.csv")
      end
      format.js
    end
  end

  # GET <%= route_url %>/1
  # GET <%= route_url %>/1.json
  def show
    @<%= singular_table_name %> = <%= orm_class.find(class_name, "params[:id]") %>

    respond_to do |format|
      format.html # show.html.erb
      format.json { render <%= key_value :json, "@#{singular_table_name}" %> }
      format.js
    end
  end

  # GET <%= route_url %>/new
  # GET <%= route_url %>/new.json
  def new
    @<%= singular_table_name %> = <%= orm_class.build(class_name) %>
    <%- if nested? -%>
    @<%= singular_table_name %>.<%= last_parent %>_id = @<%= last_parent %>.id
    <%- end -%>

    respond_to do |format|
      format.html # new.html.erb
      format.json { render <%= key_value :json, "@#{singular_table_name}" %> }
    end
  end

  # GET <%= route_url %>/1/edit
  def edit
    @<%= singular_table_name %> = <%= orm_class.find(class_name, "params[:id]") %>
  end

  # POST <%= route_url %>
  # POST <%= route_url %>.json
  def create
    @<%= singular_table_name %> = <%= orm_class.build(class_name, "params[:#{singular_table_name}]") %>
    <%- if nested? -%>
    @<%= singular_table_name %>.<%= last_parent %>_id ||= @<%= last_parent %>.id
    <%- end -%>

    respond_to do |format|
      if @<%= orm_instance.save %>
        format.html { redirect_to <%= show_resource_path("@") %>, <%= key_value :notice, "I18n.t(:created, :model => I18n.t('models.#{singular_table_name}'))" %> }
        format.json { render <%= key_value :json, "@#{singular_table_name}" %>, <%= key_value :status, ':created' %>, <%= key_value :location, "@#{singular_table_name}" %> }
      else
        format.html { render <%= key_value :action, '"new"' %> }
        format.json { render <%= key_value :json, "@#{orm_instance.errors}" %>, <%= key_value :status, ':unprocessable_entity' %> }
      end
    end
  end

  # PUT <%= route_url %>/1
  # PUT <%= route_url %>/1.json
  def update
    @<%= singular_table_name %> = <%= orm_class.find(class_name, "params[:id]") %>

    respond_to do |format|
      if @<%= orm_instance.update_attributes("params[:#{singular_table_name}]") %>
        format.html { redirect_to <%= show_resource_path("@") %>, <%= key_value :notice, "I18n.t(:updated, :model => I18n.t('models.#{singular_table_name}'))" %> }
        format.json { head :ok }
      else
        format.html { render <%= key_value :action, '"edit"' %> }
        format.json { render <%= key_value :json, "@#{orm_instance.errors}" %>, <%= key_value :status, ':unprocessable_entity' %> }
      end
    end
  end

  # DELETE <%= route_url %>/1
  # DELETE <%= route_url %>/1.json
  def destroy
    @<%= singular_table_name %> = <%= orm_class.find(class_name, "params[:id]") %>
    @<%= orm_instance.destroy %>

    respond_to do |format|
      format.html { redirect_to <%= list_resources_path %> }
      format.json { head :ok }
      format.js
    end
  end

  private
    def sort_direction
      %w[asc desc].include?(params[:direction]) ?  params[:direction] : "asc"
    end
    def sort_column
      <%= class_name %>.column_names.include?(params[:sort]) ? params[:sort] : "#{<%= class_name %>.table_name}.id"
    end
end
<% end -%>