1 |
package dk.daoas.adressevedligehold; |
package dk.daoas.adressevedligehold.fileupload; |
2 |
|
|
|
import java.io.BufferedReader; |
|
3 |
import java.io.IOException; |
import java.io.IOException; |
4 |
import java.io.InputStream; |
import java.util.List; |
|
import java.io.InputStreamReader; |
|
|
import java.nio.charset.Charset; |
|
5 |
|
|
6 |
import org.apache.commons.fileupload.FileItem; |
import org.apache.commons.fileupload.FileItem; |
7 |
|
|
8 |
import dk.daoas.adressevedligehold.AddressSourceEntry.EntryType; |
import com.google.common.base.CharMatcher; |
9 |
import dk.daoas.adressevedligehold.util.DeduplicateHelper; |
import com.google.common.base.Splitter; |
10 |
|
|
11 |
|
import dk.daoas.adressevedligehold.fileupload.AddressSourceEntry.EntryType; |
12 |
import dk.daoas.adressevedligehold.util.SafeParsers; |
import dk.daoas.adressevedligehold.util.SafeParsers; |
13 |
|
|
14 |
public class AddressSourceBK implements AddressSource { |
public class AddressSourceBK extends AbstractAddressSource { |
|
|
|
|
DeduplicateHelper<String> dirigeringsCache = new DeduplicateHelper<String>(); |
|
|
|
|
|
FileItem file; |
|
15 |
|
|
16 |
InputStream is; |
Splitter splitter = Splitter.on(';').trimResults( CharMatcher.is('"') ); |
|
InputStreamReader isr; |
|
|
BufferedReader br; |
|
|
|
|
|
int lineCount = 0; |
|
17 |
|
|
18 |
public AddressSourceBK(FileItem file) throws Exception { |
public AddressSourceBK(FileItem file) throws Exception { |
19 |
this.file = file; |
super(file); |
|
|
|
|
|
|
|
|
|
20 |
} |
} |
21 |
|
|
|
@Override |
|
|
public String getFilename() { |
|
|
return file.getName(); |
|
|
} |
|
22 |
|
|
23 |
@Override |
@Override |
24 |
public void validate() throws IOException { |
public void validate() throws IOException { |
25 |
try ( |
super.validatNoHeaderLine(14, ';'); |
|
InputStream is1 = file.getInputStream(); |
|
|
InputStreamReader isr1 = new InputStreamReader(is1, Charset.forName("ISO-8859-1") ); |
|
|
BufferedReader br1 = new BufferedReader(isr1) |
|
|
) { |
|
|
String line = br1.readLine(); |
|
|
String[] parts = line.split(";"); |
|
|
int numFields = parts.length; |
|
|
if (numFields != 13) { |
|
|
throw new IOException("Not enough fields in CSV file. Found " + numFields + ", expected 13"); |
|
|
} |
|
|
} |
|
|
|
|
|
|
|
|
is = file.getInputStream(); |
|
|
isr = new InputStreamReader(is, Charset.forName("ISO-8859-1") ); |
|
|
br = new BufferedReader(isr); |
|
26 |
} |
} |
27 |
|
|
|
//TODO: Skal csv parsning klares med Apache Commons CSV ? |
|
28 |
|
|
29 |
@Override |
@Override |
30 |
public AddressSourceEntry getNextEntry() throws IOException { |
public AddressSourceEntry getNextEntry() throws IOException { |
35 |
if (line.trim().equals("")) |
if (line.trim().equals("")) |
36 |
return null; |
return null; |
37 |
|
|
|
//System.out.println(line); |
|
38 |
|
|
39 |
AddressSourceEntry entry = new AddressSourceEntry( EntryType.TypeSingleAddress); |
AddressSourceEntry entry = new AddressSourceEntry( EntryType.TypeSingleAddress); |
40 |
entry.distributor = "BK"; |
entry.distributor = "BK"; |
41 |
|
|
42 |
String[] parts = line.split(";"); |
List<String> parts = splitter.splitToList(line); |
43 |
|
|
44 |
if (parts.length != 13) { |
if (parts.size() != 14) { |
45 |
throw new IOException("Not enough fields in CSV file. Found " + parts.length + ", expected 13"); |
throw new IOException("Not enough fields in CSV file. Found " + parts.size() + ", expected 14"); |
46 |
} |
} |
47 |
|
|
48 |
entry.postnr = Short.parseShort( parts[0]); |
entry.postnr = Short.parseShort( parts.get(0) ); |
49 |
entry.vejnavn = parts[1].replace("\"", ""); |
entry.vejnavn = parts.get( 1 ); |
50 |
entry.husnr = Short.parseShort( parts[2] ); |
entry.husnr = Short.parseShort( parts.get( 2 ) ); |
51 |
entry.litra = parts[3].replace("\"", ""); |
entry.litra = parts.get( 3 ); |
52 |
entry.vejkode = SafeParsers.parseShort( parts[4] ); |
entry.vejkode = SafeParsers.parseShort( parts.get( 4) ); |
53 |
entry.kommunekode = SafeParsers.parseShort( parts[5] ); |
entry.kommunekode = SafeParsers.parseShort( parts.get( 5) ); |
54 |
entry.gadeid = Integer.parseInt( parts[6] ); |
entry.gadeid = Integer.parseInt( parts.get( 6 ) ); |
55 |
|
|
56 |
String ugedage = parts[7].replace("\"", ""); |
String ugedage = parts.get( 7 ); |
57 |
|
|
58 |
String laesnr = parts[8].replace("\"", ""); |
String laesnr = parts.get( 8 ); |
59 |
|
|
60 |
//String distnr = parts[9].replace("\"", ""); //Bruges ikke |
//String distnr = parts.get( 9 ); //Bruges ikke |
61 |
String foede = parts[10].replace("\"", ""); |
String foede = parts.get( 10 ); |
62 |
String jobnr = parts[11].replace("\"", ""); |
String jobnr = parts.get( 11 ); |
63 |
String tklaes = parts[12].replace("\"", ""); |
String tklaes = parts.get( 12 ); |
64 |
|
|
65 |
entry.rute = laesnr; |
entry.rute = laesnr; |
66 |
entry.koreliste = "/" + foede + "/" + tklaes + "/" + jobnr; |
entry.koreliste = "/" + foede + "/" + tklaes + "/" + jobnr; |
96 |
return "BK"; |
return "BK"; |
97 |
} |
} |
98 |
|
|
|
@Override //AutoCloseable |
|
|
public void close() throws Exception { |
|
|
System.out.println("Closing BK after lines " + lineCount); |
|
|
try { |
|
|
br.close(); |
|
|
isr.close(); |
|
|
is.close(); |
|
|
|
|
|
file.delete(); |
|
|
|
|
|
} catch (Exception e) { |
|
|
System.out.println("Error on closing " + e.getMessage() ); |
|
|
} |
|
|
|
|
|
|
|
|
} |
|
|
|
|
99 |
} |
} |