package webService;

import java.io.StringWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.transform.Result;
import javax.xml.transform.Source;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerConfigurationException;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;

import org.w3c.dom.Document;
import org.w3c.dom.Element;

import com.pindarset.myclipper.common.Util;
import com.pindarset.myclipper.common.exception.MyClipperApplicationException;
import com.pindarset.myclipper.common.exception.MyClipperException;
import com.pindarset.myclipper.common.exception.MyClipperSystemException;
import com.pindarset.myclipper.job.common.JobDelegator;
import com.pindarset.myclipper.job.specvisual.model.Advertiser;
import com.pindarset.myclipper.job.specvisual.model.SpecVisual;

public class EdicionImpl implements Edicion {

	public Document getXMLMassiveSpecVisualResponse(
			ArrayList<AdvertSearchForMassiveSpecVisualCreationInfo> lstAdvertSearchForMassiveSpecVisualCreationInfo,
			int totalOK) throws ParserConfigurationException {
		Document document = null;
		DocumentBuilderFactory documentBuilderFactory =

		DocumentBuilderFactory.newInstance();
		DocumentBuilder documentBuilder = null;

		documentBuilder = documentBuilderFactory.newDocumentBuilder();

		document = documentBuilder.newDocument();

		Element rootElement = document.createElement("response");
		document.appendChild(rootElement);

		Element ok = document.createElement("ok");

		Element total = document.createElement("total");
		total.appendChild(document.createTextNode(String.valueOf(totalOK)));

		ok.appendChild(total);

		Element fail = document.createElement("fail");
		int i = 0;
		while (i < lstAdvertSearchForMassiveSpecVisualCreationInfo.size()) {

			AdvertSearchForMassiveSpecVisualCreationInfo tmpAdvertSearchForMassiveSpecVisualCreationInfo = (AdvertSearchForMassiveSpecVisualCreationInfo) lstAdvertSearchForMassiveSpecVisualCreationInfo
					.get(i);

			// while (i <= specVisual.size()) {
			Element boceto = document.createElement("boceto");

			Element id = document.createElement("id");
			id.appendChild(document
					.createTextNode(tmpAdvertSearchForMassiveSpecVisualCreationInfo
							.getClipper_wi_ref()));

			Element guia = document.createElement("guia");
			guia.appendChild(document
					.createTextNode(tmpAdvertSearchForMassiveSpecVisualCreationInfo
							.getEdition_name()));

			Element edicion = document.createElement("edicion");
			edicion.appendChild(document
					.createTextNode(tmpAdvertSearchForMassiveSpecVisualCreationInfo
							.getBook_edition()));

			Element tamano = document.createElement("tamano");
			tamano.appendChild(document
					.createTextNode(tmpAdvertSearchForMassiveSpecVisualCreationInfo
							.getUdac_desc()));

			Element producto = document.createElement("producto");
			producto.appendChild(document
					.createTextNode(tmpAdvertSearchForMassiveSpecVisualCreationInfo
							.getPub_product_desc()));

			Element estado = document.createElement("estado");
			estado.appendChild(document
					.createTextNode(tmpAdvertSearchForMassiveSpecVisualCreationInfo
							.getCurrent_status()));

			boceto.appendChild(id);
			boceto.appendChild(guia);
			boceto.appendChild(edicion);
			boceto.appendChild(tamano);
			boceto.appendChild(producto);
			boceto.appendChild(estado);

			fail.appendChild(boceto);

			i++;

		}

		rootElement.appendChild(ok);
		rootElement.appendChild(fail);

		return document;
	}

	public static void main(String args[]) {

		String array[] = new String[4];
		array[0] = "1-S00001030001";
		array[1] = "1-S00626023001";
		array[2] = "1-S00605935001";
		array[3] = "1-S00001030001";
		EdicionImpl edicion = new EdicionImpl();
		try {
			edicion.Insertar(array);
		} catch (MyClipperException e) {
			e.printStackTrace();
		}

	}

	public ArrayList<SpecVisual> Insertar_bocetos(String[] anuncios) {

		String driver = "org.postgresql.Driver";
		String connectString = "jdbc:postgresql://db1.medellin.intrayell.com:5432/clipper";
		String user = "clipper";
		String password = "clipper";

		SpecVisual specVisual = new SpecVisual();
		Advertiser advertiser = new Advertiser();
		ArrayList<SpecVisual> arrbocetos = new ArrayList<SpecVisual>();

		try {
			Class.forName(driver);
			Connection con = DriverManager.getConnection(connectString, user,
					password);
			Statement stmt = con.createStatement();
			for (int i = 0; i < anuncios.length; i++) {

				ResultSet rs = stmt
						.executeQuery("Select sp.clipper_Book_Id,sp.Book_Edition,"
								+ "sp.creativity_id,sp.Awaiting_ref_flag,sp.type_Id,sp.pub_ad_code,sp.heading_name,"
								+ "sp.Login_Id,sp.sales_rep_code,ad.advertiser_name,ad.clipper_advertiser_ref,sp.language_id,sp.multi_page_flag "
								+ "from advertiser ad,Spec_visual sp "
								+ "where sp.clipper_advertiser_ref= ad.clipper_advertiser_ref and sp.clipper_wi_ref='"
								+ anuncios[i] + "'");

				while (rs.next()) {

					specVisual
							.setClipperBookId(rs.getString("clipper_Book_Id"));
					specVisual.setBookEditionId(Long.parseLong(rs
							.getString("Book_Edition")));
					specVisual.setCreativityId(Integer.parseInt(rs
							.getString("creativity_id")));
					specVisual.setAwaitRefFlag(Integer.parseInt(rs
							.getString("Awaiting_ref_flag")));
					specVisual.setTypeId(Integer.parseInt(rs
							.getString("type_Id")));
					specVisual.setPubAdCode(rs.getString("pub_ad_code"));
					specVisual.setHeadingName(rs.getString("heading_name"));
					specVisual.setLoginId(rs.getString("Login_Id"));
					specVisual.setSalesRepCode(rs.getString("sales_rep_code"));

					advertiser.setAdvertiserName(rs
							.getString("advertiser_name"));
					advertiser.setClipperAdvertiserRef(rs
							.getString("clipper_advertiser_ref"));

					specVisual.setAdvertiser(advertiser);
					specVisual.setLanguageId(Integer.parseInt(rs
							.getString("language_id")));
					specVisual.setMultiPageFlag(Integer.parseInt(rs
							.getString("multi_page_flag")));
					// specVisual.setTypeInstructionsText("specVisualFB.getInstructions()");
					arrbocetos.add(specVisual);

				}
			}
				stmt.close();
				con.close();


		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return arrbocetos;
	}

	public String Insertar(String[] anuncios) throws MyClipperException,
			MyClipperApplicationException {

		String textXMLDoc = "";
		ArrayList<SpecVisual> arrbocetos = null;
		arrbocetos = new ArrayList<SpecVisual>();
		ArrayList<SpecVisual> arrbocetosEnviar = null;
		arrbocetosEnviar = new ArrayList<SpecVisual>();
		ArrayList<SpecVisual> arrbocetosFallidos = null;
		arrbocetosFallidos = new ArrayList<SpecVisual>();
		ArrayList<AdvertSearchForMassiveSpecVisualCreationInfo> arrbocetosFallidosadvert = null;
		arrbocetosFallidosadvert = new ArrayList<AdvertSearchForMassiveSpecVisualCreationInfo>();

		arrbocetos = Insertar_bocetos(anuncios);

		for (SpecVisual spec : arrbocetos) {
			arrbocetosEnviar.add(spec);
			try {
				arrbocetosEnviar.clear();
				JobDelegator.createSpecVisuals(arrbocetosEnviar);
				arrbocetosEnviar.clear();
			}

			catch (MyClipperException exe) {
				arrbocetosFallidos.add(spec);
				arrbocetosEnviar.clear();
				for (SpecVisual specFall : arrbocetosFallidos) {
					AdvertSearchForMassiveSpecVisualCreationInfo adverFall = new AdvertSearchForMassiveSpecVisualCreationInfo();

					try {

						adverFall.setClipper_wi_ref(specFall.getClipperWiRef());
						// adverFall.setEdition_name(specFall.get);
						adverFall.setBook_edition(specFall.getBookEdition()
								.toString());// ?
						adverFall.setUdac_desc(specFall.getPubAdCode());
						// adverFall.setPub_product_desc(specFall.getPubAdCode());
						adverFall
								.setCurrent_status(specFall.getCurrentStatus());
						arrbocetosFallidosadvert.add(adverFall);
					}

					catch (Exception e) {

					}
				}

			}
		}

		try {
			Document doc = getXMLMassiveSpecVisualResponse(
					arrbocetosFallidosadvert, arrbocetosFallidos.size());
			try {

				Source source = new DOMSource(doc);
				StringWriter stringWriter = new StringWriter();
				Result result = new StreamResult(stringWriter);
				TransformerFactory factory = TransformerFactory.newInstance();
				Transformer transformer = factory.newTransformer();
				transformer.transform(source, result);
				textXMLDoc = stringWriter.getBuffer().toString();
			} catch (TransformerConfigurationException e) {
				throw new MyClipperException(
						"Error while creating Massive SpecVisuals");

			} catch (TransformerException e) {
				throw new MyClipperException(
						"Error while creating Massive SpecVisuals");
			}
		} catch (ParserConfigurationException e) {

			e.printStackTrace();
		}

		return textXMLDoc;
	}

}