USE [THPSFA2]
GO
/****** Object:  StoredProcedure [dbo].[sp_Call_all]    Script Date: 4/26/2018 6:28:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_Call_all]
AS
    BEGIN
        DECLARE @CompanyID INT;
        SELECT  @CompanyID = CompanyID
        FROM    dbo.DMSAimStagingConfig;
	-- Ma SP
        EXEC sp_temp_salesprice;
	--Dang ky TMKT: Set job để chạy, không import khi call all
    --    EXEC sp_TMKT_register

	--KH moi
        EXEC sp_NewCust_insert

	 --Cap nhat toa do outlet
	 --Ko được update Location về Acu
      --EXEC sp_update_CustomerLocation @CompanyID

	--Delete all data
        EXEC dbo.SP_Calc_Clear_all;

	-- load danh sach SM
        EXEC dbo.sp_Sync_Calc_allEmployee @CompanyID;
	-- Load danh sach outlet
        EXEC dbo.sp_Sync_Calc_allCustomer @CompanyID;
	-- Load danh sach cac CTKM active
	--EXEC dbo.sp_Sync_Call_allpromo
	-- Lay MTM cua all cust
        EXEC dbo.sp_Sync_system_CustomerMTD @CompanyID; -- int

	-- Load customer attribute
        EXEC sp_Sync_Calc_CustomerAttribute @CompanyID;

		-- load cust cho all SM
        EXEC dbo.sp_Sync_calc_Customer_New @CompanyID;  -- int

		--Geography
        EXEC sp_Sync_Calc_Geography_New @CompanyID;

		--Load danh sach SP
        EXEC dbo.sp_Sync_Calc_allInventory @CompanyID;

		-- Load CT POSM, phải chạy trước sp_Sync_TMKT_New
		-- vì sp_Sync_TMKT_New su dụng dữ liệu từ sync_posm
        EXEC sp_Sync_POSM @CompanyID;

		-- Load CT TMKT
        EXEC sp_Sync_TMKT_New @CompanyID;

		-- Promotion
        EXEC sp_Sync_Call_promo_New @CompanyID;
		-- Order Suggest
        EXEC sp_Sync_SKU_Suggest_new @CompanyID;

		--Sync Location
        EXEC dbo.sp_Sync_CallSyncLocation_New @CompanyID;  -- int

		--Allocate
        EXEC sp_Sync_allocation_New @CompanyID;

		-- History Order :
        EXEC sp_Sync_calc_history_order_new @CompanyID;
		-- Kiem ton kho
        EXEC sp_sync_checkStock_new @CompanyID;
		-- Files
        EXEC sp_Sync_file_new @CompanyID;
		--KPI
        EXEC sp_Sync_KPI_new @CompanyID;
		-- Incentive
        EXEC sp_Sync_incentive_new @CompanyID;

		-- Sync du lieu tich luy
        EXEC sp_Sync_CustomerMTD_Inventory @CompanyID;

		----Hieu : taqm thoi lay so tu BL len cho tich luy
		--	exec sp_temp_TMKTMTD

		-- Sync d� giao cua customer de show man hinh thongtin khach hang
        EXEC sp_Sync_CustomerBL @CompanyID;

        --Sync Khảo sát (DMSAImCamaign)
        EXEC sp_Sync_Survey_Posm @CompanyID;

		 --Sync Khảo sát (DMSAImCamaign) CT Định nghĩa trực tiếp ở staging
        EXEC p_aim_survey_campaign_CAMP001SM @CompanyID;
        EXEC p_aim_survey_campaign_CAMP002SM @CompanyID;

		--Sync tài liệu huấn luyện
        EXEC dbo.sp_Sync_TrainingMaterial @CompanyID
        EXEC sp_Sync_Support_Info

		--Sync Khảo sát KH - No use
		EXEC dbo.sp_aim_customerSurvey @CompanyID -- int

    END;