SCRIPT PERBAIKAN TAGGING PROMO, SUB PROMO, LAUNCHING

/** SCRIPT PERBAIKAN TAGGING PROMO, SUB PROMO, LAUNCHING **/

BEGIN;

-- Update data so info
UPDATE sl_so_info A SET
    promo_id = 28,
    sub_promo_id = 13,
    product_launching_id = -99,
    flg_promo_coin = 'Y',
    flg_sub_promo_coin = 'S',
    flg_launching_coin = 'P',
    update_datetime = TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDDHH24MISS'),
    update_user_id = -1,
    VERSION = A.VERSION+1
WHERE A.so_id = 78899;

-- Insert data so tagging
INSERT INTO sl_so_tagging (
    tenant_id, ou_id, so_id, tag_key, tag_doc_id, tag_doc_no, remark,
    create_datetime, create_user_id, update_datetime, update_user_id, version)
SELECT A.tenant_id, A.ou_id, A.so_id, 'PROMO', B.promo_id, C.promo_code, 'Tag To Promo',
    TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDDHH24MISS'), -1, TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDDHH24MISS'), -1, 0
FROM sl_so A
    INNER JOIN sl_so_info B ON A.so_id = B.so_id
    INNER JOIN m_promo C ON B.promo_id = C.promo_id
WHERE A.so_id = 78899 AND
    B.promo_id <> -99;

-- Updat data manage so info
UPDATE sl_manage_so_info A SET
    promo_id = 28,
    sub_promo_id = 13,
    product_launching_id = -99,
    flg_promo_coin = 'Y',
    flg_sub_promo_coin = 'S',
    flg_launching_coin = 'P',
    update_datetime = TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDDHH24MISS'),
    update_user_id = -1,
    VERSION = A.VERSION+1
WHERE A.manage_so_id = 1617;

-- Updat data manage so changes
UPDATE sl_manage_so_changes A SET
    new_data_value = '{"tenantId":10,"createDateTime":"20180502094349","promoId":28,"flgShowInvTax":"N","remark":"HARGA INCLUDE PPN.BRG TDK DKRM U/PNGGNTI TKRN MSK.NO:EXC-00623/DIY/18.CASH 150.000.U/LCF+FKTUR DIKRM. LUNAS.SK\u003d253/SK","remarkInternal":"","subPromoId":13,"lineNo":2,"flgTypeSo":"REG","flgPromoCoin":"Y","mouId":-99,"version":0,"flgSubPromoCoin":"S","id":240,"soId":78899,"updateUserId":55,"flgLaunchingCoin":"P","remarkSettlement":"","flgAutoSettle":"Y","manageSoId":1617,"updateDateTime":"20180502094421","productLaunchingId":-99,"createUserId":55}',
    update_datetime = TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDDHH24MISS'),
    update_user_id = -1,
    VERSION = A.VERSION+1
WHERE A.manage_so_id = 1617
AND A.type_data = 'info';

END;