Sort plural before string

Question

I would like to know how to sort numeric characters before a string. I use array_multisort to sort my array.

My sample data is available

$arr = [
    [
        'company_name' => '',
        'expiryDate' => '2018.7',
        'classification' => 1
    ],
    [
        'company_name' => '',
        'expiryDate' => '2018.7',
        'classification' => '2-03'
    ],
    [
        'company_name' => '',
        'expiryDate' => '2018.7',
        'classification' => 3
    ],
    [
        'company_name' => '',
        'expiryDate' => '2018.7',
        'classification' => '2-01'
    ],
];

The current result after sorting. String number "2-01" is sorted between 1 and 3

$arr = [
    [
        'company_name' => '',
        'expiryDate' => '2018.7',
        'classification' => 1
    ],
    [
        'company_name' => '',
        'expiryDate' => '2018.7',
        'classification' => '2-01'
    ],
    [
        'company_name' => '',
        'expiryDate' => '2018.7',
        'classification' => '2-03'
    ],
    [
        'company_name' => '',
        'expiryDate' => '2018.7',
        'classification' => 3
    ],
];

Expected Result. I want to sort the string "2-01", "2-03" after the numbers 1 and 3

$arr = [
       [
          'company_name' => '',
          'expiryDate' => '2018.7',
          'classification' => 1
       ],
       [
          'company_name' => '',
          'expiryDate' => '2018.7',
          'classification' => 3
       ],
       [
          'company_name' => '',
          'expiryDate' => '2018.7',
          'classification' => '2-01'
       ],
       [
          'company_name' => '',
          'expiryDate' => '2018.7',
          'classification' => '2-03'
       ],
    ];

My sort fields. I used array_multisort to sort multiple fields

$sortFields = [
    'classification' => SORT_ASC,
    'company_name' => SORT_ASC,
    'expiryDate' => SORT_ASC
];

Answer 1

You can use usort () to do this:

usort($arr, function($a,$b) {
    // First, sort by classification. If it returns non-zero, use this
    // sort. If not, move to the next sort type.
    $sort = sortByClassification($a['classification'],$b['classification']);
    if ($sort !== 0) {
        return $sort;
    }

    // Second, sort by company name. If it returns non-zero, use this
    // sort. If not, move to the next sort type.
    $sort = sortByCompanyName($a['company_name'],$b['company_name']);
    if ($sort !== 0) {
        return $sort;
    }

    // Third, sort by expiry date. Since this is the last sort type,
    // we can just return it
    return sortByExpiryDate($a['expiryDate'],$b['expiryDate']);
});

function sortByClassification($a,$b) {
    // Both are numeric, so sort numerically
    if (is_numeric($a) && is_numeric($b)) {
        if ($a == $b) {
            return 0;
        }
        return ($a < $b) ? -1 : 1;
    }
    // Both are strings, so sort alphabetically
    if (!is_numeric($a) && !is_numeric($b)) {
        return strcmp($a, $b);
    }
    return is_numeric($a) ? -1 : 1;
}

function sortByCompanyName($a,$b) {
    return strcmp($a, $b);
}

function sortByExpiryDate($a, $b) {
    $a_explode = explode('.', $a);
    $a_expiry = new DateTime($a_explode[0].'-'.$a_explode[1].'-1');

    $b_explode = explode('.', $b);
    $b_expiry = new DateTime($b_explode[0].'-'.$b_explode[1].'-1');

    if ($a_expiry == $b_expiry) {
        return 0;
    }
    return $a_expiry < $b_expiry ? -1 : 1;
}

print_r($arr);

Conclusion:

Array
(
    [0] => Array
        (
            [company_name] => 
            [expiryDate] => 2018.7
            [classification] => 1
        )

    [1] => Array
        (
            [company_name] => 
            [expiryDate] => 2018.7
            [classification] => 3
        )

    [2] => Array
        (
            [company_name] => 
            [expiryDate] => 2018.7
            [classification] => 2-01
        )

    [3] => Array
        (
            [company_name] => 
            [expiryDate] => 2018.7
            [classification] => 2-03
        )

)

Answer 2

Try usort()and comparator:

// @param $arr array that you want to sort
// @param $sortby sort by $arr[$indexOfArray][$sortby]
// @param $isDate boolean
function sortItOutYourself(&$arr, $sortby, $isDate) {
    usort($arr, function($a1, $a2) use ($sortby, $isDate) {
        if($isDate)
            return DateTime::createFromFormat("Y.m", $a1[$sortby])->getTimestamp()
                - DateTime::createFromFormat("Y.m", $a2[$sortby])->getTimestamp();

        if( (gettype($a1[$sortby]) == "string" && gettype($a2[$sortby]) == "string") ||
            (gettype($a1[$sortby]) == "integer" && gettype($a2[$sortby]) == "integer") )
            return $a1[$sortby] > $a2[$sortby] ? 1 : -1;

        return gettype($a1[$sortby]) == "integer" && gettype($a2[$sortby]) == "string" ? -1 : 1;
    });
}

sortItOutYourself($arr, "classification", false);
sortItOutYourself($arr, "company_name", false);
sortItOutYourself($arr, "expiryDate", true);