Linking task to a group

Shouldn't the route for posting a task be:

$router->post('groups/{slug}/tasksandbookings', ['as' => 'tnb.store', 'uses' => 'TnBController@store']);

And likewise, the form action should post there instead of just to /tasksandbookings

@willvincent that ofcourse makes more sence, but I'm still getting this error:

NotFoundHttpException in RouteCollection.php line 143:

Also when looking at the source I see that it doesn't retrieve the slug:

<div class="container col-md-8 col-md-offset-2">
            <div class="panel panel-default">
        <div class="panel-heading">Create task or booking:</div>
            <div class="panel-body">
                
                <form method="POST" action="http://app.dev:8000/groups//tasksandbookings" accept-charset="UTF-8"><input name="_token" type="hidden" value="c3OFem5yIxQZyk8tnhHEMiAdkg8C2EIT2CLEshpX">
                    <div class="form-group form-horizontal">
                        <div class="form-group">
                                <label for="name" class="col-md-4 control-label">Task/Booking:</label>
                            <div class="col-md-6">
                                <input class="form-control" name="name" type="text" id="name">
                            </div>  
                        </div>
                        <div class="form-group">
                                <label for="username" class="col-md-4 control-label">Concirning:</label>
                            <div class="col-md-6">
                                <select class="form-control" id="username" name="username"><option value="0">Ced</option><option value="1">Test1</option></select>
                            </div>  
                        </div>
                        <div class="form-group">
                            <div class="col-md-6 col-md-offset-4">
                                <input class="btn btn-primary" type="submit" value="Create task or booking">
                            </div>
                        </div>
                    </div>
                </form>
        </div>
    </div>

What do you get if you put a dd($group); before the return in your create method?

@willvincent Yea, it seems like it can't find the group..

Group {#181 ▼
  #table: "groups"
  #fillable: array:7 [▼
    0 => "name"
    1 => "owner"
    2 => "shortdesc"
    3 => "longdesc"
    4 => "groupimage"
    5 => "invitecode"
    6 => "slug"
  ]
  #connection: null
  #primaryKey: "id"
  #perPage: 15
  +incrementing: true
  +timestamps: true
  #attributes: array:10 [▶]
  #original: array:10 [▶]
  #relations: []
  #hidden: []
  #visible: []
  #appends: []
  #guarded: array:1 [▶]
  #dates: []
  #dateFormat: null
  #casts: []
  #touches: []
  #observables: []
  #with: []
  #morphClass: null
  +exists: true
  +wasRecentlyCreated: false
}

@willvincent ok found the error by doing this:

public function create($slug)
    {
        $group = Group::whereSlug($slug)->first();
        $usernames = User::lists('username');
        return view('tnb.create', compact('usernames', 'group'));
    }

Thanks for all your help

@willvincent I just noticed something. When doing:

$usernames = User::lists('username');

I noticed that I ofcourse get all the users on the users table. Is there an easy way to simply get all the users in that specific group?

You have a relationship between users & tasks, and groups and tasks, but are users related to groups directly?

Can you share code for your user and group models?

@willvincent Yes ofcourse:

Group

    /**
     * Database relationships
     */

    public function owner()
    {
        return $this->belongsTo('App\User');
    }

    public function users()
    {
        return $this->belongsToMany('App\User');
    }

    public function tnbs()
    {
        return $this->hasMany('App\TnB');
    }

User

    /**
     * Database relationships
     */
    public function groups()
    {
        return $this->belongsToMany('App\Group');
    }

    public function ownedGroups() 
    {
        return $this->hasMany('App\Group', 'owner');
    }

    public function tnbs()
    {
        return $this->hasMany('App\TnB');
    }

TnB

    /**
     * Database relationships
     */
    public function group() 
    {
        return $this->belongsTo('App\Group');
    }

    public function user()
    {
        return $this->belongsTo('App\User');
    }
}

I think this might work...

public function create($slug) {
  $group = Group::whereSlug($slug)->first();
  $usernames = Group::find($group->id)->with('user')->lists('username');
  return view('tnb.create', compact('usernames', 'group'));
}

Not sure if that syntax is quite right, but that should be heading in the right direction

@willvincent Yea it's close I think, but with that code, it's trying to find usernames in the groups table:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'username' in 'field list' (SQL: select username from groups)

hmm... lists('user.username') perhaps?

@willvincent seems to be giving the same error. I also tried:

$usernames = User::find($group->id)->with('user')->lists('username');

But this also just gives a list of all the users.

How about something like this?

public function create($slug) {
  $usernames = array();
  $group = Group::whereSlug($slug)->with('user')->first();
  foreach ($group->users as $user) {
    $usernames[$user->id] = $user->username;
  }
  return view('tnb.create', compact('usernames', 'group'));
}

@willvincent The code was almost correct, I only had to remove the ->with('user') like this:

public function create($slug)
    {
        $usernames = array();
        $group = Group::whereSlug($slug)->first();
        foreach ($group->users as $user) {
            $usernames[$user->id] = $user->username;
        }
        return view('tnb.create', compact('usernames', 'group'));
    }

Thanks a whole lot!