package ext;

import java.util.*;
import java.rmi.RemoteException;

import wt.util.*;
import wt.fc.*;
import wt.vc.*;
import wt.query.*;
import wt.epm.*;
import wt.lifecycle.*;
import wt.lifecycle.State;
import wt.httpgw.GatewayAuthenticator;
import wt.method.RemoteMethodServer;
import com.ptc.windchill.enterprise.search.server.*;

import wt.enterprise.*;
import wt.series.*;
import com.ptc.windchill.enterprise.templates.*;

public class epmList_1A {

	public static void FindEpmNumbered(String drwNo) throws WTException, WTPropertyVetoException {

		Vector resultVector = new Vector();

		ClassAttribute versionAttribute = new ClassAttribute(EPMDocument.class, "versionInfo.identifier.versionId");
		ClassAttribute numberAttribute = new ClassAttribute(EPMDocument.class, EPMDocument.NUMBER);
		ClassAttribute iterationAttribute = new ClassAttribute(EPMDocument.class, "iterationInfo.identifier.iterationId");

		QuerySpec qs = new QuerySpec(EPMDocument.class);

		qs.appendSelect(numberAttribute, false);
		qs.appendSelect(versionAttribute, false);
		qs.appendSelect(iterationAttribute, false);
		qs.appendWhere(new SearchCondition(EPMDocument.class,EPMDocument.NUMBER,SearchCondition.LIKE,drwNo));
		qs.appendAnd();
		qs.appendWhere(new SearchCondition(EPMDocument.class, "iterationInfo.latest", "TRUE"));
		qs.appendOrderBy(new OrderBy(numberAttribute, false));
		qs.appendOrderBy(new OrderBy(versionAttribute, false));

		final QueryResult result = PersistenceHelper.manager.find(qs);

		while (result.hasMoreElements())
		{
			Object[] obj = (Object[]) result.nextElement();
			Series currentSeries = Series.newSeries((wt.vc.VersionIdentifier.class).getName(), (String) obj[2]);
			String currentNumber = (String) obj[1];

			try
			{
				Object[] lastObj = (Object[]) resultVector.lastElement();
				String lastNumber = (String) lastObj[1];
				Series lastSeries = Series.newSeries((wt.vc.VersionIdentifier.class).getName(), (String) lastObj[2]);

				if ((currentNumber.equals(lastNumber)) && (lastSeries.lessThan(currentSeries))) {
					resultVector.remove(lastObj);
				} else
				if ((currentNumber.equals(lastNumber)) && (lastSeries.greaterThan(currentSeries))) {
					continue;
				}
			}
			catch(NoSuchElementException e) { }
			catch(Exception e) { }

			resultVector.addElement(obj);
		}

		Enumeration resultEnum = resultVector.elements();

		while (resultEnum.hasMoreElements())
		{
			Object[] objr = (Object[]) resultEnum.nextElement();
			System.out.println( objr[1] + "," + objr[2] + "."+objr[3]);
		}
	}

	public static void main(String[] args) {
		if(args.length < 1)
		{
			System.out.println("Usage: windchill epmList <epmdoc search string>");
			System.exit(0);
		} else
		{
			try {
				RemoteMethodServer rms = RemoteMethodServer.getDefault();
				GatewayAuthenticator auth = new GatewayAuthenticator();
				auth.setRemoteUser("wcadmin");
				rms.setAuthenticator(auth);

				String drwNo = args[0];

				FindEpmNumbered(drwNo);

				System.exit(0);
			}
			catch(Exception exceptionMain)
			{
				exceptionMain.printStackTrace();
			}
		}
	}
}