1 回答

TA贡献1806条经验 获得超8个赞
想想您的查询和关系是否正确,然后使用下面的IF()条件
public function prediksi()
{
$collection = array();
$title = "Data Prediksi Sentimen";
$testing_data = DataTesting::count();
$klasifikasi = DataTesting::with(['data_crawling','klasifikasi'])->get();
foreach($klasifikasi as $class){
$prediksi = Klasifikasi::with(['sentimen'])->where('id_testing',$class->id_testing)->first();
$hasil = Hasil::where('id_testing',$class->id_testing)->get();
$aktual = Sentimen::where('id_sentimen', $class->data_crawling->id_sentimen)->first();
if($prediksi && isset($prediksi->sentimen)){
$collection[] = [
'id_testing' => $class->id_testing,
'username' => $class->data_crawling->username,
'tweet' => $class->data_crawling->tweet,
'kategori' => $aktual->kategori,
'prediksi' => $prediksi->sentimen->kategori,
];
}
}
return view('visualisasi.prediksi', compact(['title','collection','testing_data','hasil']));
}
更新
public function prediksi()
{
$collection = array();
$title = "Data Prediksi Sentimen";
$testing_data = DataTesting::count();
$klasifikasi = DataTesting::with(['data_crawling','klasifikasi'])->get();
foreach($klasifikasi as $class){
$prediksi = Klasifikasi::with(['sentimen'])->where('id_testing',$class->id_testing)->first();
$hasil = Hasil::where('id_testing',$class->id_testing)->get();
$aktual = Sentimen::where('id_sentimen', $class->data_crawling->id_sentimen)->first();
if($prediksi && isset($prediksi->sentimen)){
$collection[] = [
'id_testing' => $class->id_testing,
'username' => $class->data_crawling->username,
'tweet' => $class->data_crawling->tweet,
'kategori' => $aktual->kategori,
'prediksi' => $prediksi->sentimen->kategori,
];
$hasil_data[$class->id_testing][] = $hasil;
}
}
return view('visualisasi.prediksi', compact(['title','collection','testing_data','hasil_data']));
}
然后在您的视图中,当您收集数据时
foreach($collection as $key){
//to use hasil data
foreach($hasil_data[$key['id_testing']] as $hasil){
dd($hasil);
}
}
- 1 回答
- 0 关注
- 156 浏览
添加回答
举报