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

        return CharacterAgentResearch::join(
            'invNames',
            'character_agent_researches.agent_id', '=',
            'invNames.itemID')
            ->join(
                'invTypes',
                'character_agent_researches.skill_type_id', '=',
                'invTypes.typeID')
            ->where('character_id', $character_id)
            ->get();
    }
public function getCharacterResearchAgents(int $character_id): Collection
    {

        return CharacterAgentResearch::join(
            'invNames',
            'character_agent_researches.agent_id', '=',
            'invNames.itemID')
            ->join(
                'invTypes',
                'character_agent_researches.skill_type_id', '=',
                'invTypes.typeID')
            ->where('character_id', $character_id)
            ->get();
    }
public function getCharacterResearchAgents ( int $ character_id ) : Collection { return CharacterAgentResearch :: join ( 'invNames' , 'character_agent_researches.agent_id' , '=' , 'invNames.itemID' ) -> join ( 'invTypes' , 'character_agent_researches.skill_type_id' , '=' , 'invTypes.typeID' ) -> where ( 'character_id' , $ character_id ) -> get ( ) ; }
Return a characters research info.

@param int $character_id

@return \Illuminate\Support\Collection
Return a characters research info .