Added an option to by pass the claim review and process claims

hirensoni913 · hirensoni913 · commit cca7eb7921c9 · 2022-04-08T10:20:51.000+03:00
diff --git a/sql/base/1_schema_tables.sql b/sql/base/1_schema_tables.sql
@@ -1365,7 +1365,8 @@ CREATE TABLE [dbo].[tblIMISDefaults](
 	[AppVersionFeedbackRenewal] [decimal](3, 1) NULL,
 	[AppVersionImis] [decimal](3, 1) NULL,
 	[APIKey] [nvarchar](100) NULL,
-	[ActivationOption] tinyint NOT NULL 
+	[ActivationOption] tinyint NOT NULL,
+	[BypassReviewClaim] BIT NOT NULL
  CONSTRAINT [PK_tblIMISDefaults] PRIMARY KEY CLUSTERED 
 (
 	[DefaultID] ASC
@@ -1376,6 +1377,8 @@ GO
 ALTER TABLE [tblIMISDefaults] ADD CONSTRAINT ActivationOptionDefaultConstraint DEFAULT ((2)) FOR [ActivationOption]
 GO
 
+ALTER TABLE [tblIMISDefaults] ADD CONSTRAINT DF_BypassReviewClaim DEFAULT ((0)) FOR [BypassReviewClaim]
+GO
 
 SET ANSI_NULLS ON
 GO
diff --git a/sql/base/6_bundle_stored_procedures.sql b/sql/base/6_bundle_stored_procedures.sql
@@ -14029,7 +14029,31 @@ UPDATECLAIM:
 			--no rejections 
 			UPDATE tblClaim SET ClaimStatus = 4, AuditUserIDSubmit = @AuditUser , SubmitStamp = GETDATE() ,  ClaimCategory = @BaseCategory WHERE ClaimID = @ClaimID 
 		END
-		SET @RtnStatus = 1 
+		SET @RtnStatus = 1;
+		
+		--Check the default settings, if the review is bypassed process the claim
+		DECLARE @BypassReviewClaim BIT;
+		SELECT @BypassReviewClaim = ISNULL(BypassReviewClaim, 0) FROM tblIMISDefaults;
+		
+		IF @BypassReviewClaim = 1
+		BEGIN
+			DECLARE @xtClaimSubmit dbo.xClaimSubmit;
+			INSERT INTO @xtClaimSubmit(ClaimId, RowID)
+			SELECT ClaimId, RowID FROM tblClaim WHERE ClaimID = @ClaimID;
+
+			DECLARE @RC int
+			DECLARE @Submitted int
+			DECLARE @Processed int
+			DECLARE @Valuated int
+			DECLARE @Changed int
+			DECLARE @Rejected int
+			DECLARE @Failed int
+			
+
+			EXEC @oReturnValue =  uspProcessClaims @AuditUser, @xtClaimSubmit, @Submitted OUTPUT, @Processed OUTPUT, @Valuated OUTPUT, @Changed OUTPUT, @Rejected OUTPUT, @Failed OUTPUT, @oReturnValue OUTPUT
+			
+		END
+
 	END
 	ELSE
 	BEGIN
@@ -14043,14 +14067,13 @@ FINISH:
 	END TRY
 	
 	BEGIN CATCH
-		SELECT 'Unexpected error encountered'
+		SELECT ERROR_MESSAGE()
 		SET @oReturnValue = 1 
 		RETURN @oReturnValue
 		
 	END CATCH
 END
 GO
-
 SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON
