USE [HRISDEV]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[proc_list_surat_tugas]
		@pi_nip = NULL,
		@pi_nama = NULL,
		@pi_no_surat = 'st-9/ms.212/2020',
		@pi_lokasi = NULL,
		@pi_sender = N'03342',
		@pi_limit = 10,
		@pi_offset = 11

SELECT	'Return Value' = @return_value

@pi_nip VARCHAR(6),
	@pi_nama VARCHAR(100),
	@pi_no_surat VARCHAR(100),	-- 'ST-23/PM.1/2016'
	@pi_lokasi VARCHAR(255),
	@pi_sender VARCHAR(6),		-- '01845',	--'H02935',	--'03313',
	@pi_limit SMALLINT,
	@pi_offset SMALLINT

--GO
--//http://simfosia.ojk.go.id/webservices/rest/index_dev.php?format=json&wsc_id=WSC-000011&pin=aS91rN1&method=SuratTugasSmartHR&sender=03342&nip=&nama=&no_surat=st-9%2Fms.212%2F2020

DECLARE
	@pi_nip VARCHAR(6) = NULL,	-- 00345
	@pi_nama VARCHAR(100) = NULL,
	@pi_no_surat VARCHAR(100) = 'st-9/ms.212/2020',	-- 'ST-23/PM.1/2016'
	@pi_sender VARCHAR(6) = N'03342'		-- '01845',	--'H02935',	--'03313',

	---- GET HAK AKSES ----

	DECLARE @hak_akses VARCHAR(20)
	DECLARE @list_nip TABLE (nip VARCHAR(6), nm_peg VARCHAR(100))

	SELECT
		@hak_akses = ia.WIA_INQUIRYACCESS
	FROM
		dbo.TBL_USER AS tu
		INNER JOIN
		dbo.WF_INQUIRY_ACCESS AS ia ON tu.WIA_ACCESSNAME = ia.WIA_ACCESSNAME
	WHERE
		ia.WIA_INQUIRYNAME = 'UPK'
		AND tu.NIP = @pi_sender

	DECLARE @full_access BIT = 0
	IF @hak_akses LIKE '%pusat%'
		SET @full_access = 1

	IF COALESCE(@hak_akses, '') = ''
		INSERT INTO @list_nip
		SELECT 
			NIP,
			NM_PEG
		FROM
			dbo.SPG_DATA_CURRENT
		WHERE
			STS_PENSIUN = '0'
			AND NIP = @pi_sender
	ELSE 
		BEGIN

			INSERT INTO @list_nip
			SELECT DISTINCT
				RTRIM(LTRIM(LEFT(list.NIP,6))),
				NM_PEG
			FROM
				(
					SELECT 
						satker.NIP,
						satker.NM_PEG
					FROM 
						dbo.SplitStrings_CTE(@hak_akses, '|') AS h INNER JOIN
						dbo.SPG_DATA_CURRENT AS sdc ON 1 = 1 INNER JOIN
						dbo.SPG_08_UNIT_ORGANISASI AS suo ON sdc.KD_UNIT_ORG = suo.KD_UNIT_ORG INNER JOIN
						(
							SELECT
								sdc2.NIP,
								sdc2.NM_PEG,
								suo2.kode_satker_organisasi
							FROM
								dbo.SPG_DATA_CURRENT AS sdc2 INNER JOIN
								dbo.SPG_08_UNIT_ORGANISASI AS suo2 ON sdc2.KD_UNIT_ORG = suo2.KD_UNIT_ORG
							WHERE
								sdc2.STS_PENSIUN = '0'
						) AS satker ON suo.kode_satker_organisasi = satker.kode_satker_organisasi
					WHERE
						h.Item = 'lokal'
						AND sdc.STS_PENSIUN = '0'
						AND sdc.NIP = @pi_sender
						AND (satker.NIP = @pi_nip OR ISNULL(@pi_nip, '') = '')
						AND (satker.NM_PEG LIKE '%'+@pi_nama+'%' OR ISNULL(@pi_nama, '') = '')

					UNION ALL

					SELECT 
						sdc2.NIP,
						sdc2.NM_PEG
					FROM 
						dbo.SplitStrings_CTE(@hak_akses, '|') AS h INNER JOIN
						dbo.SPG_DATA_CURRENT AS sdc ON 1 = 1 INNER JOIN
						dbo.SPG_DATA_CURRENT AS sdc2 ON LEFT(sdc.KD_UNIT_ORG, 3) = LEFT(sdc2.KD_UNIT_ORG, 3)
					WHERE
						h.Item = 'wilayah'
						AND sdc.NIP = @pi_sender
						AND sdc.STS_PENSIUN = '0'
						AND sdc2.STS_PENSIUN = '0'
						AND (sdc2.NIP = @pi_nip OR ISNULL(@pi_nip, '') = '')
						AND (sdc2.NM_PEG LIKE '%'+@pi_nama+'%' OR ISNULL(@pi_nama, '') = '')

					UNION ALL

					SELECT 
						sdc.NIP,
						sdc.NM_PEG
					FROM 
						dbo.SplitStrings_CTE(@hak_akses, '|') AS h INNER JOIN
						dbo.SPG_DATA_CURRENT AS sdc ON 1 = 1
					WHERE
						h.Item = 'pusat'
						AND sdc.STS_PENSIUN = '0'
						AND (sdc.NIP = @pi_nip OR ISNULL(@pi_nip, '') = '')
						AND (sdc.NM_PEG LIKE '%'+@pi_nama+'%' OR ISNULL(@pi_nama, '') = '')
				) AS list

		END
		--select * from @list_nip

	---- DATA ST ----
SELECT
	*
FROM
	(
	SELECT
		ROW_NUMBER() OVER (ORDER BY l.TGL_SURAT_DATE DESC) AS row_num,
		*
	FROM
		(
	--		-- berdasar no surat
			SELECT DISTINCT
				sst.STU_ID AS stu_id,
				sst.KSO_KASUSNOMOR AS kso_kasusnomor,
				sst.TYPE,
				sst.NO_SURAT AS no_surat,
				sst.TGL_SURAT AS TGL_SURAT_DATE,
				dbo.func_datetostring(sst.TGL_SURAT) AS tgl_surat,
				CAST(sst.KETERANGAN AS VARCHAR(MAX)) AS keterangan_surat_tugas,
				sst.LOKASI AS lokasi_surat_tugas,
				'' AS jenis_surat_tugas,
				sst.NAMA_BUAT AS nip_pembuat_st,
				pembuat_st.nm_peg_pembuat AS nama_pembuat_st,
				pembuat_st.satker_pembuat AS satker_pembuat_st,
				sst.NAMA_UPDATE AS nip_pengubah_st,
				pengubah_st.NM_PEG AS nama_pengubah_st,
				sst.NIP_TTD AS nip_ttd_st,
				ttd_st.NM_PEG AS nama_ttd_st,
				d.POSISI AS jabatan_ttd_st,
				jmlpst.jml AS jml_pst_st,
				listpst.pst AS list_pst
				--spst.KETERANGAN,
				--spst.TGL_MULAI,
				--spst.TGL_SELESAI,
				--spst.NAMA_UPDATE AS PST_NAMA_UPDATE
			FROM
				SPG_SURAT_TUGAS AS sst INNER JOIN	-- 02:16
				--SPG_PESERTA_SURAT_TUGAS AS spst ON sst.STU_ID = spst.STU_ID INNER JOIN
				--@list_nip AS list ON sst.NAMA_BUAT = list.nip
				--				OR sst.NAMA_UPDATE = list.nip
				--				OR sst.NIP_TTD = list.nip
				--				OR spst.NIP = list.nip
				--				OR spst.NAMA_UPDATE = list.nip
				(
					SELECT DISTINCT
							STU_ID
						FROM
							(
								SELECT STU_ID FROM SPG_SURAT_TUGAS AS sst INNER JOIN @list_nip AS list ON sst.NAMA_BUAT = list.nip
								UNION ALL
								SELECT STU_ID FROM SPG_SURAT_TUGAS AS sst INNER JOIN @list_nip AS list ON sst.NAMA_UPDATE = list.nip
								UNION ALL
								SELECT STU_ID FROM SPG_SURAT_TUGAS AS sst INNER JOIN @list_nip AS list ON sst.NIP_TTD = list.nip
								UNION ALL
								SELECT STU_ID FROM SPG_PESERTA_SURAT_TUGAS AS spst INNER JOIN @list_nip AS list ON spst.NIP = list.nip
								UNION ALL
								SELECT STU_ID FROM SPG_PESERTA_SURAT_TUGAS AS spst INNER JOIN @list_nip AS list ON spst.NAMA_UPDATE = list.nip
							) AS x
				) AS akses ON sst.STU_ID = akses.STU_ID
				OUTER APPLY
				(
					SELECT STUFF((SELECT ',' + spst2.NIP + ':' + sdc2.NM_PEG + ':' + COALESCE(dbo.func_datetostring(spst2.TGL_MULAI),'') + ':' + COALESCE(dbo.func_datetostring(spst2.TGL_SELESAI),'')
					FROM SPG_PESERTA_SURAT_TUGAS AS spst2 INNER JOIN SPG_DATA_CURRENT AS sdc2 ON spst2.NIP = sdc2.NIP WHERE spst2.STU_ID = sst.STU_ID
					FOR XML PATH('')) ,1,1,'') AS pst
				 ) AS listpst
				 OUTER APPLY
				 (
					SELECT COUNT(*) AS jml FROM SPG_PESERTA_SURAT_TUGAS WHERE STU_ID = sst.STU_ID
				 ) AS jmlpst 
				 LEFT JOIN
				 --SPG_DATA_CURRENT AS pembuat_st ON sst.NAMA_BUAT = pembuat_st.NIP
				 (
					SELECT
						sdc2.NIP,
						sdc2.NM_PEG AS nm_peg_pembuat,
						suo2.nama_satker_organisasi AS satker_pembuat
					FROM
						dbo.SPG_DATA_CURRENT AS sdc2 INNER JOIN
						dbo.SPG_08_UNIT_ORGANISASI AS suo2 ON sdc2.KD_UNIT_ORG = suo2.KD_UNIT_ORG
					WHERE
						sdc2.STS_PENSIUN = '0'
				) AS pembuat_st ON sst.NAMA_BUAT = pembuat_st.NIP
				LEFT JOIN
				SPG_DATA_CURRENT AS pengubah_st ON sst.NAMA_UPDATE = pengubah_st.NIP
				LEFT JOIN
				SPG_DATA_CURRENT AS ttd_st ON sst.NIP_TTD = ttd_st.NIP
				LEFT JOIN
				(select kd_jabatan,kd_unit_org,max(posisi) POSISI from SPG_08_JABATAN_UNIT  where kd_jabatan != '' and KD_UNIT_ORG != '' group by KD_JABATAN,KD_UNIT_ORG) d
				on ttd_st.KD_JABATAN_STR = d.KD_JABATAN and ttd_st.KD_UNIT_ORG = d.KD_UNIT_ORG
				 
			WHERE
				(sst.NO_SURAT LIKE '%'+@pi_no_surat+'%' OR ISNULL(@pi_no_surat, '') = '')
		) AS l
	) AS lst
WHERE
	lst.row_num = 3
	--		UNION ALL

	--		SELECT DISTINCT
	--			sst.STU_ID,
	--			sst.KSO_KASUSNOMOR,
	--			sst.TYPE,
	--			sst.NO_SURAT,
	--			sst.TGL_SURAT,
	--			CAST(sst.KETERANGAN AS VARCHAR(MAX)) AS KETERANGAN,
	--			sst.LOKASI,
	--			sst.NAMA_BUAT,
	--			sst.NAMA_UPDATE,
	--			sst.NIP_TTD--,
	--			--spst.KETERANGAN,
	--			--spst.TGL_MULAI,
	--			--spst.TGL_SELESAI,
	--			--spst.NAMA_UPDATE AS PST_NAMA_UPDATE
	--		FROM
	--			SPG_SURAT_TUGAS AS sst INNER JOIN
	--			SPG_PESERTA_SURAT_TUGAS AS spst ON sst.STU_ID = spst.STU_ID INNER JOIN
	--			@list_nip AS list ON sst.NAMA_BUAT = list.nip
	--							OR sst.NAMA_UPDATE = list.nip
	--							OR sst.NIP_TTD = list.nip
	--							OR spst.NIP = list.nip
	--							OR spst.NAMA_UPDATE = list.nip
	--		WHERE
	--			list.nip = @pi_nip
	--			OR list.nm_peg LIKE '%'+@pi_nama+'%'
	--	) AS lst INNER JOIN
	--	(	-- hak akses
			--SELECT DISTINCT
			--	sst.STU_ID
			--FROM
			--	SPG_SURAT_TUGAS AS sst INNER JOIN
			--	SPG_PESERTA_SURAT_TUGAS AS spst ON sst.STU_ID = spst.STU_ID INNER JOIN
			--	@list_nip AS list ON sst.NAMA_BUAT = list.nip
			--					OR sst.NAMA_UPDATE = list.nip
			--					OR sst.NIP_TTD = list.nip
			--					OR spst.NIP = list.nip
			--					OR spst.NAMA_UPDATE = list.nip
			--SELECT DISTINCT
			--	STU_ID
			--FROM
			--	(
			--		SELECT STU_ID FROM SPG_SURAT_TUGAS AS sst INNER JOIN @list_nip AS list ON sst.NAMA_BUAT = list.nip
			--		UNION ALL
			--		SELECT STU_ID FROM SPG_SURAT_TUGAS AS sst INNER JOIN @list_nip AS list ON sst.NAMA_UPDATE = list.nip
			--		UNION ALL
			--		SELECT STU_ID FROM SPG_SURAT_TUGAS AS sst INNER JOIN @list_nip AS list ON sst.NIP_TTD = list.nip
			--		UNION ALL
			--		SELECT STU_ID FROM SPG_PESERTA_SURAT_TUGAS AS spst INNER JOIN @list_nip AS list ON spst.NIP = list.nip
			--		UNION ALL
			--		SELECT STU_ID FROM SPG_PESERTA_SURAT_TUGAS AS spst INNER JOIN @list_nip AS list ON spst.NAMA_UPDATE = list.nip
			--	) AS x
		--) AS aks ON lst.STU_ID = aks.STU_ID OR ISNULL(@full_access, 0) <> 0

		
	-------------------------------
	--SELECT
	--	sst.STU_ID,
	--	sst.KSO_KASUSNOMOR,
	--	sst.TYPE,
	--	sst.NO_SURAT,
	--	sst.TGL_SURAT,
	--	CAST(sst.KETERANGAN AS VARCHAR(MAX)) AS KETERANGAN,
	--	sst.LOKASI,
	--	sst.NAMA_BUAT,
	--	sst.NAMA_UPDATE,
	--	sst.NIP_TTD--,
	--	--spst.KETERANGAN,
	--	--spst.TGL_MULAI,
	--	--spst.TGL_SELESAI,
	--	--spst.NAMA_UPDATE AS PST_NAMA_UPDATE
	--FROM
	--	SPG_SURAT_TUGAS AS sst 
	--	INNER JOIN
	--	(
	--		SELECT DISTINCT
	--			spst.STU_ID
	--		FROM
	--			SPG_PESERTA_SURAT_TUGAS AS spst INNER JOIN
	--		WHERE
	--			(
	--				spst.NIP = @pi_nip
	--				OR spst.NAMA_UPDATE = @pi_nip
	--			) OR ISNULL(@pi_nip, '') = ''
	--	) AS pst_st ON sst.STU_ID = pst_st.STU_ID
	--WHERE
	--	(
	--		(
	--			sst.NAMA_BUAT = @pi_nip
	--			OR sst.NAMA_UPDATE = @pi_nip
	--			OR sst.NIP_TTD = @pi_nip
	--		) OR ISNULL(@pi_nip, '') = ''
	--	)
	--	AND 
	--	(sst.NO_SURAT LIKE '%'+@pi_no_surat+'%' OR ISNULL(@pi_no_surat, '') = '')
	--ORDER BY
	--	sst.STU_ID

	--SELECT 
	--	ROW_NUMBER() OVER (ORDER BY st.TGL_SURAT DESC) AS no,
	--	st.STU_ID AS stu_id,
	--	st.KSO_KASUSNOMOR AS kso_kasusnomor,
	--	st.NO_SURAT AS no_surat,
	--	--dbo.func_datetostring(st.TGL_MULAI) AS tgl_mulai_surat_tugas,
	--	--dbo.func_datetostring(st.TGL_SELESAI) AS tgl_selesai_surat_tugas,
	--	st.KETERANGAN AS keterangan_surat_tugas,
	--	st.LOKASI AS lokasi_surat_tugas,
	--	'' AS jenis_surat_tugas,
	--	st.NAMA_BUAT AS nip_pembuat_st,
	--	pembuat_st.NM_PEG AS nama_pembuat_st,
	--	'' AS satker_pembuat_st,
	--	st.NAMA_UPDATE AS nip_pengubah_st,
	--	pengubah_st.NM_PEG AS nama_pengubah_st,
	--	st.NIP_TTD AS nip_ttd_st,
	--	ttd_st.NM_PEG AS nama_ttd_st,
	--	st.PST_NAMA_UPDATE AS nip_pengubah_pst_st,
	--	'' AS nama_pengubah_pst_st,
	--	jmlpst.jml AS jml_pst_st,
	--	listpst.pst AS list_pst
	--FROM
	--	--@list_nip AS list INNER JOIN
	--	--SPG_DATA_CURRENT AS sdc ON list.NIP = sdc.NIP
	--	--CROSS APPLY
	--	--(
	--	--	SELECT
	--	--		sst.STU_ID,
	--	--		sst.TYPE,
	--	--		sst.NO_SURAT,
	--	--		sst.TGL_SURAT,
	--	--		spst.KETERANGAN,
	--	--		spst.TGL_MULAI,
	--	--		spst.TGL_SELESAI
	--	--	FROM
	--	--		SPG_SURAT_TUGAS AS sst INNER JOIN
	--	--		SPG_PESERTA_SURAT_TUGAS AS spst ON sst.STU_ID = spst.STU_ID
	--	--	WHERE
	--	--		(
	--	--			(
	--	--				sst.NAMA_BUAT = sdc.NIP
	--	--				OR sst.NAMA_UPDATE = sdc.NIP
	--	--				OR sst.NIP_TTD = sdc.NIP
	--	--				OR spst.NIP = sdc.NIP
	--	--				OR spst.NAMA_UPDATE = sdc.NIP
	--	--			) OR ISNULL(sdc.NIP, '') = ''
	--	--		)
	--	--		AND (sst.NO_SURAT LIKE '%'+@pi_no_surat+'%' OR ISNULL(@pi_no_surat, '') = '')
	--	--) AS st 
	--	(
	--		SELECT DISTINCT
	--			sst.STU_ID,
	--			sst.KSO_KASUSNOMOR,
	--			sst.TYPE,
	--			sst.NO_SURAT,
	--			sst.TGL_SURAT,
	--			CAST(sst.KETERANGAN AS VARCHAR(MAX)) AS KETERANGAN,
	--			sst.LOKASI,
	--			sst.NAMA_BUAT,
	--			sst.NAMA_UPDATE,
	--			sst.NIP_TTD,
	--			spst.NIP,
	--			--spst.KETERANGAN AS PST_KETERANGAN,
	--			spst.TGL_MULAI,
	--			spst.TGL_SELESAI,
	--			spst.NAMA_UPDATE AS PST_NAMA_UPDATE
	--		FROM
	--			SPG_SURAT_TUGAS AS sst INNER JOIN
	--			SPG_PESERTA_SURAT_TUGAS AS spst ON sst.STU_ID = spst.STU_ID LEFT JOIN
	--			@list_nip AS list ON
	--		WHERE
	--			COALESCE(sst.STATUS, '0') <> '0'
	--			--AND sst.TYPE = ''
	--			AND spst.STATUS = '1'	--1 'Disetujui', 2 'Ditolak', 4 'Dibatalkan'
	--			--AND spst.TYPE = ''
	--			AND (sst.NO_SURAT LIKE '%'+@pi_no_surat+'%' OR ISNULL(@pi_no_surat, '') = '')
	--	) AS st ON (
	--				(	-- ini adalah pengecekan hak akses
	--					st.NAMA_BUAT = list.NIP
	--					OR st.NAMA_UPDATE = list.NIP
	--					OR st.NIP_TTD = list.NIP
	--					OR st.NIP = list.NIP
	--					OR st.PST_NAMA_UPDATE = list.NIP
	--				) OR ISNULL(@full_access, 0) <> 0
	--			)
	--	OUTER APPLY
	--	(
	--		SELECT STUFF((SELECT ', ' + spst2.NIP + ': ' + sdc2.NM_PEG
	--		FROM SPG_PESERTA_SURAT_TUGAS AS spst2 INNER JOIN SPG_DATA_CURRENT AS sdc2 ON spst2.NIP = sdc2.NIP WHERE spst2.STATUS = '1' AND spst2.STU_ID = st.STU_ID
	--		FOR XML PATH('')) ,1,1,'') AS pst
	--	 ) AS listpst
	--	 --OUTER APPLY
	--	 --(
	--		--SELECT COUNT(*) AS jml FROM SPG_PESERTA_SURAT_TUGAS WHERE STU_ID = st.STU_ID
	--	 --) AS jmlpst 
	--	 LEFT JOIN
	--	 (
	--		SELECT COUNT(*) AS jml, STU_ID FROM SPG_PESERTA_SURAT_TUGAS WHERE STATUS = '1' GROUP BY STU_ID
	--	 ) AS jmlpst ON st.STU_ID = jmlpst.STU_ID
	--	 LEFT JOIN
	--	 SPG_DATA_CURRENT AS pembuat_st ON st.NAMA_BUAT = pembuat_st.NIP
	--	 LEFT JOIN
	--	 SPG_DATA_CURRENT AS pengubah_st ON st.NAMA_UPDATE = pengubah_st.NIP
	--	 LEFT JOIN
	--	 SPG_DATA_CURRENT AS ttd_st ON st.NIP_TTD = ttd_st.NIP
	--WHERE
	--	(list.NIP = @pi_nip OR ISNULL(@pi_nip, '') = '')
	--	AND (list.NM_PEG LIKE '%'+@pi_nama+'%' OR ISNULL(@pi_nama, '') = '')
	--	--AND (st.NO_SURAT LIKE '%'+@pi_no_surat+'%' OR ISNULL(@pi_no_surat, '') = '')
	--	--AND st.STU_ID IS NOT NULL
	--ORDER BY
	--	st.TGL_SURAT DESC

--            "nama": "RAOM",
--            "nip": "00042",
--            "jabatan": "Advisor Strategic Committee",
--            "level_jabatan": "Kepala Departemen",
--            "grade": "",
--            "bidang": "Bidang Manajemen Strategis I",
--            "satuan_kerja": "Strategic Committee",
--            "unit_kerja": "",
--            "md_jabatan": "6 Tahun 8 Bulan",
--            "md_satuan_kerja": "2 Tahun 0 Bulan",
--            "md_ojk": "7 Tahun 11 Bulan",
--            "sisa_md": "6 Tahun 3 Bulan",
--            "usia": "53 Tahun 9 Bulan",
--            "sanksi": "Tidak",
--            "no_telepon": "2xxxxxx0",
--            "no_ekstension": "3xxxxx6",
--            "email": "Rxxxx.xxx@xxx.xx.xd",
--            "keahlian": "",
--            "aktualisasi_diri": "Saudara Hartono, SH adalah kakak kandung saya",
--            "status_pegawai": "Pegawai Tetap",
--            "md_lembaga_asal": "26 Tahun 10 Bulan",
--            "md_level_jabatan": "6 Tahun 8 Bulan",
--            "tmt_berakhir_kontrak": "",
--            "tmt_pensiun": "01-04-2027",
--            "posisi": "Advisor Strategic Committee",
--            "nm_agama": "Islam",
--            "sts_perkawinan": "Belum Menikah",
--            "nm_jns_kelamin_peg": "WANITA",
--            "nm_propinsi_homebase": "DKI JAKARTA",
--            "ket_lembaga_asal": "BAPEPAM-LK",
--            "tmt_lembaga_asal": "01-02-1994",
--            "tmt_level_jabatan": "01-04-2014",
--            "tmt_jabatan": "01-01-2016",
--            "tmt_satker": "01-12-2018",
--            "email_pribadi": "exx_x@xxxxxxx.xxm",
--            "handphone_1": "0xxxxxxxx6",
--            "handphone_2": "0xxxxxxxxxx1",
--            "peserta_surat_tugas": "Tidak",
--            "stu_id": "STU-339746",
--            "kso_kasusnomor": "KSO-679977",
--            "no_surat": "ST-70/MS.4/2019",
--            "tgl_mulai_surat_tugas": "05-03-2018",
--            "tgl_selesai_surat_tugas": "19-12-2019",
--            "keterangan_surat_tugas": "Konsinyering Koordinasi antar Departemen terkait Tugas dan Fungsi Departemen Internasional di Mandarin, Jakarta pada tanggal 18-19 Desember 2019",
--            "lokasi_surat_tugas": "Jakarta",
--            "jenis_surat_tugas": "Dalam Kota Pungutan",
--            "nip_name": "00042 - RAOM"