/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $act = Models\Activity::find($id); //活动列表 $activities = Models\Activity::select('id', 'title')->get(); return view('home.activity.show', compact('act', 'activities')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { //社团列表 $associates = Models\Associate::select('id', 'name', 'poly_id')->take(5)->orderBy('id', 'desc')->get(); //活动列表 $activities = Models\Activity::select('id', 'title')->take(5)->orderBy('id', 'desc')->get(); //->orderBy('name', 'desc')->take(10)->get(); return view('home.index', compact('activities', 'associates')); }
public function all($params) { $params['order'] = isset($params['order']) ? $params['order'] : ['activity_log.created_at|DESC']; $activities = Activity::select("activity_log.*"); $activities->leftJoin('users', 'users.id', '=', 'activity_log.user_id'); $activities->leftJoin('company_person', 'company_person.id', '=', 'activity_log.contact_id'); $activities->leftJoin('people', 'people.id', '=', 'company_person.person_id'); $activities->leftJoin('companies', 'companies.id', '=', 'company_person.company_id'); $activities = parent::execute($activities, $params); return $activities; }