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