INSERT INTO [TR_REQUEST_JOB_FORM] ([REQ_ID],[REQ_CODE],[REQ_DT],[REF_ID],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[REQ_REASON],[REQ_DESC],[NOTES],[REQ_TYPE_TRANS],[REQ_TYPE_GROUP],[REQ_TYPE_BOOKING_HOTEL],[REQ_TYPE_BOOKING_AIR],[REQ_TYPE_BOOKING_TRAIN],[SENDER_ID],[SEND_DT],[SIGN_USER],[SIGN_DT],[PROCESS_ID],[BRANCH_CREATE],[DEP_CREATE],[BRANCH_ID],[DEP_ID],[FRMDATE],[TODATE],[IS_SEND_APPR],[COST_AMOUNT])VALUES(N'TRJF00000000001',N'AFT-22-000001',NULL,N'baotq',N'baotq',N'Apr 12 2022 9:56AM',N'A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'DV0001',N'DEP000000000028',NULL,NULL,NULL,NULL,N'N',90000000)
go
INSERT INTO [TR_REQUEST_JOB_DETAIL] ([REQ_DT_ID],[REQ_ID],[EMP_ID],[TLNANME],[BRANCH_ID],[DEP_ID],[PHONE],[NOTES],[AUTH_STATUS])VALUES(N'TRJD00000000001',N'TRJF00000000001',N'EMP000000000119',N'tuanva',N'DV0001',N'DEP000000000028',N'0376869390',N'',N'')
go
INSERT INTO [TR_REQ_JOB_TRIP] ([TRIP_ID],[REQ_ID],[TIME_TRIP],[DAY_TRIP],[FROM_TRIP],[TO_TRIP],[NOTES],[AUTH_STATUS])VALUES(N'RJT000000000001',N'TRJF00000000001',N'10:54',N'Apr 12 2022 12:00AM',N'01',N'02',N'',N'')
go
INSERT INTO [TR_REQ_JOB_RETURN_TRIP] ([RETURN_ID],[REQ_ID],[TIME_RETURN],[DAY_RETURN],[FROM_RETURN],[TO_RETURN],[NOTES],[AUTH_STATUS])VALUES(N'RJRT00000000001',N'TRJF00000000001',N'10:55',N'Apr 13 2022 12:00AM',N'02',N'01',N'',N'')
go
INSERT INTO [TR_REQ_JOB_FLY] ([FLY_ID],[REQ_ID],[TIME_FLY],[DAY_FLY],[COST],[NOTES],[AUTH_STATUS])VALUES(N'RJF000000000001',N'TRJF00000000001',N'10:54',NULL,6000000.00,N'',N'')


insert into SYS_PREFIX ([ID], Prefix, Description)
VALUES('TR_REQ_PAY_JOB_DT', 'PJDT', N'Chi tiết phiếu yêu cầu công tác')

insert into SYS_PREFIX ([ID], Prefix, Description)
VALUES('TR_REQ_PAY_JOB', 'TRPJ', N'Phiếu yêu cầu công tác')

insert into SYS_PREFIX ([ID], Prefix, Description)
VALUES('TR_REQ_PAY_DRIVE', 'TRDR', N'Thông chi chi phí vận hành xe')

insert into SYS_PREFIX ([ID], Prefix, Description)
VALUES('TR_REQ_PAY_DRIVE_DT', 'TRDDT', N'Bảng kê chi phí sử dụng nhiên liệu')


CREATE TABLE BANK_OUTSIDE(
BANK_OUTSIDE_ID VARCHAR(20),
BANK_OUTSIDE_CODE VARCHAR(20),
BANK_OUTSIDE_NAME NVARCHAR(250),
NOTE NVARCHAR(250),
MAKER_ID VARCHAR(20),
CREATE_DT VARCHAR(20),
AUTH_STATUS VARCHAR(1)
)



CREATE PROCEDURE [dbo].[BANK_OUTSIDE_Search]
@p_BANK_OUTSIDE_ID	varchar(20)  = NULL,
@p_BANK_OUTSIDE_CODE	varchar(20)  = NULL,
@p_BANK_OUTSIDE_NAME	varchar(20)  = NULL,
@p_TOP	INT = NULL
AS
BEGIN -- PAGING

IF @p_TOP = 300 SET @p_TOP = 1000

IF(@p_TOP IS NULL OR @P_TOP = '' OR @P_TOP = 0)
-- PAGING BEGIN
-- SELECT END
SELECT A.*
FROM BANK_OUTSIDE A 
 WHERE 1 = 1
	AND (A.BANK_OUTSIDE_CODE LIKE '%' + @p_BANK_OUTSIDE_CODE + '%' OR  @p_BANK_OUTSIDE_CODE IS NULL OR @p_BANK_OUTSIDE_CODE = '')
	AND (A.BANK_OUTSIDE_NAME LIKE '%' + @p_BANK_OUTSIDE_NAME + '%' OR  @p_BANK_OUTSIDE_NAME IS NULL OR @p_BANK_OUTSIDE_NAME = '')
	ORDER BY A.BANK_OUTSIDE_CODE
-- PAGING END
ELSE
-- PAGING BEGIN
SELECT TOP(CONVERT(INT,@P_TOP))A.*
-- SELECT END
FROM BANK_OUTSIDE A 
 WHERE 1 = 1
	AND (A.BANK_OUTSIDE_CODE LIKE '%' + BANK_OUTSIDE_CODE + '%' OR  BANK_OUTSIDE_CODE IS NULL OR BANK_OUTSIDE_CODE = '')
	AND (A.BANK_OUTSIDE_NAME LIKE '%' + BANK_OUTSIDE_CODE + '%' OR  @p_BANK_OUTSIDE_NAME IS NULL OR @p_BANK_OUTSIDE_NAME = '')
	ORDER BY A.BANK_OUTSIDE_CODE
-- PAGING END
END -- PAGING