| Server IP : 78.140.185.180 / Your IP : 216.73.216.170 Web Server : LiteSpeed System : Linux cpanel13.v.fozzy.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : builderbox ( 1072) PHP Version : 7.3.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /proc/self/root/proc/self/root/home/builderbox/./public_html/common/Workspaces/ |
Upload File : |
<?php
namespace Common\Workspaces;
use App\User;
use App\Workspaces\WorkspaceRelationships;
use Auth;
use Carbon\Carbon;
use Common\Search\Searchable;
use Database\Factories\WorkspaceFactory;
use Eloquent;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\HasMany;
/**
* App\Workspace
*
* @property int $id
* @property string $name
* @property Carbon|null $created_at
* @property Carbon|null $updated_at
* @property Collection $members
* @property User $owner
* @property int owner_id
* @mixin Eloquent
* @property int $owner_id
* @property-read Collection|\Common\Workspaces\WorkspaceInvite[] $invites
* @property-read int|null $invites_count
* @property-read Collection|\App\LinkDomain[] $linkDomains
* @property-read int|null $link_domains_count
* @property-read Collection|\App\LinkGroup[] $linkGroups
* @property-read int|null $link_groups_count
* @property-read Collection|\App\LinkOverlay[] $linkOverlays
* @property-read int|null $link_overlays_count
* @property-read Collection|\App\LinkPage[] $linkPages
* @property-read Collection|\App\Link[] $links
* @property-read int|null $links_count
* @property-read int|null $members_count
* @property-read Collection|\App\TrackingPixel[] $trackingPixels
* @property-read int|null $tracking_pixels_count
* @method static \Database\Factories\WorkspaceFactory factory(...$parameters)
* @method static Builder|Workspace forUser(int $userId)
* @method static Builder|Workspace newModelQuery()
* @method static Builder|Workspace newQuery()
* @method static Builder|Workspace query()
*/
class Workspace extends Model
{
use WorkspaceRelationships, Searchable, HasFactory;
protected $guarded = ['id'];
protected $casts = [
'id' => 'integer',
'owner_id' => 'integer',
];
public function invites(): HasMany
{
return $this->hasMany(WorkspaceInvite::class)
->join('roles', 'roles.id', '=', 'workspace_invites.role_id')
->select([
'workspace_invites.id',
'workspace_invites.workspace_id',
'roles.name as role_name',
'workspace_invites.email',
'workspace_invites.role_id',
'email',
'avatar',
]);
}
public function owner()
{
return $this->belongsTo(User::class, 'owner_id')->select([
'id',
'email',
'first_name',
'last_name',
'avatar',
]);
}
public function members()
{
return $this->hasMany(WorkspaceMember::class)
->join('roles', 'roles.id', '=', 'workspace_user.role_id', 'left')
->join('users', 'users.id', '=', 'workspace_user.user_id')
->select([
'roles.name as role_name',
'users.email',
'workspace_user.workspace_id',
'workspace_user.created_at as joined_at',
'workspace_user.role_id',
'workspace_user.is_owner',
'workspace_user.id as member_id',
'users.id',
'users.first_name',
'users.last_name',
'users.avatar',
]);
}
public function isMember(User $user): bool
{
return $this->members()
->where('user_id', $user->id)
->exists();
}
public function isOwner(User $user): bool
{
return $this->owner_id === $user->id;
}
public function findMember(User $user): WorkspaceMember
{
return $this->members()
->where('user_id', $user->id)
->first();
}
public function scopeForUser(Builder $builder, int $userId): Builder
{
return $builder
->where('owner_id', $userId)
->orWhereHas('members', function (Builder $builder) use ($userId) {
return $builder->where('workspace_user.user_id', $userId);
});
}
public function setCurrentUserAndOwner(): self
{
$this->setRelation(
'owner',
$this->members->where('is_owner', true)->first(),
);
$this->currentUser = $this->members->where('id', Auth::id())->first();
$this->unsetRelation('members');
// load workspace permissions for current user in case front-end needs it
if (
app(ActiveWorkspace::class)->id === $this->id &&
$this->currentUser &&
!$this->currentUser->relationLoaded('permissions')
) {
$this->currentUser->load('permissions');
}
return $this;
}
public function toSearchableArray(): array
{
return [
'id' => $this->id,
'name' => $this->name,
'created_at' => $this->created_at->timestamp ?? '_null',
'updated_at' => $this->updated_at->timestamp ?? '_null',
];
}
public static function filterableFields(): array
{
return ['id', 'created_at', 'updated_at'];
}
protected static function newFactory()
{
return WorkspaceFactory::new();
}
}