} // 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);
}
/**
* Get Multiplier from Scope to Display
* @param goal goal
* @return null if error or multiplier
*/
public static Decimal?GetMultiplier(MGoal goal)
{
String MeasureScope = goal.GetMeasureScope();
String MeasureDisplay = goal.GetMeasureDisplay();
if (MeasureDisplay == null ||
MeasureScope.Equals(MeasureDisplay))
{
return(Env.ONE); // 1:1
}
if (MeasureScope.Equals(MEASURESCOPE_Total) ||
MeasureDisplay.Equals(MEASUREDISPLAY_Total))
{
return(null); // Error
}
Decimal?Multiplier = null;
if (MeasureScope.Equals(MEASURESCOPE_Year))
{
if (MeasureDisplay.Equals(MEASUREDISPLAY_Quarter))
{
Multiplier = new Decimal(1.0 / 4.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Month))
{
Multiplier = new Decimal(1.0 / 12.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Week))
{
Multiplier = new Decimal(1.0 / 52.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Day))
{
Multiplier = new Decimal(1.0 / 364.0);
}
}
else if (MeasureScope.Equals(MEASURESCOPE_Quarter))
{
if (MeasureDisplay.Equals(MEASUREDISPLAY_Year))
{
Multiplier = new Decimal(4.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Month))
{
Multiplier = new Decimal(1.0 / 3.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Week))
{
Multiplier = new Decimal(1.0 / 13.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Day))
{
Multiplier = new Decimal(1.0 / 91.0);
}
}
else if (MeasureScope.Equals(MEASURESCOPE_Month))
{
if (MeasureDisplay.Equals(MEASUREDISPLAY_Year))
{
Multiplier = new Decimal(12.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Quarter))
{
Multiplier = new Decimal(3.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Week))
{
Multiplier = new Decimal(1.0 / 4.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Day))
{
Multiplier = new Decimal(1.0 / 30.0);
}
}
else if (MeasureScope.Equals(MEASURESCOPE_Week))
{
if (MeasureDisplay.Equals(MEASUREDISPLAY_Year))
{
Multiplier = new Decimal(52.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Quarter))
{
Multiplier = new Decimal(13.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Month))
{
Multiplier = new Decimal(4.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Day))
{
Multiplier = new Decimal(1.0 / 7.0);
}
}
else if (MeasureScope.Equals(MEASURESCOPE_Day))
{
if (MeasureDisplay.Equals(MEASUREDISPLAY_Year))
{
Multiplier = new Decimal(364.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Quarter))
{
Multiplier = new Decimal(91.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Month))
{
Multiplier = new Decimal(30.0);
}
else if (MeasureDisplay.Equals(MEASUREDISPLAY_Week))
{
Multiplier = new Decimal(7.0);
}
}
return(Multiplier);
}
/**
* 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);
}