App\Payment_detail

Complexity

Total Complexity

9

Size/Duplication

Total Lines	60
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
B	scopeIndexQuery()	0	18	5
A	createdBy()	0	3	1
A	Cheque()	0	3	1
A	updatedBy()	0	3	1
A	Invoice()	0	3	1

<?php

namespace App;

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

class Payment_detail extends Model
{
	 protected $table = 'trn_payment_details';

	 protected $fillable = [
	 		'payment_amount',
	 		'note',
	 		'mode',
	 		'invoice_id',
	 		'created_by',
    		'updated_by',
	 ];

     //Eloquence Search mapping
    use Eloquence;

    protected $searchableColumns = [
        'payment_amount' => 20,
        'Invoice.invoice_number' => 20,
        'Invoice.member.name' => 20,
    ];  

    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('trn_invoice','trn_payment_details.invoice_id','=','trn_invoice.id')
                         ->leftJoin('mst_members','trn_invoice.member_id','=','mst_members.id')
                         ->select('trn_payment_details.id','trn_payment_details.created_at','trn_payment_details.payment_amount','trn_payment_details.mode','trn_payment_details.invoice_id','trn_invoice.invoice_number','mst_members.id as member_id','mst_members.name as member_name','mst_members.member_code')
                         ->orderBy($sorting_field,$sorting_direction);
        }

        return $query->leftJoin('trn_invoice','trn_payment_details.invoice_id','=','trn_invoice.id')
                     ->leftJoin('mst_members','trn_invoice.member_id','=','mst_members.id')
                     ->select('trn_payment_details.id','trn_payment_details.created_at','trn_payment_details.payment_amount','trn_payment_details.mode','trn_invoice.invoice_number','mst_members.name as member_name','mst_members.member_code')
                     ->whereBetween('trn_payment_details.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 Invoice()
    {
    	return $this->belongsTo('App\Invoice','invoice_id');
    }    
	
	public function Cheque()
    {
        return $this->hasOne('App\Cheque_detail','payment_id');
    }
}