public function viewGroup($name, $mode = 'default')
{
$group = Group::where('group_name', $name)->firstOrFail();
$subscription = Gsub::where('user_fp', self::userFp())->where('group_name', $name)->first();
$subscribers = Gsub::where('group_name', $name)->count();
$subscribers = DB::table('gsubs')->where('gsubs.group_name', $name)->join('users', 'users.user_fp', '=', 'gsubs.user_fp')->select('gsubs.id', 'users.*')->get();
return View::make('board.group', ['mode' => $mode, 'posts' => Post::group($name, $mode, self::getBL()), 'subscription' => $subscription, 'subscribers' => $subscribers, 'group' => $group]);
}
public static function checkOwner($user_fp, $name)
{
if (Gsub::where('group_name', $name)->where('user_fp', $user_fp)->where('role', 'owner')->first() == NULL) {
App::abort(500, 'You are not owner!');
}
}
public static function membership($user_fp, $group_name)
{
return Gsub::where('group_name', $group_name)->where('user_fp', $user_fp)->where('is_member', 1)->first();
}
