PHP app Profile::select示例

示例#1

文件： ProfileController.php 项目： ElasticOrange/canon-orasul-respira-foto

 public function getClasament()
 {
     $profiles = Profile::select(DB::raw('*,(select count(*) from votes where profile_id=profiles.id and isActive=1) as voteCount'))->where('isActive', '=', '1')->orderBy('voteCount', 'desc')->paginate(20);
     $data = array('selectedPage' => 1, 'profiles' => $profiles);
     return view('profile.clasament', $data);
 }