/** * Return the killmails for a character * * @param int $character_id * @param bool $get * @param int $chunk * * @return */ public function getCharacterKillmails(int $character_id, bool $get = true, int $chunk = 200) { $killmails = KillMail::select('*', 'character_kill_mails.characterID as ownerID', 'kill_mail_details.characterID as victimID')->leftJoin('kill_mail_details', 'character_kill_mails.killID', '=', 'kill_mail_details.killID')->leftJoin('invTypes', 'kill_mail_details.shipTypeID', '=', 'invTypes.typeID')->leftJoin('mapDenormalize', 'kill_mail_details.solarSystemID', '=', 'mapDenormalize.itemID')->where('character_kill_mails.characterID', $character_id); if ($get) { return $killmails->orderBy('character_kill_mails.killID', 'desc')->paginate($chunk); } return $killmails; }
/** * Return the killmails for a character * * @param $character_id * * @return mixed */ public function getCharacterKillmails($character_id) { return KillMail::select('*', 'character_kill_mails.characterID as ownerID', 'kill_mail_details.characterID as victimID')->leftJoin('kill_mail_details', 'character_kill_mails.killID', '=', 'kill_mail_details.killID')->leftJoin('invTypes', 'kill_mail_details.shipTypeID', '=', 'invTypes.typeID')->leftJoin('mapDenormalize', 'kill_mail_details.solarSystemID', '=', 'mapDenormalize.itemID')->where('character_kill_mails.characterID', $character_id)->get(); }