} // updateManualGoals
/**
* Update/save Goals with Achievement
* @return true if updated
*/
private Boolean UpdateAchievementGoals()
{
if (!MEASURETYPE_Achievements.Equals(GetMeasureType()))
{
return(false);
}
DateTime today = DateTime.Now;
MGoal[] goals = MGoal.GetMeasureGoals(GetCtx(), GetPA_Measure_ID());
for (int i = 0; i < goals.Length; i++)
{
MGoal goal = goals[i];
String MeasureScope = goal.GetMeasureScope();
String trunc = TimeUtil.TRUNC_DAY;
if (MGoal.MEASUREDISPLAY_Year.Equals(MeasureScope))
{
trunc = TimeUtil.TRUNC_YEAR;
}
else if (MGoal.MEASUREDISPLAY_Quarter.Equals(MeasureScope))
{
trunc = TimeUtil.TRUNC_QUARTER;
}
else if (MGoal.MEASUREDISPLAY_Month.Equals(MeasureScope))
{
trunc = TimeUtil.TRUNC_MONTH;
}
else if (MGoal.MEASUREDISPLAY_Week.Equals(MeasureScope))
{
trunc = TimeUtil.TRUNC_WEEK;
}
DateTime compare = TimeUtil.Trunc(today, trunc);
//
MAchievement[] achievements = MAchievement.GetOfMeasure(GetCtx(), GetPA_Measure_ID());
Decimal ManualActual = Env.ZERO;
for (int j = 0; j < achievements.Length; j++)
{
MAchievement achievement = achievements[j];
if (achievement.IsAchieved() && achievement.GetDateDoc() != null)
{
DateTime ach = TimeUtil.Trunc(achievement.GetDateDoc(), trunc);
if (compare.Equals(ach))
{
ManualActual = Decimal.Add(ManualActual, achievement.GetManualActual());
}
}
}
goal.SetMeasureActual(ManualActual);
goal.Save();
}
return(true);
}
} // updateGoals
/**
* Update/save Manual Goals
* @return true if updated
*/
private Boolean UpdateManualGoals()
{
if (!MEASURETYPE_Manual.Equals(GetMeasureType()))
{
return(false);
}
MGoal[] goals = MGoal.GetMeasureGoals(GetCtx(), GetPA_Measure_ID());
for (int i = 0; i < goals.Length; i++)
{
MGoal goal = goals[i];
goal.SetMeasureActual(GetManualActual());
goal.Save();
}
return(true);
} // updateManualGoals
/**
* Update/save Goals with Projects
* @return true if updated
*/
private Boolean UpdateProjects()
{
if (!MEASURETYPE_Project.Equals(GetMeasureType()) ||
GetC_ProjectType_ID() == 0)
{
return(false);
}
MGoal[] goals = MGoal.GetMeasureGoals(GetCtx(), GetPA_Measure_ID());
for (int i = 0; i < goals.Length; i++)
{
MGoal goal = goals[i];
// Find Role
MRole role = null;
if (goal.GetAD_Role_ID() != 0)
{
role = MRole.Get(GetCtx(), goal.GetAD_Role_ID());
}
else if (goal.GetAD_User_ID() != 0)
{
MUser user = MUser.Get(GetCtx(), goal.GetAD_User_ID());
MRole[] roles = user.GetRoles(goal.GetAD_Org_ID());
if (roles.Length > 0)
{
role = roles[0];
}
}
if (role == null)
{
role = MRole.GetDefault(GetCtx(), false); // could result in wrong data
}
//
Decimal? ManualActual = null;
MProjectType pt = MProjectType.Get(GetCtx(), GetC_ProjectType_ID());
String sql = pt.GetSqlPI(goal.GetRestrictions(false),
goal.GetMeasureScope(), GetMeasureDataType(), null, role);
IDataReader idr = null;
try // SQL statement could be wrong
{
idr = DataBase.DB.ExecuteReader(sql, null, null);
if (idr.Read())
{
ManualActual = Utility.Util.GetValueOfDecimal(idr[0]);
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, sql, e);
}
// SQL may return no rows or null
if (ManualActual == null)
{
ManualActual = Env.ZERO;
log.Fine("No Value = " + sql);
}
goal.SetMeasureActual(ManualActual);
goal.Save();
}
return(true);
}