iVend Database Database : ReplicationGetMobileSites Stored Procedure

Creation Date

4/13/2015 12:00 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

CfgSiteInformation

Table

Stores the site information. Enterprise always has the site id as 1. System Table Warning : Should not be modified directly

1

RepReplicationSendStatusMobile

Table

Table used to track the replication record status

1

RtlPOS

Table

Contains details about all POS defined in the system.

1

RtlStore

Table

Contains the details of Stores defined in the system.

1

CREATE PROCEDURE [dbo].[ReplicationGetMobileSites]

AS

BEGIN

SET NOCOUNT ON

Declare @lDataSourceType INT,

  @SiteId   INT

Select @SiteId = SiteId, @lDataSourceType = CASE WHEN SiteId = 1 THEN 1 ELSE 2 END

from CfgSiteInformation

Print @lDataSourceType

SELECT A.DeviceId, IsNull(B.Id, 'POS') as Description

FROM RepReplicationSendStatusMobile A, RtlPOS B, RtlStore C

WHERE B.HardwareId = A.DeviceId AND B.StoreKey = C.StoreKey AND IsNull(B.IsDeleted,'False') = 'False'

  AND

  ((@lDataSourceType = 1 AND B.DataSourceType = @lDataSourceType)

  OR

  (@lDataSourceType <> 1 AND C.SiteId= @SiteId))

END