Gecko [ thecigaretteboxes.com ]

Name	Size	Permission
ActivityService.php	1.21 KB	-rw-r--r--
ClientService.php	2.64 KB	-rw-r--r--
CourierService.php	5.78 KB	-rw-r--r--
DealProductService.php	940 B	-rw-r--r--
DealService.php	348.36 KB	-rw-r--r--
EmailPhoneDetailService.php	1.28 KB	-rw-r--r--
FileService.php	1.17 KB	-rw-r--r--
NoteService.php	1.17 KB	-rw-r--r--
PipelineService.php	88.35 KB	-rw-r--r--
PipelineStageService.php	1.59 KB	-rw-r--r--
ProductService.php	1.31 KB	-rw-r--r--
UserService.php	1.32 KB	-rw-r--r--
VendorService.php	3.66 KB	-rw-r--r--

Code Editor : PipelineService.php

<?php
/**
 * Created by crm_entity command.
 * @author : Muhammad Saeed
 * @todo   : Service todo
 * @since  : $2021Aug31
 * @description : Service description
 */

namespace App\Services\Front;

use App\Models\Deal;
use App\Models\PipelineStage;
use App\Services\Front\DealService;

use App\Services\PipelineService as ParentService;
use App\Repositories\PipelineRepository;
use App\Criteria\PipelineCriteria;

use Illuminate\Foundation\Auth\User;
use Spatie\Fractal\Fractal;
use App\Transformers\Front\Pipeline\ListTransformer as PipelineListTransformer;

class PipelineService extends ParentService
{
    /**
     * @var PipelineRepository
     */
    protected $repository;

/**
     * @var DealService
     */
    protected $service;
    /**
     * DealController constructor.
     *
     * @param DealService $service
     */

/**
     * PipelineRepository constructor.
     *
     * @param PipelineRepository $repository
     */
    public function __construct(PipelineRepository $repository,  DealService $service) {
        $this->service = $service;
        parent::__construct($repository, 'Front');
    }

/**
     * PipelineRepository constructor.
     *
     * @todo Function todo
     * @description Function description
     * @since $2021Aug31
     * @param PipelineRepository $repository
     */
    public function index($request){

$this->repository->setPresenter("App\\Presenters\\Front\\Pipeline\\ListPresenter");
        $this->repository->pushCriteria(app('Prettus\Repository\Criteria\RequestCriteria'));
        $this->repository->pushCriteria(new PipelineCriteria($request));

if ($request->has('paginate') && $request->paginate) {
            return $this->repository->paginate();
        }

return $this->repository->all();
    }

public function getBoardData($request)
    {

if ($request->has('paginate') && $request->paginate) {
            $pipelines = $pipelines->paginate();

}else{
            $pipelines = $pipelines->all();
        }

return $pipelines;
    }

public function getProductionData($request)
    {

if ($request->has('paginate') && $request->paginate) {
            $pipelines = $pipelines->paginate();
        }else{
            $pipelines = $pipelines->all();
        }
        return $pipelines;
    }

public function getPieChartData($request)
    {

if ($request->has('paginate') && $request->paginate) {

$pipelines = $pipelines->paginate();
        } else {
            $pipelines = $pipelines->all();
        }

if (!empty($request->get('from') || $request->get('to') || $request->get('user_deals') || $request->get('deal_name'))) {
            $pieChartData['total_leads'] = Deal::select('*')->with(['deals', 'client'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('1', '2', '3', '6', '11', '12'));
            if ($request->has('deal_name')) {
                $pieChartData['total_leads']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['total_leads']->where('owner_id', '=', $request->user_deals);

}else if(

!auth()->user()->hasRole('Sales Data Entry') && !auth()->user()->hasRole('super-admin')
            ) {
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_leads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_leads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['total_leads']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_leads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_leads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(auth()->user()->employee_country_id==2){

$pieChartData['total_leads']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if(!empty($request->get('sale_type') )) {

$pieChartData['total_leads']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['total_leads']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['total_leads']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['total_leads']->where('domain_id' ,'=', $request->domain_id);
            }

if (!empty($request->get('from') && $request->get('to'))) {
                $pieChartData['total_leads']->whereBetween('open_date', [date($request->from), date($request->to)]);

}
            $pieChartData['total_leads']->where('deal_status', '=', '1');
            $pieChartData['total_leadss'] = $pieChartData['total_leads']->count();
            $pieChartData['total_lead'] = $pieChartData['total_leadss'];

} else {

$first =date("Y-m-d", strtotime("first day of this month"));
            $last = date("Y-m-d", strtotime("last day of this month"));

$pieChartData['total_leads'] = Deal::select('*')->with(['deals', 'client', 'dealProducts', 'dealProducts.product', 'dealProducts.productstyle'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('1', '2', '3', '6', '11', '12'));
            if ($request->has('deal_name')) {
                $pieChartData['total_leads']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['total_leads']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['total_leads']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['total_leads']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['total_leads']->where('domain_id' ,'=', $request->domain_id);
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['total_leads']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['total_leads']->whereIn('owner_id', explode(',',$uid->team_member));
                }else{
                    $pieChartData['total_leads']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_leads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_leads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }
            if(!empty($request->get('clost_reason') )) {

$pieChartData['total_leads']->where('lost_reason' ,'=', $request->clost_reason);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['total_leads']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if (!empty($request->get('from') && $request->get('to'))) {
                $pieChartData['total_leads']->whereBetween('open_date', [date($request->from), date($request->to)]);

} else {

$first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));
                $pieChartData['total_leads']->whereBetween('open_date', [date($first), date($last)]);

}
//////////////

if (!empty($request->get('from') || $request->get('to') || $request->get('user_deals') || $request->get('deal_name'))) {

$pieChartData['total_dead_lead'] = Deal::select('*')->with(['deals', 'client','deal_amount'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('13'));
            if ($request->has('deal_name')) {
                $pieChartData['total_dead_lead']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['total_dead_lead']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['total_dead_lead']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_dead_lead']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['total_dead_lead']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_dead_lead']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_dead_lead']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['total_dead_lead']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['total_dead_lead']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['total_dead_lead']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['total_dead_lead']->where('domain_id' ,'=', $request->domain_id);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['total_dead_lead']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }

if(!empty($request->get('from') && $request->get('to'))) {
                $first =date("Y-m-d", strtotime("first day of this month"));
                $last = date("Y-m-d", strtotime("last day of this month"));

$pieChartData['total_dead_lead']->whereBetween('close_date', [date($request->get('from')), date($request->get('to'))]);

}else{

$first =date("Y-m-d", strtotime("first day of this month"));
                $last = date("Y-m-d", strtotime("last day of this month"));

if (empty($request->get('from') && $request->get('to'))) {
                    $pieChartData['total_dead_lead']->whereBetween('close_date', [date($first), date($last)]);

}

}
            $pieChartData['total_dead_lead']->where('deal_status', '=', '1');
            $pieChartData['total_dead'] = $pieChartData['total_dead_lead']->count();

$pieChartData['total'] = $pieChartData['total_lead'] + $pieChartData['total_dead'];

} else {
            $first =date("Y-m-d", strtotime("first day of this month"));
            $last = date("Y-m-d", strtotime("last day of this month"));
            $pieChartData['total_dead_lead'] = Deal::select('*')->with(['deals', 'client'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('13'));
            if ($request->has('deal_name')) {
                $pieChartData['total_dead_lead']->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 . '%');
                            });
                        });
                    });
                });
            }
            if(!empty($request->get('user_deals') )) {

$pieChartData['total_dead_lead']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['total_dead_lead']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_dead_lead']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['total_dead_lead']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_dead_lead']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_dead_lead']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }
            if(!empty($request->get('sale_type') )) {

$pieChartData['total_dead_lead']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['total_dead_lead']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['total_dead_lead']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['total_dead_lead']->where('domain_id' ,'=', $request->domain_id);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['total_dead_lead']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if (empty($request->get('from') && $request->get('to'))) {
                $first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));

$pieChartData['total_dead_lead']->whereBetween('close_date', [date($first), date($last)]);

}
            $pieChartData['total_dead_lead']->where('deal_status', '=', '1');
            $pieChartData['total_dead'] = $pieChartData['total_dead_lead']->count();

$pieChartData['total'] = $pieChartData['total_lead'] + $pieChartData['total_dead'];

}

////////////////////////
        if (!empty($request->get('from') || $request->get('to') || $request->get('user_deals') || $request->get('deal_name'))) {

$pieChartData['total_close_won'] = Deal::select('*')->with(['deals', 'client','deal_amount'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('4'));
            if ($request->has('deal_name')) {
                $pieChartData['total_close_won']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['total_close_won']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['total_close_won']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_won']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['total_close_won']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_won']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_won']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['total_close_won']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['total_close_won']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['total_close_won']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['total_close_won']->where('domain_id' ,'=', $request->domain_id);
            }

if(auth()->user()->employee_country_id==2){

$pieChartData['total_close_won']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if(!empty($request->get('from') && $request->get('to'))) {

$pieChartData['total_close_won']->whereHas('deal_amount', function ($queryu) use ($request) {

$queryu->whereBetween('receiving_date', [date($request->from) , date($request->to)]);
                });

}else{

$pieChartData['total_close_won']->whereHas('deal_amount', function ($queryu) use ($request) {
                    $first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));
                    $queryu->whereBetween('receiving_date', [date($first) , date($last)]);
                });

}
            $pieChartData['total_close_won']->where('deal_status', '=', '1');
            $pieChartData['total_close'] = $pieChartData['total_close_won']->count();

$pieChartData['total'] = $pieChartData['total_lead'] + $pieChartData['total_close'] + $pieChartData['total_dead'];

} else {
            $first =date("Y-m-d", strtotime("first day of this month"));
            $last = date("Y-m-d", strtotime("last day of this month"));
            $pieChartData['total_close_won'] = Deal::select('*')->with(['deals', 'client'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('4'));
            if ($request->has('deal_name')) {
                $pieChartData['total_close_won']->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 . '%');
                            });
                        });
                    });
                });
            }
            if(!empty($request->get('user_deals') )) {

$pieChartData['total_close_won']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['total_close_won']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_won']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['total_close_won']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_won']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_won']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }
            if(!empty($request->get('sale_type') )) {

$pieChartData['total_close_won']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['total_close_won']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['total_close_won']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['total_close_won']->where('domain_id' ,'=', $request->domain_id);
            }

if (empty($request->get('from') && $request->get('to'))) {
                $pieChartData['total_close_won']->whereBetween('close_date', [date($first), date($last)]);

}
            if(auth()->user()->employee_country_id==2){

$pieChartData['total_close_won']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            $pieChartData['total_close_won']->where('deal_status', '=', '1');
            $pieChartData['total_close'] = $pieChartData['total_close_won']->count();

$pieChartData['total'] = $pieChartData['total_lead'] + $pieChartData['total_close'] + $pieChartData['total_dead'];

}

if (!empty($request->get('from') || $request->get('to') || $request->get('user_deals') || $request->get('deal_name'))) {

$pieChartData['total_close_lost'] = Deal::select('*')->with(['deals', 'client'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('5'));

if ($request->has('deal_name')) {
                $pieChartData['total_close_lost']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['total_close_lost']->where('sale_type' ,'=', $request->sale_type);
            }

if(!empty($request->get('priority_id') )) {

$pieChartData['total_close_lost']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['total_close_lost']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['total_close_lost']->where('domain_id' ,'=', $request->domain_id);
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['total_close_lost']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['total_close_lost']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_lost']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['total_close_lost']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager') ){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_lost']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_lost']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['total_close_lost']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['total_close_lost']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['total_close_lost']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['total_close_lost']->where('domain_id' ,'=', $request->domain_id);
            }

if(!empty($request->get('clost_reason') )) {

$pieChartData['total_close_lost']->where('lost_reason' ,'=', $request->clost_reason);
            }

if(auth()->user()->employee_country_id==2){

$pieChartData['total_close_lost']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }

if (!empty($request->get('from') && $request->get('to'))) {
                $pieChartData['total_close_lost']->whereBetween('close_date', [date($request->from), date($request->to)]);

}
            $pieChartData['total_close_lost']->where('deal_status', '=', '1');
            $pieChartData['total_lost'] = $pieChartData['total_close_lost']->count();

$pieChartData['total'] = $pieChartData['total_lead'] + $pieChartData['total_close'] + $pieChartData['total_lost'] + $pieChartData['total_dead'];

} else {
            $first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));
            $pieChartData['total_close_lost'] = Deal::select('*')->with(['deals', 'client'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('5'));
            if ($request->has('deal_name')) {
                $pieChartData['total_close_lost']->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 . '%');
                            });
                        });
                    });
                });
            }
            if(!empty($request->get('user_deals') )) {

$pieChartData['total_close_lost']->where('owner_id', '=', $request->user_deals);

}else  if(    !auth()->user()->hasRole('Sales Data Entry') && !auth()->user()->hasRole('super-admin')) {
                $pieChartData['total_close_lost']->where('owner_id', '=', auth()->user()->id);

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_lost']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['total_close_lost']->whereIn('owner_id', explode(',',$uid->team_member));

}

else{

}
            }
            if(!empty($request->get('clost_reason') )) {

$pieChartData['total_close_lost']->where('lost_reason' ,'=', $request->clost_reason);
            }
            if (empty($request->get('from') && $request->get('to'))) {
                $pieChartData['total_close_lost']->whereBetween('close_date', [date($first), date($last)]);

}

if(!empty($request->get('clost_reason') )) {

$pieChartData['total_close_lost']->where('lost_reason' ,'=', $request->clost_reason);
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['total_close_lost']->where('sale_type' ,'=', $request->sale_type);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['total_close_lost']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }

if(!empty($request->get('priority_id') )) {

$pieChartData['total_close_lost']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['total_close_lost']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['total_close_lost']->where('domain_id' ,'=', $request->domain_id);
            }
            $pieChartData['total_close_lost']->where('deal_status', '=', '1');
            $pieChartData['total_lost'] = $pieChartData['total_close_lost']->count();

$pieChartData['total'] = $pieChartData['total_lead'] + $pieChartData['total_close'] + $pieChartData['total_lost'] + $pieChartData['total_dead'];
        }

if (!empty($request->get('from') || $request->get('to') || $request->get('user_deals') || $request->get('deal_name'))) {
            $pieChartData['deads'] = Deal::select('*')->with(['deals', 'client'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('13'));
            if ($request->has('deal_name')) {
                $pieChartData['deads']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['deads']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['deads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['deads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['deads']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['deads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['deads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['deads']->where('sale_type' ,'=', $request->sale_type);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['deads']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['deads']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['deads']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['deads']->where('domain_id' ,'=', $request->domain_id);
            }

if (!empty($request->get('from') && $request->get('to'))) {
                $pieChartData['deads']->whereBetween('close_date', [date($request->from), date($request->to)]);

}
            $pieChartData['deads']->where('deal_status', '=', '1');
            $pieChartData['deads'] = $pieChartData['deads']->count();

$pieChartData['dead'] = $pieChartData['deads'] * 100 / ($pieChartData['total'] ?: 1);

} else {

$pieChartData['deads'] = Deal::select('*')->with(['deals', 'client', 'deal_amount'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('13'));
            if ($request->has('deal_name')) {
                $pieChartData['deads']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['deads']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['deads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['deads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['deads']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['deads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['deads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['deads']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['deads']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['deads']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['deads']->where('domain_id' ,'=', $request->domain_id);
            }

if(auth()->user()->employee_country_id==2){

$pieChartData['deads']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }

if (!empty($request->get('from') && $request->get('to'))) {
                $pieChartData['deads']->whereBetween('close_date', [date($request->from), date($request->to)]);

}else{

$first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));
                $pieChartData['deads']->whereBetween('close_date', [date($first), date($last)]);

}

$pieChartData['deads']->where('deal_status', '=', '1');

$pieChartData['deads'] = $pieChartData['deads']->count();

$pieChartData['dead'] = $pieChartData['deads'] * 100 / ($pieChartData['total'] ?: 1);

}

if (!empty($request->get('from') || $request->get('to') || $request->get('user_deals') || $request->get('deal_name'))) {
            $pieChartData['wins'] = Deal::select('*')->with(['deals', 'client'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('4'));
            if ($request->has('deal_name')) {
                $pieChartData['wins']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['wins']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['wins']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['wins']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['wins']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager') ){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['wins']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['wins']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['wins']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['wins']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['wins']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['wins']->where('domain_id' ,'=', $request->domain_id);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['wins']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }

if (!empty($request->get('from') && $request->get('to'))) {

$pieChartData['wins']->whereHas('deal_amount', function ($queryu) use ($request) {

$queryu->whereBetween('receiving_date', [date($request->from), date($request->to)]);
                });

}
            $pieChartData['wins']->where('deal_status', '=', '1');
            $pieChartData['wins'] = $pieChartData['wins']->count();

$pieChartData['win'] = $pieChartData['wins'] * 100 / ($pieChartData['total'] ?: 1);

} else {

$pieChartData['wins'] = Deal::select('*')->with(['deals', 'client', 'deal_amount'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('4'));
            if ($request->has('deal_name')) {
                $pieChartData['wins']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['wins']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['wins']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['wins']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['wins']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['wins']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['wins']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['wins']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['wins']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['wins']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['wins']->where('domain_id' ,'=', $request->domain_id);
            }

if(auth()->user()->employee_country_id==2){

$pieChartData['wins']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if (empty($request->get('from') && $request->get('to'))) {

$pieChartData['wins']->whereHas('deal_amount', function ($queryu) use ($request) {
                    $first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));

$queryu->whereBetween('receiving_date', [date($first), date($last)]);
                });

}

$pieChartData['wins']->where('deal_status', '=', '1');

$pieChartData['wins'] = $pieChartData['wins']->count();

$pieChartData['win'] = $pieChartData['wins'] * 100 / ($pieChartData['total'] ?: 1);

}
        if (!empty($request->get('from') && $request->get('to') || $request->get('user_deals') || $request->has('deal_name'))) {

$pieChartData['estimations'] = Deal::select('*')->with(['deals', 'client'])->whereIn('pipeline_stage_id', array('2'));
            if ($request->has('deal_name')) {
                $pieChartData['estimations']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['estimations']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['estimations']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['estimations']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['estimations']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['estimations']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['estimations']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['estimations']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['estimations']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['estimations']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['estimations']->where('domain_id' ,'=', $request->domain_id);
            }

if (!empty($request->get('from') && $request->get('to'))) {

$pieChartData['estimations']->whereBetween('open_date', [date($request->get('from')), date($request->get('to'))]);

}
            if(auth()->user()->employee_country_id==2){

$pieChartData['estimations']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            $pieChartData['estimations']->where('deal_status', '=', '1');
            $pieChartData['estimations'] = $pieChartData['estimations']->count();

$pieChartData['estimation'] = $pieChartData['estimations'] * 100 / ($pieChartData['total'] ?: 1);

} else {

$first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));

$pieChartData['estimations']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['estimations']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['estimations']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['estimations']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['estimations']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['estimations']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['estimations']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['estimations']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['estimations']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['estimations']->where('domain_id' ,'=', $request->domain_id);
            }

if(auth()->user()->employee_country_id==2){

$pieChartData['estimations']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }

if (empty($request->get('from') && $request->get('to'))) {

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

}
            $pieChartData['estimations']->where('deal_status', '=', '1');
            $pieChartData['estimations'] = $pieChartData['estimations']->count();

$pieChartData['estimation'] = $pieChartData['estimations'] * 100 / ($pieChartData['total'] ?: 1);

}

if (!empty($request->get('from') || $request->get('to') || $request->get('user_deals') || $request->has('deal_name'))) {
            $pieChartData['losss'] = Deal::select('*')->with(['deals', 'client'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('5'));
            if ($request->has('deal_name')) {
                $pieChartData['losss']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['losss']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['losss']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['losss']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['losss']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['losss']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['losss']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('clost_reason') )) {

$pieChartData['losss']->where('lost_reason' ,'=', $request->clost_reason);
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['losss']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['losss']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['losss']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['losss']->where('domain_id' ,'=', $request->domain_id);
            }

if (!empty($request->get('from') && $request->get('to'))) {
                $pieChartData['losss']->whereBetween('close_date', [date($request->get('from')), date($request->get('to'))]);

}
            if(auth()->user()->employee_country_id==2){

$pieChartData['losss']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }

$pieChartData['losss'] = $pieChartData['losss']->count();

$pieChartData['loss'] = $pieChartData['losss'] * 100 / ($pieChartData['total'] ?: 1);

} else {
            $first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));
            $pieChartData['losss'] = Deal::select('*')->with(['deals', 'client'])->where('deal_status', '=', '1')->whereIn('pipeline_stage_id', array('5'));
            if ($request->has('deal_name')) {
                $pieChartData['losss']->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 . '%');
                            });
                        });
                    });
                });
            }
            if(!empty($request->get('user_deals') )) {

$pieChartData['losss']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['losss']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['losss']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['losss']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['losss']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['losss']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }
            if(!empty($request->get('clost_reason') )) {

$pieChartData['losss']->where('lost_reason' ,'=', $request->clost_reason);
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['losss']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['losss']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['losss']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['losss']->where('domain_id' ,'=', $request->domain_id);
            }
            if (empty($request->get('from') && $request->get('to'))) {
                $pieChartData['losss']->whereBetween('close_date', [date($first), date($last)]);

}
            if(auth()->user()->employee_country_id==2){

$pieChartData['losss']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            $pieChartData['losss'] = $pieChartData['losss']->count();
            $pieChartData['loss'] = $pieChartData['losss'] * 100 / ($pieChartData['total'] ?: 1);

}

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

$pieChartData['in-progresss'] = Deal::select('*')->with(['deals', 'client'])->whereIn('pipeline_stage_id', array('3'));

if ($request->has('deal_name')) {
                $pieChartData['in-progresss']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['in-progresss']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['in-progresss']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['in-progresss']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['in-progresss']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['in-progresss']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['in-progresss']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['in-progresss']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['in-progresss']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['in-progresss']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['in-progresss']->where('domain_id' ,'=', $request->domain_id);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['in-progresss']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }

if (!empty($request->get('from') && $request->get('to'))) {
                $pieChartData['in-progresss']->whereBetween('open_date', [date($request->get('from')), date($request->get('to'))]);

}
            $pieChartData['in-progresss']->where('deal_status', '=', '1');
            $pieChartData['in-progresss'] = $pieChartData['in-progresss']->count();

$pieChartData['in-progress'] = $pieChartData['in-progresss'] * 100 / ($pieChartData['total'] ?: 1);

} else {

$first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));
            $pieChartData['in-progresss'] = Deal::select('*')->with(['deals', 'client'])->whereIn('pipeline_stage_id', array('3'));

if (!empty($request->has('deal_name'))) {
                $pieChartData['in-progresss']->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 . '%');
                            });
                        });
                    });
                });
            }
            if(!empty($request->get('user_deals') )) {

$pieChartData['in-progresss']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['in-progresss']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['in-progresss']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['in-progresss']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['in-progresss']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['in-progresss']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['in-progresss']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['in-progresss']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['in-progresss']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['in-progresss']->where('domain_id' ,'=', $request->domain_id);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['in-progresss']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }

if (empty($request->get('from') && $request->get('to'))) {
                $pieChartData['in-progresss']->whereBetween('open_date', [date($first), date($last)]);

}
            $pieChartData['in-progresss']->where('deal_status', '=', '1');
            $pieChartData['in-progresss'] = $pieChartData['in-progresss']->count();

$pieChartData['in-progress'] = $pieChartData['in-progresss'] * 100 / ($pieChartData['total'] ?: 1);

}

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

$pieChartData['follow-ups'] = Deal::select('*')->with(['deals', 'client'])->whereIn('pipeline_stage_id', array('11'));
            if ($request->has('deal_name')) {
                $pieChartData['follow-ups']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['follow-ups']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['follow-ups']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['follow-ups']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['follow-ups']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')) {
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['follow-ups']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['follow-ups']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['follow-ups']->where('sale_type' ,'=', $request->sale_type);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['follow-ups']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['follow-ups']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['follow-ups']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['follow-ups']->where('domain_id' ,'=', $request->domain_id);
            }

if (!empty($request->get('from') && $request->get('to'))) {
                $pieChartData['follow-ups']->whereBetween('open_date', [date($request->get('from')), date($request->get('to'))]);

}
            $pieChartData['follow-ups']->where('deal_status', '=', '1');
            $pieChartData['follow-ups'] = $pieChartData['follow-ups']->count();

$pieChartData['follow-up'] = $pieChartData['follow-ups'] * 100 / ($pieChartData['total'] ?: 1);

} else {

$first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));
            $pieChartData['follow-ups'] = Deal::select('*')->with(['deals', 'client'])->whereIn('pipeline_stage_id', array('11'));
            if ($request->has('deal_name')) {
                $pieChartData['follow-ups']->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 . '%');
                            });
                        });
                    });
                });
            }
            if(!empty($request->get('user_deals') )) {

$pieChartData['follow-ups']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['follow-ups']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['follow-ups']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['follow-ups']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['follow-ups']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['follow-ups']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['follow-ups']->where('sale_type' ,'=', $request->sale_type);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['follow-ups']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['follow-ups']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['follow-ups']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['follow-ups']->where('domain_id' ,'=', $request->domain_id);
            }

if (empty($request->get('from') && $request->get('to'))) {
                $pieChartData['follow-ups']->whereBetween('open_date', [date($first), date($last)]);

}
            $pieChartData['follow-ups']->where('deal_status', '=', '1');
            $pieChartData['follow-ups'] = $pieChartData['follow-ups']->count();

$pieChartData['follow-up'] = $pieChartData['follow-ups'] * 100 / ($pieChartData['total'] ?: 1);
        }

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

$pieChartData['leads'] = Deal::select('*')->with(['deals', 'client'])->whereIn('pipeline_stage_id', array('1'));
            if ($request->has('deal_name')) {
                $pieChartData['leads']->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 . '%');
                            });
                        });
                    });
                });
            }

if(!empty($request->get('sale_type') )) {

$pieChartData['leads']->where('sale_type' ,'=', $request->sale_type);
            }
            if(auth()->user()->employee_country_id==2){

$pieChartData['leads']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['leads']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['leads']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['leads']->where('domain_id' ,'=', $request->domain_id);
            }

if(!empty($request->get('user_deals') )) {

$pieChartData['leads']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['leads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['leads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['leads']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['leads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['leads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{

}
            }

if (!empty($request->get('from') && $request->get('to'))) {
                $pieChartData['leads']->whereBetween('open_date', [date($request->get('from')), date($request->get('to'))]);

}
            $pieChartData['leads']->where('deal_status', '=', '1');
            $pieChartData['leads'] = $pieChartData['leads']->count();

$pieChartData['lead'] = $pieChartData['leads'] * 100 / ($pieChartData['total'] ?: 1);

} else {

$first =date("Y-m-d", strtotime("first day of this month"));

$last = date("Y-m-d", strtotime("last day of this month"));
            $pieChartData['leads'] = Deal::select('*')->with(['deals', 'client'])->whereIn('pipeline_stage_id', array('1'));
            if ($request->has('deal_name')) {
                $pieChartData['leads']->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 . '%');
                            });
                        });
                    });
                });
            }
            if(!empty($request->get('user_deals') )) {

$pieChartData['leads']->where('owner_id', '=', $request->user_deals);

}else if(

$pieChartData['leads']->whereIn('owner_id', explode(',',$uid->team_member));
                }elseif(  auth()->user()->id==148 ){

$uid = User::where('id',auth()->user()->id)->first();

$pieChartData['leads']->whereIn('owner_id', explode(',',$uid->team_member));

}else{
                    $pieChartData['leads']->where('owner_id', '=', auth()->user()->id);

}

}else{
                if(auth()->user()->hasRole('Team Lead') || auth()->user()->hasRole('Manager')){
                    $uid = User::where('id',auth()->user()->id)->first();

$pieChartData['leads']->whereIn('owner_id', explode(',',$uid->team_member));
                }else{

}
            }
            if(!empty($request->get('sale_type') )) {

$pieChartData['leads']->where('sale_type' ,'=', $request->sale_type);
            }
            if(!empty($request->get('priority_id') )) {

$pieChartData['leads']->where('priority_id' ,'=', $request->priority_id);
            }
            if(!empty($request->get('order_type_id') )) {

$pieChartData['leads']->where('deal_type_id' ,'=', $request->order_type_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['leads']->where('domain_id' ,'=', $request->domain_id);
            } if(!empty($request->get('domain_id') )) {

$pieChartData['leads']->where('domain_id' ,'=', $request->domain_id);
            }

if(auth()->user()->employee_country_id==2){

$pieChartData['leads']->where('production_from' ,'=',auth()->user()->employee_country_id);
            }
            if (empty($request->get('from') && $request->get('to'))) {

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

}
            $pieChartData['leads']->where('deal_status', '=', '1');
            $pieChartData['leads'] = $pieChartData['leads']->count();

$pieChartData['lead'] = $pieChartData['leads'] * 100 / ($pieChartData['total'] ?: 1);
            //    print_r($pieChartData['leads']);
        }

// dd($pieChartData);
        return $pieChartData;
    }
}

${this.title}

Code Editor : PipelineService.php