Finding max with multiple key filter inside an array

Question

I have script which needs to find the star performer of the month.

This is sample data

 $data = array (
          [0] = array(
               "tasks_done" => 5,
                "rating" => 5),
          [1] = array(
               "tasks_done" => 4,
                "rating" => 5),
          [2] = array(
               "tasks_done" => 3,
                "rating" => 5),
          [3] = array(
               "tasks_done" => 5,
               "rating" => 5)
       );

So the question is to find the person with max tasks done and max number of rating. Is this possible using any algorithm of by simple php code.

References Sample to find max number in array :

find max() of specific multidimensional array value in php

But nothing seems to work. Any help is appreciated.

Which hold more weight when comparasion??? Or your want to find max separately? — LF00, Jun 23 '17 at 09:40
@KrisRoofe find max separately with two filters findmax(task_done) and findmax(rating) which must output one result — Arth Parikh, Jun 23 '17 at 09:44
This is a simple task - iterate over array and compare values. — u_mulder, Jun 23 '17 at 09:50
@KrisRoofe your code will only find person with max number of tasks done. i want with both max no of tasks and max no of rating — Arth Parikh, Jun 23 '17 at 09:53
@u_mulder can you please provide a sample code with fiddle or else — Arth Parikh, Jun 23 '17 at 09:53
Make an effort and try something. Just coming here and waiting for a code is a bad approach. — u_mulder, Jun 23 '17 at 09:56
@u_mulder i already tried many solutions and I also provided one reference link in the question. Please read it again. — Arth Parikh, Jun 23 '17 at 09:58
Providing a link somewhere does not mean that you tried something. Same to `I tried many solutions`. — u_mulder, Jun 23 '17 at 10:00
tasks_done & ratting is interlinked? means depends on each other ? — Ashu, Jun 23 '17 at 10:12

score 0 · Answer 1 · answered Jun 23 '17 at 10:36

I have sort by rating first and second tasks_done.

Please check below code,

$data = array();
$data[0]=array("tasks_done" => 5,"rating" => 5);
$data[1]=array("tasks_done" => 4,"rating" => 5);
$data[2]=array("tasks_done" => 3,"rating" => 3);
$data[3]=array("tasks_done" => 5,"rating" => 6);
$data[4]=array("tasks_done" => 6,"rating" => 2);
$data[5]=array("tasks_done" => 3,"rating" => 6);
$temp_array = array();
$output = array();
foreach($data as $k=>$values){
    $temp_array['tasks_done'][$values['tasks_done']][$k]=$values['tasks_done'];
    $temp_array['rating'][$values['rating']][$k]=$values['rating'];
}
echo "<pre>";
print_r($data);
krsort($temp_array['tasks_done']);
krsort($temp_array['rating']);
foreach($temp_array['rating'] as $k=>$v){
    $check = checkUpper($v,$temp_array['tasks_done']);
    foreach($v as $k1=>$v1){
        $output[]=array(
            "tasks_done"=>$check[$k1],
            "rating"=>$v1
        );
    }
}
function checkUpper($array_check,$array){
    $tmp = array();
    foreach($array as $keys=>$values){
        foreach($values as $key=>$value){
            if(array_key_exists($key,$array_check)){
                $tmp[$key]=$value;
            }
        }
    }
    arsort($tmp);
    return $tmp;
}

Output,

Array
(
    [0] => Array
        (
            [tasks_done] => 5
            [rating] => 6
        )

    [1] => Array
        (
            [tasks_done] => 3
            [rating] => 6
        )

    [2] => Array
        (
            [tasks_done] => 5
            [rating] => 5
        )

    [3] => Array
        (
            [tasks_done] => 4
            [rating] => 5
        )

    [4] => Array
        (
            [tasks_done] => 3
            [rating] => 3
        )

    [5] => Array
        (
            [tasks_done] => 6
            [rating] => 2
        )

)

score 0 · Answer 2 · answered Jun 23 '17 at 12:30

0

I solved it using mysql with order by parameter. Thank you folks for your help.

answered Jun 23 '17 at 12:30

Arth Parikh

43
8

Finding max with multiple key filter inside an array

2 Answers2