From 8fbe0a0530123a4697224b348b17382d329dabe5 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 29 Jul 2025 09:21:57 +0700 Subject: add import leadtime v2 --- import_leadtime_job_v2.kjb | 434 +++++++++++++++++++++++++++++++++++++++++++++ run_indoteknik_job.kjb | 52 +++++- 2 files changed, 483 insertions(+), 3 deletions(-) create mode 100644 import_leadtime_job_v2.kjb diff --git a/import_leadtime_job_v2.kjb b/import_leadtime_job_v2.kjb new file mode 100644 index 0000000..02e5769 --- /dev/null +++ b/import_leadtime_job_v2.kjb @@ -0,0 +1,434 @@ + + + import_leadtime_job_v2 + + + + / + - + 2025/07/29 09:17:26.019 + - + 2025/07/29 09:17:26.019 + + + + + + + + + + + + + ID_JOB + Y + ID_JOB + + + CHANNEL_ID + Y + CHANNEL_ID + + + JOBNAME + Y + JOBNAME + + + STATUS + Y + STATUS + + + LINES_READ + Y + LINES_READ + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + LINES_UPDATED + Y + LINES_UPDATED + + + LINES_INPUT + Y + LINES_INPUT + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + LINES_REJECTED + Y + LINES_REJECTED + + + ERRORS + Y + ERRORS + + + STARTDATE + Y + STARTDATE + + + ENDDATE + Y + ENDDATE + + + LOGDATE + Y + LOGDATE + + + DEPDATE + Y + DEPDATE + + + REPLAYDATE + Y + REPLAYDATE + + + LOG_FIELD + Y + LOG_FIELD + + + EXECUTING_SERVER + N + EXECUTING_SERVER + + + EXECUTING_USER + N + EXECUTING_USER + + + START_JOB_ENTRY + N + START_JOB_ENTRY + + + CLIENT + N + CLIENT + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + JOBNAME + Y + TRANSNAME + + + JOBENTRYNAME + Y + STEPNAME + + + LINES_READ + Y + LINES_READ + + + LINES_WRITTEN + Y + LINES_WRITTEN + + + LINES_UPDATED + Y + LINES_UPDATED + + + LINES_INPUT + Y + LINES_INPUT + + + LINES_OUTPUT + Y + LINES_OUTPUT + + + LINES_REJECTED + Y + LINES_REJECTED + + + ERRORS + Y + ERRORS + + + RESULT + Y + RESULT + + + NR_RESULT_ROWS + Y + NR_RESULT_ROWS + + + NR_RESULT_FILES + Y + NR_RESULT_FILES + + + LOG_FIELD + N + LOG_FIELD + + + COPY_NR + N + COPY_NR + + + + + +
+ + + ID_BATCH + Y + ID_BATCH + + + CHANNEL_ID + Y + CHANNEL_ID + + + LOG_DATE + Y + LOG_DATE + + + LOGGING_OBJECT_TYPE + Y + LOGGING_OBJECT_TYPE + + + OBJECT_NAME + Y + OBJECT_NAME + + + OBJECT_COPY + Y + OBJECT_COPY + + + REPOSITORY_DIRECTORY + Y + REPOSITORY_DIRECTORY + + + FILENAME + Y + FILENAME + + + OBJECT_ID + Y + OBJECT_ID + + + OBJECT_REVISION + Y + OBJECT_REVISION + + + PARENT_CHANNEL_ID + Y + PARENT_CHANNEL_ID + + + ROOT_CHANNEL_ID + Y + ROOT_CHANNEL_ID + + + N + + + + Start + + SPECIAL + + Y + N + N + 0 + 0 + 60 + 12 + 0 + 1 + 1 + N + Y + 0 + 144 + 96 + + + + calculate lead time so to po working hour + + TRANS + + filename + + /home/stephan/transformation-job-bi/calculate_leadtime_so_to_delivered.ktr + + N + N + N + N + N + N + + + N + N + Basic + N + + N + Y + N + N + N + Pentaho local + N + + Y + + N + Y + 0 + 336 + 96 + + + + calculate lead time po to arrival working hour + + TRANS + + filename + + /home/stephan/transformation-job-bi/calculate_leadtime_po_to_mr.ktr + + N + N + N + N + N + N + + + N + N + Basic + N + + N + Y + N + N + N + Pentaho local + N + + Y + + N + Y + 0 + 720 + 96 + + + + Success + + SUCCESS + + N + Y + 0 + 720 + 240 + + + + + + Start + calculate lead time so to po working hour + 0 + 0 + Y + Y + Y + + + calculate lead time so to po working hour + calculate lead time po to arrival working hour + 0 + 0 + Y + Y + N + + + calculate lead time po to arrival working hour + Success + 0 + 0 + Y + Y + N + + + + + + diff --git a/run_indoteknik_job.kjb b/run_indoteknik_job.kjb index 74a41f9..6f9fac2 100644 --- a/run_indoteknik_job.kjb +++ b/run_indoteknik_job.kjb @@ -427,8 +427,8 @@ N Y 0 - 1008 - 96 + 992 + 208 @@ -501,7 +501,44 @@ N Y 0 - 880 + 992 + 96 + + + + leadtime v2 + + JOB + + filename + + /home/stephan/transformation-job-bi/import_leadtime_job_v2.kjb + + + N + N + N + N + + + N + N + Nothing + + Y + N + N + N + N + Pentaho local + + Y + + N + N + Y + 0 + 864 96 @@ -545,6 +582,15 @@ deadstock job + leadtime v2 + 0 + 0 + Y + Y + N + + + leadtime v2 refresh mv 0 0 -- cgit v1.2.3