/**
* Return the Killmails for a Corporation
*
* @param int $corporation_id
* @param bool $get
* @param int $chunk
*
* @return \Illuminate\Pagination\LengthAwarePaginator
*/
public function getCorporationKillmails(int $corporation_id, bool $get = true, int $chunk = 200)
{
$killmails = KillMail::select('*', 'corporation_kill_mails.corporationID as ownerID', 'kill_mail_details.corporationID as victimID')->leftJoin('kill_mail_details', 'corporation_kill_mails.killID', '=', 'kill_mail_details.killID')->leftJoin('invTypes', 'kill_mail_details.shipTypeID', '=', 'invTypes.typeID')->leftJoin('mapDenormalize', 'kill_mail_details.solarSystemID', '=', 'mapDenormalize.itemID')->where('corporation_kill_mails.corporationID', $corporation_id);
if ($get) {
return $killmails->orderBy('corporation_kill_mails.killID', 'desc')->paginate($chunk);
}
return $killmails;
}
/**
* Return the Killmails for a Corporation
*
* @param $corporation_id
*
* @return mixed
*/
public function getCorporationKillmails($corporation_id)
{
return KillMail::select('*', 'corporation_kill_mails.corporationID as ownerID', 'kill_mail_details.corporationID as victimID')->leftJoin('kill_mail_details', 'corporation_kill_mails.killID', '=', 'kill_mail_details.killID')->leftJoin('invTypes', 'kill_mail_details.shipTypeID', '=', 'invTypes.typeID')->leftJoin('mapDenormalize', 'kill_mail_details.solarSystemID', '=', 'mapDenormalize.itemID')->where('corporation_kill_mails.corporationID', $corporation_id)->get();
}
