Company::verifyMeetingTimeslot() - Code Metrics - Inspection of "Meeting timeslots" - dsd-meetme/backend - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#51)

by claudio

created 2015-12-27 23:28 UTC

Company::verifyMeetingTimeslot() A

↳ Parent: Company

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	1	Features	0

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

<?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 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	38	public function groups()
69		{
70	38	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 Meeting $meeting
112		* @return bool
113		*/
114		public function verifyMeeting(Meeting $meeting)
115		{
116		//TODO implement and test this
117		return false;
118		}
119
120		/**
121		* @param MeetingTimeslot $meetingTimeslot
122		* @return bool
123		*/
124		public function verifyMeetingTimeslot(MeetingTimeslot $meetingTimeslot)
125		{
126		//TODO implement and test this
127		return false;
128		}
129
130		/**
131		* @param \DateTime $from
132		* @param \DateTime $to
133		* @return \Illuminate\Support\Collection
134		*/
135	2	public function getEmployeesTimeSlots($from, $to)
136		{
137	2	return \DB::table('employees')
138	2	->join('calendars', 'employees.id', '=', 'calendars.employee_id')
139	2	->join('timeslots', 'calendars.id', '=', 'timeslots.calendar_id')
140	2	->where('calendars.enabled', '=', '1')
141	2	->where('timeslots.time_start', '>=', $from)
142	2	->where('timeslots.time_end', '<=', $to)
143	2	->where('employees.company_id','=', $this->id)
144	2	->select('employees.id','timeslots.time_start','timeslots.time_end')
145	2	->get();
146		}
147
148		/**
149		* @param \DateTime $from
150		* @param \DateTime $to
151		* @return \Illuminate\Support\Collection
152		*/
153	2	public function getMeetingsTimeSlots($from, $to)
154		{
155	2	return \DB::table('meetings')
156	2	->join('groups', 'meetings.group_id', '=', 'groups.id')
157	2	->join('meeting_timeslots', 'meetings.id', '=', 'meeting_timeslots.meeting_id')
158	2	->where('meeting_timeslots.time_start', '>=', $from)
159	2	->where('meeting_timeslots.time_end', '<=', $to)
160	2	->where('groups.company_id','=', $this->id)
161	2	->where('meetings.start_time','=', NULL)
162	2	->select('meetings.id', 'meetings.duration','meeting_timeslots.time_start','meeting_timeslots.time_end')
163	2	->get();
164		}
165
166		/**
167		* @param array $users
168		* @param array $meetings
169		* @return \Illuminate\Support\Collection
170		*/
171	2	public function getUsersMeetings(array $users, array $meetings)
172		{
173	2	return \DB::table('meetings')
174	2	->join('groups', 'meetings.group_id', '=', 'groups.id')
175	2	->join('employee_group', 'employee_group.group_id', '=', 'groups.id')
176	2	->join('employees', 'employee_group.employee_id', '=', 'employees.id')
177	2	->whereIn('employees.id', $users)
178	2	->whereIn('meetings.id', $meetings)
179	2	->where('groups.company_id','=', $this->id) //this is not needed
180	2	->where('employees.company_id','=', $this->id) //this is not needed
181	2	->select('employees.id as employee_id', 'meetings.id as meeting_id')
182	2	->get();
183		}
184		}
185

dsd-meetme / backend

Pull Request — master (#51)

Company::verifyMeetingTimeslot() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like