Questions[laravel]

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 need to get the rows/fields from a file that I upload excelto my Laravel project, I made the code to load my database directly with laravel excel 3.1, but what I need is to get the data and then enter it myself through a insertin the part of the values. In addition, excelthere are several data (several rows). So how could that be made insert?

I add the code of my controller (import):

namespace App\Imports;

 use App\tbl_instrumentos;
 use Maatwebsite\Excel\Concerns\ToModel;

class InstrumentosImport implements ToModel
 {

public function model(array $row)
{
    return new tbl_instrumentos([
        'ins_codigo'   => $row[0],
        'ins_observacionInicial'   => $row[1],
        'ins_claseOexactitud'    => $row[2],
    ]);
 }
}

Additionally I add the code of my main controller:

class TestController extends Controller
{

public function importExportView()
{
   $data=DB::table('tbl_instrumentos')->orderBy('ins_id','DESC')
            ->get();
    return view('importar',compact('data'));
}

/**
* @return \Illuminate\Support\Collection
*/
public function exportExcel($type) 
{
    return Excel::download(new InstrumentosExport, 'instrumentos.'.$type);
}

/**
* @return \Illuminate\Support\Collection
*/
public function importExcel(Request $request) 
{
   $this->validate($request, [
  'select_file'  => 'required|mimes:xls,xlsx'
 ]);
    Excel::import(new InstrumentosImport,$request->import_file);

     return back()->with('success', 'Datos Excel Importados Satisfactoriamente.');
}

The import_file that I have in my controller (import) comes from my view through an input which is the following:

    <input type="file" name="import_file" />

I am working with migrations in Laravel and I have a partners table that has a type attribute of type enum with the following values:

$table->enum('type', ['cliente', 'proveedor', 'empleado', 'transportadora'])->nullable();

What I need is the following: Create another migration so that I can modify the partners table, adding one more value to the enum so that the database looks like this:

['cliente', 'proveedor', 'empleado', 'transportadora', 'nuevo_dato']

What I tried so far was the following:

Schema::table('partners', function ($table) {            
         DB::statement("ALTER COLUMN 'type' ADD VALUE 'nuevo_dato' AFTER 'cliente'");
});

And I also tried:

Schema::table('partners', function ($table) {    
      $table->enum('type', ['cliente', 'proveedor', 'empleado', 'transportadora', 'nuevo_dato'])->change();
});

Y...

DB::statement("ALTER TABLE 'partners' MODIFY COLUMN 'type' enum('nuevo_dato') NOT NULL AFTER `transportadora`");

Without reaching the expected result. I would be very grateful if you help me with this. (PS: I'm using PostgreSQL)

I want to edit a record by its id and I have the following code in my view:

<a href="{{route('guest.edit',$g->id)}}" class="btn btn-simple btn-warning btn-icon edit"><i class="ti-pencil-alt"></i></a>

And so I have in my route:

Route::resource('guest','GuestController');

Then in my controller:

public function edit($id){
    $guest=Guest::find($id);
    return view('Guests.edit1',compact('guest'));
}

The problem with this is that the id appears in my route, which I consider is not safe, it appears in this way

http://localhost:8081/guest/2/edit

How do I solve in such a way that the id is not shown in the url, or the url is not shown at all

I would like you to help me understand how the is applied @forelsein Laravel .