public function show($type, $alias, $id) { $chitiet = BaiViet::join('nguoi_dung', function ($join) { $join->on('nguoi_dung.id', '=', 'bai_viet.id_nguoi_dang'); })->join('loai_bai_viet', function ($join) { $join->on('loai_bai_viet.id', '=', 'bai_viet.id_loai_bai_viet'); })->select('nguoi_dung.ho_ten', 'bai_viet.id', 'bai_viet.thoi_gian_dang', 'bai_viet.thoi_gian_sua', 'bai_viet.tieu_de_bai_viet', 'loai_bai_viet.mo_ta_loai_bai_viet', 'bai_viet.tom_tat_bai_viet', 'bai_viet.noi_dung_bai_viet', 'loai_bai_viet.alias', 'bai_viet.tags')->where("bai_viet.trang_thai_bai_viet", 1)->where('bai_viet.id', $id, 'and')->where('loai_bai_viet.nhom_loai', $type, 'and')->where('loai_bai_viet.alias', $alias)->orderBy('bai_viet.thu_tu_bai_viet', 'asc')->get(); $tags = new QuanLyQuanLyBaiViet(); $tags = $tags->convertToStringTags($chitiet[0]->tags); return View::make('nguoidung_baiviet.view')->with('chitiet', $chitiet)->with('title', 'Chi tiết bài viết')->with('tags', $tags); }
public function getIdThreads($array_id_tags) { $all_id_threads = BaiViet::select('id', 'tags')->where('tags', '!=', '')->get(); $result_id = array(); $index = 0; foreach ($all_id_threads as $thread) { $array_id_tags_thread = explode(',', $thread->tags); foreach ($array_id_tags_thread as $key => $value) { if (array_search($value, $array_id_tags)) { $result_id[$index++] = $thread->id; } } } return array_unique($result_id); }