where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $hasil_karyas = DB::table('hasil_karyas') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $kegiatan_eksternal_kampus = DB::table('kegiatan_eksternal_kampus') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $kegiatan_internal_kampus = DB::table('kegiatan_internal_kampus') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $lomba_kompetisis = DB::table('lomba_kompetisis') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $ukm_mahasiswas = DB::table('ukm_mahasiswas') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $prestasi_aktivitas_mahasiswas = DB::table('prestasi_aktivitas_mahasiswas') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $layanan_mahasiswas = DB::table('layanan_mahasiswas') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $informasi_beasiswas = DB::table('informasi_beasiswas') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $penelitians = DB::table('penelitians') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $pengabdian_ke_masyarakats = DB::table('pengabdian_ke_masyarakats') ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL); $informasiTerbaru = DB::table('beritas') ->union($kerjasama_mitra_kolaborasis) ->union($hasil_karyas) ->union($kegiatan_eksternal_kampus) ->union($kegiatan_internal_kampus) ->union($lomba_kompetisis) ->union($ukm_mahasiswas) ->union($prestasi_aktivitas_mahasiswas) ->union($layanan_mahasiswas) ->union($informasi_beasiswas) ->union($penelitians) ->union($pengabdian_ke_masyarakats) ->where('release_date', '<=', date('Y-m-d')) ->where('deleted_at', NULL) ->orderBy('release_date', 'DESC'); return $informasiTerbaru; } }