Example usage for org.joda.time DateTime minusMinutes

List of usage examples for org.joda.time DateTime minusMinutes

  1. HOME
  2. Java
  3. org.joda.time
  4. org.joda.time.*
  5. DateTime
  6. minusMinutes

Introduction

In this page you can find the example usage for org.joda.time DateTime minusMinutes.

Prototype

public DateTime minusMinutes(int minutes)

Source Link

Document

Returns a copy of this datetime minus the specified number of minutes.

Usage

From source file:org.efaps.admin.user.Person.java

License:Apache License

/**
 * Method that sets the time and the number of failed logins.
 *
 * @param _logintry time of the false Login
 * @param _count number of tries/*  w  w  w . ja v  a2  s .  c om*/
 * @throws EFapsException on error
 */
private void setFalseLogin(final DateTime _logintry, final int _count) throws EFapsException {
    if (_count > 0) {
        final DateTime now = new DateTime(DateTimeUtil.getCurrentTimeFromDB().getTime());
        final SystemConfiguration kernelConfig = EFapsSystemConfiguration.get();

        final int minutes = kernelConfig.getAttributeValueAsInteger(KernelSettings.LOGIN_TIME_RETRY);

        final int maxtries = kernelConfig.getAttributeValueAsInteger(KernelSettings.LOGIN_MAX_TRIES);

        final int count = _count + 1;
        if (minutes > 0 && _logintry.minusMinutes(minutes).isBefore(now)) {
            updateFalseLoginDB(1);
        } else {
            updateFalseLoginDB(count);
        }
        if (maxtries > 0 && count > maxtries && getStatus()) {
            setStatusInDB(false);
        }
    } else {
        updateFalseLoginDB(1);
    }
}

From source file:org.efaps.esjp.accounting.Period_Base.java

License:Apache License

/**
 * Called from a tree menu command to present the documents related with
 * stock movement that are not connected with the period and therefor
 * must be worked on still./*from  www.  j av  a2s. c  om*/
 *
 * @param _parameter Paremeter
 * @return List if Instances
 * @throws EFapsException on error
 */
public Return getStockToBook(final Parameter _parameter) throws EFapsException {
    final Return ret = new Return();
    final Instance instance = _parameter.getInstance();
    final PrintQuery print = new PrintQuery(instance);
    print.addAttribute(CIAccounting.Period.FromDate);
    print.addAttribute(CIAccounting.Period.ToDate);
    print.execute();
    final DateTime from = print.<DateTime>getAttribute(CIAccounting.Period.FromDate);
    final DateTime to = print.<DateTime>getAttribute(CIAccounting.Period.ToDate);

    final QueryBuilder attrQueryBldr = new QueryBuilder(CIAccounting.Transaction2SalesDocument);
    final AttributeQuery attrQuery = attrQueryBldr
            .getAttributeQuery(CIAccounting.Transaction2SalesDocument.ToLink);

    final QueryBuilder queryBldr = new QueryBuilder(CISales.DocumentStockAbstract);
    queryBldr.addWhereAttrEqValue(CISales.DocumentStockAbstract.StatusAbstract,
            Status.find(CISales.DeliveryNoteStatus.Closed), Status.find(CISales.ReturnSlipStatus.Closed));
    queryBldr.addWhereAttrGreaterValue(CISales.DocumentStockAbstract.Date, from.minusMinutes(1));
    queryBldr.addWhereAttrLessValue(CISales.DocumentStockAbstract.Date, to.plusDays(1));
    queryBldr.addWhereAttrNotInQuery(CISales.DocumentStockAbstract.ID, attrQuery);

    final IFilterList filterlist = (IFilterList) _parameter.get(ParameterValues.OTHERS);
    final DocMulti multi = new DocMulti();
    multi.analyzeTable(_parameter, filterlist, queryBldr, CISales.DocumentStockAbstract.getType());

    final InstanceQuery query = queryBldr.getQuery();
    final List<Instance> instances = query.execute();
    ret.put(ReturnValues.VALUES, instances);
    return ret;
}

From source file:org.efaps.esjp.accounting.Period_Base.java

License:Apache License

/**
 * @param _parameter Paremeter/*from w  w w  .j  a v a2 s .  co m*/
 * @return List if Instances
 * @throws EFapsException on error
 */
public Return getFundsToBeSettled(final Parameter _parameter) throws EFapsException {
    final MultiPrint multi = new MultiPrint() {

        @Override
        protected void add2QueryBldr(final Parameter _parameter, final QueryBuilder _queryBldr)
                throws EFapsException {
            final Instance instance = _parameter.getInstance();
            final PrintQuery print = new CachedPrintQuery(instance, Period_Base.CACHEKEY);
            print.addAttribute(CIAccounting.Period.FromDate);
            print.execute();
            final DateTime from = print.<DateTime>getAttribute(CIAccounting.Period.FromDate);
            _queryBldr.addWhereAttrGreaterValue(CISales.DocumentSumAbstract.Date, from.minusMinutes(1));

            final List<Status> statusArrayBalance = new ArrayList<>();

            final QueryBuilder queryBldr = new QueryBuilder(CISales.FundsToBeSettledBalance);
            if (containsProperty(_parameter, "FundsToBeSettledBalanceStatus")) {
                for (final String balanceStatus : analyseProperty(_parameter, "FundsToBeSettledBalanceStatus")
                        .values()) {
                    statusArrayBalance
                            .add(Status.find(CISales.FundsToBeSettledBalanceStatus.uuid, balanceStatus));
                }
            } else {
                statusArrayBalance.add(Status.find(CISales.FundsToBeSettledBalanceStatus.Verified));
            }
            if (!statusArrayBalance.isEmpty()) {
                queryBldr.addWhereAttrEqValue(CISales.FundsToBeSettledBalance.Status,
                        statusArrayBalance.toArray());
            }
            final AttributeQuery attrQuery = queryBldr.getAttributeQuery(CISales.FundsToBeSettledBalance.ID);

            final QueryBuilder queryBldr2 = new QueryBuilder(CISales.Document2DocumentAbstract);
            queryBldr2.addWhereAttrInQuery(CISales.Document2DocumentAbstract.FromAbstractLink, attrQuery);
            final AttributeQuery attrQuery2 = queryBldr2
                    .getAttributeQuery(CISales.Document2DocumentAbstract.ToAbstractLink);
            final QueryBuilder docTypeAttrQueryBldr = new QueryBuilder(CIERP.Document2DocumentTypeAbstract);
            docTypeAttrQueryBldr.addWhereAttrInQuery(CIERP.Document2DocumentTypeAbstract.DocumentLinkAbstract,
                    attrQuery2);
            final AttributeQuery docTypeAttrQuery = docTypeAttrQueryBldr
                    .getAttributeQuery(CIERP.Document2DocumentTypeAbstract.DocumentLinkAbstract);

            _queryBldr.addWhereAttrInQuery(CISales.DocumentSumAbstract.ID, docTypeAttrQuery);

            add2DocQueryBldr(_parameter, _queryBldr);
        }
    };
    return multi.execute(_parameter);
}

From source file:org.efaps.esjp.accounting.Period_Base.java

License:Apache License

/**
 * Called from a tree menu command to present the documents that are with status
 * booked and therefor must be worked on still.
 *
 * @param _parameter Paremeter/*from  www  . j a  va 2 s.  c  o m*/
 * @return List if Instances
 * @throws EFapsException on error
 */
public Return getPettyCashReceipt(final Parameter _parameter) throws EFapsException {
    final MultiPrint multi = new MultiPrint() {

        @Override
        protected void add2QueryBldr(final Parameter _parameter, final QueryBuilder _queryBldr)
                throws EFapsException {
            final Instance instance = _parameter.getInstance();
            final PrintQuery print = new CachedPrintQuery(instance, Period_Base.CACHEKEY);
            print.addAttribute(CIAccounting.Period.FromDate);
            print.execute();
            final DateTime from = print.<DateTime>getAttribute(CIAccounting.Period.FromDate);
            _queryBldr.addWhereAttrGreaterValue(CISales.DocumentSumAbstract.Date, from.minusMinutes(1));

            final List<Status> statusArrayBalance = new ArrayList<>();

            final QueryBuilder queryBldr = new QueryBuilder(CISales.PettyCashBalance);
            if (containsProperty(_parameter, "PettyCashBalanceStatus")) {
                for (final String balanceStatus : analyseProperty(_parameter, "PettyCashBalanceStatus")
                        .values()) {
                    statusArrayBalance.add(Status.find(CISales.PettyCashBalanceStatus.uuid, balanceStatus));
                }
            } else {
                statusArrayBalance.add(Status.find(CISales.PettyCashBalanceStatus.Verified));
            }
            if (!statusArrayBalance.isEmpty()) {
                queryBldr.addWhereAttrEqValue(CISales.PettyCashBalance.Status, statusArrayBalance.toArray());
            }
            final AttributeQuery attrQuery = queryBldr.getAttributeQuery(CISales.PettyCashBalance.ID);

            final QueryBuilder queryBldr2 = new QueryBuilder(CISales.Document2DocumentAbstract);
            queryBldr2.addWhereAttrInQuery(CISales.Document2DocumentAbstract.FromAbstractLink, attrQuery);
            final AttributeQuery attrQuery2 = queryBldr2
                    .getAttributeQuery(CISales.Document2DocumentAbstract.ToAbstractLink);
            final QueryBuilder docTypeAttrQueryBldr = new QueryBuilder(CIERP.Document2DocumentTypeAbstract);
            docTypeAttrQueryBldr.addWhereAttrInQuery(CIERP.Document2DocumentTypeAbstract.DocumentLinkAbstract,
                    attrQuery2);
            final AttributeQuery docTypeAttrQuery = docTypeAttrQueryBldr
                    .getAttributeQuery(CIERP.Document2DocumentTypeAbstract.DocumentLinkAbstract);

            _queryBldr.addWhereAttrInQuery(CISales.DocumentSumAbstract.ID, docTypeAttrQuery);

            add2DocQueryBldr(_parameter, _queryBldr);
        }
    };
    return multi.execute(_parameter);
}

From source file:org.efaps.esjp.accounting.Period_Base.java

License:Apache License

/**
 * Gets the undeductible.//from w ww. jav  a 2s .  com
 *
 * @param _parameter Parameter as passed by the eFaps API
 * @return the undeductible
 * @throws EFapsException on error
 */
public Return getUndeductible(final Parameter _parameter) throws EFapsException {
    final MultiPrint multi = new MultiPrint() {

        @Override
        protected void add2QueryBldr(final Parameter _parameter, final QueryBuilder _queryBldr)
                throws EFapsException {
            final Instance instance = _parameter.getInstance();
            final PrintQuery print = new CachedPrintQuery(instance, Period_Base.CACHEKEY);
            print.addAttribute(CIAccounting.Period.FromDate);
            print.execute();
            final DateTime from = print.<DateTime>getAttribute(CIAccounting.Period.FromDate);
            _queryBldr.addWhereAttrGreaterValue(CISales.DocumentSumAbstract.Date, from.minusMinutes(1));

            final List<Status> statusArrayBalance = new ArrayList<>();

            final QueryBuilder queryBldr = new QueryBuilder(CISales.PettyCashBalance);
            if (containsProperty(_parameter, "PettyCashBalanceStatus")) {
                for (final String balanceStatus : analyseProperty(_parameter, "PettyCashBalanceStatus")
                        .values()) {
                    statusArrayBalance.add(Status.find(CISales.PettyCashBalanceStatus.uuid, balanceStatus));
                }
            } else {
                statusArrayBalance.add(Status.find(CISales.PettyCashBalanceStatus.Verified));
            }
            if (!statusArrayBalance.isEmpty()) {
                queryBldr.addWhereAttrEqValue(CISales.PettyCashBalance.Status, statusArrayBalance.toArray());
            }
            final AttributeQuery attrQuery = queryBldr.getAttributeQuery(CISales.PettyCashBalance.ID);

            final QueryBuilder queryBldr2 = new QueryBuilder(CISales.Document2DocumentAbstract);
            queryBldr2.addWhereAttrInQuery(CISales.Document2DocumentAbstract.FromAbstractLink, attrQuery);
            _queryBldr.addWhereAttrInQuery(CISales.DocumentSumAbstract.ID,
                    queryBldr2.getAttributeQuery(CISales.Document2DocumentAbstract.ToAbstractLink));

            final QueryBuilder docTypeAttrQueryBldr = new QueryBuilder(CIERP.Document2DocumentTypeAbstract);
            final AttributeQuery docTypeAttrQuery = docTypeAttrQueryBldr
                    .getAttributeQuery(CIERP.Document2DocumentTypeAbstract.DocumentLinkAbstract);

            _queryBldr.addWhereAttrNotInQuery(CISales.DocumentSumAbstract.ID, docTypeAttrQuery);
        }
    };
    return multi.execute(_parameter);
}

From source file:org.efaps.esjp.accounting.report.ExpenseReport_Base.java

License:Apache License

/**
 * Gets the instances./*from  w  w  w .  j a v a 2s.c o  m*/
 *
 * @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();
}

From source file:org.efaps.esjp.accounting.SubPeriod_Base.java

License:Apache License

/**
 * Called from a tree menu command to present the documents that are not
 * included in accounting yet.//ww w  .jav  a 2  s  .  c o m
 *
 * @param _parameter Paremeter
 * @return List if Instances
 * @throws EFapsException on error
 */
public Return getDocuments(final Parameter _parameter) throws EFapsException {
    final MultiPrint multi = new MultiPrint() {
        @Override
        protected void add2QueryBldr(final Parameter _parameter, final QueryBuilder _queryBldr)
                throws EFapsException {
            final Instance instance = _parameter.getInstance();
            final PrintQuery print = new CachedPrintQuery(instance, SubPeriod_Base.CACHEKEY);
            print.addAttribute(CIAccounting.SubPeriod.FromDate);
            print.addAttribute(CIAccounting.SubPeriod.ToDate);
            print.execute();
            final DateTime from = print.<DateTime>getAttribute(CIAccounting.SubPeriod.FromDate);
            final DateTime to = print.<DateTime>getAttribute(CIAccounting.SubPeriod.ToDate);

            final QueryBuilder attrQueryBldr = new QueryBuilder(CIAccounting.Transaction2SalesDocument);
            final AttributeQuery attrQuery = attrQueryBldr
                    .getAttributeQuery(CIAccounting.Transaction2SalesDocument.ToLink);
            _queryBldr.addWhereAttrGreaterValue(CISales.DocumentSumAbstract.Date, from.minusMinutes(1));
            _queryBldr.addWhereAttrLessValue(CISales.DocumentSumAbstract.Date, to.plusDays(1));
            _queryBldr.addWhereAttrNotInQuery(CISales.DocumentSumAbstract.ID, attrQuery);
        }
    };
    return multi.execute(_parameter);
}

From source file:org.efaps.esjp.accounting.SubPeriod_Base.java

License:Apache License

/**
 * Called from a tree menu command to present the documents that are already
 * included in accounting./*www  .j a va  2s  .  c  om*/
 *
 * @param _parameter Paremeter
 * @return List if Instances
 * @throws EFapsException on error
 */
public Return getDocumentsToBook(final Parameter _parameter) throws EFapsException {
    final MultiPrint multi = new MultiPrint() {
        @Override
        protected void add2QueryBldr(final Parameter _parameter, final QueryBuilder _queryBldr)
                throws EFapsException {
            final Instance periodInst = new Period().evaluateCurrentPeriod(_parameter);
            final Instance instance = _parameter.getInstance();
            final PrintQuery print = new CachedPrintQuery(instance, SubPeriod_Base.CACHEKEY);
            print.addAttribute(CIAccounting.SubPeriod.FromDate);
            print.execute();
            final DateTime from = print.<DateTime>getAttribute(CIAccounting.SubPeriod.FromDate);

            final QueryBuilder transQueryBldr = new QueryBuilder(CIAccounting.Transaction);
            transQueryBldr.addWhereAttrEqValue(CIAccounting.Transaction.PeriodLink, periodInst);
            final AttributeQuery tranAttrQuery = transQueryBldr.getAttributeQuery(CIAccounting.Transaction.ID);

            final QueryBuilder attrQueryBldr = new QueryBuilder(CIAccounting.Transaction2SalesDocument);
            attrQueryBldr.addWhereAttrInQuery(CIAccounting.Transaction2SalesDocument.FromLink, tranAttrQuery);
            final AttributeQuery attrQuery = attrQueryBldr
                    .getAttributeQuery(CIAccounting.Transaction2SalesDocument.ToLink);
            _queryBldr.addWhereAttrInQuery(CISales.DocumentSumAbstract.ID, attrQuery);
            _queryBldr.addWhereAttrGreaterValue(CISales.DocumentSumAbstract.Date, from.minusMinutes(1));
        }
    };
    return multi.execute(_parameter);
}

From source file:org.efaps.esjp.accounting.SubPeriod_Base.java

License:Apache License

/**
 * Called from a tree menu command to present the documents that are with status
 * booked and therefor must be worked on still.
 *
 * @param _parameter Paremeter/*from   w  ww.j  av  a2 s. c o m*/
 * @return List if Instances
 * @throws EFapsException on error
 */
public Return getExternals(final Parameter _parameter) throws EFapsException {
    final MultiPrint multi = new MultiPrint() {
        @Override
        protected void add2QueryBldr(final Parameter _parameter, final QueryBuilder _queryBldr)
                throws EFapsException {
            final Instance instance = _parameter.getInstance();
            final PrintQuery print = new CachedPrintQuery(instance, SubPeriod_Base.CACHEKEY);
            print.addAttribute(CIAccounting.SubPeriod.FromDate);
            print.addAttribute(CIAccounting.SubPeriod.ToDate);
            print.execute();
            final DateTime from = print.<DateTime>getAttribute(CIAccounting.SubPeriod.FromDate);
            final DateTime to = print.<DateTime>getAttribute(CIAccounting.SubPeriod.ToDate);

            final QueryBuilder attrQueryBldr = new QueryBuilder(CIAccounting.Transaction2SalesDocument);
            final AttributeQuery attrQuery = attrQueryBldr
                    .getAttributeQuery(CIAccounting.Transaction2SalesDocument.ToLink);
            _queryBldr.addWhereAttrGreaterValue(CISales.DocumentSumAbstract.Date, from.minusMinutes(1));
            _queryBldr.addWhereAttrLessValue(CISales.DocumentSumAbstract.Date, to.plusDays(1));
            _queryBldr.addWhereAttrNotInQuery(CISales.DocumentSumAbstract.ID, attrQuery);
        }
    };
    return multi.execute(_parameter);
}

From source file:org.efaps.esjp.accounting.SubPeriod_Base.java

License:Apache License

/**
 * Called from a tree menu command to present the documents that are with status
 * booked and therefor must be worked on still.
 *
 * @param _parameter Paremeter/*from   www  . j a va2 s  .co  m*/
 * @return List if Instances
 * @throws EFapsException on error
 */
public Return getExternalsToBook(final Parameter _parameter) throws EFapsException {
    final MultiPrint multi = new MultiPrint() {
        @Override
        protected void add2QueryBldr(final Parameter _parameter, final QueryBuilder _queryBldr)
                throws EFapsException {
            final Instance periodInst = new Period().evaluateCurrentPeriod(_parameter);

            final PrintQuery print = new CachedPrintQuery(_parameter.getInstance(), SubPeriod_Base.CACHEKEY);
            print.addAttribute(CIAccounting.SubPeriod.FromDate);
            print.execute();
            final DateTime from = print.<DateTime>getAttribute(CIAccounting.SubPeriod.FromDate);

            final QueryBuilder transQueryBldr = new QueryBuilder(CIAccounting.Transaction);
            transQueryBldr.addWhereAttrEqValue(CIAccounting.Transaction.PeriodLink, periodInst);
            final AttributeQuery tranAttrQuery = transQueryBldr.getAttributeQuery(CIAccounting.Transaction.ID);

            final QueryBuilder attrQueryBldr = new QueryBuilder(CIAccounting.Transaction2SalesDocument);
            attrQueryBldr.addWhereAttrInQuery(CIAccounting.Transaction2SalesDocument.FromLink, tranAttrQuery);
            final AttributeQuery attrQuery = attrQueryBldr
                    .getAttributeQuery(CIAccounting.Transaction2SalesDocument.ToLink);

            _queryBldr.addWhereAttrInQuery(CISales.DocumentSumAbstract.ID, attrQuery);
            _queryBldr.addWhereAttrGreaterValue(CISales.DocumentSumAbstract.Date, from.minusMinutes(1));

        }
    };
    return multi.execute(_parameter);
}