Sort Array based on multiple values [duplicate]

Question

I need to sort an array of objects based on the objects properties. Basically if you take a look at this fixture table and note "Liverpool FC" and "Manchester City FC" you can see that they have the same amount of points, so they are ordered based on the other values being higher.

Now if you take a look at mine i'm only ordering based on the points, i'm not sure how to order this based on multiple values.

The data is stored within an instance of a class, this instance is stored within an Array() with the Key being the team name.

Below is the class which managed the data, how can I re-arrange the array so that the objects are in order the way the first link has them ordered?

 class Calc {
    private $config;
    public $win = 0, $draw = 0, $loss = 0, $goalFor = 0, $goalConc = 0;

    public function __construct($payload = array(0,0)) {
      // Load config file
      $this->config = parse_ini_file('config.ini', true);

      // Add wins, losses, draws, goals for and goal conceived
      $this->addData($payload);
    }

    // Linked data updated, ammend values
    public function calcPlays() {
      return 0 + $this->win + $this->draw + $this->loss;
    }
    public function calcPoints() {
      // Add 0 to ensure value is an int
      return $this->win * ($this->config['winPoints']) + ($this->draw * $this->config['drawPoints']) + ($this->loss * $this->config['lossPoints']);
    }
    public function calcGoalDifference() {
      return ($this->goalFor - $this->goalConc);
    }

    public function addData($data) {
      // Append goal data
      $this->goalFor += $data[0];
      $this->goalConc += $data[1];

      // Win, Loss or Draw
      if ($data[0] > $data[1]) { $this->win++;} elseif
      ($data[0] < $data[1]) { $this->loss++;} elseif
      ($data[0] == $data[1]) { $this->draw++;}
    }
  }

Edit:

My data is now everywhere:

1   Burnley FC  13  4   2   7   12  21  -9  14
2   Leicester City FC   13  3   4   6   16  22  -6  13
3   Crystal Palace FC   13  3   2   8   21  26  -5  11
4   Swansea City FC 13  2   3   8   16  26  -10 9
5   Arsenal FC  13  8   4   1   28  13  15  28

I'm assuming my checks are the wrong way around, I was assuming it would check if $a is bigger than or equal to $b, if so then return true, if not move on to the next check?

The code:

// Sort teams by points
uasort($teamData, function($a, $b) {
  if ($a->calcPoints() < $b->calcPoints() && $a->calcPoints() !== $b->calcPoints()) {
    return true;
  } elseif ($a->calcGoalDifference() < $b->calcGoalDifference() && $a->calcGoalDifference() !== $b->calcGoalDifference()) {
    return true;
  } elseif($a->goalConc < $b->goalConc) {
    return true;
  }
  return false;
});

trincot · Accepted Answer · 2016-11-27 21:37:52Z

2

Use usort as follows:

uasort($teamData, function($a, $b) {
    $diff = $a->calcPoints() - $b->calcPoints();
    if (!$diff) $diff = $a->calcGoalDifference() - $b->calcGoalDifference();
    if (!$diff) $diff = $a->goalConc - $b->goalConc;
    return $diff;
});

The if conditions are true when the previous comparison was a tie. Note also that the return value is not supposed to be a boolean, but a signed number.

This sorts in ascending order. If you need it the other way around, then swap the positions of $a and $b either in the argument list, or in the expressions.

answered Nov 27, 2016 at 21:37

trincot

357k38 gold badges282 silver badges338 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Winter Faulk · Accepted Answer · 2016-11-27 21:46:19Z

1

You can use usort and write a function that compares the different values and sorts them accordingly.

Something along the lines of:

uasort($teamData, function ($a, $b)
{
    if ( $a->calcPoints() < $b->calcPoints() )
    {
        return 1;
    }
    elseif ( $a->calcPoints() <= $b->calcPoints() && $a->calcGoalDifference() < $b->calcGoalDifference() )
    {
        return 1;
    }
    elseif ( ($a->calcPoints() <= $b->calcPoints() && $a->calcGoalDifference() <= $b->calcGoalDifference()) && $a->goalConc < $b->goalConc )
    {
        return 1;
    }

    return 0;
});

edited Nov 27, 2016 at 21:46

answered Nov 27, 2016 at 21:07

Winter Faulk

4134 silver badges9 bronze badges

4 Comments

Martyn Ball Over a year ago

You got any idea how football premier league positions are calculated as I don't know football at all!

Winter Faulk Over a year ago

Nope, I know very little about football but my guess is first Pts, then GD, then A

Winter Faulk Over a year ago

I adjusted to match your needs, I think

Winter Faulk Over a year ago

FYI: @trincot's post is a clean approach then mine.

Collectives™ on Stack Overflow

Sort Array based on multiple values [duplicate]

2 Answers 2

Comments

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Linked

Related