import java.io.*;
import java.beans.*;
import java.net.URL;
import java.text.*;
import java.sql.*;

import java.awt.*;
import java.awt.Window;
import java.awt.event.*;

import javax.swing.*;
import javax.swing.JOptionPane;
import javax.swing.border.*;
import javax.swing.plaf.*;
import javax.swing.event.*;
import javax.swing.JFrame;
import javax.swing.JList;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JScrollPane;
import javax.swing.DefaultListModel;
import javax.swing.JTable;
import javax.swing.table.*;

import java.util.*;
import java.util.List;
import java.util.Vector;
import java.util.ResourceBundle;

public class NCR_IF_Man20i extends JInternalFrame implements ListSelectionListener {

	static int openFrameCount = 0;
	static final int offset = 20;

	public NCR_IF_Man20i() {
		super("NCR Query", true, true, true, true);
		setResizable( true );
		openFrameCount++;

		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		Dimension frameSize=new Dimension((int)(screenSize.width/2),(int)(screenSize.height/2));
		int x=(int)(frameSize.width/2);
		int y=(int)(frameSize.height/2);

		JPanel topPanel = new JPanel();
		topPanel.setBorder(new EmptyBorder(1,1,1,1));
		topPanel.setLayout(new BorderLayout());

		JPanel ncr_sel = new JPanel();
		ncr_sel.setLayout(new BorderLayout());
		ncr_sel.add(build_NCR_selPanel(), BorderLayout.NORTH);

		JPanel buttonPanel = new JPanel();
		buttonPanel.setLayout ( new FlowLayout(FlowLayout.CENTER) );

		RunBut = new JButton("RUN");
		RunBut.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				svr_cyc();
		}});
		buttonPanel.add(RunBut);

		UpBut = new JButton("Update Existing MDB");
		UpBut.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				data2mdb( " " );
		}});
		buttonPanel.add(UpBut);

		WrBut = new JButton("Write New MDB");
		WrBut.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				data2mdb( "WN" );
		}});
		buttonPanel.add(WrBut);

		topPanel.add(ncr_sel, BorderLayout.NORTH);
		topPanel.add(buttonPanel, BorderLayout.SOUTH);

		setContentPane(topPanel);
		pack();
		setLocation( offset * openFrameCount, offset * openFrameCount);
	}

	public JPanel build_NCR_selPanel() {
		JPanel NCR_allGrid = new JPanel();
		GridBagLayout gbc0 = new GridBagLayout();
		NCR_allGrid.setLayout(gbc0);

		//		All Panels

		JPanel NCR_selPanel = new JPanel();
		GridBagLayout gbc1 = new GridBagLayout();
		NCR_selPanel.setLayout(gbc1);
		NCR_selPanel.setBorder( new TitledBorder("INPUT") );

		//		Lot Number List/Panel

		JPanel Lnum_StgPanel = new JPanel();
		Lnum_StgPanel.setLayout(new BorderLayout());

		JLabel Lnum_StgLabel = new JLabel (" Lot Number: ");
		Lnum_StgPanel.add(Lnum_StgLabel, BorderLayout.NORTH);

		LlistModel = new DefaultListModel();
		LnumJList = new JList(LlistModel);
		LnumJList.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
		//LnumJList.setSelectedIndex(0);
		LnumJList.addListSelectionListener(this);

		LtextScroller = new JScrollPane( LnumJList,
			ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS,
			ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);
		LtextScroller.setPreferredSize(new Dimension(80, 200));
		Lnum_StgPanel.add(LtextScroller);

		LnumField = new JTextField(14);
		LnumField.setEditable(false);
		Lnum_StgPanel.add(LnumField, BorderLayout.SOUTH);

		NCR_selPanel.add(Lnum_StgPanel, new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
				,GridBagConstraints.EAST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));

		//		Team Name, Dispositioner, Part Number List/Panel

		JPanel NCR_outtaPanel = new JPanel();
		GridBagLayout gbc2 = new GridBagLayout();
		NCR_outtaPanel.setLayout(gbc2);
		NCR_outtaPanel.setBorder( new TitledBorder("OUTPUT") );

		//		Team Name List/Panel

		JPanel TmMem_StgPanel = new JPanel();
		TmMem_StgPanel.setLayout(new BorderLayout());

		JLabel TmMem_StgLabel = new JLabel(" Team Members: ");
		TmMem_StgPanel.add(TmMem_StgLabel, BorderLayout.NORTH);

		TmMemJList = new JList(TmMem);
		TmMemJList.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
		TmMemJList.addListSelectionListener(this);

		TtextScroller = new JScrollPane( TmMemJList,
			ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS,
			ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);
		TtextScroller.setPreferredSize(new Dimension(80, 60));
		TmMem_StgPanel.add(TtextScroller);

		TmMemField = new JTextField(" ", 14);
		//TmMemField.setEditable(false);
		TmMem_StgPanel.add(TmMemField, BorderLayout.SOUTH);

		//		Dispositioner List/Panel

		JPanel Disp_StgPanel = new JPanel();
		Disp_StgPanel.setLayout(new BorderLayout());

		JLabel Disp_StgLabel = new JLabel(" Dispositioner: ");
		Disp_StgPanel.add(Disp_StgLabel, BorderLayout.NORTH);

		DispJList = new JList(TmMem);
		DispJList.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
		DispJList.addListSelectionListener(this);

		DtextScroller = new JScrollPane( DispJList,
			ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS,
			ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);
		DtextScroller.setPreferredSize(new Dimension(80, 60));
		Disp_StgPanel.add(DtextScroller);

		DispField = new JTextField(" ", 14);
		//DispField.setEditable(false);
		Disp_StgPanel.add(DispField, BorderLayout.SOUTH);

		//		Part Number Panel

		JPanel Pnum_StgPanel = new JPanel();
		Pnum_StgPanel.setLayout(new BorderLayout());

		JLabel Pnum_StgLabel = new JLabel(" Part Numbers: ");
		Pnum_StgPanel.add(Pnum_StgLabel, BorderLayout.NORTH);

		PnumField = new JTextField(12);
		PnumField.setEditable(false);
		Pnum_StgPanel.add(PnumField, BorderLayout.SOUTH);

		//		Job Number Panel

		JPanel Jnum_StgPanel = new JPanel();
		Jnum_StgPanel.setLayout(new BorderLayout());

		JLabel Jnum_StgLabel = new JLabel(" Job Number: ");
		Jnum_StgPanel.add(Jnum_StgLabel, BorderLayout.NORTH);

		JnumField = new JTextField(12);
		JnumField.setEditable(false);
		Jnum_StgPanel.add(JnumField, BorderLayout.SOUTH);

		//		CMM File Panel

		JPanel Cf_StgPanel = new JPanel();
		Cf_StgPanel.setLayout(new BorderLayout());

		JLabel Cf_StgLabel = new JLabel(" CMM File: ");
		Cf_StgPanel.add(Cf_StgLabel, BorderLayout.NORTH);

		CfField = new JTextField(12);
		CfField.setEditable(false);
		Cf_StgPanel.add(CfField, BorderLayout.SOUTH);

		//		NCR Number Panel

		JPanel Nnum_StgPanel = new JPanel();
		Nnum_StgPanel.setLayout(new BorderLayout());

		JLabel Nnum_StgLabel = new JLabel(" NCR Number: ");
		Nnum_StgPanel.add(Nnum_StgLabel, BorderLayout.NORTH);

		NnumField = new JTextField(NcrNoStg, 12);
		//NnumField.setEditable(false);
		Nnum_StgPanel.add(NnumField, BorderLayout.SOUTH);

		NCR_outtaPanel.add(TmMem_StgPanel, new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
				,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));
		NCR_outtaPanel.add(Disp_StgPanel, new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
				,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));
		NCR_outtaPanel.add(Pnum_StgPanel, new GridBagConstraints(1, 0, 1, 1, 0.0, 0.0
				,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));
		NCR_outtaPanel.add(Nnum_StgPanel, new GridBagConstraints(1, 1, 1, 1, 0.0, 0.0
				,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));
		NCR_outtaPanel.add(Jnum_StgPanel, new GridBagConstraints(2, 0, 1, 1, 0.0, 0.0
				,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));
		NCR_outtaPanel.add(Cf_StgPanel, new GridBagConstraints(2, 1, 1, 1, 0.0, 0.0
				,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));

		//		Table Panel
		JPanel tbl_StgPanel = new JPanel();
		tbl_StgPanel.setLayout(new BorderLayout());

		rows=9;cols=9;

		DefaultTableModel tableModel = new DefaultTableModel();
		table = new JTable(tableModel);

		JScrollPane scrollPane = new JScrollPane( table,
			ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS,
			ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);
		scrollPane.setPreferredSize(new Dimension(900, 163));

		JLabel tbl_StgLabel = new JLabel(" Index Table: ");
		tbl_StgPanel.add(tbl_StgLabel, BorderLayout.NORTH);
		tbl_StgPanel.add(scrollPane, BorderLayout.SOUTH);

		//		Status Field Panel
		JPanel stat_StgPanel = new JPanel();
		stat_StgPanel.setLayout(new BorderLayout());

		JLabel stat_StgLabel = new JLabel(" Status Output: ");
		stat_StgPanel.add(stat_StgLabel, BorderLayout.WEST);

		statField = new JTextField(40);
		statField.setEditable(false);
		stat_StgPanel.add(statField, BorderLayout.EAST);

		//		All Panel Grid

		NCR_allGrid.add(NCR_selPanel, new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
				,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));
		NCR_allGrid.add(NCR_outtaPanel, new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
				,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));
		NCR_allGrid.add(stat_StgPanel, new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
				,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));
		NCR_allGrid.add(tbl_StgPanel, new GridBagConstraints(0, 2, 1, 1, 0.0, 0.0
				,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(3, 3, 3, 3), 5, 0));

		return NCR_allGrid;
	}

	public void svr_cyc() {
		dirV = new Vector();

		if ( LnumJList.getModel().getSize() > 0 ) {
			LnumJList.setModel(LlistModel = new DefaultListModel());
			LnumField.setText("");
		}

		rtnLotVec();
		String[] serStgArr = new String[ dirV.size() ];
		dirV.copyInto( serStgArr );

		for (int t = 0; t < serStgArr.length; t++) {
			dirStgF = serStgArr[t].substring((serStgArr[t].lastIndexOf("\\")+1),serStgArr[t].length());
			LlistModel.addElement(dirStgF);
		}
	}

	public void rtnLotVec() {
		File aFile = new File(ncr_root_dir);
		if(!aFile.exists())
			System.out.println("Directory: " + ncr_root_dir + " does not exist");
		else if(!aFile.isDirectory())
			System.out.println( ncr_root_dir + " is not a directory" );
		else{
			File[] theFiles = aFile.listFiles();
			for(int x=0; x<theFiles.length; x++){
				if(theFiles[x].isDirectory()){ dirV.addElement( theFiles[x].toString() ); }
			}
		}
	}

	public void valueChanged(ListSelectionEvent e) {
		if (e.getValueIsAdjusting() == false) {
			if (LnumJList.getSelectedIndex() != -1) {
				entV = new Vector();
				indV = new Vector();
				ncrV = new Vector();
				rowsV = new Vector();
				colNmV = new Vector();

				LnumSnm = LnumJList.getSelectedValue().toString();
				LnumField.setText("");
				LnumField.setText(LnumSnm);
				LnumJList.clearSelection();

				ChkLot( LnumSnm );
				GetJbFeed();
				RtnCamStg();
				TblWR();
			}
			if (TmMemJList.getSelectedIndex() != -1) {
				TmMemSnm = TmMemJList.getSelectedValue().toString();
				TmMemField.setText("");
				TmMemField.setText(TmMemSnm);
				TmMemJList.clearSelection();
			}
			if (DispJList.getSelectedIndex() != -1) {
				DispSnm = DispJList.getSelectedValue().toString();
				DispField.setText("");
				DispField.setText(DispSnm);
				DispJList.clearSelection();
			}
		}
	}

	public void TblWR ( ) {
		finText = new String[ entV.size() ];
		entV.copyInto( finText );

		for (int t = 0; t < IcolNames.length; t++) {
			System.out.println("IcolNames[t]: " + IcolNames[t]);
			colNmV.add(IcolNames[t]);
		}

		rowsV = new Vector(finText.length);

		for (int u = 0; u < finText.length; u++) {
			String tmpVStg = finText[u];
			System.out.println("tmpVStg: " + tmpVStg);

			String[] rowArr = creTArray( tmpVStg, "," );

			Vector colData = new Vector(rowArr.length);

			for (int v = 0; v < rowArr.length; v++) {
				System.out.println("rowArr[v]: " + rowArr[v]);
				colData.add(rowArr[v]);
			}
			rowsV.add(colData);
		}

		( (DefaultTableModel) table.getModel()).setDataVector(rowsV, colNmV);

		for (int t = 0; t < IcolNames.length; t++) {
			TableColumn col = table.getColumnModel().getColumn(t);
			int width = 40;
			if ( t == 5 ) { width = 80; }
			if ( t == 6 ) { width = 500; }
			if ( t == 7 ) { width = 80; }
			col.setPreferredWidth(width);
		}

		PnumField.setText("");
		PnumField.setText(PartStg);

		JnumField.setText("");

		JobStg = LotStg;

		if ( JobStg.length() > 6 ) {
			JobStg = JobStg.substring(0,6);
		}
		String ntmpStg = JobStg.substring(0,1);
		if ( ntmpStg.compareTo("A") == 0 ) { }
		else { JobStg = "J"+JobStg; }

		System.out.println("JobStg: " + JobStg+"\n");

		JnumField.setText(JobStg);

		CfField.setText("");
		CfField.setText(LotStg);
	}

	public void data2mdb ( String WR ) {
		Vector columnNames = new Vector();
		Vector data = new Vector();

		String outMdbStg = "./tst_NCR.mdb";
		String FldStg = outMdbStg+" File Updated";

		if ( WR.compareTo( "WN" ) >= 0 ) {
			String dtStg	= getDateStg();
			outMdbStg	= LotStg + "_" + dtStg + ".mdb";
			FldStg = outMdbStg+" File Created";
			CopyMdb(outMdbStg);
		}

		statField.setText(FldStg);

		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
			database+= outMdbStg.trim() + ";DriverID=22;READONLY=true}";
			Connection connection = DriverManager.getConnection( database ,"","");
			Statement stmt = connection.createStatement();

			String TmMemStg = TmMemField.getText();
			String dispStg = DispField.getText();
			NcrNo = Integer.parseInt(NnumField.getText());

			stmt.executeUpdate("insert into NCR values ("+NcrNo+",'"+JobStg+"',0,1,0,'"+LotStg+"','"+PartStg+"',0,0,'"+TmMemStg+"',0,0,0,'"+dispStg+"',' ',' ')");

			DefaultTableModel dtm = (DefaultTableModel)table.getModel();
			Vector datad = dtm.getDataVector();

			for (int t = 0; t < datad.size(); t++) {
				Vector curRow = (Vector) datad.elementAt(t);

				String exeStg = "insert into Index values (";

				for (int x = 0; x < curRow.size(); x++) {
					if ( x < 5 ) {
						int tmpNo = Integer.parseInt(curRow.elementAt(x).toString());
						exeStg = exeStg+tmpNo+",";
					}
					else if ( x == (curRow.size()-1)) {
						exeStg = exeStg+"'"+curRow.elementAt(x)+"')";
					}
					else {
						exeStg = exeStg+"'"+curRow.elementAt(x)+"',";
					}
				}

				System.out.println("exeStg: " + exeStg);

				stmt.executeUpdate(exeStg);

				String strRow = curRow.toString();
				System.out.println("strRow: " + strRow);
			}

			stmt.close();
			connection.close();
		}
		catch(Exception e) {
			System.out.println(outMdbStg + " Error.");
			statField.setText(outMdbStg + " Error.");
			//exc2.printStackTrace();
			//System.out.println( e );
		}
	}

	public void ChkLot( String LnumIn ){
		String LotPath = ncr_root_dir + "\\" + LnumIn;

		File aFile = new File(LotPath);
		File[] theFiles = aFile.listFiles();

		for(int x=0; x<theFiles.length; x++){
			fileStg = theFiles[x].toString();

			int spPos = fileStg.lastIndexOf(".txt");
			if ( spPos >= 0 ) {
				int spPos0 = fileStg.lastIndexOf("\\");
				String dirStg0 = fileStg.substring(spPos0+1,spPos); // A2JA809808_D_A5-191

				String[] varArr = creTArray( dirStg0, "_" );
				PartStg = varArr[0] + "_" + varArr[1];
				LotStg = varArr[2];

				if ( varArr.length > 3 ) {
					PartStg = varArr[0] + "_" + varArr[1];
					LotStg = varArr[2] + "_" + varArr[3];
				}
			}
		}
	}

	public void GetJbFeed( ) {
		String cdPath = mrb_air_dir + "\\" + PartStg + "\\" + LotStg + "\\MRB.TXT";

		try {
			FileInputStream fis = new FileInputStream(cdPath);
			InputStreamReader isr = new InputStreamReader(fis);
			LineNumberReader reader = new LineNumberReader(isr);

			Vector lines = new Vector();
			String aLine = reader.readLine();

			while( aLine != null ) {
				lines.addElement( aLine );
				aLine = reader.readLine();
			}

			fulText = new String[ lines.size() ];
			lines.copyInto( fulText );

			reader.close();

			stgRead();
		}
		catch (IOException exc2) {
			fulText = new String[0];
			System.out.println(LotStg +"/MRB.TXT NOT Found.");
			statField.setText(LotStg +"/MRB.TXT NOT Found.");
			//exc2.printStackTrace();
		}
	}

	public void RtnCamStg() {
		String nCamFile = ncr_root_dir + "\\" + LotStg + "\\" + PartStg + "_" + LotStg + ".txt";
		File aFile = new File(nCamFile);

		if(!aFile.exists()) { System.out.println("File: " + nCamFile + " does not exist"); }
		else{
			lotFlRead( nCamFile );
			System.out.println( "Found: " + nCamFile);
		}
	}

	public void stgRead() {
		for (i = 2; i < fulText.length; i++) {
			NcrNo = Integer.parseInt(NnumField.getText());

			if ( fulText[i].indexOf(statStg) < 0 ) {
				String[] varArr = creTArray( fulText[i], " " );

				codeStg = "AIRFOIL";
				if ( varArr[2].compareTo("N_ANGLE") == 0 || varArr[2].compareTo("LEA") == 0
					|| varArr[2].compareTo("TEA") == 0 ) { codeStg = "ROOT"; }

				String tstVar = varArr[1];
				System.out.println("1)tstVar: "+tstVar);

				String finVarStg = "";
				int chCnt = 0;

				for ( int z = 0;  z < tstVar.length();  z++ ) {
					char ch = tstVar.charAt( z );
					if (  Character.isDigit(ch) ) {
						finVarStg=finVarStg+ch;
						chCnt++;
					}
				}

				if ( tstVar.length() == 0 ) { tstVar="0"; }
				else { tstVar=finVarStg; }

				System.out.println("2) tstVar: "+tstVar);

				String secfStg = varArr[0].substring(4,varArr[0].length());
				tfulStg = "0,"+NcrNo+","+tstVar+",0,1,"+codeStg+","+secfStg+"|"+varArr[2]+"|"+varArr[3]+", , ";

				int secPos2 = tstVar.indexOf("SECT");

				System.out.println("secPos2: "+secPos2);
				System.out.println("chCnt: "+chCnt);

				if ( secPos2 == -1 && chCnt > 0 ) {  entV.addElement( lfulStg ); }
				else { statField.setText("ERROR: SECT Found In: "+secfStg); break;}
			}
			else {
				i = fulText.length;
			}
		}
		//fulText = new String[0];
	}

	public void ctlRead( String xfilename ) {
		try {
			FileInputStream xfis = new FileInputStream(xfilename);
			InputStreamReader xisr = new InputStreamReader(xfis);
			LineNumberReader xlnr = new LineNumberReader(xisr);

			Vector xlines = new Vector();
			String xfLine = xlnr.readLine();

			while( xfLine != null ) {
				xlines.addElement( xfLine );
				xfLine = xlnr.readLine();
			}

			ctlText = new String[ xlines.size() ];
			xlines.copyInto( ctlText );
			xisr.close();
		}
		catch (IOException exc2) {
			ctlText = new String[0];
			System.out.println(xfilename +" Unreadable.");
			statField.setText(xfilename +" Unreadable.");
			//exc2.printStackTrace();
		}
	}

	public void lotFlRead( String filename ) {
		try {
			FileInputStream fis = new FileInputStream(filename);
			InputStreamReader isr = new InputStreamReader(fis);
			LineNumberReader lnr = new LineNumberReader(isr);

			Vector flines = new Vector();
			String afLine = lnr.readLine();

			while( afLine != null ) {
				flines.addElement( afLine );
				afLine = lnr.readLine();
			}

			lfText = new String[ flines.size() ];
			flines.copyInto( lfText );
			isr.close();

			QueryRead( lfText );
		}
		catch (IOException exc2) {
			lfText = new String[0];
			System.out.println(filename +" Unreadable.");
			statField.setText(filename +" Unreadable.");
			//exc2.printStackTrace();
		}
	}

	public void QueryRead( String[] fulText ) {
		for (i = 0; i < fulText.length; i++) {
			int cnPos, dimPos, dimPosIV, dimPosI, dimPosV, snPos = 0;
			String inStg="0";
			NcrNo = Integer.parseInt(NnumField.getText());

			cnPos = fulText[i].indexOf("C/N");
			snPos = fulText[i].indexOf("S/N");
			dimPos = fulText[i].indexOf("DIM");
			dimPosI = fulText[i].indexOf("DIM I");
			dimPosV = fulText[i].indexOf("DIM V_");
			dimPosIV = fulText[i].indexOf("DIM IV");

			if ( cnPos > -1 || snPos > -1 ) {
				int spPos = fulText[i].lastIndexOf(" ");
				cnStg1 = fulText[i].substring(spPos+1,fulText[i].length()); // Found C/N
			}
			else if ( dimPos > -1 ) {
				if ( dimPosV > -1  || dimPosIV > -1 ) {
					String[] varArrU = creTArray( fulText[i], "=" );
					inStg = varArrU[0].substring(6,varArrU[0].length());
				}
				else if ( dimPosI > -1 ) {
					String[] varArrU = creTArray( fulText[i], "_" );
					inStg = varArrU[0].substring(5,varArrU[0].length());
				}

				System.out.println("1) inStg: "+inStg);

				String tstVar2 = inStg;
				String finVarStg2 = "";
				int chCnt2 = 0;

				System.out.println("1) tstVar2: "+tstVar2);

				for ( int z = 0;  z < tstVar2.length();  z++ ) {
					char ch = tstVar2.charAt( z );
					if (  Character.isDigit(ch) ) {
						finVarStg2=finVarStg2+ch;
						chCnt2++;
					}
				}

				if ( inStg.length() == 0 ) { inStg="0"; }
				else { inStg=finVarStg2; }

				System.out.println("2) inStg: "+inStg);

				tmpStg = fulText[i+2];
				String[] varArr = creTArray( tmpStg, " " );
				float OutFl = Float.parseFloat(varArr[7]);
				String disStg = "REWORK";
				if ( OutFl < 0 ) { disStg = "SCRAP"; }

				lfulStg = "0,"+NcrNo+","+cnStg1+","+ inStg +",1,ROOT,NOM="+varArr[1]+"|+TOL="+varArr[2]+"|-TOL="+varArr[3]
					+"|MEAS="+varArr[4]+"|DEV="+varArr[7]+"|OUTTOL="+varArr[8]+","+disStg+", ";

				int secPos = inStg.indexOf("SECT");

				System.out.println("secPos: "+secPos);

				if ( secPos == -1 ) {  entV.addElement( lfulStg ); }
				else {
					statField.setText("ERROR: SECT Found In: "+cnStg1);
					//break;
				}
				i++;i++;
			}
		}
		//fulText = new String[0];
	}

	public void SaveSelected( String getDataNm ) {
		try {
			PrintStream expfl = new PrintStream(new FileOutputStream(getDataNm));
			for (j = 0; j < finText.length; j++) {
				if ( finText[j] != "" ) { expfl.println( finText[j] ); }
			}
			expfl.flush();
			expfl.close();
		} catch(java.io.IOException IOEx) {
			System.out.println("Cannot create " + getDataNm + " file.");
		}
	}

	public String[] sortStrings( String[] strings ) {
		for ( int i = 0; i < strings.length - 1; ++i ) {
			for ( int j = i + 1; j < strings.length; ++j ) {
				if ( strings[i].compareTo( strings[j] ) > 0 ) {
		 			String t = strings[i];
		 			strings[i] = strings[j];
		 			strings[j] = t;
				}
			}
		}
		return strings;
	}

	public String[] reverseStrings( String[] strings ) {
		String temp;
		int left = 0;
		int right = strings.length - 1;

		while (left < right) {
			temp = strings[left];
			strings[left] = strings[right];
			strings[right] = temp;
			right--;
			left++;
		}
		return strings;
	}

	public String[] creTArray(String toArray, String splitChar) {
		StringTokenizer token1 = new StringTokenizer(toArray,splitChar);
		int number1 = token1.countTokens();
		String[] newArray = new String[ number1 ];

		for (int i = 0; i < number1; i++) {
			String st = token1.nextToken();
			newArray[i] = st;
		}
		return newArray;
	}

	public void DelOut() {
		String s2 = null;
		try {
			String delStg = ("\"del *_out.*\"");
			Process p2 = Runtime.getRuntime().exec("cmd /C " + delStg );
			BufferedReader stdInput2 = new BufferedReader(new InputStreamReader(p2.getInputStream()));
			BufferedReader stdError2 = new BufferedReader(new InputStreamReader(p2.getErrorStream()));
			while ((s2 = stdInput2.readLine()) != null) { System.out.println( s2 ); }
		}
		catch (IOException e9) {
			System.out.println("Exception (DelOut): ");
			e9.printStackTrace();
			System.exit(-1);
		}
	}

	public void CopyMdb ( String finMdbNm ) {
		String s3 = null;
		try {
			String copyStg = ("\"copy NCR_Swap.mdb\"");
			Process p3 = Runtime.getRuntime().exec("cmd /C " + copyStg + " " + finMdbNm );
			BufferedReader stdInput3 = new BufferedReader(new InputStreamReader(p3.getInputStream()));
			BufferedReader stdError3 = new BufferedReader(new InputStreamReader(p3.getErrorStream()));
			while ((s3 = stdInput3.readLine()) != null) { System.out.println( s3 ); }
		}
		catch (IOException e8) {
			System.out.println("Exception (CopyMdb): " );
			e8.printStackTrace();
			System.exit(-1);
		}
	}

	public void RunCmdInt ( String getDataNm, String ed ) {
		String s = null;
		try {
			String notepad = ("\"%windir%\\notepad.exe\"");
			String wordpad = ("\"C:\\Program Files\\Windows NT\\Accessories\\wordpad.exe\"");
			String editor = notepad;
			if ( ed.compareTo( "wp" ) >= 0 ) { editor = wordpad; }
			Process p = Runtime.getRuntime().exec("cmd /C " + editor + " " + getDataNm );
			BufferedReader stdInput = new BufferedReader(new InputStreamReader(p.getInputStream()));
			BufferedReader stdError = new BufferedReader(new InputStreamReader(p.getErrorStream()));
			while ((s = stdInput.readLine()) != null) { System.out.println( s ); }
		}
		catch (IOException e) {
			System.out.println("Exception (RunCmdInt): " );
			e.printStackTrace();
			System.exit(-1);
		}
	}

	protected boolean alreadyInLList(String name) { return LlistModel.contains(name); }

	public String getDataNm() {
		OutFileNm = LotStg + "." + PartStg + "." + sName + "_out.txt";
		return OutFileNm;
	}

	public void sop2( String inStgN, String inStgV ) { System.out.println( inStgN + ": " +inStgV ); }
	public void sop4( String inStgN, String inStgV, String cStg, int lcntr ) {
		System.out.println( inStgN + ": " +inStgV + " & " + cStg + ": " + lcntr );
	}

	public String getDateStg() {
		SimpleDateFormat df = new SimpleDateFormat ("MMddyy_HHmmss", Locale.getDefault());
		java.util.Date tm = new java.util.Date();
		String dtStg = df.format(tm);

		return dtStg;
	}

    public void ExitSelected() {
		this.setVisible(false);
	}

	JList LnumJList, TmMemJList, DispJList;
	JTextField PnumField, LnumField, DispField, ProgField, ftp_Field, TmMemField;
	JTextField JnumField, CfField, NnumField, statField;
	JButton ButQry, ButRQry, RunBut, ResBut, OpenBut, GetBut, RInBut, RStatBut, RQuBut, UpBut;
	JButton WrBut;
	JTable table;

	JScrollPane PtextScroller, LtextScroller, DtextScroller, TtextScroller;
	ListSelectionModel listSelectionModel;
	DefaultListModel LlistModel;

	String Fstg, Pnum, Lnum, Snum, query, ftp_stg, ftp_Fstg, OutFileNm, uNm, pWd, path1, loc1;
	String TmpFileNm, getDataNm, dataOutStg, DOSubNm, DataOutSubStg, delStg;
	String LotStg, PartStg, paramStg, tfulStg, codeStg, sName, finFlStg, uStg, fileStg;
	String dirStg, dirStg0, dirStg1, dirStg2, dirStg3, dirStgF, lfulStg, tmpStg, cnStg1;
	String SubStg, LnumSnm, TmMemSnm, DispSnm, JnumSnm, CfSnm, JobStg, outMdbStg;
	String FfileStg, LotFile, jbStg = "/JB_FILES/", ed	= "np", NcrNoStg="9999";
	String statStg = "STATISTICAL PROCESS CONTROL";
	String uName = "Lawrence L Jett Jr";

	String[] TmMem = {"Adaris Cajete","Alba Ponce","Angel Vega","Babychan Idiculla",
		"Carlos Marin","Chris Baumann","Diego Ortiz","Edgar Gallo", "Emmanuel Pierre-Louis",
		"Esperanza Vargas","Frank Kistner","Harry Marks","Isidra Presbot","Jim Persinger",
		"Jorge Calvo","Joseph Schroeder","Ken Shutika","Lawrence Jett","Lennox Weir",
		"Luz Velasco","Martha Valencia","Michael Tram","Miguel Hornedo","Miguel Rodriguez",
		"Moises Prieto","Monica Perez","Mustafa Abdulali","Nancy Aleman","Noah Rivera",
		"Otto Gonzalez","Pat Markham","Randall Allen","Raul Arroyo","Riste Galevski",
		"Steve Gale","Virginia Libonati"};

	//String mrb_air_dir = "\\\\hei-fs1\\lpi$\\LPI CMM\\LPI CMM\\JB_FILES";
	//String ncr_root_dir = "\\\\hei-fs1\\lpi$\\LPI CMM\\Lot_Data";

	String mrb_air_dir = "D:\\Dev\\HTML\\datajett.com\\public_html\\HC\\JB_FILES";
	String ncr_root_dir = "D:\\Dev\\HTML\\datajett.com\\public_html\\HC\\NCR\\LOT_DATA";

	String[] fulText, finText, fulNcr, fulLdir, lfText, lotReadStg, ctlText;
	String[] IcolNames = {"ID","NCR Number","CN-Line","Index","Quantity","Defect Code",
		"Discrepancy","Disposition","RP Number"};

	String[] NcolNames = {"NCR Number","Job","Job Suffix","Job Sub Lot","Operation",
		"CMM File","Part Number","Date","Time","Team Member","Lot Quantity","Reject Quantity",
		"Box Scrap Quantity","Dispositioner","Customer MRB","CAR"};

	int trackWord, cntr, scntr, nctr, rcntr, h, i, j, k, mtPos = 0, cols, rows, NcrNo;
	long tBC1, tBC2, tBC3, tBC4, tBC5, tBC6, tAC1, tAC2, tAC3, tAC4, tAC5, tAC6;

	Vector dirV, dbV, entV, indV, ncrV, colNmV, rowsV;
}