PHP Array and how to display it with this order of array

Question

I have an array that is the one below.

I need to be able to display it like a table with first columns on top being Agent Names. The columns on the left displaying dates, and sums in the records where they intersect. I understand how to step through and add HTML in a For Each.. However I am having trouble with the sorting to have it appear correct.. Something like the table below:

--------------1-23-2018---------------1-24-2018---------------------

Daniel ---$1,995.00 ----------------$1,459.00

Gail ------$1,695.00 ----------------$3,845.00

I understand how to step through

Please Help. I am doing all this in PHP.

Possible duplicate of PHP multidimensional array to html table — admcfajn
– admcfajn, Commented Feb 17, 2018 at 2:32
Try something like this: stackoverflow.com/questions/13767211/… & Moving forward please provide a minimal reproducible example of what you've tried on your own to solve this problem. — admcfajn
– admcfajn, Commented Feb 17, 2018 at 2:33
We could probably do a great job of helping you, starting from the query, if you provide an sqlfiddle link. It looks like your results set is _array but only needs to be _assoc. — mickmackusa
– mickmackusa ♦, Commented Feb 17, 2018 at 4:18

sevavietl · Accepted Answer · 2018-02-17 10:06:40Z

What you are trying to create is a Pivot table. In general, it is not a simple task to do (that is one of the killer features of spreadsheets (i.e. Excel)), but in your particular case you can do the following:

// Flatten array, maybe redundant if you get data in appropriate format.
$flatten = array_reduce($array, 'array_merge', []);

// Store all unique dates in the index lookup table (j).
$dates = array_flip(array_values(array_unique(array_column($flatten, 'Deal_Date'))));
// Store all unique names in the index lookup table (i).
$names = array_flip(array_values(array_unique(array_column($flatten, 'Agent'))));

$totals = array_reduce(
    $flatten,
    function ($totals, $item) use ($names, $dates) {
        $i = $names[$item['Agent']];
        $j = $dates[$item['Deal_Date']];
        $totals[$i][$j] += $item['Total'];

        return $totals;
    },
    // Prefil table with zeros.
    array_fill(0, count($names), array_fill(0, count($dates), 0))
);

// Displaying part:
// Merge all the raws and cols together (add headers).
$table = $totals;
array_unshift($table, array_flip($dates));
$names = array_flip($names);
array_unshift($names, null);
$table = array_map(function ($name, $row) {
    array_unshift($row, $name);

    return $row;
}, $names, $table);

// Calculate max widthes for better displaying:
$width = array_map(function ($column) {
    return max(array_map('strlen', $column));
}, array_map(null, ...$table));

foreach ($table as $row) {
    echo implode(' | ', array_map(function ($cell, $width) {
        return str_pad($cell, $width);
    }, $row, $width)), PHP_EOL;
}

This will give you a table like the following:

       | 2018-01-23 | 2018-01-25
Daniel | 1995       | 4590      
Gail   | 1695       | 3845      
Joe    | 395        | 495       
Judy   | 1795       | 0         
Justin | 2390       | 945       
Kevin  | 1800       | 1995      
Sky    | 795        | 995       
Tony   | 1695       | 995       
Kyle   | 0          | 1790      
Lisa   | 0          | 1995      
Sam    | 0          | 2990

Here is the demo.

For a more general solution, please, consider using some dedicated library, for example, this one.

Collectives™ on Stack Overflow

PHP Array and how to display it with this order of array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related