daoas/daoadresseservice/AddressSearch.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.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;
        
        /* Mapper mellem db Row ID og adresse noden */
        Map<Integer,Address> idAddressMap;
        
        
        public SearchResult search(String postnrStr, String adresse)  {
                int postnr=0;
                
                try {
                        postnr = Integer.parseInt(postnrStr);
                } catch (Exception E) {
                        return new SearchResult(Status.ERROR_UNKNOWN_POSTAL);
                }               
                
                Map<String,Long> postnrVeje = searchPostnrVejnavnGadeid.get(postnr);                    
                
                if (postnrVeje == null) {
                        return new SearchResult(Status.ERROR_UNKNOWN_POSTAL);
                }
                
                SplitResult split = AddressUtils.splitAdresse(adresse);
                String vasketVejnavn = AddressUtils.vaskVejnavn( split.vej );
                
                if (split.husnr.length() == 0) {
                        return new SearchResult(Status.ERROR_MISSING_HOUSENUMBER);                      
                }
                
                Long gadeident =  postnrVeje.get(vasketVejnavn);
                if (gadeident == null) {
                        return new SearchResult(Status.ERROR_UNKNOWN_STREETNAME);
                }       
                
                Map<String, Address> gade =  searchGadeidentAdresser.get(gadeident); //Denne søgning må ikke fejle
                
                
                String husnrSearch = "" + split.husnr + split.litra;
                Address addr = gade.get(husnrSearch);
                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 ?
                }
                                
                
                return new SearchResult(addr);
        }
        
        
        public void buildSearchStructures() throws SQLException{
                searchPostnrVejnavnGadeid = new HashMap<Integer, Map<String,Long>>();
                searchGadeidentAdresser = new HashMap<Long,  Map<String,Address>>();
                idAddressMap = new HashMap<Integer,Address>();
                
                System.out.println("Build -- stage 1");
                
                alleAdresser = DatabaseLayer.getAllAdresses();
                
                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);
                        }
                        
                        Long gadeident = postnrVeje.get(a.vasketVejnavn);
                        if (gadeident == null) {
                                postnrVeje.put(a.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;

                        orgAddress.rute = calculateExtendedRoute(eb,orgAddress,targetAddress);
                        
                        if (orgAddress.rute != null) {
                                orgAddress.daekningsType = DaekningsType.DAEKNING_UDVIDET;
                                orgAddress.koreliste = targetAddress.koreliste;
                                orgAddress.dbkBane = targetAddress.dbkBane;
                                
                                /* Sådan gør den gamle service */
                                orgAddress.kommunekode = targetAddress.kommunekode;
                                orgAddress.vejkode = targetAddress.vejkode;
                                
                                orgAddress.distributor = targetAddress.distributor;
                        }

                        
                }
                //////////////////////////////////////////////////////////////////////////////////////
                System.out.println("Build -- stage 3 - 100pct");
                
                Map<Integer,HundredePctBean> 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;
                }
                
        }
        
        
        private String calculateExtendedRoute(ExtendedBean eb, Address orgAddress, Address targetAddress) {
                switch (targetAddress.distributor) {
                case "DAO":
                        // ///////////////////////////////////////////////////////////////////
                        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;
                        }
                        break;
                        
                ///////////////////////////////////////////////////////////
                        
                case "BK":
                        String inject;
                        if (eb.afstand <= 0.500) {
                                inject = ".";
                        } else {
                                inject = "..";
                        }
                        return AddressUtils.injectIntoBk(targetAddress.rute, inject);
                }
                return null;
        }       
        
        
}
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.SearchResult.Status;
11	import dk.daoas.daoadresseservice.db.DatabaseLayer;
12
13	public class AdressSearch {
14
15	Map<Integer, Map<String,Long>> searchPostnrVejnavnGadeid;
16	Map<Long, Map<String,Address>> searchGadeidentAdresser;
17
18	List<Address> alleAdresser;
19
20	/* Mapper mellem db Row ID og adresse noden */
21	Map<Integer,Address> idAddressMap;
22
23
24	public SearchResult search(String postnrStr, String adresse) {
25	int postnr=0;
26
27	try {
28	postnr = Integer.parseInt(postnrStr);
29	} catch (Exception E) {
30	return new SearchResult(Status.ERROR_UNKNOWN_POSTAL);
31	}
32
33	Map<String,Long> postnrVeje = searchPostnrVejnavnGadeid.get(postnr);
34
35	if (postnrVeje == null) {
36	return new SearchResult(Status.ERROR_UNKNOWN_POSTAL);
37	}
38
39	SplitResult split = AddressUtils.splitAdresse(adresse);
40	String vasketVejnavn = AddressUtils.vaskVejnavn( split.vej );
41
42	if (split.husnr.length() == 0) {
43	return new SearchResult(Status.ERROR_MISSING_HOUSENUMBER);
44	}
45
46	Long gadeident = postnrVeje.get(vasketVejnavn);
47	if (gadeident == null) {
48	return new SearchResult(Status.ERROR_UNKNOWN_STREETNAME);
49	}
50
51	Map<String, Address> gade = searchGadeidentAdresser.get(gadeident); //Denne søgning må ikke fejle
52
53
54	String husnrSearch = "" + split.husnr + split.litra;
55	Address addr = gade.get(husnrSearch);
56	if (addr == null) {
57	return new SearchResult(Status.ERROR_UNKNOWN_ADDRESSPOINT);
58	}
59
60	if (addr.daekningsType == DaekningsType.DAEKNING_IKKEDAEKKET) {
61	return new SearchResult(Status.STATUS_NOT_COVERED);
62	}
63
64	if (addr.distributor.equals("LUKKET")) {
65	return new SearchResult(Status.STATUS_NOT_COVERED); //Skal vi have en special status til Lukkede adresser ?
66	}
67
68
69	return new SearchResult(addr);
70	}
71
72
73	public void buildSearchStructures() throws SQLException{
74	searchPostnrVejnavnGadeid = new HashMap<Integer, Map<String,Long>>();
75	searchGadeidentAdresser = new HashMap<Long, Map<String,Address>>();
76	idAddressMap = new HashMap<Integer,Address>();
77
78	System.out.println("Build -- stage 1");
79
80	alleAdresser = DatabaseLayer.getAllAdresses();
81
82	for (Address a : alleAdresser) {
83	idAddressMap.put(a.id, a);
84
85	Map<String,Long> postnrVeje = searchPostnrVejnavnGadeid.get(a.postnr);
86
87	if (postnrVeje == null) {
88	postnrVeje = new ConcurrentHashMap<String,Long>();
89	searchPostnrVejnavnGadeid.put(a.postnr, postnrVeje);
90	}
91
92	Long gadeident = postnrVeje.get(a.vasketVejnavn);
93	if (gadeident == null) {
94	postnrVeje.put(a.vasketVejnavn, a.gadeid);
95	}
96
97	Map<String, Address> gade = searchGadeidentAdresser.get(a.gadeid);
98	if (gade == null) {
99	gade = new HashMap<String, Address>();
100	searchGadeidentAdresser.put(a.gadeid, gade);
101	}
102	String husnrSearch = "" + a.husnr + a.husnrbogstav;
103	gade.put(husnrSearch, a);
104	}
105
106
107	////////////////////////////////////////////////////////////////////////////////////////
108	System.out.println("Build -- stage 2 udvidet dækning");
109
110	List<ExtendedBean> extDao = DatabaseLayer.getExtendedAdresslist();
111	for (ExtendedBean eb : extDao) {
112
113	Address orgAddress = idAddressMap.get(eb.orgId);
114	if (orgAddress == null)
115	continue;
116
117	Address targetAddress = idAddressMap.get(eb.targetId);
118	if (targetAddress == null)
119	continue;
120
121	if (orgAddress.distributor != null && orgAddress.distributor.equals("LUKKET")) {
122	continue;
123	}
124
125	if (targetAddress.distributor.equals("LUKKET")) {
126	continue;
127	}
128
129	orgAddress.extTarget = targetAddress;
130	orgAddress.extAfstand = eb.afstand;
131
132	orgAddress.rute = calculateExtendedRoute(eb,orgAddress,targetAddress);
133
134	if (orgAddress.rute != null) {
135	orgAddress.daekningsType = DaekningsType.DAEKNING_UDVIDET;
136	orgAddress.koreliste = targetAddress.koreliste;
137	orgAddress.dbkBane = targetAddress.dbkBane;
138
139	/* Sådan gør den gamle service */
140	orgAddress.kommunekode = targetAddress.kommunekode;
141	orgAddress.vejkode = targetAddress.vejkode;
142
143	orgAddress.distributor = targetAddress.distributor;
144	}
145
146
147	}
148	//////////////////////////////////////////////////////////////////////////////////////
149	System.out.println("Build -- stage 3 - 100pct");
150
151	Map<Integer,HundredePctBean> hundredePct = DatabaseLayer.get100PctList();
152	for (Address addr : alleAdresser) {
153	if (addr.daekningsType != DaekningsType.DAEKNING_IKKEDAEKKET) {
154	continue;
155	}
156
157	if (addr.distributor != null && addr.distributor.equals("LUKKET")) {
158	continue;
159	}
160
161
162	HundredePctBean bean = hundredePct.get(addr.postnr);
163	if (bean == null) {
164	continue;
165	}
166
167	addr.daekningsType = DaekningsType.DAEKNING_100PCT;
168	addr.rute = bean.rute;
169	addr.koreliste = bean.koreliste;
170	addr.dbkBane = bean.dbkBane;
171	addr.distributor = bean.distributor;
172	}
173
174	}
175
176
177	private String calculateExtendedRoute(ExtendedBean eb, Address orgAddress, Address targetAddress) {
178	switch (targetAddress.distributor) {
179	case "DAO":
180	// ///////////////////////////////////////////////////////////////////
181	switch( eb.transport) {
182	case "cykel":
183	if (eb.afstand < 0.151) {
184	return "." + targetAddress.rute;
185	} else if (eb.afstand < 0.501) {
186	return ".." + targetAddress.rute;
187	} else if (eb.afstand < 0.701) {
188	return "..." + targetAddress.rute;
189	} else if (eb.afstand < 0.501) {
190	return "...." + targetAddress.rute;
191	}
192	break;
193	case "scooter":
194	if (eb.afstand < 0.151) {
195	return "." + targetAddress.rute;
196	} else if (eb.afstand < 0.801) {
197	return ".." + targetAddress.rute;
198	} else if (eb.afstand < 1.201) {
199	return "..." + targetAddress.rute;
200	} else if (eb.afstand < 2.101) {
201	return "...." + targetAddress.rute;
202	}
203	break;
204	case "bil":
205	if (eb.afstand < 0.151) {
206	return "." + targetAddress.rute;
207	} else if (eb.afstand < 1.001) {
208	return ".." + targetAddress.rute;
209	} else if (eb.afstand < 1.601) {
210	return "..." + targetAddress.rute;
211	} else if (eb.afstand < 2.601) {
212	return "...." + targetAddress.rute;
213	}
214	break;
215	}
216	break;
217
218	///////////////////////////////////////////////////////////
219
220	case "BK":
221	String inject;
222	if (eb.afstand <= 0.500) {
223	inject = ".";
224	} else {
225	inject = "..";
226	}
227	return AddressUtils.injectIntoBk(targetAddress.rute, inject);
228	}
229	return null;
230	}
231
232
233	}