/**
    * Copyright 2005-2013 The Kuali Foundation
    *
    * Licensed under the Educational Community License, Version 2.0 (the "License");
    * you may not use this file except in compliance with the License.
    * You may obtain a copy of the License at
    *
    * http://www.opensource.org/licenses/ecl2.php
    *
   * Unless required by applicable law or agreed to in writing, software
   * distributed under the License is distributed on an "AS IS" BASIS,
   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   * See the License for the specific language governing permissions and
   * limitations under the License.
   */
  package org.kuali.rice.krad.uif.widget;
  
  import org.apache.commons.collections.CollectionUtils;
  import org.apache.commons.lang.ClassUtils;
  import org.apache.commons.lang.StringUtils;
  import org.kuali.rice.core.api.CoreApiServiceLocator;
  import org.kuali.rice.core.api.config.property.ConfigurationService;
  import org.kuali.rice.core.api.util.type.KualiDecimal;
  import org.kuali.rice.core.api.util.type.KualiInteger;
  import org.kuali.rice.core.api.util.type.KualiPercent;
  import org.kuali.rice.krad.datadictionary.parse.BeanTag;
  import org.kuali.rice.krad.datadictionary.parse.BeanTagAttribute;
  import org.kuali.rice.krad.datadictionary.parse.BeanTags;
  import org.kuali.rice.krad.uif.UifConstants;
  import org.kuali.rice.krad.uif.UifParameters;
  import org.kuali.rice.krad.uif.component.Component;
  import org.kuali.rice.krad.uif.component.ComponentBase;
  import org.kuali.rice.krad.uif.container.CollectionGroup;
  import org.kuali.rice.krad.uif.control.CheckboxControl;
  import org.kuali.rice.krad.uif.control.CheckboxGroupControl;
  import org.kuali.rice.krad.uif.control.Control;
  import org.kuali.rice.krad.uif.control.RadioGroupControl;
  import org.kuali.rice.krad.uif.control.SelectControl;
  import org.kuali.rice.krad.uif.field.DataField;
  import org.kuali.rice.krad.uif.field.Field;
  import org.kuali.rice.krad.uif.field.FieldGroup;
  import org.kuali.rice.krad.uif.field.InputField;
  import org.kuali.rice.krad.uif.field.LinkField;
  import org.kuali.rice.krad.uif.field.MessageField;
  import org.kuali.rice.krad.uif.layout.LayoutManager;
  import org.kuali.rice.krad.uif.layout.TableLayoutManager;
  import org.kuali.rice.krad.uif.util.ObjectPropertyUtils;
  import org.kuali.rice.krad.uif.view.View;
  import org.kuali.rice.krad.util.KRADConstants;
  import org.kuali.rice.krad.util.KRADUtils;
  import org.kuali.rice.krad.web.form.UifFormBase;
  
  import java.sql.Timestamp;
  import java.util.ArrayList;
  import java.util.HashSet;
  import java.util.List;
  import java.util.Set;
  
  /**
   * Decorates a HTML Table client side with various tools
   *
   * <p>
   * Decorations implemented depend on widget implementation. Examples are
   * sorting, paging and skinning.
   * </p>
   *
   * @author Kuali Rice Team (rice.collab@kuali.org)
   */
  @BeanTags({@BeanTag(name = "richTable-bean", parent = "Uif-RichTable"),
          @BeanTag(name = "pagedRichTable-bean", parent = "Uif-PagedRichTable"),
          @BeanTag(name = "scrollableRichTable-bean", parent = "Uif-ScrollableRichTable")})
  public class RichTable extends WidgetBase {
      private static final long serialVersionUID = 4671589690877390070L;
  
      private String emptyTableMessage;
      private boolean disableTableSort;
  
      private boolean forceAoColumnDefsOverride;
  
      private boolean forceLocalJsonData;
      private int nestedLevel;
      private String aaData;
  
      private Set<String> hiddenColumns;
      private Set<String> sortableColumns;
      private List<String> cellCssClasses;
  
      private String ajaxSource;
  
      private boolean showSearchAndExportOptions = true;
      private boolean showSearchOption = false;
      private boolean showExportOption = false;
  
      private String groupingOptionsJSString;
  
      public RichTable() {
          super();
          groupingOptionsJSString = "null";
          cellCssClasses = new ArrayList<String>();
     }
 
     /**
      * The following initialization is performed:
      *
      * <ul>
      * <li>Initializes component options for empty table message</li>
      * </ul>
      */
     @Override
     public void performFinalize(View view, Object model, Component component) {
         super.performFinalize(view, model, component);
 
         UifFormBase formBase = (UifFormBase) model;
 
         if (!isRender()) {
             return;
         }
 
         if (StringUtils.isNotBlank(getEmptyTableMessage()) && !getTemplateOptions().containsKey(
                 UifConstants.TableToolsKeys.LANGUAGE)) {
             getTemplateOptions().put(UifConstants.TableToolsKeys.LANGUAGE,
                     "{\"" + UifConstants.TableToolsKeys.EMPTY_TABLE + "\" : \"" + getEmptyTableMessage() + "\"}");
         }
 
         if (!isShowSearchAndExportOptions()) {
             Object domOption = getTemplateOptions().get(UifConstants.TableToolsKeys.SDOM);
             if (domOption instanceof String) {
                 String sDomOption = (String) domOption;
 
                 if (StringUtils.isNotBlank(sDomOption)) {
                     if (!isShowExportOption()) {
                         sDomOption = StringUtils.remove(sDomOption, "T"); //Removes Export option
                     }
                     if (!isShowSearchOption()) {
                         sDomOption = StringUtils.remove(sDomOption, "f"); //Removes search option
                     }
                     getTemplateOptions().put(UifConstants.TableToolsKeys.SDOM, sDomOption);
                 }
             }
         }
 
         // for add events, disable initial sorting
         if (UifConstants.ActionEvents.ADD_LINE.equals(formBase.getActionEvent()) || UifConstants.ActionEvents
                 .ADD_BLANK_LINE.equals(formBase.getActionEvent())) {
             getTemplateOptions().put(UifConstants.TableToolsKeys.AASORTING, "[]");
         }
 
         if ((component instanceof CollectionGroup)) {
             CollectionGroup collectionGroup = (CollectionGroup) component;
             LayoutManager layoutManager = collectionGroup.getLayoutManager();
 
             //if useServerPaging is true, add the css cell styling to the template options so it can still be used
             //since this will not go through the grid ftl
             if (layoutManager instanceof TableLayoutManager && collectionGroup.isUseServerPaging()) {
                 addCellStyling((TableLayoutManager) layoutManager);
             }
 
             buildTableOptions(collectionGroup);
             setTotalOptions(collectionGroup);
         }
 
         if (isDisableTableSort()) {
             getTemplateOptions().put(UifConstants.TableToolsKeys.TABLE_SORT, "false");
         }
 
         String kradUrl = getConfigurationService().getPropertyValueAsString(UifConstants.ConfigProperties.KRAD_URL);
         if (StringUtils.isNotBlank(ajaxSource)) {
             getTemplateOptions().put(UifConstants.TableToolsKeys.SAJAX_SOURCE, ajaxSource);
         } else if (component instanceof CollectionGroup && ((CollectionGroup) component).isUseServerPaging()) {
             // enable required dataTables options for server side paging
             getTemplateOptions().put(UifConstants.TableToolsKeys.BPROCESSING, "true");
             getTemplateOptions().put(UifConstants.TableToolsKeys.BSERVER_SIDE, "true");
 
             //build sAjaxSource url to call
             getTemplateOptions().put(UifConstants.TableToolsKeys.SAJAX_SOURCE, kradUrl
                     + ((UifFormBase) model).getControllerMapping()
                     + "?"
                     + UifConstants.CONTROLLER_METHOD_DISPATCH_PARAMETER_NAME
                     + "="
                     + UifConstants.MethodToCallNames.TABLE_JSON
                     + "&"
                     + UifParameters.TABLE_ID
                     + "="
                     + component.getId()
                     + "&"
                     + UifParameters.FORM_KEY
                     + "="
                     + ((UifFormBase) model).getFormKey()
                     + "&"
                     + UifParameters.AJAX_RETURN_TYPE
                     + "="
                     + UifConstants.AjaxReturnTypes.UPDATENONE.getKey()
                     + "&"
                     + UifParameters.AJAX_REQUEST
                     + "="
                     + "true");
         }
 
         //build sAjaxSource url to call
         getTemplateOptions().put(UifConstants.TableToolsKeys.SDOWNLOAD_SOURCE, kradUrl
                 + ((UifFormBase) model).getControllerMapping()
                 + "?"
                 + UifParameters.TABLE_ID
                 + "="
                 + component.getId()
                 + "&"
                 + UifParameters.FORM_KEY
                 + "="
                 + ((UifFormBase) model).getFormKey()
                 + "&"
                 + UifParameters.AJAX_RETURN_TYPE
                 + "="
                 + UifConstants.AjaxReturnTypes.UPDATENONE.getKey()
                 + "&"
                 + UifParameters.AJAX_REQUEST
                 + "="
                 + "true");
 
     }
 
     /**
      * Add the css style to the cellCssClasses by column index, later used by the aoColumnDefs
      *
      * @param manager the tableLayoutManager that contains the original fields
      */
     private void addCellStyling(TableLayoutManager manager) {
         if (!CollectionUtils.isEmpty(manager.getAllRowFields())) {
             for (int index = 0; index < manager.getNumberOfColumns(); index++) {
                 String cellStyleClasses = ((ComponentBase) manager.getAllRowFields().get(index))
                         .getCellStyleClassesAsString();
                 cellCssClasses.add(cellStyleClasses);
             }
         }
     }
 
     /**
      * Builds the footer callback template option for column totals
      *
      * @param collectionGroup the collection group
      */
     private void setTotalOptions(CollectionGroup collectionGroup) {
         LayoutManager layoutManager = collectionGroup.getLayoutManager();
 
         if (layoutManager instanceof TableLayoutManager) {
             List<String> totalColumns = ((TableLayoutManager) layoutManager).getColumnsToCalculate();
 
             if (totalColumns.size() > 0) {
                 String array = "[";
 
                 for (String i : totalColumns) {
                     array = array + i + ",";
                 }
                 array = StringUtils.removeEnd(array, ",");
                 array = array + "]";
                 getTemplateOptions().put(UifConstants.TableToolsKeys.FOOTER_CALLBACK,
                         "function (nRow, aaData, iStart, iEnd, aiDisplay) {initializeTotalsFooter (nRow, aaData, iStart, iEnd, aiDisplay, "
                                 + array
                                 + " )}");
             }
         }
     }
 
     /**
      * Builds column options for sorting
      *
      * @param collectionGroup
      */
     protected void buildTableOptions(CollectionGroup collectionGroup) {
         LayoutManager layoutManager = collectionGroup.getLayoutManager();
         final boolean isUseServerPaging = collectionGroup.isUseServerPaging();
 
         // if sub collection exists, don't allow the table sortable
         if (!collectionGroup.getSubCollections().isEmpty()) {
             setDisableTableSort(true);
         }
 
         if (!isDisableTableSort()) {
             // if rendering add line, skip that row from col sorting
             if (collectionGroup.isRenderAddLine()
                     && !collectionGroup.isReadOnly()
                     && !((layoutManager instanceof TableLayoutManager) && ((TableLayoutManager) layoutManager)
                     .isSeparateAddLine())) {
                 getTemplateOptions().put(UifConstants.TableToolsKeys.SORT_SKIP_ROWS,
                         "[" + UifConstants.TableToolsValues.ADD_ROW_DEFAULT_INDEX + "]");
             }
 
             StringBuffer tableToolsColumnOptions = new StringBuffer("[");
 
             int columnIndex = 0;
             int actionIndex = UifConstants.TableLayoutValues.ACTIONS_COLUMN_RIGHT_INDEX;
             boolean actionFieldVisible = collectionGroup.isRenderLineActions() && !collectionGroup.isReadOnly();
 
             if (layoutManager instanceof TableLayoutManager) {
                 actionIndex = ((TableLayoutManager) layoutManager).getActionColumnIndex();
             }
 
             if (actionIndex == UifConstants.TableLayoutValues.ACTIONS_COLUMN_LEFT_INDEX && actionFieldVisible) {
                 String actionColOptions = constructTableColumnOptions(columnIndex, false, isUseServerPaging, null,
                         null);
                 tableToolsColumnOptions.append(actionColOptions + " , ");
                 columnIndex++;
             }
 
             if (layoutManager instanceof TableLayoutManager && ((TableLayoutManager) layoutManager)
                     .isRenderSequenceField()) {
 
                 //add mData handling if using a json data source
                 String mDataOption = "";
                 if (collectionGroup.isUseServerPaging() || this.forceLocalJsonData) {
                     mDataOption = "\""
                             + UifConstants.TableToolsKeys.MDATA
                             +
                             "\" : function(row,type,newVal){ return _handleColData(row,type,'c"
                             + columnIndex
                             + "',newVal);}, ";
                 }
 
                 tableToolsColumnOptions.append("{\""
                         + UifConstants.TableToolsKeys.SORTABLE
                         + "\" : "
                         + false
                         // auto sequence column is never sortable
                         + ", \""
                         + UifConstants.TableToolsKeys.SORT_TYPE
                         + "\" : \""
                         + UifConstants.TableToolsValues.NUMERIC
                         + "\", "
                         + mDataOption
                         + "\""
                         + UifConstants.TableToolsKeys.TARGETS
                         + "\": ["
                         + columnIndex
                         + "]}, ");
                 columnIndex++;
                 if (actionIndex == 2 && actionFieldVisible) {
                     String actionColOptions = constructTableColumnOptions(columnIndex, false, isUseServerPaging, null,
                             null);
                     tableToolsColumnOptions.append(actionColOptions + " , ");
                     columnIndex++;
                 }
             }
 
             // skip select field if enabled
             if (collectionGroup.isIncludeLineSelectionField()) {
                 String colOptions = constructTableColumnOptions(columnIndex, false, isUseServerPaging, null, null);
                 tableToolsColumnOptions.append(colOptions + " , ");
                 columnIndex++;
             }
 
             // if data dictionary defines aoColumns, copy here and skip default sorting/visibility behaviour
             if (!StringUtils.isEmpty(getTemplateOptions().get(UifConstants.TableToolsKeys.AO_COLUMNS))) {
                 // get the contents of the JS array string
                 String jsArray = getTemplateOptions().get(UifConstants.TableToolsKeys.AO_COLUMNS);
                 int startBrace = StringUtils.indexOf(jsArray, "[");
                 int endBrace = StringUtils.lastIndexOf(jsArray, "]");
                 tableToolsColumnOptions.append(StringUtils.substring(jsArray, startBrace + 1, endBrace) + ", ");
 
                 if (actionFieldVisible && (actionIndex == -1 || actionIndex >= columnIndex)) {
                     String actionColOptions = constructTableColumnOptions(columnIndex, false, isUseServerPaging, null,
                             null);
                     tableToolsColumnOptions.append(actionColOptions);
                 } else {
                     tableToolsColumnOptions = new StringBuffer(StringUtils.removeEnd(tableToolsColumnOptions.toString(),
                             ", "));
                 }
 
                 tableToolsColumnOptions.append("]");
                 getTemplateOptions().put(UifConstants.TableToolsKeys.AO_COLUMNS, tableToolsColumnOptions.toString());
             } else if (!StringUtils.isEmpty(getTemplateOptions().get(UifConstants.TableToolsKeys.AO_COLUMN_DEFS))
                     && forceAoColumnDefsOverride) {
                 String jsArray = getTemplateOptions().get(UifConstants.TableToolsKeys.AO_COLUMN_DEFS);
                 int startBrace = StringUtils.indexOf(jsArray, "[");
                 int endBrace = StringUtils.lastIndexOf(jsArray, "]");
                 tableToolsColumnOptions.append(StringUtils.substring(jsArray, startBrace + 1, endBrace) + ", ");
 
                 if (actionFieldVisible && (actionIndex == -1 || actionIndex >= columnIndex)) {
                     String actionColOptions = constructTableColumnOptions(columnIndex, false, isUseServerPaging, null,
                             null);
                     tableToolsColumnOptions.append(actionColOptions);
                 } else {
                     tableToolsColumnOptions = new StringBuffer(StringUtils.removeEnd(tableToolsColumnOptions.toString(),
                             ", "));
                 }
 
                 tableToolsColumnOptions.append("]");
                 getTemplateOptions().put(UifConstants.TableToolsKeys.AO_COLUMN_DEFS,
                         tableToolsColumnOptions.toString());
             } else if (layoutManager instanceof TableLayoutManager) {
                 List<Field> rowFields = ((TableLayoutManager) layoutManager).getFirstRowFields();
 
                 // build column defs from the the first row of the table
                 for (Component component : rowFields) {
                     if (actionFieldVisible && columnIndex + 1 == actionIndex) {
                         String actionColOptions = constructTableColumnOptions(columnIndex, false, isUseServerPaging,
                                 null, null);
                         tableToolsColumnOptions.append(actionColOptions + " , ");
                         columnIndex++;
                     }
 
                     //add mData handling if using a json data source
                     String mDataOption = "";
                     if (collectionGroup.isUseServerPaging() || this.forceLocalJsonData) {
                         mDataOption = "\""
                                 + UifConstants.TableToolsKeys.MDATA
                                 +
                                 "\" : function(row,type,newVal){ return _handleColData(row,type,'c"
                                 + columnIndex
                                 + "',newVal);}, ";
                     }
 
                     // for FieldGroup, get the first field from that group
                     if (component instanceof FieldGroup) {
                         component = ((FieldGroup) component).getItems().get(0);
                     }
 
                     if (component instanceof DataField) {
                         DataField field = (DataField) component;
 
                         // if a field is marked as invisible in hiddenColumns, append options and skip sorting
                         if (getHiddenColumns() != null && getHiddenColumns().contains(field.getPropertyName())) {
                             tableToolsColumnOptions.append("{"
                                     + UifConstants.TableToolsKeys.VISIBLE
                                     + ": "
                                     + UifConstants.TableToolsValues.FALSE
                                     + ", "
                                     + mDataOption
                                     + "\""
                                     + UifConstants.TableToolsKeys.TARGETS
                                     + "\": ["
                                     + columnIndex
                                     + "]"
                                     + "}, ");
                             // if sortableColumns is present and a field is marked as sortable or unspecified
                         } else if (getSortableColumns() != null && !getSortableColumns().isEmpty()) {
                             if (getSortableColumns().contains(field.getPropertyName())) {
                                 tableToolsColumnOptions.append(getDataFieldColumnOptions(columnIndex, collectionGroup,
                                         field) + ", ");
                             } else {
                                 tableToolsColumnOptions.append("{'"
                                         + UifConstants.TableToolsKeys.SORTABLE
                                         + "': "
                                         + UifConstants.TableToolsValues.FALSE
                                         + ", "
                                         + mDataOption
                                         + "\""
                                         + UifConstants.TableToolsKeys.TARGETS
                                         + "\": ["
                                         + columnIndex
                                         + "]"
                                         + "}, ");
                             }
                         } else {// sortable columns not defined
                             String colOptions = getDataFieldColumnOptions(columnIndex, collectionGroup, field);
                             tableToolsColumnOptions.append(colOptions + " , ");
                         }
                         columnIndex++;
                     } else if (component instanceof MessageField && component.getDataAttributes().get(
                             UifConstants.DataAttributes.ROLE) != null && component.getDataAttributes().get(
                             UifConstants.DataAttributes.ROLE).equals(UifConstants.RoleTypes.ROW_GROUPING)) {
                         //Grouping column is never shown, so skip
                         tableToolsColumnOptions.append("{"
                                 + UifConstants.TableToolsKeys.VISIBLE
                                 + ": "
                                 + UifConstants.TableToolsValues.FALSE
                                 + ", "
                                 + mDataOption
                                 + "\""
                                 + UifConstants.TableToolsKeys.TARGETS
                                 + "\": ["
                                 + columnIndex
                                 + "]"
                                 + "}, ");
                         columnIndex++;
                     } else if (component instanceof LinkField) {
                         String colOptions = constructTableColumnOptions(columnIndex, true, isUseServerPaging,
                                 String.class, UifConstants.TableToolsValues.DOM_TEXT);
                         tableToolsColumnOptions.append(colOptions + " , ");
                         columnIndex++;
                     } else {
                         String colOptions = constructTableColumnOptions(columnIndex, false, isUseServerPaging, null,
                                 null);
                         tableToolsColumnOptions.append(colOptions + " , ");
                         columnIndex++;
                     }
                 }
 
                 if (actionFieldVisible && (actionIndex == -1 || actionIndex >= columnIndex)) {
                     String actionColOptions = constructTableColumnOptions(columnIndex, false, isUseServerPaging, null,
                             null);
                     tableToolsColumnOptions.append(actionColOptions);
                 } else {
                     tableToolsColumnOptions = new StringBuffer(StringUtils.removeEnd(tableToolsColumnOptions.toString(),
                             ", "));
                 }
 
                 //merge the aoColumnDefs passed in
                 if (!StringUtils.isEmpty(getTemplateOptions().get(UifConstants.TableToolsKeys.AO_COLUMN_DEFS))) {
                     String origAoOptions = getTemplateOptions().get(UifConstants.TableToolsKeys.AO_COLUMN_DEFS).trim();
                     origAoOptions = StringUtils.removeStart(origAoOptions, "[");
                     origAoOptions = StringUtils.removeEnd(origAoOptions, "]");
                     tableToolsColumnOptions.append("," + origAoOptions);
                 }
 
                 tableToolsColumnOptions.append("]");
                 getTemplateOptions().put(UifConstants.TableToolsKeys.AO_COLUMN_DEFS,
                         tableToolsColumnOptions.toString());
             }
         }
     }
 
     /**
      * Construct the column options for a data field
      *
      * @param collectionGroup the collectionGroup in which the data field is defined
      * @param field the field to construction options for
      * @return options as valid for datatable
      */
     protected String getDataFieldColumnOptions(int target, CollectionGroup collectionGroup, DataField field) {
         String sortType = null;
 
         if (!collectionGroup.isReadOnly()
                 && (field instanceof InputField)
                 && ((InputField) field).getControl() != null) {
             Control control = ((InputField) field).getControl();
             if (control instanceof SelectControl) {
                 sortType = UifConstants.TableToolsValues.DOM_SELECT;
             } else if (control instanceof CheckboxControl || control instanceof CheckboxGroupControl) {
                 sortType = UifConstants.TableToolsValues.DOM_CHECK;
             } else if (control instanceof RadioGroupControl) {
                 sortType = UifConstants.TableToolsValues.DOM_RADIO;
             } else {
                 sortType = UifConstants.TableToolsValues.DOM_TEXT;
             }
         } else {
             sortType = UifConstants.TableToolsValues.DOM_TEXT;
         }
 
         Class dataTypeClass = ObjectPropertyUtils.getPropertyType(collectionGroup.getCollectionObjectClass(),
                 field.getPropertyName());
 
         boolean isSortable = true;
         if (field.isApplyMask()) {
             isSortable = false;
         }
 
         return constructTableColumnOptions(target, isSortable, collectionGroup.isUseServerPaging(), dataTypeClass,
                 sortType);
     }
 
     /**
      * Constructs the sort data type for each data table columns in a format that will be used to initialize the data
      * table widget via javascript
      *
      * @param target the column index
      * @param isSortable whether a column should be marked as sortable
      * @param isUseServerPaging is server side paging enabled?
      * @param dataTypeClass the class type of the column value - used determine the sType option - which identifies
      * the search plugin to use
      * @param sortDataType Defines a data source type for the sorting which can be used to read realtime information
      * from the table
      * @return a formatted string with data table options for one column
      */
     public String constructTableColumnOptions(int target, boolean isSortable, boolean isUseServerPaging,
             Class dataTypeClass, String sortDataType) {
         String colOptions = "null";
 
         String sortType = "";
         if (!isSortable || dataTypeClass == null || sortType == null) {
             colOptions = "\"" + UifConstants.TableToolsKeys.SORTABLE + "\" : false, \"sType\" : \"string\"";
         } else {
             if (ClassUtils.isAssignable(dataTypeClass, KualiPercent.class)) {
                 sortType = UifConstants.TableToolsValues.PERCENT;
             } else if (ClassUtils.isAssignable(dataTypeClass, KualiInteger.class) || ClassUtils.isAssignable(
                     dataTypeClass, KualiDecimal.class)) {
                 sortType = UifConstants.TableToolsValues.CURRENCY;
             } else if (ClassUtils.isAssignable(dataTypeClass, Timestamp.class)) {
                 sortType = "date";
             } else if (ClassUtils.isAssignable(dataTypeClass, java.sql.Date.class) || ClassUtils.isAssignable(
                     dataTypeClass, java.util.Date.class)) {
                 sortType = UifConstants.TableToolsValues.DATE;
             } else if (ClassUtils.isAssignable(dataTypeClass, Number.class)) {
                 sortType = UifConstants.TableToolsValues.NUMERIC;
             } else {
                 sortType = UifConstants.TableToolsValues.STRING;
             }
 
             colOptions = "\"" + UifConstants.TableToolsKeys.SORT_TYPE + "\" : \"" + sortType + "\"";
 
             if (!isUseServerPaging && !this.forceLocalJsonData) {
                 colOptions += ", \"" + UifConstants.TableToolsKeys.SORT_DATA_TYPE + "\" : \"" + sortDataType + "\"";
             }
         }
 
         if (target < cellCssClasses.size() && target >= 0) {
             colOptions += ", \""
                     + UifConstants.TableToolsKeys.CELL_CLASS
                     + "\" : \""
                     + cellCssClasses.get(target)
                     + "\"";
         }
 
         // only use the mDataProp when using json data (only relevant for this table type)
         if (isUseServerPaging || this.forceLocalJsonData) {
             colOptions += ", \"" + UifConstants.TableToolsKeys.MDATA +
                     "\" : function(row,type,newVal){ return _handleColData(row,type,'c" + target + "',newVal);}";
         }
 
         if (!colOptions.equals("null")) {
             colOptions = "{" + colOptions + ", \"" + UifConstants.TableToolsKeys.TARGETS + "\": [" + target + "]}";
         } else {
             colOptions = "{" + colOptions + "}";
         }
 
         return colOptions;
     }
 
     /**
      * Returns the text which is used to display text when the table is empty
      *
      * @return empty table message
      */
     @BeanTagAttribute(name = "emptyTableMessage")
     public String getEmptyTableMessage() {
         return emptyTableMessage;
     }
 
     /**
      * Setter for a text to be displayed when the table is empty
      *
      * @param emptyTableMessage
      */
     public void setEmptyTableMessage(String emptyTableMessage) {
         this.emptyTableMessage = emptyTableMessage;
     }
 
     /**
      * Returns true if sorting is disabled
      *
      * @return the disableTableSort
      */
     @BeanTagAttribute(name = "disableTableSort")
     public boolean isDisableTableSort() {
         return this.disableTableSort;
     }
 
     /**
      * Enables/disables the table sorting
      *
      * @param disableTableSort the disableTableSort to set
      */
     public void setDisableTableSort(boolean disableTableSort) {
         this.disableTableSort = disableTableSort;
     }
 
     /**
      * Returns true if search and export options are enabled
      *
      * @return the showSearchAndExportOptions
      */
     @BeanTagAttribute(name = "showSearchAndExportOptions")
     public boolean isShowSearchAndExportOptions() {
         return this.showSearchAndExportOptions;
     }
 
     /**
      * Returns true if search option is enabled
      *
      * @return the showSearchOption
      */
     @BeanTagAttribute(name = "showSearchOption")
     public boolean isShowSearchOption() {
         return this.showSearchOption;
     }
 
     /**
      * Returns true if export option is enabled
      *
      * @return the showExportOption
      */
     @BeanTagAttribute(name = "showExportOption")
     public boolean isShowExportOption() {
         return this.showExportOption;
     }
 
     /**
      * Show/Hide the search and export options in tabletools.  This option supercedes
      * the individual 'show search' option and 'show export' option
      *
      * @param showSearchAndExportOptions the showSearchAndExportOptions to set
      */
     public void setShowSearchAndExportOptions(boolean showSearchAndExportOptions) {
         this.showSearchAndExportOptions = showSearchAndExportOptions;
     }
 
     /**
      * Show/Hide the search option in tabletools
      *
      * @param showSearchOption the showSearchOptions to set
      */
     public void setShowSearchOption(boolean showSearchOption) {
         this.showSearchOption = showSearchOption;
     }
 
     /**
      * Show/Hide the search and export option in tabletools
      *
      * @param showExportOption the showExportOptions to set
      */
     public void setShowExportOption(boolean showExportOption) {
         this.showExportOption = showExportOption;
     }
 
     /**
      * Holds propertyNames for the ones meant to be hidden since columns are visible by default
      *
      * <p>Duplicate entries are ignored and the order of entries is not significant</p>
      *
      * @return a set with propertyNames of columns to be hidden
      */
     @BeanTagAttribute(name = "hiddenColumns", type = BeanTagAttribute.AttributeType.SETVALUE)
     public Set<String> getHiddenColumns() {
         return hiddenColumns;
     }
 
     /**
      * Setter for the hidden columns set
      *
      * @param hiddenColumns a set containing propertyNames
      */
     public void setHiddenColumns(Set<String> hiddenColumns) {
         this.hiddenColumns = hiddenColumns;
     }
 
     /**
      * Holds the propertyNames for columns that are to be sorted
      *
      * <p>Duplicate entries are ignored and the order of entries is not significant</p>
      *
      * @return a set of propertyNames with for columns that will be sorted
      */
     @BeanTagAttribute(name = "sortableColumns", type = BeanTagAttribute.AttributeType.SETVALUE)
     public Set<String> getSortableColumns() {
         return sortableColumns;
     }
 
     /**
      * Setter for sortable columns
      *
      * @param sortableColumns a set containing propertyNames of columns to be sorted
      */
     public void setSortableColumns(Set<String> sortableColumns) {
         this.sortableColumns = sortableColumns;
     }
 
     /**
      * Specifies a URL for acquiring the table data with ajax
      *
      * <p>
      * When the ajax source URL is specified the rich table plugin will retrieve the data by invoking the URL and
      * building the table rows from the result. This is different from the standard use of the rich table plugin
      * with uses progressive enhancement to decorate a table that has already been rendereed
      * </p>
      *
      * @return URL for ajax source
      */
     @BeanTagAttribute(name = "ajaxSource")
     public String getAjaxSource() {
         return ajaxSource;
     }
 
     /**
      * Setter for the Ajax source URL
      *
      * @param ajaxSource
      */
     public void setAjaxSource(String ajaxSource) {
         this.ajaxSource = ajaxSource;
     }
 
     /**
      * Get groupingOption
      *
      * @return
      */
     public String getGroupingOptionsJSString() {
         return groupingOptionsJSString;
     }
 
     /**
      * Set the groupingOptions js data.  <b>This should not be set through XML configuration.</b>
      *
      * @param groupingOptionsJSString
      */
     public void setGroupingOptionsJSString(String groupingOptionsJSString) {
         this.groupingOptionsJSString = groupingOptionsJSString;
     }
 
     /**
      * If set to true and the aoColumnDefs template option is explicitly defined in templateOptions, those aoColumnDefs
      * will be used for this table.  Otherwise, if false, the aoColumnDefs will attempt to be merged with those that
      * are automatically generated by RichTable
      *
      * @return true if the aoColumnDefs set will completely override those that are generated automatically by
      *         RichTable
      */
     public boolean isForceAoColumnDefsOverride() {
         return forceAoColumnDefsOverride;
     }
 
     /**
      * Set forceAoColumnDefsOverride
      *
      * @param forceAoColumnDefsOverride
      */
     public void setForceAoColumnDefsOverride(boolean forceAoColumnDefsOverride) {
         this.forceAoColumnDefsOverride = forceAoColumnDefsOverride;
     }
 
     /**
      * If true, the table will automatically use row JSON data generated by this widget
      *
      * <p>This forces the table backed by this RichTable to get its content from a template option called aaData.  This
      * will automatically skip row generation in the template, and cause
      * the table receive its data from the aaData template option automatically generated and set by this RichTable.
      * This allows the table to take advantage of the bDeferRender option (also automatically set to true)
      * when this table is a paged table (performance increase for tables that are more than one page).
      * Note: the CollectionGroup's isUseServerPaging flag will always override this functionality if it is also true.
      * </p>
      *
      * @return true if backed by the aaData option in JSON, that is generated during the ftl rendering process by
      *         this widget for this table
      */
     public boolean isForceLocalJsonData() {
         return forceLocalJsonData;
     }
 
     /**
      * Set the forceLocalJsonData flag to force this table to use generated row json data
      *
      * @param forceLocalJsonData
      */
     public void setForceLocalJsonData(boolean forceLocalJsonData) {
         this.forceLocalJsonData = forceLocalJsonData;
     }
 
     /**
      * The nestedLevel property represents how many collection tables deep this particular table is
      *
      * <p>This property must be manually set if the flag forceLocalJsonData is being used and the collection table this
      * RichTable represents is a subcollection of a TABLE collection (not stacked collection).  If this is true,
      * add 1 for each level deep (ex. subCollection would be 1, sub-subCollection would be 2).  If this property is
      * not set javascript errors will occur on the page, as this determines how deep to escape certain characters.</p>
      *
      * @return the nestedLevel representing the
      */
     public int getNestedLevel() {
         return nestedLevel;
     }
 
     /**
      * Set the nestedLevel for this table - must be set if using forceLocalJsonData and this is a subCollection of
      * a TableCollection (also using forceLocalJsonData)
      *
      * @param nestedLevel
      */
     public void setNestedLevel(int nestedLevel) {
         this.nestedLevel = nestedLevel;
     }
 
     /**
      * Get the translated aaData array generated by calls to addRowToTableData by the ftl
      *
      * <p>This data is in JSON format and expected to be consumed by datatables when utilizing the forceLocalJsonData
      * option.
      * This will be populated automatically if that flag is set to true.</p>
      *
      * @return the generated aaData
      */
     public String getAaData() {
         return aaData;
     }
 
     /**
      * Set the translated aaData array
      *
      * <p>This data is in JSON format and expected to be consumed by datatables when utilizing the forceLocalJsonData.
      * This setter is required for copyProperties()</p>
      *
      * @return the generated aaData
      */
     public void setAaData(String aaData) {
         this.aaData = aaData;
     }
 
     /**
      * Get the simple value as a string that represents the field's sortable value, to be used as val in the custom
      * uif json data object (accessed by mDataProp option on datatables - automated by framework) when using the
      * forceLocalJsonData option or the CollectionGroup's isUseServerPaging option
      *
      * @param model model the current model
      * @param field the field to retrieve a sortable value from for use in custom json data
      * @return the value as a String
      */
     public String getCellValue(Object model, Field field) {
         String value = KRADUtils.getSimpleFieldValue(model, field);
 
         if (value == null) {
             value = "null";
         } else {
             value = KRADConstants.QUOTE_PLACEHOLDER + value + KRADConstants.QUOTE_PLACEHOLDER;
         }
 
         return value;
     }
 
     /**
      * Add row content passed from table ftl to the aaData array by converting and escaping the content
      * to an object (in an array of objects) in JSON format
      *
      * <p>The data in aaData is expected to be consumed by a call by the datatables plugin using sAjaxSource or aaData.
      * The addRowToTableData generation call is additive must be made per a row in the ftl.</p>
      *
      * @param row the row of content with each cell content surrounded by the @quot@ token and followed by a comma
      */
     public void addRowToTableData(String row) {
         String escape = "";
 
         // if nestedLevel is set add the appropriate amount of escape characters per a level of nesting
         for (int i = 0; i < nestedLevel && forceLocalJsonData; i++) {
             escape = escape + "\\";
         }
 
         // remove newlines and replace quotes and single quotes with unicode characters
         row = row.trim().replace("\"", escape + "\\u0022").replace("'", escape + "\\u0027").replace("\n", "").replace(
                 "\r", "");
 
         // remove hanging comma
         row = StringUtils.removeEnd(row, ",");
 
         // replace all quote placeholders with actual quote characters
         row = row.replace(KRADConstants.QUOTE_PLACEHOLDER, "\"");
         row = "{" + row + "}";
 
         // if first call create aaData and force defer render option, otherwise append
         if (StringUtils.isBlank(aaData)) {
             aaData = "[" + row + "]";
 
             if (this.getTemplateOptions().get(UifConstants.TableToolsKeys.DEFER_RENDER) == null) {
                 //make sure deferred rendering is forced if not explicitly set
                 this.getTemplateOptions().put(UifConstants.TableToolsKeys.DEFER_RENDER,
                         UifConstants.TableToolsValues.TRUE);
             }
         } else if (StringUtils.isNotBlank(row)) {
             aaData = aaData.substring(0, aaData.length() - 1) + "," + row + "]";
         }
 
         //force json data use if forceLocalJsonData flag is set
         if (forceLocalJsonData) {
             this.getTemplateOptions().put(UifConstants.TableToolsKeys.AA_DATA, aaData);
         }
     }
 
     protected ConfigurationService getConfigurationService() {
         return CoreApiServiceLocator.getKualiConfigurationService();
     }
 
     /**
      * @see org.kuali.rice.krad.uif.component.ComponentBase#copy()
      */
     @Override
     protected <T> void copyProperties(T component) {
         super.copyProperties(component);
         RichTable richTableCopy = (RichTable) component;
         richTableCopy.setEmptyTableMessage(this.getEmptyTableMessage());
         richTableCopy.setDisableTableSort(this.isDisableTableSort());
         richTableCopy.setForceAoColumnDefsOverride(this.isForceAoColumnDefsOverride());
         richTableCopy.setForceLocalJsonData(this.isForceLocalJsonData());
         richTableCopy.setNestedLevel(this.getNestedLevel());
         richTableCopy.setAaData(this.getAaData());
 
         if (hiddenColumns != null) {
             richTableCopy.setHiddenColumns(new HashSet<String>(hiddenColumns));
         }
 
         if (sortableColumns != null) {
             richTableCopy.setSortableColumns(new HashSet<String>(sortableColumns));
         }
 
         if (cellCssClasses != null) {
             richTableCopy.setCssClasses(new ArrayList<String>(this.cellCssClasses));
         }
 
         richTableCopy.setAjaxSource(this.getAjaxSource());
         richTableCopy.setShowSearchAndExportOptions(this.isShowSearchAndExportOptions());
         richTableCopy.setShowSearchOption(this.isShowSearchOption());
         richTableCopy.setShowExportOption(this.isShowExportOption());
         richTableCopy.setGroupingOptionsJSString(this.getGroupingOptionsJSString());
     }
 }