/*
Marcella Wong
Project 1
*/

//package project1;

import java.io.*;
import java.util.*;
import java.text.DecimalFormat;

public class Orders
{
  public String fieldArray[] = new String[13];
  public String rows;
  public int index =0;
  public BufferedReader br;
  public String dayArray[] = new String[3];
  public String freightArray[] = new String[1];
  public String monthArray[] = new String[12];
  public double totalFreightMonth[] = {0,0,0,0,0,0,0,0,0,0,0,0};
  String totalFreight[] = new String[12];
  DecimalFormat df = new DecimalFormat("0.00");

  public Orders() throws IOException
  {
    String file = "Orders.csv";

    br = new BufferedReader(new FileReader(file));
    rows = br.readLine();
    rows = br.readLine();
  } //end Orders constructor

  public void sortFields() throws IOException
  {
    while (rows != null)
    {
        fieldArray=rows.split(",");
        dayArray=fieldArray[3].split("-");

        if (dayArray[2].compareTo("97") == 0)
        {
          for (int i=0; i<fieldArray.length; i++)
          {
            if(fieldArray[i].endsWith("\"")){
              fieldArray[i-1] = fieldArray[i-1] + (fieldArray[i]);
              fieldArray[i-1] = fieldArray[i-1].replace('\"', ' ');
              fieldArray[i-1] = fieldArray[i-1].trim();
            }
          }
          freightArray[0]=fieldArray[7];
          sumMonth();
        }
        rows = br.readLine();
    } // end WHILE loop
  } //end sortFields()

  public String month(int i)
  {
    monthArray[0]="Jan";
    monthArray[1]="Feb";
    monthArray[2]="Mar";
    monthArray[3]="Apr";
    monthArray[4]="May";
    monthArray[5]="Jun";
    monthArray[6]="Jul";
    monthArray[7]="Aug";
    monthArray[8]="Sep";
    monthArray[9]="Oct";
    monthArray[10]="Nov";
    monthArray[11]="Dec";

    return monthArray[i];
  } // end month()

  public void sumMonth()
  {
    for(int k=0; k<=11; k++)
    {
      if (month(k).compareTo(dayArray[1]) == 0)
      {
        totalFreightMonth[k] = totalFreightMonth[k] +  Double.parseDouble(freightArray[0]);
      } // end IF
    } // end FOR loop
  } // end sumMonth()

  public String getTotalFreight(int mo)
  {
    for (int j=0; j<=11; j++)
    {
      totalFreight[j]=df.format(totalFreightMonth[j]);
    }
    return totalFreight[mo];
  } // end getTotalFreight()

  public int MonMax()
  {
    double maxFreightAmt = 0;
    int maxMonthIndex=0;

    for (int i=0; i<=11; i++)
    {
      if (maxFreightAmt < totalFreightMonth[i])
      {
        maxFreightAmt=totalFreightMonth[i];
        maxMonthIndex=i;
      }// end IF
    } // end FOR

    return maxMonthIndex;
  } // end MonMax()

  public int MonMin()
  {
    double minFreightAmt=totalFreightMonth[0];
    int minMonthIndex=0;

    for (int i=1; i<=11; i++)
    {
      if (minFreightAmt > totalFreightMonth[i])
      {
        minFreightAmt=totalFreightMonth[i];
        minMonthIndex= i;
      } // end IF
    } // end FOR loop
    return minMonthIndex;
  } // end MonMin()

  public String GrandTotal()
  {
    String grandTotal;
    double total=0;
    for (int i=0; i<=11; i++)
    {
      total = total + totalFreightMonth[i];
    }
    grandTotal=df.format(total);

    return grandTotal;
  } // end GrandTotal()
} //end class Orders