src/Repositories/Character/JumpClone.php
public function getCharacterJumpClones(int $character_id): Collection
    {

        return DB::table(DB::raw(
            'character_jump_clones as a'))
            ->select(DB::raw('
                *, CASE
                when a.location_id BETWEEN 66015148 AND 66015151 then
                    (SELECT s.stationName FROM staStations AS s
                      WHERE s.stationID=a.location_id-6000000)
                when a.location_id BETWEEN 66000000 AND 66014933 then
                    (SELECT s.stationName FROM staStations AS s
                      WHERE s.stationID=a.location_id-6000001)
                when a.location_id BETWEEN 66014934 AND 67999999 then
                    (SELECT d.name FROM `sovereignty_structures` AS c
                      JOIN universe_stations d ON c.structure_id = d.station_id
                      WHERE c.structure_id=a.location_id-6000000)
                when a.location_id BETWEEN 60014861 AND 60014928 then
                    (SELECT d.name FROM `sovereignty_structures` AS c
                      JOIN universe_stations d ON c.structure_id = d.station_id
                      WHERE c.structure_id=a.location_id)
                when a.location_id BETWEEN 60000000 AND 61000000 then
                    (SELECT s.stationName FROM staStations AS s
                      WHERE s.stationID=a.location_id)
                when a.location_id>=61000000 then
                    (SELECT d.name FROM `sovereignty_structures` AS c
                      JOIN universe_stations d ON c.structure_id = d.station_id
                      WHERE c.structure_id=a.location_id)
                else (SELECT m.itemName FROM mapDenormalize AS m
                    WHERE m.itemID=a.location_id) end
                    AS location,a.location_id AS locID'))
            ->where('a.character_id', $character_id)
            ->get();
    }
public function getCharacterJumpClones(int $character_id): Collection
    {

        return DB::table(DB::raw(
            'character_jump_clones as a'))
            ->select(DB::raw('
                *, CASE
                when a.location_id BETWEEN 66015148 AND 66015151 then
                    (SELECT s.stationName FROM staStations AS s
                      WHERE s.stationID=a.location_id-6000000)
                when a.location_id BETWEEN 66000000 AND 66014933 then
                    (SELECT s.stationName FROM staStations AS s
                      WHERE s.stationID=a.location_id-6000001)
                when a.location_id BETWEEN 66014934 AND 67999999 then
                    (SELECT d.name FROM `sovereignty_structures` AS c
                      JOIN universe_stations d ON c.structure_id = d.station_id
                      WHERE c.structure_id=a.location_id-6000000)
                when a.location_id BETWEEN 60014861 AND 60014928 then
                    (SELECT d.name FROM `sovereignty_structures` AS c
                      JOIN universe_stations d ON c.structure_id = d.station_id
                      WHERE c.structure_id=a.location_id)
                when a.location_id BETWEEN 60000000 AND 61000000 then
                    (SELECT s.stationName FROM staStations AS s
                      WHERE s.stationID=a.location_id)
                when a.location_id>=61000000 then
                    (SELECT d.name FROM `sovereignty_structures` AS c
                      JOIN universe_stations d ON c.structure_id = d.station_id
                      WHERE c.structure_id=a.location_id)
                else (SELECT m.itemName FROM mapDenormalize AS m
                    WHERE m.itemID=a.location_id) end
                    AS location,a.location_id AS locID'))
            ->where('a.character_id', $character_id)
            ->get();
    }
public function getCharacterJumpClones ( int $ character_id ) : Collection { return DB :: table ( DB :: raw ( 'character_jump_clones as a' ) ) -> select ( DB :: raw ( '
                *, CASE
                when a.location_id BETWEEN 66015148 AND 66015151 then
                    (SELECT s.stationName FROM staStations AS s
                      WHERE s.stationID=a.location_id-6000000)
                when a.location_id BETWEEN 66000000 AND 66014933 then
                    (SELECT s.stationName FROM staStations AS s
                      WHERE s.stationID=a.location_id-6000001)
                when a.location_id BETWEEN 66014934 AND 67999999 then
                    (SELECT d.name FROM `sovereignty_structures` AS c
                      JOIN universe_stations d ON c.structure_id = d.station_id
                      WHERE c.structure_id=a.location_id-6000000)
                when a.location_id BETWEEN 60014861 AND 60014928 then
                    (SELECT d.name FROM `sovereignty_structures` AS c
                      JOIN universe_stations d ON c.structure_id = d.station_id
                      WHERE c.structure_id=a.location_id)
                when a.location_id BETWEEN 60000000 AND 61000000 then
                    (SELECT s.stationName FROM staStations AS s
                      WHERE s.stationID=a.location_id)
                when a.location_id>=61000000 then
                    (SELECT d.name FROM `sovereignty_structures` AS c
                      JOIN universe_stations d ON c.structure_id = d.station_id
                      WHERE c.structure_id=a.location_id)
                else (SELECT m.itemName FROM mapDenormalize AS m
                    WHERE m.itemID=a.location_id) end
                    AS location,a.location_id AS locID' ) ) -> where ( 'a.character_id' , $ character_id ) -> get ( ) ; }
Get jump clones and jump clone locations for a
character.

@param int $character_id

@return \Illuminate\Support\Collection
Get jump clones and jump clone locations for a character .