ALTER PROCEDURE [dbo].[rpt_MW_TRANS_PXK_Excel_BanViet]
@TRANSFER_ID	varchar(15) = NULL,
@BRANCH_ID	varchar(15) = NULL
AS
SELECT Row_number() over(order by A.TRANSFER_DT_ID) AS STT, A.QTY, A.NOTES,MI.MATERIAL_NAME, UN.UNIT_CODE, UN.UNIT_NAME,DP.DEP_CODE, DP.DEP_NAME, BR.BRANCH_CODE AS DVKD_CODE, BR.BRANCH_NAME AS DVKD_NAME
, A.COST_ACC
FROM MW_TRANSFER_DT A 
LEFT JOIN MW_MAST_BAL MB ON A.MAST_BAL_ID = MB.MAST_BAL_ID
LEFT JOIN MW_MAST_PRICE MP ON MB.PRICE_ID = MP.PRICE_ID
LEFT JOIN MW_IN MI ON MP.MATERIAL_ID = MI.IN_ID
LEFT JOIN MW_MATERIAL MT ON MT.MATERIAL_ID = MI.MATERIAL_ID
LEFT JOIN CM_UNIT UN ON UN.UNIT_ID = MT.UNIT_ID
LEFT JOIN CM_DEPARTMENT DP ON A.TO_DEPT_ID = DP.DEP_ID
--- LUCTV: 01 06 2020 - BO SUNG LAY MA DON VI KD, TEN DVKD THEO HD BAO HANH BAO TRI DU AN
LEFT JOIN CM_BRANCH BR ON A.TO_BRN_ID = BR.BRANCH_ID
WHERE A.TRANSFER_ID =@TRANSFER_ID 
AND  (A.TO_BRN_ID = @BRANCH_ID OR @BRANCH_ID IS NULL OR @BRANCH_ID ='')

-- doanptt 08/04/2022  nếu xuất kho cho nhiều đơn vị thì bên nhận là Chung - DVKD
DECLARE @IS_MULTI_BRANCH INT = 0;
SET @IS_MULTI_BRANCH =
	CASE WHEN (SELECT DISTINCT COUNT(TO_BRN_ID) FROM MW_TRANSFER_DT WHERE TRANSFER_ID = @TRANSFER_ID) > 1
		AND (SELECT COUNT(TO_BRN_ID) FROM MW_TRANSFER_DT WHERE TRANSFER_ID = @TRANSFER_ID) > 1 THEN 1 END

		DECLARE @IS_ONE_BRANCH NVARCHAR(250) = 0;
SET @IS_ONE_BRANCH = (SELECT TOP 1 BR.BRANCH_NAME AS DVKD_NAME
					FROM MW_TRANSFER_DT A 
					LEFT JOIN MW_MAST_BAL MB ON A.MAST_BAL_ID = MB.MAST_BAL_ID
					LEFT JOIN MW_MAST_PRICE MP ON MB.PRICE_ID = MP.PRICE_ID
					LEFT JOIN MW_IN MI ON MP.MATERIAL_ID = MI.IN_ID
					LEFT JOIN MW_MATERIAL MT ON MT.MATERIAL_ID = MI.MATERIAL_ID
					LEFT JOIN CM_UNIT UN ON UN.UNIT_ID = MT.UNIT_ID
					LEFT JOIN CM_DEPARTMENT DP ON A.TO_DEPT_ID = DP.DEP_ID
					--- LUCTV: 01 06 2020 - BO SUNG LAY MA DON VI KD, TEN DVKD THEO HD BAO HANH BAO TRI DU AN
					LEFT JOIN CM_BRANCH BR ON A.TO_BRN_ID = BR.BRANCH_ID
					WHERE A.TRANSFER_ID =@TRANSFER_ID 
					AND  (A.TO_BRN_ID = @BRANCH_ID OR @BRANCH_ID IS NULL OR @BRANCH_ID =''))



select CASE WHEN @IS_MULTI_BRANCH = 1 THEN 'Chung-DVKD' ELSE @IS_ONE_BRANCH END AS DVKD_NAME