AssetMaintenance.php

Go to the documentation of this file.

<?php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Lang;
use Illuminate\Database\Eloquent\SoftDeletes;
use Watson\Validating\ValidatingTrait;

class AssetMaintenance extends Model implements ICompanyableChild
{
    use SoftDeletes;
    use CompanyableChildTrait;


    protected $dates = [ 'deleted_at' ];
    protected $table = 'asset_maintenances';

    // Declaring rules for form validation
    protected $rules = [
        'asset_id'               => 'required|integer',
        'supplier_id'            => 'required|integer',
        'asset_maintenance_type' => 'required',
        'title'                  => 'required|max:100',
        'is_warranty'            => 'boolean',
        'start_date'             => 'required|date_format:Y-m-d',
        'completion_date'        => 'date_format:Y-m-d',
        'notes'                  => 'string',
        'cost'                   => 'numeric'
    ];

    public function getCompanyableParents()
    {
        return [ 'asset' ];
    }

    public static function getImprovementOptions()
    {

        return [
            Lang::get('admin/asset_maintenances/general.maintenance') => Lang::get('admin/asset_maintenances/general.maintenance'),
            Lang::get('admin/asset_maintenances/general.repair')      => Lang::get('admin/asset_maintenances/general.repair'),
            Lang::get('admin/asset_maintenances/general.upgrade')     => Lang::get('admin/asset_maintenances/general.upgrade')
        ];
    }

    public function asset()
    {

        return $this->belongsTo('\App\Models\Asset', 'asset_id')
                    ->withTrashed();
    }

    public function supplier()
    {

        return $this->belongsTo('\App\Models\Supplier', 'supplier_id')
                    ->withTrashed();
    }

    public function scopeDeleted($query)
    {

        return $query->whereNotNull('deleted_at');
    }

    public function scopeTextSearch($query, $search)
    {

         return $query->where(function ($query) use ($search) {

                $query->where('title', 'LIKE', '%'.$search.'%')
                ->orWhere('notes', 'LIKE', '%'.$search.'%')
                ->orWhere('asset_maintenance_type', 'LIKE', '%'.$search.'%')
                ->orWhere('cost', 'LIKE', '%'.$search.'%')
                ->orWhere('start_date', 'LIKE', '%'.$search.'%')
                ->orWhere('completion_date', 'LIKE', '%'.$search.'%');
         });
    }
}