Company::getMeetingsTimeSlots() - Code Metrics - Inspection of "scrutinzier restored" - dsd-meetme/backend - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( cb49ac...f14b58 )

by claudio

created 2015-12-28 21:30 UTC

Company::getMeetingsTimeSlots() A

↳ Parent: Company

Complexity

Conditions	1
Paths	1

Size

Total Lines	12
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	10
CRAP Score	1

Importance

Changes	2
Bugs	1	Features	0

Metric	Value
c	2
b	1
f	0
dl	0
loc	12
ccs	10
cts	10
cp	1
rs	9.4286
cc	1
eloc	10
nc	1
nop	2
crap	1

<?php

namespace plunner;

use Illuminate\Auth\Authenticatable;
use Illuminate\Auth\Passwords\CanResetPassword;
use Illuminate\Contracts\Auth\Access\Authorizable as AuthorizableContract;
use Illuminate\Contracts\Auth\Authenticatable as AuthenticatableContract;
use Illuminate\Contracts\Auth\CanResetPassword as CanResetPasswordContract;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Foundation\Auth\Access\Authorizable;

/**
 * Class Company
 *
 * @package plunner
 * @author Claudio Cardinale <[email protected]>
 * @copyright 2015 Claudio Cardinale
 * @version 1.0.0
 * @property integer $id
 * @property string $name
 * @property string $email
 * @property string $password
 * @property boolean $verified
 * @property string $remember_token
 * @property \Carbon\Carbon $created_at
 * @property \Carbon\Carbon $updated_at
 * @property-read \Illuminate\Database\Eloquent\Collection|Employee[] $employees
 * @property-read \Illuminate\Database\Eloquent\Collection|Group[] $groups
 * @method static \Illuminate\Database\Query\Builder|\plunner\Company whereId($value)
 * @method static \Illuminate\Database\Query\Builder|\plunner\Company whereName($value)
 * @method static \Illuminate\Database\Query\Builder|\plunner\Company whereEmail($value)
 * @method static \Illuminate\Database\Query\Builder|\plunner\Company wherePassword($value)
 * @method static \Illuminate\Database\Query\Builder|\plunner\Company whereVerified($value)
 * @method static \Illuminate\Database\Query\Builder|\plunner\Company whereRememberToken($value)
 * @method static \Illuminate\Database\Query\Builder|\plunner\Company whereCreatedAt($value)
 * @method static \Illuminate\Database\Query\Builder|\plunner\Company whereUpdatedAt($value)
 */
class Company extends Model implements AuthenticatableContract,
                                    AuthorizableContract,
                                    CanResetPasswordContract,
                                    PolicyCheckable
{
    use Authenticatable, Authorizable, CanResetPassword;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = ['name', 'email', 'password'];

    /**
     * The attributes excluded from the model's JSON form.
     *
     * @var array
     */
    protected $hidden = ['password', 'remember_token'];

    /**
     * @return \Illuminate\Database\Eloquent\Relations\HasMany
     */
    public function employees()
    {
        return $this->hasMany(Employee::class);
    }

    public function groups()
    {
        return $this->hasMany(Group::class);
    }

    /**
     * @param Group $group
     * @return bool
     */
    public function verifyGroup(Group $group)
    {
        return $group->company_id === $this->id;
    }

    /**
     * @param Employee $employee
     * @return bool
     */
    public function verifyEmployee(Employee $employee)
    {
        return $employee->company_id === $this->id;
    }

    /**
     * @param Company $company
     * @return bool
     */
    public function verifyCompany(Company $company)
    {
        return $company->id === $this->id;
    }

    /**
     * @param Calendar $calendar
     * @return bool
     */
    public function verifyCalendar(Calendar $calendar)
    {
        //TODO test this
        return $calendar->employee->company->id == $this->id;
    }

    /**
     * @param Timeslot $timeslot
     * @return bool
     */
    public function verifyTimeslot(Timeslot $timeslot)
    {
        //TODO implement and test this
        return false;
    }

    /**
     * @param Meeting $meeting
     * @return bool
     */
    public function verifyMeeting(Meeting $meeting)
    {
        //TODO implement and test this
        return false;
    }

    /**
     * @param MeetingTimeslot $meetingTimeslot
     * @return bool
     */
    public function verifyMeetingTimeslot(MeetingTimeslot $meetingTimeslot)
    {
        //TODO implement and test this
        return false;
    }
    
    /**
     * @param \DateTime $from
     * @param \DateTime $to
     * @return \Illuminate\Support\Collection
     */
    public function getEmployeesTimeSlots($from, $to)
    {
        return \DB::table('employees')
            ->join('calendars', 'employees.id', '=', 'calendars.employee_id')
            ->join('timeslots', 'calendars.id', '=', 'timeslots.calendar_id')
            ->where('calendars.enabled', '=', '1')
            ->where('timeslots.time_start', '>=', $from)
            ->where('timeslots.time_end', '<=', $to)
            ->where('employees.company_id','=', $this->id)
            ->select('employees.id','timeslots.time_start','timeslots.time_end')
            ->get();
    }

    /**
     * @param \DateTime $from
     * @param \DateTime $to
     * @return \Illuminate\Support\Collection
     */
    public function getMeetingsTimeSlots($from, $to)
    {
        return \DB::table('meetings')
            ->join('groups', 'meetings.group_id', '=', 'groups.id')
            ->join('meeting_timeslots', 'meetings.id', '=', 'meeting_timeslots.meeting_id')
            ->where('meeting_timeslots.time_start', '>=', $from)
            ->where('meeting_timeslots.time_end', '<=', $to)
            ->where('groups.company_id','=', $this->id)
            ->where('meetings.start_time','=', NULL)
            ->select('meetings.id', 'meetings.duration','meeting_timeslots.time_start','meeting_timeslots.time_end')
            ->get();
    }

    /**
     * @param array $users
     * @param array $meetings
     * @return \Illuminate\Support\Collection
     */
    public function getUsersMeetings(array $users, array $meetings)
    {
        return \DB::table('meetings')
            ->join('groups', 'meetings.group_id', '=', 'groups.id')
            ->join('employee_group', 'employee_group.group_id', '=', 'groups.id')
            ->join('employees', 'employee_group.employee_id', '=', 'employees.id')
            ->whereIn('employees.id', $users)
            ->whereIn('meetings.id', $meetings)
            ->where('groups.company_id','=', $this->id) //this is not needed
            ->where('employees.company_id','=', $this->id) //this is not needed
            ->select('employees.id as employee_id', 'meetings.id as meeting_id')
            ->get();
    }
}


1		<?php
2
3		namespace plunner;
4
5		use Illuminate\Auth\Authenticatable;
6		use Illuminate\Auth\Passwords\CanResetPassword;
7		use Illuminate\Contracts\Auth\Access\Authorizable as AuthorizableContract;
8		use Illuminate\Contracts\Auth\Authenticatable as AuthenticatableContract;
9		use Illuminate\Contracts\Auth\CanResetPassword as CanResetPasswordContract;
10		use Illuminate\Database\Eloquent\Model;
11		use Illuminate\Foundation\Auth\Access\Authorizable;
12
13		/**
14		* Class Company
15		*
16		* @package plunner
17		* @author Claudio Cardinale <[email protected]>
18		* @copyright 2015 Claudio Cardinale
19		* @version 1.0.0
20		* @property integer $id
21		* @property string $name
22		* @property string $email
23		* @property string $password
24		* @property boolean $verified
25		* @property string $remember_token
26		* @property \Carbon\Carbon $created_at
27		* @property \Carbon\Carbon $updated_at
28		* @property-read \Illuminate\Database\Eloquent\Collection\|Employee[] $employees
29		* @property-read \Illuminate\Database\Eloquent\Collection\|Group[] $groups
30		* @method static \Illuminate\Database\Query\Builder\|\plunner\Company whereId($value)
31		* @method static \Illuminate\Database\Query\Builder\|\plunner\Company whereName($value)
32		* @method static \Illuminate\Database\Query\Builder\|\plunner\Company whereEmail($value)
33		* @method static \Illuminate\Database\Query\Builder\|\plunner\Company wherePassword($value)
34		* @method static \Illuminate\Database\Query\Builder\|\plunner\Company whereVerified($value)
35		* @method static \Illuminate\Database\Query\Builder\|\plunner\Company whereRememberToken($value)
36		* @method static \Illuminate\Database\Query\Builder\|\plunner\Company whereCreatedAt($value)
37		* @method static \Illuminate\Database\Query\Builder\|\plunner\Company whereUpdatedAt($value)
38		*/
39		class Company extends Model implements AuthenticatableContract,
40		AuthorizableContract,
41		CanResetPasswordContract,
42		PolicyCheckable
43		{
44		use Authenticatable, Authorizable, CanResetPassword;
45
46		/**
47		* The attributes that are mass assignable.
48		*
49		* @var array
50		*/
51		protected $fillable = ['name', 'email', 'password'];
52
53		/**
54		* The attributes excluded from the model's JSON form.
55		*
56		* @var array
57		*/
58		protected $hidden = ['password', 'remember_token'];
59
60		/**
61		* @return \Illuminate\Database\Eloquent\Relations\HasMany
62		*/
63	112	public function employees()
64		{
65	112	return $this->hasMany(Employee::class);
66		}
67
68	48	public function groups()
69		{
70	48	return $this->hasMany(Group::class);
71		}
72
73		/**
74		* @param Group $group
75		* @return bool
76		*/
77	16	public function verifyGroup(Group $group)
78		{
79	16	return $group->company_id === $this->id;
80		}
81
82		/**
83		* @param Employee $employee
84		* @return bool
85		*/
86	16	public function verifyEmployee(Employee $employee)
87		{
88	16	return $employee->company_id === $this->id;
89		}
90
91		/**
92		* @param Company $company
93		* @return bool
94		*/
95		public function verifyCompany(Company $company)
96		{
97		return $company->id === $this->id;
98		}
99
100		/**
101		* @param Calendar $calendar
102		* @return bool
103		*/
104		public function verifyCalendar(Calendar $calendar)
105		{
106		//TODO test this
107		return $calendar->employee->company->id == $this->id;
108		}
109
110		/**
111		* @param Timeslot $timeslot
112		* @return bool
113		*/
114		public function verifyTimeslot(Timeslot $timeslot)
115		{
116		//TODO implement and test this
117		return false;
118		}
119
120		/**
121		* @param Meeting $meeting
122		* @return bool
123		*/
124		public function verifyMeeting(Meeting $meeting)
125		{
126		//TODO implement and test this
127		return false;
128		}
129
130		/**
131		* @param MeetingTimeslot $meetingTimeslot
132		* @return bool
133		*/
134		public function verifyMeetingTimeslot(MeetingTimeslot $meetingTimeslot)
135		{
136		//TODO implement and test this
137		return false;
138		}
139
140		/**
141		* @param \DateTime $from
142		* @param \DateTime $to
143		* @return \Illuminate\Support\Collection
144		*/
145	2	public function getEmployeesTimeSlots($from, $to)
146		{
147	2	return \DB::table('employees')
148	2	->join('calendars', 'employees.id', '=', 'calendars.employee_id')
149	2	->join('timeslots', 'calendars.id', '=', 'timeslots.calendar_id')
150	2	->where('calendars.enabled', '=', '1')
151	2	->where('timeslots.time_start', '>=', $from)
152	2	->where('timeslots.time_end', '<=', $to)
153	2	->where('employees.company_id','=', $this->id)
154	2	->select('employees.id','timeslots.time_start','timeslots.time_end')
155	2	->get();
156		}
157
158		/**
159		* @param \DateTime $from
160		* @param \DateTime $to
161		* @return \Illuminate\Support\Collection
162		*/
163	2	public function getMeetingsTimeSlots($from, $to)
164		{
165	2	return \DB::table('meetings')
166	2	->join('groups', 'meetings.group_id', '=', 'groups.id')
167	2	->join('meeting_timeslots', 'meetings.id', '=', 'meeting_timeslots.meeting_id')
168	2	->where('meeting_timeslots.time_start', '>=', $from)
169	2	->where('meeting_timeslots.time_end', '<=', $to)
170	2	->where('groups.company_id','=', $this->id)
171	2	->where('meetings.start_time','=', NULL)
172	2	->select('meetings.id', 'meetings.duration','meeting_timeslots.time_start','meeting_timeslots.time_end')
173	2	->get();
174		}
175
176		/**
177		* @param array $users
178		* @param array $meetings
179		* @return \Illuminate\Support\Collection
180		*/
181	2	public function getUsersMeetings(array $users, array $meetings)
182		{
183	2	return \DB::table('meetings')
184	2	->join('groups', 'meetings.group_id', '=', 'groups.id')
185	2	->join('employee_group', 'employee_group.group_id', '=', 'groups.id')
186	2	->join('employees', 'employee_group.employee_id', '=', 'employees.id')
187	2	->whereIn('employees.id', $users)
188	2	->whereIn('meetings.id', $meetings)
189	2	->where('groups.company_id','=', $this->id) //this is not needed
190	2	->where('employees.company_id','=', $this->id) //this is not needed
191	2	->select('employees.id as employee_id', 'meetings.id as meeting_id')
192	2	->get();
193		}
194		}
195

dsd-meetme / backend

Push — master ( cb49ac...f14b58 )

Company::getMeetingsTimeSlots() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like