RSM » RSM Phase II

/*

-------------------------

LOKASI: DB

TABLE: PCMWFCUSTPARAM

ID: PMSGetGSFromK

VALUE:

-------------------------

*/

--DECLARE @EmployeeID VARCHAR(8) = '00000002' DECLARE @now VARCHAR(8) = dbo.fn_formatdatetime(GETDATE(), 'yyyymmdd')

SELECT 

om01.ObjectDescription AS 'Goals',

'' AS 'KPIGroup_49',

'' AS 'MeasuresAchievement_49',

'' AS 'Target_49',

'' AS 'StartDate_49',

'' AS 'EndDate_49',

'' AS 'PlanToExecuteTasks_49',

'' AS 'ResourcesNeeded_49',

'' AS 'ActionsRequiredforFollowup_49',

'' AS 'ContigencyPlans_49'

FROM PHROM0002 om02

INNER JOIN PHROM0001 om01 ON om02.ObjectID = om01.ObjectID

WHERE om02.ObjectID in ('00000001','00000002','00000003')

  AND om02.ObjectClass = 'K' 

  AND om02.RelationshipClass = 'KG' 

  AND om02.StartDate <= @now 

  AND om02.EndDate >= @now 

  AND om01.ObjectClass = 'K' 

  AND om01.StartDate <= @now 

  AND om01.EndDate >= @now

/*

-------------------------

LOKASI: DB

TABLE: PCMWFCUSTPARAM

ID: PMSGetIDPFromK

VALUE:

-------------------------

*/

--DECLARE @EmployeeID VARCHAR(8) = '00000002' DECLARE @now VARCHAR(8) = dbo.fn_formatdatetime(GETDATE(), 'yyyymmdd')

SELECT 

om01.ObjectDescription AS 'Goals',

'' AS 'DevelopmentGoals_492',

'' AS 'TaskRequired_492',

'' AS 'Measuresofachievement_492',

'' AS 'TracticForDevelopment_492',

'' AS 'DescribeTheAssignment_492',

'' AS 'TaskRequiredForTheAssignment_492',

'' AS 'EstimatedTimeFrameWithMilestones_492',

'' AS 'ResourcesNeededd_49',

'' AS 'MentoringProgress_49',

'' AS 'StartDate',

'' AS 'AnticipatedDate'

FROM PHROM0002 om02

INNER JOIN PHROM0001 om01 ON om02.ObjectID = om01.ObjectID

WHERE om02.ObjectID in ('00000026','00000027')

  AND om02.ObjectClass = 'K' 

  AND om02.RelationshipClass = 'KG' 

  AND om02.StartDate <= @now 

  AND om02.EndDate >= @now 

  AND om01.ObjectClass = 'K' 

  AND om01.StartDate <= @now 

  AND om01.EndDate >= @now

/*

-------------------------

LOKASI: DB

TABLE: PCMWFDEFBIZPROC

BizProcessID: PMS_Goal

OnDocAfterRender:

-------------------------

*/

var body = MinovaUtil.WORKFLOW.getViewBodyWorkflow();

var taskID = MinovaUtil.WORKFLOW.getTaskId();

var EmpID = MinovaUtil.WORKFLOW.getEmpId();

//body.down('field[name=AppraisalType_47]').setValue('G');

//var gridStore = Ext.StoreManager.lookup('storePHRPA0048ESS');

var gridStore49_GS = Ext.StoreManager.lookup('storePHRPA0049ESS1');

var gridStore49_IDP = Ext.StoreManager.lookup('storePHRPA0049ESS2');

if (taskID == 'start' || taskID == 'create' || taskID == '') {

	/*

	MinovaUtil.ExecuteParamQuery({

		ID: 'PMSDefaultApprG',

		empid_requester: MinovaUtil.WORKFLOW.getEmpId(),

		now: MinovaUtil.GetNowDate()

	}, function (s) {

		try {

			var result = Ext.decode(s.responseText).data;

			var dataGrid = Ext.decode(Ext.decode(result));

			gridStore.loadData(dataGrid);

		} catch (e) {}

	}, function (e) {}); 

	*/

	MinovaUtil.ExecuteParamQuery({

		ID: 'PMSGetGSFromK',

		EmployeeID: EmpID,

		now: MinovaUtil.GetNowDate()

	}, function (s) {

		try {

			var result = Ext.decode(s.responseText).data;

			var dataGrid = Ext.decode(Ext.decode(result));

			gridStore49_GS.loadData(dataGrid);

		} catch (e) {}

	}, function (e) {});

	MinovaUtil.ExecuteParamQuery({

		ID: 'PMSGetIDPFromK',

		EmployeeID: EmpID,

		now: MinovaUtil.GetNowDate()

	}, function (s) {

		try {

			var result = Ext.decode(s.responseText).data;

			var dataGrid = Ext.decode(Ext.decode(result));

			gridStore49_IDP.loadData(dataGrid);

		} catch (e) {}

	}, function (e) {});

	/*

	var AppraisalType = Ext.ComponentQuery.query('[name=AppraisalType_47]')[0].getValue();

	var Sequence = Ext.ComponentQuery.query('[name=Sequence_47]')[0];

	var Dt = null;

	MinovaUtil.ExecuteParamQuery({

		ID: "WFPMSGETSEQHEADER",

		EmpID: EmpID,

		AppType: AppraisalType

	}, function (s) {

		var result = Ext.decode(s.responseText);

		Dt = Ext.decode(Ext.decode(result.data));

		if (Dt.length > 0) {

			Sequence.setValue(Dt[0].NextSeq)

		}

	}, function (f) {});

	Ext.ComponentQuery.query('[name=EmployeeID_47]')[0].setValue(EmpID);

	*/

} else {

	if(taskID != 'revise_creator')

	{

		body.down('button[name=PHRPA0049ESS1Add]').hide();

		body.down('button[name=PHRPA0049ESS1DeleteText]').hide();

	}

}

/*

setTimeout(function () {

	//Ext.ComponentQuery.query("[name=gridPHRPA0048ESS]")[0].view.refresh();

	Ext.ComponentQuery.query("[name=gridPHRPA0049ESS1]")[0].view.refresh();

	Ext.ComponentQuery.query("[name=gridPHRPA0049ESS2]")[0].view.refresh();

}, 5000);

*/

/*

body.down('button[name=PHRPA0048ESSAdd]').hide();

body.down('button[name=PHRPA0048ESSDeleteText]').hide();

*/