<form enctype="multipart/form-data" method="POST">
CSV File: <input name="uploadedfile" type="file" /><br />
<input name="submit" type="submit" value="Upload File" />
</form>

<?php
if (!isset($_POST['submit'])) {exit;}
if (($handle = fopen($_FILES['uploadedfile']['tmp_name'], "r")) !== FALSE) {

  //ignore first 3 lines
  fgetcsv($handle);
  fgetcsv($handle);
  fgetcsv($handle);

  //get sales data
  $sales=array();
  while (($data = fgetcsv($handle)) !== FALSE) {

    //get useful parts
    $d['order_data']=$data[0];
    $d['title']=$data[1];
    $d['profit']=(substr($data[5],1)-substr($data[9],1));
    $d['order_status']=$data[11];
    $d['payment_status']=$data[12];
    $d['order_number']=$data[15];
    $d['material']=$data[16];

    //store values
    $sales[]=$d;
  }

  //compute stats
  $stats=array();
  foreach ($sales as $sale) {
    if ($sale['order_status']=='canceled') {

      //canceled order
      $stats['canceled_material_count'][$sale['material']]++;
      $stats['canceled_material_profit'][$sale['material']]+=$sale['profit'];
    } else {

      //orders that are good
      $stats['material_count'][$sale['material']]++;
      $stats['material_profit'][$sale['material']]+=$sale['profit'];
      if ($sale['payment_status']=='Settled') {
        $stats['paid']+=$sale['profit'];
      } else {
        $stats['unpaid']+=$sale['profit'];
      }
      $stats['model_count'][$sale['title']]++;
    }

  }


  //compute percents
  $sum=array_sum($stats['material_count']);
  foreach ($stats['material_count'] as $material=>$value) {
    $stats['material_count_percent'][$material]=100*$value/$sum;
  }
  $sum=array_sum($stats['material_profit']);
  foreach ($stats['material_profit'] as $material=>$value) {
    $stats['material_profit_percent'][$material]=100*$value/$sum;
  }
  $sum=array_sum($stats['canceled_material_count']);
  foreach ($stats['canceled_material_count'] as $material=>$value) {
    $stats['canceled_material_count_percent'][$material]=100*$value/$sum;
  }
  $sum=array_sum($stats['canceled_material_profit']);
  foreach ($stats['canceled_material_profit'] as $material=>$value) {
    $stats['canceled_material_profit_percent'][$material]=100*$value/$sum;
  }


  print_r($stats);

  //close file
  fclose($handle);
}

?>