19 |
|
|
20 |
/* |
/* |
21 |
* TODO: håndtering af entry dupletter ! (+ rapportering af dem) |
* TODO: håndtering af entry dupletter ! (+ rapportering af dem) |
22 |
|
* TODO: ajourføring af DBKbane |
23 |
|
DAO: |
24 |
|
UPDATE fulddaekning.adressetabel |
25 |
|
SET dbkbane = case |
26 |
|
when substr(korelisteMa,1,2) IN ('07','10','11','12','14','15','16','18','19','20') then 205 #DAO-BRA |
27 |
|
when substr(korelisteMa,1,2) BETWEEN 24 and 30 then 201 #DAO-Ovrige |
28 |
|
else 202 #dao syd (52-99= |
29 |
|
END |
30 |
|
WHERE distributor='DAO' |
31 |
|
AND ruteMa is not null; |
32 |
|
|
33 |
|
FD: Altid 200 |
34 |
|
NS: Altid 204 |
35 |
|
BK: 195,196,197,198 |
36 |
|
|
37 |
|
|
38 |
*/ |
*/ |
39 |
|
|
40 |
public class AddressManager { |
public class AddressManager { |
173 |
if (addr.state == AddressState.NOT_CHANGED) { |
if (addr.state == AddressState.NOT_CHANGED) { |
174 |
continue; |
continue; |
175 |
} |
} |
176 |
if (addr.stateMan == AddressState.NOT_CHANGED || addr.stateMan == AddressState.CREATED) { |
/*if (addr.stateMan == AddressState.NOT_CHANGED || addr.stateMan == AddressState.CREATED) { |
177 |
continue; |
continue; |
178 |
} |
}*/ |
179 |
|
|
180 |
if (addr.stateMan != AddressState.MODIFIED ) { |
if (addr.stateMan != AddressState.OPENED ) { |
181 |
continue; |
continue; |
182 |
} |
} |
183 |
|
|
206 |
} |
} |
207 |
|
|
208 |
DatabaseLayerImplementation db = new DatabaseLayerImplementation(); |
DatabaseLayerImplementation db = new DatabaseLayerImplementation(); |
209 |
|
|
210 |
db.updateAddresses(updates); |
db.updateAddresses(updates); |
211 |
|
|
212 |
|
|
213 |
|
|
214 |
System.out.println("Writeback done: elapsed " + timer.getElapsed() + "ms."); |
System.out.println("Writeback done: elapsed " + timer.getElapsed() + "ms."); |
215 |
} |
} |
294 |
return; |
return; |
295 |
} |
} |
296 |
|
|
297 |
addr.visited = true; |
|
|
if (addr.state == AddressState.NOT_CHANGED) { |
|
|
if (addr.distributor == null) { |
|
|
addr.state = AddressState.OPENED; |
|
|
addr.distributor = entry.distributor; |
|
|
} else { |
|
|
addr.state = AddressState.MODIFIED; |
|
|
} |
|
|
} |
|
298 |
|
|
299 |
if (entry.ugedage.mandag) { |
if (entry.ugedage.mandag) { |
300 |
addr.visitedMan = true; |
addr.visitedMan = true; |
414 |
} |
} |
415 |
} |
} |
416 |
} |
} |
417 |
|
|
418 |
|
|
419 |
|
|
420 |
|
addr.visited = true; |
421 |
|
if (addr.state == AddressState.NOT_CHANGED) { |
422 |
|
if (addr.distributor == null) { |
423 |
|
addr.state = AddressState.OPENED; |
424 |
|
addr.distributor = entry.distributor; |
425 |
|
} else { |
426 |
|
if (addr.stateMan != AddressState.NOT_CHANGED || addr.stateTir != AddressState.NOT_CHANGED |
427 |
|
|| addr.stateOns != AddressState.NOT_CHANGED || addr.stateTor != AddressState.NOT_CHANGED |
428 |
|
|| addr.stateFre != AddressState.NOT_CHANGED || addr.stateLor != AddressState.NOT_CHANGED || addr.stateSon != AddressState.NOT_CHANGED ){ |
429 |
|
|
430 |
|
addr.state = AddressState.MODIFIED; |
431 |
|
} |
432 |
|
} |
433 |
|
} |
434 |
|
|
435 |
|
|
436 |
} |
} |