温馨提示:本文翻译自stackoverflow.com,查看原文请点击:php - How to Add Multiple Child Row Data together with Parent Row in Laravel Blade
laravel-6 php

php - 如何在Laravel Blade中将多个子行数据与父行一起添加

发布于 2020-04-13 18:25:29

我一直在尝试通过刀片添加多个数据。以我的刀片形式,我正在使用克隆,添加行。例如,一个请购单有很多项目。

我的刀片视图 在此处输入图片说明

刀片视图代码

<form autocomplete="off" method="POST" action="{{ route("requisition.store") }}" enctype="multipart/form-data">
        @csrf
        <div class="form-group">
            <label class="required" for="purpose">Purpose</label>
            <input class="form-control" type="text" name="purpose" id="purpose" required>
            <span class="help-block"></span>
        </div>

        <div class="form-group">
            <label class="required" for="requisition_date">Date</label>
            <input class="form-control" type="date" name="requisition_date" id="requisition_date" required>
            <span class="help-block"></span>
        </div>

        <div class="form-group">
            <label class="required" for="requested_by">Released By</label>
            <input class="form-control" type="text" name="requested_by" id="requested_by" required>
            <span class="help-block"></span>
        </div>

        <table class="table table-bordered">
            <thead>
                <tr>
                    <th>Qty</th>    
                    <th>Unit</th>    
                    <th>Description</th>   
                    <th>
                        <a href="#" class="addRow"><i class="fas fa-plus"></i></a>    
                    </th> 
                </tr>
            </thead>
            <tbody>
                <tr>
                    <td>
                        <input type="number" name="rows[0][qty]" class="form-control quantity" required>  
                    </td>    
                    <td>
                        <input type="text" name="rows[0][unit]" class="form-control" required>  
                    </td>    
                    <td>
                        <input type="text" name="rows[0][description]" class="form-control" required>  
                    </td> 
                    <td>

                    </td>   
                </tr> 
            </tbody>    
        </table>



        <div class="form-group">
            <button class="btn btn-danger" type="submit">
                Save
            </button>
        </div>
    </form>

克隆脚本代码

function addRow()
{
    var tr = '<tr>'+
    '<td><input type="number" name="rows[0][qty]" class="form-control quantity"></td>'+
    '<td><input type="text" name="rows[0][unit]" class="form-control quantity"></td>'+
    '<td><input type="text" name="rows[0][description]" class="form-control quantity"></td>'+
    '<td><a class="btn btn-danger remove"><i class="fas fa-times"></i></a></td>'+
    '</tr>';
    $('tbody').append(tr);
  }

还有我的商店控制器代码

public function store(Request $request)
{
   $requisition = Requisition::create([
            'purpose' => $request->input('purpose'),
            'requisition_date' => $request->input('requisition_date'),
            'requested_by' => $request->input('requested_by')
        ]);  

        $rows = $request->input('rows');

        foreach ($rows as $row)
        {
            $items[] = [
                'requisition_id' => $requisition->id,
                'qty' => $row['qty'],
                'unit' => $row['unit'],
                'description' => $row['description']
            ];
        }

        RequisitionItem::insert($items);

}

我的商店控制器代码中的问题是,它仅添加一项而不是多项。我的模型:申请表='id','目的','requisition_date','requested_by','requisition_date'RequisitionItem table ='id','requisition_id','qty','unit','description'

dd($ rows)结果

在此处输入图片说明

查看更多

提问者
Boss Pogs
被浏览
14
Akhtar Munir 2020-02-03 15:48

我认为最简单的方法是同时使用您的附加输入和刀片输入...

name="qty[]"

代替

name="rows[0][qty]"

并且在控制器中循环通过将始终添加的一个字段。例如;

for($i = 0; $i < sizeof($request->qty); $i++)
    {
        RequisitionItem::insert([
            'requisition_id' => $requisition->id,
            'qty' => $request->qty[$i],
            'unit' => $request->unit[$i],
            'description' => $request->description[$i]
        ]);
    }

您也可以按照以下步骤操作,

  for($i = 0; $i < sizeof($request->qty); $i++)
    {
        $items[] = [
            'requisition_id' => $requisition->id,
            'qty' => $request->qty[$i],
            'unit' => $request->unit[$i],
            'description' => $request->description[$i]
        ];
    }

  RequisitionItem::insert($items);