org.efaps.db.print.GenInstSelectPart Maven / Gradle / Ivy

Go to download
/*
 * Copyright 2003 - 2012 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: 7483 $
 * Last Changed:    $Date: 2012-05-11 11:57:38 -0500 (Fri, 11 May 2012) $
 * Last Changed By: $Author: [email protected] $
 */


package org.efaps.db.print;

import org.efaps.admin.datamodel.Type;
import org.efaps.db.GeneralInstance;
import org.efaps.db.wrapper.SQLPart;
import org.efaps.db.wrapper.SQLSelect;


/**
 * TODO comment!
 *
 * @author The eFaps Team
 * @version $Id: GenInstSelectPart.java 7483 2012-05-11 16:57:38Z [email protected] $
 */
public class GenInstSelectPart
    extends AbstractSelectPart
{
    /**
     * Type the General Instance belongs to.
     */
    private final Type type;

    /**
     * Index of the GernalInstance table.
     */
    private Integer tableIdx;

    /**
     * Add the type clause.
     */
    private boolean addTypeClause = false;

    /**
     * @param _type Type the General Instance belongs to
     */
    public GenInstSelectPart(final Type _type)
    {
        this.type = _type;
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public int join(final OneSelect _oneSelect,
                    final SQLSelect _select,
                    final int _relIndex)
    {
        this.tableIdx = _oneSelect.getTableIndex(GeneralInstance.TABLENAME,
                        GeneralInstance.ISIDCOLUMN + "_" + GeneralInstance.ISTYPECOLUMN, _relIndex);
        if (this.tableIdx == null) {
            this.tableIdx = _oneSelect.getNewTableIndex(GeneralInstance.TABLENAME,
                            GeneralInstance.ISIDCOLUMN + "_" + GeneralInstance.ISTYPECOLUMN, _relIndex);
            if (getType().getMainTable().getSqlColType() != null) {
                _select.leftJoin(GeneralInstance.TABLENAME, this.tableIdx,
                                new String[] {GeneralInstance.ISIDCOLUMN, GeneralInstance.ISTYPECOLUMN},
                                _relIndex, new String[] {"ID", getType().getMainTable().getSqlColType()});
            } else {
                _select.leftJoin(GeneralInstance.TABLENAME, this.tableIdx, GeneralInstance.ISIDCOLUMN, _relIndex, "ID");
                this.addTypeClause = true;
            }
        }
        _select.column(this.tableIdx, "ID");
        return this.tableIdx;
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public Type getType()
    {
        return this.type;
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public void add2Where(final OneSelect _oneselect,
                          final SQLSelect _select)
    {
        if (this.addTypeClause) {
            _select.addPart(SQLPart.AND).addColumnPart(this.tableIdx, GeneralInstance.ISTYPECOLUMN)
                .addPart(SQLPart.IN).addPart(SQLPart.PARENTHESIS_OPEN);
            _select.addValuePart(this.type.getId());
            for (final Type childType : this.type.getChildTypes()) {
                _select.addPart(SQLPart.COMMA);
                _select.addValuePart(childType.getId());
            }
            _select.addPart(SQLPart.PARENTHESIS_CLOSE);
        }
    }
}