1.0 [FN_CHECK_LIMIT_TR_REQ].txt
| 1 |
ALTER FUNCTION [dbo].[FN_CHECK_LIMIT_TR_REQ] |
|---|---|
| 2 |
( |
| 3 |
-- Add the parameters for the function here |
| 4 |
@REQ_ID VARCHAR(20), |
| 5 |
@p_role VARCHAR(20) |
| 6 |
) |
| 7 |
RETURNS BIT |
| 8 |
AS |
| 9 |
BEGIN |
| 10 |
|
| 11 |
IF( (SELECT SUM(TOTAL_AMT) FROM dbo.TR_REQUEST_DOC_DT WHERE REQ_DOC_ID=@REQ_ID AND TRAN_TYPE_ID NOT IN (SELECT TRN_TYPE FROM dbo.CM_TRAN_TYPE WHERE NOTES='XK' )) <=5000000) |
| 12 |
BEGIN |
| 13 |
RETURN 0 |
| 14 |
END |
| 15 |
DECLARE @DMMS_ID VARCHAR(20), @SUM_PYC DECIMAL(18,0) |
| 16 |
SET @DMMS_ID =(SELECT DMMS_ID FROM dbo.TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID) |
| 17 |
SET @SUM_PYC =(SELECT SUM(TOTAL_AMT) FROM dbo.TR_REQUEST_DOC_DT WHERE REQ_DOC_ID=@REQ_ID AND TRAN_TYPE_ID NOT IN (SELECT TRN_TYPE FROM dbo.CM_TRAN_TYPE WHERE NOTES='XK')) |
| 18 |
|
| 19 |
--IF( EXISTS(SELECT DMMS_ID FROM dbo.CM_DMMS WHERE DMMS_ID=@DMMS_ID AND |
| 20 |
-- EXISTS (SELECT CM_BRANCH.BRANCH_ID FROM dbo.CM_BRANCH WHERE CM_BRANCH.BRANCH_TYPE='HS' AND CM_DMMS.BRANCH_ID=CM_BRANCH.BRANCH_ID))) |
| 21 |
--BEGIN |
| 22 |
IF(@DMMS_ID ='DMMS00000000001' OR @DMMS_ID ='DM0000000000003') -- NEU DMMS LA PHONG HANH CHINH HOI SO 2022214 |
| 23 |
BEGIN |
| 24 |
IF(@SUM_PYC >=0 AND @SUM_PYC <=100000000) |
| 25 |
BEGIN |
| 26 |
RETURN 0 |
| 27 |
END |
| 28 |
ELSE |
| 29 |
BEGIN |
| 30 |
RETURN 1 |
| 31 |
END |
| 32 |
END |
| 33 |
ELSE IF(@DMMS_ID NOT IN ('DMMS00000000001','DM0000000000003') AND (SELECT BRANCH_DVMS FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID) = 'DV0001') --- NEU DMMS LA DVCM O HOI SO VÀ TRONG NHUNG PHIEU NHO HON 10 TR
|
| 34 |
BEGIN |
| 35 |
IF(@SUM_PYC <=10000000) |
| 36 |
BEGIN |
| 37 |
RETURN 0 |
| 38 |
END |
| 39 |
ELSE |
| 40 |
BEGIN |
| 41 |
RETURN 1 |
| 42 |
END |
| 43 |
END |
| 44 |
--- |
| 45 |
ELSE IF(@DMMS_ID NOT IN ('DMMS00000000001','DM0000000000003') AND (SELECT BRANCH_DVMS FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID) <> 'DV0001') --- NEU DMMS LA DVCM O HOI SO VÀ TRONG NHUNG PHIEU NHO HON 10 TR
|
| 46 |
BEGIN |
| 47 |
IF(EXISTS(SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID AND HANGHOA_ID IN ('HH0000000000035')))
|
| 48 |
BEGIN |
| 49 |
RETURN 0 |
| 50 |
END |
| 51 |
ELSE IF(@SUM_PYC <=20000000) |
| 52 |
BEGIN |
| 53 |
RETURN 0 |
| 54 |
END |
| 55 |
ELSE |
| 56 |
BEGIN |
| 57 |
RETURN 1 |
| 58 |
END |
| 59 |
END |
| 60 |
|
| 61 |
--- |
| 62 |
--END |
| 63 |
----IF( EXISTS(SELECT DMMS_ID FROM dbo.CM_DMMS WHERE DMMS_ID=@DMMS_ID AND |
| 64 |
---- EXISTS (SELECT CM_BRANCH.BRANCH_ID FROM dbo.CM_BRANCH WHERE CM_BRANCH.BRANCH_TYPE='HS' AND CM_DMMS.BRANCH_ID=CM_BRANCH.BRANCH_ID))) |
| 65 |
----BEGIN |
| 66 |
---- RETURN 1 |
| 67 |
----END |
| 68 |
RETURN 0 |
| 69 |
END |