10 |
import java.util.List; |
import java.util.List; |
11 |
import java.util.Map; |
import java.util.Map; |
12 |
|
|
13 |
import dk.daoas.daoadresseservice.DaekningsType; |
import dk.daoas.daoadresseservice.AddressUtils; |
14 |
import dk.daoas.daoadresseservice.beans.Address; |
import dk.daoas.daoadresseservice.beans.Address; |
15 |
import dk.daoas.daoadresseservice.beans.AliasBean; |
import dk.daoas.daoadresseservice.beans.AliasBean; |
16 |
import dk.daoas.daoadresseservice.beans.ExtendedBean; |
import dk.daoas.daoadresseservice.beans.ExtendedBean; |
17 |
import dk.daoas.daoadresseservice.beans.HundredePctBean; |
import dk.daoas.daoadresseservice.beans.HundredePctBean; |
|
import dk.daoas.daoadresseservice.beans.LoggedAddress; |
|
18 |
import dk.daoas.daoadresseservice.beans.SearchResult; |
import dk.daoas.daoadresseservice.beans.SearchResult; |
19 |
import dk.daoas.daoadresseservice.util.DeduplicateHelper; |
import dk.daoas.daoadresseservice.util.DeduplicateHelper; |
20 |
|
|
74 |
|
|
75 |
//a.vasketVejnavn = AddressUtils.vaskVejnavn(a.vejnavn); |
//a.vasketVejnavn = AddressUtils.vaskVejnavn(a.vejnavn); |
76 |
|
|
77 |
if (a.rute != null && a.rute.length()> 0) { |
|
78 |
a.daekningsType = DaekningsType.DAEKNING_DIREKTE; |
//Ajourfør adresse objectets dækningstype |
79 |
} else { |
AddressUtils.updateDaekningstype(a); |
|
a.daekningsType = DaekningsType.DAEKNING_IKKEDAEKKET; |
|
|
} |
|
80 |
|
|
81 |
list.add(a); |
list.add(a); |
82 |
} |
} |
250 |
} |
} |
251 |
} |
} |
252 |
|
|
|
/* |
|
|
* Bruges til at sammenligne gammel og ny adresse service - kan fjernes engang efter at vi er skiftet til ny service |
|
|
*/ |
|
|
@Deprecated |
|
|
public static List<LoggedAddress> getLoggedAdresses(int antaldage) throws SQLException { |
|
|
String sql = "select postnr,adresse,status from logs.hentruteinformation where indlast>=date_sub(curdate(), interval " + antaldage + " day) " + |
|
|
"and status IN (10,11,12) " + |
|
|
"group by postnr,adresse " |
|
|
; |
|
|
|
|
|
try ( Connection conn = DBConnection.getConnection(); |
|
|
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
|
|
) { |
|
|
|
|
|
|
|
|
stmt.setFetchSize(Integer.MIN_VALUE); |
|
|
|
|
|
ResultSet res = stmt.executeQuery(sql); |
|
|
|
|
|
List<LoggedAddress> result = new ArrayList<LoggedAddress>(); |
|
|
|
|
|
while (res.next()) { |
|
|
LoggedAddress a = new LoggedAddress(); |
|
|
a.postnr = res.getInt(1); |
|
|
a.adresse = res.getString(2); |
|
|
a.status = res.getInt(3); |
|
|
|
|
|
result.add(a); |
|
|
} |
|
|
|
|
|
res.close(); |
|
253 |
|
|
|
return result; |
|
|
} |
|
|
} |
|
254 |
|
|
255 |
|
|
256 |
private static int safeInt(String str) { |
private static int safeInt(String str) { |