Go to the documentation of this file.
 <?php
 namespace App\Models;
 
 use App\Models\User;
 use App\Models\ConsumableAssignment;
 use App\Models\Company;
 use App\Models\Location;
 use App\Models\Category;
 use App\Models\ActionLog;
 use Illuminate\Database\Eloquent\Model;
 use Illuminate\Database\Eloquent\SoftDeletes;
 use Watson\Validating\ValidatingTrait;
 
 class Consumable extends Model
 {
     use SoftDeletes;
     use CompanyableTrait;
 
     protected $dates = ['deleted_at'];
     protected $table = 'consumables';
 
 
     public $rules = array(
         'name'        => 'required|min:3|max:255',
         'qty'         => 'required|integer|min:0',
         'category_id' => 'required|integer',
         'company_id'  => 'integer',
         'min_amt'     => 'integer|min:1',
     );
 
     protected $injectUniqueIdentifier = true;
     use ValidatingTrait;
 
     protected $fillable = ['name','qty','company_id','category_id'];
 
 
     public function admin()
     {
         return $this->belongsTo('\App\Models\User', 'user_id');
     }
 
     public function consumableAssigments()
     {
         return $this->hasMany('\App\Models\ConsumableAssignment');
     }
 
     public function company()
     {
         return $this->belongsTo('\App\Models\Company', 'company_id');
     }
 
     public function location()
     {
         return $this->belongsTo('\App\Models\Location', 'location_id');
     }
 
     public function category()
     {
         return $this->belongsTo('\App\Models\Category', 'category_id');
     }
 
     public function assetlog()
     {
         return $this->hasMany('\App\Models\Actionlog', 'consumable_id')->where('asset_type', '=', 'consumable')->orderBy('created_at', 'desc')->withTrashed();
     }
 
 
     public function users()
     {
         return $this->belongsToMany('\App\Models\User', 'consumables_users', 'consumable_id', 'assigned_to')->withPivot('user_id')->withTrashed()->withTimestamps();
     }
 
     public function hasUsers()
     {
         return $this->belongsToMany('\App\Models\User', 'consumables_users', 'consumable_id', 'assigned_to')->count();
     }
 
 
     public function requireAcceptance()
     {
         return $this->category->require_acceptance;
     }
 
     public function getEula()
     {
 
         $Parsedown = new \Parsedown();
 
         if ($this->category->eula_text) {
             return $Parsedown->text(e($this->category->eula_text));
         } elseif ((Setting::getSettings()->default_eula_text) && ($this->category->use_default_eula=='1')) {
             return $Parsedown->text(e(Setting::getSettings()->default_eula_text));
         } else {
             return null;
         }
 
     }
 
     public function numRemaining()
     {
         $checkedout = $this->users->count();
         $total = $this->qty;
         $remaining = $total - $checkedout;
         return $remaining;
     }
 
     public function scopeTextSearch($query, $search)
     {
         $search = explode(' ', $search);
 
         return $query->where(function ($query) use ($search) {
         
             foreach ($search as $search) {
                     $query->whereHas('category', function ($query) use ($search) {
                         $query->where('categories.name', 'LIKE', '%'.$search.'%');
                     })->orWhere(function ($query) use ($search) {
                         $query->whereHas('company', function ($query) use ($search) {
                             $query->where('companies.name', 'LIKE', '%'.$search.'%');
                         });
                     })->orWhere(function ($query) use ($search) {
                         $query->whereHas('location', function ($query) use ($search) {
                             $query->where('locations.name', 'LIKE', '%'.$search.'%');
                         });
                     })->orWhere('consumables.name', 'LIKE', '%'.$search.'%')
                             ->orWhere('consumables.order_number', 'LIKE', '%'.$search.'%')
                             ->orWhere('consumables.purchase_cost', 'LIKE', '%'.$search.'%')
                             ->orWhere('consumables.purchase_date', 'LIKE', '%'.$search.'%');
             }
         });
     }
 
     public function scopeOrderCategory($query, $order)
     {
         return $query->join('categories', 'consumables.category_id', '=', 'categories.id')->orderBy('categories.name', $order);
     }
 
     public function scopeOrderLocation($query, $order)
     {
         return $query->leftJoin('locations', 'consumables.location_id', '=', 'locations.id')->orderBy('locations.name', $order);
     }
 
 
     public function scopeOrderCompany($query, $order)
     {
         return $query->leftJoin('companies', 'consumables.company_id', '=', 'companies.id')->orderBy('companies.name', $order);
     }
 }
Snipe-IT

Search Results
