App\Models\Location Class Reference

Inheritance diagram for App\Models\Location:

Public Member Functions
	users ()
	assets ()
	assignedassets ()
	parent ()
	childLocations ()
	scopeTextsearch ($query, $search)
	Query builder scope to search on text. More...
	scopeOrderParent ($query, $order)
	Query builder scope to order on parent. More...

Static Public Member Functions
static	getLocationHierarchy ($locations, $parent_id=null)
static	flattenLocationsArray ($location_options_array=null)

Protected Attributes
	$dates = ['deleted_at']
	$table = 'locations'
	$rules
	$injectUniqueIdentifier = true
	$fillable = ['name']

Detailed Description

Definition at line 10 of file Location.php.

Member Function Documentation

App\Models\Location::assets

(

)

Definition at line 48 of file Location.php.

    {
        return $this->hasManyThrough('\App\Models\Asset', '\App\Models\Actionlog', 'location_id', 'id');
    }

App\Models\Location::assignedassets

(

)

Definition at line 53 of file Location.php.

    {
        return $this->hasMany('\App\Models\Asset', 'rtd_location_id');
    }

App\Models\Location::childLocations

(

)

Definition at line 63 of file Location.php.

    {
        return $this->hasMany('\App\Models\Location', 'parent_id');
    }

static App\Models\Location::flattenLocationsArray (   $location_options_array = null )

static

Definition at line 96 of file Location.php.

    {
        $location_options = array();
        foreach ($location_options_array as $id => $value) {

            // get the top level key value
            $location_options[$id] = $value['name'];

                // If there is a key named children, it has child locations and we have to walk it
            if (array_key_exists('children', $value)) {

                foreach ($value['children'] as $child_id => $child_location_array) {
                    $child_location_options = Location::flattenLocationsArray($value['children']);

                    foreach ($child_location_options as $child_id => $child_name) {
                        $location_options[$child_id] = '--'.$child_name;
                    }
                }

            }

        }

        return $location_options;
    }

static App\Models\Location::getLocationHierarchy (   $locations,   $parent_id = null  )

static

Definition at line 68 of file Location.php.

    {


        $op = array();

        foreach ($locations as $location) {

            if ($location['parent_id'] == $parent_id) {
                $op[$location['id']] =
                    array(
                        'name' => $location['name'],
                        'parent_id' => $location['parent_id']
                    );

                // Using recursion
                $children =  Location::getLocationHierarchy($locations, $location['id']);
                if ($children) {
                    $op[$location['id']]['children'] = $children;
                }

            }

        }
        return $op;
    }

App\Models\Location::parent

(

)

Definition at line 58 of file Location.php.

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

App\Models\Location::scopeOrderParent	(		$query,
			$order
	)

Query builder scope to order on parent.

Parameters

Illuminate\Database\Query\Builder	$query	Query builder instance
text	$order	Order

Returns

Illuminate Modified query builder

Definition at line 163 of file Location.php.

    {
      // Left join here, or it will only return results with parents
        return $query->leftJoin('locations as parent_loc', 'locations.parent_id', '=', 'parent_loc.id')->orderBy('parent_loc.name', $order);
    }

App\Models\Location::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 130 of file Location.php.

    {

        return $query->where('name', 'LIKE', "%$search%")
          ->orWhere('address', 'LIKE', "%$search%")
          ->orWhere('city', 'LIKE', "%$search%")
          ->orWhere('state', 'LIKE', "%$search%")
          ->orWhere('zip', 'LIKE', "%$search%")

          // This doesn't actually work - need to use a table alias maybe?
          ->orWhere(function ($query) use ($search) {
              $query->whereHas('parent', function ($query) use ($search) {
                  $query->where(function ($query) use ($search) {
                      $query->where('name', 'LIKE', '%'.$search.'%');
                  });
              })
            // Ugly, ugly code because Laravel sucks at self-joins
                ->orWhere(function ($query) use ($search) {
                    $query->whereRaw("parent_id IN (select id from locations where name LIKE '%".$search."%') ");
                });
          });

    }

App\Models\Location::users

(

)

Definition at line 43 of file Location.php.

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

Member Data Documentation

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

protected

Definition at line 13 of file Location.php.

App\Models\Location::$fillable = ['name']

protected

Definition at line 41 of file Location.php.

App\Models\Location::$injectUniqueIdentifier = true

protected

Definition at line 32 of file Location.php.

App\Models\Location::$rules

protected

Initial value:

= array(
      'name'        => 'required|min:3|max:255|unique:locations,name,NULL,deleted_at',
      'city'        => 'min:3|max:255',
      'state'           => 'min:2|max:32',
      'country'     => 'min:2|max:2|max:2',
      'address'         => 'min:5|max:80',
      'address2'        => 'min:2|max:80',
      'zip'         => 'min:3|max:10',
    )

Definition at line 15 of file Location.php.

App\Models\Location::$table = 'locations'

protected

Definition at line 14 of file Location.php.

---

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

• Location.php