daoas/daoadresseservice/AdressSearch.java

package dk.daoas.daoadresseservice;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.concurrent.ConcurrentHashMap;

import dk.daoas.daoadresseservice.AddressUtils.SplitResult;
import dk.daoas.daoadresseservice.beans.Address;
import dk.daoas.daoadresseservice.beans.ExtendedBean;
import dk.daoas.daoadresseservice.beans.HundredePctBean;
import dk.daoas.daoadresseservice.beans.SearchResult;
import dk.daoas.daoadresseservice.beans.SearchResult.Status;
import dk.daoas.daoadresseservice.db.DatabaseLayer;

public class AdressSearch {

        Map<Integer, Map<String,Long>> searchPostnrVejnavnGadeid;       
        Map<Long,  Map<String,Address>> searchGadeidentAdresser;

        List<Address> alleAdresser;
        
        
        Map<Integer,HundredePctBean> hundredePct;
        
        
        public SearchResult search(String postnrStr, String adresse)  {
                long start1 = System.currentTimeMillis();
                
                int postnr=0;
                
                try {
                        postnr = Integer.parseInt(postnrStr);
                } catch (Exception E) {
                        return new SearchResult(Status.ERROR_UNKNOWN_POSTAL);
                }               
                long start2 = System.currentTimeMillis();
                
                Map<String,Long> postnrVeje = searchPostnrVejnavnGadeid.get(postnr);                    
                
                if (postnrVeje == null) {
                        return new SearchResult(Status.ERROR_UNKNOWN_POSTAL);
                }
                
                long start3 = System.currentTimeMillis();
                
                SplitResult split = AddressUtils.splitAdresse(adresse);
                String vasketVejnavn = AddressUtils.vaskVejnavn( split.vej );                           
                
                if (split.husnr.length() == 0) {
                        return new SearchResult(Status.ERROR_MISSING_HOUSENUMBER);                      
                }
                long start4 = System.currentTimeMillis();
                
                Long gadeident =  postnrVeje.get(vasketVejnavn);
                if (gadeident == null) {
                        return new SearchResult(Status.ERROR_UNKNOWN_STREETNAME);
                }
                long start5 = System.currentTimeMillis();
                
                Map<String, Address> gade =  searchGadeidentAdresser.get(gadeident); //Denne søgning må ikke fejle
                
                long start6 = System.currentTimeMillis();
                
                String husnrSearch = "" + split.husnr + split.litra;
                Address addr = gade.get(husnrSearch);
                long start7 = System.currentTimeMillis();
                if (addr == null) {
                        return new SearchResult(Status.ERROR_UNKNOWN_ADDRESSPOINT);
                }
                
                if (addr.daekningsType == DaekningsType.DAEKNING_IKKEDAEKKET) {
                        return new SearchResult(Status.STATUS_NOT_COVERED);
                }
                
                if (addr.distributor.equals("LUKKET")) {
                        return new SearchResult(Status.STATUS_NOT_COVERED); //Skal vi have en special status til Lukkede adresser ?
                }
                
                System.out.println("Search2: " + (start2-start1) );
                System.out.println("Search3: " + (start3-start1) );
                System.out.println("Search4: " + (start4-start1) );
                System.out.println("Search5: " + (start5-start1) );
                System.out.println("Search6: " + (start6-start1) );
                System.out.println("Search7: " + (start7-start1) );

                                
                
                return new SearchResult(addr);
        }
        
        
        public void buildSearchStructures() throws SQLException{
                searchPostnrVejnavnGadeid = new HashMap<Integer, Map<String,Long>>();
                searchGadeidentAdresser = new HashMap<Long,  Map<String,Address>>();
                                
                System.out.println("Build -- stage 1");
                
                alleAdresser = DatabaseLayer.getAllAdresses();
                
                
                /* Mapper mellem db Row ID og adresse noden */
                Map<Integer,Address> idAddressMap = new HashMap<Integer,Address>( alleAdresser.size() );
                
                for (Address a : alleAdresser) {
                        idAddressMap.put(a.id, a);
                        
                        Map<String,Long> postnrVeje = searchPostnrVejnavnGadeid.get(a.postnr);          
                        
                        if (postnrVeje == null) {
                                postnrVeje = new ConcurrentHashMap<String,Long>();
                                searchPostnrVejnavnGadeid.put(a.postnr, postnrVeje);
                        }
                        
                        String vasketVejnavn = AddressUtils.vaskVejnavn(a.vejnavn);
                        Long gadeident = postnrVeje.get(vasketVejnavn);
                        if (gadeident == null) {
                                postnrVeje.put(vasketVejnavn, a.gadeid);
                        }
                        
                        Map<String, Address> gade =  searchGadeidentAdresser.get(a.gadeid); 
                        if (gade == null) {
                                gade = new HashMap<String, Address>();
                                searchGadeidentAdresser.put(a.gadeid, gade);
                        }
                        String husnrSearch = "" + a.husnr + a.husnrbogstav;
                        gade.put(husnrSearch, a);                       
                }
                
                
                ////////////////////////////////////////////////////////////////////////////////////////
                System.out.println("Build -- stage 2 udvidet dækning");
                
                List<ExtendedBean> extDao = DatabaseLayer.getExtendedAdresslist();
                for (ExtendedBean eb : extDao) {
                        
                        Address orgAddress = idAddressMap.get(eb.orgId);                        
                        if (orgAddress == null)
                                continue;
                        
                        Address targetAddress = idAddressMap.get(eb.targetId);
                        if (targetAddress == null)
                                continue;
                        
                        if (orgAddress.distributor != null && orgAddress.distributor.equals("LUKKET")) {
                                continue;
                        }                       
                        
                        if (targetAddress.distributor.equals("LUKKET")) {
                                continue;
                        }
                        
                        orgAddress.extTarget = targetAddress;
                        orgAddress.extAfstand = eb.afstand;

                        boolean covered = false;
                        if (targetAddress.distributor.equals("DAO")) {
                                orgAddress.rute = calculateExtendedDaoRoute(eb,orgAddress,targetAddress);                               
                                if (orgAddress.rute != null) {
                                        orgAddress.koreliste = targetAddress.koreliste;
                                        covered = true;
                                }
                        }
                        
                        if (targetAddress.distributor.equals("BK")) {
                                orgAddress.koreliste = calculateExtendedBkKoreliste(eb,orgAddress,targetAddress);                               
                                if (orgAddress.koreliste != null) {
                                        orgAddress.rute = targetAddress.rute;
                                        covered = true;
                                }
                        }
                        
                        if (covered) { //Kopier resten af felterne
                                orgAddress.daekningsType = DaekningsType.DAEKNING_UDVIDET;
                                orgAddress.dbkBane = targetAddress.dbkBane;
                                
                                /* Sådan gør den gamle service */
                                orgAddress.kommunekode = targetAddress.kommunekode;
                                orgAddress.vejkode = targetAddress.vejkode;
                                
                                orgAddress.distributor = targetAddress.distributor;
                        }
                }
                
                // nu skal vi ikke bruge idAddressMap længere
                idAddressMap = null;
                
                //////////////////////////////////////////////////////////////////////////////////////
                System.out.println("Build -- stage 3 - 100pct");
                
                hundredePct = DatabaseLayer.get100PctList();
                for (Address addr : alleAdresser) {
                        if (addr.daekningsType != DaekningsType.DAEKNING_IKKEDAEKKET) {                         
                                continue;
                        }
                        
                        if (addr.distributor != null && addr.distributor.equals("LUKKET")) {
                                continue;
                        }
                        
                        
                        HundredePctBean bean = hundredePct.get(addr.postnr);
                        if (bean == null) {
                                continue;
                        }
                        
                        addr.daekningsType = DaekningsType.DAEKNING_100PCT;
                        addr.rute = bean.rute;
                        addr.koreliste = bean.koreliste;
                        addr.dbkBane = bean.dbkBane;
                        addr.distributor = bean.distributor;
                }
                
                ////////////////////////////////////////////////////////////////////////////////////
                System.out.println("Build -- Gathering statistics");
                
                int direkteCount = 0;
                int extendedCount = 0;
                int hundredePctCount = 0;
                int ikkeDaekketCount = 0;
                
                for (Address addr : alleAdresser) {
                        switch (addr.daekningsType) {
                        case DAEKNING_DIREKTE:
                                direkteCount++;
                                break;
                        case DAEKNING_UDVIDET:
                                extendedCount++;
                                break;
                        case DAEKNING_100PCT:
                                hundredePctCount++;
                                break;
                        default:
                                ikkeDaekketCount++;
                        }
                }
                
                System.out.println("Build: direkteCount: " + direkteCount);
                System.out.println("Build: extendedCount: " + extendedCount);
                System.out.println("Build: hundredePctCount: " + hundredePctCount);
                System.out.println("Build: ikkeDaekketCount: " + ikkeDaekketCount);
                
                System.out.println("Build Completed");
                
        }
        
        
        private String calculateExtendedDaoRoute(ExtendedBean eb, Address orgAddress, Address targetAddress) {

                // ///////////////////////////////////////////////////////////////////
                switch( eb.transport) {
                case "cykel":
                        if (eb.afstand < 0.151) {
                                return "." + targetAddress.rute;
                        } else if (eb.afstand < 0.501) {
                                return ".." + targetAddress.rute;
                        } else if (eb.afstand < 0.701) {
                                return "..." + targetAddress.rute;
                        } else if (eb.afstand < 0.501) {
                                return "...." + targetAddress.rute;
                        }
                        break;                  
                case "scooter":
                        if (eb.afstand < 0.151) {
                                return "." + targetAddress.rute;
                        } else if (eb.afstand < 0.801) {
                                return ".." + targetAddress.rute;
                        } else if (eb.afstand < 1.201) {
                                return "..." + targetAddress.rute;
                        } else if (eb.afstand < 2.101) {
                                return "...." + targetAddress.rute;
                        }
                        break;                          
                case "bil":
                        if (eb.afstand < 0.151) {
                                return "." + targetAddress.rute;
                        } else if (eb.afstand < 1.001) {
                                return ".." + targetAddress.rute;
                        } else if (eb.afstand < 1.601) {
                                return "..." + targetAddress.rute;
                        } else if (eb.afstand < 2.601) {
                                return "...." + targetAddress.rute;
                        }
                        break;
                }               
                return null;
        }       
        
        ///////////////////////////////////////////////////////////
        private String calculateExtendedBkKoreliste(ExtendedBean eb, Address orgAddress, Address targetAddress) {
                String inject;
                if (eb.afstand <= 0.500) {
                        inject = ".";
                } else {
                        inject = "..";
                }
                return AddressUtils.injectIntoBk(targetAddress.koreliste, inject);
        }
        
        
}
1	package dk.daoas.daoadresseservice;
2
3	import java.sql.SQLException;
4	import java.util.HashMap;
5	import java.util.List;
6	import java.util.Map;
7	import java.util.concurrent.ConcurrentHashMap;
8
9	import dk.daoas.daoadresseservice.AddressUtils.SplitResult;
10	import dk.daoas.daoadresseservice.beans.Address;
11	import dk.daoas.daoadresseservice.beans.ExtendedBean;
12	import dk.daoas.daoadresseservice.beans.HundredePctBean;
13	import dk.daoas.daoadresseservice.beans.SearchResult;
14	import dk.daoas.daoadresseservice.beans.SearchResult.Status;
15	import dk.daoas.daoadresseservice.db.DatabaseLayer;
16
17	public class AdressSearch {
18
19	Map<Integer, Map<String,Long>> searchPostnrVejnavnGadeid;
20	Map<Long, Map<String,Address>> searchGadeidentAdresser;
21
22	List<Address> alleAdresser;
23
24
25	Map<Integer,HundredePctBean> hundredePct;
26
27
28	public SearchResult search(String postnrStr, String adresse) {
29	long start1 = System.currentTimeMillis();
30
31	int postnr=0;
32
33	try {
34	postnr = Integer.parseInt(postnrStr);
35	} catch (Exception E) {
36	return new SearchResult(Status.ERROR_UNKNOWN_POSTAL);
37	}
38	long start2 = System.currentTimeMillis();
39
40	Map<String,Long> postnrVeje = searchPostnrVejnavnGadeid.get(postnr);
41
42	if (postnrVeje == null) {
43	return new SearchResult(Status.ERROR_UNKNOWN_POSTAL);
44	}
45
46	long start3 = System.currentTimeMillis();
47
48	SplitResult split = AddressUtils.splitAdresse(adresse);
49	String vasketVejnavn = AddressUtils.vaskVejnavn( split.vej );
50
51	if (split.husnr.length() == 0) {
52	return new SearchResult(Status.ERROR_MISSING_HOUSENUMBER);
53	}
54	long start4 = System.currentTimeMillis();
55
56	Long gadeident = postnrVeje.get(vasketVejnavn);
57	if (gadeident == null) {
58	return new SearchResult(Status.ERROR_UNKNOWN_STREETNAME);
59	}
60	long start5 = System.currentTimeMillis();
61
62	Map<String, Address> gade = searchGadeidentAdresser.get(gadeident); //Denne søgning må ikke fejle
63
64	long start6 = System.currentTimeMillis();
65
66	String husnrSearch = "" + split.husnr + split.litra;
67	Address addr = gade.get(husnrSearch);
68	long start7 = System.currentTimeMillis();
69	if (addr == null) {
70	return new SearchResult(Status.ERROR_UNKNOWN_ADDRESSPOINT);
71	}
72
73	if (addr.daekningsType == DaekningsType.DAEKNING_IKKEDAEKKET) {
74	return new SearchResult(Status.STATUS_NOT_COVERED);
75	}
76
77	if (addr.distributor.equals("LUKKET")) {
78	return new SearchResult(Status.STATUS_NOT_COVERED); //Skal vi have en special status til Lukkede adresser ?
79	}
80
81	System.out.println("Search2: " + (start2-start1) );
82	System.out.println("Search3: " + (start3-start1) );
83	System.out.println("Search4: " + (start4-start1) );
84	System.out.println("Search5: " + (start5-start1) );
85	System.out.println("Search6: " + (start6-start1) );
86	System.out.println("Search7: " + (start7-start1) );
87
88
89
90	return new SearchResult(addr);
91	}
92
93
94	public void buildSearchStructures() throws SQLException{
95	searchPostnrVejnavnGadeid = new HashMap<Integer, Map<String,Long>>();
96	searchGadeidentAdresser = new HashMap<Long, Map<String,Address>>();
97
98	System.out.println("Build -- stage 1");
99
100	alleAdresser = DatabaseLayer.getAllAdresses();
101
102
103	/* Mapper mellem db Row ID og adresse noden */
104	Map<Integer,Address> idAddressMap = new HashMap<Integer,Address>( alleAdresser.size() );
105
106	for (Address a : alleAdresser) {
107	idAddressMap.put(a.id, a);
108
109	Map<String,Long> postnrVeje = searchPostnrVejnavnGadeid.get(a.postnr);
110
111	if (postnrVeje == null) {
112	postnrVeje = new ConcurrentHashMap<String,Long>();
113	searchPostnrVejnavnGadeid.put(a.postnr, postnrVeje);
114	}
115
116	String vasketVejnavn = AddressUtils.vaskVejnavn(a.vejnavn);
117	Long gadeident = postnrVeje.get(vasketVejnavn);
118	if (gadeident == null) {
119	postnrVeje.put(vasketVejnavn, a.gadeid);
120	}
121
122	Map<String, Address> gade = searchGadeidentAdresser.get(a.gadeid);
123	if (gade == null) {
124	gade = new HashMap<String, Address>();
125	searchGadeidentAdresser.put(a.gadeid, gade);
126	}
127	String husnrSearch = "" + a.husnr + a.husnrbogstav;
128	gade.put(husnrSearch, a);
129	}
130
131
132	////////////////////////////////////////////////////////////////////////////////////////
133	System.out.println("Build -- stage 2 udvidet dækning");
134
135	List<ExtendedBean> extDao = DatabaseLayer.getExtendedAdresslist();
136	for (ExtendedBean eb : extDao) {
137
138	Address orgAddress = idAddressMap.get(eb.orgId);
139	if (orgAddress == null)
140	continue;
141
142	Address targetAddress = idAddressMap.get(eb.targetId);
143	if (targetAddress == null)
144	continue;
145
146	if (orgAddress.distributor != null && orgAddress.distributor.equals("LUKKET")) {
147	continue;
148	}
149
150	if (targetAddress.distributor.equals("LUKKET")) {
151	continue;
152	}
153
154	orgAddress.extTarget = targetAddress;
155	orgAddress.extAfstand = eb.afstand;
156
157	boolean covered = false;
158	if (targetAddress.distributor.equals("DAO")) {
159	orgAddress.rute = calculateExtendedDaoRoute(eb,orgAddress,targetAddress);
160	if (orgAddress.rute != null) {
161	orgAddress.koreliste = targetAddress.koreliste;
162	covered = true;
163	}
164	}
165
166	if (targetAddress.distributor.equals("BK")) {
167	orgAddress.koreliste = calculateExtendedBkKoreliste(eb,orgAddress,targetAddress);
168	if (orgAddress.koreliste != null) {
169	orgAddress.rute = targetAddress.rute;
170	covered = true;
171	}
172	}
173
174	if (covered) { //Kopier resten af felterne
175	orgAddress.daekningsType = DaekningsType.DAEKNING_UDVIDET;
176	orgAddress.dbkBane = targetAddress.dbkBane;
177
178	/* Sådan gør den gamle service */
179	orgAddress.kommunekode = targetAddress.kommunekode;
180	orgAddress.vejkode = targetAddress.vejkode;
181
182	orgAddress.distributor = targetAddress.distributor;
183	}
184	}
185
186	// nu skal vi ikke bruge idAddressMap længere
187	idAddressMap = null;
188
189	//////////////////////////////////////////////////////////////////////////////////////
190	System.out.println("Build -- stage 3 - 100pct");
191
192	hundredePct = DatabaseLayer.get100PctList();
193	for (Address addr : alleAdresser) {
194	if (addr.daekningsType != DaekningsType.DAEKNING_IKKEDAEKKET) {
195	continue;
196	}
197
198	if (addr.distributor != null && addr.distributor.equals("LUKKET")) {
199	continue;
200	}
201
202
203	HundredePctBean bean = hundredePct.get(addr.postnr);
204	if (bean == null) {
205	continue;
206	}
207
208	addr.daekningsType = DaekningsType.DAEKNING_100PCT;
209	addr.rute = bean.rute;
210	addr.koreliste = bean.koreliste;
211	addr.dbkBane = bean.dbkBane;
212	addr.distributor = bean.distributor;
213	}
214
215	////////////////////////////////////////////////////////////////////////////////////
216	System.out.println("Build -- Gathering statistics");
217
218	int direkteCount = 0;
219	int extendedCount = 0;
220	int hundredePctCount = 0;
221	int ikkeDaekketCount = 0;
222
223	for (Address addr : alleAdresser) {
224	switch (addr.daekningsType) {
225	case DAEKNING_DIREKTE:
226	direkteCount++;
227	break;
228	case DAEKNING_UDVIDET:
229	extendedCount++;
230	break;
231	case DAEKNING_100PCT:
232	hundredePctCount++;
233	break;
234	default:
235	ikkeDaekketCount++;
236	}
237	}
238
239	System.out.println("Build: direkteCount: " + direkteCount);
240	System.out.println("Build: extendedCount: " + extendedCount);
241	System.out.println("Build: hundredePctCount: " + hundredePctCount);
242	System.out.println("Build: ikkeDaekketCount: " + ikkeDaekketCount);
243
244	System.out.println("Build Completed");
245
246	}
247
248
249	private String calculateExtendedDaoRoute(ExtendedBean eb, Address orgAddress, Address targetAddress) {
250
251	// ///////////////////////////////////////////////////////////////////
252	switch( eb.transport) {
253	case "cykel":
254	if (eb.afstand < 0.151) {
255	return "." + targetAddress.rute;
256	} else if (eb.afstand < 0.501) {
257	return ".." + targetAddress.rute;
258	} else if (eb.afstand < 0.701) {
259	return "..." + targetAddress.rute;
260	} else if (eb.afstand < 0.501) {
261	return "...." + targetAddress.rute;
262	}
263	break;
264	case "scooter":
265	if (eb.afstand < 0.151) {
266	return "." + targetAddress.rute;
267	} else if (eb.afstand < 0.801) {
268	return ".." + targetAddress.rute;
269	} else if (eb.afstand < 1.201) {
270	return "..." + targetAddress.rute;
271	} else if (eb.afstand < 2.101) {
272	return "...." + targetAddress.rute;
273	}
274	break;
275	case "bil":
276	if (eb.afstand < 0.151) {
277	return "." + targetAddress.rute;
278	} else if (eb.afstand < 1.001) {
279	return ".." + targetAddress.rute;
280	} else if (eb.afstand < 1.601) {
281	return "..." + targetAddress.rute;
282	} else if (eb.afstand < 2.601) {
283	return "...." + targetAddress.rute;
284	}
285	break;
286	}
287	return null;
288	}
289
290	///////////////////////////////////////////////////////////
291	private String calculateExtendedBkKoreliste(ExtendedBean eb, Address orgAddress, Address targetAddress) {
292	String inject;
293	if (eb.afstand <= 0.500) {
294	inject = ".";
295	} else {
296	inject = "..";
297	}
298	return AddressUtils.injectIntoBk(targetAddress.koreliste, inject);
299	}
300
301
302	}