Файловый менеджер - Редактировать - /home/clickysoft/public_html/assets.clickysoft.net/app/Repositories/AssignableAssetsRepository.php
Назад
<?php namespace App\Repositories; use App\Models\Asset; use Illuminate\Http\Request; class AssignableAssetsRepository implements AssignableAssetsRepositoryInterface { public function getAllAssignableAssets(Request $request) { $assets = Asset::with([ 'company:id,name', 'branch:id,name', 'category:id,name', ])->where('assignable', 1); if ($request->filled('search')) { $assets = $assets->where("asset_name", "like", "%" . $request->get("search", "") . "%"); $assets = $assets->orWhereHas('company', function ($q) use ($request) { $q->where('name', 'like', '%' . $request->search . '%')->orWhere('contact_number', 'like', '%' . $request->search . '%'); })->orWhereHas('branch', function ($q) use ($request) { $q->where('name', 'like', '%' . $request->search . '%')->orWhere('email', 'like', '%' . $request->search . '%')->orWhere('contact_number', 'like', '%' . $request->search . '%'); })->orWhereHas('supplier', function ($q) use ($request) { $q->where('contact_name', 'like', '%' . $request->search . '%')->orWhere('contact_email', 'like', '%' . $request->search . '%'); })->orWhereHas('category', function ($q) use ($request) { $q->where('name', 'like', '%' . $request->search . '%'); })->orWhereHas('currency', function ($q) use ($request) { $q->where('name', 'like', '%' . $request->search . '%')->orWhere('code', 'like', '%' . $request->search . '%')->orWhere('symbol', 'like', '%' . $request->search . '%'); }); } return $assets->orderBy("id", "desc")->paginate(50); } public function getAssignableAsset($id) { return Asset::with([ 'company:id,name', 'branch:id,name', 'asset_status:id,name', 'category:id,name', ])->where('assignable', 1)->findOrFail($id); } }
| ver. 1.4 |
Github
|
.
| PHP 8.1.29 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка