|
1
|
|
|
2
|
ALTER PROCEDURE [dbo].[rpt_MW_OUT_PXK_Excel_BanViet]
|
|
3
|
@OUT_ID varchar(15) = NULL
|
|
4
|
AS
|
|
5
|
SELECT Row_number() over(order by A.OUT_DT_ID) AS STT, A.QTY, A.NOTES,MI.MATERIAL_NAME, UN.UNIT_CODE, UN.UNIT_NAME, A.NOTES,
|
|
6
|
ISNULL(DP.DEP_CODE,''), ISNULL(DP.DEP_NAME,''),DP.DEP_CODE, DP.DEP_NAME, BR.BRANCH_CODE AS DVKD_CODE, BR.BRANCH_NAME AS DVKD_NAME, A.COST_ACC AS COST_ACC
|
|
7
|
FROM MW_OUT_DT A
|
|
8
|
LEFT JOIN MW_MAST_BAL MB ON A.MAST_BAL_ID = MB.MAST_BAL_ID
|
|
9
|
LEFT JOIN MW_MAST_PRICE MP ON MB.PRICE_ID = MP.PRICE_ID
|
|
10
|
LEFT JOIN MW_IN MI ON MP.MATERIAL_ID = MI.IN_ID
|
|
11
|
LEFT JOIN MW_MATERIAL MT ON MT.MATERIAL_ID = MI.MATERIAL_ID
|
|
12
|
LEFT JOIN CM_UNIT UN ON UN.UNIT_ID = MT.UNIT_ID
|
|
13
|
LEFT JOIN CM_DEPARTMENT DP ON A.TO_DEPT_ID = DP.DEP_ID
|
|
14
|
--- LUCTV: 01 06 2020 - BO SUNG LAY MA DON VI KD, TEN DVKD THEO HD BAO HANH BAO TRI DU AN
|
|
15
|
LEFT JOIN CM_BRANCH BR ON A.TO_BRN_ID = BR.BRANCH_ID
|
|
16
|
WHERE A.OUT_ID =@OUT_ID OR @OUT_ID IS NULL OR @OUT_ID =''
|
|
17
|
|
|
18
|
-- doanptt 08/04/2022 nếu xuất kho cho nhiều đơn vị thì bên nhận là Chung - DVKD
|
|
19
|
DECLARE @IS_MULTI_BRANCH INT = 0;
|
|
20
|
SET @IS_MULTI_BRANCH =
|
|
21
|
CASE WHEN (SELECT DISTINCT COUNT(TO_BRN_ID) FROM MW_OUT_DT WHERE OUT_ID = @OUT_ID) > 1
|
|
22
|
AND (SELECT COUNT(TO_BRN_ID) FROM MW_OUT_DT WHERE OUT_ID = @OUT_ID) > 1 THEN 1 END
|
|
23
|
|
|
24
|
DECLARE @IS_ONE_BRANCH NVARCHAR(250) = 0;
|
|
25
|
SET @IS_ONE_BRANCH = (SELECT TOP 1 BR.BRANCH_NAME AS DVKD_NAME
|
|
26
|
FROM MW_OUT_DT A
|
|
27
|
LEFT JOIN MW_MAST_BAL MB ON A.MAST_BAL_ID = MB.MAST_BAL_ID
|
|
28
|
LEFT JOIN MW_MAST_PRICE MP ON MB.PRICE_ID = MP.PRICE_ID
|
|
29
|
LEFT JOIN MW_IN MI ON MP.MATERIAL_ID = MI.IN_ID
|
|
30
|
LEFT JOIN MW_MATERIAL MT ON MT.MATERIAL_ID = MI.MATERIAL_ID
|
|
31
|
LEFT JOIN CM_UNIT UN ON UN.UNIT_ID = MT.UNIT_ID
|
|
32
|
LEFT JOIN CM_DEPARTMENT DP ON A.TO_DEPT_ID = DP.DEP_ID
|
|
33
|
--- LUCTV: 01 06 2020 - BO SUNG LAY MA DON VI KD, TEN DVKD THEO HD BAO HANH BAO TRI DU AN
|
|
34
|
LEFT JOIN CM_BRANCH BR ON A.TO_BRN_ID = BR.BRANCH_ID
|
|
35
|
WHERE A.OUT_ID =@OUT_ID OR @OUT_ID IS NULL OR @OUT_ID ='')
|
|
36
|
|
|
37
|
|
|
38
|
|
|
39
|
select CASE WHEN @IS_MULTI_BRANCH = 1 THEN 'Chung-DVKD' ELSE @IS_ONE_BRANCH END AS DVKD_NAME
|
|
40
|
|
|
41
|
|