org.efaps.eql.JSONData Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of efaps-kernel Show documentation
eFaps is a framework used to map objects with or without attached files to a relational database and optional file systems (only for attaches files). Configurable access control can be provided down to object and attribute level depending on implementation and use case. Depending on requirements, events (like triggers) allow to implement business logic and to separate business logic from user interface. The framework includes integrations (e.g. webdav, full text search) and a web application as 'simple' configurable user interface. Some best practises, example web application modules (e.g. team work module) support administrators and implementers using this framework.
The newest version!
/*
 * Copyright 2003 - 2014 The eFaps Team
 *
 * Licensed under the Apache 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.apache.org/licenses/LICENSE-2.0
 *
 * 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.
 *
 * Revision:        $Rev$
 * Last Changed:    $Date$
 * Last Changed By: $Author$
 */

package org.efaps.eql;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.UUID;

import org.apache.commons.collections4.comparators.ComparatorChain;
import org.apache.commons.lang3.ObjectUtils;
import org.apache.commons.lang3.StringUtils;
import org.efaps.admin.datamodel.IBitEnum;
import org.efaps.admin.program.esjp.EFapsClassLoader;
import org.efaps.db.MultiPrintQuery;
import org.efaps.json.data.AbstractValue;
import org.efaps.json.data.BooleanValue;
import org.efaps.json.data.DataList;
import org.efaps.json.data.DateTimeValue;
import org.efaps.json.data.DecimalValue;
import org.efaps.json.data.LongValue;
import org.efaps.json.data.NullValue;
import org.efaps.json.data.ObjectData;
import org.efaps.json.data.StringListValue;
import org.efaps.json.data.StringValue;
import org.efaps.json.data.UUIDValue;
import org.efaps.util.EFapsException;
import org.joda.time.DateTime;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 * TODO comment!
 *
 * @author The eFaps Team
 * @version $Id$
 */
public class JSONData
{
    /**
     * Logging instance used in this class.
     */
    private static final Logger LOG = LoggerFactory.getLogger(JSONData.class);

    /**
     * @param _statement Statement the datalist will be created for
     * @return a DataList
     * @throws EFapsException on error
     */
    public static DataList getDataList(final Statement _statement)
        throws EFapsException
    {
        DataList ret = new DataList();
        final Map mapping = _statement.getAlias2Selects();
        if (_statement.isEsjp()) {
            try {
                  final Class clazz = Class.forName(_statement.getEsjp(), false, EFapsClassLoader.getInstance());
                  final IEsjpExecute esjp = (IEsjpExecute) clazz.newInstance();
                  LOG.debug("Instantiated class: {}", esjp);
                  final List parameters = _statement.getParameters();
                  if (parameters.isEmpty()) {
                      ret = esjp.execute(mapping);
                  } else {
                      ret = esjp.execute(mapping, parameters.toArray(new String[parameters.size()]));
                  }
            } catch (ClassNotFoundException | InstantiationException | IllegalAccessException e) {
                LOG.error("Could not invoke IEsjpQuery.", e);
                throw new EFapsException("Could not invoke IEsjpQuery.", e);
            }
        } else {
            final MultiPrintQuery multi = _statement.getMultiPrint();
            multi.execute();
            while (multi.next()) {
                final ObjectData data = new ObjectData();
                for (final Entry entry : mapping.entrySet()) {
                    final Object obj = multi.getSelect(entry.getValue());
                    data.getValues().add(getValue(entry.getKey(), obj));
                }
                ret.add(data);
            }
        }
        final Map sortMap = _statement.getSortKey2ascDesc();
        if (!sortMap.isEmpty()) {
            final ComparatorChain comparator = new ComparatorChain<>();
            for (final Entry entry : sortMap.entrySet()) {
                AbstractValue sortVal = null;
                if (StringUtils.isNumeric(entry.getKey())) {
                    final int idx = Integer.parseInt(entry.getKey());
                    sortVal = ret.get(0).getValues().get(idx -1);
                } else {
                    for (final AbstractValue val : ret.get(0).getValues()) {
                        if (val.getKey().equals(entry.getKey())) {
                            sortVal = val;
                            break;
                        }
                    }
                }
                comparator.addComparator(new ObjectDataComparator(sortVal, entry.getValue()));
            }
            Collections.sort(ret, comparator);
        }
        return ret;
    }

    /**
     * @param _key  key the value is wanted for
     * @param _object oebjct to be converted
     * @return AbstractValue for the key
     */
    @SuppressWarnings("unchecked")
    public static AbstractValue getValue(final String _key,
                                            final Object _object)
    {
        AbstractValue ret = null;
        if (_object instanceof String) {
            ret = new StringValue().setValue((String) _object);
        } else if (_object instanceof BigDecimal) {
            ret = new DecimalValue().setValue((BigDecimal) _object);
        } else if (_object instanceof Long) {
            ret = new LongValue().setValue((Long) _object);
        } else if (_object instanceof DateTime) {
            ret = new DateTimeValue().setValue((DateTime) _object);
        } else if (_object instanceof UUID) {
            ret = new UUIDValue().setValue((UUID) _object);
        } else if (_object instanceof Boolean) {
            ret = new BooleanValue().setValue((Boolean) _object);
        } else if (_object instanceof List) {
            final List list = (List) _object;
            if (!list.isEmpty()) {
                final Object inner = list.get(0);
                if (inner instanceof String) {
                    ret = new StringListValue().setValue((List) list);
                } else if (inner instanceof IBitEnum) {
                    final List tmpList = new ArrayList<>();
                    for (final Object obj  : list) {
                        tmpList.add(obj.toString());
                    }
                    ret = new StringListValue().setValue(tmpList);
                }
            }
        } else if (_object != null) {
            ret = new StringValue().setValue(_object.toString());
        } else {
            ret = new NullValue();
        }
        if (ret != null) {
            ret.setKey(_key);
        }
        return ret;
    }


    public static class ObjectDataComparator
        implements Comparator
    {

        private final AbstractValue sortVal;
        private final boolean asc;

        /**
         * @param _sortVal
         */
        public ObjectDataComparator(final AbstractValue _sortVal,
                                    final boolean _asc)
        {
            this.sortVal = _sortVal;
            this.asc = _asc;
        }

        @Override
        public int compare(final ObjectData _o1,
                           final ObjectData _o2)
        {
            int ret = 0;
            final Object data1 = isAsc() ? getValue(_o1) : getValue(_o2);
            final Object data2 = isAsc() ? getValue(_o2) : getValue(_o1);
            if (data1 == null && data2 != null && data2 instanceof Comparable
                            || data2 == null && data1 != null && data1 instanceof Comparable
                            || data1 != null && data1 instanceof Comparable && data2 != null
                            && data2 instanceof Comparable) {
                ret = ObjectUtils.compare((Comparable) data1, (Comparable) data2);
            }
            return ret;
        }

        protected Object getValue(final ObjectData _data)
        {
            Object ret = null;
            for (final AbstractValue val : _data.getValues()) {
                if (val.getKey().equals(getSortVal().getKey())) {
                    ret = val.getValue();
                    break;
                }
            }
            return ret;
        }

        /**
         * Getter method for the instance variable {@link #sortVal}.
         *
         * @return value of instance variable {@link #sortVal}
         */
        public AbstractValue getSortVal()
        {
            return this.sortVal;
        }

        /**
         * Getter method for the instance variable {@link #asc}.
         *
         * @return value of instance variable {@link #asc}
         */
        public Boolean isAsc()
        {
            return this.asc;
        }

    }
}