FuelPHP Forums

Hi Making a small events site for Twitter which I've been working on for a few weeks with thanks to some of you guys here. However, since I'm new to Fuel I'm not sure where to go next with this. I'll explain what I want to achieve and then show you my controller. What I'd like to do is users to be able to go to their dashboard and see a list of all events they've been invited to, and are attending. Once you accept an invite, it'll automatically create the row in the attendees table and delete it from the invites table. <i>Do give me suggestions though if you think it would be better in the attendees table all as one.</i> Basically so far I'm just trying to deal with the invites, I've managed to get the IDs for the events I'm invited to. By the following code:

$invited = Model_Invite::find()
   ->where('user_id', $this->current_user->id)
   ->related(array('invited_by', 'event'))
   ->get();
  
  foreach ($invited as $i)
   $invites[] = $i->event_id;

And then code for the get events:

if (count($invites) > 0)
  {
   $events = $this->data['events'] = Model_Event::find()
    ->where('start_date', '>=', date('Y-m-d'))
    ->where('id', 'IN', $invites)
    ->related(array('user', 'attendees'))
    ->order_by('start_date', 'asc')
    ->order_by('start_time', 'asc')
    ->get();
  }

The only problem is, in the view I want to be able to see if an event is an invite, or something I'm attending. I could setup a function in the User model which would be something like is_attending(event_id); etc.. but seems like I'm trying to do too much more than what's necessary. Hopefully someone will be able to point me in the right direction as where to go next with this. I have in my head it would be better adding a type to the rows in the foreach on the invites, type either 'invite' or 'attendee' but I wouldn't know where's best to do that either. Hopefully someone can help me. Maybe getting rid of the invites table and just using the attendees table would be better. Put in the invited_by columns in there, but that's another time maybe.
Thanks for your support guys, again!