Gecko [ thecigaretteboxes.com ]

Name	Size	Permission
AgentRawDataCriteria.php	689 B	-rw-r--r--
ClientCriteria.php	1.07 KB	-rw-r--r--
DealCriteria.php	982 B	-rw-r--r--
DealProductCriteria.php	900 B	-rw-r--r--
PipelineCriteria.php	2.69 KB	-rw-r--r--
PipelineStageCriteria.php	1.17 KB	-rw-r--r--
ProductColorCriteria.php	950 B	-rw-r--r--
ProductCriteria.php	901 B	-rw-r--r--
ProductMeasurementUnitCriteria...	970 B	-rw-r--r--
ProductPrintingCriteria.php	956 B	-rw-r--r--
ProductStockCriteria.php	950 B	-rw-r--r--
RoleCriteria.php	606 B	-rw-r--r--
UserCriteria.php	730 B	-rw-r--r--

Code Editor : PipelineCriteria.php

<?php

namespace App\Criteria;

use Prettus\Repository\Contracts\CriteriaInterface;
use Prettus\Repository\Contracts\RepositoryInterface;
use Auth;
use Illuminate\Http\Request;
use Carbon\Carbon;
use Illuminate\Support\Facades\DB;

/**
 * Class PipelineCriteria.
 *
 * @package namespace App\Criteria;
 */
class PipelineCriteria implements CriteriaInterface
{
    /**
     * @var \Illuminate\Http\Request
     */
    protected $request;

public function __construct(Request $request = null)
    {
        $this->request = $request;
    }

/**
     * Apply criteria in query repository
     *
     * @param string              $model
     * @param RepositoryInterface $repository
     *
     * @return mixed
     */
    public function apply($model, RepositoryInterface $repository)
    {
        $request = $this->request;

if($request->has('deal_name') ||  $request->has('user_deals') ||  $request->has('from') ||  $request->has('to') ){

$model = $model->with(['pipelineStages.deals' => function($query) use ($request) {

if($request->has('deal_name') ) {

$query->whereHas('client', function ($queryu) use ($request) {
                        $queryu->where('name', 'like', $request->deal_name . '%')->orWhere(function ($ques) use ($request) {
                            $ques->whereHas('clientDetails', function ($queryu) use ($request) {
                                $queryu->where('value', 'like', $request->deal_name . '%')->orWhere(function ($ques) use ($request) {
                                    $ques->where('order_number' ,'like', $request->deal_name.'%');
                                });
                            });
                        });
                    });

//   $query->where('order_number', 'like', $request->deal_name . '%');
                }if(!empty($request->get('user_deals') )) {

$query->where('owner_id' ,'=', $request->user_deals);
                }
               if(!empty($request->get('from') && $request->get('to'))) {
                    $query->whereBetween('open_date', [date($request->from) , date($request->to)]);
                }

}]);
        }else{
            $model = $model->with(['pipelineStages.deals' => function($query) use ($request) {
                $first = date("Y-m-d", strtotime("first day of this month"));
                $last = date("Y-m-d", strtotime("last day of this month"));
              if(auth()->user()->id!=1) {
                  $query->where('owner_id', '=', auth()->user()->id);
              }

$query->whereBetween('open_date', [date($first) , date($last)]);

}]);

}

return $model;
    }
}

${this.title}

Code Editor : PipelineCriteria.php