PK - code
// ==================================================================================
// Trigger: After Update on TimeEntry_c
// Purpose: When PPMTaskID_c is updated (null → value) by an end user (not integration),
// check if all entries have PPMTaskID_c and uncheck flag on Timesheet if true.
// ==================================================================================
try {
println "[1] Starting PPMTaskCheckTrigger (After Update on TimeEntry_c)"
println "[1.1] Processing TimeEntry record ID: ${Id}"
// 1️⃣ Quick check
if (!(isAttributeChanged('PPMTaskID_c') && PPMTaskID_c != null)) {
println "[2] PPMTaskID_c not changed or still null — exiting"
return
}
// 2️⃣ Skip for integration users
def oicUsers = [
'OicPpmPrdUsr01@pike.com','OicCrmPrdUsr01@pike.com','OicHcmPrdUsr01@pike.com',
'OicCRMUat1Usr01@pike.com','OicPpmUat1Usr01@pike.com','OicHcmUat1Usr01@pike.com',
'OicPpmDev1User01','OicHcmDev1User01','OicCrmDev1User01'
]
def currentUser = adf.context.getSecurityContext().getUserName()
println "[3] Current user: ${currentUser}"
if (oicUsers.contains(currentUser)) {
println "[4] Integration user detected — skipping trigger logic"
return
}
// 3️⃣ Get parent Timesheet ID
def tsId = Timesheet_Id_c
println "[5] Timesheet_Id_c = ${tsId}"
if (tsId == null) {
println "[6] No Timesheet_Id_c found — exiting"
return
}
// 4️⃣ Check if ANY Equipment entries have null PPMTaskID_c
println "[7] Checking EquipmentsTimeEntry_c for NULL PPMTaskID_c"
def eqpEntries = newView('EquipmentsTimeEntry_c')
eqpEntries.appendViewCriteria("TimeSheet_Id_c = ${tsId} and PPMTaskID_c is null")
eqpEntries.executeQuery()
def eqpHasNull = eqpEntries.hasNext()
println "[8] Equipment null PPMTask found? ${eqpHasNull}"
// 5️⃣ Check if ANY TimeEntry entries have null PPMTaskID_c
println "[9] Checking TimeEntry_c for NULL PPMTaskID_c"
def timeEntries = newView('TimeEntry_c')
timeEntries.appendViewCriteria("Timesheet_Id_c = ${tsId} and PPMTaskID_c is null")
timeEntries.executeQuery()
def timeHasNull = timeEntries.hasNext()
println "[10] TimeEntry null PPMTask found? ${timeHasNull}"
// 6️⃣ Update parent if all tasks are filled
if (!eqpHasNull && !timeHasNull) {
println "[11] ✅ All entries have PPMTaskID_c — updating parent Timesheet"
def tsView = newView('Timesheet_c')
def rows = tsView.findByKey(key(tsId), 1)
if (rows.size() == 1) {
def ts = rows[0]
ts.setAttribute('PPMTaskIDMissing_c', false) // Replace with actual field name
println "[12] Flag unchecked on Timesheet_c ID: ${tsId}"
} else {
println "[13] Timesheet not found or duplicate key results"
}
} else {
println "[14] Some entries still missing PPMTaskID_c — parent not updated"
}
println "[15] PPMTaskCheckTrigger completed successfully"
} catch (Exception e) {
println "[E] [PPMTaskCheckTrigger] Exception: ${e.getMessage()}"
}
Comments
Post a Comment