//
//    usage:java CSVTest <csv file name>
//    example: java CSVTest list.txt
//

import java.io.*;
import java.util.*;
import java.util.regex.*;

public class CSVTest {
   private HashMap customerSpent;
   private HashMap productSold;
   private BufferedReader in;
   private Pattern delimiter;

   public CSVTest(String salesList) throws IOException{
      customerSpent = new HashMap();
      productSold   = new HashMap();
      delimiter = Pattern.compile(",");

      in = new BufferedReader(
             new FileReader(salesList));
          
    }

    public String getOneRecord() throws IOException{
        return in.readLine();
    }

    public void produceOneRecord(String record){
        String customerName;
        String productName;
        double price;
        int quantity;
        double spent ;

        String [] items = delimiter.split(record);
        customerName = items[1].trim();
        productName =  items[5].trim();
        price = Double.parseDouble(items[3]);
        quantity = Integer.parseInt(items[4]);
        spent = price * quantity;

        Object o = customerSpent.get(customerName);

        //new customer
        if(o == null){  
            customerSpent.put(customerName, new Double(spent));
        }
        //customer already exists
        else{ 
            double oldSpent = ((Double)o).doubleValue();
            customerSpent.put(customerName, new Double(oldSpent + spent));
        }

        o = productSold.get(productName);
        //new product
        if(o == null){
            productSold.put(productName, new Integer(quantity));
        }
        //product already exists
        else{
            int oldQuantity = ((Integer)o).intValue();
            productSold.put(productName, new Integer(oldQuantity + quantity));
        }
    }

    public void printResult(){
        Set customerSet = customerSpent.keySet();
        Set productSet = productSold.keySet();

        for(Iterator itr = customerSet.iterator(); itr.hasNext(); ){
            String customer= (String)itr.next();
            System.out.println( customer + " spent " + 
                                  customerSpent.get(customer));
        }

        System.out.println("\n-------\n");

        for(Iterator itr = productSet.iterator(); itr.hasNext(); ){
            String product= (String)itr.next();
            System.out.println( productSold.get(product) + " " + product 
                                + " were sold " );
        }
    }


    public static void main(String [] args) throws IOException{
        if(args.length == 0){
            System.out.println("usage: java CSVTest <csv file name>");
            return;
        }

        String record;
 
        CSVTest ct = new CSVTest(args[0]);
        while((record = ct.getOneRecord()) != null){
            ct.produceOneRecord(record);
        }
        
        ct.printResult(); 
    }
 
}