Home / Questions / 520761
Accepted
Darinel Cigarroa
Asked: 2022-08-16 10:54:03 +0800 CST 2022-08-16 10:54:03 +0800 CST

How to remove repeated data in a JSON and add their amounts in PHP/Laravel?

  • 772

I have the following JSON (I will show a dd of the $data_concepts variable):

array:3 [
  0 => {#2408
    +"total": "1300"
    +"concepto": "AHORRO SOLIDARIO 1 B"
    +"alias": "2AS"
    +"tipo": 2
    +"code": "2AS"
  }
  1 => {#2377
    +"total": "700"
    +"concepto": "AHORRO SOLIDARIO 1 M"
    +"alias": "2AS"
    +"tipo": 2
    +"code": "2AS.0"
  }
  2 => {#2391
    +"total": "9815.670000000002"
    +"concepto": "AHORRO SOLIDARIO 2 B"
    +"alias": "24S"
    +"tipo": 2
    +"code": "24S."
  }
]

I am trying to group the data by alias, that is, if the alias field is repeated, get another JSON with a single alias and the sum of the total field of all of them.

That is, something like this:

array:2 [
      0 => {#2408
        +"total": "2000"
        +"concepto": "AHORRO SOLIDARIO 1 B"
        +"alias": "2AS"
        +"tipo": 2
        +"code": "2AS"
      }
      1 => {#2391
        +"total": "9815.670000000002"
        +"concepto": "AHORRO SOLIDARIO 2 B"
        +"alias": "24S"
        +"tipo": 2
        +"code": "24S."
      }
    ]

I am trying this way:

$conceptss= [];
  foreach ($data_concepts as $clave => $conceptss) {
                if (!empty($conceptss->alias)) {
                    if(!empty($concepts)) {
                        if (in_array($conceptss->alias, $concepts[$clave])) {
                            continue;
                        } else {
                            array_push($concepts, $conceptss);
                            // dd($concepts);
                        }
                    } else {
                        array_push($concepts, $conceptss);
                    }
                }
            }

But this throws an error, any ideas or tips? Any help is helpful and much appreciated, thanks.

I get the data from a query to my database, the query is as follows:

  $data_concepts = DB::table('processed_payroll_concepts')
                ->select(DB::raw('sum(processed_payroll_concepts.amount) as Total, processed_payroll_concepts.name as Concepto,  processed_payroll_concepts.alias as Alias,  processed_payroll_concepts.cat_concept_type_id as Tipo,  processed_payroll_concepts.code as Code'))
                ->leftJoin('processed_payrolls', 'processed_payrolls.id', '=', 'processed_payroll_concepts.processed_payroll_id')
                ->where('processed_payrolls.payroll_id', $id)
                // ->whereNotNull('alias')
                ->groupBy('processed_payroll_concepts.name')
                ->groupBy('processed_payroll_concepts.alias')
                ->groupBy('processed_payroll_concepts.cat_concept_type_id')
                ->groupBy('processed_payroll_concepts.code')
                ->get();
php

1 Answers

  1. Best Answer

    As I said in the comments, I don't understand why you want that output, because the values ​​of codeand conceptoare different.

    Still, I think this might work for you:

    $output = [];
foreach ($data_concepts as $clave => $conceptss) {
    if(!isset($output[$conceptss->alias])) {
        $output[$conceptss->alias] = $conceptss;
    } else {
        $output[$conceptss->alias]->total += $conceptss->total;
    }
}
print_r(array_values($output));
$json = json_encode(array_values($output));

    So it generates this output:

    Array
(
    [0] => stdClass Object
        (
            [total] => 2000
            [concepto] => AHORRO SOLIDARIO 1 B
            [alias] => 2AS
            [tipo] => 2
            [code] => 2AS
        )

    [1] => stdClass Object
        (
            [total] => 9815.670000000002
            [concepto] => AHORRO SOLIDARIO 2 B
            [alias] => 24S
            [tipo] => 2
            [code] => 24S.
        )
)

    which comes to coincide with what you ask.

    Explanation

    • First we define and initialize an array type variable called $outputwhere we will store the data of each cycle, related by keys that match the propertyalias
    $output = [];
    • Then we start the loop. And by means of a conditional we check if, in the variable, $outputthere is the key that corresponds to the value of the property aliasof the object iterated in that cycle of the loop.
        if(!isset($output[$conceptss->alias])) {
    • If it does not exist, we enter the conditional and create it, assigning it the value of the first iterated object complete with all its variables and values:
            $output[$conceptss->alias] = $conceptss;
    • And if it exists, it means that it already contains at least one complete object, and therefore we can add the new total that comes to us in that new object iterated in that cycle and that coincides in its alias:
        } else {
        $output[$conceptss->alias]->total += $conceptss->total;
    }
    • And so on until the cycles of the loop finish. Then, to get rid of the alias keys we've been using, we print it using array_values() which will print us a new numerically indexed array, as requested in the question.
    print_r(array_values($output));

    Then, if you need it in json format , you can do the following:

    $json = json_encode(array_values($output));

    Tell us if it works for you.

    • 1