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 : CourierService.php

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

namespace App\Services\Front;

use App\Models\Courier;
use App\Services\CourierService as ParentService;
use App\Repositories\CourierRepository;
use Illuminate\Foundation\Auth\User;

class CourierService extends ParentService
{
    /**
     * @var CourierRepository
     */
    protected $repository;

/**
     * CourierRepository constructor.
     *
     * @param CourierRepository $repository
     */
    public function __construct(CourierRepository $repository) {
        parent::__construct($repository, 'Front');
    }

/**
     * CourierRepository constructor.
     *
     * @todo Function todo
     * @description Function description
     * @since $2022Feb08
     * @param CourierRepository $repository
     */
    public function index($request){
        $this->repository->setPresenter("App\\Presenters\\Front\\Courier\\ListPresenter");
        $this->repository->pushCriteria(app('Prettus\Repository\Criteria\RequestCriteria'));
        if ($request->has('paginate') && $request->paginate) {
            return $this->repository->paginate();
        }
        return $this->repository->all();
    }

public function getActiveCouriers(){
        return Courier::where('status','active')->get();
    }

public function GetActiveCourier($request){

$courier  = Courier::with([
            'courier_deals' => function($query) use ($request) {
                if(auth()->user()->id == 148) {
                    $uid = User::findOrFail(auth()->user()->id);
                    $query->whereIn('owner_id', explode(',', $uid->team_member));
                }

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.'%')->orWhere(function ($ques) use ($request) {
                                        $ques->where('bd_order_number' ,'like', $request->deal_name.'%');
                                    });
                                });
                            });
                        });
                    });
                }

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

$query->where('owner_id', '=', $request->user_deals);

}else if(

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

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

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

$query->whereIn('owner_id', explode(',',$uid->team_member));

}else {

$query->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();

$query->whereIn('owner_id', explode(',',$uid->team_member));
                    }else{

}
                }

if(!empty($request->from) && !empty($request->to)) {
                    $query->whereHas('tracking', function ($trackingQuery) use ($request) {
                        $trackingQuery->whereBetween('shipping_date', [$request->from, $request->to]);
                    });
                } else {
                    $query->whereHas('tracking', function ($trackingQuery) {
                        $trackingQuery->whereBetween('shipping_date', [date("Y-m-01"), date("Y-m-t")]);
                    });
                }

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

$query->where('production_from' ,'=',auth()->user()->employee_country_id);
                }

$query->where('deal_status', 1)
                    ->where('complete_status', 0)
                    ->where(function ($q) {
                        $q->where(function ($qs) {
                            $qs->where('bd_pipeline_stage_id', 4)->where('pipeline_stage_id', 5);
                        })->orWhere('pipeline_stage_id', 4);
                    });
            },
            'courier_deals.client',
            'courier_deals.tracking' => function($query) use ($request) {
                if(!empty($request->user_deals)) {
                    $query->where('courier_id', $request->user_deals);
                }

if(!empty($request->from) && !empty($request->to)) {
                    $query->whereBetween('shipping_date', [$request->from, $request->to]);
                } else {
                    $query->whereBetween('shipping_date', [date("Y-m-01"), date("Y-m-t")]);
                }
            },
            'courier_deals.dealProducts',
            'courier_deals.dealProducts.product',
            'courier_deals.dealProducts.productstyle'
        ])->where('id', 1)->get();

return $courier;

}

${this.title}

Code Editor : CourierService.php