traininfoservice/banedk/DepartureFetcher.java

package dk.thoerup.traininfoservice.banedk;

import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import java.util.Map;
import java.util.logging.Logger;

import com.gargoylesoftware.htmlunit.BrowserVersion;
import com.gargoylesoftware.htmlunit.WebClient;
import com.gargoylesoftware.htmlunit.html.DomNodeList;
import com.gargoylesoftware.htmlunit.html.HtmlElement;
import com.gargoylesoftware.htmlunit.html.HtmlPage;

import dk.thoerup.circuitbreaker.CircuitBreaker;
import dk.thoerup.circuitbreaker.CircuitBreakerManager;
import dk.thoerup.traininfoservice.StationBean;
import dk.thoerup.traininfoservice.StationDAO;
import dk.thoerup.traininfoservice.Statistics;

public class DepartureFetcher {
        
        Logger logger = Logger.getLogger(DepartureFetcher.class.getName());
        
        Map<String, List<DepartureBean>> cache;
        
        StationDAO stationDao = new StationDAO();
        
        private boolean useTempSite;
        
        public DepartureFetcher(boolean tempSite, int cacheTimeout) {
                useTempSite = tempSite;
                cache = new TimeoutMap<String,List<DepartureBean>>(cacheTimeout);
        }
        
        
        public List<DepartureBean> cachedLookupDepartures(int stationID, boolean arrival) throws Exception {
                final String key = "" + stationID + ":" + arrival;
                
                List<DepartureBean> list = cache.get(key);

                
                if (list == null) {
                        list = lookupDepartures(stationID,arrival);
                        cache.put(key, list);
                } else {
                        Statistics.getInstance().incrementDepartureCacheHits();
                        logger.info("Departure: Cache hit " + key); //remove before production
                }
                return list;
        }
                

        public List<DepartureBean> lookupDepartures(int stationID, boolean arrival) throws Exception {
                List<DepartureBean> departureList = new ArrayList<DepartureBean>();
                
                StationBean station = stationDao.getById(stationID);
                
                if (station.getRegional() != null) {
                        List<DepartureBean> list = lookupDepartures(station.getRegional(), "FJRN", arrival);
                        departureList.addAll(list);                     
                }
                
                if (station.getStrain() != null) {
                        List<DepartureBean> list = lookupDepartures(station.getStrain(), "S2", arrival);
                        departureList.addAll(list);     
                }               
                
                Collections.sort( departureList );

                
                return departureList;
        }
        
        public List<DepartureBean> lookupDepartures(String stationcode, String type, boolean arrival) throws Exception {
                if (useTempSite == false) {
                        return lookupDeparturesNormalSite(stationcode, type, arrival);
                } else {
                        return lookupDeparturesFromTemporarySite(stationcode, type);
                }
        }
        
        public List<DepartureBean> lookupDeparturesNormalSite(String stationcode, String type, boolean arrival) throws Exception {
                
                List<DepartureBean> departureList = new ArrayList<DepartureBean>();
                
            final WebClient webClient = new WebClient( BrowserVersion.FIREFOX_3 );
            webClient.setTimeout(2500);
            webClient.setJavaScriptEnabled(false);
                            
            String uri = "http://www.bane.dk/visStation.asp?ArtikelID=4275&W=" + type + "&S=" + stationcode;
            BanedkInvocation wrapper = new BanedkInvocation(webClient, uri);
            CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
            
            HtmlPage page = (HtmlPage) breaker.invoke(wrapper);
            
            String tableName = arrival == false ? "afgangtabel" : "ankomsttabel";
            
            System.out.println(uri);
            System.out.println(tableName);
            
            HtmlElement table = page.getElementById(tableName);
            
            if (table != null) {
                    DomNodeList<HtmlElement> tableRows =  table.getElementsByTagName("tr");
                    
                    for (HtmlElement currentRow : tableRows) {
                        String rowClass = currentRow.getAttribute("class");
                        if (rowClass != null && rowClass.toLowerCase().contains("station") ) {
                                DomNodeList<HtmlElement> fields = currentRow.getElementsByTagName("td");
        
                                DepartureBean departure = new DepartureBean();
                                
                                String time = fields.get(0).asText();
                                if (time.equals(""))
                                        time = "0:00"; //Bane.dk bug work-around
                                departure.setTime(time);
                                
                                int updated = extractUpdated( fields.get(1) );
                                departure.setUpdated(updated);
                                
                                String trainNumber = fields.get(2).asText();
                                if (type.equalsIgnoreCase("S2")) //If it is S-train we need to extract the trainNumber 
                                        trainNumber = trainNumber + " " + extractTrainNumber(fields.get(2));
                                departure.setTrainNumber(trainNumber);
                                
                                String destination = fields.get(3).asText();
                                departure.setDestination(destination);
                                
                                String origin = fields.get(4).asText();
                                departure.setOrigin(origin);
                                
                                String location = fields.get(5).asText();
                                departure.setLocation(location);
                                
                                String status = fields.get(6).asText();
                                departure.setStatus(status);
                                
                                String note = extractNote( fields.get(7) );
                                departure.setNote(note);
                                
                                departure.setType(type);
                                
                                departureList.add(departure);
                        }
                    }
            } else {
                logger.warning("No departures found for station=" + stationcode + ", type=" + type);
            }
            webClient.closeAllWindows();
            
            return departureList;
        }
        
        public List<DepartureBean> lookupDeparturesFromTemporarySite(String stationcode, String type) throws Exception {
                
                List<DepartureBean> departureList = new ArrayList<DepartureBean>();
                
            final WebClient webClient = new WebClient(BrowserVersion.FIREFOX_3);
            webClient.setTimeout(2500);
            webClient.setJavaScriptEnabled(false);
            

            String uri = "http://bane.dk/lite/station.asp?w=" + type + "&s=" + stationcode;
            
            BanedkInvocation wrapper = new BanedkInvocation(webClient, uri);
            CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
            
            HtmlPage page = (HtmlPage) breaker.invoke(wrapper);
            
            HtmlElement table = page.getElementById("traf_afgang");
            
            if (table != null) {                        
                    DomNodeList<HtmlElement> tableRows =  table.getElementsByTagName("tr");
                    
                    boolean isFirst = true;
                    
                    for (HtmlElement currentRow : tableRows) {
                        if (isFirst == true) { //skip table headers
                                isFirst = false;
                                continue;
                        }
                        
                        DomNodeList<HtmlElement> fields = currentRow.getElementsByTagName("td");

                        DepartureBean departure = new DepartureBean();

                        String time = fields.get(0).asText().trim();

                        if (time.equals(""))
                                time = "0:00"; //Bane.dk bug work-around
                        departure.setTime(time);


                        String trainNumber = fields.get(1).asText();
                        departure.setTrainNumber(trainNumber);

                        String destination = fields.get(2).asText();
                        departure.setDestination(destination);

                        String origin = fields.get(3).asText();
                        departure.setOrigin(origin);

                        String status = fields.get(4).asText();
                        departure.setStatus(status);

                        String note = fields.get(5).asText();
                        departure.setNote(note);

                        departureList.add(departure);
                    }
            } else {
                logger.warning("No departures found for station=" + stationcode + ", type=" + type);
            }
            webClient.closeAllWindows();
            
            
            return departureList;
        }

        
        private int extractUpdated(HtmlElement updatedTd) { //extract the digit (in this case: 4) from "media/trafikinfo/opdater4.gif" 
                int updated = -1;
                
                DomNodeList<HtmlElement> updatedImgs = updatedTd.getElementsByTagName("img");
                String updatedStr = updatedImgs.get(0).getAttribute("src");
                
                if (updatedStr != null) {
                        for (int i=0; i<updatedStr.length(); i++) {
                                char c = updatedStr.charAt(i);
                                if ( Character.isDigit(c))  {
                                        updated = Character.digit(c, 10);
                                        break;
                                }
                        }
                }               
                return updated;
        }
        
        private String extractNote(HtmlElement noteTd) {
                String note = noteTd.asText().trim();
                
                List<HtmlElement> elems = noteTd.getElementsByAttribute("span", "class", "bemtype");
                if (elems.size() > 0 && note.charAt(note.length()-1) == 'i')
                        note = note.substring(0,note.length() -1 );

                return note;
        }
        
        private String extractTrainNumber(HtmlElement trainTd) {
                String number = "";
                HtmlElement anchorElement = trainTd.getElementsByTagName("a").get(0);
                String href = anchorElement.getAttribute("href");
                String argstring = href.substring( href.indexOf('?') + 1);
                
                String args[] = argstring.split("&");
                for (String arg : args) {
                        String pair[] = arg.split("="); // Key=pair[0], Value=pair[1]
                        
                        if (pair[0].equalsIgnoreCase("TogNr"))
                                number = pair[1];
                }
                
                
                return number;
        }
        
        //test
        /*
        public static void main(String args[]) throws Exception {
                DepartureFetcher f = new DepartureFetcher();
                List<DepartureBean> deps = f.lookupDepartures("AR", "FJRN");
                for(DepartureBean d : deps) {
                        System.out.println( d.getTime() + ";" + d.getUpdated() + ";" + d.getTrainNumber() + ";" + 
                                                d.getDestination() + ";" + d.getOrigin() + ";" + d.getLocation() + ";" + d.getStatus() + ";" + d.getNote()   );
                }
                
                System.out.println("--------------------------");
        }*/
}
1	torben	305	package dk.thoerup.traininfoservice.banedk;
2
3			import java.util.ArrayList;
4	torben	307	import java.util.Collections;
5	torben	305	import java.util.List;
6	torben	428	import java.util.Map;
7	torben	348	import java.util.logging.Logger;
8	torben	305
9	torben	591	import com.gargoylesoftware.htmlunit.BrowserVersion;
10	torben	305	import com.gargoylesoftware.htmlunit.WebClient;
11			import com.gargoylesoftware.htmlunit.html.DomNodeList;
12			import com.gargoylesoftware.htmlunit.html.HtmlElement;
13			import com.gargoylesoftware.htmlunit.html.HtmlPage;
14
15	torben	468	import dk.thoerup.circuitbreaker.CircuitBreaker;
16			import dk.thoerup.circuitbreaker.CircuitBreakerManager;
17	torben	588	import dk.thoerup.traininfoservice.StationBean;
18			import dk.thoerup.traininfoservice.StationDAO;
19	torben	711	import dk.thoerup.traininfoservice.Statistics;
20	torben	307
21	torben	305	public class DepartureFetcher {
22	torben	348
23			Logger logger = Logger.getLogger(DepartureFetcher.class.getName());
24	torben	387
25	torben	829	Map<String, List<DepartureBean>> cache;
26	torben	387
27	torben	588	StationDAO stationDao = new StationDAO();
28
29	torben	580	private boolean useTempSite;
30
31	torben	584	public DepartureFetcher(boolean tempSite, int cacheTimeout) {
32	torben	580	useTempSite = tempSite;
33	torben	829	cache = new TimeoutMap<String,List<DepartureBean>>(cacheTimeout);
34	torben	580	}
35
36
37	torben	307
38	torben	387
39	torben	829	public List<DepartureBean> cachedLookupDepartures(int stationID, boolean arrival) throws Exception {
40			final String key = "" + stationID + ":" + arrival;
41
42			List<DepartureBean> list = cache.get(key);
43	torben	308
44	torben	387
45			if (list == null) {
46	torben	829	list = lookupDepartures(stationID,arrival);
47			cache.put(key, list);
48	torben	387	} else {
49	torben	711	Statistics.getInstance().incrementDepartureCacheHits();
50	torben	829	logger.info("Departure: Cache hit " + key); //remove before production
51	torben	387	}
52			return list;
53			}
54
55
56	torben	829	public List<DepartureBean> lookupDepartures(int stationID, boolean arrival) throws Exception {
57	torben	307	List<DepartureBean> departureList = new ArrayList<DepartureBean>();
58
59	torben	588	StationBean station = stationDao.getById(stationID);
60	torben	307
61	torben	588	if (station.getRegional() != null) {
62	torben	829	List<DepartureBean> list = lookupDepartures(station.getRegional(), "FJRN", arrival);
63	torben	588	departureList.addAll(list);
64	torben	307	}
65
66	torben	588	if (station.getStrain() != null) {
67	torben	829	List<DepartureBean> list = lookupDepartures(station.getStrain(), "S2", arrival);
68	torben	588	departureList.addAll(list);
69			}
70
71			Collections.sort( departureList );
72
73
74	torben	307	return departureList;
75	torben	305	}
76
77	torben	829	public List<DepartureBean> lookupDepartures(String stationcode, String type, boolean arrival) throws Exception {
78	torben	580	if (useTempSite == false) {
79	torben	829	return lookupDeparturesNormalSite(stationcode, type, arrival);
80	torben	580	} else {
81			return lookupDeparturesFromTemporarySite(stationcode, type);
82			}
83			}
84
85	torben	829	public List<DepartureBean> lookupDeparturesNormalSite(String stationcode, String type, boolean arrival) throws Exception {
86	torben	305
87			List<DepartureBean> departureList = new ArrayList<DepartureBean>();
88
89	torben	591	final WebClient webClient = new WebClient( BrowserVersion.FIREFOX_3 );
90	torben	386	webClient.setTimeout(2500);
91	torben	313	webClient.setJavaScriptEnabled(false);
92
93	torben	421	String uri = "http://www.bane.dk/visStation.asp?ArtikelID=4275&W=" + type + "&S=" + stationcode;
94			BanedkInvocation wrapper = new BanedkInvocation(webClient, uri);
95			CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
96	torben	305
97	torben	421	HtmlPage page = (HtmlPage) breaker.invoke(wrapper);
98	torben	305
99	torben	829	String tableName = arrival == false ? "afgangtabel" : "ankomsttabel";
100	torben	305
101	torben	829	System.out.println(uri);
102			System.out.println(tableName);
103
104			HtmlElement table = page.getElementById(tableName);
105
106	torben	342	if (table != null) {
107			DomNodeList<HtmlElement> tableRows = table.getElementsByTagName("tr");
108
109			for (HtmlElement currentRow : tableRows) {
110			String rowClass = currentRow.getAttribute("class");
111			if (rowClass != null && rowClass.toLowerCase().contains("station") ) {
112			DomNodeList<HtmlElement> fields = currentRow.getElementsByTagName("td");
113
114			DepartureBean departure = new DepartureBean();
115
116			String time = fields.get(0).asText();
117	torben	375	if (time.equals(""))
118			time = "0:00"; //Bane.dk bug work-around
119	torben	342	departure.setTime(time);
120
121			int updated = extractUpdated( fields.get(1) );
122			departure.setUpdated(updated);
123
124			String trainNumber = fields.get(2).asText();
125	torben	410	if (type.equalsIgnoreCase("S2")) //If it is S-train we need to extract the trainNumber
126	torben	349	trainNumber = trainNumber + " " + extractTrainNumber(fields.get(2));
127	torben	342	departure.setTrainNumber(trainNumber);
128
129			String destination = fields.get(3).asText();
130			departure.setDestination(destination);
131
132			String origin = fields.get(4).asText();
133			departure.setOrigin(origin);
134
135			String location = fields.get(5).asText();
136			departure.setLocation(location);
137
138			String status = fields.get(6).asText();
139			departure.setStatus(status);
140
141			String note = extractNote( fields.get(7) );
142			departure.setNote(note);
143
144	torben	697	departure.setType(type);
145
146	torben	342	departureList.add(departure);
147			}
148			}
149	torben	348	} else {
150			logger.warning("No departures found for station=" + stationcode + ", type=" + type);
151	torben	305	}
152	torben	591	webClient.closeAllWindows();
153	torben	348
154	torben	305	return departureList;
155			}
156
157	torben	580	public List<DepartureBean> lookupDeparturesFromTemporarySite(String stationcode, String type) throws Exception {
158
159			List<DepartureBean> departureList = new ArrayList<DepartureBean>();
160
161	torben	591	final WebClient webClient = new WebClient(BrowserVersion.FIREFOX_3);
162	torben	580	webClient.setTimeout(2500);
163			webClient.setJavaScriptEnabled(false);
164
165
166			String uri = "http://bane.dk/lite/station.asp?w=" + type + "&s=" + stationcode;
167
168			BanedkInvocation wrapper = new BanedkInvocation(webClient, uri);
169			CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
170
171			HtmlPage page = (HtmlPage) breaker.invoke(wrapper);
172
173			HtmlElement table = page.getElementById("traf_afgang");
174
175			if (table != null) {
176			DomNodeList<HtmlElement> tableRows = table.getElementsByTagName("tr");
177
178			boolean isFirst = true;
179
180			for (HtmlElement currentRow : tableRows) {
181			if (isFirst == true) { //skip table headers
182			isFirst = false;
183			continue;
184			}
185
186			DomNodeList<HtmlElement> fields = currentRow.getElementsByTagName("td");
187
188			DepartureBean departure = new DepartureBean();
189
190			String time = fields.get(0).asText().trim();
191	torben	583
192	torben	580	if (time.equals(""))
193			time = "0:00"; //Bane.dk bug work-around
194			departure.setTime(time);
195
196
197			String trainNumber = fields.get(1).asText();
198			departure.setTrainNumber(trainNumber);
199
200			String destination = fields.get(2).asText();
201			departure.setDestination(destination);
202
203			String origin = fields.get(3).asText();
204			departure.setOrigin(origin);
205
206			String status = fields.get(4).asText();
207			departure.setStatus(status);
208
209	torben	582	String note = fields.get(5).asText();
210	torben	580	departure.setNote(note);
211
212			departureList.add(departure);
213			}
214			} else {
215			logger.warning("No departures found for station=" + stationcode + ", type=" + type);
216			}
217	torben	591	webClient.closeAllWindows();
218	torben	580
219	torben	591
220	torben	580	return departureList;
221			}
222
223
224	torben	305	private int extractUpdated(HtmlElement updatedTd) { //extract the digit (in this case: 4) from "media/trafikinfo/opdater4.gif"
225			int updated = -1;
226
227			DomNodeList<HtmlElement> updatedImgs = updatedTd.getElementsByTagName("img");
228			String updatedStr = updatedImgs.get(0).getAttribute("src");
229
230			if (updatedStr != null) {
231			for (int i=0; i<updatedStr.length(); i++) {
232			char c = updatedStr.charAt(i);
233			if ( Character.isDigit(c)) {
234			updated = Character.digit(c, 10);
235			break;
236			}
237			}
238			}
239			return updated;
240			}
241
242	torben	313	private String extractNote(HtmlElement noteTd) {
243			String note = noteTd.asText().trim();
244
245			List<HtmlElement> elems = noteTd.getElementsByAttribute("span", "class", "bemtype");
246			if (elems.size() > 0 && note.charAt(note.length()-1) == 'i')
247			note = note.substring(0,note.length() -1 );
248
249			return note;
250			}
251
252	torben	349	private String extractTrainNumber(HtmlElement trainTd) {
253			String number = "";
254			HtmlElement anchorElement = trainTd.getElementsByTagName("a").get(0);
255			String href = anchorElement.getAttribute("href");
256			String argstring = href.substring( href.indexOf('?') + 1);
257
258			String args[] = argstring.split("&");
259			for (String arg : args) {
260			String pair[] = arg.split("="); // Key=pair[0], Value=pair[1]
261
262			if (pair[0].equalsIgnoreCase("TogNr"))
263			number = pair[1];
264			}
265
266
267			return number;
268			}
269
270	torben	305	//test
271	torben	580	/*
272	torben	451	public static void main(String args[]) throws Exception {
273	torben	305	DepartureFetcher f = new DepartureFetcher();
274	torben	307	List<DepartureBean> deps = f.lookupDepartures("AR", "FJRN");
275	torben	305	for(DepartureBean d : deps) {
276			System.out.println( d.getTime() + ";" + d.getUpdated() + ";" + d.getTrainNumber() + ";" +
277			d.getDestination() + ";" + d.getOrigin() + ";" + d.getLocation() + ";" + d.getStatus() + ";" + d.getNote() );
278			}
279
280			System.out.println("--------------------------");
281	torben	580	}*/
282	torben	305	}