Package com.projity.algorithm

Examples of com.projity.algorithm.SelectFrom


    return null;
  }


  public void calcDataBetween(Object type, long start, long end) {
    SelectFrom clause = SelectFrom.getInstance().whereInRange(start,end); // automatically also adds a generator to limit range
    AssignmentFieldFunctor dataFunctor = getDataSelect(type,clause,false);

    RangeIntervalGenerator dailyInRange = RangeIntervalGenerator.getInstance(start, end, 1000*60*60*24);
    PrintValueFunctor print = PrintValueFunctor.getInstance(dataFunctor);
    Query.getInstance().selectFrom(clause)
View Full Code Here


  /**
   * Calculate the total cost
   * @return
   */
  public double calcAll(Object type) {
    SelectFrom clause = SelectFrom.getInstance();
    AssignmentFieldFunctor dataFunctor = getDataSelect(type,clause,true);
    Query.getInstance().selectFrom(clause)
    .execute();
    return dataFunctor.getValue();
  }
View Full Code Here

//    .action(actionVisitor)
//    .execute();
//  }

  public void buildReverseQuery(ReverseQuery reverseQuery) {
    SelectFrom clause = SelectFrom.getInstance();
    reverseQuery.addField(getDataSelect(reverseQuery.getType(),clause,false));
    reverseQuery.addGroupBy(IntervalGeneratorSet.extractUnshared(clause.getFromIntervalGenerators()));
    reverseQuery.addSelectFrom(clause);
  }
View Full Code Here

   * @param type
   * @param value
   * @return
   */
  public long getDateAtValue(Object type, double value) {
    SelectFrom clause = SelectFrom.getInstance();
    AssignmentFieldFunctor dataFunctor = (type==COST) ? cost(clause, true) : work(clause);

    DateAtValueFunctor dateAtValue = DateAtValueFunctor.getInstance(value, AssignmentFieldClosureCollection.getInstance(dataFunctor));
    clause.select(dateAtValue); // override existing select

    Query.getInstance().selectFrom(clause)
    .execute();
    return dateAtValue.getDate();
  }
View Full Code Here

  //Costs and earned value
  public double acwp(long start, long end) {
    if (!isInRange(start,end))
      return NO_VALUE_DOUBLE;
    Query query = Query.getInstance();
    SelectFrom clause = SelectFrom.getInstance().whereInRange(Math.max(start,detail.effectiveBaselineStart()),Math.min(end,getCompletedOrStatusDate()));
    query.selectFrom(clause)
      .action(cost(clause,false))
      .execute();
    return ((DoubleValue)query.getActionVisitor()).getValue();
  }
View Full Code Here

    if (AdvancedOption.getInstance().isEarnedValueFieldsCumulative())
      start = getStart(); // start from the beginning of the task and ignore the range start

    Query query = Query.getInstance();
    SelectFrom clause = SelectFrom.getInstance().whereInRange(Math.max(start,detail.effectiveBaselineStart()),Math.min(end,getStatusDate()));
    query.selectFrom(clause)
      .action(baselineData(COST,clause))
      .execute();
    return ((DoubleValue)query.getActionVisitor()).getValue();
  }
View Full Code Here

  public double bac(long start, long end) {
    if (!isInRange(start,end))
      return NO_VALUE_DOUBLE;
    Query query = Query.getInstance();
    SelectFrom clause = SelectFrom.getInstance().whereInRange(start,end);
    query.selectFrom(clause)
      .action(baselineData(COST,clause))
      .execute();
    return ((DoubleValue)query.getActionVisitor()).getValue();
  }
View Full Code Here

  public double cost(long start, long end) {
    if (!isInRange(start,end))
      return NO_VALUE_DOUBLE;
    Query query = Query.getInstance();
    SelectFrom clause = SelectFrom.getInstance().whereInRange(start,end);
    query.selectFrom(clause)
      .action(cost(clause,false))
      .execute();
    return ((DoubleValue)query.getActionVisitor()).getValue();
  }
View Full Code Here

    if (!isInRange(start,end))
      return NO_VALUE_LONG;
//    if (!isLabor()) // TODO this right?
//      return 0;
    Query query = Query.getInstance();
    SelectFrom clause = SelectFrom.getInstance().whereInRange(start,end);
    query.selectFrom(clause)
      .action(work(clause))
      .execute();
    return (long) ((DoubleValue)query.getActionVisitor()).getValue();
View Full Code Here

  public double actualCost(long start, long end) {
    if (!isInRange(start,end))
      return NO_VALUE_DOUBLE;

    Query query = Query.getInstance();
    SelectFrom clause = SelectFrom.getInstance().whereInRange(Math.max(start,detail.getStart()),Math.min(end,getStop()));
    query.selectFrom(clause)
      .action(cost(clause,false))
      .execute();
    return ((DoubleValue)query.getActionVisitor()).getValue();
  }
View Full Code Here

TOP

Related Classes of com.projity.algorithm.SelectFrom

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.