shared_channel_msg_op_list()

Complexity

Conditions	8
Paths	25

Size

Total Lines	44
Code Lines	27

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php declare(strict_types=1);
function shared_channel_msg_op_list(SmrPlayer $player): array {
	// get the op info from db
	$db = Smr\Database::getInstance();
	$dbResult = $db->read('SELECT 1
				FROM alliance_has_op
				WHERE alliance_id = ' . $db->escapeNumber($player->getAllianceID()) . '
					AND game_id = ' . $db->escapeNumber($player->getGameID()));
	if (!$dbResult->hasRecord()) {
		return ['Your leader has not scheduled an op.'];
	}

	$responses = [
		'YES' => [],
		'NO' => [],
		'MAYBE' => [],
	];
	$dbResult = $db->read('SELECT account_id, response
				FROM alliance_has_op_response
				WHERE alliance_id = ' . $db->escapeNumber($player->getAllianceID()) . '
					AND game_id = ' . $db->escapeNumber($player->getGameID()));
	foreach ($dbResult->records() as $dbRecord) {
		$respondingPlayer = SmrPlayer::getPlayer($dbRecord->getInt('account_id'), $player->getGameID(), true);
		// check that the player is still in this alliance
		if (!$player->sameAlliance($respondingPlayer)) {
			continue;
		}
		$responses[$dbRecord->getField('response')][] = $respondingPlayer;
	}

	$results = [];
	foreach ($responses as $response => $responders) {
		if (count($responders) > 0) {
			$results[] = $response . ' (' . count($responders) . '):';
			foreach ($responders as $responder) {
				$results[] = ' * ' . $responder->getPlayerName();
			}
		}
	}

	if (!$results) {
		return ['No one has responded to the upcoming op.'];
	}

	return $results;
}