Ebay API Question posted in
The official documentation of all the APIs offered by Ebay can be found here.

Ebay API – php function to sum values from multi dimensional array

My $results array looks like this..

$results = [
    '2020-09-06' => [
        'Etsy' => ['total_orders' => 2, 'total_stickers' => 3, 'total_value' => 7.8300000000000001],
        'Woo' => ['total_orders' => 10, 'total_stickers' => 20, 'total_value' => 100.38],
        'eBay' => ['total_orders' => 17, 'total_stickers' => 18, 'total_value' => 67.359999999999999],
    ],
    '2020-09-07' => [
        'Etsy' => ['total_stickers' => 8, 'total_orders' => 4, 'total_value' => 34.920000000000002],
        'Woo' => ['total_stickers' => 9, 'total_orders' => 3, 'total_value' => '52.90'],
        'eBay' => ['total_stickers' => 23, 'total_orders' => 21, 'total_value' => 58.030000000000001],
    ]
];

I want to echo the combined sum for each individual item (total_value, total_stickers, total_orders) for each "marketplace" by date and thought i could do this if i pass the variables in a function and tried the following..

$array_value_sum = create_function('$array,$key', '$total = 0; foreach($array as $row) $total = $total + $row[$key]; return $total;');
echo "Total Current Value" . $array_value_sum($obj['results'], 'total_value');

That way I can change the variables and sum any of them with a similar echo line but this is not working for me, do I also need to specify dates in a foreach? or how can I achieve this expected output..

Array
(
    [2020-09-06] => Array
        (
                    [total_orders] => 29
                    [total_stickers] => 41
                    [total_value] => 175.5      
        )
    [2020-09-07] => Array
        (           
                    [total_stickers] => 40
                    [total_orders] => 28
                    [total_value] => 145.85
        )
)
Tags:

2

Answers


  1. 0

    One way would be to simply loop over it with a couple of foreach’s and add the values together.

    Sum all by date, including all marketplaces.

    <?php
$result = [];
foreach ($data as $date => $marketplaces) {
    foreach ($marketplaces as $data) {
        if (!isset($result[$date])) $result[$date] = ['total_orders' => 0, 'total_stickers' => 0, 'total_value' => 0];
        
        $result[$date] = [
            'total_stickers' => $result[$date]['total_stickers'] + $data['total_stickers'],
            'total_orders' => $result[$date]['total_orders'] + $data['total_orders'],
            'total_value' => $result[$date]['total_value'] + $data['total_value'],
        ];
    }
}

print_r($result);

    Result:

    Array
(
    [2020-09-06] => Array
        (
            [total_stickers] => 41
            [total_orders] => 29
            [total_value] => 175.57
        )

    [2020-09-07] => Array
        (
            [total_stickers] => 40
            [total_orders] => 28
            [total_value] => 145.85
        )

)

    https://3v4l.org/qQ04D

    Original answer: Sum all marketplaces.

    <?php
$result = [];
foreach ($data as $date => $marketplaces) {
    foreach ($marketplaces as $marketplace => $data) {
        if (!isset($result[$marketplace])) {
            $result[$marketplace] = $data;
        } else {
            $result[$marketplace] = [
                'total_stickers' => $result[$marketplace]['total_stickers'] + $data['total_stickers'],
                'total_orders' => $result[$marketplace]['total_orders'] + $data['total_orders'],
                'total_value' => $result[$marketplace]['total_value'] + $data['total_value'],
            ];
        }
    }
}

print_r($result);

    Result:

    Array
(
    [Etsy] => Array
        (
            [total_stickers] => 11
            [total_orders] => 6
            [total_value] => 42.75
        )

    [Woo] => Array
        (
            [total_stickers] => 29
            [total_orders] => 13
            [total_value] => 153.28
        )

    [eBay] => Array
        (
            [total_stickers] => 41
            [total_orders] => 38
            [total_value] => 125.39
        )

)

    https://3v4l.org/g4CmZ

    Login or Signup to reply.
  2. 0

    As always, no need to over-engineer, if you know the structure, just iterate trough the values, and sum them up, this is how I would do that.

    This way you can add many other marketplace and dates without later modifying the code.

    <?php
$results = [
    '2020-09-06' => [
        'Etsy' => ['total_orders' => 2, 'total_stickers' => 3, 'total_value' => 7.8300000000000001],
        'Woo' => ['total_orders' => 10, 'total_stickers' => 20, 'total_value' => 100.38],
        'eBay' => ['total_orders' => 17, 'total_stickers' => 18, 'total_value' => 67.359999999999999],
    ],
    '2020-09-07' => [
        'Etsy' => ['total_stickers' => 8, 'total_orders' => 4, 'total_value' => 34.920000000000002],
        'Woo' => ['total_stickers' => 9, 'total_orders' => 3, 'total_value' => '52.90'],
        'eBay' => ['total_stickers' => 23, 'total_orders' => 21, 'total_value' => 58.030000000000001],
    ]
];

$total = ['total_stickers' => 0, 'total_orders' => 0, 'total_value' => 0];

foreach ($results as $k => $v){
  foreach ($v as $k1 => $v1){
   $total['total_stickers'] += $v1['total_stickers'];
   $total['total_orders'] += $v1['total_orders'];
   $total['total_value'] += $v1['total_value'];
  
  }
}

var_dump($total);
/*
 * array(3) {
  ["total_stickers"]=>
  int(81)
  ["total_orders"]=>
  int(57)
  ["total_value"]=>
  float(321.42)
}
* */
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search