René Merlo's questions

I am doing some tests to control the scroll in a div and I am not able to do the following: when I click a button, I want the scroll of a div to return to zero. Here's a brief overview of what I'm doing:

If I now press the Cancel or Save button, this screen will close and when I return to it from here:

clicking on NEW NEWS, I want the data loading screen to appear again set with the scroll at zero and I am not achieving it since it reappears with the scroll towards the bottom of the screen, where the user can see the buttons to save or cancel editing.

The code I am trying to use is the following:

  <script>
    function TopeCero(){
        var elem = document.getElementById('VentanaDtos');
        elem.scrollTo = 0;
    }
</script>

This is the code that triggers the ZeroTop function:

<div>
<div x-data="{AltaNuevaNoticia: $wire.AltaNuevaNoticia}">
    <button onclick="TopeCero()" wire:click="VerForm()" class="mr-2 inline-flex items-center px-4 py-2 bg-gray-800 border border-transparent rounded-md font-semibold text-xs text-white uppercase tracking-widest hover:bg-gray-700 active:bg-gray-900 focus:outline-none focus:border-gray-900 focus:ring focus:ring-gray-300 disabled:opacity-25 transition">NUEVA NOTICIA</button>

    <section class="modal" x-cloak x-show="AltaNuevaNoticia = $wire.AltaNuevaNoticia" x-transition.duration.700ms>
        <div id="VentanaDtos" class="modal__container1">
            <div class="apartado margenInf15">

Doing a console.log(), I can see that I got to that function, but it doesn't get set to zero by the scrollTo I'm trying to do on the div.

Thank you very much in advance and I look forward to your help.

I have come across the following requirement: I need to build a query via Eloquent that has to have one or more orWhere concatenated depending on certain vendor codes, I copy the query with which I am starting this:

                $pedidos = Vta_PedidosVendedor_34::with('relUsers')->where('estado', '=', '0')->
                where('OrderNumber', 'like', '%' . $this->buscar . '%')->
                whereBetween('date', [$fd, $fd])-> 
                orderBy($this->orden, $this->direccion)->
                paginate(15);

I explain a little more, each user who enters the system has the ability to see the orders of other users, for example if the user '34' enters he can see his orders + those of '15', '16' and '20', Now, when the user changes, for example he enters '40', he can only see the orders of '11' and his own, whose id is '40'. This is where I'm stuck, I don't know how to make this query dynamic. In other languages ​​(C#), what he did was build a select and through an array where he put the codes that should participate in the select, he was able to dynamically build the select. I can more or less reproduce this directly using DB::, but, there is always a but, this construction doesn't let me paginate, or at least I don't know how to do it.

Thank you very much in advance and I hope you can help me.

I need to fire events when a user initializes a session under Laravel, when he closes it or when the lifetime of said session expires. The reason why I need to do this is that I have to identify from a Control Panel, which users have an active session on the site. Reviewing in other posts, it is suggested to use events and from there this implementation idea arises, but if you have implemented this in another way or Laravel itself already has some magic command that can be used, I will be very grateful for the data. I apologize for not providing code for your review as I haven't started yet and am still reviewing alternatives.

Thank you very much in advance and best regards.

I am trying to create a json from a class created in php and I am not getting the expected result, I show you the code I am using and the result I get. Thank you very much in advance and I hope you can help me.

This is the class I want to use:

<?php

namespace App\ClasesEspeciales;

Class ClsItemsPed{
    
    private $ProductCode;
    private $SKUCode;
    private $VariantCode;
    private $Description;
    private $VariantDescription;
    private $Quantity;
    private $DiscountPercentage;
    private $UnitPrice;
    private $cantKilos;
    private $SelectMeasureUnit;
    private $MeasureCode;
    
    public function __construct(){
        $this->ProductCode = "";
        $this->SKUCode = "";
        $this->VariantCode = "";
        $this->Description = "";
        $this->VariantDescription = "";
        $this->Quantity = "";
        $this->DiscountPercentage = "";
        $this->UnitPrice = "";
        $this->cantKilos = "";
        $this->SelectMeasureUnit = "";
        $this->MeasureCode = "";
    }

    public function getProductCode(){
        return $this->ProductCode;
    }
    public function setProductCode($ProductCode){
        $this->ProductCode = $ProductCode;
    }
    
    public function getSKUCode(){
        return $this->SKUCode;
    }
    public function setSKUCode($SKUCode){
        $this->SKUCode = $SKUCode;
    }
    
    public function getVariantCode(){
        return $this->VariantCode;
    }
    public function setVariantCode($VariantCode){
        $this->VariantCode = $VariantCode;
    }
    
    public function getDescription(){
        return $this->Description;
    }
    public function setDescription($Description){
        $this->Description = $Description;
    }
    
    public function getVariantDescription(){
        return $this->VariantDescription;
    }
    public function setVariantDescription($VariantDescription){
        $this->VariantDescription = $VariantDescription;
    }
    
    public function getQuantity(){
        return $this->Quantity;
    }
    public function setQuantity($Quantity){
        $this->Quantity = $Quantity;
    }
    
    public function getDiscountPercentage(){
        return $this->DiscountPercentage;
    }
    public function setDiscountPercentage($DiscountPercentage){
        $this->DiscountPercentage = $DiscountPercentage;
    }
    
    public function getUnitPrice(){
        return $this->UnitPrice;
    }
    public function setUnitPrice($UnitPrice){
        $this->UnitPrice = $UnitPrice;
    }
    
    public function getcantKilos(){
        return $this->cantKilos;
    }
    public function setcantKilos($cantKilos){
        $this->cantKilos = $cantKilos;
    }
    
    public function getSelectMeasureUnit(){
        return $this->SelectMeasureUnit;
    }
    public function setSelectMeasureUnit($SelectMeasureUnit){
        $this->SelectMeasureUnit = $SelectMeasureUnit;
    }
    
    public function getMeasureCode(){
        return $this->MeasureCode;
    }
    public function setMeasureCode($MeasureCode){
        $this->MeasureCode = $MeasureCode;
    }
}

Here I show you the code that I am using, it should be noted that it is a functionality test, I am jarcoding the values ​​in order to be able to do tests, then the filling of the class with the real data will be completed.

$varPedido = new ClsPedido();

$varPedido->setOrderID('1');
$varPedido->setOrderNumber('1');
$varPedido->setDate('1');
$varPedido->setTotal('1');
$varPedido->setTotalDiscount('1');
$varPedido->setPaidTotal('1');
$varPedido->setFinancialSurcharge('1');
$varPedido->setWarehouseCode('1');
$varPedido->setSellerCode('1');
$varPedido->setTransportCode('1');
$varPedido->setSaleConditionCode('1');
$varPedido->setPriceListNumber('1');
$varPedido->setIvaIncluded('1');
$varPedido->setInternalTaxIncluded('1');
$varPedido->setCancelOrder('1');
$varPedido->setCancelReason('1');
$varPedido->setCancelDate('1');
$varPedido->setAgreedWithSeller('1');
$varPedido->setInvoiceCounterfoil('1');
$varPedido->setComment('1');
$varPedido->setOrderCounterfoil('1');

and this is the line I'm using to generate it's json:

$json =json_encode(serialize($varPedido));

Finally, I show you the result that I am getting and as you will see there is my problem:

"O:30:\"App\\ClasesEspeciales\\ClsPedido\":23:{s:39:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000OrderID\";s:1:\"1\";s:43:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000OrderNumber\";s:1:\"1\";s:36:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000Date\";s:1:\"1\";s:37:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000Total\";s:1:\"1\";s:45:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000TotalDiscount\";s:1:\"1\";s:41:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000PaidTotal\";s:1:\"1\";s:50:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000FinancialSurcharge\";s:1:\"1\";s:45:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000WarehouseCode\";s:1:\"1\";s:42:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000SellerCode\";s:1:\"1\";s:45:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000TransportCode\";s:1:\"1\";s:49:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000SaleConditionCode\";s:1:\"1\";s:47:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000PriceListNumber\";s:1:\"1\";s:43:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000IvaIncluded\";s:1:\"1\";s:51:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000InternalTaxIncluded\";s:1:\"1\";s:43:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000CancelOrder\";s:1:\"1\";s:44:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000CancelReason\";s:1:\"1\";s:42:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000CancelDate\";s:1:\"1\";s:48:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000AgreedWithSeller\";s:1:\"1\";s:50:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000InvoiceCounterfoil\";s:1:\"1\";s:39:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000Comment\";s:1:\"1\";s:48:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000OrderCounterfoil\";s:1:\"1\";s:42:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000objCliente\";N;s:43:\"\u0000App\\ClasesEspeciales\\ClsPedido\u0000objItemsPed\";N;}"

I get the path of the class I'm using + some escaped characters, \u000, anyway, I can't build a clean json.

Thank you very much, greetings and I look forward to your comments.

I'm doing some tests using livewire components and what I need is to get the value of a select and show it in a , I already have the part of managing the load of the Select solved and working, and what I'm missing is being able to catch the value of the selected item. I show you the code of the component.

<?php

namespace App\Http\Livewire;

use Livewire\Component;
use App\Models\Cliente;

class Clientes extends Component
{
    public $buscar;

    public function render()
    {
        $datos = Cliente::where('raz_social', 'like' , '%' . $this->buscar . '%')
        ->orderBy('raz_social')->get();

        return view('livewire.clientes', ['dtosclie' => $datos]);
    }
}

and here the view:

<div>
    <div class="flex flex-col">
        <input class="mb-1 bg-transparent border-0 border-b-2" type="text" placeholder="Nombre del cliente..." wire:model="buscar">
        <span>Aqui quiero poner el valor del cod_cli seleccionado</span>
        <select class="form-select rounded-lg">
            <option value="">Seleccionar...</option>
            @foreach($dtosclie as $it)
                <option value="{{ $it->cod_cli}}">{{ $it->raz_social}}</option>
            @endforeach
        </select>
    </div>
</div>

Thanks and regards

I need to do a query using Eloquent on a couple of tables that are 1-to-many related and I'm not able to figure it out. Here is the code I am using:

$datos = Vigelectrodetenida::query()
    ->with('relUsr')
    ->where('cam1b', 'LIKE', '%' . $this->busquedas . '%')
    ->orWhere('cam1c','LIKE', '%' . $this->busquedas . '%')
    ->orderBy($this->campOrden, $this->direcOrden)
    ->paginate(20);

I use this code to generate a table that has a lookup input using livewire. For now, the queries I make on the cam1b or cam1c field work fine, but when I want to put another orWhere and have it act on the name field that is in the users table (relUsr) it stops working, it tells me that the name field. Next I put the code that I am using and the error that is being generated.

$datos = Vigelectrodetenida::query()
    ->with('relUsr')
    ->where('cam1b', 'LIKE', '%' . $this->busquedas . '%')
    ->orWhere('cam1c','LIKE', '%' . $this->busquedas . '%')
    ->orWhere('name','LIKE', '%' . $this->busquedas . '%')
    ->orderBy($this->campOrden, $this->direcOrden)
    ->paginate(20);

Well, I hope I have been able to convey my doubt correctly and that you can help me.

I want to thank @HeytalePazguato for his valuable help

I have a table with a series of numeric columns and I need to return via Eloquent a column that is the sum of three fields of the same table, then I show you the structure of the table and what I need to return.

How should I build the query via Eloquent so that it returns all the records but also generates a column with the sum of the columns C1_01, C1_02 and C1_03 called totPartial, for example?

    $tbSnej1 = Snejtabsnej1::paginate(5);

    $totParcial = 0;
    foreach ($tbSnej1 as $it){
        $totParcial = ($it->C1_01 +$it->C1_02 +$it->C1_03 );
        //aquí debería armar el array con todos los campos mas $totParcial
        //¿como debería armar el array para devolverlo en el return?
    }

This is what I was trying to do, i.e. retrieve the records and then using a foreach loop through and build the summed field I need. Now, I'm stuck on how to build an associative array to return this structure as Eloquent itself would return it.

I am making a page that allows you to search for records by filtering through a field, in the image I show you in greater detail:

I have already defined the Controller that will return the data applying the filter, which is not how to pass the value that the user writes in the field through the Search button. The Search button in a link, but it could also be a button, but I think that there I would have to use a Form

This is the Controller I would like to use:

    public function indexF($cadFiltros){
    $clientes = Cliente::orderBy('id', 'desc' )
        ->where('razSocial', 'LIKE', '%' . $cadFiltros . '%')
        ->paginate(15);

    return view('clientes.listaClientes',
        [
            'clientes'=>$clientes
        ]
    );
}

and this other piece of code, shows the field and the button to perform the searches:

<div class="flex w-full bg-gray-500 rounded mt-10 mb-5 p-2">
        <label class="form-label" for="cadBusquedas">Nombre del Cliente</label>
        <input class="form-camptextos" type="text" name="cadBusquedas" value="" placeholder="Cliente a buscar...">
        <a type="button" class="font-osw text-sm bg-blue-500 hover:bg-blue-700 text-white text-center w-28 ml-3 p-2 pt-3.5 rounded focus:outline-none focus:shadow-outline" href="{{route('clientes.indexF', 'JUAN')}}">Buscar</a>
    </div>

I am parameterizing by "JUAN" code, but it is only for testing purposes. Precisely, that is where I am stuck, how do I send what the user writes in the field

Thanks and regards for your help.

I have a view in Laravel 8 that manages Vendor data, it has a dropdown field whose content is a list of users, what I need to do is validate that each Vendor has a user associated with it, that is, that there is a 1 to 1 relationship between vendors and users. Now, what I don't know is how to validate that a user is not assigned to a seller when recording the seller's data. I have the other form validations running, but I can't figure out how to do the aforementioned validation.

In the image I show you this dropdown that is loaded with the user data, and at the time of recording, you should verify that the selected user is not associated with a seller, otherwise, it would not be respecting the established 1 to 1 relationship for users and sellers.

I am doing the other validations in the Vendors Controller:

/**
 * @param Request $request
 */
private function validarCampos(Request $request): void
{
    $request->validate([
        'id_usuario' => 'required',
        'nombre' => 'required|max:100',
        'telCelular' => 'required',
        'ctaEmail' => 'required',
        'avatar'=>'mimes:jpg,jpeg,png,gif,svg,webp|max:2048'
    ],
    [
        'id_usuario.required'=>'Debe seleccionar un Usuario de la Lista de Usuarios',
        'nombre.required'=>'Debe ingresar un Nombre',
        'nombre.max'=>'Cantidad máxima de caracteres permitidos = 100',
        'telCelular.required'=>'Debe ingresar un número de teléfono celular',
        'ctaEmail.required'=>'Debe ingresar una cuenta de correo electrónico válida',
        'avatar.mimes'=>'Debe seleccionar un archivo de imágen',
        'avatar.max'=>'El archivo de imagen pesa mas de 2Mb'
    ]);
}

and this is the procedure to validate within the Controller:

/**
 * @param Request $request
 */
private function validarCampos(Request $request): void
{
    $request->validate([
        'id_usuario' => 'required',
        'nombre' => 'required|max:100',
        'telCelular' => 'required',
        'ctaEmail' => 'required',
        'avatar'=>'mimes:jpg,jpeg,png,gif,svg,webp|max:2048'
    ],
    [
        'id_usuario.required'=>'Debe seleccionar un Usuario de la Lista de Usuarios',
        'nombre.required'=>'Debe ingresar un Nombre',
        'nombre.max'=>'Cantidad máxima de caracteres permitidos = 100',
        'telCelular.required'=>'Debe ingresar un número de teléfono celular',
        'ctaEmail.required'=>'Debe ingresar una cuenta de correo electrónico válida',
        'avatar.mimes'=>'Debe seleccionar un archivo de imágen',
        'avatar.max'=>'El archivo de imagen pesa mas de 2Mb'
    ]);
}

Greetings and until another contact.

I am using Laravel 8 and I would need to make some adjustments to the buttons of the simple pagination provided by Laravel, I am using simplePaginate and I don't know where this should be done, in passing I comment that what I need is very simple, I just want there to be a small space between the buttons and put a border of another color.

Thank you very much in advance and I look forward to your response.

I have a .bat file that launches the following: "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" http://localhost/TestApiRest/ClienteApiRest.php. I have this programmed with a Windows Task. But my problem is that as this bat is executed, instances of the chrome that have already been executed remain active. The question is: is there any way to, for example after a certain time, delete the created task?

Thank you very much in advance and until another contact.

I will detail my problem, I am building a table using JavaScrip and with this I have no problem, I already have it running, but what I need is to save a value within the tds tags for later, if I go through all the tds of the table, to be able to count on the ids of the elements that I put in the table. Somewhere I saw that it can be done, but there is always a but, I don't remember how, which is why I ask you for help.

It would be something like this

<tr>
   <td clave=1>Item_1</td>
</tr>
<tr>
   <td clave=2>Item_2</td>
</tr>

From now on, thank you very much and I await some clue where to continue my search.