Inheritance diagram for App\Models\License:

Public Member Functions
	company ()

	assignedusers ()
	Get the assigned user. More...

	assetlog ()
	Get asset logs for this asset. More...

	uploads ()
	Get uploads for this asset. More...

	adminuser ()
	Get admin user for this asset. More...

	totalSeatsByLicenseID ()
	Get total licenses. More...

	availcount ()
	Get the number of available seats. More...

	assignedcount ()
	Get the number of assigned seats. More...

	remaincount ()

	totalcount ()
	Get the total number of seats. More...

	licenseseats ()
	Get license seat data. More...

	supplier ()

	freeSeat ()

	scopeTextSearch ($query, $search)
	Query builder scope to search on text. More...

	depreciation ()
	Depreciation Relation, and associated helper methods. More...

	get_depreciation ()

	getDepreciatedValue ()

	time_until_depreciated ()

	depreciated_date ()

Static Public Member Functions
static	assetcount ()
	Get total licenses. More...

static	availassetcount ()
	Get total licenses not checked out. More...

static	getExpiringLicenses ($days=60)

Public Attributes
	$timestamps = true

Protected Attributes
	$injectUniqueIdentifier = true

	$dates = ['deleted_at']

	$guarded = 'id'

	$table = 'licenses'

	$rules

Detailed Description

Definition at line 10 of file License.php.

Member Function Documentation

App\Models\License::adminuser ( )

Get admin user for this asset.

Definition at line 73 of file License.php.

     {
         return $this->belongsTo('\App\Models\User', 'user_id');
     }

static App\Models\License::assetcount ( )

static

Get total licenses.

Definition at line 81 of file License.php.

     {
         return LicenseSeat::whereNull('deleted_at')
                    ->count();
     }

App\Models\License::assetlog ( )

Get asset logs for this asset.

Definition at line 50 of file License.php.

     {
         return $this->hasMany('\App\Models\Actionlog', 'asset_id')
             ->where('asset_type', '=', 'software')
             ->orderBy('created_at', 'desc');
     }

App\Models\License::assignedcount ( )

Get the number of assigned seats.

Definition at line 126 of file License.php.

     {
 
         return \App\Models\LicenseSeat::where('license_id', '=', $this->id)
             ->where(function ($query) {
 
                 $query->whereNotNull('assigned_to')
                 ->orWhereNotNull('asset_id');
             })
         ->count();
 
 
     }

App\Models\License::assignedusers ( )

Get the assigned user.

Definition at line 42 of file License.php.

     {
         return $this->belongsToMany('\App\Models\User', 'license_seats', 'assigned_to', 'license_id');
     }

static App\Models\License::availassetcount ( )

static

Get total licenses not checked out.

Definition at line 102 of file License.php.

     {
         return LicenseSeat::whereNull('assigned_to')
                    ->whereNull('asset_id')
                    ->whereNull('deleted_at')
                    ->count();
     }

App\Models\License::availcount ( )

Get the number of available seats.

Definition at line 113 of file License.php.

     {
         return LicenseSeat::whereNull('assigned_to')
                     ->whereNull('asset_id')
                     ->where('license_id', '=', $this->id)
                     ->whereNull('deleted_at')
                     ->count();
     }

App\Models\License::company ( )

Definition at line 34 of file License.php.

     {
         return $this->belongsTo('\App\Models\Company', 'company_id');
     }

App\Models\Depreciable::depreciated_date ( )

inherited

Definition at line 77 of file Depreciable.php.

     {
         $date = date_create($this->purchase_date);
         date_add($date, date_interval_create_from_date_string($this->get_depreciation()->months . ' months'));
         return $date; //date_format($date, 'Y-m-d'); //don't bake-in format, for internationalization
     }

App\Models\Depreciable::depreciation ( )

inherited

Depreciation Relation, and associated helper methods.

Definition at line 28 of file Depreciable.php.

     {
         return $this->belongsTo('\App\Models\Depreciation', 'depreciation_id');
     }

App\Models\License::freeSeat ( )

Definition at line 172 of file License.php.

     {
         $seat = LicenseSeat::where('license_id', '=', $this->id)
                     ->whereNull('deleted_at')
                     ->whereNull('assigned_to')
                     ->whereNull('asset_id')
                     ->first();
         return $seat->id;
     }

App\Models\Depreciable::get_depreciation ( )

inherited

Definition at line 33 of file Depreciable.php.

     {
         return $this->depreciation;
     }

App\Models\Depreciable::getDepreciatedValue ( )

inherited

Returns: float|int

Definition at line 42 of file Depreciable.php.

     {
         if (!$this->get_depreciation()) { // will never happen
             return $this->purchase_cost;
         }
 
         if ($this->get_depreciation()->months <= 0) {
             return $this->purchase_cost;
         }
 
         // fraction of value left
         $months_remaining = $this->time_until_depreciated()->m + 12*$this->time_until_depreciated()->y; //UGlY
         $current_value = round(($months_remaining/ $this->get_depreciation()->months) * $this->purchase_cost, 2);
 
         if ($current_value < 0) {
             $current_value = 0;
         }
         return $current_value;
     }

static App\Models\License::getExpiringLicenses ( $days = 60 )

static

Definition at line 182 of file License.php.

     {
 
         return License::whereNotNull('expiration_date')
         ->whereNull('deleted_at')
         ->whereRaw(DB::raw('DATE_SUB(`expiration_date`,INTERVAL '.$days.' DAY) <= DATE(NOW()) '))
         ->where('expiration_date', '>', date("Y-m-d"))
         ->orderBy('expiration_date', 'ASC')
         ->get();
 
     }

App\Models\License::licenseseats ( )

Get license seat data.

Definition at line 162 of file License.php.

     {
         return $this->hasMany('\App\Models\LicenseSeat');
     }

App\Models\License::remaincount ( )

Definition at line 140 of file License.php.

     {
         $total = $this->totalSeatsByLicenseID();
         $taken =  $this->assignedcount();
         $diff =   ($total - $taken);
         return $diff;
     }

App\Models\License::scopeTextSearch	(	$query,
		$search
	)

Query builder scope to search on text.

Parameters

Illuminate\Database\Query\Builder	$query	Query builder instance
text	$search	Search term

Returns: Illuminate Modified query builder

Definition at line 202 of file License.php.

     {
 
         return $query->where(function ($query) use ($search) {
 
             $query->where('name', 'LIKE', '%'.$search.'%')
                 ->orWhere('serial', 'LIKE', '%'.$search.'%')
                 ->orWhere('notes', 'LIKE', '%'.$search.'%')
                 ->orWhere('order_number', 'LIKE', '%'.$search.'%')
                 ->orWhere('purchase_date', 'LIKE', '%'.$search.'%')
                 ->orWhere('purchase_cost', 'LIKE', '%'.$search.'%');
         });
     }

App\Models\License::supplier ( )

Definition at line 167 of file License.php.

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

App\Models\Depreciable::time_until_depreciated ( )

inherited

Definition at line 62 of file Depreciable.php.

     {
         // @link http://www.php.net/manual/en/class.datetime.php
         $d1 = new \DateTime();
         $d2 = $this->depreciated_date();
 
         // @link http://www.php.net/manual/en/class.dateinterval.php
         $interval = $d1->diff($d2);
         if (!$interval->invert) {
             return $interval;
         } else {
             return new \DateInterval("PT0S"); //null interval (zero seconds from now)
         }
     }

App\Models\License::totalcount ( )

Get the total number of seats.

Definition at line 151 of file License.php.

     {
         $avail =  $this->availcount();
         $taken =  $this->assignedcount();
         $diff =   ($avail + $taken);
         return $diff;
     }

App\Models\License::totalSeatsByLicenseID ( )

Get total licenses.

Definition at line 91 of file License.php.

     {
         return LicenseSeat::where('license_id', '=', $this->id)
                    ->whereNull('deleted_at')
                    ->count();
     }

App\Models\License::uploads ( )

Get uploads for this asset.

Definition at line 60 of file License.php.

     {
         return $this->hasMany('\App\Models\Actionlog', 'asset_id')
             ->where('asset_type', '=', 'software')
             ->where('action_type', '=', 'uploaded')
             ->whereNotNull('filename')
             ->orderBy('created_at', 'desc');
     }

Member Data Documentation

App\Models\License::$dates = ['deleted_at']

protected

Definition at line 17 of file License.php.

App\Models\License::$guarded = 'id'

protected

Definition at line 21 of file License.php.

App\Models\License::$injectUniqueIdentifier = true

protected

Definition at line 14 of file License.php.

App\Models\License::$rules

protected

Initial value:

= array(
        'name'   => 'required|string|min:3|max:255',
        'serial'   => 'required|min:5',
        'seats'   => 'required|min:1|max:10000|integer',
        'license_email'   => 'email|min:0|max:120',
        'license_name'   => 'string|min:0|max:100',
        'note'   => 'string',
        'notes'   => 'string|min:0',
        'company_id' => 'integer',
    )

Definition at line 23 of file License.php.

App\Models\License::$table = 'licenses'

protected

Definition at line 22 of file License.php.

App\Models\License::$timestamps = true

Definition at line 19 of file License.php.

The documentation for this class was generated from the following file:

License.php

Public Member Functions

Static Public Member Functions

Public Attributes

Protected Attributes

Detailed Description

Member Function Documentation

Member Data Documentation