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

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

namespace App\Services\Front;

use App\Models\Vendors;
use App\Services\VendorService as ParentService;
use App\Repositories\VendorsRepository;
use Illuminate\Foundation\Auth\User;

class VendorService extends ParentService
{
    /**
     * @var VendorsRepository
     */
    protected $repository;

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

/**
     * VendorsRepository constructor.
     *
     * @todo Function todo
     * @description Function description
     * @since $2022Feb02
     * @param VendorsRepository $repository
     */
    public function index($request){
        $this->repository->setPresenter("App\\Presenters\\Front\\Vendors\\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 GetActiveVendors($request){

$vendors=Vendors::select('*')->with(['vendor_deals'=> function($que) use ($request){
            if($request->has('deal_name') ) {
                $que->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'))) {
                $que->where('vendor_id', '=', $request->user_deals);
            }

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

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

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

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

}

$que->where('shipping_status','=','0');
            $que->whereHas('production', function ($queryu) use ($request) {
                if (!empty($request->get('from') && $request->get('to'))) {
                    $queryu->whereBetween('send_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"));
                    $queryu->whereBetween('send_date', [date($first), date($last)]);
                }
            });
        },'vendor_deals.client','vendor_deals.dealProducts','vendor_deals.dealProducts.product','vendor_deals.dealProducts.productstyle'])->where('status','active')->get();

if ($vendors->has('paginate') && $vendors->paginate) {
            return $vendors->paginate();
        }
        return $vendors;

}
}

${this.title}

Code Editor : VendorService.php