用口才选择时重复数据 [英] Duplicate Data When Select With Eloquent
本文介绍了用口才选择时重复数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的观点:
@foreach($sasarans as $i => $sasaran)
@foreach($sasaran->indikator as $indikator)
@foreach($indikator->pertanyaan as $pertanyaan)
<tr>
@if($loop->first)
<td style="text-align:center; vertical-align:middle;" rowspan="{{$indikator->pertanyaan->count()}}">{{$i+1}} </td>
<td style="vertical-align:middle;" rowspan="{{$indikator->pertanyaan->count()}}">{{$sasaran->sasaran}} </td>
<td style="vertical-align:middle;" rowspan="{{$indikator->pertanyaan->count()}}">{{ $indikator->indikator}} </td>
@endif
<td style="vertical-align:middle;">{{ $pertanyaan->pertanyaan}}</td>
@foreach($data_laporans as $data)
<td>{{$data->jumlah}}</td>
<td>{{$data->keterangan}}</td>
<td><a href="{{ route('data.download', $data->id) }}" class="btn btn-sm btn-default btn-block"><i class="fa fa-download"></i> Unduh Bukti</a></td>
@endforeach
</tr>
@endforeach
@endforeach
@endforeach
控制器:
public function show($id)
{
$sasarans = Sasaran::all();
$laporan_indikators = LaporanIndikator::where('id',$id)->first();
$data_laporans = DataLaporan::where('id_laporan',$id)->get();
return view('indikator-kinerja.show',compact('laporan_indikators','data_laporans','sasarans'));
}
我还尝试在phpMyAdmin中执行查询,没有重复数据。Data in PhpMyAdmin
您可以在this question中查看模型关系和其他详细信息。我为我糟糕的英语感到抱歉。请帮帮我,因为我还是初学者。谢谢。
推荐答案
尝试了几次后,实际上我只需要更改视图:
@foreach($sasarans as $i => $sasaran)
@foreach($sasaran->indikator as $indikator)
@foreach($indikator->pertanyaan as $pertanyaan)
<tr>
@if($loop->first)
<td style="text-align:center; vertical-align:middle;" rowspan="{{$indikator->pertanyaan->count()}}">{{$i+1}} </td>
<td style="vertical-align:middle;" rowspan="{{$indikator->pertanyaan->count()}}">{{$sasaran->sasaran}} </td>
<td style="vertical-align:middle;" rowspan="{{$indikator->pertanyaan->count()}}">{{ $indikator->indikator}} </td>
@endif
<td style="vertical-align:middle;">{{ $pertanyaan->pertanyaan}}</td>
@foreach($pertanyaan->data_laporan as $data)
<td>{{$data->jumlah}}</td>
<td>{{$data->keterangan}}</td>
<td><a href="{{ route('data.download', $data->id) }}" class="btn btn-sm btn-default btn-block"><i class="fa fa-download"></i> Unduh Bukti</a></td>
@endforeach
</tr>
@endforeach
@endforeach
@endforeach
这篇关于用口才选择时重复数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文