1
|
/*
|
2
|
-------------------------
|
3
|
LOKASI: DB
|
4
|
TABLE: PCMWFCUSTPARAM
|
5
|
ID: PMSGetGSFromK
|
6
|
VALUE:
|
7
|
-------------------------
|
8
|
*/
|
9
|
|
10
|
--DECLARE @EmployeeID VARCHAR(8) = '00000002' DECLARE @now VARCHAR(8) = dbo.fn_formatdatetime(GETDATE(), 'yyyymmdd')
|
11
|
|
12
|
SELECT
|
13
|
om01.ObjectDescription AS 'Goals',
|
14
|
'' AS 'KPIGroup_49',
|
15
|
'' AS 'MeasuresAchievement_49',
|
16
|
'' AS 'Target_49',
|
17
|
'' AS 'StartDate_49',
|
18
|
'' AS 'EndDate_49',
|
19
|
'' AS 'PlanToExecuteTasks_49',
|
20
|
'' AS 'ResourcesNeeded_49',
|
21
|
'' AS 'ActionsRequiredforFollowup_49',
|
22
|
'' AS 'ContigencyPlans_49'
|
23
|
FROM PHROM0002 om02
|
24
|
INNER JOIN PHROM0001 om01 ON om02.ObjectID = om01.ObjectID
|
25
|
WHERE om02.ObjectID in ('00000001','00000002','00000003')
|
26
|
AND om02.ObjectClass = 'K'
|
27
|
AND om02.RelationshipClass = 'KG'
|
28
|
AND om02.StartDate <= @now
|
29
|
AND om02.EndDate >= @now
|
30
|
AND om01.ObjectClass = 'K'
|
31
|
AND om01.StartDate <= @now
|
32
|
AND om01.EndDate >= @now
|
33
|
|
34
|
/*
|
35
|
-------------------------
|
36
|
LOKASI: DB
|
37
|
TABLE: PCMWFCUSTPARAM
|
38
|
ID: PMSGetIDPFromK
|
39
|
VALUE:
|
40
|
-------------------------
|
41
|
*/
|
42
|
--DECLARE @EmployeeID VARCHAR(8) = '00000002' DECLARE @now VARCHAR(8) = dbo.fn_formatdatetime(GETDATE(), 'yyyymmdd')
|
43
|
|
44
|
SELECT
|
45
|
om01.ObjectDescription AS 'Goals',
|
46
|
'' AS 'DevelopmentGoals_492',
|
47
|
'' AS 'TaskRequired_492',
|
48
|
'' AS 'Measuresofachievement_492',
|
49
|
'' AS 'TracticForDevelopment_492',
|
50
|
'' AS 'DescribeTheAssignment_492',
|
51
|
'' AS 'TaskRequiredForTheAssignment_492',
|
52
|
'' AS 'EstimatedTimeFrameWithMilestones_492',
|
53
|
'' AS 'ResourcesNeededd_49',
|
54
|
'' AS 'MentoringProgress_49',
|
55
|
'' AS 'StartDate',
|
56
|
'' AS 'AnticipatedDate'
|
57
|
FROM PHROM0002 om02
|
58
|
INNER JOIN PHROM0001 om01 ON om02.ObjectID = om01.ObjectID
|
59
|
WHERE om02.ObjectID in ('00000026','00000027')
|
60
|
AND om02.ObjectClass = 'K'
|
61
|
AND om02.RelationshipClass = 'KG'
|
62
|
AND om02.StartDate <= @now
|
63
|
AND om02.EndDate >= @now
|
64
|
AND om01.ObjectClass = 'K'
|
65
|
AND om01.StartDate <= @now
|
66
|
AND om01.EndDate >= @now
|
67
|
|
68
|
/*
|
69
|
-------------------------
|
70
|
LOKASI: DB
|
71
|
TABLE: PCMWFDEFBIZPROC
|
72
|
BizProcessID: PMS_Goal
|
73
|
OnDocAfterRender:
|
74
|
-------------------------
|
75
|
*/
|
76
|
|
77
|
var body = MinovaUtil.WORKFLOW.getViewBodyWorkflow();
|
78
|
var taskID = MinovaUtil.WORKFLOW.getTaskId();
|
79
|
var EmpID = MinovaUtil.WORKFLOW.getEmpId();
|
80
|
//body.down('field[name=AppraisalType_47]').setValue('G');
|
81
|
//var gridStore = Ext.StoreManager.lookup('storePHRPA0048ESS');
|
82
|
var gridStore49_GS = Ext.StoreManager.lookup('storePHRPA0049ESS1');
|
83
|
var gridStore49_IDP = Ext.StoreManager.lookup('storePHRPA0049ESS2');
|
84
|
if (taskID == 'start' || taskID == 'create' || taskID == '') {
|
85
|
/*
|
86
|
MinovaUtil.ExecuteParamQuery({
|
87
|
ID: 'PMSDefaultApprG',
|
88
|
empid_requester: MinovaUtil.WORKFLOW.getEmpId(),
|
89
|
now: MinovaUtil.GetNowDate()
|
90
|
}, function (s) {
|
91
|
try {
|
92
|
var result = Ext.decode(s.responseText).data;
|
93
|
var dataGrid = Ext.decode(Ext.decode(result));
|
94
|
gridStore.loadData(dataGrid);
|
95
|
} catch (e) {}
|
96
|
}, function (e) {});
|
97
|
*/
|
98
|
MinovaUtil.ExecuteParamQuery({
|
99
|
ID: 'PMSGetGSFromK',
|
100
|
EmployeeID: EmpID,
|
101
|
now: MinovaUtil.GetNowDate()
|
102
|
}, function (s) {
|
103
|
try {
|
104
|
var result = Ext.decode(s.responseText).data;
|
105
|
var dataGrid = Ext.decode(Ext.decode(result));
|
106
|
gridStore49_GS.loadData(dataGrid);
|
107
|
} catch (e) {}
|
108
|
}, function (e) {});
|
109
|
|
110
|
MinovaUtil.ExecuteParamQuery({
|
111
|
ID: 'PMSGetIDPFromK',
|
112
|
EmployeeID: EmpID,
|
113
|
now: MinovaUtil.GetNowDate()
|
114
|
}, function (s) {
|
115
|
try {
|
116
|
var result = Ext.decode(s.responseText).data;
|
117
|
var dataGrid = Ext.decode(Ext.decode(result));
|
118
|
gridStore49_IDP.loadData(dataGrid);
|
119
|
} catch (e) {}
|
120
|
}, function (e) {});
|
121
|
/*
|
122
|
var AppraisalType = Ext.ComponentQuery.query('[name=AppraisalType_47]')[0].getValue();
|
123
|
var Sequence = Ext.ComponentQuery.query('[name=Sequence_47]')[0];
|
124
|
var Dt = null;
|
125
|
MinovaUtil.ExecuteParamQuery({
|
126
|
ID: "WFPMSGETSEQHEADER",
|
127
|
EmpID: EmpID,
|
128
|
AppType: AppraisalType
|
129
|
}, function (s) {
|
130
|
var result = Ext.decode(s.responseText);
|
131
|
Dt = Ext.decode(Ext.decode(result.data));
|
132
|
if (Dt.length > 0) {
|
133
|
Sequence.setValue(Dt[0].NextSeq)
|
134
|
}
|
135
|
}, function (f) {});
|
136
|
Ext.ComponentQuery.query('[name=EmployeeID_47]')[0].setValue(EmpID);
|
137
|
*/
|
138
|
} else {
|
139
|
if(taskID != 'revise_creator')
|
140
|
{
|
141
|
body.down('button[name=PHRPA0049ESS1Add]').hide();
|
142
|
body.down('button[name=PHRPA0049ESS1DeleteText]').hide();
|
143
|
}
|
144
|
}
|
145
|
/*
|
146
|
setTimeout(function () {
|
147
|
//Ext.ComponentQuery.query("[name=gridPHRPA0048ESS]")[0].view.refresh();
|
148
|
Ext.ComponentQuery.query("[name=gridPHRPA0049ESS1]")[0].view.refresh();
|
149
|
Ext.ComponentQuery.query("[name=gridPHRPA0049ESS2]")[0].view.refresh();
|
150
|
}, 5000);
|
151
|
*/
|
152
|
/*
|
153
|
body.down('button[name=PHRPA0048ESSAdd]').hide();
|
154
|
body.down('button[name=PHRPA0048ESSDeleteText]').hide();
|
155
|
*/
|