public static function customCreate(CreateConversationRequest $request)
{
$conv = new Conversation();
$conv->Title = $request->Title;
// if nothing specified in the request
if (!$request->has('user_id')) {
// if we are not even logged ( happen while seeding base)
if (!\Auth::check()) {
$conv->user_id = User::first()->id;
} else {
$conv->user_id = \Auth::id();
}
}
// if Pending status is specified we take it, if not default value will be applied (false)
if (!$request->has('Pending')) {
$conv->Pending = $request->Pending;
}
$conv->created_at = Carbon::now();
$conv->save();
// When conversation is settled the Thread can be created
$thread = new Thread();
$thread->user_id = $conv->user_id;
$thread->Content = $request->Content;
$thread->conversation_id = $conv->id;
$thread->created_at = Carbon::now();
$thread->Pending = $conv->Pending;
$thread->save();
return true;
}
function scopeForUser($query, $id)
{
if (!$id) {
$id = Auth::id();
}
$query->whereHas('user_id', function ($query) use($id) {
$query->where('id', $id);
});
}
public function getSchedulesForDropdown()
{
# Only let the user see their schedules
$schedules = $this->where('user_id', '=', \Auth::id())->orderby('name', 'ASC')->get();
$schedules_for_dropdown = [];
foreach ($schedules as $schedule) {
$schedules_for_dropdown[$schedule->id] = $schedule->name;
}
return $schedules_for_dropdown;
}
public function scopeOwner($q)
{
return $q->whereUserId(Auth::id());
}
/**
* Take all users with roles
*
* @return array
*/
public static function allUsersWithRoles()
{
$users = \DB::table('users')->join('role_user', 'users.id', '=', 'role_user.user_id')->join('roles', 'roles.id', '=', 'role_user.role_id')->where('users.id', '<>', \Auth::id())->whereNull('users.deleted_at')->select('users.*', 'roles.name as role', 'roles.slug', 'roles.level');
return $users->orderBy('first_name', 'asc')->get();
}
/**
* [scopeUserIdle description]
* @return [type] [description]
*/
public function scopeUpdateIdleUser(Builder $query)
{
return $query->where('id', Session::getId())->update(['user_id' => \Auth::id()]);
}
public function scopeAuth($query, $input = false)
{
return $query->where('user_id', \Auth::id())->whereIn('action_type_id', $this->actionsType);
//trans('notices.actions')
}
public function notReadCount()
{
return $this->messages()->selectRaw('conversation_id, count(*) as aggregate')->where('user_id', '!=', \Auth::id())->where('read', '=', 0)->groupBy('conversation_id');
}
public static function cantUpdate($id)
{
return \Auth::check() && (\Auth::id() == $id || \Auth::user() && in_array(\Auth::user()->role, ['admin', 'root']));
}
/**
* Checkout this model to the logged in user
* @method checkoutToMe
* @return [type] [description]
*/
public function checkoutToMe()
{
return $this->checkoutToId(\Auth::id());
}
public function isSameUser()
{
return (bool) ($this->user_id === \Auth::id());
}
public function scopeForLoggedInUser($query)
{
return $query->where('user_id', Auth::id());
}
/**
* @param Builder|\Illuminate\Database\Eloquent\Builder|Profile $query
* @return mixed
*/
public function scopeVisible($query)
{
return $query->where(function ($query) {
$query = $query->approved();
if (\Auth::check()) {
$query = $query->orWhere('user_id', \Auth::id());
}
return $query;
});
}
