Home / Questions / 562751
Accepted
Karelix Alejandra
Asked: 2022-10-18 11:23:18 +0800 CST 2022-10-18 11:23:18 +0800 CST

Group values ​​in laravel based on another value

  • 772

Hello, I have a collection of data that contains, (for example, because this comes out according to the operations of the day):

"id" => 53
    "articulo_id" => 23
    "almacen_id" => 1
    "transtype" => "TR"
    "comentario" => "Transferencia origen 5"
    "trans_id" => 5
    "cantidad" => -5
    "onhand" => 10
    "created_at" => "2022-10-17 09:04:17"
    "updated_at" => "2022-10-17 09:04:17"
    "articulo" => "Caja clips nro 1"

"id" => 54
    "articulo_id" => 23
    "almacen_id" => 2
    "transtype" => "TR"
    "comentario" => "Transferencia destino 5"
    "trans_id" => 5
    "cantidad" => 5
    "onhand" => 5
    "created_at" => "2022-10-17 09:04:17"
    "updated_at" => "2022-10-17 09:04:17"
    "articulo" => "Caja clips nro 1"

What do I get by:

$data = Operacion::join('articulos as a', 'a.id', 'operaciones.articulo_id')
            ->select('operaciones.*', 'a.nombre as articulo')
            ->whereBetween('operaciones.created_at', [$from, $to])
            ->when($artId > 0, function($query) use($artId){
                return $query->where('articulo_id', $artId);
            
            })
            ->get();

Now, I want to group by first articulo_idand then by almacen_idso that I have something like this in a view, (this would go inside a table):

Artículo 1
          Almacén 1
                   created_at   comentario   cantidad   onhand
                   created_at   comentario   cantidad   onhand
                   created_at   comentario   cantidad   onhand
          Almacén 2
                   created_at   comentario   cantidad   onhand
                   created_at   comentario   cantidad   onhand

I tried to do it by

foreach ($data as $k => $operacion) {
        $operaciones[$operacion['articulo_id']][$k] = $operacion['comentario'];

    }

But from that I don't know how to bring me everything and then group it by store or display it in a view the way I want.

I don't know if there is any other way to achieve this, if you could help me I would really appreciate it.

php

1 Answers

  1. Best Answer

    try this

    $articulos = [];
foreach ($data as $k => $operacion) {
    $articulos[$operacion['articulo']][$operacion['almacen_id']][] = $operacion;
}
print_r($artículos);

    And that will return an array something like this:

    [
    "Caja clips nro 1" => [
        "1" => [["articulo_id" => 23,
                "almacen_id" => 1,
                "transtype" => "TR",
                "comentario" => "Transferencia origen 5",
                "trans_id" => 5,
                "cantidad" => -5,
                "onhand" => 10,
                "created_at" => "2022-10-17 09:04:17",
                "updated_at" => "2022-10-17 09:04:17",
                "articulo" => "Caja clips nro 1",
               ]],
        "2" => [["articulo_id" => 23
                "almacen_id" => 2
                "transtype" => "TR"
                "comentario" => "Transferencia destino 5"
                "trans_id" => 5
                "cantidad" => 5
                "onhand" => 5
                "created_at" => "2022-10-17 09:04:17"
                "updated_at" => "2022-10-17 09:04:17"
                "articulo" => "Caja clips nro 1"
                ]]
    ]
]

    where, if you then write this:

    $articulo = "Caja clips nro 1";
$almacen_id = "2";
echo $articulos[$articulo][$almacen_id][0]['created_at'];

    will return the date of the first record of that item in that store.

    And so with all other fields.

    How to generate the table

    As for how to show it in the view as a table, I understand that you must pass that variable $articles to the view and go through it like this:

    <table>
<thead></thead>
<tbody>
@foreach ($articulos as $articulo => $almacen)
    <tr><td colspan="4"><h3>Artículo {{$articulo}}</h3></td></tr>
  @foreach ($almacen as $almacen_id => $operaciones)
    <tr><td colspan="4"><h5>Almacen {{$almacen_id}}</h5></td></tr>
    @foreach ($operaciones as $index => $operacion)
    <tr>
      <td>{{$operacion['created_at']}}</td>
      <td>{{$operacion['comentario']}}</td>
      <td>{{$operacion['cantidad']}}</td>
      <td>{{$operacion['onhand']}}</td>
    </tr>
    @endforeach
  @endforeach
@endforeach
</tbody>
</table>

    As I said in the comments, I don't know laravel or blade, but I understand that you can nest foreach in blade and go through that array.

    I'm telling you all of this blindly, because I can't reproduce your environment, but a loop is a loop and I can have syntax errors, but I don't think so in terms of logic.

    Try to see if it works for you as I have exposed it now.

    • 2