package dk.daoas.adressevedligehold;

import java.util.HashMap;
import java.util.List;
import java.util.Map.Entry;
import java.util.Properties;

import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;

import dk.daoas.adressevedligehold.beans.Address;
import dk.daoas.adressevedligehold.beans.Address.AddressState;
import dk.daoas.adressevedligehold.tasks.TaskLogger;
import dk.daoas.adressevedligehold.util.TimingHelper;

/* 
 * TODO: detail rapport pr postnr
 * TODO: ved mangel oversigten - skeln mellem om det er nye/CREATED eller om det er gamle kendte adresser
 */

public class AddressReport {
	
	static class NumEntry {
		int open = 0;
		int closed = 0;
		int modified = 0;
		int created = 0;
		
		public void updateFromState(AddressState st) {
			if (st == AddressState.OPENED)
				open++;
			if (st == AddressState.MODIFIED)
				modified++;
			if (st == AddressState.CLOSED)
				closed++;
		}
		public void updateFromOther(NumEntry other) {
			this.open += other.open;
			this.modified += other.modified;
			this.closed += other.closed;
			this.created += other.created;
		}
	}
	static class WeekEntry {
		NumEntry man = new NumEntry();
		NumEntry tir = new NumEntry();
		NumEntry ons = new NumEntry();
		NumEntry tor = new NumEntry();
		NumEntry fre = new NumEntry();
		NumEntry lor = new NumEntry();
		NumEntry son = new NumEntry();
		
		public void incrementFromOther(WeekEntry other) {
			man.updateFromOther(other.man);
			tir.updateFromOther(other.tir);
			ons.updateFromOther(other.ons);
			tor.updateFromOther(other.tor);
			fre.updateFromOther(other.fre);
			lor.updateFromOther(other.lor);
			son.updateFromOther(other.son);
		}
		
		public void incrementCreated() {
			man.created++;
			tir.created++;
			ons.created++;
			tor.created++;
			fre.created++;
			lor.created++;
			son.created++;
		}
	}
	
	private static TaskLogger logger = TaskLogger.getInstance();
	
	AddressManager addrManager;
	List<Address> addressList;
	int entryCount;
	EntryUgedage ugedage;
	AddressSource source;
	TimingHelper timer;
	boolean writeBack;
	
	//TODO: Afviste adresser
	public AddressReport(AddressManager addrManager, int entryCount, EntryUgedage ugedage, AddressSource source, TimingHelper timer, boolean writeBack ) {
		this.addrManager = addrManager;
		addressList = addrManager.getAddressList();
		this.entryCount = entryCount;
		this.ugedage = ugedage;
		this.source = source;
		this.timer = timer;
		this.writeBack = writeBack;
		
	}
	
	public void sendRapport() {
		logger.info("Sending mail");
		
		String reportData = getReportData();
		String subject = "Indlæsnings rapport for " + source.getDistributor();
		
		AddressReport.sendMail(subject, reportData);
		
	}
	
	public static void sendMail(String subject, String htmlBody) {
	       Properties props = new Properties();
	        props.put("mail.smtp.host", "10.30.1.28");
	        //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(htmlBody, "text/html; charset=utf-8");
				
				Transport.send(msg);
				
	        	
	    	} catch (MessagingException e) {
				logger.warning("Unable to send report mail ", e );
			}		
	}
	
	
	public String getReportData() {
	
		WeekEntry total = new WeekEntry();
		HashMap<Short, WeekEntry> postnrEntries = new HashMap<Short,WeekEntry>();
		
		int createFailCount = 0;
		
		int antalUdenGadeid = 0;
		int antalUdenKommunekode = 0;
		int antalUdenLatitude = 0;
		int antalUdenDBKBane = 0;
		
		// first gather the intel
		for (Address a : addressList) {
			
			if (a.state == AddressState.CREATE_FAIL) {
				createFailCount++;
				continue;			
			}
			
			if (a.gadeid == 0) {
				antalUdenGadeid++;
			}
			
			if (a.kommunekode == 0 || a.vejkode == 0) {				
				antalUdenKommunekode++;
			}
			
			if (a.latitude == 0 || a.longitude == 0) {
				antalUdenLatitude++;
			}
			
			if (a.state == AddressState.NOT_CHANGED) {
				continue;
			}
			if (a.dbkBane == 0) {
				antalUdenDBKBane++;
			}
			
			WeekEntry weekEntry = postnrEntries.get(a.postnr);
			if (weekEntry == null) {
				weekEntry = new WeekEntry();
				postnrEntries.put(a.postnr, weekEntry);
			}
			

			
			if (a.state == AddressState.CREATED) {
				weekEntry.incrementCreated();
			} else {
				weekEntry.man.updateFromState(a.stateMan);
				weekEntry.tir.updateFromState(a.stateTir);
				weekEntry.ons.updateFromState(a.stateOns);
				weekEntry.tor.updateFromState(a.stateTor);
				weekEntry.fre.updateFromState(a.stateFre);
				weekEntry.lor.updateFromState(a.stateLor);
				weekEntry.son.updateFromState(a.stateSon);
				
			}			
		}
		for (WeekEntry w : postnrEntries.values()) {
			total.incrementFromOther(w);
		}
		
		StringBuilder sb = new StringBuilder();
		
		sb.append("<h1>Indlæsnings rapport for " + source.getDistributor() + " </h1>");
		sb.append("Filnavn: ").append( source.getFilename() ).append("<br>");
		sb.append("Tidsforbrug: ").append( timer.getElapsed() ).append("ms. <br>");
		sb.append("Skriv til DB: ").append( writeBack ).append("<br>");
		sb.append("Antal entries: " ).append( entryCount ).append("<br>");
		sb.append("Antal afviste: " ).append( addrManager.getRejectedCount() ).append("<br>");
		sb.append("Antal fejlede inserts: ").append(createFailCount).append("<br>"); 
		sb.append("Filen indeholder data til: ");
		if (ugedage.mandag) sb.append("Mandag, ");
		if (ugedage.tirsdag) sb.append("Tirsdag, ");
		if (ugedage.onsdag) sb.append("Onsdag, ");
		if (ugedage.torsdag) sb.append("Torsdag, ");
		if (ugedage.fredag) sb.append("Fredag, ");
		if (ugedage.lordag) sb.append("Lørdag, ");
		if (ugedage.sondag) sb.append("Søndag, ");
		sb.append("<br>");
		
		sb.append("<h2>Data Mangler</h2>\n");
		sb.append("<pre>");
		sb.append("Mangler kommune/vejkode: ").append(antalUdenKommunekode).append("\n");
		sb.append("Mangler gadeid: ").append(antalUdenGadeid).append("\n");
		sb.append("Mangler DBK bane: ").append(antalUdenDBKBane).append("\n");
		sb.append("Mangler latitude/longitude: ").append(antalUdenLatitude).append("\n");
		sb.append("</pre>");
		

		
		sb.append("<h2>Ændrings oversigt</h2>\n");
		sb.append("<table>");
		
		sb.append("<tr><td>&nbsp;</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>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>Å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>Æ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>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("</table>");
		
		sb.append("<br>");
		sb.append("<h2>Nye/Ukendte gader</h2>");
		sb.append("<table>");
		sb.append("<tr><th>Gadeid</th><th>Vejnavn</th></tr>");
		for( Entry<Integer,String> unknownStreet : addrManager.getUnknownStreets().entrySet() ) {
			sb.append("<tr><td>").append(unknownStreet.getKey()).append("</td><td>").append(unknownStreet.getValue()).append("</td></tr>");
		}
		sb.append("</table>");
		
		
		sb.append("</table><br>\n");
		
		return sb.toString();
	}
}