Luis's questions

How could you access the nameone located in league?

I was able to access lastNamewith this:

$url = "https://www.easports.com/fifa/ultimate-team/api/fut/item";
$response = Http::get($url);
$data = $response->json(['items']);

foreach ($data as $obj) {         
     $name = "nombre de jugador: ". $obj['firstName'] . '<br>';
     print ($name);
            
}

"items": [{
  "commonName": "Cristiano Ronaldo",
  "firstName": "C. Ronaldo",
  "lastName": "dos Santos Aveiro",
  "league": {
    "imageUrls": {},
    "abbrName": "ITA 1",
    "id": 31,
    "imgUrl": null,
    "name": "Serie A TIM"
  },

}],

I am getting the data from https://www.easports.com/fifa/ultimate-team/api/fut/item

I am using Laravel 6 and I am making a modal to fetch the info from another related table, the information is printed correctly but if I close the modal and reopen it, the info of said related table is duplicated

Modal:

<div class="modal fade" id="modal_view_shop" data-backdrop="static" data-keyboard="false" tabindex="-1" role="dialog" aria-labelledby="staticBackdropLabel" aria-hidden="true">
    <div class="modal-dialog">
      <div class="modal-content">
        <div class="modal-header">
          <h5 class="modal-title" id="title_modal_view_shop"></h5>
          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">&times;</span>
          </button>
        </div>
        <div class="modal-body">

                <div class="form-group row">
                    <label for="services" class="col-md-4 col-form-label text-md-right">Servicios*</label>
                    <div class="col-md-6">
                        <textarea id="services_list" class="form-control"></textarea>
                    </div>
                </div>

        </div>

         <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-dismiss="modal"> Cerrar  <i class="fa fa-close"></i></button>
        </div>
      </div>
    </div>
</div>

This is how I get the information:

let services = data.service_shops;

services.forEach(element => document.getElementById('services_list').innerHTML += element.service.title);

$('#modal_view_shop').modal('show');

service_shops is the other table and to access the rest I had to do that forEach

Image of what it looks like when I open the modal for the first time:

image of what it looks like if I close the modal and reopen it

and if I keep opening and closing different modals, the info of the images appears next to that of the modal that I opened

I am using laravel 6

I have 2 tables:

Table 1: id, description.

Table 2: id, table1_id, file, file2

table1 has the relationship of hasMany

table2 has a belongsTo relationship

Deleting table1 also deletes table2 . What I want to do is that when deleting table1, table2 is deleted along with all the files that I have in the project whose path is in the database in the file fields

If I separately delete a field from table2, it is deleted along with the file with the following code:

unlink(storage_path('app/public/'.$tabla2->file));
unlink(storage_path('app/public/'.$tabla2->file2));

But trying to delete everything from table1 doesn't work for me, I've tried this:

public function destroy($id){
   $tabla1    = Tabla1::find($id);
   $tabla2    = Tabla2::all()->where('tabla1_id', $id);

   if(isset($tabla2->file)){
     unlink(storage_path('app/public/'.$tabla2->file));
   }
   if(isset($tabla2->file2)){
     unlink(storage_path('app/public/'.$tabla->file2));
   }

   $tabla1->delete();
}

I have two tables in which I want to delete certain fields from a table related to another

a table is called procesess and another diligences and I want to eliminate all the fields that have in status_diligence the values ​​of: pending, rejected, sent there is another value that is approved but the fields with that value must remain

I have tried this but it does not work or it deletes all those with that id even if it has the value of approved

attempt1

$diligences = Diligence::where('process_id', "=", $id)->delete([
    ['status_diligence', "=", "pendiente"],
    ['status_diligence', "=", "rechazado"],
    ['status_diligence', "=", "enviado"]
]);

attempt 2

$diligences = Diligence::select('process_id', $id)
                        ->where(function($q) {
                            $q->where('status_diligence', 'pendiente')
                            ->where('status_diligence', 'rechazado')
                            ->where('status_diligence', 'enviado');
                        })
                        ->delete();

I have 3 boards

• Users table fields: id,

• processes table fields: id, user_id ("user_id" is related to the users table)

• Histories table fields: id, processes_id ("processes_id" is related to the processes table)

users has many processes(processes)

processes has many histories

histories has a single processes(process)

what I want to do is:

Fetch the data historythat is related to processes-user_idthe logged in user

I bring the processes in the following way in the controller:

$processes = Auth::user()->processes;
return view('processes.index', compact('processes'));

But with stories I couldn't

Here the dd of the answer

This is what appears to me when I put $data

I have a table in which I have two fields called created_at and updated_at in a table called processes, what I want to do is compare how many days there are between those two fields

I am using laravel 6

controller

$processes = Process::findOrFail(Crypt::decrypt(base64_decode($id)));
return view('clientes.show', compact('processes', 'histories', 'diligences', 'services', 'iva', 'dias'));

Query

SELECT TIMESTAMPDIFF(DAY,created_at, updated_at) AS days FROM processes 
WHERE id = 1

I am trying to block a button if an input is empty when a certain option is selected from a select

Let me explain: I have a select with 3 options which are pending, approved, rejected. when approved is selected an input appears in which I must enter a number value but if that input is empty the button must be blocked but if you select any other option from the select it is enabled

Code

<div>
    <label for="status">Estado del proceso</label>
    <select name="status" id="status" onChange="statuses()">
        <option value="pendiente">Pendiente</option>
        <option value="aprobado">Aprobado</option>
        <option value="rechazado">Rechazado</option>
    </select>                    
</div>
<div id="honorary" style="display:none;">
        <input type="number" name="honorary" id="fee">
    </div>
</div>
<input type="submit" value="Editar" id="update" class="btn btn-success" >

<script type="text/javascript">
    function statuses() {
        var x = document.getElementById("status").value;
        if ( x == 'aprobado') {
            document.getElementById("honorary").style.display = "";                    
        }else{
            document.getElementById("honorary").style.display = "none";
            document.getElementById("update").disabled = false;
        }
    }
</script>