1 |
package dk.daoas.adressevedligehold; |
package dk.daoas.adressevedligehold.coveragefileupload; |
2 |
|
|
3 |
|
import java.util.ArrayList; |
4 |
|
import java.util.Comparator; |
5 |
import java.util.HashMap; |
import java.util.HashMap; |
6 |
import java.util.List; |
import java.util.List; |
7 |
import java.util.Properties; |
import java.util.Map.Entry; |
8 |
|
|
9 |
import javax.mail.Message; |
import org.apache.commons.lang3.builder.CompareToBuilder; |
|
import javax.mail.MessagingException; |
|
|
import javax.mail.Session; |
|
|
import javax.mail.Transport; |
|
|
import javax.mail.internet.InternetAddress; |
|
|
import javax.mail.internet.MimeMessage; |
|
10 |
|
|
11 |
|
import dk.daoas.adressevedligehold.MailSender; |
12 |
import dk.daoas.adressevedligehold.beans.Address; |
import dk.daoas.adressevedligehold.beans.Address; |
13 |
import dk.daoas.adressevedligehold.beans.Address.AddressState; |
import dk.daoas.adressevedligehold.beans.Address.AddressState; |
14 |
|
import dk.daoas.adressevedligehold.tasks.TaskLogger; |
15 |
import dk.daoas.adressevedligehold.util.TimingHelper; |
import dk.daoas.adressevedligehold.util.TimingHelper; |
16 |
|
|
17 |
/* |
/* |
18 |
* TODO: detail rapport pr postnr |
* |
|
* TODO: ved mangel oversigten - skeln mellem om det er nye/CREATED eller om det er gamle kendte adresser |
|
19 |
*/ |
*/ |
20 |
|
|
21 |
public class AddressReport { |
public class AddressReport { |
22 |
|
|
23 |
class NumEntry { |
static class NumEntry { |
24 |
int open = 0; |
int open = 0; |
25 |
int closed = 0; |
int closed = 0; |
26 |
int modified = 0; |
int modified = 0; |
27 |
int created = 0; |
int created = 0; |
28 |
|
|
29 |
public void updateFromState(AddressState st) { |
public void updateFromState(AddressState st) { |
30 |
if (st == AddressState.OPENED) |
if (st == AddressState.OPENED) |
31 |
open++; |
open++; |
41 |
this.created += other.created; |
this.created += other.created; |
42 |
} |
} |
43 |
} |
} |
44 |
class WeekEntry { |
static class WeekEntry { |
45 |
NumEntry man = new NumEntry(); |
NumEntry man = new NumEntry(); |
46 |
NumEntry tir = new NumEntry(); |
NumEntry tir = new NumEntry(); |
47 |
NumEntry ons = new NumEntry(); |
NumEntry ons = new NumEntry(); |
49 |
NumEntry fre = new NumEntry(); |
NumEntry fre = new NumEntry(); |
50 |
NumEntry lor = new NumEntry(); |
NumEntry lor = new NumEntry(); |
51 |
NumEntry son = new NumEntry(); |
NumEntry son = new NumEntry(); |
52 |
|
|
53 |
public void incrementFromOther(WeekEntry other) { |
public void incrementFromOther(WeekEntry other) { |
54 |
man.updateFromOther(other.man); |
man.updateFromOther(other.man); |
55 |
tir.updateFromOther(other.tir); |
tir.updateFromOther(other.tir); |
59 |
lor.updateFromOther(other.lor); |
lor.updateFromOther(other.lor); |
60 |
son.updateFromOther(other.son); |
son.updateFromOther(other.son); |
61 |
} |
} |
62 |
|
|
63 |
public void incrementCreated() { |
public void incrementCreated() { |
64 |
man.created++; |
man.created++; |
65 |
tir.created++; |
tir.created++; |
70 |
son.created++; |
son.created++; |
71 |
} |
} |
72 |
} |
} |
73 |
|
|
74 |
|
private static TaskLogger logger = TaskLogger.getInstance(); |
75 |
|
|
76 |
AddressManager addrManager; |
AddressManager addrManager; |
77 |
List<Address> addressList; |
List<Address> addressList; |
78 |
int entryCount; |
int entryCount; |
80 |
AddressSource source; |
AddressSource source; |
81 |
TimingHelper timer; |
TimingHelper timer; |
82 |
boolean writeBack; |
boolean writeBack; |
83 |
|
int duplicateCount; |
84 |
//TODO: Afviste adresser |
|
85 |
public AddressReport(AddressManager addrManager, int entryCount, EntryUgedage ugedage, AddressSource source, TimingHelper timer, boolean writeBack ) { |
|
86 |
|
public AddressReport(AddressManager addrManager, int entryCount, EntryUgedage ugedage, AddressSource source, TimingHelper timer, boolean writeBack, int duplicateCount ) { |
87 |
this.addrManager = addrManager; |
this.addrManager = addrManager; |
88 |
addressList = addrManager.getAddressList(); |
addressList = addrManager.getAddressList(); |
89 |
this.entryCount = entryCount; |
this.entryCount = entryCount; |
91 |
this.source = source; |
this.source = source; |
92 |
this.timer = timer; |
this.timer = timer; |
93 |
this.writeBack = writeBack; |
this.writeBack = writeBack; |
94 |
|
this.duplicateCount = duplicateCount; |
95 |
} |
} |
96 |
|
|
97 |
public void sendRapport() { |
public void sendRapport() { |
98 |
System.out.println("Sending mail"); |
logger.info("Sending mail"); |
99 |
|
|
100 |
String reportData = getReportData(); |
String reportData = getReportData(); |
101 |
String subject = "Indlæsnings rapport for " + source.getDistributor(); |
String subject = "Indlæsnings rapport for " + source.getDistributor(); |
102 |
|
|
103 |
|
String newOpenCloseAttachment = getAttachement(); |
104 |
Properties props = new Properties(); |
|
105 |
props.put("mail.smtp.host", "10.30.1.28"); |
MailSender.sendMailWithAttachment(subject, reportData, "Details.csv", newOpenCloseAttachment); |
106 |
//props.put("mail.smtp.host", "192.168.12.10"); |
|
|
|
|
|
try { |
|
|
// create some properties and get the default Session |
|
|
Session session = Session.getDefaultInstance(props, null); |
|
|
session.setDebug(false); |
|
|
|
|
|
MimeMessage msg = new MimeMessage(session); |
|
|
msg.setFrom( new InternetAddress("no-reply@daoas.dk") ); |
|
|
|
|
|
|
|
|
msg.setRecipient(Message.RecipientType.TO, new InternetAddress("thn@daoas.dk") );//TODO: mulighed for at ændre modtager mail |
|
|
msg.setSubject( subject ); |
|
|
msg.setContent(reportData, "text/html; charset=utf-8"); |
|
|
|
|
|
Transport.send(msg); |
|
|
|
|
|
|
|
|
} catch (MessagingException e) { |
|
|
System.out.println("Unable to send report mail " + e.getMessage() ); |
|
|
} |
|
|
|
|
|
|
|
107 |
} |
} |
108 |
|
|
109 |
|
|
110 |
|
|
111 |
public String getReportData() { |
public String getReportData() { |
112 |
|
|
113 |
WeekEntry total = new WeekEntry(); |
WeekEntry total = new WeekEntry(); |
114 |
HashMap<Short, WeekEntry> postnrEntries = new HashMap<Short,WeekEntry>(); |
HashMap<Short, WeekEntry> postnrEntries = new HashMap<Short,WeekEntry>(); |
115 |
|
|
116 |
|
int createFailCount = 0; |
117 |
int antalUdenKommunekodeNy = 0; |
|
118 |
|
int antalUdenGadeid = 0; |
119 |
int antalUdenKommunekode = 0; |
int antalUdenKommunekode = 0; |
120 |
int antalUdenLatitude = 0; |
int antalUdenLatitude = 0; |
121 |
int antalUdenDBKBane = 0; |
int antalUdenDBKBane = 0; |
122 |
|
|
123 |
// first gather the intel |
// first gather the intel |
124 |
for (Address a : addressList) { |
for (Address a : addressList) { |
125 |
if (a.kommunekode == 0 || a.vejkode == 0) { |
|
126 |
if (a.state == AddressState.CREATED) { |
if (a.state == AddressState.CREATE_FAIL) { |
127 |
antalUdenKommunekodeNy++; |
createFailCount++; |
128 |
} |
continue; |
129 |
|
} |
130 |
|
|
131 |
|
if (a.gadeid == 0) { |
132 |
|
antalUdenGadeid++; |
133 |
|
} |
134 |
|
|
135 |
|
if (a.kommunekode == 0 || a.vejkode == 0) { |
136 |
antalUdenKommunekode++; |
antalUdenKommunekode++; |
137 |
} |
} |
138 |
|
|
139 |
if (a.latitude == 0 || a.longitude == 0) { |
if (a.latitude == 0 || a.longitude == 0) { |
140 |
antalUdenLatitude++; |
antalUdenLatitude++; |
141 |
} |
} |
142 |
|
|
143 |
if (a.state == AddressState.NOT_CHANGED) { |
if (a.state == AddressState.NOT_CHANGED) { |
144 |
continue; |
continue; |
145 |
} |
} |
146 |
if (a.dbkBane == 0) { |
if (a.dbkBane == 0) { |
147 |
antalUdenDBKBane++; |
antalUdenDBKBane++; |
148 |
} |
} |
149 |
|
|
150 |
WeekEntry weekEntry = postnrEntries.get(a.postnr); |
WeekEntry weekEntry = postnrEntries.get(a.postnr); |
151 |
if (weekEntry == null) { |
if (weekEntry == null) { |
152 |
weekEntry = new WeekEntry(); |
weekEntry = new WeekEntry(); |
153 |
postnrEntries.put(a.postnr, weekEntry); |
postnrEntries.put(a.postnr, weekEntry); |
154 |
} |
} |
155 |
|
|
156 |
|
|
157 |
|
|
158 |
if (a.state == AddressState.CREATED) { |
if (a.state == AddressState.CREATED) { |
159 |
weekEntry.incrementCreated(); |
weekEntry.incrementCreated(); |
160 |
} else { |
} else { |
165 |
weekEntry.fre.updateFromState(a.stateFre); |
weekEntry.fre.updateFromState(a.stateFre); |
166 |
weekEntry.lor.updateFromState(a.stateLor); |
weekEntry.lor.updateFromState(a.stateLor); |
167 |
weekEntry.son.updateFromState(a.stateSon); |
weekEntry.son.updateFromState(a.stateSon); |
168 |
|
|
169 |
} |
} |
170 |
} |
} |
171 |
for (WeekEntry w : postnrEntries.values()) { |
for (WeekEntry w : postnrEntries.values()) { |
172 |
total.incrementFromOther(w); |
total.incrementFromOther(w); |
173 |
} |
} |
174 |
|
|
175 |
StringBuilder sb = new StringBuilder(); |
StringBuilder sb = new StringBuilder(); |
176 |
|
|
177 |
sb.append("<h1>Indlæsnings rapport for " + source.getDistributor() + " </h1>"); |
sb.append("<h1>Indlæsnings rapport for " + source.getDistributor() + " </h1>"); |
178 |
sb.append("Filnavn: ").append( source.getFilename() ).append("<br>"); |
sb.append("Filnavn: ").append( source.getFilename() ).append("<br>"); |
179 |
sb.append("Tidsforbrug: ").append( timer.getElapsed() ).append("ms. <br>"); |
sb.append("Tidsforbrug: ").append( timer.getElapsed() ).append("ms. <br>"); |
180 |
sb.append("Skriv til DB: ").append( writeBack ).append("<br>"); |
sb.append("Skriv til DB: ").append( writeBack ).append("<br>"); |
181 |
sb.append("Antal entries: " ).append( entryCount ).append("<br>"); |
sb.append("Antal entries: " ).append( entryCount ).append("<br>"); |
182 |
sb.append("Antal afviste: " ).append( addrManager.getAfvistAntal() ).append("<br>"); |
sb.append("Antal afviste: " ).append( addrManager.getRejectedCount() ).append("<br>"); |
183 |
|
sb.append("Antal dubletter: " ).append( duplicateCount ).append("<br>"); |
184 |
|
sb.append("Antal fejlede inserts: ").append(createFailCount).append("<br>"); |
185 |
|
sb.append("Filen indeholder data til: "); |
186 |
|
if (ugedage.mandag) sb.append("Mandag, "); |
187 |
|
if (ugedage.tirsdag) sb.append("Tirsdag, "); |
188 |
|
if (ugedage.onsdag) sb.append("Onsdag, "); |
189 |
|
if (ugedage.torsdag) sb.append("Torsdag, "); |
190 |
|
if (ugedage.fredag) sb.append("Fredag, "); |
191 |
|
if (ugedage.lordag) sb.append("Lørdag, "); |
192 |
|
if (ugedage.sondag) sb.append("Søndag, "); |
193 |
|
sb.append("<br>"); |
194 |
|
|
195 |
sb.append("<h2>Data Mangler</h2>\n"); |
sb.append("<h2>Data Mangler</h2>\n"); |
196 |
sb.append("<pre>"); |
sb.append("<pre>"); |
197 |
sb.append("Mangler kommune/vejkode: ").append(antalUdenKommunekode).append("\n"); |
sb.append("Mangler kommune/vejkode: ").append(antalUdenKommunekode).append("\n"); |
198 |
|
sb.append("Mangler gadeid: ").append(antalUdenGadeid).append("\n"); |
199 |
sb.append("Mangler DBK bane: ").append(antalUdenDBKBane).append("\n"); |
sb.append("Mangler DBK bane: ").append(antalUdenDBKBane).append("\n"); |
200 |
sb.append("Mangler latitude/longitude: ").append(antalUdenLatitude).append("\n"); |
sb.append("Mangler latitude/longitude: ").append(antalUdenLatitude).append("\n"); |
201 |
sb.append("</pre>"); |
sb.append("</pre>"); |
|
|
|
202 |
|
|
203 |
|
|
204 |
|
|
205 |
sb.append("<h2>Ændrings oversigt</h2>\n"); |
sb.append("<h2>Ændrings oversigt</h2>\n"); |
206 |
sb.append("<table>"); |
sb.append("<table>"); |
207 |
|
|
208 |
sb.append("<tr><td> </td><td>Mandag</td><td>Tirsdag</td><td>Onsdag</td><td>Torsdag</td><td>Fredag</td><td>Lørdag</td><td>Søndag</td></tr>"); |
sb.append("<tr><td> </td><td>Mandag</td><td>Tirsdag</td><td>Onsdag</td><td>Torsdag</td><td>Fredag</td><td>Lørdag</td><td>Søndag</td></tr>"); |
209 |
sb.append("<tr><td>Oprettet:</td><td>").append(total.man.created).append("</td><td>").append(total.tir.created).append("</td><td>").append(total.ons.created).append("</td><td>").append(total.tor.created).append("</td><td>").append(total.fre.created).append("</td><td>").append(total.lor.created).append("</td><td>").append(total.son.created).append("</td></tr>"); |
sb.append("<tr><td>Oprettet:</td><td>").append(total.man.created).append("</td><td>").append(total.tir.created).append("</td><td>").append(total.ons.created).append("</td><td>").append(total.tor.created).append("</td><td>").append(total.fre.created).append("</td><td>").append(total.lor.created).append("</td><td>").append(total.son.created).append("</td></tr>"); |
210 |
sb.append("<tr><td>Åbnet:</td><td>").append(total.man.open).append("</td><td>").append(total.tir.open).append("</td><td>").append(total.ons.open).append("</td><td>").append(total.tor.open).append("</td><td>").append(total.fre.open).append("</td><td>").append(total.lor.open).append("</td><td>").append(total.son.open).append("</td></tr>"); |
sb.append("<tr><td>Åbnet:</td><td>").append(total.man.open).append("</td><td>").append(total.tir.open).append("</td><td>").append(total.ons.open).append("</td><td>").append(total.tor.open).append("</td><td>").append(total.fre.open).append("</td><td>").append(total.lor.open).append("</td><td>").append(total.son.open).append("</td></tr>"); |
211 |
sb.append("<tr><td>Ændret:</td><td>").append(total.man.modified).append("</td><td>").append(total.tir.modified).append("</td><td>").append(total.ons.modified).append("</td><td>").append(total.tor.modified).append("</td><td>").append(total.fre.modified).append("</td><td>").append(total.lor.modified).append("</td><td>").append(total.son.modified).append("</td></tr>"); |
sb.append("<tr><td>Ændret:</td><td>").append(total.man.modified).append("</td><td>").append(total.tir.modified).append("</td><td>").append(total.ons.modified).append("</td><td>").append(total.tor.modified).append("</td><td>").append(total.fre.modified).append("</td><td>").append(total.lor.modified).append("</td><td>").append(total.son.modified).append("</td></tr>"); |
212 |
sb.append("<tr><td>Lukket:</td><td>").append(total.man.closed).append("</td><td>").append(total.tir.closed).append("</td><td>").append(total.ons.closed).append("</td><td>").append(total.tor.closed).append("</td><td>").append(total.fre.closed).append("</td><td>").append(total.lor.closed).append("</td><td>").append(total.son.closed).append("</td></tr>"); |
sb.append("<tr><td>Lukket:</td><td>").append(total.man.closed).append("</td><td>").append(total.tir.closed).append("</td><td>").append(total.ons.closed).append("</td><td>").append(total.tor.closed).append("</td><td>").append(total.fre.closed).append("</td><td>").append(total.lor.closed).append("</td><td>").append(total.son.closed).append("</td></tr>"); |
213 |
|
sb.append("</table>"); |
214 |
|
|
215 |
|
sb.append("<br>"); |
216 |
|
sb.append("<h2>Nye/Ukendte gader</h2>"); |
217 |
|
sb.append("<table>"); |
218 |
|
sb.append("<tr><th>Gadeid</th><th>Vejnavn</th></tr>"); |
219 |
|
for( Entry<Integer,String> unknownStreet : addrManager.getUnknownStreets().entrySet() ) { |
220 |
|
sb.append("<tr><td>").append(unknownStreet.getKey()).append("</td><td>").append(unknownStreet.getValue()).append("</td></tr>"); |
221 |
|
} |
222 |
|
sb.append("</table>"); |
223 |
|
|
224 |
|
|
225 |
|
sb.append("</table><br>\n"); |
226 |
|
|
227 |
|
return sb.toString(); |
228 |
|
} |
229 |
|
|
230 |
|
public String getAttachement() { |
231 |
|
StringBuilder sb = new StringBuilder(); |
232 |
|
sb.append("Status;Gadeid;Post;Vejnavn;Husnr;Litra\r\n"); |
233 |
|
|
234 |
|
ArrayList<Address> attachmentData = new ArrayList<Address>(); |
235 |
|
for (Address a : addressList) { |
236 |
|
if (a.state == AddressState.CLOSED || a.state == AddressState.CREATED || a.state == AddressState.OPENED) { |
237 |
|
attachmentData.add(a); |
238 |
|
} |
239 |
|
} |
240 |
|
|
241 |
|
attachmentData.sort( new AttachmentComparator() ); |
242 |
|
|
243 |
sb.append("</table><br>\n"); |
|
244 |
|
for (Address a : attachmentData) { |
245 |
|
switch (a.state) { |
246 |
|
case CLOSED: |
247 |
|
sb.append("Closed;"); |
248 |
|
break; |
249 |
|
case CREATED: |
250 |
|
sb.append("Created;"); |
251 |
|
break; |
252 |
|
case OPENED: |
253 |
|
sb.append("Opened;"); |
254 |
|
break; |
255 |
|
default: |
256 |
|
break; |
257 |
|
} |
258 |
|
|
259 |
|
//tilføj resten af dataene |
260 |
|
sb.append( a.gadeid + ";" + a.postnr + ";" + a.vejnavn + ";" + a.husnr + ";" + a.husnrbogstav + "\r\n"); |
261 |
|
} |
262 |
|
|
263 |
return sb.toString(); |
return sb.toString(); |
264 |
} |
} |
265 |
|
|
266 |
|
class AttachmentComparator implements Comparator<Address> { |
267 |
|
|
268 |
|
@Override |
269 |
|
public int compare(Address a1, Address a2) { |
270 |
|
|
271 |
|
|
272 |
|
//Brug apache commons lang3 |
273 |
|
return new CompareToBuilder() |
274 |
|
.append(a1.state, a2.state) |
275 |
|
.append(a1.postnr, a2.postnr) |
276 |
|
.append(a1.vejnavn, a2.vejnavn) |
277 |
|
.append(a1.husnr, a2.husnr) |
278 |
|
.append(a1.husnrbogstav, a2.husnrbogstav) |
279 |
|
.toComparison(); |
280 |
|
} |
281 |
|
|
282 |
|
} |
283 |
} |
} |