/**
* 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;
}
