private function getViewIndexDatas() { $current_user_id = Session::get('user')['id']; $owners_id = Follow::where('follower_id', $current_user_id)->where('is_deleted', 0)->get(['followed_id'])->toArray(); array_walk($owners_id, function (&$value, $key) { $value = $value['followed_id']; }); $owners_id[] = $current_user_id; // $privacy = Privacy::where('name',"Công khai")->get()->first(); $entries = Entry::whereIn('user_id', $owners_id)->where('privacy', 1)->orWhere('user_id', $current_user_id)->orderBy('updated_at', 'DESC')->paginate($this->entries_per_page); $left_albums = Album::whereIn('user_id', $owners_id)->where('privacy', 1)->orWhere('user_id', $current_user_id)->orderBy('updated_at', 'DESC')->get(); // $datas = array(); // // foreach ($entries as $index => $entry) { // if (FEUsersHelper::isCurrentUser($entry->user_id)) { // if($this->getEntry($entry->entry_id, $entry->type, null)){ // $datas[] = $this->getEntry($entry->entry_id, $entry->type, null); // } // } else{ // if($this->getEntry($entry->entry_id, $entry->type, $privacy->id)){ // $datas[] = $this->getEntry($entry->entry_id, $entry->type, $privacy->id); // } // // } // } //// $datas = $this->pagination($datas, 3, $page); $suggests = FEUsersHelper::getSuggestes(); return array('datas' => $entries, 'suggestes' => $suggests, 'left_albums' => $left_albums); }
/** * Display a listing of the resource. * * @return Response */ public function index() { // $sortby = Input::get('sortby'); $order = Input::get('order'); $keyword = Input::get('keyword'); $option = Input::get('search_opt'); if ($sortby && $option && $keyword && $option == "fullname") { $users = User::where('fullname', 'LIKE', "%{$keyword}%")->get(); $users_id = array(); foreach ($users as $key => $user) { $users_id[] = $user->id; } $albums = Album::whereIn('user_id', $users_id)->orderBy($sortby, $order)->paginate(8); } elseif ($sortby && $option && $keyword && $option == "title") { $albums = Album::select('*')->where('title', 'LIKE', '%' . $keyword . '%')->orderBy($sortby, $order)->paginate(5); } elseif ($keyword && $option == "fullname") { $users = User::where('fullname', 'LIKE', "%{$keyword}%")->get(); $users_id = array(); foreach ($users as $key => $user) { $users_id[] = $user->id; } $albums = Album::whereIn('user_id', $users_id)->paginate(8); } elseif ($keyword && $option == "title") { $albums = Album::select('*')->where($option, 'LIKE', '%' . $keyword . '%')->paginate(5); } elseif ($sortby && $order) { $albums = Album::select('*')->orderBy($sortby, $order)->paginate(8); } else { $albums = Album::select('*')->paginate(5); } return View::make('backend.album.index', compact('albums', 'sortby', 'order', 'keyword', 'option')); }
public static function getIdsByNames($names) { if (!empty($names)) { return Album::whereIn('name', $names)->lists('id'); } else { return 0; } }
public function getNewAlbumsNotification($current_user_id, $last_time) { $followed_users = Follow::where('follower_id', '=', $current_user_id)->select('followed_id')->get(); $new_albums = Album::whereIn('user_id', $followed_users->fetch('followed_id')->toArray())->where('privacy', 1)->where('created_at', '>=', $last_time)->get(); return $new_albums ? $new_albums : array(); }
public function whereIn() { $values = array('Something Corporate', 'The Ataris'); //return Album::whereNotIn('artist',$values) return Album::whereIn('artist', $values)->toSql(); }