Inserting additional data in import using Laravel-Excel

[nikos25]

Good afternoon everyone, I need to make an insert in 2 tables: "serialziacions" and "det_serializacions" for what in my controller I have a function that through a transaction will make the insert, but in the table "det_serializacions" data must be inserted from an excel file that is loaded from a form in a modal window (where are the additional data to be inserted).

I have this function in my controller but it doesn't work, I don't know how to do the insert in the second table (the excel and the additional data):

public function store(Request $request)
{
    //$path = $request->file('serie')->getRealPath();
    //$data = Excel::import(new DetSerializacionImport, $path);
    //dd($data);
    //return $data;
    try {
        DB::beginTransaction();

        //INSERT A LA TABLA PADRE "SERIALIZACIONS"
        $serializacion = new Serializacion();

        $serializacion->fecha_serializacion = $request->get('fecha_serializacion');
        $serializacion->status = $request->get('status');
        $serializacion->usuario_id = $request->get('usuario_id');
        $serializacion->ingreso_material_id = $request->get('ingreso_material_id');
        $serializacion->det_ingreso_material_id = $request->get('det_ingreso_material_id');
        $serializacion->save();

        //INSERCION A LA TABLA MENOR "DET_SERIALIZACIONS" INCLUYENDO DATOS DEL EXCEL
        //LOS DATOS A INSERTAR VIENEN DESDE LA VENTANA MODAL
        $path = $request->file('serie')->getRealPath();
        Excel::import(new DetSerializacionImport, $path, function($reader) {
            $serie = $reader->get();

            $reader->each(function($row, $request, $serializacion) {
                $material_id = $request->get('material_id');

                $detalleSeriado = new DetSerializacion;
                $detalleSeriado->mac = $row->mac; //ESTE DATO VIENE DEL EXCEL
                $detalleSeriado->serie = $row->serie; //ESTE DATO VIENE DEL EXCEL
                $detalleSeriado->serializacion_id = $serializacion->id; //ID GENERADO EN EL PRIMER INSERT
                $detalleSeriado->material_id = $material_id;
                //$user->save();
                $detalleSeriado->save();
                //$cont=$cont+1;
                });
        });
        DB::commit();
    } catch (\Exception $e) {
        //throw $th;
        DB::rollback();
    }
//return ('hola');
}

And the code of the modal (where the excel is loaded and where are the additional data for the insert in the second table):

<div class="modal-body">
    <form action="{{ route('serializacion') }}" method="post" enctype="multipart/form-data">
        @csrf
        matrial_id<input type="text" name="material_id" id="material_id" value="{{$item->ingreso_material_material_nom->id}}"><br>
        fecha:<input type="datetime" name="fecha_serializacion" id="fecha_serializacion" value="<?php echo date("Y-m-d H:i:s");?>"><br>
        status:<input type="text" name="status" id="status" value="0"><br>
        usuario:<input type="text" name="usuario_id" id="usuario_id" value="{{$ingreso[0]->usuario_id}}"><br>
        ingreso-mtaterial:<input type="text" name="ingreso_material_id" id="ingreso_material_id" value="{{$ingreso[0]->id}}"><br>
        det_ingreso_material<input type="text" name="det_ingreso_material_id" id="det_ingreso_material_id" value="14"><br>
        <div class="form-group alert alert-danger">
            <h5 class="text-center">¡Atención!</h5>
            <p class="text-center">Esta por asignar Numeros de serie al material <strong>{{$item->ingreso_material_material_nom->detalle}}</strong></p>
        </div>
        <div class="form-group">
            <label for="serie">Seleccione Archivo de series</label>
            <input type="file" name="serie" id="serie" class="form-control">
        </div>
        <input type="submit" value="subir">
    </form>
</div>

Thank you very much for your attention and help, from Chile...