/*
	[CM_SUPPLIER_Search] '1','','','','','','','','','','','','','','','','',100
*/

ALTER PROCEDURE dbo.PL_COSTCENTER_Search
	@p_COST_CODE	varchar(15)  = NULL,
	@p_COST_NAME	Nvarchar(300)  = NULL,
	@p_PLAN_TYPE_ID VARCHAR(20)=NULL,
	@p_NOTES	nvarchar(1000)  = NULL,
	@p_RECORD_STATUS	varchar(1)  = NULL,
	@p_MAKER_ID	varchar(20)  = NULL,
	@p_CREATE_DT	NVARCHAR(25) = NULL,
	@p_AUTH_STATUS	varchar(50)  = NULL,
	@p_CHECKER_ID	varchar(20)  = NULL,
	@p_APPROVE_DT	NVARCHAR(25) = NULL,
	@p_TOP INT = NULL
AS
BEGIN -- PAGING
	IF(@p_TOP IS NULL OR @p_TOP = '' OR @p_TOP = 0)
-- PAGING BEGIN
		SELECT A.*,B.AUTH_STATUS_NAME,
		CASE
			WHEN A.RECORD_STATUS = 1 THEN N'Hoạt động'
			ELSE N'Không hoạt động'
		END AS RECORD_STATUS_NAME
		,T.GD_TYPE_NAME as PLAN_TYPE_NAME
-- SELECT END
		FROM dbo.PL_COSTCENTER A 
		LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
		LEFT JOIN dbo.CM_GOODSTYPE T ON T.GD_TYPE_ID=A.PLAN_TYPE_ID
        JOIN CM_DVDM cd ON A.DVDM_ID = cd.DVDM_ID AND cd.IS_DVDM =1
		WHERE 1 = 1
	    AND (A.PLAN_TYPE_ID like + '%' + @p_PLAN_TYPE_ID + '%' OR @p_PLAN_TYPE_ID IS NULL OR @p_PLAN_TYPE_ID = '')
		AND (A.COST_NAME like '%' + @p_COST_NAME + '%' OR @p_COST_NAME IS NULL OR @p_COST_NAME = '')
		AND (A.COST_CODE like + '%' + @p_COST_CODE + '%' OR @p_COST_CODE IS NULL OR @p_COST_CODE = '')
		AND (A.NOTES LIKE '%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
		AND (A.RECORD_STATUS LIKE '%' + @p_RECORD_STATUS + '%' OR @p_RECORD_STATUS IS NULL OR @p_RECORD_STATUS = '')
		AND (A.MAKER_ID LIKE '%' + @p_MAKER_ID + '%' OR @p_MAKER_ID IS NULL OR @p_MAKER_ID = '')
		AND (DATEDIFF(DAY,A.CREATE_DT ,CONVERT(DATETIME, @p_CREATE_DT, 103)) =0 OR  @p_CREATE_DT IS NULL OR @p_CREATE_DT = '')
		AND (A.AUTH_STATUS LIKE '%' + @p_AUTH_STATUS + '%' OR @p_AUTH_STATUS IS NULL OR @p_AUTH_STATUS = '')
			AND (A.CHECKER_ID LIKE '%' + @p_CHECKER_ID + '%' OR @p_CHECKER_ID IS NULL OR @p_CHECKER_ID = '')
		AND (DATEDIFF(DAY,A.APPROVE_DT ,CONVERT(DATETIME, @p_APPROVE_DT, 103)) = 0 OR  @p_APPROVE_DT IS NULL OR @p_APPROVE_DT = '')
		--AND A.RECORD_STATUS = '1'
-- PAGING END
   ELSE
-- PAGING BEGIN
		SELECT TOP(CONVERT(INT, @p_TOP))A.*,B.AUTH_STATUS_NAME,
		CASE
			WHEN A.RECORD_STATUS = 1 THEN N'Hoạt động'
			ELSE N'Không hoạt động'
		END AS RECORD_STATUS_NAME
		--,T.PLAN_TYPE_NAME
-- SELECT END
		FROM dbo.PL_COSTCENTER A 
		LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
        JOIN CM_DVDM cd ON A.DVDM_ID = cd.DVDM_ID AND cd.IS_DVDM =1
		--LEFT JOIN dbo.CM_PLAN_TYPE T ON T.PLAN_TYPE_ID=A.PLAN_TYPE_ID
		WHERE 1 = 1
	     AND (A.PLAN_TYPE_ID like + '%' + @p_PLAN_TYPE_ID + '%' OR @p_PLAN_TYPE_ID IS NULL OR @p_PLAN_TYPE_ID = '')
		AND (A.COST_NAME like '%' + @p_COST_NAME + '%' OR @p_COST_NAME IS NULL OR @p_COST_NAME = '')
		AND (A.COST_CODE like + '%' + @p_COST_CODE + '%' OR @p_COST_CODE IS NULL OR @p_COST_CODE = '')
		AND (A.NOTES LIKE '%' + @p_NOTES + '%' OR @p_NOTES IS NULL OR @p_NOTES = '')
		AND (A.RECORD_STATUS LIKE '%' + @p_RECORD_STATUS + '%' OR @p_RECORD_STATUS IS NULL OR @p_RECORD_STATUS = '')
		AND (A.MAKER_ID LIKE '%' + @p_MAKER_ID + '%' OR @p_MAKER_ID IS NULL OR @p_MAKER_ID = '')
		AND (DATEDIFF(DAY,A.CREATE_DT ,CONVERT(DATETIME, @p_CREATE_DT, 103)) =0 OR  @p_CREATE_DT IS NULL OR @p_CREATE_DT = '')
		AND (A.AUTH_STATUS LIKE '%' + @p_AUTH_STATUS + '%' OR @p_AUTH_STATUS IS NULL OR @p_AUTH_STATUS = '')
		AND (A.CHECKER_ID LIKE '%' + @p_CHECKER_ID + '%' OR @p_CHECKER_ID IS NULL OR @p_CHECKER_ID = '')
		AND (DATEDIFF(DAY,A.APPROVE_DT ,CONVERT(DATETIME, @p_APPROVE_DT, 103)) = 0 OR  @p_APPROVE_DT IS NULL OR @p_APPROVE_DT = '')
		--AND A.RECORD_STATUS = '1'
-- PAGING END
END -- PAGING
GO