App\Subscription

Complexity

Total Complexity

22

Size/Duplication

Total Lines	102
Duplicated Lines	0 %

Importance

Changes

0

10 Methods

Rating	Name	Duplication	Size	Complexity
B	scopeIndexQuery()	0	11	5
B	scopeExpiring()	0	11	5
A	createdBy()	0	3	1
A	Member()	0	3	1
B	scopeExpired()	0	11	5
A	Plan()	0	3	1
A	scopeDashboardExpiring()	0	3	1
A	Invoice()	0	3	1
A	updatedBy()	0	3	1
A	scopeDashboardExpired()	0	3	1

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Sofa\Eloquence\Eloquence;
use Carbon\Carbon;

class Subscription extends Model
{
	 protected $table = 'trn_subscriptions';

	 protected $fillable = [
            'member_id',
	 		'invoice_id',
	 		'plan_id',
            'status',
            'is_renewal',
	 		'start_date',
	 		'end_date',
    		'created_by',
    		'updated_by',
	 ];  

    protected $dates  = ['created_at', 'updated_at', 'start_date', 'end_date'];

    //Eloquence Search mapping
    use Eloquence;

    protected $searchableColumns = [
        'Member.member_code' => 20,
        'start_date' => 20,
        'end_date' => 20,
        'Member.name' => 20,
        'Plan.plan_name' => 20,
        'Invoice.invoice_number' => 20,
    ];

    public function scopeDashboardExpiring($query)
    {
        return $query->where('end_date','<',Carbon::today()->addDays(7))->where('status','=',\constSubscription::onGoing);
    }

    public function scopeDashboardExpired($query)
    {
        return $query->where('status','=',\constSubscription::Expired);
    }

    public function scopeIndexQuery($query,$sorting_field,$sorting_direction,$drp_start,$drp_end)
    {
        $sorting_field = ($sorting_field != null ? $sorting_field : 'created_at');
        $sorting_direction = ($sorting_direction != null ? $sorting_direction : 'desc');

        if ($drp_start == null or $drp_end == null) 
        {
            return $query->leftJoin('mst_plans', 'trn_subscriptions.plan_id', '=', 'mst_plans.id')->select('trn_subscriptions.*','mst_plans.plan_name')->orderBy($sorting_field,$sorting_direction);
        }

        return $query->leftJoin('mst_plans', 'trn_subscriptions.plan_id', '=', 'mst_plans.id')->select('trn_subscriptions.*','mst_plans.plan_name')->whereBetween('trn_subscriptions.created_at', [$drp_start, $drp_end])->orderBy($sorting_field,$sorting_direction);
    }

    public function scopeExpiring($query,$sorting_field,$sorting_direction,$drp_start,$drp_end)
    {
        $sorting_field = ($sorting_field != null ? $sorting_field : 'created_at');
        $sorting_direction = ($sorting_direction != null ? $sorting_direction : 'desc');

        if ($drp_start == null or $drp_end == null) 
        {
            return $query->leftJoin('mst_plans', 'trn_subscriptions.plan_id', '=', 'mst_plans.id')->select('trn_subscriptions.*','mst_plans.plan_name')->where('trn_subscriptions.end_date','<',Carbon::today()->addDays(7))->where('trn_subscriptions.status','=',\constSubscription::onGoing)->orderBy($sorting_field,$sorting_direction);
        }

        return $query->leftJoin('mst_plans', 'trn_subscriptions.plan_id', '=', 'mst_plans.id')->select('trn_subscriptions.*','mst_plans.plan_name')->where('trn_subscriptions.end_date','<',Carbon::today()->addDays(7))->where('trn_subscriptions.status','=',\constSubscription::onGoing)->whereBetween('trn_subscriptions.created_at', [$drp_start, $drp_end])->orderBy($sorting_field,$sorting_direction);
    }

    public function scopeExpired($query,$sorting_field,$sorting_direction,$drp_start,$drp_end)
    {
        $sorting_field = ($sorting_field != null ? $sorting_field : 'created_at');
        $sorting_direction = ($sorting_direction != null ? $sorting_direction : 'desc');

        if ($drp_start == null or $drp_end == null) 
        {
            return $query->leftJoin('mst_plans', 'trn_subscriptions.plan_id', '=', 'mst_plans.id')->select('trn_subscriptions.*','mst_plans.plan_name')->where('trn_subscriptions.status','=',\constSubscription::Expired)->where('trn_subscriptions.status','!=',\constSubscription::renewed)->orderBy($sorting_field,$sorting_direction);
        }

        return $query->leftJoin('mst_plans', 'trn_subscriptions.plan_id', '=', 'mst_plans.id')->select('trn_subscriptions.*','mst_plans.plan_name')->where('trn_subscriptions.status','=',\constSubscription::Expired)->where('trn_subscriptions.status','!=',\constSubscription::renewed)->whereBetween('trn_subscriptions.created_at', [$drp_start, $drp_end])->orderBy($sorting_field,$sorting_direction);
    }

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

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

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

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