org.efaps.esjp.accounting.report.ExpenseReport

Introduction

Here is the source code for org.efaps.esjp.accounting.report.ExpenseReport_Base.java
Source

/*
 * Copyright 2003 - 2015 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.
 *
 */

package org.efaps.esjp.accounting.report;

import java.util.List;

import org.efaps.admin.dbproperty.DBProperties;
import org.efaps.admin.event.Parameter;
import org.efaps.admin.program.esjp.EFapsApplication;
import org.efaps.admin.program.esjp.EFapsUUID;
import org.efaps.db.AttributeQuery;
import org.efaps.db.Instance;
import org.efaps.db.InstanceQuery;
import org.efaps.db.QueryBuilder;
import org.efaps.esjp.ci.CIAccounting;
import org.efaps.esjp.ci.CIERP;
import org.efaps.esjp.sales.report.SalesRecordReport;
import org.efaps.util.EFapsException;
import org.joda.time.DateTime;
import org.joda.time.format.DateTimeFormat;

/**
 * TODO comment!
 *
 * @author The eFaps Team
 */
@EFapsUUID("25cc9a9b-0cd9-49e4-ae2e-70540a6edead")
@EFapsApplication("eFapsApp-Accounting")
public abstract class ExpenseReport_Base extends SalesRecordReport {

    /**
     * Get the name for the report.
     * @param _parameter Parameter as passed form the eFaps API
     * @param _from fromdate
     * @param _to   to date
     * @return name of the report
     */
    protected String getReportName(final Parameter _parameter, final DateTime _from, final DateTime _to) {
        return DBProperties.getProperty("Accounting_ExpenseReport.Label", "es") + "-"
                + _from.toString(DateTimeFormat.shortDate()) + "-" + _to.toString(DateTimeFormat.shortDate());
    }

    /**
     * Gets the instances.
     *
     * @param _parameter Parameter as passed by the eFaps API
     * @param _from the from
     * @param _to the to
     * @return the instances
     * @throws EFapsException on error
     */
    protected List<Instance> getInstances(final Parameter _parameter, final DateTime _from, final DateTime _to)
            throws EFapsException {
        final QueryBuilder attrQuerBldr = new QueryBuilder(CIAccounting.Transaction2SalesDocument);
        final AttributeQuery attrQuery = attrQuerBldr
                .getAttributeQuery(CIAccounting.Transaction2SalesDocument.FromLink);

        final QueryBuilder queryBldr = new QueryBuilder(CIAccounting.TransactionAbstract);
        queryBldr.addWhereAttrInQuery(CIAccounting.TransactionAbstract.ID, attrQuery);
        queryBldr.addWhereAttrGreaterValue(CIERP.DocumentAbstract.Date, _from.minusMinutes(1));
        queryBldr.addWhereAttrLessValue(CIERP.DocumentAbstract.Date, _to.plusDays(1));
        queryBldr.addWhereAttrEqValue(CIAccounting.TransactionAbstract.PeriodLink,
                _parameter.getInstance().getId());
        final InstanceQuery query = queryBldr.getQuery();
        query.execute();
        return query.getValues();
    }
}
org.efaps.esjp.accounting.report.ExpenseReport_Base.java Source code

Introduction

Source
