You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
81 lines
4.3 KiB
81 lines
4.3 KiB
USE [FastMoneyPro_Remit]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[proc_dropDownListsInboundApi] Script Date: 5/6/2024 9:04:42 AM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
ALTER PROC [dbo].[proc_dropDownListsInboundApi]
|
|
@flag VARCHAR(200)
|
|
,@param VARCHAR(200) = NULL
|
|
,@param1 VARCHAR(200) = NULL
|
|
,@user VARCHAR(30) = NULL
|
|
,@branchId INT = NULL
|
|
,@country VARCHAR(50) = NULL
|
|
,@agentId VARCHAR(50) = NULL
|
|
,@countryId INT = NULL
|
|
,@countryName VARCHAR(100) = NULL
|
|
,@userType VARCHAR(20) = NULL
|
|
,@groupId INT = NULL
|
|
--,@parentId INT = NULL
|
|
AS
|
|
SET NOCOUNT ON;
|
|
|
|
IF @flag = 'a-countryPay'
|
|
BEGIN
|
|
SELECT
|
|
countryId,
|
|
UPPER(countryName) countryName
|
|
FROM countryMaster
|
|
WHERE ISNULL(isOperativeCountry,'') = 'Y'
|
|
AND ISNULL(operationType,'B') IN ('B','R')
|
|
ORDER BY countryName ASC
|
|
RETURN
|
|
END
|
|
|
|
IF @flag = 'a-countrySend'
|
|
BEGIN
|
|
SELECT
|
|
countryId,
|
|
UPPER(countryName) countryName
|
|
FROM countryMaster
|
|
WHERE ISNULL(isOperativeCountry,'') = 'Y'
|
|
AND ISNULL(operationType,'B') IN ('B','S')
|
|
--AND countryName='UNITED KINGDOM' -- new added as send country is always korea other remove this condition: sugg by (Prahlad Sir)
|
|
ORDER BY countryName ASC
|
|
RETURN;
|
|
END
|
|
|
|
IF @flag = 'agentSend'
|
|
BEGIN
|
|
SELECT
|
|
agentId,
|
|
agentName agentName
|
|
FROM agentMaster am WITH(NOLOCK)
|
|
WHERE ISNULL(am.agentrole,'B') IN ('B','S')
|
|
AND agentCountryId = @param
|
|
AND isSettlingAgent = 'Y'
|
|
AND ISNULL(am.isActive,'Y') ='Y'
|
|
AND ISNULL(am.isDeleted,'N') = 'N'
|
|
ORDER BY agentName ASC
|
|
RETURN
|
|
END
|
|
|
|
ELSE IF @flag = 'branch' -- Select branchName List According to CountryName and AgentName
|
|
BEGIN
|
|
SELECT
|
|
agentId,
|
|
agentName
|
|
FROM agentMaster am WITH(NOLOCK)
|
|
WHERE ISNULL(am.isDeleted, 'N') <> 'Y'
|
|
AND am.agentType = '2904' AND isActive = 'Y'
|
|
AND am.agentCountryId = ISNULL(@country,am.agentCountryId) AND am.parentId = ISNULL(@agentId,am.parentId)
|
|
ORDER BY agentName ASC
|
|
RETURN
|
|
END
|
|
|
|
|
|
|
|
|
|
|