adressevedligehold/fileupload/AddressSourceBK.java

package dk.daoas.adressevedligehold.fileupload;

import java.io.IOException;
import java.util.List;

import org.apache.commons.fileupload.FileItem;

import com.google.common.base.CharMatcher;
import com.google.common.base.Splitter;

import dk.daoas.adressevedligehold.fileupload.AddressSourceEntry.EntryType;
import dk.daoas.adressevedligehold.util.SafeParsers;

public class AddressSourceBK extends AbstractAddressSource {
        
        Splitter splitter = Splitter.on(';').trimResults( CharMatcher.is('"') );
                
        public AddressSourceBK(FileItem file) throws Exception {
                super(file);
        }

        
        @Override
        public void validate() throws IOException {
                super.validatNoHeaderLine(14, ';');
        }

        //TODO: Skal csv parsning klares med Apache Commons CSV ?

        @Override
        public AddressSourceEntry getNextEntry() throws IOException {
                String line = br.readLine();
                if (line == null) // end of file
                        return null;
                
                if (line.trim().equals(""))
                        return null;
                
                
                AddressSourceEntry entry = new AddressSourceEntry( EntryType.TypeSingleAddress);
                entry.distributor = "BK";
                
                List<String> parts = splitter.splitToList(line);
                
                if (parts.size() != 14) {
                        throw new IOException("Not enough fields in CSV file. Found " + parts.size() + ", expected 14");
                }
                
                entry.postnr = Short.parseShort( parts.get(0) );
                entry.vejnavn = parts.get( 1 );
                entry.husnr = Short.parseShort( parts.get( 2 ) );
                entry.litra = parts.get( 3 );
                entry.vejkode = SafeParsers.parseShort( parts.get( 4)  );
                entry.kommunekode = SafeParsers.parseShort( parts.get( 5)  );
                entry.gadeid = Integer.parseInt( parts.get( 6 ) );
                
                String ugedage = parts.get( 7 );
                
                String laesnr = parts.get( 8 );
                
                //String distnr = parts.get( 9 ); //Bruges ikke
                String foede = parts.get( 10 );
                String jobnr = parts.get( 11 );
                String tklaes = parts.get( 12 );
                
                entry.rute = laesnr;
                entry.koreliste = "/" + foede + "/" + tklaes + "/" + jobnr;
                
                entry.rute = dirigeringsCache.getInstance(entry.rute);
                entry.koreliste = dirigeringsCache.getInstance(entry.koreliste);
                
                switch (ugedage) {              
                case "1234000":
                        entry.ugedage = EntryUgedage.MAN_TOR;
                        break;
                case "0000500":
                        entry.ugedage = EntryUgedage.FRE;
                        break;
                case "0000060":
                        entry.ugedage = EntryUgedage.LOR;
                        break;
                case "0000007":
                        entry.ugedage = EntryUgedage.SON;
                        break;
                default:
                        throw new IOException("Ukendt ugedag:" + ugedage);
                }

                
                lineCount++;
                
                return entry;
        }
        
        @Override
        public String getDistributor() {
                return "BK";
        }

}
1	torben	2947	package dk.daoas.adressevedligehold.fileupload;
2	torben	2838
3			import java.io.IOException;
4	torben	2874	import java.util.List;
5	torben	2838
6			import org.apache.commons.fileupload.FileItem;
7
8	torben	2875	import com.google.common.base.CharMatcher;
9	torben	2874	import com.google.common.base.Splitter;
10
11	torben	2947	import dk.daoas.adressevedligehold.fileupload.AddressSourceEntry.EntryType;
12	torben	2838	import dk.daoas.adressevedligehold.util.SafeParsers;
13
14	torben	2868	public class AddressSourceBK extends AbstractAddressSource {
15	torben	2838
16	torben	2875	Splitter splitter = Splitter.on(';').trimResults( CharMatcher.is('"') );
17	torben	2838
18			public AddressSourceBK(FileItem file) throws Exception {
19	torben	2868	super(file);
20	torben	2838	}
21
22
23	torben	2844	@Override
24			public void validate() throws IOException {
25	torben	2874	super.validatNoHeaderLine(14, ';');
26	torben	2844	}
27
28	torben	2838	//TODO: Skal csv parsning klares med Apache Commons CSV ?
29
30			@Override
31			public AddressSourceEntry getNextEntry() throws IOException {
32			String line = br.readLine();
33			if (line == null) // end of file
34			return null;
35
36			if (line.trim().equals(""))
37			return null;
38
39
40			AddressSourceEntry entry = new AddressSourceEntry( EntryType.TypeSingleAddress);
41			entry.distributor = "BK";
42
43	torben	2875	List<String> parts = splitter.splitToList(line);
44	torben	2857
45	torben	2874	if (parts.size() != 14) {
46			throw new IOException("Not enough fields in CSV file. Found " + parts.size() + ", expected 14");
47	torben	2857	}
48
49	torben	2874	entry.postnr = Short.parseShort( parts.get(0) );
50	torben	2875	entry.vejnavn = parts.get( 1 );
51	torben	2874	entry.husnr = Short.parseShort( parts.get( 2 ) );
52	torben	2875	entry.litra = parts.get( 3 );
53	torben	2874	entry.vejkode = SafeParsers.parseShort( parts.get( 4) );
54			entry.kommunekode = SafeParsers.parseShort( parts.get( 5) );
55			entry.gadeid = Integer.parseInt( parts.get( 6 ) );
56	torben	2838
57	torben	2875	String ugedage = parts.get( 7 );
58	torben	2838
59	torben	2875	String laesnr = parts.get( 8 );
60	torben	2838
61	torben	2875	//String distnr = parts.get( 9 ); //Bruges ikke
62			String foede = parts.get( 10 );
63			String jobnr = parts.get( 11 );
64			String tklaes = parts.get( 12 );
65	torben	2838
66			entry.rute = laesnr;
67			entry.koreliste = "/" + foede + "/" + tklaes + "/" + jobnr;
68
69			entry.rute = dirigeringsCache.getInstance(entry.rute);
70			entry.koreliste = dirigeringsCache.getInstance(entry.koreliste);
71
72			switch (ugedage) {
73			case "1234000":
74			entry.ugedage = EntryUgedage.MAN_TOR;
75			break;
76			case "0000500":
77			entry.ugedage = EntryUgedage.FRE;
78			break;
79			case "0000060":
80			entry.ugedage = EntryUgedage.LOR;
81			break;
82			case "0000007":
83			entry.ugedage = EntryUgedage.SON;
84			break;
85			default:
86			throw new IOException("Ukendt ugedag:" + ugedage);
87			}
88
89
90			lineCount++;
91
92			return entry;
93			}
94
95			@Override
96			public String getDistributor() {
97			return "BK";
98			}
99
100			}