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();
}
