Followup::scopeReminders() - Code Metrics - lubusIN/laravel-gymie - Measure and Improve Code Quality continuously with Scrutinizer

Followup::scopeReminders() A
last analyzed 2018-03-09 00:26 UTC

↳ Parent: Followup

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	7
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	5
nc	1
nop	1

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Carbon\Carbon;
use App\Enquiry;

class Followup extends Model
{
	protected $table = 'trn_enquiry_followups';

	protected $fillable = [
		'enquiry_id',
		'followup_by',
		'due_date',
		'status',
		'outcome',
		'created_by',
    	'updated_by',
	];

	protected $dates  = ['created_at', 'updated_at', 'due_date'];

	public function Enquiry()
	{
		return $this->belongsTo('App\Enquiry','enquiry_id');
	}

	public function scopeReminders($query)
	{
		return $query->leftJoin('mst_enquiries','trn_enquiry_followups.enquiry_id','=','mst_enquiries.id')
					 ->select('trn_enquiry_followups.*','mst_enquiries.status')
					 ->where('trn_enquiry_followups.due_date','<=',Carbon::today())
					 ->where('trn_enquiry_followups.status','=',\constFollowUpStatus::Pending)
					 ->where('mst_enquiries.status','=',\constEnquiryStatus::Lead);
	}

	public function createdBy()
    {
        return $this->belongsTo('App\User','created_by');
    }

    public function updatedBy()
    {
        return $this->belongsTo('App\User','updated_by');
    }
}

1			<?php
2
3			namespace App;
4
5			use Illuminate\Database\Eloquent\Model;
6			use Carbon\Carbon;
7			use App\Enquiry;
8
9			class Followup extends Model
10			{
11			protected $table = 'trn_enquiry_followups';
12
13			protected $fillable = [
14			'enquiry_id',
15			'followup_by',
16			'due_date',
17			'status',
18			'outcome',
19			'created_by',
20			'updated_by',
21			];
22
23			protected $dates = ['created_at', 'updated_at', 'due_date'];
24
25			public function Enquiry()
26			{
27			return $this->belongsTo('App\Enquiry','enquiry_id');
28			}
29
30			public function scopeReminders($query)
31			{
32			return $query->leftJoin('mst_enquiries','trn_enquiry_followups.enquiry_id','=','mst_enquiries.id')
33			->select('trn_enquiry_followups.*','mst_enquiries.status')
34			->where('trn_enquiry_followups.due_date','<=',Carbon::today())
35			->where('trn_enquiry_followups.status','=',\constFollowUpStatus::Pending)
36			->where('mst_enquiries.status','=',\constEnquiryStatus::Lead);
37			}
38
39			public function createdBy()
40			{
41			return $this->belongsTo('App\User','created_by');
42			}
43
44			public function updatedBy()
45			{
46			return $this->belongsTo('App\User','updated_by');
47			}
48			}

lubusIN / laravel-gymie

Followup::scopeReminders() A last analyzed 2018-03-09 00:26 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Followup::scopeReminders() A
last analyzed 2018-03-09 00:26 UTC