/**
* Returns a corporation assets grouped by location.
* Only assets in space will appear here as assets
* that are in stations dont have 'locations' entries.
*
* @param $corporation_id
*
* @return mixed
*/
public function getCorporationAssetByLocation($corporation_id)
{
return Locations::leftJoin('corporation_asset_lists', 'corporation_locations.itemID', '=', 'corporation_asset_lists.itemID')->leftJoin('invTypes', 'corporation_asset_lists.typeID', '=', 'invTypes.typeID')->where('corporation_locations.corporationID', $corporation_id)->get()->groupBy('mapID');
// <--- :O That is so sexy <3
}
