VisualDataCode_VisualFrame

import java.awt.Color;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;


public class VisualFrame extends JFrame implements ActionListener{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JButton backb;
	
	public VisualFrame(JFrame a, int teamnum) throws IOException{
		JFrame frame = a; // Creates get global frame variable, and sets it to a local variable
		JLabel fieldpic = new JLabel(); // Creates a Label variable
		ImageIcon backpic = new ImageIcon("field2020.png"); //Creates a ImageIcon variable

		//Actual Data From Execel Sheet
		ArrayList<Integer> rowToGet = new ArrayList<Integer>(); // Stores the rows where the team's info is.
		int wheelComplete = 0;// Stores the a value which says if they did color wheel(0 = No Color Wheel, 1 = Color Wheel Spun, 2 = Color Wheel Spun to Color)
		int totAUTOscore = 0; //Counts how many points scored during AUTONOMOUS
		int totTELOPscore = 0; //Counts how many points scored during TELEOP
		int[] zoneAUTOscore = new int[6];
		int[] zoneTELOPscore = new int[6];
		int numgames = 0; // Counts number of games played by the team number
		
		backb = new JButton();
		backb.setBounds(1115,536,75,25);
		backb.addActionListener(this);
		frame.add(backb);
		
		Color customColor = new Color(0,162,232); //Creates a background color
		
		
		frame.setTitle("WVR Scouting App: Visual Data"); // Titles the Window
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); // When the X is clicked, the window closes
		frame.setResizable(false); // Keeps a consistent window size.
		frame.setSize(1200,600);  // In pixels, the size of the widow. (width x height)
		frame.getContentPane().setBackground(customColor);
		
		fieldpic.setIcon(backpic); //Puts the Label as the ImageIcon
		fieldpic.setText("2020 Field Diagram");
		fieldpic.setFont(new Font("TimesRoman", Font.BOLD, 20));
		fieldpic.setForeground(Color.white);
		fieldpic.setHorizontalTextPosition(0);
		fieldpic.setVerticalTextPosition(1);
		fieldpic.setHorizontalAlignment(0); // Centers ImageIcon
		fieldpic.setVerticalAlignment(0); // Centers ImageIcon
		frame.add(fieldpic);
		
		
		
	
		String file = "3538_2020misou.xlsx";
		OPCPackage fs = null;
		try {
			fs = OPCPackage.open(new File(file));
		} catch (InvalidFormatException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	    XSSFWorkbook wb = new XSSFWorkbook(file);
	    XSSFSheet sheet = wb.getSheetAt(0);
	    XSSFRow row;
	    XSSFCell cell;

	    int rows; // No of rows
	    rows = sheet.getPhysicalNumberOfRows();

	    int cols = 0; // No of columns
	    int tmp = 0;

	    // This trick ensures that we get the data properly even if it doesn't start from first few rows
	    for(int i = 0; i < 10 || i < rows; i++) {
	        row = sheet.getRow(i);
	        if(row != null) {
	            tmp = sheet.getRow(i).getPhysicalNumberOfCells();
	            if(tmp > cols) cols = tmp;
	        }
	    }
	    for(int r = 0; r < rows; r++) {
	        row = sheet.getRow(r);
	        if(row != null) {
	            for(int c = 0; c < cols; c++) {
	                cell = row.getCell((short)c);
	                if(cell != null) {
	                	if(CellType.NUMERIC == cell.getCellType()) {
	                		if(c == 1 && cell.getNumericCellValue() == teamnum) {
	                			numgames++;
	                			rowToGet.add(r);	
	                		}
	                	}
	                }
	            }
	        }
	    }
	    
	    System.out.println("Games Played: " + numgames);
	    for(int i = 0; i< rowToGet.size(); i++) {
	    	System.out.println("Team# in Row: " + (rowToGet.get(i)+1)); //This shows the row + 1 since the index of rows starts with 0
	    }
	    
	    /**
	     * 
	     */
	    for(int r = 0; r < rowToGet.size(); r++) {
	        row = sheet.getRow(rowToGet.get(r));
	        if(row != null) {
	            for(int c = 0; c < cols; c++) {
	                cell = row.getCell((short)c);
	                if(cell != null) {
	                	if(CellType.NUMERIC == cell.getCellType()) {
	                		if(c >= 3 && c <= 8) {
	                			totAUTOscore += cell.getNumericCellValue();
	                			if(cell.getNumericCellValue() != 0) {
	                				zoneAUTOscore[c-3] += (int) cell.getNumericCellValue(); 
	                			}
	                		}
	                		else if(c>=11 && c<=16) {
	                			totTELOPscore += cell.getNumericCellValue();
	                			if(cell.getNumericCellValue() != 0) {
	                				zoneTELOPscore[c-11] += (int) cell.getNumericCellValue(); 
	                			}
	                		}
	                		else if(c == 17) {
	                			wheelComplete = 1;
	                		}
	                		else if(c == 18) {
	                			wheelComplete = 2;
	                		}
	                	}
	                }
	            }
	        }
	    }
	    System.out.println("Total Autonomous Points: " + totAUTOscore);
	    System.out.println("Total Teloperational Points: " + totTELOPscore);
	    for(int i=0; i<=5;i++){
	    	if(i != 1 && i != 2) {
	    		System.out.println("Teleoperation Points at Zone " + (i+1) + ": " + (zoneTELOPscore[i]));
	    		System.out.println("Autonomous Points at Zone " + (i+1) + ": " + (zoneAUTOscore[i]));
	    	}
	    	else if(i == 1) {
	    		System.out.println("Teleoperation Points at Zone 2/3: " + (zoneTELOPscore[i] + zoneTELOPscore[i+1]));
	    		System.out.println("Autonomous Points at Zone 2/3: " + (zoneAUTOscore[i] + zoneAUTOscore[i+1]));
	    	}
	    }
	    if(wheelComplete == 0) {
	    	System.out.println("Team#: "+ teamnum + " did not turn the wheel.");
	    }
	    else if(wheelComplete == 1) {
	    	System.out.println("Team#: "+ teamnum + " spun the wheel a certain number of times.");
	    }
	    else if(wheelComplete == 2) {
	    	System.out.println("Team#: "+ teamnum + " spun the wheel to a certain color.");
	    }
	    else {
	    	System.out.println("Error: wheelComplete Logic");
	    }
	    
		frame.setVisible(true); // Makes the frame visible with all of it's stuff
	}

	@Override
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==backb) {
			System.out.print("LOLL");
		}
		
	}

}