function index()
{
$download = new Download();
if (@$_GET['search']) {
$download->where("title like '%" . $_GET['search'] . "%'");
}
if (@$_GET['category_id']) {
$download->where("category_id = " . $_GET['category_id']);
}
$data['rs'] = $download->order_by('id', 'desc')->get();
$this->template->append_metadata(js_checkbox('approve'));
$this->template->build('admin/index', $data);
}
/**
* Display customer profile
*
* @param $profile
* @return Response
*/
public function show($profile)
{
$p = User::where('profile_url', '=', $profile)->where('approved', '=', '0')->first();
$page = Page::where('title', '=', 'faq-customer')->first();
$follow = Follow::where('user', $p->id)->where('hub', '=', 0)->get();
$follow_hub = Follow::where('user', $p->id)->where('artist', '=', 0)->get();
$wall = new \Illuminate\Database\Eloquent\Collection();
$events = new \Illuminate\Database\Eloquent\Collection();
$comments = Comment::where('user', '=', $p->id)->orderBy('created_at', 'desc')->get();
$hidden = unserialize(Cookie::get('hide'));
//dd( Cookie::get('hide') );
if (count($follow) > 0) {
foreach ($follow as $f) {
$s = Song::where('artist', '=', $f->artist)->where('completed', '=', '1')->get();
$e = ArtistEvent::where('artist', '=', $f->artist)->where('date', '>', \Carbon\Carbon::now())->get();
$wall = $wall->merge($s);
$events = $events->merge($e);
}
}
if (count($follow_hub) > 0) {
foreach ($follow_hub as $h) {
$hub = Hub::where('id', '=', $h->hub)->first();
if (!is_null($hub)) {
$artists = User::where('type', '=', 'artist')->where('hub', '=', $hub->id)->get();
$artists_list = [];
$songs = [];
$events = [];
foreach ($artists as $a) {
$artists_list[] = $a->id;
}
if (count($artists_list) > 0) {
$songs = Song::where('completed', '=', '1')->whereIn('artist', $artists_list)->orderBy('created_at', 'desc')->get();
$events = ArtistEvent::whereIn('artist', $artists_list)->get();
}
$news = News::where('hub', '=', $hub->id)->take(3)->get();
$wall = $wall->merge($songs);
$events = $events->merge($events);
}
}
}
$purchased = Purchase::where('customer', '=', $p->id)->get();
foreach ($purchased as $pp) {
$song_purchased = Song::withTrashed()->where('id', '=', $pp->song)->get();
$download = Download::where('customer', '=', $p->id)->where('song', '=', $pp->song)->first();
$song_purchased[0]->purchased = true;
if (isset($download)) {
$song_purchased[0]->link = $download->url;
}
$wall = $wall->merge($song_purchased);
}
$wall->sortByDesc('created_at');
if (!isset($news)) {
$news = null;
}
return View::make('customer.profile-new', ['profile' => $p, 'wall' => $wall, 'page' => $page, 'events' => $events, 'comments' => $comments, 'hidden' => $hidden, 'news' => $news]);
}
return Redirect::to('customer/settings');
}
if (Auth::user()->type == 'charity') {
return Redirect::to('charity/settings');
}
}
return Redirect::to('/');
});
Route::get('migrate', function () {
Artisan::call('migrate', array('--force' => true));
});
Route::get('thumbnail/{id}', 'ArtistsController@showthumbnail');
Route::get('small/thumbnail/{id}', 'ArtistsController@smallthumbnail');
Route::get('socialize/{provider}', 'UsersController@socialize');
Route::get('download/{code}', function ($code) {
$d = Download::where('url', '=', $code)->first();
if (!is_null($d)) {
$song = Song::withTrashed()->where('id', '=', $d->song)->first();
if ($song) {
$path = $song->path . "/" . $song->original_name;
return Response::download($path, $song->title . ".mp3");
} else {
App::abort('404');
}
} else {
App::abort('404');
}
});
Route::get('admin', ['uses' => 'AdminController@index', 'before' => 'auth|admin']);
Route::post('admin', ['uses' => 'AdminController@index', 'before' => 'auth|admin']);
Route::get('admin/transaction/status/{id}', ['uses' => 'AdminController@change_status', 'before' => 'auth|admin']);