ALTER PROCEDURE [dbo].[PL_IMPORT_Search]
	@p_PLAN_CODE	varchar(15)  = NULL,
	@p_IMP_YEAR	int  = NULL,
	@p_IMP_NAME NVARCHAR(200),
	@p_FILE_NAME VARCHAR(20)=NULL,
	@p_NOTES	nvarchar(1000)  = NULL,
	@p_RECORD_STATUS	varchar(1)  = NULL,
	@p_MAKER_ID	varchar(20)  = NULL,
	@p_CREATE_DT	DATETIME = NULL,
	@p_AUTH_STATUS	varchar(50)  = NULL,
	@p_CHECKER_ID	varchar(20)  = NULL,
	@p_APPROVE_DT	DATETIME = NULL,
	@P_TOP INT = 10
AS
BEGIN
	IF(@P_TOP = NULL OR @P_TOP = '' OR @P_TOP = 0)
		SELECT A.*,B.AUTH_STATUS_NAME,MA.TLFullName AS MAKER_NAME,AP.TLFullName AS APPROVE_NAME
		FROM dbo.PL_IMPORT A 
		LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
		LEFT JOIN dbo.TL_USER MA ON MA.TLNANME=A.EDITER_ID
		LEFT JOIN dbo.TL_USER AP ON AP.TLNANME=A.CHECKER_ID
	
		WHERE 1 = 1
	    AND (A.PLAN_CODE like + '%' + @p_PLAN_CODE + '%' OR @p_PLAN_CODE IS NULL OR @p_PLAN_CODE = '')
		AND (A.IMP_YEAR =@p_IMP_YEAR OR @p_IMP_YEAR IS NULL )
		AND (A.IMP_NAME like + '%' + @p_IMP_NAME + '%' OR @p_IMP_NAME IS NULL OR @p_IMP_NAME = '')
		AND (A.FILE_NAME like + '%' + @p_FILE_NAME + '%' OR @p_FILE_NAME IS NULL OR @p_FILE_NAME = '')
		
		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'
   ELSE
		SELECT A.*,B.AUTH_STATUS_NAME,MA.TLFullName AS MAKER_NAME,AP.TLFullName AS APPROVE_NAME
		FROM dbo.PL_IMPORT A 
		LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS = B.AUTH_STATUS
		LEFT JOIN dbo.TL_USER MA ON MA.TLNANME=A.MAKER_ID
		LEFT JOIN dbo.TL_USER AP ON AP.TLNANME=A.CHECKER_ID
	
	
		WHERE 1 = 1
	    AND (A.PLAN_CODE like + '%' + @p_PLAN_CODE + '%' OR @p_PLAN_CODE IS NULL OR @p_PLAN_CODE = '')
		AND (A.IMP_YEAR =@p_IMP_YEAR OR @p_IMP_YEAR IS NULL )
		AND (A.IMP_NAME like + '%' + @p_IMP_NAME + '%' OR @p_IMP_NAME IS NULL OR @p_IMP_NAME = '')
		AND (A.FILE_NAME like + '%' + @p_FILE_NAME + '%' OR @p_FILE_NAME IS NULL OR @p_FILE_NAME = '')
		
		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'
END