/**
* check all system log tables for the correct number of system entries that will be locked
* @return array
*/
private function prepareSystemLogTables()
{
// get information for all systems from CCP DB
$systemController = new Controller\Api\System();
$systemsData = $systemController->getSystems();
$pfDB = DB\Database::instance()->getDB('PF');
// insert systems into each log table if not exist
$pfDB->begin();
foreach ($this->logTables as $tableName) {
// insert systems into jump log table
$sqlInsertSystem = "INSERT IGNORE INTO " . $tableName . " (systemId)\n VALUES(:systemId)";
foreach ($systemsData as $systemData) {
// skip WH systems -> no jump data available
if ($systemData['type']['name'] == 'k-space') {
$pfDB->exec($sqlInsertSystem, array(':systemId' => $systemData['systemId']), 0, false);
}
}
}
$pfDB->commit();
return $systemsData;
}
/**
* get blank system model pre-filled with default SDE data
* -> check for "inactive" systems on this map first!
* @param int $systemId
* @return SystemModel
*/
public function getNewSystem($systemId)
{
// check for "inactive" system
$system = $this->getSystemByCCPId($systemId);
if (is_null($system)) {
// get blank system
$systemController = new System();
$systems = $systemController->getSystemModelByIds([$systemId]);
$system = reset($systems);
$system->mapId = $this->_id;
}
$system->setActive(true);
return $system;
}
