Traversify::__queryFilter() - Code Metrics - alohajaycee/laravel-traversify - Measure and Improve Code Quality continuously with Scrutinizer

Traversify::__queryFilter() C
last analyzed 2019-07-12 05:29 UTC

↳ Parent: Traversify
Complexity

Conditions	12
Paths	2
Size

Total Lines	53
Code Lines	29
Duplication

Lines	0
Ratio	0 %
Importance

Changes	1
Bugs	0	Features	0
Metric	Value
cc	12
eloc	29
c	1
b	0
f	0
nc	2
nop	0
dl	0
loc	53
rs	6.9666
How to fix Long Method Complexity

<?php

namespace Traversify;

trait Traversify
{
    public      $search;    # Search keyword (String)

    public      $filter;    # Query filters (Array)

    public      $custom;     # Custom queries

    public      $take;      # For limited show (Integer)

    public      $order;     # Order of list (Array)

    public      $range;     # Range of query (Array)

    public      $limit;     # Limit show - Paginate Prerequesit ()

    public      $expose;    # Returns all data (Uses get instead of paginate)
    
    public      $debug;     # For testing;

    private     $query;     # Query builder


    public static function traversify($custom = NULL)
    {
        $_traverse = new self;

        return $_traverse->traverse($custom);
    }


    public function traverse($custom = NULL)
    {
        $custom && $this->custom = $custom;
    
        $this->__getters();

        \DB::enableQueryLog();
filter:
    dependency_paths: ["lib/*"]

        $result = $this->__queryBuilder();

        if($this->debug && env('APP_DEBUG')):
        if($this->debug && /** @scrutinizer ignore-call */ env('APP_DEBUG')):

            return \DB::getQueryLog();

        else:

            return $result;

        endif;
    }

    private function __queryBuilder()
    {
        $this->query = $this->query();
        $this->query = $this->query();
        
        $queries = ['Search','Filter','Range', 'Order', 'Custom'];

        self::loader($queries,'__query');
              loader($queries,'__query');
       
        return ($this->expose || $this->take) ? ['data' => $this->query->take($this->take)->get()] : $this->query->paginate($this->limit);
    }

    private function __queryCustom()
    {
        if(!isset($this->custom)) return;

        $this->query->where($this->custom);
    }

    private function __querySearch()
    {
        if(!isset(self::$searchables)) return;


        $this->query->where( function($query)
        {
            foreach(self::$searchables ?: [] as $searchable):

                
                $_searchable = explode('~',$searchable);

                if(count($_searchable)>1):
                    
                    $query->with($_searchable[0])->orWhereHas($_searchable[0], function($query) use ( $_searchable )
                      {
                          $query->where($_searchable[1],'LIKE','%'.$this->search.'%');    
                      });
                  else:
                      $query->orWhere($searchable,'LIKE','%'.$this->search.'%');     
                  endif;

            endforeach;
        });
    }

    private function __queryFilter()
    {
        if(!isset(self::$filterables)) return;

        
        $this->query->where(function($query)
        {
            foreach($this->filter ?: [] as $attribute => $value):

                $value == 'null' && $value = null;

                if(in_array($attribute, self::$filterables)):


                    $relationship = explode('~', $attribute);

                    if(count($relationship) == 2):

                        if($value[0]=='!'):

                            $values = explode(',',substr($value,1));

                            $value == 'null' && $value = null;


                            $query->with($relationship[0])->whereHas($relationship[0],function($query) use ( $relationship, $values)
                            {
                                $query->whereNotIn($relationship[1],$values);                                    
                            });

                        else:
                
                            $values = explode(',',$value);

                            $query->with($relationship[0])->whereHas($relationship[0],function($query) use ( $relationship, $values, $value)
                            {
                                count($values) > 1 ? $query->whereIn($relationship[1],$values) : $query->where($relationship[1],$value);                            
                            });
                            
                        endif;

                    else:
                        if($value[0]=='!'):

                            $values = explode(',',substr($value,1));
        
                            $query->where(function($query) use ($attribute, $values)
                            {
                                $query->whereNotIn($attribute,$values);
                            });
                            
                        else:
                
                            $values = explode(',',$value);
                            
                            count($values) > 1 ? $query->whereIn($attribute,$values) : $query->where($attribute,$value);
    
                        endif;

                    endif;

                endif;
    
            endforeach;
        });
    }

    private function __queryRange()
    {
        if(!isset(self::$rangables)) return;


        $this->query->where(function($query)
        {
            foreach($this->range ?: [] as $attribute => $value):

                if(in_array($attribute, self::$rangables)):


                    $relationship = explode('~', $attribute);

                    if(count($relationship) == 2):

                        if($value[0]=='!'):

                            $values = explode(',',substr($value,1));

                            $query->with($relationship[0])->whereHas($relationship[0],function($query) use ( $relationship, $values)
                            {
                                $query->whereNotBetween($relationship[1],$values);                                    
                            });

                        else:
                
                            $values = explode(',',$value);

                            $query->with($relationship[0])->whereHas($relationship[0],function($query) use ( $relationship, $values, $value)

                            {
                               $query->whereBetween($relationship[1],$values);                            
                            });
                            
                        endif;

                    else:

                        if($value[0]=='!'):

                            $values = explode(',',substr($value,1));
        
                            $query->where(function($q) use ($attribute, $values)
                            {
                                $q->whereNotBetween($attribute,$values);
                            });
                            
                        else:

                            $values = explode(',',$value);
        
                            $query->whereBetween($attribute,$values);
        
                        endif;

                    endif;

                endif;

            endforeach;
        });
    }

    private function __queryOrder()
    {
        if(!isset(self::$orderables)) return;


        foreach($this->order ?: [] as $attribute => $value):

            if(in_array($attribute, self::$orderables)):
                
                $relationship = explode('~', $attribute);

                if(count($relationship) == 2):
                   
                    $this->query->with([$relationship[0] => function($query) use ( $relationship, $value)
                    {
                        $query->orderBy($relationship[1],$value); 
                    }]);

                else:

                    $this->query->orderBy($attribute, $value);

                endif;
                
            endif;

        endforeach;
    }

    private function __getters ( $getters = ['search', 'filter', 'take', 'order', 'range', 'limit', 'expose', 'debug'] )
    {
        foreach($getters as $getter):
            !$this->$getter && $this->$getter = request()->get($getter);
            !$this->$getter && $this->$getter = /** @scrutinizer ignore-call */ request()->get($getter);
        endforeach;
    }

    private function loader($loads, $prefix = '__')
    {
        foreach($loads as $load):
            
            self::{$prefix.$load}();

        endforeach;
    }
}
alohajaycee / laravel-traversify

Traversify::__queryFilter() C last analyzed 2019-07-12 05:29 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like

Traversify::__queryFilter() C
last analyzed 2019-07-12 05:29 UTC
