public function getAllTerhah()
{
$terhahs = Terhah::orderBy('word', 'asc')->get();
$indonesian = Indonesian::all();
$english = English::all();
$thid = ThtoId::all();
$then = ThtoEn::all();
//return $terhah;
//$indonesian = Terhah::find(1)->indonesian;
//$english = Terhah::find(2)->english;
$word_in_english = DB::table('th_to_eng')->leftJoin('english', 'th_to_eng.english_id', '=', 'english.id')->select('english.id', 'th_to_eng.terhah_id', 'english.word')->get();
$word_in_indonesian = DB::table('th_to_ina')->leftJoin('indonesians', 'th_to_ina.indonesian_id', '=', 'indonesians.id')->select('indonesians.id', 'th_to_ina.terhah_id', 'indonesians.word')->get();
//return $word_in_indonesian;
//return $word_in_english;
$data = array();
foreach ($terhahs as $key => $terhah) {
//unset($terhah->english);
$kata_english = array();
foreach ($word_in_english as $key => $wie) {
if ($wie->terhah_id == $terhah->id) {
$kata_english[] = $wie->word;
} else {
unset($terhah->english);
}
$terhah->english = $kata_english;
}
$kata_indonesian = array();
foreach ($word_in_indonesian as $key => $wii) {
if ($wii->terhah_id == $terhah->id) {
$kata_indonesian[] = $wii->word;
} else {
unset($terhah->indonesian);
}
$terhah->indonesian = $kata_indonesian;
}
// echo $terhah;
$data[] = $terhah;
}
return response()->json(['results' => $data]);
}
public function deleteTerhahId($id)
{
//hapus di table terhah
$terhah = Terhah::find($id);
$terhah->delete();
//end
//hapus di table thtoina
$th_to_ina = ThtoId::where('terhah_id', $id)->get();
foreach ($th_to_ina as $key => $thina) {
echo $thina->id;
ThtoId::find($thina->id)->delete();
}
// return $th_to_ina;
//end
//hapus di table thtoeng
$th_to_eng = ThtoEn::where('terhah_id', $id)->get();
foreach ($th_to_eng as $key => $theng) {
echo $theng;
ThtoEn::find($theng->id)->delete();
}
//end
//return 'kata terhah sudah di hapus';
return redirect()->route('admin.terhah');
}
