/*
 * Created on 2005-10-4
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package org.huihoo.openweb.uddiserver.util;

import java.io.BufferedInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.net.MalformedURLException;
import java.net.URL;
import java.rmi.RemoteException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Enumeration;
import java.util.Iterator;
import java.util.Vector;

import javax.wsdl.Binding;
import javax.wsdl.BindingOperation;
import javax.wsdl.Definition;
import javax.wsdl.Operation;
import javax.wsdl.PortType;
import javax.wsdl.WSDLException;
import javax.wsdl.factory.WSDLFactory;
import javax.wsdl.xml.WSDLReader;
import javax.xml.namespace.QName;
import javax.xml.rpc.ServiceException;

import org.apache.axis.client.Call;
import org.huihoo.openweb.uddi.BusinessEntity;
import org.huihoo.openweb.uddi.BusinessService;
import org.huihoo.openweb.uddi.DispositionReport;
import org.huihoo.openweb.uddi.KeyedReference;
import org.huihoo.openweb.uddi.TModel;
import org.huihoo.openweb.uddi.UDDIXmlException;
import org.huihoo.openweb.uddi.UddiObject;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;



/**
 * @author sky1
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class validate_values {
	
	private static Connection con =null;
	static{
		try {
			con = SqlConnection.getConnection();
		}catch (Exception e)
		{
			try {
				con.rollback();
				con.close();
			}
			catch ( Exception e1){
				e1.printStackTrace();
			}
			e.printStackTrace();
		}
	}

	/**從Valid_Services表中找到引用某個分類tModel的驗證服務。
	 * 如果從Valid_Services表中找到了一個這樣的驗證服務，說明這個tModel引用的分類tModel是需要checked的。
	 * */
	
	public static boolean performValidValues(Enumeration enum){
		System.out.println("performValidValues");
		boolean isvalid=true;
		while(enum.hasMoreElements()){
			UddiObject obj=(UddiObject)enum.nextElement();
			if(obj instanceof BusinessEntity){
					isvalid=performValidValue((BusinessEntity)obj);
					System.out.println("performValidValues isvalid="+isvalid);
					if(!isvalid){
						break;
					}
			}
			
			if(obj instanceof BusinessService){
					isvalid=performValidValue((BusinessService)obj);
					if(!isvalid){
						break;
					}
			}
			
			if(obj instanceof TModel){
					isvalid=performValidValue((TModel)obj);
					if(!isvalid){
						break;
					}
			}
		}
		System.out.println("isvalid: "+ isvalid);
		return isvalid;
	}
    
	private static boolean performValidValue(TModel model)
//	throws SQLException,UDDIXmlException, ClassNotFoundException,WSDLException,MalformedURLException,IOException,
//	ServiceException,RemoteException
	{
		boolean validCategory=true;
		boolean validIdentifier=true;
		//驗證categorybag中的內容
		org.huihoo.openweb.uddi.CategoryBag categorybag = null;
		try{
			if(model.getCategoryBag() != null)
			{
				categorybag = model.getCategoryBag();
				Enumeration keyedref = null;
				if(categorybag.getKeyedReference() != null){
					keyedref = categorybag.getKeyedReference();
					validCategory=validateKeyReference(keyedref,model);
				}
			}
		}catch(UDDIXmlException e){
			
		}

		//驗證identifierbag中的內容
		org.huihoo.openweb.uddi.IdentifierBag identifierBag = null;
		try{
			if(model.getIdentifierBag() != null)
			{
				identifierBag = model.getIdentifierBag();
				Enumeration keyedref = null;
				if(identifierBag.getKeyedReference() != null){
					keyedref = identifierBag.getKeyedReference();
					validIdentifier=validateKeyReference(keyedref ,model);
				}
			}
		}catch(UDDIXmlException e){
			
		}

		return validCategory&&validIdentifier;
	}
	
	private static boolean performValidValue(BusinessEntity entity)
//	throws SQLException,UDDIXmlException, ClassNotFoundException,WSDLException,MalformedURLException,IOException,
//	ServiceException,RemoteException
	{	
		System.out.println("performValidValue BusinessEntity");
		boolean validCategory=true;
		boolean validIdentifier=true;
		//驗證categorybag中的內容
		org.huihoo.openweb.uddi.CategoryBag categorybag = null;
		try{
			if(entity.getCategoryBag() != null)
			{
				categorybag = entity.getCategoryBag();
				Enumeration keyedref = null;
				if(categorybag.getKeyedReference() != null){
					keyedref = categorybag.getKeyedReference();
					validCategory=validateKeyReference(keyedref,entity);
					System.out.println("validateKeyReference validCategory="+validCategory);
					//System.out.println("validateKeyReference hahah");
				}
			}
		}catch(UDDIXmlException e){
			//System.err.println("validateKeyReference hahahahaha");
		}
		//System.out.println("validateKeyReference validCategory1="+validCategory);
		//驗證identifierbag中的內容
		org.huihoo.openweb.uddi.IdentifierBag identifierBag = null;
		try{
			if(entity.getIdentifierBag()!= null)
			{	
				//System.out.println("validateKeyReference dddddd");
				identifierBag = entity.getIdentifierBag();
				Enumeration keyedref = null;
				if(identifierBag.getKeyedReference() != null){
					keyedref = identifierBag.getKeyedReference();
					validIdentifier=validateKeyReference(keyedref,entity);
					//System.out.println("validateKeyReference dddddd");
				}
			}
		}catch (UDDIXmlException e){
			//System.err.println("validateKeyReference dadfasdf");
		}
		
		System.out.println("validCategory: "+validCategory);
		System.out.println("validIdentifier: "+validIdentifier);
		System.out.println("validCategory&&validIdentifier: "+ (validCategory&&validIdentifier));
		return (validCategory&&validIdentifier);
	}
	
	//在BusinessService中只有categorybag信息。
	private static boolean performValidValue(BusinessService bService)
//	throws SQLException,UDDIXmlException, ClassNotFoundException,WSDLException,MalformedURLException,IOException,
//	ServiceException,RemoteException
	{
		boolean validCategory=true;
		boolean validIdentifier=true;
		//驗證categorybag中的內容
		org.huihoo.openweb.uddi.CategoryBag categorybag = null;
		try{
			if(bService.getCategoryBag() != null)
			{
				categorybag = bService.getCategoryBag();
				Enumeration keyedref = null;
				if(categorybag.getKeyedReference() != null){
					keyedref = categorybag.getKeyedReference();
					validCategory=validateKeyReference(keyedref,bService);
					
				}
			}
		}catch (UDDIXmlException e){
			
		}

		return validCategory;
	}
	
	private static boolean validateKeyReference(Enumeration keyedref,UddiObject obj)
//	throws SQLException,UDDIXmlException, ClassNotFoundException,WSDLException,MalformedURLException,IOException,
//	ServiceException,RemoteException
	{
		System.out.println("validateKeyReference ");
		try{
			Statement stmt1;
			boolean valid=true;
			UddiObject resp=null;
			for(; keyedref.hasMoreElements(); stmt1.close())
			{
				KeyedReference keyedreference = (KeyedReference)keyedref.nextElement();
				String keyname = "";
				if(keyedreference.getKeyName() != null)
					keyname = keyedreference.getKeyName();
				System.out.println("keyname:"+keyname);
				String keyvalue = "";
				if(keyedreference.getKeyValue() != null)
					keyvalue = keyedreference.getKeyValue();
				System.out.println("keyvalue:"+keyvalue);
				String standardkey = "";
				if(keyedreference.getTModelKey().getValue() != null)
					standardkey = keyedreference.getTModelKey().getValue();
				System.out.println("standardkey:"+standardkey);
				System.out.println("validateKeyReference 0 ");
					
				//分類的使用是否需要check,不需要check則直接返回true
				String query1="select * from CategoryBag where Keys='" + standardkey + "' and tmodelkey='uuid:c1acf26d-9672-4404-9d70-39b756e62ab4'and Keyvalue='checked'";
				
				stmt1 = con.createStatement();
				ResultSet rs1 = stmt1.executeQuery(query1);