AbstractSmrLocation::moveSectorLocation() - Code Metrics - Inspection of "Uni Gen: add ability to drag and drop locations" - smrealms/smr - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions
Pull Request — master (#1101)

by Dan
created 2021-07-08 08:13 UTC
AbstractSmrLocation::moveSectorLocation() A

↳ Parent: AbstractSmrLocation
Complexity

Conditions	2
Paths	2
Size

Total Lines	16
Code Lines	9
Duplication

Lines	0
Ratio	0 %
Importance

Changes	1
Bugs	1	Features	0
Metric	Value
cc	2
eloc	9
c	1
b	1
f	0
nc	2
nop	4
dl	0
loc	16
rs	9.9666
<?php declare(strict_types=1);

class AbstractSmrLocation {
	protected static array $CACHE_ALL_LOCATIONS;
	protected static array $CACHE_LOCATIONS = [];
	protected static array $CACHE_SECTOR_LOCATIONS = [];

	protected Smr\Database $db;
	protected string $SQL;

	protected int $typeID;
	protected string $name;
	protected ?string $processor;
	protected string $image;

	protected bool $fed;
	protected bool $bank;
	protected bool $bar;
	protected bool $HQ;
	protected bool $UG;

	protected array $hardwareSold;
	protected array $shipsSold;
	protected array $weaponsSold;

	public static function clearCache() : void {
		self::$CACHE_ALL_LOCATIONS = [];
		self::$CACHE_LOCATIONS = [];
		self::$CACHE_SECTOR_LOCATIONS = [];
	}

	public static function getAllLocations(bool $forceUpdate = false) : array {
		if ($forceUpdate || !isset(self::$CACHE_ALL_LOCATIONS)) {
			$db = Smr\Database::getInstance();
			$dbResult = $db->read('SELECT * FROM location_type ORDER BY location_type_id');
			$locations = array();
			foreach ($dbResult->records() as $dbRecord) {
				$locationTypeID = $dbRecord->getInt('location_type_id');
				$locations[$locationTypeID] = SmrLocation::getLocation($locationTypeID, $forceUpdate, $dbRecord);
			}
			self::$CACHE_ALL_LOCATIONS = $locations;
		}
		return self::$CACHE_ALL_LOCATIONS;
	}

	public static function getGalaxyLocations(int $gameID, int $galaxyID, bool $forceUpdate = false) : array {
		$db = Smr\Database::getInstance();
		$dbResult = $db->read('SELECT location_type.*, sector_id FROM location LEFT JOIN sector USING(game_id, sector_id) LEFT JOIN location_type USING (location_type_id) WHERE game_id = ' . $db->escapeNumber($gameID) . ' AND galaxy_id = ' . $db->escapeNumber($galaxyID));
		$galaxyLocations = [];
		foreach ($dbResult->records() as $dbRecord) {
			$sectorID = $dbRecord->getInt('sector_id');
			$locationTypeID = $dbRecord->getInt('location_type_id');
			$location = self::getLocation($locationTypeID, $forceUpdate, $dbRecord);
			self::$CACHE_SECTOR_LOCATIONS[$gameID][$sectorID][$locationTypeID] = $location;
			$galaxyLocations[$sectorID][$locationTypeID] = $location;
		}
		return $galaxyLocations;
	}

	public static function getSectorLocations(int $gameID, int $sectorID, bool $forceUpdate = false) : array {
		if ($forceUpdate || !isset(self::$CACHE_SECTOR_LOCATIONS[$gameID][$sectorID])) {
			$db = Smr\Database::getInstance();
			$dbResult = $db->read('SELECT * FROM location LEFT JOIN location_type USING (location_type_id) WHERE sector_id = ' . $db->escapeNumber($sectorID) . ' AND game_id=' . $db->escapeNumber($gameID));
			$locations = array();
			foreach ($dbResult->records() as $dbRecord) {
				$locationTypeID = $dbRecord->getInt('location_type_id');
				$locations[$locationTypeID] = self::getLocation($locationTypeID, $forceUpdate, $dbRecord);
			}
			self::$CACHE_SECTOR_LOCATIONS[$gameID][$sectorID] = $locations;
		}
		return self::$CACHE_SECTOR_LOCATIONS[$gameID][$sectorID];
	}

	public static function addSectorLocation(int $gameID, int $sectorID, SmrLocation $location) : void {
		self::getSectorLocations($gameID, $sectorID); // make sure cache is populated
		$db = Smr\Database::getInstance();
		$db->write('INSERT INTO location (game_id, sector_id, location_type_id)
						values(' . $db->escapeNumber($gameID) . ',' . $db->escapeNumber($sectorID) . ',' . $db->escapeNumber($location->getTypeID()) . ')');
		self::$CACHE_SECTOR_LOCATIONS[$gameID][$sectorID][$location->getTypeID()] = $location;
	}

	public static function moveSectorLocation(int $gameID, int $oldSectorID, int $newSectorID, SmrLocation $location) : void {
		if ($oldSectorID === $newSectorID) {
			return;
		}

		// Make sure cache is populated
		self::getSectorLocations($gameID, $oldSectorID);
		self::getSectorLocations($gameID, $newSectorID);

		$db = Smr\Database::getInstance();
		$db->write('UPDATE location SET sector_id = ' . $db->escapeNumber($newSectorID) . ' WHERE game_id = ' . $db->escapeNumber($gameID) . ' AND sector_id = ' . $db->escapeNumber($oldSectorID) . ' AND location_type_id = ' . $location->getTypeID());
		unset(self::$CACHE_SECTOR_LOCATIONS[$gameID][$oldSectorID][$location->getTypeID()]);
		self::$CACHE_SECTOR_LOCATIONS[$gameID][$newSectorID][$location->getTypeID()] = $location;

		// Preserve the same element order that we'd have in getSectorLocations
		ksort(self::$CACHE_SECTOR_LOCATIONS[$gameID][$newSectorID]);
	}

	public static function removeSectorLocations(int $gameID, int $sectorID) : void {
		$db = Smr\Database::getInstance();
		$db->write('DELETE FROM location WHERE game_id = ' . $db->escapeNumber($gameID) . ' AND sector_id = ' . $db->escapeNumber($sectorID));
		self::$CACHE_SECTOR_LOCATIONS[$gameID][$sectorID] = [];
	}

	public static function getLocation(int $locationTypeID, bool $forceUpdate = false, Smr\DatabaseRecord $dbRecord = null) : SmrLocation {
		if ($forceUpdate || !isset(self::$CACHE_LOCATIONS[$locationTypeID])) {
			self::$CACHE_LOCATIONS[$locationTypeID] = new SmrLocation($locationTypeID, $dbRecord);
		}
		return self::$CACHE_LOCATIONS[$locationTypeID];
	}

	protected function __construct(int $locationTypeID, Smr\DatabaseRecord $dbRecord = null) {
		$this->db = Smr\Database::getInstance();
		$this->SQL = 'location_type_id = ' . $this->db->escapeNumber($locationTypeID);

		if ($dbRecord === null) {
			$dbResult = $this->db->read('SELECT * FROM location_type WHERE ' . $this->SQL . ' LIMIT 1');
			if ($dbResult->hasRecord()) {
				$dbRecord = $dbResult->record();
			}
		}
		$locationExists = $dbRecord !== null;

		if ($locationExists) {
			$this->typeID = $dbRecord->getInt('location_type_id');
			$this->name = $dbRecord->getField('location_name');
			$this->processor = $dbRecord->getField('location_processor');
			$this->image = $dbRecord->getField('location_image');
		} else {
			throw new Exception('Cannot find location: ' . $locationTypeID);
		}
	}

	public function getTypeID() : int {
		return $this->typeID;
	}

	public function getRaceID() : int {
		if ($this->isFed() && $this->getTypeID() != LOCATION_TYPE_FEDERAL_BEACON) {
			return $this->getTypeID() - LOCATION_GROUP_RACIAL_BEACONS;
		}
		if ($this->isHQ() && $this->getTypeID() != LOCATION_TYPE_FEDERAL_HQ) {
			return $this->getTypeID() - LOCATION_GROUP_RACIAL_HQS;
		}
		return RACE_NEUTRAL;
	}

	public function getName() : string {
		return $this->name;
	}

	public function setName(string $name) : void {
		$name = htmlentities($name, ENT_COMPAT, 'utf-8');
		if ($this->name === $name) {
			return;
		}
		$this->name = $name;
		$this->db->write('UPDATE location_type SET location_name=' . $this->db->escapeString($this->name) . ' WHERE ' . $this->SQL . ' LIMIT 1');
	}

	public function hasAction() : bool {
		return $this->processor !== null;
	}

	public function getAction() : ?string {
		return $this->processor;
	}

	public function getImage() : string {
		return $this->image;
	}

	public function isFed() : bool {
		if (!isset($this->fed)) {
			$dbResult = $this->db->read('SELECT 1 FROM location_is_fed WHERE ' . $this->SQL . ' LIMIT 1');
			$this->fed = $dbResult->hasRecord();
		}
		return $this->fed;
	}

	public function setFed(bool $bool) : void {
		if ($this->fed === $bool) {
			return;
		}
		if ($bool) {
			$this->db->write('INSERT IGNORE INTO location_is_fed (location_type_id) values (' . $this->db->escapeNumber($this->getTypeID()) . ')');
		} else {
			$this->db->write('DELETE FROM location_is_fed WHERE ' . $this->SQL . ' LIMIT 1');
		}
		$this->fed = $bool;
	}

	public function isBank() : bool {
		if (!isset($this->bank)) {
			$dbResult = $this->db->read('SELECT 1 FROM location_is_bank WHERE ' . $this->SQL . ' LIMIT 1');
			$this->bank = $dbResult->hasRecord();
		}
		return $this->bank;
	}

	public function setBank(bool $bool) : void {
		if ($this->bank === $bool) {
			return;
		}
		if ($bool) {
			$this->db->write('INSERT INTO location_is_bank (location_type_id) values (' . $this->db->escapeNumber($this->getTypeID()) . ')');
		} else {
			$this->db->write('DELETE FROM location_is_bank WHERE ' . $this->SQL . ' LIMIT 1');
		}
		$this->bank = $bool;
	}

	public function isBar() : bool {
		if (!isset($this->bar)) {
			$dbResult = $this->db->read('SELECT 1 FROM location_is_bar WHERE ' . $this->SQL . ' LIMIT 1');
			$this->bar = $dbResult->hasRecord();
		}
		return $this->bar;
	}

	public function setBar(bool $bool) : void {
		if ($this->bar === $bool) {
			return;
		}
		if ($bool) {
			$this->db->write('INSERT IGNORE INTO location_is_bar (location_type_id) values (' . $this->db->escapeNumber($this->getTypeID()) . ')');
		} else {
			$this->db->write('DELETE FROM location_is_bar WHERE ' . $this->SQL . ' LIMIT 1');
		}
		$this->bar = $bool;
	}

	public function isHQ() : bool {
		if (!isset($this->HQ)) {
			$dbResult = $this->db->read('SELECT * FROM location_is_hq WHERE ' . $this->SQL . ' LIMIT 1');
			$this->HQ = $dbResult->hasRecord();
		}
		return $this->HQ;
	}

	public function setHQ(bool $bool) : void {
		if ($this->HQ === $bool) {
			return;
		}
		if ($bool) {
			$this->db->write('INSERT IGNORE INTO location_is_hq (location_type_id) values (' . $this->db->escapeNumber($this->getTypeID()) . ')');
		} else {
			$this->db->write('DELETE FROM location_is_hq WHERE ' . $this->SQL . ' LIMIT 1');
		}
		$this->HQ = $bool;
	}

	public function isUG() : bool {
		if (!isset($this->UG)) {
			$dbResult = $this->db->read('SELECT * FROM location_is_ug WHERE ' . $this->SQL . ' LIMIT 1');
			$this->UG = $dbResult->hasRecord();
		}
		return $this->UG;
	}

	public function setUG(bool $bool) : void {
		if ($this->UG === $bool) {
			return;
		}
		if ($bool) {
			$this->db->write('INSERT INTO location_is_ug (location_type_id) values (' . $this->db->escapeNumber($this->getTypeID()) . ')');
		} else {
			$this->db->write('DELETE FROM location_is_ug WHERE ' . $this->SQL . ' LIMIT 1');
		}
		$this->UG = $bool;
	}

	public function getHardwareSold() : array {
		if (!isset($this->hardwareSold)) {
			$this->hardwareSold = array();
			$dbResult = $this->db->read('SELECT hardware_type_id FROM location_sells_hardware WHERE ' . $this->SQL);
			foreach ($dbResult->records() as $dbRecord) {
				$this->hardwareSold[$dbRecord->getInt('hardware_type_id')] = Globals::getHardwareTypes($dbRecord->getInt('hardware_type_id'));
			}
		}
		return $this->hardwareSold;
	}

	public function isHardwareSold(int $hardwareTypeID = null) : bool {
		$hardware = $this->getHardwareSold();
		if ($hardwareTypeID === null) {
			return count($hardware) != 0;
		}
		return isset($hardware[$hardwareTypeID]);
	}

	public function addHardwareSold(int $hardwareTypeID) : void {
		if ($this->isHardwareSold($hardwareTypeID)) {
			return;
		}
		$dbResult = $this->db->read('SELECT 1 FROM hardware_type WHERE hardware_type_id = ' . $this->db->escapeNumber($hardwareTypeID) . ' LIMIT 1');
		if (!$dbResult->hasRecord()) {
			throw new Exception('Invalid hardware type id given');
		}
		$this->db->write('INSERT INTO location_sells_hardware (location_type_id,hardware_type_id) values (' . $this->db->escapeNumber($this->getTypeID()) . ',' . $this->db->escapeNumber($hardwareTypeID) . ')');
		$this->hardwareSold[$hardwareTypeID] = Globals::getHardwareTypes($hardwareTypeID);
	}

	public function removeHardwareSold(int $hardwareTypeID) : void {
		if (!$this->isHardwareSold($hardwareTypeID)) {
			return;
		}
		$this->db->write('DELETE FROM location_sells_hardware WHERE ' . $this->SQL . ' AND hardware_type_id = ' . $this->db->escapeNumber($hardwareTypeID) . ' LIMIT 1');
		unset($this->hardwareSold[$hardwareTypeID]);
	}

	public function getShipsSold() : array {
		if (!isset($this->shipsSold)) {
			$this->shipsSold = array();
			$dbResult = $this->db->read('SELECT * FROM location_sells_ships JOIN ship_type USING (ship_type_id) WHERE ' . $this->SQL);
			foreach ($dbResult->records() as $dbRecord) {
				$shipTypeID = $dbRecord->getInt('ship_type_id');
				$this->shipsSold[$shipTypeID] = SmrShipType::get($shipTypeID, $dbRecord);
			}
		}
		return $this->shipsSold;
	}

	public function isShipSold(int $shipTypeID = null) : bool {
		$ships = $this->getShipsSold();
		if ($shipTypeID === null) {
			return count($ships) != 0;
		}
		return isset($ships[$shipTypeID]);
	}

	public function addShipSold(int $shipTypeID) : void {
		if ($this->isShipSold($shipTypeID)) {
			return;
		}
		$ship = SmrShipType::get($shipTypeID);
		$this->db->write('INSERT INTO location_sells_ships (location_type_id,ship_type_id) values (' . $this->db->escapeNumber($this->getTypeID()) . ',' . $this->db->escapeNumber($shipTypeID) . ')');
		$this->shipsSold[$shipTypeID] = $ship;
	}

	public function removeShipSold(int $shipTypeID) : void {
		if (!$this->isShipSold($shipTypeID)) {
			return;
		}
		$this->db->write('DELETE FROM location_sells_ships WHERE ' . $this->SQL . ' AND ship_type_id = ' . $this->db->escapeNumber($shipTypeID) . ' LIMIT 1');
		unset($this->shipsSold[$shipTypeID]);
	}

	public function getWeaponsSold() : array {
		if (!isset($this->weaponsSold)) {
			$this->weaponsSold = array();
			$dbResult = $this->db->read('SELECT * FROM location_sells_weapons JOIN weapon_type USING (weapon_type_id) WHERE ' . $this->SQL);
			foreach ($dbResult->records() as $dbRecord) {
				$weaponTypeID = $dbRecord->getInt('weapon_type_id');
				$this->weaponsSold[$weaponTypeID] = SmrWeapon::getWeapon($weaponTypeID, $dbRecord);
			}
		}
		return $this->weaponsSold;
	}

	public function isWeaponSold(int $weaponTypeID = null) : bool {
		$weapons = $this->getWeaponsSold();
		if ($weaponTypeID === null) {
			return count($weapons) != 0;
		}
		return isset($weapons[$weaponTypeID]);
	}

	public function addWeaponSold(int $weaponTypeID) : void {
		if ($this->isWeaponSold($weaponTypeID)) {
			return;
		}
		$weapon = SmrWeapon::getWeapon($weaponTypeID);
		$this->db->write('INSERT INTO location_sells_weapons (location_type_id,weapon_type_id) values (' . $this->db->escapeNumber($this->getTypeID()) . ',' . $this->db->escapeNumber($weaponTypeID) . ')');
		$this->weaponsSold[$weaponTypeID] = $weapon;
	}

	public function removeWeaponSold(int $weaponTypeID) : void {
		if (!$this->isWeaponSold($weaponTypeID)) {
			return;
		}
		$this->db->write('DELETE FROM location_sells_weapons WHERE ' . $this->SQL . ' AND weapon_type_id = ' . $this->db->escapeNumber($weaponTypeID) . ' LIMIT 1');
		unset($this->weaponsSold[$weaponTypeID]);
	}

	public function getLinkedLocations() : array {
		$linkedLocations = array();
		if ($this->isHQ()) {
			if ($this->getTypeID() == LOCATION_TYPE_FEDERAL_HQ) {
				$linkedLocations[] = SmrLocation::getLocation(LOCATION_TYPE_FEDERAL_BEACON);
				$linkedLocations[] = SmrLocation::getLocation(LOCATION_TYPE_FEDERAL_MINT);
			} else {
				$raceID = $this->getRaceID();
				$linkedLocations[] = SmrLocation::getLocation(LOCATION_GROUP_RACIAL_BEACONS + $raceID);
				$linkedLocations[] = SmrLocation::getLocation(LOCATION_GROUP_RACIAL_SHIPS + $raceID);
				$linkedLocations[] = SmrLocation::getLocation(LOCATION_GROUP_RACIAL_SHOPS + $raceID);
			}
		}
		return $linkedLocations;
	}

	public function getExamineHREF() : string {
		$container = Page::create('skeleton.php', $this->getAction());
		$container = Page::create('skeleton.php', /** @scrutinizer ignore-type */ $this->getAction());
		$container['LocationID'] = $this->getTypeID();
		return $container->href();
	}

	public function getEditHREF() : string {
		$container = Page::create('skeleton.php', 'location_edit.php');
		$container['location_type_id'] = $this->getTypeID();
		return $container->href();
	}

	public function equals(SmrLocation $otherLocation) : bool {
		return $this->getTypeID() == $otherLocation->getTypeID();
	}

	public function hasX(mixed $x, AbstractSmrPlayer $player = null) : bool {
		if ($x instanceof SmrWeaponType) {
			return $this->isWeaponSold($x->getWeaponTypeID());
		}
		if ($x instanceof SmrShipType) {
			return $this->isShipSold($x->getTypeID());
		}
		if (is_array($x) && $x['Type'] == 'Hardware') { // instanceof ShipEquipment)
			return $this->isHardwareSold($x['ID']);
		}
		if (is_string($x)) {
			if ($x == 'Bank') {
				return $this->isBank();
			}
			if ($x == 'Bar') {
				return $this->isBar();
			}
			if ($x == 'Fed') {
				return $this->isFed();
			}
			if ($x == 'SafeFed') {
				return $player != null && $this->isFed() && $player->canBeProtectedByRace($this->getRaceID());
			}
			if ($x == 'HQ') {
				return $this->isHQ();
			}
			if ($x == 'UG') {
				return $this->isUG();
			}
			if ($x == 'Hardware') {
				return $this->isHardwareSold();
			}
			if ($x == 'Ship') {
				return $this->isShipSold();
			}
			if ($x == 'Weapon') {
				return $this->isWeaponSold();
			}
		}
		return false;
	}
}

smrealms / smr

Scrutinizer GitHub App not installed

Pull Request — master (#1101)

AbstractSmrLocation::moveSectorLocation() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
