DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

ALTER   PROC [dbo].[DB_STATUS_ASSET_QUANTITY_PIE]

@p_USER_LOGIN VARCHAR(250) = NULL,

@p_BRANCH_ID VARCHAR(15) = NULL,

@p_YEAR VARCHAR(15) = NULL

AS

BEGIN

	DECLARE @RESULT TABLE (

		TYPE_ID VARCHAR(15),

		TOTAL_COUNT FLOAT

	)

	DECLARE @BRANCH_LOGIN varchar(15) ='', @DEP_LOGIN varchar(15) =''

	SELECT @DEP_LOGIN = SECUR_CODE, @BRANCH_LOGIN = TLSUBBRID FROM TL_USER WHERE TLNANME = @p_USER_LOGIN

  IF(NOT EXISTS(SELECT * FROM CM_DEPARTMENT cd WHERE cd.BRANCH_ID = @BRANCH_LOGIN AND cd.DEP_ID = @DEP_LOGIN AND (cd.DEP_CODE = '0690604' OR cd.DEP_CODE = '0690802' OR cd.DEP_CODE = '0690803')))

  BEGIN

    IF(@BRANCH_LOGIN = 'DV0001') SET @p_BRANCH_ID = @DEP_LOGIN

    ELSE SET @p_BRANCH_ID = @BRANCH_LOGIN

  END

	INSERT INTO @RESULT

	SELECT A.TYPE_ID AS TYPE_ID, COUNT(A.TYPE_ID) AS TOTAL_COUNT

	FROM ASS_MASTER A

	WHERE 1=1

	AND (A.BRANCH_ID = @p_BRANCH_ID OR @p_BRANCH_ID IS NULL OR @p_BRANCH_ID = '' OR A.DEPT_ID = @p_BRANCH_ID)

	AND (YEAR(A.BUY_DATE_KT) <= @p_YEAR OR @p_YEAR IS NULL OR @p_YEAR = '' )

	AND (YEAR(A.LIQUIDATION_DT) >= @p_YEAR OR @p_YEAR IS NULL OR @p_YEAR = '' )

	GROUP BY A.TYPE_ID

	------------------------

	-------Chuyển từ số lượng sang % -------------

	DECLARE @SUM_TOTAL_COUNT INT = 0

	SELECT @SUM_TOTAL_COUNT = SUM(TOTAL_COUNT) FROM @RESULT

	UPDATE @RESULT SET TOTAL_COUNT = ROUND(TOTAL_COUNT * 100 / @SUM_TOTAL_COUNT, 2)

	-------Chuyển từ số lượng sang % -------------

	SELECT * FROM @RESULT

END