将Excel多个表单输入导入到Laravel中的同一mysql表中

Question

我在Laravel 7中使用maatsite的Excel导入库将文件分析和支持数据导入到“分析”数据库表中，它工作得很好。但是，在我选择要导入的Excel文件的视图页面上，我有一个选择下拉和输入文本。我在各自的模型中创建了has很多和属性关系。

处理控制器：

//view import profiling page
public function profiling_import()
{
    // mengambil data edc
    $edc = Edc::all();

    // mengambil data brand
    $brand = Brand::all();
    
    return view('processing.profiling_import',['edc' => $edc, 'brand' => $brand]);  
}



public function profiling_import_excel(Request $request) 
{
    $messages = [     
        'required' => 'Bidang ini harus di isi',
    ];

    // validasi
    $this->validate($request, [
        'file' => 'required|mimes:xls,xlsx',
        'pemohon' => 'required',
        'brand_id' => 'required'
    ],$messages);
    
    
    if ($request->hasFile('file')) {
    
    $pemohon = $request->pemohon;
    $brand_id = $request->brand_id;
    $user_id = $request->user_id;

        Excel::Import(new \App\Imports\ProfilingImport,$request->file('file'), $brand_id);
        return redirect('/profiling')->with("sukses","Data profiling berhasil di import");

    }

    return redirect('/profiling')->with("gagal","Silakan pilih file import kembali");

}

利润进口：

public function collection(Collection $collection)
{
    $collection = $collection->toArray();
    foreach ($collection as $key => $row){
        if($key >= 2){
            
            $pemohon = request('pemohon');
            $brand_id = request('brand_id');
            $user_id = request('user_id');

            $row['pemohon'] = $pemohon;
            $row['brand_id'] = $brand_id;
            $row['user_id'] = $user_id;
                    
            //dd($collection);

            return Profiling::create([
                'terminalid' => $row['terminalid'],
                'merchant_name_1' => $row['merchant_name_1'],
                'merchant_name_2' => $row['merchant_name_2'],
                'pemohon' => $row['pemohon'],
                'brand_id' => $row['brand_id'],
                'user_id' => $row['user_id'],
                ]);
        }
    }
 }

profiling_import.blade：

<div class="card-body">
                        <form method="post" action="{{ url('/profiling/import_excel') }}" enctype="multipart/form-data"> 
                            @csrf
                            <div class="form-group"> 
                                <label>Pemohon</label> 
                                <input type="text" name="pemohon" class="form-control" placeholder="Isi dengan nama pemohon ..." value="{{ old('pemohon') }}" autofocus> 
     
                                @if($errors->has('pemohon')) 
                                <span class="text-danger"> 
                                    <strong>{{ $errors->first('pemohon') }}</strong> 
                                </span> 
                                @endif      
                            </div>

                            <div class="form-group"> 
                                <label>Brand</label> 
                                <select id="brand_id" name="brand_id" class="form-control">
                                    <option value="0" disabled="true" selected="true">- Pilih Brand EDC</option>
                                    @foreach($brand as $b)
                                        <option value="{{ $b->id }}">{{ $b->brand}} ({{$b->principal }})</option>
                                    @endforeach
                                </select>

                                @if($errors->has('brand_id')) 
                                <span class="text-danger"> 
                                    <strong>{{ $errors->first('brand_id') }}</strong> 
                                </span> 
                                @endif      
                            </div>

                            <div class="form-group">
                                <label for="">File Profiling (.xls, .xlsx)</label>
                                <input type="file" class="form-control" name="file">
                                <p class="text-danger">{{ $errors->first('file') }}</p>
                                   
                                <div class="form-group">
                                    <input type="hidden" name="user_id" value="{{ Auth::user()->name }}" />
                                    <input type="reset" class="btn btn-warning" value="Reset" autofocus>
                                    <input type="submit" class="btn btn-primary" value="Save" autofocus>
                                </div>


                            </div>
                        </form>
                    </div>

在Excel文件中：

| terminalid | merchant_name_1 | merchant_name_2 |
| 12345678   | Matahari Store  | Jakarta         |
| 98765432   | Amazon Store    | Bandung         | 

视图：

Pemohon : Ardi            (input text)
Brand   : Ingenico      v (select)
File    : Choose File     (input file)

Save

问题是pemohon、品牌和用户数据没有填入数据库。

array:4 [▼
  0 => array:54 [▶]
  1 => array:54 [▶]
  2 => array:54 [▼
       0 => "98765432"
       1 => "Amazon Store"
       2 => "Bandung"

       3 ? Ardi
       4 ? Ingenico
       5 ? Admin

非常感谢你

Answer 1

这是因为您可以在项目中的任何位置访问请求对象。这可能会起作用：

return Profiling::create([
            'terminalid' => $row['terminalid'],
            'merchant_name_1' => $row['merchant_name_1'],
            'merchant_name_2' => $row['merchant_name_2'],
            'pemohon' => request('pemohon'),
            'brand_id' => request('brand_id'),
            'user_id' => $row['user_id'],
            ]);