Karelix Alejandra's questions

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.

I have a kind of purchase page where the income of the products to the stores is registered:

The suppliers table has a data called 'retencion'which is the withholding percentage that has to be subtracted from the total to pay, it can be 0%, 75% or 100%; Now, when I change the select option, I need it to bring me the retention and perform the calculation, but it is not doing it, instead it places a value NaNthat I understand means 'not a number'.

My controller Proveedorhas this:

public function get_proveedor_by_id(Request $request)
{
    if ($request->ajax()) {
        $proveedors = Proveedor::findOrFail($request->proveedor_id);
        return response()->json($proveedors);
    }
}

My functions:

var proveedor_id = $('#proveedor_id');
    proveedor_id.change(function() {
        $.ajax({
            url: "{{ route('get_proveedor_by_id') }}",
            method: 'GET',
            data: {
                proveedor_id: proveedor_id.val(),
            },
            success: function(data) {
                $("#retencion").val(data.retencion);
            }
        });
    });

To calculate totals:

function totales() {
        $("#subtotal").html("$ " + subtotalapagar.toFixed(2));
        subtotal_pagar = subtotalapagar;
        $("#subtotal_pagar_html").html("$ " + subtotal_pagar.toFixed(2));
        $("#subtotal_pagar").val(subtotal_pagar.toFixed(2));

        retencion = $("#retencion").val;

        retencionapagar = subtotal * (retencion / 100);
        $("#retencion").html("$ " + retencionapagar.toFixed(2));
        $("#retencion_pagar_html").html("$ " + retencionapagar.toFixed(2));
        $("#retencion_pagar").val(retencionapagar.toFixed(2));

        impuesto = subtotalapagar * 0.16;
        $("#impuesto").html("$ " + impuesto.toFixed(2));
        impuesto_pagar = impuesto;
        $("#impuesto_pagar_html").html("$ " + impuesto_pagar.toFixed(2));
        $("#impuesto_pagar").val(impuesto_pagar.toFixed(2));

        $("#total").html("$ " + total.toFixed(2));
        total_pagar = total + impuesto;
        $("#total_pagar_html").html("$ " + total_pagar.toFixed(2));
        $("#total_pagar").val(total_pagar.toFixed(2));

        tasa = $("#tasabs").val();

        total_pagarbs = tasa * total_pagar;

        $("#totalbs").html("Bs. " + total_pagarbs.toFixed(2));
        $("#total_pagar_htmlbs").html("Bs. " + total_pagarbs.toFixed(2));
        $("#total_pagarbs").val(total_pagarbs.toFixed(2));
    }

What am I doing wrong?

I have a popup where I have a series of articles; In turn, I have a select (if the item is associated with more than one warehouse) to select the warehouse from which it is required to order and a function so that when selecting it, it shows you the available quantity of that item.

The problem is that if I place myself on another page of the table other than the first, the select does not perform any action on me, if I select to show me all the articles on a page it does so without problems, but being in another no longer works, what am I doing wrong?

Here is my table:

<table class="table table-striped mt-0.5 table-bordered shadow-lg mt-4" id="articulo">
    <thead class="bg-primary text-white">
        <tr>
            <th scope="col" width="60px">Código</th>
            <th scope="col">Imagen</th>
            <th scope="col">Nombre</th>
            <th scope="col">Categoría</th>
            <th scope="col">Almacén</th>
            <th scope="col">Disponible</th>
            <th scope="col">Cantidad</th>
            <th scope="col">Acciones</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($articulos as $articulo)
            <tr>
                <td>{{ $articulo->codigo }}</td>
                @if (isset($articulo->imagen))
                    <td class="text-center">
                        <img src="/imagen/{{ $articulo->imagen }}" style="height: 50px; width: 50px; border-radius: 20%;">
                    </td>
                @else
                    <td class="text-center">
                        <img src="/imagen/caja.png" alt="" width="70" height="70">
                    </td>
                @endif
                <td>{{ Str::ucfirst($articulo->nombre) }}</td>
                <td>{{ Str::ucfirst($articulo->categoria->nombre) }}</td>
                @if ($articulo->detallearticulos()->count() > 1)
                    <td>
                        <select class="form-control js-almacen-id" name="almacen_id" id="almacen_id" lang="es" index={{ $loop->index }} data-articulo-id={{ $articulo->id }}>
                            <option value="" data-icon="fas fa-box" disabled selected>Buscar almacén</option>
                            @foreach ($detallearticulos as $detallearticulo)
                                @if ($detallearticulo->articulo_id == $articulo->id)
                                    <option value="{{ $detallearticulo->almacen_id }}">{{ $detallearticulo->almacen_id }} - {{ $detallearticulo->almacen->nom_alm }}</option>
                                @endif
                            @endforeach
                        </select>
                    </td>
                    <td style="width: 50px;">
                        <input type="text" name="stock" id="stock" class="form-control js-stock" disabled>
                    </td>
                @elseif ($articulo->detallearticulos()->count() == 1)
                    <td>
                        @foreach ($detallearticulos as $detallearticulo)
                            @if ($detallearticulo->articulo_id == $articulo->id)
                                <input type="text" class="form-control js-almacen-nombre" name="almacen_id" id="almacen_id" readonly value="{{$detallearticulo->almacen->nom_alm}}">
                                <input type="hidden" class="form-control js-almacen-id" name="almacen_id" id="almacen_id" readonly value="{{$detallearticulo->almacen_id}}">
                            @endif
                        @endforeach
                    </td>
                    <td>
                        @foreach ($detallearticulos as $detallearticulo)
                            @if ($detallearticulo->articulo_id == $articulo->id)
                               <input type="text" value="{{ $detallearticulo->disponible }}" name="stock" id="stock" class="form-control js-stock" disabled>
                            @endif
                        @endforeach
                    </td>
                @endif
                <td>
                    <input type="number" class="form-control js-cantidad" min="0" max="1000" name="cantidad" step="1" oninput="validity.valid || (value = '')">
                    @if ($errors->has('cantidad'))
                        <div class="alert alert-danger">
                            <span class="error text-danger">{{ $errors->first('cantidad') }}</span>
                        </div>
                    @endif
                </td>
                <td class="text-right">
                    <input type="hidden" class="form-control js-articulo-id" name="articulo_id" value="{{ $articulo->id }}">
                    <input type="hidden" class="form-control js-articulo-nombre" name="articulo_nombre" value="{{ $articulo->nombre }}">
                    <div class="form-group">
                        <button type="button" class="btn btn-info float-right mt-1 js-agregar">
                            <i class="fas fa-check"></i>Agregar
                        </button>
                    </div>
                </td>
            </tr>
        @endforeach
    </tbody>
</table>

and my find function:

$('.table').on('change', '.js-almacen-id', mostrarValores);

function mostrarValores() {
    datosProducto = document.getElementById('almacen_id').value.split('_');
    $('.js-stock').fila.val(datosProducto[1]);
};

var almacen_id = $('.js-almacen-id');

almacen_id.change(function(event) {
    const index = $(event.target).attr('index');
    const articulo_id = $(event.target).attr('data-articulo-id');

    $.ajax({
        url: "{{ route('get_products_by_id') }}",
        method: 'GET',
        data: {
            almacen_id: event.target.value,
            //Añades tu el id de tu articulo a tu solicitud HTTP
            articulo_id: articulo_id
        },
        success: function(data) {
            $('.js-stock').eq(index).val(data.disponible);
            $('.js-almacen-id').eq(index).val(data.almacen_id);
            $('.js-articulo-id').eq(index).val(data.articulo_id);
        }
    });
});

The warehouse area gives you almacen_idwhat it is looking for in the database, the quantity of the item available, and then writes it to you in the 'available' part

I think the problem is that I have a loop->indexin the table and $('.js-almacen-id').eq(index).val(data.almacen_id);he is writing the stock to me in that 'position' in the table, how can I make the index take it as the row in which it is placed?

I have 4 tables, users, almacenes, detalle_alma_usersand detalle_articulos; are related in this way:

I have a sales system, and I want that according to the warehouses to which the logged in user is related, only the articles that are related to that warehouse appear. It's giving me the error Property [almacen_id] does not exist on this collection instance.And I think it's because of the way I'm using ->where()it but I'm not sure how to do it and I haven't found anything on the internet.

My relationships are like this:

users

public function almacen()
{
    return $this->hasMany(Almacen::class);
}

public function detallealmausers(){
    return $this->hasMany(DetalleAlmaUser::class);
}

almacenes

public function detallealmausers(){
    return $this->hasMany(DetalleAlmaUser::class);
}

public function user(){
    return $this->belongsTo(User::class);
}

detalle_alma_users

  public function almacen(){
    return $this->belongsTo(Almacen::class);
}

public function user(){
    return $this->belongsTo(User::class);
}

And my controller VentaControlleris the following:

public function create()
{
    $user = Auth::user();
    $clientes = Cliente::where('user_id',Auth::user()->id)->get();
    $detallearticulos = DetalleArticulo::where('almacen_id','=',$user->detallealmausers->almacen_id)->get();
    $articulos = Articulo::where('estado', 'ACTIVO')->get();
    $venta = Venta::get();
    return view('admin.venta.create', compact('clientes', 'detallearticulos', 'articulos', 'venta'));
}

I have a table of items:

As you can see, there is a warehouse area since I am working with an inventory system where an item can be stored in one or more warehouses, and depending on the warehouse, the available stock is different. My goal is that when I select the warehouse in the select, the stock that that item has available within the selected warehouse is shown to me, and while in the first one it works for me, in any other row it does not. And if, in addition, I click on 'add' later it does not continue to do the function, nothing appears. Could you help me?

This is my function:

$(".js-agregar").on("click", function(){
        fila = $(this).closest("tr");
        agregar(fila);
    });

    var cont = 1;
    total = 0;

    $("#guardar").hide();
    $(".js-almacen-id").change(mostrarValores);

    function mostrarValores() {
        datosProducto = document.getElementById('almacen_id').value.split('_');

        $("#stock").val(datosProducto[1]);
    };

    var almacen_id = $('.js-almacen-id');

    almacen_id.change(function(event) {
    const index = $(event.target).attr('index')
    var articulo_id = $(event.target).attr('.js-articulo-id')
    $.ajax({
            url: "{{ route('get_products_by_id') }}",
            method: 'GET',
            data: {
                almacen_id: event.target.value,
            },
            success: function(data) {

                $(".js-stock").eq(index).val(data.disponible);
                $(".js-almacen-id").eq(index).val(data.almacen_id);
                $(".js-articulo-id").eq(index).val(data.articulo_id);
            }
        });

    });

And my add to cart function:

function agregar(fila) {

        articulo_id = fila.find(".js-articulo-id").val();
        articulo = fila.find(".js-articulo-nombre").val();
        cantidad = fila.find(".js-cantidad").val();
        almacen_id = fila.find(".js-almacen-id").val();
        stock = $("#stock").val();

        if (articulo_id != "" && cantidad != "" && cantidad > 0 && articulo_id != null) {
            if (parseInt(stock) >= parseInt(cantidad)) {
                subtotal[cont] = cantidad * precio_compra;
                total = total + subtotal[cont];
                var fila = '<tr class="selected" id="fila' + cont +
                    '"><td><button type="button" class="btn btn-danger btn-sm" onclick="eliminar(' + cont +
                    ');"><i class="fas fa-trash-alt"></i></button></td><td><input type="hidden" name="articulo_id[]" value="' +
                    articulo_id + '">' + articulo +
                    '</td><td> <input type="hidden" name="almacen_id[]" value="' + almacen_id +
                    '"> <input class="form-control" type="number" value="' + almacen_id +
                    '" disabled> </td><td> <input type="number" class="form-control" name="cantidad[]" value="' + cantidad +
                    '"></td> <td><input type="text" name="comentario[]" class="form-control" required></td></tr>';
                cont++;
                limpiar();
                totales();
                evaluar();
                $('#detalles').append(fila);
            } else {
                Swal.fire({
                    icon: 'error',
                    cancelButtonColor: '#d33',
                    text: 'La cantidad a vender supera el stock.',

                })
            }
        } else {
            Swal.fire({
                icon: 'error',
                cancelButtonColor: '#d33',
                text: 'Rellene todos los campos del detalle del pedido.',

            })
        }
    }

And so is the get_products_by_idin my item controller:

public function get_products_by_id(Request $request)
{
    if ($request->ajax()) {
        $articulos = DetalleArticulo::where('almacen_id', $request->almacen_id, 'articulo_id', $request->articulo_id)->firstOrFail();
        return response()->json($articulos);
    }
}

My item table is as follows:

<table class="table table-striped mt-0.5 table-bordered shadow-lg mt-4" id="articulo">
                <thead class="bg-primary text-white">
                    <tr>
                        <th scope="col" width='60px'>Código</th>
                        <th scope="col">Imagen</th>
                        <th scope="col">Nombre</th>
                        <th scope="col">Categoría</th>
                        <th scope="col">Almacén</th>
                        <th scope="col">Disponible</th>
                        <th scope="col">Cantidad</th>
                        <th scope="col">Acciones</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($articulos as $articulo)
                        <tr>
                            <td>{{ $articulo->codigo }}</td>
                            @if (isset($articulo->imagen))
                                <td class="text-center">
                                    <img src="/imagen/{{$articulo->imagen}}" style="height: 50px; width: 50px; border-radius: 20%;">
                                </td>
                            @else
                                <td class="text-center"><img src="/imagen/caja.png"
                                        alt="" width="70" height="70"></td>
                            @endif
                            <td>{{ Str::ucfirst($articulo->nombre) }}
                            </td>
                            <td>{{ Str::ucfirst($articulo->categoria->nombre) }}</td>
                            <td>
                            <select class="form-control selectpicker articuloB js-almacen-id" data-live-search="true" name="almacen_id" id="almacen_id" lang="es" index={{$articulo->id}}>
                                <option value="" data-icon="fas fa-box" disabled selected>Buscar almacén</option>
                                @foreach ($detallearticulos as $detallearticulo)
                                @if ($detallearticulo->articulo_id == $articulo->id)
                                <option value="{{ $detallearticulo->almacen_id }}">{{ $detallearticulo->almacen_id }} - {{ $detallearticulo->almacen->nom_alm }}</option>
                                @endif
                                @endforeach
                            </select>
                            </td>
                            <td style="width: 50px;">
                                    <input type="text" name="stock" id="stock" class="form-control js-stock" disabled>
                            </td>
                            <td>
                                <input type="number" class="form-control js-cantidad" min="0" max="100" name="cantidad" step="1"
                                    oninput="validity.valid||(value='')">
                                @if ($errors->has('cantidad'))
                                    <div class="alert alert-danger">
                                        <span class="error text-danger">{{ $errors->first('cantidad') }}</span>
                                    </div>
                                @endif
                            </td>
                            <td class="text-right">
                                <input type="hidden" class="form-control js-articulo-id" name="articulo_id" value="{{$articulo->id}}">
                                <input type="hidden" class="form-control js-articulo-nombre" name="articulo_nombre" value="{{$articulo->nombre}}">
    
                                <div class="form-group">
                                    <button type="button" class="btn btn-info float-right mt-1 js-agregar"><i class="fas fa-check"></i>Agregar</button>
                                </div>                             
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>

I have the following table of articles which I want to add to another table that works as a 'cart':

<table id="articulo">
        <thead class="bg-primary text-white">
            <tr>
                <th scope="col" width='60px'>Código</th>
                <th scope="col">Imagen</th>
                <th scope="col">Nombre</th>
                <th scope="col">Categoría</th>
                <th scope="col">Almacén</th>
                <th scope="col">Cantidad</th>
                <th scope="col">Precio</th>
                <th scope="col">Acciones</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($articulos as $articulo)
                <tr>
                    <td>{{ $articulo->codigo }}</td>
                    @if (isset($articulo->imagen))
                        <td class="text-center">
                            <img src="/imagen/{{$articulo->imagen}}" style="height: 50px; width: 50px; border-radius: 20%;">
                        </td>
                    @else
                        <td class="text-center"><img src="/imagen/caja.png"
                                alt="" width="70" height="70"></td>
                    @endif
                    <td>{{ Str::ucfirst($articulo->nombre) }}
                    </td>
                    <td>{{ Str::ucfirst($articulo->categoria->nombre) }}</td>
                    <td>
                    <select class="form-control" name="almacen" id="almacen">
                        @foreach ($detallearticulos as $detallearticulo)
                        @if ($detallearticulo->articulo_id == $articulo->id)
                        <option value="{{ $detallearticulo->almacen_id }}">{{ $detallearticulo->almacen->nom_alm }}</option>
                        @endif
                        @endforeach
                    </select>
                    </td>
                    <td>
                        <input type="number" class="form-control" min="0" max="100" name="cantidad" id="cantidad" step="1"
                            oninput="validity.valid||(value='')">                     
                    </td>
                    <td>
                        <input type="number" class="form-control" min="0" max="10000" name="precio_compra" id="precio_compra"
                            placeholder="0.00" step="0.25" >
                    </td>
                    <td class="text-right" style="width: 220px;">
                        <input type="hidden" name="articulo_id" id="articulo_id" value="{{$articulo->id}}">
                        <input type="hidden" name="articulo_nombre" id="articulo_nombre" value="{{$articulo->nombre}}">

                        <div class="form-group">
                            <button type="button" id="agregar" class="btn btn-info float-right mt-1"> <i class="fas fa-check"></i>
                                Agregar</button>
                        </div>                             
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>

What I need is that from a modal with a table the articles are added to another table dynamically, but in my case the add button only works for the first row, and in the rest of the rows it does not perform any action, What I can do? I don't know if the error is inside the table or in the add function.

My add function is as follows:

function agregar() {
        articulo_id = $("#articulo_id").val();
        articulo = $("#articulo_nombre").val();
        cantidad = $("#cantidad").val();
        precio_compra = $("#precio_compra").val();

        if (articulo_id != "" && cantidad != "" && cantidad > 0 && precio_compra != "" && articulo_id != null) {
            if (precio_compra <= 10000) {
                subtotal[cont] = cantidad * precio_compra;
                total = total + subtotal[cont];
                var fila = '<tr class="selected" id="fila' + cont +
                    '"><td><button type="button" class="btn btn-danger btn-sm" onclick="eliminar(' + cont +
                    ');"><i class="fas fa-trash-alt"></i></button></td><td><input type="hidden" name="articulo_id[]" value="' +
                    articulo_id + '">' + articulo +
                    '</td> <td> <input type="hidden" id="precio_compra[]" name="precio_compra[]" value="' +
                    precio_compra + '"> <input class="form-control" type="number" id="precio_compra[]" value="' +
                    precio_compra +
                    '" disabled> </td>  <td> <input type="hidden" name="cantidad[]" value="' + cantidad +
                    '"> <input class="form-control" type="number" value="' + cantidad +
                    '" disabled> </td> <td align="right">Bs ' + parseFloat(subtotal[cont]).toFixed(2) + ' </td></tr>';
                cont++;
                limpiar();
                totales();
                evaluar();
                $('#detalles').append(fila);
            }

If you could help me I would appreciate it very much.

I have an inventory system which has an order system, so that an employee can request X product.

The data is taken by the form:

But I don't know how to reference the 'quantity' data so that it is saved

This is myCartController

 public function add(Request $request){
   
    $producto = Producto::find($request->id);

    $userId = auth()->user()->id; // or any string represents user identifier
    Cart::add(
        $producto->id, 
        $producto->descripcion, 
        "quantity"->quantity
       
    );
    return back();

}

The error it gives me is:Attempt to read property "quantity" on string

I'm using DarrylCode's ShoppingCart package and I'm having a problem when adding to cart, because for some reason it doesn't add the first product in the table, but when I add another from any other position it lets me add it.

My add function:

public function add(Request $request){
   
    $producto = Producto::find($request->id);

    Cart::add(
        $producto->id, 
        $producto->descripcion, 
        $producto->quantity = 1, 
       
    );
    return back();

}

My table:

<table id="productosexistentes" class="table table-striped table-bordered shadow-lg nt-4">
                <thead>
                    <tr>
                        <th scope="col">ID</th>
                        <th scope="col">Imagen</th>
                        <th scope="col">Código</th>
                        <th scope="col">Descripción</th>
                        <th scope="col">Stock</th>
                        <th scope="col"></th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($productos as $producto)
                    <tr>
                        <td>{{$producto->id}}</td>
                        <td>
                            <img src="/imagen/{{$producto->imagen}}" style="height: 50px; width: 50px; border-radius: 20%;">
                        </td>
                        <td>{{$producto->codigo}}</td>
                        <td>{{$producto->descripcion}}</td>
                        <td>{{$producto->cantidad}}</td>
                        <td>
                            <form action="{{route('cart.add')}}" method="POST" enctype="multipart/form-data">
                                @csrf
                                <input type="hidden" value="{{ $producto->id }}" name="id">
                                <input type="hidden" value="{{ $producto->descripcion }}" name="descripcion">
                                <input type="hidden" value="{{ $producto->cantidad }}"  name="cantidad">
                                <input type="hidden" value="{{ 1 }}" name="quantity">
                                <div class="flex justify-center rounded-lg" role="group">
                                    <button class="px-4 py-2 text-white bg-blue-800 rounded">Agregar</button>
                                </div>
                            </form>
                        </td>
                    </tr>
                    @endforeach
                </tbody>
            </table>

I only have that problem with the first data, and I don't understand what could be happening to me. I have tried to delete it and see if it was an error with that product, but it does not add me it is the first product that is in the table.

When I hit the add button, it doesn't do anything for me, but only in the first data. If I add another one and then try to add the first one it does let me add it.

I have a table:

<table id="productos" class="table table-striped table-bordered shadow-lg nt-4 display responsive nowrap" style="width:100%">
        <thead>
            <tr>
                <th scope="col">ID</th>
                <th scope="col">Imagen</th>
                <th scope="col">Código</th>
                <th scope="col">Categoría</th>
                <th scope="col">Descripción</th>
                <th scope="col">Stock</th>
                <th scope="col">Solicitado</th>
                <th scope="col">Acciones</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($productos as $producto)
            <tr>
                <td>{{$producto->id}}</td>
                <td>
                    <img src="/imagen/{{$producto->imagen}}" style="height: 50px; width: 50px; border-radius: 20%;">
                </td>
                <td>{{$producto->codigo}}</td>
                <td>{{$producto->categorias->categoria}}</td>
                <td>{{$producto->descripcion}}</td>
                <td>{{$producto->cantidad}}</td>
                <td>{{$producto->solicitudes}}</td>
                <td>
                    <div class="flex justify-center rounded-lg text-lg" role="group">
                        <a href="/productos/{{ $producto->id}}/edit" class="rounded bg-blue-500 hover:bg-blue-600 text-white py-1 px-2">Editar</a>
                        <form action="{{ route('productos.destroy', $producto->id) }}" method="POST" class="formEliminar">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="rounded bg-red-400 hover:bg-red-500 text-white py-1 px-2">Borrar</button>
                        </form>
                    </div>
                </td>
            </tr>
                
            @endforeach
        </tbody>
    </table>

to which I want to add buttons to export to excel, pdf, etc., and while with the code of the following form the buttons appear:

$(document).ready(function() {
            $('#productos').DataTable({
                dom: 'Bfrtip',
                    buttons: [
                        'copy', 'csv', 'excel', 'pdf'
                    ],

                
                language: {
                    "lengthMenu": "Mostrar _MENU_ registros",
                    "zeroRecords": "No se encontraron resultados",
                    "info": "Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros",
                    "infoEmpty": "Mostrando registros del 0 al 0 de un total de 0 registros",
                    "infoFiltered": "(filtrado de un total de _MAX_ registros)",
                    "sSearch": "Buscar:",
                    "oPaginate": {
                        "sFirst": "Primero",
                        "sLast": "Último",
                        "sNext": "Siguiente",
                        "sPrevious": "Anterior"
                    },
                    "sProcessing": "Procesando...",
                },  
                
                });
            });

when i want to use

exportOptions: {
                columns: [1,3,4,5,6,7]
               }

To modify the print format. the buttons disappear, just like when I type the ' buttons' part in another way.

This is what I have referenced on the page:

@section('css')
    <link rel="stylesheet" href="/css/admin_custom.css">
    <link href="https://cdn.datatables.net/1.12.1/css/dataTables.bootstrap5.min.css" rel="stylesheet">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.min.css"> <script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
            
@stop

@section('js')
      <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
      <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script>
      <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.flash.min.js"></script>
      <script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
      <script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
      <script type="text/javascript" language="javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
      <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js"></script> 
@stop   

I need to create an order system for the staff of a company, each user has one or more employees associated with it. Within the orders, the employees associated with the user must be shown.

The problem is that when it shows me the data, it does not bring me any employee.

The order controller:

public function create()
    {
        $users = User::all();
        $empleados = Auth::user()->empleados;
        $productos = Producto::all();

        return view('pedido.create', compact('empleados','productos', 'users')); 
    }

The order view:

<input id="id_usuario" name="id_usuario" type="text" class="form-control" value="{{auth()->user()->name}}" readonly>
                <div>
                    <label for="" class="form-label">Empleado:<p></label>
                    <select name="id_empleado" class="form-control">
                        <option value="">-- Seleccione el empleado -- </option>
                        @foreach ($empleados as $empleado) 
                            <option value="{{ $empleado->id }}">{{ $empleado->nombre }}</option>
                        @endforeach

                    </select>

Model used:

class Empleado extends Model
{
    use HasFactory;
    protected $fillable = ['nombre', 'id_user', 'cargo', 'departamento', 'empresa'];

    public function users(){
        return $this->belongsTo(User::class, 'id_user', 'id');
    }

    public function pedidos(){
        return $this->hasMany(Pedido::class, 'id', 'id_empleado');
    }
}

User model:

class User extends Authenticatable
{
public function empleados(){
        return $this->hasMany(Empleado::class, 'id', 'id_user');
    }
}

I am making an inventory system with Laravel 9, and I have a 'categories' table that is associated with a 'products' table since these fall into the categories that one creates. The category id is stored in the product and what I want is that in the index where the data is displayed, instead of showing the category id number, it shows me the name.

Model Product

 public function categorias(){
        return $this->belongsTo(Categoria::class, 'id');
    }

Model Category

public function productos(){
        return $this->hasMany(Producto::class, 'id_cat');
    }

ProductController

public function index()
    {
        $categorias = Categoria::all();
        $productos = Producto::with('categorias')->get();
        
        return view('producto.index', compact('categorias','productos')); //->with('productos',$productos);
    }

View

<table id="productos" class="table table-striped table-dark table-bordered shadow-lg nt-4">
        <thead>
            <tr>
                <th scope="col">ID</th>
                <th scope="col">Imagen</th>
                <th scope="col">Código</th>
                <th scope="col">Categoría</th>
                <th scope="col">Descripción</th>
                <th scope="col">Stock</th>
                <th scope="col">Solicitado</th>
                <th scope="col">Acciones</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($productos as $producto)
            <tr>
                <td>{{$producto->id}}</td>
                <td>{{$producto->imagen}}</td>
                <td>{{$producto->codigo}}</td>
                <td>{{$producto->categoria->categoria}}</td>
                <td>{{$producto->descripcion}}</td>
                <td>{{$producto->cantidad}}</td>
                <td>{{$producto->solicitudes}}</td>
                <td>
                    <form action="{{route ('productos.destroy',$producto->id)}}" method="POST">
                        <a href="/productos/{{ $producto->id}}/edit" class="btn btn-info">Editar</a>
                        @csrf
                        @method('DELETE')
                        <button type="submit" class="btn btn-danger">Borrar</button>
                    </form>
                </td>
            </tr>
                
            @endforeach
        </tbody>
    </table>

In my ignorance, I understand that what is wrong would be

<td>{{$producto->categoria->categoria}}</td>

because there really isn't a 'category' in products, but I don't know how to make del id_cat = categoria.idtake the name of the category, the error it gives me is the following:

Attempt to read property "categoria" on null