/**
* Display a listing of my going events.
*
* @return Response
*/
public function goingEvents()
{
$events = Event::whereIn('id', function ($query) {
$query->select('event_id')->from('event_user')->where('user_id', \Auth::id());
})->where('date_start', '>=', new \DateTime('today'))->orderBy('date_start')->select(array('id', 'name'))->paginate();
$tittle = 'Going';
return view('events', compact('events', 'tittle'));
}
public function registeredevents()
{
$user = Auth::user();
$eventid = Register::where('userid', $user->id)->lists('eventid');
$events = Event::whereIn('id', $eventid)->get();
$festid = Event::whereIn('id', $events->toArray())->lists('festid');
$fests = Fest::whereIn('id', $festid);
return view('user.regevents', ['user' => Auth::user(), 'fests' => $fests, 'events' => $events]);
}
/**
* Execute the job.
*
* @return void
*/
public function handle()
{
if ($this->user->unsubscribed_email != "no") {
$soc_ids = DB::table('subscriptions')->where('user_id', $this->user->id)->lists('society_id');
// All Events, in user subscribed society, next week.
$events = Event::whereIn('society_id', $soc_ids)->where('time', '>', date('Y-m-d H:i:s'))->where('time', '<', date('Y-m-d H:i:s', time() + 604800));
$allEvents = $this->events->toArray();
if (count($allEvents)) {
$random_event = $allEvents[array_rand($allEvents, 1)];
$data = ['user' => $this->user, 'events' => $events, 'random_event' => $random_event];
Mail::send('emails.weekly', $data, function ($message) {
$message->from('*****@*****.**', 'Lowdown');
$message->subject('Your Weekly Society Lowdown');
$message->to($this->user->email);
});
}
}
}
private function manageableRolesForUser()
{
$roles = $this->roleResultToList(Role::with('perms')->get());
if (Entrust::can(PermissionNames::ManageGlobalPermissions())) {
return $roles;
}
//Filter out global permissions
$roles = array_filter($roles, function ($r) {
$globalPerms = PermissionNames::AllGlobalPermissions();
foreach ($r->perms as $p) {
if (in_array($p->name, $globalPerms)) {
return false;
}
}
return true;
});
$confPermNamePart = PermissionNames::normalizePermissionName(PermissionNames::ConferencePermissionManagement(1));
$evtPermNamePart = PermissionNames::normalizePermissionName(PermissionNames::EventPermissionManagement(1));
//Get the permissions this user has which are permissions management
//permissions
$currentPermManagement = Permission::whereHas("roles", function ($query) {
$query->whereHas("users", function ($query) {
//on Account table
$query->where("id", Auth::user()->id);
});
})->where(function ($query) use($confPermNamePart, $evtPermNamePart) {
$query->where('name', 'like', $confPermNamePart . '%');
$query->orWhere('name', 'like', $evtPermNamePart . '%');
})->get();
$conferences = [];
$events = [];
foreach ($currentPermManagement as $perm) {
if (PermissionNames::isConferencePermission($perm->name)) {
$conferences[] = PermissionNames::extractPermissionData($perm->name)->idPart;
} else {
$events[] = PermissionNames::extractPermissionData($perm->name)->idPart;
}
}
$ownedEvents = Event::whereIn('conferenceID', $conferences)->select('id')->get();
$ownedEvents = array_map(function ($e) {
return $e['id'];
}, $ownedEvents->toArray());
$events = array_merge($events, $ownedEvents);
//Filter out permissions not associated with the conferences/events
//this user can control.
$roles = array_filter($roles, function ($r) use($events, $conferences) {
foreach ($r->perms as $p) {
if (PermissionNames::isConferencePermission($p->name)) {
$confId = PermissionNames::extractPermissionData($p->name)->idPart;
if (!in_array($confId, $conferences)) {
return false;
}
} else {
if (PermissionNames::isEventPermission($p->name)) {
$evtId = PermissionNames::extractPermissionData($p->name)->idPart;
if (!in_array($evtId, $events)) {
return false;
}
}
}
return true;
}
});
return $roles;
}
private function dopublish(Request $request, $value)
{
$event = Event::whereIn('id', $request->ids)->update(array('is_published' => $value));
$response = ['model_type' => 'Event', 'ids' => $request->ids, 'action_type' => $value == 1 ? "Publish" : "Unpublish"];
return json_encode($response);
}
