/**
* Returns formatted data
*
* @access public
* @param bool $admin
* @return array
*/
public function data($admin = false)
{
$league_ids = sp_get_the_term_ids($this->ID, 'sp_league');
$season_ids = sp_get_the_term_ids($this->ID, 'sp_season');
$table_stats = (array) get_post_meta($this->ID, 'sp_teams', true);
$usecolumns = get_post_meta($this->ID, 'sp_columns', true);
$adjustments = get_post_meta($this->ID, 'sp_adjustments', true);
$select = get_post_meta($this->ID, 'sp_select', true);
// Get labels from result variables
$result_labels = (array) sp_get_var_labels('sp_result');
// Get labels from outcome variables
$outcome_labels = (array) sp_get_var_labels('sp_outcome');
// Get teams automatically if set to auto
if ('auto' == $select) {
$team_ids = array();
$args = array('post_type' => 'sp_team', 'numberposts' => -1, 'posts_per_page' => -1, 'order' => 'ASC', 'tax_query' => array('relation' => 'AND'));
if ($league_ids) {
$args['tax_query'][] = array('taxonomy' => 'sp_league', 'field' => 'id', 'terms' => $league_ids);
}
if ($season_ids) {
$args['tax_query'][] = array('taxonomy' => 'sp_season', 'field' => 'id', 'terms' => $season_ids);
}
$teams = get_posts($args);
if ($teams && is_array($teams)) {
foreach ($teams as $team) {
$team_ids[] = $team->ID;
}
}
} else {
$team_ids = (array) get_post_meta($this->ID, 'sp_team', false);
}
// Get all leagues populated with stats where available
$tempdata = sp_array_combine($team_ids, $table_stats);
// Create entry for each team in totals
$totals = array();
$placeholders = array();
// Initialize incremental counter
$this->pos = 0;
$this->counter = 0;
// Initialize team compare
$this->compare = null;
// Initialize streaks counter
$streaks = array();
// Initialize last counters
$last5s = array();
$last10s = array();
// Initialize record counters
$homerecords = array();
$awayrecords = array();
foreach ($team_ids as $team_id) {
if (!$team_id) {
continue;
}
// Initialize team streaks counter
$streaks[$team_id] = array('name' => '', 'count' => 0, 'fire' => 1);
// Initialize team last counters
$last5s[$team_id] = array();
$last10s[$team_id] = array();
// Initialize team record counters
$homerecords[$team_id] = array();
$awayrecords[$team_id] = array();
// Add outcome types to team last and record counters
foreach ($outcome_labels as $key => $value) {
$last5s[$team_id][$key] = 0;
$last10s[$team_id][$key] = 0;
$homerecords[$team_id][$key] = 0;
$awayrecords[$team_id][$key] = 0;
}
// Initialize team totals
$totals[$team_id] = array('eventsplayed' => 0, 'eventsplayed_home' => 0, 'eventsplayed_away' => 0, 'eventsplayed_venue' => 0, 'eventminutes' => 0, 'eventminutes_home' => 0, 'eventminutes_away' => 0, 'eventminutes_venue' => 0, 'streak' => 0, 'streak_home' => 0, 'streak_away' => 0, 'streak_venue' => 0);
foreach ($result_labels as $key => $value) {
$totals[$team_id][$key . 'for'] = 0;
$totals[$team_id][$key . 'for_home'] = 0;
$totals[$team_id][$key . 'for_away'] = 0;
$totals[$team_id][$key . 'for_venue'] = 0;
$totals[$team_id][$key . 'against'] = 0;
$totals[$team_id][$key . 'against_home'] = 0;
$totals[$team_id][$key . 'against_away'] = 0;
$totals[$team_id][$key . 'against_venue'] = 0;
}
foreach ($outcome_labels as $key => $value) {
$totals[$team_id][$key] = 0;
$totals[$team_id][$key . '_home'] = 0;
$totals[$team_id][$key . '_away'] = 0;
$totals[$team_id][$key . '_venue'] = 0;
}
// Get static stats
$static = get_post_meta($team_id, 'sp_columns', true);
if ('yes' == get_option('sportspress_team_column_editing', 'no') && $league_ids && $season_ids) {
// Add static stats to placeholders
foreach ($league_ids as $league_id) {
foreach ($season_ids as $season_id) {
$placeholders[$team_id] = (array) sp_array_value(sp_array_value($static, $league_id, array()), $season_id, array());
}
}
}
}
$args = array('post_type' => 'sp_event', 'post_status' => array('publish', 'future'), 'numberposts' => -1, 'posts_per_page' => -1, 'orderby' => 'post_date', 'order' => 'DESC', 'meta_query' => array(array('key' => 'sp_format', 'value' => apply_filters('sportspress_competitive_event_formats', array('league')), 'compare' => 'IN')), 'tax_query' => array('relation' => 'AND'));
if ($league_ids) {
$args['tax_query'][] = array('taxonomy' => 'sp_league', 'field' => 'id', 'terms' => $league_ids);
}
if ($season_ids) {
$args['tax_query'][] = array('taxonomy' => 'sp_season', 'field' => 'id', 'terms' => $season_ids);
}
$args = apply_filters('sportspress_table_data_event_args', $args);
$events = get_posts($args);
$e = 0;
// Event loop
foreach ($events as $event) {
$results = (array) get_post_meta($event->ID, 'sp_results', true);
$minutes = get_post_meta($event->ID, 'sp_minutes', true);
if ($minutes === '') {
$minutes = get_option('sportspress_event_minutes', 90);
}
$i = 0;
foreach ($results as $team_id => $team_result) {
if (!in_array($team_id, $team_ids)) {
continue;
}
if ($team_result) {
foreach ($team_result as $key => $value) {
if ($key == 'outcome') {
if (!is_array($value)) {
$value = array($value);
}
foreach ($value as $outcome) {
// Increment events played and outcome count
if (array_key_exists($team_id, $totals) && is_array($totals[$team_id]) && array_key_exists($outcome, $totals[$team_id])) {
$totals[$team_id]['eventsplayed']++;
$totals[$team_id]['eventminutes'] += $minutes;
$totals[$team_id][$outcome]++;
// Add to home or away stats
if (0 === $i) {
$totals[$team_id]['eventsplayed_home']++;
$totals[$team_id]['eventminutes_home'] += $minutes;
$totals[$team_id][$outcome . '_home']++;
} else {
$totals[$team_id]['eventsplayed_away']++;
$totals[$team_id]['eventminutes_away'] += $minutes;
$totals[$team_id][$outcome . '_away']++;
}
// Add to venue stats
if (sp_is_home_venue($team_id, $event->ID)) {
$totals[$team_id]['eventsplayed_venue']++;
$totals[$team_id]['eventminutes_venue'] += $minutes;
$totals[$team_id][$outcome . '_venue']++;
}
}
if ($outcome && $outcome != '-1') {
// Add to streak counter
if ($streaks[$team_id]['fire'] && ($streaks[$team_id]['name'] == '' || $streaks[$team_id]['name'] == $outcome)) {
$streaks[$team_id]['name'] = $outcome;
$streaks[$team_id]['count']++;
} else {
$streaks[$team_id]['fire'] = 0;
}
// Add to last 5 counter if sum is less than 5
if (array_key_exists($team_id, $last5s) && array_key_exists($outcome, $last5s[$team_id]) && array_sum($last5s[$team_id]) < 5) {
$last5s[$team_id][$outcome]++;
}
// Add to last 10 counter if sum is less than 10
if (array_key_exists($team_id, $last10s) && array_key_exists($outcome, $last10s[$team_id]) && array_sum($last10s[$team_id]) < 10) {
$last10s[$team_id][$outcome]++;
}
// Add to home or away record
if (0 === $i) {
if (array_key_exists($team_id, $homerecords) && array_key_exists($outcome, $homerecords[$team_id])) {
$homerecords[$team_id][$outcome]++;
}
} else {
if (array_key_exists($team_id, $awayrecords) && array_key_exists($outcome, $awayrecords[$team_id])) {
$awayrecords[$team_id][$outcome]++;
}
}
}
}
} else {
if (array_key_exists($team_id, $totals) && is_array($totals[$team_id]) && array_key_exists($key . 'for', $totals[$team_id])) {
$totals[$team_id][$key . 'for'] += $value;
$totals[$team_id][$key . 'for' . ($e + 1)] = $value;
// Add to home or away stats
if (0 === $i) {
$totals[$team_id][$key . 'for_home'] += $value;
} else {
$totals[$team_id][$key . 'for_away'] += $value;
}
// Add to venue stats
if (sp_is_home_venue($team_id, $event->ID)) {
$totals[$team_id][$key . 'for_venue'] += $value;
}
foreach ($results as $other_team_id => $other_result) {
if ($other_team_id != $team_id && array_key_exists($key . 'against', $totals[$team_id])) {
$totals[$team_id][$key . 'against'] += sp_array_value($other_result, $key, 0);
$totals[$team_id][$key . 'against' . ($e + 1)] = sp_array_value($other_result, $key, 0);
// Add to home or away stats
if (0 === $i) {
$totals[$team_id][$key . 'against_home'] += sp_array_value($other_result, $key, 0);
} else {
$totals[$team_id][$key . 'against_away'] += sp_array_value($other_result, $key, 0);
}
// Add to venue stats
if (sp_is_home_venue($team_id, $event->ID)) {
$totals[$team_id][$key . 'against_venue'] += sp_array_value($other_result, $key, 0);
}
}
}
}
}
}
}
$i++;
}
$e++;
}
foreach ($streaks as $team_id => $streak) {
// Compile streaks counter and add to totals
if ($streak['name']) {
$args = array('name' => $streak['name'], 'post_type' => 'sp_outcome', 'post_status' => 'publish', 'posts_per_page' => 1, 'orderby' => 'menu_order', 'order' => 'ASC');
$outcomes = get_posts($args);
if ($outcomes) {
$outcome = reset($outcomes);
$abbreviation = get_post_meta($outcome->ID, 'sp_abbreviation', true);
if (!$abbreviation) {
$abbreviation = substr($outcome->post_title, 0, 1);
}
$totals[$team_id]['streak'] = $abbreviation . $streak['count'];
} else {
$totals[$team_id]['streak'] = null;
}
} else {
$totals[$team_id]['streak'] = null;
}
}
foreach ($last5s as $team_id => $last5) {
// Add last 5 to totals
$totals[$team_id]['last5'] = $last5;
}
foreach ($last10s as $team_id => $last10) {
// Add last 10 to totals
$totals[$team_id]['last10'] = $last10;
}
foreach ($homerecords as $team_id => $homerecord) {
// Add home record to totals
$totals[$team_id]['homerecord'] = $homerecord;
}
foreach ($awayrecords as $team_id => $awayrecord) {
// Add away record to totals
$totals[$team_id]['awayrecord'] = $awayrecord;
}
$args = array('post_type' => 'sp_column', 'numberposts' => -1, 'posts_per_page' => -1, 'orderby' => 'menu_order', 'order' => 'ASC');
$stats = get_posts($args);
$columns = array();
$this->priorities = array();
foreach ($stats as $stat) {
// Get post meta
$meta = get_post_meta($stat->ID);
// Add equation to object
$stat->equation = sp_array_value(sp_array_value($meta, 'sp_equation', array()), 0, null);
$stat->precision = sp_array_value(sp_array_value($meta, 'sp_precision', array()), 0, 0);
// Add column name to columns
$columns[$stat->post_name] = $stat->post_title;
// Add order to priorities if priority is set and does not exist in array already
$priority = sp_array_value(sp_array_value($meta, 'sp_priority', array()), 0, 0);
if ($priority && !array_key_exists($priority, $this->priorities)) {
$this->priorities[$priority] = array('column' => $stat->post_name, 'order' => sp_array_value(sp_array_value($meta, 'sp_order', array()), 0, 'DESC'));
}
}
// Sort priorities in descending order
ksort($this->priorities);
// Initialize games back column variable
$gb_column = null;
// Fill in empty placeholder values for each team
foreach ($team_ids as $team_id) {
if (!$team_id) {
continue;
}
foreach ($stats as $stat) {
if (sp_array_value(sp_array_value($placeholders, $team_id, array()), $stat->post_name, '') == '') {
if ($stat->equation == null) {
$placeholder = sp_array_value(sp_array_value($adjustments, $team_id, array()), $stat->post_name, null);
if ($placeholder == null) {
$placeholder = '-';
}
} else {
// Solve
$placeholder = sp_solve($stat->equation, sp_array_value($totals, $team_id, array()), $stat->precision);
if ('$gamesback' == $stat->equation) {
$gb_column = $stat->post_name;
}
if (!in_array($stat->equation, array('$gamesback', '$streak', '$last5', '$last10', '$homerecord', '$awayrecord'))) {
// Adjustments
$adjustment = sp_array_value($adjustments, $team_id, array());
if ($adjustment != 0) {
$placeholder += sp_array_value($adjustment, $stat->post_name, 0);
$placeholder = number_format($placeholder, $stat->precision, '.', '');
}
}
}
$placeholders[$team_id][$stat->post_name] = $placeholder;
}
}
}
// Find win and loss variables for games back
$w = $l = null;
if ($gb_column) {
$args = array('post_type' => 'sp_outcome', 'numberposts' => 1, 'posts_per_page' => 1, 'meta_query' => array(array('key' => 'sp_condition', 'value' => '>')));
$outcomes = get_posts($args);
if ($outcomes) {
$outcome = reset($outcomes);
if (is_array($stats)) {
foreach ($stats as $stat) {
if ('$' . $outcome->post_name == $stat->equation) {
$w = $stat->post_name;
}
}
}
}
// Calculate games back
$args = array('post_type' => 'sp_outcome', 'numberposts' => 1, 'posts_per_page' => 1, 'meta_query' => array(array('key' => 'sp_condition', 'value' => '<')));
$outcomes = get_posts($args);
if ($outcomes) {
$outcome = reset($outcomes);
if (is_array($stats)) {
foreach ($stats as $stat) {
if ('$' . $outcome->post_name == $stat->equation) {
$l = $stat->post_name;
}
}
}
}
}
// Merge the data and placeholders arrays
$merged = array();
foreach ($placeholders as $team_id => $team_data) {
// Add team name to row
$merged[$team_id] = array();
$team_data['name'] = get_the_title($team_id);
foreach ($team_data as $key => $value) {
// Use static data if key exists and value is not empty, else use placeholder
if (array_key_exists($team_id, $tempdata) && array_key_exists($key, $tempdata[$team_id]) && $tempdata[$team_id][$key] != '') {
$merged[$team_id][$key] = $tempdata[$team_id][$key];
} else {
$merged[$team_id][$key] = $value;
}
}
}
uasort($merged, array($this, 'sort'));
// Calculate position of teams for ties
foreach ($merged as $team_id => $team_columns) {
$merged[$team_id]['pos'] = $this->calculate_pos($team_columns);
}
// Rearrange data array to reflect values
$data = array();
foreach ($merged as $key => $value) {
$data[$key] = $tempdata[$key];
}
if ($admin) {
$this->add_gb($placeholders, $w, $l, $gb_column);
return array($columns, $usecolumns, $data, $placeholders, $merged);
} else {
$this->add_gb($merged, $w, $l, $gb_column);
if (!is_array($usecolumns)) {
$usecolumns = array();
}
$labels = array_merge(array('pos' => __('Pos', 'sportspress'), 'name' => __('Team', 'sportspress')), $columns);
$merged[0] = $labels;
return $merged;
}
}
/**
* Returns formatted data
*
* @access public
* @param bool $admin
* @return array
*/
public function data($admin = false)
{
$league_ids = sp_get_the_term_ids($this->ID, 'sp_league');
$season_ids = sp_get_the_term_ids($this->ID, 'sp_season');
$position_ids = sp_get_the_term_ids($this->ID, 'sp_position');
$team = get_post_meta($this->ID, 'sp_team', true);
$list_stats = (array) get_post_meta($this->ID, 'sp_players', true);
$adjustments = get_post_meta($this->ID, 'sp_adjustments', true);
$orderby = get_post_meta($this->ID, 'sp_orderby', true);
$order = get_post_meta($this->ID, 'sp_order', true);
$select = get_post_meta($this->ID, 'sp_select', true);
// Get labels from performance variables
$performance_labels = (array) sp_get_var_labels('sp_performance');
// Get labels from outcome variables
$outcome_labels = (array) sp_get_var_labels('sp_outcome');
// Get labels from result variables
$result_labels = (array) sp_get_var_labels('sp_result');
// Get players automatically if set to auto
if ('auto' == $select) {
$player_ids = array();
$args = array('post_type' => 'sp_player', 'numberposts' => -1, 'posts_per_page' => -1, 'meta_key' => 'sp_number', 'orderby' => 'meta_value_num', 'order' => 'ASC', 'tax_query' => array('relation' => 'AND'));
if ($league_ids) {
$args['tax_query'][] = array('taxonomy' => 'sp_league', 'field' => 'id', 'terms' => $league_ids);
}
if ($season_ids) {
$args['tax_query'][] = array('taxonomy' => 'sp_season', 'field' => 'id', 'terms' => $season_ids);
}
if ($position_ids) {
$args['tax_query'][] = array('taxonomy' => 'sp_position', 'field' => 'id', 'terms' => $position_ids);
}
if ($team && apply_filters('sportspress_has_teams', true)) {
$args['meta_query'] = array(array('key' => 'sp_team', 'value' => $team));
}
$players = get_posts($args);
if ($players && is_array($players)) {
foreach ($players as $player) {
$player_ids[] = $player->ID;
}
}
} else {
$player_ids = (array) get_post_meta($this->ID, 'sp_player', false);
}
// Get all leagues populated with stats where available
$tempdata = sp_array_combine($player_ids, $list_stats);
// Create entry for each player in totals
$totals = array();
$placeholders = array();
// Initialize columns
$columns = array();
// Initialize streaks counter
$streaks = array();
// Initialize last counters
$last5s = array();
$last10s = array();
foreach ($player_ids as $player_id) {
if (!$player_id) {
continue;
}
// Initialize player streaks counter
$streaks[$player_id] = array('name' => '', 'count' => 0, 'fire' => 1);
// Initialize player last counters
$last5s[$player_id] = array();
$last10s[$player_id] = array();
// Add outcome types to player last counters
foreach ($outcome_labels as $key => $value) {
$last5s[$player_id][$key] = 0;
$last10s[$player_id][$key] = 0;
}
// Initialize player totals
$totals[$player_id] = array('eventsattended' => 0, 'eventsplayed' => 0, 'eventsstarted' => 0, 'eventssubbed' => 0, 'eventminutes' => 0, 'streak' => 0);
foreach ($performance_labels as $key => $value) {
$totals[$player_id][$key] = 0;
}
foreach ($outcome_labels as $key => $value) {
$totals[$player_id][$key] = 0;
}
foreach ($result_labels as $key => $value) {
$totals[$player_id][$key . 'for'] = $totals[$player_id][$key . 'against'] = 0;
}
// Get metrics
$metrics = (array) get_post_meta($player_id, 'sp_metrics', true);
foreach ($metrics as $key => $value) {
$adjustment = sp_array_value(sp_array_value($adjustments, $player_id, array()), $key, null);
if ($adjustment != null) {
$metrics[$key] += $adjustment;
}
}
// Get static stats
$static = get_post_meta($player_id, 'sp_statistics', true);
// Get league and season arrays for static stats
$static_league_ids = empty($league_ids) ? array(0) : $league_ids;
$static_season_ids = empty($season_ids) ? array(0) : $season_ids;
// Add static stats to placeholders
if ($static_league_ids && $static_season_ids) {
foreach ($static_league_ids as $league_id) {
foreach ($static_season_ids as $season_id) {
$player_league_season_stats = sp_array_value(sp_array_value($static, $league_id, array()), $season_id, array());
if (is_array($player_league_season_stats)) {
foreach ($player_league_season_stats as $key => $value) {
$current_value = sp_array_value(sp_array_value($placeholders, $player_id, array()), $key, 0);
$placeholders[$player_id][$key] = $current_value + $value;
}
}
}
}
} else {
$placeholders[$player_id] = sp_array_value(sp_array_value($static, 0, array()), 0, array());
}
// Add metrics to placeholders
$placeholders[$player_id] = array_merge($metrics, sp_array_value($placeholders, $player_id, array()));
}
$args = array('post_type' => 'sp_event', 'numberposts' => -1, 'posts_per_page' => -1, 'order' => 'DESC', 'meta_query' => array(array('key' => 'sp_format', 'value' => apply_filters('sportspress_competitive_event_formats', array('league')), 'compare' => 'IN')), 'tax_query' => array('relation' => 'AND'));
if ($league_ids) {
$args['tax_query'][] = array('taxonomy' => 'sp_league', 'field' => 'id', 'terms' => $league_ids);
}
if ($season_ids) {
$args['tax_query'][] = array('taxonomy' => 'sp_season', 'field' => 'id', 'terms' => $season_ids);
}
$args = apply_filters('sportspress_list_data_event_args', $args);
$events = get_posts($args);
// Event loop
foreach ($events as $i => $event) {
$results = (array) get_post_meta($event->ID, 'sp_results', true);
$team_performance = get_post_meta($event->ID, 'sp_players', true);
$minutes = get_post_meta($event->ID, 'sp_minutes', true);
if ($minutes === '') {
$minutes = get_option('sportspress_event_minutes', 90);
}
// Add all team performance
if (is_array($team_performance)) {
foreach ($team_performance as $team_id => $players) {
if (is_array($players)) {
foreach ($players as $player_id => $player_performance) {
if (array_key_exists($player_id, $totals) && is_array($totals[$player_id])) {
$player_performance = sp_array_value($players, $player_id, array());
foreach ($player_performance as $key => $value) {
if ('outcome' == $key) {
// Increment events attended, played, and started
$totals[$player_id]['eventsattended']++;
$totals[$player_id]['eventsplayed']++;
$totals[$player_id]['eventsstarted']++;
$totals[$player_id]['eventminutes'] += $minutes;
// Convert to array
if (!is_array($value)) {
$value = array($value);
}
foreach ($value as $outcome) {
if ($outcome && $outcome != '-1') {
// Increment events attended and outcome count
if (array_key_exists($outcome, $totals[$player_id])) {
$totals[$player_id][$outcome]++;
}
// Add to streak counter
if ($streaks[$player_id]['fire'] && ($streaks[$player_id]['name'] == '' || $streaks[$player_id]['name'] == $outcome)) {
$streaks[$player_id]['name'] = $outcome;
$streaks[$player_id]['count']++;
} else {
$streaks[$player_id]['fire'] = 0;
}
// Add to last 5 counter if sum is less than 5
if (array_key_exists($player_id, $last5s) && array_key_exists($outcome, $last5s[$player_id]) && array_sum($last5s[$player_id]) < 5) {
$last5s[$player_id][$outcome]++;
}
// Add to last 10 counter if sum is less than 10
if (array_key_exists($player_id, $last10s) && array_key_exists($outcome, $last10s[$player_id]) && array_sum($last10s[$player_id]) < 10) {
$last10s[$player_id][$outcome]++;
}
}
}
} elseif (array_key_exists($key, $totals[$player_id])) {
$totals[$player_id][$key] += $value;
}
}
$team_results = sp_array_value($results, $team_id, array());
// Loop through home team
foreach ($team_results as $result_slug => $team_result) {
if ('outcome' == $result_slug) {
// Increment events attended
$totals[$player_id]['eventsattended']++;
// Continue with incrementing values if active in event
if (sp_array_value($player_performance, 'status') != 'sub' || sp_array_value($player_performance, 'sub', 0)) {
$totals[$player_id]['eventsplayed']++;
$totals[$player_id]['eventminutes'] += $minutes;
if (sp_array_value($player_performance, 'status') == 'lineup') {
$totals[$player_id]['eventsstarted']++;
} elseif (sp_array_value($player_performance, 'status') == 'sub' && sp_array_value($player_performance, 'sub', 0)) {
$totals[$player_id]['eventssubbed']++;
}
$value = $team_result;
// Convert to array
if (!is_array($value)) {
$value = array($value);
}
foreach ($value as $outcome) {
if ($outcome && $outcome != '-1') {
// Increment events attended and outcome count
if (array_key_exists($outcome, $totals[$player_id])) {
$totals[$player_id][$outcome]++;
}
// Add to streak counter
if ($streaks[$player_id]['fire'] && ($streaks[$player_id]['name'] == '' || $streaks[$player_id]['name'] == $outcome)) {
$streaks[$player_id]['name'] = $outcome;
$streaks[$player_id]['count']++;
} else {
$streaks[$player_id]['fire'] = 0;
}
// Add to last 5 counter if sum is less than 5
if (array_key_exists($player_id, $last5s) && array_key_exists($outcome, $last5s[$player_id]) && array_sum($last5s[$player_id]) < 5) {
$last5s[$player_id][$outcome]++;
}
// Add to last 10 counter if sum is less than 10
if (array_key_exists($player_id, $last10s) && array_key_exists($outcome, $last10s[$player_id]) && array_sum($last10s[$player_id]) < 10) {
$last10s[$player_id][$outcome]++;
}
}
}
}
} else {
// Add to total
$value = sp_array_value($totals[$player_id], $result_slug . 'for', 0);
$value += $team_result;
$totals[$player_id][$result_slug . 'for'] = $value;
// Add subset
$totals[$player_id][$result_slug . 'for' . ($i + 1)] = $team_result;
}
}
// Loop through away teams
if (sizeof($results)) {
foreach ($results as $id => $team_results) {
if ($team_id == $id) {
continue;
}
unset($team_results['outcome']);
foreach ($team_results as $result_slug => $team_result) {
// Add to total
$value = sp_array_value($totals[$player_id], $result_slug . 'against', 0);
$value += $team_result;
$totals[$player_id][$result_slug . 'against'] = $value;
// Add subset
$totals[$player_id][$result_slug . 'against' . ($i + 1)] = $team_result;
}
}
}
}
}
}
}
}
$i++;
}
foreach ($streaks as $player_id => $streak) {
// Compile streaks counter and add to totals
if ($streak['name']) {
$args = array('name' => $streak['name'], 'post_type' => 'sp_outcome', 'post_status' => 'publish', 'posts_per_page' => 1);
$outcomes = get_posts($args);
if ($outcomes) {
$outcome = reset($outcomes);
$abbreviation = sp_get_abbreviation($outcome->ID);
if (empty($abbreviation)) {
$abbreviation = strtoupper(substr($outcome->post_title, 0, 1));
}
$totals[$player_id]['streak'] = $abbreviation . $streak['count'];
} else {
$totals[$player_id]['streak'] = null;
}
} else {
$totals[$player_id]['streak'] = null;
}
}
foreach ($last5s as $player_id => $last5) {
// Add last 5 to totals
$totals[$player_id]['last5'] = $last5;
}
foreach ($last10s as $player_id => $last10) {
// Add last 10 to totals
$totals[$player_id]['last10'] = $last10;
}
$args = array('post_type' => array('sp_performance', 'sp_metric', 'sp_statistic'), 'numberposts' => -1, 'posts_per_page' => -1, 'orderby' => 'menu_order', 'order' => 'ASC');
$stats = get_posts($args);
foreach ($stats as $stat) {
// Get post meta
$meta = get_post_meta($stat->ID);
// Add equation to object
if ($stat->post_type == 'sp_metric') {
$stat->equation = null;
} else {
$stat->equation = sp_array_value(sp_array_value($meta, 'sp_equation', array()), 0, 0);
}
// Add precision to object
$stat->precision = sp_array_value(sp_array_value($meta, 'sp_precision', array()), 0, 0);
// Add column name to columns
$columns[$stat->post_name] = $stat->post_title;
}
// Fill in empty placeholder values for each player
foreach ($player_ids as $player_id) {
if (!$player_id) {
continue;
}
$placeholders[$player_id] = array_merge(sp_array_value($totals, $player_id, array()), array_filter(sp_array_value($placeholders, $player_id, array())));
foreach ($stats as $stat) {
if (sp_array_value($placeholders[$player_id], $stat->post_name, '') == '') {
if ($stat->equation === null) {
$placeholder = sp_array_value(sp_array_value($adjustments, $player_id, array()), $stat->post_name, null);
if ($placeholder == null) {
$placeholder = '-';
}
} else {
// Solve
$placeholder = sp_solve($stat->equation, $placeholders[$player_id], $stat->precision);
// Adjustments
$adjustment = sp_array_value($adjustments, $player_id, array());
if ($adjustment != 0) {
$placeholder += sp_array_value($adjustment, $stat->post_name, 0);
$placeholder = number_format($placeholder, $stat->precision, '.', '');
}
}
$placeholders[$player_id][$stat->post_name] = $placeholder;
}
}
}
// Merge the data and placeholders arrays
$merged = array();
foreach ($placeholders as $player_id => $player_data) {
// Add player number and name to row
$merged[$player_id] = array();
if (in_array('number', $this->columns)) {
$player_data['number'] = get_post_meta($player_id, 'sp_number', true);
}
$player_data['name'] = get_the_title($player_id);
if (in_array('team', $this->columns)) {
$player_data['team'] = get_post_meta($player_id, 'sp_team', true);
}
if (in_array('position', $this->columns)) {
$player_data['position'] = null;
}
foreach ($player_data as $key => $value) {
// Use static data if key exists and value is not empty, else use placeholder
if (array_key_exists($player_id, $tempdata) && array_key_exists($key, $tempdata[$player_id]) && $tempdata[$player_id][$key] != '') {
$merged[$player_id][$key] = $tempdata[$player_id][$key];
} else {
$merged[$player_id][$key] = $value;
}
}
}
if ($orderby != 'number' || $order != 'ASC') {
$this->priorities = array(array('key' => $orderby, 'order' => $order));
uasort($merged, array($this, 'sort'));
}
// Rearrange data array to reflect values
$data = array();
foreach ($merged as $key => $value) {
$data[$key] = $tempdata[$key];
}
if ($admin) {
$labels = array();
foreach ($this->columns as $key) {
if ($key == 'number') {
$labels[$key] = '#';
} elseif ($key == 'team' && apply_filters('sportspress_has_teams', true)) {
$labels[$key] = __('Team', 'sportspress');
} elseif ($key == 'position') {
$labels[$key] = __('Position', 'sportspress');
} elseif (array_key_exists($key, $columns)) {
$labels[$key] = $columns[$key];
}
}
return array($labels, $data, $placeholders, $merged, $orderby);
} else {
if (!is_array($this->columns)) {
$this->columns = array();
}
foreach ($columns as $key => $label) {
if (!in_array($key, $this->columns)) {
unset($columns[$key]);
}
}
$labels = array();
if (in_array('number', $this->columns)) {
$labels['number'] = '#';
}
$labels['name'] = __('Player', 'sportspress');
if (in_array('team', $this->columns) && apply_filters('sportspress_has_teams', true)) {
$labels['team'] = __('Team', 'sportspress');
}
if (in_array('position', $this->columns)) {
$labels['position'] = __('Position', 'sportspress');
}
$merged[0] = array_merge($labels, $columns);
return $merged;
}
}
/**
* Returns league tables
*
* @access public
* @return array
*/
public function tables($admin = false)
{
if (!$this->ID) {
return null;
}
$league_ids = sp_get_the_term_ids($this->ID, 'sp_league');
$season_ids = sp_get_the_term_ids($this->ID, 'sp_season');
$args = array('post_type' => 'sp_table', 'numberposts' => -1, 'posts_per_page' => -1, 'orderby' => 'menu_order', 'order' => 'ASC', 'meta_query' => array('relation' => 'AND', array('key' => 'sp_select', 'value' => 'manual'), array('key' => 'sp_team', 'value' => $this->ID)));
$tables_by_id = get_posts($args);
$args = array('post_type' => 'sp_table', 'numberposts' => -1, 'posts_per_page' => -1, 'orderby' => 'menu_order', 'order' => 'ASC', 'meta_query' => array(array('key' => 'sp_select', 'value' => 'auto')), 'tax_query' => array('relation' => 'AND', array('taxonomy' => 'sp_league', 'field' => 'term_id', 'terms' => $league_ids), array('taxonomy' => 'sp_season', 'field' => 'term_id', 'terms' => $season_ids)));
$tables_by_terms = get_posts($args);
$tables = array_merge($tables_by_id, $tables_by_terms);
$checked = (array) get_post_meta($this->ID, 'sp_table');
if ($admin) {
return array($tables, $checked);
} else {
foreach ($tables as $key => $table) {
if (!in_array($table->ID, $checked)) {
unset($tables[$key]);
}
}
return $tables;
}
}
