Class: WidgetList::List

Inherits:

Object

• Object
• WidgetList::List

Includes:

ActionView::Helpers::NumberHelper, ActionView::Helpers::SanitizeHelper

Defined in:

lib/widget_list.rb

Instance Attribute Summary

• #isAdministrating ⇒ Object

  Returns the value of attribute isAdministrating.

Class Method Summary

• .build_drill_down(*params) ⇒ Object
• .build_list(list_parms) ⇒ Object

  build_list controls a default AJAX/Export and full HTML return output in some cases you should copy and paste this logic for custom scenarios in your controller, but in most cases, this is okay.

• .build_search_button_click(list_parms) ⇒ Object
• .checkbox_helper(list_parms, primary_key) ⇒ Object

  checkbox_helper just builds the proper Hashes to setup a checkbox widget row it assumes you have a fake column called ” AS checkbox to fill in with the widget_check.

• .clear_check_box_session(name = '') ⇒ Object
• .concat_inner(primary) ⇒ Object
• .concat_outer(primary) ⇒ Object
• .concat_string(primary) ⇒ Object
• .determine_db_type(db_type) ⇒ Object
• .double_quote(primary) ⇒ Object
• .drill_down_back(list_name = '') ⇒ Object
• .get_db_type(primary = true) ⇒ Object
• .get_defaults ⇒ Object
• .get_filter_and_drilldown(listId) ⇒ Object
• .get_group_by_selection(list_parms) ⇒ Object
• .get_sequel(primary = true) ⇒ Object
• .group_by_max_each_field(list_parms, group_by_filter) ⇒ Object
• .init_config ⇒ Object
• .is_sequel(primary) ⇒ Object
• .load_widget_list_database_yml ⇒ Object
• .load_widget_list_yml ⇒ Object
• .mysql_to_mongo_predicate(predicate = '=', value = '', build_mongo_expression_hash = false) ⇒ Object
• .parse_inputs_for_mongo_predicates(active_record_model, field, predicate, value_original) ⇒ Object
• .where(list_parms, field, value, predicate = '=') ⇒ Object

Instance Method Summary

• #ajax_maintain_checks ⇒ Object
• #auto_column_name(name = '') ⇒ Object
• #build_column_button(column, j) ⇒ Object
• #build_column_input(column, row = '') ⇒ Object
• #build_column_link(column, j) ⇒ Object
• #build_headers ⇒ Object
• #build_pagination ⇒ Object
• #build_rows ⇒ Object
• #build_statement ⇒ Object
• #build_summary_row ⇒ Object
• #cast_col ⇒ Object
• #clear_search_session(all = false) ⇒ Object
• #clear_sort_get_vars ⇒ Object
• #clear_sql_session(all = false) ⇒ Object
• #connect ⇒ Object
• #generate_error_output(ex = '') ⇒ Object
• #generate_limits ⇒ Object
• #get_database ⇒ Object
• #get_db_type(primary = true) ⇒ Object
• #get_grouping_functions ⇒ Object
• #get_header_pieces ⇒ Object
• #get_header_px_value ⇒ Object
• #get_radius_value ⇒ Object
• #get_shadow_inset_value ⇒ Object
• #get_shadow_spread_value ⇒ Object
• #get_total_records ⇒ Object
• #get_view ⇒ Object
• #initialize(list = {}) ⇒ List constructor

  A new instance of List.

• #render(results = {}) ⇒ Object

  pass results of $DATABASE.final_results after running a _select query.

• #skip_column(fieldName) ⇒ Object
• #strip_aliases(name = '') ⇒ Object
• #tick_field ⇒ Object

Constructor Details

#initialize(list = {}) ⇒ List

Returns a new instance of List.

Parameters:

• list (Hash) (defaults to: {})

# File 'lib/widget_list.rb', line 1368

def initialize(list={})

  # Defaults for all configs
  # See https://github.com/davidrenne/widget_list/blob/master/README.md#feature-configurations

  @items        = WidgetList::List::get_defaults()

  if list.empty? || list == @items
    @isAdministrating = true
    return
  else
    @isAdministrating = false
  end

  @csv          = []
  @csv          << []
  @totalRowCount= 0
  @totalPages   = 0
  @fixHtmlLinksReplace = {}

  @sequence     = 1
  @totalRows    = 0
  @totalPage    = 0
  @listSortNext = 'ASC'
  @filter       = ''
  @listFilter   = ''
  @fieldList    = []
  @templateFill = {}
  @results      = {}
  @headerPieces = {}

  ac = ActionController::Base.new()

  #the main template and outer shell
  @items.deep_merge!({ 'template'                              => ac.render_to_string(:partial => 'widget_list/list_partials/outer_shell') })
  @items.deep_merge!({ 'row'                                   => ac.render_to_string(:partial => 'widget_list/list_partials/row') })
  @items.deep_merge!({ 'list_description'                      => ac.render_to_string(:partial => 'widget_list/list_partials/list_description') })
  @items.deep_merge!({ 'col'                                   => ac.render_to_string(:partial => 'widget_list/list_partials/col') })
  @items.deep_merge!({ 'templateSequence'                      => ac.render_to_string(:partial => 'widget_list/list_partials/sequence') })

  #Sorting
  #
  @items.deep_merge!({ 'templateSortColumn'                    => ac.render_to_string(:partial => 'widget_list/list_partials/sort_column') })
  @items.deep_merge!({ 'templateNoSortColumn'                  => ac.render_to_string(:partial => 'widget_list/list_partials/no_sort_column') })

  #Pagintion
  #
  @items.deep_merge!({ 'template_pagination_wrapper'           => ac.render_to_string(:partial => 'widget_list/list_partials/pagination_wrapper') })
  @items.deep_merge!({ 'template_pagination_next_active'       => ac.render_to_string(:partial => 'widget_list/list_partials/pagination_next_active') })
  @items.deep_merge!({ 'template_pagination_next_disabled'     => ac.render_to_string(:partial => 'widget_list/list_partials/pagination_next_disabled') })
  @items.deep_merge!({ 'template_pagination_previous_active'   => ac.render_to_string(:partial => 'widget_list/list_partials/pagination_previous_active') })
  @items.deep_merge!({ 'template_pagination_previous_disabled' => ac.render_to_string(:partial => 'widget_list/list_partials/pagination_previous_disabled') })
  @items.deep_merge!({ 'template_pagination_jump_active'       => ac.render_to_string(:partial => 'widget_list/list_partials/pagination_jump_active') })
  @items.deep_merge!({ 'template_pagination_jump_unactive'     => ac.render_to_string(:partial => 'widget_list/list_partials/pagination_jump_unactive') })

  if list['view'].class.name == 'ActiveRecord::Relation'
    tag_fields = '<!--FIELDS_PLAIN-->'
  else
    #In a case where someone passes a SQL query raw with Sequel, we need to support fieldFunction's like action buttons which wouldnt be in your query, so use FIELDS to build entire query
    tag_fields = '<!--FIELDS-->'
  end

  @items.deep_merge!({ 'statement' =>
                           {'select'=>
                                {'view' =>'SELECT ' + tag_fields + ' FROM <!--SOURCE--> <!--WHERE--> <!--GROUPBY--> <!--ORDERBY--> <!--LIMIT-->'}
                           }
                     })

  @items.deep_merge!({ 'statement' =>
                           {'count'=>
                                {'view' => 'SELECT count(1) total FROM <!--VIEW--> <!--WHERE--> <!--GROUPBY-->'}
                           }
                     })
  #inject site wide configs before list specific configs if a helper exists

  if defined?(WidgetListHelper) == 'constant' && WidgetListHelper::SiteDefaults.class == Class && WidgetListHelper::SiteDefaults.respond_to?('get_site_widget_list_defaults')
    @items = WidgetList::Widgets::populate_items(WidgetListHelper::SiteDefaults::get_site_widget_list_defaults() ,@items)
  end

  if defined?(WidgetListThemeHelper) == 'constant' && WidgetListThemeHelper::ThemeDefaults.class == Class && WidgetListThemeHelper::ThemeDefaults.respond_to?('get_theme_widget_list_defaults')
    @items = WidgetList::Widgets::populate_items(WidgetListThemeHelper::ThemeDefaults::get_theme_widget_list_defaults() ,@items)
  end

  @items = WidgetList::Widgets::populate_items(list,@items)

  # If ransack is used
  if @items['view'].class.name == 'ActiveRecord::Relation' && @items['ransackSearch'].class.name == 'Ransack::Search'
    @items['ransackSearch'].build_condition if @items['ransackSearch'].conditions.empty?

    if @items['listSearchForm'].empty?

      #
      # if no one passed a listSearchForm inject a default one to show the ransack form
      #
      fill = {
          '<!--BUTTON_SEARCH-->'       => WidgetList::Widgets::widget_button('Search', {'onclick' => WidgetList::List::build_search_button_click(@items), 'innerClass' => @items['defaultButtonClass'] }),
          '<!--BUTTON_CLOSE-->'        => "HideAdvancedSearch(this)"
      }
      @items['listSearchForm'] = WidgetList::Utils::fill( fill , ac.render_to_string(:partial => 'widget_list/ransack_widget_list_advanced_search') )

    end
  end

  # I have several different styles for borders, but using borders Everywhere will setup everything with one call
  if @items['bordersEverywhere?']
    @items['borderedColumns'] = @items['borderHeadFoot'] = @items['borderedRows'] = true
    @items['borderColumnStyle'] = @items['borderRowStyle'] = @items['headFootBorderStyle'] = @items['tableBorder'] = @items['borderEverywhere']
  end

  # current_db is a flag of the last known primary or secondary YML used or defaulted when running a list
  @current_db_selection = @items['database']

  if get_database.db_type == 'oracle'

    @items.deep_merge!({'statement' =>
                            {'count'=>
                                 {'view' =>
                                      '
                               SELECT count(1) total FROM <!--VIEW--> ' + ((@items['groupBy'].empty? && !@active_record_model) ? '<!--WHERE-->  <!--GROUPBY-->' : '' )
                                 }
                            }
                       })
    @items.deep_merge!({'statement' =>
                            {'select'=>
                                 {'view' =>
                                      'SELECT <!--FIELDS_PLAIN--> FROM ( SELECT a.*, DENSE_RANK() over (<!--ORDERBY-->) rn FROM ( SELECT ' + ( (!get_view().include?('(')) ? '<!--SOURCE-->' : get_view().strip.split(" ").last ) + '.* FROM <!--SOURCE--> ) a ' + ((@items['groupBy'].empty?) ? '<!--WHERE-->' : '') + ' <!--ORDERBY--> ) <!--LIMIT--> ' + ((!@active_record_model) ? '<!--GROUPBY-->' : '')
                                 }
                            }
                       })

  end


  if $_REQUEST.key?('searchClear')
    clear_search_session()
  end

  begin
    @isJumpingList = false

    #Ajax ListJump
    if ! $_REQUEST.empty?
      if $_REQUEST.key?('LIST_FILTER_ALL') && !$_REQUEST['LIST_FILTER_ALL'].empty?
        @items['LIST_FILTER_ALL']     = $_REQUEST['LIST_FILTER_ALL']
        @isJumpingList = true
      end

      if $_REQUEST.key?('LIST_COL_SORT') && !$_REQUEST['LIST_COL_SORT'].empty?
        @items['LIST_COL_SORT']     = $_REQUEST['LIST_COL_SORT']
        @isJumpingList = true
      end

      if $_REQUEST.key?('LIST_COL_SORT_ORDER') && !$_REQUEST['LIST_COL_SORT_ORDER'].empty?
        @items['LIST_COL_SORT_ORDER']     = $_REQUEST['LIST_COL_SORT_ORDER']
        @isJumpingList = true
      end

      if $_REQUEST.key?('LIST_SEQUENCE') && !$_REQUEST['LIST_SEQUENCE'].empty?
        @items['LIST_SEQUENCE']     = $_REQUEST['LIST_SEQUENCE'].to_i
        @isJumpingList = true
      end

      if $_REQUEST.key?('ROW_LIMIT') && !$_REQUEST['ROW_LIMIT'].empty?
        @items['ROW_LIMIT']     = $_REQUEST['ROW_LIMIT']
        @isJumpingList = true

        if @items['showPagination']
          $_SESSION['pageDisplayLimit']            = $_REQUEST['ROW_LIMIT']
          $_SESSION.deep_merge!({'ROW_LIMIT' => { @items['name'] => $_REQUEST['ROW_LIMIT']} })
        end

      end

      clear_sort_get_vars()

      if $_REQUEST.key?('list_action') && $_REQUEST['list_action'] == 'ajax_widgetlist_checks' && @items['storeSessionChecks']
        ajax_maintain_checks()
      end

    end

    @items['groupByClick'] = WidgetList::Utils::fill({'<!--NAME-->' => @items['name']}, @items['groupByClickDefault'] + @items['groupByClick'])

    begin
      if @items['searchClear'] || @items['searchClearAll']
        clear_search_session(@items.key?('searchClearAll'))
      end

      matchesCurrentList   = $_REQUEST.key?('BUTTON_VALUE') && $_REQUEST['BUTTON_VALUE'] == @items['buttonVal']
      isSearchRequest      = $_REQUEST.key?('search_filter') && $_REQUEST['search_filter'] != 'undefined'
      templateCustomSearch = !@items['templateFilter'].empty? # if you define templateFilter WidgetList will not attempt to build a where clause with search

      #
      # Search restore
      #
      if !isSearchRequest && !$_SESSION.empty? && $_SESSION.key?('SEARCH_FILTER') && $_SESSION['SEARCH_FILTER'].key?(@items['name']) && @items['searchSession']
        isSearchRestore = true
      end

      if (isSearchRequest && matchesCurrentList && !templateCustomSearch && @items['showSearch']) || isSearchRestore


        get_view() if $is_mongo # call function to fill in @active_record_model

        if !isSearchRestore
          $_SESSION.deep_merge!({'SEARCH_FILTER' => { @items['name'] => $_REQUEST['search_filter']} })
          searchFilter = $_REQUEST['search_filter'].strip_or_self()
        else
          searchFilter = $_SESSION['SEARCH_FILTER'][@items['name']]
        end

        if ! searchFilter.empty?
          if ! @items['filter'].empty? && @items['filter'].class.name != 'Array'
            # convert string to array filter
            filterString = @items['filter']
            @items['filter'] = [] unless $is_mongo
            @items['filter'] << filterString unless $is_mongo
          end

          fieldsToSearch = @items['fields'].dup

          if @items['fieldsHidden'].class.name == 'Array'
            @items['fieldsHidden'].each { |columnPivot|
              fieldsToSearch[columnPivot] = strip_aliases(columnPivot)
            }
          elsif @items['fieldsHidden'].class.name == 'Hash'
            @items['fieldsHidden'].each { |columnPivot|
              fieldsToSearch[columnPivot[0]] = strip_aliases(columnPivot[0])
            }
          end
          fieldsToSearch.delete('cnt') if fieldsToSearch.key?('cnt')
          searchCriteria = searchFilter.strip_or_self()
          searchSQL      = []
          numericSearch  = false

          #
          # Comma delimited search
          #
          if searchFilter.include?(',')
            #It is either a CSV or a comma inside the search string
            #
            criteriaTmp = searchFilter.split_it(',')

            #Assumed a CSV of numeric ids
            #
            isNumeric = true
            criteriaTmp.each_with_index { |value, key|
              if !value.empty?
                criteriaTmp[key] = value.strip_or_self()

                if !criteriaTmp[key].nil? &&  ! criteriaTmp[key].empty?
                  if ! WidgetList::Utils::numeric?(criteriaTmp[key])
                    isNumeric = false
                  end
                else
                  criteriaTmp.delete(key)
                end
              end
            }

            if isNumeric
              numericSearch = true
              if @items['searchIdCol'].class.name == 'Array'
                @items['searchIdCol'].each { |searchIdCol|
                  if(fieldsToSearch.key?(searchIdCol))
                    searchSQL << tick_field() + searchIdCol + tick_field() + " IN(" + searchFilter  + ")"

                    if $is_mongo
                      criteriaTmp.each_with_index { |value, key|

                        if !@items['groupBy'].empty?
                          @items['filter']   <<  searchIdCol
                          @items['predicate']<<  '='
                          @items['bindVars'] <<  value
                        end
                        @active_record_model = @active_record_model.where('$or' => [{searchIdCol=>value}]) if @items['groupBy'].empty?
                      }
                    end
                  end
                }

                if !searchSQL.empty?
                  #
                  # Assemble Numeric Filter
                  #
                  @items['filter'] << "(" + searchSQL.join(' OR ') + ")" unless $is_mongo
                end
              elsif @items['fields'].key?(@items['searchIdCol'])
                numericSearch = true
                @items['filter']  << tick_field() + "#{@items['searchIdCol']}" + tick_field() + " IN(" + criteriaTmp.join(',') + ")" unless $is_mongo

                if $is_mongo
                  criteriaTmp.each_with_index { |value, key|
                    if !@items['groupBy'].empty?
                      @items['filter']   <<  @items['searchIdCol']
                      @items['predicate']<<  '='
                      @items['bindVars'] <<  value
                    end
                    @active_record_model = @active_record_model.where('$or' => [{@items['searchIdCol']=>value}]) if @items['groupBy'].empty?
                  }
                end
              end
            end
          elsif @items['searchIdCol'].class.name == 'Array'
            if WidgetList::Utils::numeric?(searchFilter) && ! searchFilter.include?('.')
              numericSearch = true
              @items['searchIdCol'].each { |searchIdCol|
                if fieldsToSearch.key?(searchIdCol)
                  searchSQL << tick_field() + "#{searchIdCol}" + tick_field() + " IN(#{searchFilter})"

                  if $is_mongo

                    if !@items['groupBy'].empty?
                      @items['filter']   <<  searchIdCol
                      @items['predicate']<<  '='
                      @items['bindVars'] <<  searchFilter
                    end
                    @active_record_model = @active_record_model.where('$or' => [{searchIdCol=>searchFilter}]) if @items['groupBy'].empty?
                  end
                end
              }

              if !searchSQL.empty?
                #
                # Assemble Numeric Filter
                #
                @items['filter'] << "(" + searchSQL.join(' OR ') + ")" unless $is_mongo
              end
            end
          elsif WidgetList::Utils::numeric?(searchFilter) && ! searchFilter.include?('.') && @items['fields'].key?(@items['searchIdCol'])
            numericSearch = true
            @items['filter'] << tick_field() + "#{@items['searchIdCol']}" + tick_field() + " IN(" + searchFilter + ")" unless $is_mongo

            if $is_mongo

              if !@items['groupBy'].empty?
                @items['filter']   <<  @items['searchIdCol']
                @items['predicate']<<  '='
                @items['bindVars'] <<  searchFilter
              end
              @active_record_model = @active_record_model.where('$or' => [{@items['searchIdCol']=>searchFilter}]) if @items['groupBy'].empty?
            end
          end

          # If it is not an id or a list of ids then it is assumed a string search
          if !numericSearch

            fieldValues = {}

            fieldsToSearch.each { |fieldName,fieldTitle|

              fieldName = strip_aliases(fieldName)
              # new lodgette. if fieldFunction exists, find all matches and skip them

              if @items['fieldFunction'].key?(fieldName)
                if get_database.db_type == 'oracle'
                  theField = fieldName
                else
                  theField = @items['fieldFunction'][fieldName]  + cast_col()
                end
              else
                theField = tick_field() + "#{fieldName}" + cast_col() + tick_field()
              end

              skip = false
              skip = skip_column(fieldName)

              #buttons must ALWAYS BE ON THE RIGHT SIDE IN ORDER FOR THIS NOT TO SEARCH A NON-EXISTENT COLUMN  (used to be hard coded to 'features' as a column to remove)
              if skip
                next
              end

              #Search only specified fields. This can involve a dynamic field list from an advanced search form
              #
              if ! @items['searchFieldsIn'].empty?
                #
                # If it exists in either key or value
                #
                if ! @items['searchFieldsIn'].key?(fieldName) && ! @items['searchFieldsIn'].include?(fieldName)
                  next
                end
              elsif ! @items['searchFieldsOut'].empty?
                if @items['searchFieldsOut'].key?(fieldName) ||  @items['searchFieldsOut'].include?(fieldName)
                  next
                end
              end

              #todo - escape bind variables using Sequel
              searchSQL <<  theField + " LIKE '%" + searchCriteria + "%'"
              fieldValues[theField] = searchCriteria

              if $is_mongo

                if !@items['groupBy'].empty?
                  @items['filter']   <<  fieldName
                  @items['predicate']<<  '='
                  @items['bindVars'] <<  searchCriteria
                end

                if @items['groupBy'].empty? && (@active_record_model.respond_to?(:serializers) &&  ['DateTime','Time','Date'].include?(@active_record_model.serializers[fieldName].type.to_s)) == false
                  if searchCriteria.include?(',')
                    criteriaTmp = searchCriteria.split_it(',')
                    criteriaTmp.each_with_index { |value, key|
                      if !value.empty?
                        @active_record_model = @active_record_model.where('$or' => [{fieldName=>value.strip_or_self()}])
                      end
                    }
                  else
                    @active_record_model = @active_record_model.where('$or' => [{fieldName=>searchCriteria}])
                  end
                end

              end
            }

            #
            # Assemble String Filter
            #
            if(! searchSQL.empty?)
              @items['filter'] << "(" + searchSQL.join(' OR ') + ")" unless $is_mongo
            end
          end
        end
      end

    rescue Exception => e
      @templateFill['<!--DATA-->']  = '<tr><td colspan="50"><div id="noListResults">' + generate_error_output(e) + @items['noDataMessage'] + '</div></td></tr>'
    end

    if !$_REQUEST.key?('BUTTON_VALUE')

      #Initialize page load/Session stuff whe list first loads
      #
      WidgetList::List::clear_check_box_session(@items['name'])
    end


    if ! @items.key?('templateHeader')
      @items['templateHeader'] = ''
    end

    #Set a list title if it exists
    #

    if ! $_REQUEST.key?('BUTTON_VALUE') && !@items['title'].empty?
      @items['templateHeader'] = '
                                   <h1 style="font-size:' + get_header_px_value() + ';"><!--TITLE--></h1><div class="horizontal_rule"></div>
                                   <!--FILTER_HEADER-->
                                 '
    elsif !$_REQUEST.key?('BUTTON_VALUE')
      # Only if not in ajax would we want to output the filter header
      #
      @items['templateHeader'] = '<!--FILTER_HEADER-->'
    end

    # Build the filter (If any)
    #
    # todo - unit test filter
    if !@items['filter'].empty? && @items['filter'].class.name == 'Array'
      @filter = @items['filter'].join(' AND ')
    elsif !@items['filter'].empty? && @items['filter'].class.name == 'String'
      @filter = @items['filter']
    end

    #Sorting
    #

    if !@items['LIST_COL_SORT'].empty?
      @items['LIST_SEQUENCE'] = 1
    end

    if @items['LIST_SEQUENCE'].class.name == 'Fixnum' && @items['LIST_SEQUENCE'] > 0
      @sequence               = @items['LIST_SEQUENCE'].to_i
    end

    if ! @items['ROW_LIMIT'].empty?
      @items['rowLimit']      = @items['ROW_LIMIT'].to_i
    end

    if $_SESSION.key?('ROW_LIMIT') && !$_SESSION['ROW_LIMIT'].nil? && $_SESSION['ROW_LIMIT'].key?(@items['name']) && !$_SESSION['ROW_LIMIT'][@items['name']].empty?
      @items['rowLimit'] = $_SESSION['ROW_LIMIT'][@items['name']].to_i
    end

    if ! @items['LIST_COL_SORT'].empty?
      case @items['LIST_COL_SORT_ORDER']
        when 'ASC'
          @listSortNext = 'DESC'
        else
          @listSortNext = 'ASC'
      end
    end

    generate_limits()
  rescue Exception => e
    @templateFill['<!--DATA-->']  = '<tr><td colspan="50"><div id="noListResults">' + generate_error_output(e) + @items['noDataMessage'] + '</div></td></tr>'
  end
end

Instance Attribute Details

#isAdministrating ⇒ Object

Returns the value of attribute isAdministrating.

# File 'lib/widget_list.rb', line 1362

def isAdministrating
  @isAdministrating
end

Class Method Details

.build_drill_down(*params) ⇒ Object

# File 'lib/widget_list.rb', line 3390

def self.build_drill_down(*params)
  required_params = {
      :list_id                  => true,              # -- your widget_list name (used for JS)
      :drill_down_name          => true,              # -- an identifier that is pass for the "column" or "type of drill down" which is passed as $_REQUEST['drill_down'] when the user clicks and returned from get_filter_and_drilldown based on session or request
      :data_to_pass_from_view   => true,              # -- Any SQL function or column name/value in the resultset in which would be the value passed when the user clicks the drill down
      :column_to_show           => true,              # -- The visible column or SQL functions to display to user for the link
  }

  optional_params = {
      :column_alias             => '',                # -- AS XXXX
      :extra_function           => '',                # -- Onclick of link, call another JS function after the drill down function is called
      :js_function_name         => 'ListDrillDown',   # -- name of JS Function
      :column_class             => '',                # -- custom class on the <a> tag
      :link_color               => 'blue',            # -- whatever color you want the link to be
      :extra_js_func_params     => '',                # -- Add extra params to ListDrillDown outside of the default
      :primary_database         => true,              # -- Since this function builds a column before widget_list is instantiated, tell which connection you are using
  }

  valid = WidgetList::Widgets::validate_items(params[0],required_params)
  items = WidgetList::Widgets::populate_items(params[0],optional_params)

  if items[:column_alias].empty?
    items[:column_alias] = items[:column_to_show]
  end

  if !items[:column_class].empty?
    items[:column_class] = ' "' + WidgetList::List::concat_string(items[:primary_database]) + items[:column_class] + WidgetList::List::concat_string(items[:primary_database]) + '"'
  end

  if WidgetList::List.get_db_type(items[:primary_database]) == 'oracle'
    link = %[q'[<a style='cursor:pointer;color:#{items[:link_color]};' class='#{items[:column_alias]}_drill#{items[:column_class]}' onclick='#{items[:js_function_name]}("#{items[:drill_down_name]}", ListDrillDownGetRowValue(this) ,"#{items[:list_id]}"#{items[:extra_js_func_params]});#{items[:extra_function]}'>]' #{WidgetList::List::concat_string(items[:primary_database])}#{items[:column_to_show]}#{WidgetList::List::concat_string(items[:primary_database])}q'[</a><script class='val-db' type='text'>]' #{WidgetList::List::concat_string(items[:primary_database])} #{items[:data_to_pass_from_view]} #{WidgetList::List::concat_string(items[:primary_database])} q'[</script>]' #{WidgetList::List::concat_outer(items[:primary_database])} #{WidgetList::List::is_sequel(items[:primary_database]) ? " as #{items[:column_alias]} " : ""}]
  else
    if WidgetList::List.get_db_type(items[:primary_database]) == 'postgres'
      link = %['<a style="cursor:pointer;color:#{items[:link_color]};" class="#{items[:column_alias]}_drill#{items[:column_class]}" onclick="#{items[:js_function_name]}(''#{items[:drill_down_name]}'', ListDrillDownGetRowValue(this) ,''#{items[:list_id]}''#{items[:extra_js_func_params]});#{items[:extra_function]}">"' #{WidgetList::List::concat_string(items[:primary_database])}#{items[:column_to_show]}#{WidgetList::List::concat_string(items[:primary_database])}'</a><script class="val-db" type="text">' #{WidgetList::List::concat_string(items[:primary_database])} #{items[:data_to_pass_from_view]} #{WidgetList::List::concat_string(items[:primary_database])}'</script>' #{WidgetList::List::is_sequel(items[:primary_database]) ? " as #{items[:column_alias]} " : ""}]
    else
      link = %[#{WidgetList::List::concat_inner(items[:primary_database])}"<a style='cursor:pointer;color:#{items[:link_color]};' class='#{items[:column_alias]}_drill#{items[:column_class]}' onclick='#{items[:js_function_name]}(#{WidgetList::List::double_quote(items[:primary_database])}#{items[:drill_down_name]}#{WidgetList::List::double_quote(items[:primary_database])}, ListDrillDownGetRowValue(this) ,#{WidgetList::List::double_quote(items[:primary_database])}#{items[:list_id]}#{WidgetList::List::double_quote(items[:primary_database])}#{items[:extra_js_func_params]});#{items[:extra_function]}'>"#{WidgetList::List::concat_string(items[:primary_database])}#{items[:column_to_show]}#{WidgetList::List::concat_string(items[:primary_database])}"</a><script class='val-db' type='text'>"#{WidgetList::List::concat_string(items[:primary_database])} #{items[:data_to_pass_from_view]} #{WidgetList::List::concat_string(items[:primary_database])}"</script>"#{WidgetList::List::concat_outer(items[:primary_database])} #{WidgetList::List::is_sequel(items[:primary_database]) ? " as #{items[:column_alias]} " : ""}]
    end
  end

  if $_REQUEST.key?('export_widget_list')
    link = "#{items[:column_to_show]} #{WidgetList::List::is_sequel(items[:primary_database]) ? " as #{items[:column_alias]} " : ""}"
  end

  return link

end

.build_list(list_parms) ⇒ Object

build_list controls a default AJAX/Export and full HTML return output in some cases you should copy and paste this logic for custom scenarios in your controller, but in most cases, this is okay

# File 'lib/widget_list.rb', line 3214

def self.build_list(list_parms)

  list = WidgetList::List.new(list_parms)

  ret = {}
  #
  # If AJAX, send back JSON
  #
  if $_REQUEST.key?('BUTTON_VALUE') && $_REQUEST['LIST_NAME'] == list_parms['name']

    if $_REQUEST.key?('export_widget_list')
      return ['export',list.render()]
    end

    if $_REQUEST['list_action'] != 'ajax_widgetlist_checks'
      ret['list']           = list.render()
      ret['search_bar']     = list.get_header_pieces['searchBar']
      ret['group_by_items'] = list.get_header_pieces['groupByItems']
      ret['export_button']  = list.get_header_pieces['exportButton']
      ret['list_id']        = list_parms['name']
      ret['callback']       = 'ListSearchAheadResponse'
    end

    return ['json',WidgetList::Utils::json_encode(ret)]
  else
    #
    # Else assign to variable for view
    #
    if list.isAdministrating
      return list.render()
    else
      if $widget_list_conf.key?(:api_mode) && $widget_list_conf[:api_mode]
        ret['list']           = list.render()
        return ['json',WidgetList::Utils::json_encode(ret)]
      else
        return ['html', list.render() ]
      end
    end
  end

end

.build_search_button_click(list_parms) ⇒ Object

# File 'lib/widget_list.rb', line 2859

def self.build_search_button_click(list_parms)

  extra_get_vars  = ''
  extra_func       = ''
  filterParameters = {}
  if list_parms.key?('ajaxFunctionAll')
    extra_func = list_parms['ajaxFunctionAll']
  end

  if list_parms.key?('carryOverRequsts')
    list_parms['carryOverRequsts'].each { |value|
      if $_REQUEST.key?(value)
        filterParameters[value] = $_REQUEST[value]
      end
    }
    extra_get_vars = WidgetList::Utils::build_query_string(filterParameters)
  end

  "ListJumpMin(jQuery('##{list_parms['name']}_jump_url').val() + '&advanced_search=1&' + jQuery('#list_search_id_#{list_parms['name']}_results *').serialize() + '&#{extra_get_vars}', '#{list_parms['name']}');HideAdvancedSearch(this);" + extra_func
end

.checkbox_helper(list_parms, primary_key) ⇒ Object

checkbox_helper just builds the proper Hashes to setup a checkbox widget row it assumes you have a fake column called ” AS checkbox to fill in with the widget_check

# File 'lib/widget_list.rb', line 3309

def self.checkbox_helper(list_parms,primary_key)

  list_parms.deep_merge!({'inputs' =>
                              {'checkbox'=>
                                   {'type' => 'checkbox'
                                   }
                              }
                         })

  list_parms.deep_merge!({'inputs' =>
                              {'checkbox'=>
                                   {'items' =>
                                        {
                                            'name'          => list_parms['name'] + '_visible_checks[]',
                                            'value'         => primary_key, #the value should be a column name mapping
                                            'class_handle'  => list_parms['name'] + '_info_tables',
                                        }
                                   }
                              }
                         })

  list_parms.deep_merge!({'inputs' =>
                              {'checkbox_header'=>
                                   {'type' => 'checkbox'
                                   }
                              }
                         })

  list_parms.deep_merge!({'inputs' =>
                              {'checkbox_header'=>
                                   {'items' =>
                                        {
                                            'check_all'     => true,
                                            'id'            => list_parms['name'] + '_info_tables_check_all',
                                            'class_handle'  => list_parms['name'] + '_info_tables',
                                        }
                                   }
                              }
                         })
  return list_parms
end

.clear_check_box_session(name = '') ⇒ Object

# File 'lib/widget_list.rb', line 2212

def self.clear_check_box_session(name='')

  if $_SESSION.key?('DRILL_DOWN_FILTERS')
    $_SESSION.delete('DRILL_DOWN_FILTERS')
  end

  if $_SESSION.key?('DRILL_DOWNS')
    $_SESSION.delete('DRILL_DOWNS')
  end

  $_SESSION['list_checks'].keys.each { |key|
    if key.include?(name)
      $_SESSION['list_checks'].delete(key)
    end
  } if $_SESSION.key?('list_checks')  && !$_SESSION['list_checks'].nil? && !$_SESSION['list_checks'].empty?

end

.concat_inner(primary) ⇒ Object

# File 'lib/widget_list.rb', line 3469

def self.concat_inner(primary)
  case WidgetList::List.get_db_type(primary)
    when 'mysql'
      'CONCAT('
    else
      ''
  end
end

.concat_outer(primary) ⇒ Object

# File 'lib/widget_list.rb', line 3460

def self.concat_outer(primary)
  case WidgetList::List.get_db_type(primary)
    when 'mysql'
      ')'
    else
      ''
  end
end

.concat_string(primary) ⇒ Object

# File 'lib/widget_list.rb', line 3437

def self.concat_string(primary)

  case WidgetList::List.get_db_type(primary)
    when 'mysql'
      ' , '
    when 'oracle','sqlite','postgres'
      ' || '
    else
      ','
  end
end

.determine_db_type(db_type) ⇒ Object

# File 'lib/widget_list.rb', line 4456

def self.determine_db_type(db_type)
  if db_type.include?('://')
    the_type, void = db_type.split("://")
    if the_type == 'sqlite:/'
      the_type = 'sqlite'
    end
    return the_type.downcase
  else
    begin
      WidgetList::List::load_widget_list_database_yml()

      if $is_mongo
        return 'mongo'
      else
        if $widget_list_db_conf.key?(db_type)
          if $widget_list_db_conf[db_type]['adapter'].include?('mysql')
            return 'mysql'
          elsif $widget_list_db_conf[db_type]['adapter'].include?('postgres')
            return 'postgres'
          elsif $widget_list_db_conf[db_type]['adapter'].include?('oracle')
            return 'oracle'
          elsif $widget_list_db_conf[db_type]['adapter'].include?('sqlite')
            return 'sqlite'
          elsif $widget_list_db_conf[db_type]['adapter'].include?('sqlserver')
            return 'sqlserver'
          elsif $widget_list_db_conf[db_type]['adapter'].include?('ibm')
            return 'db2'
          end
        end
      end
    rescue
      return ''
    end

  end
end

.double_quote(primary) ⇒ Object

# File 'lib/widget_list.rb', line 3449

def self.double_quote(primary)
  case WidgetList::List.get_db_type(primary)
    when 'mysql'
      '\\"'
    when 'oracle','sqlite'
      '""'
    else
      '"'
  end
end

.drill_down_back(list_name = '') ⇒ Object

# File 'lib/widget_list.rb', line 3386

def self.drill_down_back(list_name='')
  '<div class="goback" onclick="ListHome(\'' + list_name + '\');" title="Go Back"></div>'
end

.get_db_type(primary = true) ⇒ Object

# File 'lib/widget_list.rb', line 4514

def self.get_db_type(primary=true)
  WidgetList::List::load_widget_list_yml()
  if primary
    database_conn = $widget_list_conf[:primary]
  else
    database_conn = $widget_list_conf[:secondary]
  end
  WidgetList::List::determine_db_type(database_conn)
end

.get_defaults ⇒ Object

# File 'lib/widget_list.rb', line 1916

def self.get_defaults()
  {
      'errors'              => [],
      'name'                => ([*('A'..'Z'),*('0'..'9')]-%w(0 1 I O)).sample(16).join,
      'database'            => 'primary', #
      'title'               => '',
      'listDescription'     => '',
      'pageId'              => $_SERVER['SCRIPT_NAME'] + $_SERVER['PATH_INFO'],
      'view'                => '',
      'data'                => {},
      'bindVars'            => [],
      'bindVarsLegacy'      => {},
      'links'               => {},
      'buttons'             => {},
      'inputs'              => {},
      'filter'              => [],
      'predicate'           => [],
      'groupBy'             => '',
      'rowStart'            => 0,
      'rowLimit'            => 10,
      'orderBy'             => '',
      'allowHTML'           => true,
      'showPagination'      => true,

      #
      # carryOverRequests will allow you to post custom things from request to all sort/paging URLS for each ajax
      #
      'carryOverRequsts'    => ['switch_grouping','group_row_id','q'],

      #
      # Head/Foot
      #

      'customFooter'        => '',
      'customHeader'        => '',

      #
      # Ajax
      #
      'ajaxFunctionAll'     => '',
      'ajaxFunction'        => 'ListJumpMin',

      #
      #  Search
      #
      'showSearch'          => true,
      'searchOnkeyup'       => "SearchWidgetList('<!--URL-->', '<!--TARGET-->', this);",
      'searchIdCol'         => ($is_mongo) ? '_id' : 'id',
      'searchTitle'         => 'Search by Id or CSV of Ids and more',
      'searchFieldsIn'      => {},
      'searchClear'         => false,
      'searchClearAll'      => false,
      'searchSession'       => true,
      'searchFieldsOut'     => {($is_mongo) ? '_id' : 'id'=>true},
      'templateFilter'      => '',

      #
      #  Export
      #
      'showExport'          => true,
      'exportButtonTitle'   => 'Export CSV',

      #
      # Group By Box
      #
      'groupByItems'        => [],
      'groupBySelected'     => false,
      'groupByLabel'        => 'Group By',
      'groupByClick'        => '',
      'groupByClickDefault' => "ListChangeGrouping('<!--NAME-->', this);",


      #
      # Advanced searching
      #
      'listSearchForm'      => '',
      'ransackSearch'       => false,

      #
      # Column Specific
      #
      'colClass'            => '',
      'colAlign'            => 'center',
      'fields'              => {},
      'fieldsHidden'        => [],
      'columnStyle'         => {},
      'columnClass'         => {},
      'columnPopupTitle'    => {},
      'columnSort'          => {},
      'columnWidth'         => {},
      'columnNoSort'        => {},

      #
      # Column Border (on right of each column)
      #
      'borderedColumns'     => false,
      'borderColumnStyle'   => '1px solid #CCCCCC',

      #
      # Row Border (on top of each row)
      #
      'borderedRows'        => true,
      'borderRowStyle'      => '1px solid #CCCCCC',

      #
      # Head/Foot border
      #
      'borderHeadFoot'      => false,
      'headFootBorderStyle' => '1px solid #CCCCCC',

      'bordersEverywhere?'  => false,
      'borderEverywhere'    => '1px solid #CCCCCC',

      #
      # Buttons
      #
      'defaultButtonClass'  => 'info',

      #
      # Font
      #
      'fontFamily'           => false,  #'"Times New Roman", Times, serif',
      'headerFooterFontSize' => '14px',
      'dataFontSize'         => '14px',
      'titleFontSize'        => '24px',

      #
      # Table Colors
      #
      'footerBGColor'       => '#ECECEC',
      'headerBGColor'       => '#ECECEC',
      'footerFontColor'     => '#494949',
      'headerFontColor'     => '#494949',
      'tableBorder'         => '1',
      'cornerRadius'        => 15,

      'useBoxShadow'        => true,
      'shadowInset'         => 10,
      'shadowSpread'        => 20,
      'shadowColor'         => '#888888',

      #
      # Row specifics
      #
      'rowClass'            => '',
      'rowFontColor'        => 'black',
      'rowColorByStatus'    => {},
      'rowStylesByStatus'   => {},
      'rowOffsets'          => ['#FFFFFF','#FFFFFF'],

      'class'               => 'listContainerPassive',
      'tableclass'          => 'tableBlowOutPreventer',
      'noDataMessage'       => 'Currently no data.',
      'useSort'             => true,
      'headerClass'         => {},
      'fieldFunction'       => {},
      'buttonVal'           => 'templateListJump',
      'linkFunction'        => 'ButtonLinkPost',
      'template'            => '',
      'LIST_COL_SORT_ORDER' => 'ASC',
      'LIST_COL_SORT'       => '',
      'LIST_FILTER_ALL'     => '',
      'ROW_LIMIT'           => '',
      'LIST_SEQUENCE'       => 1,
      'NEW_SEARCH'          => false,

      #
      # Checkbox
      #
      'checkedClass'        => 'widgetlist-checkbox',
      'checkedFlag'         => {},
      'storeSessionChecks'  => false,

      #
      # Summary Row
      #
      'totalRow'            => {},
      'totalRowFirstCol'    => '<strong>Total:</strong>',
      'totalRowMethod'      => {},
      'totalRowPrefix'      => {},
      'totalRowSuffix'      => {},
      'totalRowSeparator'   => '.',
      'totalRowDelimiter'   => ',',
      'totalRowDefault'     => 'N/A',

      #
      # Hooks
      #
      'columnHooks'         => {},
      'rowHooks'            => {}
  }
end

.get_filter_and_drilldown(listId) ⇒ Object

# File 'lib/widget_list.rb', line 2294

def self.get_filter_and_drilldown(listId)
  filter = ''
  drillDown = ''
  if !$_REQUEST.key?('BUTTON_VALUE')
    # Initialize page load/Session stuff whe list first loads
    #
    WidgetList::List::clear_check_box_session(listId)
  end

  if $_REQUEST.key?('drill_down') && !$_REQUEST.key?('searchClear')
    drillDown = $_REQUEST['drill_down']
    $_SESSION.deep_merge!({'DRILL_DOWNS' => { listId => drillDown} })
  elsif $_SESSION.key?('DRILL_DOWNS') && $_SESSION['DRILL_DOWNS'].key?(listId) && !$_REQUEST.key?('searchClear')
    drillDown = $_SESSION['DRILL_DOWNS'][listId]
  else
    drillDown = 'default'
  end

  if $_REQUEST.key?('filter') && !$_REQUEST.key?('searchClear')
    filter = $_REQUEST['filter']
    $_SESSION.deep_merge!({'DRILL_DOWN_FILTERS' => { listId => filter} })
  elsif $_SESSION.key?('DRILL_DOWN_FILTERS') && $_SESSION['DRILL_DOWN_FILTERS'].key?(listId) && !$_REQUEST.key?('searchClear')
    filter = $_SESSION['DRILL_DOWN_FILTERS'][listId]
  end
  return drillDown, filter
end

.get_group_by_selection(list_parms) ⇒ Object

# File 'lib/widget_list.rb', line 2321

def self.get_group_by_selection(list_parms)
  groupBy = ''

  if $_REQUEST.key?('switch_grouping')
    groupBy = $_REQUEST['switch_grouping']
    $_SESSION.deep_merge!({'CURRENT_GROUPING' => { list_parms['name'] => groupBy} })
  elsif $_SESSION.key?('CURRENT_GROUPING') && !$_SESSION['CURRENT_GROUPING'].nil? && $_SESSION['CURRENT_GROUPING'].key?(list_parms['name'])
    groupBy = $_SESSION['CURRENT_GROUPING'][list_parms['name']]
    list_parms['groupBySelected'] =  groupBy
  else
    groupBy = ''
  end

  return groupBy
end

.get_sequel(primary = true) ⇒ Object

# File 'lib/widget_list.rb', line 4654

def self.get_sequel(primary=true)
  WidgetList::List::load_widget_list_yml()
  if primary
    Sequel.connect($widget_list_conf[:primary])
  else
    Sequel.connect($widget_list_conf[:secondary])
  end
end

.group_by_max_each_field(list_parms, group_by_filter) ⇒ Object

# File 'lib/widget_list.rb', line 3352

def self.group_by_max_each_field(list_parms,group_by_filter)

  #
  # Oracle needs MAX on most fields when grouping in order to shy away from 'not a GROUP BY expression' errors
  #
  if group_by_filter != 'none'
    if list_parms.key?('fieldFunction') && !list_parms['fieldFunction'].empty?
      list_parms['fieldFunction'].each { |k, v|
        if !k.include?('_linked') && k != 'cnt'
          list_parms['fieldFunction'][k] = "MAX(#{v})"
        end
      }
    end

    if list_parms.key?('fieldsHidden') && !list_parms['fieldsHidden'].empty?
      list_parms['fieldsHidden'].each { |k|
        if (list_parms.key?('fieldFunction') && !list_parms['fieldFunction'].empty? && !list_parms['fieldFunction'].key?(k))  || list_parms['fieldFunction'].empty?
          list_parms['fieldFunction'][k] = "MAX(#{k})"
        end
      }
    end

    list_parms['fields'].each { |k|
      if !k.include?('_linked') && k != 'cnt'
        if (list_parms.key?('fieldFunction') && !list_parms['fieldFunction'].empty? && !list_parms['fieldFunction'].key?(k))  || list_parms['fieldFunction'].empty?
          list_parms['fieldFunction'][k] = "MAX(#{k})"
        end
      end
    }
  end

  return list_parms
end

.init_config ⇒ Object

# File 'lib/widget_list.rb', line 2109

def self.init_config()
  list_parms = {}
  WidgetList::List::get_defaults.each { |k,v|
    if (v.is_a?(Array) || v.is_a?(Hash)) && v.empty?
      list_parms[k] = v
    end
  }
  return list_parms
end

.is_sequel(primary) ⇒ Object

# File 'lib/widget_list.rb', line 4640

def self.is_sequel(primary)
  WidgetList::List::load_widget_list_yml()
  if primary
    database_conn = $widget_list_conf[:primary]
  else
    database_conn = $widget_list_conf[:secondary]
  end
  is_sequel = true
  if database_conn != false && ! database_conn.include?('://')
    is_sequel = false
  end
  return is_sequel
end

.load_widget_list_database_yml ⇒ Object

# File 'lib/widget_list.rb', line 4502

def self.load_widget_list_database_yml
  if $widget_list_db_conf.nil?
    if Rails.root.join("config", "mongoid.yml").file?
      $is_mongo            = true
      $widget_list_db_conf = YAML.load(ERB.new(File.new(Rails.root.join("config", "mongoid.yml")).read).result)
    else
      $is_mongo            = false
      $widget_list_db_conf = YAML.load(ERB.new(File.new(Rails.root.join("config", "database.yml")).read).result)
    end
  end
end

.load_widget_list_yml ⇒ Object

# File 'lib/widget_list.rb', line 4493

def self.load_widget_list_yml
  if $widget_list_conf.nil?
    $widget_list_conf = YAML.load(ERB.new(File.new(Rails.root.join("config", "widget-list.yml")).read).result)[Rails.env]
    if Rails.root.join("app/helpers", "widget_list_helper.rb").file?
      require Rails.root.join("app/helpers", "widget_list_helper.rb")
    end
  end
end

.mysql_to_mongo_predicate(predicate = '=', value = '', build_mongo_expression_hash = false) ⇒ Object

# File 'lib/widget_list.rb', line 4317

def self.mysql_to_mongo_predicate(predicate='=',value='',build_mongo_expression_hash=false)
  functioncall = ''
  case predicate
    when '>','gt'
      functioncall = 'gt'
    when 'in','in'
      functioncall = 'in'
    when '>=','gte'
      functioncall = 'gte'
    when '<','lt'
      functioncall = 'lt'
    when '<=','lte'
      functioncall = 'lte'
    when '!=','ne'
      functioncall = 'ne'
    else
      functioncall = ''
  end
  if build_mongo_expression_hash
    if functioncall.empty?
      #when using the aggregation framework in mongoid, you do not pass {$eq => 'val'}, you pass just the value associated with the column
      return value
    else
      return {'$' + functioncall => value}
    end
  else
    return functioncall
  end
end

.parse_inputs_for_mongo_predicates(active_record_model, field, predicate, value_original) ⇒ Object

# File 'lib/widget_list.rb', line 3257

def self.parse_inputs_for_mongo_predicates(active_record_model, field, predicate, value_original)
  if active_record_model.respond_to?(:serializers) &&  !active_record_model.serializers.key?(field)
    throw "field #{field} doesnt seem to exist in active record object here are the fields in the model class ==>>>> " + active_record_model.serializers.keys.inspect
  end
  is_int = (active_record_model.respond_to?(:serializers) &&  active_record_model.serializers[field].type.to_s == 'Integer')
  if predicate == '$in'
    #caste CSV string into proper array
    values = value_original.to_i if is_int
    values = value_original unless is_int
    if value_original.include?(',')
      #It is either a CSV or a comma inside the search string
      #
      values = []
      value_original.split_it(',').each { |val|
        values << val.to_i if is_int
        values << val.strip unless is_int
      }
    else
      values = [values]
    end

    return values
  else

    if value_original.class.name == 'Hash'
      the_value = value_original[value_original.keys.first]
    else
      the_value = value_original
    end

    if the_value.include?(',')
      values = []
      the_value.split_it(',').each { |val|
        values << val.strip
      }
      if value_original.class.name == 'Hash'
        final_value = {value_original.keys.first => values}
      else
        final_value = values
      end

    else
      final_value = value_original
    end

    return final_value
  end
end

.where(list_parms, field, value, predicate = '=') ⇒ Object

# File 'lib/widget_list.rb', line 4347

def self.where(list_parms,field,value,predicate='=')
  if $is_mongo
    list_parms['predicate'] <<  WidgetList::List.mysql_to_mongo_predicate(predicate,value,false)
  end
  list_parms['filter']    << field
  list_parms['bindVars']  << value
  return list_parms
end

Instance Method Details

#ajax_maintain_checks ⇒ Object

# File 'lib/widget_list.rb', line 2151

def ajax_maintain_checks()

  if !$_SESSION.key?('list_checks')
    $_SESSION['list_checks'] = {}
  end

  #
  # A list must be provided
  #
  if $_REQUEST.key?('LIST_NAME')
    listName  = $_REQUEST['LIST_NAME']
    sqlHash   = $_REQUEST['SQL_HASH']
    sequence  = $_REQUEST['LIST_SEQUENCE'].to_s

    #
    # The placeholder is created when the list initially forms. This validates it and makes it so
    # not just anything can be injected into the session via this method.
    #

    #
    # For each posted check box
    #

    $_REQUEST.each { |value, checked|
      if checked.to_s == '1'
        #
        # Set it as checked
        #
        $_SESSION.deep_merge!({'list_checks' => { listName + sqlHash + value => true  } })
      else
        #
        # Unset if it exists and is unchecked
        #
        if $_SESSION['list_checks'].key?(listName + sqlHash + value)
          $_SESSION['list_checks'].delete(listName + sqlHash + value)
        end
      end
    }

    #
    # Check All
    #
    if $_REQUEST.key?('checked_all') && $_REQUEST['checked_all'] == '1'
      if $_SESSION.key?('list_checks')

        if $_SESSION['list_checks'].key?('check_all_' + sqlHash + listName + sequence)
          if $_REQUEST['checked_all'].empty?
            $_SESSION['list_checks'].delete('check_all_' + sqlHash + listName + sequence)
          else
            $_SESSION.deep_merge!({'list_checks' => { 'check_all_' + sqlHash + listName + sequence => true } })
          end
        else
          if ! $_REQUEST['checked_all'].empty?
            $_SESSION.deep_merge!({'list_checks' => { 'check_all_' + sqlHash + listName +  $_REQUEST['LIST_SEQUENCE'] => true } })
          end
        end
      end
    end
  end
end

#auto_column_name(name = '') ⇒ Object

# File 'lib/widget_list.rb', line 4313

def auto_column_name(name='')
  name.gsub(/\_/,' ').gsub(/\-/,' ').capitalize
end

#build_column_button(column, j) ⇒ Object

# File 'lib/widget_list.rb', line 3478

def build_column_button(column,j)
  buttons     = @items['buttons'][column]
  btnOut      = []
  strCnt      = 0
  nameId      = ''

  buttons.each { |buttonId,buttonAttribs|
    function     = @items['linkFunction']
    parameters   = ''
    renderButton = true
    page         = ''
    if buttonAttribs.key?('page')
      page = buttonAttribs['page'].dup
    end
    if buttonAttribs.key?('tags')
      tags = buttonAttribs['tags'].dup
      all_wildcard = false
      if buttonAttribs['tags'].first[0] == 'all'
        all_wildcard = true
        tags = {}
        @results.keys.each { |tag|
          tags[tag.downcase] = tag.downcase
        }
      end

      tags.each { | tagName , tag |
        if @results.key?(tag.upcase) && @results[tag.upcase][j]
          #
          # Data exists, lets check to see if page has any lowercase tags for restful URLs
          #

          if buttonAttribs.key?('page') && buttonAttribs['page'].include?(tag.downcase)
            page.gsub!(tag.downcase,@results[tag.upcase][j])
          else
            #
            # Will build ?tagname=XXXX based on your hash passed to your page
            #
            buttonAttribs.deep_merge!({ 'args' => { tagName => @results[tag.upcase][j] } })
          end
        else

          #
          # User is passing hard coded tags such as 'tags'       => {'my_static_var' => '1234'}
          # Just fill in normally wherever anything is matched
          #
          if buttonAttribs.key?('page') && buttonAttribs['page'].include?(tag.downcase)
            page.gsub!(tagName,tag)
          else
            buttonAttribs.deep_merge!({ 'args' => { tagName => tag } })
          end
        end
      }
    end
    nameId = buttonId.to_s + '_' + j.to_s

    buttonAttribs['name'] = nameId
    buttonAttribs['id']   = nameId

    if buttonAttribs.key?('hide_if') && input['hide_if'].class.name == 'Proc'
      row_tmp = {}
      @results.map { |column| column }.each { |col|
        row_tmp[ col[0] ] = col[1][row]
      }
      if buttonAttribs['hide_if'].call(row_tmp)
        renderButton = false
      end
    end

    if (renderButton)
      strCnt += (buttonAttribs['text'].length * 15)
      attributes = buttonAttribs.dup
      attributes['page'] = page
      attributes['innerClass'] = @items['defaultButtonClass'] if !attributes.key?('innerClass')
      btnOut << WidgetList::Widgets::widget_button(buttonAttribs['text'], attributes , true)
    end
  }

  #BS width algorithm. HACK/TWEAK/OMG Get it working.
  #
  colWidth = ((strCnt + (btnOut.count * 35)) / 2) + 10

  width = ''
  center = ''

  if @items['colAlign'] == 'center'
    center = 'text-align:center;'
    width = 'width:' + colWidth.to_s + 'px'
  end

  return '<div style="border:0px solid black;white-space:nowrap;margin:auto;' + center + width + '"><div style="margin:auto;display:inline-block">' + btnOut.join('') + '</div></div>'
end

#build_column_input(column, row = '') ⇒ Object

Parameters:

• column (String) —

  (the name)

• row (Fixnum) (defaults to: '') —

  (the id or pointer in the loop to fetch the data)

# File 'lib/widget_list.rb', line 3091

def build_column_input(column, row='')
  content = ''

  inputManager = @items['inputs'][column]
  case inputManager['type']
    when "checkbox"


      input = {}
      input['name']         = 'widget_check_name'
      input['id']           = 'widget_check_id'
      input['check_all']    = false
      input['value']        = ''
      input['checked']      = ''
      input['onclick']      = ''
      input['input_class']  = 'widgetlist-checkbox-input'

      input['class_handle'] = ''

      input = WidgetList::Widgets::populate_items(inputManager['items'],input)

      onClick    = []
      checkAllId = ''

      #
      # Get a value. Assumes it is a column initially.
      #
      # @note headers are ignored and would fail as row would be null
      #
      if @results.key?(input['value'].upcase) && !@results[input['value'].upcase][row].to_s.empty?
        input['value'] = @results[ input['value'].upcase ][row]
      end

      if input.key?('disabled_if') && input['disabled_if'].class.name == 'Proc'
        row_tmp = {}
        @results.map { |column| column }.each { |col|
          row_tmp[ col[0] ] = col[1][row]
        }

        if input['disabled_if'].call(row_tmp)
          input['disabled'] = true
        end
      end

      #
      # Append class handle
      #
      input['input_class'] = "#{input['input_class']} #{input['class_handle']}"

      if input['check_all']
        checkAllId = input['id']
        if $_SESSION.key?('list_checks') && !$_SESSION['list_checks'].nil? && $_SESSION['list_checks'].key?('check_all_' + @sqlHash.to_s  + @items['name'].to_s + @sequence.to_s)
          input['checked'] = true
        end

        #
        # Set header class
        #
        if @items['headerClass'].class.name == 'Array' && @items['headerClass'].key?('checkbox')
          if $_SESSION['list_checks'].key?('check_all_' + @sqlHash.to_s  + @items['name'].to_s + @sequence.to_s)
            input['checked'] = true
          end
        end
      else
        input['input_class'] = "#{input['input_class']} #{input['class_handle']} #{input['class_handle']}_list"
      end

      #
      # Setup onclick action
      #
      if input['onclick'].empty?
        listJumpUrl = {}
        listJumpUrl['BUTTON_VALUE']        = @items['buttonVal']
        listJumpUrl['LIST_COL_SORT']       = @items['LIST_COL_SORT']
        listJumpUrl['LIST_COL_SORT_ORDER'] = @items['LIST_COL_SORT_ORDER']
        listJumpUrl['LIST_FILTER_ALL']     = @items['LIST_FILTER_ALL']
        listJumpUrl['ROW_LIMIT']           = @items['ROW_LIMIT']
        listJumpUrl['LIST_SEQUENCE']       = @sequence
        listJumpUrl['LIST_NAME']           = @items['name']
        listJumpUrl['SQL_HASH']            = @sqlHash
        listJumpUrl['list_action']         = 'ajax_widgetlist_checks'

        onClick << "AjaxMaintainChecks(this, '#{input['class_handle']}', '#{@items['name']}', '" + WidgetList::Utils::build_url(@items['pageId'],listJumpUrl,(!$_REQUEST.key?('BUTTON_VALUE'))) + "', '#{checkAllId}');"
      end

      input['onclick'] = onClick.join(' ')

      #
      # Checkbox is checked or not per query value
      #
      if ! @items['checkedFlag'].empty?
        if @items['checkedFlag'].key?(column)
          input['checked'] =  !!@results[ @items['checkedFlag'][column].upcase ][row]
        end
      end

      #
      # Checkbox is checked or not per session (overwrites query)
      #
      if $_SESSION.key?('list_checks') && !$_SESSION['list_checks'].nil? && $_SESSION['list_checks'].key?(@items['name'] + @sqlHash + input['value'].to_s)
        input['checked'] = true
      end

      content = WidgetList::Widgets::widget_check(input)

    #todo never implemented

    when "text"
      a=1
    #content = WidgetInput()

    when "select"
      a=1
    #content = WidgetSelect()

  end

  return content
end

#build_column_link(column, j) ⇒ Object

Parameters:

• column (String)

# File 'lib/widget_list.rb', line 3571

def build_column_link(column,j)

  links      = @items['links'][column].dup
  if links.key?('page')
    page      = links['page'].dup
  end
  url        = {'PAGE_ID' => @items['pageId']}
  function   = @items['linkFunction']
  parameters = []

  if links.key?('tags')
    tags = links['tags'].dup
    all_wildcard = false
    if links['tags'].first[0] == 'all'
      all_wildcard = true
      tags = {}
      @results.keys.each { |tag|
        tags[tag.downcase] = tag.downcase
      }
    end

    tags.each { | tagName, tag |

      if links.key?('page') && links['page'].include?(tag.downcase) && @results.key?(tag.upcase)
        page.gsub!(tag.downcase,@results[tag.upcase][j])
      else
        if @results[tag.upcase][j]
          url[tagName] = @results[tag.upcase][j]
        else
          url[tagName] = tag
        end
      end
    }
  end

  if links.key?('onclick')
    function = links['onclick']

    if links.key?('tags')
      tags.each { | tagName, tag |
        if @results.key?(tag.upcase)
          parameters << "'" + @results[tag.upcase][j].gsub(/'/,"\\\\'") + "'"
        end
      }
    end
  end

  if links.key?('page')
    linkUrl = page
    return "#{function}('#{linkUrl}')"
  else
    url['SQL_HASH']      = @sqlHash
    linkUrl = WidgetList::Utils::build_url(@items['pageId'], url, (!$_REQUEST.key?('BUTTON_VALUE')))
    if !parameters.empty?
      return "#{function}(#{parameters.join(',')})"
    else
      return "#{function}('#{linkUrl}')"
    end
  end
end

#build_headers ⇒ Object

# File 'lib/widget_list.rb', line 2880

def build_headers()
  headers = []

  ii = 0
  @items['fields'].each { |field, fieldTitle|
    colWidthStyle = '';
    colClass      = '';
    popupTitle    = '';
    templateIdx   = 'templateNoSortColumn'

    #Column class
    #
    if ! @items['headerClass'].empty?
      if @items['headerClass'].key?(field.downcase)
        colClass = @items['headerClass'][field.downcase]
      end
    end

    #Column width
    #
    if ! @items['columnWidth'].empty?
      if @items['columnWidth'].key?(field.downcase)
        colWidthStyle = "width:" + @items['columnWidth'][field.downcase] + ";"
      end
    end

    if @items['borderedColumns']
      colWidthStyle += 'border-right: ' + @items['borderColumnStyle'] + ';'
    end

    colWidthStyle +=  @items['borderHeadFoot'] ? 'border-bottom:' + @items['headFootBorderStyle'] + ';' : ''

    $_SESSION.deep_merge!({'LIST_SEQUENCE' => { @sqlHash => @sequence} })

    #Hover Title
    #
    if @items['columnPopupTitle'].key?(field.downcase)
      popupTitle = @items['columnPopupTitle'][field.downcase]
    end


    #
    # Column is an input
    #
    if @items['inputs'].key?(fieldTitle) && @items['inputs'][fieldTitle].class.name == 'Hash'
      #
      # Default checkbox hover to "Select All"
      #
      # Do specific input type functions
      #
      case @items['inputs'][fieldTitle]['type']
        when 'checkbox'

          if popupTitle.empty? && @items['inputs'][fieldTitle]['items']['check_all']
            popupTitle = 'Select All'
          end

          #
          # No sort on this column
          #
          if ! @items['columnNoSort'].key?(fieldTitle)
            @items['columnNoSort'][field] =  field
          end

          if colClass.empty?
            @items['headerClass'] = { fieldTitle => 'widgetlist-checkbox-header'}
            colClass = @items['headerClass'][fieldTitle]
          end
      end

      #
      # Build the input
      #
      fieldTitle = build_column_input(fieldTitle)

    else

      if $_REQUEST.key?('export_widget_list') && !skip_column(field)
        @csv[0] << fieldTitle
      end

    end

    #Add in radius
    if ii == @items['fields'].length - 1 && @items['listDescription'] == ''
      colWidthStyle += '-moz-border-radius-topright:' + get_radius_value() + ';-webkit-border-top-right-radius:' + get_radius_value() + ';border-top-right-radius:' + get_radius_value() + ';'
    end

    if ii == 0 && @items['listDescription'] == ''
      colWidthStyle += '-moz-border-radius-topleft:' + get_radius_value() + ';-webkit-border-top-left-radius:' + get_radius_value() + ';border-top-left-radius:' + get_radius_value() + ';'
    end

    if (@items['useSort'] && (@items['columnSort'].include?(field) || (@items['columnSort'].key?(field)) && !@items['columnNoSort'].include?(field)) || (@items['columnSort'].empty? && !@items['columnNoSort'].include?(field)))

      templateIdx = 'templateSortColumn'
      colSort = {}

      #Assign the column to be sorted
      #
      if !@items['columnSort'].empty? && @items['columnSort'].key?(field)
        colSort['LIST_COL_SORT'] = @items['columnSort'][field]
      elsif (!@items['columnSort'].empty? && @items['columnSort'].include?(field)) || @items['columnSort'].empty?
        colSort['LIST_COL_SORT'] = field
      end

      colSort['PAGE_ID']             = @items['pageId']
      colSort['LIST_NAME']           = @items['name']
      colSort['BUTTON_VALUE']        = @items['buttonVal']
      colSort['LIST_COL_SORT_ORDER'] = @listSortNext
      colSort['LIST_FILTER_ALL']     = @items['LIST_FILTER_ALL']
      colSort['ROW_LIMIT']           = @items['ROW_LIMIT']
      colSort['LIST_SEQUENCE']       = @sequence

      icon = ""

      if (
      ( (@items.key?('LIST_COL_SORT') && !@items['LIST_COL_SORT'].empty?) && @items['LIST_COL_SORT'] == colSort['LIST_COL_SORT']) ||
          ( $_SESSION.key?('LIST_COL_SORT') && !$_SESSION['LIST_COL_SORT'].nil? && $_SESSION['LIST_COL_SORT'].key?(@sqlHash) && $_SESSION['LIST_COL_SORT'][@sqlHash].key?(field))
      )
        changedSession = false
        if @items.key?('LIST_COL_SORT') && !@items['LIST_COL_SORT'].empty?
          changedSession = ( $_SESSION.key?('LIST_COL_SORT') && $_SESSION['LIST_COL_SORT'].key?(@sqlHash) && ! $_SESSION['LIST_COL_SORT'][@sqlHash].key?(@items['LIST_COL_SORT']) )
          if $_SESSION.key?('LIST_COL_SORT') && $_SESSION['LIST_COL_SORT'].key?(@sqlHash)
            $_SESSION['LIST_COL_SORT'].delete(@sqlHash)
          end
          $_SESSION.deep_merge!({'LIST_COL_SORT' => { @sqlHash => {@items['LIST_COL_SORT']=> @items['LIST_COL_SORT_ORDER']  } } })
        end

        if !changedSession && @items.key?('LIST_COL_SORT') && ! @items['LIST_COL_SORT'].empty?
          if @items['LIST_COL_SORT_ORDER'] == 'DESC'
            icon = "&uarr;"
          else
            icon = "&darr;"
          end
        elsif !changedSession && $_SESSION['LIST_COL_SORT'].class.name == 'Hash' && $_SESSION['LIST_COL_SORT'].key?(@sqlHash)
          #load sort from session
          $_SESSION['LIST_COL_SORT'][@sqlHash].each_with_index { |order,void|
            if order[1] == 'DESC'
              colSort['LIST_COL_SORT_ORDER'] = "ASC"
              icon = "&uarr;"
            else
              colSort['LIST_COL_SORT_ORDER'] = "DESC"
              icon = "&darr;"
            end
          }
        end
      end

      #Carry over any search criteria on a sort to SORT URL
      #
      if $_REQUEST.key?('search_filter') && ! $_REQUEST['search_filter'].empty?
        if $_REQUEST['search_filter'].empty?
          colSort['search_filter'] = $_REQUEST['search_filter']
        end
      end

      @items['carryOverRequsts'].each { |value|
        if $_REQUEST.key?(value)
          colSort[value] = $_REQUEST[value]
        end
      }

      colSort['SQL_HASH'] = @sqlHash

      pieces = {      '<!--COLSORTURL-->'       => WidgetList::Utils::build_url(@items['pageId'],colSort,(!$_REQUEST.key?('BUTTON_VALUE'))),
                      '<!--NAME-->'             => @items['name'],
                      '<!--COLSORTICON->'       => icon,
                      '<!--COL_HEADER_ID-->'    => strip_tags(field).gsub(/\s/,'_'),
                      '<!--INLINE_STYLE-->'     => colWidthStyle,
                      '<!--TITLE_POPUP-->'      => popupTitle,
                      '<!--ALIGN-->'            => @items['colAlign'],
                      '<!--COL_HEADER_CLASS-->' => colClass,
                      '<!--TITLE-->'            => fieldTitle,
                      '<!--FUNCTION-->'         => @items['ajaxFunction'],
                      '<!--FUNCTION_ALL-->'     => @items['ajaxFunctionAll'],
      }
      headers << WidgetList::Utils::fill(pieces, @items[templateIdx])
    else
      pieces = {      '<!--TITLE-->'            => fieldTitle,
                      '<!--INLINE_STYLE-->'     => colWidthStyle,
                      '<!--ALIGN-->'            => @items['colAlign'],
                      '<!--TITLE_POPUP-->'      => popupTitle,
                      '<!--COL_HEADER_CLASS-->' => colClass,
                      '<!--COL_HEADER_ID-->'    => strip_tags(field).gsub(/\s/,'_')
      }

      headers << WidgetList::Utils::fill(pieces, @items[templateIdx])
    end

    ii = ii + 1
  }

  @templateFill['<!--COLSPAN_FULL-->'] = headers.count()

  @templateFill['<!--PAGINATION_LIST-->'] = build_pagination()
  @templateFill['<!--HEADERS-->']         = headers.join('')

  if ! @items['listDescription'].empty?
    fillDesc = {}
    fillDesc['<!--COLSPAN-->']          = headers.count()
    fillDesc['<!--LIST_DESCRIPTION-->'] = @items['listDescription']
    fillDesc['<!--LIST_NAME-->']        = @items['name']
    @templateFill['<!--LIST_TITLE-->']  = WidgetList::Utils::fill(fillDesc,@items['list_description'])
  else
    @templateFill['<!--LIST_TITLE-->'] = ''
  end

end

#build_pagination ⇒ Object

# File 'lib/widget_list.rb', line 2656

def build_pagination()
  pageRange = 3
  pageNext  = 1
  pagePrev  = 1
  showPrev  = false
  showNext  = true
  prevUrl   = ''
  nextUrl   = ''
  tags      = ''
  urlTags   = {}
  templates = {}

  urlTags['SQL_HASH']        = @sqlHash
  urlTags['PAGE_ID']         = @items['pageId']
  urlTags['LIST_NAME']       = @items['name']
  urlTags['BUTTON_VALUE']    = @items['buttonVal']
  urlTags['LIST_FILTER_ALL'] = @items['LIST_FILTER_ALL']

  templates['btn_previous']  = @items['template_pagination_previous_disabled']
  templates['btn_next']      = @items['template_pagination_next_active']

  if $_REQUEST.key?('search_filter') && ! $_REQUEST['search_filter'].empty?
    urlTags['search_filter'] = $_REQUEST['search_filter']
  end

  if @items['LIST_COL_SORT'].empty?
    urlTags['LIST_COL_SORT']       = @items['LIST_COL_SORT']
    urlTags['LIST_COL_SORT_ORDER'] = @items['LIST_COL_SORT_ORDER']
    urlTags['ROW_LIMIT']           = @items['ROW_LIMIT']
  end

  if @items['links'].key?('paginate') && @items['links']['paginate'].class.name == 'Hash'
    @items['links']['paginate'].each { |tagName, tag|
      urlTags[tagName] = tag
    }
  end

  @items['carryOverRequsts'].each { |value|
    if $_REQUEST.key?(value)
      urlTags[value] = $_REQUEST[value]
    end
  }
  if (@sequence == @totalPages || ! (@totalPages > 0))
    showNext = false
  else
    urlTags['LIST_SEQUENCE'] = @sequence + 1
    nextUrl = WidgetList::Utils::build_url(@items['pageId'],urlTags,(!$_REQUEST.key?('BUTTON_VALUE')))
  end

  if @sequence > 1
    pagePrev = @sequence - 1
    urlTags['LIST_SEQUENCE'] = pagePrev
    prevUrl = WidgetList::Utils::build_url(@items['pageId'],urlTags,(!$_REQUEST.key?('BUTTON_VALUE')))
    showPrev = true
  end

  if !showNext
    templates['btn_next'] = @items['template_pagination_next_disabled']
  end

  if showPrev
    templates['btn_previous'] = @items['template_pagination_previous_active']
  end

  #Assemble navigation buttons
  #
  pieces = {
      '<!--NEXT_URL-->'     => nextUrl,
      '<!--LIST_NAME-->'    => @items['name'],
      '<!--PREVIOUS_URL-->' => prevUrl,
      '<!--FUNCTION-->'     => @items['ajaxFunction'],
      '<!--FUNCTION_ALL-->' => @items['ajaxFunctionAll'],
  }

  templates['btn_next']     = WidgetList::Utils::fill(pieces,templates['btn_next'])
  templates['btn_previous'] = WidgetList::Utils::fill(pieces,templates['btn_previous'])

  #
  # Sequence Range Drop Down
  #
  # Show x per page
  #
  urlTags['LIST_SEQUENCE'] = @sequence
  urlTags['ROW_LIMIT']     = 10

  @items['carryOverRequsts'].each { |value|
    if $_REQUEST.key?(value)
      urlTags[value] = $_REQUEST[value]
    end
  }

  # Automate select box and rules
  #
  rowLimitSelect        = [10,20,50,100,500,1000]
  rowLimitSelectData    = {}
  rowLimitSelectConfigs = {}

  #Set a default of 10
  #
  urlTags['ROW_LIMIT'] = 10
  options = ''
  rowLimitSelect.each_with_index { |jumpCount, key|
    if (@totalRows >= jumpCount || @totalRows > rowLimitSelect[key-1])
      urlTags['ROW_LIMIT'] = jumpCount

      rowLimitUrl = WidgetList::Utils::build_url(@items['pageId'],urlTags,(!$_REQUEST.key?('BUTTON_VALUE')))
      selected = ''
      if (@items['rowLimit'] == jumpCount)
        selected = 'selected'
      end
      options += "<option value='#{rowLimitUrl}' #{selected}>#{jumpCount}</option> "
    end
  }

  # WidgetSelect( todo)
  pageSelect = <<-EOD
    <select id="<!--LIST_NAME-->_per_page" onchange="#{@items['ajaxFunction']}(this.value,'#{@items['name']}');#{@items['ajaxFunctionAll']}" style="width:58px">
      #{options}
    </select>
  EOD

  #Ensure the range does not exceed the actual number of pages
  #
  if @totalPages < pageRange
    pageRange = @totalPages
  end

  ###
  # Create a range of x or less numbers.
  #
  # Take 2 off and add 2 or as much as possible either way
  ###
  startingPoint  = @sequence
  vkill          = pageRange

  while vkill > 0 do
    vkill = vkill - 1
    if startingPoint <= 1
      break
    else
      startingPoint = startingPoint-1
    end
  end

  endPoint       = @sequence
  vkill          = pageRange

  while vkill > 0 do
    vkill = vkill - 1
    if endPoint <= 1
      endPoint = endPoint+1
    else
      break
    end
  end

  jumpSection = []

  #Builds jump section    previous 4 5 6 7 next
  #
  for page in startingPoint..endPoint
    urlTags['LIST_SEQUENCE'] = page
    urlTags['SQL_HASH']      = @sqlHash
    jumpTemplate = ''
    jumpUrl = ''
    jumpUrl = WidgetList::Utils::build_url(@items['pageId'], urlTags, (!$_REQUEST.key?('BUTTON_VALUE')))

    if page == @sequence
      jumpTemplate = @items['template_pagination_jump_active']
    else
      jumpTemplate = @items['template_pagination_jump_unactive']
    end

    jumpSection << WidgetList::Utils::fill({
                                               '<!--SEQUENCE-->'     => page,
                                               '<!--JUMP_URL-->'     => jumpUrl,
                                               '<!--LIST_NAME-->'    => @items['name'],
                                               '<!--FUNCTION-->'     => @items['ajaxFunction'],
                                               '<!--FUNCTION_ALL-->' => @items['ajaxFunctionAll'],
                                           }, jumpTemplate)
  end

  pieces = {
      '<!--PREVIOUS_BUTTON-->'         => templates['btn_previous'],
      '<!--SEQUENCE-->'                => @sequence,
      '<!--NEXT_BUTTON-->'             => templates['btn_next'],
      '<!--TOTAL_PAGES-->'             => @totalPages,
      '<!--TOTAL_ROWS-->'              => @totalRows,
      '<!--PAGE_SEQUENCE_JUMP_LIST-->' => pageSelect,
      '<!--JUMP-->'                    => jumpSection.join(''),
      '<!--LIST_NAME-->'               => @items['name'],
  }

  paginationOutput = WidgetList::Utils::fill(pieces,@items['template_pagination_wrapper'])

  if (@items['showPagination'])
    return paginationOutput
  else
    return ''
  end

end

#build_rows ⇒ Object

# File 'lib/widget_list.rb', line 3632

def build_rows()
  sql = build_statement()
  if @totalResultCount > 0
    if @items['data'].empty?
      #Run the actual statement
      #

      #code flow forces me to merge the sort array here
      if !@group_match.nil?
        @group_match = @group_match.merge({"sort"  =>  { "$sort"  =>  @mongo_sort  } }) if !@mongo_sort.empty?
        @group_match = @group_match.merge({"skip"  =>  { "$skip"  =>  @mongo_skip  } })
        @group_match = @group_match.merge({"limit" =>  { "$limit" =>  @mongo_limit } })
        @group_match = @group_match.merge({"match" =>   @mongo_match })
      end

      @totalRowCount = get_database._select(sql , @items['bindVars'], @items['bindVarsLegacy'], @active_record_model, @group_match)
    end

    if @totalRowCount > 0
      if @items['data'].empty?
        @results = get_database.final_results
      else
        @results = @items['data']
      end

      #Build each row
      #
      max  = @totalRowCount-1
      rows = []
      j    = 0
      for j in j..max
        columns        = []
        row_values     = []
        customRowColor = ''
        customRowStyle = ''

        #
        # For each column (field) in this row
        #

        changedFontColor = false

        @items['fields'].each { |column , fieldTitle|
          column = strip_aliases(column)

          colPieces        = {}
          colClasses       = []
          theStyle         = ''
          colData          = ''
          colClass         = ''
          onClick          = ''
          colWidthStyle    = ''
          content          = ''
          contentTitle     = ''



          #todo unit test build_column_link

          #
          # Column is a Link
          #
          if @items['links'].key?(column) && @items['links'][column].class.name == 'Hash'
            onClick = build_column_link(column,j)
          end

          #
          # Column is a Button
          #
          if @items['buttons'].key?(column) && @items['buttons'][column].class.name == 'Hash'
            content = build_column_button(column, j)


            #
            # Column is an input
            #
          elsif @items['inputs'].key?(column) && @items['inputs'][column].class.name == 'Hash'
            colClasses << @items['checkedClass']
            content     = build_column_input(column, j)


            #
            # Column is text
            #
          else

            unless @results.key?(column.upcase)
              throw "Are you sure that the column #{column} exists in your fields array?  The resultset does not have this field returned from the database"
            end

            cleanData = strip_tags(@results[column.upcase][j].to_s)

            row_values << cleanData

            #
            # For now disable length parser
            #
            if false && cleanData.length > @items['strlength']
              content = @results[column.upcase][j].to_s[ 0, @items['strlength'] ] + '...'
            else
              content = @results[column.upcase][j].to_s
            end

            #
            #Strip HTML
            #
            if !@items['allowHTML']
              content = strip_tags(content)
            end

            content = get_database._bind(content, @items['bindVarsLegacy'])

            # Column color
            #
            if ! @items['columnStyle'].empty?
              if @items['columnStyle'].key?(column.downcase)
                colHeader  = @items['columnStyle'][column.downcase]

                if @results.key?(colHeader.upcase)
                  theStyle = @results[colHeader.upcase][j]
                else
                  theStyle = colHeader
                end

              end
            end

            # Column width
            #
            if ! @items['columnWidth'].empty?
              if @items['columnWidth'].key?(column.downcase)
                colWidthStyle = "width:" + @items['columnWidth'][column.downcase] + ";"
              end
            end

            # Column Class
            #
            if !@items['columnClass'].empty?
              if @items['columnClass'].key?(column.downcase)
                colClasses << @items['columnClass'][column.downcase]
              end
            end

          end


          #
          # Setup any column classes
          #
          colClasses << @items['colClass']
          colClass = colClasses.join(' ')

          #
          # Row Color
          #
          if !@items['rowColorByStatus'].empty? && @items['rowColorByStatus'].key?(column) &&  !@items['rowColorByStatus'][column].empty?
            @items['rowColorByStatus'][column].each { |status,color|
              if status === content
                customRowColor = color
              end
            }
          end

          #
          # Row Style
          #
          if !@items['rowStylesByStatus'].empty? && @items['rowStylesByStatus'].key?(column) &&  !@items['rowStylesByStatus'][column].empty?
            @items['rowStylesByStatus'][column].each { |status,inlineStyle|
              if status === content
                customRowStyle = inlineStyle
                if inlineStyle.include?('color:') || inlineStyle.include?('color :')
                  changedFontColor = true
                end
              end
            }
          end

          #
          # Set up Column Pieces
          #
          colPieces['<!--CLASS-->']   = colClass
          colPieces['<!--ALIGN-->']   = @items['colAlign']
          colPieces['<!--STYLE-->']   = colWidthStyle

          if @items['borderedColumns']
            colPieces['<!--STYLE-->'] += 'border-right: ' + @items['borderColumnStyle'] + ';'
          end

          if @items['borderedRows']
            colPieces['<!--STYLE-->'] += 'border-top: ' + @items['borderRowStyle'] + ';'
          end

          colPieces['<!--ONCLICK-->'] = onClick

          if !onClick.empty?
            colPieces['<!--SPAN_STYLE-->'] = 'cursor:pointer;' + theStyle
          else
            colPieces['<!--SPAN_STYLE-->'] = '' + theStyle
          end

          colPieces['<!--TITLE-->']   = contentTitle #todo htmlentities needed ?
          colPieces['<!--CONTENT-->'] = content

          #
          # Assemble the Column
          #
          columns << WidgetList::Utils::fill(colPieces, @items['col'])
        }


        if $_REQUEST.key?('export_widget_list')
          @csv << row_values
        end

        #Draw the row
        #

        pieces = {'<!--CONTENT-->' => columns.join('') }
        if @items['rowColorByStatus'].empty? &&  @items['rowStylesByStatus'].empty?
          #Set the row color
          #

          if( j % 2 ==0)
            rowColor = @items['rowOffsets'][1]
          else
            rowColor = @items['rowOffsets'][0]
          end

          #Draw default color
          #
          pieces['<!--BGCOLOR-->']  = rowColor
          pieces['<!--ROWSTYLE-->'] = ''
          pieces['<!--ROWCLASS-->'] = @items['rowClass']
        else
          pieces['<!--BGCOLOR-->']   = !customRowColor.empty? ? customRowColor : @items['rowColor']
          pieces['<!--ROWSTYLE-->']  = !customRowStyle.empty? ? customRowStyle : ''
          pieces['<!--ROWCLASS-->']  = @items['rowClass']
        end
        pieces['<!--ROWSTYLE-->']    += 'font-size:' + @items['dataFontSize'] + ';'

        if !changedFontColor
          pieces['<!--ROWSTYLE-->']  += 'color:' + @items['rowFontColor'] + ';'
        end

        rows << WidgetList::Utils::fill(pieces, @items['row'])

      end

      @templateFill['<!--DATA-->'] = rows.join('')

    else

      err_message = (get_database.errors) ? @items['noDataMessage'] + ' <span style="color:red">(An error occurred)</span>' : @items['noDataMessage']

      @templateFill['<!--DATA-->'] = '<tr><td colspan="50"><div id="noListResults">' + generate_error_output() + err_message + '</div></td></tr>'

    end

  else

    err_message = (get_database.errors) ? @items['noDataMessage'] + ' <span style="color:red">(An error occurred)</span>' : @items['noDataMessage']

    @templateFill['<!--DATA-->'] = '<tr><td colspan="50"><div id="noListResults">' + generate_error_output() + err_message + '</div></td></tr>'
  end

end

#build_statement ⇒ Object

# File 'lib/widget_list.rb', line 4114

def build_statement()

  @mongo_sort = {}
  statement  = ''
  @fieldList      = []
  @fieldListPlain = []
  pieces     =      { '<!--FIELDS_PLAIN-->'  => '',
                      '<!--FIELDS-->'        => '',
                      '<!--SOURCE-->'        => '',
                      '<!--WHERE-->'         => '',
                      '<!--GROUPBY-->'       => '',
                      '<!--ORDERBY-->'       => '',
                      '<!--LIMIT-->'         => ''}

  #Build out a list of columns to select from
  #

  @items['fields'].each { |column, fieldTitle|
    @fieldListPlain << strip_aliases(column)
    if @items['fieldFunction'].key?(column) && !@items['fieldFunction'][column].empty?
      # fieldFunction's should not have an alias, just the database functions
      column = @items['fieldFunction'][column] + " " + column
    end
    @fieldList << column
  }


  if get_database.db_type == 'oracle'
    if !@items['groupBy'].empty?
      @fieldList << 'MAX(rn) as rn'
    else
      @fieldList << 'rn'
    end
    @fieldListPlain << 'rn'
  end

  if @items['fieldsHidden'].class.name == 'Array'
    @items['fieldsHidden'].each { |column|
      if !@items['fields'].key?(column)
        @fieldListPlain << strip_aliases(column)
        if @items['fieldFunction'].key?(column) && !@items['fieldFunction'][column].empty?
          # fieldFunction's should not have an alias, just the database functions
          column = @items['fieldFunction'][column] + " " + column
        end
        @fieldList << column
      end
    }
  elsif @items['fieldsHidden'].class.name == 'Hash'
    @items['fieldsHidden'].each { |column|
      col = column[0]
      if !@items['fields'].key?(col)
        @fieldListPlain << strip_aliases(col)
        if @items['fieldFunction'].key?(column[0]) && !@items['fieldFunction'][column[0]].empty?
          # fieldFunction's should not have an alias, just the database functions
          col = @items['fieldFunction'][column[0]] + " " + column[0]
        end
        @fieldList << col
      end
    }
  end


  viewPieces = {}
  viewPieces['<!--FIELDS_PLAIN-->'] = @fieldListPlain.join(',')
  viewPieces['<!--FIELDS-->'] = @fieldList.join(',')
  viewPieces['<!--SOURCE-->'] = get_view()

  statement = WidgetList::Utils::fill(viewPieces, @items['statement']['select']['view'])

  @sqlHash = Digest::SHA2.hexdigest( WidgetList::Utils::fill(pieces, statement) )

  if @items['searchClear'] || @items['searchClearAll']
    clear_sql_session(@items.key?('searchClearAll'))
  end

  if !$_REQUEST.key?('BUTTON_VALUE') && !$_SESSION['LIST_SEQUENCE'].nil? && $_SESSION.key?('LIST_SEQUENCE') && $_SESSION['LIST_SEQUENCE'].key?(@sqlHash) &&  $_SESSION['LIST_SEQUENCE'][@sqlHash] > 0
    @sequence = $_SESSION['LIST_SEQUENCE'][@sqlHash]
    generate_limits
  end

  if !@filter.empty?
    pieces['<!--WHERE-->'] = ' WHERE ' + @filter
  end

  if !@items['groupBy'].empty?
    pieces['<!--GROUPBY-->'] = ' GROUP BY ' + @items['groupBy']
  else
    pieces['<!--GROUPBY-->'] = ''
  end

  if !@items['LIST_COL_SORT'].empty? || ($_SESSION.key?('LIST_COL_SORT') && $_SESSION['LIST_COL_SORT'].class.name == 'Hash' && $_SESSION['LIST_COL_SORT'].key?(@sqlHash))
    pieces['<!--ORDERBY-->'] += ' ORDER BY '
    foundColumn = false
    if ! @items['LIST_COL_SORT'].empty?
      foundColumn = true
      @mongo_sort[(( @items['LIST_COL_SORT'] != 'cnt') ? '_id.' : '') + @items['LIST_COL_SORT']] = (@items['LIST_COL_SORT_ORDER'] == 'ASC') ? 1 : -1 if $is_mongo
      pieces['<!--ORDERBY-->'] += tick_field() + strip_aliases(@items['LIST_COL_SORT']) + tick_field() + " " + @items['LIST_COL_SORT_ORDER']
    else
      $_SESSION['LIST_COL_SORT'][@sqlHash].each_with_index { |order,void|
        if @items['fields'].key?(order[0])
          foundColumn = true
          @mongo_sort[((order[0] != 'cnt') ? '_id.' : '') + order[0]] = (order[1] == 'ASC') ? 1 : -1 if $is_mongo
          pieces['<!--ORDERBY-->'] += tick_field() + strip_aliases(order[0]) + tick_field() +  " " + order[1]
        end
      } if $_SESSION.key?('LIST_COL_SORT') && $_SESSION['LIST_COL_SORT'].class.name == 'Hash' && $_SESSION['LIST_COL_SORT'].key?(@sqlHash)
    end

    # Add base order by
    if ! @items['orderBy'].empty?
      pieces['<!--ORDERBY-->'] += ',' if foundColumn == true
      pieces['<!--ORDERBY-->'] += @items['orderBy']

      if $is_mongo
        if @items['orderBy'].include?(',')
          criteriaTmp = @items['orderBy'].split_it(',')
        else
          criteriaTmp = [@items['orderBy']]
        end

        criteriaTmp.each { |value|
          @mongo_sort['_id.' + value.gsub(/ASC/,'').gsub(/DESC/,'').strip] = (value.include?('DESC')) ? -1 : 1
        }
      end
    end

  elsif !@items['orderBy'].empty?
    pieces['<!--ORDERBY-->'] += ' ORDER BY ' + @items['orderBy']
  end

  if get_database.db_type == 'oracle' && pieces['<!--ORDERBY-->'].empty?
    #oracle needs a field to perform the rank() over
    #if field is not an "inputs" or a "buttons"
    #if field is all NULL, then you better watch out as paging will NOT work
    tmp  = @items['fields'].dup.reject { |val|
      if (!@items['inputs'].key?(val) && !@items['buttons'].key?(val))
        false
      else
        true
      end
    }

    keys = tmp.keys
    pieces['<!--ORDERBY-->'] += ' ORDER BY ' + strip_aliases(keys[0]) + ' ASC' unless keys[0].nil?
  end

  case get_database.db_type
    when 'postgres'
      pieces['<!--LIMIT-->'] = ' LIMIT :HIGH OFFSET :LOW'
    when 'oracle'

      pieces['<!--LIMIT-->'] =
          '
        WHERE
        (
             rn >' + (@sequence > 1 ? '' : '=') + ' :LOW
          AND
             rn <= :HIGH
        )
        '
    else
      pieces['<!--LIMIT-->'] = ' LIMIT :LOW, :HIGH'
  end


  statement = WidgetList::Utils::fill(pieces, statement)

  if @items['rowLimit'].to_i >= @totalRows
    @items['bindVarsLegacy']['LOW'] = 0
    @sequence = 1
  end


  if $is_mongo

    #
    # Ordering in mongo object
    #

    columnordering = pieces['<!--ORDERBY-->'].gsub!(/ORDER BY/,'')
    pieces['<!--ORDERBY-->'] = columnordering.strip unless columnordering.nil?
    @active_record_model = @active_record_model.order_by(pieces['<!--ORDERBY-->'])  unless columnordering.nil?

    #
    # Limits in mongo
    #
    @active_record_model = @active_record_model.skip(@items['bindVarsLegacy']['LOW'].to_i).limit(@items['rowLimit'].to_i)

    @mongo_skip  = @items['bindVarsLegacy']['LOW'].to_i
    @mongo_limit = @items['rowLimit'].to_i

  end
  statement
end

#build_summary_row ⇒ Object

# File 'lib/widget_list.rb', line 3899

def build_summary_row()
  if @totalResultCount > 0 && !@items['totalRow'].empty?

    if @totalRowCount > 0

      columns        = []
      first_col      = true
      @rawTotals     = {}
      row_values     = []


      @items['fields'].each { |column , fieldTitle|
        column = strip_aliases(column)

        colPieces        = {}
        colClasses       = []
        theStyle         = ''
        colData          = ''
        colClass         = ''
        onClick          = ''
        colWidthStyle    = ''
        content          = ''
        contentTitle     = ''

        if first_col
          first_col          = false
          content            = @items['totalRowFirstCol']
          @rawTotals[column] = strip_tags(content)
        else
          if (@items['totalRow'].include?(column) || @items['totalRow'].key?(column) && @results.key?(column.upcase))

            preg_max_precision = Regexp.new('\\' + @items['totalRowSeparator'] + '([0-9]+)')   #/\.([0-9]+)/
            preg_number_value  = Regexp.new('[0-9|\\' + @items['totalRowSeparator'] + '0-9]+') #/[0-9|\.0-9]+/
            preg_strip_commas  = Regexp.new('\\' + @items['totalRowDelimiter'])

            content       = 0
            max_precision = [0]
            raw_value     = 0.0
            prefix        = ''
            suffix        = ''

            @results[column.upcase].each { |val|

              if val.include?("<script class='val-db'")
                val = val[0..val.index("<script class='val-db'")-1]
              end

              cleanData      = strip_tags(val.to_s)

              max_precision  << cleanData.match(preg_max_precision)[1].length unless cleanData.match(preg_max_precision).nil?

              raw_value      = cleanData.gsub(preg_strip_commas,'').match(preg_number_value)[0].to_f  unless cleanData.gsub(preg_strip_commas,'').match(preg_number_value).nil?

              prefix, suffix = cleanData.gsub(preg_strip_commas,'').split(preg_number_value)
              prefix = '' if prefix.nil?
              suffix = '' if suffix.nil?
              content = content + raw_value
            }


            if @items['totalRowPrefix'].key?(column)
              prefix = @items['totalRowPrefix'][column]
            end

            if @items['totalRowSuffix'].key?(column)
              suffix = @items['totalRowSuffix'][column]
            end

            precision = max_precision.max

            if @items['totalRowMethod'].key?(column)

              case @items['totalRowMethod'][column]
                when 'average'
                  content =  (content/@totalRowCount).round(precision)
              end

            end

            @rawTotals[column] = content
            content = number_to_currency(content, :unit => prefix, :precision => precision, :separator => @items['totalRowSeparator'], :delimiter => @items['totalRowDelimiter']) + suffix

          else
            @rawTotals[column] = @items['totalRowDefault']
            content = @items['totalRowDefault']
          end


          row_values << content
        end

        content = get_database._bind(content, @items['bindVarsLegacy'])

        # Column color
        #
        if ! @items['columnStyle'].empty?
          if @items['columnStyle'].key?(column.downcase)
            colHeader  = @items['columnStyle'][column.downcase]

            if @results.key?(colHeader.upcase)
              theStyle = @results[colHeader.upcase][j]
            else
              theStyle = colHeader
            end

          end
        end

        # Column width
        #
        if ! @items['columnWidth'].empty?
          if @items['columnWidth'].key?(column.downcase)
            colWidthStyle = "width:" + @items['columnWidth'][column.downcase] + ";"
          end
        end

        # Column Class
        #
        if !@items['columnClass'].empty?
          if @items['columnClass'].key?(column.downcase)
            colClasses << @items['columnClass'][column.downcase]
          end
        end

        #
        # Setup any column classes
        #
        colClasses << @items['colClass']
        colClass = colClasses.join(' ')

        #
        # Set up Column Pieces
        #
        colPieces['<!--CLASS-->']   = colClass
        colPieces['<!--ALIGN-->']   = @items['colAlign']
        colPieces['<!--STYLE-->']   = theStyle  + colWidthStyle

        if @items['borderedColumns']
          colPieces['<!--STYLE-->'] += 'border-right: ' + @items['borderColumnStyle'] + ';'
        end

        if @items['borderedRows']
          colPieces['<!--STYLE-->'] += 'border-top: ' + @items['borderRowStyle'] + ';'
        end

        colPieces['<!--ONCLICK-->']    = onClick
        colPieces['<!--TITLE-->']      = contentTitle #todo htmlentities needed ?
        colPieces['<!--CONTENT-->']    = content
        colPieces['<!--SPAN_STYLE-->'] = ''

        #
        # Assemble the Column
        #
        columns << WidgetList::Utils::fill(colPieces, @items['col'])
      }


      if $_REQUEST.key?('export_widget_list')
        @csv << row_values
      end

      #
      # Draw the row
      #
      pieces = {'<!--CONTENT-->' => columns.join('') }

      pieces['<!--BGCOLOR-->']   = @items['rowOffsets'][@totalRowCount % 2]
      pieces['<!--ROWSTYLE-->']  = ''
      pieces['<!--ROWCLASS-->']  = @items['rowClass']
      pieces['<!--ROWSTYLE-->']    += 'font-size:' + @items['dataFontSize'] + ';'

      @templateFill['<!--DATA-->'] +=  WidgetList::Utils::fill(pieces, @items['row'])

    end

  end

end

#cast_col ⇒ Object

# File 'lib/widget_list.rb', line 2142

def cast_col()
  case get_database.db_type
    when 'postgres'
      '::char(1000)'
    else
      ''
  end
end

#clear_search_session(all = false) ⇒ Object

# File 'lib/widget_list.rb', line 2230

def clear_search_session(all=false)

  if $_SESSION.key?('SEARCH_FILTER') && $_SESSION['SEARCH_FILTER'].key?(@items['name'])
    $_SESSION['SEARCH_FILTER'].delete(@items['name'])
  end

  if $_SESSION.key?('ROW_LIMIT') && $_SESSION['ROW_LIMIT'].key?(@items['name'])
    $_SESSION['ROW_LIMIT'].delete(@items['name'])
  end

  if $_SESSION.key?('DRILL_DOWNS') && $_SESSION['DRILL_DOWNS'].key?(@items['name'])
    $_SESSION['DRILL_DOWNS'].delete(@items['name'])
  end

  if $_SESSION.key?('DRILL_DOWN_FILTERS') && $_SESSION['DRILL_DOWN_FILTERS'].key?(@items['name'])
    $_SESSION['DRILL_DOWN_FILTERS'].delete(@items['name'])
  end

  if all && $_SESSION.key?('SEARCH_FILTER')
    $_SESSION.delete('SEARCH_FILTER')
  end

  if all && $_SESSION.key?('ROW_LIMIT')
    $_SESSION.delete('ROW_LIMIT')
  end

  if $_REQUEST.key?('LIST_FILTER_ALL')
    $_REQUEST.delete('LIST_FILTER_ALL')
  end

  if $_REQUEST.key?('LIST_COL_SORT')
    $_REQUEST.delete('LIST_COL_SORT')
  end

  if $_REQUEST.key?('LIST_COL_SORT_ORDER')
    $_REQUEST.delete('LIST_COL_SORT_ORDER')
  end

  if $_REQUEST.key?('LIST_SEQUENCE')
    $_REQUEST.delete('LIST_SEQUENCE')
  end

end

#clear_sort_get_vars ⇒ Object

# File 'lib/widget_list.rb', line 2337

def clear_sort_get_vars()
  $_REQUEST.delete('LIST_FILTER_ALL')
  $_REQUEST.delete('ROW_LIMIT')
  $_REQUEST.delete('LIST_SEQUENCE')
  $_REQUEST.delete('LIST_COL_SORT_ORDER')
  $_REQUEST.delete('LIST_COL_SORT')
  $_REQUEST.delete('LIST_FILTER_ALL')
end

#clear_sql_session(all = false) ⇒ Object

# File 'lib/widget_list.rb', line 2274

def clear_sql_session(all=false)

  if $_SESSION.key?('LIST_SEQUENCE') && $_SESSION['LIST_SEQUENCE'].key?(@sqlHash)
    $_SESSION['LIST_SEQUENCE'].delete(@sqlHash)
  end

  if $_SESSION.key?('LIST_COL_SORT') && $_SESSION['LIST_COL_SORT'].key?(@sqlHash)
    $_SESSION['LIST_COL_SORT'].delete(@sqlHash)
  end

  if all && $_SESSION.key?('LIST_COL_SORT')
    $_SESSION.delete('LIST_COL_SORT')
  end

  if all && $_SESSION.key?('LIST_SEQUENCE')
    $_SESSION.delete('LIST_SEQUENCE')
  end

end

#connect ⇒ Object

# File 'lib/widget_list.rb', line 4588

def connect

  @has_connected = true
  begin
    if Rails.root.join("config", "widget-list.yml").file?
      WidgetList::List::load_widget_list_yml()
      if $widget_list_conf.nil?
        throw 'Configuration file widget-list.yml has no data.  Check that (' + Rails.env + ') Rails.env matches the pointers in the file'
      end
      @primary_conn   = $widget_list_conf[:primary]
      @secondary_conn = $widget_list_conf[:secondary]
    else
      throw 'widget-list.yml not found'
    end

    @is_primary_sequel                 = true
    @is_secondary_sequel               = true
    if @primary_conn != false && ! @primary_conn.include?(':/')
      @is_primary_sequel               = false
    end

    if @secondary_conn != false && !@secondary_conn.include?(':/')
      @is_secondary_sequel             = false
    end

    if @primary_conn != false
      if @primary_conn.include?(':/')
        @widget_list_sequel_conn         = Sequel.connect(@primary_conn)
        @widget_list_sequel_conn.db_type = WidgetList::List::determine_db_type(@primary_conn)
      else
        @widget_list_ar_conn             = WidgetListActiveRecord.new
        @widget_list_ar_conn.db_type     = WidgetList::List::determine_db_type(@primary_conn)
      end
    end

    if @secondary_conn != false
      if @secondary_conn.include?(':/')
        @widget_list_sequel_conn2         = Sequel.connect(@secondary_conn)
        @widget_list_sequel_conn2.db_type = WidgetList::List::determine_db_type(@secondary_conn)
      else
        @widget_list_ar_conn2             = WidgetListActiveRecord.new
        @widget_list_ar_conn2.db_type     = WidgetList::List::determine_db_type(@secondary_conn)
      end
    end

  rescue Exception => e
    Rails.logger.info "widget-list.yml and connection to @widget_list_sequel_conn or @widget_list_sequel_conn2 failed.  Please fix and try again (" + e.to_s + ")"
  end

end

#generate_error_output(ex = '') ⇒ Object

# File 'lib/widget_list.rb', line 4078

def generate_error_output(ex='')
  sqlDebug = ""

  if !@items['errors'].empty?
    sqlDebug += "<br/><br/><strong style='color:red'>(" + @items['errors'].join(', ') + ")</strong>"
  end

  if Rails.env == 'development'
    sqlDebug += "<br/><br/><textarea style='width:100%;height:400px;'>" + get_database.last_sql.to_s + "</textarea>"
  end

  if Rails.env == 'development' && get_database.errors
    sqlDebug += "<br/><br/><strong style='color:red'>(" + get_database.last_error.to_s + ")</strong>"
  end

  if Rails.env == 'development' && ex != ''
    sqlDebug += "<br/><br/><strong style='color:red'>(" + ex.to_s + ") <pre>"  + $!.backtrace.join("\n\n") +  "</pre></strong>"
  end

  if Rails.env != 'development'

    if get_database.errors
      Rails.logger.info get_database.last_error.to_s
    end

    if ex != ''
      Rails.logger.info $!.backtrace.join("\n\n")
    end

  end

  Rails.logger.info sqlDebug

  sqlDebug
end

#generate_limits ⇒ Object

# File 'lib/widget_list.rb', line 2346

def generate_limits()
  #Pagination
  #
  @items['bindVarsLegacy']['LOW']  = @items['rowStart']
  @items['bindVarsLegacy']['HIGH'] = @items['rowLimit']

  if @sequence.to_i > 1 && ! @items['NEW_SEARCH']
    subtractLimit = 0
    if get_database.db_type != 'oracle'
      subtractLimit = @items['rowLimit']
    end
    @items['bindVarsLegacy']['LOW'] = (((@sequence * @items['rowLimit']) -  subtractLimit))
    if get_database.db_type == 'oracle'
      @items['bindVarsLegacy']['HIGH'] = ((((@sequence + 1) * @items['rowLimit'])))
      @items['bindVarsLegacy']['LOW'] = @items['bindVarsLegacy']['LOW'] - @items['rowLimit']
      @items['bindVarsLegacy']['HIGH'] = @items['bindVarsLegacy']['HIGH'] - @items['rowLimit']
    end

  end
end

#get_database ⇒ Object

# File 'lib/widget_list.rb', line 4663

def get_database

  if @has_connected.nil?
    connect
  end

  if @is_primary_sequel && @widget_list_sequel_conn.class.name.to_s.split('::').first == 'Sequel' && @current_db_selection == 'primary' || @current_db_selection.nil?
    @widget_list_sequel_conn.test_connection
  end

  if @is_secondary_sequel && @widget_list_sequel_conn2.class.name.to_s.split('::').first == 'Sequel' && @current_db_selection == 'secondary'
    @widget_list_sequel_conn2.test_connection
  end

  case @current_db_selection
    when 'primary'
      return (@is_primary_sequel) ? @widget_list_sequel_conn : @widget_list_ar_conn
    when 'secondary'
      return (@is_secondary_sequel) ? @widget_list_sequel_conn2 : @widget_list_ar_conn2
    else
      return (@is_primary_sequel) ? @widget_list_sequel_conn : @widget_list_ar_conn
  end

end

#get_db_type(primary = true) ⇒ Object

# File 'lib/widget_list.rb', line 4524

def get_db_type(primary=true)
  WidgetList::List::get_db_type(primary)
end

#get_grouping_functions ⇒ Object

# File 'lib/widget_list.rb', line 1866

def get_grouping_functions()
  #http://docs.oracle.com/cd/E11882_01/server.112/e10592/functions003.htm
  [
      'AVG(',
      'COLLECT(',
      'CORR(',
      'COUNT(',
      'COVAR_POP(',
      'COVAR_SAMP(',
      'CUME_DIST(',
      'DENSE_RANK(',
      'FIRST(',
      'GROUP_ID(',
      'GROUPING_ID(',
      'LAST(',
      'LISTAGG(',
      'MAX(',
      'MEDIAN(',
      'MIN(',
      'PERCENT_RANK(',
      'PERCENTILE_CONT(',
      'PERCENTILE_DISC(',
      'RANK(',
      'REGR_SLOPE(',
      'REGR_INTERCEPT(',
      'REGR_COUNT(',
      'REGR_R2(',
      'REGR_AVGX(',
      'REGR_AVGY(',
      'REGR_SXX(',
      'REGR_SYY(',
      'REGR_SXY(',
      'STATS_MINOMIAL_TEST(',
      'STATS_CROSSTAB(',
      'STATS_F_TEST(',
      'STATS_KS_TEST(',
      'STATS_MODE(',
      'STATS_MW_TEST(',
      'STDDEV(',
      'STDDEV_POP(',
      'STDDEV_SAMP(',
      'SUM(',
      'SYS_XMLAGG(',
      'VAR_POP(',
      'VAR_SAMP(',
      'VARIANCE(',
      'XMLAGG(',
  ]
end

#get_header_pieces ⇒ Object

# File 'lib/widget_list.rb', line 2652

def get_header_pieces()
  @headerPieces
end

#get_header_px_value ⇒ Object

# File 'lib/widget_list.rb', line 2648

def get_header_px_value()
  @items['titleFontSize'].to_s.include?('px') ? @items['titleFontSize'].to_s : @items['titleFontSize'].to_s + 'px'
end

#get_radius_value ⇒ Object

# File 'lib/widget_list.rb', line 2636

def get_radius_value()
  @items['cornerRadius'].to_s.include?('px') ? @items['cornerRadius'].to_s : @items['cornerRadius'].to_s + 'px'
end

#get_shadow_inset_value ⇒ Object

# File 'lib/widget_list.rb', line 2640

def get_shadow_inset_value()
  @items['shadowInset'].to_s.include?('px') ? @items['shadowInset'].to_s : @items['shadowInset'].to_s + 'px'
end

#get_shadow_spread_value ⇒ Object

# File 'lib/widget_list.rb', line 2644

def get_shadow_spread_value()
  @items['shadowSpread'].to_s.include?('px') ? @items['shadowSpread'].to_s : @items['shadowSpread'].to_s + 'px'
end

#get_total_records ⇒ Object

# File 'lib/widget_list.rb', line 4356

def get_total_records()

  filter = ''
  fields = {}
  sql    = ''
  hashed = false

  if !get_view().empty?
    sql = WidgetList::Utils::fill({'<!--VIEW-->' => get_view(),'<!--GROUPBY-->' => !@items['groupBy'].empty? ? ' GROUP BY ' + @items['groupBy'] : '' }, @items['statement']['count']['view'])
  end

  if $is_mongo

    @active_record_model = @active_record_model.skip(0) #turn object into Mongoid::Criteria which has all the column definitions needed in _select

    #
    # List filters
    #
    @mongo_match = []
    @items['filter'].each_with_index { |value, key|
      field = value.to_sym
      predicate = ''
      if @items.key?('predicate') && !@items['predicate'][key].nil? && !@items['predicate'][key].empty? && value.to_sym.respond_to?(@items['predicate'][key])
        field = field.send(@items['predicate'][key])
        predicate = '$' + @items['predicate'][key]
      end

      @active_record_model = @active_record_model.where('$and' => [{
                                                                       field => WidgetList::List.parse_inputs_for_mongo_predicates(@active_record_model, value, predicate, @items['bindVars'][key])
                                                                   }]) if @items['groupBy'].empty?
      @mongo_match << { value =>  WidgetList::List.mysql_to_mongo_predicate(@items['predicate'][key],@items['bindVars'][key],true) } if @items['fields'].key?(value)
    } if @items.key?('filter') && !@items['filter'].empty?

    if !@items['groupBy'].empty?

      if @items['groupBy'].include?(',')
        criteriaTmp = @items['groupBy'].split_it(',')
      else
        criteriaTmp = [@items['groupBy']]
      end

      map_groups = {}
      criteriaTmp.each { |value|
        map_groups[value] =  "$#{value}"
      }
      #
      @group_match =
          {
              "group" =>  {"$group" => { "_id" => map_groups , "cnt" => { "$sum" => 1 } } },
          }
    end

  else

    if ! @filter.empty?
      filter = ' WHERE ' + @filter
    end
    sql = WidgetList::Utils::fill({'<!--WHERE-->' => filter}, sql)
  end

  if ! sql.empty? || $is_mongo
    if @items['showPagination']

      tmp_match = @group_match

      if $is_mongo
        if !tmp_match.nil?
          tmp_match = @group_match.dup
          tmp_match = tmp_match.merge({"match" =>   @mongo_match })
        end
      end

      cnt = get_database._select( $is_mongo ? 'count' : sql, @items['bindVars'], @items['bindVarsLegacy'], @active_record_model, tmp_match)
      if cnt > 0
        if cnt > get_database.final_results['TOTAL'][0].to_i
          #sometimes databases and queries run do not count(1) and group properly and instead
          rows = cnt
        else
          rows = get_database.final_results['TOTAL'][0].to_i
        end
      else
        rows = 0
      end
      if rows > 0
        @totalRows = rows.to_i
      end
    else
      rows = 1
    end
  else
    rows = 0
  end

  if @totalRows > 0
    @totalPages = (@totalRows.to_f / @items['rowLimit'].to_f).ceil()
  end

  rows
end

#get_view ⇒ Object

# File 'lib/widget_list.rb', line 4528

def get_view
  initializing = false
  if @active_record_model.nil?
    initializing = true
    @active_record_model = false
  end
  if (@is_primary_sequel && @items['database'] == 'primary') ||  (@is_secondary_sequel && @items['database'] == 'secondary')
    return @items['view']
  elsif $is_mongo || (@items['view'].respond_to?('scoped') && @items['view'].scoped.respond_to?('to_sql'))
    @active_record_model = @items['view'].name.constantize if initializing
    new_columns = []

    @items['fields'].each { |column, fieldTitle|
      if @items['fieldFunction'].key?(column) && !@items['fieldFunction'][column].empty?
        # fieldFunction's should not have an alias, just the database functions
        column = @items['fieldFunction'][column] + " " + column
      end
      new_columns << column
    }

    if @items['fieldsHidden'].class.name == 'Array' && !@items['fieldsHidden'].empty?
      @items['fieldsHidden'].each { |columnPivot|
        if !@items['fields'].key?(columnPivot)
          if @items['fieldFunction'].key?(columnPivot) && !@items['fieldFunction'][columnPivot].empty?
            # fieldFunction's should not have an alias, just the database functions
            columnPivot = @items['fieldFunction'][columnPivot] + " " + columnPivot
          end
          new_columns << columnPivot
        end
      }
    elsif @items['fieldsHidden'].class.name == 'Hash' && !@items['fieldsHidden'].empty?
      @items['fieldsHidden'].each { |columnPivot|
        if !@items['fields'].key?(columnPivot[0])
          if @items['fieldFunction'].key?(columnPivot[0]) && !@items['fieldFunction'][columnPivot[0]].empty?
            # fieldFunction's should not have an alias, just the database functions
            columnPivot[0] = @items['fieldFunction'][columnPivot[0]] + " " + columnPivot[0]
          end
          new_columns << columnPivot[0]
        end
      }
    end

    if $is_mongo
      return ''
    else
      view     = @items['view'].scoped.to_sql
      sql_from = view[view.index(/FROM/),view.length]
      view     = "SELECT #{new_columns.join(',')} " + sql_from
      where    = ''
      if !@items['groupBy'].empty?
        where    = '<!--WHERE-->'
      end

      return "( #{view} #{where} <!--GROUPBY--> ) a"
    end
  else
    return ""
  end
end

#render(results = {}) ⇒ Object

pass results of $DATABASE.final_results after running a _select query

Parameters:

• results (Hash) (defaults to: {})

# File 'lib/widget_list.rb', line 2369

def render(results={})

  if @isAdministrating
    if $_REQUEST.key?('name')
      return WidgetList::Administration.new.save_and_show_code()
    elsif $_REQUEST.key?('ajax') && $_REQUEST.key?('model')
      return WidgetList::Administration.new.ajax_get_field_json($_REQUEST['model'])
    elsif $_REQUEST.key?('ajax') && $_REQUEST.key?('save')
      return WidgetList::Administration.new.save_and_show_code()
    else
      return WidgetList::Administration.new.show_interface()
    end
  end

  begin
    if !results.empty?
      @items['data'] = results
    end

    #Get total records for statement validation and pagination
    #
    @items['data'].keys.each { |column|
      @items['fields'][column.downcase] = auto_column_name(column)
    } if !@items['data'].empty? && @items['fields'].empty?

    if @items['data'].empty?
      # Generate count() from database
      #
      @totalResultCount = get_total_records()
    else
      # Count the items in the passed data
      #
      @items['data'].keys.each { |column|
        @totalResultCount = @items['data'][column].count
        @totalRowCount    = @totalResultCount
        @totalRows        = @totalResultCount
        break
      }
    end

    build_rows()

    build_summary_row()

    build_headers()

    listJumpUrl = {}
    listJumpUrl['PAGE_ID']             = @items['pageId']
    listJumpUrl['ACTION']              = 'AJAX'
    listJumpUrl['BUTTON_VALUE']        = @items['buttonVal']
    listJumpUrl['LIST_COL_SORT']       = @items['LIST_COL_SORT']
    listJumpUrl['LIST_COL_SORT_ORDER'] = @items['LIST_COL_SORT_ORDER']
    listJumpUrl['LIST_FILTER_ALL']     = @items['LIST_FILTER_ALL']
    listJumpUrl['ROW_LIMIT']           = @items['ROW_LIMIT']
    listJumpUrl['LIST_SEQUENCE']       = @sequence
    listJumpUrl['LIST_NAME']           = @items['name']
    listJumpUrl['SQL_HASH']            = @sqlHash

    if $_REQUEST.key?('switch_grouping')
      listJumpUrl['switch_grouping'] = $_REQUEST['switch_grouping']
    end

    @templateFill['<!--CORNER_RADIUS-->']        = get_radius_value()
    @templateFill['<!--BOX_SHADOW-->']           = @items['useBoxShadow'] ? 'box-shadow: <!--SHADOW_INSET--> <!--SHADOW_INSET--> <!--SHADOW_SPREAD--> <!--SHADOW_COLOR-->;'  : ''
    @templateFill['<!--SHADOW_INSET-->']         = get_shadow_inset_value()
    @templateFill['<!--SHADOW_SPREAD-->']        = get_shadow_spread_value()
    @templateFill['<!--SHADOW_COLOR-->']         = @items['shadowColor']
    @templateFill['<!--BORDER_HEAD_FOOT_TOP-->'] = @items['borderHeadFoot'] ? 'border-top:' + @items['headFootBorderStyle'] + ';' : ''
    if @items['fontFamily']
      @templateFill['<!--FONT-->']               = 'font-family:' + @items['fontFamily'] + ';'
    end
    @templateFill['<!--FONT_HEADER-->']          = @items['headerFooterFontSize']


    @templateFill['<!--CUSTOM_CONTENT_BOTTOM-->']= @items['customFooter']
    @templateFill['<!--CUSTOM_CONTENT_TOP-->']   = @items['customHeader']
    @templateFill['<!--WRAP_START-->']           = ''
    @templateFill['<!--WRAP_END-->']             = ''
    if !$_REQUEST.key?('BUTTON_VALUE')
      @templateFill['<!--WRAP_START-->']         = '<div class="widget_list_outer">
                                               <input type="hidden" id="<!--NAME-->_jump_url_original" value="<!--JUMP_URL-->"/>'
      @templateFill['<!--WRAP_END-->']           = '</div>'
    end

    @templateFill['<!--HEADER-->']               = @items['templateHeader']
    @templateFill['<!--TABLE_BORDER-->']         = @items['tableBorder']
    @templateFill['<!--HEADER_COLOR-->']         = @items['headerBGColor']
    @templateFill['<!--FOOTER_COLOR-->']         = @items['footerBGColor']
    @templateFill['<!--HEADER_TXT_COLOR-->']     = @items['headerFontColor']
    @templateFill['<!--FOOTER_TXT_COLOR-->']     = @items['footerFontColor']
    @templateFill['<!--TITLE-->']                = @items['title']
    @templateFill['<!--CLASS-->']                = @items['class']

    if @totalRowCount > 0
      @templateFill['<!--INLINE_STYLE-->']       = ''
      @templateFill['<!--TABLE_CLASS-->']        = @items['tableclass']
    else
      @templateFill['<!--INLINE_STYLE-->']       = 'table-layout:auto;'
    end

    #Filter form
    #
    if @items['showSearch'] === true
      if ! @items['templateFilter'].empty?
        @templateFill['<!--FILTER_HEADER-->']    = @items['templateFilter']
      else

        @templateFill['<!--FILTER_HEADER-->'] = ''

        if !$_REQUEST.key?('search_filter') && !@isJumpingList

          #Search page url
          #
          searchUrl = ''
          searchVal = ''

          if ! @items['buttonVal'].empty?
            searchVal = @items['buttonVal']
          else
            searchVal = @items['name']
          end

          filterParameters = {}
          filterParameters['BUTTON_VALUE'] = searchVal
          filterParameters['PAGE_ID']      = @items['pageId']
          filterParameters['LIST_NAME']    = @items['name']
          filterParameters['SQL_HASH']     = @sqlHash

          @items['carryOverRequsts'].each { |value|
            if $_REQUEST.key?(value)
              filterParameters[value] = $_REQUEST[value]
            end
          }

          searchUrl =  WidgetList::Utils::build_url(@items['pageId'], filterParameters, (!$_REQUEST.key?('BUTTON_VALUE')))

          list_search  = {}
          #
          # Search value
          #
          list_search['value'] = ''

          if @items['searchSession']
            if $_SESSION.key?('SEARCH_FILTER') && !$_SESSION['SEARCH_FILTER'].nil? && $_SESSION['SEARCH_FILTER'].key?(@items['name'])
              list_search['value'] = $_SESSION['SEARCH_FILTER'][@items['name']]
            end
          end

          #
          # Search Input Field
          #
          list_search['list-search'] = true
          list_search['width']       = '500'
          list_search['input_class'] = 'info-input'
          list_search['title']       = @items['searchTitle']
          list_search['id']          = 'list_search_id_' + @items['name']
          list_search['name']        = 'list_search_name_' + @items['name']
          list_search['class']       = 'inputOuter widget-search-outer ' + @items['name'].downcase + '-search'
          list_search['search_ahead']       = {
              'url'               => searchUrl,
              'skip_queue'        => false,
              'target'            => @items['name'],
              'search_form'       => @items['listSearchForm'],
              'onkeyup'           => (! @items['searchOnkeyup'].empty?) ? WidgetList::Utils::fill({'<!--URL-->'=>searchUrl, '<!--TARGET-->' => @items['name'], '<!--FUNCTION_ALL-->' => @items['ajaxFunctionAll']}, @items['searchOnkeyup'] + '<!--FUNCTION_ALL-->') : ''
          }

          fillRansack = {}
          if @items['ransackSearch'] != false
            fillRansack['<!--RANSACK-->'] = ActionController::Base.new.render_to_string(:partial => 'widget_list/ransack_fields', :locals => { 'search_object' => @items['ransackSearch'], 'url' => '--JUMP_URL--'})
          end

          @headerPieces['searchBar']            = WidgetList::Utils::fill(fillRansack,WidgetList::Widgets::widget_input(list_search))
          @templateFill['<!--FILTER_HEADER-->'] = @headerPieces['searchBar']

        end

        #
        # Grouping box
        #
        if ! @items['groupByItems'].empty?
          list_group = {}
          list_group['arrow_action']  = 'var stub;'
          list_group['readonly']      = true
          if @items['groupBySelected']
            list_group['value']      = @items['groupBySelected']
          elsif $_REQUEST.key?('group_row_id')
            tmp                      = $_REQUEST['group_row_id'].gsub(@items['name'] + '_row_','')
            if Float(tmp.to_i) != nil
              list_group['value']      = @items['groupByItems'][tmp.to_i - 1]
            end
          else
            list_group['value']      = @items['groupByItems'][0]
          end

          list_group['style']         = 'cursor:pointer;margin-left:5px;'
          list_group['input_style']   = 'cursor:pointer;'
          list_group['outer_onclick'] = 'ToggleAdvancedSearch(this);SelectBoxResetSelectedRow(\'' + @items['name'] + '\');'
          list_group['list-search']   = false
          list_group['width']         = '200'  #hard code for now.  needs to be dynamic based on max str length if this caller is made into a "WidgetFakeSelect"
          list_group['id']            = 'list_group_id_' + @items['name']
          list_group['name']          = 'list_group_name_' + @items['name']
          list_group['class']         = 'inputOuter widget-search-outer ' + @items['name'].downcase + '-group'

          className = ''
          groupRows = []
          if !@items['groupBySelected']
            className     = 'widget-search-results-row-selected'
          end

          num = 1
          @items['groupByItems'].each { |grouping|
            if @items['groupBySelected'] && @items['groupBySelected'] === grouping
              className     = 'widget-search-results-row-selected'
            end
            groupRows << '<div class="widget-search-results-row ' +  className + '" id="' + @items['name'] + '_row_' + num.to_s + '" title="' + grouping + '" onmouseover="jQuery(\'.widget-search-results-row\').removeClass(\'widget-search-results-row-selected\')" onclick="SelectBoxSetValue(\'' + grouping + '\',\'' + @items['name'] + '\');' + @items['groupByClick'] + '">' + grouping + '</div>'
            className = ''
            num = num + 1
          }

          list_group['search_ahead']  = {
              'skip_queue' => false,
              'search_form'=>  '
                             <div id="advanced-search-container" style="height:100% !important;">
                                ' + groupRows.join("\n") + '
                             </div>'
          }
          if !@templateFill.key?('<!--FILTER_HEADER-->')
            @templateFill['<!--FILTER_HEADER-->'] = ''
          end
          @headerPieces['groupByItems']           = '<div class="fake-select ' + @items['name'] + '-group-by"><div class="label">' + @items['groupByLabel'] + ':</div> ' + WidgetList::Widgets::widget_input(list_group) + '</div>'
          @templateFill['<!--FILTER_HEADER-->']  += @headerPieces['groupByItems']

        end

        if @items['showExport']
          @headerPieces['exportButton']           =  '<span class="' + @items['name'] + '-export">' + WidgetList::Widgets::widget_button(@items['exportButtonTitle'], { 'onclick' => 'ListExport(\'' + @items['name'] + '\');' , 'innerClass' => @items['defaultButtonClass'] }, true) + '</span>'
          @templateFill['<!--FILTER_HEADER-->']  += @headerPieces['exportButton']
        end

      end
    end

    @templateFill['<!--NAME-->']                 = @items['name']
    @templateFill['<!--JUMP_URL-->']             = WidgetList::Utils::build_url(@items['pageId'],listJumpUrl,(!$_REQUEST.key?('BUTTON_VALUE')))
    @templateFill['--JUMP_URL--']                = @templateFill['<!--JUMP_URL-->']
    @templateFill['<!--JUMP_URL_NAME-->']        = @items['name'] + '_jump_url'

  rescue Exception => e
    out = '<tr><td colspan="50"><div id="noListResults">' + generate_error_output(e) + @items['noDataMessage'] + '</div></td></tr>'
    if !@templateFill.key?('<!--DATA-->')
      @templateFill['<!--DATA-->']  = out
    else
      @templateFill['<!--DATA-->'] += out
    end
  end

  if $_REQUEST.key?('export_widget_list')
    csv = ''
    @csv.each{ |v|
      csv += v.to_csv
    }
    return csv
  else
    return WidgetList::Utils::fill(@templateFill, @items['template'])
  end
end

#skip_column(fieldName) ⇒ Object

# File 'lib/widget_list.rb', line 2119

def skip_column(fieldName)
  skip = false
  (@items['inputs']||{}).each { |k,v|
    if fieldName == k
      skip = true
    end
  }

  if @items['buttons'].key?(fieldName)
    skip = true
  end
  return skip
end

#strip_aliases(name = '') ⇒ Object

# File 'lib/widget_list.rb', line 4308

def strip_aliases(name='')
  name = (name.include?(' ') ? name.split(' ').last : name)
  ((name.include?('.')) ? name.split('.').last.gsub(/'||"/,'') : name.gsub(/'||"/,''))
end

#tick_field ⇒ Object

# File 'lib/widget_list.rb', line 2133

def tick_field()
  case get_database.db_type
    when 'postgres','mongo','oracle'
      ''
    else
      '`'
  end
end