Skip to content
logo
platformaerp.com

Lokacje

Konfiguracja dla regalow automatyczych

oparta jest na 4 wartosciach w tabeli wms.location

  • rack - regal
  • shelf - polka
  • section - sekcja
  • ipaddress - adres ip

Usunięcie powiązania z automatycznymi regałami

SQL
1
2
3
4
5
update [wms].[location]
set rack=null,shelf=null,section=null,ipaddress=null
  FROM [wms].[location]
  where status >-1 and rack in ('xxx','xxxx')
  and locationcode like '112%'

Listowanie lokacji dla regału X

SQL
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
select
    [locationCode], [locationName],[rack], [shelf], [section], [row], [ipAddress],
    [locationID], [warehouseID],  [locationTypeID],
    [groupID], [addDate], [addUsername], [modDate], [modUsername], [status], [remoteSource], [remoteID],
    [parentID], [isLocationRequiredSince], [isLocationRequired], [isIncomeBlockedSince], [isOutcomeBlocked],
    [isOutcomeBlockedSince], [isIncomeBlocked], [warehouseValuationMethod]
from
    wms.location
where
    rack ='1' --nr regału
    and status>-1
order by
    [rack],
    cast ([shelf] as int),
    cast ([section] as int),
    [row]

Dodanie lokacji na podstawie innej lokacji

SQL
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
declare @rack varchar(20) ='1'
declare @shelf varchar(20) ='40'
declare @section varchar(20) ='3'
declare @locationcode varchar(20) ='102-R'+ @rack +'-' + @shelf + '-' +@section

insert into wms.location (
    [locationCode], [locationName],[rack], [shelf], [section], [row], [ipAddress],
    [warehouseID],  [locationTypeID],
    [groupID], [addDate], [addUsername], [modDate], [modUsername], [status], [remoteSource], [remoteID],
    [parentID], [isLocationRequiredSince], [isLocationRequired], [isIncomeBlockedSince], [isOutcomeBlocked],
    [isOutcomeBlockedSince], [isIncomeBlocked], [warehouseValuationMethod]
    )

select
    @locationcode, @locationcode,@rack, @shelf, @section, [row] , [ipAddress],
    [warehouseID],  [locationTypeID],
    [groupID],  getutcdate(), 'sys', getutcdate(), 'sys', [status], [remoteSource], [remoteID],
    [parentID], [isLocationRequiredSince], [isLocationRequired], [isIncomeBlockedSince], [isOutcomeBlocked],
    [isOutcomeBlockedSince], [isIncomeBlocked], [warehouseValuationMethod]
from
    wms.location
where
    locationid = 'CC39DFAD-7C7D-4C96-ABB8-084382DDEE0D'

/*TEST*/
select
 [locationCode] ,[locationName],ipAddress, [rack]  ,[shelf] ,[section] ,[row]
from wms.location with(nolock)
where
    rack ='3' and status >-1
order by
     warehouseid,rack,cast (shelf as int) ,cast (section as int),row,   locationname

Dodanie lokacji na podstawie grupy

SQL
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
insert into [wms].[location]
(
 [warehouseID]
      ,[locationCode]
      ,[locationName]
      ,[locationTypeID]
      ,[groupID]
      ,[addUsername]
      ,[modUsername]
      ,[status]
      ,[remoteSource]
      ,[remoteID]
      ,[parentID]
      ,[isLocationRequiredSince]
      ,[isLocationRequired]
      ,[rack]
      ,[shelf]
      ,[section]
      ,[row]
      ,[ipAddress]
      ,[isIncomeBlockedSince]
      ,[isOutcomeBlocked]
      ,[isOutcomeBlockedSince]
      ,[isIncomeBlocked]
      ,[warehouseValuationMethod]
      )
SELECT TOP (1000) '94121E98-E1A1-49AD-A133-8BF228E11A3D'
      ,replace(locationcode,'101','102')
      ,replace([locationName],'101','102')
      ,[locationTypeID]
      ,[groupID]
      ,'sys'
      ,'sys'
      ,[status]
      ,[remoteSource]
      ,[remoteID]
      ,'94121E98-E1A1-49AD-A133-8BF228E11A3D'
      ,[isLocationRequiredSince]
      ,[isLocationRequired]
      ,[rack]
      ,[shelf]
      ,[section]
      ,[row]
      ,[ipAddress]
      ,[isIncomeBlockedSince]
      ,[isOutcomeBlocked]
      ,[isOutcomeBlockedSince]
      ,[isIncomeBlocked]
      ,[warehouseValuationMethod]
  FROM [wms].[location]
  where
    locationcode like '101-R3-36%'
    or locationcode like '101-R3-37%'
    or locationcode like '101-R3-38%'
    or locationcode like '101-R3-39%'
    or locationcode like '101-R3-40%'
    or locationcode like '101-R3-41%'
    or locationcode like '101-R3-42%'
    or locationcode like '101-R3-47%'