BuddyModel::db_buddy_update_status() - Code Metrics - Inspection of "CODE-feat-41a50.88: Moving buddy.php code to Buddy..." - supernova-ws/SuperNova - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — work-fleets ( d28adc...7496c9 )

by SuperNova.WS

created 2016-07-30 18:33 UTC

BuddyModel::db_buddy_update_status() A

↳ Parent: BuddyModel

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
cc	1
eloc	4
c	2
b	0
f	0
nc	1
nop	1
dl	0
loc	7
ccs	0
cts	5
cp	0
crap	2
rs	9.4285

<?php

namespace Buddy;

use classSupernova;
use db_mysql;
use DbEmptyIterator;
use DbMysqliResultIterator;
use DBStaticMessages;
use DBStaticUser;

/**
 * Class BuddyModel
 *
 * @property int|float|string $playerSenderId Who makes buddy request
 * @property int|float|string $playerOwnerId To whom this buddy request made
 * @property int              $buddyStatusId Current buddy request status
 * @property string           $requestText Request text
 *
 * @package Buddy
 */
class BuddyModel extends \Entity {

  protected static $tableName = 'buddy';
  protected static $idField = 'BUDDY_ID';
  protected static $exceptionClass = 'BuddyException';

  // TODO - make it work with Model's properties
  /**
   * Property list
   *
   * @var array
   */
  protected static $_properties = array(
    'dbId'           => array(
      P_DB_FIELD => 'BUDDY_ID',
    ),
    'playerSenderId' => array(
      P_DB_FIELD => 'BUDDY_SENDER_ID',
    ),
    'playerOwnerId'  => array(
      P_DB_FIELD => 'BUDDY_OWNER_ID',
    ),
    'buddyStatusId'  => array(
      P_DB_FIELD => 'BUDDY_STATUS',
    ),
    'requestText'    => array(
      P_DB_FIELD => 'BUDDY_REQUEST',
    ),
  );

  // TODO - remove public static function db_buddy_update_status($buddy_id, $status) {

  public function db_buddy_update_status($status) {
    $buddy_id = idval($this->dbId);

    doquery("UPDATE `{{buddy}}` SET `BUDDY_STATUS` = {$status} WHERE `BUDDY_ID` = '{$buddy_id}' LIMIT 1;");

    return classSupernova::$db->db_affected_rows();
  }

  /**
   * @param int $playerIdSafe
   * @param int $newFriendIdSafe
   *
   * @throws BuddyException
   */
  public function db_buddy_check_relation($playerIdSafe, $newFriendIdSafe) {
    $result = static::$dbStatic->doQueryFetchValue(
      "SELECT `BUDDY_ID` FROM `{{buddy}}` WHERE
      (`BUDDY_SENDER_ID` = {$playerIdSafe} AND `BUDDY_OWNER_ID` = {$newFriendIdSafe})
      OR
      (`BUDDY_SENDER_ID` = {$newFriendIdSafe} AND `BUDDY_OWNER_ID` = {$playerIdSafe})
      LIMIT 1 FOR UPDATE;"
    );

    if (!empty($result)) {
      throw new BuddyException('buddy_err_adding_exists', ERR_WARNING);
    }
  }

  /**
   * @param db_mysql $db
   * @param mixed    $user_id
   *
   * @return DbEmptyIterator|DbMysqliResultIterator
   */
  // TODO - make it non-static
  public static function db_buddy_list_by_user($db, $user_id) {
    return ($user_id = idval($user_id)) ? $db->doQueryIterator(
      "SELECT
      b.*,
      IF(b.BUDDY_OWNER_ID = {$user_id}, b.BUDDY_SENDER_ID, b.BUDDY_OWNER_ID) AS BUDDY_USER_ID,
      u.username AS BUDDY_USER_NAME,
      p.name AS BUDDY_PLANET_NAME,
      p.galaxy AS BUDDY_PLANET_GALAXY,
      p.system AS BUDDY_PLANET_SYSTEM,
      p.planet AS BUDDY_PLANET_PLANET,
      a.id AS BUDDY_ALLY_ID,
      a.ally_name AS BUDDY_ALLY_NAME,
      u.onlinetime
    FROM {{buddy}} AS b
      LEFT JOIN {{users}} AS u ON u.id = IF(b.BUDDY_OWNER_ID = {$user_id}, b.BUDDY_SENDER_ID, b.BUDDY_OWNER_ID)
      LEFT JOIN {{planets}} AS p ON p.id_owner = u.id AND p.id = id_planet
      LEFT JOIN {{alliance}} AS a ON a.id = u.ally_id
    WHERE (`BUDDY_OWNER_ID` = {$user_id}) OR `BUDDY_SENDER_ID` = {$user_id}
    ORDER BY BUDDY_STATUS, BUDDY_ID"
    ) : new DbEmptyIterator();
  }

  /**
   * @param BuddyRoutingParams $cBuddy
   *
   * @throws BuddyException
   */
  public function accept($cBuddy) {
    if ($cBuddy->mode != 'accept') {
      return;
    }

    $playerId = $cBuddy->playerId;

    if ($this->playerSenderId == $playerId) {
      throw new BuddyException('buddy_err_accept_own', ERR_ERROR);
    }

    if ($this->playerOwnerId != $playerId) {
      throw new BuddyException('buddy_err_accept_alien', ERR_ERROR);
    }

    if ($this->buddyStatusId == BUDDY_REQUEST_ACTIVE) {
      throw new BuddyException('buddy_err_accept_already', ERR_WARNING);
    }

    if ($this->buddyStatusId == BUDDY_REQUEST_DENIED) {
      throw new BuddyException('buddy_err_accept_denied', ERR_ERROR);
    }

    if ($this->buddyStatusId != BUDDY_REQUEST_WAITING) {
      throw new BuddyException('buddy_err_unknown_status', ERR_ERROR);
    }

    $result = $this->db_buddy_update_status(BUDDY_REQUEST_ACTIVE);
    if ($result) {
      DBStaticMessages::msgSendFromPlayerBuddy($cBuddy, 'buddy_msg_accept_title', 'buddy_msg_accept_text');
      throw new BuddyException('buddy_err_accept_none', ERR_NONE);
    } else {
      throw new BuddyException('buddy_err_accept_internal', ERR_ERROR);
    }
  }

  /**
   * Declining buddy request
   *
   * If it is own request - it will be deleted
   *
   * @param BuddyRoutingParams $cBuddy
   *
   * @throws BuddyException
   */
  public function decline($cBuddy) {
    if ($cBuddy->mode != 'delete') {
      return;
    }

    $playerId = $cBuddy->playerId;

    if ($this->playerSenderId != $playerId && $this->playerOwnerId != $playerId) {
      throw new BuddyException('buddy_err_delete_alien', ERR_ERROR);
    }

    if ($this->buddyStatusId == BUDDY_REQUEST_ACTIVE) {
      // Existing friendship
      $cBuddy->newFriendIdSafe = $this->playerSenderId == $playerId ? $this->playerOwnerId : $this->playerSenderId;
      DBStaticMessages::msgSendFromPlayerBuddy($cBuddy, 'buddy_msg_unfriend_title', 'buddy_msg_unfriend_text');

      static::$rowOperator->deleteById($this);
      throw new BuddyException('buddy_err_unfriend_none', ERR_NONE);
    } elseif ($this->playerSenderId == $playerId) {
      // Player's outcoming request - either denied or waiting
      static::$rowOperator->deleteById($this);
      throw new BuddyException('buddy_err_delete_own', ERR_NONE);
    } elseif ($this->buddyStatusId == BUDDY_REQUEST_WAITING) {
      // Deny incoming request
      DBStaticMessages::msgSendFromPlayerBuddy($cBuddy, 'buddy_msg_deny_title', 'buddy_msg_deny_text');

      $this->db_buddy_update_status(BUDDY_REQUEST_DENIED);
      throw new BuddyException('buddy_err_deny_none', ERR_NONE);
    }
  }

  /**
   * @param int    $newFriendIdSafe
   * @param string $newFriendNameUnsafe
   *
   * @return array|bool|false|\mysqli_result|null
   */
  protected function getNewFriend($newFriendIdSafe, $newFriendNameUnsafe) {
    $new_friend_row = array();
    if ($newFriendIdSafe) {
      $new_friend_row = DBStaticUser::db_user_by_id($newFriendIdSafe, true, '`id`, `username`');
    } elseif ($newFriendNameUnsafe) {
      $new_friend_row = DBStaticUser::db_user_by_username($newFriendNameUnsafe, true, '`id`, `username`');
    }

    return $new_friend_row;
  }

  /**
   * @param BuddyRoutingParams $cBuddy
   *
   * @throws BuddyException
   */
  public function beFriend($cBuddy) {
    if (empty($cBuddy->newFriendIdSafe) && empty($cBuddy->new_friend_name_unsafe)) {
      return;
    }

    $new_friend_row = $this->getNewFriend($cBuddy->newFriendIdSafe, $cBuddy->new_friend_name_unsafe);

    if (empty($new_friend_row) || empty($new_friend_row['id'])) {
      throw new BuddyException('buddy_err_unknown_player', ERR_ERROR);
    }

    if ($new_friend_row['id'] == $cBuddy->playerId) {
      throw new BuddyException('buddy_err_adding_self', ERR_ERROR);
    }

    $cBuddy->newFriendIdSafe = $new_friend_row['id'];
    $this->db_buddy_check_relation($cBuddy->playerId, $new_friend_row['id']);
    DBStaticMessages::msgSendFromPlayerBuddy($cBuddy, 'buddy_msg_adding_title', 'buddy_msg_adding_text');

    $this->playerSenderId = idval($cBuddy->playerId);
    $this->playerOwnerId = idval($new_friend_row['id']);
    $this->buddyStatusId = BUDDY_REQUEST_WAITING;
    $this->requestText = $cBuddy->new_request_text_unsafe;

    static::$rowOperator->insert($this);
    throw new BuddyException('buddy_err_adding_none', ERR_NONE);
  }

  public function isContainerEmpty() {
    return
      $this->buddyStatusId == null
      ||
      $this->buddyStatusId == BUDDY_REQUEST_NOT_SET
      ||
      empty($this->playerSenderId)
      ||
      empty($this->playerOwnerId);
  }

  /**
   * @param BuddyRoutingParams $cBuddy
   *
   * @throws BuddyException
   */
  public function route($cBuddy) {
    // Trying to load buddy record with supplied dbId
    if ($cBuddy->buddy_id && !$this->loadTry($cBuddy->buddy_id)) {
      throw new BuddyException('buddy_err_not_exist', ERR_ERROR);
    }

    // Trying to accept buddy request
    $this->accept($cBuddy);
    // Trying to decline buddy request. If it's own request - it will be deleted
    $this->decline($cBuddy);
    // New request?
    $this->beFriend($cBuddy);
  }

}


1			<?php
2
3			namespace Buddy;
4
5			use classSupernova;
6			use db_mysql;
7			use DbEmptyIterator;
8			use DbMysqliResultIterator;
9			use DBStaticMessages;
10			use DBStaticUser;
11
12			/**
13			* Class BuddyModel
14			*
15			* @property int\|float\|string $playerSenderId Who makes buddy request
16			* @property int\|float\|string $playerOwnerId To whom this buddy request made
17			* @property int $buddyStatusId Current buddy request status
18			* @property string $requestText Request text
19			*
20			* @package Buddy
21			*/
22			class BuddyModel extends \Entity {
23
24			protected static $tableName = 'buddy';
25			protected static $idField = 'BUDDY_ID';
26			protected static $exceptionClass = 'BuddyException';
27
28			// TODO - make it work with Model's properties
29			/**
30			* Property list
31			*
32			* @var array
33			*/
34			protected static $_properties = array(
35			'dbId' => array(
36			P_DB_FIELD => 'BUDDY_ID',
37			),
38			'playerSenderId' => array(
39			P_DB_FIELD => 'BUDDY_SENDER_ID',
40			),
41			'playerOwnerId' => array(
42			P_DB_FIELD => 'BUDDY_OWNER_ID',
43			),
44			'buddyStatusId' => array(
45			P_DB_FIELD => 'BUDDY_STATUS',
46			),
47			'requestText' => array(
48			P_DB_FIELD => 'BUDDY_REQUEST',
49			),
50			);
51
52			// TODO - remove public static function db_buddy_update_status($buddy_id, $status) {
			0 ignored issues – show Unused Code Comprehensibility introduced 2016-07-26 18:33 UTC by Report Bug Copy Issue Report `41%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
53			public function db_buddy_update_status($status) {
54			$buddy_id = idval($this->dbId);
55
56			doquery("UPDATE `{{buddy}}` SET `BUDDY_STATUS` = {$status} WHERE `BUDDY_ID` = '{$buddy_id}' LIMIT 1;");
57
58			return classSupernova::$db->db_affected_rows();
59			}
60
61			/**
62			* @param int $playerIdSafe
63			* @param int $newFriendIdSafe
64			*
65			* @throws BuddyException
66			*/
67			public function db_buddy_check_relation($playerIdSafe, $newFriendIdSafe) {
68			$result = static::$dbStatic->doQueryFetchValue(
69			"SELECT `BUDDY_ID` FROM `{{buddy}}` WHERE
70			(`BUDDY_SENDER_ID` = {$playerIdSafe} AND `BUDDY_OWNER_ID` = {$newFriendIdSafe})
71			OR
72			(`BUDDY_SENDER_ID` = {$newFriendIdSafe} AND `BUDDY_OWNER_ID` = {$playerIdSafe})
73			LIMIT 1 FOR UPDATE;"
74			);
75
76			if (!empty($result)) {
77			throw new BuddyException('buddy_err_adding_exists', ERR_WARNING);
78			}
79			}
80
81			/**
82			* @param db_mysql $db
83			* @param mixed $user_id
84			*
85			* @return DbEmptyIterator\|DbMysqliResultIterator
86			*/
87			// TODO - make it non-static
88			public static function db_buddy_list_by_user($db, $user_id) {
89			return ($user_id = idval($user_id)) ? $db->doQueryIterator(
90			"SELECT
91			b.*,
92			IF(b.BUDDY_OWNER_ID = {$user_id}, b.BUDDY_SENDER_ID, b.BUDDY_OWNER_ID) AS BUDDY_USER_ID,
93			u.username AS BUDDY_USER_NAME,
94			p.name AS BUDDY_PLANET_NAME,
95			p.galaxy AS BUDDY_PLANET_GALAXY,
96			p.system AS BUDDY_PLANET_SYSTEM,
97			p.planet AS BUDDY_PLANET_PLANET,
98			a.id AS BUDDY_ALLY_ID,
99			a.ally_name AS BUDDY_ALLY_NAME,
100			u.onlinetime
101			FROM {{buddy}} AS b
102			LEFT JOIN {{users}} AS u ON u.id = IF(b.BUDDY_OWNER_ID = {$user_id}, b.BUDDY_SENDER_ID, b.BUDDY_OWNER_ID)
103			LEFT JOIN {{planets}} AS p ON p.id_owner = u.id AND p.id = id_planet
104			LEFT JOIN {{alliance}} AS a ON a.id = u.ally_id
105			WHERE (`BUDDY_OWNER_ID` = {$user_id}) OR `BUDDY_SENDER_ID` = {$user_id}
106			ORDER BY BUDDY_STATUS, BUDDY_ID"
107			) : new DbEmptyIterator();
108			}
109
110			/**
111			* @param BuddyRoutingParams $cBuddy
112			*
113			* @throws BuddyException
114			*/
115			public function accept($cBuddy) {
116			if ($cBuddy->mode != 'accept') {
117			return;
118			}
119
120			$playerId = $cBuddy->playerId;
121
122			if ($this->playerSenderId == $playerId) {
123			throw new BuddyException('buddy_err_accept_own', ERR_ERROR);
124			}
125
126			if ($this->playerOwnerId != $playerId) {
127			throw new BuddyException('buddy_err_accept_alien', ERR_ERROR);
128			}
129
130			if ($this->buddyStatusId == BUDDY_REQUEST_ACTIVE) {
131			throw new BuddyException('buddy_err_accept_already', ERR_WARNING);
132			}
133
134			if ($this->buddyStatusId == BUDDY_REQUEST_DENIED) {
135			throw new BuddyException('buddy_err_accept_denied', ERR_ERROR);
136			}
137
138			if ($this->buddyStatusId != BUDDY_REQUEST_WAITING) {
139			throw new BuddyException('buddy_err_unknown_status', ERR_ERROR);
140			}
141
142			$result = $this->db_buddy_update_status(BUDDY_REQUEST_ACTIVE);
143			if ($result) {
144			DBStaticMessages::msgSendFromPlayerBuddy($cBuddy, 'buddy_msg_accept_title', 'buddy_msg_accept_text');
145			throw new BuddyException('buddy_err_accept_none', ERR_NONE);
146			} else {
147			throw new BuddyException('buddy_err_accept_internal', ERR_ERROR);
148			}
149			}
150
151			/**
152			* Declining buddy request
153			*
154			* If it is own request - it will be deleted
155			*
156			* @param BuddyRoutingParams $cBuddy
157			*
158			* @throws BuddyException
159			*/
160			public function decline($cBuddy) {
161			if ($cBuddy->mode != 'delete') {
162			return;
163			}
164
165			$playerId = $cBuddy->playerId;
166
167			if ($this->playerSenderId != $playerId && $this->playerOwnerId != $playerId) {
168			throw new BuddyException('buddy_err_delete_alien', ERR_ERROR);
169			}
170
171			if ($this->buddyStatusId == BUDDY_REQUEST_ACTIVE) {
172			// Existing friendship
173			$cBuddy->newFriendIdSafe = $this->playerSenderId == $playerId ? $this->playerOwnerId : $this->playerSenderId;
174			DBStaticMessages::msgSendFromPlayerBuddy($cBuddy, 'buddy_msg_unfriend_title', 'buddy_msg_unfriend_text');
175
176			static::$rowOperator->deleteById($this);
177			throw new BuddyException('buddy_err_unfriend_none', ERR_NONE);
178			} elseif ($this->playerSenderId == $playerId) {
179			// Player's outcoming request - either denied or waiting
180			static::$rowOperator->deleteById($this);
181			throw new BuddyException('buddy_err_delete_own', ERR_NONE);
182			} elseif ($this->buddyStatusId == BUDDY_REQUEST_WAITING) {
183			// Deny incoming request
184			DBStaticMessages::msgSendFromPlayerBuddy($cBuddy, 'buddy_msg_deny_title', 'buddy_msg_deny_text');
185
186			$this->db_buddy_update_status(BUDDY_REQUEST_DENIED);
187			throw new BuddyException('buddy_err_deny_none', ERR_NONE);
188			}
189			}
190
191			/**
192			* @param int $newFriendIdSafe
193			* @param string $newFriendNameUnsafe
194			*
195			* @return array\|bool\|false\|\mysqli_result\|null
196			*/
197			protected function getNewFriend($newFriendIdSafe, $newFriendNameUnsafe) {
198			$new_friend_row = array();
199			if ($newFriendIdSafe) {
200			$new_friend_row = DBStaticUser::db_user_by_id($newFriendIdSafe, true, '`id`, `username`');
201			} elseif ($newFriendNameUnsafe) {
202			$new_friend_row = DBStaticUser::db_user_by_username($newFriendNameUnsafe, true, '`id`, `username`');
203			}
204
205			return $new_friend_row;
206			}
207
208			/**
209			* @param BuddyRoutingParams $cBuddy
210			*
211			* @throws BuddyException
212			*/
213			public function beFriend($cBuddy) {
214			if (empty($cBuddy->newFriendIdSafe) && empty($cBuddy->new_friend_name_unsafe)) {
215			return;
216			}
217
218			$new_friend_row = $this->getNewFriend($cBuddy->newFriendIdSafe, $cBuddy->new_friend_name_unsafe);
219
220			if (empty($new_friend_row) \|\| empty($new_friend_row['id'])) {
221			throw new BuddyException('buddy_err_unknown_player', ERR_ERROR);
222			}
223
224			if ($new_friend_row['id'] == $cBuddy->playerId) {
225			throw new BuddyException('buddy_err_adding_self', ERR_ERROR);
226			}
227
228			$cBuddy->newFriendIdSafe = $new_friend_row['id'];
229			$this->db_buddy_check_relation($cBuddy->playerId, $new_friend_row['id']);
230			DBStaticMessages::msgSendFromPlayerBuddy($cBuddy, 'buddy_msg_adding_title', 'buddy_msg_adding_text');
231
232			$this->playerSenderId = idval($cBuddy->playerId);
233			$this->playerOwnerId = idval($new_friend_row['id']);
234			$this->buddyStatusId = BUDDY_REQUEST_WAITING;
235			$this->requestText = $cBuddy->new_request_text_unsafe;
236
237			static::$rowOperator->insert($this);
238			throw new BuddyException('buddy_err_adding_none', ERR_NONE);
239			}
240
241			public function isContainerEmpty() {
242			return
243			$this->buddyStatusId == null
244			\|\|
245			$this->buddyStatusId == BUDDY_REQUEST_NOT_SET
246			\|\|
247			empty($this->playerSenderId)
248			\|\|
249			empty($this->playerOwnerId);
250			}
251
252			/**
253			* @param BuddyRoutingParams $cBuddy
254			*
255			* @throws BuddyException
256			*/
257			public function route($cBuddy) {
258			// Trying to load buddy record with supplied dbId
259			if ($cBuddy->buddy_id && !$this->loadTry($cBuddy->buddy_id)) {
260			throw new BuddyException('buddy_err_not_exist', ERR_ERROR);
261			}
262
263			// Trying to accept buddy request
264			$this->accept($cBuddy);
265			// Trying to decline buddy request. If it's own request - it will be deleted
266			$this->decline($cBuddy);
267			// New request?
268			$this->beFriend($cBuddy);
269			}
270
271			}
272

supernova-ws / SuperNova

Push — work-fleets ( d28adc...7496c9 )

BuddyModel::db_buddy_update_status() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like