Travailler avec des expressions

Aspose.Tasks pour l’API Java peut utiliser les champs de tâche, de ressources et de projet comme formule dans les expressions. Des champs tels que le travail, le coût, les champs de nombres, la datetime, le booléen et les champs de projet tels que le nombre de tâches et le nombre de ressources peuvent être utilisés dans les expressions de formule dans un attribut étendu.

Utilisation de tâches et champs de ressources dans les calculs de formule

// Create new project instance
   Project project = new Project();
        
java.util.Calendar cal = java.util.Calendar.getInstance();
cal.set(2015, 26, 3, 8,0,0);
        
project.set(Prj.START_DATE, cal.getTime());
        
   // Add new task with extended attribute
   Task task = project.getRootTask().getChildren().add("Task");
   ExtendedAttributeDefinition extendedAttributeDefinition = ExtendedAttributeDefinition.createTaskDefinition(CustomFieldType.Text, ExtendedAttributeTask.Text5, "My Ext Attr");
   project.getExtendedAttributes().add(extendedAttributeDefinition);
   ExtendedAttribute extendedAttribute = extendedAttributeDefinition.createExtendedAttribute();
   task.getExtendedAttributes().add(extendedAttribute);

   // Add resource and resource assignment
   Resource rsc = project.getResources().add("Rsc");
   ResourceAssignment assn = project.getResourceAssignments().add(task, rsc);
   return project;

// see this helper method below
Project project = CreateTestProjectWithCustomField();
        
ExtendedAttributeDefinition attr = project.getExtendedAttributes().get(0);
attr.setAlias("Days from finish to deadline");
attr.setFormula("[Deadline] - [Finish]");
        
java.util.Calendar cal = java.util.Calendar.getInstance();
cal.set(2015, 26, 3, 8,0,0);

Task task = project.getRootTask().getChildren().getById(1);
task.set(Tsk.DEADLINE, cal.getTime());

project.save("SaveFile.mpp", SaveFileFormat.MPP);

Using Arithmetic Expression

Project project = CreateTestProjectWithCustomField();
      
// Set arithmetic formula for extended attribute
ExtendedAttributeDefinition attr = project.getExtendedAttributes().get(0);
attr.setAlias("Arithmetic Expression");
attr.setFormula("(1+3*(2+ -5)+8/2)^3");

// Display extended attribute value
Task task = project.getRootTask().getChildren().getById(1);
System.out.println(task.getExtendedAttributes().get(0).getNumericValue());

Using Task Number Fields

Project project = CreateTestProjectWithCustomField();

// Set Formula
ExtendedAttributeDefinition attr = project.getExtendedAttributes().get(0);
attr.setAlias("Task number fields");
attr.setFormula("(([Outline Level] + [Priority] + [% Complete])/2");

Task task = project.getRootTask().getChildren().getById(1);

// Print extended attribute value before and after updating task percent complete
System.out.println(task.getExtendedAttributes().get(0).getNumericValue());

task.set(Tsk.PERCENT_COMPLETE, 50);
System.out.println(task.getExtendedAttributes().get(0).getNumericValue());

Formula With Boolean Values

Project project = CreateTestProjectWithCustomField();

// Set formula for extended attribute
project.getExtendedAttributes().get(0).setFormula("[Critical]-[Marked]+4+[Active]-Not [Active]");
        
// Print value of extened attribute
Task task = project.getRootTask().getChildren().getById(1);
System.out.println("Formula with boolean values" + task.getExtendedAttributes().get(0).getTextValue());

Formula With Project Fields

Project project = CreateTestProjectWithCustomField();

// Set formula for extended attribute
project.getExtendedAttributes().get(0).setFormula("\"Total tasks: \" & [Task Count] & \" Total resources: \" & [Resource Count]");
        
// Print value of extened attribute
Task task = project.getRootTask().getChildren().getById(1);
System.out.println("Formula with boolean values" + task.getExtendedAttributes().get(0).getTextValue());