Miguel Angel Blanco Gonzalez's questions

1 operation: Through a select->option I load information to a div which will contain a form and within said form a table with a general checkbox that controls whether all the checkboxes of the table have to be marked or not and then has a checkbox per face row along with info.

2 The problem: when editing, I correctly fill in the select->option but I can't get the corresponding checkboxes to be marked, in fact I can't get any checkbox to be marked.

I have removed certain functions that did not paint much like the ajax that sent the data to the server

vista Blade

<div class="container col">
    <div class="card subCabeceraModal">
        <div class="row">
            <div class="col">
                <select class="form-control" id="clienteFusion">
                    <option value="">Selecciona un Cliente</option>
                    @foreach ($clientes as  $var)
                        <option value="{{ $var->idCliente }}">{{ Str::length($var->cliente) >30?  Str::substr($var->cliente, 0, 30).'....':$var->cliente}}</option>
                    @endforeach
                </select>
            </div>
        </div>

        <div class="row">
            <div class="col" id="engancheOfertas">
                <div id="tablaOfertas" style="height: 700px">
                @if($ventas!='')
                <div class="table-responsive" style="height: 500px">
                    <form id="fusionOfertasForm" name="fusionOfertasForm">
                        @csrf
                        <table class="table tablaPersonalizada table-bordered table-striped mb-0" style="overflow-y:auto;">
                            <thead>
                                <tr>
                                <th scope="col" class="col-1 cabeceraTabla">
                                        <input  type="checkbox" id="selectAllFusionOferta" name="selectAllFusionOferta">
                                </th>
                                <th scope="col" class="col-1 cabeceraTabla">ID</th>
                                <th scope="col" class="col-2 cabeceraTabla">FECHA</th>
                                <th scope="col" class="col-2 cabeceraTabla">TIPO</th>
                                <th scope="col"class="col-7 cabeceraTabla">OBSERVACIONES</th>
                                </tr>
                            </thead>
                            <tbody>
                                    @foreach ($ventas  as $venta)
                                        <tr id="{{$venta->oferta->idOferta}}">
                                            <td>
                                                <input  type="checkbox" class="selectFusionOferta" value="{{ $venta->oferta}}" name="selectFusionOferta[]">
                                            </td>
                                            <th scope="row">{{$venta->oferta->idOferta}} </th>
                                            <td>   {{ date("j-n-Y", strtotime($venta->oferta->fechaEnvioOfertaInicial))}} </td>
                                            <td>{{$venta->tipo}}</td>
                                            <td> {{$venta->oferta->observaciones}}</td>
                                        </tr>
                                    @endforeach
                            </tbody>
                        </table>
                        <div class="col mt-3">
                            <button id="fusionOfertasFormBoton" type="button" class="btn btn-success">Fusión</button>
                        </div>
                 

                    </form>
                </div>
                  @endif
       
<script>
    $(function(){
        let validacion=0;
        $('#clienteFusion').on('change', function(){
            addInfoTabla($('#clienteFusion').val());
        });
        //selectores
        $('#engancheOfertas').on('change', '#selectAllFusionOferta',function(){
            $('input:checkbox').not(this).prop('checked', this.checked);
            $('#fusionOfertasFormBoton').attr('disabled', false);
        })
        function editar(){
            let editarCliente_id= <?php echo isset($editarCliente_id)?$editarCliente_id:0; ?> ;
            let editarOfertas_id=  <?php echo  isset($editarOfertas_id)?json_encode($editarOfertas_id):0; ?>;
            let ruta= "{{ $ruta ?? '' }}";
            if (editarCliente_id!=0 && editarOfertas_id!=0 && ruta!='') {
               console.log(editarOfertas_id);

                //Cargo la informacion en los respectivos sitios
                    //select
                    $('#clienteFusion').val(editarCliente_id);
                    addInfoTabla($('#clienteFusion').val());
            }
        }
        editar();
        function addInfoTabla(cliente){
            $.get('/ofertas-crear-grupos',{cliente: cliente } , function(respuesta){
                        $("#tablaOfertas").html( $(respuesta).find(' #tablaOfertas'));
                        validacion= $("#fusionOfertasForm").validate({debug: true,rules:{"selectFusionOferta[]":{required:true}}});
                    });
        }





    });
</script>
 

I have an Array with this structure

 3 => {#631 ▼
      +"id": 20
      +"cliente": "Juan Pérez"
      +"codigo": "01/A2"
    }
    4 => {#1038 ▼
      +"id": 20
      +"cliente": "Juan Pérez"
      +"codigo": "01/A3"
    }
    5 => {#1249 ▼
      +"id": 20
      +"cliente": "Juan Pérez"
      +"codigo": "01/A1"
    }
    6 => {#1248 ▼
      +"id": 19
      +"cliente": "Autoescuelas Perez S.L"
      +"codigo": "01/A3"
    }
    7 => {#1251 ▼
      +"id": 19
      +"cliente": "Autoescuelas Perez S.L"
      +"codigo": "01/A1"
    }
    8 => {#1252 ▼
      +"id": 19
      +"cliente": "Autoescuelas Perez S.L"
      +"codigo": "01/A2"
    }
    9 => {#1253 ▼
      +"id": 18
      +"cliente": "bfsfdgsdfg"
      +"codigo": "01/A2"
    } 

I need to transform it into this:

 3 => {#631 ▼
      +"id": 20
      +"cliente": "Juan Pérez"
      +"codigo": "01/A2,01/A3,01/A1"
    }
6 => {#1248 ▼
      +"id": 19
      +"cliente": "Autoescuelas Perez S.L"
      +"codigo": "01/A2,01/A3,01/A1"
    }
 9 => {#1253 ▼
      +"id": 18
      +"cliente": "bfsfdgsdfg"
      +"codigo": "01/A2"
    } 

I've tried several things but none of them worked fairly well or even worked, what's more I don't even know how to do it the truth because if you make a loop to the same id and extract the code part, use the + operator to join the two codes it didn't work for me So I really don't know how to deal with this. I have tried this:

 $ite=0;
        for ($i=0; $i <count($ventas) ; $i++) {
            if ($ite < count($ventas)-1) {
                $ite++;
            }
            if ($ventas[$i]->id==$ventas[$ite]->id) {
                $ventas[$i]->codigo=$ventas[$i]->codigo." ".$ventas[$ite]->codigo;
                
            }
        }

But it's not even remotely close to what I need

I have a table sales_orders in this table I have 3 important fields:

• housing(numeric)
• status(enum)
• shipping_status(enum)

I need to make a query that filters me by the state when it is active and that the housing field is different from zero, but that nullreturns them, that is, to clarify a bit the query would be something like this:

$venta=venta_pedidos::where('estado','aceptado')->where('vivenda','!=',0)->where('estado_envio','pendiente')->get();

But with this it does not return the ones nullfrom the housing field and if I enter the function it orWhereNull()uses all of them nullwithout exception, it does not look at the state they are in.

I am doing a filter for the search engine in a section I have: table A and table B related by 1 to n. table A -> A_id(Primary)... table B->B_id(Primary),A_id(foreing),customerId(foreing)...

I access from table A to the data in table B via the model so I'm forced to use the model and I can't use a db::table because I have all the functionality implemented and would have to redo it.

The filter for the search engine is based on looking in table B for records that match the id that I pass and they would look in the clientId column so that it returns me the info from table A

Then I use that query to search table B and return the model related to table A in such a way that if the client is in two rows of table A, it returns those rows.

$consulta=A::where('A_id', function($consulta) use($request) {  $consulta->select('A_id')->from('B')->where('cliente_id', $request->cliente )->first();} )->paginate($this->numeroRegistrosPagina);

Currently this query fails if you remove first() it gives an error cardinality violation: 1242 Subquery returns more than 1 row because the subquery returns more than one row and it is normal since the clients can be in more than one row of the table A. So how can I fix this? Model B can be used since it also has the id of table A.

Thank you all