enterprises.orbital.evekit.snapshot.capsuleer.PlanetaryColoniesSheetWriter Maven / Gradle / Ivy
package enterprises.orbital.evekit.snapshot.capsuleer;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;
import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVPrinter;
import enterprises.orbital.evekit.account.SynchronizedEveAccount;
import enterprises.orbital.evekit.model.character.PlanetaryColony;
import enterprises.orbital.evekit.model.character.PlanetaryLink;
import enterprises.orbital.evekit.model.character.PlanetaryPin;
import enterprises.orbital.evekit.model.character.PlanetaryRoute;
import enterprises.orbital.evekit.snapshot.SheetUtils;
import enterprises.orbital.evekit.snapshot.SheetUtils.DumpCell;
public class PlanetaryColoniesSheetWriter {
// Singleton
private PlanetaryColoniesSheetWriter() {}
public static List dumpPlanetaryPins(
SynchronizedEveAccount acct,
ZipOutputStream stream,
List planets,
long at) throws IOException {
List itemIDs = new ArrayList();
stream.putNextEntry(new ZipEntry("PlanetaryPins.csv"));
CSVPrinter output = CSVFormat.EXCEL.print(new OutputStreamWriter(stream));
output.printRecord("ID", "Planet ID", "Pin ID", "Type ID", "Type Name", "Schematic ID", "Last Launch Time (Raw)", "Last Launch Time", "Cycle Time",
"Quantity Per Cycle", "Install Time (Raw)", "Install Time", "Expiry Time (Raw)", "Expiry Time", "Content Type ID", "Content Type Name",
"Content Quantity", "Longitude", "Latitude");
for (long planetID : planets) {
List allPins = PlanetaryPin.getAllPlanetaryPinsByPlanet(acct, at, planetID);
for (PlanetaryPin next : allPins) {
// @formatter:off
SheetUtils.populateNextRow(output,
new DumpCell(next.getCid(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getPlanetID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getPinID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getTypeID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getTypeName(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getSchematicID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getLastLaunchTime(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(new Date(next.getLastLaunchTime()), SheetUtils.CellFormat.DATE_STYLE),
new DumpCell(next.getCycleTime(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getQuantityPerCycle(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getInstallTime(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(new Date(next.getInstallTime()), SheetUtils.CellFormat.DATE_STYLE),
new DumpCell(next.getExpiryTime(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(new Date(next.getExpiryTime()), SheetUtils.CellFormat.DATE_STYLE),
new DumpCell(next.getContentTypeID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getContentTypeName(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getContentQuantity(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getLongitude(), SheetUtils.CellFormat.DOUBLE_STYLE),
new DumpCell(next.getLatitude(), SheetUtils.CellFormat.DOUBLE_STYLE));
// @formatter:on
if (next.hasMetaData()) itemIDs.add(next.getCid());
}
if (allPins.size() > 0) output.println();
}
output.flush();
stream.closeEntry();
return itemIDs;
}
public static List dumpPlanetaryLinks(
SynchronizedEveAccount acct,
ZipOutputStream stream,
List planets,
long at) throws IOException {
List itemIDs = new ArrayList();
stream.putNextEntry(new ZipEntry("PlanetaryLinks.csv"));
CSVPrinter output = CSVFormat.EXCEL.print(new OutputStreamWriter(stream));
output.printRecord("ID", "Planet ID", "Source Pin ID", "Destination Pin ID", "Link Level");
for (long planetID : planets) {
List allLinks = PlanetaryLink.getAllPlanetaryLinksByPlanet(acct, at, planetID);
for (PlanetaryLink next : allLinks) {
// @formatter:off
SheetUtils.populateNextRow(output,
new DumpCell(next.getCid(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getPlanetID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getSourcePinID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getDestinationPinID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getLinkLevel(), SheetUtils.CellFormat.LONG_NUMBER_STYLE));
// @formatter:on
if (next.hasMetaData()) itemIDs.add(next.getCid());
}
if (allLinks.size() > 0) output.println();
}
output.flush();
stream.closeEntry();
return itemIDs;
}
public static List dumpPlanetaryRoutes(
SynchronizedEveAccount acct,
ZipOutputStream stream,
List planets,
long at) throws IOException {
List itemIDs = new ArrayList();
stream.putNextEntry(new ZipEntry("PlanetaryRoutes.csv"));
CSVPrinter output = CSVFormat.EXCEL.print(new OutputStreamWriter(stream));
output.printRecord("ID", "Planet ID", "Route ID", "Source Pin ID", "Destination Pin ID", "Content Type ID", "Content Type Name", "Quantity", "Waypoint 1",
"Waypoint 2", "Waypoint 3", "Waypoint 4", "Waypoint 5");
for (long planetID : planets) {
List allRoutes = PlanetaryRoute.getAllPlanetaryRoutesByPlanet(acct, at, planetID);
for (PlanetaryRoute next : allRoutes) {
// @formatter:off
SheetUtils.populateNextRow(output,
new DumpCell(next.getCid(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getPlanetID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getRouteID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getSourcePinID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getDestinationPinID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getContentTypeID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getContentTypeName(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getQuantity(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getWaypoint1(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getWaypoint2(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getWaypoint3(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getWaypoint4(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getWaypoint5(), SheetUtils.CellFormat.LONG_NUMBER_STYLE));
// @formatter:on
if (next.hasMetaData()) itemIDs.add(next.getCid());
}
if (allRoutes.size() > 0) output.println();
}
output.flush();
stream.closeEntry();
return itemIDs;
}
public static void dumpToSheet(
SynchronizedEveAccount acct,
ZipOutputStream stream,
long at) throws IOException {
// Sections:
// PlanetaryColonies.csv
// PlanetaryColoniesMeta.csv
// PlanetaryPins.csv
// PlanetaryPinsMeta.csv
// PlanetaryLinks.csv
// PlanetaryLinksMeta.csv
// PlanetaryRoutes.csv
// PlanetaryRoutesMeta.csv
stream.putNextEntry(new ZipEntry("PlanetaryColonies.csv"));
CSVPrinter output = CSVFormat.EXCEL.print(new OutputStreamWriter(stream));
output.printRecord("ID", "Planet ID", "Solar System ID", "Solar System Name", "Planet Name", "Planet Type ID", "Planet Type Name", "Owner ID", "Owner Name",
"Last Update (Raw)", "Last Update", "Upgrade Level", "Number Of Pins");
List planetIDs = new ArrayList();
List metaIDs = new ArrayList();
List batch = PlanetaryColony.getAllPlanetaryColonies(acct, at);
for (PlanetaryColony next : batch) {
// @formatter:off
SheetUtils.populateNextRow(output,
new DumpCell(next.getCid(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getPlanetID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getSolarSystemID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getSolarSystemName(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getPlanetName(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getPlanetTypeID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getPlanetTypeName(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getOwnerID(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getOwnerName(), SheetUtils.CellFormat.NO_STYLE),
new DumpCell(next.getLastUpdate(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(new Date(next.getLastUpdate()), SheetUtils.CellFormat.DATE_STYLE),
new DumpCell(next.getUpgradeLevel(), SheetUtils.CellFormat.LONG_NUMBER_STYLE),
new DumpCell(next.getNumberOfPins(), SheetUtils.CellFormat.LONG_NUMBER_STYLE));
// @formatter:on
planetIDs.add(next.getPlanetID());
if (next.hasMetaData()) metaIDs.add(next.getCid());
}
output.flush();
stream.closeEntry();
if (planetIDs.size() > 0) {
// Wrote at least one colony so proceed
// Write out meta data for colonies
output = SheetUtils.prepForMetaData("PlanetaryColoniesMeta.csv", stream, false, null);
for (Long next : metaIDs) {
int count = SheetUtils.dumpNextMetaData(acct, output, next, "PlanetaryColony");
if (count > 0) output.println();
}
output.flush();
stream.closeEntry();
// Write out planetary pins data in the same style as meta data.
metaIDs = dumpPlanetaryPins(acct, stream, planetIDs, at);
if (metaIDs.size() > 0) {
// Only write out meta-data if a pin was actually written.
output = SheetUtils.prepForMetaData("PlanetaryPinsMeta.csv", stream, false, null);
for (Long next : metaIDs) {
int count = SheetUtils.dumpNextMetaData(acct, output, next, "PlanetaryPin");
if (count > 0) output.println();
}
output.flush();
stream.closeEntry();
}
// Write out links data in the same style as meta data.
metaIDs = dumpPlanetaryLinks(acct, stream, planetIDs, at);
if (metaIDs.size() > 0) {
// Only write out meta-data if a link was actually written.
output = SheetUtils.prepForMetaData("PlanetaryLinksMeta.csv", stream, false, null);
for (Long next : metaIDs) {
int count = SheetUtils.dumpNextMetaData(acct, output, next, "PlanetaryLink");
if (count > 0) output.println();
}
output.flush();
stream.closeEntry();
}
// Write out routes data in the same style as meta data.
metaIDs = dumpPlanetaryRoutes(acct, stream, planetIDs, at);
if (metaIDs.size() > 0) {
// Only write out meta-data if a route was actually written.
output = SheetUtils.prepForMetaData("PlanetaryRoutesMeta.csv", stream, false, null);
for (Long next : metaIDs) {
int count = SheetUtils.dumpNextMetaData(acct, output, next, "PlanetaryRoute");
if (count > 0) output.println();
}
output.flush();
stream.closeEntry();
}
}
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy