-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path15. Sixth Step - Update LovelySite for MID (Mark Complain) Header Mark Term 1620.sql
54 lines (46 loc) · 2.84 KB
/
15. Sixth Step - Update LovelySite for MID (Mark Complain) Header Mark Term 1620.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
;------------------------------
DECLARE @Term NVARCHAR(MAX) = N'1620'
,@WorkshopName NVARCHAR(MAX) = N'Firmware'
;------------------------------
DECLARE @QuarterSessionId NVARCHAR(MAX), @WorkshopId NVARCHAR(MAX)
;------------------------------
SELECT @QuarterSessionId = QuarterSessions.QuarterSessionId FROM Seaweed.dbo.QuarterSessions WHERE QuarterSessions.Period = @Term
;------------------------------
/******************************************************************************************
* Generate Required Data
******************************************************************************************//*
EXECUTE WE.SP_GenerateFamilyMarkSummaryGalaxy @Term
EXECUTE WE.SP_GenerateFamilyMarkDetailGalaxy @Term
*/
/**********************************************************************
* ---------- ---------- Update Manual Mark Summary ---------- ----------
* @Update = 0, Kalo misalnya mau liat yang bakal kena update. Jadi cek selisihnya kalo yang ini, kalo ga ada yang beda row-nya 0.
* @Update = 1, Kalo misalnya mau update Mark-nya.
* @MidTermOnly = 1, Kalo misalnya cuman mau update Mark MID aja
* @MidTermOnly = 0, Kalo misalnya cuman mau update semuanya
**********************************************************************//*
EXECUTE [WE].[SP_UpdateManualMarkSummary] @Term = @Term
,@MidTermOnly = 1 --Update :: 8 Row(s) 02-06-2017 (Mid Only)
,@Update = 0
*/
/**********************************************************************
* ---------- Transfer Mark from Galaxy to LovelySite ----------
* @LamBrandActvPostDate : Diisikan dengan tanggal pertama seharusnya posting (Tanggal Initial, bukan tanggal publish Complain maupun lain-nya). Kalau tidak mau ada perubahan ketika publish hasil Complain Mark atau konfirmasi berkas, maka jangan diisi.
Misal: @LamBrandActvPostDate = '2017-05-19 11:00:00.000'
* @FamilyMarkDtlSubmitDate : Diisikan dengan tanggal tampil berikutnya (Tanggal Mulai ComplainMark), kalau ga mau diganti jangan diisi.
Misal: @FamilyMarkDtlSubmitDate = '2017-05-19 11:00:00.000'
* @Update = 0, Kalo misalnya mau liat yang bakal kena update. Jadi cek selisihnya kalo yang ini, kalo ga ada yang beda row-nya 0.
* @Update = 1, Kalo misalnya mau update Mark-nya.
**********************************************************************//*
EXECUTE [WE].[SP_UpdateLamBrandActvAndFamilyMarkDtl] @Term = @Term
,@Update = 0
,@ASCID = '1701301076'
-- ,@ExcludeMemberYY = ''
-- ,@ExcludeMemberNumber = ''
*/
/**********************************************************************
* Check Update History
**********************************************************************//*
SELECT * FROM DeepSeaKingdom.dbo.History_LAM_Brand_ACTV ORDER BY InsertedDate DESC
SELECT * FROM DeepSeaKingdom.dbo.History_Family_Mark_DTL ORDER BY InsertedDate DESC
*/