/** * 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; }