sales-by-days-to-show-by-performance.php

<?php
date_default_timezone_set('UTC');

require_once( 'generic-report-parser.php' );

function summarise_sales_report( $filename, $first_show_dates ) {

	$_file = new ArtsPeople_Report( $filename );

	foreach( $_file->parsed_file as $_entry ) {
		$_type = $_entry[ 'Bought What' ];
		$_show = $_entry[ 'Show Name' ];
		$_perfomance = $_entry[ 'Ticket Date' ];
		$_purchased_on = $_entry[ 'Purchase Date' ];
		$_volume = $_entry[ 'Ticket Count' ];

		if ( isset( $first_show_dates[ $_show ] ) ) {
			$_elapsed_days_seconds = strtotime( $first_show_dates[ $_show ] ) - strtotime( date( 'Y-m-d', strtotime( $_purchased_on ) ) );

			$_days = $_elapsed_days_seconds / 60 / 60 / 24;
	
			if ( isset( $_summary[ $_show ][ $_perfomance ][ $_days ] ) ) {
				$_summary[ $_show ][ $_perfomance ][ $_days ] += $_volume;
			} else {
				$_summary[ $_show ][ $_perfomance ][ $_days ] = $_volume;
			}
		}
	}

	foreach( $_summary as $_show => &$_performances ) {
		foreach( $_performances as $_performance => &$_weeks ) {
			krsort( $_weeks );
		}
		uksort( $_performances, '_date_sort_helper' );
	}

	return $_summary;
}

function _date_sort_helper( $a, $b ) {
	$_date_a = strtotime( $a );
	$_date_b = strtotime( $b );	
	return $_date_a - $_date_b;
}

function graph_sales_for_show( $show_sales, $sales_per_char = 25 ) {

	foreach( $show_sales as $_show => $_performances ) {
		foreach( $_performances as $_performance => $_sales ) {
			echo "\n{$_show} - {$_performance}\n";
			echo "\nDays to first show\tSales so far\n";
			$_total = 0;
			foreach( $_sales as $_week => $_sold ) {
				$_total += $_sold;
				echo "{$_week}\t\t\t{$_total}\t" . str_repeat( '#', floor( $_total / $sales_per_char ) ) . "\n";
			}
			echo "Total\t{$_total}\n\n";
		}
	}
}

function csv_sales_for_show( $show_sales, $show ) {
	$_max_days = 0;
	$_performances = array();
	foreach( $show_sales[$show] as $_performance => $_sales ) {
		$_max_days = max( $_max_days, key( $_sales ) );
		$_performances[] = $_performance;
	}

	$_stdout = fopen("php://output", "w");
	fputcsv( $_stdout, array_merge( array( 'days' ), $_performances ) );
	foreach( range( $_max_days, -3 ) as $_day ) {
		$_row = array();
		$_row[] = $_day;
		foreach( $_performances as $_perfomance  ) {
			if ( isset( $show_sales[ $show ][$_perfomance][ $_day ] ) ) {
				$_row[] = $show_sales[ $show ][$_perfomance][ $_day ];
			} else {
				$_row[] = 0;
			}
		}
		fputcsv( $_stdout, $_row );
	}

}
/*
$__summary = summarise_sales_report(
	realpath( 'Sales_Listing-_Online_-_Box_Office.csv.alltime' ),
	array(
		'A Dark & Stormy Night' => '2015-03-26',
		'Its All Greek To Me' => '2016-03-31',
		'Step Right Up' => '2017-03-23',
		'In The Same Boat' => '2018-03-22',
	)
);
graph_sales_for_show( $__summary );
csv_sales_for_shows(
	$__summary,
	array(
		'A Dark & Stormy Night' => '2015-03-26',
		'Its All Greek To Me' => '2016-03-31',
		'Step Right Up' => '2017-03-23',
		'In The Same Boat' => '2018-03-22',
	)
);
*/
$__summary = summarise_sales_report(
	realpath( 'Sales_Listing__Online___Box_Office.csv' ),
	array(
		'In The Same Boat' => '2018-03-22',
	)
);
graph_sales_for_show( $__summary );
csv_sales_for_show( $__summary,	'In The Same Boat' );